Film_Locations_in_San_Francisco

Data source: data.sfgov.org

27 rows where Production Company = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Fun Facts, 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
13 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  
252 252 Casualties of War 47 1989 35 Mission Dolores Park (Mission District) via J-Church MUNI Train 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. Columbia Pictures Corporation 5 Columbia Pictures 4 Brian DePalma 45 Daniel Lang 44 Michael J. Fox 278 Sean Penn 40  
488 488 Experiment in Terror 89 1962 29 George Washington High School (600 32nd Avenue )   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
489 489 Experiment in Terror 89 1962 29 Wells Fargo Bank (1 California Street, Financial District)   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
490 490 Experiment in Terror 89 1962 29 The Sea Captain's Chest (Fisherman's Wharf)   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
491 491 Experiment in Terror 89 1962 29 Sheraton Palace Hotel (2 Montgomery Street, Financial District) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
492 492 Experiment in Terror 89 1962 29 Roaring Twenties Nightclub (555 Broadway at Columbus)   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
493 493 Experiment in Terror 89 1962 29 Candlestick Park Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
494 494 Experiment in Terror 89 1962 29 2632 Larkin Street at Lombard   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
495 495 Experiment in Terror 89 1962 29 100 St. Germain Avenue   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
496 496 Experiment in Terror 89 1962 29 1 Montgomery Street at Post   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
616 616 Good NeighborSam 108 1964 51 Various locations in San Francisco during driving scene   Columbia Pictures Corporation 5 Columbia Pictures 4 David Swift 100 James Fritzell 100 Jack Lemmon 292 Romy Schneider 87 Dorothy Provine 482
623 623 Guess Who's Coming to Dinner 111 1967 53 Sutter Street between Powell and Mason   Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
624 624 Guess Who's Coming to Dinner 111 1967 53 San Francisco International Airport SFO has a museum dedicated to aviation history. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
625 625 Guess Who's Coming to Dinner 111 1967 53 Mel's Drive-In (Corner South Van Ness & Mission St.) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
626 626 Guess Who's Coming to Dinner 111 1967 53 634 Raycliff Terrace   Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
1002 1002 Pal Joey 184 1957 61 Spreckels Mansion (2080 Washington Street, Pacific Heights)   Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1003 1003 Pal Joey 184 1957 61 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. Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1004 1004 Pal Joey 184 1957 61 Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business. Columbia Pictures Corporation 5 Columbia Pictures 4 George Sidney 153 Dorothy Kingsley 159 Rita Hayworth 354 Frank Sinatra 141 Kim Novak 231
1053 1053 Quicksilver 197 1986 28 Pacific Stock Exchange   Columbia Pictures Corporation 5 Columbia Pictures 4 Thomas Michael Donnelly 164 Thomas Michael Donnelly 170 Kevin Bacon 365 Jami Gertz 152 Paul Rodriguez 511
1332 1332 The Competition 248 1980 34 Pier 39   Columbia Pictures Corporation 5 American Broadcasting Company (ABC) 51 Joel Oliansky 204 Joel Oliansky 215 Richard Dreyfuss 252 Amy Irving 190 Lee Remick 57
1333 1333 The Competition 248 1980 34 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. Columbia Pictures Corporation 5 American Broadcasting Company (ABC) 51 Joel Oliansky 204 Joel Oliansky 215 Richard Dreyfuss 252 Amy Irving 190 Lee Remick 57
1478 1478 The Pursuit of Happyness 277 2006 68 Glen Park Subway Station   Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1479 1479 The Pursuit of Happyness 277 2006 68 Glide Memorial Church (434 Ellis St)   Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1480 1480 The Pursuit of Happyness 277 2006 68 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1482 1482 The Pursuit of Happyness 277 2006 68 Golden Gate Park Children's Playground Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Columbia Pictures Corporation 5 Columbia Pictures 4 Steven Conrad 227 Gabriele Muccino 202 Will Smith 416 Jayden C. Smith 213  
1544 1544 True Believer 292 1989 35     Columbia Pictures Corporation 5 Columbia Pictures 4 Joseph Ruben 238 Wesley Strick 252 James Woods 428 Robert Downey, Jr. 227  

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