Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Director = 124

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
680 Interview With The Vampire 133 1994 48 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
681 Interview With The Vampire 133 1994 48 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
682 Interview With The Vampire 133 1994 48 100 Market Street at 6th Street   Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
683 Interview With The Vampire 133 1994 48 6th Street On-ramp to Highway 280   Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490

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