Film_Locations_in_San_Francisco

14 rows where Actor 1 = 178

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
375	375	Class Action 65	1991 37	Mission Dolores (3321 16th Street, Mission District)	Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes.	Interscope Communications 49	Twentieth Century Fox Film Corp. 13	Michael Apted 59	Carolyn Shelby 59	Gene Hackman 178	Mary Elizabeth Mastrantonio 47
376	376	Class Action 65	1991 37	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.	Interscope Communications 49	Twentieth Century Fox Film Corp. 13	Michael Apted 59	Carolyn Shelby 59	Gene Hackman 178	Mary Elizabeth Mastrantonio 47
377	377	Class Action 65	1991 37	Bix Restaurant (56 Gold Street)		Interscope Communications 49	Twentieth Century Fox Film Corp. 13	Michael Apted 59	Carolyn Shelby 59	Gene Hackman 178	Mary Elizabeth Mastrantonio 47
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

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