Film_Locations_in_San_Francisco

Data source: data.sfgov.org

18 rows where Actor 1 = 286 sorted by Locations

View and edit SQL

Suggested facets: Title, Release Year, Production Company, Distributor, Director, Writer, Actor 2, Actor 3

Link rowid Title Release Year Locations ▼ Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
700 Invasion of the Body Snatchers 134 1978 7 1227 Montgomery Street (Telegraph Hill)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
386 Crackers 69 1984 40 24th Street between Mission Street and Potrero Avenue   Universal Pictures 15 Universal Pictures 41 Louis Malle 63 Jeffrey Fiskin 62 Donald Sutherland 286 Jack Warden 51 Sean Penn 40
699 Invasion of the Body Snatchers 134 1978 7 32 Napier Lane   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
698 Invasion of the Body Snatchers 134 1978 7 720 Steiner Street (Hayes Valley)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
697 Invasion of the Body Snatchers 134 1978 7 Bimbo's 365 Club (1025 Columbus Avenue, North Beach)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
696 Invasion of the Body Snatchers 134 1978 7 Broadway Tunnel (Russian Hill)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
695 Invasion of the Body Snatchers 134 1978 7 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
694 Invasion of the Body Snatchers 134 1978 7 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. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
686 Invasion of the Body Snatchers 134 1978 7 Department of Public Health (101 Grove Street at Polk, Civic Center)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
693 Invasion of the Body Snatchers 134 1978 7 Hamlin Hotel (385 Eddy Street)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
387 Crackers 69 1984 40 La Rondalla (Valencia and 20th Streets)   Universal Pictures 15 Universal Pictures 41 Louis Malle 63 Jeffrey Fiskin 62 Donald Sutherland 286 Jack Warden 51 Sean Penn 40
692 Invasion of the Body Snatchers 134 1978 7 Lafayette Park (Pacific Heights)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
684 Invasion of the Body Snatchers 134 1978 7 Pier 33 (Embarcadero)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
691 Invasion of the Body Snatchers 134 1978 7 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. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
690 Invasion of the Body Snatchers 134 1978 7 Ramada Plaza Hotel Downtown (1231 Market Street, Civic Center)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
689 Invasion of the Body Snatchers 134 1978 7 San Francisco Drydock (20th and Illinois Streets)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
688 Invasion of the Body Snatchers 134 1978 7 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
687 Invasion of the Body Snatchers 134 1978 7 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491

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