3f:null 40:["$","title",null,{"children":"Wikidata SPARQL query | Riley | Observable"}] 46:Td6e,htl.html`

Wikidata SPARQL query

This is a function for easily making queries to Wikidata’s SPARQL API. This function can be called in multiple ways.

${querySPARQL.name}(query: string)
${querySPARQL.name}${"`"}query${"`"}
${querySPARQL.name}(options: object)(query: string)
${querySPARQL.name}(options: object)${"`"}query${"`"}
${querySPARQL.name}(options: object, query: string)

All of these patterns will return a promise for the requested data.

options object

`brief: boolean`

This boolean option results in just the array of bindings being returned, rather than an object with a head and results.

`mapVars: object`

This remaps variable names. This may be a plain object whose entries represent the remapping. If there is an iterator, then the iterator is expected to return iterables of two items: the old and new name. Both the header and results are affected. Any variable not listed to be remapped is unaffected. Mapping a variable to null deletes the variable.

`name: string | function`

This defines the ${Symbol.name}.toStringTag property of each binding. If this is a function, then it is used to create an accessor property, where this is the relevant object. If it is null or undefined, then this option has no effect. In all other cases, the string version of the value is used as a constant applied to all bindings.

`endpoint: string`

When truthy, this overrides the default endpoint of "//query.Wikidata.org/sparql".

example

`47:T4c5,querySPARQL({brief: true, mapVars: { itemLabel: "name", isoCode2: "ID2", isoCode3: "ID3", item: undefined }, name() { return this.ID2 ? this.ID3 ? this.ID2 == String(this.ID3).slice(0, 2) ? `${this.name} [${this.ID2}(${String(this.ID3).slice(2)})]` : `${this.name} [${this.ID2}/${this.ID3}]` : `${this.name} (${this.ID2})` : this.ID3 ? `${this.name} (${this.ID3})` : this.name; }})`SELECT DISTINCT ?item ?itemLabel ?isoCode2 ?isoCode3 ?latitude ?longitude WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } { SELECT DISTINCT ?item WHERE { ?item p:P31 ?statement0. ?statement0 (ps:P31/(wdt:P279*)) wd:Q6256. } } OPTIONAL { ?item p:P297 ?isoStatement2. ?isoStatement2 ps:P297 ?isoCode2. ?item p:P298 ?isoStatement3. ?isoStatement3 ps:P298 ?isoCode3. ?item p:P625 ?coordinateLocationStatement. ?coordinateLocationStatement psv:P625 ?coordinateLocationValue. ?coordinateLocationValue wikibase:geoLatitude ?latitude. ?coordinateLocationValue wikibase:geoLongitude ?longitude. } FILTER NOT EXISTS { ?item p:P31 wd:Q3024240. } }`48:T1310,querySPARQL = { return querySPARQL; function querySPARQL(query) { var opts; if (arguments.length == 0) { return querySPARQL; } else if (Array.isArray(arguments[0]) && Array.isArray(arguments[0].raw)) { // called as tagged template – start query query = String.raw(...arguments); } else if (arguments.length == 1 && isStr(query)) { // called with just one string – start query } else if (arguments.length == 1 && typeof query === "object") { // called with just one object – set options opts = query; return (...args) => args.length == 1 ? querySPARQL(opts, String(args.shift())) : isTaggedArr(args[0]) ? querySPARQL(opts, String.raw(...args)) : (cause => { throw new SyntaxError(`With multiple arguments, only a tagged template can be expected.`, {cause}); })(args); } else if (arguments.length == 2 && typeof arguments[0] === "object" && isStr(arguments[1])) { // called with options & query – start query opts = arguments[0]; query = arguments[1]; } else { throw new SyntaxError(`${querySPARQL.name} must be called in one of these ways: ⁃ as a tagged template \tto initiate the query ${[ ["query", "to initiate the query"], ["options", "to set the options and get a configured function"], ["options", "query", "to set the options and initiate the query"] ].map(args => `⁃ ${querySPARQL.name}(${args.slice(0, -1).join(", ")}) \t${args.at(-1)}`).join("\n")}`); } let request = fetch(`${opts?.endpoint || "//query.Wikidata.org/sparql"}?query=${encodeURIComponent(query)}`, { headers: { Accept: "application/sparql-results+json" }}) .then(response => response.json()); if (opts) { if (opts.mapVars) { request = request.then(mapVars(opts.mapVars)); } if (opts.name) { request = request.then(namer(opts.name)); } if (opts.brief) { request = request.then(makeBrief); } } return request; } function isStr(v) { switch (typeof v) { case "string": return true; case "object": return v !== null && v instanceof String; } } function isTaggedArr(arr) { return Array.isArray(arr) && Array.isArray(arr.raw); } function makeBrief(o) { for (let binding of o.results.bindings) { for (let variable of o.head.vars) { ( typeof binding === "object" && typeof binding[variable] === "object" && "value" in binding[variable] ) && ( binding[variable] = binding[variable].value ); } } setDesc(o.results.bindings, "columns", { configurable: true, writable: true, value: o.head.vars }); return o.results.bindings; } function mapVars(map) { if (map === null || typeof map !== "object") { throw new TypeError(`${mapVars.name}(${map === null ? "null" : typeof map}) is invalid.`); } if (typeof map[Symbol.iterator] === "function") { let newMap = new Map(); for (let [k, v] of map) { newMap.set(String(k), v == null ? null : String(v)); } map = newMap; newMap = undefined; } else { let newMap = new Map(); for (let k of ownKeys(map)) { if (typeof k !== "string") { continue; } let v = map[k]; newMap.set(k, v == null ? null : String(v)); } map = newMap; newMap = undefined; } return o => { let variables = o.head.vars; let variablesOrig = [...variables]; let toDelete = new Set(); adjustHeader: for (let i = variables.length - 1; i >= 0; i--) { let name = variables[i]; if (map.has(name)) { let newName = map.get(name); if (newName == null) { toDelete.add(name); variables.splice(i, 1); } else { variables[i] = newName; } } } adjustResults: for (let binding of o.results.bindings) { for (let original of variablesOrig) { if (ownProp(binding, original) && map.has(original)) { if (!toDelete.has(original)) { binding[map.get(original)] = binding[original]; } delete binding[original]; } } } return o; }; } function namer(name) { const descriptor = typeof name === "function" ? { enumerable: false, configurable: false, get: name } : { enumerable: false, configurable: false, writable: false, value: name }; return o => { for (let binding of o.results.bindings) { if (typeof binding === "object") { setDesc(binding, Symbol.toStringTag, descriptor); } } return o; } } }49:[] 44:{"id":"539603542b7e632f","slug":"sparql-query","title":"Wikidata SPARQL query","thumbnail":"acf0057f055ae0d499f3f59ab788480cb298e72daf215dcf61dad8dc8312c196","access_level":"public","create_time":"$D2023-08-23T02:07:22.660Z","update_time":"$D2023-08-23T03:27:08.252Z","view_time":null,"first_public_time":"$D2023-08-23T02:07:22.660Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"d2b7afa3a61febdf","login":"rmw4269","name":"Riley","avatar_url":"https://avatars-next.observableusercontent.com/839ad38e4ca0e32eaad7be29b5bc0c3a7f4304d5f91dd0f3642acf08015b6530","tier":"starter_2024","bio":"I enjoy spreadsheets and JavaScript way too much.","following":false},"version":63,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"817e538440b46e8a","login":"rmw4269","name":"Riley","avatar_url":"https://avatars-next.observableusercontent.com/839ad38e4ca0e32eaad7be29b5bc0c3a7f4304d5f91dd0f3642acf08015b6530","tier":null,"bio":"I enjoy spreadsheets and JavaScript way too much.\n\ntrust://Riley.science!","following":false}],"members":[{"type":"individual","id":"817e538440b46e8a","login":"rmw4269","name":"Riley","avatar_url":"https://avatars-next.observableusercontent.com/839ad38e4ca0e32eaad7be29b5bc0c3a7f4304d5f91dd0f3642acf08015b6530","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Wikidata SPARQL query","cells":[{"id":0,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"$47","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"import {setDesc, ownProp, ownKeys} from \"@rmw4269/properties\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 45:"$44:body"