Film_Locations_in_San_Francisco

Data source: data.sfgov.org

5 rows where Director = 75 sorted by Director

View and edit SQL

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

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