Film_Locations_in_San_Francisco

7 rows where Actor 1 = 354

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1002	1002	Pal Joey 184	1957 61	Spreckels Mansion (2080 Washington Street, Pacific Heights)		Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1003	1003	Pal Joey 184	1957 61	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.	Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1004	1004	Pal Joey 184	1957 61	Barbary Coast	The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business.	Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1429	1429	The Lady from Shanghai 263	1947 41	Steinhart Aquarium (California Academy of Sciences, Golden Gate Park)	The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1430	1430	The Lady from Shanghai 263	1947 41	Mandarin Theatre (1021 Grant Avenue)	The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1431	1431	The Lady from Shanghai 263	1947 41	Golden Gate Park	The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1432	1432	The Lady from Shanghai 263	1947 41	Former Hall of Justice (750 Kearny Street at Washington)		Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537

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