Film_Locations_in_San_Francisco

6 rows where Actor 2 = 167

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1165	1165	Sister Act 218	1992 22	St. Paul's Church (Church Street, Noe Valley)		Touchstone Pictures 104	Buena Vista Pictures 25	Emile Ardolino 180	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167
1166	1166	Sister Act 2: Back in the Habit 219	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.	Touchstone Pictures 104	Buena Vista Pictures 25	Bill Duke 181	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167
1167	1167	Sister Act 2: Back in the Habit 219	1993 46	Maritime Museum, Building 201 (Fort Mason)		Touchstone Pictures 104	Buena Vista Pictures 25	Bill Duke 181	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167
1168	1168	Sister Act 2: Back in the Habit 219	1993 46	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.	Touchstone Pictures 104	Buena Vista Pictures 25	Bill Duke 181	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167
1169	1169	Sister Act 2: Back in the Habit 219	1993 46	CCSF Alemany Campus		Touchstone Pictures 104	Buena Vista Pictures 25	Bill Duke 181	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167
1170	1170	Sister Act 2: Back in the Habit 219	1993 46	Carnelian Room, Bank of America Building (555 California Street, 53rd Floor)	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.	Touchstone Pictures 104	Buena Vista Pictures 25	Bill Duke 181	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167

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