Film_Locations_in_San_Francisco

Data source: data.sfgov.org

29 rows where Release Year = 22 sorted by Writer

View and edit SQL

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

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer ▼ Actor 1 Actor 2 Actor 3
99 Basic Instinct 27 1992 22 Yerba Buena Center for the Arts   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
100 Basic Instinct 27 1992 22 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
101 Basic Instinct 27 1992 22 Tosca Café (242 Columbus Avenue)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
102 Basic Instinct 27 1992 22 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
103 Basic Instinct 27 1992 22 Raw Hide II (280 Seventh Street)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
104 Basic Instinct 27 1992 22 Pier 7 (The Embarcadero)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
105 Basic Instinct 27 1992 22 Kearney Street (Telegraph Hill)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
107 Basic Instinct 27 1992 22 Hall of Justice (850 Bryant Street)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
108 Basic Instinct 27 1992 22 2930 Vallejo Street   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
109 Basic Instinct 27 1992 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
110 Basic Instinct 27 1992 22 Gibb Street (Chinatown)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
111 Basic Instinct 27 1992 22 1158-70 Montgomery Street   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
112 Basic Instinct 27 1992 22 2104 Broadway   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
513 Final Analysis 95 1992 22 Westin St. Francis Hotel (335 Powell Street, Union Square) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
514 Final Analysis 95 1992 22 Public Health Service Hospital (Presidio, Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
515 Final Analysis 95 1992 22 Presidio, Golden Gate National Recreation Area In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
516 Final Analysis 95 1992 22 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
517 Final Analysis 95 1992 22 Bix Restaurant (56 Gold Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Phil Joanou 86 Robert Berger 87 Richard Gere 264 Kim Basinger 75  
884 Memoirs of an Invisible Man 163 1992 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Carpenter 33 Robert Collector 142 Chevy Chase 79 Daryl Hannah 126 Sam Neill 499
1070 Raising Cain 199 1992 22     Pacific Western 125 Universal Pictures 41 Brian DePalma 45 Brian DePalma 172 John Lithgow 367    
1165 Sister Act 218 1992 22 St. Paul's Church (Church Street, Noe Valley)   Touchstone Pictures 104 Buena Vista Pictures 25 Emile Ardolino 180 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1196 Sneakers 221 1992 22 The Embarcadero   Universal Pictures 15 Universal Pictures 41 Phil Alden Robinson 183 Walter Parkes 192 Sydney Poitier 381 Robert Redford 169  
1197 Sneakers 221 1992 22 Hills Brothers Plaza (The Embarcadero at Harrison)   Universal Pictures 15 Universal Pictures 41 Phil Alden Robinson 183 Walter Parkes 192 Sydney Poitier 381 Robert Redford 169  
1559 Vegas in Space 297 1992 22 Project Artaud (Florida Street)   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1560 Vegas in Space 297 1992 22 Corona Heights Park   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1561 Vegas in Space 297 1992 22 544 Natoma (SOMA)   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1562 Vegas in Space 297 1992 22 422 Oak Street at Laguna   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1563 Vegas in Space 297 1992 22 3567 18th Street   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1564 Vegas in Space 297 1992 22 Under Highway 101 (near Potrero and Cesar Chavez Streets)   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549

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