Data Schemas
CSVW Table Schemas
We provide CSV on the Web metadata files inside our zip downloads. These JSON files contain TableSchema's that describe the columns in our data and their datatypes as JSON.
NOTE: We do not currently host these schemas on the web outside of the bundled and generated downloads. This is because this service has historically focussed on providing bulk access to EPC data, and consequently our principle unit of download are either zip files, or API requests.
The arrangement of the files in our zips is described on the bulk download page for each certificate type, (domestic, non-domestic & display) but most zips, with the exception of the multiple table zip will contain two CSV files, a LICENSE and a schema, and have the following structure:
| Filename | Description |
|---|---|
/certificates.csv |
A table of the main certificate data |
/recommendations.csv |
A table of recommendations, keyed to certificates by LMK_KEY |
/schema.json |
The CSVW metadata file containing two CSVW:TableSchema's for both /certificates.csv and /recommendations.csv. |
/columns.csv |
A data dictionary containing a subset of the information in schema.json but as a CSV file. |
/LICENCE.txt |
The licence and conditions you agree to use the data under |
Bulk downloads through the app will also follow the same structure and contain a CSVW schema.
We provide these schemas for all three certificate types. Though the schemas are similar, they contain differences.
Domestic CSVW Schema
The domestic CSVW metadata file provides the following JSON metadata for both the CSV of certificates and recommendations:
{
"@context": [
"http://www.w3.org/ns/csvw",
{
"@language": "en"
}
],
"tables": [
{
"url": "certificates.csv",
"tableSchema": {
"columns": [
{
"name": "LMK_KEY",
"dc:description": "Individual lodgement identifier. Guaranteed to be unique and can be used to identify a certificate in the downloads and the API.",
"datatype": "string",
"required": true
}, {
"name": "ADDRESS1",
"dc:description": "First line of the address",
"datatype": "string"
}, {
"name": "ADDRESS2",
"dc:description": "Second line of the address",
"datatype": "string"
}, {
"name": "ADDRESS3",
"dc:description": "Third line of the address",
"datatype": "string"
}, {
"name": "POSTCODE",
"dc:description": "The postcode of the property",
"datatype": "string"
}, {
"name": "BUILDING_REFERENCE_NUMBER",
"dc:description": "Unique identifier for the property.",
"datatype": "string"
}, {
"name": "CURRENT_ENERGY_RATING",
"dc:description": "Current energy rating converted into a linear 'A to G' rating (where A is the most energy efficient and G is the least energy efficient)",
"datatype": "string"
}, {
"name": "POTENTIAL_ENERGY_RATING",
"dc:description": "Estimated potential energy rating converted into a linear 'A to G' rating (where A is the most energy efficient and G is the least energy efficient)",
"datatype": "string"
}, {
"name": "CURRENT_ENERGY_EFFICIENCY",
"dc:description": "Based on cost of energy, i.e. energy required for space heating, water heating and lighting [in kWh/year] multiplied by fuel costs. (£/m²/year where cost is derived from kWh).",
"datatype": "integer"
}, {
"name": "POTENTIAL_ENERGY_EFFICIENCY",
"dc:description": "The potential energy efficiency rating of the property.",
"datatype": "integer"
}, {
"name": "PROPERTY_TYPE",
"dc:description": "Describes the type of property such as House, Flat, Maisonette etc. This is the type differentiator for dwellings.",
"datatype": "string"
}, {
"name": "BUILT_FORM",
"dc:description": "The building type of the Property e.g. Detached, Semi-Detached, Terrace etc. Together with the Property Type, the Build Form produces a structured description of the property",
"datatype": "string"
}, {
"name": "INSPECTION_DATE",
"dc:description": "The date that the inspection was actually carried out by the energy assessor",
"datatype": "date"
}, {
"name": "LOCAL_AUTHORITY",
"dc:description": "Office for National Statistics (ONS) code. Local authority area in which the building is located.",
"datatype": "string"
}, {
"name": "CONSTITUENCY",
"dc:description": "Office for National Statistics (ONS) code. Parliamentary constituency in which the building is located.",
"datatype": "string"
}, {
"name": "COUNTY",
"dc:description": "County in which the building is located (where applicable)",
"datatype": "string"
}, {
"name": "LODGEMENT_DATE",
"dc:description": "Date lodged on the Energy Performance of Buildings Register",
"datatype": "date"
}, {
"name": "TRANSACTION_TYPE",
"dc:description": "Type of transaction that triggered EPC. For example, one of: marketed sale; non-marketed sale; new-dwelling; rental; not sale or rental; assessment for Green Deal; following Green Deal; FIT application; none of the above; RHI application; ECO assessment. Where the reason for the assessment is unknown by the energy assessor the transaction type will be recorded as 'none of the above'. Transaction types may be changed over time.",
"datatype": "string"
}, {
"name": "ENVIRONMENTAL_IMPACT_CURRENT",
"dc:description": "The Environmental Impact Rating. A measure of the property's current impact on the environment in terms of carbon dioxide (CO₂) emissions. The higher the rating the lower the CO₂ emissions. (CO₂ emissions in tonnes / year)",
"datatype": "integer"
}, {
"name": "ENVIRONMENTAL_IMPACT_POTENTIAL",
"dc:description": "The potential Environmental Impact Rating. A measure of the property's potential impact on the environment in terms of carbon dioxide (CO₂) emissions after improvements have been carried out. The higher the rating the lower the CO₂ emissions. (CO₂ emissions in tonnes / year)",
"datatype": "integer"
}, {
"name": "ENERGY_CONSUMPTION_CURRENT",
"dc:description": "Current estimated total energy consumption for the property in a 12 month period (kWh/m2). Displayed on EPC as the current primary energy use per square metre of floor area.",
"datatype": "float"
}, {
"name": "ENERGY_CONSUMPTION_POTENTIAL",
"dc:description": "Estimated potential total energy consumption for the Property in a 12 month period. Value is Kilowatt Hours per Square Metre (kWh/m²)",
"datatype": "float"
}, {
"name": "CO2_EMISSIONS_CURRENT",
"dc:description": "CO₂ emissions per year in tonnes/year.",
"datatype": "decimal"
}, {
"name": "CO2_EMISS_CURR_PER_FLOOR_AREA",
"dc:description": "CO₂ emissions per square metre floor area per year in kg/m²",
"datatype": "decimal"
}, {
"name": "CO2_EMISSIONS_POTENTIAL",
"dc:description": "Estimated value in Tonnes per Year of the total CO₂ emissions produced by the Property in 12 month period.",
"datatype": "decimal"
}, {
"name": "LIGHTING_COST_CURRENT",
"dc:description": "GBP. Current estimated annual energy costs for lighting the property.",
"datatype": "float"
}, {
"name": "LIGHTING_COST_POTENTIAL",
"dc:description": "GBP. Potential estimated annual energy costs for lighting the property after improvements have been made.",
"datatype": "float"
}, {
"name": "HEATING_COST_CURRENT",
"dc:description": "GBP. Current estimated annual energy costs for heating the property.",
"datatype": "float"
}, {
"name": "HEATING_COST_POTENTIAL",
"dc:description": "GBP. Potential annual energy costs for lighting the property after improvements have been made.",
"datatype": "float"
}, {
"name": "HOT_WATER_COST_CURRENT",
"dc:description": "GBP. Current estimated annual energy costs for hot water",
"datatype": "float"
}, {
"name": "HOT_WATER_COST_POTENTIAL",
"dc:description": "GBP. Potential estimated annual energy costs for hot water after improvements have been made.",
"datatype": "float"
}, {
"name": "TOTAL_FLOOR_AREA",
"dc:description": "The total useful floor area is the total of all enclosed spaces measured to the internal face of the external walls, i.e. the gross floor area as measured in accordance with the guidance issued from time to time by the Royal Institute of Chartered Surveyors or by a body replacing that institution. (m²)",
"datatype": "decimal"
}, {
"name": "ENERGY_TARIFF",
"dc:description": "Type of electricity tariff for the property, e.g. single.",
"datatype": "string"
}, {
"name": "MAINS_GAS_FLAG",
"dc:description": "Whether mains gas is available. Yes means that there is a gas meter or a gas-burning appliance in the dwelling. A closed-off gas pipe does not count.",
"datatype": "string"
}, {
"name": "FLOOR_LEVEL",
"dc:description": "Flats and maisonettes only. Floor level relative to the lowest level of the property (0 for ground floor). If there is a basement, the basement is level 0 and the other floors are from 1 upwards",
"datatype": "string"
}, {
"name": "FLAT_TOP_STOREY",
"dc:description": "Whether the flat is on the top storey",
"datatype": "string"
}, {
"name": "FLAT_STOREY_COUNT",
"dc:description": "The number of storeys in the apartment block.",
"datatype": "decimal"
}, {
"name": "MAIN_HEATING_CONTROLS",
"dc:description": "Type of main heating controls. Includes both main heating systems if there are two.",
"datatype": "string"
}, {
"name": "MULTI_GLAZE_PROPORTION",
"dc:description": "The estimated banded range (e.g. 0% - 10%) of the total glazed area of the Property that is multiple glazed.",
"datatype": "float"
}, {
"name": "GLAZED_TYPE",
"dc:description": "The type of glazing. From British Fenestration Rating Council or manufacturer declaration, one of; single; double; triple.",
"datatype": "string"
}, {
"name": "GLAZED_AREA",
"dc:description": "Ranged estimate of the total glazed area of the Habitable Area.",
"datatype": "string"
}, {
"name": "EXTENSION_COUNT",
"dc:description": "The number of extensions added to the property. Between 0 and 4.",
"datatype": "integer"
}, {
"name": "NUMBER_HABITABLE_ROOMS",
"dc:description": "Habitable rooms include any living room, sitting room, dining room, bedroom, study and similar; and also a non-separated conservatory. A kitchen/diner having a discrete seating area (with space for a table and four chairs) also counts as a habitable room. A non-separated conservatory adds to the habitable room count if it has an internal quality door between it and the dwelling. Excluded from the room count are any room used solely as a kitchen, utility room, bathroom, cloakroom, en-suite accommodation and similar and any hallway, stairs or landing; and also any room not having a window.",
"datatype": "float"
}, {
"name": "NUMBER_HEATED_ROOMS",
"dc:description": "The number of heated rooms in the property if more than half of the habitable rooms are not heated.",
"datatype": "float"
}, {
"name": "LOW_ENERGY_LIGHTING",
"dc:description": "The percentage of low energy lighting present in the property as a percentage of the total fixed lights in the property. 0% indicates that no low-energy lighting is present.",
"datatype": "integer"
}, {
"name": "NUMBER_OPEN_FIREPLACES",
"dc:description": "The number of Open Fireplaces in the Property. An Open Fireplace is a fireplace that still allows air to pass between the inside of the Property and the outside.",
"datatype": "integer"
}, {
"name": "HOTWATER_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "HOT_WATER_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "HOT_WATER_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "FLOOR_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "FLOOR_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "FLOOR_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "WINDOWS_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "WINDOWS_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "WINDOWS_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "WALLS_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "WALLS_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "WALLS_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "SECONDHEAT_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "SHEATING_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "SHEATING_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "ROOF_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "ROOF_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "ROOF_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "MAINHEAT_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "MAINHEAT_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "MAINHEAT_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "MAINHEATCONT_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "MAINHEATC_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "MAINHEATC_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "LIGHTING_DESCRIPTION",
"dc:description": "Overall description of the property feature",
"datatype": "string"
}, {
"name": "LIGHTING_ENERGY_EFF",
"dc:description": "Energy efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "LIGHTING_ENV_EFF",
"dc:description": "Environmental efficiency rating. One of: very good; good; average; poor; very poor. On actual energy certificate shown as one to five star rating.",
"datatype": "string"
}, {
"name": "MAIN_FUEL",
"dc:description": "The type of fuel used to power the central heating e.g. Gas, Electricity",
"datatype": "string"
}, {
"name": "WIND_TURBINE_COUNT",
"dc:description": "Number of wind turbines; 0 if none.",
"datatype": "float"
}, {
"name": "HEAT_LOSS_CORRIDOR",
"dc:description": "Flats and maisonettes only. Indicates that the flat contains a corridor through which heat is lost. Heat loss corridor, one of: no corridor; heated corridor; unheated corridor",
"datatype": "string"
}, {
"name": "UNHEATED_CORRIDOR_LENGTH",
"dc:description": "The total length of unheated corridor in the flat. Only populated if flat or maisonette contains unheated corridor. If unheated corridor, length of sheltered wall (m²).",
"datatype": "decimal"
}, {
"name": "FLOOR_HEIGHT",
"dc:description": "Average height of the storey in metres.",
"datatype": "decimal"
}, {
"name": "PHOTO_SUPPLY",
"dc:description": "Percentage of photovoltaic area as a percentage of total roof area. 0% indicates that a Photovoltaic Supply is not present in the property.",
"datatype": "float"
}, {
"name": "SOLAR_WATER_HEATING_FLAG",
"dc:description": "Indicates whether the heating in the Property is solar powered.",
"datatype": "string"
}, {
"name": "MECHANICAL_VENTILATION",
"dc:description": "Identifies the type of mechanical ventilation the property has. This is required for the RdSAP calculation.",
"datatype": "string"
}, {
"name": "ADDRESS",
"dc:description": "Field containing the concatenation of address1, address2 and address3. Note that post code is recorded separately.",
"datatype": "string"
}, {
"name": "LOCAL_AUTHORITY_LABEL",
"dc:description": "The name of the local authority area in which the building is located. This field is for additional information only and should not be relied upon: please refer to the Local Authority ONS Code.",
"datatype": "string"
}, {
"name": "CONSTITUENCY_LABEL",
"dc:description": "The name of the parliamentary constituency in which the building is located. This field is for additional information only and should not be relied upon: please refer to the Constituency ONS Code.",
"datatype": "string"
}, {
"name": "POSTTOWN",
"dc:description": "The post town of the property",
"datatype": "string"
}, {
"name": "CONSTRUCTION_AGE_BAND",
"dc:description": "Age band when building part constructed. England & Wales only. One of: before 1900; 1900-1929; 1930-1949; 1950-1966; 1967-1975; 1976-1982; 1983-1990; 1991-1995; 1996-2002; 2003-2006; 2007-2011; 2012 onwards.",
"datatype": "string"
}, {
"name": "LODGEMENT_DATETIME",
"dc:description": "Date and time lodged on the Energy Performance of Buildings Register.",
"datatype": {"base":"datetime",
"format": "yyyy-MM-dd HH:mm:ss"}
}, {
"name": "TENURE",
"dc:description": "Describes the tenure type of the property. One of: Owner-occupied; Rented (social); Rented (private).",
"datatype": "string"
}, {
"name": "FIXED_LIGHTING_OUTLETS_COUNT",
"dc:description": "The number of fixed lighting outlets.",
"datatype": "float"
}, {
"name": "LOW_ENERGY_FIXED_LIGHT_COUNT",
"dc:description": "The number of low-energy fixed lighting outlets.",
"datatype": "float"
}, {
"name": "UPRN",
"dc:description": "The UPRN submitted by an assessor or alternatively from the department’s address matching algorithm.",
"datatype": "integer"
}, {
"name": "UPRN_SOURCE",
"dc:description": "Populated with the values \"Energy Assessor\" or \"Address Matched\" to show how the UPRN was populated.",
"datatype": "string"
}
],
"primaryKey": "LMK_KEY",
"foreignKeys": [{
"columnReference": "LMK_KEY",
"reference": {
"resource": "recommendations.csv",
"columnReference": "LMK_KEY"
}
}]
},
"dialect": {
"header": true
}
} , {
"url": "recommendations.csv",
"tableSchema": {
"columns": [
{
"name": "LMK_KEY",
"dc:description": "Individual lodgement identifier. Guaranteed to be unique and can be used to identify a certificate in the downloads and the API.",
"datatype": "string",
"required": true
}, {
"name": "IMPROVEMENT_ITEM",
"dc:description": "Used to order the recommendations on the output EPC.",
"datatype": "integer"
}, {
"name": "IMPROVEMENT_SUMMARY_TEXT",
"dc:description": "A short description of the suggested improvement.",
"datatype": "string"
}, {
"name": "IMPROVEMENT_DESCR_TEXT",
"dc:description": "Detailed description of the suggested improvement.",
"datatype": "string"
}, {
"name": "IMPROVEMENT_ID",
"dc:description": "Code number associated with the improvement measure.",
"datatype": "integer"
}, {
"name": "IMPROVEMENT_ID_TEXT",
"dc:description": "The text associated with the improvement measure.",
"datatype": "string"
}, {
"name": "INDICATIVE_COST",
"dc:description": "The indicative costs are the cost of installed recommendation measures, which are fixed no matter the type of house being assessed. These are displayed as a cost range on the Energy Performance Certificate as costs vary between individual suppliers.",
"datatype": "string"
}
],
"primaryKey": "LMK_KEY",
"foreignKeys": [{
"columnReference": "LMK_KEY",
"reference": {
"resource": "certificates.csv",
"columnReference": "LMK_KEY"
}
}]
},
"dialect": {
"header": true
}
}
]
}
Non-Domestic CSVW Schema
The non-domestic CSVW metadata file provides the following JSON metadata for both the CSV of certificates and recommendations:
{
"@context": [
"http://www.w3.org/ns/csvw",
{
"@language": "en"
}
],
"tables": [
{
"url": "certificates.csv",
"tableSchema": {
"columns": [
{
"name": "LMK_KEY",
"dc:description": "Individual lodgement identifier. Guaranteed to be unique and can be used to identify a certificate in the downloads and the API.",
"datatype": "string",
"required": true
}, {
"name": "ADDRESS1",
"dc:description": "First line of the address",
"datatype": "string"
}, {
"name": "ADDRESS2",
"dc:description": "Second line of the address",
"datatype": "string"
}, {
"name": "ADDRESS3",
"dc:description": "Third line of the address",
"datatype": "string"
}, {
"name": "POSTCODE",
"dc:description": "The postcode of the property",
"datatype": "string"
}, {
"name": "BUILDING_REFERENCE_NUMBER",
"dc:description": "Unique identifier for the property.",
"datatype": "string"
}, {
"name": "ASSET_RATING",
"dc:description": "Energy Performance Asset Rating. The CO₂ emissions from the actual building in comparison to a Standard Emission Rate. (kg CO₂/m²)",
"datatype": "integer"
}, {
"name": "ASSET_RATING_BAND",
"dc:description": "Energy Performance Asset Rating converted into an energy band/grade into a linear 'A+ to G' scale (where A+ is the most energy efficient and G the least energy efficient)",
"datatype": "string"
}, {
"name": "PROPERTY_TYPE",
"dc:description": "Describes the type of building that is being inspected. Based on planning use class.",
"datatype": "string"
}, {
"name": "INSPECTION_DATE",
"dc:description": "The date that the inspection was actually carried out by the energy assessor",
"datatype": "date"
}, {
"name": "LOCAL_AUTHORITY",
"dc:description": "Office for National Statistics (ONS) code. Local authority area in which the building is located.",
"datatype": "string"
}, {
"name": "CONSTITUENCY",
"dc:description": "Office for National Statistics (ONS) code. Parliamentary constituency in which the building is located.",
"datatype": "string"
}, {
"name": "COUNTY",
"dc:description": "County in which the building is located (where applicable)",
"datatype": "string"
}, {
"name": "LODGEMENT_DATE",
"dc:description": "Date lodged on the Energy Performance of Buildings Register",
"datatype": "date"
}, {
"name": "TRANSACTION_TYPE",
"dc:description": "Type of transaction that triggered EPC. One of: mandatory issue (marketed sale); mandatory issue (non-marketed sale); mandatory issue (property on construction); mandatory issue (property to let); voluntary re-issue (a valid epc is already lodged); voluntary (no legal requirement for an epc); not recorded. Transaction types may be changed over time.",
"datatype": "string"
}, {
"name": "NEW_BUILD_BENCHMARK",
"dc:description": "",
"datatype": "string"
}, {
"name": "EXISTING_STOCK_BENCHMARK",
"dc:description": "The Benchmark value of existing stock for this type of building",
"datatype": "string"
}, {
"name": "BUILDING_LEVEL",
"dc:description": "Building Complexity Level based on Energy Assessor National Occupation Standards",
"datatype": "string"
}, {
"name": "MAIN_HEATING_FUEL",
"dc:description": "Main Heating fuel for the building is taken as the fuel which delivers the greatest total thermal output for space or water heating",
"datatype": "string"
}, {
"name": "OTHER_FUEL_DESC",
"dc:description": "Text description of unspecified fuel type if 'Other' is selected for Main Heating Fuel",
"datatype": "string"
}, {
"name": "SPECIAL_ENERGY_USES",
"dc:description": "Special energy uses discounted. This only appears on the Recommendations Report.",
"datatype": "string"
}, {
"name": "RENEWABLE_SOURCES",
"dc:description": "On-site renewable energy sources. This only appears on the Advisory Report.",
"datatype": "string"
}, {
"name": "FLOOR_AREA",
"dc:description": "The total useful floor area is the total of all enclosed spaces measured to the internal face of the external walls, i.e. the gross floor area as measured in accordance with the guidance issued from time to time by the Royal Institute of Chartered Surveyors or by a body replacing that institution. (m2)",
"datatype": "integer"
}, {
"name": "STANDARD_EMISSIONS",
"dc:description": "Standard Emission Rate is determined by applying a fixed improvement factor to the emissions from a reference building. (kg CO₂/m²/year).",
"datatype": "decimal"
}, {
"name": "TARGET_EMISSIONS",
"dc:description": "Standard Emission Rate is determined by applying a fixed improvement factor to the emissions from a reference building. (kg CO₂/m²/year).",
"datatype": "decimal"
}, {
"name": "TYPICAL_EMISSIONS",
"dc:description": "Typical Emission Rate.",
"datatype": "decimal"
}, {
"name": "BUILDING_EMISSIONS",
"dc:description": "Building Emissions Rate. Annual CO₂ emissions from the building. Decimal (kg CO₂/m²)",
"datatype": "decimal"
}, {
"name": "AIRCON_PRESENT",
"dc:description": "Air Conditioning System. Does the building have an air conditioning system?",
"datatype": "string"
}, {
"name": "AIRCON_KW_RATING",
"dc:description": "Air conditioning System. Rating in kW",
"datatype": "decimal"
}, {
"name": "ESTIMATED_AIRCON_KW_RATING",
"dc:description": "Air Conditioning System. If exact rating unknown, what is the estimated total effective output rating of the air conditioning system",
"datatype": "decimal"
}, {
"name": "AC_INSPECTION_COMMISSIONED",
"dc:description": "One of:1=Yes, inspection completed; 2=Yes, inspection commissioned; 3=No inspection completed or commissioned; 4=Not relevant; 5=Don't know",
"datatype": "integer"
}, {
"name": "BUILDING_ENVIRONMENT",
"dc:description": "Building environment which is taken as the servicing strategy that contributes the largest proportion of the building's CO₂ emissions.",
"datatype": "string"
}, {
"name": "ADDRESS",
"dc:description": "Field containing the concatenation of address1, address2 and address3. Note that post code is recorded separately.",
"datatype": "string"
}, {
"name": "LOCAL_AUTHORITY_LABEL",
"dc:description": "The name of the local authority area in which the building is located. This field is for additional information only and should not be relied upon: please refer to the Local Authority ONS Code.",
"datatype": "string"
}, {
"name": "CONSTITUENCY_LABEL",
"dc:description": "The name of the parliamentary constituency in which the building is located. This field is for additional information only and should not be relied upon: please refer to the Constituency ONS Code.",
"datatype": "string"
}, {
"name": "POSTTOWN",
"dc:description": "The post town of the property",
"datatype": "string"
}, {
"name": "LODGEMENT_DATETIME",
"dc:description": "Date and time lodged on the Energy Performance of Buildings Register.",
"datatype": "string"
}, {
"name": "PRIMARY_ENERGY_VALUE",
"dc:description": "Displayed on the non-domestic EPC as primary energy use (kWh/m2 per year)",
"datatype": "integer"
}, {
"name": "UPRN",
"dc:description": "The UPRN submitted by an assessor or alternatively from the department’s address matching algorithm.",
"datatype": "integer"
}, {
"name": "UPRN_SOURCE",
"dc:description": "Populated with the values \"Energy Assessor\" or \"Address Matched\" to show how the UPRN was populated.",
"datatype": "string"
}
],
"primaryKey": "LMK_KEY",
"foreignKeys": [{
"columnReference": "LMK_KEY",
"reference": {
"resource": "recommendations.csv",
"columnReference": "LMK_KEY"
}
}]
},
"dialect": {
"header": true
}
} , {
"url": "recommendations.csv",
"tableSchema": {
"columns": [
{
"name": "PAYBACK_TYPE",
"datatype": "string",
"required": true
},
{
"name": "LMK_KEY",
"datatype": "string",
"required": true
}, {
"name": "RECOMMENDATION_ITEM",
"datatype": "integer"
}, {
"name": "RECOMMENDATION_CODE",
"datatype": "string"
}, {
"name": "RECOMMENDATION",
"datatype": "string"
}, {
"name": "CO2_IMPACT",
"datatype": "string"
}
],
"primaryKey": "LMK_KEY",
"foreignKeys": [{
"columnReference": "LMK_KEY",
"reference": {
"resource": "certificates.csv",
"columnReference": "LMK_KEY"
}
}]
},
"dialect": {
"header": true
}
}
]
}
Display CSVW Schema
The display CSVW metadata file provides the following JSON metadata for both the CSV of certificates and recommendations:
{
"@context": [
"http://www.w3.org/ns/csvw",
{
"@language": "en"
}
],
"tables": [
{
"url": "certificates.csv",
"tableSchema": {
"columns": [
{
"name": "LMK_KEY",
"dc:description": "Individual lodgement identifier. Guaranteed to be unique and can be used to identify a certificate in the downloads and the API.",
"datatype": "string",
"required": true
}, {
"name": "ADDRESS1",
"dc:description": "First line of the address",
"datatype": "string"
}, {
"name": "ADDRESS2",
"dc:description": "Second line of the address",
"datatype": "string"
}, {
"name": "ADDRESS3",
"dc:description": "Third line of the address",
"datatype": "string"
}, {
"name": "POSTCODE",
"dc:description": "The postcode of the property",
"datatype": "string"
}, {
"name": "BUILDING_REFERENCE_NUMBER",
"dc:description": "Unique identifier for the property.",
"datatype": "string"
}, {
"name": "CURRENT_OPERATIONAL_RATING",
"dc:description": "Current Operational Rating (OR) for this building. A numeric indicator of the amount of energy consumed during the occupation of the building over a period of 12 months. An OR is a measure of the annual (CO₂) emission per unit of area of the building caused by its consumption of energy, compared to a value that would be considered typical for the particular type of building. The numbers do not represent actual units of energy consumed; they represent comparative energy efficiency.",
"datatype": "float"
}, {
"name": "YR1_OPERATIONAL_RATING",
"dc:description": "Operational Ratings from previous years (CO₂).",
"datatype": "float"
}, {
"name": "YR2_OPERATIONAL_RATING",
"dc:description": "Operational Ratings from previous years (CO₂).",
"datatype": "float"
}, {
"name": "OPERATIONAL_RATING_BAND",
"dc:description": "Current Operational Rating converted into an energy band/grade into a linear 'A to G' scale (where A is the most energy efficient and G the least energy efficient).",
"datatype": "string"
}, {
"name": "ELECTRIC_CO2",
"dc:description": "Total CO₂ emissions from electricity. The energy used by the building is converted into an amount of carbon dioxide (CO₂). Different types of fuel emit different amounts of CO₂. Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "HEATING_CO2",
"dc:description": "Total CO₂ emissions from heating. The energy used by the building is converted into an amount of carbon dioxide (CO₂). Different types of fuel emit different amounts of CO₂. Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "RENEWABLES_CO2",
"dc:description": "Total CO₂ emissions from Renewable sources. On-Site Renewables (OSR) include technologies that generate heat or electricity from ambient sources and have zero (or near zero) CO₂ emissions. The energy they deliver reduces CO₂ emissions from the building.",
"datatype": "float"
}, {
"name": "PROPERTY_TYPE",
"dc:description": "Describes the type of building that is being inspected.",
"datatype": "string"
}, {
"name": "INSPECTION_DATE",
"dc:description": "The date that the inspection was actually carried out by the energy assessor",
"datatype": "date"
}, {
"name": "LOCAL_AUTHORITY",
"dc:description": "Office for National Statistics (ONS) code. Local authority area in which the building is located.",
"datatype": "string"
}, {
"name": "CONSTITUENCY",
"dc:description": "Office for National Statistics (ONS) code. Parliamentary constituency in which the building is located.",
"datatype": "string"
}, {
"name": "COUNTY",
"dc:description": "County in which the building is located (where applicable)",
"datatype": "string"
}, {
"name": "LODGEMENT_DATE",
"dc:description": "Date lodged on the Energy Performance of Buildings Register",
"datatype": "date"
}, {
"name": "MAIN_BENCHMARK",
"dc:description": "The benchmark is the average energy performance for a building of this type, under a number of standardised conditions for temperature, occupancy and proportion of non-electrical energy used. Under certain circumstances, these benchmarks may be adjusted according to location, occupancy and the ratio of non-electrical energy used.",
"datatype": "string"
}, {
"name": "MAIN_HEATING_FUEL",
"dc:description": "This indicates the main type of fuel used to heat the building.",
"datatype": "string"
}, {
"name": "OTHER_FUEL",
"dc:description": "Text description of unspecified fuel type if 'Other' is selected for Main-Heating-Fuel.",
"datatype": "string"
}, {
"name": "SPECIAL_ENERGY_USES",
"dc:description": "Separable energy uses. The aim of the Operational Rating is to compare the annual energy consumption of the building with that of a building typical of its type. In some cases the building may include activities that consume energy and which are not considered typical of that building type. It may be reasonable to subtract these separable energy uses in certain circumstances. In order to be able to isolate and remove the annual separable energy consumption from the total, any separable energy uses must be separately metered. This only appears on the Recommendations Report.",
"datatype": "string"
}, {
"name": "RENEWABLE_SOURCES",
"dc:description": "On-site renewable energy sources. This only appears on the Recommendations Report.",
"datatype": "string"
}, {
"name": "TOTAL_FLOOR_AREA",
"dc:description": "Total Useful Floor Area (m²)",
"datatype": "integer"
}, {
"name": "ANNUAL_THERMAL_FUEL_USAGE",
"dc:description": "Annual Energy Use (kWh/m²/year) for heating",
"datatype": "integer"
}, {
"name": "TYPICAL_THERMAL_FUEL_USAGE",
"dc:description": "Typical Energy Use (kWh/m²/year) for heating",
"datatype": "integer"
}, {
"name": "ANNUAL_ELECTRICAL_FUEL_USAGE",
"dc:description": "Annual Energy Use (kWh/m²/year) for electricity",
"datatype": "integer"
}, {
"name": "TYPICAL_ELECTRICAL_FUEL_USAGE",
"dc:description": "Typical Energy Use (kWh/m²/year) for electricity",
"datatype": "integer"
}, {
"name": "RENEWABLES_FUEL_THERMAL",
"dc:description": "Percentage of energy obtained from on-site renewable sources for heating (if any)",
"datatype": "integer"
}, {
"name": "RENEWABLES_ELECTRICAL",
"dc:description": "Percentage of energy obtained from on-site renewable sources for electricity (if any).",
"datatype": "float"
}, {
"name": "YR1_ELECTRICITY_CO2",
"dc:description": "CO₂ emissions from electricity in previous reporting year (if any). Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "YR2_ELECTRICITY_CO2",
"dc:description": "CO₂ emissions from electricity in previous reporting year (if any). Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "YR1_HEATING_CO2",
"dc:description": "CO₂ emissions from heating in previous reporting year (if any). Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "YR2_HEATING_CO2",
"dc:description": "CO₂ emissions from heating in previous reporting year (if any). Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "YR1_RENEWABLES_CO2",
"dc:description": "CO₂ emissions from renewable sources in previous reporting year (if any). Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "YR2_RENEWABLES_CO2",
"dc:description": "CO₂ emissions from renewable sources in previous reporting year (if any). Total CO₂ emissions in tonnes per year of CO₂.",
"datatype": "float"
}, {
"name": "AIRCON_PRESENT",
"dc:description": "Air Conditioning System. Does the building have an air conditioning system?",
"datatype": "string"
}, {
"name": "AIRCON_KW_RATING",
"dc:description": "Air conditioning System. Rating in kW",
"datatype": "float"
}, {
"name": "ESTIMATED_AIRCON_KW_RATING",
"dc:description": "Air Conditioning System. If exact rating unknown, what is the estimated total effective output rating of the air conditioning system in kW.",
"datatype": "float"
}, {
"name": "AC_INSPECTION_COMMISSIONED",
"dc:description": "One of:1=Yes, inspection completed; 2=Yes, inspection commissioned; 3=No inspection completed or commissioned; 4=Not relevant; 5=Don't know",
"datatype": "float"
}, {
"name": "BUILDING_ENVIRONMENT",
"dc:description": "Building environment which is taken as the servicing strategy that contributes the largest proportion of the building's CO2 emissions.",
"datatype": "string"
}, {
"name": "BUILDING_CATEGORY",
"dc:description": "Building category codes. This data field may contain multiple benchmark categories. Where a building has a mix of uses that would place parts of the building in a different benchmark category, it is possible to construct a composite benchmark, e.g. a school with a swimming pool.",
"datatype": "string"
}, {
"name": "ADDRESS",
"dc:description": "Field containing the concatenation of address1, address2 and address3. Note that post code is recorded separately.",
"datatype": "string"
}, {
"name": "LOCAL_AUTHORITY_LABEL",
"dc:description": "The name of the local authority area in which the building is located. This field is for additional information only and should not be relied upon: please refer to the Local Authority ONS Code.",
"datatype": "string"
}, {
"name": "CONSTITUENCY_LABEL",
"dc:description": "The name of the parliamentary constituency in which the building is located. This field is for additional information only and should not be relied upon: please refer to the Constituency ONS Code.",
"datatype": "string"
}, {
"name": "POSTTOWN",
"dc:description": "The post town of the property",
"datatype": "string"
}, {
"name": "NOMINATED_DATE",
"dc:description": "The default nominated date is the assessment date. The assessor can select an alternative nominated date no later than three months after the end of the assessment period.",
"datatype": "date"
}, {
"name": "OR_ASSESSMENT_END_DATE",
"dc:description": "Specified end date of the assessment period.",
"datatype": "date"
}, {
"name": "LODGEMENT_DATETIME",
"dc:description": "Date and time lodged on the Energy Performance of Buildings Register.",
"datatype": {"base":"datetime",
"format": "yyyy-MM-dd HH:mm:ss"}
}, {
"name": "OCCUPANCY_LEVEL",
"dc:description": "Occupancy during the hours of operation of the building.",
"datatype": "string"
}, {
"name": "UPRN",
"dc:description": "The UPRN submitted by an assessor or alternatively from the department’s address matching algorithm.",
"datatype": "integer"
}, {
"name": "UPRN_SOURCE",
"dc:description": "Populated with the values \"Energy Assessor\" or \"Address Matched\" to show how the UPRN was populated.",
"datatype": "string"
}
],
"primaryKey": "LMK_KEY",
"foreignKeys": [{
"columnReference": "LMK_KEY",
"reference": {
"resource": "recommendations.csv",
"columnReference": "LMK_KEY"
}
}]
},
"dialect": {
"header": true
}
} , {
"url": "recommendations.csv",
"tableSchema": {
"columns": [
{
"name": "PAYBACK_TYPE",
"dc:description": "TODO",
"datatype": "string",
"required": true
},
{
"name": "LMK_KEY",
"dc:description": "Individual lodgement identifier. Guaranteed to be unique and can be used to identify a certificate in the downloads and the API.",
"datatype": "string",
"required": true
}, {
"name": "RECOMMENDATION_ITEM",
"dc:description": "Used to order the recommendations on the output EPC.",
"datatype": "integer"
}, {
"name": "RECOMMENDATION_CODE",
"dc:description": "Shorthand code to represent the recommendation.",
"datatype": "string"
}, {
"name": "RECOMMENDATION",
"dc:description": "Description of the suggested improvement.",
"datatype": "string"
}, {
"name": "CO2_IMPACT",
"dc:description": "Descriptor for impact on co2 (e.g. LOW)",
"datatype": "string"
}
],
"primaryKey": "LMK_KEY",
"foreignKeys": [{
"columnReference": "LMK_KEY",
"reference": {
"resource": "certificates.csv",
"columnReference": "LMK_KEY"
}
}]
},
"dialect": {
"header": true
}
}
]
}
CSV Data Dictionary (columns.csv)
As an added convenience we also provide the main metadata from
of our CSVW schemas in a columns.csv file for
consumers wishing to use this metadata in tabular
environments, such as spreadsheets.
This file is provided inside zips downloaded with custom searches through our app, and in most of our bulk zip downloads. For details on the specific zip contents, please see the download page for each certificate type ( Domestic EPC, Non-domestic EPC and DEC).
The format of all of our columns.csv tables is:
| Column | Description |
|---|---|
| filename | The filename the column is located in; currently either certificates.csv or recommendations.csv. |
| column | The column in the source data file that this row provides metadata about. The values here match the column headings in the data files, e.g. LMK_KEY. |
| datatype | The built in CSVW datatype we use or derive a datatype from. e.g. string, decimal, date etc... |
| description | An English language description of the field. |