Film_Locations_in_San_Francisco

Data source: data.sfgov.org

33 rows where Release Year = 39

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Production Company, Distributor, 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
380 380 Copycat 68 1995 39 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
381 381 Copycat 68 1995 39 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
382 382 Copycat 68 1995 39 Sound Factory (1st and Harrison Streets)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
383 383 Copycat 68 1995 39 Java House (Pier 40, Embarcadero)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
384 384 Copycat 68 1995 39 Alta Plaza Park The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
385 385 Copycat 68 1995 39 82 & 67 Rico Way (Marina District)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
660 660 Jade 126 1995 39 Lombard & Hyde Streets   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
685 685 Jade 126 1995 39 Hall of Justice (850 Bryant Street)   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
706 706 Jade 126 1995 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
707 707 Jade 126 1995 39 Fior d' Italia (601 Union Street at Stockton)   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
708 708 Jade 126 1995 39 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. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
709 709 Jade 126 1995 39 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
710 710 Jade 126 1995 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
711 711 Jade 126 1995 39 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
712 712 Jade 126 1995 39 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
977 977 Nine Months 178 1995 39 The Malloch Apartment Building (1360 Montgomery Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
978 978 Nine Months 178 1995 39 Wasteland Store (1600 Haight Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
979 979 Nine Months 178 1995 39 Star's Café (55 Golden Gate Avenue at Van Ness)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
980 980 Nine Months 178 1995 39 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
981 981 Nine Months 178 1995 39 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
982 982 Nine Months 178 1995 39 Pierce Street between Pacific & Green Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
983 983 Nine Months 178 1995 39 Montgomery & Vallejo Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
984 984 Nine Months 178 1995 39 Marathon Plaza (303 2nd Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
985 985 Nine Months 178 1995 39 Jones Street at Bush   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
986 986 Nine Months 178 1995 39 Jack Kerouac Alley between Columbus & Grant Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
987 987 Nine Months 178 1995 39 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
988 988 Nine Months 178 1995 39 Belli Building (722 Montgomery Street at Washington)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
989 989 Nine Months 178 1995 39 Alamo Square   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
990 990 Nine Months 178 1995 39 60 Spear Street   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
991 991 Nine Months 178 1995 39 101 Henry Adams Place, 4th Floor   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
1005 1005 Panther 185 1995 39     Gramercy Pictures 116 PolyGram Video 72 Mario Van Peebles 154 Mario Van Peebles 160 Kadeem Hardison 355 Bookeem Woodbine 142  
1448 1448 The Net 270 1995 39 Moscone Convention Center   Columbia Pictures Corp. 93 Columbia Pictures 4 Irwin Winkler 223 John Brancato 224 Sandra Bullock 411 Jeremy Northam 207  
1449 1449 The Net 270 1995 39 Montgomery & Market Streets   Columbia Pictures Corp. 93 Columbia Pictures 4 Irwin Winkler 223 John Brancato 224 Sandra Bullock 411 Jeremy Northam 207  

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 43.355ms · Data source: data.sfgov.org