Film_Locations_in_San_Francisco

Data source: data.sfgov.org

12 rows where Release Year = 3

View and edit SQL

Suggested facets: Title, Production Company, Distributor, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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 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 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 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 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 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 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 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 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 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 Rollerball 203 2002 3     Atlas Entertainment 48 MGM Home Entertainment 79 John McTiernan 168 William Harrison 176 Chris Klein 370 Jean Reno 156  
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

CSV options:

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");
Powered by Datasette · Query took 55.583ms · Data source: data.sfgov.org