The Next Bechdel Test: nextBechdel_allTests.csv

Table actions

This table contains data behind the story The Next Bechdel Test.

nextBechal_allTests.csv and shows the high-level breakdown of which movies passed and failed - Each row is one of the 50 top-grossing movies from 2016. - Each column is one of the tests. A 0 means the movie failed that test, a 1 means it passed.

nextBechal_castGender.csv contains the estimated gender for the entire cast for every movie, including whether a role was supporting or main. Data was obtained from The Numbers.

Variable Definition
MOVIE Title of the film
ACTOR Full name of the actor
CHARACTER All characters played by the actor in that movie
TYPE Leading, Supporting, Cameo or Lead Ensemble Member
BILLING Billing number
GENDER Estimated gender of the actor

nextBechal_crewGender.csv contains data for the crew for every movie, by probablity that a give first name is male.

Variable Definition
MOVIE Title of the film
DEPARTMENT Full name of the actor
FULL_NAME Actor's first and last name
FIRST_NAME Just first name of actor
IMDB Actor's IMDB page
GENDER_PROB Percent chance that a given name is male
GENDER_GUESS Based on the probablity, guess if the name is male or female

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

23 rows where villareal = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: bechdel, peirce, landau, feldman, ko, waithe, koeze_dottle, rees-davies

Link rowid ▼ movie bechdel peirce landau feldman villareal hagen ko villarobos waithe koeze_dottle uphold white rees-davies
8 8 Ice Age: Collision Course 0 1 0 1 1 1 0 1 1 0 1 1 0
9 9 Kung Fu Panda 3 0 1 0 0 1 1 0 1 1 1 1 1 0
11 11 Sing 0 0 1 1 1 1 0 1 1 0 1 1 0
12 12 The Boss 0 0 0 0 1 1 1 1 1 0 1 1 1
14 14 Boo! A Madea Halloween 0 0 1 1 1 1 0 1 0 0 1 1 1
15 15 Alice Through the Looking Glass 0 0 1 0 1 1 1 1 1 1 1 1 0
21 21 Sausage Party 0 0 1 1 1 1 0 1 1 1 1 1 0
23 23 Suicide Squad 0 0 1 1 1 1 0 1 1 1 1 1 0
29 29 Captain America: Civil War 0 0 1 1 1 1 1 1 1 1 1 1 0
30 30 Central Intelligence 1 0 1 1 1 1 0 1 0 1 1 1 1
31 31 Don't Breathe 0 0 1 1 1 1 1 1 1 0 1 1 1
33 33 Lights Out 0 0 1 1 1 1 1 1 1 0 1 1 1
34 34 Moana 0 0 1 1 1 1 0 1 1 1 1 1 1
35 35 Ride Along 2 1 0 0 1 1 1 0 1 1 1 1 1 1
36 36 Star Trek Beyond 1 0 1 1 1 1 0 1 1 1 1 1 0
41 41 Trolls 0 0 1 1 1 1 1 1 1 0 1 1 1
43 43 Jason Bourne 1 0 1 1 1 1 1 1 1 1 1 1 0
44 44 Rogue One 0 0 1 1 1 1 1 1 1 1 1 1 1
45 45 The Accountant 1 0 1 1 1 1 0 1 1 1 1 1 1
46 46 The Jungle Book 1 1 0 1 1 1 0 1 1 1 1 1 1
48 48 Deadpool 1 1 1 1 1 1 1 1 1 0 1 1 1
49 49 Doctor Strange 1 1 1 1 1 1 1 1 1 1 1 1 0
50 50 The Secret Life of Pets 1 0 1 1 1 1 1 1 1 1 1 1 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "next-bechdel/nextBechdel_allTests" (
"movie" TEXT,
  "bechdel" INTEGER,
  "peirce" INTEGER,
  "landau" INTEGER,
  "feldman" INTEGER,
  "villareal" INTEGER,
  "hagen" INTEGER,
  "ko" INTEGER,
  "villarobos" INTEGER,
  "waithe" INTEGER,
  "koeze_dottle" INTEGER,
  "uphold" INTEGER,
  "white" INTEGER,
  "rees-davies" INTEGER
);