Biopics: biopics.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
761 rows sorted by subject_sex
This data as json, copyable, CSV (advanced)
Suggested facets: country, number_of_subjects, type_of_subject, race_known, subject_race, person_of_color, subject_sex
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 11 | 84 Charing Cross Road | http://www.imdb.com/title/tt0090570/ | US/UK | 1987 | $1.08M | David Hugh Jones | 2 | Helene Hanff | Author | Unknown | 0 | Female | Anne Bancroft | |
| 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 |
| 16 | 16 | A Home of Our Own | http://www.imdb.com/title/tt0107130/ | US | 1993 | $1.7M | Tony Bill | 1 | Frances Lacey | Other | Unknown | 0 | Female | Kathy Bates | |
| 19 | 19 | A Matador's Mistress | http://www.imdb.com/title/tt0491046/ | US/UK | 2008 | - | Menno Meyjes | 2 | Lupe Sino | Actress | Known | Hispanic (White) | 0 | Female | Pen̩lope Cruz |
| 22 | 22 | A Mighty Heart | http://www.imdb.com/title/tt0829459/ | US/UK | 2007 | $9.17M | Michael Winterbottom | 2 | Mariane Pearl | Journalist | Known | Multi racial | 1 | Female | Angelina Jolie |
| 27 | 27 | Against the Ropes | http://www.imdb.com/title/tt0312329/ | US | 2004 | $5.88M | Charles S. Dutton | 1 | Jackie Kallen | Athlete | Unknown | 0 | Female | Meg Ryan | |
| 36 | 36 | Amelia | http://www.imdb.com/title/tt1129445/ | US/Canada | 2009 | $14.2M | Mira Nair | 1 | Amelia Earhart | Other | Known | White | 0 | Female | Hilary Swank |
| 41 | 41 | An American Crime | http://www.imdb.com/title/tt0802948/ | US | 2007 | - | Tommy O'Haver | 2 | Gertrude Baniszewski | Criminal | Known | White | 0 | Female | Catherine Keener |
| 42 | 42 | An American Crime | http://www.imdb.com/title/tt0802948/ | US | 2007 | - | Tommy O'Haver | 2 | Sylvia Likens | Other | Unknown | 0 | Female | Ellen Page | |
| 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 |
| 44 | 44 | Anastasia | http://www.imdb.com/title/tt0048947/ | US | 1956 | - | Anatole Litvak | 1 | Anna Anderson / Anastasia | Other | Known | White | 0 | Female | Ingrid Bergman |
| 45 | 45 | Anna and the King of Siam | http://www.imdb.com/title/tt0038303/ | US | 1946 | - | John Cromwell | 1 | Anna Leonowens | Other | Known | Multi racial | 0 | Female | Irene Dunne |
| 46 | 46 | Annie Get Your Gun | http://www.imdb.com/title/tt0042200/ | US | 1950 | $8M | George Sidney | 1 | Annie Oakley | Athlete | Known | White | 0 | Female | Betty Hutton |
| 47 | 47 | Annie Oakley | http://www.imdb.com/title/tt0026073/ | US | 1935 | - | George Stevens | 1 | Annie Oakley | Athlete | Known | White | 0 | Female | Barbara Stanwyck |
| 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 |
| 68 | 68 | Bernard and Doris | http://www.imdb.com/title/tt0470732/ | US/UK | 2006 | - | Bob Balaban | 2 | Doris Duke | Other | Known | White | 0 | Female | Susan Sarandon |
| 72 | 72 | Big Eyes | http://www.imdb.com/title/tt1126590/ | US/Canada | 2014 | $14.5M | Tim Burton | 1 | Margaret Keane | Artist | Known | White | 0 | Female | Amy Adams |
| 78 | 78 | Blossoms in the Dust | http://www.imdb.com/title/tt0033407/ | US | 1941 | - | Mervyn LeRoy | 1 | Edna Gladney | Other | Unknown | 0 | Female | Greer Garson | |
| 84 | 84 | Bonnie and Clyde | http://www.imdb.com/title/tt0061418/ | US | 1967 | - | Arthur Penn | 2 | Bonnie Parker | Criminal | Unknown | 0 | Female | Faye Dunaway | |
| 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 | |
| 103 | 103 | Cadillac Records | http://www.imdb.com/title/tt1042877/ | US | 2008 | $8.13M | Darnell Martin | 3 | Etta James | Singer | Known | African American | 1 | Female | Beyonc̩ Knowles |
| 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 |
| 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 |
| 134 | 134 | Ciao Manhattan | http://www.imdb.com/title/tt0068379/ | US | 1972 | - | John Palmer, David Weisman | 1 | Edie Sedgwick | Actress | Known | White | 0 | Female | Edie Sedgwick |
| 136 | 136 | Cleopatra | http://www.imdb.com/title/tt0024991/ | US | 1934 | - | Cecil B. DeMille | 1 | Cleopatra | Historical | Known | Middle Eastern | 1 | Female | Claudette Colbert |
| 137 | 137 | Cleopatra | http://www.imdb.com/title/tt0056937/ | US/UK | 1963 | $57.8M | Joseph L. Mankiewicz | 1 | Cleopatra | Historical | Known | Middle Eastern | 1 | Female | Elizabeth Taylor |
| 138 | 138 | Coal Miner's Daughter | http://www.imdb.com/title/tt0080549/ | US | 1980 | $79.9M | Michael Apted | 1 | Loretta Lynn | Singer | Known | Multi racial | 1 | Female | Sissy Spacek |
| 145 | 145 | Conviction | http://www.imdb.com/title/tt1244754/ | US | 2010 | $6.78M | Tony Goldwyn | 1 | Betty Anne Waters | Other | Unknown | 0 | Female | Hilary Swank | |
| 150 | 150 | Cross Creek | http://www.imdb.com/title/tt0085380/ | US | 1983 | $200K | Martin Ritt | 1 | Marjorie Kinnan Rawlings | Author | Unknown | 0 | Female | Mary Steenburgen | |
| 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 | |
| 157 | 157 | Dangerous Beauty | http://www.imdb.com/title/tt0118892/ | US | 1998 | $4.53M | Marshall Herskovitz | 1 | Veronica Franco | Other | Known | White | 0 | Female | Catherine McCormack |
| 158 | 158 | Dangerous Minds | http://www.imdb.com/title/tt0112792/ | US | 1995 | $84.9M | John N. Smith | 1 | Louanne Johnson | Teacher | Known | White | 0 | Female | Michelle Pfeiffer |
| 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) |
| 163 | 163 | D̩sir̩e | http://www.imdb.com/title/tt0046903/ | US | 1954 | - | Henry Koster | 2 | D̩sir̩e Clary | Historical | Known | White | 0 | Female | Jean Simmons |
| 168 | 168 | Devotion | http://www.imdb.com/title/tt0038474/ | US | 1946 | - | Curtis Bernhardt | 3 | Charlotte Bronte | Author | Known | White | 0 | Female | Olivia de Havilland |
| 169 | 169 | Devotion | http://www.imdb.com/title/tt0038474/ | US | 1946 | - | Curtis Bernhardt | 3 | Emily Bronte | Author | Known | White | 0 | Female | Ida Lupino |
| 170 | 170 | Devotion | http://www.imdb.com/title/tt0038474/ | US | 1946 | - | Curtis Bernhardt | 3 | Anne Bronte | Author | Known | White | 0 | Female | Nancy Coleman |
| 171 | 171 | Diana | http://www.imdb.com/title/tt1758595/ | UK | 2013 | $332K | Oliver Hirschbiegel | 1 | Princess Diana | Other | Known | White | 0 | Female | Naomi Watts |
| 176 | 176 | Domino | http://www.imdb.com/title/tt0421054/ | US/UK | 2005 | $10.1M | Tony Scott | 1 | Domino Harvey | Other | Known | White | 0 | Female | Keira Knightley |
| 181 | 181 | Dreamchild | http://www.imdb.com/title/tt0089052/ | UK | 1985 | - | Gavin Millar | 1 | Alice Liddell Hargreaves | Other | Unknown | 0 | Female | Coral Browne | |
| 188 | 188 | Elizabeth | http://www.imdb.com/title/tt0127536/ | US/UK | 1998 | $30M | Shekhar Kapur | 1 | Elizabeth I of England | Historical | Known | White | 0 | Female | Cate Blanchett |
| 189 | 189 | Elizabeth: The Golden Age | http://www.imdb.com/title/tt0414055/ | US/UK | 2007 | $16.3M | Shekhar Kapur | 1 | Elizabeth I of England | Historical | Known | White | 0 | Female | Cate Blanchett |
| 190 | 190 | Erin Brockovich | http://www.imdb.com/title/tt0195685/ | US | 2000 | $126M | Steven Soderbergh | 1 | Erin Brockovich | Activist | Unknown | 0 | Female | Julia Roberts | |
| 196 | 196 | Evita | http://www.imdb.com/title/tt0116250/ | US | 1996 | $50M | Alan Parker | 1 | Eva "Evita" Duarte de Peron | Actress / activist | Known | Hispanic (Latin American) | 0 | Female | Madonna |
| 198 | 198 | Factory Girl | http://www.imdb.com/title/tt0432402/ | US | 2006 | $1.65M | George Hickenlooper | 1 | Edie Sedgwick | Actress | Known | White | 0 | Female | Sienna Miller |
| 199 | 199 | Fair Game | http://www.imdb.com/title/tt0977855/ | US | 2010 | $9.53M | Doug Liman | 1 | Valerie Plame | Government | Known | White | 0 | Female | Naomi Watts |
| 210 | 210 | Frances | http://www.imdb.com/title/tt0083967/ | US | 1982 | $5M | Graeme Clifford | 1 | Frances Farmer | Actress | Known | White | 0 | Female | Jessica Lange |
| 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 |
| 215 | 215 | Freedom Writers | http://www.imdb.com/title/tt0463998/ | US | 2007 | $36.6M | Richard LaGravenese | 1 | Erin Gruwell | Other | Known | White | 0 | Female | Hilary Swank |
| 217 | 217 | Frida | http://www.imdb.com/title/tt0120679/ | US/Canada | 2002 | $25.8M | Julie Taymor | 1 | Frida Kahlo | Artist | Known | Hispanic (Latin American) | 1 | Female | Salma Hayek |
| 219 | 219 | Funny Girl | http://www.imdb.com/title/tt0062994/ | US | 1968 | $223K | William Wyler | 1 | Fanny Brice | Actress | Known | White | 0 | Female | Barbra Streisand |
| 220 | 220 | Fur: An Imaginary Portrait of Diane Arbus | http://www.imdb.com/title/tt0422295/ | US | 2006 | $221K | Steven Shainberg | 1 | Diane Arbus | Other | Known | White | 0 | Female | Nicole Kidman |
| 227 | 227 | Girl, Interrupted | http://www.imdb.com/title/tt0172493/ | US | 1999 | $28.9M | James Mangold | 1 | Susanna Kaysen | Author | Unknown | 0 | Female | Winona Ryder | |
| 234 | 234 | Gorillas in the Mist | http://www.imdb.com/title/tt0095243/ | US | 1988 | $24.7M | Michael Apted | 1 | Dian Fossey | Academic | Unknown | 0 | Female | Sigourney Weaver | |
| 237 | 237 | Gracie | http://www.imdb.com/title/tt0441007/ | US | 2007 | $2.96M | Davis Guggenheim | 1 | Elisabeth Shue | Athlete | Known | White | 0 | Female | Carly Schroeder |
| 241 | 241 | Gypsy | http://www.imdb.com/title/tt0056048/ | US | 1962 | - | Mervyn LeRoy | 2 | Gypsy Rose Lee | Artist | Known | White | 0 | Female | Natalie Wood |
| 242 | 242 | Gypsy | http://www.imdb.com/title/tt0056048/ | US | 1962 | - | Mervyn LeRoy | 2 | Rose Thompson Hovick | Other | Known | White | 0 | Female | Rosalind Russell |
| 244 | 244 | Harlow | http://www.imdb.com/title/tt0059252/ | US | 1965 | - | Gordon Douglas | 1 | Jean Harlow | Actress | Known | White | 0 | Female | Carroll Baker |
| 245 | 245 | Heart Like a Wheel | http://www.imdb.com/title/tt0085656/ | US | 1983 | - | Jonathan Kaplan | 1 | Shirley Muldowney | Athlete | Known | White | 0 | Female | Bonnie Bedelia |
| 246 | 246 | Heaven & Earth | http://www.imdb.com/title/tt0107096/ | US | 1993 | $5.86M | Oliver Stone | 1 | Le Ly Hayslip | Other | Known | Asian American | 1 | Female | Hiep Thi Le |
| 249 | 249 | Henry & June | http://www.imdb.com/title/tt0099762/ | US | 1990 | $11.6M | Philip Kaufman | 3 | AnaÌøs Nin | Author | Known | White | 0 | Female | Maria de Medeiros |
| 250 | 250 | Henry & June | http://www.imdb.com/title/tt0099762/ | US | 1990 | $11.6M | Philip Kaufman | 3 | June Miller | Other | Known | White | 0 | Female | Uma Thurman |
| 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 |
| 258 | 258 | Hitchcock | http://www.imdb.com/title/tt0975645/ | US/UK | 2012 | $6M | Sacha Gervasi | 2 | Alma Reville | Other | Known | White | 0 | Female | Helen Mirren |
| 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 | |
| 270 | 270 | I Shot Andy Warhol | http://www.imdb.com/title/tt0116594/ | US/UK | 1996 | $1.81M | Mary Harron | 1 | Valerie Solanas | Activist | Known | Hispanic (White) | 0 | Female | Lil Taylor |
| 271 | 271 | I Want to Live! | http://www.imdb.com/title/tt0051758/ | US | 1958 | - | Robert Wise | 1 | Barbara Graham | Criminal | Unknown | 0 | Female | Susan Hayward | |
| 272 | 272 | I'll Cry Tomorrow | http://www.imdb.com/title/tt0048191/ | US | 1955 | - | Daniel Mann | 1 | Lillian Roth | Actress | Known | White | 0 | Female | Susan Hayward |
| 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 |
| 280 | 280 | In Love and War | http://www.imdb.com/title/tt0116621/ | US | 1996 | $14.5M | Richard Attenborough | 2 | Agnes von Kurowsky | Other | Known | White | 0 | Female | Sandra Bullock |
| 284 | 284 | Interrupted Melody | http://www.imdb.com/title/tt0048210/ | US | 1955 | - | Curtis Bernhardt | 1 | Marjorie Lawrence | Singer | Known | White | 0 | Female | Eleanor Parker |
| 289 | 289 | Iris | http://www.imdb.com/title/tt0280778/ | US/UK | 2001 | $1.2M | Richard Eyre | 1 | Iris Murdoch | Author | Known | White | 0 | Female | Judi Dench and Kate Winslet |
| 290 | 290 | Isadora | http://www.imdb.com/title/tt0063141/ | UK | 1968 | - | Karel Reisz | 1 | Isadora Duncan | Artist | Unknown | 0 | Female | Vanessa Redgrave | |
| 291 | 291 | Isn't She Great | http://www.imdb.com/title/tt0141399/ | US/UK | 2000 | $2.95M | Andrew Bergman | 1 | Jacqueline Susann | Author | Known | White | 0 | Female | Bette Midler |
| 307 | 307 | Joan of Arc | http://www.imdb.com/title/tt0040491/ | US | 1948 | - | Victor Fleming | 1 | Joan of Arc | Historical | Known | White | 0 | Female | Ingrid Bergman |
| 311 | 311 | Julie & Julia | http://www.imdb.com/title/tt1135503/ | US | 2009 | $94.1M | Nora Ephron | 2 | Julia Child | Other | Unknown | 0 | Female | Meryl Streep | |
| 312 | 312 | Julie & Julia | http://www.imdb.com/title/tt1135503/ | US | 2009 | $94.1M | Nora Ephron | 2 | Julia Powell | Other | Unknown | 0 | Female | Amy Adams | |
| 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 |
| 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 | |
| 328 | 328 | Lady Sings the Blues | http://www.imdb.com/title/tt0068828/ | US | 1972 | $9.6M | Sidney J. Furie | 1 | Billie Holiday | Musician | Known | African American | 1 | Female | Diana Ross |
| 343 | 343 | Love Is a Many-Splendored Thing | http://www.imdb.com/title/tt0048316/ | US | 1955 | - | Henry King | 1 | Han Suyin | Other | Known | Eurasian | 1 | Female | Jennifer Jones |
| 345 | 345 | Love Me or Leave Me | http://www.imdb.com/title/tt0048317/ | US | 1955 | - | Charles Vidor | 1 | Ruth Etting | Singer | Unknown | 0 | Female | Doris Day | |
| 346 | 346 | Lovelace | http://www.imdb.com/title/tt1426329/ | US | 2013 | $355K | Rob Epstein, Jeffrey Friedman | 1 | Linda Lovelace | Actress | Known | White | 0 | Female | Amanda Seyfried |
| 355 | 355 | Madame Curie | http://www.imdb.com/title/tt0036126/ | US | 1943 | - | Mervyn LeRoy | 2 | Marie Curie | Academic | Known | White | 0 | Female | Greer Garson |
| 357 | 357 | Mahler | http://www.imdb.com/title/tt0071797/ | UK | 1974 | - | Ken Russell | 2 | Alma Mahler | Other | Unknown | 0 | Female | Georgina Hale | |
| 362 | 362 | Marie Antoinette | http://www.imdb.com/title/tt0030418/ | US | 1938 | - | W.S. Van Dyke | 1 | Marie Antoinette | Historical | Known | White | 0 | Female | Norma Shearer |
| 363 | 363 | Marie Antoinette | http://www.imdb.com/title/tt0422720/ | US | 2006 | $16M | Sofia Coppola | 1 | Marie Antoinette | Historical | Known | White | 0 | Female | Kirsten Dunst |
| 364 | 364 | Mary of Scotland | http://www.imdb.com/title/tt0027948/ | US | 1936 | - | John Ford | 1 | Mary Stuart, Queen of Scots | Historical | Known | White | 0 | Female | Katharine Hepburn |
| 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 |
| 376 | 376 | Million Dollar Mermaid | http://www.imdb.com/title/tt0044903/ | US | 1952 | - | Mervyn LeRoy | 1 | Annette Kellerman | Athlete | Known | White | 0 | Female | Esther Williams |
| 379 | 379 | Miss Potter | http://www.imdb.com/title/tt0482546/ | US/UK | 2006 | $2.98M | Chris Noonan | 1 | Beatrix Potter | Author | Known | White | 0 | Female | Ren̩e Zellweger |
| 380 | 380 | Mockingbird Don't Sing | http://www.imdb.com/title/tt0273822/ | US | 2001 | - | Harry Bromley Davenport | 1 | Genie (pseudonym) | Other | Unknown | 0 | Female | Tarra Steele | |
| 382 | 382 | Mommie Dearest | http://www.imdb.com/title/tt0082766/ | US | 1981 | - | Frank Perry | 1 | Joan Crawford | Actress | Known | White | 0 | Female | Faye Dunaway |
| 385 | 385 | Monster | http://www.imdb.com/title/tt0340855/ | US | 2003 | $34.5M | Patty Jenkins | 1 | Aileen Wuornos | Criminal | Unknown | 0 | Female | Charlize Theron | |
| 389 | 389 | Mrs Brown | http://www.imdb.com/title/tt0119280/ | US/UK | 1997 | $9.22M | John Madden | 1 | Victoria | Historical | Known | White | 0 | Female | Judi Dench |
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 );