Film_Locations_in_San_Francisco

Data source: data.sfgov.org

23 rows where Writer = 180

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Fun Facts

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1114 1114 Sense8 208 2015 10 18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March" Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1115 1115 Sense8 208 2015 10 Atlas Café, 3049 20th St. Dialogue scene inside the café Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1116 1116 Sense8 208 2015 10 Clarion Alley between Valencia & Mission St. Ladies discuss their relationship in the mural alley Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1117 1117 Sense8 208 2015 10 Harrison & 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1118 1118 Sense8 208 2015 10 Folsom Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1119 1119 Sense8 208 2015 10 16th St. Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1120 1120 Sense8 208 2015 10 S. Van Ness Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1121 1121 Sense8 208 2015 10 22nd St. Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1122 1122 Sense8 208 2015 10 Harrison Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1123 1123 Sense8 208 2015 10 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1124 1124 Sense8 208 2015 10 Z Space Studios; 450 Florida St. Filming of the "Fresh Meat" Festival Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1125 1125 Sense8 208 2015 10 375 Castro St. and 17th between Castro and Diamond St. Chase sequence on bicycles ends at gas station Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1126 1126 Sense8 208 2015 10 Corbett St. Bicycle chase scene, actors dressed as fake officers present Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1127 1127 Sense8 208 2015 10 Romain St. Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1128 1128 Sense8 208 2015 10 Market St. overpass Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1129 1129 Sense8 208 2015 10 Grand View Ave. Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1130 1130 Sense8 208 2015 10 Vallejo Street Garage; 766 Vallejo St. dialogue scene on top of a garage roof Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1131 1131 Sense8 208 2015 10 Laguna Honda Hospital; 375 Laguna Honda Blvd. dialogue scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1132 1132 Sense8 208 2015 10 Irving St. at 9th Ave. continuous driving shots of a taxi going with the flow of existing traffic Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1134 1134 Sense8 208 2015 10 Dolores Park, 20th St. between Church & Dolores St. group of friends have a heated argument, then flashback of pre-argument Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1135 1135 Sense8 208 2015 10 Palace of Fine Arts: 3306 Lyon St. Filming of "Dyke's on Bikes" and "Dyke March" Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1136 1136 Sense8 208 2015 10 Van Ness and 12th St. A couple reminisces on the moment they first fell in love Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1137 1137 Sense8 208 2015 10 "Metzger's Apt" 151 Alice B. Toklas Pl. Overnight scene involving aggressive arguments between actors, spfx shoot out involved Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    

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