Film_Locations_in_San_Francisco

7 rows where Director = 158

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1015	1015	Petulia 189	1968 31	Japanese Tea Garden, Hagiwara Tea Garden Drive, Golden Gate Park	The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden	Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506
1016	1016	Petulia 189	1968 31	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.	Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506
1017	1017	Petulia 189	1968 31	Pier 43 1/2		Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506
1018	1018	Petulia 189	1968 31	Cala Foods (California Street and Hyde)		Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506
1019	1019	Petulia 189	1968 31	307 Filbert Street		Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506
1020	1020	Petulia 189	1968 31	2417 Franklin Street		Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506
1021	1021	Petulia 189	1968 31	Fort Point (Presidio, Golden Gate National Recreation Area)	Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF.	Warner Brothers / Seven Arts 120	Warner Brothers / Seven Arts 75	Richard Lester 158	Lawrence B. Marcus 163	Julie Christie 358	George C. Scott 145	Richard Chamberlain 506

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