Public
Edited
Sep 23, 2024
1 fork
2 stars
Insert cell
Insert cell
data
X
Date
Y
Total
Color
Day of Week
Size
Facet X
Day of Week
Facet Y
Transportation
Mark
area
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
mta
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
mta.csv
SELECT Date
, 'Subways' as Transportation
, date_part('dayofweek', Date::date) as dow
, "Subways: Total Estimated Ridership" as Total
FROM mta

UNION

SELECT Date
, 'Buses' as Transportation
, date_part('dayofweek', Date::date) as dow
, "Buses: Total Estimated Ridership" as Total
FROM mta
Insert cell
dayOfWeekLookup = ({
0: "7 - Sunday",
1: "1 - Monday",
2: "2 - Tuesday",
3: "3 - Wednesday",
4: "4 - Thursday",
5: "5 - Friday",
6: "6 - Saturday"
})
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more