The avatar for @anthonymoser
Anthony Moser
Public
Edited
Dec 8, 2022
Fork of choice and offers
Insert cell
Insert cell
schooldata
select
CAST(a.year AS CHAR) year,
o.offerstatus,
count(offerstatus) as records
from
choice_offers o
JOIN
applicant a
ON
a.id = o.applicant_id
GROUP BY
year, offerstatus
ORDER BY
offerstatus, year
Insert cell
schooldata = new DatasetteClient("https://data.thefoiabakery.org/_memory")
Insert cell
import { DatasetteClient } from "@fgregg/datasette-client-with-sql-cells-full-results"
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