Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Fun Facts

View and edit SQL

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
9 24 Hours on Craigslist 2 2005 2     Yerba Buena Productions 2 Zealot Pictures 1 Michael Ferris Gibson 2   Craig Newmark 238    
12 48 Hours 4 1982 4     Paramount Pictures 4 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Nick Nolte 19 Eddie Murphy 3 Annette O'Toole 440
13 50 First Dates 5 2004 5 Rainforest Café (145 Jefferson Street)   Columbia Pictures Corporation 5 Columbia Pictures 4 Peter Segal 5 George Wing 4 Adam Sandler 240 Drew Barrymore 4  
14 A Jitney Elopement 6 1915 6 20th and Folsom Streets   The Essanay Film Manufacturing Company 6 General Film Company 5 Charles Chaplin 6 Charles Chaplin 5 Charles Chaplin 241 Edna Purviance 5  
19 A Night Full of Rain 7 1978 7 Broadway (North Beach)   Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
20 A Smile Like Yours 8 1997 8 75 California Street   Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
22 A Smile Like Yours  9 1997 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
25 A View to a Kill 10 1985 9 Port of San Francisco   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
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  
33 A View to a Kill 10 1985 9 Burger Island (901 3rd Street, China Basin)   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
34 A View to a Kill 10 1985 9 Van Ness Avenue   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
35 A View to a Kill 10 1985 9 Taylor and Jefferson Streets (Fisherman's Wharf)   Metro-Goldwyn Mayer 8 MGM/UA Entertainment Company 7 John Glen 9 Richard Maibaum 8 Roger Moore 244 Christopher Walken 8 Tanya Roberts 441
36 About a Boy 12 2014 11 Broderick from Fulton to McAlister   NBC Studios 10 National Broadcasting Company 9 Mark J. Kunerth 11 Jason Katims 10 David Walton 246 Minnie Driver 10  
37 About a Boy 12 2014 11 Crissy Field   NBC Studios 10 National Broadcasting Company 9 Mark J. Kunerth 11 Jason Katims 10 David Walton 246 Minnie Driver 10  
38 About a Boy 12 2014 11 Powell from Bush and Sutter   NBC Studios 10 National Broadcasting Company 9 Mark J. Kunerth 11 Jason Katims 10 David Walton 246 Minnie Driver 10  
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
45 Alcatraz 15 2012 13 Filbert St. from Jones to Mason   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
46 Alcatraz 15 2012 13 Leavenworth from Filbert & Francisco St   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
47 Alcatraz 15 2012 13 Chestnut St. from Larkin to Columbus   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
48 Alcatraz 15 2012 13 Francisco St from Larkin to Polk   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
49 Alcatraz 15 2012 13 Broadway from Mason to Taylor   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
50 Alcatraz 15 2012 13 Taylor St. from Broadway to Filbert   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
53 Alexander's Ragtime Band 16 1938 14 San Francisco Bay   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Henry King 15 Kathryn Scola 14 Tyrone Power 250 Alice Faye 14 Don Ameche 443
57 American Graffiti 18 1973 16 3355 Geary Blvd.   Universal Pictures 15 Universal Pictures' 14 George Lucas 17 George Lucas 16 Richard Dreyfuss 252 Ron Howard 16 Paul Le Mat 445
58 American Yearbook 19 2004 5     All Planet Studios 16   Brian Ging 18 Brian Ging 17 Nick Tagas 253 Jon Carlo Alvarez 17  
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
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 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 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 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 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 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
76 Another 48 Hours 21 1990 17     Eddie Murphy Productions 18 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Eddie Murphy 3 Nick Nolte 19  
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  
90 Babies 24 2010 19     Canal+ 21 Focus Features 17 Thomas Balmes 22 Thomas Balmes 21 Bayar 257 Hattie 20  
91 Ballers Season 3 25 2017 20 Fairmont Hotel (950 Mason Street, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
92 Ballers Season 3 25 2017 20 Embarcadero around Rincon Park   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
93 Ballers Season 3 25 2017 20 San Remo Hotel (2237 Mason)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
94 Ballers Season 3 25 2017 20 Huntington Park (California & Taylor Streets, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
95 Ballers Season 3 25 2017 20 Driving around Taylor/Pacific/Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
96 Ballers Season 3 25 2017 20 California and Jones St.   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
97 Ballers Season 3 25 2017 20 Another Café, 1191 Pine St at Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
98 Barbary Coast 26 1935 21     The Samuel Goldwyn Company 23 United Artists 19 Howard Hawks 24 Ben Hecht 23 Mariam Hopkins 259 Edward G. Robinson 22 Joel McCrea 448
99 Basic Instinct 27 1992 22 Yerba Buena Center for the Arts   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
101 Basic Instinct 27 1992 22 Tosca Café (242 Columbus Avenue)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
103 Basic Instinct 27 1992 22 Raw Hide II (280 Seventh Street)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
104 Basic Instinct 27 1992 22 Pier 7 (The Embarcadero)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
105 Basic Instinct 27 1992 22 Kearney Street (Telegraph Hill)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
106 Big Eyes 28 2014 11 Nobles Alley   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
107 Basic Instinct 27 1992 22 Hall of Justice (850 Bryant Street)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
108 Basic Instinct 27 1992 22 2930 Vallejo Street   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
110 Basic Instinct 27 1992 22 Gibb Street (Chinatown)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
111 Basic Instinct 27 1992 22 1158-70 Montgomery Street   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
112 Basic Instinct 27 1992 22 2104 Broadway   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
113 Beaches 29 1988 23     Silver Screen Partners IV 26 Columbia Broadcasting System 22 Garry Marshall 27 Mary Agnes Donoghue 26 Bette Midler 261 Barbara Hershey 25 John Heard 451
114 Beautiful Boy 30 2018 24 Divisadero between Broadway and Greenwich   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
115 Beautiful Boy 30 2018 24 Ohloff Recovery Center (601 Steiner St)   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
116 Beautiful Boy 30 2018 24 Haight at Masonic   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
117 Beautiful Boy 30 2018 24 Tenderloin Neighborhood   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
118 Beautiful Boy 30 2018 24 Olympic Flame Café, 555 Geary St   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
119 Beautiful Boy 30 2018 24 18th St at San Bruno Ave.   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
120 Beautiful Boy 30 2018 24 Wisconsin between 19th and 20th St   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
121 Bedazzled 31 2000 25 1155 Filbert Street at Hyde   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
122 Bedazzled 31 2000 25 Washington Square Park (Filbert, between Stockton and Powell)   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
124 Bedazzled 31 2000 25 Montgomery & Market Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
126 Bee Season 32 2005 2     Bee Season Productions 28 Fox Searchlight Pictures 24 Scott McGehee 30 David Siegel 29 Richard Gere 264 Juliette Binoche 28  
132 Big Eyes 28 2014 11 Caffe Trieste   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
133 Big Eyes 28 2014 11 Palace of Fine Arts   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
134 Big Eyes 28 2014 11 1101 Filbert St.   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
135 Big Eyes 28 2014 11 Saints Peter & Paul Church   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
136 Big Eyes 28 2014 11 Green St. & Grant Ave.   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
137 Big Eyes 28 2014 11 Filbert St. & Leavenworth   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
138 Big Eyes 28 2014 11 Pine St. & Grant   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
139 Big Eyes 28 2014 11 Way Faire Inn on Leidesdorff   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
140 Big Eyes 28 2014 11 Harry's Bar on Fillmore   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
141 Big Sur 34 2013 27 Tosca Café (242 Columbus Avenue, North Beach)   3311 Productions 30   Michael Polish 32 Jack Kerouac & Michael Polish 31 Josh Lucas 266 Kate Bosworth 29 Stana Katic 453
142 Big Trouble in Little China 35 1986 28     Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 John Carpenter 33 Gary Goldman 32 Kurt Russell 267 Kim Catrall 30 James Hong 454

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