Film_Locations_in_San_Francisco

6 rows where Distributor = 10

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
39	39	After the Thin Man 13	1936 12	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	W.S. Van Dyke 12	Frances Goodrich 11	William Powell 247	Myrna Loy 11	James Stewart 432
1032	1032	Point Blank 194	1967 53	Fort Point (Presidio, Golden Gate National Recreation Area)	Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	John Boorman 163	Alexander Jacobs 167	Lee Marvin 363	Angie Dickinson 149	Keenan Wynn 509
1033	1033	Point Blank 194	1967 53	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	John Boorman 163	Alexander Jacobs 167	Lee Marvin 363	Angie Dickinson 149	Keenan Wynn 509
1111	1111	San Francisco 206	1936 12	The Barbary Coast	The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	W.S. Van Dyke 12	Anita Loos 179	Clark Gable 372	Jeanette MacDonald 158	Spencer Tracy 315
1112	1112	San Francisco 206	1936 12	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.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	W.S. Van Dyke 12	Anita Loos 179	Clark Gable 372	Jeanette MacDonald 158	Spencer Tracy 315
1160	1160	Shadow of the Thin Man 214	1941 63	Bay Bridge	Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	W.S. Van Dyke 12	Harry Kurnitz 186	William Powell 247	Myrna Loy 11	Barry Nelson 515

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