I'm a data engineer. I do a lot of stuff with Wikidata and Sparql.
Public
Edited
Dec 6, 2023
1 star
First notebook:Testing Wikidata and Sparql
import {tex} from "@lukesmurray/wikidata-sparql-cell-mode-hack"
query_nyt_obi_by_year = `
SELECT ?year (COUNT(?q) AS ?count) WHERE {
SELECT DISTINCT ?q (YEAR(?date) AS ?year) (MONTH(?date) AS ?month) WHERE {
?q wdt:P31 wd:Q309481 ; wdt:P1433 wd:Q9684 .
?q wdt:P577 ?date.
FILTER(?date >= "2011-01-01"^^xsd:dateTime && ?date < "2023-01-01"^^xsd:dateTime) .
}
}
GROUP BY ?year
ORDER BY ?year
`
res_nyt_obi_by_year = fetch(`https://query.wikidata.org/sparql?query=${encodeURIComponent(query_nyt_obi_by_year)}`, {headers: {accept: "application/sparql-results+json"}}).then(response => response.json())
import {aq, op} from "@uwdata/arquero"
df_nyt_obi_by_year = aq.from(res_nyt_obi_by_year.results.bindings.map(res => ({
year: res.year.value,
count: res.count.value
})))
df_nyt_obi_by_year.view()
import {vl} from "@vega/vega-lite-api-v5"
vl.markBar().data(
df_nyt_obi_by_year
).encode(
vl.y().field("count").type('quantitative').title("Number of obituaries"),
vl.x().field("year").type('ordinal').title("Year"),
vl.tooltip(['year', 'count'])
).width(width) // full width
.render()
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.
