Film_Locations_in_San_Francisco

5 rows where Director = 75

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
439	439	Dr. Dolittle 2 82	2001 33	West Chrissy Field (Presidio, Golden Gate National Recreation Area)	This movie was the first to film in the revamped Chrissy Field Picnic Area.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
440	440	Dr. Dolittle 2 82	2001 33	Sacramento St., Between Pierce & Broderick Streets		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
441	441	Dr. Dolittle 2 82	2001 33	Hyde Street & Lombard Street		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
442	442	Dr. Dolittle 2 82	2001 33	Building 924, 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.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
443	443	Dr. Dolittle 2 82	2001 33	Broadway, Between Franklin & Laguna Streets		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63

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