Film_Locations_in_San_Francisco

4 rows where Writer = 107

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1
633	633	Heart and Souls 116	1993 46	Stockton Tunnel (Stockton Street at Sutter Street)	Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area.	Universal Pictures 15	Electric Parc 55	Tomas Gislason 108	Tomas Gislason 107	Jorgen Leth 319
634	634	Heart and Souls 116	1993 46	2810 Pacific Avenue		Universal Pictures 15	Electric Parc 55	Tomas Gislason 108	Tomas Gislason 107	Jorgen Leth 319
635	635	Heart and Souls 116	1993 46	War Memorial Opera House (401 Van Ness Avenue)	In 1945 the United Nations had its first conference at The War Memorial Opera House.	Universal Pictures 15	Electric Parc 55	Tomas Gislason 108	Tomas Gislason 107	Jorgen Leth 319
636	636	Heart and Souls 116	1993 46	Conservatory of Flowers (Golden Gate Park)	The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere.	Universal Pictures 15	Electric Parc 55	Tomas Gislason 108	Tomas Gislason 107	Jorgen Leth 319

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