Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Writer = 131

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
723 Junior 142 1994 48 2552 Hyde Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
724 Junior 142 1994 48 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
725 Junior 142 1994 48 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
726 Junior 142 1994 48 Hyatt Fisherman's Wharf (555 Northpoint Street)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
727 Junior 142 1994 48 Fairmont Hotel (950 Mason Street, Nob Hill)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
728 Junior 142 1994 48 Chinatown Gate Designed in 1970, the Chinatown Gate (aka the Dragon Gate) is based on ceremonial gates found in Chinese villages. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
729 Junior 142 1994 48 722 Steiner Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494

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