Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Writer = 72

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
429 Doctor Dolittle 79 1998 18 Webster Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
430 Doctor Dolittle 79 1998 18 Telegraph Hill Blvd (Telegraph Hill)   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
431 Doctor Dolittle 79 1998 18 Larkin & Hyde Streets   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
432 Doctor Dolittle 79 1998 18 Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
433 Doctor Dolittle 79 1998 18 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
434 Doctor Dolittle 79 1998 18 2107 Union Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  
435 Doctor Dolittle 79 1998 18 2100 Green Street   Twentieth Century Fox Film Cooperation 60 Twentieth Century Fox Film Cooperation 45 Betty Thomas 72 Nat Mauldin 72 Eddie Murphy 3 Ossie Davis 61  

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