PREFIX bif: PREFIX skos: PREFIX rdf: PREFIX rdfs: PREFIX schema: PREFIX person: PREFIX event: PREFIX bio: PREFIX iisgv: PREFIX xsd: SELECT DISTINCT ?b_year (avg(?hiscam2) as ?hiscam_father) (avg(?hiscam3) as ?hiscam_grandfather) WHERE { #birth info ?birth_1 a bio:Birth . ?birth_1 iisgv:newborn ?person1 . #?person1 schema:gender "m" . ?birth_1 bio:date ?b_date . ?birth_1 schema:location ?location . ?location rdfs:label ?birthplace . ?birth_1 iisgv:father ?person2 . #?person2 iisgv:ageYears ?age_father . ?person2 schema:hasOccupation ?occ2. ?occ2 ?hiscam2. ?birth_2 a bio:Birth . ?birth_2 iisgv:newborn ?person2 . ?birth_2 bio:date ?b2_date . ?birth_2 iisgv:father ?person3 . ?person3 schema:hasOccupation ?occ3. ?occ3 ?hiscam3. ?birth_3 a bio:Birth . ?birth_3 iisgv:newborn ?person3 . ?birth_3 bio:date ?b3_date . FILTER(xsd:int(year(?b2_date)) < xsd:int(year(?b_date)-16)) FILTER(xsd:int(year(?b3_date)) < xsd:int(year(?b2_date)-16)) #FILTER(xsd:int(year(?b4_date)) < xsd:int(year(?b3_date)-16)) BIND(YEAR(?b_date) as ?b_year) FILTER(?b_year < 1921 && ?b_year > 1850) } ORDER BY ASC (?b_year)

social-mobility-births

API

Variables