Film_Locations_in_San_Francisco

5 rows where Actor 2 = 75 and Distributor = 6

Search:

descending

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

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