Film_Locations_in_San_Francisco

16 rows where Director = 111 and Distributor = 19

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
684	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
686	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
687	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
688	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
689	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
690	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
691	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
692	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
693	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
694	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
695	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
696	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
697	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
698	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
699	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
700	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

Advanced export

JSON shape: default, array, newline-delimited

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");