Public
Edited
Oct 17, 2024
1 fork
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
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_label } from "@pac02/user-level-gender-statistics-for-wikipedia"
Insert cell
label1 = get_label(item1, lang)
Insert cell
label2 = get_label(item2, lang)
Insert cell
query1 = `SELECT ?item ?itemLabel ?wd ?wdLabel ?target ?targetLabel WHERE {
BIND(wd:${item1} AS ?item)
BIND(wd:${item2} AS ?target)
?item ?p ?statement.
?statement ?ps ?target.
?wd wikibase:claim ?p;
wikibase:statementProperty ?ps.
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang} ". }
}
`
Insert cell
query2 = `SELECT ?item ?itemLabel ?wd ?wdLabel ?target ?targetLabel WHERE {
BIND(wd:${item2} AS ?item)
BIND(wd:${item1} AS ?target)
?item ?p ?statement.
?statement ?ps ?target.
?wd wikibase:claim ?p;
wikibase:statementProperty ?ps.
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang} ". }
}
`
Insert cell
base = `https://query-main.wikidata.org/sparql`
Insert cell
output1 = fetch(`${base}?query=${encodeURIComponent(query1)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
Insert cell
output2 = fetch(`${base}?query=${encodeURIComponent(query2)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
Insert cell
output3 = fetch(`${base}?query=${encodeURIComponent(qualifier1)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
Insert cell
output4 = fetch(`${base}?query=${encodeURIComponent(qualifier2)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
Insert cell
output5 = fetch(`${base}?query=${encodeURIComponent(ref1)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
Insert cell
output6 = fetch(`${base}?query=${encodeURIComponent(ref2)}`, {
headers: { accept: "application/sparql-results+json" }
}).then((response) => response.json())
Insert cell
data1 = output1.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel?.value,
property: d.wd.value,
propertyLabel: d.wdLabel.value,
target: d.target.value,
targetLabel: d.targetLabel?.value
}))
Insert cell
data1.length
Insert cell
data2 = output2.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel?.value,
property: d.wd.value,
propertyLabel: d.wdLabel.value,
target: d.target.value,
targetLabel: d.targetLabel?.value
}))
Insert cell
qualifier1 = `
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?qualifier ?qualifierLabel ?target ?targetLabel WHERE {
{
SELECT ?item ?property ?value ?target ?qualifier WHERE {
BIND(wd:${item1} AS ?item)
BIND(wd:${item2} AS ?target)
hint:Query hint:optimizer "None".
?qualifier wikibase:qualifier ?pq.
?st ?pq ?target.
?property wikibase:claim ?p;
wikibase:statementProperty ?ps.
?item ?p ?st.
?st ?ps ?value.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang},en". }
}`
Insert cell
qualifier2 = `
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?qualifier ?qualifierLabel ?target ?targetLabel WHERE {
{
SELECT ?item ?property ?value ?target ?qualifier WHERE {
BIND(wd:${item2} AS ?item)
BIND(wd:${item1} AS ?target)
hint:Query hint:optimizer "None".
?qualifier wikibase:qualifier ?pq.
?st ?pq ?target.
?property wikibase:claim ?p;
wikibase:statementProperty ?ps.
?item ?p ?st.
?st ?ps ?value.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang},en". }
}`
Insert cell
data3 = output3.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel.value,
property: d.property.value,
propertyLabel: d.propertyLabel.value,
value: d.value.value,
valueLabel: d.valueLabel.value,
qualifier: d.qualifier.value,
qualifierLabel: d.qualifierLabel.value,
target: d.target.value,
targetLabel: d.targetLabel.value
}))
Insert cell
data4 = output4.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel?.value,
property: d.property.value,
propertyLabel: d.propertyLabel.value,
value: d.value.value,
valueLabel: d.valueLabel.value,
qualifier: d.qualifier.value,
qualifierLabel: d.qualifierLabel.value,
target: d.target.value,
targetLabel: d.targetLabel?.value
}))
Insert cell
data5 = output5.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel.value,
property: d.property.value,
propertyLabel: d.propertyLabel.value,
value: d.value.value,
valueLabel: d.valueLabel.value,
reference: d.reference.value,
referenceLabel: d.referenceLabel.value,
target: d.target.value,
targetLabel: d.targetLabel?.value
}))
Insert cell
data6 = output6.results.bindings.map((d) => ({
item: d.item.value,
itemLabel: d.itemLabel.value,
property: d.property.value,
propertyLabel: d.propertyLabel.value,
value: d.value.value,
valueLabel: d.valueLabel.value,
reference: d.reference.value,
referenceLabel: d.referenceLabel.value,
target: d.target.value,
targetLabel: d.targetLabel?.value
}))
Insert cell
ref1 = `SELECT ?item ?itemLabel ?property ?propertyLabel ?reference ?referenceLabel ?value ?valueLabel ?target ?targetLabel WHERE {
{
SELECT ?item ?property ?value ?reference ?target WHERE {
hint:Query hint:optimizer "None".
BIND(wd:${item1} AS ?item)
BIND(wd:${item2} AS ?target)
?reference wikibase:reference ?pr.
?ref ?pr ?target.
?statement prov:wasDerivedFrom ?ref.
?item ?p ?statement.
?property wikibase:claim ?p;
wikibase:statementProperty ?ps.
?statement ?ps ?value.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang}, en". }
}`
Insert cell
ref2 = `SELECT ?item ?itemLabel ?property ?propertyLabel ?reference ?referenceLabel ?value ?valueLabel ?target ?targetLabel WHERE {
{
SELECT ?item ?property ?value ?reference ?target WHERE {
hint:Query hint:optimizer "None".
BIND(wd:${item2} AS ?item)
BIND(wd:${item1} AS ?target)
?reference wikibase:reference ?pr.
?ref ?pr ?target.
?statement prov:wasDerivedFrom ?ref.
?item ?p ?statement.
?property wikibase:claim ?p;
wikibase:statementProperty ?ps.
?statement ?ps ?value.
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "${lang}, en". }
}`
Insert cell
defaults = {
const params = new URL(document.URL).searchParams;
const defaults = {
item1: "Q504998",
item2: "Q32055",
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;
}
Insert cell
import { aq, op } from "@uwdata/arquero"
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