Film_Locations_in_San_Francisco

5 rows where Director = 29

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
121	121	Bedazzled 31	2000 25	1155 Filbert Street at Hyde		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Harold Ramis 29	Harold Ramis 28	Brendan Fraser 263	Elizabeth Hurley 27
122	122	Bedazzled 31	2000 25	Washington Square Park (Filbert, between Stockton and Powell)		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Harold Ramis 29	Harold Ramis 28	Brendan Fraser 263	Elizabeth Hurley 27
123	123	Bedazzled 31	2000 25	Vaillancourt Fountain (Justin Herman Plaza)	Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Harold Ramis 29	Harold Ramis 28	Brendan Fraser 263	Elizabeth Hurley 27
124	124	Bedazzled 31	2000 25	Montgomery & Market Streets		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Harold Ramis 29	Harold Ramis 28	Brendan Fraser 263	Elizabeth Hurley 27
125	125	Bedazzled 31	2000 25	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.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Harold Ramis 29	Harold Ramis 28	Brendan Fraser 263	Elizabeth Hurley 27

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