Platform
Resources
Pricing
Sign in
Get started
Forest Gregg
Workspace
Fork
Public
CPS
By
Forest Gregg
Edited
Nov 26, 2022
1 fork
Insert cell
Insert cell
schooldata
select level, year, count(*) from applicant group by level, year;
Insert cell
schooldata
select
year,
grade,
sum(students)
from
twentieth_day_school
where
grade in ('K', '1', '8', '9')
and year >= 2016
group by
year,
grade;
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
Cells
schooldata
File attachments
Databases
Add comment
Select
Duplicate
Copy link
Embed
Delete
Cells
schooldata
File attachments
Databases
schooldata
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML