W3C-CSV-ON-THE-WEB

W3C CSVW CSV + JSON metadata Web data.

Définition

W3C CSVW 4 recommendations decembre 2015 : (1) Model for Tabular Data and Metadata on the Web : conceptual model tables, columns, rows, cells. (2) Metadata Vocabulary for Tabular Data : JSON-LD vocabulary @context csvw:Schema, table, columns, datatypes, virtual columns, transformations. (3) Generating JSON from Tabular Data on the Web : algorithm transformation CSV+metadata -> JSON-LD ou plain JSON. (4) Generating RDF from Tabular Data on the Web : algorithm transformation CSV+metadata -> RDF triples (NTriples, Turtle, RDF/XML). Sample : metadata.json defines tables array, columns with names + datatypes (number, string, date, boolean, URI), constraints (required, unique, pattern regex, minimum/maximum), virtualcolumns (computed), foreignKeys (cross-table). Adoption : open data portals (data.gov.uk, EU Open Data Portal, ONS Office for National Statistics UK), academic data sharing, modest production adoption.

Origine

W3C CSV on the Web Working Group fonde 2014 ; 4 recommendations W3C publiees 17 decembre 2015 ; WG ferme 2016 ; CSVW Community Group continues maintenance W3C.

Exemple en contexte

data.gov.uk publie dataset CSV UK road accidents 2023 (~140000 rows) avec metadata.json CSVW : columns definition (accident_id integer, date xsd:date, longitude decimal, latitude decimal, severity 1-3 enum, etc.), foreign keys vers vehicles.csv ; validation automatic constraint engines (csvlint), transformation RDF Linked Data publishing.

Termes liés

• W3C JSON-LD 1.1 — JSON-LD base.