The avatar for @tashapiro
Tanya Shapiro
Independent Data Analytics Consultant, passionate about data visualization and storytelling · she/her 🏳️‍🌈
Public
Edited
Jan 15, 2024
1 fork
3 stars
1
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
nhl_rosters.csv
select
birth_country
,count(*) as count_players
from nhl_rosters
where YEAR(birth_date) = ${selectedYear}
group by 1
Insert cell
Insert cell
nhl_rosters.csv
select
MONTH(birth_date) as month_num
,YEAR(birth_date) as year
,strftime(birth_date, '%b') as month_abbr
,count(distinct player_id) as count_players
from nhl_rosters
WHERE year>=1995 and year<=2000
GROUP BY ALL
ORDER BY 2, 1
Insert cell
nhl_rosters
SELECT *
FROM nhl_rosters
WHERE season = 20222023 and birth_country = ${selectCountry}
Insert cell
Insert cell
nhl_rosters.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
beeswarmData = calculateBeeswarm(roster_subset, "weight_in_pounds",0, radius, 1.5)
Insert cell
Insert cell
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