Public
Edited
Nov 5, 2022
1 star
viewof labels_table = Inputs.table(labels)
Plot.plot({
color: {
legend: true
},
width: 1000,
marginLeft: 120,
marks: [
Plot.barX(labels, {
x: "Number",
y: "Label",
sort: {
y: "x",
reverse: false
}
}),
Plot.ruleX([0])
]
})
viewof table_descriptions = Inputs.table(descriptions)
viewof table_aliases = Inputs.table(aliases)
Plot.plot({
color: {
legend: true
},
width: 1000,
marginLeft: 120,
marks: [
Plot.barX(aliases, {
x: "Number",
y: "Label",
sort: {
y: "x",
reverse: false
}
}),
Plot.ruleX([0])
]
})
sovereign_state_labels = d3.group(sovereign_states, d => d.Label)
function query_wikidata(query){
let results_json = fetch(`https://query.wikidata.org/sparql?query=${encodeURIComponent(query)}`, {headers: {accept: "application/sparql-results+json"}}).then(response => response.json())
return results_json
}
function parse_values(results_json) {
return results_json.results.bindings
}
function extract_identifiers_labels_number(result_values) {
let identifiers_labels = result_values.map(function (d) {
let output = {
Identifier: d.item.value.replace("http://www.wikidata.org/entity/", ""),
Label: d.label.value,
Number: parseInt(d.number.value)
};
return output;
});
return identifiers_labels;
}
function extract_identifiers_labels_date(result_values) {
let identifiers_labels = result_values.map(function (d) {
let output = {
Identifier: d.item.value.replace("http://www.wikidata.org/entity/", ""),
Label: d.label.value,
Date: d.date.value.slice(0, 10)
};
return output;
});
return identifiers_labels;
}
function extract_identifiers_labels(result_values) {
let identifiers_labels = result_values.map(function(d) {
let output = {
Identifier: d.item.value.replace("http://www.wikidata.org/entity/",""),
Label: d.label.value
};
return output;
})
return identifiers_labels
}
cities_sparql_query = `SELECT DISTINCT ?item ?label {
?item wdt:P31 wd:Q515;
wdt:P17 wd:` + sovereign_state.Identifier + `;
rdfs:label ?label.
FILTER (lang(?label) = "en")
}`
cities_json = query_wikidata(cities_sparql_query)
cities = get_identifiers_label(cities_json)
sitelinks_response_json = query_wikidata(sitelinks_query)
sitelinks = get_identifiers_label_number(sitelinks_response_json)
properties_response_json = query_wikidata(properties_query);
properties = get_identifiers_label_number(properties_response_json)
labels_query = `SELECT DISTINCT ?item ?label (count (?mlabel) as ?number) WHERE {
?item wdt:P31 wd:Q515;
wdt:P17 wd:` +
sovereign_state.Identifier +
`;
rdfs:label ?mlabel;
rdfs:label ?label.
FILTER((LANG(?label)) = "en")
}
GROUP by ?item ?label
`
labels_json = query_wikidata(labels_query)
labels = get_identifiers_label_number(labels_json)
descriptions_json = query_wikidata(descriptions_query)
descriptions = get_identifiers_label_number(descriptions_json)
aliases_query = `SELECT DISTINCT ?item ?label (count (?alias) as ?number) WHERE {
?item wdt:P31 wd:Q515;
wdt:P17 wd:` +
sovereign_state.Identifier +
`;
skos:altLabel ?alias;
rdfs:label ?label.
FILTER((LANG(?label)) = "en")
}
GROUP by ?item ?label`
aliases_json = query_wikidata(aliases_query)
aliases = get_identifiers_label_number(aliases_json)
function get_identifiers_label_number(response_json) {
let response_values = parse_values(response_json);
let values = extract_identifiers_labels_number(response_values);
return values;
}
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.
