Film_Locations_in_San_Francisco

4 rows where Actor 1 = 416

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1478	1478	The Pursuit of Happyness 277	2006 68	Glen Park Subway Station		Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1479	1479	The Pursuit of Happyness 277	2006 68	Glide Memorial Church (434 Ellis St)		Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1480	1480	The Pursuit of Happyness 277	2006 68	Candlestick Park (602 Jamestown Ave.)	Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park.	Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213
1482	1482	The Pursuit of Happyness 277	2006 68	Golden Gate Park Children's Playground	Golden Gate Park is similar in shape but 20% larger than New York's Central Park.	Columbia Pictures Corporation 5	Columbia Pictures 4	Steven Conrad 227	Gabriele Muccino 202	Will Smith 416	Jayden C. Smith 213

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