Film_Locations_in_San_Francisco

Data source: data.sfgov.org

32 rows where Distributor = 19

View and edit SQL

Suggested facets: Title, Release Year, 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
98 Barbary Coast 26 1935 21     The Samuel Goldwyn Company 23 United Artists 19 Howard Hawks 24 Ben Hecht 23 Mariam Hopkins 259 Edward G. Robinson 22 Joel McCrea 448
143 Birdman of Alcatraz 36 1962 29 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Norma Productions 31 United Artists 19 John Frankenheimer 34 Guy Trosper 33 Burt Lancaster 268 Karl Maden 31 Thelma Ritter 455
144 Birdman of Alcatraz 36 1962 29 Pier 43 1/2   Norma Productions 31 United Artists 19 John Frankenheimer 34 Guy Trosper 33 Burt Lancaster 268 Karl Maden 31 Thelma Ritter 455
389 D.O.A 71 1950 15 Powell & California Streets   Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
390 D.O.A 71 1950 15 Southern Pacific Memorial Hospital (1400 Fell Street)   Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
391 D.O.A 71 1950 15 The Embarcadero/ Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
392 D.O.A 71 1950 15 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
393 D.O.A 71 1950 15 Westin St. Francis Hotel (335 Powell Street) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
394 D.O.A 71 1950 15 Chambord Apartments (1298 Sacramento Street at Jones)   Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
395 D.O.A 71 1950 15 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
396 D.O.A 71 1950 15 Market & Steuart Streets (Financial District)   Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
397 D.O.A 71 1950 15 Market Street (from 6th- 4th Streets)   Cardinal Pictures 54 United Artists 19 Rudolph Mate 65 Russell Rouse 64 Edmond O'Brien 288 Pamela Britton 53 Luther Adler 464
684 Invasion of the Body Snatchers 134 1978 7 Pier 33 (Embarcadero)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
686 Invasion of the Body Snatchers 134 1978 7 Department of Public Health (101 Grove Street at Polk, Civic Center)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
687 Invasion of the Body Snatchers 134 1978 7 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
688 Invasion of the Body Snatchers 134 1978 7 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
689 Invasion of the Body Snatchers 134 1978 7 San Francisco Drydock (20th and Illinois Streets)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
690 Invasion of the Body Snatchers 134 1978 7 Ramada Plaza Hotel Downtown (1231 Market Street, Civic Center)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
691 Invasion of the Body Snatchers 134 1978 7 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. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
692 Invasion of the Body Snatchers 134 1978 7 Lafayette Park (Pacific Heights)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
693 Invasion of the Body Snatchers 134 1978 7 Hamlin Hotel (385 Eddy Street)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
694 Invasion of the Body Snatchers 134 1978 7 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
695 Invasion of the Body Snatchers 134 1978 7 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
696 Invasion of the Body Snatchers 134 1978 7 Broadway Tunnel (Russian Hill)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
697 Invasion of the Body Snatchers 134 1978 7 Bimbo's 365 Club (1025 Columbus Avenue, North Beach)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
698 Invasion of the Body Snatchers 134 1978 7 720 Steiner Street (Hayes Valley)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
699 Invasion of the Body Snatchers 134 1978 7 32 Napier Lane   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
700 Invasion of the Body Snatchers 134 1978 7 1227 Montgomery Street (Telegraph Hill)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
994 On the Beach 181 1959 60     Stanley Kramer Productions 113 United Artists 19 Stanley Kramer 103 John Paxton 156 Gregory Peck 351 Ava Gardner 138 Fred Astaire 362
1451 The Organization 272 1971 42     The Mirisch Corporation 160 United Artists 19 Don Medford 224 James R. Webb 235 Sidney Poitier 90 Barbara McNair 209  
1516 They Call Me MISTER Tibbs 287 1970 74     Mirisch Corporation 168 United Artists 19 Gordon Douglas 235 Alan R. Trustman 39 Sidney Poitier 90 Martin Landau 222 Barbara McNair 209
1621 Yours, Mine and Ours 306 1968 31     Desilu Productions 179 United Artists 19 Melville Shavelson 249 Bob Carroll, Jr. 265 Lucille Ball 437 Henry Fonda 236 Van Johnson 551

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