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

2 rows where country = "US/UK/Canada"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
528 528 The Assassination of Jesse James by the Coward Robert Ford http://www.imdb.com/title/tt0443680/ US/UK/Canada 2007 $3.9M Andrew Dominik 2 Jesse James Criminal Known White 0 Male Brad Pitt
529 529 The Assassination of Jesse James by the Coward Robert Ford http://www.imdb.com/title/tt0443680/ US/UK/Canada 2007 $3.9M Andrew Dominik 2 Robert Ford Criminal Unknown   0 Male Casey Affleck

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