The avatar for @danyx
Daniel Bachler
Published
Edited
Sep 5, 2022
Fork of Color investigations - map charts
•
2 forks
Insert cell
Insert cell
Insert cell
Insert cell
Inputs.table(chartsWithBaseScheme, {
height: "800px",
width: {id: "10%", slug: "90%"},
format: {
slug: (slug) =>
html`<iframe src="https://ourworldindata.org/grapher/${slug}" loading="lazy" style="width: 100%; height: 500px; border: 0px none;"/>`
}
})
Insert cell
Inputs.table(chartsWithBaseScheme, {
format: {
slug: (slug) => html`<a href="https://ourworldindata.org/grapher/${slug}">${slug}</a>`
}
})
Insert cell
owid
select id, slug
from charts
where config ->> '$.hasChartTab' = true
and ((${baseScheme.baseScheme} = 'null' and config ->> '$.colorScale.baseColorScheme' is null) or config ->> '$.colorScale.baseColorScheme'= ${baseScheme.baseScheme})
and ((${baseScheme.type} = 'null' and config ->> '$.type' is null) or config ->> '$.type'= ${baseScheme.type})
order by updatedAt desc
Insert cell
owid
select c.config ->> '$.colorScale.baseColorScheme' as baseScheme, c.config ->> '$.type' as type, count(*) as count
from charts c
where c.config ->> '$.hasChartTab' = true
group by c.config ->> '$.colorScale.baseColorScheme', c.config ->> '$.type'
order by count(*) desc
Insert cell
Insert cell
owid = new DatasetteClient(
"https://owid-datasette-y43qr.ondigitalocean.app/owid"
)
Insert cell
//Inputs.table(variables.query(`SELECT * from variables ${whereClause}`))
Insert cell
import {DatasetteClient} from "@ambassadors/datasette-client"
Insert cell
import {debounce} from "@mbostock/debouncing-input"
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