Film_Locations_in_San_Francisco

12 rows where Release Year = 3

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
10	10	40 Days and 40 Nights 3	2002 3	The Walden House, Buena Vista Park	Established in 1867, Buena Vista Park is the oldest official park in San Francisco.	Miramax Films 3	Miramax Films 2	Michael Lehmann 3	Robert Perez 2	Josh Hartnett 239	Shaynnyn Sossamon 2
11	11	40 Days and 40 Nights 3	2002 3	Café Trieste (609 Vallejo)	Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste.	Miramax Films 3	Miramax Films 2	Michael Lehmann 3	Robert Perez 2	Josh Hartnett 239	Shaynnyn Sossamon 2
370	370	Cherish 62	2002 3	387 Fair Oaks at 25th Street		3 Ring Circus Films 46	Fine Line Features 37	Finn Taylor 56	Finn Taylor 56	Brad Hunt 65	Robin Tunney 44
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
1084	1084	Rollerball 203	2002 3			Atlas Entertainment 48	MGM Home Entertainment 79	John McTiernan 168	William Harrison 176	Chris Klein 370	Jean Reno 156
1494	1494	The Sweetest Thing 281	2002 3	Golden Gate National Recreation Area	The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco.	Columbia Pictures Corp. 93	Columbia Pictures 4	Roger Kumble 230	Nancy M. Pimental 242	Cameron Diaz 418	Christina Applegate 217

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