Film_Locations_in_San_Francisco

Data source: data.sfgov.org

13 rows where Actor 1 = 245, Distributor = 20 and Production Company = 24

View and edit SQL

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

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