Biopics: biopics.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
761 rows sorted by country
This data as json, copyable, CSV (advanced)
Suggested facets: country, number_of_subjects, race_known, subject_race, person_of_color, subject_sex
type_of_subject 27 ✖
- Other 159
- Criminal 81
- Historical 76
- Musician 76
- Athlete 74
- Author 45
- Military 45
- Activist 31
- Artist 29
- Academic 21
- Singer 20
- World leader 17
- Actress 16
- Media 15
- Actor 14
- Author (poet) 13
- Medicine 9
- Comedian 7
- Government 4
- Journalist 2
- Academic (Philosopher) 1
- Actress 1
- Actress / activist 1
- Athlete / military 1
- Military / activist 1
- Politician 1
- Teacher 1
Link | rowid | title | site | country ▼ | year_release | box_office | director | number_of_subjects | subject | type_of_subject | race_known | subject_race | person_of_color | subject_sex | lead_actor_actress |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | 1987 | http://www.imdb.com/title/tt2833074/ | Canada | 2014 | - | Ricardo Trogi | 1 | Ricardo Trogi | Other | Known | White | 0 | Male | Jean-Carl Boucher |
120 | 120 | Casino Jack | http://www.imdb.com/title/tt1194417/ | Canada | 2010 | $1.04M | George Hickenlooper | 1 | Jack Abramoff | Other | Unknown | 0 | Male | Kevin Spacey | |
214 | 214 | Frankie & Alice | http://www.imdb.com/title/tt1221208/ | Canada | 2010 | $693K | Geoffrey Sax | 1 | Frankie Murdoch | Other | Known | African American | 1 | Female | Halle Berry |
275 | 275 | If You Could See What I Hear | http://www.imdb.com/title/tt0084117/ | Canada | 1982 | - | Eric Till | 1 | Tom Sullivan | Singer | Known | White | 0 | Male | Marc Singer |
295 | 295 | Jappeloup | http://www.imdb.com/title/tt2018079/ | Canada | 2013 | - | Christian Duguay | 1 | Pierre Durand, Jr. | Athlete | Known | White | 0 | Male | Guillaume Canet |
341 | 341 | Louis Cyr | http://www.imdb.com/title/tt1657513/ | Canada | 2013 | - | Daniel Roby | 1 | Louis Cyr | Athlete | Known | White | 0 | Male | Antoine Bertrand |
370 | 370 | Mesrine Part 1: Killer Instinct | http://www.imdb.com/title/tt1259014/ | Canada | 2008 | $552K | Jean-Fran̤ois Richet | 1 | Jacques Mesrine | Criminal | Known | White | 0 | Male | Vincent Cassel |
371 | 371 | Mesrine Part 2: Public Enemy #1 | http://www.imdb.com/title/tt0411272/ | Canada | 2008 | $275K | Jean-Fran̤ois Richet | 1 | Jacques Mesrine | Criminal | Known | White | 0 | Male | Vincent Cassel |
535 | 535 | The Bang Bang Club | http://www.imdb.com/title/tt1173687/ | Canada | 2010 | - | Steven Silver | 4 | Greg Marinovich | Media | Unknown | 0 | Male | ||
536 | 536 | The Bang Bang Club | http://www.imdb.com/title/tt1173687/ | Canada | 2010 | - | Steven Silver | 4 | Jọo Silva | Media | Known | White | 0 | Male | |
537 | 537 | The Bang Bang Club | http://www.imdb.com/title/tt1173687/ | Canada | 2010 | - | Steven Silver | 4 | Ken Oosterbroek | Media | Unknown | 0 | Male | ||
538 | 538 | The Bang Bang Club | http://www.imdb.com/title/tt1173687/ | Canada | 2010 | - | Steven Silver | 4 | Kevin Carter | Media | Known | White | 0 | Male | Taylor Kitsch |
547 | 547 | The Boy in Blue | http://www.imdb.com/title/tt0090769/ | Canada | 1986 | $275K | Charles Jarrott | 1 | Ned Hanlan | Athlete | Known | White | 0 | Male | Nicolas Cage |
577 | 577 | The Gaul | http://www.imdb.com/title/tt0199481/ | Canada | 2001 | - | Jacques Dorfmann | 1 | Vercingetorix | Historical | Known | White | 0 | Male | Christopher Lambert |
588 | 588 | The Grey Fox | http://www.imdb.com/title/tt0085622/ | Canada | 1982 | - | Phillip Borsos | 1 | Bill Miner | Other | Unknown | 0 | Male | Richard Farnsworth | |
658 | 658 | The Rocket: The Legend of Rocket Richard | http://www.imdb.com/title/tt0460505/ | Canada | 2005 | - | Charles BinamÌÄå© | 1 | Maurice "The Rocket" Richard | Athlete | Known | White | 0 | Male | Roy Dupuis |
699 | 699 | Thirty Two Short Films About Glenn Gould | http://www.imdb.com/title/tt0108328/ | Canada | 1993 | $1.57M | Fran̤ois Girard | 1 | Glenn Gould | Musician | Known | White | 0 | Male | Colm Feore |
746 | 746 | Winnie Mandela | http://www.imdb.com/title/tt1551641/ | Canada | 2011 | - | Darrell Roodt | 1 | Winnie Mandela | Government | Known | African | 1 | Female | Jennifer Hudson |
13 | 13 | A Dangerous Method | http://www.imdb.com/title/tt1571222/ | Canada/UK | 2011 | $5.7M | David Cronenberg | 3 | Carl Gustav Jung | Academic | Known | White | 0 | Male | Michael Fassbender |
14 | 14 | A Dangerous Method | http://www.imdb.com/title/tt1571222/ | Canada/UK | 2011 | $5.7M | David Cronenberg | 3 | Sigmund Freud | Academic | Known | White | 0 | Male | Viggo Mortensen |
15 | 15 | A Dangerous Method | http://www.imdb.com/title/tt1571222/ | Canada/UK | 2011 | $5.7M | David Cronenberg | 3 | Sabina Spielrein | Academic | Known | White | 0 | Female | Keira Knightley |
66 | 66 | Behind the Lines | http://www.imdb.com/title/tt0120001/ | Canada/UK | 1997 | $19.3K | Gillies MacKinnon | 1 | Siegfried Loraine Sassoon | Military | Known | Multi racial | 0 | Male | James Wilby |
240 | 240 | Grey Owl | http://www.imdb.com/title/tt0128239/ | Canada/UK | 1999 | $315K | Richard Attenborough | 1 | Grey Owl (Archibald Belaney) | Other | Known | Multi racial | 1 | Male | Pierce Brosnan |
326 | 326 | La Vie en Rose | http://www.imdb.com/title/tt0450188/ | Canada/UK | 2007 | $10.3M | Olivier Dahan | 1 | Ìädith Piaf. | Singer | Known | White | 0 | Female | Marion Cotillard |
369 | 369 | Mesmer | http://www.imdb.com/title/tt0110496/ | Canada/UK | 1994 | - | Roger Spottiswoode | 1 | Franz Anton Mesmer | Medicine | Known | White | 0 | Male | Alan Rickman |
405 | 405 | Nightwatching | http://www.imdb.com/title/tt0446750/ | Canada/UK | 2007 | - | Peter Greenaway | 1 | Rembrandt | Artist | Known | White | 0 | Male | Martin Freeman |
411 | 411 | Nowhere Boy | http://www.imdb.com/title/tt1266029/ | Canada/UK | 2009 | $1.45M | Sam Taylor-Johnson | 1 | John Lennon | Musician | Known | White | 0 | Male | Aaron Taylor-Johnson |
501 | 501 | Stander | http://www.imdb.com/title/tt0326208/ | Canada/UK | 2003 | $19.1K | Bronwen Hughes | 1 | Andre Stander | Other | Known | White | 0 | Male | Thomas Jane |
684 | 684 | The Visual Bible: The Gospel of John | http://www.imdb.com/title/tt0377992/ | Canada/UK | 2003 | $4.07M | Philip Saville | 1 | Jesus | Historical | Known | Middle Eastern (White) | 0 | Male | Henry Ian Cusick |
709 | 709 | To Walk with Lions | http://www.imdb.com/title/tt0132563/ | Canada/UK | 1999 | - | Carl Schultz | 2 | George Adamson | Other | Unknown | 0 | Male | Richard Harris | |
710 | 710 | To Walk with Lions | http://www.imdb.com/title/tt0132563/ | Canada/UK | 1999 | - | Carl Schultz | 2 | Tony Fitzjohn | Other | Unknown | 0 | Male | John Michie | |
1 | 1 | 10 Rillington Place | http://www.imdb.com/title/tt0066730/ | UK | 1971 | - | Richard Fleischer | 1 | John Christie | Criminal | Unknown | 0 | Male | Richard Attenborough | |
7 | 7 | 24 Hour Party People | http://www.imdb.com/title/tt0274309/ | UK | 2002 | $1.13M | Michael Winterbottom | 1 | Tony Wilson | Musician | Known | White | 0 | Male | Steve Coogan |
18 | 18 | A Man for All Seasons | http://www.imdb.com/title/tt0060665/ | UK | 1966 | - | Fred Zinnemann | 1 | Thomas More | Historical | Known | White | 0 | Male | Paul Scofield |
43 | 43 | An Angel at My Table | http://www.imdb.com/title/tt0099040/ | UK | 1990 | $1.1M | Jane Campion | 1 | Janet Frame | Author | Known | White | 0 | Female | Kerry Fox |
48 | 48 | Another Country | http://www.imdb.com/title/tt0086904/ | UK | 1984 | - | Marek Kanievska | 1 | Guy Burgess | Military | Unknown | 0 | Male | Rupert Everett | |
53 | 53 | Baader | http://www.imdb.com/title/tt0309320/ | UK | 2002 | - | Christopher Roth | 1 | Andreas Baader | Military | Known | White | 0 | Male | Frank Giering |
54 | 54 | Backbeat | http://www.imdb.com/title/tt0106339/ | UK | 1994 | $2.39M | Iain Softley | 2 | John Lennon | Musician | Known | White | 0 | Male | Ian Hart |
55 | 55 | Backbeat | http://www.imdb.com/title/tt0106339/ | UK | 1994 | $2.39M | Iain Softley | 2 | Stuart Sutcliffe | Musician | Known | White | 0 | Male | Stephen Dorff |
56 | 56 | Bandit Queen | http://www.imdb.com/title/tt0109206/ | UK | 1994 | $400K | Shekhar Kapur | 1 | Phoolan Devi | Criminal | Known | Indian | 1 | Female | Seema Biswas |
59 | 59 | Bathory: Countess of Blood | http://www.imdb.com/title/tt0469640/ | UK | 2008 | - | Juraj Jakubisko | 1 | Elizabeth Bathory | Criminal | Known | White | 0 | Female | Anna Friel |
64 | 64 | Becoming Jane | http://www.imdb.com/title/tt0416508/ | UK | 2007 | $18.7M | Julian Jarrold | 1 | Jane Austen | Author | Known | White | 0 | Female | Anne Hathaway |
69 | 69 | Best | http://www.imdb.com/title/tt0181311/ | UK | 2000 | - | Mary McGuckian | 1 | George Best | Athlete | Known | White | 0 | Male | John Lynch |
80 | 80 | Blue | http://www.imdb.com/title/tt0106438/ | UK | 1993 | $1.72M | Derek Jarman | 1 | Derek Jarman | Other | Unknown | 0 | Male | Derek Jarman | |
92 | 92 | Bright Star | http://www.imdb.com/title/tt0810784/ | UK | 2009 | $4.44M | Jane Campion | 2 | John Keats | Author (poet) | Known | White | 0 | Male | Ben Whishaw |
93 | 93 | Bright Star | http://www.imdb.com/title/tt0810784/ | UK | 2009 | $4.44M | Jane Campion | 2 | Fanny Brawne | Other | Unknown | 0 | Female | Abbie Cornish | |
94 | 94 | Bronson | http://www.imdb.com/title/tt1172570/ | UK | 2008 | $105K | Nicolas Winding Refn | 1 | Charles Bronson | Criminal | Unknown | 0 | Male | Tom Hardy | |
95 | 95 | Brother Sun, Sister Moon | http://www.imdb.com/title/tt0069824/ | UK | 1972 | - | Franco Zeffirelli | 1 | St. Francis of Assisi | Historical | Known | White | 0 | Male | Graham Faulkner |
100 | 100 | Buster | http://www.imdb.com/title/tt0094819/ | UK | 1988 | $540K | David Green | 1 | Buster Edwards | Criminal | Unknown | 0 | Male | Phil Collins | |
106 | 106 | Caesar and Cleopatra | http://www.imdb.com/title/tt0038390/ | UK | 1945 | - | Gabriel Pascal | 2 | Julius Caesar | Historical | Known | White | 0 | Male | Claude Rains |
107 | 107 | Caesar and Cleopatra | http://www.imdb.com/title/tt0038390/ | UK | 1945 | - | Gabriel Pascal | 2 | Cleopatra | Historical | Known | Middle Eastern | 1 | Female | Vivien Leigh |
108 | 108 | Callas Forever | http://www.imdb.com/title/tt0274407/ | UK | 2002 | $446K | Franco Zeffirelli | 1 | Maria Callas | Singer | Known | Mediterranean | 0 | Female | Fanny Ardant |
114 | 114 | Caravaggio | http://www.imdb.com/title/tt0090798/ | UK | 1986 | $3.15K | Derek Jarman | 1 | Michelangelo Merisi de Caravaggio | Artist | Known | White | 0 | Male | Multiple |
116 | 116 | Carrington | http://www.imdb.com/title/tt0112637/ | UK | 1995 | $3.24M | Christopher Hampton | 2 | Lytton Strachey | Author | Known | White | 0 | Male | Jonathan Pryce |
117 | 117 | Carrington | http://www.imdb.com/title/tt0112637/ | UK | 1995 | $3.24M | Christopher Hampton | 2 | Dora Carrington | Artist | Known | White | 0 | Female | Emma Thompson |
118 | 118 | Carve Her Name with Pride | http://www.imdb.com/title/tt0051454/ | UK | 1958 | - | Lewis Gilbert | 1 | Violette Bushell Szabo | Military | Known | White | 0 | Female | Virginia McKenna |
121 | 121 | Cass | http://www.imdb.com/title/tt0954981/ | UK | 2008 | - | Jon S. Baird | 1 | Cass Pennant | Other | Known | Caribbean | 1 | Male | Nonso Anozie |
148 | 148 | Creation | http://www.imdb.com/title/tt0974014/ | UK | 2009 | $341K | Jon Amiel | 1 | Charles Darwin | Academic | Unknown | 0 | Male | Paul Bettany | |
149 | 149 | Cromwell | http://www.imdb.com/title/tt0065593/ | UK | 1970 | - | Ken Hughes | 1 | Oliver Cromwell | Historical | Known | White | 0 | Male | Richard Harris |
152 | 152 | Cry Freedom | http://www.imdb.com/title/tt0092804/ | UK | 1987 | $5.9M | Richard Attenborough | 1 | Steve Biko | Activist | Known | African | 1 | Male | Denzel Washington |
156 | 156 | Dance with a Stranger | http://www.imdb.com/title/tt0088987/ | UK | 1985 | $138K | Mike Newell | 1 | Ruth Ellis | Criminal | Unknown | 0 | Female | Miranda Richardson | |
161 | 161 | Desert Dancer | http://www.imdb.com/title/tt2403393/ | UK | 2014 | $144K | Richard Raymond | 1 | Afshin Ghaffarian | Artist | Known | Middle Eastern | 1 | Male | Reece Ritchie |
162 | 162 | Desert Flower | http://www.imdb.com/title/tt1054580/ | UK | 2009 | $44.3K | Sherry Hormann | 1 | Waris Dirie | Activist | Known | African | 1 | Female | Soraya Omar-Scego (young) and Liya Kebede (older) |
171 | 171 | Diana | http://www.imdb.com/title/tt1758595/ | UK | 2013 | $332K | Oliver Hirschbiegel | 1 | Princess Diana | Other | Known | White | 0 | Female | Naomi Watts |
181 | 181 | Dreamchild | http://www.imdb.com/title/tt0089052/ | UK | 1985 | - | Gavin Millar | 1 | Alice Liddell Hargreaves | Other | Unknown | 0 | Female | Coral Browne | |
185 | 185 | Eichmann | http://www.imdb.com/title/tt0901481/ | UK | 2007 | - | Robert Young | 1 | Adolf Eichmann | Military | Known | White | 0 | Male | Thomas Kretschmann |
197 | 197 | Exodus: Gods and Kings | http://www.imdb.com/title/tt1528100/ | UK | 2014 | $65M | Ridley Scott | 1 | Moses | Historical | Known | Middle Eastern (White) | 0 | Male | Christian Bale |
221 | 221 | Gandhi | http://www.imdb.com/title/tt0083987/ | UK | 1982 | - | Richard Attenborough | 1 | Mahatma Gandhi | Activist | Known | Indian | 1 | Male | Ben Kingsley |
226 | 226 | Girl with a Pearl Earring | http://www.imdb.com/title/tt0335119/ | UK | 2003 | $11.6M | Peter Webber | 1 | Johannes Vermeer | Artist | Known | White | 0 | Male | Colin Firth |
230 | 230 | Goltzius and the Pelican Company | http://www.imdb.com/title/tt1851006/ | UK | 2012 | - | Peter Greenaway | 1 | Hendrik Goltzius | Artist | Known | White | 0 | Male | Ramsey Nasr |
232 | 232 | Good Vibrations | http://www.imdb.com/title/tt1920945/ | UK | 2012 | - | Lisa Barros D'Sa, Glenn Leyburn | 1 | Terri Hooley | Musician | Unknown | 0 | Male | Richard Dormer | |
251 | 251 | Henry V | http://www.imdb.com/title/tt0036910/ | UK | 1944 | - | Laurence Olivier | 1 | Henry V of England | Historical | Known | White | 0 | Male | Laurence Olivier |
252 | 252 | Henry V | http://www.imdb.com/title/tt0097499/ | UK | 1989 | $10.2M | Kenneth Branagh | 1 | Henry V of England | Historical | Known | White | 0 | Male | Kenneth Branagh |
254 | 254 | Hilary and Jackie | http://www.imdb.com/title/tt0150915/ | UK | 1998 | $4.87M | Anand Tucker | 2 | Jacqueline du Pr̩ | Musician | Known | White | 0 | Female | Emily Watson |
255 | 255 | Hilary and Jackie | http://www.imdb.com/title/tt0150915/ | UK | 1998 | $4.87M | Anand Tucker | 2 | Hilary du Pr̩-Finzi | Musician | Known | White | 0 | Female | Rachel Griffiths |
259 | 259 | Hitler: A Film from Germany | http://www.imdb.com/title/tt0076147/ | UK | 1977 | - | Hans-JÌ_rgen Syberberg | 1 | Adolf Hitler | Military | Known | White | 0 | Male | Heinz Schubert |
260 | 260 | Hitler: The Last Ten Days | http://www.imdb.com/title/tt0070184/ | UK | 1973 | - | Ennio De Concini | 1 | Adolf Hitler | Military | Known | White | 0 | Male | Alec Guinness |
265 | 265 | Hunger | http://www.imdb.com/title/tt0986233/ | UK | 2008 | $154K | Steve McQueen | 1 | Bobby Sands | Activist | Known | White | 0 | Male | Michael Fassbender |
266 | 266 | Hyde Park on Hudson | http://www.imdb.com/title/tt1477855/ | UK | 2012 | $6.37M | Roger Michell | 2 | Franklin Delano Roosevelt | World leader | Known | White | 0 | Male | Bill Murray |
267 | 267 | Hyde Park on Hudson | http://www.imdb.com/title/tt1477855/ | UK | 2012 | $6.37M | Roger Michell | 2 | Margaret Suckley | Other | Unknown | 0 | Female | Laura Linney | |
277 | 277 | Impromptu | http://www.imdb.com/title/tt0102103/ | UK | 1991 | $4.08M | James Lapine | 2 | Fr̩d̩ric Fran̤ois Chopin | Musician | Known | White | 0 | Male | Hugh Grant |
278 | 278 | Impromptu | http://www.imdb.com/title/tt0102103/ | UK | 1991 | $4.08M | James Lapine | 2 | George Sand / Aurore | Other | Known | White | 0 | Female | Judy Davis |
290 | 290 | Isadora | http://www.imdb.com/title/tt0063141/ | UK | 1968 | - | Karel Reisz | 1 | Isadora Duncan | Artist | Unknown | 0 | Female | Vanessa Redgrave | |
296 | 296 | Jean Charles | http://www.imdb.com/title/tt0989007/ | UK | 2009 | - | Henrique Goldman | 1 | Jean Charles de Menezes | Other | Known | White | 0 | Male | Selton Mello |
305 | 305 | Jinnah | http://www.imdb.com/title/tt0183306/ | UK | 1998 | - | Jamil Dehlavi | 1 | Mohammad Ali Jinnah | Other | Known | Middle Eastern | 1 | Male | Christopher Lee |
321 | 321 | Klimt | http://www.imdb.com/title/tt0417871/ | UK | 2006 | - | Raoul Ruiz | 1 | Gustav Klimt | Artist | Known | White | 0 | Male | John Malkovich |
323 | 323 | Korczak | http://www.imdb.com/title/tt0099949/ | UK | 1990 | - | Andrzej Wajda | 1 | Janusz Korczak | Other | Known | White | 0 | Male | Wojciech Pszoniak |
327 | 327 | Lady Jane | http://www.imdb.com/title/tt0091374/ | UK | 1986 | $278K | Trevor Nunn | 1 | Lady Jane Grey | Historical | Unknown | 0 | Female | Helena Bonham Carter | |
330 | 330 | Lawrence of Arabia | http://www.imdb.com/title/tt0056172/ | UK | 1962 | $342K | David Lean | 1 | Thomas Edward Lawrence | Military | Known | White | 0 | Male | Peter O'Toole |
335 | 335 | Lisztomania | http://www.imdb.com/title/tt0073298/ | UK | 1975 | - | Ken Russell | 1 | Franz Liszt | Musician | Known | White | 0 | Male | Roger Daltrey |
336 | 336 | Little Ashes | http://www.imdb.com/title/tt1104083/ | UK | 2008 | $480K | Paul Morrison | 1 | Salvador DalÌ_ | Artist | Known | Multi racial | 1 | Male | Robert Pattinson |
356 | 356 | Mahler | http://www.imdb.com/title/tt0071797/ | UK | 1974 | - | Ken Russell | 2 | Gustav Mahler | Musician | Known | White | 0 | Male | Robert Powell |
357 | 357 | Mahler | http://www.imdb.com/title/tt0071797/ | UK | 1974 | - | Ken Russell | 2 | Alma Mahler | Other | Unknown | 0 | Female | Georgina Hale | |
361 | 361 | Mandela: Long Walk to Freedom | http://www.imdb.com/title/tt2304771/ | UK | 2013 | $8.32M | Justin Chadwick | 1 | Nelson Mandela | World leader | Known | African | 1 | Male | Idris Elba |
365 | 365 | Mary, Queen of Scots | http://www.imdb.com/title/tt0067402/ | UK | 1971 | - | Charles Jarrott | 1 | Mary Stuart, Queen of Scots | Historical | Known | White | 0 | Female | Vanessa Redgrave |
367 | 367 | Meetings with Remarkable Men | http://www.imdb.com/title/tt0079542/ | UK | 1979 | - | Peter Brook | 1 | G.I. Gurdjieff | Other | Known | White | 0 | Male | Dragan Maksimovic |
381 | 381 | Modigliani | http://www.imdb.com/title/tt0367188/ | UK | 2004 | $195K | Mick Davis | 1 | Amedeo Modigliani | Artist | Known | White | 0 | Male | Andy Garcia |
384 | 384 | Monsieur N. | http://www.imdb.com/title/tt0308595/ | UK | 2003 | $16.8K | Antoine de Caunes | 1 | Napoleon Bonaparte | Historical | Known | White | 0 | Male | Philippe Torreton |
386 | 386 | Moulin Rouge | http://www.imdb.com/title/tt0044926/ | UK | 1952 | - | John Huston | 1 | Henri de Toulouse-Lautrec | Artist | Unknown | 0 | Male | Jos̩ Ferrer | |
387 | 387 | Mr. Nice | http://www.imdb.com/title/tt1183911/ | UK | 2010 | - | Bernard Rose | 1 | Howard Marks | Criminal | Unknown | 0 | Male | Rhys Ifans |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "biopics/biopics" ( "title" TEXT, "site" TEXT, "country" TEXT, "year_release" INTEGER, "box_office" TEXT, "director" TEXT, "number_of_subjects" INTEGER, "subject" TEXT, "type_of_subject" TEXT, "race_known" TEXT, "subject_race" TEXT, "person_of_color" INTEGER, "subject_sex" TEXT, "lead_actor_actress" TEXT );