# AddressBase Premium An address from the Ordnance Survey AddressBase Premium dataset. Please contact us to have this enabled on your account. All AddressBase Premium addresses have a UPRN and a rooftop geolocation available; however, they may not have a UDPRN. A property record from Ordnance Survey's AddressBase Premium, Ordnance Survey's most detailed address dataset for Great Britain. Each record is a Basic Land and Property Unit (BLPU) keyed by its UPRN. Alongside the Royal Mail delivery point it carries the local authority address (`pao_*`, `sao_*`, `usrn`), classification (`classification_code`), lifecycle (`logical_status`, `blpu_state`), coordinates, Welsh alternatives (`welsh_*`), the street record (`street_*`) and cross references to OS MasterMap (`toid`), the Valuation Office Agency (`council_tax_ref`, `ndr_ref`) and ONS (`ons_ward_code`, `ons_parish_code`). Ordnance Survey publishes around 40 million records and refreshes them every six weeks. How it differs from the neighbouring datasets: * **AddressBase Core** (`ab`) is a weekly, flat cut of the current approved records: one row per UPRN with coordinates, a two-character classification and the key identifiers. It carries no history, no provisional records, no Welsh alternatives, no local authority address breakdown and no street, VOA or ONS cross references. * **Royal Mail PAF** (`paf`) lists delivery points, keyed by UDPRN. The vast majority of PAF addresses are matched to a UPRN, but there will always be a small number (\~1%) with no corresponding record on AddressBase Premium. PAF holds around 30 million GB delivery points against AddressBase Premium's 40 million UPRNs; the difference is non-postal objects (substations, car parks, sites under construction), provisional and historic records. Every GB PAF delivery point appears here as the `dpa_*` record. * **OS NGD Address** carries the same content restructured into feature types with daily currency. AddressBase Premium is not being retired. The Ordnance Survey end of life notice for autumn 2027 covers AddressBase and AddressBase Plus only. ## Example Record | Field | Example | Type | | ----------------------------------------------------------------------------------------------------- | ---------------------------------------------- | -------- | | [Unique Property Reference Number `uprn`](#unique-property-reference-number) | 49020496 | `string` | | [Parent UPRN `parent_uprn`](#parent-uprn) | 49020495 | `string` | | [Logical Status Code `logical_status`](#logical-status-code) | `1` | `number` | | [BLPU State Code `blpu_state`](#blpu-state-code) | 2 | `string` | | [BLPU State Date `blpu_state_date`](#blpu-state-date) | 2011-10-06T00:00:00.000Z | `string` | | [Country Code `country`](#country-code) | W | `string` | | [Latitude (ETRS89) `latitude`](#latitude-etrs89) | `52.4121999` | `number` | | [Longitude (ETRS89) `longitude`](#longitude-etrs89) | `-4.0883772` | `number` | | [Eastings (OSGB36 British National Grid) `x_coordinate`](#eastings-osgb36-british-national-grid) | `258053.87` | `number` | | [Northings (OSGB36 British National Grid) `y_coordinate`](#northings-osgb36-british-national-grid) | `281405.95` | `number` | | [Representative Point Code `rpc`](#representative-point-code) | `2` | `number` | | [Local Custodian Code `local_custodian_code`](#local-custodian-code) | `6820` | `number` | | [AddressBase Postal Code `addressbase_postal`](#addressbase-postal-code) | D | `string` | | [Postcode Locator `postcode_locator`](#postcode-locator) | SY23 1JT | `string` | | [Multi-occupancy Count `multi_occ_count`](#multi-occupancy-count) | `4` | `number` | | [BLPU Start Date `blpu_start_date`](#blpu-start-date) | 2007-10-24T00:00:00.000Z | `string` | | [BLPU End Date `blpu_end_date`](#blpu-end-date) | `null` | `object` | | [BLPU Last Update Date `blpu_last_update_date`](#blpu-last-update-date) | 2025-10-13T00:00:00.000Z | `string` | | [BLPU Entry Date `blpu_entry_date`](#blpu-entry-date) | 2006-11-24T00:00:00.000Z | `string` | | [Unique Delivery Point Reference Number `udprn`](#unique-delivery-point-reference-number) | 24255522 | `string` | | [Organisation Name `organisation_name`](#organisation-name) | `null` | `object` | | [Legal Name `legal_name`](#legal-name) | `null` | `object` | | [Department Name `department_name`](#department-name) | `null` | `object` | | [Sub-building Name `sub_building_name`](#sub-building-name) | `null` | `object` | | [Building Name `building_name`](#building-name) | `null` | `object` | | [Building Number `building_number`](#building-number) | `1` | `number` | | [Dependent Thoroughfare `dependent_thoroughfare`](#dependent-thoroughfare) | Castle Terrace | `string` | | [Thoroughfare `thoroughfare`](#thoroughfare) | South Road | `string` | | [Double Dependent Locality `double_dependent_locality`](#double-dependent-locality) | `null` | `object` | | [Dependent Locality `dependent_locality`](#dependent-locality) | `null` | `object` | | [Post Town `post_town`](#post-town) | Aberystwyth | `string` | | [Postcode `postcode`](#postcode) | SY23 1JT | `string` | | [Postcode Type Code `postcode_type`](#postcode-type-code) | S | `string` | | [Delivery Point Suffix `delivery_point_suffix`](#delivery-point-suffix) | 1A | `string` | | [PO Box Number `po_box_number`](#po-box-number) | `null` | `object` | | [Welsh Dependent Thoroughfare `welsh_dependent_thoroughfare`](#welsh-dependent-thoroughfare) | HEOL Y CASTELL | `string` | | [Welsh Thoroughfare `welsh_thoroughfare`](#welsh-thoroughfare) | TAN Y CAE | `string` | | [Welsh Double Dependent Locality `welsh_double_dependent_locality`](#welsh-double-dependent-locality) | `null` | `object` | | [Welsh Dependent Locality `welsh_dependent_locality`](#welsh-dependent-locality) | `null` | `object` | | [Welsh Post Town `welsh_post_town`](#welsh-post-town) | ABERYSTWYTH | `string` | | [DPA Process Date `dpa_process_date`](#dpa-process-date) | 2016-01-18T00:00:00.000Z | `string` | | [DPA Start Date `dpa_start_date`](#dpa-start-date) | 2012-04-23T00:00:00.000Z | `string` | | [DPA End Date `dpa_end_date`](#dpa-end-date) | `null` | `object` | | [DPA Last Update Date `dpa_last_update_date`](#dpa-last-update-date) | 2016-02-10T00:00:00.000Z | `string` | | [DPA Entry Date `dpa_entry_date`](#dpa-entry-date) | 2012-03-19T00:00:00.000Z | `string` | | [Classification Code `classification_code`](#classification-code) | RD04 | `string` | | [Classification Scheme `class_scheme`](#classification-scheme) | AddressBase Premium Classification Scheme | `string` | | [Classification Scheme Version `scheme_version`](#classification-scheme-version) | `1` | `number` | | [Classification Start Date `classification_start_date`](#classification-start-date) | 2007-10-24T00:00:00.000Z | `string` | | [Classification End Date `classification_end_date`](#classification-end-date) | `null` | `object` | | [Classification Last Update Date `classification_last_update_date`](#classification-last-update-date) | 2018-09-23T00:00:00.000Z | `string` | | [Classification Entry Date `classification_entry_date`](#classification-entry-date) | 2006-11-24T00:00:00.000Z | `string` | | [Organisation Start Date `organisation_start_date`](#organisation-start-date) | `null` | `object` | | [Organisation End Date `organisation_end_date`](#organisation-end-date) | `null` | `object` | | [Organisation Last Update Date `organisation_last_update_date`](#organisation-last-update-date) | `null` | `object` | | [Organisation Entry Date `organisation_entry_date`](#organisation-entry-date) | `null` | `object` | | [LPI Key `lpi_key`](#lpi-key) | 6820L000054880 | `string` | | [LPI Language Code `lpi_language`](#lpi-language-code) | CYM | `string` | | [LPI Logical Status Code `lpi_logical_status`](#lpi-logical-status-code) | `1` | `number` | | [LPI Start Date `lpi_start_date`](#lpi-start-date) | 2007-10-24T00:00:00.000Z | `string` | | [LPI End Date `lpi_end_date`](#lpi-end-date) | `null` | `object` | | [LPI Last Update Date `lpi_last_update_date`](#lpi-last-update-date) | 2025-09-26T00:00:00.000Z | `string` | | [LPI Entry Date `lpi_entry_date`](#lpi-entry-date) | 2007-09-04T00:00:00.000Z | `string` | | [SAO Start Number `sao_start_number`](#sao-start-number) | `null` | `object` | | [SAO Start Suffix `sao_start_suffix`](#sao-start-suffix) | `null` | `object` | | [SAO End Number `sao_end_number`](#sao-end-number) | `null` | `object` | | [SAO End Suffix `sao_end_suffix`](#sao-end-suffix) | `null` | `object` | | [SAO Text `sao_text`](#sao-text) | `null` | `object` | | [PAO Start Number `pao_start_number`](#pao-start-number) | `1` | `number` | | [PAO Start Suffix `pao_start_suffix`](#pao-start-suffix) | `null` | `object` | | [PAO End Number `pao_end_number`](#pao-end-number) | `null` | `object` | | [PAO End Suffix `pao_end_suffix`](#pao-end-suffix) | `null` | `object` | | [PAO Text `pao_text`](#pao-text) | HEOL Y CASTELL | `string` | | [Unique Street Reference Number `usrn`](#unique-street-reference-number) | 47114724 | `string` | | [USRN Match Indicator Code `usrn_match_indicator`](#usrn-match-indicator-code) | 1 | `string` | | [Area Name `area_name`](#area-name) | `null` | `object` | | [Level `level`](#level) | `null` | `object` | | [Official Flag Code `official_flag`](#official-flag-code) | Y | `string` | | [Street Record Type Code `street_record_type`](#street-record-type-code) | `1` | `number` | | [SWA Org Ref (Naming) `swa_org_ref_naming`](#swa-org-ref-naming) | `6820` | `number` | | [Street State Code `street_state`](#street-state-code) | 2 | `string` | | [Street State Date `street_state_date`](#street-state-date) | 1990-01-01T00:00:00.000Z | `string` | | [Street Surface Code `street_surface`](#street-surface-code) | 1 | `string` | | [Street Classification Code `street_classification`](#street-classification-code) | `null` | `object` | | [Street Start Date `street_start_date`](#street-start-date) | 2007-10-24T00:00:00.000Z | `string` | | [Street Last Update Date `street_last_update_date`](#street-last-update-date) | 2022-01-14T00:00:00.000Z | `string` | | [Street Record Entry Date `street_record_entry_date`](#street-record-entry-date) | 1998-07-14T00:00:00.000Z | `string` | | [Street Start Eastings `street_start_x`](#street-start-eastings) | `257968` | `number` | | [Street Start Northings `street_start_y`](#street-start-northings) | `281400` | `number` | | [Street Start Latitude `street_start_lat`](#street-start-latitude) | `52.4121241` | `number` | | [Street Start Longitude `street_start_long`](#street-start-longitude) | `-4.0896363` | `number` | | [Street End Eastings `street_end_x`](#street-end-eastings) | `258266` | `number` | | [Street End Northings `street_end_y`](#street-end-northings) | `281393` | `number` | | [Street End Latitude `street_end_lat`](#street-end-latitude) | `52.4121386` | `number` | | [Street End Longitude `street_end_long`](#street-end-longitude) | `-4.0852551` | `number` | | [Street Tolerance `street_tolerance`](#street-tolerance) | `10` | `number` | | [Street Description `street_description`](#street-description) | SOUTH ROAD | `string` | | [Street Locality `street_locality`](#street-locality) | `null` | `object` | | [Street Town `street_town`](#street-town) | ABERYSTWYTH | `string` | | [Administrative Area `adminstrative_area`](#administrative-area) | CEREDIGION | `string` | | [Street Descriptor Language Code `sd_language`](#street-descriptor-language-code) | ENG | `string` | | [Street Descriptor Start Date `sd_start_date`](#street-descriptor-start-date) | 2007-10-24T00:00:00.000Z | `string` | | [Street Descriptor End Date `sd_end_date`](#street-descriptor-end-date) | `null` | `object` | | [Street Descriptor Last Update Date `sd_last_update_date`](#street-descriptor-last-update-date) | 2016-02-06T00:00:00.000Z | `string` | | [Street Descriptor Entry Date `sd_entry_date`](#street-descriptor-entry-date) | 1998-07-14T00:00:00.000Z | `string` | | [TOID (Topography) `toid`](#toid-topography) | osgb1000020592167 | `string` | | [TOID (Address Layer) `toid_address`](#toid-address-layer) | osgb1000002175099422 | `string` | | [TOID (Highways) `toid_highways`](#toid-highways) | osgb5000005181786114 | `string` | | [Council Tax Reference `council_tax_ref`](#council-tax-reference) | `null` | `object` | | [Non-Domestic Rates Reference `ndr_ref`](#non-domestic-rates-reference) | `null` | `object` | | [ONS Ward Code `ons_ward_code`](#ons-ward-code) | W05001302 | `string` | | [ONS Parish Code `ons_parish_code`](#ons-parish-code) | W04000359 | `string` | | [Record ID `id`](#record-id) | abp\_49020496 | `string` | | [Dataset `dataset`](#dataset) | abp | `string` | | [Country ISO Code `country_iso`](#country-iso-code) | GBR | `string` | | [Suggestion Line `suggestion_line`](#suggestion-line) | 1 Castle Terrace South Road, Aberystwyth, SY23 | `string` | ```json { "uprn": "49020496", "parent_uprn": "49020495", "logical_status": 1, "blpu_state": "2", "blpu_state_date": "2011-10-06T00:00:00.000Z", "country": "W", "latitude": 52.4121999, "longitude": -4.0883772, "x_coordinate": 258053.87, "y_coordinate": 281405.95, "rpc": 2, "local_custodian_code": 6820, "addressbase_postal": "D", "postcode_locator": "SY23 1JT", "multi_occ_count": 4, "blpu_start_date": "2007-10-24T00:00:00.000Z", "blpu_end_date": null, "blpu_last_update_date": "2025-10-13T00:00:00.000Z", "blpu_entry_date": "2006-11-24T00:00:00.000Z", "udprn": "24255522", "organisation_name": null, "legal_name": null, "department_name": null, "sub_building_name": null, "building_name": null, "building_number": 1, "dependent_thoroughfare": "Castle Terrace", "thoroughfare": "South Road", "double_dependent_locality": null, "dependent_locality": null, "post_town": "Aberystwyth", "postcode": "SY23 1JT", "postcode_type": "S", "delivery_point_suffix": "1A", "po_box_number": null, "welsh_dependent_thoroughfare": "HEOL Y CASTELL", "welsh_thoroughfare": "TAN Y CAE", "welsh_double_dependent_locality": null, "welsh_dependent_locality": null, "welsh_post_town": "ABERYSTWYTH", "dpa_process_date": "2016-01-18T00:00:00.000Z", "dpa_start_date": "2012-04-23T00:00:00.000Z", "dpa_end_date": null, "dpa_last_update_date": "2016-02-10T00:00:00.000Z", "dpa_entry_date": "2012-03-19T00:00:00.000Z", "classification_code": "RD04", "class_scheme": "AddressBase Premium Classification Scheme", "scheme_version": 1, "classification_start_date": "2007-10-24T00:00:00.000Z", "classification_end_date": null, "classification_last_update_date": "2018-09-23T00:00:00.000Z", "classification_entry_date": "2006-11-24T00:00:00.000Z", "organisation_start_date": null, "organisation_end_date": null, "organisation_last_update_date": null, "organisation_entry_date": null, "lpi_key": "6820L000054880", "lpi_language": "CYM", "lpi_logical_status": 1, "lpi_start_date": "2007-10-24T00:00:00.000Z", "lpi_end_date": null, "lpi_last_update_date": "2025-09-26T00:00:00.000Z", "lpi_entry_date": "2007-09-04T00:00:00.000Z", "sao_start_number": null, "sao_start_suffix": null, "sao_end_number": null, "sao_end_suffix": null, "sao_text": null, "pao_start_number": 1, "pao_start_suffix": null, "pao_end_number": null, "pao_end_suffix": null, "pao_text": "HEOL Y CASTELL", "usrn": "47114724", "usrn_match_indicator": "1", "area_name": null, "level": null, "official_flag": "Y", "street_record_type": 1, "swa_org_ref_naming": 6820, "street_state": "2", "street_state_date": "1990-01-01T00:00:00.000Z", "street_surface": "1", "street_classification": null, "street_start_date": "2007-10-24T00:00:00.000Z", "street_last_update_date": "2022-01-14T00:00:00.000Z", "street_record_entry_date": "1998-07-14T00:00:00.000Z", "street_start_x": 257968, "street_start_y": 281400, "street_start_lat": 52.4121241, "street_start_long": -4.0896363, "street_end_x": 258266, "street_end_y": 281393, "street_end_lat": 52.4121386, "street_end_long": -4.0852551, "street_tolerance": 10, "street_description": "SOUTH ROAD", "street_locality": null, "street_town": "ABERYSTWYTH", "adminstrative_area": "CEREDIGION", "sd_language": "ENG", "sd_start_date": "2007-10-24T00:00:00.000Z", "sd_end_date": null, "sd_last_update_date": "2016-02-06T00:00:00.000Z", "sd_entry_date": "1998-07-14T00:00:00.000Z", "toid": "osgb1000020592167", "toid_address": "osgb1000002175099422", "toid_highways": "osgb5000005181786114", "council_tax_ref": null, "ndr_ref": null, "ons_ward_code": "W05001302", "ons_parish_code": "W04000359", "id": "abp_49020496", "dataset": "abp", "country_iso": "GBR", "suggestion_line": "1 Castle Terrace South Road, Aberystwyth, SY23" } ``` Every field is documented below. ## Essential Elements Standard address elements returned alongside every AddressBase Premium record. * `dataset` string Dataset Indicates the provenance of an address Example: `abp` Enum: "abp" * `id` string Id Example: `abp_49020496` * `line_1` string Line 1 First address line. Often contains premise and thoroughfare information. For a commercial premise the first line is the full name of the registered organisation. Never empty. * `line_2` string Line 2 Second address line. Often contains thoroughfare and locality information. May be empty. * `line_3` string Line 3 Third address line. Takes the address elements left after `line_1` and `line_2` are filled; where the address needs more than three lines the remaining elements are joined into `line_3`, comma separated. May be empty. * `premise` string Premise A pre-computed string which sensibly combines building\_number, building\_name and sub\_building\_name. Those three fields hold raw dataset values and can be difficult to parse if you are unaware of how they work together, so we also provide this single, simple premise string. Ideal if you want to pull premise information and thoroughfare information separately instead of using our address lines data. * `building_number` string Building Number Number identifying the premise on a thoroughfare or dependant thoroughfare. May be empty. Example: `1` * `building_name` string Building Name Name of a residential or commercial premise. May be empty. Examples: * The Manor * 1-2 * A * 12A * K * Victoria House * `sub_building_name` string Sub Building Name Identifies a unit where a premise is split into flats, apartments or business units. Cannot be present without either building\_name or building\_number. E.g. Flat 1, A, 10B. May be empty. * `organisation_name` string Organisation Name Name of the business or organisation at this address. May be empty. * `thoroughfare` string Thoroughfare Also known as the street or road name. May be empty. Example: `South Road` * `dependant_locality` string Dependant Locality A locality that qualifies the thoroughfare. Used where the same thoroughfare name occurs more than once in a post town and no dependant thoroughfare distinguishes them. May be empty. * `post_town` string Post Town The town or city used to route mail to the address. For UK addresses this is the Royal Mail post town, which is a routing instruction rather than the nearest town geographically. Present on every address. Example: `Aberystwyth` * `postcode` string Postcode Correctly formatted postcode. Capitalised and spaced. Empty (`""`) where the address has no postcode. Example: `SY23 1JT` * `postcode_type` string Postcode Type Royal Mail postcode user type. UK addresses only. * `S` small user. The postcode identifies a group of delivery points. There are on average 19 delivery points per postcode, and never more than 100 * `L` large user. The postcode is assigned to a single address, either because of the volume of mail it receives or because a PO Box or Selectapost service is set up Empty (`""`) where not applicable. Example: `S` Enum: "S", "L", "" * `county` string County Whatever county data is available for the address. Normally the postal county. If that is not present it falls back to the administrative county, then to the traditional county. May be empty where none of the three is present. * `uprn` string Uprn UPRN stands for Unique Property Reference Number and is maintained by the Ordnance Survey (OS). Local governments in the UK have allocated a unique number for each land or property. Up to 12 digits in length. Multiple Residence premises currently share the same UPRN as the parent premise. May not be available for a small number of Great Britain addresses due to longer update cycles for Ordnance Survey's AddressBase datasets. Returns empty string "" in these instances, as it does for addresses outside the UK. Although UPRN takes an integer format, we encode and transmit this data as strings. As a 12 digit number, the UPRN can exceed the maximum safe integer `Number.MAX_SAFE_INTEGER` in most browsers causing this datapoint to be corrupted. Take special care when storing UPRN. As a 12 digit identifier, you will need 64 bits to encode every possible UPRN value. This means applications like Excel will corrupt cells containing UPRN values. Example: `49020496` * `udprn` integer | string Udprn UDPRN stands for 'Unique Delivery Point Reference Number'. Royal Mail assigns a unique UDPRN code for each premise on PAF. Simple, unique reference number for each Delivery Point. Unlikely to be reused when an address expires. Up to 8-digit numeric code. A new UDPRN is automatically assigned to each new Delivery Point added to PAF. Returns `0` on a UK dataset that carries no UDPRN for the address, and an empty string `""` on a non-UK address. Use `id` for an identifier present on every address. Example: `24255522` * `longitude` string Longitude Example: `-4.0883772` * `latitude` string Latitude Example: `52.4121999` ## Native AddressBase Premium Record The `native` object contains the complete property-level record from Ordnance Survey AddressBase Premium — the consolidated BLPU, DPA, LPI, classification, and street records for the address. * `uprn` string Unique Property Reference Number Unique Property Reference Number - a persistent identifier for a Basic Land and Property Unit (BLPU). Up to 12 digits. Primary key for the BLPU spine. Carried as a string to preserve precision (12-digit values can exceed Number.MAX\_SAFE\_INTEGER). Example: `49020496` * `parent_uprn` string Parent UPRN UPRN of the parent record where a parent-child relationship exists (flats sharing a building entrance, sub-units of a parent property). Example: `49020495` * `logical_status` integer Logical Status Code Logical lifecycle status of the BLPU. `1` Approved, `6` Provisional, `8` Historical. BLPU records do not take value `3` (alternative). Example: `1` * `blpu_state` string BLPU State Code Physical state of the BLPU. `1` Under construction, `2` In use, `3` Unoccupied / vacant / derelict, `4` No longer existing, `6` Planning permission granted. Example: `2` * `blpu_state_date` string BLPU State Date Date the BLPU achieved its current state. Format: `date-time` Example: `2011-10-06T00:00:00.000Z` * `country` string Country Code Country containing the BLPU, determined by intersection with OS Boundary-Line. `E` England, `W` Wales, `S` Scotland, `N` Northern Ireland, `L` Channel Islands, `M` Isle of Man, `J` not assigned to a country. Example: `W` * `latitude` number Latitude (ETRS89) Latitude coordinate in the ETRS89 coordinate reference system. Format: `double` Example: `52.4121999` * `longitude` number Longitude (ETRS89) Longitude coordinate in the ETRS89 coordinate reference system. Format: `double` Example: `-4.0883772` * `x_coordinate` number Eastings (OSGB36 British National Grid) X location in metres on the OSGB36 British National Grid (precision 8, scale 2). Format: `double` Example: `258053.87` * `y_coordinate` number Northings (OSGB36 British National Grid) Y location in metres on the OSGB36 British National Grid (precision 9, scale 2). Format: `double` Example: `281405.95` * `rpc` integer Representative Point Code Representative Point Code - reliability of the BLPU's coordinate, as assessed by the local authority custodian. `1` Central internal, `2` General internal, `3` Transitional, `4` Street location, `5` Postcode unit, `9` Low accuracy. Example: `2` * `local_custodian_code` integer Local Custodian Code 4-digit identifier of the Local Authority responsible for maintaining the record. Example: `6820` * `addressbase_postal` string AddressBase Postal Code Whether the address can receive mail per AddressBase rules. `D` linked to PAF, `N` not a postal address, `C` postal with a PAF-linked parent, `L` postal based on Local Authority information. Example: `D` * `postcode_locator` string Postcode Locator Royal Mail PAF postcode, locally assigned by the custodian, or spatially derived where no PAF match exists. Up to 8 characters. Example: `SY23 1JT` * `multi_occ_count` integer Multi-occupancy Count Count of child UPRNs for this record where parent-child relationships exist. Example: `4` * `blpu_start_date` string BLPU Start Date Date the address record was inserted into the database. Format: `date-time` Example: `2007-10-24T00:00:00.000Z` * `blpu_end_date` string BLPU End Date Date the address record was closed in the database. Format: `date-time` * `blpu_last_update_date` string BLPU Last Update Date Date of the most recent attribute change on the BLPU record. Format: `date-time` Example: `2025-10-13T00:00:00.000Z` * `blpu_entry_date` string BLPU Entry Date Date the record was inserted into the Local Authority database. Format: `date-time` Example: `2006-11-24T00:00:00.000Z` * `udprn` string Unique Delivery Point Reference Number Royal Mail's Unique Delivery Point Reference Number - primary key for the Delivery Point Address (DPA) record. Up to 8 digits. NULL for non-postal UPRNs. Example: `24255522` * `organisation_name` string Organisation Name Royal Mail-recognised organisation name from DPA, falling back to the AddressBase Organisation record's `organisation` when DPA is absent. Title-cased. * `legal_name` string Legal Name Registered legal name from the AddressBase Organisation record. * `department_name` string Department Name Subdivision of an organisation that receives mail at a distinct delivery point. Requires `organisation_name` to be present. Title-cased. * `sub_building_name` string Sub-building Name Property subdivision identifier (e.g. flat number). Requires `building_name` or `building_number`. Title-cased. Falls back to the LPI's `sao_text` when there is no delivery point. * `building_name` string Building Name Descriptive name applied to a single building or small group of buildings. Title-cased. Falls back to the LPI's SAO number/range plus `pao_text` when there is no delivery point. * `building_number` integer Building Number Numeric identifier for a single building or small group of buildings. Complex number formats (e.g. "12A") go in `building_name` or `sub_building_name`. Falls back to the LPI's `pao_start_number` when there is no delivery point and that number is a bare integer - a suffixed or ranged PAO number is folded onto `thoroughfare` instead. Example: `1` * `dependent_thoroughfare` string Dependent Thoroughfare Named thoroughfare within another named thoroughfare. Requires `thoroughfare` to be present. Title-cased. Example: `Castle Terrace` * `thoroughfare` string Thoroughfare Road, track or named access route with Royal Mail delivery points. Title-cased. Falls back to the LPI street's `street_description` (with a suffixed or ranged PAO number prefixed) when there is no delivery point. Example: `South Road` * `double_dependent_locality` string Double Dependent Locality Estate or area name used to distinguish similar thoroughfares within a dependent locality. Requires `dependent_locality`. Title-cased. * `dependent_locality` string Dependent Locality Subdivision of a post town to differentiate same-name thoroughfares. Title-cased. Falls back to the LPI street's `street_locality` when there is no delivery point. * `post_town` string Post Town Town or city of the Royal Mail sorting office serving this record. Capitalised. Falls back to the LPI street's `street_town` when there is no delivery point; NULL when neither is present. Example: `Aberystwyth` * `postcode` string Postcode Royal Mail postcode from DPA, falling back to BLPU's `postcode_locator` when no Royal Mail delivery point exists. Uppercased, with single space between outward and inward portions. Example: `SY23 1JT` * `postcode_type` string Postcode Type Code Royal Mail postal-user category. `S` Small user (e.g. a residential property), `L` Large user (e.g. a large commercial company). Example: `S` * `delivery_point_suffix` string Delivery Point Suffix Two-character code uniquely identifying an individual delivery point within a postcode (Royal Mail DPS). Example: `1A` * `po_box_number` string PO Box Number Post Office Box number. * `welsh_dependent_thoroughfare` string Welsh Dependent Thoroughfare Welsh translation of `dependent_thoroughfare`. Requires `welsh_thoroughfare`. Example: `HEOL Y CASTELL` * `welsh_thoroughfare` string Welsh Thoroughfare Welsh translation of `thoroughfare`. Example: `TAN Y CAE` * `welsh_double_dependent_locality` string Welsh Double Dependent Locality Welsh translation of `double_dependent_locality`. Requires `welsh_dependent_locality`. * `welsh_dependent_locality` string Welsh Dependent Locality Welsh translation of `dependent_locality`. * `welsh_post_town` string Welsh Post Town Welsh translation of `post_town`. Example: `ABERYSTWYTH` * `dpa_process_date` string DPA Process Date Date the PAF record was processed into the database. Format: `date-time` Example: `2016-01-18T00:00:00.000Z` * `dpa_start_date` string DPA Start Date Date the address record was matched to the Delivery Point Address. Format: `date-time` Example: `2012-04-23T00:00:00.000Z` * `dpa_end_date` string DPA End Date Date the PAF record no longer existed in the database. Format: `date-time` * `dpa_last_update_date` string DPA Last Update Date Date any attribute on the DPA record was last changed. Format: `date-time` Example: `2016-02-10T00:00:00.000Z` * `dpa_entry_date` string DPA Entry Date Date the PAF record was first loaded by GeoPlace. Format: `date-time` Example: `2012-03-19T00:00:00.000Z` * `classification_code` string Classification Code Current AddressBase classification code (e.g. `RD` residential, `CR` commercial retail). Top-level categories: `R` Residential, `C` Commercial, `L` Land, `M` Military, `O` Other, `P` Parent shell, `U` Unclassified, `X` Dual use, `Z` Object of interest. NULL when no current classification row exists for the UPRN. Example: `RD04` * `class_scheme` string Classification Scheme Name of the classification scheme applied to this record. Example: `AddressBase Premium Classification Scheme` * `scheme_version` number Classification Scheme Version Version number of the classification scheme in use (e.g. `1.0`). Example: `1` * `classification_start_date` string Classification Start Date Date the classification record was first loaded into the database. Format: `date-time` Example: `2007-10-24T00:00:00.000Z` * `classification_end_date` string Classification End Date Date the classification record ceased to exist. Format: `date-time` * `classification_last_update_date` string Classification Last Update Date Date of the most recent attribute change on the classification record. Format: `date-time` Example: `2018-09-23T00:00:00.000Z` * `classification_entry_date` string Classification Entry Date Date the associated address record was inserted into the Local Authority database. Format: `date-time` Example: `2006-11-24T00:00:00.000Z` * `organisation_start_date` string Organisation Start Date Date the organisation record was initially loaded into the database. Format: `date-time` * `organisation_end_date` string Organisation End Date Date the organisation record ceased to exist. Format: `date-time` * `organisation_last_update_date` string Organisation Last Update Date Date of the most recent attribute change on the organisation record. Format: `date-time` * `organisation_entry_date` string Organisation Entry Date Date the UPRN was entered into the Local Authority database. Format: `date-time` * `lpi_key` string LPI Key Unique identifier and primary key for the LPI record. Example: `6820L000054880` * `lpi_language` string LPI Language Code Language used for this LPI record. `ENG` English, `CYM` Welsh, `GAE` Gaelic (Scottish), `BIL` Bilingual. Example: `CYM` * `lpi_logical_status` integer LPI Logical Status Code Logical status of the LPI record. `1` Approved, `3` Alternative, `6` Provisional, `8` Historical. Example: `1` * `lpi_start_date` string LPI Start Date Date the LPI was first loaded into the database. Format: `date-time` Example: `2007-10-24T00:00:00.000Z` * `lpi_end_date` string LPI End Date Date the LPI record ceased to exist. Format: `date-time` * `lpi_last_update_date` string LPI Last Update Date Date of the most recent attribute change on the LPI record. Format: `date-time` Example: `2025-09-26T00:00:00.000Z` * `lpi_entry_date` string LPI Entry Date Date the LPI record was inserted into the Local Authority database. Format: `date-time` Example: `2007-09-04T00:00:00.000Z` * `sao_start_number` integer SAO Start Number Number of the Secondary Addressable Object, or range start. Requires `pao_start_number` or `pao_text` to be present. * `sao_start_suffix` string SAO Start Suffix Suffix appended to `sao_start_number`. Requires `sao_start_number`. * `sao_end_number` integer SAO End Number End number of the SAO range. Requires `sao_start_number`. * `sao_end_suffix` string SAO End Suffix Suffix appended to `sao_end_number`. Requires `sao_end_number`. * `sao_text` string SAO Text Building name or description for the Secondary Addressable Object (e.g. "FLAT 1", "UNIT B"). Requires `pao_start_number` or `pao_text`. * `pao_start_number` integer PAO Start Number Number of the Primary Addressable Object, or range start. Mandatory if `pao_text` is absent. Example: `1` * `pao_start_suffix` string PAO Start Suffix Suffix appended to `pao_start_number`. Requires `pao_start_number`. * `pao_end_number` integer PAO End Number End number of the PAO range. Requires `pao_start_number`. * `pao_end_suffix` string PAO End Suffix Suffix appended to `pao_end_number`. Requires `pao_end_number`. * `pao_text` string PAO Text Building name or description for the Primary Addressable Object. Mandatory if `pao_start_number` is absent. Example: `HEOL Y CASTELL` * `usrn` string Unique Street Reference Number Unique Street Reference Number linking this LPI to its Street record. Up to 8 digits. Example: `47114724` * `usrn_match_indicator` string USRN Match Indicator Code Confidence of the LPI to Street linkage. `1` Matched manually to the nearest accessible Street, `2` Matched spatially to the nearest USRN. Example: `1` * `area_name` string Area Name Third-level geographic area name such as island or property group. * `level` string Level Vertical position of the property (e.g. "GROUND FLOOR"). * `official_flag` string Official Flag Code Whether the LPI corresponds to an entry in the official Street Name and Numbering register. `Y` Official address, `N` Unofficial address. Example: `Y` * `street_record_type` integer Street Record Type Code Description of the street record type. `1` Official designated Street Name, `2` Street Description, `3` Numbered Street, `4` Unofficial Street Description, `9` Description used for LLPG Access. Example: `1` * `swa_org_ref_naming` integer SWA Org Ref (Naming) Code identifying the Street Naming and Numbering Authority or Local Highway Authority (DfT-allocated). Example: `6820` * `street_state` string Street State Code Current state of the street. `1` Under construction, `2` Open, `4` Permanently closed. Example: `2` * `street_state_date` string Street State Date Date when the street achieved its current state. Format: `date-time` Example: `1990-01-01T00:00:00.000Z` * `street_surface` string Street Surface Code Surface finish of the street. `1` Metalled, `2` Unmetalled, `3` Mixed. Example: `1` * `street_classification` string Street Classification Code Primary classification of the street record. `4` Pedestrian way or footpath, `6` Cycletrack or cycleway, `8` All vehicles, `9` Restricted byway, `10` Bridleway. * `street_start_date` string Street Start Date Date this street record or version was inserted into the database. Format: `date-time` Example: `2007-10-24T00:00:00.000Z` * `street_last_update_date` string Street Last Update Date Date when any attribute of the street record was last changed. Format: `date-time` Example: `2022-01-14T00:00:00.000Z` * `street_record_entry_date` string Street Record Entry Date Date the street record was entered into the Local Authority database. Format: `date-time` Example: `1998-07-14T00:00:00.000Z` * `street_start_x` number Street Start Eastings X coordinate (BNG) for the street start point. Format: `double` Example: `257968` * `street_start_y` number Street Start Northings Y coordinate (BNG) for the street start point. Format: `double` Example: `281400` * `street_start_lat` number Street Start Latitude Latitude (ETRS89) for the street start point. Format: `double` Example: `52.4121241` * `street_start_long` number Street Start Longitude Longitude (ETRS89) for the street start point. Format: `double` Example: `-4.0896363` * `street_end_x` number Street End Eastings X coordinate (BNG) for the street end point. Format: `double` Example: `258266` * `street_end_y` number Street End Northings Y coordinate (BNG) for the street end point. Format: `double` Example: `281393` * `street_end_lat` number Street End Latitude Latitude (ETRS89) for the street end point. Format: `double` Example: `52.4121386` * `street_end_long` number Street End Longitude Longitude (ETRS89) for the street end point. Format: `double` Example: `-4.0852551` * `street_tolerance` integer Street Tolerance Accuracy of street-coordinate data capture, in metres. Example: `10` * `street_description` string Street Description Street name, description or street number. Example: `SOUTH ROAD` * `street_locality` string Street Locality Geographical area within a town. * `street_town` string Street Town Name of the town. Required for Street Record Types `1` and `2`; optional for types `3`, `4` and `9`. Example: `ABERYSTWYTH` * `adminstrative_area` string Administrative Area Local Highway Authority name (administrative area / county / unitary authority). Field name spelling preserved verbatim from OS (`ADMINSTRATIVE_AREA`). Example: `CEREDIGION` * `sd_language` string Street Descriptor Language Code Language of the street descriptor. `ENG` English, `CYM` Welsh, `GAE` Gaelic (Scottish), `BIL` Bilingual. Example: `ENG` * `sd_start_date` string Street Descriptor Start Date Date the street descriptor record was first created in the database. Format: `date-time` Example: `2007-10-24T00:00:00.000Z` * `sd_end_date` string Street Descriptor End Date Date the street descriptor record ceased to exist. Format: `date-time` * `sd_last_update_date` string Street Descriptor Last Update Date Date of the most recent attribute change on the street descriptor record. Format: `date-time` Example: `2016-02-06T00:00:00.000Z` * `sd_entry_date` string Street Descriptor Entry Date Date the street descriptor record was entered into the Local Authority database. Format: `date-time` Example: `1998-07-14T00:00:00.000Z` * `toid` string TOID (Topography) OS MasterMap Topography Layer TOID (cross-reference source `7666MT`) linked to the UPRN. Example: `osgb1000020592167` * `toid_address` string TOID (Address Layer) OS MasterMap Address Layer 2 TOID (cross-reference source `7666MA`) linked to the UPRN. Example: `osgb1000002175099422` * `toid_highways` string TOID (Highways) OS MasterMap Highways TOID (cross-reference source `7666MI`) linked to the UPRN. Example: `osgb5000005181786114` * `council_tax_ref` string Council Tax Reference Centrally created Valuation Office Agency council tax reference (cross-reference source `7666VC`) linked to the UPRN. * `ndr_ref` string Non-Domestic Rates Reference Centrally created Valuation Office Agency non-domestic rates reference (cross-reference source `7666VN`) linked to the UPRN. * `ons_ward_code` string ONS Ward Code Office for National Statistics ward code (cross-reference source `7666OW`) linked to the UPRN. Example: `W05001302` * `ons_parish_code` string ONS Parish Code Office for National Statistics parish code (cross-reference source `7666OP`) linked to the UPRN. Example: `W04000359`