Film_Locations_in_San_Francisco

Data source: data.sfgov.org

31 rows where Distributor = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Production Company, Director, 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
52 52 Alexander's Ragtime Band 16 1938 14 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Henry King 15 Kathryn Scola 14 Tyrone Power 250 Alice Faye 14 Don Ameche 443
53 53 Alexander's Ragtime Band 16 1938 14 San Francisco Bay   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Henry King 15 Kathryn Scola 14 Tyrone Power 250 Alice Faye 14 Don Ameche 443
54 54 Alexander's Ragtime Band 16 1938 14 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Henry King 15 Kathryn Scola 14 Tyrone Power 250 Alice Faye 14 Don Ameche 443
142 142 Big Trouble in Little China 35 1986 28     Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 John Carpenter 33 Gary Goldman 32 Kurt Russell 267 Kim Catrall 30 James Hong 454
640 640 Hello Frisco, Hello 118 1943 54     Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Bruce Humberstone 110 Robert Ellis 109 Alice Faye 14 John Payne 94 Jack Oakie 485
648 648 High Anxiety 122 1977 55 Hyatt Regency Hotel (5 Embarcadero Center)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
649 649 High Anxiety 122 1977 55 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. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
650 650 High Anxiety 122 1977 55 Conservatory of Flowers, Golden Gate Park The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
651 651 High Crimes 123 2002 3 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
653 653 High Crimes 123 2002 3 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
654 654 High Crimes 123 2002 3 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
655 655 High Crimes 123 2002 3 Maiden Lane   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
656 656 High Crimes 123 2002 3 Condor Club (Columbus and Broadway)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
657 657 High Crimes 123 2002 3 Chase H & Q (1 Bush Street at Sansome)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98  
661 661 How Stella Got Her Groove Back 127 1998 18 Marriot Hotel (55 4th Street at Market)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Kevin Rodney Sullivan 118 Terry McMillan 117 Angela Bassett 325 Taye Diggs 103  
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
992 992 Nine to Five 179 1980 34 Albert S. Samuels Clock (856 Market Street between Powell and Stockton)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Colin Higgins 90 Colin Higgins 91 Jane Fonda 349 Lily Tomlin 136 Dolly Parton 504
999 999 Pacific Heights 183 1990 17 Texas & 19th Streets (Potrero Hill)   Morgan Creek Productions 115 Twentieth Century Fox Film Corporation 12 John Schlesinger 152 Daniel Pyne 158 Melanie Griffith 353 Matthew Modine 140  
1000 1000 Pacific Heights 183 1990 17 Financial District   Morgan Creek Productions 115 Twentieth Century Fox Film Corporation 12 John Schlesinger 152 Daniel Pyne 158 Melanie Griffith 353 Matthew Modine 140  
1001 1001 Pacific Heights 183 1990 17 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Morgan Creek Productions 115 Twentieth Century Fox Film Corporation 12 John Schlesinger 152 Daniel Pyne 158 Melanie Griffith 353 Matthew Modine 140  
1282 1282 Swingin' Along 237 1961 47 Powell Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Charles Barton 195 Jameson Brewer 207 Tommy Noonan 393 Barbara Eden 181 Peter Marshall 526
1424 1424 The Internship 261 2013 27 Grant Ave from Sacramento to Clay   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1425 1425 The Internship 261 2013 27 Montgomery and Union St.   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1426 1426 The Internship 261 2013 27 Epic Roasthouse   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1427 1427 The Internship 261 2013 27 Players Arcade at Pier 39   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535

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