Film_Locations_in_San_Francisco

10 rows where Actor 1 = 113

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
504	504	Fearless 94	1993 46	400 Montgomery Street		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
505	505	Fearless 94	1993 46	Folsom Street & Embarcadero		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
506	506	Fearless 94	1993 46	Varennes Alley between Filbert and Union		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
507	507	Fearless 94	1993 46	St. Peter & Paul's Church (666 Filbert Street, Washington Square)	Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials.	Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
508	508	Fearless 94	1993 46	San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill)	SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County.	Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
509	509	Fearless 94	1993 46	Kohl Building (400 Montgomery Street)		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
510	510	Fearless 94	1993 46	Bank of America Building (555 California Street)	The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast.	Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
511	511	Fearless 94	1993 46	90 Gold Street		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
512	512	Fearless 94	1993 46	5th and Beale Streets		Spring Creek Productions 68	Warner Bros. Pictures 6	Peter Weir 85	Rafael Yglesias 86	Jeff Bridges 113	Isabella Rosellini 74	Rosie Perez 475
1545	1545	Tucker: The Man and His Dream 293	1988 23	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.	Lucasfilm 170	Paramount Pictures 3	Francis Ford Coppola 127	Arnold Schulman 253	Jeff Bridges 113	Joan Allen 228	Marin Landau 548

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