Film_Locations_in_San_Francisco

Data source: data.sfgov.org

10 rows where Release Year = 1

View and edit SQL

Suggested facets: Title, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1 180 1 2011 1 Epic Roasthouse (399 Embarcadero)   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
2 180 1 2011 1 Mason & California Streets (Nob Hill)   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
3 180 1 2011 1 Justin Herman Plaza   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
4 180 1 2011 1 200 block Market Street   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
5 180 1 2011 1 City Hall   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
6 180 1 2011 1 Polk & Larkin Streets   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
7 180 1 2011 1 Randall Museum   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
8 180 1 2011 1 555 Market St.   SPI Cinemas 1   Jayendra 1 Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba  1 Siddarth 237 Nithya Menon 1 Priya Anand 439
641 Hemingway & Gelhorn 119 2011 1 Muni Metro East (501 Cesar Chavez)   Attaboy Films, For Whom Productions, Home Box Office (HBO) 81 Home Box Office (HBO) 57 Philip Kaufman 111 Jerry Stahl & Barbara Turner 110 Nicole Kidman 320 Clive Owen 95  
701 I's 135 2011 1 1 Post Street   Banshee Cinema 90   Chris Edgette 125 Kyle Tuck 125      

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 34.151ms · Data source: data.sfgov.org