Film_Locations_in_San_Francisco

Data source: data.sfgov.org

32 rows where Director = 111

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Fun Facts, Production Company, Distributor, 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
641 641 Hemingway & Gelhorn 119 2011 1 Muni Metro East (501 Cesar Chavez)   Attaboy Films, For Whom Productions, Home Box Office (HBO) 81 Home Box Office (HBO) 57 Philip Kaufman 111 Jerry Stahl & Barbara Turner 110 Nicole Kidman 320 Clive Owen 95  
684 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1133 1133 Twisted 209 2004 5 Pier 24   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1483 1483 The Right Stuff 279 1983 65 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1484 1484 The Right Stuff 279 1983 65 Cow Palace Supposedly, the Cow Palace's name derives from a newspaper editorial in which the writer wonders whether the soon-to-be-built structure for livestock was a "palace for cows". The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1485 1485 The Right Stuff 279 1983 65 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. The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1486 1486 The Right Stuff 279 1983 65 Financial District   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1547 1547 Twisted 209 2004 5 Red's Java House (Pier 30-32, The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1548 1548 Twisted 209 2004 5 Piers 30-32   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1549 1549 Twisted 209 2004 5 Pier 39   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1550 1550 Twisted 209 2004 5 Mojito (1337-1339 Grant Avenue)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1551 1551 Twisted 209 2004 5 McCovey Point, China Basin Park (24 Willy Mays Plaza)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1552 1552 Twisted 209 2004 5 Veterans' War Memorial Building (401 Van Ness Avenue)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1553 1553 Twisted 209 2004 5     Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1554 1554 Twisted 209 2004 5 La Bodega (1332 Grant Avenue at Vallejo)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1555 1555 Twisted 209 2004 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1556 1556 Twisted 209 2004 5 The Saloon (1232 Grant Avenue)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  

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