Film_Locations_in_San_Francisco

Data source: data.sfgov.org

27 rows where Distributor = 51

✎ View and edit SQL

This data as json, CSV (advanced)

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
544 544 Freebie and the Bean 100 1974 49 Alco Plaza   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
545 545 Freebie and the Bean 100 1974 49 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area "called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
546 546 Freebie and the Bean 100 1974 49 TransAmerica Pyramid (600 Montgomery Street) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
547 547 Freebie and the Bean 100 1974 49 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
548 548 Freebie and the Bean 100 1974 49 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
549 549 Freebie and the Bean 100 1974 49 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
550 550 Freebie and the Bean 100 1974 49 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
551 551 Freebie and the Bean 100 1974 49 Hyatt Regency Hotel (5 Embarcadero Center)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
552 552 Freebie and the Bean 100 1974 49 Folsom Street (SOMA)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
553 553 Freebie and the Bean 100 1974 49 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. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
554 554 Freebie and the Bean 100 1974 49 Embarcadero Freeway   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
555 555 Freebie and the Bean 100 1974 49 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
556 556 Freebie and the Bean 100 1974 49 Broadway and Columbus Avenue (North Beach)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
1072 1072 Red Widow 201 2013 27 York & 24th St.   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1073 1073 Red Widow 201 2013 27 2nd St & Howard   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1074 1074 Red Widow 201 2013 27 Montgomery & Market Streets   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1075 1075 Red Widow 201 2013 27 Broadway & Taylor   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1076 1076 Red Widow 201 2013 27 Mason & Sacramento St   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1077 1077 Red Widow 201 2013 27 Geary & 27th Ave   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1078 1078 Red Widow 201 2013 27 Geary & 20th Ave   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1079 1079 Red Widow 201 2013 27 Pioneer Park at Coit Tower   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1080 1080 Red Widow 201 2013 27 Vallejo Street Garage   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1081 1081 Red Widow 201 2013 27 California & Davis St   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1082 1082 Red Widow 201 2013 27 Golden Gate Ave & Jones   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1332 1332 The Competition 248 1980 34 Pier 39   Columbia Pictures Corporation 5 American Broadcasting Company (ABC) 51 Joel Oliansky 204 Joel Oliansky 215 Richard Dreyfuss 252 Amy Irving 190 Lee Remick 57
1333 1333 The Competition 248 1980 34 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. Columbia Pictures Corporation 5 American Broadcasting Company (ABC) 51 Joel Oliansky 204 Joel Oliansky 215 Richard Dreyfuss 252 Amy Irving 190 Lee Remick 57
1433 1433 The Laughing Policeman 264 1973 16     Twentieth Century Fox Film Corporation 13 American Broadcasting Company (ABC) 51 Stuart Rosenberg 219 Thomas Rickman 230 Walter Matthau 408 Bruce Dern 70 Louis Gossett Jr. 538

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