Film_Locations_in_San_Francisco

Data source: data.sfgov.org

28 rows where Actor 3 = 457, Title = 38 and Writer = 35

View and edit SQL

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

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