Film_Locations_in_San_Francisco

Data source: data.sfgov.org

28 rows where Actor 2 = 69, Distributor = 43 and Release Year = 20

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
460 Etruscan Smile 88 2017 20 Treasure Island   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
461 Etruscan Smile 88 2017 20 Andronico's, 1200 Irving Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
462 Etruscan Smile 88 2017 20 Mudpie, 2185 Fillmore Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
463 Etruscan Smile 88 2017 20 Hooker Alley Garden on Mason between Bush & Pine   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
464 Etruscan Smile 88 2017 20 Broadway @ Jones Streets   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
465 Etruscan Smile 88 2017 20 Outpost Studios, 69 Green Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
466 Etruscan Smile 88 2017 20 Legion of Honor, 100 34th Ave California Palace of the Legion of Honor was completed in 1924, and on Armistice Day of that year the doors opened to the public. In keeping with the wishes of the donors, to “honor the dead while serving the living,” it was accepted by the city of San Francisco as a museum of fine arts dedicated to the memory of the 3,600 California men who had lost their lives on the battlefields of France during World War I. Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
467 Etruscan Smile 88 2017 20 UCSF Mt Zion 1600 Divisadero   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
468 Etruscan Smile 88 2017 20 343 Union Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
469 Etruscan Smile 88 2017 20 Pier 39 San Francisco   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
470 Etruscan Smile 88 2017 20 Pier 14 San Francisco   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
471 Etruscan Smile 88 2017 20 Chaya / Perry's 132 Embarcadero   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
472 Etruscan Smile 88 2017 20 Castle Street @ Green Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
473 Etruscan Smile 88 2017 20 1227 Montgomery Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
474 Etruscan Smile 88 2017 20 San Francisco City Hall The museum party interiors were shot in the Historic San Francisco City Hall. Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
475 Etruscan Smile 88 2017 20 San Francisco Airport   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
476 Etruscan Smile 88 2017 20 Benu Restaurant, 22 Hawthorne Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
477 Etruscan Smile 88 2017 20 California Street between Front and Davis   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
478 Etruscan Smile 88 2017 20 Jones @ Broadway   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
479 Etruscan Smile 88 2017 20 Bentley Reserve, 301 Battery Street The Bentley Reserve is the former San Francisco Federal Reserve. Designed by architect George W. Kelham and completed in 1924, the building has been a prominent landmark of the Financial District for 89 years. Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
480 Etruscan Smile 88 2017 20 St Regis Hotel, 125 3rd Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
481 Etruscan Smile 88 2017 20 Marriott Marquis, 780 Mission Street The Marriott Marquis opened on October 17, 1989, the day of the Loma Prieta earthquake.[7] With better earthquake proofing than several nearby hotels, the building only lost a single window.[7] Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
482 Etruscan Smile 88 2017 20 Laguna Honda Hospital, 375 Laguna Honda Blvd.   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
483 Etruscan Smile 88 2017 20 Turk Street between Mason & Leavenworth   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
484 Etruscan Smile 88 2017 20 California Street between Sansome & Davis   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
485 Etruscan Smile 88 2017 20 3rd Street between Market & Harrison   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
486 Etruscan Smile 88 2017 20 Mason Street @ Vallejo   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472
487 Etruscan Smile 88 2017 20 225 California Street   Po Valley Productions, LLC 65 TBD 43 Oded Binnun/ Michel Brezis 80 Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 Brian Cox 300 Roseanne Arquette 69 Thora Birch 472

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