Film_Locations_in_San_Francisco

Data source: data.sfgov.org

13 rows where Production Company = 147

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1312 The Bachelor 241 1999 26 Merchant Exchange (465 California Street at Leidesdorff)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1314 The Bachelor 241 1999 26 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1315 The Bachelor 241 1999 26 Sutter-Stockton Garage (330 Sutter Street at Stockton) Garage roof serves as a heliport in the movie George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1316 The Bachelor 241 1999 26 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1317 The Bachelor 241 1999 26 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1318 The Bachelor 241 1999 26 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1319 The Bachelor 241 1999 26 Roof of Cable Car (California at Front Street) SF Cable Cars are the only moving National Historical Landmark. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1320 The Bachelor 241 1999 26 Pacific Stock Exchange (301 Pine Street at Sansome)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1321 The Bachelor 241 1999 26 Nina M. Designs (52 2nd Street at Jessie)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1322 The Bachelor 241 1999 26 Moose's Restaurant (1652 Stockton)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1323 The Bachelor 241 1999 26 Mama's Restaurant (1701 Stockton)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1324 The Bachelor 241 1999 26 Danilo's Bakery (Green Street & Bannam Place)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1325 The Bachelor 241 1999 26 Columbus Avenue at Green & Stockton   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  

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