Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Actor 1 = 323

View and edit SQL

Suggested facets: Title, Release Year

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
648 High Anxiety 122 1977 55 Hyatt Regency Hotel (5 Embarcadero Center)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
649 High Anxiety 122 1977 55 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. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
650 High Anxiety 122 1977 55 Conservatory of Flowers, Golden Gate Park The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
651 High Crimes 123 2002 3 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
653 High Crimes 123 2002 3 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
654 High Crimes 123 2002 3 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
655 High Crimes 123 2002 3 Maiden Lane   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
656 High Crimes 123 2002 3 Condor Club (Columbus and Broadway)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
657 High Crimes 123 2002 3 Chase H & Q (1 Bush Street at Sansome)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  

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