Public
Edited
Feb 19, 2023
1 star
Computing Jaccard similarity between Wikidata items🇪🇺 Members of European Parliament 🇪🇺The media directoryAu bord de l'eauC'est pas gégé !Social reproduction in the French cinema: evidence from WikidataProbability of having notable parents by country of citizenshipActress-singers and actor-singers (v2)Tribute to Annie ErnauxTribute to JLGAll Tour de France's stage winners by country of citizenship with flagAll Vuelta's stage winners by country of citizenshipHello SPARQL queries datasetTour de France FemmesTour de France's stage winners by countryWikidata Property searchActress-singers and actor-singers: do actresses become singers and singers become actors?Tour de France's history at a glanceLes libellés francophones genrés dans WikidataTour de France's stage winnersWikidata APIAn introduction to Observable for Wikidata usersWikidata's Q item explorerHow to get Wikidata claims from Wikipedia sitelinks using Wikidata API ?Introduction à Observable pour les utilisateurs de WikidataAre occupation labels in Wikidata gender neutral?
Social reproduction in the French cinema: Occupations of the parents
df = get_parents_occupation({ occupation: occupation.qid })
get_parents_occupation = ({
occupation = "Q33999",
citizenship = "Q142",
birthyear = 1970
}) => {
const query = `PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT DISTINCT ?parentOccupation ?parentOccupationLabel (COUNT(?item) as ?count) WHERE {
?item wdt:P31 wd:Q5;
wdt:P106/wdt:P279* wd:${occupation};
wdt:P27 wd:${citizenship};
wdt:P569 ?birthdate;
rdfs:label ?itemLabel FILTER(lang(?itemLabel) = "fr") .
?sitelink schema:about ?item;
schema:isPartOf <https://fr.wikipedia.org/>.
FILTER(YEAR( ?birthdate ) >= ${birthyear} )
BIND(YEAR(?birthdate) AS ?year)
?item (wdt:P22|wdt:P25) ?parent.
?parentlink schema:about ?parent;
schema:isPartOf <https://fr.wikipedia.org/>.
?parent rdfs:label ?parentLabel ;
wdt:P106 ?parentOccupation.
?parentOccupation rdfs:label ?parentOccupationLabel .
FILTER(lang(?parentLabel) = "fr")
FILTER(lang(?parentOccupationLabel) = "fr")
}
GROUP BY ?parentOccupation ?parentOccupationLabel
ORDER BY DESC(?count)`;
return fetch(
`https://qlever.cs.uni-freiburg.de/api/wikidata?query=${encodeURIComponent(
query
)}`,
{ headers: { accept: "application/sparql-results+json" } }
)
.then((response) => response.json())
.then((res) =>
aq.from(
res.results.bindings.map((d) => ({
parentOccupation: d.parentOccupation.value,
parentOccupationLabel: d.parentOccupationLabel.value,
count: d.count.value
}))
)
);
}
// colors from https://colorhunt.co/palette/86a3b8e8d2a6f48484f55050
function sparkbar(max) {
return (x) => htl.html`<div style="
background: #EAC7C7;
color: #444444 ;
width: ${(5 * x) / max}%;
float: left;
padding-right: 3px;
padding-left: 3px;
box-sizing: border-box;
overflow: visible;
display: flex;
justify-content: start;">${x.toLocaleString("en")}`;
}
import { aq, op } from "@uwdata/arquero"
import { stylesheet } from "@ajar/css"
stylesheet
import {get_labels} from "@pac02/what-kind-of-articles-have-you-created"
import {qid, property} from "@pac02/hello-sparql-queries-dataset"
One platform to build and deploy the best data apps
Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.