Film_Locations_in_San_Francisco

8 rows where Release Year = 2

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
9	9	24 Hours on Craigslist 2	2005 2			Yerba Buena Productions 2	Zealot Pictures 1	Michael Ferris Gibson 2		Craig Newmark 238
126	126	Bee Season 32	2005 2			Bee Season Productions 28	Fox Searchlight Pictures 24	Scott McGehee 30	David Siegel 29	Richard Gere 264	Juliette Binoche 28
730	730	Just Like Heaven 143	2005 2			DreamWorks SKG 84	DreamWorks Distribution 59	Mark Waters 131	Peter Tolan 132	Reese Witherspoon 335	Mark Ruffalo 118
975	975	Night of Henna 176	2005 2			Zee Films 111	Illuminare Entertainment 70	Hassan Zee 149	Hassan Zee 153	Joyce Carlin 346	Nancy Carlin 133
1083	1083	Rent 202	2005 2	Treasure Island	An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.	Rent Productions LLC 127	Columbia Pictures 4	Chris Columbus 31	Stephen Chbosky 175	Anthony Rapp 369	Rosario Dawson 155
1330	1330	The Californians 246	2005 2			Parker Film Company 149	Fabrication Films 107	Jonathan Parker 202	Jonathan Parker & Catherine DiNapoli 213	Noah Wyle 396
1515	1515	The Zodiac 286	2005 2			Blackwater Films 167	THINKFilm 104	Alexander Bulkley 234	Alexander Bulkley & Kelley Bulkeley 247	Justin Chambers 423	Robin Tunney 44
1546	1546	Tweek City 294	2005 2			Tweek City LLC 171	Maverick Entertainment Group 116	Eric G. Johnson 239	Eric G. Johnson 254	Giuseppe Andrews 429

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