Film_Locations_in_San_Francisco

14 rows where Actor 1 = 3

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
76	76	Another 48 Hours 21	1990 17			Eddie Murphy Productions 18	Paramount Pictures 3	Walter Hill 4	Walter Hill 3	Eddie Murphy 3	Nick Nolte 19
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
439	439	Dr. Dolittle 2 82	2001 33	West Chrissy Field (Presidio, Golden Gate National Recreation Area)	This movie was the first to film in the revamped Chrissy Field Picnic Area.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
440	440	Dr. Dolittle 2 82	2001 33	Sacramento St., Between Pierce & Broderick Streets		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
441	441	Dr. Dolittle 2 82	2001 33	Hyde Street & Lombard Street		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
442	442	Dr. Dolittle 2 82	2001 33	Building 924, Presidio (Golden Gate National Recreation Area)	In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
443	443	Dr. Dolittle 2 82	2001 33	Broadway, Between Franklin & Laguna Streets		Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Steve Carr 75	Larry Levin 75	Eddie Murphy 3	Kristen Wilson 63
885	885	Metro 164	1997 8	Bush Street at Jones		Touchstone Pictures 104	Buena Vista Pictures 25	Thomas Carter 140	Randy Feldman 143	Eddie Murphy 3

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