PREFIX schema: PREFIX rdf: PREFIX rdfs: PREFIX reg: PREFIX col: PREFIX rico: PREFIX plaats: PREFIX beroep: PREFIX id: PREFIX skos: PREFIX dbo: CONSTRUCT { reg:Register a schema:Dataset ; schema:name "Bevolkingsregister 1814" , ?jaar ; schema:isBasedOn "Bevolkingsregister1814.csv" ; schema:datePublished "10 september 2020" . plaats:DenBosch a rico:Place ; rico:hasPlaceName "'s-Hertogenbosch" ; rico:hasPlaceType "plaats" ; schema:isPartOf reg:Register . ?uri_persoon a schema:Person ; rdfs:label ?label ; schema:streetAddress ?full_address ; schema:givenName ?givenName ; schema:familyName ?fullFamilyName ; schema:birthDate ?birthDate ; schema:birthPlace ?birthPlace ; schema:gender ?gender ; schema:jobTitle ?uri_beroep ; dbo:religon ?godsdienst ; schema:comment ?comment ; schema:identifier ?identifier ; schema:image ?bestandsnaam ; rico:hasLocation ?uri_wijk ; rico:source ?source ; schema:isPartOf reg:Register . ?uri_wijk a rico:Place ; rdfs:label ?wijk ; rico:hasPlaceName ?wijk ; rico:hasPlaceType "wijk" ; rico:isContainedBy plaats:DenBosch ; schema:isPartOf reg:Register . ?uri_beroep a skos:Concept ; rdfs:label ?jobTitle ; schema:isPartOf reg:Register . } FROM WHERE { ?uri a schema:Person BIND(IRI(REPLACE(?uri,"/id/","_")) as ?uri_persoon) OPTIONAL { ?uri col:Straat ?address } OPTIONAL { ?uri col:Nummer ?nummer } OPTIONAL { ?uri col:Voornamen ?givenName } OPTIONAL { ?uri col:Naam ?familyName } OPTIONAL { ?uri col:Tussenvoegsel ?tussen } OPTIONAL { ?uri col:Geboortedatum ?birthDate } OPTIONAL { ?uri col:Geboorteplaats ?birthPlace } OPTIONAL { ?uri col:Geslacht ?raw_gender BIND(IF(?raw_gender="m","man",IF(?raw_gender="v","vrouw","onbekend")) as ?gender) } OPTIONAL { ?uri col:Wijk ?raw_wijk BIND(IRI(CONCAT("https://data.netwerkdigitaalerfgoed.nl/denbosch/plaats/1814/",REPLACE(LCASE(?raw_wijk)," ","") )) as ?uri_wijk) } OPTIONAL { ?uri col:Beroep\(en\) ?raw_jobTitle BIND(LCASE(?raw_jobTitle) as ?jobTitle) } OPTIONAL { ?uri col:Godsdienst ?godsdienst } OPTIONAL { ?uri col:Opmerkingen ?comment } OPTIONAL { ?uri col:Inventarisnummer ?inventarisnummer } OPTIONAL { ?uri col:folionummer ?folionummer } OPTIONAL { ?uri col:Bestandsnaam ?image } BIND(IF(BOUND(?jobTitle)&&!(?jobTitle=""), IRI(CONCAT("https://data.netwerkdigitaalerfgoed.nl/denbosch/beroep/1814/",REPLACE(?jobTitle," ","_"))), IRI("https://data.netwerkdigitaalerfgoed.nl/denbosch/beroep/1814/onbekend/")) as ?uri_beroep) BIND(CONCAT(IF(BOUND(?address),?address,"")," ",IF(BOUND(?nummer),?nummer,"")) as ?full_address) BIND(CONCAT( IF(BOUND(?familyName),?familyName,""), IF(BOUND(?tussen)&&BOUND(?givenName)&&!(?tussen=?givenName),CONCAT(", ",?tussen),"") ) as ?fullFamilyName) BIND(CONCAT( IF(BOUND(?givenName),?givenName,""), IF(BOUND(?tussen)&&BOUND(?givenName)&&!(?tussen=?givenName),CONCAT(" ",?tussen),""), IF(BOUND(?familyName),CONCAT(" ",?familyName),"") ) as ?raw_label) BIND(IF(?raw_label="","onbekend",?raw_label) as ?label) BIND(CONCAT( IF(BOUND(?inventarisnummer),?inventarisnummer,""), IF(BOUND(?folionummer),CONCAT(" : ",?folionummer),"") ) as ?source) }

denbosch-bevolkingsregister-1814

API

Variables