Bob Ross: elements-by-episode.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2 rows where AURORA_BOREALIS = 1
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104 | 104 | S08E13 | "NORTHERN LIGHTS" | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 376 | 376 | S29E12 | "AURORA'S DANCE" | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );