Automate GND reconciliation for OpenRefine

lobid-gnd-reconciliation-data.csv

name;beruf;ort
J. Weizenbaum;Informatiker;Berlin
Twain, Mark;Schriftsteller;
Kumar, Lalit;;
Jemand;;

lobid-gnd-reconciliation-history.json

[
  {
    "op": "core/recon",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "name",
    "config": {
      "mode": "standard-service",
      "service": "https://lobid.org/gnd/reconcile",
      "identifierSpace": "https://lobid.org/gnd",
      "schemaSpace": "https://lobid.org/gnd",
      "type": {
        "id": "Person",
        "name": "Person"
      },
      "autoMatch": true,
      "columnDetails": [
        {
          "column": "beruf",
          "propertyName": "Beruf oder Beschäftigung (Literal)",
          "propertyID": "professionOrOccupationAsLiteral"
        }
      ],
      "limit": 0
    },
    "description": "Reconcile cells in column name to type Person"
  },
  {
    "op": "core/extend-reconciled-data",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "baseColumnName": "name",
    "endpoint": "https://lobid.org/gnd/reconcile",
    "identifierSpace": "https://lobid.org/gnd",
    "schemaSpace": "https://lobid.org/gnd",
    "extension": {
      "properties": [
        {
          "id": "professionOrOccupation",
          "name": "Beruf oder Beschäftigung"
        },
        {
          "id": "placeOfBirth",
          "name": "Geburtsort"
        },
        {
          "id": "placeOfDeath",
          "name": "Sterbeort"
        },
        {
          "id": "geographicAreaCode",
          "name": "Ländercode"
        }
      ]
    },
    "columnInsertIndex": 1,
    "description": "Extend data at index 1 based on column name"
  },
  {
    "op": "core/row-removal",
    "engineConfig": {
      "facets": [
        {
          "type": "list",
          "name": "name: judgment",
          "expression": "forNonBlank(cell.recon.judgment, v, v, if(isNonBlank(value), \"(unreconciled)\", \"(blank)\"))",
          "columnName": "name",
          "invert": false,
          "omitBlank": false,
          "omitError": false,
          "selection": [
            {
              "v": {
                "v": "none",
                "l": "none"
              }
            }
          ],
          "selectBlank": false,
          "selectError": false
        }
      ],
      "mode": "row-based"
    },
    "description": "Remove rows"
  },
  {
    "op": "core/column-removal",
    "columnName": "beruf",
    "description": "Remove column beruf"
  },
  {
    "op": "core/column-removal",
    "columnName": "ort",
    "description": "Remove column ort"
  }
]

lobid-gnd-reconciliation.ipynb