The avatar for @bmschmidt
Benjamin Schmidt
Digital Humanist. Manhattan-based.
Published
Edited
Oct 7, 2022
4 stars
1
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
SELECT title, LENGTH(text) characters, file, volume, page, text FROM eb07 ORDER BY characters DESC LIMIT 250
Insert cell
Insert cell
db
SELECT COUNT(*) FROM eb07
Insert cell
Insert cell
db
SELECT SUM(pmax)::FLOAT FROM (SELECT volume, MAX(page) pmax FROM eb07 GROUP BY volume) t1
Insert cell
Insert cell
db
SELECT SUM(LENGTH(text))::FLOAT FROM eb07;
Insert cell
Insert cell
db
SELECT * FROM (SELECT title, lag(title) OVER (), title >= lag(title) OVER () fits FROM eb07) t1 WHERE fits = FALSE;
Insert cell
Insert cell
db = DuckDBClient.of({ eb07 })
Insert cell
import {DuckDBClient} from '@cmudig/duckdb'

Insert cell
eb07 = FileAttachment("eb07@2.parquet")
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