Film_Locations_in_San_Francisco

9 rows where Actor 2 = 102 and Distributor = 3

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
660	660	Jade 126	1995 39	Lombard & Hyde Streets		Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
685	685	Jade 126	1995 39	Hall of Justice (850 Bryant Street)		Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
706	706	Jade 126	1995 39	Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park)	The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
707	707	Jade 126	1995 39	Fior d' Italia (601 Union Street at Stockton)		Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
708	708	Jade 126	1995 39	Fairmont Hotel (950 Mason Street, Nob Hill)	In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
709	709	Jade 126	1995 39	Washington Square (North Beach)	Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach.	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
710	710	Jade 126	1995 39	War Memorial Opera House (401 Van Ness Avenue)	In 1945 the United Nations had its first conference at The War Memorial Opera House.	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
711	711	Jade 126	1995 39	Sheraton Palace Hotel (639 Market Street)	The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909.	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487
712	712	Jade 126	1995 39	Palace of Fine Arts	The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965.	Paramount Pictures 4	Paramount Pictures 3	William Friedkin 117	Joe Eszterhas 24	David Caruso 223	Linda Fiorentino 102	Chazz Palminteri 487

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