Film_Locations_in_San_Francisco

Data source: data.sfgov.org

8 rows where Release Year = 53

View and edit SQL

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
623 Guess Who's Coming to Dinner 111 1967 53 Sutter Street between Powell and Mason   Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
624 Guess Who's Coming to Dinner 111 1967 53 San Francisco International Airport SFO has a museum dedicated to aviation history. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
625 Guess Who's Coming to Dinner 111 1967 53 Mel's Drive-In (Corner South Van Ness & Mission St.) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
626 Guess Who's Coming to Dinner 111 1967 53 634 Raycliff Terrace   Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
1032 Point Blank 194 1967 53 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. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 John Boorman 163 Alexander Jacobs 167 Lee Marvin 363 Angie Dickinson 149 Keenan Wynn 509
1033 Point Blank 194 1967 53 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 John Boorman 163 Alexander Jacobs 167 Lee Marvin 363 Angie Dickinson 149 Keenan Wynn 509
1418 The Graduate 259 1967 53 San Francisco Zoo (2701 Sloat Blvd.)   Embassy Pictures Corporation 157 Embassy Pictures Corporation 111 Mike Nichols 214 Calder Willingham 225 Anne Bancroft 404 Dustin Hoffman 197 Katharine Ross 533
1419 The Graduate 259 1967 53 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Embassy Pictures Corporation 157 Embassy Pictures Corporation 111 Mike Nichols 214 Calder Willingham 225 Anne Bancroft 404 Dustin Hoffman 197 Katharine Ross 533

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