30:[] 2e:{"title":"Common values","cells":[{"id":0,"value":"# Common values\n## Exploring common values between two Wikidata items\n\nTaking two Wikidata items, I look at all statements with the same value, all statements with the same qualifier value and all statements with the same reference value.\n\nThis is another approach to look at the similarity between Wikidata items. \n\nThe tool is similar to [Wikidata Diff](https://dicare.toolforge.org/wikidata-diff/) but there are two main differences:\n* Common values only shows similarities, not differences between items\n* Common values looks at qualifiers and references whereas Wikidata Diff is focused on main statements. ","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/common-values?item1=${item1}&item2=${item2}&lang=${lang}","pinned":false,"hidden":false,"mode":"md"},{"id":60,"value":"## ${data1.length} common values as main statements ","pinned":false,"hidden":false,"mode":"md"},{"id":288,"value":"html`${data1\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

Item 1	Item 2	Property	Value
' +\n o.item1Label +\n '	' +\n o.item2Label +\n '	' +\n o.propertyLabel +\n '	' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":218,"value":"## ${data3.length} common values as qualifiers ","pinned":false,"hidden":false,"mode":"md"},{"id":275,"value":"html`${data3\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

Item 1	Item 2	Property	Qualifier	Value
' +\n o.item1Label +\n '	' +\n o.item2Label +\n '	' +\n o.propertyLabel +\n '	' +\n o.qualifierLabel +\n '	' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":226,"value":"## ${data5.length} common values as references","pinned":false,"hidden":false,"mode":"md"},{"id":296,"value":"html`${data5\n .map(\n (o) =>\n '\"\n )\n .join(\"\\n\")}\n

Item 1	Item 2	Property	Reference	Value
' +\n o.item1Label +\n '	' +\n o.item2Label +\n '	' +\n o.propertyLabel +\n '	' +\n o.referenceLabel +\n '	' +\n o.targetLabel +\n \"

`","pinned":false,"hidden":false,"mode":"ojs"},{"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 ?item1 ?item1Label ?item2 ?item2Label ?wd ?wdLabel ?target ?targetLabel WHERE {\n BIND(wd:${item1} AS ?item1)\n BIND(wd:${item2} AS ?item2)\n ?item1 ?p ?statement1.\n ?statement1 ?ps ?target.\n ?wd wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?item2 ?p ?statement2.\n ?statement2 ?ps ?target.\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang}\". }\n}\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":400,"value":"baseurl = `https://query-main.wikidata.org/sparql`","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"output1 = fetch(`${baseurl}?query=${encodeURIComponent(query1)}`, {\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 item1: d.item1.value,\n item1Label: d.item1Label.value,\n item2: d.item2.value,\n item2Label: d.item2Label.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":161,"value":"output3 = fetch(`${baseurl}?query=${encodeURIComponent(qualifier1)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":200,"value":"output5 = fetch(`${baseurl}?query=${encodeURIComponent(ref1)}`, {\n headers: { accept: \"application/sparql-results+json\" }\n}).then((response) => response.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":156,"value":"qualifier1 = `\nSELECT ?item1 ?item1Label ?item2 ?item2Label ?property ?propertyLabel ?qualifier ?qualifierLabel ?target ?targetLabel WHERE {\n {\n SELECT ?item1 ?item2 ?property ?target ?qualifier WHERE {\n BIND(wd:${item1} AS ?item1)\n BIND(wd:${item2} AS ?item2)\n ?qualifier wikibase:qualifier ?pq.\n ?property wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?item1 ?p ?statement1.\n ?statement1 ?ps ?value1;\n ?pq ?target.\n ?item2 ?p ?statement2.\n ?statement2 ?ps ?value2;\n ?pq ?target.\n }\n }\n SERVICE wikibase:label { bd:serviceParam wikibase:language \"${lang} \". }\n}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":159,"value":"data3 = output3.results.bindings.map((d) => ({\n item1: d.item1.value,\n item1Label: d.item1Label.value,\n item2: d.item2.value,\n item2Label: d.item2Label.value,\n property: d.property.value,\n propertyLabel: d.propertyLabel.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 item1: d.item1.value,\n item1Label: d.item1Label.value,\n item2: d.item2.value,\n item2Label: d.item2Label.value,\n property: d.property.value,\n propertyLabel: d.propertyLabel.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 DISTINCT ?item1 ?item1Label\n ?item2 ?item2Label\n?property ?propertyLabel ?reference ?referenceLabel ?target ?targetLabel WHERE {\n {\n SELECT ?item1?item2 ?property ?value ?reference ?target WHERE {\n \n BIND(wd:${item1} AS ?item1)\n BIND(wd:${item2} AS ?item2)\n ?reference wikibase:reference ?pr.\n ?ref1 ?pr ?target.\n ?statement1 prov:wasDerivedFrom ?ref1.\n ?item1 ?p ?statement1.\n ?property wikibase:claim ?p;\n wikibase:statementProperty ?ps.\n ?item2 ?p ?statement2. \n \n?statement2 prov:wasDerivedFrom ?ref2. \n ?ref2 ?pr ?target. \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: \"Q3718\",\n item2: \"Q8673\",\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"}