Film_Locations_in_San_Francisco

Data source: data.sfgov.org

16 rows where Actor 2 = 231

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1565 1565 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1566 1566 Vertigo 298 1958 72 York Hotel (940 Sutter Street)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1567 1567 Vertigo 298 1958 72 San Francisco Drydock (20th and Illinois Streets)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1568 1568 Vertigo 298 1958 72 Park Hill Sanatorium (351 Buena Vista Avenue East) This location is now a condominium complex. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1569 1569 Vertigo 298 1958 72 Mission San Juan Bautista (2nd & Mariposa Streets)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1570 1570 Vertigo 298 1958 72 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1571 1571 Vertigo 298 1958 72 Gough & Eddy Streets (Western Addition)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1572 1572 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1573 1573 Vertigo 298 1958 72 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. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1574 1574 Vertigo 298 1958 72 Ernie's Restaurant (847 Montgomery Street) Called the "Essex Club" in the film. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1575 1575 Vertigo 298 1958 72 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1576 1576 Vertigo 298 1958 72 Claude Lane at Bush Street   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1577 1577 Vertigo 298 1958 72 California Palace of the Legion of Honor (34th Avenue & Clement, Lincoln Park) Built in 1924, the Legion of Honor is a 3/4 replica of the Parisian Palais de la Legion d'Honneur. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1578 1578 Vertigo 298 1958 72 Brocklebank Apartments (1000 Mason Street)   Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1579 1579 Vertigo 298 1958 72 900 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106
1580 1580 Vertigo 298 1958 72 1007 Gough Street Tennis courts now sit on the site; in the movie the structure was Carlota Valdes' home. Alfred J. Hitchcock Productions 174 Paramount Pictures 3 Alfred Hitchcock 81 Alec Coppel 258 James Stewart 432 Kim Novak 231 Barbara Bel Geddes 106

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