home / fivethirtyeight

bob-ross/elements-by-episode

2 rows where CLOUDS = 1, EPISODE starts with "S03" and MOUNTAIN = 1

View and edit SQL

This data as .json, .jsono

rowidEPISODETITLEAPPLE_FRAMEAURORA_BOREALISBARNBEACHBOATBRIDGEBUILDINGBUSHESCABINCACTUSCIRCLE_FRAMECIRRUSCLIFFCLOUDSCONIFERCUMULUSDECIDUOUSDIANE_ANDREDOCKDOUBLE_OVAL_FRAMEFARMFENCEFIREFLORIDA_FRAMEFLOWERSFOGFRAMEDGRASSGUESTHALF_CIRCLE_FRAMEHALF_OVAL_FRAMEHILLSLAKELAKESLIGHTHOUSEMILLMOONMOUNTAINMOUNTAINSNIGHTOCEANOVAL_FRAMEPALM_TREESPATHPERSONPORTRAITRECTANGLE_3D_FRAMERECTANGULAR_FRAMERIVERROCKSSEASHELL_FRAMESNOWSNOWY_MOUNTAINSPLIT_FRAMESTEVE_ROSSSTRUCTURESUNTOMB_FRAMETREETREESTRIPLE_FRAMEWATERFALLWAVESWINDMILLWINDOW_FRAMEWINTERWOOD_FRAMED
31 S03E05 "DISTANT HILLS" 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
39 S03E13 "PEACEFUL WATERS" 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 1 1 0 0 0 0 0 0 0
CREATE TABLE "bob-ross/elements-by-episode" (
"EPISODE" TEXT,
  "TITLE" TEXT,
  "APPLE_FRAME" INTEGER,
  "AURORA_BOREALIS" INTEGER,
  "BARN" INTEGER,
  "BEACH" INTEGER,
  "BOAT" INTEGER,
  "BRIDGE" INTEGER,
  "BUILDING" INTEGER,
  "BUSHES" INTEGER,
  "CABIN" INTEGER,
  "CACTUS" INTEGER,
  "CIRCLE_FRAME" INTEGER,
  "CIRRUS" INTEGER,
  "CLIFF" INTEGER,
  "CLOUDS" INTEGER,
  "CONIFER" INTEGER,
  "CUMULUS" INTEGER,
  "DECIDUOUS" INTEGER,
  "DIANE_ANDRE" INTEGER,
  "DOCK" INTEGER,
  "DOUBLE_OVAL_FRAME" INTEGER,
  "FARM" INTEGER,
  "FENCE" INTEGER,
  "FIRE" INTEGER,
  "FLORIDA_FRAME" INTEGER,
  "FLOWERS" INTEGER,
  "FOG" INTEGER,
  "FRAMED" INTEGER,
  "GRASS" INTEGER,
  "GUEST" INTEGER,
  "HALF_CIRCLE_FRAME" INTEGER,
  "HALF_OVAL_FRAME" INTEGER,
  "HILLS" INTEGER,
  "LAKE" INTEGER,
  "LAKES" INTEGER,
  "LIGHTHOUSE" INTEGER,
  "MILL" INTEGER,
  "MOON" INTEGER,
  "MOUNTAIN" INTEGER,
  "MOUNTAINS" INTEGER,
  "NIGHT" INTEGER,
  "OCEAN" INTEGER,
  "OVAL_FRAME" INTEGER,
  "PALM_TREES" INTEGER,
  "PATH" INTEGER,
  "PERSON" INTEGER,
  "PORTRAIT" INTEGER,
  "RECTANGLE_3D_FRAME" INTEGER,
  "RECTANGULAR_FRAME" INTEGER,
  "RIVER" INTEGER,
  "ROCKS" INTEGER,
  "SEASHELL_FRAME" INTEGER,
  "SNOW" INTEGER,
  "SNOWY_MOUNTAIN" INTEGER,
  "SPLIT_FRAME" INTEGER,
  "STEVE_ROSS" INTEGER,
  "STRUCTURE" INTEGER,
  "SUN" INTEGER,
  "TOMB_FRAME" INTEGER,
  "TREE" INTEGER,
  "TREES" INTEGER,
  "TRIPLE_FRAME" INTEGER,
  "WATERFALL" INTEGER,
  "WAVES" INTEGER,
  "WINDMILL" INTEGER,
  "WINDOW_FRAME" INTEGER,
  "WINTER" INTEGER,
  "WOOD_FRAMED" INTEGER
)
Powered by Datasette · Query took 2.527ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub