import { get_label } from "@pac02/user-level-gender-statistics-for-wikipedia"
label1 = get_label(item1, lang)
label2 = get_label(item2, lang)
query1 = `SELECT ?item1 ?item1Label ?item2 ?item2Label ?wd ?wdLabel ?target ?targetLabel WHERE {
BIND(wd:${item1} AS ?item1)
BIND(wd:${item2} AS ?item2)
?item1 ?p ?statement1.
?statement1 ?ps ?target.
?wd wikibase:claim ?p;
wikibase:statementProperty ?ps.
?item2 ?p ?statement2.
?statement2 ?ps ?target.
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang}". }
}
`
baseurl = `https://query-main.wikidata.org/sparql`
output1 = fetch(`${baseurl}?query=${encodeURIComponent(query1)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
data1 = output1.results.bindings.map((d) => ({
item1: d.item1.value,
item1Label: d.item1Label.value,
item2: d.item2.value,
item2Label: d.item2Label.value,
property: d.wd.value,
propertyLabel: d.wdLabel.value,
target: d.target.value,
targetLabel: d.targetLabel?.value
}))
output3 = fetch(`${baseurl}?query=${encodeURIComponent(qualifier1)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
output5 = fetch(`${baseurl}?query=${encodeURIComponent(ref1)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
qualifier1 = `
SELECT ?item1 ?item1Label ?item2 ?item2Label ?property ?propertyLabel ?qualifier ?qualifierLabel ?target ?targetLabel WHERE {
{
SELECT ?item1 ?item2 ?property ?target ?qualifier WHERE {
BIND(wd:${item1} AS ?item1)
BIND(wd:${item2} AS ?item2)
?qualifier wikibase:qualifier ?pq.
?property wikibase:claim ?p;
wikibase:statementProperty ?ps.
?item1 ?p ?statement1.
?statement1 ?ps ?value1;
?pq ?target.
?item2 ?p ?statement2.
?statement2 ?ps ?value2;
?pq ?target.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang} ". }
}`
data3 = output3.results.bindings.map((d) => ({
item1: d.item1.value,
item1Label: d.item1Label.value,
item2: d.item2.value,
item2Label: d.item2Label.value,
property: d.property.value,
propertyLabel: d.propertyLabel.value,
qualifier: d.qualifier.value,
qualifierLabel: d.qualifierLabel.value,
target: d.target.value,
targetLabel: d.targetLabel.value
}))
data5 = output5.results.bindings.map((d) => ({
item1: d.item1.value,
item1Label: d.item1Label.value,
item2: d.item2.value,
item2Label: d.item2Label.value,
property: d.property.value,
propertyLabel: d.propertyLabel.value,
reference: d.reference.value,
referenceLabel: d.referenceLabel.value,
target: d.target.value,
targetLabel: d.targetLabel.value
}))
ref1 = `SELECT DISTINCT ?item1 ?item1Label
?item2 ?item2Label
?property ?propertyLabel ?reference ?referenceLabel ?target ?targetLabel WHERE {
{
SELECT ?item1?item2 ?property ?value ?reference ?target WHERE {
BIND(wd:${item1} AS ?item1)
BIND(wd:${item2} AS ?item2)
?reference wikibase:reference ?pr.
?ref1 ?pr ?target.
?statement1 prov:wasDerivedFrom ?ref1.
?item1 ?p ?statement1.
?property wikibase:claim ?p;
wikibase:statementProperty ?ps.
?item2 ?p ?statement2.
?statement2 prov:wasDerivedFrom ?ref2.
?ref2 ?pr ?target.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang}, en". }
}`
defaults = {
const params = new URL(document.URL).searchParams;
const defaults = {
item1: "Q3718",
item2: "Q8673",
lang: "en"
};
if (params.has("item1")) {
defaults.item1 = params.get("item1");
}
if (params.has("item2")) {
defaults.item2 = params.get("item2");
}
if (params.has("lang")) {
defaults.item2 = params.get("lang");
}
return defaults;
}
import { aq, op } from "@uwdata/arquero"
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.
