home / fivethirtyeight

Bob Ross: elements-by-episode.csv

This table contains data behind the story A Statistical Analysis of the Work of Bob Ross.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

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

View and edit SQL

Link rowid EPISODE TITLE APPLE_FRAME AURORA_BOREALIS BARN BEACH BOAT BRIDGE BUILDING BUSHES CABIN CACTUS CIRCLE_FRAME CIRRUS CLIFF CLOUDS CONIFER CUMULUS DECIDUOUS DIANE_ANDRE DOCK DOUBLE_OVAL_FRAME FARM FENCE FIRE FLORIDA_FRAME FLOWERS FOG FRAMED GRASS GUEST HALF_CIRCLE_FRAME HALF_OVAL_FRAME HILLS LAKE LAKES LIGHTHOUSE MILL MOON MOUNTAIN MOUNTAINS NIGHT OCEAN OVAL_FRAME PALM_TREES PATH PERSON PORTRAIT RECTANGLE_3D_FRAME RECTANGULAR_FRAME RIVER ROCKS SEASHELL_FRAME SNOW SNOWY_MOUNTAIN SPLIT_FRAME STEVE_ROSS STRUCTURE SUN TOMB_FRAME TREE TREES TRIPLE_FRAME WATERFALL WAVES WINDMILL WINDOW_FRAME WINTER WOOD_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

Advanced export

JSON shape: default, array

CSV options:

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 67.417ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub