Film_Locations_in_San_Francisco

7 rows where Director = 72

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
429	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	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	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	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	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	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	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

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");