c0mm0.com — the continuously verified register of European data

Register record·API·GB·GOVERNMENTUNVERIFIED · last tried 52d ago
N

National Statistics Postcode Lookup Camden

query.json

APIDiscovered1/7blocked by verifiedPreviewSubscribe🇬🇧United Kingdom

This dataset provides the National Statistics Postcode Lookup (NSPL) filtered for the London Borough of Camden. It links current UK postcodes to a range of current statutory administrative, electoral, health and other statistical geographies, using best-fit allocation from 2021 Census output areas. The dataset supports the production of area-based statistics from postcoded data. It is produced by ONS Geography, the branch of the UK's Office for National Statistics (ONS) that provides geographic support to ONS and geographic services used by other public and private organisations.This dataset contains the National Statistics Postcode Lookup (NSPL) for the London Borough of Camden. The NSPL relates current postcodes to a range of current statutory administrative, electoral, health and other statistical geographies via ‘-fit’ allocation from the 2021 Census output areas. It supports the production of area based statistics from postcoded data. The NSPL is produced by ONS Geography, which provides geographic support to the Office for National Statistics (ONS) and geographic services used by other organisations.

geospatial
⬇ Download distributionRun verified request

Trust score

How is this computed?
26
poor

Weighted across five axes. Tap a ring for what it measures.

Data schema (42 fields)

Click a field to see example values.

FieldTypeDescription
:idtextUnique system identifier for the record.Unique system identifier for the record.
:versiontextInternal version identifier for the record.Internal version identifier for the record.
:created_at:created atdatetimeTimestamp when the record was created in the system.Timestamp when the record was created in the system.
:updated_at:updated atdatetimeTimestamp when the record was last updated in the system.Timestamp when the record was last updated in the system.
postcode_1Postcode 1textPostcode with no spaces.Postcode with no spaces.
postcode_2Postcode 2textPostcode fixed to an 8-character format with padding spaces.Postcode fixed to an 8-character format with padding spaces.
postcode_3Postcode 3textPostcode with a single space before the last three characters.Postcode with a single space before the last three characters.
date_introducedDate introducedtextDate (YYYYMM) the postcode was first introduced.Date (YYYYMM) the postcode was first introduced.
user_typeUser typetextCode indicating whether the postcode is small or large user type.Code indicating whether the postcode is small or large user type.
eastingtextNational grid easting coordinate of the postcode.National grid easting coordinate of the postcode.
northingtextNational grid northing coordinate of the postcode.National grid northing coordinate of the postcode.
positional_qualityPositional qualitytextCode indicating the positional accuracy of the postcode's grid reference.Code indicating the positional accuracy of the postcode's grid reference.
county_codeCounty codetextCode for the county containing the postcode.Code for the county containing the postcode.
county_nameCounty nametextName of the county containing the postcode.Name of the county containing the postcode.
local_authority_codeLocal authority codetextCode for the local authority district containing the postcode.Code for the local authority district containing the postcode.
local_authority_nameLocal authority nametextName of the local authority district containing the postcode.Name of the local authority district containing the postcode.
ward_codeWard codetextCode for the electoral ward containing the postcode.Code for the electoral ward containing the postcode.
ward_nameWard nametextName of the electoral ward containing the postcode.Name of the electoral ward containing the postcode.
country_codeCountry codetextCode for the country containing the postcode.Code for the country containing the postcode.
country_nameCountry nametextName of the country containing the postcode.Name of the country containing the postcode.
region_codeRegion codetextCode for the region containing the postcode.Code for the region containing the postcode.
region_nameRegion nametextName of the region containing the postcode.Name of the region containing the postcode.
parliamentary_constituency_codeParliamentary constituency codetextCode for the parliamentary constituency containing the postcode.Code for the parliamentary constituency containing the postcode.
parliamentary_constituency_nameParliamentary constituency nametextName of the parliamentary constituency containing the postcode.Name of the parliamentary constituency containing the postcode.
european_electoral_region_codeEuropean electoral region codetextCode for the former European electoral region, now obsolete.Code for the former European electoral region, now obsolete.
european_electoral_region_nameEuropean electoral region nametextName of the former European electoral region, now obsolete.Name of the former European electoral region, now obsolete.
primary_care_trust_codePrimary care trust codetextCode for the former primary care trust, now obsolete.Code for the former primary care trust, now obsolete.
primary_care_trust_namePrimary care trust nametextName of the former primary care trust, now obsolete.Name of the former primary care trust, now obsolete.
lsoa_codeLsoa codetextCode for the Lower Layer Super Output Area containing the postcode.Code for the Lower Layer Super Output Area containing the postcode.
lower_super_output_areaLower super output areatextName of the Lower Layer Super Output Area containing the postcode.Name of the Lower Layer Super Output Area containing the postcode.
msoa_codeMsoa codetextCode for the Middle Layer Super Output Area containing the postcode.Code for the Middle Layer Super Output Area containing the postcode.
middle_super_output_areaMiddle super output areatextName of the Middle Layer Super Output Area containing the postcode.Name of the Middle Layer Super Output Area containing the postcode.
output_area_classification_codeOutput area classification codetextCode for the output area's statistical classification group.Code for the output area's statistical classification group.
output_area_classification_nameOutput area classification nametextName of the output area's statistical classification group.Name of the output area's statistical classification group.
longitudeLongitudetextLongitude coordinate of the postcode location.Longitude coordinate of the postcode location.
latitudeLatitudetextLatitude coordinate of the postcode location.Latitude coordinate of the postcode location.
spatial_accuracySpatial accuracytextDescription of the level of spatial precision for the location.Description of the level of spatial precision for the location.
last_uploadedLast uploadeddatetimeDate and time the record was last uploaded to the dataset.Date and time the record was last uploaded to the dataset.
locationobjectGeographic point location of the postcode with coordinates.Geographic point location of the postcode with coordinates.
socrata_idSocrata idtextIdentifier assigned by the Socrata publishing platform.Identifier assigned by the Socrata publishing platform.
:@computed_region_6i9a_26nj:@computed region 6i9a 26njtextComputed region identifier linking the record to a geographic boundary layer.Computed region identifier linking the record to a geographic boundary layer.
:@computed_region_hxwp_gyfc:@computed region hxwp gyfctextComputed region identifier linking the record to a geographic boundary layer.Computed region identifier linking the record to a geographic boundary layer.

Schema inferred from the distribution file's first records 1 hour ago. Column types are sampled estimates, not source-declared.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

=

Sample data (5 records)

Record 1:id: row-r57e.zg63-bk84 · easting: 529433
{
  ":id": "row-r57e.zg63-bk84",
  "easting": "529433",
  ":version": "rv-2gz9.zhm8-kg7a",
  "latitude": "51.530786",
  "location": {
    "type": "Point",
    "coordinates": [
      -0.135405,
      51.530786
    ]
  },
  "northing": "182967",
  "longitude": "-0.135405",
  "lsoa_code": "E01035710",
  "msoa_code": "E02000188",
  "user_type": "1",
  "ward_code": "E05013668",
  "ward_name": "Regent's Park",
  "postcode_1": "NW1W8AU",
  "postcode_2": "NW1W 8AU",
  "postcode_3": "NW1W 8AU",
  "socrata_id": "1812528",
  ":created_at": "2026-09-08T09:42:52.405Z",
  ":updated_at": "2026-09-08T09:42:55.653Z",
  "county_code": "E13000001",
  "county_name": "Inner London",
  "region_code": "E12000007",
  "region_name": "London",
  "country_code": "E92000001",
  "country_name": "England",
  "last_uploaded": "2026-09-08T10:27:26.000",
  "date_introduced": "201203",
  "spatial_accuracy": "Postcode Level",
  "positional_quality": "1",
  "local_authority_code": "E09000007",
  "local_authority_name": "Camden",
  "lower_super_output_area": "Camden 023F",
  "primary_care_trust_code": "obsolete",
  "primary_care_trust_name": "obsolete",
  "middle_super_output_area": "Camden 023",
  ":@computed_region_6i9a_26nj": "104",
  ":@computed_region_hxwp_gyfc": "15",
  "european_electoral_region_code": "obsolete",
  "european_electoral_region_name": "obsolete",
  "output_area_classification_code": "3b1",
  "output_area_classification_name": "currently unavailable",
  "parliamentary_constituency_code": "E14001290",
  "parliamentary_constituency_name": "Holborn and St Pancras"
}
Record 2:id: row-mf7w-3bu7.qws2 · easting: 529619
{
  ":id": "row-mf7w-3bu7.qws2",
  "easting": "529619",
  ":version": "rv-777h~m39z~7yhi",
  "latitude": "51.529378",
  "location": {
    "type": "Point",
    "coordinates": [
      -0.13278,
      51.529378
    ]
  },
  "northing": "182815",
  "longitude": "-0.132780",
  "lsoa_code": "E01000956",
  "msoa_code": "E02000187",
  "user_type": "0",
  "ward_code": "E05013669",
  "ward_name": "St Pancras & Somers Town",
  "postcode_1": "NW1 1DA",
  "postcode_2": "NW1  1DA",
  "postcode_3": "NW1 1DA",
  "socrata_id": "1811010",
  ":created_at": "2026-09-08T09:42:52.405Z",
  ":updated_at": "2026-09-08T09:42:55.653Z",
  "county_code": "E13000001",
  "county_name": "Inner London",
  "region_code": "E12000007",
  "region_name": "London",
  "country_code": "E92000001",
  "country_name": "England",
  "last_uploaded": "2026-09-08T10:27:25.000",
  "date_introduced": "198001",
  "spatial_accuracy": "Postcode Level",
  "positional_quality": "1",
  "local_authority_code": "E09000007",
  "local_authority_name": "Camden",
  "lower_super_output_area": "Camden 022E",
  "primary_care_trust_code": "obsolete",
  "primary_care_trust_name": "obsolete",
  "middle_super_output_area": "Camden 022",
  ":@computed_region_6i9a_26nj": "115",
  ":@computed_region_hxwp_gyfc": "16",
  "european_electoral_region_code": "obsolete",
  "european_electoral_region_name": "obsolete",
  "output_area_classification_code": "3b1",
  "output_area_classification_name": "currently unavailable",
  "parliamentary_constituency_code": "E14001290",
  "parliamentary_constituency_name": "Holborn and St Pancras"
}
Record 3:id: row-t5hk-rcyu-k5fq · easting: 529408
{
  ":id": "row-t5hk-rcyu-k5fq",
  "easting": "529408",
  ":version": "rv-e6mb_fw9k.n6cr",
  "latitude": "51.525885",
  "location": {
    "type": "Point",
    "coordinates": [
      -0.135965,
      51.525885
    ]
  },
  "northing": "182421",
  "longitude": "-0.135965",
  "lsoa_code": "E01035710",
  "msoa_code": "E02000188",
  "user_type": "0",
  "ward_code": "E05013668",
  "ward_name": "Regent's Park",
  "postcode_1": "NW1 2NG",
  "postcode_2": "NW1  2NG",
  "postcode_3": "NW1 2NG",
  "socrata_id": "1811257",
  ":created_at": "2026-09-08T09:42:52.405Z",
  ":updated_at": "2026-09-08T09:42:55.653Z",
  "county_code": "E13000001",
  "county_name": "Inner London",
  "region_code": "E12000007",
  "region_name": "London",
  "country_code": "E92000001",
  "country_name": "England",
  "last_uploaded": "2026-09-08T10:27:25.000",
  "date_introduced": "198001",
  "spatial_accuracy": "Postcode Level",
  "positional_quality": "1",
  "local_authority_code": "E09000007",
  "local_authority_name": "Camden",
  "lower_super_output_area": "Camden 023F",
  "primary_care_trust_code": "obsolete",
  "primary_care_trust_name": "obsolete",
  "middle_super_output_area": "Camden 023",
  ":@computed_region_6i9a_26nj": "104",
  ":@computed_region_hxwp_gyfc": "15",
  "european_electoral_region_code": "obsolete",
  "european_electoral_region_name": "obsolete",
  "output_area_classification_code": "3b1",
  "output_area_classification_name": "currently unavailable",
  "parliamentary_constituency_code": "E14001290",
  "parliamentary_constituency_name": "Holborn and St Pancras"
}
Record 4:id: row-2tnd_rmje_dxwq · easting: 531157
{
  ":id": "row-2tnd_rmje_dxwq",
  "easting": "531157",
  ":version": "rv-njyw-bjzu~md2x",
  "latitude": "51.521330",
  "location": {
    "type": "Point",
    "coordinates": [
      -0.11094,
      51.52133
    ]
  },
  "northing": "181959",
  "longitude": "-0.110940",
  "lsoa_code": "E01000917",
  "msoa_code": "E02000192",
  "user_type": "0",
  "ward_code": "E05013662",
  "ward_name": "Holborn & Covent Garden",
  "postcode_1": "EC1N7UT",
  "postcode_2": "EC1N 7UT",
  "postcode_3": "EC1N 7UT",
  "socrata_id": "1810434",
  ":created_at": "2026-09-08T09:42:52.405Z",
  ":updated_at": "2026-09-08T09:42:55.653Z",
  "county_code": "E13000001",
  "county_name": "Inner London",
  "region_code": "E12000007",
  "region_name": "London",
  "country_code": "E92000001",
  "country_name": "England",
  "last_uploaded": "2026-09-08T10:26:09.000",
  "date_introduced": "198001",
  "spatial_accuracy": "Postcode Level",
  "positional_quality": "1",
  "local_authority_code": "E09000007",
  "local_authority_name": "Camden",
  "lower_super_output_area": "Camden 027C",
  "primary_care_trust_code": "obsolete",
  "primary_care_trust_name": "obsolete",
  "middle_super_output_area": "Camden 027",
  ":@computed_region_6i9a_26nj": "76",
  ":@computed_region_hxwp_gyfc": "11",
  "european_electoral_region_code": "obsolete",
  "european_electoral_region_name": "obsolete",
  "output_area_classification_code": "3b2",
  "output_area_classification_name": "currently unavailable",
  "parliamentary_constituency_code": "E14001290",
  "parliamentary_constituency_name": "Holborn and St Pancras"
}
Record 5:id: row-ercv_rr6a_pdqv · easting: 525035
{
  ":id": "row-ercv_rr6a_pdqv",
  "easting": "525035",
  ":version": "rv-3gr5.m6pi~7tub",
  "latitude": "51.545482",
  "location": {
    "type": "Point",
    "coordinates": [
      -0.198233,
      51.545482
    ]
  },
  "northing": "184492",
  "longitude": "-0.198233",
  "lsoa_code": "E01000931",
  "msoa_code": "E02000178",
  "user_type": "0",
  "ward_code": "E05013665",
  "ward_name": "Kilburn",
  "postcode_1": "NW6 2JU",
  "postcode_2": "NW6  2JU",
  "postcode_3": "NW6 2JU",
  "socrata_id": "1815750",
  ":created_at": "2026-09-08T09:42:52.405Z",
  ":updated_at": "2026-09-08T09:42:55.653Z",
  "county_code": "E13000001",
  "county_name": "Inner London",
  "region_code": "E12000007",
  "region_name": "London",
  "country_code": "E92000001",
  "country_name": "England",
  "last_uploaded": "2026-09-08T10:27:27.000",
  "date_introduced": "198001",
  "spatial_accuracy": "Postcode Level",
  "positional_quality": "1",
  "local_authority_code": "E09000007",
  "local_authority_name": "Camden",
  "lower_super_output_area": "Camden 013C",
  "primary_care_trust_code": "obsolete",
  "primary_care_trust_name": "obsolete",
  "middle_super_output_area": "Camden 013",
  ":@computed_region_6i9a_26nj": "90",
  ":@computed_region_hxwp_gyfc": "13",
  "european_electoral_region_code": "obsolete",
  "european_electoral_region_name": "obsolete",
  "output_area_classification_code": "3b2",
  "output_area_classification_name": "currently unavailable",
  "parliamentary_constituency_code": "E14001265",
  "parliamentary_constituency_name": "Hampstead and Highgate"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Source URL is HTML, not a machine-readable API — possible mis-classification

Using the API

Configuration

Base URL
https://opendata.camden.gov.uk
Format
rest

Query examples

curl -sL 'https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD' -o data.json

Full json file download — the schema shown was inferred from the file's first records.

Machine-readable & source

JSONGitHub
National Statistics Postcode Lookup Camden — live verification badge

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.