Film_Locations_in_San_Francisco

Data source: data.sfgov.org

16 rows where Actor 2 = 193

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1375 The Diary of a Teenage Girl 252 2015 10 Victoria Theatre   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1376 The Diary of a Teenage Girl 252 2015 10 SPECS' Twelve Adler Museum Café   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1377 The Diary of a Teenage Girl 252 2015 10 Ocean Beach at Point Lobos   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1378 The Diary of a Teenage Girl 252 2015 10 700 Kansas St.   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1379 The Diary of a Teenage Girl 252 2015 10 Presidio Branch Library   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1380 The Diary of a Teenage Girl 252 2015 10 The Royal Oak   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1381 The Diary of a Teenage Girl 252 2015 10 Tonic   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1382 The Diary of a Teenage Girl 252 2015 10 Polk and Northpoint St.   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1383 The Diary of a Teenage Girl 252 2015 10 770 Haight St.   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1384 The Diary of a Teenage Girl 252 2015 10 Tank Hill Park   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1385 The Diary of a Teenage Girl 252 2015 10 Hamburger Haven   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1386 The Diary of a Teenage Girl 252 2015 10 Higher Grounds Coffee House   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1387 The Diary of a Teenage Girl 252 2015 10 304 Lily St.   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1388 The Diary of a Teenage Girl 252 2015 10 The Magazine at 920 Larkin   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1389 The Diary of a Teenage Girl 252 2015 10 Geary St. from Polk to Larkin   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531
1390 The Diary of a Teenage Girl 252 2015 10 Yerba Buena Island   Diary the Movie, LLC 153 Sony Pictures Classics 27 Marielle Heller 207 Marielle Heller 219 Alexander Skarsgard 399 Kristen Wiig 193 Christopher Meloni 531

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