Film_Locations_in_San_Francisco

Data source: data.sfgov.org

28 rows where Director = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Fun Facts, Production Company, Distributor, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
127 127 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
128 128 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
129 129 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
130 130 Bicentennial Man 33 1999 26 Postcard Row, Alamo Square, Hayes Valley The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
131 131 Bicentennial Man 33 1999 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
905 905 Mrs. Doubtfire 170 1993 46 1200 Washington Street at Taylor Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
906 906 Mrs. Doubtfire 170 1993 46 Hancock School (940 Filbert Street)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
907 907 Mrs. Doubtfire 170 1993 46 Danilo's Bakery (Green Street & Bannam Place)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
908 908 Mrs. Doubtfire 170 1993 46 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
909 909 Mrs. Doubtfire 170 1993 46 520-522A Green Street at Grant Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
910 910 Mrs. Doubtfire 170 1993 46 516 Green Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
911 911 Mrs. Doubtfire 170 1993 46 100 Embarcadero Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
977 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1083 1083 Rent 202 2005 2 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. Rent Productions LLC 127 Columbia Pictures 4 Chris Columbus 31 Stephen Chbosky 175 Anthony Rapp 369 Rosario Dawson 155  

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