Film_Locations_in_San_Francisco

7 rows where Director = 229

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1487	1487	The Rock 280	1996 43	Palace of Fine Arts (3301 Lyon Street)	The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965.	Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216
1488	1488	The Rock 280	1996 43	The San Francisco Bay		Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216
1489	1489	The Rock 280	1996 43	New Russian Hill Market (1198 Pacific Avenue at Jones)		Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216
1490	1490	The Rock 280	1996 43	Fairmont Hotel (950 Mason Street, Nob Hill)	In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.	Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216
1491	1491	The Rock 280	1996 43	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.	Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216
1492	1492	The Rock 280	1996 43	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.	Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216
1493	1493	The Rock 280	1996 43	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.	Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216

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