films

Table actions

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: genre (array)

id ▼ slug title director original_title year country runtime genre poster_url production collection language classification sub_classification
1 pandoras-box Pandora's Box G.W. Pabst Die Büchse der Pandora 1929 Germany 110 ["Drama", "Romance", "Crime"] https://krisyotam.com/cdn/images/film/1929-pandoras-box-gw-pabst.webp Nero-Film AG Criterion Collection Silent P PN1995
2 jeanne-dielman Jeanne Dielman, 23, quai du Commerce, 1080 Bruxelles Chantal Akerman   1975 Belgium 201 ["Drama"] https://krisyotam.com/cdn/images/film/1975-jeanne-dielman-23-quai-du-commerce-1080-bruxelles-chantal-akerman.png Paradise Films Criterion Collection French P PN1995

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE films (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  slug TEXT UNIQUE NOT NULL,
  title TEXT NOT NULL,
  director TEXT,
  original_title TEXT,
  year INTEGER,
  country TEXT,
  runtime INTEGER,
  genre TEXT,
  poster_url TEXT,
  production TEXT,
  collection TEXT,
  language TEXT,
  classification TEXT,
  sub_classification TEXT
);
CREATE INDEX idx_films_slug ON films(slug);
CREATE INDEX idx_films_classification ON films(classification);