Film_Locations_in_San_Francisco

Data source: data.sfgov.org

10 rows where Actor 2 = 24

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
106 Big Eyes 28 2014 11 Nobles Alley   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
132 Big Eyes 28 2014 11 Caffe Trieste   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
133 Big Eyes 28 2014 11 Palace of Fine Arts   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
134 Big Eyes 28 2014 11 1101 Filbert St.   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
135 Big Eyes 28 2014 11 Saints Peter & Paul Church   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
136 Big Eyes 28 2014 11 Green St. & Grant Ave.   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
137 Big Eyes 28 2014 11 Filbert St. & Leavenworth   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
138 Big Eyes 28 2014 11 Pine St. & Grant   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
139 Big Eyes 28 2014 11 Way Faire Inn on Leidesdorff   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
140 Big Eyes 28 2014 11 Harry's Bar on Fillmore   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450

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