CAT🐈: LanguagesCAT🐈: MetricsCAT🐈: Most frequent propertiesMAP🐈CAT🐈CAT🐈 focused on humans
CAT🐈: Overview of references
query = `SELECT ?item ?itemLabel ?value ?valueLabel ?reference ?propertyref ?propertyrefLabel ?valueref
WITH
{
SELECT ?item ?value ?reference ?propertyref ?valueref
WHERE {
?item ${wdt}:${filtering_property} ${target} ;
p:${analytical_property} ?statement.
?statement ps:${analytical_property} ?value.
OPTIONAL {
?statement prov:wasDerivedFrom ?reference.
?reference ?pref ?valueref.
?propertyref wikibase:reference ?pref.
}} } AS %base
WHERE {
INCLUDE %base
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang}, mul". }
}
`
url = `https://query-main.wikidata.org/sparql?query=${encodeURIComponent(
query
)}`
df = {
try {
const response = await fetch(url, {
headers: {
accept: "application/sparql-results+json",
"User-Agent": "Overview of references"
}
});
if (!response.ok) {
throw new Error(`HTTP error! Status: ${response.status}`);
}
const res = await response.json(); // Attendez la résolution de la promesse ici
const array = res.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel.value,
value: d.value.value,
valueLabel: d.valueLabel.value,
reference: d.reference?.value,
propertyref: d.propertyref?.value,
propertyrefLabel: d.propertyrefLabel?.value,
valueref: d.valueref?.value
}));
const df = aq.from(array).derive({
reference: (d) =>
op.replace(d.reference, "http://www.wikidata.org/reference/", ""),
item: (d) => op.replace(d.item, "http://www.wikidata.org/entity/", ""),
value: (d) => op.replace(d.value, "http://www.wikidata.org/entity/", ""),
propertyref: (d) =>
op.replace(d.propertyref, "http://www.wikidata.org/entity/", "")
});
return df;
} catch (error) {
console.error("Error fetching data:", error);
throw error; // Relancez l'erreur pour la gestion en amont
}
}
count_ref = df
.filter((d) => d.reference !== undefined)
.dedupe(["item", "itemLabel", "value", "valueLabel", "reference"])
.groupby(["item", "itemLabel", "value", "valueLabel"])
.count()
.concat(
df
.filter((d) => d.reference == undefined)
.dedupe(["item", "itemLabel", "value", "valueLabel"])
.select(["item", "itemLabel", "value", "valueLabel"])
.derive({ count: 0 })
)
.orderby(aq.desc("count"))
propertyrefs = df
.filter((d) => d.reference !== undefined)
.dedupe([
"item",
"itemLabel",
"value",
"valueLabel",
"reference",
"propertyref",
"propertyrefLabel"
])
.groupby(["propertyref", "propertyrefLabel"])
.count()
.orderby(aq.desc("count"))
.objects()
prefMap = new Map(
propertyrefs.map(({ propertyref, propertyrefLabel }) => [
propertyrefLabel + " (" + propertyref + ")",
propertyref
])
)
get_default = () => {
const params = new URL(document.URL).searchParams;
const defaults = {
filtering_property: "P27",
filtering_target: "Q822",
reverse: false,
lang: "en",
analytical_property: "P106"
};
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("lang")) {
defaults.lang = params.get("lang");
}
if (params.has("reverse")) {
defaults.reverse = params.get("reverse");
}
if (params.has("analytical_property")) {
defaults.analytical_property = params.get("analytical_property");
}
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.
