Film_Locations_in_San_Francisco

6 rows where Release Year = 47

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
518	518	Flower Drum Song 96	1961 47	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.	Fields Productions 69	Universal Pictures 41	Henry Koster 87	Joseph Fields 88	Nancy Kwan 304	James Shigeta 76	Benson Fong 476
519	519	Flower Drum Song 96	1961 47	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	Fields Productions 69	Universal Pictures 41	Henry Koster 87	Joseph Fields 88	Nancy Kwan 304	James Shigeta 76	Benson Fong 476
1030	1030	Pleasure of His Company 193	1961 47	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.	Perlsea Company 122	Paramount Pictures 3	George Seaton 162	Samuel A. Taylor 166	Fred Astaire 362	Debbie Reynolds 130	Lilli Palmer 508
1031	1031	Pleasure of His Company 193	1961 47	2700 Vallejo Street (Pacific Heights)		Perlsea Company 122	Parmaount Pictures 76	George Seaton 162	Samuel A. Taylor 166	Fred Astaire 362	Debbie Reynolds 130	Lilli Palmer 508
1270	1270	Susan Slade 234	1961 47	On Board the SS President Cleveland, docked at Pier 50		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves 204	Troy Donahue 390	Connie Stevens 179	Dorothy McGuire 525
1282	1282	Swingin' Along 237	1961 47	Powell Street		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Charles Barton 195	Jameson Brewer 207	Tommy Noonan 393	Barbara Eden 181	Peter Marshall 526

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