{"id":"408b5a12-94ad-4686-8c44-85e16d0f60f8","type":"DATASET","name":"Public Sector Apprenticeship Data Publication","slug":"public-sector-apprenticeship-data-publication-1","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/downloads/file/555/public_sector_apprenticeship_data_publication_201718","status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=manchester.gov.uk","primary_source_url":"http://www.manchester.gov.uk/open/downloads/file/555/public_sector_apprenticeship_data_publication_201718","extraction_confidence":"0.16","created_at":"2026-07-02T11:35:56.665Z","updated_at":"2026-08-16T18:23:59.706Z","last_verified_at":"2026-08-16T18:23:59.706Z","deprecated_at":null,"ranking_score":59,"last_ranked_at":"2026-08-05T04:25:44.807Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-02T11:50:12.113Z","search_vector":"'a':104B,128B 'accompani':59B 'accompanying':145B 'activ':49B 'activity':135B 'and':154B,166B 'apprenticeship':3A,15B,34B,48B,78B,89A,101B,134B,164B 'apprenticeships':120B 'as':141B 'authent':74B 'authentication':160B 'avail':72B 'available':158B 'by':122B 'citi':38B 'city':124B 'council':39B,125B 'cover':63B 'covers':149B 'data':4A,7B,16B,90A,93B,102B 'dataset':27B,62B,113B,148B 'detail':56B 'detailed':142B 'develop':82B 'development':168B 'figur':67B 'figures':153B 'for':103B 'freeli':71B 'freely':157B 'in':109B,143B 'includ':9B,41B 'includes':95B,127B 'inform':11B,30B 'information':97B,116B 'is':155B 'it':126B 'level':66B,152B 'list':22B 'listed':108B 'made':70B,156B 'manchest':37B 'manchester':123B 'measur':21B,45B 'measures':107B,131B 'metadata':25B,60B,111B,146B 'monitor':76B 'monitoring':162B 'nation':65B 'national':151B 'national-level':64B,150B 'number':19B,43B,105B,129B 'of':106B,130B,163B 'on':98B,117B 'organis':86B 'organisations':172B 'provid':28B 'provides':114B 'public':1A,5A,13B,32B,52B,84B,87A,99B,118B,138B,170B 'publication':91A 'publish':35B 'published':121B 'relat':46B 'relating':132B 'sector':2A,14B,33B,53B,85B,88A,100B,119B,139B,171B 'set':8B,94B 'support':75B 'supporting':161B 'the':110B,137B,144B,147B 'this':92B,112B 'to':133B 'uptak':79B 'uptake':165B 'within':50B,83B,136B,169B 'without':73B,159B 'workforc':10B,29B,54B,81B 'workforce':96B,115B,140B,167B","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-07-03T15:57:55.839Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset provides workforce information on public sector apprenticeships, published by Manchester City Council. It includes a number of measures relating to apprenticeship activity within the public sector workforce, as detailed in the accompanying metadata. The dataset covers national-level figures and is made freely available without authentication, supporting monitoring of apprenticeship uptake and workforce development within public sector organisations.","native_lang":"en","access_level":"direct","formats":["EXCEL XLSX"],"capability_tier":"download","trust_score":49.94230769230769,"access":{"level":"direct","primary":{"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},"actions":[{"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},{"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 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}],"formats":["EXCEL XLSX"]},"maturity":{"entry_id":"408b5a12-94ad-4686-8c44-85e16d0f60f8","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-16T19:47:36.018Z"},"api_details":null,"dataset_details":{"id":"367be6ec-8fb7-4802-abce-d781672fb060","entry_id":"408b5a12-94ad-4686-8c44-85e16d0f60f8","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-07-02T11:35:56.834Z","updated_at":"2026-07-09T07:44:13.025Z","publisher":"Manchester City Council","publisher_url":null,"distributions":[{"id":"246e48e5-8013-4ec8-987b-970309f789b1","dataset_details_id":"367be6ec-8fb7-4802-abce-d781672fb060","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":"ogl-uk-3.0","license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":"2026-08-16T18:23:58.166Z","is_available":true,"last_http_status":403,"created_at":"2026-07-02T11:35:57.150Z","updated_at":"2026-08-16T18:23:58.166Z"},{"id":"2375f820-4244-470e-a361-2cf1db293bb4","dataset_details_id":"367be6ec-8fb7-4802-abce-d781672fb060","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":"ogl-uk-3.0","license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":"2026-07-27T05:57:30.791Z","is_available":false,"last_http_status":null,"created_at":"2026-07-02T11:35:57.326Z","updated_at":"2026-07-27T05:57:30.791Z"},{"id":"2a276388-6125-49a7-ac30-c5d690f28bff","dataset_details_id":"367be6ec-8fb7-4802-abce-d781672fb060","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":"ogl-uk-3.0","license_raw":"http://reference.data.gov.uk/id/open-government-licence","last_checked_at":"2026-07-27T05:57:40.432Z","is_available":false,"last_http_status":null,"created_at":"2026-07-02T11:35:57.512Z","updated_at":"2026-07-27T05:57:40.432Z"},{"id":"b0e3f87e-dcc4-40a0-8897-c2b889edf246","dataset_details_id":"367be6ec-8fb7-4802-abce-d781672fb060","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":"ogl-uk-3.0","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-07-02T11:35:57.691Z","updated_at":"2026-07-02T11:35:57.691Z"},{"id":"d0b6f33e-c33d-4a3a-b6e8-03087988249d","dataset_details_id":"367be6ec-8fb7-4802-abce-d781672fb060","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":"ogl-uk-3.0","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-07-02T11:35:57.892Z","updated_at":"2026-07-02T11:35:57.892Z"}],"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":"8a3fe6d9-ce06-40b5-8369-b81912554e70","entry_id":"408b5a12-94ad-4686-8c44-85e16d0f60f8","status":"VERIFIED","last_checked_at":"2026-08-16T18:23:59.438Z","p50_latency_ms":1497,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-02T11:37:01.093Z","updated_at":"2026-08-16T18:23:59.438Z","consecutive_successes":82,"probe_url":"http://www.manchester.gov.uk/open/downloads/file/555/public_sector_apprenticeship_data_publication_201718","probe_method":"GET","probe_http_status":403,"probe_content_type":"text/html; charset=UTF-8","probe_succeeded_at":"2026-08-16T18:23:59.438Z"},"data_profile":{"id":"c069c51a-b485-47c0-bbc8-6088e9c94900","entry_id":"408b5a12-94ad-4686-8c44-85e16d0f60f8","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-26T13:07:11.565Z","run_id":"079ae46e-fc32-4793-9c03-03fb122b795b","created_at":"2026-07-02T11:41:15.648Z","updated_at":"2026-07-27T17:53:35.297Z","license_raw":null,"license_id":null,"consecutive_failure_count":1,"last_error_at":"2026-07-26T13:07:11.565Z","last_error_message":"Distribution fetch failed: 403","previewable":false},"datasets":[],"limits":[]}