Film_Locations_in_San_Francisco

Data source: data.sfgov.org

15 rows where Director = 31, Distributor = 13 and Title = 178

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
977 Nine Months 178 1995 39 The Malloch Apartment Building (1360 Montgomery Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
978 Nine Months 178 1995 39 Wasteland Store (1600 Haight Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
979 Nine Months 178 1995 39 Star's Café (55 Golden Gate Avenue at Van Ness)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
980 Nine Months 178 1995 39 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
981 Nine Months 178 1995 39 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
982 Nine Months 178 1995 39 Pierce Street between Pacific & Green Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
983 Nine Months 178 1995 39 Montgomery & Vallejo Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
984 Nine Months 178 1995 39 Marathon Plaza (303 2nd Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
985 Nine Months 178 1995 39 Jones Street at Bush   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
986 Nine Months 178 1995 39 Jack Kerouac Alley between Columbus & Grant Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
987 Nine Months 178 1995 39 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
988 Nine Months 178 1995 39 Belli Building (722 Montgomery Street at Washington)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
989 Nine Months 178 1995 39 Alamo Square   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
990 Nine Months 178 1995 39 60 Spear Street   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
991 Nine Months 178 1995 39 101 Henry Adams Place, 4th Floor   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265

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 35.266ms · Data source: data.sfgov.org