Film_Locations_in_San_Francisco

Data source: data.sfgov.org

6 rows where Distributor = 10

View and edit SQL

Suggested facets: Title, Release Year, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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 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 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 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 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 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

CSV options:

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");
Powered by Datasette · Query took 32.633ms · Data source: data.sfgov.org