Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Actor 3 = 535

View and edit SQL

Suggested facets: Production Company

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1424 The Internship 261 2013 27 Grant Ave from Sacramento to Clay   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1425 The Internship 261 2013 27 Montgomery and Union St.   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1426 The Internship 261 2013 27 Epic Roasthouse   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1427 The Internship 261 2013 27 Players Arcade at Pier 39   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535

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