Film_Locations_in_San_Francisco

13 rows where Distributor = 17

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
90	90	Babies 24	2010 19			Canal+ 21	Focus Features 17	Thomas Balmes 22	Thomas Balmes 21	Bayar 257	Hattie 20
887	887	Milk 166	2008 59	Duboce Park		Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
888	888	Milk 166	2008 59	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.	Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
889	889	Milk 166	2008 59	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
890	890	Milk 166	2008 59	424 Sansome Street		Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
891	891	Milk 166	2008 59	29th and Dolores Street		Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
892	892	Milk 166	2008 59	El Camino Del Mar		Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
893	893	Milk 166	2008 59	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.	Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
894	894	Milk 166	2008 59	Market & Castro Street	From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.	Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
895	895	Milk 166	2008 59	Marine Fireman's Union Headquarters		Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
896	896	Milk 166	2008 59	Lower Haight Street		Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
898	898	Milk 166	2008 59	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.	Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128
899	899	Milk 166	2008 59	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.	Focus Features 106	Focus Features 17	Gus Van Sant 142	Dustin Lance Black 145	Sean Penn 40	Emile Hirsch 128

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