Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Release Year = 40

View and edit SQL

Suggested facets: Title, Production Company, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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 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 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 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 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 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 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 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 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

CSV options:

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");
Powered by Datasette · Query took 37.63ms · Data source: data.sfgov.org