Generating RDF from Tabular Data on the Web

Abstract

This document defines the procedures and rules to be applied when converting tabular data into RDF. Tabular data may be complemented with metadata annotations that describe its structure, the meaning of its content and how it may form part of a collection of interrelated tabular data. This document specifies the effect of this metadata on the resulting RDF.

4. Converting Tabular Data to RDF

The procedures for converting delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data into RDF are described below for both delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN"> insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal modes.

4.1 Algorithm terms

delete: <dfn id="dfn-about-url"> insert: <dfn data-dfn-type="dfn" id="dfn-about-url"> about URL: The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation on the current delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell . As defined in [ tabular-data-model ].
delete: <dfn id="dfn-annotated-table"> insert: <dfn data-dfn-type="dfn" id="dfn-annotated-table"> annotated table: The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-annotated-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-annotated-table" class="externalDFN"> annotated table is defined in [ tabular-data-model ] as describing a particular delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> table and its annotations.
delete: <dfn id="dfn-blank-node"> insert: <dfn data-dfn-type="dfn" id="dfn-blank-node"> blank node: A blank node is defined in [ rdf11-concepts ] as an RDF Term disjoint from IRIs or delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literals .
delete: <dfn id="dfn-cell"> insert: <dfn data-dfn-type="dfn" id="dfn-cell"> cell: A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell is defined in [ tabular-data-model ] as the intersection of a delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row and a delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column within a delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
delete: <dfn id="dfn-cell-errors"> insert: <dfn data-dfn-type="dfn" id="dfn-cell-errors"> cell errors: delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-errors" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-errors" class="externalDFN"> Cell errors are defined in [ tabular-data-model ] as a (possibly empty) list of validation errors generated while parsing the literal content of a delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell to generate the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN"> insert: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> semantic value .
delete: <dfn id="dfn-cell-value"> insert: <dfn data-dfn-type="dfn" id="dfn-cell-value"> cell value: A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-value" class="externalDFN"> cell value is defined in [ tabular-data-model ] as the semantic value of the delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell ; this MAY be null or a sequence of values.
delete: <dfn id="dfn-column"> insert: <dfn data-dfn-type="dfn" id="dfn-column"> column: A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> column is defined in [ tabular-data-model ] as a vertical arrangement of delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells within a delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
delete: <dfn id="dfn-group-of-tables"> insert: <dfn data-dfn-type="dfn" id="dfn-group-of-tables"> group of tables: A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-group-of-tables" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-group-of-tables" class="externalDFN"> group of tables is defined in [ tabular-data-model ] as comprising a set of delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated tables and a set of annotations that relate to that group.
delete: <dfn id="dfn-group-of-tables-identifier"> insert: <dfn data-dfn-type="dfn" id="dfn-group-of-tables-identifier"> group of tables identifier: The group of tables identifier is the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-group-id" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-group-id" class="externalDFN"> id annotation on a delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables . As defined in [ tabular-data-model ].
delete: <dfn id="dfn-literal-node"> insert: <dfn data-dfn-type="dfn" id="dfn-literal-node"> literal node: A literal node is defined in [ rdf11-concepts ] as a delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node within an RDF graph that provides values such as strings, numbers, and dates.
delete: <dfn id="dfn-node"> insert: <dfn data-dfn-type="dfn" id="dfn-node"> node: A node is defined in [ rdf11-concepts ] as a subject or an object of an RDF triple. When in subject position, it can be either a delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node or identified with a URL; when in object position, it can be a delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node , a delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal , or identified with a URL.
delete: <dfn id="dfn-non-core-annotations"> insert: <dfn data-dfn-type="dfn" id="dfn-non-core-annotations"> non-core annotations: Core annotations are listed in [ tabular-data-model ]; delete: <a title="group of tables" href="#dfn-group-of-tables" class="internalDFN"> insert: <a data-lt="group of tables" href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> groups of tables and delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables may also have other annotations that are not defined in that specification; these are known as delete: <a href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations .
delete: <dfn id="dfn-notes"> insert: <dfn data-dfn-type="dfn" id="dfn-notes"> notes: A list of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-notes" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-notes" class="externalDFN"> notes , as defined in [ tabular-data-model ], attached to an delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table or delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables using the notes property. This may be an empty list.
delete: <dfn id="dfn-predicate"> insert: <dfn data-dfn-type="dfn" id="dfn-predicate"> predicate: A predicate is defined in [ rdf11-concepts ] as an IRI that denotes the property used to relate delete: <a title="node" href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> nodes within an RDF triple.
delete: <dfn id="dfn-prefixed-name"> insert: <dfn data-dfn-type="dfn" id="dfn-prefixed-name"> prefixed name: A prefixed name is an abbreviation for a URI, in the syntax prefix : name . See delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#names-of-common-properties"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#names-of-common-properties"> Names of Common Properties in [ tabular-metadata ] for information on expansion.
delete: <dfn id="dfn-property-url"> insert: <dfn data-dfn-type="dfn" id="dfn-property-url"> property URL: The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL annotation on the current delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell . As defined in [ tabular-data-model ].
delete: <dfn id="dfn-row"> insert: <dfn data-dfn-type="dfn" id="dfn-row"> row: The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row" class="externalDFN"> row is defined in [ tabular-data-model ] as a horizontal arrangement of delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells within a delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
delete: <dfn id="dfn-row-number"> insert: <dfn data-dfn-type="dfn" id="dfn-row-number"> row number: A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-number" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-number" class="externalDFN"> row number is defined in [ tabular-data-model ] as the position of the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table , starting from 1.
delete: <dfn id="dfn-row-source-number"> insert: <dfn data-dfn-type="dfn" id="dfn-row-source-number"> row source number: A delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-source-number" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-source-number" class="externalDFN"> row source number is defined in [ tabular-data-model ] as the position of the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the source delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data-file" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data-files" class="externalDFN"> tabular data file . Provision of the delete: <a href="#dfn-row-source-number" class="internalDFN"> insert: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> row source number is dependent on parsing applications and may be reported as null .
delete: <dfn id="dfn-subject"> insert: <dfn data-dfn-type="dfn" id="dfn-subject"> subject: Within this algorithm, a delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject is the resource that the value of a given delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell refers to. This may be specified using delete: <a href="#dfn-about-url" class="internalDFN"> insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL .
delete: <dfn id="dfn-table-identifier"> insert: <dfn data-dfn-type="dfn" id="dfn-table-identifier"> table identifier: The table identifier is the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-id" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-id" class="externalDFN"> id annotation on an delete: <a href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table . As defined in [ tabular-data-model ].
delete: <dfn id="dfn-tabular-data-mapping"> insert: <dfn data-dfn-type="dfn" id="dfn-tabular-data-mapping"> tabular data mapping: The mapping from tabular data to RDF, as defined by this Recommendation.
delete: <dfn id="dfn-value-url"> insert: <dfn data-dfn-type="dfn" id="dfn-value-url"> value URL: The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotation on the current delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell" class="externalDFN"> cell . As defined in [ tabular-data-model ].

4.2 Generating RDF

A conformant RDF conversion application MUST emit triples conforming to those described in this algorithm according to the chosen mode of conversion: delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard or delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN"> insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal .

Unless specified otherwise, the steps in the algorithm defined herein apply to both delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard and delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN"> insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> minimal modes.

Note

Where an delete: <a href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table is defined in isolation (e.g. in the absence of a delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables ), a default delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables is provided with a single delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-group-tables" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-group-tables" class="externalDFN"> tables annotation that refers to the given delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .

The [ tabular-data-model ] specifies that string values within delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-tabular-data" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-tabular-data" class="externalDFN"> tabular data (such as delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-titles" class="externalDFN"> column titles or delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-string-value" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-string-value" class="externalDFN"> cell string values ) MUST contain only Unicode characters. No Unicode normalization (as specified in [ UAX15 ]) is applied to these string values during the conversion to RDF.

Note

If a CSV file is originally encoded as UTF-8, it should not go through Unicode normalization during parsing, nor in conversion to RDF. This can result in RDF literals that are not in Normal Form C as they should be according to [ rdf11-concepts ].

In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, establish a new delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G . If the delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables has an delete: <a title="group of tables identifier" href="#dfn-group-of-tables-identifier" class="internalDFN"> insert: <a data-lt="group of tables identifier" href="#dfn-group-of-tables-identifier" class="internalDFN" data-link-type="dfn"> identifier then delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G MUST be identified accordingly; else if delete: <a title="group of tables identifier" href="#dfn-group-of-tables-identifier" class="internalDFN"> insert: <a data-lt="group of tables identifier" href="#dfn-group-of-tables-identifier" class="internalDFN" data-link-type="dfn"> identifier is null , then delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G MUST be a new delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node .
In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, specify the type of delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G as csvw:TableGroup ; emit the following triple:

subject

delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G

predicate

rdf:type

object

csvw:TableGroup
In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, emit the triples generated by running the algorithm specified in section 6. JSON-LD to RDF over any delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations specified for the delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables , with delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G as an initial subject , the delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes or delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotation as property , and the value of the delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes or delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotation as value .
For each delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table where the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation is false :
1. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, establish a new delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T which represents the current delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .
  
  If the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table has an delete: <a title="table identifier" href="#dfn-table-identifier" class="internalDFN"> insert: <a data-lt="table identifier" href="#dfn-table-identifier" class="internalDFN" data-link-type="dfn"> identifier then delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T MUST be identified accordingly; else if delete: <a title="table identifier" href="#dfn-table-identifier" class="internalDFN"> insert: <a data-lt="table identifier" href="#dfn-table-identifier" class="internalDFN" data-link-type="dfn"> identifier is null , then delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T MUST be a new delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node .
2. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, relate the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table to the delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables ; emit the following triple:
  
  subject
  
  delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node G
  
  predicate
  
  csvw:table
  
  object
  
  delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T
3. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, specify the type of delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T as csvw:Table ; emit the following triple:
  
  subject
  
  delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T
  
  predicate
  
  rdf:type
  
  object
  
  csvw:Table
4. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, specify the source tabular data file URL for the current delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table based on the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-url" class="externalDFN"> url annotation; emit the following triple:
  
  subject
  
  delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T
  
  predicate
  
  csvw:url
  
  object
  
  a delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node identified by URL
5. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, emit the triples generated by running the algorithm specified in section 6. JSON-LD to RDF over any delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes and delete: <a href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations specified for the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table , with delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T as an initial subject , the delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes or delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotation as property , and the value of the delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes or delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotation as value .
  
  Note
  
  All other delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-core-annotations" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-core-annotations" class="externalDFN"> core annotations for the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table are ignored during the conversion; including information about delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-schema" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-schema" class="externalDFN"> table schemas and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column" class="externalDFN"> their insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column" class="externalDFN"> columns specified therein, delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-foreign-keys" class="externalDFN"> , insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-foreign-keys" class="externalDFN"> foreign keys , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-direction" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-direction" class="externalDFN"> table direction , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-transformations" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-transformations" class="externalDFN"> transformations , etc.
6. For each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row in the current delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table :
  1. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, establish a new delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node R which represents the current delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
  2. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, relate the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row to the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table ; emit the following triple:
    
    subject
    
    delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node T
    
    predicate
    
    csvw:row
    
    object
    
    delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R
  3. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, specify the type of delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R as csvw:Row ; emit the following triple:
    
    subject
    
    delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R
    
    predicate
    
    rdf:type
    
    object
    
    csvw:Row
  4. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, specify the delete: <a href="#dfn-row-number" class="internalDFN"> insert: <a href="#dfn-row-number" class="internalDFN" data-link-type="dfn"> row number n for the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row ; emit the following triple:
    
    subject
    
    delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R
    
    predicate
    
    csvw:rownum
    
    object
    
    a delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal n ; specified with datatype IRI xsd:integer
  5. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, specify the delete: <a href="#dfn-row-source-number" class="internalDFN"> insert: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> row source number n _source for the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within the source tabular data file URL using a fragment-identifier as specified in [ RFC7111 ]; if delete: <a href="#dfn-row-source-number" class="internalDFN"> insert: <a href="#dfn-row-source-number" class="internalDFN" data-link-type="dfn"> row source number is not null , emit the following triple:
    
    subject
    
    delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R
    
    predicate
    
    csvw:url
    
    object
    
    a delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node identified by URL #row= n _source
  6. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, if delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row titles is not null , insert any delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> titles specified for the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row . For each value, t _v , of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row titles annotation, emit the following triple:
    
    subject
    
    delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R
    
    predicate
    
    csvw:title
    
    object
    
    a delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal t _v ; specified with the the appropriate language tag (as defined in [ rdf11-concepts ]) for that delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-row-titles" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-row-titles" class="externalDFN"> row title annotation value
  7. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, emit the triples generated by running the algorithm specified in section 6. JSON-LD to RDF over any delete: <a href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations specified for the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row , with delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R as an initial subject , the delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotation as property , and the value of the delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotation as value .
  8. Establish a new delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node S _def to be used as the default subject for delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells where delete: <a href="#dfn-about-url" class="internalDFN"> insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL is undefined.
    
    Note
    
    A delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row MAY describe multiple interrelated delete: <a title="subject" href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subjects ; where the delete: <a href="#dfn-value-url" class="internalDFN"> insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL annotation on one delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell matches the delete: <a href="#dfn-about-url" class="internalDFN"> insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL annotation on another delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the same delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row .
    
    For each delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell in the current delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row where the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation for the delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column associated with that delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is false :
    1. Establish a delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node S from delete: <a href="#dfn-about-url" class="internalDFN"> insert: <a href="#dfn-about-url" class="internalDFN" data-link-type="dfn"> about URL if set, or from S _def otherwise as the current delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject .
    2. In delete: <a href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> standard mode only, relate the current delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject to the current delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row ; emit the following triple:
      
      subject
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node R
      
      predicate
      
      csvw:describes
      
      object
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node S
    3. If the value of delete: <a href="#dfn-property-url" class="internalDFN"> insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> property URL for the delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is not null , then predicate P takes the value of delete: <a href="#dfn-property-url" class="internalDFN"> insert: <a href="#dfn-property-url" class="internalDFN" data-link-type="dfn"> property URL .
      
      Else, delete: <a href="#dfn-predicate" class="internalDFN"> insert: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> predicate P is constructed by appending the value of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-name" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> name annotation for the delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column associated with the delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell to the the tabular data file URL as a fragment identifier.
    4. If the delete: <a href="#dfn-value-url" class="internalDFN"> insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL for the current delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell is not null , then delete: <a href="#dfn-value-url" class="internalDFN"> insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL identifies a delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node V _url that is related the current delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject using the delete: <a href="#dfn-predicate" class="internalDFN"> insert: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> predicate P ; emit the following triple:
      
      subject
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node S
      
      predicate
      
      P
      
      object
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node V _url
    5. Else, if the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is a delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-list" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-list" class="externalDFN"> list and the delete: <a href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-ordered" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> ordered annotation is true , then the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value provides an ordered sequence of delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal nodes for inclusion within the RDF output using an instance of rdf:List V _list as defined in [ rdf-schema ]. This instance is related to the delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject using the delete: <a href="#dfn-predicate" class="internalDFN"> insert: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> predicate P ; emit the triples defining list V _list plus the following triple:
      
      subject
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node S
      
      predicate
      
      P
      
      object
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node V _list
    6. Else, if the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is a delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-list" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-list" class="externalDFN"> list , then the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value provides an unordered sequence of delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal nodes for inclusion within the RDF output, each of which is related to the delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject using the delete: <a href="#dfn-predicate" class="internalDFN"> insert: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> predicate P . For each value provided in the sequence, add a delete: <a href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal node V _literal ; emit the following triple:
      
      subject
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node S
      
      predicate
      
      P
      
      object
      
      delete: <a href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal node V _literal
    7. Else, if the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is not null , then the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value provides a single delete: <a href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal node V _literal for inclusion within the RDF output that is related the current delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject using the delete: <a href="#dfn-predicate" class="internalDFN"> insert: <a href="#dfn-predicate" class="internalDFN" data-link-type="dfn"> predicate P ; emit the following triple:
      
      subject
      
      delete: <a href="#dfn-node" class="internalDFN"> insert: <a href="#dfn-node" class="internalDFN" data-link-type="dfn"> node S
      
      predicate
      
      P
      
      object
      
      delete: <a href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal node V _literal
      
      The delete: <a title="literal node" href="#dfn-literal-node" class="internalDFN"> insert: <a href="#dfn-literal-node" class="internalDFN" data-link-type="dfn"> literal nodes derived from the delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell values MUST be expressed according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype as defined below: Interpreting datatypes .
      
      Note
      
      In the case when a delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value does not have a delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> datatype , the conversion should insert: <em class="rfc2119" title="SHOULD"> SHOULD insert: </em> default to string .
      
      Note
      
      In the case where a sequence of values is provided, each value in the list has its own delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> datatype ; the datatype may be different for different items in the sequence.

4.3 Interpreting datatypes

delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> Cell values are expressed in the RDF output according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype . The relationship between the value of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-datatype" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-datatype" class="externalDFN"> cell value's datatype and the datatype IRI used in the RDF output is as follows:

if the datatype's delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-id" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-datatype-id" class="externalDFN"> id annotation is not null , then its value MUST be used as the RDF datatype IRI ;
else, the datatype's delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-base" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-base" class="externalDFN"> base annotation value MUST be mapped to the RDF datatype IRI using the table below. as shown below:

delete: <div class="note"> delete: <div class="note-title" aria-level="4" role="heading" id="h-note9"> delete: <span> Note delete: </span> delete: </div> delete: <div class=""> delete: <p> A datatype's delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-format" class="externalDFN"> format delete: </a> annotation is irrelevant to the conversion procedure defined in this specification; the delete: <a href="#dfn-cell-value" class="internalDFN"> cell value delete: </a> has already been parsed from the contents the delete: <a href="#dfn-cell" class="internalDFN"> cell delete: </a> according to the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-datatype-format" class="externalDFN"> format delete: </a> annotation. delete: </p> delete: <p> Where the contents of the delete: <a href="#dfn-cell" class="internalDFN"> cell delete: </a> cannot be parsed, or other validation errors occur, delete: <a href="#dfn-cell-errors" class="internalDFN"> cell errors delete: </a> will be provided. It is an implementation decision to determine how conversion applications should proceed in the event that delete: <a href="#dfn-cell-errors" class="internalDFN"> cell errors delete: </a> are encountered. delete: </p> delete: </div> delete: </div> insert: <td>

`datatype`	RDF datatype IRI	Remarks
`anyAtomicType`	`xsd:anyAtomicType`
`anyURI`	`xsd:anyURI`
`base64Binary`	`xsd:base64Binary`
`boolean`	`xsd:boolean`
`date`	`xsd:date`
`dateTime`	`xsd:dateTime`
`dateTimeStamp`	`xsd:dateTimeStamp`
`decimal`	`xsd:decimal`
`integer`	`xsd:integer`
`long`	`xsd:long`
`int`	`xsd:int`
`short`	`xsd:short`
`byte`	`xsd:byte`
`nonNegativeInteger`	`xsd:nonNegativeInteger`
`positiveInteger`	`xsd:positiveInteger`
`unsignedLong`	`xsd:unsignedLong`
`unsignedInt`	`xsd:unsignedInt`
`unsignedShort`	`xsd:unsignedShort`
`unsignedByte`	`xsd:unsignedByte`
`nonPositiveInteger`	`xsd:nonPositiveInteger`
`negativeInteger`	`xsd:negativeInteger`
`double`	`xsd:double`
`duration`	`xsd:duration`
`dayTimeDuration`	`xsd:dayTimeDuration`
`yearMonthDuration`	`xsd:yearMonthDuration`
`float`	`xsd:float`
`gDay`	`xsd:gDay`
`gMonth`	`xsd:gMonth`
`gMonthDay`	`xsd:gMonthDay`
`gYear`	`xsd:gYear`
`gYearMonth`	`xsd:gYearMonth`
`hexBinary`	`xsd:hexBinary`
`QName`	`xsd:QName`
`string`	`xsd:string` or `rdf:langString` depending insert: `</td>`	Choice depends on whether or not the value has an associated language. delete: `</td>` delete: `<td>` language
`normalizedString`	`xsd:normalizedString`
`token`	`xsd:token`
`language`	`xsd:language`
`Name`	`xsd:Name`
`NMTOKEN`	`xsd:NMTOKEN`
`xml`	`rdf:XMLLiteral`
`html`	`rdf:HTML`
`json`	`csvw:JSON`	`csvw:JSON` is a sub-class of `xsd:string`
`time`	`xsd:time`

insert: <div class="note">

insert: <div class="note-title" aria-level="4" role="heading" id="h-note9">

insert: <span> Note insert: </span> insert: </div>

insert: <div class="">

insert: <p>

A datatype's insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-format" class="externalDFN"> format insert: </a> annotation is irrelevant to the conversion procedure defined in this specification; the insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value insert: </a> has already been parsed from the contents of the insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell insert: </a> according to the insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-format" class="externalDFN"> format insert: </a> annotation. insert: </p>

insert: <p>

insert: <a href="#dfn-cell-errors" class="internalDFN" data-link-type="dfn"> Cell errors insert: </a> insert: <em class="rfc2119" title="MUST"> MUST insert: </em> be recorded by applications where the contents of a insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cell insert: </a> cannot be parsed or validated (see insert: <cite> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#parsing-cells"> Parsing Cells insert: </a> insert: </cite> and insert: <cite> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#validating-tables"> Validating Tables insert: </a> insert: </cite> in [ insert: <cite> insert: <a class="bibref" href="#bib-tabular-data-model"> tabular-data-model insert: </a> insert: </cite> ] respectively). In cases where insert: <a href="#dfn-cell-errors" class="internalDFN" data-link-type="dfn"> cell errors insert: </a> are recorded, applications may attempt to determine the appropriate RDF insert: <a href="http://www.w3.org/TR/rdf11-concepts/#dfn-datatype-iri" class="externalDFN"> datatype IRI insert: </a> during the subsequent conversion process according to local rules. insert: </p>

insert: </div>

In the case of rdf:langString , the appropriate language tag (as defined in [ rdf11-concepts ]) MUST be provided for the string, based on the value of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-language" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-language" class="externalDFN"> cell value's language . (See section on Graph Literals in [ rdf11-concepts ] for further details on language tagged literals.)

Note

According to [ rdf11-concepts ] language tags cannot be combined with any other xsd datatypes. If a cell has any datatype other datatype than string , the value of lang MUST be ignored. Also, all literals have a datatype; however, specific serializations, like Turtle [ turtle ], MAY provide a special syntax for literals with datatype xsd:string or rdf:langString .

7. Examples

This section is non-normative.

In addition to the namespaces defined above , the examples provided here make use of the following namespaces:

dc :: http://purl.org/dc/terms/
foaf :: http://xmlns.com/foaf/0.1/
oa :: http://www.w3.org/ns/oa#
org :: http://www.w3.org/ns/org#
schema :: http://schema.org/

Furthermore, these examples also make use of the Turtle syntax @base declaration (as defined in [ turtle ]). Where a single tabular data file is used in the example, the @base declaration is set to the URL of that tabular data file.

Note

Each of the examples expresses more complex conversions - it is recommended that readers of this specification work through the examples in sequential order.

7.1 Simple example

This example comprises a single delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table containing information attributes about countries; country code, position (latitude, longitude) and name. Whilst the input tabular data file, published at http://example.org/countries.csv , includes a delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-header-line" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-header-line" class="externalDFN"> header line , no further metadata annotations are given. The tabular data file is provided below:

Example 3 : http://example.org/countries.csv

 countryCode,latitude,longitude,name AD,42.5,1.6,Andorra AE,23.4,53.8,"United Arab Emirates" AF,33.9,67.7,Afghanistan

The delete: <a href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table generated from parsing the tabular data file is shown below and provides the basis for the conversion to RDF.

id	core annotations
id	url	columns	rows
`T`	`http://example.org/countries.csv`	`C1` , `C2` , `C3` , `C4`	`R1` , `R2` , `R3`

Annotations for the delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns , delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows and delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are shown in the tables below. below:

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column annotations:

id	core annotations
id	table	number	source number	cells	name	titles
`C1`	`T`	1	1	`C1.1` , `C2.1` , `C3.1`	`countryCode`	`countryCode`
`C2`	`T`	2	2	`C1.2` , `C2.2` , `C3.2`	`latitude`	`latitude`
`C3`	`T`	3	3	`C1.3` , `C2.3` , `C3.3`	`longitude`	`longitude`
`C4`	`T`	4	4	`C1.4` , `C2.4` , `C3.4`	`name`	`name`

delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> Row annotations:

id	core annotations
id	table	number	source number	cells
`R1`	`T`	1	2	`C1.1` , `C1.2` , `C1.3` , `C1.4`
`R2`	`T`	2	3	`C2.1` , `C2.2` , `C2.3` , `C2.4`
`R3`	`T`	3	4	`C3.1` , `C3.2` , `C3.3` , `C3.4`

delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cell annotations:

id	core annotations
id	table	column	row	string value	value	property URL
`C1.1`	`T`	`C1`	`R1`	`"AD"`	`"AD"`	`null`
`C1.2`	`T`	`C2`	`R1`	`"42.5"`	`"42.5"`	`null`
`C1.3`	`T`	`C3`	`R1`	`"1.6"`	`"1.6"`	`null`
`C1.4`	`T`	`C4`	`R1`	`"Andorra"`	`"Andorra"`	`null`
`C2.1`	`T`	`C1`	`R2`	`"AE"`	`"AE"`	`null`
`C2.2`	`T`	`C2`	`R2`	`"23.4"`	`"23.4"`	`null`
`C2.3`	`T`	`C3`	`R2`	`"53.8"`	`"53.8"`	`null`
`C2.4`	`T`	`C4`	`R2`	`"United Arab Emirates"`	`"United Arab Emirates"`	`null`
`C3.1`	`T`	`C1`	`R3`	`"AF"`	`"AF"`	`null`
`C3.2`	`T`	`C2`	`R3`	`"33.9"`	`"33.9"`	`null`
`C3.3`	`T`	`C3`	`R3`	`"67.7"`	`"67.7"`	`null`
`C3.4`	`T`	`C4`	`R3`	`"Afghanistan"`	`"Afghanistan"`	`null`

delete: <a title="minimal mode" href="#dfn-minimal-mode" class="internalDFN"> insert: <a href="#dfn-minimal-mode" class="internalDFN" data-link-type="dfn"> Minimal mode output for this example is provided in Turtle [ turtle ] syntax below:

Example 4 : http://example.org/countries-minimal.ttl

  @base     <   http   :   //example.org/countries.csv> .   _   :   8228a149   -   8efe   -   448d   -   b15f   -   8abf92e7bd17     <#   countryCode   >     "AD"     ;     <#   latitude   >     "42.5"     ;     <#   longitude   >     "1.6"     ;     <#   name   >     "Andorra"     .   _   :   ec59dcfc   -   872a   -   4144   -   822b   -   9ad5e2c6149c     <#   countryCode   >     "AE"     ;     <#   latitude   >     "23.4"     ;     <#   longitude   >     "53.8"     ;     <#   name   >     "United Arab Emirates"     .   _   :   e8f2e8e9   -   3d02   -   4bf5   -   b4f1   -   4794ba5b52c9     <#   countryCode   >     "AF"     ;     <#   latitude   >     "33.9"     ;     <#   longitude   >     "67.7"     ;     <#   name   >     "Afghanistan"     .

Note

The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation has not been set for cells in table T ( { "url": "http://example.org/countries.csv"} ); delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in a given delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row where delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL has not been specified are assumed to refer to the same delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject . This unspecified delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject is treated as a delete: <a href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node .

Given that the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL is null for cells in table T ( { "url": "http://example.org/countries.csv"} ), the property URL defaults to the URI Template (see [ RFC6570 ]) #{ [column-name] } , where [column-name] is the value of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-name" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-name" class="externalDFN"> name annotation of the column associated with the cell. For example, the value of the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL annotation for all delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C1 ( "name": "countryCode" ) is http://example.org/countries.csv#countryCode .

delete: <a title="standard mode" href="#dfn-standard-mode" class="internalDFN"> insert: <a href="#dfn-standard-mode" class="internalDFN" data-link-type="dfn"> Standard mode output for this example is provided in Turtle [ turtle ] syntax below:

Example 5 : http://example.org/countries-standard.ttl

  @base     <   http   :   //example.org/countries.csv> .     @prefix   csvw   :     <   http   :   //www.w3.org/ns/csvw#> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .   _   :   d4f8e548   -   9601   -   4e41   -   aadb   -   09a8bce32625   a csvw   :   TableGroup     ;   csvw   :   table   [   a csvw   :   Table     ;   csvw   :   url   <   http   :   //example.org/countries.csv> ;   csvw   :   row   [   a csvw   :   Row     ;   csvw   :   rownum   "1"   ^^   xsd   :   integer   ;   csvw   :   url   <#   row   =   2   >     ;   csvw   :   describes _   :   8228a149   -   8efe   -   448d   -   b15f   -   8abf92e7bd17     ],     [   a csvw   :   Row     ;   csvw   :   rownum   "2"   ^^   xsd   :   integer   ;   csvw   :   url   <#   row   =   3   >     ;   csvw   :   describes _   :   ec59dcfc   -   872a   -   4144   -   822b   -   9ad5e2c6149c     ],     [   a csvw   :   Row     ;   csvw   :   rownum   "3"   ^^   xsd   :   integer   ;   csvw   :   url   <#   row   =   4   >     ;   csvw   :   describes _   :   e8f2e8e9   -   3d02   -   4bf5   -   b4f1   -   4794ba5b52c9     ]     ]     .   _   :   8228a149   -   8efe   -   448d   -   b15f   -   8abf92e7bd17     <#   countryCode   >     "AD"     ;     <#   latitude   >     "42.5"     ;     <#   longitude   >     "1.6"     ;     <#   name   >     "Andorra"     .   _   :   ec59dcfc   -   872a   -   4144   -   822b   -   9ad5e2c6149c     <#   countryCode   >     "AE"     ;     <#   latitude   >     "23.4"     ;     <#   longitude   >     "53.8"     ;     <#   name   >     "United Arab Emirates"     .   _   :   e8f2e8e9   -   3d02   -   4bf5   -   b4f1   -   4794ba5b52c9     <#   countryCode   >     "AF"     ;     <#   latitude   >     "33.9"     ;     <#   longitude   >     "67.7"     ;     <#   name   >     "Afghanistan"     .

Note

Even though the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table was defined in isolation, the delete: <a href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table is wrapped in a delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables .

The type of both delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table and delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables objects is explicitly stated; csvw:TableGroup and csvw:Table respectively.

The csvw:url property provides reference to the original tabular data file and to specific delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows therein - noting the need to escape the Turtle-syntax reserved character = ( U+003D ) within the fragment identifier.

The delete: <a href="#dfn-row-number" class="internalDFN"> insert: <a href="#dfn-row-number" class="internalDFN" data-link-type="dfn"> row number is provided for each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row using csvw:rownum property.

A delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject and delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are related using the csvw:describes property.

7.2 Example with single table and rich annotations

This example is based on Use Case #11 - City of Palo Alto Tree Data and comprises a single delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table describing an inventory of tree maintenance operations. The input tabular data file, published at http://example.org/tree-ops-ext.csv , and the associated metadata description http://example.org/tree-ops-ext.csv-metadata.json are provided below:

Example 6 : http://example.org/tree-ops-ext.csv

 GID,On Street,Species,Trim Cycle,Diameter at Breast Ht,Inventory Date,Comments,Protected,KML 1,ADDISON AV,Celtis australis,Large Tree Routine Prune,11,10/18/2010,,,"<Point><coordinates>-122.156485,37.440963</coordinates></Point>" 2,EMERSON ST,Liquidambar styraciflua,Large Tree Routine Prune,11,6/2/2010,,,"<Point><coordinates>-122.156749,37.440958</coordinates></Point>" 6,ADDISON AV,Robinia pseudoacacia,Large Tree Routine Prune,29,6/1/2010,cavity or decay; trunk decay; codominant leaders; included bark; large leader or limb decay; previous failure root damage; root decay; beware of BEES,YES,"<Point><coordinates>-122.156299,37.441151</coordinates></Point>"

Example 7 : http://example.org/tree-ops-ext.csv-metadata.json

  {     "@context"   :     [   "http://www.w3.org/ns/csvw"   ,     {   "@language"   :     "en"   }],     "@id"   :     "http://example.org/tree-ops-ext"   ,     "url"   :     "tree-ops-ext.csv"   ,     "dc:title"   :     "Tree Operations"   ,     "dcat:keyword"   :     [   "tree"   ,     "street"   ,     "maintenance"   ],     "dc:publisher"   :     [{     "schema:name"   :     "Example Municipality"   ,     "schema:url"   :     {   "@id"   :     "http://example.org"   }     }],     "dc:license"   :     {   "@id"   :     "http://opendefinition.org/licenses/cc-by/"   },     "dc:modified"   :     {   "@value"   :     "2010-12-31"   ,     "@type"   :     "xsd:date"   },     "notes"   :     [{     "@type"   :     "oa:Annotation"   ,     "oa:hasTarget"   :     {   "@id"   :     "http://example.org/tree-ops-ext"   },     "oa:hasBody"   :     {     "@type"   :     "oa:EmbeddedContent"   ,     "rdf:value"   :     "This is a very interesting comment about the table; it's a table!"   ,     "dc:format"   :     {   "@value"   :     "text/plain"   }     }     }],     "dialect"   :     {   "trim"   :     true   },     "tableSchema"   :     {     "columns"   :     [{     "name"   :     "GID"   ,     "titles"   :     [     "GID"   ,     "Generic Identifier"     ],     "dc:description"   :     "An identifier for the operation on a tree."   ,     "datatype"   :     "string"   ,     "required"   :     true   ,     "suppressOutput"   :     true     },     {     "name"   :     "on_street"   ,     "titles"   :     "On Street"   ,     "dc:description"   :     "The street that the tree is on."   ,     "datatype"   :     "string"     },     {     "name"   :     "species"   ,     "titles"   :     "Species"   ,     "dc:description"   :     "The species of the tree."   ,     "datatype"   :     "string"     },     {     "name"   :     "trim_cycle"   ,     "titles"   :     "Trim Cycle"   ,     "dc:description"   :     "The operation performed on the tree."   ,     "datatype"   :     "string"   ,     "lang"   :     "en"     },     {     "name"   :     "dbh"   ,     "titles"   :     "Diameter at Breast Ht"   ,     "dc:description"   :     "Diameter at Breast Height (DBH) of the tree (in feet), measured 4.5ft above ground."   ,     "datatype"   :     "integer"     },     {     "name"   :     "inventory_date"   ,     "titles"   :     "Inventory Date"   ,     "dc:description"   :     "The date of the operation that was performed."   ,     "datatype"   :     {   "base"   :     "date"   ,     "format"   :     "M/d/yyyy"   }     },     {     "name"   :     "comments"   ,     "titles"   :     "Comments"   ,     "dc:description"   :     "Supplementary comments relating to the operation or tree."   ,     "datatype"   :     "string"   ,     "separator"   :     ";"     },     {     "name"   :     "protected"   ,     "titles"   :     "Protected"   ,     "dc:description"   :     "Indication (YES / NO) whether the tree is subject to a protection order."   ,     "datatype"   :     {   "base"   :     "boolean"   ,     "format"   :     "YES|NO"   },     "default"   :     "NO"     },     {     "name"   :     "kml"   ,     "titles"   :     "KML"   ,     "dc:description"   :     "KML-encoded description of tree location."   ,     "datatype"   :     "xml"     }],     "primaryKey"   :     "GID"   ,     "aboutUrl"   :     "http://example.org/tree-ops-ext#gid-{GID}"     }     }

Note

The delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes annotation in the metadata description uses the Open Annotation data model currently under development within the Web Annotations Working Group . This is purely illustrative; no constraints are placed on the value of the delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes annotation.

The delete: <a href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table generated from parsing the tabular data file and associated metadata is shown below and provides the basis for the conversion to RDF.

Core annotations for the resulting delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T , with 9 delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns and 3 delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows , are shown below:

id	core annotations
id	id	url	columns	rows	notes
`T`	<http://example.org/tree-ops-ext>	`http://example.org/tree-ops-ext.csv`	`C1` , `C2` , `C3` , `C4` , `C5` , `C6` , `C7` , `C8` , `C9`	`R1` , `R2` , `R3`	`[{ "@type": "oa:Annotation", ... }]`

Non-core annotations for the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T are:

dc:title: "Tree Operations"
dcat:keyword: ["tree", "street", "maintenance"]
dc:publisher: [{ "schema:name": "Example Municipality", "schema:url": { "@id": "http://example.org" } }]
dc:license: { "@id": "http://opendefinition.org/licenses/cc-by/" }
dc:modified: "2010-12-31"

Note

The value of the delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes annotation has been shortened for clarity in the table above.

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column annotations:

id	core annotations								annotations
id	table	number	source number	cells	name	titles	required	suppress output	`dc:description`
`C1`	`T`	1	1	`C1.1` , `C2.1` , `C3.1`	`GID`	`GID` , `Generic Identifier`	`true`	`true`	`An identifier for the operation on a tree.`
`C2`	`T`	2	2	`C1.2` , `C2.2` , `C3.2`	`on_street`	`On Street`			`The street that the tree is on.`
`C3`	`T`	3	3	`C1.3` , `C2.3` , `C3.3`	`species`	`Species`			`The species of the tree.`
`C4`	`T`	4	4	`C1.4` , `C2.4` , `C3.4`	`trim_cycle`	`Trim Cycle`			`The operation performed on the tree.`
`C5`	`T`	5	5	`C1.5` , `C2.5` , `C3.5`	`dbh`	`Diameter at Breast Ht`			`Diameter at Breast Height (DBH) of the tree (in feet), measured 4.5ft above ground.`
`C6`	`T`	6	6	`C1.6` , `C2.6` , `C3.6`	`inventory_date`	`Inventory Date`			`The date of the operation that was performed.`
`C7`	`T`	7	7	`C1.7` , `C2.7` , `C3.7`	`comments`	`Comments`			`Supplementary comments relating to the operation or tree.`
`C8`	`T`	8	8	`C1.8` , `C2.8` , `C3.8`	`protected`	`Protected`			`Indication (YES / NO) whether the tree is subject to a protection order.`
`C9`	`T`	9	9	`C1.9` , `C2.9` , `C3.9`	`kml`	`KML`			`KML-encoded description of tree location.`

Note

In this example, output for delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C1 ( GID ) is not required; note the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation on this delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column .

delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> Row annotations:

id	core annotations
id	table	number	source number	cells	primary key
`R1`	`T`	1	2	`C1.1` , `C1.2` , `C1.3` , `C1.4` , `C1.5` , `C1.6` , `C1.7` , `C1.8` , `C1.9`	`C1.1`
`R2`	`T`	2	3	`C2.1` , `C2.2` , `C2.3` , `C2.4` , `C2.5` , `C2.6` , `C2.7` , `C2.8` , `C2.9`	`C2.1`
`R3`	`T`	3	4	`C3.1` , `C3.2` , `C3.3` , `C3.4` , `C3.5` , `C3.6` , `C3.7` , `C3.8` , `C3.9`	`C3.1`

delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cell annotations:

id	core annotations
id	table	column	row	string value	value	about URL
`C1.1`	`T`	`C1`	`R1`	`"1"`	`"1"`	`http://example.org/tree-ops-ext#gid-1`
`C1.2`	`T`	`C2`	`R1`	`"ADDISON AV"`	`"ADDISON AV"`	`<http://example.org/tree-ops-ext#gid-1>`
`C1.3`	`T`	`C3`	`R1`	`"Celtis australis"`	`"Celtis australis"`	`<http://example.org/tree-ops-ext#gid-1>`
`C1.4`	`T`	`C4`	`R1`	`"Large Tree Routine Prune"`	`"Large Tree Routine Prune"` (English)	`<http://example.org/tree-ops-ext#gid-1>`
`C1.5`	`T`	`C5`	`R1`	`"11"`	`11`	`<http://example.org/tree-ops-ext#gid-1>`
`C1.6`	`T`	`C6`	`R1`	`"10/18/2010"`	`2010-10-18`	`<http://example.org/tree-ops-ext#gid-1>`
`C1.7`	`T`	`C7`	`R1`	`""`	`null`	`<http://example.org/tree-ops-ext#gid-1>`
`C1.8`	`T`	`C8`	`R1`	`""`	`false`	`<http://example.org/tree-ops-ext#gid-1>`
`C1.9`	`T`	`C9`	`R1`	`"<Point><coordinates>-122.156485,37.440963</coordinates></Point>"`	`"<Point><coordinates>-122.156485,37.440963</coordinates></Point>"` (XML)	`<http://example.org/tree-ops-ext#gid-1>`
`C2.1`	`T`	`C1`	`R2`	`"2"`	`"2"`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.2`	`T`	`C2`	`R2`	`"EMERSON ST"`	`"EMERSON ST"`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.3`	`T`	`C3`	`R2`	`"Liquidambar styraciflua"`	`"Liquidambar styraciflua"`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.4`	`T`	`C4`	`R2`	`"Large Tree Routine Prune"`	`"Large Tree Routine Prune"` (English)	`<http://example.org/tree-ops-ext#gid-2>`
`C2.5`	`T`	`C5`	`R2`	`"11"`	`11`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.6`	`T`	`C6`	`R2`	`"6/2/2010"`	`2010-06-02`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.7`	`T`	`C7`	`R2`	`""`	`null`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.8`	`T`	`C8`	`R2`	`""`	`false`	`<http://example.org/tree-ops-ext#gid-2>`
`C2.9`	`T`	`C9`	`R2`	`"<Point><coordinates>-122.156749,37.440958</coordinates></Point>"`	`"<Point><coordinates>-122.156749,37.440958</coordinates></Point>"` (XML)	`<http://example.org/tree-ops-ext#gid-2>`
`C3.1`	`T`	`C1`	`R3`	`"6"`	`"6"`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.2`	`T`	`C2`	`R3`	`"ADDISON AV"`	`"ADDISON AV"`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.3`	`T`	`C3`	`R3`	`"Robinia pseudoacacia"`	`"Robinia pseudoacacia"`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.4`	`T`	`C4`	`R3`	`"Large Tree Routine Prune"`	`"Large Tree Routine Prune"` (English)	`<http://example.org/tree-ops-ext#gid-6>`
`C3.5`	`T`	`C5`	`R3`	`"29"`	`29`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.6`	`T`	`C6`	`R3`	`"6/1/2010"`	`2010-06-01`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.7`	`T`	`C7`	`R3`	`"cavity or decay; trunk decay; codominant leaders; included bark; large leader or limb decay; previous failure root damage; root decay; beware of BEES"`	`"cavity or decay"` , `"trunk decay"` , `"codominant leaders"` , `"included bark"` , `"large leader or limb decay"` , `"previous failure root damage"` , `"root decay"` , `"beware of BEES"`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.8`	`T`	`C8`	`R3`	`"YES"`	`true`	`<http://example.org/tree-ops-ext#gid-6>`
`C3.9`	`T`	`C9`	`R3`	`"<Point><coordinates>-122.156299,37.441151</coordinates></Point>"`	`"<Point><coordinates>-122.156299,37.441151</coordinates></Point>"` (XML)	`<http://example.org/tree-ops-ext#gid-6>`

Note

The lists of values from delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C7 ( "name": "comments" ) are assumed to be unordered as the boolean delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-ordered" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> ordered annotation, which defaults to false , has not be set within the metadata description.

Example 8 : http://example.org/tree-ops-ext-minimal.ttl

  @base     <   http   :   //example.org/tree-ops-ext.csv> .     @prefix   rdf   :     <   http   :   //www.w3.org/1999/02/22-rdf-syntax-ns#> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .     <   http   :   //example.org/tree-ops-ext#gid-1>     <#   on_street   >     "ADDISON AV"     ;     <#   species   >     "Celtis australis"     ;     <#   trim_cycle   >     "Large Tree Routine Prune"   @en     ;     <#   dbh   >     11     ;     <#   inventory_date   >     "2010-10-18"   ^^   xsd   :   date   ;     <#   protected   >     false     ;     <#   kml   >     "<Point><coordinates>-122.156485,37.440963</coordinates></Point>"   ^^   rdf   :   XMLLiteral     .     <   http   :   //example.org/tree-ops-ext#gid-2>     <#   on_street   >     "EMERSON ST"     ;     <#   species   >     "Liquidambar styraciflua"     ;     <#   trim_cycle   >     "Large Tree Routine Prune"   @en     ;     <#   dbh   >     11     ;     <#   inventory_date   >     "2010-06-02"   ^^   xsd   :   date   ;     <#   protected   >     false     ;     <#   kml   >     "<Point><coordinates>-122.156749,37.440958</coordinates></Point>"   ^^   rdf   :   XMLLiteral     .     <   http   :   //example.org/tree-ops-ext#gid-6>     <#   on_street   >     "ADDISON AV"     ;     <#   species   >     "Robinia pseudoacacia"     ;     <#   trim_cycle   >     "Large Tree Routine Prune"   @en     ;     <#   dbh   >     29     ;     <#   inventory_date   >     "2010-06-01"   ^^   xsd   :   date   ;     <#   comments   >     "cavity or decay"   ,     "trunk decay"   ,     "codominant leaders"   ,     "included bark"   ,     "large leader or limb decay"   ,     "previous failure root damage"   ,     "root decay"   ,     "beware of BEES"     ;     <#   protected   >     true     ;     <#   kml   >     "<Point><coordinates>-122.156299,37.441151</coordinates></Point>"   ^^   rdf   :   XMLLiteral     .

Note

The delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject described by each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row is explicitly defined using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation; e.g. the delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject of delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row R1 is http://example.org/tree-ops-ext#gid-1 .

Output for delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C1 ( { "name": "GID" } ) is not included as the delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-suppress-output" class="externalDFN"> suppress output annotation is true .

A language tag is specified for delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN"> insert: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> values of delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column C4 ( { "name": "trim_cycle" } ) as the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-language" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-language" class="externalDFN"> cell value language annotation is en .

The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-datatype"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-column-datatype"> datatype annotation is set on delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns C5 , C6 , C8 and C9 ( { "name": "dbh"} , { "name": "inventory_date" } , { "name": "protected" } and { "name": "kml" } ); as integer , date , boolean and xml respectively. The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-datatype"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-datatype"> datatype property is inherited by all delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in each of those delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns , therefore the RDF output for those delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells includes the appropriate datatype IRI .

delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cells C1.7 and C2.7 ( delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows R1 and R2 ; delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column , { "name": "comments" } ) have null delete: <a title="cell value" href="#dfn-cell-value" class="internalDFN"> insert: <a data-lt="cell value" href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> values - no output is included for these delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells .

delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cell C3.7 ( delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row R3 ; delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column , { "name": "comments" } ) contains an unordered sequence of values; the set of values are included as a simple set of triples as opposed to an instance of rdf:List as the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-ordered" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-ordered" class="externalDFN"> ordered annotation has defaulted to false .

Example 9 : http://example.org/tree-ops-ext-standard.ttl

  @base     <   http   :   //example.org/tree-ops-ext.csv> .     @prefix   csvw   :     <   http   :   //www.w3.org/ns/csvw#> .     @prefix   dc   :     <   http   :   //purl.org/dc/terms/> .     @prefix   dcat   :     <   http   :   //www.w3.org/ns/dcat#> .     @prefix   oa   :     <   http   :   //www.w3.org/ns/oa#> .     @prefix   rdf   :     <   http   :   //www.w3.org/1999/02/22-rdf-syntax-ns#> .     @prefix   schema   :     <   http   :   //schema.org/> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .   _   :   68fc08e5   -   56a0   -   47e2   -   a784   -   3a644d8257c4   a csvw   :   TableGroup     ;   csvw   :   table   <   http   :   //example.org/tree-ops-ext> .     <   http   :   //example.org/tree-ops-ext> a csvw:Table ;   csvw   :   url   <   http   :   //example.org/tree-ops-ext.csv> ;   dc   :   title   "Tree Operations"   @en     ;   dcat   :   keyword   "tree"   @en   ,     "street"   @en   ,     "maintenance"   @en     ;   dc   :   publisher   [   schema   :   name   "Example Municipality"   @en     ;   schema   :   url   <   http   :   //example.org>     ]     ;   dc   :   license   <   http   :   //opendefinition.org/licenses/cc-by/> ;   dc   :   modified   "2010-12-31"   ^^   xsd   :   date   ;   csvw   :   note   [   a oa   :   Annotation     ;   oa   :   hasTarget   <   http   :   //example.org/tree-ops-ext> ;   oa   :   hasBody   [   a oa   :   EmbeddedContent     ;   rdf   :   value   "This is a very interesting comment about the table; it's a table!"   @en     ;   dc   :   format   "text/plain"     ]     ]     ;   csvw   :   row   [   a csvw   :   Row     ;   csvw   :   rownum   1     ;   csvw   :   url   <#   row   =   2   >     ;   csvw   :   describes   <   http   :   //example.org/tree-ops-ext#gid-1>     ],     [   a csvw   :   Row     ;   csvw   :   rownum   2     ;   csvw   :   url   <#   row   =   3   >     ;   csvw   :   describes   <   http   :   //example.org/tree-ops-ext#gid-2>     ],     [   a csvw   :   Row     ;   csvw   :   rownum   3     ;   csvw   :   url   <#   row   =   4   >     ;   csvw   :   describes   <   http   :   //example.org/tree-ops-ext#gid-6>     ]     .     <   http   :   //example.org/tree-ops-ext#gid-1>     <#   on_street   >     "ADDISON AV"     ;     <#   species   >     "Celtis australis"     ;     <#   trim_cycle   >     "Large Tree Routine Prune"   @en     ;     <#   dbh   >     11     ;     <#   inventory_date   >     "2010-10-18"   ^^   xsd   :   date   ;     <#   protected   >     false     ;     <#   kml   >     "<Point><coordinates>-122.156485,37.440963</coordinates></Point>"   ^^   rdf   :   XMLLiteral     .     <   http   :   //example.org/tree-ops-ext#gid-2>     <#   on_street   >     "EMERSON ST"     ;     <#   species   >     "Liquidambar styraciflua"     ;     <#   trim_cycle   >     "Large Tree Routine Prune"   @en     ;     <#   dbh   >     11     ;     <#   inventory_date   >     "2010-06-02"   ^^   xsd   :   date   ;     <#   protected   >     false     ;     <#   kml   >     "<Point><coordinates>-122.156749,37.440958</coordinates></Point>"   ^^   rdf   :   XMLLiteral     .     <   http   :   //example.org/tree-ops-ext#gid-6>     <#   on_street   >     "ADDISON AV"     ;     <#   species   >     "Robinia pseudoacacia"     ;     <#   trim_cycle   >     "Large Tree Routine Prune"   @en     ;     <#   dbh   >     29     ;     <#   inventory_date   >     "2010-06-01"   ^^   xsd   :   date   ;     <#   comments   >     "cavity or decay"   ,     "trunk decay"   ,     "codominant leaders"   ,     "included bark"   ,     "large leader or limb decay"   ,     "previous failure root damage"   ,     "root decay"   ,     "beware of BEES"     ;     <#   protected   >     true     ;     <#   kml   >     "<Point><coordinates>-122.156299,37.441151</coordinates></Point>"   ^^   rdf   :   XMLLiteral     .

Note

delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> Table T ( { "url": "http://example.org/tree-ops-ext.csv"} ) has been explicitly identified: { "@id": "<http://exmple.org/tree-ops-ext>"} .

delete: <a title="non-core annotations" href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> Non-core annotations and delete: <a href="#dfn-notes" class="internalDFN"> insert: <a href="#dfn-notes" class="internalDFN" data-link-type="dfn"> notes specified for delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T ( { "url": "http://example.org/tree-ops-ext.csv"} ) are included in the output.

As the metadata description file http://example.org/tree-ops-ext.csv-metadata.json defines a default language within the context ( "@context": ["http://www.w3.org/ns/csvw", {"@language": "en"}] ), all delete: <a href="#dfn-non-core-annotations" class="internalDFN"> insert: <a href="#dfn-non-core-annotations" class="internalDFN" data-link-type="dfn"> non-core annotations of type string (e.g. dc:title , dcat:keyword , dc:publisher , dc:license and dc:modified ) are expressed in the RDF output using the the appropriate language tag .

7.3 Example with single table and using virtual columns to produce multiple subjects per row

This example uses a single delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table describing a listing of music events. Each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row from the tabular data file corresponds to three resources; the music event itself, the location where that event occurs and the offer to sell tickets for that event. The goal is to convert the CSV content into schema.org markup that a search engine such as Google can use to index music events. Details of how Google expects this information to be structured can be found here .

The input tabular data file, published at http://example.org/events-listing.csv , and the associated metadata description http://example.org/events-listing.csv-metadata.json are provided below:

Example 10 : http://example.org/events-listing.csv

 Name, Start Date, Location Name, Location Address, Ticket Url B.B. King,2014-04-12T19:30,"Lupo’s Heartbreak Hotel","79 Washington St., Providence, RI",https://www.etix.com/ticket/1771656 B.B. King,2014-04-13T20:00,"Lynn Auditorium","Lynn, MA, 01901",http://frontgatetickets.com/venue.php?id=11766

Example 11 : http://example.org/events-listing.csv-metadata.json

  {     "@context"   :     [   "http://www.w3.org/ns/csvw"   ,     {   "@language"   :     "en"   }],     "url"   :     "events-listing.csv"   ,     "dialect"   :     {   "trim"   :     true   },     "tableSchema"   :     {     "columns"   :     [{     "name"   :     "name"   ,     "titles"   :     "Name"   ,     "aboutUrl"   :     "#event-{_row}"   ,     "propertyUrl"   :     "schema:name"     },     {     "name"   :     "start_date"   ,     "titles"   :     "Start Date"   ,     "datatype"   :     {     "base"   :     "datetime"   ,     "format"   :     "yyyy-MM-ddTHH:mm"     },     "aboutUrl"   :     "#event-{_row}"   ,     "propertyUrl"   :     "schema:startDate"     },     {     "name"   :     "location_name"   ,     "titles"   :     "Location Name"   ,     "aboutUrl"   :     "#place-{_row}"   ,     "propertyUrl"   :     "schema:name"     },     {     "name"   :     "location_address"   ,     "titles"   :     "Location Address"   ,     "aboutUrl"   :     "#place-{_row}"   ,     "propertyUrl"   :     "schema:address"     },     {     "name"   :     "ticket_url"   ,     "titles"   :     "Ticket Url"   ,     "datatype"   :     "anyURI"   ,     "aboutUrl"   :     "#offer-{_row}"   ,     "propertyUrl"   :     "schema:url"     },     {     "name"   :     "type_event"   ,     "virtual"   :     true   ,     "aboutUrl"   :     "#event-{_row}"   ,     "propertyUrl"   :     "rdf:type"   ,     "valueUrl"   :     "schema:MusicEvent"     },     {     "name"   :     "type_place"   ,     "virtual"   :     true   ,     "aboutUrl"   :     "#place-{_row}"   ,     "propertyUrl"   :     "rdf:type"   ,     "valueUrl"   :     "schema:Place"     },     {     "name"   :     "type_offer"   ,     "virtual"   :     true   ,     "aboutUrl"   :     "#offer-{_row}"   ,     "propertyUrl"   :     "rdf:type"   ,     "valueUrl"   :     "schema:Offer"     },     {     "name"   :     "location"   ,     "virtual"   :     true   ,     "aboutUrl"   :     "#event-{_row}"   ,     "propertyUrl"   :     "schema:location"   ,     "valueUrl"   :     "#place-{_row}"     },     {     "name"   :     "offers"   ,     "virtual"   :     true   ,     "aboutUrl"   :     "#event-{_row}"   ,     "propertyUrl"   :     "schema:offers"   ,     "valueUrl"   :     "#offer-{_row}"     }]     }     }

Note

The CSV to RDF translation is limited to providing one statement, or triple, per delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column in the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table . The target schema.org markup requires 10 statements to describe each event. As the base tabular data file contains 5 columns, an additional 5 virtual delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns have been added in order to provide for the full complement of statements—including the relationships between the 3 resources (event, location, and offer) described by each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table . Note that the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-virtual" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual" class="externalDFN"> virtual annotation is set to true for these virtual delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns .

Furthermore, note that no attempt is made to reconcile between locations or offers that may be associated with more than one event; every delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row in the delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table will create both a new location resource and offer resource in addition to the event resource. If considered necessary, applications such as OpenRefine may be used to identify and reconcile duplicate location resources once the RDF output has been generated.

The delete: <a href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated table generated from parsing the tabular data file and associated metadata is shown below and provides the basis for the conversion to RDF.

Annotations for the resulting delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table T , with 10 delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns and 2 delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> rows , are shown below:

id	core annotations
id	url	columns	rows
`T`	`http://example.org/events-listing.csv`	`C1` , `C2` , `C3` , `C4` , `C5` , `C6` , `C7` , `C8` , `C9` , `C10`	`R1` , `R2`

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column annotations:

`C1`	`T`	1	1	`C1.1` , `C2.1`	`name`	`Name`
`C2`	`T`	2	2	`C1.2` , `C2.2`	`start_date`	`Start Date`
`C3`	`T`	3	3	`C1.3` , `C2.3`	`location_name`	`Location Name`
`C4`	`T`	4	4	`C1.4` , `C2.4`	`location_address`	`Location Address`
`C5`	`T`	5	5	`C1.5` , `C2.5`	`ticket_url`	`Ticket Url`
`C6`	`T`	6	6	`C1.6` , `C2.6`	`type_event`		`true`
`C7`	`T`	7	7	`C1.7` , `C2.7`	`type_place`		`true`
`C8`	`T`	8	8	`C1.8` , `C2.8`	`type_offer`		`true`
`C9`	`T`	9	9	`C1.9` , `C2.9`	`location`		`true`
`C10`	`T`	10	10	`C1.10` , `C2.10`	`offers`		`true`

delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> Row annotations:

id	core annotations
id	table	number	source number	cells
`R1`	`T`	1	2	`C1.1` , `C1.2` , `C1.3` , `C1.4` , `C1.5` , `C1.6` , `C1.7` , `C1.8` , `C1.9` , `C1.10`
`R2`	`T`	2	3	`C2.1` , `C2.2` , `C2.3` , `C2.4` , `C2.5` , `C2.6` , `C2.7` , `C2.8` , `C2.9` , `C2.10`

delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cell annotations:

id	core annotations
id	table	column	row	string value	value	about URL	property URL	value URL
`C1.1`	`T`	`C1`	`R1`	`"B.B. King"`	`"B.B. King"`	`<http://example.org/events-listing.csv#event-1>`	`schema:name`
`C1.2`	`T`	`C2`	`R1`	`"2014-04-12T19:30"`	`2014-04-12T19:30:00`	`<http://example.org/events-listing.csv#event-1>`	`schema:startDate`
`C1.3`	`T`	`C3`	`R1`	`"Lupo’s Heartbreak Hotel"`	`"Lupo’s Heartbreak Hotel"`	`<http://example.org/events-listing.csv#place-1>`	`schema:name`
`C1.4`	`T`	`C4`	`R1`	`"79 Washington St., Providence, RI"`	`"79 Washington St., Providence, RI"`	`<http://example.org/events-listing.csv#place-1>`	`schema:address`
`C1.5`	`T`	`C5`	`R1`	`"https://www.etix.com/ticket/1771656"`	`<https://www.etix.com/ticket/1771656>`	`<http://example.org/events-listing.csv#offer-1>`	`schema:url`
`C1.6`	`T`	`C6`	`R1`	`""`	`null`	`<http://example.org/events-listing.csv#event-1>`	`rdf:type`	`schema:MusicEvent`
`C1.7`	`T`	`C7`	`R1`	`""`	`null`	`<http://example.org/events-listing.csv#place-1>`	`rdf:type`	`schema:Place`
`C1.8`	`T`	`C8`	`R1`	`""`	`null`	`<http://example.org/events-listing.csv#offer-1>`	`rdf:type`	`schema:Offer`
`C1.9`	`T`	`C9`	`R1`	`""`	`null`	`<http://example.org/events-listing.csv#event-1>`	`schema:location`	`<http://example.org/events-listing.csv#place-1>`
`C1.10`	`T`	`C10`	`R1`	`""`	`null`	`<http://example.org/events-listing.csv#event-1>`	`schema:offers`	`<http://example.org/events-listing.csv#offer-1>`
`C2.1`	`T`	`C1`	`R2`	`"B.B. King"`	`"B.B. King"`	`<http://example.org/events-listing.csv#event-2>`	`schema:name`
`C2.2`	`T`	`C2`	`R2`	`"2014-04-13T20:00"`	`2014-04-13T20:00:00`	`<http://example.org/events-listing.csv#event-2>`	`schema:startDate`
`C2.3`	`T`	`C3`	`R2`	`"Lynn Auditorium"`	`"Lynn Auditorium"`	`<http://example.org/events-listing.csv#place-2>`	`schema:name`
`C2.4`	`T`	`C4`	`R2`	`"Lynn, MA, 01901"`	`"Lynn, MA, 01901"`	`<http://example.org/events-listing.csv#place-2>`	`schema:address`
`C2.5`	`T`	`C5`	`R2`	`"http://frontgatetickets.com/venue.php?id=11766"`	`<http://frontgatetickets.com/venue.php?id=11766>`	`<http://example.org/events-listing.csv#offer-2>`	`schema:url`
`C2.6`	`T`	`C6`	`R2`	`""`	`null`	`<http://example.org/events-listing.csv#event-2>`	`rdf:type`	`schema:MusicEvent`
`C2.7`	`T`	`C7`	`R2`	`""`	`null`	`<http://example.org/events-listing.csv#place-2>`	`rdf:type`	`schema:Place`
`C2.8`	`T`	`C8`	`R2`	`""`	`null`	`<http://example.org/events-listing.csv#offer-2>`	`rdf:type`	`schema:Offer`
`C2.9`	`T`	`C9`	`R2`	`""`	`null`	`<http://example.org/events-listing.csv#event-2>`	`schema:location`	`<http://example.org/events-listing.csv#place-2>`
`C2.10`	`T`	`C10`	`R2`	`""`	`null`	`<http://example.org/events-listing.csv#event-2>`	`schema:offers`	`<http://example.org/events-listing.csv#offer-2>`

Example 12 : http://example.org/events-listing-minimal.ttl

  @base     <   http   :   //example.org/events-listing.csv> .     @prefix   schema   :     <   http   :   //schema.org/> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .     <#   event   -   1   >   a schema   :   MusicEvent     ;   schema   :   name   "B.B. King"     ;   schema   :   startDate   "2014-04-12T19:30:00"   ^^   xsd   :   dateTime   ;   schema   :   location   <#   place   -   1   >     ;   schema   :   offers   <#   offer   -   1   >     .     <#   place   -   1   >   a schema   :   Place     ;   schema   :   name   "Lupo’s Heartbreak Hotel"     ;   schema   :   address   "79 Washington St., Providence, RI"     .     <#   offer   -   1   >   a schema   :   Offer     ;   schema   :   url   "https://www.etix.com/ticket/1771656"   ^^   xsd   :   anyURI   .     <#   event   -   2   >   a schema   :   MusicEvent     ;   schema   :   name   "B.B. King"     ;   schema   :   startDate   "2014-04-13T20:00:00"   ^^   xsd   :   dateTime   ;   schema   :   location   <#   place   -   2   >     ;   schema   :   offers   <#   offer   -   2   >     .     <#   place   -   2   >   a schema   :   Place     ;   schema   :   name   "Lynn Auditorium"     ;   schema   :   address   "Lynn, MA, 01901"     .     <#   offer   -   2   >   a schema   :   Offer     ;   schema   :   url   "http://frontgatetickets.com/venue.php?id=11766"   ^^   xsd   :   anyURI   .

Note

Three resources are defined for each row within the table; event, location, and offer.

Each delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column description in the metadata explicitly defines both delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> aboutUrl and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-propertyUrl"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-propertyUrl"> propertyUrl properties which are used to create the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL annotations on the column's delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells .

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Columns C6 , C7 and C8 ( { "name": "type_event"} , { "name": "type_place"} and { "name": "type_offer"} ) define the semantic types of the resources described by each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row : schema:MusicEvent , schema:Place and schema:Offer respectively.

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column C9 ( { "name": "location"} ) uses the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL to assert the relationship between the event and location resources.

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column C10 ( { "name": "offer"} ) uses the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL to assert the relationship between the event and offer resources.

Example 13 : http://example.org/events-listing-standard.ttl

  @base     <   http   :   //example.org/events-listing.csv> .     @prefix   csvw   :     <   http   :   //www.w3.org/ns/csvw#> .     @prefix   schema   :     <   http   :   //schema.org/> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .   _   :   95cc7970   -   ce99   -   44b0   -   900c   -   e2c2c028bbd3 a csvw   :   TableGroup     ;   csvw   :   table   [   a csvw   :   Table     ;   csvw   :   url   <   http   :   //example.org/events-listing.csv> ;   csvw   :   row   [   a csvw   :   Row     ;   csvw   :   rownum   1     ;   csvw   :   url   <#   row   =   2   >     ;   csvw   :   describes   <#   event   -   1   >,     <#   place   -   1   >,     <#   offer   -   1   >     ],     [   a csvw   :   Row     ;   csvw   :   rownum   2     ;   csvw   :   url   <#   row   =   3   >     ;   csvw   :   describes   <#   event   -   2   >,     <#   place   -   2   >,     <#   offer   -   2   >     ]     ]     .     <#   event   -   1   >   a schema   :   MusicEvent     ;   schema   :   name   "B.B. King"     ;   schema   :   startDate   "2014-04-12T19:30:00"   ^^   xsd   :   dateTime   ;   schema   :   location   <#   place   -   1   >     ;   schema   :   offers   <#   offer   -   1   >     .     <#   place   -   1   >   a schema   :   Place     ;   schema   :   name   "Lupo’s Heartbreak Hotel"     ;   schema   :   address   "79 Washington St., Providence, RI"     .     <#   offer   -   1   >   a schema   :   Offer     ;   schema   :   url   "https://www.etix.com/ticket/1771656"   ^^   xsd   :   anyURI   .     <#   event   -   2   >   a schema   :   MusicEvent     ;   schema   :   name   "B.B. King"     ;   schema   :   startDate   "2014-04-13T20:00:00"   ^^   xsd   :   dateTime   ;   schema   :   location   <#   place   -   2   >     ;   schema   :   offers   <#   offer   -   2   >     .     <#   place   -   2   >   a schema   :   Place     ;   schema   :   name   "Lynn Auditorium"     ;   schema   :   address   "Lynn, MA, 01901"     .     <#   offer   -   2   >   a schema   :   Offer     ;   schema   :   url   "http://frontgatetickets.com/venue.php?id=11766"   ^^   xsd   :   anyURI   .

Note

The resources described by each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row are explcitly explicitly defined using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL annotation this case three resources per delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row (event, location, and offer). The relationship between the delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row and each delete: <a href="#dfn-subject" class="internalDFN"> insert: <a href="#dfn-subject" class="internalDFN" data-link-type="dfn"> subject resource is asserted using the csvw:describes property; e.g. for delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row R1 , a insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank node insert: </a> , we state delete: <code> [] the following triples: insert: </p>

insert: <dl class="triple">

subject insert: </dt>: insert: <var> R1 insert: </var> insert: </dd>
predicate insert: </dt>: insert: <code> csvw:describes t1:event-1, t1:place-1, insert: </code> insert: </dd>
object insert: </dt>: insert: <code> t1:event-1 insert: </code> insert: </dd>

insert: <dl class="triple">

subject insert: </dt>: insert: <var> R1 insert: </var> insert: </dd>
predicate insert: </dt>: insert: <code> csvw:describes insert: </code> insert: </dd>
object insert: </dt>: insert: <code> t1:place-1 insert: </code> insert: </dd>

insert: <dl class="triple">

subject insert: </dt>: insert: <var> R1 insert: </var> insert: </dd>
predicate insert: </dt>: insert: <code> csvw:describes insert: </code> insert: </dd>
object insert: </dt>: insert: <code> t1:offer-1 . delete: </code> . delete: </p> insert: </code> insert: </dd>

7.4 Example with delete: `<a href="#dfn-group-of-tables" class="internalDFN">` insert: `<a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn">` group of tables comprising four interrelated tables

This example is based on Use Case #4 - Publication of public sector roles and salaries and uses four delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> annotated tables published as a delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables . Information about senior roles and junior roles within a government department or organization are published in CSV format by each department. These are validated against a centrally published delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#dfn-schema" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-schema" class="externalDFN"> schema to ensure that all the data published by departments is consistent. Additionally, lists of organizations and professions are also published centrally, providing controlled vocabularies against which departmental submissions are validated.

Information published about junior and senior roles provides summary information for each post within the government department or organization. Whilst the junior role information is anonymous, providing only an indication of the number of full-time-equivalent (FTE) staff occupying a given post, the senior role information specifies the named individual occupying each post. As such, each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row from the tabular data file describing senior roles corresponds to two resources; the post and the person occupying that post.

This example is concerned only with converting the information provided by each government department or organization not rather than the centrally published information listing organizations and professions.

The input tabular data files and associated metadata descriptions are provided below:

Example 14 : http://example.org/gov.uk/data/organizations.csv

 Organization Unique Reference,Organization Name,Department Reference hefce.ac.uk,Higher Education Funding Council for England,bis.gov.uk bis.gov.uk,"Department for Business, Innovation and Skills",xx

Example 15 : http://example.org/gov.uk/data/professions.csv

 Profession Finance Information Technology Operational Delivery Policy

Example 16 : http://example.org/senior-roles.csv

 Post Unique Reference,Name,Grade,Job Title,Reports to Senior Post,Profession,Organization Reference 90115,Steve Egan,SCS1A,Deputy Chief Executive,90334,Finance,hefce.ac.uk 90334,Sir Alan Langlands,SCS4,Chief Executive,xx,Policy,hefce.ac.uk

Example 17 : http://example.org/junior-roles.csv

 Reporting Senior Post,Grade,Payscale Minimum (£),Payscale Maximum (£),Generic Job Title,Number of Posts (FTE),Profession,Organization Reference 90115,4,17426,20002,Administrator,8.67,Operational Delivery,hefce.ac.uk 90115,5,19546,22478,Administrator,0.5,Operational Delivery,hefce.ac.uk

Example 18 : http://example.org/csv-metadata.json

  {     "@type"   :     "TableGroup"   ,     "@context"   :     [   "http://www.w3.org/ns/csvw"   ,     {   "@language"   :     "en"   }],     "tables"   :     [{     "url"   :     "gov.uk/data/organizations.csv"   ,     "tableSchema"   :     "gov.uk/schema/organizations.json"   ,     "suppressOutput"   :     true     },     {     "url"   :     "gov.uk/data/professions.csv"   ,     "tableSchema"   :     "gov.uk/schema/professions.json"   ,     "suppressOutput"   :     true     },     {     "url"   :     "senior-roles.csv"   ,     "tableSchema"   :     "gov.uk/schema/senior-roles.json"     },     {     "url"   :     "junior-roles.csv"   ,     "tableSchema"   :     "gov.uk/schema/junior-roles.json"     }]     }

Example 19 : http://example.org/gov.uk/schema/organizations.json

  {     "@id"   :     "http://example.org/gov.uk/schema/organizations.json"   ,     "@context"   :     "http://www.w3.org/ns/csvw"   ,     "columns"   :     [{     "name"   :     "ref"   ,     "titles"   :     "Organization Unique Reference"   ,     "datatype"   :     "string"   ,     "required"   :     true   ,     "propertyUrl"   :     "dc:identifier"     },     {     "name"   :     "name"   ,     "titles"   :     "Organization Name"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "foaf:name"     },     {     "name"   :     "department"   ,     "titles"   :     "Department Reference"   ,     "datatype"   :     "string"   ,     "null"   :     "xx"   ,     "propertyUrl"   :     "org:subOrganizationOf"   ,     "valueUrl"   :     "http://example.org/organization/{department}"     }],     "primaryKey"   :     "ref"   ,     "aboutUrl"   :     "http://example.org/organization/{ref}"   ,     "foreignKeys"   :     [{     "columnReference"   :     "department"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/organizations.json"   ,     "columnReference"   :     "ref"     }     }]     }

Example 20 : http://example.org/gov.uk/schema/professions.json

  {     "@id"   :     "http://example.org/gov.uk/schema/professions.json"   ,     "@context"   :     "http://www.w3.org/ns/csvw"   ,     "columns"   :     [{     "name"   :     "name"   ,     "titles"   :     "Profession"   ,     "datatype"   :     "string"   ,     "required"   :     true     }],     "primaryKey"   :     "name"     }

Example 21 : http://example.org/gov.uk/schema/senior-roles.json

  {     "@id"   :     "http://example.org/gov.uk/schema/senior-roles.json"   ,     "@context"   :     "http://www.w3.org/ns/csvw"   ,     "columns"   :     [{     "name"   :     "ref"   ,     "titles"   :     "Post Unique Reference"   ,     "datatype"   :     "string"   ,     "required"   :     true   ,     "propertyUrl"   :     "dc:identifier"     },     {     "name"   :     "name"   ,     "titles"   :     "Name"   ,     "datatype"   :     "string"   ,     "aboutUrl"   :     "http://example.org/organization/{organizationRef}/person/{_row}"   ,     "propertyUrl"   :     "foaf:name"     },     {     "name"   :     "grade"   ,     "titles"   :     "Grade"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/grade"     },     {     "name"   :     "job"   ,     "titles"   :     "Job Title"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/job"     },     {     "name"   :     "reportsTo"   ,     "titles"   :     "Reports to Senior Post"   ,     "datatype"   :     "string"   ,     "null"   :     "xx"   ,     "propertyUrl"   :     "org:reportsTo"   ,     "valueUrl"   :     "http://example.org/organization/{organizationRef}/post/{reportsTo}"     },     {     "name"   :     "profession"   ,     "titles"   :     "Profession"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/profession"     },     {     "name"   :     "organizationRef"   ,     "titles"   :     "Organization Reference"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "org:postIn"   ,     "valueUrl"   :     "http://example.org/organization/{organizationRef}"   ,     "required"   :     true     },     {     "name"   :     "post_holder"   ,     "virtual"   :     true   ,     "propertyUrl"   :     "org:heldBy"   ,     "valueUrl"   :     "http://example.org/organization/{organizationRef}/person/{_row}"     }],     "primaryKey"   :     "ref"   ,     "aboutUrl"   :     "http://example.org/organization/{organizationRef}/post/{ref}"   ,     "foreignKeys"   :     [{     "columnReference"   :     "reportsTo"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/senior-roles.json"   ,     "columnReference"   :     "ref"     }     },     {     "columnReference"   :     "profession"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/professions.json"   ,     "columnReference"   :     "name"     }     },     {     "columnReference"   :     "organizationRef"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/organizations.json"   ,     "columnReference"   :     "ref"     }     }]     }

Example 22 : http://example.org/gov.uk/schema/junior-roles.json

  {     "@id"   :     "http://example.org/gov.uk/schema/junior-roles.json"   ,     "@context"   :     "http://www.w3.org/ns/csvw"   ,     "columns"   :     [{     "name"   :     "reportsToSenior"   ,     "titles"   :     "Reporting Senior Post"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "org:reportsTo"   ,     "valueUrl"   :     "http://example.org/organization/{organizationRef}/post/{reportsToSenior}"   ,     "required"   :     true     },     {     "name"   :     "grade"   ,     "titles"   :     "Grade"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/grade"     },     {     "name"   :     "min_pay"   ,     "titles"   :     "Payscale Minimum (£)"   ,     "datatype"   :     "integer"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/min_pay"     },     {     "name"   :     "max_pay"   ,     "titles"   :     "Payscale Maximum (£)"   ,     "datatype"   :     "integer"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/max_pay"     },     {     "name"   :     "job"   ,     "titles"   :     "Generic Job Title"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/job"     },     {     "name"   :     "number"   ,     "titles"   :     "Number of Posts (FTE)"   ,     "datatype"   :     "number"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/number_of_posts"     },     {     "name"   :     "profession"   ,     "titles"   :     "Profession"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "http://example.org/gov.uk/def/profession"     },     {     "name"   :     "organizationRef"   ,     "titles"   :     "Organization Reference"   ,     "datatype"   :     "string"   ,     "propertyUrl"   :     "org:postIn"   ,     "valueUrl"   :     "http://example.org/organization/{organizationRef}"   ,     "required"   :     true     }],     "foreignKeys"   :     [{     "columnReference"   :     "reportsToSenior"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/senior-roles.json"   ,     "columnReference"   :     "ref"     }     },     {     "columnReference"   :     "profession"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/professions.json"   ,     "columns"   :     "name"     }     },     {     "columnReference"   :     "organizationRef"   ,     "reference"   :     {     "schemaReference"   :     "http://example.org/gov.uk/schema/organizations.json"   ,     "columns"   :     "ref"     }     }]     }

Note

This example makes extensive use of the example.org domain. As described in [ RFC6761 ], this domain is used for illustrative examples within documentation. In reality, the resources described here with the URL path /gov.uk would be centrally published by the UK Government at, say, the domain data.gov.uk .

Given that these resources are centrally published with an aspiration for reuse, the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#dfn-schema-description" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-schema-description" class="externalDFN"> schema descriptions have been factored out into separate resources. As such, the top-level metadata description resource metadata.json simply provides the list of delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table" class="externalDFN"> tables and binds each of them to the appropriate delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#dfn-schema" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-schema" class="externalDFN"> schema that is defined elsewhere.

Finally, note that because the centrally published metadata descriptions are intended to be reused across many government departments and organizations, extra consideration has been given to defining URIs for the person and post resources defined in each row of the senior roles tabular data and subsequently referenced from the junior roles tabular data. To ensure that naming clashes are avoided, the unique reference for the organization to which the person or post belongs has been included in a path segment of the identifier. For example, the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#dfn-uri-template-property"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#dfn-uri-template-properties"> URI template property delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> aboutUrl used to identify the senior post is specified as http://example.org/organization/{organizationRef}/post/{ref} , thus yielding the URI http://example.org/organization/hefce.ac.uk/post/90115 for the post described in the first delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of the senior roles tabular data.

The delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables generated from parsing the tabular data files and associated metadata is shown below and provides the basis for the conversion to RDF.

Annotations for the delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables G and the four delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables Ta , Tb , Tc , and Td are shown below. below:

delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> Group of Tables annotations:

id	core annotations
id	tables
`G`	`Ta` , `Tb` , `Tc` , `Td`

delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> Table annotations:

id	core annotations
id	`url`	columns	rows	suppress output	foreign keys
`Ta`	`http://example.org/gov.uk/data/organizations.csv`	`Ca1` , `Ca2` , `Ca3`	`Ra1` , `Ra2`	`true`	`Fa1`
`Tb`	`http://example.org/gov.uk/professions.csv`	`Cb1`	`Rb1` , `Rb2` , `Rb3` , `Rb4`	`true`
`Tc`	`http://example.org/senior-roles.csv`	`Cc1` , `Cc2` , `Cc3` , `Cc4` , `Cc5` , `Cc6`	`Rc1` , `Rc2`	`false`	`Fc1` , `Fc2` , `Fc3`
`Td`	`http://example.org/junior-roles.csv`	`Cd1` , `Cd2` , `Cd3` , `Cd4` , `Cd5` , `Cd6` , `Cd7`	`Rd1` , `Rd2`	`false`	`Fd1` , `Fd2` , `Fd3`

Note

In this example, output for the centrally published lists of organizations and professions, tables Ta and Tb ( http://example.org/gov.uk/data/organizations.csv and http://example.org/gov.uk/data/professions.csv respectively), are not required; only information from the departmental submissions is to be translated to RDF. Note the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation on this delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table .

The following foreign keys are defined:

id	columns in table	columns in referenced table
`Fa1`	`Ca3`	`Ca1`
`Fc1`	`Cc5`	`Cc1`
`Fc2`	`Cc6`	`Cb1`
`Fc3`	`Cc7`	`Ca1`
`Fd1`	`Cd1`	`Cc1`
`Fd2`	`Cd7`	`Cb1`
`Fd3`	`Cd8`	`Ca1`

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column annotations:

id	core annotations
id	table	number	source number	cells	name	titles	required	virtual
`Ca1`	`Ta`	1	1	`Ca1.1` , `Ca2.1`	`ref`	`Organization Unique Reference`	`true`
`Ca2`	`Ta`	1	1	`Ca1.2` , `Ca2.2`	`name`	`Organization Name`
`Ca3`	`Ta`	1	1	`Ca1.3` , `Ca2.3`	`department`	`Department Reference`
`Cb1`	`Tb`	1	1	`Cb1.1` , `Cb2.1` , `Cb3.1` , `Cb4.1`	`name`	`Profession`	`true`
`Cc1`	`Tc`	1	1	`Cc1.1` , `Cc2.1`	`ref`	`Post Unique Reference`	`true`
`Cc2`	`Tc`	2	2	`Cc1.2` , `Cc2.2`	`name`	`Name`
`Cc3`	`Tc`	3	3	`Cc1.3` , `Cc2.3`	`grade`	`Grade`
`Cc4`	`Tc`	4	4	`Cc1.4` , `Cc2.4`	`job`	`Job Title`
`Cc5`	`Tc`	5	5	`Cc1.5` , `Cc2.5`	`reportsTo`	`Reports to Senior Post`
`Cc6`	`Tc`	6	6	`Cc1.6` , `Cc2.6`	`profession`	`Profession`
`Cc7`	`Tc`	7	7	`Cc1.7` , `Cc2.7`	`organizationRef`	`Organization Reference`	`true`
`Cc8`	`Tc`	8	8	`Cc1.8` , `Cc2.8`	`post_holder`			`true`
`Cd1`	`Td`	1	1	`Cd1.1` , `Cd2.1`	`reportsToSenior`	`Reporting Senior Post`	`true`
`Cd2`	`Td`	2	2	`Cd1.2` , `Cd2.2`	`grade`	`Grade`
`Cd3`	`Td`	3	3	`Cd1.3` , `Cd2.3`	`min_pay`	`Payscale Minimum (£)`
`Cd4`	`Td`	4	4	`Cd1.4` , `Cd2.4`	`max_pay`	`Payscale Maximum (£)`
`Cd5`	`Td`	5	5	`Cd1.5` , `Cd2.5`	`job`	`Generic Job Title`
`Cd6`	`Td`	6	6	`Cd1.6` , `Cd2.6`	`number`	`Number of Posts (FTE)`
`Cd7`	`Td`	7	7	`Cd1.7` , `Cd2.7`	`profession`	`Profession`
`Cd8`	`Td`	8	8	`Cd1.8` , `Cd2.8`	`organizationRef`	`Organization Reference`	`true`

Note

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Column Cc8 , with the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#column-virtual"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#column-virtual"> virtual annotation specified as true , is used to relate the person resource, whose name is provided in delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column Cc2 , to the associated post resource within the current delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table Tc ( { "url": "http://example.org/senior-roles.csv" } ).

delete: <a title="row" href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> Row annotations:

id	core annotations
id	table	number	source number	cells
`Ra1`	`Ta`	1	2	`Ca1.1` , `Ca1.2` , `Ca1.3`
`Ra2`	`Ta`	2	3	`Ca2.1` , `Ca2.2` , `Ca2.3`
`Rb1`	`Tb`	1	2	`Cb1.1`
`Rb2`	`Tb`	2	3	`Cb2.1`
`Rb3`	`Tb`	3	4	`Cb3.1`
`Rb4`	`Tb`	4	5	`Cb4.1`
`Rc1`	`Tc`	1	2	`Cc1.1` , `Cc1.2` , `Cc1.3` , `Cc1.4` , `Cc1.5` , `Cc1.6` , `Cc1.7` , `Cc1.8`
`Rc2`	`Tc`	2	3	`Cc2.1` , `Cc2.2` , `Cc2.3` , `Cc2.4` , `Cc2.5` , `Cc2.6` , `Cc2.7` , `Cc2.8`
`Rd1`	`Td`	1	2	`Cd1.1` , `Cd1.2` , `Cd1.3` , `Cd1.4` , `Cd1.5` , `Cd1.6` , `Cd1.7` , `Cd1.8`
`Rd2`	`Td`	2	3	`Cd2.1` , `Cd2.2` , `Cd2.3` , `Cd2.4` , `Cd2.5` , `Cd2.6` , `Cd2.7` , `Cd2.8`

delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> Cell annotations:

id	core annotations
id	table	column	row	string value	value	about URL	property URL	value URL
`Ca1.1`	`Ta`	`Ca1`	`Ra1`	`"hefce.ac.uk"`	`"hefce.ac.uk"`	`<http://example.org/organization/hefce.ac.uk>`	`dc:identifier`
`Ca1.2`	`Ta`	`Ca2`	`Ra1`	`"Higher Education Funding Council for England"`	`"Higher Education Funding Council for England"`	`<http://example.org/organization/hefce.ac.uk>`	`foaf:name`
`Ca1.3`	`Ta`	`Ca3`	`Ra1`	`"bis.gov.uk"`	`"bis.gov.uk"`	`<http://example.org/organization/hefce.ac.uk>`	`org:subOrganizationOf`	`<http://example.org/organization/bis.gov.uk>`
`Ca2.1`	`Ta`	`Ca1`	`Ra2`	`"bis.gov.uk"`	`"bis.gov.uk"`	`<http://example.org/organization/bis.gov.uk>`	`dc:identifier`
`Ca2.2`	`Ta`	`Ca2`	`Ra2`	`"Department for Business, Innovation and Skills"`	`"Department for Business, Innovation and Skills"`	`<http://example.org/organization/bis.gov.uk>`	`foaf:name`
`Ca2.3`	`Ta`	`Ca3`	`Ra2`	`"xx"`	`null`	`<http://example.org/organization/bis.gov.uk>`	`org:subOrganizationOf`
`Cb1.1`	`Tb`	`Cb1`	`Rb1`	`"Finance"`	`"Finance"`
`Cb2.1`	`Tb`	`Cb1`	`Rb2`	`"Information Technology"`	`"Information Techology"`
`Cb3.1`	`Tb`	`Cb1`	`Rb3`	`"Operational Delivery"`	`"Operational Delivery"`
`Cb4.1`	`Tb`	`Cb1`	`Rb4`	`"Policy"`	`"Policy"`
`Cc1.1`	`Tc`	`Cc1`	`Rc1`	`"90115"`	`"90115"`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`dc:identifier`
`Cc1.2`	`Tc`	`Cc2`	`Rc1`	`"Steve Egan"`	`"Steve Egan"`	`<http://example.org/organization/hefce.ac.uk/person/1>`	`foaf:name`
`Cc1.3`	`Tc`	`Cc3`	`Rc1`	`"SCS1A"`	`"SCS1A"`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`<http://example.org/gov.uk/def/grade>`
`Cc1.4`	`Tc`	`Cc4`	`Rc1`	`"Deputy Chief Executive"`	`"Deputy Chief Executive"`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`<http://example.org/gov.uk/def/job>`
`Cc1.5`	`Tc`	`Cc5`	`Rc1`	`"90334"`	`"90334"`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`org:reportsTo`	`<http://example.org/organization/hefce.ac.uk/post/90334>`
`Cc1.6`	`Tc`	`Cc6`	`Rc1`	`"Finance"`	`"Finance"`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`<http://example.org/gov.uk/def/profession>`
`Cc1.7`	`Tc`	`Cc7`	`Rc1`	`"hefce.ac.uk"`	`"hefce.ac.uk"`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`org:postIn`	`<http://example.org/organization/hefce.ac.uk>`
`Cc1.8`	`Tc`	`Cc8`	`Rc1`	`""`	`null`	`<http://example.org/organization/hefce.ac.uk/post/90115>`	`org:heldBy`	`<http://example.org/organization/hefce.ac.uk/person/1>`
`Cc2.1`	`Tc`	`Cc1`	`Rc2`	`"90334"`	`"90334"`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`dc:identifier`
`Cc2.2`	`Tc`	`Cc2`	`Rc2`	`"Sir Alan Langlands"`	`"Sir Alan Langlands"`	`<http://example.org/organization/hefce.ac.uk/person/2>`	`foaf:name`
`Cc2.3`	`Tc`	`Cc3`	`Rc2`	`"SCS4"`	`"SCS4"`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`<http://example.org/gov.uk/def/grade>`
`Cc2.4`	`Tc`	`Cc4`	`Rc2`	`"Chief Executive"`	`"Chief Executive"`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`<http://example.org/gov.uk/def/job>`
`Cc2.5`	`Tc`	`Cc5`	`Rc2`	`"xx"`	`null`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`org:reportsTo`
`Cc2.6`	`Tc`	`Cc6`	`Rc2`	`"Policy"`	`"Policy"`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`<http://example.org/gov.uk/def/profession>`
`Cc2.7`	`Tc`	`Cc7`	`Rc2`	`"hefce.ac.uk"`	`"hefce.ac.uk"`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`org:postIn`	`<http://example.org/organization/hefce.ac.uk>`
`Cc2.8`	`Tc`	`Cc8`	`Rc2`	`""`	`null`	`<http://example.org/organization/hefce.ac.uk/post/90334>`	`org:heldBy`	`<http://example.org/organization/hefce.ac.uk/person/2>`
`Cd1.1`	`Td`	`Cd1`	`Rd1`	`"90115"`	`"90115"`		`org:reportsTo`	`<http://example.org/organization/hefce.ac.uk/post/90115>`
`Cd1.2`	`Td`	`Cd2`	`Rd1`	`"4"`	`"4"`		`<http://example.org/gov.uk/def/grade>`
`Cd1.3`	`Td`	`Cd3`	`Rd1`	`"17426"`	`17426`		`<http://example.org/gov.uk/def/min_pay>`
`Cd1.4`	`Td`	`Cd4`	`Rd1`	`"20002"`	`20002`		`<http://example.org/gov.uk/def/max_pay>`
`Cd1.5`	`Td`	`Cd5`	`Rd1`	`"Administrator"`	`"Administrator"`		`<http://example.org/gov.uk/def/job>`
`Cd1.6`	`Td`	`Cd6`	`Rd1`	`"8.67"`	`8.67`		`<http://example.org/gov.uk/def/number_of_posts>`
`Cd1.7`	`Td`	`Cd7`	`Rd1`	`"Operational Delivery"`	`"Operational Delivery"`		`<http://example.org/gov.uk/def/profession>`
`Cd1.8`	`Td`	`Cd8`	`Rd1`	`"hefce.ac.uk"`	`"hefce.ac.uk"`		`org:postIn`	`<http://example.org/organization/hefce.ac.uk>`
`Cd2.1`	`Td`	`Cd1`	`Rd2`	`"90115"`	`"90115"`		`org:reportsTo`	`<http://example.org/organization/hefce.ac.uk/post/90115>`
`Cd2.2`	`Td`	`Cd2`	`Rd2`	`"5"`	`"5"`		`<http://example.org/gov.uk/def/grade>`
`Cd2.3`	`Td`	`Cd3`	`Rd2`	`"19546"`	`19546`		`<http://example.org/gov.uk/def/min_pay>`
`Cd2.4`	`Td`	`Cd4`	`Rd2`	`"22478"`	`22478`		`<http://example.org/gov.uk/def/max_pay>`
`Cd2.5`	`Td`	`Cd5`	`Rd2`	`"Administrator"`	`"Administrator"`		`<http://example.org/gov.uk/def/job>`
`Cd2.6`	`Td`	`Cd6`	`Rd2`	`"0.5"`	`0.5`		`<http://example.org/gov.uk/def/number_of_posts>`
`Cd2.7`	`Td`	`Cd7`	`Rd2`	`"Operational Delivery"`	`"Operational Delivery"`		`<http://example.org/gov.uk/def/profession>`
`Cd2.8`	`Td`	`Cd8`	`Rd2`	`"hefce.ac.uk"`	`"hefce.ac.uk"`		`org:postIn`	`<http://example.org/organization/hefce.ac.uk>`

Note

Notice that delete: <a href="#dfn-value-url" class="internalDFN"> insert: <a href="#dfn-value-url" class="internalDFN" data-link-type="dfn"> value URL is not specified for delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells Ca2.3 and Cc2.5 because in each case the delete: <a href="#dfn-cell-value" class="internalDFN"> insert: <a href="#dfn-cell-value" class="internalDFN" data-link-type="dfn"> cell value is null and the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-column-virtual" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-virtual" class="externalDFN"> virtual annotation of delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column Cb5 is not defined.

Example 23 : http://example.org/public-sector-roles-and-salaries-minimal.ttl

  @prefix   dc   :     <   http   :   //purl.org/dc/terms/> .     @prefix   foaf   :     <   http   :   //xmlns.com/foaf/0.1/> .     @prefix   org   :     <   http   :   //www.w3.org/ns/org#> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .     <   http   :   //example.org/organization/hefce.ac.uk/post/90115>   dc   :   identifier   "90115"     ;   org   :   heldBy   <   http   :   //example.org/organization/hefce.ac.uk/person/1> ;     <   http   :   //example.org/gov.uk/def/grade> "SCS1A" ;     <   http   :   //example.org/gov.uk/def/job> "Deputy Chief Executive" ;   org   :   reportsTo   <   http   :   //example.org/organization/hefce.ac.uk/post/90334> ;     <   http   :   //example.org/gov.uk/def/profession> "Finance" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .     <   http   :   //example.org/organization/hefce.ac.uk/person/1>   foaf   :   name   "Steve Egan"     .     <   http   :   //example.org/organization/hefce.ac.uk/post/90334>   dc   :   identifier   "90334"     ;   org   :   heldBy   <   http   :   //example.org/organization/hefce.ac.uk/person/2> ;     <   http   :   //example.org/gov.uk/def/grade> "SCS4" ;     <   http   :   //example.org/gov.uk/def/job> "Chief Executive" ;     <   http   :   //example.org/gov.uk/def/profession> "Policy" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .     <   http   :   //example.org/organization/hefce.ac.uk/person/2>   foaf   :   name   "Sir Alan Langlands"     .   _   :   d8b8e40c   -   8c74   -   458b   -   99f7   -   64d1cf5c65f2   org   :   reportsTo   <   http   :   //example.org/organization/hefce.ac.uk/post/90115> ;     <   http   :   //example.org/gov.uk/def/grade> "4" ;     <   http   :   //example.org/gov.uk/def/min_pay> "17426"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/max_pay> "20002"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/job> "Administrator" ;     <   http   :   //example.org/gov.uk/def/number_of_posts> "8.67"^^xsd:double ;     <   http   :   //example.org/gov.uk/def/profession> "Operational Delivery" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .   _   :   fa1fa954   -   dd5f   -   4aa1   -   b2bc   -   20bf9867fac6   org   :   reportsTo   <   http   :   //example.org/organization/hefce.ac.uk/post/90115> ;     <   http   :   //example.org/gov.uk/def/grade> "5" ;     <   http   :   //example.org/gov.uk/def/min_pay> "19546"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/max_pay> "22478"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/job> "Administrator" ;     <   http   :   //example.org/gov.uk/def/number_of_posts> "0.5"^^xsd:double ;     <   http   :   //example.org/gov.uk/def/profession> "Operational Delivery" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .

Note

Output for delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables Ta and Tb ( { "url": "http://example.org/gov.uk/data/organizations.csv" } and { "url": "http://example.org/gov.uk/data/professions.csv" } ) are not included as the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-table-suppress-output" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-table-suppress-output" class="externalDFN"> suppress output annotation is true .

The delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL is specified for all delete: <a title="cell" href="#dfn-cell" class="internalDFN"> insert: <a href="#dfn-cell" class="internalDFN" data-link-type="dfn"> cells in delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> tables Tc and Td .

delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> Columns Cc5 and Cd1 ( { "name": "reportsTo" } and { "name": "reportsToSenior" } ) use the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotations to assert the relationship between the post described by a given post insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row insert: </a> and the senior post to which it reports to for the delete: <a title="cell" href="#dfn-cell" class="internalDFN"> cells delete: </a> therein. reports.

Similarly, delete: <a title="column" href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> columns Cc7 and Cd8 (both with { "name": "organizationRef" } ) use the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotations to assert the relationship between the post described by a given post insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row insert: </a> and the organization to which it belongs for the delete: <a title="cell" href="#dfn-cell" class="internalDFN"> cells delete: </a> those delete: <a title="column" href="#dfn-column" class="internalDFN"> columns delete: </a> . belongs.

Finally, note that two resources are created for each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row within delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table Tc ( { "url": "http://example.org/senior-roles.csv" } ): the person and the post they occupy. The relationship between these resources is specified via virtual delete: <a href="#dfn-column" class="internalDFN"> insert: <a href="#dfn-column" class="internalDFN" data-link-type="dfn"> column Cc8 ( { "name": "post_holder" } ) using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-about-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-about-url" class="externalDFN"> about URL , delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-property-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-property-url" class="externalDFN"> property URL and delete: <a href="http://www.w3.org/TR/2015/CR-tabular-data-model-20150716/#dfn-cell-value-url" class="externalDFN"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-data-model-20151117/#dfn-cell-value-url" class="externalDFN"> value URL annotations.

Example 24 : http://example.org/public-sector-roles-and-salaries-standard.ttl

  @prefix   csvw   :     <   http   :   //www.w3.org/ns/csvw#> .     @prefix   dc   :     <   http   :   //purl.org/dc/terms/> .     @prefix   foaf   :     <   http   :   //xmlns.com/foaf/0.1/> .     @prefix   org   :     <   http   :   //www.w3.org/ns/org#> .     @prefix   xsd   :     <   http   :   //www.w3.org/2001/XMLSchema#> .   _   :   3d36cfbb   -   d2d5   -   4573   -   a1a7   -   3bf817062db8   a csvw   :   TableGroup     ;   csvw   :   table   [   a csvw   :   Table     ;   csvw   :   url   <   http   :   //example.org/senior-roles.csv> ;   csvw   :   row   [   a csvw   :   Row     ;   csvw   :   rownum   "1"   ^^   xsd   :   integer   ;   csvw   :   url   <   http   :   //example.org/senior-roles.csv#row=2> ;   csvw   :   describes   <   http   :   //example.org/organization/hefce.ac.uk/post/90115>, <http://example.org/organization/hefce.ac.uk/person/1>     ],     [   a csvw   :   Row     ;   csvw   :   rownum   "2"   ^^   xsd   :   integer   ;   csvw   :   url   <   http   :   //example.org/senior-roles.csv#row=3> ;   csvw   :   describes   <   http   :   //example.org/organization/hefce.ac.uk/post/90334>, <http://example.org/organization/hefce.ac.uk/person/2>     ]     ],     [   a csvw   :   Table     ;   csvw   :   url   <   http   :   //example.org/junior-roles.csv> ;   csvw   :   row   [   a csvw   :   Row     ;   csvw   :   rownum   "1"   ^^   xsd   :   integer   ;   csvw   :   url   <   http   :   //example.org/junior-roles.csv#row=2> ;   csvw   :   describes _   :   d8b8e40c   -   8c74   -   458b   -   99f7   -   64d1cf5c65f2     ],     [   a csvw   :   Row     ;   csvw   :   rownum   "2"   ^^   xsd   :   integer   ;   csvw   :   url   <   http   :   //example.org/junior-roles.csv#row=3> ;   csvw   :   describes _   :   fa1fa954   -   dd5f   -   4aa1   -   b2bc   -   20bf9867fac6     ]     ]     .     <   http   :   //example.org/organization/hefce.ac.uk/post/90115>   dc   :   identifier   "90115"     ;   org   :   heldBy   <   http   :   //example.org/organization/hefce.ac.uk/person/1> ;     <   http   :   //example.org/gov.uk/def/grade> "SCS1A" ;     <   http   :   //example.org/gov.uk/def/job> "Deputy Chief Executive" ;   org   :   reportsTo   <   http   :   //example.org/organization/hefce.ac.uk/post/90334> ;     <   http   :   //example.org/gov.uk/def/profession> "Finance" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .     <   http   :   //example.org/organization/hefce.ac.uk/person/1>   foaf   :   name   "Steve Egan"     .     <   http   :   //example.org/organization/hefce.ac.uk/post/90334>   dc   :   identifier   "90334"     ;   org   :   heldBy   <   http   :   //example.org/organization/hefce.ac.uk/person/2> ;     <   http   :   //example.org/gov.uk/def/grade> "SCS4" ;     <   http   :   //example.org/gov.uk/def/job> "Chief Executive" ;     <   http   :   //example.org/gov.uk/def/profession> "Policy" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .     <   http   :   //example.org/organization/hefce.ac.uk/person/2>   foaf   :   name   "Sir Alan Langlands"     .   _   :   d8b8e40c   -   8c74   -   458b   -   99f7   -   64d1cf5c65f2   org   :   reportsTo   <   http   :   //example.org/organization/hefce.ac.uk/post/90115> ;     <   http   :   //example.org/gov.uk/def/grade> "4" ;     <   http   :   //example.org/gov.uk/def/min_pay> "17426"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/max_pay> "20002"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/job> "Administrator" ;     <   http   :   //example.org/gov.uk/def/number_of_posts> "8.67"^^xsd:double ;     <   http   :   //example.org/gov.uk/def/profession> "Operational Delivery" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .   _   :   fa1fa954   -   dd5f   -   4aa1   -   b2bc   -   20bf9867fac6   org   :   reportsTo   <   http   :   //example.org/organization/hefce.ac.uk/post/90115> ;     <   http   :   //example.org/gov.uk/def/grade> "5" ;     <   http   :   //example.org/gov.uk/def/min_pay> "19546"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/max_pay> "22478"^^xsd:integer ;     <   http   :   //example.org/gov.uk/def/job> "Administrator" ;     <   http   :   //example.org/gov.uk/def/number_of_posts> "0.5"^^xsd:double ;     <   http   :   //example.org/gov.uk/def/profession> "Operational Delivery" ;   org   :   postIn   <   http   :   //example.org/organization/hefce.ac.uk> .

Note

delete: <a title="group of tables" href="#dfn-group-of-tables" class="internalDFN"> insert: <a data-lt="group of tables" href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> Table group G was explicitly defined, but has not been explicitly identified; the table group and table resources are treated as delete: <a title="blank node" href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank nodes .

The person and post resources described by each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table Tc ( { "url": "http://example.org/senior-roles.csv"} ) are explcitly defined using the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-aboutUrl"> insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> aboutUrl property; therefore, say, for delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row Rc1 we state delete: <code> [] the following triples: insert: </p>

insert: <dl class="triple">

subject insert: </dt>: insert: <var> Rc1 insert: </var> insert: </dd>
predicate insert: </dt>: insert: <code> csvw:describes <http://example.org/organization/hefce.ac.uk/post/90115>, insert: </code> insert: </dd>
object insert: </dt>: insert: <code> <http://example.org/organization/hefce.ac.uk/post/90115> insert: </code> insert: </dd>

insert: <dl class="triple">

subject insert: </dt>: insert: <var> Rc1 insert: </var> insert: </dd>
predicate insert: </dt>: insert: <code> csvw:describes insert: </code> insert: </dd>
object insert: </dt>: insert: <code> <http://example.org/organization/hefce.ac.uk/person/1> . delete: </code> ; whilst the delete: <a href="http://www.w3.org/TR/2015/CR-tabular-metadata-20150716/#cell-aboutUrl"> insert: </code> insert: </dd>

insert: <p>

Conversely, the insert: <a href="http://www.w3.org/TR/2015/PR-tabular-metadata-20151117/#cell-aboutUrl"> aboutUrl property has not been defined for resources described by each delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row of delete: <a title="annotated table" href="#dfn-annotated-table" class="internalDFN"> insert: <a href="#dfn-annotated-table" class="internalDFN" data-link-type="dfn"> table Td ( { "url": "http://example.org/junior-roles.csv"} ); therefore delete: <a title="blank node" href="#dfn-blank-node" class="internalDFN"> insert: <a href="#dfn-blank-node" class="internalDFN" data-link-type="dfn"> blank nodes are used, e.g. for delete: <a href="#dfn-row" class="internalDFN"> insert: <a href="#dfn-row" class="internalDFN" data-link-type="dfn"> row Rd1 we state delete: <code> [] the following triple: insert: </p>

insert: <dl class="triple">

subject insert: </dt>: insert: <var> Rd1 insert: </var> insert: </dd>
predicate insert: </dt>: insert: <code> csvw:describes insert: </code> insert: </dd>
object insert: </dt>: insert: <code> _:d8b8e40c-8c74-458b-99f7-64d1cf5c65f2 . delete: </code> . delete: </p> insert: </code> insert: </dd>

ID	fname	addr
PK		→ Addresses(ID)
7	Bob	18

ID	fname	addr	deptName	deptCity
PK		→ Addresses(ID)	→ Department(name,city)
7	Bob	18	accounting	Cambridge

ID	name	city
PK	Unique Key
23	accounting	Cambridge

Generating RDF from Tabular Data on the Web

W3C Candidate Proposed Recommendation delete: `<time property="dcterms:issued" class="dt-published" datetime="2015-07-16">` 16 July insert: `<time property="dcterms:issued" class="dt-published" datetime="2015-11-17">` 17 November 2015

Abstract

Status of This Document

Table of Contents

1. Introduction

2. Conformance

3. Typographical conventions

4. Converting Tabular Data to RDF

4.1 Algorithm terms

4.2 Generating RDF

4.3 Interpreting datatypes

5. Inclusion of provenance information

6. JSON-LD to RDF

7. Examples

7.1 Simple example

7.2 Example with single table and rich annotations

7.3 Example with single table and using virtual columns to produce multiple subjects per row

7.4 Example with delete: `<a href="#dfn-group-of-tables" class="internalDFN">` insert: `<a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn">` group of tables comprising four interrelated tables

A. Relationship to RDB Direct Mapping

A.1 Single table case

A.2 Simple, two table case

A.3 More complex example with three tables

B. Acknowledgements

C. Changes since previous versions

insert: `<span property="xhv:role" resource="xhv:heading">` insert: `<span class="secno">` C.1 insert: `</span>` Changes since candidate recommendation of 16 July 2015 insert: `</span>` insert: `</h3>`

C.1 C.2 Changes since the working draft of 16 April 2015

C.2 C.3 Changes since the first public working draft of 08 January 2015

D. References

D.1 Normative references

D.2 Informative references

Abstract

Status of This Document

Table of Contents

1. Introduction

2. Conformance

3. Typographical conventions

4. Converting Tabular Data to RDF

4.1 Algorithm terms

4.2 Generating RDF

4.3 Interpreting datatypes

5. Inclusion of provenance information

6. JSON-LD to RDF

7. Examples

7.1 Simple example

7.2 Example with single table and rich annotations

7.3 Example with single table and using virtual columns to produce multiple subjects per row

7.4 Example with delete: <a href="#dfn-group-of-tables" class="internalDFN"> insert: <a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn"> group of tables comprising four interrelated tables

A. Relationship to RDB Direct Mapping

A.1 Single table case

A.2 Simple, two table case

A.3 More complex example with three tables

B. Acknowledgements

C. Changes since previous versions

insert: <span property="xhv:role" resource="xhv:heading"> insert: <span class="secno"> C.1 insert: </span> Changes since candidate recommendation of 16 July 2015 insert: </span> insert: </h3>

C.1 C.2 Changes since the working draft of 16 April 2015

C.2 C.3 Changes since the first public working draft of 08 January 2015

D. References

D.1 Normative references

D.2 Informative references

7.4 Example with delete: `<a href="#dfn-group-of-tables" class="internalDFN">` insert: `<a href="#dfn-group-of-tables" class="internalDFN" data-link-type="dfn">` group of tables comprising four interrelated tables

insert: `<span property="xhv:role" resource="xhv:heading">` insert: `<span class="secno">` C.1 insert: `</span>` Changes since candidate recommendation of 16 July 2015 insert: `</span>` insert: `</h3>`