Film_Locations_in_San_Francisco

5 rows where Writer = 99

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
611	611	Golden Gate 107	1994 48	Ross Alley (Chinatown)	Ross Alley is the oldest alley in San Francisco.	American Playhouse Theatrical Films 75	The Samuel Goldwyn Company 54	John Madden 99	David Henry Hwang 99	Matt Dillon 312	Joan Chen 86
612	612	Golden Gate 107	1994 48	University of California Hastings College of the Law		Metro-Goldwyn-Mayer (MGM) 71	Metro-Goldwyn-Mayer (MGM) 52	Howard Deutch 95	David Henry Hwang 99	Matt Dillon 312	Joan Chen 86
613	613	Golden Gate 107	1994 48	Bush Street (between Grant & Kearny Streets)		American Playhouse Theatrical Films 75	The Samuel Goldwyn Company 54	John Madden 99	David Henry Hwang 99	Matt Dillon 312	Joan Chen 86
614	614	Golden Gate 107	1994 48	Buena Vista Park (Haight Street at Buena Vista)	Established in 1867, Buena Vista Park is the oldest official park in San Francisco.	American Playhouse Theatrical Films 75	The Samuel Goldwyn Company 54	John Madden 99	David Henry Hwang 99	Matt Dillon 312	Joan Chen 86
615	615	Golden Gate 107	1994 48	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.	American Playhouse Theatrical Films 75	The Samuel Goldwyn Company 54	John Madden 99	David Henry Hwang 99	Matt Dillon 312	Joan Chen 86

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