Film_Locations_in_San_Francisco

Data source: data.sfgov.org

5 rows where Actor 2 = 82

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
558 George of the Jungle 102 1997 8 755 Vallejo Street   Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
559 George of the Jungle 102 1997 8 The Tamalpais Building (1201 Greenwich Street at Hyde)   Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
560 George of the Jungle 102 1997 8 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
561 George of the Jungle 102 1997 8 First Bank (550 Montgomery Street at Commercial) Called "Stanhope Bank" in the film. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
562 George of the Jungle 102 1997 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  

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