Film_Locations_in_San_Francisco

Data source: data.sfgov.org

29 rows where Distributor = 20 sorted by Actor 1

View and edit SQL

Suggested facets: Title, Release Year, Production Company, 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
410 Desperate Measures 76 1998 18     Mandalay Entertainment 57 TriStar Pictures 20 Barbet Schroeder 70 David Klass 69 Michael Keaton 293 Andy Garcia 58 Raven-Symone 469
1198 So I Married an Axe Murderer 222 1993 46 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1199 So I Married an Axe Murderer 222 1993 46 Swedenborgian Church (2107 Lyon Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1200 So I Married an Axe Murderer 222 1993 46 St. John's Presbyterian Church (25 Lake Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1201 So I Married an Axe Murderer 222 1993 46 San Francisco Chronicle (901 Mission Street at 15th Street) The paper is called the San Francisco Globe in the movie. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1202 So I Married an Axe Murderer 222 1993 46 Rocco's Corner (Columbus Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1203 So I Married an Axe Murderer 222 1993 46 Prudente's Italian Deli (1462 Grant Ave at Union) Prudente's Italian Deli, which has since closed, is called "Meats of the World" in the film. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1204 So I Married an Axe Murderer 222 1993 46 Fog City Diner (1300 Battery Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1205 So I Married an Axe Murderer 222 1993 46 Edinburgh Castle (950 Geary Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1206 So I Married an Axe Murderer 222 1993 46 City Light Bookstore (261 Columbus Avenue)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1207 So I Married an Axe Murderer 222 1993 46 Café Picaro 3120 16th Street   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1208 So I Married an Axe Murderer 222 1993 46 Alcatraz Island Alcatraz Island was a military fort before it became a prison. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1209 So I Married an Axe Murderer 222 1993 46 Aladdin Terrace (off of Taylor Street, Between Filbert and Union)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1210 So I Married an Axe Murderer 222 1993 46 305 Hugo Street   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1211 So I Married an Axe Murderer 222 1993 46 1462 Grant Avenue, at Union Street   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1392 The Doors 254 1991 37     Bill Graham Films 154 TriStar Pictures 20 Oliver Stone 209 J. Randal Johnson 221 Val Kilmer 401 Meg Ryan 46  

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