Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Actor 2 = 21

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
91 Ballers Season 3 25 2017 20 Fairmont Hotel (950 Mason Street, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
92 Ballers Season 3 25 2017 20 Embarcadero around Rincon Park   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
93 Ballers Season 3 25 2017 20 San Remo Hotel (2237 Mason)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
94 Ballers Season 3 25 2017 20 Huntington Park (California & Taylor Streets, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
95 Ballers Season 3 25 2017 20 Driving around Taylor/Pacific/Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
96 Ballers Season 3 25 2017 20 California and Jones St.   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
97 Ballers Season 3 25 2017 20 Another Café, 1191 Pine St at Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447

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