Film_Locations_in_San_Francisco

Data source: data.sfgov.org

8 rows where Release Year = 2

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
9 24 Hours on Craigslist 2 2005 2     Yerba Buena Productions 2 Zealot Pictures 1 Michael Ferris Gibson 2   Craig Newmark 238    
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 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 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 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 The Californians 246 2005 2     Parker Film Company 149 Fabrication Films 107 Jonathan Parker 202 Jonathan Parker & Catherine DiNapoli 213 Noah Wyle 396    
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 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

CSV options:

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");
Powered by Datasette · Query took 33.683ms · Data source: data.sfgov.org