Film_Locations_in_San_Francisco

Data source: data.sfgov.org

24 rows where Production Company = 145

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1286 Terminator - Genisys 239 2015 10 16th and Utah Helicopter flies over Utah St. from 16th, rises up before freeway T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1287 Terminator - Genisys 239 2015 10 Van Ness between Fell and Lombard   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1288 Terminator - Genisys 239 2015 10 California between Leavenworth and Powell   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1289 Terminator - Genisys 239 2015 10 Mission at 1st and 2nd   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1290 Terminator - Genisys 239 2015 10 Market at Mason   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1291 Terminator - Genisys 239 2015 10 California at Larkin   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1292 Terminator - Genisys 239 2015 10 California at Jones   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1293 Terminator - Genisys 239 2015 10 Pine and Leavenworth   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1294 Terminator - Genisys 239 2015 10 Howard St. from Embarcadero to 11 St.   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1295 Terminator - Genisys 239 2015 10 Construction Site in front of 260 Stockton St. at Post St.   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1296 Terminator - Genisys 239 2015 10 California St. between Drumm St. and Kearny St.   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1297 Terminator - Genisys 239 2015 10 Market St. at Embarcadero area   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1298 Terminator - Genisys 239 2015 10 Pine St. between Market and Kearny   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1299 Terminator - Genisys 239 2015 10 Front St. between Market and Clay   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1300 Terminator - Genisys 239 2015 10 Union Square   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1301 Terminator - Genisys 239 2015 10 San Francisco - Oakland Bay Bridge   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1302 Terminator - Genisys 239 2015 10 Mission St., Embarcadero, and Front between Clay and Market   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1303 Terminator - Genisys 239 2015 10 Sutter Stockton Garage   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1304 Terminator - Genisys 239 2015 10 Bush St. at Stockton St.   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1305 Terminator - Genisys 239 2015 10 Powell St at Geary St   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1306 Terminator - Genisys 239 2015 10 1 Market St. Landmark Building   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1307 Terminator - Genisys 239 2015 10 Embarcadero between Pier 2 and Harrison   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1308 Terminator - Genisys 239 2015 10 Pier 14   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  
1309 Terminator - Genisys 239 2015 10 Pine St. between Market and Montgomery   T5 Productions LLC 145 Paramount Pictures 3 Alan Taylor 196 James Cameron 208 Arnold Schwarzenegger 334 Jason Clarke 183  

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