Film_Locations_in_San_Francisco

Data source: data.sfgov.org

23 rows where Writer = 222

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Production Company, Distributor, Director, 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
1393 1393 The Enforcer 255 1976 45 Sutter & Webster Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1394 1394 The Enforcer 255 1976 45 Hall of Justice   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1395 1395 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1396 1396 The Enforcer 255 1976 45 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1397 1397 The Enforcer 255 1976 45 Balmy Street (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1398 1398 The Enforcer 255 1976 45 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1399 1399 The Enforcer 255 1976 45 24th Street Mini Park (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1400 1400 The Enforcer 255 1976 45 23rd & Capp Streets (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1401 1401 The Enforcer 255 1976 45 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1434 1434 The Lineup 265 1958 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1435 1435 The Lineup 265 1958 72 The Embarcadero   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1436 1436 The Lineup 265 1958 72 Sutro Baths (Point Lobos Avenue)   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1437 1437 The Lineup 265 1958 72 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1438 1438 The Lineup 265 1958 72 Pier 41   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1439 1439 The Lineup 265 1958 72 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1440 1440 The Lineup 265 1958 72 2090 Jackson Street   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1481 1481 The Towering Inferno 278 1974 49 2898 Vallejo Street   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1497 1497 The Towering Inferno 278 1974 49 Bank of America Building (555 California Street, Financial District) 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. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1498 1498 The Towering Inferno 278 1974 49 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1499 1499 The Towering Inferno 278 1974 49 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1500 1500 The Towering Inferno 278 1974 49 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1501 1501 The Towering Inferno 278 1974 49 Firestation #38 (California & Laguna)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1502 1502 The Towering Inferno 278 1974 49 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. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542

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