4. Tutorial

Linking 1921 Death Duty Data to Civil Registry Data

We can convert the Tafel-Vbis data to Linked Data with CoW by modifying the metadata.json as follows:

{
 "@context": [
  "https://raw.githubusercontent.com/CLARIAH/COW/master/csvw.json",
  {
   "@language": "en",
   "@base": "https://iisg.amsterdam/tafelvbis/sample/"
  },
  {
   "aat": "http://vocab.getty.edu/aat/",
   "bibo": "http://purl.org/ontology/bibo/",
   "bio": "http://purl.org/vocab/bio/0.1/",
   "cidoc": "http://www.cidoc-crm.org/cidoc-crm/",
   "civ": "https://iisg.amsterdam/id/civ/",
   "class": "https://iisg.amsterdam/tafelvbis/sample/class/",
   "csvw": "http://www.w3.org/ns/csvw#",
   "dbo": "http://dbpedia.org/ontology/",
   "dc": "http://purl.org/dc/terms/",
   "dc11": "http://purl.org/dc/elements/1.1/",
   "dcterms": "http://purl.org/dc/terms/",
   "ecpo": "http://purl.org/ontology/ecpo#",
   "foaf": "http://xmlns.com/foaf/0.1/",
   "frbr": "http://purl.org/spar/frbr/core#",
   "geo": "http://www.opengis.net/ont/geosparql#",
   "geonames": "http://www.geonames.org/ontology#",
   "gg": "http://www.gemeentegeschiedenis.nl/gg-schema#",
   "gg-municipality": "http://www.gemeentegeschiedenis.nl/gemeentenaam/",
   "gg-province": "http://www.gemeentegeschiedenis.nl/provincie/",
   "hisco-code": "https://iisg.amsterdam/resource/hisco/code/hisco/",
   "gvp": "http://vocab.getty.edu/ontology#",
   "juso": "http://http://rdfs.co/juso/",
   "lemon": "http://lemon-model.net/lemon#",
   "midi": "http://purl.org/midi-ld/midi#",
   "np": "http://www.nanopub.org/nschema#",
   "owl": "http://www.w3.org/2002/07/owl#",
   "periodo": "http://n2t.net/ark:/99152/p0v#",
   "pnv": "https://www.lodewijkpetram.nl/vocab/pnv/doc/",
   "prov": "http://www.w3.org/ns/prov#",
   "qb": "http://purl.org/linked-data/cube#",
   "rdf": "http://www.w3.org/1999/02/22-rdf-syntax-ns#",
   "rdfs": "http://www.w3.org/2000/01/rdf-schema#",
   "schema": "http://schema.org/",
   "sdmx-concept": "http://purl.org/linked-data/sdmx/2009/concept#",
   "sdr": "https://iisg.amsterdam/tafelvbis/sample/",
   "sdv": "https://iisg.amsterdam/tafelvbis/sample/vocab/",
   "sem": "http://semanticweb.cs.vu.nl/2009/11/sem/",
   "skos": "http://www.w3.org/2004/02/skos/core#",
   "time": "http://www.w3.org/2006/time#",
   "ulan": "http://vocab.getty.edu/ulan/",
   "wgs84": "http://www.w3.org/2003/01/geo/wgs84_pos#",
   "xml": "http://www.w3.org/XML/1998/namespace/",
   "xsd": "http://www.w3.org/2001/XMLSchema#"
  }
 ],
 "tableSchema": {
  "aboutUrl": "{_row}",
  "primaryKey": "ID",
  "columns": [
   {
    "name": "ID",
    "datatype": "integer",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/ID",
    "dc:description": "Identification Number in database (added)",
    "titles": ["Identification Number"]
   },
   {
    "name": "Ref_Reg",
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Ref_Reg",
    "dc:description": "Reference to the underlying memorie of sucession. Original source has / instead of #. / were replaced because of the tendency to change into dates.",
    "titles": ["Reference to Memorie of Succession"]
   },
   {
    "name": "Family-Name",
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/Family-Name",
    "dc:description": "Family Name of the deceased",
    "titles": ["Family Name"],
    "propertyUrl": "schema:familyName",
    "csvw:value": "{Family-Name}"
   },
   {
    "name": "First_Name",
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/First_Name",
    "dc:description": "First Name of the deceased",
    "titles": ["First Name"],
    "propertyUrl": "schema:givenName",
    "csvw:value": "{First_Name}"
   },
   {
    "name": "Gender",
    "null": ["GO"],
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Gender",
    "dc:description": "0=male, 1=female, GO=unknown (added)",
    "titles": ["Gender"],
    "propertyUrl": "schema:gender",
    "csvw:value": "{% if Gender == '1' %}Female{% else %}Male{% endif %}"
   },
   {
    "name": "Profession",
    "null": [""],
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Profession",
    "dc:description": "Profession of the deceased",
    "titles": ["Profession"],
    "propertyUrl": "schema:hasOccupation",
    "csvw:value": "{Profession}"
   },
   {
    "name": "Hisco",
    "null": [""],
    "datatype": "integer",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Hisco",
    "dc:description": "Hisco classification of the profession (added)",
    "titles": ["HISCO"],
    "propertyUrl": "schema:occupationalCategory",
    "valueUrl": "hisco-code:{{'%05d'|format(Hisco|int)}}"
   },
   {
    "name": "Hisclass",
    "null": [""],
    "datatype": "integer",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Hisclass",
    "dc:description": "Historical Class Scheme, based on Hisco (added)",
    "titles": ["HISCLASS"]
   },
   {
    "name": "Hiscam",
    "null": [""],
    "datatype": "float",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Hiscam",
    "dc:description": "Historical Camsis classification, based on Hisco (added)",
    "titles": ["HISCAM"],
    "propertyUrl": "vocab/hiscamscale",
    "csvw:value": "{{Hiscam|replace(',', '.')}}"
   },
   {
    "name": "Residence",
    "datatype": "gg:municipality",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Residence",
    "dc:description": "Place of residence of the deceased",
    "titles": ["Residence"],
    "propertyUrl": "schema:Residence",
    "valueUrl": "gg-municipality:{Residence}"
   },
   {
    "name": "Place_Birth",
    "datatype": "gg:municipality",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Place_Birth",
    "dc:description": "Place of Birth of the deceased",
    "titles": ["Place of Birth"],
    "propertyUrl": "schema:birthPlace",
    "valueUrl": "gg-municipality:{Place_Birth}"
   },
   {
    "name": "Age",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Age",
    "dc:description": "Age calculated based on year of birth and year of death (added)",
    "titles": ["Age"]
   },
   {
    "name": "Year_Birth",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Year_Birth",
    "dc:description": "Year of birth of the deceased",
    "titles": ["Year of Birth"]
   },
   {
    "name": "Month_Birth",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Month_Birth",
    "dc:description": "Month of birth of the deceased",
    "titles": ["Month of Birth"]
   },
   {
    "name": "Day_Birth",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Day_Birth",
    "dc:description": "Day of birth of the deceased",
    "titles": ["Day of Birth"]
   },
   {
    "name": "Marital_Status",
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Marital_Status",
    "dc:description": "Marital Status of the deceased. A: unmarried, B:married, C:widow(er), D:has children",
    "titles": ["Marital Status"],
    "propertyUrl": "vocab/marital_status",
    "csvw:value": "{% if Marital_Status == 'a' %}unmarried{% elif Marital_Status == 'b' %}married{% elif Marital_Status == 'c' or Marital_Status == 'C' %}widow(er){% elif Marital_Status == 'd' %}has children{% elif Marital_Status == 'b;c' %}married;widow(er){% endif %}"
   },
   {
    "name": "Divorced",
    "null": [""],
    "datatype": "xsd:boolean",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Divorced",
    "dc:description": "0=no, 1=yes, blank=not listed",
    "titles": ["Divorced"],
    "propertyUrl": "vocab/divorced",
    "csvw:value": "{% if Divorced == '0' %}false{% else %}true{% endif %}"
   },
   {
    "name": "Children",
    "null": [""],
    "datatype": "xsd:boolean",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Children",
    "dc:description": "0=no, 1=yes, blank=not listed",
    "titles": ["Children"],
    "propertyUrl": "vocab/children",
    "csvw:value": "{% if Children == '0' %}false{% else %}true{% endif %}"
   },
   {
    "name": "Year_Death",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Year_Death",
    "dc:description": "Year of death of the deceased",
    "titles": ["Year of Death"]
   },
   {
    "name": "Month_Death",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Month_Death",
    "dc:description": "Month of death of the deceased",
    "titles": ["Month of Death"]
   },
   {
    "name": "Day_Death",
    "datatype": "int",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Day_Death",
    "dc:description": "Day of death of the deceased",
    "titles": ["Day of Death"]
   },
   {
    "name": "Net_value",
    "datatype": "float",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Net_value",
    "dc:description": "Listed net value of the estate, CVO= Certificaat van Onvermogen (meaning the deceased was too poor to pay taxes)",
    "titles": ["Net Value"],
    "propertyUrl": "vocab/netvalue",
    "csvw:value": "{{Net_value|replace(',', '.')}}"
   },
   {
    "name": "Kantoor",
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Kantoor",
    "dc:description": "Administrative unit where the registration was made"
   },
   {
    "name": "Province",
    "datatype": "gg:province",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Province",
    "propertyUrl": "vocab/ggprovince",
    "valueUrl": "gg-province:{Province}"
   },
   {
    "name": "Class",
    "datatype": "string",
    "@id": "https://iisg.amsterdam/tafelvbis/sample/column/Class",
    "dc:description": "Wealth class the deceased belonged to. 1= those who owned less than 1000 guilders, 2=0 to 70th percentile, 3=70 to 85th percentile, 4=85 to 95th percentile, 5=95 to 99th percentile, 6=99 to 100th percentile. All percentiles are calculated on the provincial level. Intervals are structured as ]-]. (added)",
    "propertyUrl": "vocab/class",
    "valueUrl": "class:{Class}"
   },
   {
    "virtual": "true",
    "datatype": "xsd:date",
    "propertyUrl": "schema:birthDate",
    "dc:description": "Date of death",
    "csvw:value": "{{['%04d'| format(Year_Birth|int),'-','%02d' | format(Month_Birth|int),'-','%02d'|format(Day_Birth|int)]|join}}"
    },
     {
    "virtual": "true",
    "datatype": "xsd:date",
    "propertyUrl": "schema:deathDate",
    "dc:description": "Date of death",
    "csvw:value": "{{['%04d'| format(Year_Death|int),'-','%02d' | format(Month_Death|int),'-','%02d'|format(Day_Death|int)]|join}}"
    }
  ]
 },
 "url": "tafelvbis.csv",
 "dialect": {
  "delimiter": ";",
  "encoding": "ascii",
  "quoteChar": "\""
 },
 "dc:title": "tafelvbis.csv",
 "dcat:keyword": [],
 "dc:publisher": {
  "schema:name": "CLARIAH Structured Data Hub - Datalegend",
  "schema:url": {
   "@id": "http://datalegend.net"
  }
 },
  "dc:creator": [{
    "@id": "r.peeters",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "owl:sameAs": [{
        "@id": "http://orcid.org/0000-0002-5238-3352"
    }],
    "foaf:name": "Ruben Peeters",
    "foaf:givenName": "Ruben",
    "foaf:familyName": "Peeters"
    }, {
    "@id": "a.de.vicq.de.cumptich",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "foaf:name": "Amaury de Vicq de Cumptich",
    "foaf:familyName": "de Vicq de Cumptich",
    "foaf:givenName": "Amaury"
},
{
	"@id": "j.jonker",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "owl:sameAs": [{
        "@id": "info:eu-repo/dai/nl/075034638"
	},{
    	"@id": "https://isni.org/isni/00000000110495797"
    }],
    "foaf:name": "Joost Jonker",
    "foaf:familyName": "Jonker",
    "foaf:givenName": "Joost"
},
{
	 "@id": "o.gelderblom",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "owl:sameAs": [{
        "@id": "scopus:6506068867"
	}],
    "foaf:name": "Oscar Gelderblom",
    "foaf:familyName": "Gelderblom",
    "foaf:givenName": "Oscar"
},
{
	 "@id": "m.donck",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "foaf:name": "Marlon Donck",
    "foaf:familyName": "Donck",
    "foaf:givenName": "Marlon"
}, {
	 "@id": "p.schilder",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "foaf:name": "Paul Schilder",
    "foaf:familyName": "Schilder",
    "foaf:givenName": "Paul"
}, {
	 "@id": "t.verburg",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "foaf:name": "Tirreg Verburg",
    "foaf:familyName": "Verburg",
    "foaf:givenName": "Tirreg"
    }, {
	"@id": "g.wieman",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "owl:sameAs": [{
        "@id": "scopus:57194142788"
	}
	],
    "foaf:name": "Guus Wieman",
    "foaf:familyName": "Wieman",
    "foaf:givenName": "Guus"
}, {
	 "@id": "e.vandongen",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "foaf:name": "Elien Vandongen",
    "foaf:familyName": "Vandongen",
    "foaf:givenName": "Elien"
}, {
	 "@id": "d.hendrikx",
    "rdf:type": [{
        "@id": "foaf:Person"
    }, {
        "@id": "prov:Person"
    }],
    "foaf:name": "Daan Hendrikx",
    "foaf:familyName": "Hendrikx",
    "foaf:givenName": "Daan"
}
],
 "prov:wasDerivedFrom": [{
    "@id": "doi:10.24416/UU01-QG9Q8B",
    "rdf:type": {
        "@id": ""
    },
    "dc:title": {
        "@value": "Tafel-Vbis: Summary of all death duties in the Netherlands in 1921",
        "@lang": "nl"
    },
    "schema:author": ["Ruben Peeters", "Amaury de Vicq de Cumptich", "Joost Jonkers", "Oscar Gelderblom"],
    "dc:publisher": "Yoda",
    "dc:date": {"@value":"2019-07-12","@type":"xsd:date"}
}, {
    "@id": "https://public.yoda.uu.nl/i-lab/UU01/QG9Q8B.html"
}],
 "dc:license": {
  "@id": "https://creativecommons.org/licenses/by-sa/4.0/"
 },
 "dc:modified": {
  "@value": "2023-02-09",
  "@type": "xsd:date"
 },
 "@id": "https://iisg.amsterdam/tafelvbis.csv"
}