Film_Locations_in_San_Francisco

13 rows where Title = 27

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
99	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	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	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	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	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	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	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	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	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	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	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	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	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

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");