The avatar for @fgregg
Forest Gregg
Public
Edited
Jan 6, 2024
1 fork
Importers
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
factors
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
with co_sponsored_bills as (
select
bill_id
from
billsponsorship as sponsorship
inner join bill on bill.id = bill_id
inner join legislativesession on legislative_session_id = legislativesession.id
where
legislativesession.identifier = '2023'
group by bill_id
having count(*) > 1
)
select
bill.identifier,
sponsorship.name,
1 as sponsoring
from
billsponsorship as sponsorship
inner join bill on bill.id = bill_id
where bill_id in (select bill_id from co_sponsored_bills);

Insert cell
db = new DatasetteClient("https://puddle.bunkum.us/chicago_council")
Insert cell
Insert cell
import { DatasetteClient } from "@fgregg/datasette-client-with-sql-cells-full-results-csv-stream"
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