{"id":"4e3ae8b7-8233-412f-8c02-95a611c92d46","type":"DATASET","name":"Public Sector - apprenticeship targets","slug":"public-sector-apprenticeship-targets","description":"The public sector apprenticeship target was introduced by government in April 2017 in accordance with The Public Sector Apprenticeship Targets Regulations 2017. Public sector bodies, including local authorities in England, with 250 or more staff, publish data each year showing the number of new apprentices and existing employees starting an apprenticeship. This data shows Leicester City Council's figures including central and school employees. .","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonl","status":"ACTIVE","verification_state":"VERIFIED","tags":["government"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=data.leicester.gov.uk","primary_source_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonl","extraction_confidence":"0.16","created_at":"2026-06-19T02:14:06.679Z","updated_at":"2026-08-16T09:32:43.025Z","last_verified_at":"2026-08-16T09:32:43.025Z","deprecated_at":null,"ranking_score":56,"last_ranked_at":"2026-08-09T20:13:43.459Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-08-07T13:55:29.355Z","search_vector":"'2017':16B,26B,92B,100B,164B,174B,240B,248B '250':36B,107B,184B,255B 'a':231B 'accord':18B 'accordance':166B 'an':202B,276B 'and':198B,214B,272B,285B,288B 'annual':116B,143B,264B 'annually':291B 'apprentic':49B,123B 'apprentices':197B,271B 'apprenticeship':3A,8B,23B,55B,81B,97B,129B,151A,156B,171B,203B,229B,245B,277B 'april':15B,91B,163B,239B 'are':289B 'author':32B,113B 'authorities':180B,261B 'bodi':29B,103B 'bodies':177B,251B 'both':281B 'by':160B,234B,292B 'central':65B,134B,213B,282B 'citi':60B,73B,146B 'city':208B,221B,294B 'council':61B,74B,135B,147B,209B,222B,283B,295B 'cover':132B,280B 'data':41B,57B,117B,189B,205B,265B 'dataset':70B,218B 'each':190B 'employe':52B,68B,126B,136B,139B 'employees':200B,216B,274B,284B,287B 'england':34B,105B,182B,253B 'exist':51B,125B 'existing':199B,273B 'figur':63B,76B,131B 'figures':211B,224B,279B 'for':225B 'govern':13B,89B,148C 'government':161B,237B 'in':162B,165B,181B,238B,252B 'includ':30B,64B,111B 'including':178B,212B,259B 'introduc':11B,85B 'introduced':159B,233B 'leicest':59B,72B,145B 'leicester':207B,220B,293B 'local':31B,112B,179B,260B 'more':186B,257B 'must':114B,262B 'new':48B,122B,196B,270B 'number':46B,120B,194B,268B 'of':195B,269B 'on':266B 'or':185B,256B 'present':71B 'presents':219B 'public':1A,6B,21B,27B,79B,95B,101B,149A,154B,169B,175B,227B,243B,249B 'publish':40B,115B,142B,188B,263B 'published':290B 'regul':25B,99B 'regulations':173B,247B 'requir':84B 'requirement':232B 's':210B,223B 'school':67B,138B,215B,286B 'sector':2A,7B,22B,28B,80B,96B,102B,150A,155B,170B,176B,228B,244B,250B 'show':44B,58B 'showing':192B 'shows':206B 'staff':39B,110B,187B,258B 'start':53B,127B 'starting':201B,275B 'target':4A,9B,24B,82B,98B,157B,230B 'targets':152A,172B,246B 'the':153B,168B,193B,226B,235B,242B,267B,278B 'this':204B,217B 'uk':88B,236B 'under':241B 'was':158B 'with':167B,183B,254B 'year':43B,191B","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-19T02:14:06.679Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset presents Leicester City Council's figures for the public sector apprenticeship target, a requirement introduced by the UK government in April 2017 under the Public Sector Apprenticeship Targets Regulations 2017. Public sector bodies in England with 250 or more staff, including local authorities, must publish annual data on the number of new apprentices and existing employees starting an apprenticeship. The figures cover both central council employees and school employees, and are published annually by Leicester City Council.","native_lang":"en","access_level":"direct","formats":["CSV","JSON","N3","PARQUET","XLSX"],"capability_tier":"live","trust_score":34.94230769230769,"access":{"level":"direct","primary":{"kind":"download","label":"Download data","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonld","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download data","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonld","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonl","format":"JSON","source":"distribution","runnable":true},{"kind":"download","label":"Download N3","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/n3","format":"N3","source":"distribution","runnable":true},{"kind":"download","label":"Download XLSX","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/xlsx?use_labels=true","format":"XLSX","source":"distribution","runnable":true},{"kind":"download","label":"Download JSON","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/json","format":"JSON","source":"distribution","runnable":true},{"kind":"download","label":"Download PARQUET","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/parquet","format":"PARQUET","source":"distribution","runnable":true},{"kind":"download","label":"Download CSV","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/csv?use_labels=true","format":"CSV","source":"distribution","runnable":true},{"kind":"download","label":"Download data","method":"GET","url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/rdfxml","source":"distribution","runnable":true}],"formats":["CSV","JSON","N3","PARQUET","XLSX"]},"maturity":{"entry_id":"4e3ae8b7-8233-412f-8c02-95a611c92d46","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":"executable","level_index":4,"level_label":"Executable","meaning":"Queries run through Commodity","counts_as_coverage":true,"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":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":true,"reached":true,"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.leicester.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-16T13:57:45.898Z"},"api_details":null,"dataset_details":{"id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","entry_id":"4e3ae8b7-8233-412f-8c02-95a611c92d46","upstream_issued":null,"upstream_modified":null,"themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":null,"source_portal_url":null,"created_at":"2026-06-19T02:14:06.844Z","updated_at":"2026-07-09T07:44:13.025Z","publisher":"Leicester City Council","publisher_url":null,"distributions":[{"id":"9ce4a5f9-efb9-44d0-a1e3-d971afb98dd4","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.jsonld","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonld","download_url":null,"media_type":null,"format":null,"byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":"2026-08-16T09:32:41.271Z","is_available":true,"last_http_status":200,"created_at":"2026-06-19T02:14:07.167Z","updated_at":"2026-08-16T09:32:41.271Z"},{"id":"d952faac-7da9-48d8-a0b3-0a6f06ded79d","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.jsonl","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonl","download_url":null,"media_type":null,"format":"JSON","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:07.329Z","updated_at":"2026-06-19T02:14:07.329Z"},{"id":"2bf2408a-a66e-476b-ab62-251cd97b22b8","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.n3","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/n3","download_url":null,"media_type":null,"format":"N3","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:07.490Z","updated_at":"2026-06-19T02:14:07.490Z"},{"id":"7ff0ee86-2f3b-4b66-ad48-599edb8c2a36","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.xlsx","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/xlsx?use_labels=true","download_url":null,"media_type":null,"format":null,"byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:07.647Z","updated_at":"2026-06-19T02:14:07.647Z"},{"id":"274500a4-f336-463e-b971-6b19f48612a9","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.json","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/json","download_url":null,"media_type":null,"format":"JSON","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:07.809Z","updated_at":"2026-06-19T02:14:07.809Z"},{"id":"a831c4b7-704a-4c7d-bcdf-a21644e273a2","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.parquet","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/parquet","download_url":null,"media_type":null,"format":"Parquet","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:07.968Z","updated_at":"2026-06-19T02:14:07.968Z"},{"id":"ff8e2ae3-0cbf-477a-b6ab-f9370d79ae1c","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.csv","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/csv?use_labels=true","download_url":null,"media_type":null,"format":"CSV","byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:08.130Z","updated_at":"2026-06-19T02:14:08.130Z"},{"id":"b2959598-183d-496c-be90-38e9b795da86","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.rdf","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/rdfxml","download_url":null,"media_type":null,"format":null,"byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:08.287Z","updated_at":"2026-06-19T02:14:08.287Z"},{"id":"966cca55-d0b6-44a2-a0d4-2325b1fb17b0","dataset_details_id":"1bf4f4ae-1f72-41e1-87ec-800947f02e40","title":"public-sector-apprenticeship-targets.ttl","description":null,"access_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/turtle","download_url":null,"media_type":null,"format":null,"byte_size":null,"license_id":null,"license_raw":null,"last_checked_at":null,"is_available":null,"last_http_status":null,"created_at":"2026-06-19T02:14:08.449Z","updated_at":"2026-06-19T02:14:08.449Z"}],"license":null},"license":null,"reuse":{"license_id":null,"license_name":null,"license_url":null,"commercial_use":{"status":"unknown","value":null},"redistribution":{"status":"unknown","value":null},"attribution_required":{"status":"unknown","value":null},"share_alike":{"status":"unknown","value":null},"personal_data_warning":{"status":"unknown","value":null},"cache_and_mirror":{"status":"unknown","value":null},"undetermined":["commercial_use","redistribution","attribution_required","share_alike","personal_data_warning","cache_and_mirror"],"basis":"unverified","confidence":0.1,"confidence_tier":"low","source_text":null,"source_url":null,"reviewed_at":null},"license_raw":null,"latest_check":{"id":"0213bdcf-27a9-4b6e-bd37-2b3c6bc727fe","entry_id":"4e3ae8b7-8233-412f-8c02-95a611c92d46","status":"VERIFIED","last_checked_at":"2026-08-16T09:32:42.860Z","p50_latency_ms":1995,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-06-19T02:14:56.884Z","updated_at":"2026-08-16T09:32:42.860Z","consecutive_successes":145,"probe_url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/jsonld","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/ld+json; charset=utf-8","probe_succeeded_at":"2026-08-16T09:32:42.860Z"},"data_profile":{"id":"7fa05ba9-6dcc-429d-bcb9-5f58d29927a3","entry_id":"4e3ae8b7-8233-412f-8c02-95a611c92d46","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"Financial year from","type":"date","label":null,"description":null,"description_en":"Start date of the financial year covered by the record."},{"name":"Financial year to","type":"date","label":null,"description":null,"description_en":"End date of the financial year covered by the record."},{"name":"Measurement Date","type":"date","label":null,"description":null,"description_en":"Date on which the headcount figures were measured."},{"name":"Employees working in Leicester","type":"int","label":null,"description":null,"description_en":"Total number of council employees working in Leicester on the measurement date."},{"name":"New employees started working in Leicester","type":"int","label":null,"description":null,"description_en":"Number of new employees who started working in Leicester during the financial year."},{"name":"Apprentices working in Leicester","type":"int","label":null,"description":null,"description_en":"Number of apprentices employed in Leicester on the measurement date."},{"name":"Apprentices in Leicester (new and existing) during financial year","type":"int","label":null,"description":null,"description_en":"Total apprentices, both new starters and existing staff, during the financial year."},{"name":"Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of employment starts","type":"number","label":null,"description":null,"description_en":"Percentage of employment starts that were apprenticeship starts."},{"name":"Total headcount that were apprentices","type":"number","label":null,"description":null,"description_en":"Percentage of total employee headcount who were apprentices."},{"name":"Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of total headcount at end of previous financial year","type":"number","label":null,"description":null,"description_en":"Apprenticeship starts as a percentage of total headcount at the end of the prior financial year."}],"field_count":10,"sample_records":[{"Measurement Date":"2021-03-31","Financial year to":"","Financial year from":"","Employees working in Leicester":"11730","Apprentices working in Leicester":"203","Total headcount that were apprentices":"1.73","New employees started working in Leicester":"","Apprentices in Leicester (new and existing) during financial year":"","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of employment starts":"","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of total headcount at end of previous financial year":""},{"Measurement Date":"2021-03-31","Financial year to":"2021-03-31","Financial year from":"2020-04-01","Employees working in Leicester":"","Apprentices working in Leicester":"","Total headcount that were apprentices":"","New employees started working in Leicester":"1372","Apprentices in Leicester (new and existing) during financial year":"197","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of employment starts":"14.36","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of total headcount at end of previous financial year":""},{"Measurement Date":"2020-03-31","Financial year to":"2021-03-31","Financial year from":"2020-04-01","Employees working in Leicester":"","Apprentices working in Leicester":"","Total headcount that were apprentices":"","New employees started working in Leicester":"","Apprentices in Leicester (new and existing) during financial year":"","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of employment starts":"","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of total headcount at end of previous financial year":"1.76"},{"Measurement Date":"2020-03-31","Financial year to":"","Financial year from":"","Employees working in Leicester":"11208","Apprentices working in Leicester":"190","Total headcount that were apprentices":"","New employees started working in Leicester":"","Apprentices in Leicester (new and existing) during financial year":"","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of employment starts":"","Apprenticeship starts (both new hires and existing employees who started an apprenticeship) as a proportion of total headcount at end of previous financial year":""}],"record_count":null,"data_size_bytes":"720","dataset_count":null,"query_examples":[{"url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/csv?use_labels=true","curl":"curl -sL 'https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/csv?use_labels=true' -o data.csv","label":"Download distribution","method":"GET","description":"Full csv file download — the schema shown was inferred from the file's first records."},{"url":"https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/csv?use_labels=true","curl":"curl -sL 'https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/public-sector-apprenticeship-targets/exports/csv?use_labels=true' -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-25T13:13:15.445Z","run_id":"ff12a34d-06b4-4cc3-be3f-374b288a2921","created_at":"2026-06-19T02:30:04.845Z","updated_at":"2026-07-25T13:13:15.445Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true},"datasets":[],"limits":[]}