diff --git a/codelists-metadata.json b/codelists-metadata.json new file mode 100644 index 0000000..4501326 --- /dev/null +++ b/codelists-metadata.json @@ -0,0 +1,12 @@ +{ + "@context": ["http://www.w3.org/ns/csvw", {"@language": "en"}], + "tables": [{ + "url": "codelists/british-isles.csv", + "tableSchema": "https://ons-opendata.github.io/ref_common/codelist-schema.json", + "rdfs:label": "British Isles" + }, { + "url": "codelists/british-islands.csv", + "tableSchema": "https://ons-opendata.github.io/ref_common/codelist-schema.json", + "rdfs:label": "British Islands" + }] +} diff --git a/columns.csv b/columns.csv new file mode 100644 index 0000000..a7f5903 --- /dev/null +++ b/columns.csv @@ -0,0 +1,8 @@ +title,name,component_attachment,property_template,value_template,datatype,value_transformation +Place,place,qb:dimension,http://purl.org/linked-data/sdmx/2009/dimension#refArea,http://www.wikidata.org/entity/{wikidata_id},string,, +Wikidata ID,wikidata_id,qb:dimension,http://purl.org/linked-data/sdmx/2009/dimension#refArea,http://www.wikidata.org/entity/{wikidata_id},string,, +Year,year,qb:dimension,http://purl.org/linked-data/sdmx/2009/dimension#refPeriod,http://reference.data.gov.uk/id/year/{year},string, +Measure Type,measure_type,qb:dimension,http://purl.org/linked-data/cube#measureType,http://gss-data.org.uk/def/measure/{measure_type},string,slugize +Value,value,,http://gss-data.org.uk/def/measure/{measure_type},,number, +Count,count,qb:measure,http://gss-data.org.uk/def/measure/count,,number, +Unit,unit,qb:attribute,http://purl.org/linked-data/sdmx/2009/attribute#unitMeasure,http://gss-data.org.uk/def/concept/measurement-units/{unit},string,unitize diff --git a/components.csv b/components.csv new file mode 100644 index 0000000..ec7ba90 --- /dev/null +++ b/components.csv @@ -0,0 +1 @@ +Label,Description,Component Type,Codelist diff --git a/population-british-islands.csv-metadata.json b/population-british-islands.csv-metadata.json new file mode 100644 index 0000000..1558f5a --- /dev/null +++ b/population-british-islands.csv-metadata.json @@ -0,0 +1,138 @@ +{ + "@context": [ + "http://www.w3.org/ns/csvw", + { + "@language": "en" + } + ], + "tables": [ + { + "url": "population-british-islands.csv", + "tableSchema": { + "columns": [ + { + "titles": "Place", + "required": true, + "name": "place", + "datatype": "string", + "suppressOutput": true + }, + { + "titles": "Wikidata ID", + "required": true, + "name": "wikidata_id", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/sdmx/2009/dimension#refArea", + "valueUrl": "http://www.wikidata.org/entity/{wikidata_id}" + }, + { + "titles": "Year", + "required": true, + "name": "year", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/sdmx/2009/dimension#refPeriod", + "valueUrl": "http://reference.data.gov.uk/id/year/{year}" + }, + { + "titles": "Population", + "required": true, + "name": "value", + "datatype": "integer", + "propertyUrl": "http://gss-data.org.uk/def/measure/count" + }, + { + "titles": "Measure Type", + "virtual": true, + "name": "measure_type", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/cube#measureType", + "valueUrl": "http://gss-data.org.uk/def/measure/count" + }, + { + "titles": "Unit", + "virtual": true, + "name": "unit", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/sdmx/2009/attribute#unitMeasure", + "valueUrl": "http://gss-data.org.uk/def/concept/measurement-units/people" + }, + { + "name": "dataset_ref", + "virtual": true, + "propertyUrl": "qb:dataSet", + "valueUrl": "http://gss-data.org.uk/population-british-islands" + }, + { + "name": "qbtype", + "virtual": true, + "propertyUrl": "rdf:type", + "valueUrl": "qb:Observation" + } + ], + "foreignKeys": [], + "primaryKey": [ + "place", + "wikidata_id", + "year", + "measure_type" + ], + "aboutUrl": "http://gss-data.org.uk/population-british-islands/{wikidata_id}/{year}/count" + } + } + ], + "@id": "http://gss-data.org.uk/population-british-islands#tablegroup", + "prov:hadDerivation": { + "@id": "http://gss-data.org.uk/population-british-islands", + "@type": [ + "qb:DataSet" + ], + "qb:structure": { + "@id": "http://gss-data.org.uk/population-british-islands/structure", + "@type": "qb:DataStructureDefinition", + "qb:component": [ + { + "@id": "http://gss-data.org.uk/population-british-islands/component/place", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/sdmx/2009/dimension#refArea" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-islands/component/wikidata_id", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/sdmx/2009/dimension#refArea" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-islands/component/year", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/sdmx/2009/dimension#refPeriod" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-islands/component/measure_type", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/cube#measureType" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-islands/component/unit", + "@type": "qb:ComponentSpecification", + "qb:attribute": { + "@id": "http://purl.org/linked-data/sdmx/2009/attribute#unitMeasure" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-islands/component/count", + "@type": "qb:ComponentSpecification", + "qb:measure": { + "@id": "http://gss-data.org.uk/def/measure/count" + } + } + ] + } + } +} diff --git a/population-british-isles.csv-metadata.json b/population-british-isles.csv-metadata.json new file mode 100644 index 0000000..caf2581 --- /dev/null +++ b/population-british-isles.csv-metadata.json @@ -0,0 +1,138 @@ +{ + "@context": [ + "http://www.w3.org/ns/csvw", + { + "@language": "en" + } + ], + "tables": [ + { + "url": "population-british-isles.csv", + "tableSchema": { + "columns": [ + { + "titles": "Place", + "required": true, + "name": "place", + "datatype": "string", + "suppressOutput": true + }, + { + "titles": "Wikidata ID", + "required": true, + "name": "wikidata_id", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/sdmx/2009/dimension#refArea", + "valueUrl": "http://www.wikidata.org/entity/{wikidata_id}" + }, + { + "titles": "Year", + "required": true, + "name": "year", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/sdmx/2009/dimension#refPeriod", + "valueUrl": "http://reference.data.gov.uk/id/year/{year}" + }, + { + "titles": "Measure Type", + "required": true, + "name": "measure_type", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/cube#measureType", + "valueUrl": "http://gss-data.org.uk/def/measure/{measure_type}" + }, + { + "titles": "Unit", + "required": true, + "name": "unit", + "datatype": "string", + "propertyUrl": "http://purl.org/linked-data/sdmx/2009/attribute#unitMeasure", + "valueUrl": "http://gss-data.org.uk/def/concept/measurement-units/{unit}" + }, + { + "titles": "Value", + "required": true, + "name": "value", + "datatype": "integer", + "propertyUrl": "http://gss-data.org.uk/def/measure/{measure_type}" + }, + { + "name": "dataset_ref", + "virtual": true, + "propertyUrl": "qb:dataSet", + "valueUrl": "http://gss-data.org.uk/population-british-isles" + }, + { + "name": "qbtype", + "virtual": true, + "propertyUrl": "rdf:type", + "valueUrl": "qb:Observation" + } + ], + "foreignKeys": [], + "primaryKey": [ + "place", + "wikidata_id", + "year", + "measure_type" + ], + "aboutUrl": "http://gss-data.org.uk/population-british-isles/{wikidata_id}/{year}/{measure_type}" + } + } + ], + "@id": "http://gss-data.org.uk/population-british-isles#tablegroup", + "prov:hadDerivation": { + "@id": "http://gss-data.org.uk/population-british-isles", + "@type": [ + "qb:DataSet" + ], + "qb:structure": { + "@id": "http://gss-data.org.uk/population-british-isles/structure", + "@type": "qb:DataStructureDefinition", + "qb:component": [ + { + "@id": "http://gss-data.org.uk/population-british-isles/component/place", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/sdmx/2009/dimension#refArea" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-isles/component/wikidata_id", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/sdmx/2009/dimension#refArea" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-isles/component/year", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/sdmx/2009/dimension#refPeriod" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-isles/component/measure_type", + "@type": "qb:ComponentSpecification", + "qb:dimension": { + "@id": "http://purl.org/linked-data/cube#measureType" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-isles/component/unit", + "@type": "qb:ComponentSpecification", + "qb:attribute": { + "@id": "http://purl.org/linked-data/sdmx/2009/attribute#unitMeasure" + } + }, + { + "@id": "http://gss-data.org.uk/population-british-isles/component/count", + "@type": "qb:ComponentSpecification", + "qb:measure": { + "@id": "http://gss-data.org.uk/def/measure/count" + } + } + ] + } + } +}