The avatar for @danyx
Daniel Bachler
Published
Edited
Jan 5, 2022
Fork of Our World In Data posts histogram
•
1 fork
2 stars
Insert cell
Insert cell
Insert cell
stacked = Plot.plot({
marks: [
Plot.barY(chartsByYearAndTag, {x: "year", y: "chart_count", fill: "tag_name", title: "tag_name"}),
Plot.ruleY([0])
]
})
Insert cell
chartsByYearAndTag = owid.sql`select t.name as tag_name, count(ct.chartId) as chart_count, STRFTIME('%Y', c.publishedAt) as year
from chart_tags ct
left join charts c on ct.chartId = c.id
left join tags t on t.id = ct.tagId
group by ct.tagId,
year
having ct.tagId in (select ct.tagId from chart_tags ct group by ct.tagId having count(ct.chartId) > 50)
order by year, chart_count desc`
Insert cell
owid
select ct.tagId, t.name , count(c.id) as chart_count
from chart_tags ct
left join charts c on ct.chartId = c.id
left join tags t on t.id = ct.tagId
group by ct.tagId
having chart_count > 50
order by chart_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

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more