Film_Locations_in_San_Francisco

5 rows where Distributor = 6 and Release Year = 7

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
16	16	A Night Full of Rain 7	1978 7	Embarcadero Freeway	Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake)	Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
17	17	A Night Full of Rain 7	1978 7	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.	Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
18	18	A Night Full of Rain 7	1978 7	San Francisco Chronicle (901 Mission Street at 15th Street)	The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices.	Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
19	19	A Night Full of Rain 7	1978 7	Broadway (North Beach)		Liberty Film 7	Warner Bros. Pictures 6	Lina Wertmuller 7	Lina Wertmuller 6	Candice Bergen 242	Giancarlo Gianni 6
1269	1269	Superman 233	1978 7	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.	Dovemead Films 142	Warner Bros. Pictures 6	Richard Donner 192	Jerry Siegel 203	Christopher Reeve 389	Gene Hackman 178	Marlon Brando 524

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