Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Actor 1

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 ▼ Actor 2 Actor 3
196 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 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      
701 701 I's 135 2011 1 1 Post Street   Banshee Cinema 90   Chris Edgette 125 Kyle Tuck 125      
736 736 Live Nude Girls Unite 147 2000 25 Lusty Lady Bar (North Beach)   Constant Communication 100 First Run Features 68 Vicky Funari 135 Vicky Funari 136      
76 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  
429 429 Doctor Dolittle 79 1998 18 Webster Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
430 430 Doctor Dolittle 79 1998 18 Telegraph Hill Blvd (Telegraph Hill)   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
431 431 Doctor Dolittle 79 1998 18 Larkin & Hyde Streets   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
432 432 Doctor Dolittle 79 1998 18 Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
433 433 Doctor Dolittle 79 1998 18 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
434 434 Doctor Dolittle 79 1998 18 2107 Union Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
435 435 Doctor Dolittle 79 1998 18 2100 Green Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
439 439 Dr. Dolittle 2 82 2001 33 West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
440 440 Dr. Dolittle 2 82 2001 33 Sacramento St., Between Pierce & Broderick Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
441 441 Dr. Dolittle 2 82 2001 33 Hyde Street & Lombard Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
442 442 Dr. Dolittle 2 82 2001 33 Building 924, Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
443 443 Dr. Dolittle 2 82 2001 33 Broadway, Between Franklin & Laguna Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
885 885 Metro 164 1997 8 Bush Street at Jones   Touchstone Pictures 104 Buena Vista Pictures 25 Thomas Carter 140 Randy Feldman 143 Eddie Murphy 3    
676 676 Indiana Jones and the Last Crusade 131 1989 35 Administration Building (Treasure Island) An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Paramount Pictures 4 Paramount Pictures 3 Steven Spielberg 122 Jeffrey Boam 121 Harrison Ford 12 Sean Connery 107  
640 640 Hello Frisco, Hello 118 1943 54     Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Bruce Humberstone 110 Robert Ellis 109 Alice Faye 14 John Payne 94 Jack Oakie 485
12 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
637 637 Heart Beat 117 1980 34 San Francisco Art Institute (800 Chestnut Street)   Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
638 638 Heart Beat 117 1980 34 Washington Square Bar & Grill (1707 Powell)   Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
639 639 Heart Beat 117 1980 34 City Lights Bookstore (261 Columbus) One of the country's earliest bookstores, City Lights was founded by, and still owned by beat poet Lawrence Ferlinghetti. The bookstore was often frequented by Beat writers like Allen Ginsberg and Jack Kerouac. Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
887 887 Milk 166 2008 59 Duboce Park   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
888 888 Milk 166 2008 59 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
889 889 Milk 166 2008 59 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
890 890 Milk 166 2008 59 424 Sansome Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
891 891 Milk 166 2008 59 29th and Dolores Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
892 892 Milk 166 2008 59 El Camino Del Mar   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
893 893 Milk 166 2008 59 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
894 894 Milk 166 2008 59 Market & Castro Street From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
895 895 Milk 166 2008 59 Marine Fireman's Union Headquarters   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
896 896 Milk 166 2008 59 Lower Haight Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
898 898 Milk 166 2008 59 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
899 899 Milk 166 2008 59 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
1310 1310 The Assassination of Richard Nixon 240 2004 5 Tosca Café (242 Columbus Avenue, North Beach)   Anhelo Productions 146 THINKFilm 104 Niels Mueller 197 Niels Mueller & Kevin Kennedy 209 Sean Penn 40 Naomi Watts 184  
1311 1311 The Assassination of Richard Nixon 240 2004 5 766 Sutter Street   Anhelo Productions 146 THINKFilm 104 Niels Mueller 197 Niels Mueller & Kevin Kennedy 209 Sean Penn 40 Naomi Watts 184  
1590 1590 When a Man Loves a Woman 302 1994 48 Buena Vista Café (2765 Hyde Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1591 1591 When a Man Loves a Woman 302 1994 48 Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1592 1592 When a Man Loves a Woman 302 1994 48 Spring Valley School (1451 Jackson Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1593 1593 When a Man Loves a Woman 302 1994 48 International Studies Academy (993 Vermont Street, Potrero Hill)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1594 1594 When a Man Loves a Woman 302 1994 48 Grant Street at Pacific Avenue   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1595 1595 When a Man Loves a Woman 302 1994 48 Cybelle's Pizza (1000 Bush Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1596 1596 When a Man Loves a Woman 302 1994 48 766 Vallejo Street at Stockton Street (North Beach)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1597 1597 When a Man Loves a Woman 302 1994 48 1521 Masonic Avenue at Piedmont Street   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
370 370 Cherish 62 2002 3 387 Fair Oaks at 25th Street   3 Ring Circus Films 46 Fine Line Features 37 Finn Taylor 56 Finn Taylor 56 Brad Hunt 65 Robin Tunney 44  
1157 1157 Serendipity 211 2001 33     Miramax Films 3 Miramax Home Entertainment 81 Peter Chelsom 174 Marc Klein 183 John Cusack 72 Kate Beckinsale 161  
884 884 Memoirs of an Invisible Man 163 1992 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Carpenter 33 Robert Collector 142 Chevy Chase 79 Daryl Hannah 126 Sam Neill 499
1451 1451 The Organization 272 1971 42     The Mirisch Corporation 160 United Artists 19 Don Medford 224 James R. Webb 235 Sidney Poitier 90 Barbara McNair 209  
1516 1516 They Call Me MISTER Tibbs 287 1970 74     Mirisch Corporation 168 United Artists 19 Gordon Douglas 235 Alan R. Trustman 39 Sidney Poitier 90 Martin Landau 222 Barbara McNair 209
912 912 Murder in the First, Season 1 171 2014 11 1821 Alabama Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
913 913 Murder in the First, Season 1 171 2014 11 Hall of Justice (850 Bryant Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
914 914 Murder in the First, Season 1 171 2014 11 Cameron House (920 Sacramento Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
915 915 Murder in the First, Season 1 171 2014 11 504 Broadway   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
916 916 Murder in the First, Season 1 171 2014 11 9 Calhoun Terrace   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
917 917 Murder in the First, Season 1 171 2014 11 AT&T Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
918 918 Murder in the First, Season 1 171 2014 11 Berry Street between 3rd and 4th Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
919 919 Murder in the First, Season 1 171 2014 11 Kearny Street between Broadway and Pacific Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
920 920 Murder in the First, Season 1 171 2014 11 731 Grant Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
921 921 Murder in the First, Season 1 171 2014 11 Waverly Alley between Grant and Sacramento Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
922 922 Murder in the First, Season 1 171 2014 11 Joice Street at Clay Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
923 923 Murder in the First, Season 1 171 2014 11 Palace of Fine Arts (3301 Lyon Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
924 924 Murder in the First, Season 1 171 2014 11 800 Bay Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
925 925 Murder in the First, Season 1 171 2014 11 1201 Columbus Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
926 926 Murder in the First, Season 1 171 2014 11 Pier 45 The famous Musee Mecanique is located on Pier 45 Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
927 927 Murder in the First, Season 1 171 2014 11 369 Embarcadero   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
928 928 Murder in the First, Season 1 171 2014 11 Dolores Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
929 929 Murder in the First, Season 1 171 2014 11 24th Street between Folsom and Harrison Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
930 930 Murder in the First, Season 1 171 2014 11 13 Lucky Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
931 931 Murder in the First, Season 1 171 2014 11 1541 Grove Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
932 932 Murder in the First, Season 1 171 2014 11 Ida B. Wells High School (1099 Hayes Street) Ida B. Wells High School is named after the African-American journalist, suffragist and early leader in the Civil Rights Movement Ida B. Wells Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
933 933 Murder in the First, Season 1 171 2014 11 Alamo Square Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
934 934 Murder in the First, Season 1 171 2014 11 50 California Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
935 935 Murder in the First, Season 1 171 2014 11 373 Columbus Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
936 936 Murder in the First, Season 1 171 2014 11 350 Union Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
937 937 Murder in the First, Season 2 172 2015 10 Potrero Hill Recreation Center (801 Arkansas Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
938 938 Murder in the First, Season 2 172 2015 10 1243 19th Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
939 939 Murder in the First, Season 2 172 2015 10 372/374 Pennsylvania Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
940 940 Murder in the First, Season 2 172 2015 10 Stevenson Alley   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
941 941 Murder in the First, Season 2 172 2015 10 901 Missouri Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
942 942 Murder in the First, Season 2 172 2015 10 83 Watchman Way   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
943 943 Murder in the First, Season 2 172 2015 10 1059 Texas Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
944 944 Murder in the First, Season 2 172 2015 10 Sue Bierman Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
945 945 Murder in the First, Season 2 172 2015 10 Embarcadero Street at Washington Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
946 946 Murder in the First, Season 2 172 2015 10 Treasure Island   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
947 947 Murder in the First, Season 2 172 2015 10 Pier 50   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
948 948 Murder in the First, Season 2 172 2015 10 435 Broadway   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
949 949 Murder in the First, Season 2 172 2015 10 Columbus Avenue between Washington and Bay Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
950 950 Murder in the First, Season 2 172 2015 10 Grant Avenue between Clay and Washington Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
951 951 Murder in the First, Season 2 172 2015 10 1400 16th Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
952 952 Murder in the First, Season 2 172 2015 10 Pennsylvania Avenue at 19th Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
953 953 Murder in the First, Season 2 172 2015 10 Harriet Street between Bryant and Brannan Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
954 954 Murder in the First, Season 2 172 2015 10 Boardman Place between Bryant and Brannan Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
955 955 Murder in the First, Season 3 173 2016 30 Golden Gate Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
956 956 Murder in the First, Season 3 173 2016 30 Civic Center Plaza   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
957 957 Murder in the First, Season 3 173 2016 30 500 Grove Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
958 958 Murder in the First, Season 3 173 2016 30 600 Octavia Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
959 959 Murder in the First, Season 3 173 2016 30 535 Octavia Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
960 960 Murder in the First, Season 3 173 2016 30 Patricia's Green   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502

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