Film_Locations_in_San_Francisco

13 rows where Writer = 210

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1312	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	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	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	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	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	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	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	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	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	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	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	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	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

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");