Biopics: biopics.csv

Table actions

This table contains the data behind the story 'Straight Outta Compton' Is The Rare Biopic Not About White Dudes.

biopics.csv contains the following variables:

Variable Definition
title Title of the film.
site URL from IMDB.
country Country of origin.
year_released Year of release.
box_office Gross earnings at U.S. box office.
director Director of film.
number_of_subjects The number of subjects featured in the film.
subject The actual name of the featured subject.
type_of_subject The occupation of subject or reason for recognition.
race_known Indicates whether the subject’s race was discernible based on background of self, parent, or grandparent.
subject_race Race of the subject.
person_of_color Dummy variable that indicates person of color.
subject_sex Sex of subject.
lead_actor_actress The actor or actress who played the subject.

Source: IMDb.

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

21 rows where number_of_subjects = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: title, site, country, year_release, box_office, director, type_of_subject, race_known, subject_race, person_of_color, subject_sex, lead_actor_actress

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
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
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
104 104 Cadillac Records http://www.imdb.com/title/tt1042877/ US 2008 $8.13M Darnell Martin 3 Muddy Water Musician Known African American 1 Male Jeffrey Wright
105 105 Cadillac Records http://www.imdb.com/title/tt1042877/ US 2008 $8.13M Darnell Martin 3 Leonard Chess Musician Known White 0 Male Adrien Brody
165 165 Devil's Knot http://www.imdb.com/title/tt0804463/ US 2013 - Atom Egoyan 3 Damien Echols Criminal Unknown   0 Male James Hamrick
166 166 Devil's Knot http://www.imdb.com/title/tt0804463/ US 2013 - Atom Egoyan 3 Jason Baldwin Criminal Unknown   0 Male Seth Meriwether
167 167 Devil's Knot http://www.imdb.com/title/tt0804463/ US 2013 - Atom Egoyan 3 Jessie Misskelley, Jr. Criminal Unknown   0 Male Kristopher Higgins
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
191 191 Escape from Alcatraz http://www.imdb.com/title/tt0079116/ US 1979 $36.5M Don Siegel 3 Clarence Anglin Criminal Unknown   0 Male Jack Thibeau
192 192 Escape from Alcatraz http://www.imdb.com/title/tt0079116/ US 1979 $36.5M Don Siegel 3 Frank Morris Criminal Unknown   0 Male Clint Eastwood
193 193 Escape from Alcatraz http://www.imdb.com/title/tt0079116/ US 1979 $36.5M Don Siegel 3 John Anglin Criminal Unknown   0 Male Fred Ward
248 248 Henry & June http://www.imdb.com/title/tt0099762/ US 1990 $11.6M Philip Kaufman 3 Henry Miller Author Known White 0 Male Fred Ward
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
338 338 Lords of Dogtown http://www.imdb.com/title/tt0355702/ US 2005 $11M Catherine Hardwicke 3 Jay Adams Athlete Unknown   0 Male Emile Hirsch
339 339 Lords of Dogtown http://www.imdb.com/title/tt0355702/ US 2005 $11M Catherine Hardwicke 3 Tony Alva Athlete Known Hispanic (Latino) 1 Male Victor Rasuk
340 340 Lords of Dogtown http://www.imdb.com/title/tt0355702/ US 2005 $11M Catherine Hardwicke 3 Stacy Peralta Athlete Unknown   0 Male John Robinson

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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