Film_Locations_in_San_Francisco

9 rows where Release Year = 40

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
386	386	Crackers 69	1984 40	24th Street between Mission Street and Potrero Avenue		Universal Pictures 15	Universal Pictures 41	Louis Malle 63	Jeffrey Fiskin 62	Donald Sutherland 286	Jack Warden 51	Sean Penn 40
387	387	Crackers 69	1984 40	La Rondalla (Valencia and 20th Streets)		Universal Pictures 15	Universal Pictures 41	Louis Malle 63	Jeffrey Fiskin 62	Donald Sutherland 286	Jack Warden 51	Sean Penn 40
629	629	Hard to Hold 114	1984 40	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.	Universal Pictures 15	Universal Pictures 41	Larry Peerce 106	Thomas Hedley, Jr. 106	Rick Springfield 317
1496	1496	The Times of Harvey Milk 283	1984 40	The Castro	From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.	UCLA Film and Television Archive 164	TC Films International 114	Rob Epstein 60	Rob Epstein 244	Harvey Milk 420	Harvey Firestein 219	Anne Kronenberg 544
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
1517	1517	Thief of Hearts 288	1984 40			Paramount Pictures 4	Paramount Pictures 3	Douglas Day Stewart 236	Douglas Day Stewart 248	Steven Bauer 424	David Caruso 223	Barbara Williams 545

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