query = `SELECT ?item ?itemLabel ?labels ?descriptions ?sitelinks ?statements
WITH {
SELECT ?item (COUNT(*) AS ?labels)
WHERE {
?item wdt:P19 ?place.
?place wdt:P131* ${target}.
?item rdfs:label ?itemLabel.
}
GROUP BY ?item
} AS %labels
WITH {
SELECT ?item (COUNT(*) AS ?descriptions)
WHERE {
?item wdt:P19 ?place.
?place wdt:P131* ${target}.
OPTIONAL {?item schema:description ?itemDescription}
}
GROUP BY ?item
} AS %descriptions
WHERE {
INCLUDE %labels
INCLUDE %descriptions
?item wikibase:sitelinks ?sitelinks; wikibase:statements ?statements.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en, mul". }
}
ORDER BY DESC(?labels)
`
data = fetch(
`https://query-main.wikidata.org/sparql?query=${encodeURIComponent(query)}`,
{ headers: { accept: "application/sparql-results+json" } }
).then((response) => response.json())
array = data.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel.value,
labels: parseInt(d.labels.value),
descriptions: parseInt(d.descriptions.value),
sitelinks: parseInt(d.sitelinks.value),
statements: parseInt(d.statements.value)
}))
df = aq.from(array).derive({
item2: (d) =>
d.itemLabel +
" (" +
op.replace(d.item, "http://www.wikidata.org/entity/", "") +
")"
})
dflong = df.fold(["labels", "descriptions", "statements", "sitelinks"])
get_default = () => {
const params = new URL(document.URL).searchParams;
const defaults = {
filtering_property: "P19",
filtering_target: "Q17063",
reverse: false
};
if (params.has("filtering_property")) {
defaults.filtering_property = params.get("filtering_property");
}
if (params.has("filtering_target")) {
defaults.filtering_target = params.get("filtering_target");
}
if (params.has("reverse")) {
defaults.reverse = params.get("reverse");
}
return defaults;
}
get_default()
target = {
if (filtering_target == "") {
return "?target";
} else {
return "wd:" + filtering_target;
}
}
wdt = {
if (reverse == true) {
return "^wdt";
} else {
return "wdt";
}
}
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.
