fandango/fandango_score_comparison

146 rows

View and edit SQL

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
120 Phoenix (2015) 99 81 91 8.0 7.2 3.5 3.4 4.95 4.05 4.55 4.0 3.6 5.0 4.0 4.5 4.0 3.5 21 3687 70 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
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
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
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
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
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
129 Mission: Impossible – Rogue Nation (2015) 92 90 75 8.0 7.8 4.5 4.4 4.6 4.5 3.75 4.0 3.9 4.5 4.5 4.0 4.0 4.0 362 82579 8357 0.1
130 Amy (2015) 97 91 85 8.8 8.0 4.5 4.4 4.85 4.55 4.25 4.4 4.0 5.0 4.5 4.5 4.5 4.0 60 5630 729 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
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
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
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
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
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
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
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
141 Inside Out (2015) 98 90 94 8.9 8.6 4.5 4.5 4.9 4.5 4.7 4.45 4.3 5.0 4.5 4.5 4.5 4.5 807 96252 15749 0.0
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
143 '71 (2015) 97 82 83 7.5 7.2 3.5 3.5 4.85 4.1 4.15 3.75 3.6 5.0 4.0 4.0 4.0 3.5 60 24116 192 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
145 Gett: The Trial of Viviane Amsalem (2015) 100 81 90 7.3 7.8 3.5 3.5 5.0 4.05 4.5 3.65 3.9 5.0 4.0 4.5 3.5 4.0 19 1955 59 0.0
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

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 4.614ms