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 Metacritic_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4 Do You Believe? (2015) 18 84 22 4.7 5.4 5.0 4.5 0.9 4.2 1.1 2.35 2.7 1.0 4.0 1.0 2.5 2.5 31 3136 1793 0.5
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
86 Little Boy (2015) 20 81 30 5.9 7.4 4.5 4.3 1.0 4.05 1.5 2.95 3.7 1.0 4.0 1.5 3.0 3.5 38 5927 811 0.2
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
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
71 Seymour: An Introduction (2015) 100 87 83 6.0 7.7 4.5 4.2 5.0 4.35 4.15 3.0 3.85 5.0 4.5 4.0 3.0 4.0 4 243 41 0.3
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
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
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
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
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
44 The Diary of a Teenage Girl (2015) 95 81 87 6.3 7.0 4.0 3.6 4.75 4.05 4.35 3.15 3.5 5.0 4.0 4.5 3.0 3.5 18 1107 38 0.4
90 Spy (2015) 93 82 75 6.3 7.3 4.5 4.3 4.65 4.1 3.75 3.15 3.65 4.5 4.0 4.0 3.0 3.5 318 66636 9418 0.2
32 When Marnie Was There (2015) 89 89 71 6.4 7.8 4.5 4.1 4.45 4.45 3.55 3.2 3.9 4.5 4.5 3.5 3.0 4.0 29 4160 46 0.4
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
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
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
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
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
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
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
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
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
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
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
73 American Sniper (2015) 72 85 72 6.6 7.4 5.0 4.8 3.6 4.25 3.6 3.3 3.7 3.5 4.5 3.5 3.5 3.5 850 251856 34085 0.2
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
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
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
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
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
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
74 Furious 7 (2015) 81 84 67 6.8 7.4 5.0 4.8 4.05 4.2 3.35 3.4 3.7 4.0 4.0 3.5 3.5 3.5 764 207211 33538 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
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
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
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
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
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
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
72 The Wrecking Crew (2015) 93 84 67 7.0 7.8 4.5 4.2 4.65 4.2 3.35 3.5 3.9 4.5 4.0 3.5 3.5 4.0 4 732 38 0.3
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
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
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
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
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
131 Jurassic World (2015) 71 81 59 7.0 7.3 4.5 4.5 3.55 4.05 2.95 3.5 3.65 3.5 4.0 3.0 3.5 3.5 1281 241807 34390 0.0
1 Avengers: Age of Ultron (2015) 74 86 66 7.1 7.8 5.0 4.5 3.7 4.3 3.3 3.55 3.9 3.5 4.5 3.5 3.5 4.0 1330 271107 14846 0.5
26 Selma (2014) 99 86 89 7.1 7.5 5.0 4.6 4.95 4.3 4.45 3.55 3.75 5.0 4.5 4.5 3.5 4.0 316 45344 7025 0.4
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
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
139 Spare Parts (2015) 52 83 50 7.1 7.2 4.5 4.5 2.6 4.15 2.5 3.55 3.6 2.5 4.0 2.5 3.5 3.5 7 47377 450 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
21 McFarland, USA (2015) 79 89 60 7.2 7.5 5.0 4.6 3.95 4.45 3.0 3.6 3.75 4.0 4.5 3.0 3.5 4.0 59 13769 3364 0.4
93 Dope (2015) 87 86 72 7.2 7.5 4.5 4.3 4.35 4.3 3.6 3.6 3.75 4.5 4.5 3.5 3.5 4.0 43 4911 2195 0.2
127 Woman in Gold (2015) 52 81 51 7.2 7.4 4.5 4.4 2.6 4.05 2.55 3.6 3.7 2.5 4.0 2.5 3.5 3.5 72 17957 2435 0.1
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
77 Straight Outta Compton (2015) 90 94 72 7.3 8.4 5.0 4.8 4.5 4.7 3.6 3.65 4.2 4.5 4.5 3.5 3.5 4.0 90 15982 8096 0.2
123 Tangerine (2015) 95 86 86 7.3 7.4 4.0 3.9 4.75 4.3 4.3 3.65 3.7 5.0 4.5 4.5 3.5 3.5 14 696 36 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

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 48.202ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub