Film_Locations_in_San_Francisco

5 rows where Director = 141

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
886	886	Midnight Lace 165	1960 58	Fairmont Hotel (950 Mason Street, Nob Hill)	In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.	Arwin Productions 105	Universal Pictures 41	David Miller 141	Ivan Goff 144	Doris Day 341	Rex Harrison 127	John Gavin 500
1240	1240	Sudden Fear 230	1952 64	Lombard Street	Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd.	Joseph Kaufmann Pictures 140	RKO Pictures 87	David Miller 141	Lenore J. Coffee 201	Joan Crawford 387	Jack Palance 175	Gloria Grahame 521
1241	1241	Sudden Fear 230	1952 64	The Tamalpais Building (1201 Greenwich Street at Hyde)		Joseph Kaufmann Pictures 140	RKO Pictures 87	David Miller 141	Lenore J. Coffee 201	Joan Crawford 387	Jack Palance 175	Gloria Grahame 521
1242	1242	Sudden Fear 230	1952 64	Brocklebank Apartments (1000 Mason Street)		Joseph Kaufmann Pictures 140	RKO Pictures 87	David Miller 141	Lenore J. Coffee 201	Joan Crawford 387	Jack Palance 175	Gloria Grahame 521
1243	1243	Sudden Fear 230	1952 64	2800 Scott Street		Joseph Kaufmann Pictures 140	RKO Pictures 87	David Miller 141	Lenore J. Coffee 201	Joan Crawford 387	Jack Palance 175	Gloria Grahame 521

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