Film_Locations_in_San_Francisco

7 rows where Director = 27 and Release Year = 33

Search:

descending

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