Film_Locations_in_San_Francisco

7 rows where Actor 3 = 542

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1481	1481	The Towering Inferno 278	1974 49	2898 Vallejo Street		Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542
1497	1497	The Towering Inferno 278	1974 49	Bank of America Building (555 California Street, Financial District)	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.	Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542
1498	1498	The Towering Inferno 278	1974 49	San Francisco Fire Station 38 (2150 California Street, Pacific Heights)		Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542
1499	1499	The Towering Inferno 278	1974 49	Hyatt Regency Hotel (5 Embarcadero Center, Financial District)		Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542
1500	1500	The Towering Inferno 278	1974 49	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.	Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542
1501	1501	The Towering Inferno 278	1974 49	Firestation #38 (California & Laguna)		Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542
1502	1502	The Towering Inferno 278	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.	Irwin Allen Productions 162	Twentieth Century - Fox 112	John Guillermin 228	Stirling Silliphant 222	Steve McQueen 273	Paul Newman 214	William Holden 542

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