Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Actor 1 = 265, Actor 2 = 100 and Director = 31

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
905 Mrs. Doubtfire 170 1993 46 1200 Washington Street at Taylor Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
906 Mrs. Doubtfire 170 1993 46 Hancock School (940 Filbert Street)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
907 Mrs. Doubtfire 170 1993 46 Danilo's Bakery (Green Street & Bannam Place)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
908 Mrs. Doubtfire 170 1993 46 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
909 Mrs. Doubtfire 170 1993 46 520-522A Green Street at Grant Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
910 Mrs. Doubtfire 170 1993 46 516 Green Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501
911 Mrs. Doubtfire 170 1993 46 100 Embarcadero Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Chris Columbus 31 Randi Mayem Singer 149 Robin Williams 265 Sally Field 100 Pierce Brosnan 501

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