Film_Locations_in_San_Francisco

7 rows where Title = 123

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
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
652	652	High Crimes 123	2002 3	391 Pennsylvania Avenue at 19th Street		Twentieth Century Fox Corporation 63	Twentieth Century Fox Corporation 48	Carl Franklin 49	Yuri Zeltser 114	Ashley Judd 324	Morgan Freeman 99
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");