Film_Locations_in_San_Francisco

Data source: data.sfgov.org

25 rows where Release Year = 44

✎ View and edit SQL

This data as json, CSV (advanced)

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
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
1518 1518 Time After Time 289 1979 44 Lombard & Laguna Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1519 1519 Time After Time 289 1979 44 Lombard & Fillmore Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1520 1520 Time After Time 289 1979 44 Lombard & Divisadero Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1521 1521 Time After Time 289 1979 44 Lombard & Broderick Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1522 1522 Time After Time 289 1979 44 Justin Herman Plaza   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1523 1523 Time After Time 289 1979 44 Intersection of Fulton & 6th Streets (Chinatown)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1524 1524 Time After Time 289 1979 44 Intersection of California & Grant Streets (Richmond District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1525 1525 Time After Time 289 1979 44 Hyatt Regency Hotel (5 Embarcadero Center)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1526 1526 Time After Time 289 1979 44 Huntington Park (California & Taylor Streets, Nob Hill) The mansion of Arabella Huntington, widow of railroad magnate Collis P. Huntington, was destroyed in the 1906 earthquake and fire. Mrs. Huntington the donated the land on which the park now stands to the city. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1527 1527 Time After Time 289 1979 44 Golden Gate Park Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1528 1528 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1529 1529 Time After Time 289 1979 44 Ghirardelli Square (900 North Point Street, Fisherman's Wharf) In 1893, chocolatier Domingo Ghirardelli bought an entire city block to house the headquarters of Ghirardelli Chocolates. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1530 1530 Time After Time 289 1979 44 Chestnut & Divisadero Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1531 1531 Time After Time 289 1979 44 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1532 1532 Time After Time 289 1979 44 Broadway at Osgood Street (North Beach)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1533 1533 Time After Time 289 1979 44 2340 Francisco Street   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1534 1534 Time After Time 289 1979 44 100 Block of Union Street (Cow Hollow)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1535 1535 Time After Time 289 1979 44 Old St. Mary's Church (660 California Street at Grant)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1536 1536 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1537 1537 Time After Time 289 1979 44 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1538 1538 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1539 1539 Time After Time 289 1979 44 One Embarcadero Center (Financial District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1540 1540 Time After Time 289 1979 44 Merchant Exchange (465 California Street at Leidesdorff)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1541 1541 Time After Time 289 1979 44 Marina Green (Marina District) Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546

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