{"id":"b98256f7-e0d7-4429-9532-270fbc4e8c8d","type":"API","name":"National Statistics Postcode Lookup Camden","slug":"national-statistics-postcode-lookup-camden-2","description":"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.","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":null,"docs_url":null,"repo_url":"https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD","status":"ACTIVE","verification_state":"VERIFIED","tags":["geospatial"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=opendata.camden.gov.uk","primary_source_url":"https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD","extraction_confidence":"0.28","created_at":"2026-07-31T13:42:50.964Z","updated_at":"2026-07-31T13:44:45.592Z","last_verified_at":"2026-07-31T13:44:12.121Z","deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'2021':44B,128B 'a':111B 'administr':32B 'administrative':116B 'alloc':41B 'allocation':125B 'and':119B,161B 'area':47B,53B,137B 'areas':131B 'base':54B 'based':138B 'borough':18B,102B 'by':147B,165B 'camden':5A,20B,89A,104B 'census':45B,129B 'contain':8B 'contains':92B 'current':24B,30B,108B,114B 'data':58B,142B 'dataset':7B,91B 'elector':33B 'electoral':117B 'fit':40B,124B 'for':99B,157B 'from':126B,140B 'geograph':68B,78B 'geographi':38B,65B 'geographic':152B,162B 'geographies':122B 'geography':149B 'geospati':84C 'health':34B,118B 'is':145B 'it':132B 'london':17B,101B 'lookup':4A,13B,88A,97B 'nation':1A,10B,74B 'national':85A,94B,158B 'nspl':14B,22B,60B,98B,106B,144B 'of':103B,113B,136B 'offic':72B 'office':156B 'on':64B,76B 'ons':148B,160B 'organis':83B 'organisations':167B 'other':120B,166B 'output':46B,130B 'postcod':3A,12B,25B,57B 'postcode':87A,96B 'postcoded':141B 'postcodes':109B 'produc':62B 'produced':146B 'product':51B 'production':135B 'provid':67B 'provides':151B 'rang':28B 'range':112B 'relat':23B 'relates':107B 'servic':79B 'services':163B 'statist':2A,11B,37B,55B,75B 'statistical':121B 'statistics':86A,95B,139B,159B 'statutori':31B 'statutory':115B 'support':49B,69B,153B 'supports':133B 'the':93B,100B,105B,127B,134B,143B,155B 'this':90B 'to':110B,154B 'use':80B 'used':164B 'via':39B,123B 'which':150B","popularity_score":"0.0000","maintenance_score":"0.0000","institution_id":"ea368adb-37b1-46ed-83cc-ad0d75bedb83","institution_type":"GOVERNMENT","country_code":"GB","official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-08-01T15:30:16.649Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["JSON"],"capability_tier":"sample","trust_score":0,"access":{"level":"direct","primary":{"kind":"download","label":"Download distribution","method":"GET","url":"https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD","format":"JSON","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Download distribution","method":"GET","url":"https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD","format":"JSON","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://opendata.camden.gov.uk","source":"probe","runnable":true}],"formats":["JSON"]},"maturity":{"entry_id":"b98256f7-e0d7-4429-9532-270fbc4e8c8d","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"profiled","level_index":3,"level_label":"Profiled","meaning":"Schema, dimensions and licence understood","counts_as_coverage":false,"blocked_by":"executable","rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":false,"reached":false,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":true,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":null,"proven_threshold":80,"institution_id":"ea368adb-37b1-46ed-83cc-ad0d75bedb83","definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"opendata.camden.gov.uk","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-07-31T15:47:12.478Z"},"api_details":{"id":"9425ab23-61bb-426b-99c1-083579ad96bd","entry_id":"b98256f7-e0d7-4429-9532-270fbc4e8c8d","base_url":"https://opendata.camden.gov.uk","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":"rest","endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":null,"created_at":"2026-07-31T13:42:51.131Z","updated_at":"2026-07-31T13:42:51.131Z"},"dataset_details":null,"license":null,"license_raw":null,"latest_check":{"id":"ed1e355a-aa86-4deb-a2e6-f4c1eab47a1c","entry_id":"b98256f7-e0d7-4429-9532-270fbc4e8c8d","status":"VERIFIED","last_checked_at":"2026-07-31T13:44:11.955Z","p50_latency_ms":1677,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-31T13:44:11.955Z","updated_at":"2026-07-31T13:44:11.955Z","consecutive_successes":1,"probe_url":"https://opendata.camden.gov.uk","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/html; charset=utf-8","probe_succeeded_at":"2026-07-31T13:44:11.955Z"},"data_profile":{"id":"5936b1b7-0f2e-4e94-8388-859081a3908b","entry_id":"b98256f7-e0d7-4429-9532-270fbc4e8c8d","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":":id","type":"text","label":null,"description":null},{"name":":version","type":"text","label":null,"description":null},{"name":":created_at","type":"datetime","label":null,"description":null},{"name":":updated_at","type":"datetime","label":null,"description":null},{"name":"postcode_1","type":"text","label":null,"description":null},{"name":"postcode_2","type":"text","label":null,"description":null},{"name":"postcode_3","type":"text","label":null,"description":null},{"name":"date_introduced","type":"text","label":null,"description":null},{"name":"user_type","type":"text","label":null,"description":null},{"name":"easting","type":"text","label":null,"description":null},{"name":"northing","type":"text","label":null,"description":null},{"name":"positional_quality","type":"text","label":null,"description":null},{"name":"county_code","type":"text","label":null,"description":null},{"name":"county_name","type":"text","label":null,"description":null},{"name":"local_authority_code","type":"text","label":null,"description":null},{"name":"local_authority_name","type":"text","label":null,"description":null},{"name":"ward_code","type":"text","label":null,"description":null},{"name":"ward_name","type":"text","label":null,"description":null},{"name":"country_code","type":"text","label":null,"description":null},{"name":"country_name","type":"text","label":null,"description":null},{"name":"region_code","type":"text","label":null,"description":null},{"name":"region_name","type":"text","label":null,"description":null},{"name":"parliamentary_constituency_code","type":"text","label":null,"description":null},{"name":"parliamentary_constituency_name","type":"text","label":null,"description":null},{"name":"european_electoral_region_code","type":"text","label":null,"description":null},{"name":"european_electoral_region_name","type":"text","label":null,"description":null},{"name":"primary_care_trust_code","type":"text","label":null,"description":null},{"name":"primary_care_trust_name","type":"text","label":null,"description":null},{"name":"lsoa_code","type":"text","label":null,"description":null},{"name":"lower_super_output_area","type":"text","label":null,"description":null},{"name":"msoa_code","type":"text","label":null,"description":null},{"name":"middle_super_output_area","type":"text","label":null,"description":null},{"name":"output_area_classification_code","type":"text","label":null,"description":null},{"name":"output_area_classification_name","type":"text","label":null,"description":null},{"name":"longitude","type":"text","label":null,"description":null},{"name":"latitude","type":"text","label":null,"description":null},{"name":"spatial_accuracy","type":"text","label":null,"description":null},{"name":"last_uploaded","type":"datetime","label":null,"description":null},{"name":"location","type":"object","label":null,"description":null},{"name":"socrata_id","type":"text","label":null,"description":null},{"name":":@computed_region_6i9a_26nj","type":"text","label":null,"description":null},{"name":":@computed_region_hxwp_gyfc","type":"text","label":null,"description":null}],"field_count":42,"sample_records":[{":id":"row-wdzg-cjdq_na59","easting":"529713",":version":"rv-e683_zywy-r7aj","latitude":"51.545784","location":{"type":"Point","coordinates":[-0.130753,51.545784]},"northing":"184643","longitude":"-0.130753","lsoa_code":"E01000869","msoa_code":"E02000180","user_type":"0","ward_code":"E05013654","ward_name":"Camden Square","postcode_1":"NW1 9XG","postcode_2":"NW1  9XG","postcode_3":"NW1 9XG","socrata_id":"1810819",":created_at":"2026-06-22T08:32:40.088Z",":updated_at":"2026-06-22T08:32:50.642Z","county_code":"E13000001","county_name":"Inner London","region_code":"E12000007","region_name":"London","country_code":"E92000001","country_name":"England","last_uploaded":"2026-06-22T08:20:39.000","date_introduced":"198001","spatial_accuracy":"Postcode Level","positional_quality":"1","local_authority_code":"E09000007","local_authority_name":"Camden","lower_super_output_area":"Camden 015E","primary_care_trust_code":"obsolete","primary_care_trust_name":"obsolete","middle_super_output_area":"Camden 015",":@computed_region_6i9a_26nj":"28",":@computed_region_hxwp_gyfc":"4","european_electoral_region_code":"obsolete","european_electoral_region_name":"obsolete","output_area_classification_code":"2D3","output_area_classification_name":"Cosmopolitans;Aspiring and affluent;EU white-collar workers","parliamentary_constituency_code":"E14001290","parliamentary_constituency_name":"Holborn and St Pancras"},{":id":"row-p57t.myqs.uei6","easting":"526881",":version":"rv-4u5r-6zgu_pxm5","latitude":"51.5455","location":{"type":"Point","coordinates":[-0.171609,51.5455]},"northing":"184540","longitude":"-0.171609","lsoa_code":"E01000844","msoa_code":"E02000176","user_type":"0","ward_code":"E05013652","ward_name":"Belsize","postcode_1":"NW3 3HS","postcode_2":"NW3  3HS","postcode_3":"NW3 3HS","socrata_id":"1812432",":created_at":"2026-06-22T08:32:40.088Z",":updated_at":"2026-06-22T08:32:50.642Z","county_code":"E13000001","county_name":"Inner London","region_code":"E12000007","region_name":"London","country_code":"E92000001","country_name":"England","last_uploaded":"2026-06-22T08:20:40.000","date_introduced":"198001","spatial_accuracy":"Postcode Level","positional_quality":"1","local_authority_code":"E09000007","local_authority_name":"Camden","lower_super_output_area":"Camden 011B","primary_care_trust_code":"obsolete","primary_care_trust_name":"obsolete","middle_super_output_area":"Camden 011",":@computed_region_6i9a_26nj":"3",":@computed_region_hxwp_gyfc":"1","european_electoral_region_code":"obsolete","european_electoral_region_name":"obsolete","output_area_classification_code":"2D3","output_area_classification_name":"Cosmopolitans;Aspiring and affluent;EU white-collar workers","parliamentary_constituency_code":"E14001265","parliamentary_constituency_name":"Hampstead and Highgate"},{":id":"row-6zin-vptm_ccwx","easting":"526630",":version":"rv-psra_wrk9.gdy9","latitude":"51.54456","location":{"type":"Point","coordinates":[-0.175266,51.54456]},"northing":"184429","longitude":"-0.175266","lsoa_code":"E01000883","msoa_code":"E02000173","user_type":"0","ward_code":"E05013652","ward_name":"Belsize","postcode_1":"NW3 5EN","postcode_2":"NW3  5EN","postcode_3":"NW3 5EN","socrata_id":"1812761",":created_at":"2026-06-22T08:32:40.088Z",":updated_at":"2026-06-22T08:32:50.642Z","county_code":"E13000001","county_name":"Inner London","region_code":"E12000007","region_name":"London","country_code":"E92000001","country_name":"England","last_uploaded":"2026-06-22T08:20:40.000","date_introduced":"198001","spatial_accuracy":"Postcode Level","positional_quality":"1","local_authority_code":"E09000007","local_authority_name":"Camden","lower_super_output_area":"Camden 008C","primary_care_trust_code":"obsolete","primary_care_trust_name":"obsolete","middle_super_output_area":"Camden 008",":@computed_region_6i9a_26nj":"42",":@computed_region_hxwp_gyfc":"6","european_electoral_region_code":"obsolete","european_electoral_region_name":"obsolete","output_area_classification_code":"2D3","output_area_classification_name":"Cosmopolitans;Aspiring and affluent;EU white-collar workers","parliamentary_constituency_code":"E14001265","parliamentary_constituency_name":"Hampstead and Highgate"},{":id":"row-gkvp-gu3y-f7gq","easting":"526259",":version":"rv-imr9~xzbg_s5qx","latitude":"51.55654","location":{"type":"Point","coordinates":[-0.180139,51.55654]},"northing":"185753","longitude":"-0.180139","lsoa_code":"E01000879","msoa_code":"E02000169","user_type":"0","ward_code":"E05013657","ward_name":"Frognal","postcode_1":"NW3 6QY","postcode_2":"NW3  6QY","postcode_3":"NW3 6QY","socrata_id":"1812995",":created_at":"2026-06-22T08:32:40.088Z",":updated_at":"2026-06-22T08:32:50.642Z","county_code":"E13000001","county_name":"Inner London","region_code":"E12000007","region_name":"London","country_code":"E92000001","country_name":"England","last_uploaded":"2026-06-22T08:20:40.000","date_introduced":"198001","spatial_accuracy":"Postcode Level","positional_quality":"1","local_authority_code":"E09000007","local_authority_name":"Camden","lower_super_output_area":"Camden 004B","primary_care_trust_code":"obsolete","primary_care_trust_name":"obsolete","middle_super_output_area":"Camden 004",":@computed_region_6i9a_26nj":"38",":@computed_region_hxwp_gyfc":"6","european_electoral_region_code":"obsolete","european_electoral_region_name":"obsolete","output_area_classification_code":"2D1","output_area_classification_name":"Cosmopolitans;Aspiring and affluent;Urban cultural mix","parliamentary_constituency_code":"E14001265","parliamentary_constituency_name":"Hampstead and Highgate"},{":id":"row-k8t5~7d6c-t7kn","easting":"528362",":version":"rv-57tq-izr6~8efw","latitude":"51.56082","location":{"type":"Point","coordinates":[-0.149627,51.56082]},"northing":"186282","longitude":"-0.149627","lsoa_code":"E01000909","msoa_code":"E02000166","user_type":"0","ward_code":"E05013661","ward_name":"Highgate","postcode_1":"NW5 1QU","postcode_2":"NW5  1QU","postcode_3":"NW5 1QU","socrata_id":"1813374",":created_at":"2026-06-22T08:32:40.088Z",":updated_at":"2026-06-22T08:32:50.642Z","county_code":"E13000001","county_name":"Inner London","region_code":"E12000007","region_name":"London","country_code":"E92000001","country_name":"England","last_uploaded":"2026-06-22T08:20:40.000","date_introduced":"198001","spatial_accuracy":"Postcode Level","positional_quality":"1","local_authority_code":"E09000007","local_authority_name":"Camden","lower_super_output_area":"Camden 001C","primary_care_trust_code":"obsolete","primary_care_trust_name":"obsolete","middle_super_output_area":"Camden 001",":@computed_region_6i9a_26nj":"68",":@computed_region_hxwp_gyfc":"10","european_electoral_region_code":"obsolete","european_electoral_region_name":"obsolete","output_area_classification_code":"2C1","output_area_classification_name":"Cosmopolitans;Comfortable cosmopolitan;Migrant families","parliamentary_constituency_code":"E14001265","parliamentary_constituency_name":"Hampstead and Highgate"}],"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD","curl":"curl -sL 'https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD' -o data.json","label":"Download distribution","method":"GET","description":"Full json file download — the schema shown was inferred from the file's first records."},{"url":"https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD","curl":"curl -sL 'https://opendata.camden.gov.uk/api/v3/views/qxtb-yhkm/query.json?accessType=DOWNLOAD' -H 'Range: bytes=0-4095'","label":"Preview first bytes","method":"GET","description":"First 4 KB of the file (servers honoring Range requests)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-31T13:44:50.446Z","run_id":"16c7e265-227c-44cf-8a3c-2b35ba3486b8","created_at":"2026-07-31T13:44:44.741Z","updated_at":"2026-07-31T13:44:50.446Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}