Public
Edited
Jan 26
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
import { get_labels } from "@pac02/what-kind-of-articles-have-you-created"
Insert cell
labels = get_labels([filtering_property, filtering_target]).then((d) =>
d.array("label")
)
Insert cell
Insert cell
query_labels = `
SELECT ?lang (COUNT(*) AS ?count)
WHERE {
?item ${wdt}:${filtering_property} ${target}.
?item rdfs:label ?itemLabel.
BIND(LANG(?itemLabel) AS ?lang)
}
GROUP BY ?lang
ORDER BY DESC(?count)
`
Insert cell
query_descriptions = `
SELECT ?lang (COUNT(*) AS ?count)
WHERE {
?item ${wdt}:${filtering_property} ${target}.
?item schema:description ?itemDescription.
BIND(LANG(?itemDescription) AS ?lang)
}
GROUP BY ?lang
ORDER BY DESC(?count)
`
Insert cell
data_descriptions = fetch(
`https://query-main.wikidata.org/sparql?query=${encodeURIComponent(
query_descriptions
)}`,
{ headers: { accept: "application/sparql-results+json" } }
).then((response) => response.json())
Insert cell
data_labels = fetch(
`https://query-main.wikidata.org/sparql?query=${encodeURIComponent(
query_labels
)}`,
{ headers: { accept: "application/sparql-results+json" } }
).then((response) => response.json())
Insert cell
array_labels = data_labels.results.bindings.map((d) => ({
lang: d.lang.value,
count: parseInt(d.count.value)
}))
Insert cell
array_descriptions = data_descriptions.results.bindings.map((d) => ({
lang: d.lang.value,
count: parseInt(d.count.value)
}))
Insert cell
df_labels = aq.from(array_labels)
Insert cell
df_descriptions = aq.from(array_descriptions)
Insert cell
Insert cell
Insert cell
Insert cell
get_default = () => {
const params = new URL(document.URL).searchParams;
const defaults = {
filtering_property: "P27",
filtering_target: "Q1008",
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;
}
Insert cell
get_default()
Insert cell
target = {
if (filtering_target == "") {
return "?target";
} else {
return "wd:" + filtering_target;
}
}
Insert cell
wdt = {
if (reverse == true) {
return "^wdt";
} else {
return "wdt";
}
}
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.
Learn more