Film_Locations_in_San_Francisco

Data source: data.sfgov.org

28 rows where Production Company = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
156 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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