Film_Locations_in_San_Francisco

9 rows where Actor 1 = 301

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
488	488	Experiment in Terror 89	1962 29	George Washington High School (600 32nd Avenue )		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
489	489	Experiment in Terror 89	1962 29	Wells Fargo Bank (1 California Street, Financial District)		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
490	490	Experiment in Terror 89	1962 29	The Sea Captain's Chest (Fisherman's Wharf)		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
491	491	Experiment in Terror 89	1962 29	Sheraton Palace Hotel (2 Montgomery Street, Financial District)	The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909.	Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
492	492	Experiment in Terror 89	1962 29	Roaring Twenties Nightclub (555 Broadway at Columbus)		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
493	493	Experiment in Terror 89	1962 29	Candlestick Park	Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park.	Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
494	494	Experiment in Terror 89	1962 29	2632 Larkin Street at Lombard		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
495	495	Experiment in Terror 89	1962 29	100 St. Germain Avenue		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473
496	496	Experiment in Terror 89	1962 29	1 Montgomery Street at Post		Columbia Pictures Corporation 5	Columbia Pictures 4	Blake Edwards 69	The Gordons 82	Glenn Ford 301	Lee Remick 57	Stefanie Powers 473

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