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

6 rows where subject_race = "Hispanic (White)"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: title, site, country, year_release, box_office, director, number_of_subjects, 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
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
20 20 A Matador's Mistress http://www.imdb.com/title/tt0491046/ US/UK 2008 - Menno Meyjes 2 Manuel RodrÌ_guez SÌÁnchez Athlete Known Hispanic (White) 0 Male Adrien Brody
160 160 Death in Granada http://www.imdb.com/title/tt0117106/ US 1996 $226K Marcos Zurinaga 1 Garcia Lorca Author Known Hispanic (White) 0 Male Andy Garcia
187 187 El Cid http://www.imdb.com/title/tt0054847/ US 1961 $26.6M Anthony Mann 1 Rodrigo Diaz Historical Known Hispanic (White) 0 Male Charlton Heston
235 235 Goya's Ghosts http://www.imdb.com/title/tt0455957/ US 2006 $1M Milos Forman 1 Francisco Goya Artist Known Hispanic (White) 0 Male Stellan SkarsgÌ´rd
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

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