Film_Locations_in_San_Francisco

Data source: data.sfgov.org

289 rows where Release Year = 10 sorted by Actor 2

✎ View and edit SQL

This data as json, CSV (advanced)

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
1087 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1118 Sense8 208 2015 10 Folsom Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1119 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 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 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 1122 Sense8 208 2015 10 Harrison Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1123 1123 Sense8 208 2015 10 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1124 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 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 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 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 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 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 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 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 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 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 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 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 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    
26 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 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 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 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 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 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 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 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 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 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 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 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 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  
40 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
70 70 Americana 20 2015 10 679 Madrid St   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
71 71 Americana 20 2015 10 Roxie Theater (3117 16th St.)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
72 72 Americana 20 2015 10 Variety Preview Room (582 Market St.)   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
73 73 Americana 20 2015 10 Laguna Honda Hospital; 375 Laguna Honda Blvd.   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
74 74 Americana 20 2015 10 3232 Jackson Ave.   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
75 75 Americana 20 2015 10 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs   Sutro Films LLC 17   Zachary Shedd 19 Zachary Shedd 18 Kelli Garner 254 Jack Davenport 18 Peter Coyote 446
242 242 Cardinal X 46 2015 10 3639 Taraval St   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
243 243 Cardinal X 46 2015 10 1458 33rd Ave.   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
244 244 Cardinal X 46 2015 10 Lyon at Chestnut St.   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
245 245 Cardinal X 46 2015 10 1559 Underwood Avenue between Lane and Keith   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
246 246 Cardinal X 46 2015 10 1465 Revere Avenue between Keith and Jennings   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
247 247 Cardinal X 46 2015 10 1601 Lane St.   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
248 248 Cardinal X 46 2015 10 420 Mason St.   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
249 249 Cardinal X 46 2015 10 119 Utah   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
250 250 Cardinal X 46 2015 10 100 Alemany Blvd.   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
251 251 Cardinal X 46 2015 10 812 22nd St. and Tennessee   Fire Horse Film Productions LLC 41   Annie Wang 44 Annie Wang 43 Annie Q 277 Francesca Eastwood 39 Pierson Fode 461
666 666 I Am Michael 129 2015 10 Flint & 16th (Castro)   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
667 667 I Am Michael 129 2015 10 Grove & Polk, thru Fulton & 6th, Masonic, 28th & 47th   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
668 668 I Am Michael 129 2015 10 Ocean Beach @ Balboa   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
669 669 I Am Michael 129 2015 10 4100 20th St   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
670 670 I Am Michael 129 2015 10 Harvey Milk Plaza   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
671 671 I Am Michael 129 2015 10 F Train   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
672 672 I Am Michael 129 2015 10 Sanchez/Cumberland steps and sidewalks   That’s Hollywood 85   Justin Kelly 120 Justin Kelly 119 James Franco 327 Emma Roberts 105 Zachary Quinto 488
797 797 Looking Season 2 ep 202 150 2015 10 901 Valencia Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496

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