Film_Locations_in_San_Francisco

4 rows where Director = 233

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1511	1511	The Woman In Red 285	1984 40	Postcard Row (Alamo Square, Hayes Valley)	The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire.	Orion Pictures Corp. 166	MGM Home Entertainment 79	Gene Wilder 233	Jean Loup Dabadie & Yves Robert 246	Gene Wilder 422	Charles Grodin 221
1512	1512	The Woman In Red 285	1984 40	Brocklebank Apartments (1000 Mason Street)		Orion Pictures Corp. 166	MGM Home Entertainment 79	Gene Wilder 233	Jean Loup Dabadie & Yves Robert 246	Gene Wilder 422	Charles Grodin 221
1513	1513	The Woman In Red 285	1984 40	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.	Orion Pictures Corp. 166	MGM Home Entertainment 79	Gene Wilder 233	Jean Loup Dabadie & Yves Robert 246	Gene Wilder 422	Charles Grodin 221
1514	1514	The Woman In Red 285	1984 40	Montgomery Street at Union Street		Orion Pictures Corp. 166	MGM Home Entertainment 79	Gene Wilder 233	Jean Loup Dabadie & Yves Robert 246	Gene Wilder 422	Charles Grodin 221

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