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

21 rows where ko = 0

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Link rowid ▼ movie bechdel peirce landau feldman villareal hagen ko villarobos waithe koeze_dottle uphold white rees-davies
1 1 Bad Moms 0 0 0 1 0 0 0 1 0 0 1 1 1
2 2 Hidden Figures 0 0 0 0 0 1 0 1 0 1 1 1 1
3 3 Independence Day: Resurgence 0 0 1 0 0 1 0 1 0 0 1 1 1
5 5 Ghostbusters 0 0 0 0 0 1 0 1 1 1 1 1 1
6 6 Allegiant 0 0 1 0 0 1 0 1 1 1 1 1 1
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
14 14 Boo! A Madea Halloween 0 0 1 1 1 1 0 1 0 0 1 1 1
16 16 Fantastic Beasts and Where to Find Them 0 0 1 1 0 1 0 1 1 1 1 1 1
18 18 Now You See Me 2 1 0 0 1 0 1 0 1 1 1 1 1 1
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
25 25 The Purge: Election Year 0 0 1 1 0 1 0 1 1 1 1 1 1
30 30 Central Intelligence 1 0 1 1 1 1 0 1 0 1 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
39 39 The Angry Birds Movie 1 1 0 1 0 1 0 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

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
);