Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Actor 2 = 213, Distributor = 4 and Production Company = 5

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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 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 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 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

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 32.537ms · Data source: data.sfgov.org