Film_Locations_in_San_Francisco

Data source: data.sfgov.org

27 rows where Release Year = 25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Locations, Fun Facts, 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
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  
184 184 Boys and Girls 39 2000 25 1122 Folsom Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
185 185 Boys and Girls 39 2000 25 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
186 186 Boys and Girls 39 2000 25 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
187 187 Boys and Girls 39 2000 25 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
188 188 Boys and Girls 39 2000 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
189 189 Boys and Girls 39 2000 25 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
190 190 Boys and Girls 39 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
191 191 Boys and Girls 39 2000 25 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
192 192 Boys and Girls 39 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
193 193 Boys and Girls 39 2000 25 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
194 194 Boys and Girls 39 2000 25 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
195 195 Boys and Girls 39 2000 25 628 Cole Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
620 620 Groove 110 2000 25 435 23rd Street at Illinois   415 Productions 76 Sony Pictures Classics 27 Greg Harrison 102 Greg Harrison 102 Chris Ferreira 314 Elizabeth Sun 89  
621 621 Groove 110 2000 25 435 23rd Street at Illinois   415 Productions 76 Sony Pictures Classics 27 Greg Harrison 102 Greg Harrison 102 Chris Ferreira 314 Elizabeth Sun 89  
622 622 Groove 110 2000 25 435 23rd Street at Illinois   415 Productions 76 Sony Pictures Classics 27 Greg Harrison 102 Greg Harrison 102 Chris Ferreira 314 Elizabeth Sun 89  
731 731 Just One Night 144 2000 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Panoptic Pictures 97 First Look International 65 Alan Jacobs 132 Alan Jacobs 133 Timothy Hutton 336 Maria Grazia Cucinotta 119  
736 736 Live Nude Girls Unite 147 2000 25 Lusty Lady Bar (North Beach)   Constant Communication 100 First Run Features 68 Vicky Funari 135 Vicky Funari 136      
1029 1029 Playing Mona Lisa 192 2000 25 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. The Bubble Factory 121 Buena Vista Pictures 25 Matthew Huffman 161 Marni Freedman 165 Alicia Witt 361 Harvey Fierstein 148  
1085 1085 Romeo Must Die 204 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Silver Pictures 128 Warner Bros. Pictures 6 Andrzej Bartkowiak 169 Mitchell Kapner 177 Jet Li 371 Aaliyah 157  
1086 1086 Romeo Must Die 204 2000 25 Embarcadero Street   Silver Pictures 128 Warner Bros. Pictures 6 Andrzej Bartkowiak 169 Mitchell Kapner 177 Jet Li 371 Aaliyah 157  
1113 1113 Sausalito 207 2000 25 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. B.O.B and Partners 130   Andrew Lau 171   Maggie Cheung 373 Leon Lai 159  
1620 1620 Woman on Top 305 2000 25 312 Fillmore Street   Fox Searchlight Pictures 178 Fox Searchlight Pictures 24 Fina Torres 248 Vera Blasi 264 Penelope Cruz 436    

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 33.095ms · Data source: data.sfgov.org