Film_Locations_in_San_Francisco

7 rows where Writer = 30

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
127	127	Bicentennial Man 33	1999 26	City Hall	The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building.	1492 Pictures 29	Buena Vista Pictures 25	Chris Columbus 31	Nicholas Kazan 30	Robin Williams 265
128	128	Bicentennial Man 33	1999 26	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.	1492 Pictures 29	Buena Vista Pictures 25	Chris Columbus 31	Nicholas Kazan 30	Robin Williams 265
129	129	Bicentennial Man 33	1999 26	Treasure Island	An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.	1492 Pictures 29	Buena Vista Pictures 25	Chris Columbus 31	Nicholas Kazan 30	Robin Williams 265
130	130	Bicentennial Man 33	1999 26	Postcard Row, Alamo Square, Hayes Valley	The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire.	1492 Pictures 29	Buena Vista Pictures 25	Chris Columbus 31	Nicholas Kazan 30	Robin Williams 265
131	131	Bicentennial Man 33	1999 26	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.	1492 Pictures 29	Buena Vista Pictures 25	Chris Columbus 31	Nicholas Kazan 30	Robin Williams 265
1013	1013	Patty Hearst 188	1988 23	Bank of America (38th Street at Balboa Street)	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.	Atlantic Entertainment Group 119	Atlantic Releasing Corporation 74	Paul Schrader 157	Nicholas Kazan 30	Natasha Richardson 357	William Forsythe 144	Ving Rhames 505
1014	1014	Patty Hearst 188	1988 23	Postcard Row (Alamo Square, Hayes Valley)	The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire.	Atlantic Entertainment Group 119	Atlantic Releasing Corporation 74	Paul Schrader 157	Nicholas Kazan 30	Natasha Richardson 357	William Forsythe 144	Ving Rhames 505

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