Film_Locations_in_San_Francisco

Data source: data.sfgov.org

16 rows where Actor 2 = 85 sorted by rowid descending

View and edit SQL

Link rowid ▲ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
610 Godzilla 106 2014 11 Potrero &San Bruno   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
609 Godzilla 106 2014 11 Mission & Beal   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
608 Godzilla 106 2014 11 Embarcadero & Washington   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
607 Godzilla 106 2014 11 Pier 1   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
606 Godzilla 106 2014 11 Pier 7 (The Embarcadero)   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
605 Godzilla 106 2014 11 Eddy & Taylor St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
604 Godzilla 106 2014 11 Mission & Fremont St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
603 Godzilla 106 2014 11 Bush & Kearny   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
602 Godzilla 106 2014 11 Stockton & Clay St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
601 Godzilla 106 2014 11 Post & Jones St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
600 Godzilla 106 2014 11 Broadway & Columbus   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
599 Godzilla 106 2014 11 Broadway & Sansome   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
598 Godzilla 106 2014 11 Sacramento & Front St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
597 Godzilla 106 2014 11 Pine St. & Davis St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
596 Godzilla 106 2014 11 California & Davis St   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481
595 Godzilla 106 2014 11 Kearney & Pine St.   Nautilus Productions, LLC 74 Warner Bros. Pictures 6 Gareth Edwards 98 Max Borenstein 98 Aaron Taylor-Johnson 311 Elizabeth Olsen 85 Bryan Cranston 481

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