Published
Edited
Mar 4, 2022
viewof publishedBeforeFilter = Inputs.date({
value: "2019-01-01",
label: "Posts published before"
})
posts = owid.sql`select id,
printf("https://ourworldindata.org/%s", slug) as url,
title,
published_at,
updated_at
from posts
where "published_at" < ${timeFormatFn(
publishedBeforeFilter
)} order by updated_at`
sitemap = FileAttachment("owid-sitemap.xml").xml()
// print the name of the root element or error message
nodes = sitemap.querySelectorAll("urlset > url > loc")
sitemapUrls = new Set([...nodes.values()].map((item) => item.innerHTML))
timeFormatFn = d3.timeFormat("%Y-%m-%d")
postsInSitemap = posts.filter((post) => sitemapUrls.has(post.url))
owid = new DatasetteClient(
"https://owid-datasette-y43qr.ondigitalocean.app/owid"
)
import {DatasetteClient} from "@ambassadors/datasette-client"
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.
