Film_Locations_in_San_Francisco

5 rows where Director = 103

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
623	623	Guess Who's Coming to Dinner 111	1967 53	Sutter Street between Powell and Mason		Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
624	624	Guess Who's Coming to Dinner 111	1967 53	San Francisco International Airport	SFO has a museum dedicated to aviation history.	Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
625	625	Guess Who's Coming to Dinner 111	1967 53	Mel's Drive-In (Corner South Van Ness & Mission St.)	This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd.	Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
626	626	Guess Who's Coming to Dinner 111	1967 53	634 Raycliff Terrace		Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
994	994	On the Beach 181	1959 60			Stanley Kramer Productions 113	United Artists 19	Stanley Kramer 103	John Paxton 156	Gregory Peck 351	Ava Gardner 138	Fred Astaire 362

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