Film_Locations_in_San_Francisco

Data source: data.sfgov.org

41 rows where Actor 2 = 122

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
737 Looking 148 2014 11 222 Mason St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
738 Looking 148 2014 11 Golden Gate Bridge   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
739 Looking 148 2014 11 Presidio Church at 130 Fisher Loop   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
740 Looking 148 2014 11 Tiburon Hiking Trail, Tiburon, CA   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
741 Looking 148 2014 11 Fort Funston   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
742 Looking 148 2014 11 Folsom Street Fair on Folsom St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
743 Looking 148 2014 11 Orphan Andy's   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
744 Looking 148 2014 11 The Stud   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
745 Looking 148 2014 11 Mr. S Leather   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
746 Looking 148 2014 11 2866 24th St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
747 Looking 148 2014 11 24th and Church St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
748 Looking 148 2014 11 Church and Duboce Muni Station   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
749 Looking 148 2014 11 St. Francis Fountain   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
750 Looking 148 2014 11 Muni line N- Judah   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
751 Looking 148 2014 11 Sutro Baths   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
752 Looking 148 2014 11 Golden Gate Park   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
753 Looking 148 2014 11 Market & Church St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
754 Looking 148 2014 11 Willy's Barber Shop   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
755 Looking 148 2014 11 Jawbone at 99 Rhode Island St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
756 Looking 148 2014 11 Urban Flowers   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
757 Looking 148 2014 11 770 Haight St   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
758 Looking 148 2014 11 Eros   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
759 Looking 148 2014 11 Doc's Clock   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
760 Looking 148 2014 11 Starbucks at 333 O'Farrell St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
761 Looking 148 2014 11 Union Square   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
762 Looking 148 2014 11 The Café at 2369 Market St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
763 Looking 148 2014 11 Castro St. from Market to 18th St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
764 Looking 148 2014 11 Bay Bridge   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
765 Looking 148 2014 11 Treasure Island   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
766 Looking 148 2014 11 The Fairmont   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
767 Looking 148 2014 11 1890 Clay St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
768 Looking 148 2014 11 2000 Folsom   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
769 Looking 148 2014 11 Mission Arts Center   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
770 Looking 148 2014 11 2413 Harrison St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
771 Looking 148 2014 11 Muddy Waters Coffee House   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
772 Looking 148 2014 11 Valencia St. from 16th to 17th   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
773 Looking 148 2014 11 601 Buena Vista West   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
774 Looking 148 2014 11 Dolores Park   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
775 Looking 148 2014 11 Casa Lucas Market at 2934 24th St   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
776 Looking 148 2014 11 Punjab   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496
777 Looking 148 2014 11 BART from Civic Center to 24th St.   Mission Street Productions, LLC 101 Home Box Office (HBO) 57 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie J. Alvarez 122 Murray Bartlett 496

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