Film_Locations_in_San_Francisco

12 rows where Actor 1 = 271

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
184	184	Boys and Girls 39	2000 25	1122 Folsom Street		Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
185	185	Boys and Girls 39	2000 25	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.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
186	186	Boys and Girls 39	2000 25	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.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
187	187	Boys and Girls 39	2000 25	Fisherman's Wharf	Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
188	188	Boys and Girls 39	2000 25	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
189	189	Boys and Girls 39	2000 25	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
190	190	Boys and Girls 39	2000 25	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.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
191	191	Boys and Girls 39	2000 25	Lombard Street	Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
192	192	Boys and Girls 39	2000 25	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
193	193	Boys and Girls 39	2000 25	Aquatic Park (Jefferson Street)	Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
194	194	Boys and Girls 39	2000 25	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
195	195	Boys and Girls 39	2000 25	628 Cole Street		Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34

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