Film_Locations_in_San_Francisco

Data source: data.sfgov.org

11 rows where Actor 1 = 368

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1072 Red Widow 201 2013 27 York & 24th St.   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1073 Red Widow 201 2013 27 2nd St & Howard   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1074 Red Widow 201 2013 27 Montgomery & Market Streets   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1075 Red Widow 201 2013 27 Broadway & Taylor   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1076 Red Widow 201 2013 27 Mason & Sacramento St   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1077 Red Widow 201 2013 27 Geary & 27th Ave   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1078 Red Widow 201 2013 27 Geary & 20th Ave   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1079 Red Widow 201 2013 27 Pioneer Park at Coit Tower   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1080 Red Widow 201 2013 27 Vallejo Street Garage   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1081 Red Widow 201 2013 27 California & Davis St   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513
1082 Red Widow 201 2013 27 Golden Gate Ave & Jones   Beyond Pix 126 American Broadcasting Company (ABC) 51 Alon Aranya 167 Melissa Rosenberg 174 Radha Mitchell 368 Sterling Beaumon 154 Clifton Collins Jr. 513

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