Film_Locations_in_San_Francisco

Data source: data.sfgov.org

289 rows where Release Year = 10 sorted by Actor 3

View and edit SQL

Suggested facets: Title, Production Company, Distributor, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3 ▼
26 Ant-Man 11 2015 10 420 Jones St. at Ellis St.   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
51 Ant-Man 11 2015 10 Broadway between Powell and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
77 Ant-Man 11 2015 10 Conzelman Rd at McCollough Rd and down Conzelman Rd. Aerial shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
78 Ant-Man 11 2015 10 Lombard at Hyde   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
79 Ant-Man 11 2015 10 601 Buena Vista Ave West at Java St.   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
80 Ant-Man 11 2015 10 Columbus between Bay and Washington Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
81 Ant-Man 11 2015 10 California between Kearney and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
82 Ant-Man 11 2015 10 Pine between Kearney and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
83 Ant-Man 11 2015 10 Market between Stuart and Van Ness Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
84 Ant-Man 11 2015 10 Grant between Bush and Broadway Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
85 Ant-Man 11 2015 10 Intersection of Broadway at Kearney Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
86 Ant-Man 11 2015 10 Intersection of California at Polk Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
87 Ant-Man 11 2015 10 Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
1087 San Andreas 205 2015 10 2nd St. at Townsend St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1088 San Andreas 205 2015 10 Jefferson St. at Powell St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1089 San Andreas 205 2015 10 Grant St. at Bush St. Characters walk down street and it's totally wrecked from a massive earthquake Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1090 San Andreas 205 2015 10 Vallejo Garage Roof (Vallejo at Powell)   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1091 San Andreas 205 2015 10 Clay St. at Taylor 3 characters walk down the street. An earthquake shakes the city and stuff starts breaking. One character gets a shard of glass stuck in his leg. Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1092 San Andreas 205 2015 10 Bay St. at Polk   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1093 San Andreas 205 2015 10 Intersection of Lombard and Hyde   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1094 San Andreas 205 2015 10 Mission between 3rd and 4th St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1095 San Andreas 205 2015 10 555 California Characters walk out of broken window of 555 California out to Kearny St. Splinter unit films a car driving into the garage at 555 California Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1096 San Andreas 205 2015 10 Broadway and Kearney   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1097 San Andreas 205 2015 10 Grant between Bush and Market   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1098 San Andreas 205 2015 10 Coit Tower   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1099 San Andreas 205 2015 10 TransAmerica Pyramid (600 Montgomery Street)   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1100 San Andreas 205 2015 10 Washington Square   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1101 San Andreas 205 2015 10 Battery Spencer   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1102 San Andreas 205 2015 10 Pier 43 Bystanders watch as a tsunami crashes over them Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1103 San Andreas 205 2015 10 Vallejo St. Garage, 766 Vallejo St. Characters watch from roof of garage as tsunami hits SF waterfront Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1104 San Andreas 205 2015 10 Fort Baker   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1105 San Andreas 205 2015 10 AT&T Stadium 3 characters run out of stadium, there is a group of people on the sidewalk, an earthquake hits, and they duck for cover Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1106 San Andreas 205 2015 10 AT&T Stadium two paragliders land on the field of AT&T Park Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1107 San Andreas 205 2015 10 Water work in SF Bay Characters drive in a high speed picture boat to see different views of the city. Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1108 San Andreas 205 2015 10 Stage Work, 47 Julian St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1109 San Andreas 205 2015 10 Hyde St. at Greenwich and Hyde St. at Lombard Characters walk to get a vantage point for Coit tower. 250 actors walking "fleeing" the city after earthquake Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1110 San Andreas 205 2015 10 Asia Star Fantasy, 1126 Grant Ave. Characters look for a form of communication with LA in a post-quake trashed city Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1114 Sense8 208 2015 10 18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March" Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1115 Sense8 208 2015 10 Atlas Café, 3049 20th St. Dialogue scene inside the café Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1116 Sense8 208 2015 10 Clarion Alley between Valencia & Mission St. Ladies discuss their relationship in the mural alley Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
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    
1124 Sense8 208 2015 10 Z Space Studios; 450 Florida St. Filming of the "Fresh Meat" Festival Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1125 Sense8 208 2015 10 375 Castro St. and 17th between Castro and Diamond St. Chase sequence on bicycles ends at gas station Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1126 Sense8 208 2015 10 Corbett St. Bicycle chase scene, actors dressed as fake officers present Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1127 Sense8 208 2015 10 Romain St. Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1128 Sense8 208 2015 10 Market St. overpass Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1129 Sense8 208 2015 10 Grand View Ave. Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1130 Sense8 208 2015 10 Vallejo Street Garage; 766 Vallejo St. dialogue scene on top of a garage roof Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1131 Sense8 208 2015 10 Laguna Honda Hospital; 375 Laguna Honda Blvd. dialogue scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1132 Sense8 208 2015 10 Irving St. at 9th Ave. continuous driving shots of a taxi going with the flow of existing traffic Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1134 Sense8 208 2015 10 Dolores Park, 20th St. between Church & Dolores St. group of friends have a heated argument, then flashback of pre-argument Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1135 Sense8 208 2015 10 Palace of Fine Arts: 3306 Lyon St. Filming of "Dyke's on Bikes" and "Dyke March" Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1136 Sense8 208 2015 10 Van Ness and 12th St. A couple reminisces on the moment they first fell in love Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1137 Sense8 208 2015 10 "Metzger's Apt" 151 Alice B. Toklas Pl. Overnight scene involving aggressive arguments between actors, spfx shoot out involved Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
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  
40 Age of Adaline 14 2015 10 Pier 50- end of the pier   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
41 Age of Adaline 14 2015 10 California @ Montgomery   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
42 Age of Adaline 14 2015 10 Montgomery/Green   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
43 Age of Adaline 14 2015 10 Driving various SF Streets   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
44 Age of Adaline 14 2015 10 Plate Shots SF streets various   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
59 Americana 20 2015 10 St. Francis Episcopal Church (399 San Fernando Way)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
60 Americana 20 2015 10 Romolo Place @ Fresno St.   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
61 Americana 20 2015 10 Palace of Fine Arts   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
62 Americana 20 2015 10 John Shelley Drive John McLaren Park   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
63 Americana 20 2015 10 Treasure Island   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
64 Americana 20 2015 10 The San Francisco School (300 Gavin St.)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
65 Americana 20 2015 10 33 Spruce St   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
66 Americana 20 2015 10 Coi Restaurant (373 Broadway)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
67 Americana 20 2015 10 Foreign Cinema (2534 Mission)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
68 Americana 20 2015 10 Bernal Heights Park   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
69 Americana 20 2015 10 Jackson St. at Spruce   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446

Next page

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