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

9 rows where subject_race = "African"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: country, year_release, box_office, director, number_of_subjects, subject, type_of_subject, 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
122 122 Catch a Fire http://www.imdb.com/title/tt0437232/ US/UK 2006 $4.29M Phillip Noyce 1 Patrick Chamusso Activist Known African 1 Male Derek Luke
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
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)
286 286 Invictus http://www.imdb.com/title/tt1057500/ US 2009 $37.5M Clint Eastwood 2 Nelson Mandela World leader Known African 1 Male Morgan Freeman
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
494 494 Skin http://www.imdb.com/title/tt0964586/ UK 2008 - Anthony Fabian 1 Sandra Laing Other Known African 1 Female Sophie Okonedo
572 572 The First Grader http://www.imdb.com/title/tt0790663/ US 2010 $331K Justin Chadwick 1 Kimani Ng‰Ûªang‰Ûªa Maruge Other Known African 1 Male Oliver Litondo
611 611 The Last King of Scotland http://www.imdb.com/title/tt0455590/ UK 2006 $17.6M Kevin Macdonald 1 Idi Amin Other Known African 1 Male Forest Whitaker
746 746 Winnie Mandela http://www.imdb.com/title/tt1551641/ Canada 2011 - Darrell Roodt 1 Winnie Mandela Government Known African 1 Female Jennifer Hudson

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