Download raw Parquet files or access them directly with DuckDB.
Every GB UPRN with coordinates, authoritative postcode, linked identifiers and the full ONS geography set. Partitioned by region so you can pull one area or all of them.
| EE East of England | 133 MB | Parquet |
| EM East Midlands | 102 MB | Parquet |
| LN London | 119 MB | Parquet |
| NE North East | 53 MB | Parquet |
| NW North West | 141 MB | Parquet |
| SC Scotland | 115 MB | Parquet |
| SE South East | 182 MB | Parquet |
| SW South West | 132 MB | Parquet |
| WA Wales | 71 MB | Parquet |
| WM West Midlands | 112 MB | Parquet |
| YH Yorkshire and The Humber | 119 MB | Parquet |
| XX Outside ONSUD regions | 4 MB | Parquet |
USRN streets with derived names, classification, local authority, centroid and bounding box - an open USRN-to-street-name lookup that exists nowhere else.
| Streets | 82 MB | Parquet |
UPRN counts and centroids rolled up by postcode, LSOA and ward - small files for choropleths and density analysis.
| By postcode | 29 MB | Parquet |
| By LSOA | 1 MB | Parquet |
| By ward | 0 MB | Parquet |
Every file is a plain HTTP range read - point DuckDB straight at the URL, no download step:
INSTALL httpfs; LOAD httpfs; SELECT * FROM read_parquet('https://data.uprns.io/uprnsio/latest/aggregate/by_postcode.parquet') LIMIT 10;
Prefer a browser? The explorer runs SQL over these shards with DuckDB-WASM - nothing leaves your machine.
Open Government Licence v3.0 (OGL-3.0). You may use and redistribute with attribution:
Contains OS data (c) Crown copyright and database right; Royal Mail data (c) Royal Mail copyright and database right; National Statistics data (c) Crown copyright and database right.