Digital Humanist. Manhattan-based.
Public
Edited
Feb 28, 2023
1 fork
Plot.plot({
facet: { data: trends, y: "INSTNM", marginRight: 290 },
marks: [Plot.lineY(trends, { x: "year", y: "majors", stroke: "INSTNM" })]
})
trends
viewof trends = await client.table(
`WITH top_english AS (
SELECT INSTNM, AWLEVEL, Discipline, sum(degrees) as t2 FROM "degrees" NATURAL JOIN "chars" WHERE AWLEVEL IN (5) AND year > 2015 AND DISCIPLINE = 'English Language and Literature' GROUP BY ALL ORDER BY t2 DESC LIMIT 10)
SELECT INSTNM, AWLEVEL, Discipline, year, sum(degrees.degrees) AS "majors" FROM top_english NATURAL JOIN degrees WHERE AWLEVEL=5 GROUP BY ALL ORDER BY year ASC
`
)
import { client } from "@bmschmidt/duckdb-degrees"
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.
