Fandango: fandango_scrape.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

510 rows sorted by FILM

View and edit SQL

Suggested facets: STARS

Link rowid FILM ▼ STARS RATING VOTES
293 Like Sunday, Like Rain (2015) 4.0 3.7 10
126 '71 (2015) 3.5 3.5 192
386 1001 Grams (2015) 3.0 3.0 2
307 12 Golden Ducks (2015) 5.0 4.5 8
353 24 Days (2015) 3.5 3.3 4
344 3 1/2 Minutes, Ten Bullets (2015) 4.0 4.0 5
235 3 Hearts (2015) 3.0 2.8 22
150 5 Flights Up (2015) 4.0 3.6 79
226 5 to 7 (2015) 3.5 3.4 24
438 6 Years (2015) 0.0 0.0 0
439 7 Minutes (2015) 0.0 0.0 0
158 A Girl Like Her (2015) 4.5 4.2 66
424 A Hard Day (2015) 5.0 5.0 1
252 A LEGO Brickumentary (2015) 4.5 4.4 19
103 A La Mala (2015) 5.0 4.6 536
148 A Little Chaos (2015) 4.0 3.9 83
425 A Midsummer Night's Dream (2015) 5.0 5.0 1
99 A Most Violent Year (2014) 3.5 3.4 675
426 A Murder In The Park (2015) 5.0 5.0 1
286 A Pigeon Sat on a Branch Reflecting on Existence (2015) 3.5 3.2 11
370 A Poem Is a Naked Person (2015) 4.0 3.7 3
373 A Walk in the Woods (2015) 4.5 4.3 3
440 A Year in Champagne (2015) 0.0 0.0 0
173 ABCD 2 (2015) 4.0 3.8 58
194 About Elly (2015) 4.0 3.6 43
155 Above and Beyond (2015) 4.5 4.4 70
319 After Words (2015) 4.0 3.6 7
283 All Is Well (2015) 3.0 2.6 11
279 Aloft (2015) 3.0 3.0 13
61 Aloha (2015) 3.5 3.1 2284
3 American Sniper (2015) 5.0 4.8 34085
100 American Ultra (2015) 4.0 3.7 638
312 Amira & Sam (2015) 5.0 4.8 8
407 Amour Fou (2015) 3.0 3.0 1
96 Amy (2015) 4.5 4.4 729
251 An Honest Liar (2015) 4.0 3.8 19
343 An Open Secret (2015) 3.0 3.0 5
149 Angrej (2015) 5.0 4.8 80
26 Annie (2014) 4.5 4.2 6835
12 Ant-Man (2015) 5.0 4.5 12055
223 Antony and Cleopatra (Stratford Festival) (2015) 3.5 3.0 25
395 Appropriate Behavior (2015) 5.0 5.0 2
175 Assassination (2015) 5.0 4.6 57
9 Avengers: Age of Ultron (2015) 5.0 4.5 14846
66 Baahubali: The Beginning (2015) 5.0 4.6 1922
328 Backcountry (2015) 4.0 3.8 6
85 Bajrangi Bhaijaan (2015) 5.0 4.6 1035
242 Ballet 422 (2015) 3.0 3.0 21
441 Balls Out (2015) 0.0 0.0 0
313 Barely Lethal (2015) 5.0 4.8 8
234 Batkid Begins (2015) 4.5 4.2 22
442 Before I Wake (2015) 0.0 0.0 0
320 Beloved Sisters (2014) 3.5 3.3 7
245 Best of Enemies (2015) 3.5 3.3 20
127 Beyond the Mask (2015) 4.5 4.4 189
74 Big Eyes (2014) 4.0 3.8 1501
225 Big Game (2015) 4.0 3.5 24
443 Big Significant Things (2015) 0.0 0.0 0
185 Bin Roye (2015) 4.5 4.4 50
39 Birdman (2014) 4.0 3.7 4194
354 Black Mass (2015) 3.5 3.3 4
123 Black Sea (2015) 4.0 3.5 218
69 Black or White (2015) 4.5 4.2 1862
76 Blackhat (2015) 3.0 2.8 1430
157 Bolshoi Ballet: Romeo And Juliet (2015) 4.5 4.2 68
139 Bolshoi Ballet: Swan Lake (2015) 4.5 4.1 112
156 Bolshoi Ballet: The Nutcracker (2014) 4.5 4.4 70
345 Bonobos: Back To The Wild (2015) 4.0 4.0 5
220 Boulevard (2015) 4.5 4.1 27
427 Bound to Vengeance (2015) 5.0 5.0 1
249 Boychoir (2015) 5.0 4.7 19
153 Brothers: Blood Against Blood (2015) 4.0 4.0 74
416 Buggs Bunny (2015) 4.0 4.0 1
371 Buzzard (2015) 4.0 3.7 3
106 Cake (2015) 3.5 3.4 482
273 Can't Stand Losing You: Surviving The Police (2015) 4.5 4.4 14
444 Caprice (2015) 0.0 0.0 0
428 Captive (2015) 5.0 5.0 1
163 Cartel Land (2015) 4.5 4.2 64
445 Cas désespéré (2015) 0.0 0.0 0
446 Chagall Malevich (2015) 0.0 0.0 0
45 Chappie (2015) 4.0 3.8 3642
387 Charlie's Country (2015) 3.0 3.0 2
318 Cheatin' (2015) 5.0 5.0 8
114 Child 44 (2015) 4.0 3.7 308
129 Chocolate City (2015) 4.0 3.8 176
11 Cinderella (2015) 5.0 4.5 12640
221 Classic Music Series: Aerosmith (2015) 5.0 4.6 27
165 Classic Music Series: Led Zeppelin (2015) 4.5 4.5 64
405 Closer to the Moon (2015) 2.0 2.0 1
130 Clouds of Sils Maria (2015) 3.5 3.4 162
447 Coffee Bloom (2015) 0.0 0.0 0
448 Come Blow Your Horn (2015) 0.0 0.0 0
236 Cop Car (2015) 3.5 3.4 22
372 Court (2015) 4.0 3.7 3
356 Cupcakes (2015) 4.0 3.8 4
321 Cut Bank (2015) 3.5 3.3 7
292 Cymbeline (2015) 4.0 3.7 10
132 DCI 2015 Tour Premiere (2015) 5.0 4.7 128
113 DIl Dhadakne Do (2015) 4.0 4.0 316

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "fandango/fandango_scrape" (
"FILM" TEXT,
  "STARS" REAL,
  "RATING" REAL,
  "VOTES" INTEGER
);
Powered by Datasette · Query took 119.218ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub