Land Registry Monthly Price Paid Schema (CSV, new version)

land-registry-price-paid.json

{
	"title": "Land Registry Monthly Price Paid Data",
	"description": "Schema for the land registry monthly price-paid data",
	"fields": [
	     {
		"name": "ID",
		"description": "Unique transaction code",
		"constraints": {
			"required": true,
			"minLength": 38,
			"maxLength": 38,
			"pattern": "\\{[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}\\}"
		}
	     },
	     {
		"name": "Price",
		"description": "Price Paid",
		"constraints": {
			"required": true,
			"type": "http://www.w3.org/2001/XMLSchema#nonNegativeInteger"
		}
	     },
	     {
		"name": "Date of Transfer",
		"description": "Data of transfer",
		"constraints": {
			"required": true,
			"type": "http://www.w3.org/2001/XMLSchema#dateTime",
			"datePattern": "%Y-%m-%d %H:%M"
		}
	     },
	     {
		"name": "Postcode",
		"description": "Postcode for the property",
		"constraints": {
			"required": true,
			"pattern": "[A-Z]{1,2}[0-9][0-9A-Z]? ?[0-9][A-Z]{2}"
		}
	     },
	     {
		"name": "Property Type",
		"description": "Type of property (D, S, T, F)",
		"constraints": {
			"required": true,
			"pattern": "(D|S|T|F)"
		}
	     },
	     {
		"name": "Old/New",
		"description": "Old or new property",
		"constraints": {
			"required": true,
			"pattern": "(Y|N)"
		}
	     },
	     {
		"name": "Duration",
		"description": "Duration of transfer",
		"constraints": {
			"required": true,
			"pattern": "(F|L)"
		}
	     },
	     {
		"name": "PAON",
		"constraints": {
			"required": false
		}
	     },
	     {
		"name": "SAON",
		"constraints": {
			"required": false
		}
	     },
	     {
		"name": "Street",
		"constraints": {
			"required": false
		}
	     },
	     {
		"name": "Locality",
		"constraints": {
			"required": false
		}
	     },
	     {
		"name": "Town/City",
		"constraints": {
			"required": false
		}
	     },
	     {
		"name": "Local Authority",
		"constraints": {
			"required": true
		}
	     },
	     {
		"name": "County",
		"constraints": {
			"required": true
		}
	     },
	     {
		"name": "Record Status",
		"constraints": {
			"required": true,
			"pattern": "(A|C|D)"
		}
	     }
	]
}