Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Fun Facts = "Driving shots" and Writer = 180

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1117 Sense8 208 2015 10 Harrison & 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1118 Sense8 208 2015 10 Folsom Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1119 Sense8 208 2015 10 16th St. Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1120 Sense8 208 2015 10 S. Van Ness Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1121 Sense8 208 2015 10 22nd St. Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1122 Sense8 208 2015 10 Harrison Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1123 Sense8 208 2015 10 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    

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 26.959ms · Data source: data.sfgov.org