Film_Locations_in_San_Francisco

13 rows where Title = 100

Search:

descending

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

Advanced export

JSON shape: default, array, newline-delimited

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");