{"id":"4501ffd0-6b12-444f-8024-2c9f19602c11","type":"DATASET","name":"Public Sector Apprenticeship Data Publication","slug":"public-sector-apprenticeship-data-publication","description":"This data set includes workforce information on Public Sector Apprenticeship Data for a number of measures listed in the metadata.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"http://www.manchester.gov.uk/open/download/downloads/id/892/public_sector_apprenticeship_data_publication_201920.xlsx","status":"ACTIVE","verification_state":"VERIFIED","tags":["employment","skills","education"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=manchester.gov.uk","primary_source_url":"http://www.manchester.gov.uk/open/download/downloads/id/892/public_sector_apprenticeship_data_publication_201920.xlsx","extraction_confidence":"0.16","created_at":"2026-06-18T02:12:48.581Z","updated_at":"2026-08-16T14:08:02.600Z","last_verified_at":"2026-08-16T14:08:02.600Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-10T00:06:18.346Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-07T12:49:33.002Z","search_vector":"'a':122B,140B 'accompani':43B 'accompanying':147B 'activ':56B 'activity':160B 'and':156B,182B,185B,191B 'apprenticeship':3A,15B,34B,55B,76B,107A,119B,159B,180B 'apprenticeships':138B 'are':194B 'associ':94B 'associated':198B 'at':166B 'by':152B 'citi':50B 'city':154B 'council':51B,155B 'cover':35B 'covering':139B 'data':4A,7B,16B,108A,111B,120B 'dataset':27B,69B,100B,131B,173B,204B 'definit':89B 'definitions':193B 'describ':91B 'described':195B 'detail':40B 'detailed':144B 'educ':104C 'employ':80B,102C 'employment':184B 'for':121B 'in':127B,145B,169B,196B,202B 'includ':9B 'includes':113B 'indic':83B 'indicators':187B 'inform':11B,30B 'information':115B,134B 'intend':71B 'intended':175B 'is':150B,174B 'it':149B 'itself':206B 'level':64B,168B 'list':22B 'listed':126B 'manchest':49B 'manchester':153B 'measur':21B,39B,86B 'measures':125B,143B,190B 'metadata':25B,44B,95B,129B,148B,199B 'monitor':74B 'monitoring':178B 'nation':63B 'national':167B 'number':19B,37B,123B,141B 'of':124B,142B,179B 'on':116B,135B 'provid':28B 'provides':132B 'public':1A,5A,13B,32B,59B,105A,117B,136B,163B 'publication':109A 'publish':47B 'published':151B 'rather':96B,200B 'relat':53B,79B 'related':183B 'relates':157B 'sector':2A,14B,33B,60B,106A,118B,137B,164B 'set':8B,112B 'skill':82B,103C 'skills':186B 'specif':85B 'specific':189B 'summari':101B 'summary':205B 'support':73B,177B 'than':201B 'the':128B,146B,162B,170B,172B,197B,203B 'their':192B 'this':110B,130B 'though':84B,188B 'to':158B,176B 'uk':67B,171B 'uptak':77B 'uptake':181B 'within':57B,161B 'workforc':10B,29B,61B 'workforce':114B,133B,165B","popularity_score":"0.0000","maintenance_score":"0.7000","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-06-18T02:12:48.581Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset provides workforce information on public sector apprenticeships, covering a number of measures detailed in the accompanying metadata. It is published by Manchester City Council and relates to apprenticeship activity within the public sector workforce at national level in the UK. The dataset is intended to support monitoring of apprenticeship uptake and related employment and skills indicators, though specific measures and their definitions are described in the associated metadata rather than in the dataset summary itself.","native_lang":"en","access_level":"direct","formats":["CSV","EXCEL XLSX"],"capability_tier":"download","trust_score":51.48076923076923,"access":{"level":"direct","primary":{"kind":"download","label":"Download EXCEL XLSX","method":"GET","url":"http://www.manchester.gov.uk/open/download/downloads/id/892/public_sector_apprenticeship_data_publication_201920.xlsx","format":"EXCEL XLSX","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download EXCEL XLSX","method":"GET","url":"http://www.manchester.gov.uk/open/download/downloads/id/892/public_sector_apprenticeship_data_publication_201920.xlsx","format":"EXCEL XLSX","source":"distribution","runnable":true},{"kind":"download","label":"Download CSV","method":"GET","url":"http://www.manchester.gov.uk/open/download/downloads/id/554/public_sector_apprenticeship_data_publication_201718.csv","format":"CSV","source":"distribution","runnable":true},{"kind":"download","label":"Download data","method":"GET","url":"http://www.manchester.gov.uk/open/download/downloads/id/557/public_sector_apprenticeship_data_publication_201718_metadata.docx","source":"distribution","runnable":true},{"kind":"download","label":"Download EXCEL XLSX","method":"GET","url":"http://www.manchester.gov.uk/open/downloads/file/555/public_sector_apprenticeship_data_publication_201718","format":"EXCEL XLSX","source":"distribution","runnable":true}],"formats":["CSV","EXCEL XLSX"]},"maturity":{"entry_id":"4501ffd0-6b12-444f-8024-2c9f19602c11","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":"verified","level_index":2,"level_label":"Verified","meaning":"Access tested successfully","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":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":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":"www.manchester.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-08-16T16:02:08.227Z"},"api_details":null,"dataset_details":{"id":"4289dd32-b6a9-4439-8331-7bc2ff200eb5","entry_id":"4501ffd0-6b12-444f-8024-2c9f19602c11","upstream_issued":null,"upstream_modified":null,"themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":"ogl-uk-3.0","license_raw":"http://reference.data.gov.uk/id/open-government-licence","has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-06-18T02:12:48.738Z","updated_at":"2026-07-09T07:44:13.025Z","publisher":"Manchester City Council","publisher_url":null,"distributions":[{"id":"a6ec20aa-04f3-42e3-b296-b61faafb96b5","dataset_details_id":"4289dd32-b6a9-4439-8331-7bc2ff200eb5","title":"Public Sector Apprenticeship Data Publication 2019/20","description":null,"access_url":"http://www.manchester.gov.uk/open/download/downloads/id/892/public_sector_apprenticeship_data_publication_201920.xlsx","download_url":null,"media_type":null,"format":"Excel XLSX","byte_size":null,"license_id":null,"license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":"2026-08-16T14:08:00.960Z","is_available":true,"last_http_status":403,"created_at":"2026-06-18T02:12:49.087Z","updated_at":"2026-08-16T14:08:00.960Z"},{"id":"ea30924b-f23c-468e-ab54-7d68acf9b250","dataset_details_id":"4289dd32-b6a9-4439-8331-7bc2ff200eb5","title":"Public Sector Apprenticeship Data Publication 2017/18","description":null,"access_url":"http://www.manchester.gov.uk/open/download/downloads/id/554/public_sector_apprenticeship_data_publication_201718.csv","download_url":null,"media_type":null,"format":"CSV","byte_size":null,"license_id":null,"license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":"2026-07-16T20:43:05.535Z","is_available":true,"last_http_status":403,"created_at":"2026-06-18T02:12:49.241Z","updated_at":"2026-07-16T20:43:05.535Z"},{"id":"da91ebe3-5e59-44f9-bf12-61161b6b98b6","dataset_details_id":"4289dd32-b6a9-4439-8331-7bc2ff200eb5","title":"Public Sector Apprenticeship Data Publication 2019/20","description":null,"access_url":"http://www.manchester.gov.uk/open/download/downloads/id/894/public_sector_apprenticeship_data_publication_201920.csv","download_url":null,"media_type":null,"format":"CSV","byte_size":null,"license_id":null,"license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":"2026-07-08T08:06:07.155Z","is_available":false,"last_http_status":404,"created_at":"2026-06-18T02:12:49.412Z","updated_at":"2026-07-08T08:06:07.155Z"},{"id":"2f638635-44df-43ce-9c5d-e281b04a8b1a","dataset_details_id":"4289dd32-b6a9-4439-8331-7bc2ff200eb5","title":"Public Sector Apprenticeship Data Publication 2017/18 Metadata","description":null,"access_url":"http://www.manchester.gov.uk/open/download/downloads/id/557/public_sector_apprenticeship_data_publication_201718_metadata.docx","download_url":null,"media_type":null,"format":null,"byte_size":null,"license_id":null,"license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-18T02:12:49.573Z","updated_at":"2026-06-18T02:12:49.573Z"},{"id":"84c92c42-0586-47ef-880e-dcefcc65ecd3","dataset_details_id":"4289dd32-b6a9-4439-8331-7bc2ff200eb5","title":"Public Sector Apprenticeship Data Publication 2017/18","description":null,"access_url":"http://www.manchester.gov.uk/open/downloads/file/555/public_sector_apprenticeship_data_publication_201718","download_url":null,"media_type":null,"format":"Excel XLSX","byte_size":null,"license_id":null,"license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-18T02:12:49.736Z","updated_at":"2026-06-18T02:12:49.736Z"}],"license":{"id":"ogl-uk-3.0","spdx_id":null,"name":"UK Open Government Licence v3.0","url":"https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"}},"license":{"id":"ogl-uk-3.0","spdx_id":null,"name":"UK Open Government Licence v3.0","url":"https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"ogl-uk-3.0","license_name":"UK Open Government Licence v3.0","license_url":"https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Licence text: you are free to \"copy, publish, distribute and transmit the Information; adapt the Information; exploit the Information commercially and non-commercially\", provided you \"acknowledge the source of the Information in your product or application by including or linking to any attribution statement specified by the Information Provider(s)\". Exemptions: \"This licence does not cover: personal data in the Information ...\". The licence lists no share-alike obligation.","source_url":"https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/","reviewed_at":null},"license_raw":"http://reference.data.gov.uk/id/open-government-licence","latest_check":{"id":"8e34caf2-248a-4bd5-93de-4e5703c5e57f","entry_id":"4501ffd0-6b12-444f-8024-2c9f19602c11","status":"VERIFIED","last_checked_at":"2026-08-16T14:08:02.285Z","p50_latency_ms":2053,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-18T02:13:32.055Z","updated_at":"2026-08-16T14:08:02.285Z","consecutive_successes":148,"probe_url":"http://www.manchester.gov.uk/open/download/downloads/id/892/public_sector_apprenticeship_data_publication_201920.xlsx","probe_method":"GET","probe_http_status":403,"probe_content_type":"text/html; charset=UTF-8","probe_succeeded_at":"2026-08-16T14:08:02.285Z"},"data_profile":{"id":"89c6d68c-cdc6-4eac-9381-b818ad640e1c","entry_id":"4501ffd0-6b12-444f-8024-2c9f19602c11","profile_source":"distribution","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":"error","error_message":"Distribution fetch failed: 403","profiled_at":"2026-07-26T12:49:11.833Z","run_id":"02191472-ceb2-4e5c-bcc7-979700c13237","created_at":"2026-06-18T02:35:45.874Z","updated_at":"2026-07-27T17:53:35.297Z","license_raw":null,"license_id":null,"consecutive_failure_count":1,"last_error_at":"2026-07-26T12:49:11.833Z","last_error_message":"Distribution fetch failed: 403","previewable":false},"datasets":[],"limits":[]}