Film_Locations_in_San_Francisco

4 rows where Director = 215

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1420	1420	The House on Telegraph Hill 260	1951 70	Telegraph Hill	Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Robert Wise 215	Elick Moll 226	Richard Basehart 405	Valentina Cortese 198	William Lundigan 534
1421	1421	The House on Telegraph Hill 260	1951 70	Market Street		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Robert Wise 215	Elick Moll 226	Richard Basehart 405	Valentina Cortese 198	William Lundigan 534
1422	1422	The House on Telegraph Hill 260	1951 70	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Robert Wise 215	Elick Moll 226	Richard Basehart 405	Valentina Cortese 198	William Lundigan 534
1423	1423	The House on Telegraph Hill 260	1951 70	1227 Montgomery Street		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Robert Wise 215	Elick Moll 226	Richard Basehart 405	Valentina Cortese 198	William Lundigan 534

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