30:[] 2e:{"title":"Relationships","cells":[{"id":0,"value":"# Relationships\n## Exploring relationships between two Wikidata items\n\nThis notebook explores the relationship between two Wikidata items.\n\nThe relationship between item 1 and item 2 can be:\n* a direct statement\n* a qualifier value\n* a reference value. ","pinned":false,"hidden":false,"mode":"md"},{"id":62,"value":"## Inputs","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"viewof item1 = Inputs.text({\n value: defaults.item1,\n label: \"Choose a Wikidata item\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":142,"value":"Item 1: [${label1} (${item1})](https://wikidata.org/wiki/${item1}) ","pinned":false,"hidden":false,"mode":"md"},{"id":11,"value":"viewof item2 = Inputs.text({\n value: defaults.item2,\n label: \"Choose another Wikidata item\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":148,"value":"Item 2: [${label2} (${item2})](https://wikidata.org/wiki/${item2}) ","pinned":false,"hidden":false,"mode":"md"},{"id":36,"value":"viewof lang = Inputs.text({\n value: defaults.lang,\n label: \"Choose a language code\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"Sharable url: https://observablehq.com/@pac02/relationships?item1=${item1}&item2=${item2}&lang=${lang}","pinned":false,"hidden":false,"mode":"md"},{"id":60,"value":"## Relationships as direct statements\n\n*${data1.length} direct statements involving [${label2} (${item2})](https://wikidata.org/wiki/${item2}) on [${label1} (${item1})](https://wikidata.org/wiki/${item1})'s page.* ","pinned":false,"hidden":false,"mode":"md"},{"id":288,"value":"html`${data1\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":244,"value":"*${data2.length} direct statements involving [${label1} (${item1})](https://wikidata.org/wiki/${item1}) on [${label2} (${item2})](https://wikidata.org/wiki/${item2})'s page.* ","pinned":false,"hidden":false,"mode":"md"},{"id":282,"value":"html`${data2\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":218,"value":"## Relationships as qualifiers ","pinned":false,"hidden":false,"mode":"md"},{"id":247,"value":"*${data3.length} statements involving [${label2} (${item2})](https://wikidata.org/wiki/${item2}) as a qualifier on [${label1} (${item1})](https://wikidata.org/wiki/${item1})'s page.* ","pinned":false,"hidden":false,"mode":"md"},{"id":275,"value":"html`${data3\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

' +\n o.itemLabel +\n '

' +\n o.propertyLabel +\n '

' +\n o.valueLabel +\n '

' +\n o.qualifierLabel +\n '

' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":250,"value":"*${data4.length} statements involving [${label1} (${item1})](https://wikidata.org/wiki/${item1}) as a qualifier on [${label2} (${item2})](https://wikidata.org/wiki/${item2})'s page.* ","pinned":false,"hidden":false,"mode":"md"},{"id":265,"value":"html`${data4\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

' +\n o.itemLabel +\n '

' +\n o.propertyLabel +\n '

' +\n o.valueLabel +\n '

' +\n o.qualifierLabel +\n '

' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":226,"value":"## Relationships as references","pinned":false,"hidden":false,"mode":"md"},{"id":253,"value":"*${data5.length} statements involving [${label2} (${item2})](https://wikidata.org/wiki/${item2}) as a reference on [${label1} (${item1})](https://wikidata.org/wiki/${item1})'s page.* ","pinned":false,"hidden":false,"mode":"md"},{"id":296,"value":"html`${data5\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

' +\n o.itemLabel +\n '

' +\n o.propertyLabel +\n '

' +\n o.valueLabel +\n '

' +\n o.referenceLabel +\n '

' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":259,"value":"*${data6.length} statements involving [${label1} (${item1})](https://wikidata.org/wiki/${item1}) as a reference on [${label2} (${item2})](https://wikidata.org/wiki/${item2})'s page.* ","pinned":false,"hidden":false,"mode":"md"},{"id":302,"value":"html`${data6\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

' +\n o.itemLabel +\n '

' +\n o.propertyLabel +\n '

' +\n o.valueLabel +\n '

' +\n o.referenceLabel +\n '

' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":320,"value":"## See also\n\n[Wikidata Diff](https://dicare.toolforge.org/wikidata-diff/) developed by [envlh](https://github.com/envlh) compares statements of two Wikidata items: \nhttps://dicare.toolforge.org/wikidata-diff/?qids=${item1}+${item2}&language=${lang}. ","pinned":false,"hidden":false,"mode":"md"},{"id":42,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":28,"value":"import { get_label } from \"@pac02/user-level-gender-statistics-for-wikipedia\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":32,"value":"label1 = get_label(item1, lang)","pinned":true,"hidden":false,"mode":"ojs"},{"id":46,"value":"label2 = get_label(item2, lang)","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"query1 = `SELECT ?item ?itemLabel ?wd ?wdLabel ?target ?targetLabel WHERE {\n BIND(wd:${item1} AS ?item) \n BIND(wd:${item2} AS ?target) \n ?item ?p ?statement.\n ?statement ?ps ?target.\n ?wd wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang} \". }\n}\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":117,"value":"query2 = `SELECT ?item ?itemLabel ?wd ?wdLabel ?target ?targetLabel WHERE {\n BIND(wd:${item2} AS ?item) \n BIND(wd:${item1} AS ?target) \n ?item ?p ?statement.\n ?statement ?ps ?target.\n ?wd wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang} \". }\n}\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":330,"value":"base = `https://query-main.wikidata.org/sparql`","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"output1 = fetch(`${base}?query=${encodeURIComponent(query1)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":119,"value":"output2 = fetch(`${base}?query=${encodeURIComponent(query2)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":161,"value":"output3 = fetch(`${base}?query=${encodeURIComponent(qualifier1)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":175,"value":"output4 = fetch(`${base}?query=${encodeURIComponent(qualifier2)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":200,"value":"output5 = fetch(`${base}?query=${encodeURIComponent(ref1)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":231,"value":"output6 = fetch(`${base}?query=${encodeURIComponent(ref2)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":115,"value":"data1 = output1.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel?.value,\n property: d.wd.value,\n propertyLabel: d.wdLabel.value,\n target: d.target.value,\n targetLabel: d.targetLabel?.value\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":306,"value":"data1.length","pinned":true,"hidden":false,"mode":"ojs"},{"id":125,"value":"data2 = output2.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel?.value,\n property: d.wd.value,\n propertyLabel: d.wdLabel.value,\n target: d.target.value,\n targetLabel: d.targetLabel?.value\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":156,"value":"qualifier1 = `\nSELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?qualifier ?qualifierLabel ?target ?targetLabel WHERE {\n {\n SELECT ?item ?property ?value ?target ?qualifier WHERE {\n BIND(wd:${item1} AS ?item)\n BIND(wd:${item2} AS ?target)\n hint:Query hint:optimizer \"None\".\n ?qualifier wikibase:qualifier ?pq.\n ?st ?pq ?target.\n ?property wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?item ?p ?st.\n ?st ?ps ?value.\n }\n }\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang},en\". }\n}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":184,"value":"qualifier2 = `\nSELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?qualifier ?qualifierLabel ?target ?targetLabel WHERE {\n {\n SELECT ?item ?property ?value ?target ?qualifier WHERE {\n BIND(wd:${item2} AS ?item)\n BIND(wd:${item1} AS ?target)\n hint:Query hint:optimizer \"None\".\n ?qualifier wikibase:qualifier ?pq.\n ?st ?pq ?target.\n ?property wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?item ?p ?st.\n ?st ?ps ?value.\n }\n }\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang},en\". }\n}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":159,"value":"data3 = output3.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel.value,\n property: d.property.value,\n propertyLabel: d.propertyLabel.value,\n value: d.value.value,\n valueLabel: d.valueLabel.value,\n qualifier: d.qualifier.value,\n qualifierLabel: d.qualifierLabel.value,\n target: d.target.value,\n targetLabel: d.targetLabel.value\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":188,"value":"data4 = output4.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel?.value,\n property: d.property.value,\n propertyLabel: d.propertyLabel.value,\n value: d.value.value,\n valueLabel: d.valueLabel.value,\n qualifier: d.qualifier.value,\n qualifierLabel: d.qualifierLabel.value,\n target: d.target.value,\n targetLabel: d.targetLabel?.value\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":202,"value":"data5 = output5.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel.value,\n property: d.property.value,\n propertyLabel: d.propertyLabel.value,\n value: d.value.value,\n valueLabel: d.valueLabel.value,\n reference: d.reference.value,\n referenceLabel: d.referenceLabel.value,\n target: d.target.value,\n targetLabel: d.targetLabel?.value\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":233,"value":"data6 = output6.results.bindings.map((d) => ({\n item: d.item.value,\n itemLabel: d.itemLabel.value,\n property: d.property.value,\n propertyLabel: d.propertyLabel.value,\n value: d.value.value,\n valueLabel: d.valueLabel.value,\n reference: d.reference.value,\n referenceLabel: d.referenceLabel.value,\n target: d.target.value,\n targetLabel: d.targetLabel?.value\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":196,"value":"ref1 = `SELECT ?item ?itemLabel ?property ?propertyLabel ?reference ?referenceLabel ?value ?valueLabel ?target ?targetLabel WHERE {\n {\n SELECT ?item ?property ?value ?reference ?target WHERE {\n hint:Query hint:optimizer \"None\".\n BIND(wd:${item1} AS ?item)\n BIND(wd:${item2} AS ?target)\n ?reference wikibase:reference ?pr.\n ?ref ?pr ?target.\n ?statement prov:wasDerivedFrom ?ref.\n ?item ?p ?statement.\n ?property wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?statement ?ps ?value.\n }\n }\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang}, en\". }\n}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":229,"value":"ref2 = `SELECT ?item ?itemLabel ?property ?propertyLabel ?reference ?referenceLabel ?value ?valueLabel ?target ?targetLabel WHERE {\n {\n SELECT ?item ?property ?value ?reference ?target WHERE {\n hint:Query hint:optimizer \"None\".\n BIND(wd:${item2} AS ?item)\n BIND(wd:${item1} AS ?target)\n ?reference wikibase:reference ?pr.\n ?ref ?pr ?target.\n ?statement prov:wasDerivedFrom ?ref.\n ?item ?p ?statement.\n ?property wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?statement ?ps ?value.\n }\n }\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang}, en\". }\n}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":92,"value":"defaults = {\n const params = new URL(document.URL).searchParams;\n const defaults = {\n item1: \"Q504998\",\n item2: \"Q32055\",\n lang: \"en\"\n };\n if (params.has(\"item1\")) {\n defaults.item1 = params.get(\"item1\");\n }\n if (params.has(\"item2\")) {\n defaults.item2 = params.get(\"item2\");\n }\n if (params.has(\"lang\")) {\n defaults.item2 = params.get(\"lang\");\n }\n return defaults;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":211,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}