Film_Locations_in_San_Francisco

Data source: data.sfgov.org

149 rows where Distributor = 3 sorted by Actor 1 descending

✎ 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
541 541 Foul Play 99 1978 7 Andrew S. Hallidie Plaza (Market & Powell Streets)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
542 542 Foul Play 99 1978 7 430 Vallejo Street (Telegraph Hill)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
543 543 Foul Play 99 1978 7 24th and Castro Streets (Noe Valley)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
521 521 Forrest Gump 98 1994 48 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. Paramount Pictures 4 Paramount Pictures 3 Robert Zemeckis 89 Eric Roth 90 Tom Hanks 305 Robin Wright 78  
459 459 Escape From Alcatraz 87 1979 44 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Paramount Pictures 4 Paramount Pictures 3 Donald Siegel 79 Richard Tuggle 80 Clint Eastwood 295 Patrick McGoohan 68 Robert Blossom 471
20 20 A Smile Like Yours 8 1997 8 75 California Street   Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
21 21 A Smile Like Yours  9 1997 8 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
22 22 A Smile Like Yours  9 1997 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
23 23 A Smile Like Yours  9 1997 8 San Francisco International Airport SFO has a museum dedicated to aviation history. Paramount Pictures 4 Paramount Pictures 3 Keith Samples 8 Keith Samples & Kevin Meyer 7 Greg Kinnear 243 Lauren Holly 7  
660 660 Jade 126 1995 39 Lombard & Hyde Streets   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
685 685 Jade 126 1995 39 Hall of Justice (850 Bryant Street)   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
706 706 Jade 126 1995 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
707 707 Jade 126 1995 39 Fior d' Italia (601 Union Street at Stockton)   Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
708 708 Jade 126 1995 39 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. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
709 709 Jade 126 1995 39 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
710 710 Jade 126 1995 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
711 711 Jade 126 1995 39 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
712 712 Jade 126 1995 39 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Paramount Pictures 4 Paramount Pictures 3 William Friedkin 117 Joe Eszterhas 24 David Caruso 223 Linda Fiorentino 102 Chazz Palminteri 487
502 502 Fat Man and Little Boy 92 1989 35 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. Paramount Pictures 4 Paramount Pictures 3 Roland Joffe 83 Roland Joffe 85 Paul Newman 214 John Cusack 72  
1334 1334 The Conversation 249 1974 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1335 1335 The Conversation 249 1974 49 Alta Plaza Park (Steiner Street) The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1336 1336 The Conversation 249 1974 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1337 1337 The Conversation 249 1974 49 Alamo Square (Hayes Valley)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1338 1338 The Conversation 249 1974 49 Westin St. Francis Hotel (335 Powell Street, Union Square) 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. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1339 1339 The Conversation 249 1974 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1340 1340 The Conversation 249 1974 49 Saks Fifth Avenue (384 Post Street, Union Square)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1341 1341 The Conversation 249 1974 49 One Embarcadero Center (Financial District)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1342 1342 The Conversation 249 1974 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1343 1343 The Conversation 249 1974 49 Financial District   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1344 1344 The Conversation 249 1974 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1545 1545 Tucker: The Man and His Dream 293 1988 23 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. Lucasfilm 170 Paramount Pictures 3 Francis Ford Coppola 127 Arnold Schulman 253 Jeff Bridges 113 Joan Allen 228 Marin Landau 548
1456 1456 The Presidio 275 1988 23 Washington Street & Waverly Place (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1457 1457 The Presidio 275 1988 23 Sansome Street (The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1458 1458 The Presidio 275 1988 23 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1459 1459 The Presidio 275 1988 23 Montgomery & Vallejo Streets (Telegraph Hill)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1460 1460 The Presidio 275 1988 23 Market & 2nd Streets   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1461 1461 The Presidio 275 1988 23 Hayes & Polk Streets (Civic Center)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1462 1462 The Presidio 275 1988 23 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1463 1463 The Presidio 275 1988 23 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. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1464 1464 The Presidio 275 1988 23 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1465 1465 The Presidio 275 1988 23 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1466 1466 The Presidio 275 1988 23 Civic Center Plaza   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1467 1467 The Presidio 275 1988 23 Battery Street (The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1468 1468 The Presidio 275 1988 23 900 Block of Grant Avenue (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1469 1469 The Presidio 275 1988 23 700 Block of Jackson Street (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1470 1470 The Presidio 275 1988 23 200 Block of Sansome Street (Financial District)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
12 12 48 Hours 4 1982 4     Paramount Pictures 4 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Nick Nolte 19 Eddie Murphy 3 Annette O'Toole 440
676 676 Indiana Jones and the Last Crusade 131 1989 35 Administration Building (Treasure Island) An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Paramount Pictures 4 Paramount Pictures 3 Steven Spielberg 122 Jeffrey Boam 121 Harrison Ford 12 Sean Connery 107  
76 76 Another 48 Hours 21 1990 17     Eddie Murphy Productions 18 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Eddie Murphy 3 Nick Nolte 19  

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