Film_Locations_in_San_Francisco

Data source: data.sfgov.org

12 rows where Director = 27

View and edit SQL

Suggested facets: Title, Release Year, Production Company, Distributor, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
113 Beaches 29 1988 23     Silver Screen Partners IV 26 Columbia Broadcasting System 22 Garry Marshall 27 Mary Agnes Donoghue 26 Bette Midler 261 Barbara Hershey 25 John Heard 451
1034 Pretty Woman 195 1990 17     Touchstone Pictures 104 Buena Vista Pictures 25 Garry Marshall 27 J.F. Lawton 168 Richard Gere 264 Julia Roberts 150  
1452 The Other Sister 273 1999 26 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. Mandeville Films 161 Buena Vista Pictures 25 Garry Marshall 27 Garry Marshall 236 Juliette Lewis 413 Diane Keaton 147  
1453 The Other Sister 273 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. Mandeville Films 161 Buena Vista Pictures 25 Garry Marshall 27 Garry Marshall 236 Juliette Lewis 413 Diane Keaton 147  
1454 The Other Sister 273 1999 26 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Mandeville Films 161 Buena Vista Pictures 25 Garry Marshall 27 Garry Marshall 236 Juliette Lewis 413 Diane Keaton 147  
1471 The Princess Diaries 276 2001 33 724 Brazil Avenue   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1472 The Princess Diaries 276 2001 33 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1473 The Princess Diaries 276 2001 33 Firestation #3 (Brazil Avenue and Athens Street)   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1474 The Princess Diaries 276 2001 33 Cliff House (1090 Point Lobos Avenue) The Musee Mechanique, which Julie Andrews' character visits in the movie, was at the time housed under the Cliff House. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1475 The Princess Diaries 276 2001 33 Broadway Tunnel (Broadway between Powell and Larkin)   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1476 The Princess Diaries 276 2001 33 Baker Beach   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1477 The Princess Diaries 276 2001 33 2601 Lyon Street   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  

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