Platform
Resources
Pricing
Sign in
Contact us
Daniel Bachler
Workspace
Fork
Published
OWID Datasette
By
Daniel Bachler
Edited
Jan 5, 2022
Fork of
Our World In Data posts histogram
OWID Datasette
Our World In Data - outdated charts finder
Our World In Data posts browser
Our World In Data Datasette search UI
Our World In Data charts visualisation
Our World In Data posts histogram
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
html
`${
posts
[
currentIndex
]
.
content
}`
Insert cell
currentIndex
=
Math
.
max
(
0
,
Math
.
min
(
posts
.
length
,
0
+
increaseCurrent
-
decreaseCurrent
)
)
Insert cell
posts
=
owid
.
sql
`select id,
printf("https://ourworldindata.org/%s", slug) as url,
title,
slug,
content,
published_at
from posts
where not published_at is null
order by id desc
limit 200`
Insert cell
cleaned_posts
=
posts
.
map
(
(
x
)
=>
(
{
...
x
,
published_at
:
new
Date
(
x
.
published_at
)
}
)
)
.
filter
(
(
x
)
=>
x
.
published_at
>
new
Date
(
"2010-01-01"
)
)
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.
Try it for free
Learn more
Compare fork
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
increaseCurrent
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
decreaseCurrent
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
currentIndex
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
posts
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
cleaned_posts
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
owid
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
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