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

13 rows where country = "Canada/UK"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: title, site, year_release, box_office, director, 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
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

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