uprns.io
Downloads

Bulk Parquet downloads

Download raw Parquet files or access them directly with DuckDB.

Buildv=202607Published2026-07-10

UPRNs41,546,482 rows

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- Parquet
EM East Midlands- Parquet
LN London- Parquet
NE North East- Parquet
NW North West- Parquet
SC Scotland- Parquet
SE South East- Parquet
SW South West- Parquet
WA Wales- Parquet
WM West Midlands- Parquet
YH Yorkshire and The Humber- Parquet
XX Outside ONSUD regions- Parquet

Streets1,765,708 rows

USRN street geometry with derived names, classification and local authority - an open USRN-to-street-name lookup that exists nowhere else.

Streets- Parquet

Aggregates1,772,503 rows

UPRN counts and centroids rolled up by postcode, LSOA and ward - small files for choropleths and density analysis.

By postcode- Parquet
By LSOA- Parquet
By ward- Parquet

Query it in place

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.

Licence

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.