Film_Locations_in_San_Francisco

Data source: data.sfgov.org

37 rows where Writer = 35

View and edit SQL

Suggested facets: 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
156 Blue Jasmine 38 2013 27 Jones & Pacific   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
157 Blue Jasmine 38 2013 27 Pacific & Divisadero   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
158 Blue Jasmine 38 2013 27 Lombard & Hyde   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
159 Blue Jasmine 38 2013 27 5546 Geary Ave   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
160 Blue Jasmine 38 2013 27 2898 Broadway   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
161 Blue Jasmine 38 2013 27 Motel Capri   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
162 Blue Jasmine 38 2013 27 Marina Green   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
163 Blue Jasmine 38 2013 27 Ocean Beach at Lincoln   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
164 Blue Jasmine 38 2013 27 Heald College   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
165 Blue Jasmine 38 2013 27 Marina Blvd from Laguna to Baker   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
166 Blue Jasmine 38 2013 27 330 Santa Clara Ave.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
167 Blue Jasmine 38 2013 27 200 Post St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
168 Blue Jasmine 38 2013 27 2179 48th Ave   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
169 Blue Jasmine 38 2013 27 The Ramp Restaurant   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
170 Blue Jasmine 38 2013 27 303-305 S. Van Ness   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
171 Blue Jasmine 38 2013 27 3563 20th St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
172 Blue Jasmine 38 2013 27 Taylor & Green St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
173 Blue Jasmine 38 2013 27 Grant & Washington St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
174 Blue Jasmine 38 2013 27 2934 24th St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
175 Blue Jasmine 38 2013 27 1138 Alabama St   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
176 Blue Jasmine 38 2013 27 South Park   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
177 Blue Jasmine 38 2013 27 2915 16th St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
178 Blue Jasmine 38 2013 27 Trolley Car from Market and 11th   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
179 Blue Jasmine 38 2013 27 Real Guitars   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
180 Blue Jasmine 38 2013 27 Aub Zam Zam Bar   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
181 Blue Jasmine 38 2013 27 790 Ulloa   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
182 Blue Jasmine 38 2013 27 SFO International Airport Terminal 3   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
183 Blue Jasmine 38 2013 27 2178 Palou Ave.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
1023 Play it Again, Sam 191 1972 62 Balboa at 22nd Avenue   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1024 Play it Again, Sam 191 1972 62 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) The theater closed in 1985. Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1025 Play it Again, Sam 191 1972 62 Surf Theater (4520 Irving Street)   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1026 Play it Again, Sam 191 1972 62 Hyde Street Cable Car   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1027 Play it Again, Sam 191 1972 62 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1028 Play it Again, Sam 191 1972 62 15-17 Fresno Street   Paramount Pictures 4 Paramount Pictures 3 Herbert Ross 160 Woody Allen 35 Woody Allen 360 Diane Keaton 147 Tony Roberts 507
1283 Take the Money and Run 238 1969 66 Mission Street   American Broadcasting Company (ABC) 144 Cinerama Releasing Corporation 103 Woody Allen 36 Woody Allen 35 Woody Allen 360 Janet Margolin 182  
1284 Take the Money and Run 238 1969 66 Golden Gate Park   American Broadcasting Company (ABC) 144 Cinerama Releasing Corporation 103 Woody Allen 36 Woody Allen 35 Woody Allen 360 Janet Margolin 182  
1285 Take the Money and Run 238 1969 66 Bank of America (1455 Stockton Street)   American Broadcasting Company (ABC) 144 Cinerama Releasing Corporation 103 Woody Allen 36 Woody Allen 35 Woody Allen 360 Janet Margolin 182  

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