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 RT_norm_round

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
18 Southpaw (2015) 59 80 57 8.2 7.8 5.0 4.6 2.95 4.0 2.85 4.1 3.9 3.0 4.0 3.0 4.0 4.0 128 23561 5597 0.4
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
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
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
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
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
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
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
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
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
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
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
23 The Man From U.N.C.L.E. (2015) 68 80 55 7.9 7.6 4.5 4.1 3.4 4.0 2.75 3.95 3.8 3.5 4.0 3.0 4.0 4.0 144 22104 2686 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
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
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
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
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
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
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
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
3 Ant-Man (2015) 80 90 64 8.1 7.8 5.0 4.5 4.0 4.5 3.2 4.05 3.9 4.0 4.5 3.0 4.0 4.0 627 103660 12055 0.5
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
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
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
45 Kingsman: The Secret Service (2015) 75 84 58 7.9 7.8 4.5 4.2 3.75 4.2 2.9 3.95 3.9 4.0 4.0 3.0 4.0 4.0 1054 272204 15205 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
87 Me and Earl and The Dying Girl (2015) 81 89 74 8.4 8.2 4.5 4.3 4.05 4.45 3.7 4.2 4.1 4.0 4.5 3.5 4.0 4.0 41 5269 624 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
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
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
118 Testament of Youth (2015) 81 79 77 7.9 7.3 4.0 3.9 4.05 3.95 3.85 3.95 3.65 4.0 4.0 4.0 4.0 3.5 15 5495 127 0.1
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
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
122 The Stanford Prison Experiment (2015) 84 87 68 8.5 7.1 4.0 3.9 4.2 4.35 3.4 4.25 3.55 4.0 4.5 3.5 4.5 3.5 6 950 51 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

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