{"id":"9b97c458-00bb-4b88-92ac-ac95ede15aac","type":"API","name":"London pubs audit","slug":"london-pubs-audit","description":"As part of the Cultural Infrastructure Plan, an annual audit of pubs using the Inter-Departmental Business Register data is produced. The overall number of pubs in London has remained largely unchanged since 2018. There were 3,535 pubs in London in 2023. Overall employee numbers increased in 2023 for the first time since the pandemic in 2020. In 2023, there were 49,000 jobs in London pubs, above the previous peak in 2020 at 48,000 jobs. The share of jobs in large pubs (with more than 10 employees) reached 85% in 2023, while the share of jobs in smaller pubs dropped to 14%, its lowest value in the data going back to 2001. Among local authorities, 13 recorded a decrease in pub numbers in 2023 compared to 2022, 13 recorded an increase and the rest saw no significant change. The long-term trends remain the same as reported in the previous iteration of this analysis : Overall, pub numbers have declined over the past 21 years in most London boroughs and in the capital overall but employment has increased as the average pub has become larger. While the decline in pub numbers reflects an overall UK trend, the number of employees increased by more in London (17%) than the UK average (6%) since 2001.","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":null,"docs_url":null,"repo_url":"https://data.london.gov.uk/download/2yp45/04ef7fa5-0784-40ad-ae58-fa8fe7ad8dbe/London%20Pubs%20Audit%20July%202024.html","status":"ACTIVE","verification_state":"UNVERIFIED","tags":["employment"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=data.london.gov.uk","primary_source_url":"https://data.london.gov.uk/download/2yp45/04ef7fa5-0784-40ad-ae58-fa8fe7ad8dbe/London%20Pubs%20Audit%20July%202024.html","extraction_confidence":"0.34","created_at":"2026-07-30T13:40:55.159Z","updated_at":"2026-07-31T11:57:59.022Z","last_verified_at":null,"deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'000':68B,81B,289B,302B '10':93B,314B '13':123B,135B,344B,356B '14':109B,330B '17':213B,434B '2001':119B,220B,340B,441B '2018':38B,259B '2020':62B,78B,283B,299B '2022':134B,355B '2023':47B,53B,64B,98B,131B,268B,274B,285B,319B,352B '21':171B,392B '3':41B,262B '48':80B,301B '49':67B,288B '535':42B,263B '6':218B,439B '85':96B,317B 'a':346B 'above':294B 'among':120B,341B 'an':232B,358B,421B 'analysi':162B 'analysis':383B 'and':360B,398B 'annual':12B,233B 'as':225B,375B,407B 'at':300B 'audit':3A,13B,224A,234B 'author':122B 'authorities':343B 'averag':188B,217B 'average':409B,438B 'back':117B,338B 'becom':191B 'become':412B 'borough':176B 'boroughs':397B 'busi':21B 'business':242B 'but':403B 'by':430B 'capit':180B 'capital':401B 'chang':145B 'change':366B 'compar':132B 'compared':353B 'cultur':8B 'cultural':229B 'data':23B,115B,244B,336B 'declin':167B,195B 'decline':416B 'declined':388B 'decreas':126B 'decrease':347B 'department':20B 'departmental':241B 'drop':107B 'dropped':328B 'employ':183B,221C 'employe':49B,94B,207B 'employee':270B 'employees':315B,428B 'employment':404B 'first':56B,277B 'for':275B 'go':116B 'going':337B 'has':254B,405B,411B 'have':387B 'in':252B,265B,267B,273B,282B,284B,291B,298B,308B,318B,325B,334B,348B,351B,377B,394B,399B,417B,432B 'increas':51B,138B,185B,208B 'increase':359B 'increased':272B,406B,429B 'infrastructur':9B 'infrastructure':230B 'inter':19B,240B 'inter-department':18B 'inter-departmental':239B 'is':245B 'iter':159B 'iteration':380B 'its':331B 'job':69B,82B,86B,103B 'jobs':290B,303B,307B,324B 'larg':35B,88B 'large':309B 'largely':256B 'larger':192B,413B 'local':121B,342B 'london':1A,32B,45B,71B,175B,212B,222A,253B,266B,292B,396B,433B 'long':148B,369B 'long-term':147B,368B 'lowest':111B,332B 'more':312B,431B 'most':395B 'no':364B 'number':28B,50B,129B,165B,198B,205B,249B,426B 'numbers':271B,350B,386B,419B 'of':227B,235B,250B,306B,323B,381B,427B 'over':389B 'overal':27B,48B,163B,181B,201B 'overall':248B,269B,384B,402B,422B 'pandem':60B 'pandemic':281B 'part':5B,226B 'past':170B,391B 'peak':76B,297B 'plan':10B,231B 'previous':75B,158B,296B,379B 'produc':25B 'produced':246B 'pub':2A,15B,30B,43B,72B,89B,106B,128B,164B,189B,197B,349B,385B,410B,418B 'pubs':223A,236B,251B,264B,293B,310B,327B 'reach':95B 'reached':316B 'record':124B,136B 'recorded':345B,357B 'reflect':199B 'reflects':420B 'regist':22B 'register':243B 'remain':34B,151B,372B 'remained':255B 'report':155B 'reported':376B 'rest':141B,362B 'same':374B 'saw':142B,363B 'share':84B,101B,305B,322B 'signific':144B 'significant':365B 'sinc':37B,58B,219B 'since':258B,279B,440B 'smaller':105B,326B 'term':149B,370B 'than':313B,435B 'the':228B,238B,247B,276B,280B,295B,304B,321B,335B,361B,367B,373B,378B,390B,400B,408B,415B,425B,436B 'there':260B,286B 'this':382B 'time':57B,278B 'to':329B,339B,354B 'trend':150B,203B,424B 'trends':371B 'uk':202B,216B,423B,437B 'unchang':36B 'unchanged':257B 'use':16B 'using':237B 'valu':112B 'value':333B 'were':261B,287B 'while':320B,414B 'with':311B 'year':172B 'years':393B","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-07-31T13:34:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"reference_only","formats":[],"capability_tier":"reference","trust_score":28.166666666666664,"access":{"level":"reference_only","primary":{"kind":"landing","label":"Open source record","method":"GET","url":"https://data.london.gov.uk/download/2yp45/04ef7fa5-0784-40ad-ae58-fa8fe7ad8dbe/London%20Pubs%20Audit%20July%202024.html","source":"primary_source","runnable":false},"actions":[{"kind":"landing","label":"Open source record","method":"GET","url":"https://data.london.gov.uk/download/2yp45/04ef7fa5-0784-40ad-ae58-fa8fe7ad8dbe/London%20Pubs%20Audit%20July%202024.html","source":"primary_source","runnable":false}],"formats":[]},"maturity":{"entry_id":"9b97c458-00bb-4b88-92ac-ac95ede15aac","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":"discovered","level_index":1,"level_label":"Discovered","meaning":"Source and metadata recorded","counts_as_coverage":false,"blocked_by":null,"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":false,"reached":false,"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":false,"reached":false,"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":false,"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":"data.london.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-31T14:35:12.826Z"},"api_details":null,"dataset_details":null,"license":null,"license_raw":null,"latest_check":{"id":"b09efdf4-8838-463d-9248-31ab94225285","entry_id":"9b97c458-00bb-4b88-92ac-ac95ede15aac","status":"UNVERIFIED","last_checked_at":"2026-07-31T09:28:31.939Z","p50_latency_ms":null,"p95_latency_ms":null,"last_error":"Source URL is HTML, not a machine-readable API — possible mis-classification","consecutive_failures":0,"created_at":"2026-07-30T13:42:03.414Z","updated_at":"2026-07-31T09:28:31.939Z","consecutive_successes":0,"probe_url":null,"probe_method":null,"probe_http_status":null,"probe_content_type":null,"probe_succeeded_at":null},"data_profile":{"id":"74de2ffd-7195-4719-b40d-725ed49f5d89","entry_id":"9b97c458-00bb-4b88-92ac-ac95ede15aac","profile_source":"none","profile_kind":"dataset","dataset_id":null,"fields":null,"field_count":null,"sample_records":null,"record_count":null,"data_size_bytes":null,"dataset_count":null,"query_examples":null,"status":"unsupported","error_message":"No introspectable source detected (primary URL sniffed: not machine-readable data)","profiled_at":"2026-07-30T13:41:31.649Z","run_id":"0be0df9b-3303-45e3-add2-f8faf0ced64d","created_at":"2026-07-30T13:41:31.649Z","updated_at":"2026-07-30T13:41:31.649Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":false},"datasets":[],"limits":[]}