Film_Locations_in_San_Francisco

12 rows where Director = 27 sorted by Director

Search:

descending

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

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