Film_Locations_in_San_Francisco

Data source: data.sfgov.org

48 rows where Distributor = 43

✎ 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
404 404 Pushing Dead 74 2016 30 2930 3rd Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
452 452 Pushing Dead 74 2016 30 Hayes Street between Ashbury and Shrader   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
460 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
897 897 Pushing Dead 74 2016 30 1069 Tennessee Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1036 1036 Pushing Dead 74 2016 30 Blind Cat, 3050 24th Street, San Francisco Pushing Dead won the Audience Award for Frameline San Francisco International LGBTQ Film Festival 2016 Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1037 1037 Pushing Dead 74 2016 30 Cordova Market, 301 Rolph Street, San Francisco   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1038 1038 Pushing Dead 74 2016 30 915 Naples, San Francisco   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1039 1039 Pushing Dead 74 2016 30 Infield Batting Cages, 1888 Clement Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1040 1040 Pushing Dead 74 2016 30 42 Walter Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1041 1041 Pushing Dead 74 2016 30 Church Street MUNI Station   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1042 1042 Pushing Dead 74 2016 30 Double Happiness Health, 3380 20th Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1043 1043 Pushing Dead 74 2016 30 Ele Nino Traiing Cetner, 2920 3rd Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1044 1044 Pushing Dead 74 2016 30 Matching Half Café, 1799 McAllister Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1045 1045 Pushing Dead 74 2016 30 433 Baker Street,   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1046 1046 Pushing Dead 74 2016 30 Mission Neibhrohood Health Cetner, 240 Shotweel Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1047 1047 Pushing Dead 74 2016 30 Octavia at Grove Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1048 1048 Pushing Dead 74 2016 30 Koshland Park   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1049 1049 Pushing Dead 74 2016 30 Daniel's Pharmacy, 943 Geneva Ave   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1050 1050 Pushing Dead 74 2016 30 5th Ave @ Fulton Street in Golden Gate Park   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1051 1051 Pushing Dead 74 2016 30 Uva Enoteca, 568 Haight Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1052 1052 Pushing Dead 74 2016 30 Turk Street between Steiner and Scott Streets   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467

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