home / fivethirtyeight

Fandango: fandango_score_comparison.csv

This directory contains the data behind the story Be Suspicious Of Online Movie Ratings, Especially Fandango’s.

fandango_score_comparison.csv contains every film that has a Rotten Tomatoes rating, a RT User rating, a Metacritic score, a Metacritic User score, and IMDb score, and at least 30 fan reviews on Fandango. The data from Fandango was pulled on Aug. 24, 2015.

Column Definition
FILM The film in question
RottenTomatoes The Rotten Tomatoes Tomatometer score for the film
RottenTomatoes_User The Rotten Tomatoes user score for the film
Metacritic The Metacritic critic score for the film
Metacritic_User The Metacritic user score for the film
IMDB The IMDb user score for the film
Fandango_Stars The number of stars the film had on its Fandango movie page
Fandango_Ratingvalue The Fandango ratingValue for the film, as pulled from the HTML of each page. This is the actual average score the movie obtained.
RT_norm The Rotten Tomatoes Tomatometer score for the film , normalized to a 0 to 5 point system
RT_user_norm The Rotten Tomatoes user score for the film , normalized to a 0 to 5 point system
Metacritic_norm The Metacritic critic score for the film, normalized to a 0 to 5 point system
Metacritic_user_nom The Metacritic user score for the film, normalized to a 0 to 5 point system
IMDB_norm The IMDb user score for the film, normalized to a 0 to 5 point system
RT_norm_round The Rotten Tomatoes Tomatometer score for the film , normalized to a 0 to 5 point system and rounded to the nearest half-star
RT_user_norm_round The Rotten Tomatoes user score for the film , normalized to a 0 to 5 point system and rounded to the nearest half-star
Metacritic_norm_round The Metacritic critic score for the film, normalized to a 0 to 5 point system and rounded to the nearest half-star
Metacritic_user_norm_round The Metacritic user score for the film, normalized to a 0 to 5 point system and rounded to the nearest half-star
IMDB_norm_round The IMDb user score for the film, normalized to a 0 to 5 point system and rounded to the nearest half-star
Metacritic_user_vote_count The number of user votes the film had on Metacritic
IMDB_user_vote_count The number of user votes the film had on IMDb
Fandango_votes The number of user votes the film had on Fandango
Fandango_Difference The difference between the presented Fandango_Stars and the actual Fandango_Ratingvalue

fandango_scrape.csv contains every film we pulled from Fandango.

Column Definiton
FILM The movie
STARS Number of stars presented on Fandango.com
RATING The Fandango ratingValue for the film, as pulled from the HTML of each page. This is the actual average score the movie obtained.
VOTES number of people who had reviewed the film at the time we pulled it.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

146 rows sorted by RottenTomatoes_User

View and edit SQL

Suggested facets: Fandango_Stars, Fandango_Ratingvalue, RT_norm_round, RT_user_norm_round, Metacritic_norm_round, Metacritic_user_norm_round, IMDB_norm_round, Fandango_Difference

Link rowid FILM RottenTomatoes RottenTomatoes_User ▼ Metacritic Metacritic_User IMDB Fandango_Stars Fandango_Ratingvalue RT_norm RT_user_norm Metacritic_norm Metacritic_user_nom IMDB_norm RT_norm_round RT_user_norm_round Metacritic_norm_round Metacritic_user_norm_round IMDB_norm_round Metacritic_user_vote_count IMDB_user_vote_count Fandango_votes Fandango_Difference
49 Fantastic Four (2015) 9 20 27 2.5 4.0 3.0 2.7 0.45 1.0 1.35 1.25 2.0 0.5 1.0 1.5 1.5 2.0 421 39838 6288 0.3
108 The Vatican Tapes (2015) 13 21 37 5.4 4.6 3.0 2.9 0.65 1.05 1.85 2.7 2.3 0.5 1.0 2.0 2.5 2.5 5 952 210 0.1
136 The Lazarus Effect (2015) 14 23 31 4.9 5.2 3.0 3.0 0.7 1.15 1.55 2.45 2.6 0.5 1.0 1.5 2.5 2.5 62 17691 1651 0.0
80 Poltergeist (2015) 31 24 47 3.7 5.0 3.0 2.8 1.55 1.2 2.35 1.85 2.5 1.5 1.0 2.5 2.0 2.5 142 21372 2704 0.2
83 Blackhat (2015) 34 25 51 5.4 5.4 3.0 2.8 1.7 1.25 2.55 2.7 2.7 1.5 1.5 2.5 2.5 2.5 80 27328 1430 0.2
137 The Woman In Black 2 Angel of Death (2015) 22 25 42 4.4 4.9 3.0 3.0 1.1 1.25 2.1 2.2 2.45 1.0 1.5 2.0 2.0 2.5 55 14873 1333 0.0
140 Serena (2015) 18 25 36 5.3 5.4 3.0 3.0 0.9 1.25 1.8 2.65 2.7 1.0 1.5 2.0 2.5 2.5 19 12165 50 0.0
61 Unfinished Business (2015) 11 27 32 3.8 5.4 3.5 3.2 0.55 1.35 1.6 1.9 2.7 0.5 1.5 1.5 2.0 2.5 39 14346 821 0.3
102 The Gallows (2015) 16 27 30 7.0 4.4 3.0 2.9 0.8 1.35 1.5 3.5 2.2 1.0 1.5 1.5 3.5 2.0 80 5511 1896 0.1
5 Hot Tub Time Machine 2 (2015) 14 28 29 3.4 5.1 3.5 3.0 0.7 1.4 1.45 1.7 2.55 0.5 1.5 1.5 1.5 2.5 88 19560 1021 0.5
60 Mortdecai (2015) 12 30 27 3.2 5.5 3.5 3.2 0.6 1.5 1.35 1.6 2.75 0.5 1.5 1.5 1.5 3.0 144 31878 1196 0.3
35 Aloha (2015) 19 31 40 4.0 5.5 3.5 3.1 0.95 1.55 2.0 2.0 2.75 1.0 1.5 2.0 2.0 3.0 67 12255 2284 0.4
88 Maggie (2015) 54 32 52 6.5 5.6 3.5 3.3 2.7 1.6 2.6 3.25 2.8 2.5 1.5 2.5 3.5 3.0 90 18986 95 0.2
65 Dark Places (2015) 26 33 39 7.9 6.3 4.0 3.7 1.3 1.65 1.95 3.95 3.15 1.5 1.5 2.0 4.0 3.0 18 9856 55 0.3
85 Sinister 2 (2015) 13 34 31 5.0 5.5 3.5 3.3 0.65 1.7 1.55 2.5 2.75 0.5 1.5 1.5 2.5 3.0 37 3200 973 0.2
105 The Gunman (2015) 17 34 39 4.3 5.8 3.5 3.4 0.85 1.7 1.95 2.15 2.9 1.0 1.5 2.0 2.0 3.0 49 16663 996 0.1
34 The Boy Next Door (2015) 10 35 30 5.5 4.6 4.0 3.6 0.5 1.75 1.5 2.75 2.3 0.5 2.0 1.5 3.0 2.5 75 19658 2800 0.4
59 Seventh Son (2015) 12 35 30 3.9 5.5 3.5 3.2 0.6 1.75 1.5 1.95 2.75 0.5 2.0 1.5 2.0 3.0 126 41177 1213 0.3
134 Paul Blart: Mall Cop 2 (2015) 5 36 13 2.4 4.3 3.5 3.5 0.25 1.8 0.65 1.2 2.15 0.5 2.0 0.5 1.0 2.0 211 15004 3054 0.0
54 Hot Pursuit (2015) 8 37 31 3.7 4.9 4.0 3.7 0.4 1.85 1.55 1.85 2.45 0.5 2.0 1.5 2.0 2.5 78 17061 2618 0.3
68 Unfriended (2015) 60 39 59 5.8 5.9 3.0 2.7 3.0 1.95 2.95 2.9 2.95 3.0 2.0 3.0 3.0 3.0 130 22348 2507 0.3
36 The Loft (2015) 11 40 24 2.4 6.3 4.0 3.6 0.55 2.0 1.2 1.2 3.15 0.5 2.0 1.0 1.0 3.0 80 21319 811 0.4
101 Jupiter Ascending (2015) 26 40 40 4.5 5.5 3.5 3.4 1.3 2.0 2.0 2.25 2.75 1.5 2.0 2.0 2.5 3.0 503 105412 4122 0.1
63 True Story (2015) 45 41 50 5.7 6.3 3.5 3.2 2.25 2.05 2.5 2.85 3.15 2.5 2.0 2.5 3.0 3.0 37 16069 540 0.3
98 Fifty Shades of Grey (2015) 25 42 46 3.2 4.2 4.0 3.9 1.25 2.1 2.3 1.6 2.1 1.5 2.0 2.5 1.5 2.0 778 179506 34846 0.1
64 Child 44 (2015) 26 44 41 5.3 6.4 4.0 3.7 1.3 2.2 2.05 2.65 3.2 1.5 2.0 2.0 2.5 3.0 73 19220 308 0.3
39 Saint Laurent (2015) 51 45 52 6.8 6.3 3.5 3.1 2.55 2.25 2.6 3.4 3.15 2.5 2.5 2.5 3.5 3.0 8 2196 43 0.4
16 Taken 3 (2015) 9 46 26 4.6 6.1 4.5 4.1 0.45 2.3 1.3 2.3 3.05 0.5 2.5 1.5 2.5 3.0 240 104235 6757 0.4
40 Maps to the Stars (2015) 60 46 67 5.8 6.3 3.5 3.1 3.0 2.3 3.35 2.9 3.15 3.0 2.5 3.5 3.0 3.0 46 22440 35 0.4
57 Project Almanac (2015) 34 46 47 5.4 6.4 4.0 3.7 1.7 2.3 2.35 2.7 3.2 1.5 2.5 2.5 2.5 3.0 95 40057 1834 0.3
37 5 Flights Up (2015) 52 47 55 6.8 6.1 4.0 3.6 2.6 2.35 2.75 3.4 3.05 2.5 2.5 3.0 3.5 3.0 6 2174 79 0.4
38 Welcome to Me (2015) 71 47 67 6.9 5.9 4.0 3.6 3.55 2.35 3.35 3.45 2.95 3.5 2.5 3.5 3.5 3.0 33 8301 56 0.4
107 Cake (2015) 49 47 49 6.4 6.5 3.5 3.4 2.45 2.35 2.45 3.2 3.25 2.5 2.5 2.5 3.0 3.5 44 19627 482 0.1
109 A Little Chaos (2015) 40 47 51 7.0 6.4 4.0 3.9 2.0 2.35 2.55 3.5 3.2 2.0 2.5 2.5 3.5 3.0 7 4778 83 0.1
99 Get Hard (2015) 29 48 34 3.8 6.1 4.0 3.9 1.45 2.4 1.7 1.9 3.05 1.5 2.5 1.5 2.0 3.0 145 50022 5933 0.1
106 Hitman: Agent 47 (2015) 7 49 28 3.3 5.9 4.0 3.9 0.35 2.45 1.4 1.65 2.95 0.5 2.5 1.5 1.5 3.0 67 4260 917 0.1
104 Strange Magic (2015) 17 50 25 5.3 5.7 3.5 3.4 0.85 2.5 1.25 2.65 2.85 1.0 2.5 1.5 2.5 3.0 41 3658 1117 0.1
112 Into the Woods (2014) 71 50 69 6.1 6.0 3.5 3.4 3.55 2.5 3.45 3.05 3.0 3.5 2.5 3.5 3.0 3.0 307 81679 13055 0.1
84 Self/less (2015) 20 51 34 8.4 6.6 4.0 3.8 1.0 2.55 1.7 4.2 3.3 1.0 2.5 1.5 4.0 3.5 77 5626 1415 0.2
62 American Ultra (2015) 46 52 50 6.8 6.5 4.0 3.7 2.3 2.6 2.5 3.4 3.25 2.5 2.5 2.5 3.5 3.5 42 3017 638 0.3
111 Escobar: Paradise Lost (2015) 52 52 56 6.9 6.6 4.0 3.9 2.6 2.6 2.8 3.45 3.3 2.5 2.5 3.0 3.5 3.5 7 7819 48 0.1
114 Inherent Vice (2014) 73 52 81 7.4 6.7 3.0 2.9 3.65 2.6 4.05 3.7 3.35 3.5 2.5 4.0 3.5 3.5 286 44711 1078 0.1
116 While We're Young (2015) 83 52 76 6.7 6.4 3.0 2.9 4.15 2.6 3.8 3.35 3.2 4.0 2.5 4.0 3.5 3.0 65 17647 449 0.1
132 Minions (2015) 54 52 56 5.7 6.7 4.0 4.0 2.7 2.6 2.8 2.85 3.35 2.5 2.5 3.0 3.0 3.5 204 55895 14998 0.0
7 Irrational Man (2015) 42 53 53 7.6 6.9 4.0 3.5 2.1 2.65 2.65 3.8 3.45 2.0 2.5 2.5 4.0 3.5 17 2680 252 0.5
46 Tomorrowland (2015) 50 53 60 6.4 6.6 4.0 3.7 2.5 2.65 3.0 3.2 3.3 2.5 2.5 3.0 3.0 3.5 262 42937 8077 0.3
58 Ricki and the Flash (2015) 64 53 54 7.0 6.2 4.0 3.7 3.2 2.65 2.7 3.5 3.1 3.0 2.5 2.5 3.5 3.0 37 1769 1462 0.3
20 Pixels (2015) 17 54 27 5.3 5.6 4.5 4.1 0.85 2.7 1.35 2.65 2.8 1.0 2.5 1.5 2.5 3.0 246 19521 3886 0.4
100 Focus (2015) 57 54 56 6.2 6.6 4.0 3.9 2.85 2.7 2.8 3.1 3.3 3.0 2.5 3.0 3.0 3.5 167 101264 4933 0.1
78 Vacation (2015) 27 55 34 6.2 6.3 4.0 3.8 1.35 2.75 1.7 3.1 3.15 1.5 3.0 1.5 3.0 3.0 72 8179 3815 0.2
91 The SpongeBob Movie: Sponge Out of Water (2015) 78 55 62 6.5 6.1 3.5 3.3 3.9 2.75 3.1 3.25 3.05 4.0 3.0 3.0 3.5 3.0 196 26046 4493 0.2
22 Insidious: Chapter 3 (2015) 59 56 52 6.9 6.3 4.5 4.1 2.95 2.8 2.6 3.45 3.15 3.0 3.0 2.5 3.5 3.0 115 25134 3276 0.4
70 Mr. Turner (2014) 98 56 94 6.6 6.9 3.5 3.2 4.9 2.8 4.7 3.3 3.45 5.0 3.0 4.5 3.5 3.5 98 13296 290 0.3
79 Chappie (2015) 30 57 41 7.4 7.0 4.0 3.8 1.5 2.85 2.05 3.7 3.5 1.5 3.0 2.0 3.5 3.5 637 125088 3642 0.2
81 Paper Towns (2015) 55 57 56 6.2 6.9 4.0 3.8 2.75 2.85 2.8 3.1 3.45 3.0 3.0 3.0 3.0 3.5 51 14156 1750 0.2
17 Ted 2 (2015) 46 58 48 6.5 6.6 4.5 4.1 2.3 2.9 2.4 3.25 3.3 2.5 3.0 2.5 3.5 3.5 197 49102 6437 0.4
19 Night at the Museum: Secret of the Tomb (2014) 50 58 47 5.8 6.3 4.5 4.1 2.5 2.9 2.35 2.9 3.15 2.5 3.0 2.5 3.0 3.0 103 50291 5445 0.4
76 San Andreas (2015) 50 58 43 5.5 6.5 4.5 4.3 2.5 2.9 2.15 2.75 3.25 2.5 3.0 2.0 3.0 3.5 199 45723 9749 0.2
24 Run All Night (2015) 60 59 59 7.3 6.6 4.5 4.1 3.0 2.95 2.95 3.65 3.3 3.0 3.0 3.0 3.5 3.5 141 50438 2066 0.4
12 Black Sea (2015) 82 60 62 6.6 6.4 4.0 3.5 4.1 3.0 3.1 3.3 3.2 4.0 3.0 3.0 3.5 3.0 37 16547 218 0.5
50 Terminator Genisys (2015) 26 60 38 6.4 6.9 4.5 4.2 1.3 3.0 1.9 3.2 3.45 1.5 3.0 2.0 3.0 3.5 779 85585 6272 0.3
128 The Last Five Years (2015) 60 60 60 6.9 6.0 4.5 4.4 3.0 3.0 3.0 3.45 3.0 3.0 3.0 3.0 3.5 3.0 20 4110 99 0.1
47 The Divergent Series: Insurgent (2015) 30 61 42 5.4 6.4 4.5 4.2 1.5 3.05 2.1 2.7 3.2 1.5 3.0 2.0 2.5 3.0 206 89618 7123 0.3
48 Annie (2014) 27 61 33 4.8 5.2 4.5 4.2 1.35 3.05 1.65 2.4 2.6 1.5 3.0 1.5 2.5 2.5 108 19222 6835 0.3
6 The Water Diviner (2015) 63 62 50 6.8 7.2 4.5 4.0 3.15 3.1 2.5 3.4 3.6 3.0 3.0 2.5 3.5 3.5 34 39373 397 0.5
103 The Second Best Exotic Marigold Hotel (2015) 62 63 51 6.1 6.6 4.0 3.9 3.1 3.15 2.55 3.05 3.3 3.0 3.0 2.5 3.0 3.5 41 12940 1870 0.1
146 Kumiko, The Treasure Hunter (2015) 87 63 68 6.4 6.7 3.5 3.5 4.35 3.15 3.4 3.2 3.35 4.5 3.0 3.5 3.0 3.5 19 5289 41 0.0
8 Top Five (2014) 86 64 81 6.8 6.5 4.0 3.5 4.3 3.2 4.05 3.4 3.25 4.5 3.0 4.0 3.5 3.5 124 16876 3223 0.5
124 Magic Mike XXL (2015) 62 64 60 5.4 6.3 4.5 4.4 3.1 3.2 3.0 2.7 3.15 3.0 3.0 3.0 2.5 3.0 52 11937 9363 0.1
95 The Overnight (2015) 82 65 65 8.6 6.9 3.5 3.3 4.1 3.25 3.25 4.3 3.45 4.0 3.5 3.5 4.5 3.5 13 867 110 0.2
113 It Follows (2015) 96 65 83 7.5 6.9 3.0 2.9 4.8 3.25 4.15 3.75 3.45 5.0 3.5 4.0 4.0 3.5 551 64656 2097 0.1
125 Home (2015) 45 65 55 7.3 6.7 4.5 4.4 2.25 3.25 2.75 3.65 3.35 2.5 3.5 3.0 3.5 3.5 177 41158 7705 0.1
126 The Wedding Ringer (2015) 27 66 35 3.3 6.7 4.5 4.4 1.35 3.3 1.75 1.65 3.35 1.5 3.5 2.0 1.5 3.5 126 37292 6506 0.1
117 Clouds of Sils Maria (2015) 89 67 78 7.1 6.8 3.5 3.4 4.45 3.35 3.9 3.55 3.4 4.5 3.5 4.0 3.5 3.5 36 11392 162 0.1
51 Pitch Perfect 2 (2015) 67 68 63 5.7 6.7 4.5 4.2 3.35 3.4 3.15 2.85 3.35 3.5 3.5 3.0 3.0 3.5 192 56333 4577 0.3
52 Entourage (2015) 32 68 38 5.2 7.1 4.5 4.2 1.6 3.4 1.9 2.6 3.55 1.5 3.5 2.0 2.5 3.5 96 21914 4279 0.3
53 The Age of Adaline (2015) 54 68 51 7.4 7.3 4.5 4.2 2.7 3.4 2.55 3.7 3.65 2.5 3.5 2.5 3.5 3.5 100 45510 3325 0.3
55 The DUFF (2015) 71 68 56 6.4 6.6 4.5 4.2 3.55 3.4 2.8 3.2 3.3 3.5 3.5 3.0 3.0 3.5 69 33594 2273 0.3
56 Black or White (2015) 39 68 45 7.9 6.6 4.5 4.2 1.95 3.4 2.25 3.95 3.3 2.0 3.5 2.5 4.0 3.5 24 4857 1862 0.3
82 Big Eyes (2014) 72 69 62 7.5 7.0 4.0 3.8 3.6 3.45 3.1 3.75 3.5 3.5 3.5 3.0 4.0 3.5 127 39152 1501 0.2
110 The 100-Year-Old Man Who Climbed Out the Window and Disappeared (2015) 67 69 58 4.6 7.1 4.0 3.9 3.35 3.45 2.9 2.3 3.55 3.5 3.5 3.0 2.5 3.5 5 17237 63 0.1
115 A Most Violent Year (2014) 90 69 79 7.0 7.1 3.5 3.4 4.5 3.45 3.95 3.5 3.55 4.5 3.5 4.0 3.5 3.5 133 32166 675 0.1
14 Unbroken (2014) 51 70 59 6.5 7.2 4.5 4.1 2.55 3.5 2.95 3.25 3.6 2.5 3.5 3.0 3.5 3.5 218 77518 9443 0.4
41 I'll See You In My Dreams (2015) 94 70 75 6.9 6.9 4.0 3.6 4.7 3.5 3.75 3.45 3.45 4.5 3.5 4.0 3.5 3.5 14 1151 281 0.4
33 The Hunting Ground (2015) 92 72 77 7.8 7.5 4.5 4.1 4.6 3.6 3.85 3.9 3.75 4.5 3.5 4.0 4.0 4.0 6 1196 42 0.4
121 The Wolfpack (2015) 84 73 75 7.0 7.1 3.5 3.4 4.2 3.65 3.75 3.5 3.55 4.0 3.5 4.0 3.5 3.5 8 1488 66 0.1
133 Max (2015) 35 73 47 5.9 7.0 4.5 4.5 1.75 3.65 2.35 2.95 3.5 2.0 3.5 2.5 3.0 3.5 15 5444 3412 0.0
135 The Longest Ride (2015) 31 73 33 4.8 7.2 4.5 4.5 1.55 3.65 1.65 2.4 3.6 1.5 3.5 1.5 2.5 3.5 49 25214 2603 0.0
25 Trainwreck (2015) 85 74 75 6.0 6.7 4.5 4.1 4.25 3.7 3.75 3.0 3.35 4.5 3.5 4.0 3.0 3.5 169 27380 8381 0.4
75 The Hobbit: The Battle of the Five Armies (2014) 61 75 59 7.0 7.5 4.5 4.3 3.05 3.75 2.95 3.5 3.75 3.0 4.0 3.0 3.5 4.0 903 289464 15337 0.2
138 Danny Collins (2015) 77 75 58 7.1 7.1 4.0 4.0 3.85 3.75 2.9 3.55 3.55 4.0 4.0 3.0 3.5 3.5 33 11206 531 0.0
119 Infinitely Polar Bear (2015) 80 76 64 7.9 7.2 4.0 3.9 4.0 3.8 3.2 3.95 3.6 4.0 4.0 3.0 4.0 3.5 8 1062 124 0.1
11 Far From The Madding Crowd (2015) 84 77 71 7.5 7.2 4.5 4.0 4.2 3.85 3.55 3.75 3.6 4.0 4.0 3.5 4.0 3.5 35 12129 804 0.5
69 Monkey Kingdom (2015) 94 77 72 7.5 7.3 4.5 4.2 4.7 3.85 3.6 3.75 3.65 4.5 4.0 3.5 4.0 3.5 15 883 701 0.3
42 Timbuktu (2015) 99 78 91 6.9 7.2 4.0 3.6 4.95 3.9 4.55 3.45 3.6 5.0 4.0 4.5 3.5 3.5 37 6246 74 0.4
66 Birdman (2014) 92 78 88 8.0 7.9 4.0 3.7 4.6 3.9 4.4 4.0 3.95 4.5 4.0 4.5 4.0 4.0 1171 303505 4194 0.3
142 Mr. Holmes (2015) 87 78 67 7.9 7.4 4.0 4.0 4.35 3.9 3.35 3.95 3.7 4.5 4.0 3.5 4.0 3.5 33 7367 1348 0.0
144 Two Days, One Night (2014) 97 78 89 8.8 7.4 3.5 3.5 4.85 3.9 4.45 4.4 3.7 5.0 4.0 4.5 4.5 3.5 123 24345 118 0.0
13 Leviathan (2014) 99 79 92 7.2 7.7 4.0 3.5 4.95 3.95 4.6 3.6 3.85 5.0 4.0 4.5 3.5 4.0 145 22521 64 0.5
67 The Gift (2015) 93 79 77 8.3 7.6 4.0 3.7 4.65 3.95 3.85 4.15 3.8 4.5 4.0 4.0 4.0 4.0 121 10891 2680 0.3

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "fandango/fandango_score_comparison" (
"FILM" TEXT,
  "RottenTomatoes" INTEGER,
  "RottenTomatoes_User" INTEGER,
  "Metacritic" INTEGER,
  "Metacritic_User" REAL,
  "IMDB" REAL,
  "Fandango_Stars" REAL,
  "Fandango_Ratingvalue" REAL,
  "RT_norm" REAL,
  "RT_user_norm" REAL,
  "Metacritic_norm" REAL,
  "Metacritic_user_nom" REAL,
  "IMDB_norm" REAL,
  "RT_norm_round" REAL,
  "RT_user_norm_round" REAL,
  "Metacritic_norm_round" REAL,
  "Metacritic_user_norm_round" REAL,
  "IMDB_norm_round" REAL,
  "Metacritic_user_vote_count" INTEGER,
  "IMDB_user_vote_count" INTEGER,
  "Fandango_votes" INTEGER,
  "Fandango_Difference" REAL
)
Powered by Datasette · Query took 45.324ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub