home / fivethirtyeight

The Next Bechdel Test: nextBechdel_crewGender.csv

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

10,029 rows

View and edit SQL


1 Rogue One_(2016) Directed by_ Gareth Edwards Gareth http://www.imdb.com/name/nm2284484/?ref_=ttfc_fc_dr1# 0.97 male
2 Rogue One_(2016) Writing Credits _ Chris Weitz Chris http://www.imdb.com/name/nm0919363/?ref_=ttfc_fc_wr1# 0.93 male
3 Rogue One_(2016) Writing Credits _ Tony Gilroy Tony http://www.imdb.com/name/nm0006904/?ref_=ttfc_fc_wr2# 1.0 male
4 Rogue One_(2016) Writing Credits _ John Knoll John http://www.imdb.com/name/nm0461306/?ref_=ttfc_fc_wr3# 0.99 male
5 Rogue One_(2016) Writing Credits _ Gary Whitta Gary http://www.imdb.com/name/nm1729428/?ref_=ttfc_fc_wr4# 1.0 male
6 Rogue One_(2016) Writing Credits _ George Lucas George http://www.imdb.com/name/nm0000184/?ref_=ttfc_fc_wr5# 0.99 male
7 Rogue One_(2016) Produced by_ Simon Emanuel Simon http://www.imdb.com/name/nm0004012/?ref_=ttfc_fc_cr2# 0.99 male
8 Rogue One_(2016) Produced by_ Kiri Hart Kiri http://www.imdb.com/name/nm1848009/?ref_=ttfc_fc_cr3# 0.14 female
9 Rogue One_(2016) Produced by_ Toby Hefferman Toby http://www.imdb.com/name/nm0373556/?ref_=ttfc_fc_cr4# 0.88 male
10 Rogue One_(2016) Produced by_ Finni Johannsson Finni http://www.imdb.com/name/nm0433579/?ref_=ttfc_fc_cr5# 0.0 female
11 Rogue One_(2016) Produced by_ Kathleen Kennedy Kathleen http://www.imdb.com/name/nm0005086/?ref_=ttfc_fc_cr6# 0.0 female
12 Rogue One_(2016) Produced by_ John Knoll John http://www.imdb.com/name/nm0461306/?ref_=ttfc_fc_cr7# 0.99 male
13 Rogue One_(2016) Produced by_ Jason D. McGatlin Jason http://www.imdb.com/name/nm0568980/?ref_=ttfc_fc_cr8# 1.0 male
14 Rogue One_(2016) Produced by_ Allison Shearmur Allison http://www.imdb.com/name/nm1903054/?ref_=ttfc_fc_cr9# 0.0 female
15 Rogue One_(2016) Produced by_ John Swartz John http://www.imdb.com/name/nm1596633/?ref_=ttfc_fc_cr10# 0.99 male
16 Rogue One_(2016) Produced by_ Susan Towner Susan http://www.imdb.com/name/nm0870030/?ref_=ttfc_fc_cr11# 0.0 female
17 Rogue One_(2016) Music by_ Michael Giacchino Michael http://www.imdb.com/name/nm0315974/?ref_=ttfc_fc_cr12# 1.0 male
18 Rogue One_(2016) Cinematography by_ Greig Fraser Greig http://www.imdb.com/name/nm0292132/?ref_=ttfc_fc_cr13# 1.0 male
19 Rogue One_(2016) Film Editing by_ John Gilroy John http://www.imdb.com/name/nm0319673/?ref_=ttfc_fc_cr14# 0.99 male
20 Rogue One_(2016) Film Editing by_ Colin Goudie Colin http://www.imdb.com/name/nm0332148/?ref_=ttfc_fc_cr15# 0.99 male
21 Rogue One_(2016) Film Editing by_ Jabez Olssen Jabez http://www.imdb.com/name/nm1288150/?ref_=ttfc_fc_cr16# 1.0 male
22 Rogue One_(2016) Casting By_ Jina Jay Jina http://www.imdb.com/name/nm0419605/?ref_=ttfc_fc_cr17# 0.0 female
23 Rogue One_(2016) Production Design by_ Doug Chiang Doug http://www.imdb.com/name/nm0156956/?ref_=ttfc_fc_cr18# 1.0 male
24 Rogue One_(2016) Production Design by_ Neil Lamont Neil http://www.imdb.com/name/nm0483678/?ref_=ttfc_fc_cr19# 1.0 male
25 Rogue One_(2016) Art Direction by_ Alex Baily Alex http://www.imdb.com/name/nm2385720/?ref_=ttfc_fc_cr20# 0.87 male
26 Rogue One_(2016) Art Direction by_ Alastair Bullock Alastair http://www.imdb.com/name/nm0120127/?ref_=ttfc_fc_cr21# 1.0 male
27 Rogue One_(2016) Art Direction by_ Robert Cowper Robert http://www.imdb.com/name/nm0184865/?ref_=ttfc_fc_cr22# 1.0 male
28 Rogue One_(2016) Art Direction by_ Jordana Finkel Jordana http://www.imdb.com/name/nm2259831/?ref_=ttfc_fc_cr23# 0.07 female
29 Rogue One_(2016) Art Direction by_ Lydia Fry Lydia http://www.imdb.com/name/nm2490919/?ref_=ttfc_fc_cr24# 0.0 female
30 Rogue One_(2016) Art Direction by_ Ashley Lamont Ashley http://www.imdb.com/name/nm2642085/?ref_=ttfc_fc_cr25# 0.1 female
31 Rogue One_(2016) Art Direction by_ Steven Lawrence Steven http://www.imdb.com/name/nm0493034/?ref_=ttfc_fc_cr26# 1.0 male
32 Rogue One_(2016) Art Direction by_ Oliver Roberts Oliver http://www.imdb.com/name/nm1312181/?ref_=ttfc_fc_cr27# 0.99 male
33 Rogue One_(2016) Art Direction by_ Stuart Rose Stuart http://www.imdb.com/name/nm0741696/?ref_=ttfc_fc_cr28# 0.99 male
34 Rogue One_(2016) Art Direction by_ Stephen Swain Stephen http://www.imdb.com/name/nm1391871/?ref_=ttfc_fc_cr29# 1.0 male
35 Rogue One_(2016) Art Direction by_ Gary Tomkins Gary http://www.imdb.com/name/nm0866772/?ref_=ttfc_fc_cr30# 1.0 male
36 Rogue One_(2016) Art Direction by_ Helen Xenopoulos Helen http://www.imdb.com/name/nm0944424/?ref_=ttfc_fc_cr31# 0.01 female
37 Rogue One_(2016) Set Decoration by_ Lee Sandales Lee http://www.imdb.com/name/nm0761227/?ref_=ttfc_fc_cr32# 0.75 male
38 Rogue One_(2016) Costume Design by_ David Crossman David http://www.imdb.com/name/nm0189366/?ref_=ttfc_fc_cr33# 1.0 male
39 Rogue One_(2016) Costume Design by_ Glyn Dillon Glyn http://www.imdb.com/name/nm1265619/?ref_=ttfc_fc_cr34# 0.98 male
40 Rogue One_(2016) Makeup Department_ Sally Alcott Sally http://www.imdb.com/name/nm3199785/?ref_=ttfc_fc_cr35# 0.01 female
41 Rogue One_(2016) Makeup Department_ Inma Azorin Inma http://www.imdb.com/name/nm2655575/?ref_=ttfc_fc_cr36# 0.0 female
42 Rogue One_(2016) Makeup Department_ Amy Byrne Amy http://www.imdb.com/name/nm1934658/?ref_=ttfc_fc_cr37# 0.01 female
43 Rogue One_(2016) Makeup Department_ Punam Chhatralia Punam http://www.imdb.com/name/nm5824371/?ref_=ttfc_fc_cr38# 0.0 female
44 Rogue One_(2016) Makeup Department_ Emily Rose Connor Emily http://www.imdb.com/name/nm6678764/?ref_=ttfc_fc_cr39# 0.0 female
45 Rogue One_(2016) Makeup Department_ Alexis Continente Alexis http://www.imdb.com/name/nm5566220/?ref_=ttfc_fc_cr40# 0.52 male
46 Rogue One_(2016) Makeup Department_ Francesca Crowder Francesca http://www.imdb.com/name/nm0189570/?ref_=ttfc_fc_cr41# 0.0 female
47 Rogue One_(2016) Makeup Department_ David Dorling David http://www.imdb.com/name/nm4481587/?ref_=ttfc_fc_cr42# 1.0 male
48 Rogue One_(2016) Makeup Department_ Amy Elliot Amy http://www.imdb.com/name/nm2733299/?ref_=ttfc_fc_cr43# 0.01 female
49 Rogue One_(2016) Makeup Department_ Ellie Garratt Ellie http://www.imdb.com/name/nm4553151/?ref_=ttfc_fc_cr44# 0.0 female
50 Rogue One_(2016) Makeup Department_ Richard Glass Richard http://www.imdb.com/name/nm0321994/?ref_=ttfc_fc_cr45# 1.0 male
51 Rogue One_(2016) Makeup Department_ Chloe Grice Chloe http://www.imdb.com/name/nm3853738/?ref_=ttfc_fc_cr46# 0.0 female
52 Rogue One_(2016) Makeup Department_ Lisa Harris Lisa http://www.imdb.com/name/nm4972356/?ref_=ttfc_fc_cr47# 0.0 female
53 Rogue One_(2016) Makeup Department_ Magdalena Janusinska-Surma Magdalena http://www.imdb.com/name/nm8709204/?ref_=ttfc_fc_cr48# 0.0 female
54 Rogue One_(2016) Makeup Department_ Roseanna Larner Roseanna http://www.imdb.com/name/nm4710837/?ref_=ttfc_fc_cr49# 0.0 female
55 Rogue One_(2016) Makeup Department_ Daniel Lawson Johnston Daniel http://www.imdb.com/name/nm4299894/?ref_=ttfc_fc_cr50# 1.0 male
56 Rogue One_(2016) Makeup Department_ Nadine Mann Nadine http://www.imdb.com/name/nm1573445/?ref_=ttfc_fc_cr51# 0.0 female
57 Rogue One_(2016) Makeup Department_ Claire Matthews Claire http://www.imdb.com/name/nm0559970/?ref_=ttfc_fc_cr52# 0.0 female
58 Rogue One_(2016) Makeup Department_ Nuria Mbomio Nuria http://www.imdb.com/name/nm1077345/?ref_=ttfc_fc_cr53# 0.0 female
59 Rogue One_(2016) Makeup Department_ Sian Miller Sian http://www.imdb.com/name/nm0877864/?ref_=ttfc_fc_cr54# 0.01 female
60 Rogue One_(2016) Makeup Department_ Rhiannon Morrell Rhiannon http://www.imdb.com/name/nm6200307/?ref_=ttfc_fc_cr55# 0.01 female
61 Rogue One_(2016) Makeup Department_ Jessica Needham Jessica http://www.imdb.com/name/nm2045727/?ref_=ttfc_fc_cr56# 0.0 female
62 Rogue One_(2016) Makeup Department_ Nicola O'Rourke Nicola http://www.imdb.com/name/nm4167206/?ref_=ttfc_fc_cr57# 0.29 female
63 Rogue One_(2016) Makeup Department_ Hannah Ovenden Hannah http://www.imdb.com/name/nm3870638/?ref_=ttfc_fc_cr58# 0.0 female
64 Rogue One_(2016) Makeup Department_ Katie Pattenden Katie http://www.imdb.com/name/nm3696141/?ref_=ttfc_fc_cr59# 0.0 female
65 Rogue One_(2016) Makeup Department_ Marc Pilcher Marc http://www.imdb.com/name/nm1706094/?ref_=ttfc_fc_cr60# 1.0 male
66 Rogue One_(2016) Makeup Department_ Chlo• Pyne Chlo• http://www.imdb.com/name/nm6546846/?ref_=ttfc_fc_cr61#    
67 Rogue One_(2016) Makeup Department_ Alex Rouse Alex http://www.imdb.com/name/nm1737031/?ref_=ttfc_fc_cr62# 0.87 male
68 Rogue One_(2016) Makeup Department_ Luca Saccuman Luca http://www.imdb.com/name/nm2779150/?ref_=ttfc_fc_cr63# 0.99 male
69 Rogue One_(2016) Makeup Department_ Jemma Scott-Knox-Gore Jemma http://www.imdb.com/name/nm1427373/?ref_=ttfc_fc_cr64# 0.0 female
70 Rogue One_(2016) Makeup Department_ Andrew Simonin Andrew http://www.imdb.com/name/nm2873464/?ref_=ttfc_fc_cr65# 1.0 male
71 Rogue One_(2016) Makeup Department_ Lisa Tomblin Lisa http://www.imdb.com/name/nm0866566/?ref_=ttfc_fc_cr66# 0.0 female
72 Rogue One_(2016) Makeup Department_ Chiara Ugolini Chiara http://www.imdb.com/name/nm2956684/?ref_=ttfc_fc_cr67# 0.01 female
73 Rogue One_(2016) Makeup Department_ Julia Wilson Julia http://www.imdb.com/name/nm0933670/?ref_=ttfc_fc_cr68# 0.01 female
74 Rogue One_(2016) Production Management_ Pippa Anderson Pippa http://www.imdb.com/name/nm0027297/?ref_=ttfc_fc_cr69# 0.02 female
75 Rogue One_(2016) Production Management_ Karl Caffrey Karl http://www.imdb.com/name/nm2137336/?ref_=ttfc_fc_cr70# 1.0 male
76 Rogue One_(2016) Production Management_ Ben Dixon Ben http://www.imdb.com/name/nm0228762/?ref_=ttfc_fc_cr71# 0.99 male
77 Rogue One_(2016) Production Management_ Simon Emanuel Simon http://www.imdb.com/name/nm0004012/?ref_=ttfc_fc_cr72# 0.99 male
78 Rogue One_(2016) Production Management_ Arni Hansson Arni http://www.imdb.com/name/nm0361420/?ref_=ttfc_fc_cr73# 0.13 female
79 Rogue One_(2016) Production Management_ Nicole Letaw Nicole http://www.imdb.com/name/nm5078788/?ref_=ttfc_fc_cr74# 0.0 female
80 Rogue One_(2016) Production Management_ Adam Teeuw Adam http://www.imdb.com/name/nm1288710/?ref_=ttfc_fc_cr75# 1.0 male
81 Rogue One_(2016) Production Management_ Susan Towner Susan http://www.imdb.com/name/nm0870030/?ref_=ttfc_fc_cr76# 0.0 female
82 Rogue One_(2016) Production Management_ Diala Al Raie Diala http://www.imdb.com/name/nm2476213/?ref_=ttfc_fc_cr77# 0.04 female
83 Rogue One_(2016) Production Management_ Birna Paulina Einarsdottir Birna http://www.imdb.com/name/nm1021435/?ref_=ttfc_fc_cr78# 0.0 female
84 Rogue One_(2016) Second Unit Director or Assistant Director_ Tarik Afifi Tarik http://www.imdb.com/name/nm3199917/?ref_=ttfc_fc_cr79# 1.0 male
85 Rogue One_(2016) Second Unit Director or Assistant Director_ Dan Channing Williams Dan http://www.imdb.com/name/nm1076211/?ref_=ttfc_fc_cr80# 0.98 male
86 Rogue One_(2016) Second Unit Director or Assistant Director_ Simon Crane Simon http://www.imdb.com/name/nm0186426/?ref_=ttfc_fc_cr81# 0.99 male
87 Rogue One_(2016) Second Unit Director or Assistant Director_ Gar“n Danêelsdãttir Gar“n http://www.imdb.com/name/nm1309719/?ref_=ttfc_fc_cr82#    
88 Rogue One_(2016) Second Unit Director or Assistant Director_ Jonny Eagle Jonny http://www.imdb.com/name/nm4424501/?ref_=ttfc_fc_cr83# 1.0 male
89 Rogue One_(2016) Second Unit Director or Assistant Director_ Fraser Fennell-Ball Fraser http://www.imdb.com/name/nm1004311/?ref_=ttfc_fc_cr84# 0.99 male
90 Rogue One_(2016) Second Unit Director or Assistant Director_ Clare Glass Clare http://www.imdb.com/name/nm1216551/?ref_=ttfc_fc_cr85# 0.0 female
91 Rogue One_(2016) Second Unit Director or Assistant Director_ Toby Hefferman Toby http://www.imdb.com/name/nm0373556/?ref_=ttfc_fc_cr86# 0.88 male
92 Rogue One_(2016) Second Unit Director or Assistant Director_ Toby Hosking Toby http://www.imdb.com/name/nm0396010/?ref_=ttfc_fc_cr87# 0.88 male
93 Rogue One_(2016) Second Unit Director or Assistant Director_ David Keadell David http://www.imdb.com/name/nm2507861/?ref_=ttfc_fc_cr88# 1.0 male
94 Rogue One_(2016) Second Unit Director or Assistant Director_ Teariki Leonard Teariki http://www.imdb.com/name/nm4246191/?ref_=ttfc_fc_cr89#    
95 Rogue One_(2016) Second Unit Director or Assistant Director_ Andy Madden Andy http://www.imdb.com/name/nm1820336/?ref_=ttfc_fc_cr90# 0.95 male
96 Rogue One_(2016) Second Unit Director or Assistant Director_ John Mahaffie John http://www.imdb.com/name/nm0536724/?ref_=ttfc_fc_cr91# 0.99 male
97 Rogue One_(2016) Second Unit Director or Assistant Director_ Guy Mannerings Guy http://www.imdb.com/name/nm2827444/?ref_=ttfc_fc_cr92# 1.0 male
98 Rogue One_(2016) Second Unit Director or Assistant Director_ Michela Marini Michela http://www.imdb.com/name/nm4177336/?ref_=ttfc_fc_cr93# 0.0 female
99 Rogue One_(2016) Second Unit Director or Assistant Director_ Phoebe Vale Markham Phoebe http://www.imdb.com/name/nm3283733/?ref_=ttfc_fc_cr94# 0.0 female
100 Rogue One_(2016) Second Unit Director or Assistant Director_ James McGrady James http://www.imdb.com/name/nm2334201/?ref_=ttfc_fc_cr95# 0.99 male

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "next-bechdel/nextBechdel_crewGender" (
Powered by Datasette · Query took 183.294ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub