Film_Locations_in_San_Francisco

Data source: data.sfgov.org

17 rows where Release Year = 18

View and edit SQL

Suggested facets: Title, Locations, Fun Facts, Distributor, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
88 Around the Fire 22 1998 18 Ocean Beach On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. Paradigm Studio 19 Ardustry Home Entertainment 15 John Jacobsen 20 John Comerford 19 Tara Reid 255    
374 City of Angels 64 1998 18 San Francisco Public Library Main Branch (100 Larkin Street)   Atlas Entertainment 48 Warner Bros. Pictures 6 Brad Silberling 58 Dana Stevens 58 Nicolas Cage 216 Meg Ryan 46  
410 Desperate Measures 76 1998 18     Mandalay Entertainment 57 TriStar Pictures 20 Barbet Schroeder 70 David Klass 69 Michael Keaton 293 Andy Garcia 58 Raven-Symone 469
429 Doctor Dolittle 79 1998 18 Webster Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
430 Doctor Dolittle 79 1998 18 Telegraph Hill Blvd (Telegraph Hill)   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
431 Doctor Dolittle 79 1998 18 Larkin & Hyde Streets   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
432 Doctor Dolittle 79 1998 18 Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
433 Doctor Dolittle 79 1998 18 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. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
434 Doctor Dolittle 79 1998 18 2107 Union Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
435 Doctor Dolittle 79 1998 18 2100 Green Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
661 How Stella Got Her Groove Back 127 1998 18 Marriot Hotel (55 4th Street at Market)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Kevin Rodney Sullivan 118 Terry McMillan 117 Angela Bassett 325 Taye Diggs 103  
1010 Patch Adams 187 1998 18 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1011 Patch Adams 187 1998 18 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1012 Patch Adams 187 1998 18 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1212 Sphere 223 1998 18 S.S. Jeremiah O'Brien   Constant c Productions 137 Warner brothers Pictures 84 Barry Levinson 185 Kurt Wimmer 194 Dustin Hoffman 197 Sharon Stone 23  
1455 The Parent Trap 274 1998 18 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Nancy Meyers 225 Nancy Meyers 237 Lindsay Lohan 414 Dennis Quaid 210  
1581 What Dreams May Come 299 1998 18 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 Vincent Ward 243 Ron Bass 259 Robin Williams 265 Cuba Gooding, Jr. 232  

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