home / sf-film-locations

Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Distributor

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
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
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
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
196 Broken-A Modern Love Story  40 2010 19 Ina Coolbrith Park (1700 Taylor Street)   RKW Films 35   Ryan K. Whiting 38 Ryan K. Whiting 37      
197 Broken-A Modern Love Story  40 2010 19 0-100 block Halleck Street   RKW Films 35   Ryan K. Whiting 38 Ryan K. Whiting 37      
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 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 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 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 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 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 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 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 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 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
594 God is a Communist?* (show me heart universe) 105 2010 19 Sacramento & Washington Streets   Trismegistus Productions 73   Jon Poznanter 97 Jon Poznanter 97 John Wynn 310    
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 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 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 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 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 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 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
701 I's 135 2011 1 1 Post Street   Banshee Cinema 90   Chris Edgette 125 Kyle Tuck 125      
862 Love & Taxes 159 2014 11 The Marsh Theatre (1062 Valencia Street)   Bad Company Films 102   Jacob Kornbluth 137 Jacob Kornbluth 138 Jacob Kornbluth 340    
863 Love & Taxes 159 2014 11 20 Hill Street   Bad Company Films 102   Jacob Kornbluth 137 Jacob Kornbluth 138 Jacob Kornbluth 340    
864 Love & Taxes 159 2014 11 198 Gough Street   Bad Company Films 102   Jacob Kornbluth 137 Jacob Kornbluth 138 Jacob Kornbluth 340    
900 Mission (aka City of Bars) 167 2001 33 The 500 Club (500 Guerrero Street, Mission District)       Loren Marsh 143 Loren Marsh 146 Chris Coburn 342    
901 Mission (aka City of Bars) 167 2001 33 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA.     Loren Marsh 143 Loren Marsh 146 Chris Coburn 342    
974 Never Die Twice 175 2001 33 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Scott / Kelly Films 110   Sean A.F. Scott 148 Sean A.F. Scott & Nancy L. Kelly 152 Claudia Christian 345    
1054 Quitters 198 2015 10 1536 Noe St.   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1055 Quitters 198 2015 10 24 Hill St.   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1056 Quitters 198 2015 10 21st St & Sanchez   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1057 Quitters 198 2015 10 4015 21st St   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1058 Quitters 198 2015 10 Tank Hill Park   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1059 Quitters 198 2015 10 Clement St. from 6th to 7th Ave.   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1060 Quitters 198 2015 10 Wine Impression   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1061 Quitters 198 2015 10 Clement St. from 5th and 7th Ave.   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1062 Quitters 198 2015 10 Claire Lilienthal Elementary School   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1063 Quitters 198 2015 10 Yerba Buena Gardens   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1064 Quitters 198 2015 10 Tonga Room   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1065 Quitters 198 2015 10 Cal-Mart Supermarket   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1066 Quitters 198 2015 10 McLaren Lodge   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1067 Quitters 198 2015 10 Bechelli's Flower Market Café   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1068 Quitters 198 2015 10 923 Vermont St.   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1069 Quitters 198 2015 10 Geary from 22nd Ave to Arguello   Frederick & Ashbury, LLC. 124   Noah Pritzker 165 Noah Pritzker 171 Kara Hayward 366 Mira Sorvino 153 Saffron Burrows 512
1113 Sausalito 207 2000 25 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. B.O.B and Partners 130   Andrew Lau 171   Maggie Cheung 373 Leon Lai 159  
1171 Smile Again, Jenny Lee 220 2015 10 Manor West (750 Harrison St.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1172 Smile Again, Jenny Lee 220 2015 10 475 Diamond St.   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1173 Smile Again, Jenny Lee 220 2015 10 Hyatt Hotel (555 North Point St.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1174 Smile Again, Jenny Lee 220 2015 10 Fairmont Hotel (950 Mason Street, Nob Hill)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1175 Smile Again, Jenny Lee 220 2015 10 411 Shrader St.   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1176 Smile Again, Jenny Lee 220 2015 10 883 42nd Ave.   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1177 Smile Again, Jenny Lee 220 2015 10 Mason & Sacramento St   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1178 Smile Again, Jenny Lee 220 2015 10 Unitarian Church (1187 Franklin St.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1179 Smile Again, Jenny Lee 220 2015 10 Huntington Park (California & Taylor Streets, Nob Hill)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1180 Smile Again, Jenny Lee 220 2015 10 E Tutto Qua Restaurant (270 Columbus St.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1181 Smile Again, Jenny Lee 220 2015 10 1328 Portola   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1182 Smile Again, Jenny Lee 220 2015 10 Clay St. at Sansome   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1183 Smile Again, Jenny Lee 220 2015 10 Montgomery Street at Post Street   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1184 Smile Again, Jenny Lee 220 2015 10 333 Pacheco St at Lopez Ave.   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1185 Smile Again, Jenny Lee 220 2015 10 Mission Inn (5630 Mission St)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1186 Smile Again, Jenny Lee 220 2015 10 87 Cervantes Blvd (beach)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1187 Smile Again, Jenny Lee 220 2015 10 Gaspare's Pizza House (5546 Geary Blvd.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1188 Smile Again, Jenny Lee 220 2015 10 510 Noe Street & 18th St.   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1189 Smile Again, Jenny Lee 220 2015 10 Europa Café (4318 California St. and 5th Ave.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1190 Smile Again, Jenny Lee 220 2015 10 New Taraval Café (1054 Taraval St.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1191 Smile Again, Jenny Lee 220 2015 10 Kansas St at 17th St.   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1192 Smile Again, Jenny Lee 220 2015 10 City Hall   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1193 Smile Again, Jenny Lee 220 2015 10 Ocean Beach Motel (2690 46th Ave.)   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517
1194 Smile Again, Jenny Lee 220 2015 10 Greenwich St at Battery St   Carlo Caldana/Marguery Films 135   Carlo Caldana 182 Linda Demetrick 191 Craig Tsuyumine 380 Puneet Prasad 168 Larry Kitagawa 517

Next page

Advanced export

JSON shape: default, array

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))
Powered by Datasette · Query took 12.936ms · Data source: data.sfgov.org