sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
9 2 2     2 1 2   238    
12 4 4     4 3 4 3 19 3 440
58 19 5     16   18 17 253 17  
76 21 17     18 3 4 3 3 19  
90 24 19     21 17 22 21 257 20  
98 26 21     23 19 24 23 259 22 448
113 29 23     26 22 27 26 261 25 451
126 32 2     28 24 30 29 264 28  
142 35 28     13 12 33 32 267 30 454
324 58 7     44 35 53 54 281    
379 67 38     51 40 61   284 49  
409 75 29     38 6 69 68 292 57 468
410 76 18     57 20 70 69 293 58 469
438 81 43     14 13 74 74 297 7  
448 85 37     63 48 77 78 150 66  
501 91 5     66 50 82 84 303 71  
503 93 8     67 22 84 79 265 73  
627 112 33     77 27 104 104 316 91  
628 113 43     78 41 105 105 240    
640 118 54     13 12 110 109 14 94 485
659 125 38     84 59 116 116 104 101  
705 137 43     92 25 127 127 265 112  
715 139 43     94 62 129 128 252 114  
722 141 38     96 64 130 130 333 116  
730 143 2     84 59 131 132 335 118  
902 168 38     107 4 144 147 150 129  
975 176 2     111 70 149 153 346 133  
976 177 48     112 47 132 133 347 134  
994 181 60     113 19 103 156 351 138 362
1005 185 39     116 72 154 160 355 142  
1034 195 17     104 25 27 168 264 150  
1035 196 31     123 77 91 169 364 151 510
1070 199 22     125 41 45 172 367    
1084 203 3     48 79 168 176 370 156  
1157 211 33     3 81 174 183 72 161  
1161 215 37     133 83 177 187 377 164  
1239 229 36     139 86 190 200 386 174 520
1330 246 2     149 107 202 213 396    
1359 251 23     152 108 206 218 398    
1391 253 37     26 25 208 220 400 194  
1392 254 37     154 20 209 221 401 46  
1403 257 38     155 27 212   403    
1433 264 16     13 51 219 230 408 70 538
1450 271 46     104 25 129 234 412 208  
1451 272 42     160 19 224 235 90 209  
1515 286 2     167 104 234 247 423 44  
1516 287 74     168 19 235 39 90 222 209
1517 288 40     4 3 236 248 424 223 545
1542 290 43     52 6 237 250 426 225  
1543 291 56     169 4 112 251 427 226 547
1544 292 35     5 4 238 252 428 227  
1546 294 2     171 116 239 254 429    
1553 209 5     4 3 111 181 324 160  
1621 306 31     179 19 249 265 437 236 551
1137 208 10 "Metzger's Apt" 151 Alice B. Toklas Pl. Overnight scene involving aggressive arguments between actors, spfx shoot out involved 131 53 172 180 374    
197 40 19 0-100 block Halleck Street   35   38 37      
1417 258 8 1 Bush Street   156 110 213 224 245 40 532
1306 239 10 1 Market St. Landmark Building   145 3 196 208 334 183  
496 89 29 1 Montgomery Street at Post   5 4 69 82 301 57 473
701 135 1 1 Post Street   90   125 125      
336 60 30 1 Urbano   43 34 51 52 280 42 463
250 46 10 100 Alemany Blvd.   41   44 43 277 39 461
1442 266 31 100 Block of Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. 82 58 112 111 410 203 540
1534 289 44 100 Block of Union Street (Cow Hollow)   166 38 186 249 425 224 546
802 150 10 100 Church Street Jake Shears, lead singer of the band Scissor Sisters, auditioned for the role of Dom. 101 18 136 137 339 123 496
911 170 46 100 Embarcadero Street   13 12 31 149 265 100 501
682 133 48 100 Market Street at 6th Street   88 61 124 123 329 109 490
495 89 29 100 St. Germain Avenue   5 4 69 82 301 57 473
326 57 30 1000 Mason St.   43 34 52 53 280 42 463
1580 298 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. 174 3 81 258 432 231 106
241 45 34 101 Henry Adams Place   40 32 43 42 276 38 460
991 178 39 101 Henry Adams Place, 4th Floor   29 13 31 154 348 135 265
302 54 30 1018 Tennessee St.   43 34 49 50 280 42 463
264 50 30 1055 Montgomery St.   43 34 48 47 280 42 463
943 172 10 1059 Texas Street   108 69 146 150 103 131 502
897 74 30 1069 Tennessee Street   56 43 68 67 291 56 467
779 149 30 1080 Natoma Street   101 18 136 137 339 123 496
786 149 30 10th Street between Market & Mission   101 18 136 137 339 123 496
304 54 30 11 San Jacinto Ave.   43 34 49 50 280 42 463
134 28 11 1101 Filbert St.   25 21 26 25 260 24 450
843 156 10 1111 California Street   101 18 136 137 339 123 496
832 153 10 1119 Alabama Street   101 18 136 137 339 123 496
184 39 25 1122 Folsom Street   34 28 37 36 271 34  
207 41 20 1125 Guerrero Street   36 29 39 38 272 35 458
175 38 27 1138 Alabama St   33 27 36 35 270 33 457
457 86 26 1138 Filbert Street   64 49 78 79 220 67  
234 42 31 1153-57 Taylor Street Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) 37 30 40 39 273 36 459
121 31 25 1155 Filbert Street at Hyde   14 13 29 28 263 27  
111 27 22 1158-70 Montgomery Street   24 20 25 24 245 23 449
647 121 19 1160 Taylor Street   83 6 113 112 322 97  
201 41 20 1167 Alabama Street   36 29 39 38 272 35 458
249 46 10 119 Utah   41   44 43 277 39 461
905 170 46 1200 Washington Street at Taylor Street   13 12 31 149 265 100 501
925 171 11 1201 Columbus Avenue   108 69 146 150 103 131 502
473 88 20 1227 Montgomery Street   65 43 80 81 300 69 472
1423 260 70 1227 Montgomery Street   14 13 215 226 405 198 534
700 134 7 1227 Montgomery Street (Telegraph Hill)   89 19 111 124 286 110 491
938 172 10 1243 19th Street   108 69 146 150 103 131 502
780 149 30 1246 Folsom Street   101 18 136 137 339 123 496
799 150 10 1246 Folsom Street   101 18 136 137 339 123 496
841 156 10 1246 Folsom Street   101 18 136 137 339 123 496
Powered by Datasette · Query took 1.996ms · Data source: data.sfgov.org