Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Director = 193 and Distributor = 6

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1271 Sweet November 235 2001 33 Marquee Lofts (1000 Van Ness Avenue at Alice B. Toklas Place)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1272 Sweet November 235 2001 33 Hotel Majestic (1500 Sutter Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1273 Sweet November 235 2001 33 Foote, Cone & Belding (733 Front Street at Pacific) The building is called "Jabe & Dunne Advertising Agency" in the movie. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1274 Sweet November 235 2001 33 Farley's Café (1315 18th Street Near Missouri)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1275 Sweet November 235 2001 33 Citicorp Center (1 Sansome Street at Sutter)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1276 Sweet November 235 2001 33 Christopher's Books (1400 18th Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1277 Sweet November 235 2001 33 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1278 Sweet November 235 2001 33 Blooms Saloon (18th Street between Missouri and Texas Streets)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  
1279 Sweet November 235 2001 33 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Pat O'Connor 193 Paul Yurick 205 Keanu Reeves 391 Charlize Theron 180  

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