The avatar for @bcglee
bcglee
Public
Edited
May 23, 2024
Fork of Search + Table
2
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
final_combined_time_meta1.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
final_combined_time_meta.csv
select
MONTH(dtime) as month_num
,YEAR(dtime) as year
,count(htid) as htid_count
,strftime(dtime, '%b') as month_abbr
from final_combined_time_meta
GROUP BY ALL
ORDER BY 2, 1
Insert cell
final_combined_time_meta1.csv
select
title
,count(*) as count_dtitles
from final_combined_time_meta1
group by 1
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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