Public
Edited
May 26, 2023
2 stars
Insert cell
Insert cell
db
select count(*)::int as total from counts;
Insert cell
db
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
db
SELECT * FROM "counts"
LIMIT 100
Insert cell
db
select pile_set_name, sum(tokens)::int as sum, count(*)::int as count
from counts
group by pile_set_name
order by sum desc
Insert cell
Insert cell
Insert cell
db
select pile_set_name, count(*)::int as count
from counts
group by pile_set_name
order by count desc
Insert cell
Insert cell
db
select pile_set_name, count(*)::int as count
from counts
where tokens < 4000
group by pile_set_name
order by count desc
Insert cell
Insert cell
db = DuckDBClient.of({counts: FileAttachment("00-counts-noindex.parquet")})
Insert cell
nformat = d3.format(",d")
Insert cell
import { colors } from "@enjalot/the-pile-test-set-token-counts"
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