Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Writer = 27

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
114 Beautiful Boy 30 2018 24 Divisadero between Broadway and Greenwich   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
115 Beautiful Boy 30 2018 24 Ohloff Recovery Center (601 Steiner St)   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
116 Beautiful Boy 30 2018 24 Haight at Masonic   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
117 Beautiful Boy 30 2018 24 Tenderloin Neighborhood   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
118 Beautiful Boy 30 2018 24 Olympic Flame Café, 555 Geary St   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
119 Beautiful Boy 30 2018 24 18th St at San Bruno Ave.   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
120 Beautiful Boy 30 2018 24 Wisconsin between 19th and 20th St   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452

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