Raw Data Extracts Flexible raw data options
What are they?
Simply a file of the data you require. Take Full PAF®, Multiple Residence and GeoData for the whole of the UK, or just an extract to suit your needs. NSPD data is also available. Bespoke supply lets you handle and manipulate the data and build your own application. It is available in a range of formats to suit your needs. We can also customise your extract - for example a radius-based extract or a random sample of addresses for market research purposes.
Who uses them?
A wide range of businesses and industry types developing bespoke applications, data analysts, direct marketing and utility companies.
Why should I use raw data?
The data is tailored to your requirements so you only get the data you want.
What data is available?
- Royal Mail's Postcode Address File (PAF®) - 1.7 million Postcodes and 28 million Delivery Points including UDPRN
- Royal Mail's Multiple Residence address file - over 400,000 additional addresses at Delivery Point, identifying where a single property shares the same letter box for multiple residences
- Royal Mail's Alias Data - Former Postal, Administrative and Traditional Counties
- GeoData - 100m and 1m Grid References, NHS Health Authority codes and names, Local Authority information, OSGB36 and ETRS89 Longitudes and Latitudes
- Current County from Allies®
- National Statistics Postcode Database from ONS - Primary Care Trust codes and names
- Up to monthly data updates
- Data aggregation - average Grid Reference values for Postcode Sectors and Districts
- Channel Islands and Isle of Man Grid Reference data calculated by Allies®
- Filtering of data to allow searching on building names, dependent streets and other fields which are normally aggregated with other data in a field
- Changes only data files
How do I pay for it?
Pricing is bespoke depending on the data you need. A range of licences for unlimited use are available for single or multiple users. Typical prices start from £120 + VAT. Please contact us to get your bespoke quote for your specific requirements.
More Details
Which data formats are available?
CSV, fixed text format or as required. For more information, please ask us.
Which PAF® and GeoData fields are available?
Please click below to see a detailed list of all of the PAF® and GeoData fields available, their maximum field length, the field names and the field codes.
WCD - Local/Unitary Authority Ward Code
This code is structured as follows - 33UHHX
- 33 - For two-tier Local Authorities this is the county portion. Unitary Authorities do not have a county code.
- UH - This is the code for the Local/Unitary Authority. In England, Wales and Scotland including the Scottish Islands, this is a two-character code. In Northern Ireland, the first character is a letter from A - Z with the second character represented by a space.
- HX - code for the Ward within the Local/Unitary Authority.
PCG - Primary Care Trust Code (formerly the Primary Care Group Code)
This field now contains the Primary Care Trust (PCT) code for England and Local Health Board (LHB) code for Wales. Primary Care Trust information is only available in England and Wales. Where Primary Care Trust information is unavailable (Scotland and Northern Ireland) a default PCT code may be allocated of 'X98'.
What fields are available in the Multiple Residence file?
Multiple Residence addresses can be extracted with PAF® and the premise names and numbers will appear within the normal ORG, NUM, and BNA fields for example. The additional fields supplied are Multi-Occupied Count (MOCC) maximum length 4, Unique Multiple Residence Reference Number (UMRRN) maximum length 8 and Data Origin (DTO - MR or PAF®) maximum length 1.
Why should I have Multiple Residence data as well as PAF®?
MR data provides additional addresses for marketing purposes. It also identifies where 1 Delivery Point on PAF® contains multiple residences by displaying the number and detail of the individual residences. Every additional occupied address at Delivery Point level can be recognised individually, which is useful for delivery of goods or for utility companies. It covers 121 Postcode areas, there are no records for the Channel Isles and the Isle of Man (JE, IM and GY).
Can I amalgamate PAF® with MR data?
Yes, we can extract MR data amalgamated with PAF®, as a separate file, or on its own.
Why do I get a "File not loaded completely" message when I open my data extract in Excel?
Microsoft Excel has a built in limitation for the number of records it can read in a worksheet. This was 65,536 rows in Excel 2000 and 1,048,576 rows in Excel 2007. If you purchase a PAF® Data extract at one record per premise for an entire Postcode Area, or full U.K., it is likely that you will exceed this limit. Data at one record per Postcode may fit into an Excel worksheet for a single Postcode area.
To resolve this, you can either:
- Use a database package such as Microsoft Access.
- Request the data from us at one record per Postcode or in split files.
