Bob Ross Paintings Dataset

Elements Featured in Bob Ross's Paintings from 'The Joy of Painting'

@fivethirtyeight.bob_ross

Table List

1 table(54.68 KB)

Elements Featured In Bob Ross Paintings By Episode

@fivethirtyeight.bob_ross.elements_by_episode

Column	Description
EPISODE	Episode number (e.g., S01E01)
TITLE	Title of the painting
APPLE_FRAME	1 if present, 0 if not
AURORA_BOREALIS	1 if present, 0 if not
BARN	1 if present, 0 if not
BEACH	1 if present, 0 if not
BOAT	1 if present, 0 if not
BRIDGE	1 if present, 0 if not
BUILDING	1 if present, 0 if not
BUSHES	1 if present, 0 if not
CABIN	1 if present, 0 if not
...	(List continues for all 67 elements with binary indicators)
WOOD_FRAMED	1 if present, 0 if not

54.68 KB
403 rows
69 columns

episode EPISODE	title TITLE	beach BEACH	bushes BUSHES	cabin CABIN	clouds CLOUDS	conifer CONIFER	deciduous DECIDUOUS	fence FENCE	grass GRASS	lake LAKE	moon MOON	mountain MOUNTAIN	mountains MOUNTAINS	night NIGHT	ocean OCEAN	river RIVER	rocks ROCKS	snow SNOW	snowy_mountain SNOWY MOUNTAIN	structure STRUCTURE	sun SUN	tree TREE	trees TREES	winter WINTER
S01E01	"A WALK IN THE WOODS"		1				1		1							1						1	1
S01E02	"MT. MCKINLEY"			1	1	1						1						1	1			1	1	1
S01E03	"EBONY SUNSET"			1		1		1				1	1							1	1	1	1	1
S01E04	"WINTER MIST"		1		1	1				1		1							1			1	1
S01E05	"QUIET STREAM"						1									1	1					1	1
S01E06	"WINTER MOON"			1		1				1	1	1	1	1				1	1	1		1	1	1
S01E07	"AUTUMN MOUNTAINS"						1			1		1	1						1			1	1
S01E08	"PEACEFUL VALLEY"		1			1				1		1	1									1	1
S01E09	"SEASCAPE"	1			1			1							1
S01E10	"MOUNTAIN LAKE"		1			1	1			1		1										1	1


CREATE TABLE elements_by_episode (
  "episode" VARCHAR,
  "title" VARCHAR,
  "apple_frame" BIGINT,
  "aurora_borealis" BIGINT,
  "barn" BIGINT,
  "beach" BIGINT,
  "boat" BIGINT,
  "bridge" BIGINT,
  "building" BIGINT,
  "bushes" BIGINT,
  "cabin" BIGINT,
  "cactus" BIGINT,
  "circle_frame" BIGINT,
  "cirrus" BIGINT,
  "cliff" BIGINT,
  "clouds" BIGINT,
  "conifer" BIGINT,
  "cumulus" BIGINT,
  "deciduous" BIGINT,
  "diane_andre" BIGINT,
  "dock" BIGINT,
  "double_oval_frame" BIGINT,
  "farm" BIGINT,
  "fence" BIGINT,
  "fire" BIGINT,
  "florida_frame" BIGINT,
  "flowers" BIGINT,
  "fog" BIGINT,
  "framed" BIGINT,
  "grass" BIGINT,
  "guest" BIGINT,
  "half_circle_frame" BIGINT,
  "half_oval_frame" BIGINT,
  "hills" BIGINT,
  "lake" BIGINT,
  "lakes" BIGINT,
  "lighthouse" BIGINT,
  "mill" BIGINT,
  "moon" BIGINT,
  "mountain" BIGINT,
  "mountains" BIGINT,
  "night" BIGINT,
  "ocean" BIGINT,
  "oval_frame" BIGINT,
  "palm_trees" BIGINT,
  "path" BIGINT,
  "person" BIGINT,
  "portrait" BIGINT,
  "rectangle_3d_frame" BIGINT,
  "rectangular_frame" BIGINT,
  "river" BIGINT,
  "rocks" BIGINT,
  "seashell_frame" BIGINT,
  "snow" BIGINT,
  "snowy_mountain" BIGINT,
  "split_frame" BIGINT,
  "steve_ross" BIGINT,
  "structure" BIGINT,
  "sun" BIGINT,
  "tomb_frame" BIGINT,
  "tree" BIGINT,
  "trees" BIGINT,
  "triple_frame" BIGINT,
  "waterfall" BIGINT,
  "waves" BIGINT,
  "windmill" BIGINT,
  "window_frame" BIGINT,
  "winter" BIGINT,
  "wood_framed" BIGINT
);