Film_Locations_in_San_Francisco

9 rows where Director = 114

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
648	648	High Anxiety 122	1977 55	Hyatt Regency Hotel (5 Embarcadero Center)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98	Cloris Leachman 486
649	649	High Anxiety 122	1977 55	Fort Point (Presidio, Golden Gate National Recreation Area)	Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF.	Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98	Cloris Leachman 486
650	650	High Anxiety 122	1977 55	Conservatory of Flowers, Golden Gate Park	The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere.	Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98	Cloris Leachman 486
651	651	High Crimes 123	2002 3	Bank of America Building (555 California Street)	The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast.	Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98
653	653	High Crimes 123	2002 3	Vesuvio Café (255 Columbus Avenue)	Jack Kerouac was a regular at the café.	Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98
654	654	High Crimes 123	2002 3	Union Square	During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".	Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98
655	655	High Crimes 123	2002 3	Maiden Lane		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98
656	656	High Crimes 123	2002 3	Condor Club (Columbus and Broadway)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98
657	657	High Crimes 123	2002 3	Chase H & Q (1 Bush Street at Sansome)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Mel Brooks 114	Mel Brooks 113	Mel Brooks 323	Madeline Kahn 98

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