{"id":"e4bda04c-21eb-4dd9-9763-eac765dc9c70","type":"DATASET","name":"Organogram of Staff Roles & Salaries","slug":"organogram-of-staff-roles-salaries-1","description":"Organogram (organisation chart) showing all staff roles. Names and salaries are also listed for the Senior Civil Servants. Organogram data is released by all central government departments and their agencies since 2010. Snapshots for 31st March and 30th September are published by 6th June and 6th December each year. The published data is validated and released in CSV format and OGL-licensed for reuse. For more information about this series, see: http://guidance.data.gov.uk/organogram-data.html.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":null,"docs_url":null,"repo_url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","status":"ACTIVE","verification_state":"VERIFIED","tags":["government"],"logo_url":"https://www.google.com/s2/favicons?sz=64&domain=s3-eu-west-1.amazonaws.com","primary_source_url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","extraction_confidence":"0.16","created_at":"2026-07-30T13:42:20.558Z","updated_at":"2026-10-12T20:48:55.866Z","last_verified_at":"2026-10-12T18:15:03.134Z","deprecated_at":null,"ranking_score":38,"last_ranked_at":"2026-10-01T16:49:06.071Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-04T23:59:24.281Z","search_vector":"'/organogram-data.html.':80B,256B '2010':37B,107B,213B,283B '30':116B,292B '30th':43B,219B '31':113B,289B '31st':40B,216B '6':122B,125B,298B,301B '6th':48B,51B,224B,227B 'a':336B 'about':250B 'across':88B,171B,264B,347B 'agenc':35B,96B 'agencies':211B,272B 'all':186B,205B,265B 'allow':143B 'allowing':319B 'also':17B,193B 'and':190B,209B,218B,226B,236B,241B,270B,275B,291B,300B,309B,334B,344B 'are':192B,221B 'as':287B 'before':307B 'bodi':173B 'bodies':349B 'by':204B,223B,297B,328B 'captur':109B 'captures':285B 'central':30B,90B,206B,266B 'chart':8B,184B 'civil':22B,103B,198B,279B 'consist':161B 'consistent':337B 'coordin':151B 'coordinated':327B 'csv':63B,136B,239B,312B 'data':25B,57B,128B,201B,233B,304B 'dataset':82B,258B 'decemb':52B,126B 'december':228B,302B 'depart':32B,93B 'departments':208B,269B 'each':229B,294B 'for':195B,215B,245B,247B,277B,331B 'format':64B,137B,240B,313B 'free':144B,320B 'govern':31B,92B,141B,172B,176C 'government':207B,268B,317B,348B 'guidanc':150B 'guidance':326B 'guidance.data.gov.uk':79B,255B 'guidance.data.gov.uk/organogram-data.html.':78B,254B 'in':238B,311B 'includ':97B 'including':273B 'inform':73B 'information':249B 'is':202B,234B,305B,323B 'it':284B,322B 'june':49B,123B,225B,299B 'licenc':142B 'licence':318B 'licens':68B 'licensed':244B 'list':18B 'listed':194B 'maintain':148B 'maintained':324B 'march':41B,114B,217B,290B 'more':248B 'name':13B,98B 'names':189B,274B 'nation':156B 'national':332B 'of':178A,288B,339B 'offer':159B 'offers':335B 'offic':154B 'office':330B 'ogl':67B,243B 'ogl-licens':66B 'ogl-licensed':242B 'open':140B,316B 'organis':7B 'organisation':183B 'organogram':1A,6B,24B,84B,177A,182B,200B 'organograms':260B 'over':350B 'pay':170B,346B 'provid':83B,134B 'provided':310B 'provides':259B 'public':164B,340B 'publish':46B,56B,105B 'published':222B,232B,281B 'releas':27B,61B,120B,132B 'release':308B 'released':203B,237B,296B 'respect':127B 'respectively':303B 'reus':70B,145B 'reuse':246B,321B 'role':4A,12B,87B 'roles':180A,188B,263B 'salari':5A,15B,100B 'salaries':181A,191B,276B 'sector':165B,341B 'see':77B,253B 'senior':21B,102B,169B,197B,278B,345B 'septemb':44B,117B 'september':220B,293B 'seri':76B 'series':252B 'servant':23B,104B 'servants':199B,280B 'show':9B,85B 'showing':185B,261B 'sinc':36B,106B 'since':212B,282B 'snapshot':38B,110B 'snapshots':214B,286B 'staf':166B 'staff':3A,11B,86B,179A,187B,262B 'staffing':342B 'statist':157B 'statistics':333B 'structur':167B 'structures':343B 'the':196B,231B,315B,329B 'their':210B,271B 'this':251B,257B 'time':175B,351B 'uk':91B,267B 'under':314B,325B 'valid':59B,130B 'validated':235B,306B 'view':162B,338B 'year':54B,119B,230B,295B","popularity_score":"0.0000","maintenance_score":"0.5000","institution_id":"53e1bda8-6b71-4db1-98f0-095339ef1ba1","institution_type":"STATISTICS_OFFICE","country_code":null,"official_confidence":null,"proof_summary":null,"source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-31T18:35:35.168Z","geographic_scope":"NATIONAL","name_en":null,"description_en":"This dataset provides organograms showing staff roles across all central UK government departments and their agencies, including names and salaries for Senior Civil Servants. Published since 2010, it captures snapshots as of 31 March and 30 September each year, released by 6 June and 6 December respectively. Data is validated before release and provided in CSV format under the Open Government Licence, allowing free reuse. It is maintained under guidance coordinated by the Office for National Statistics, and offers a consistent view of public sector staffing structures and senior pay across government bodies over time.","native_lang":"en","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":52.98076923076923,"merged_into_entry_id":null,"identity_key":"DATASET|https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv|organogram of staff roles & salaries","upstream_ref":null,"content_changed_at":"2026-10-12T16:58:04.069Z","title_qualifier":"office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","access":{"level":"direct","primary":{"kind":"download","label":"Download CSV","method":"GET","url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","format":"CSV","source":"distribution","runnable":true},"actions":[{"kind":"download","label":"Download CSV","method":"GET","url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","format":"CSV","source":"distribution","runnable":true},{"kind":"download","label":"Download CSV","method":"GET","url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-senior.csv","format":"CSV","source":"distribution","runnable":true}],"formats":["CSV"]},"maturity":{"entry_id":"e4bda04c-21eb-4dd9-9763-eac765dc9c70","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":"53e1bda8-6b71-4db1-98f0-095339ef1ba1","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":"s3-eu-west-1.amazonaws.com","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-10-12T22:47:23.468Z"},"api_details":null,"dataset_details":{"id":"42badf62-9513-4b8f-8447-d03b91c8149d","entry_id":"e4bda04c-21eb-4dd9-9763-eac765dc9c70","upstream_issued":null,"upstream_modified":null,"themes":["GOVE"],"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-30T13:42:20.739Z","updated_at":"2026-07-30T13:42:20.739Z","publisher":"Office for National Statistics","publisher_url":null,"distributions":[{"id":"194626fc-4230-43c9-99ac-b725aefab725","dataset_details_id":"42badf62-9513-4b8f-8447-d03b91c8149d","title":null,"description":null,"access_url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.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-10-12T18:15:01.679Z","is_available":true,"last_http_status":200,"created_at":"2026-07-30T13:42:21.070Z","updated_at":"2026-10-12T18:15:01.679Z"},{"id":"2a0dc15d-e84a-41e9-9681-b3b7b07d8b24","dataset_details_id":"42badf62-9513-4b8f-8447-d03b91c8149d","title":null,"description":null,"access_url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-senior.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-10-05T18:36:46.941Z","is_available":true,"last_http_status":200,"created_at":"2026-07-30T13:42:21.231Z","updated_at":"2026-10-05T18:36:46.941Z"}],"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":"bde454ce-a1f1-4945-8101-d23530f8de9d","entry_id":"e4bda04c-21eb-4dd9-9763-eac765dc9c70","status":"VERIFIED","last_checked_at":"2026-10-12T18:15:02.867Z","p50_latency_ms":1468,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-30T13:48:18.994Z","updated_at":"2026-10-12T18:15:02.867Z","consecutive_successes":109,"probe_url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","probe_method":"GET","probe_http_status":200,"probe_content_type":"text/csv","probe_succeeded_at":"2026-10-12T18:15:02.867Z"},"data_profile":{"id":"e9484af3-de80-4e86-8d69-46f02c8f586c","entry_id":"e4bda04c-21eb-4dd9-9763-eac765dc9c70","profile_source":"distribution","profile_kind":"dataset","dataset_id":null,"fields":[{"name":"Parent Department","type":"text","label":null,"description":null,"description_en":"Name of the central government department overseeing the organisation."},{"name":"Organisation","type":"text","label":null,"description":null,"description_en":"Name of the government organisation or agency."},{"name":"Unit","type":"text","label":null,"description":null,"description_en":"Name of the internal unit or division within the organisation."},{"name":"Reporting Senior Post","type":"int","label":null,"description":null,"description_en":"Identifier of the senior post that this role reports to."},{"name":"Grade","type":"text","label":null,"description":null,"description_en":"Civil service grade of the role."},{"name":"Payscale Minimum (£)","type":"int","label":null,"description":null,"description_en":"Minimum salary in pounds sterling for this grade."},{"name":"Payscale Maximum (£)","type":"int","label":null,"description":null,"description_en":"Maximum salary in pounds sterling for this grade."},{"name":"Generic Job Title","type":"text","label":null,"description":null,"description_en":"Standard job title used for the role."},{"name":"Number of Posts in FTE","type":"number","label":null,"description":null,"description_en":"Number of posts expressed as full-time equivalent staff."},{"name":"Professional/Occupational Group","type":"text","label":null,"description":null,"description_en":"Professional or occupational category the role belongs to."}],"field_count":10,"sample_records":[{"Unit":"Corporate Services","Grade":"AA","Organisation":"Office For National Statistics","Generic Job Title":"Administrative assistant","Parent Department":"UK Statistics Authority","Payscale Maximum (£)":"15164","Payscale Minimum (£)":"13941","Reporting Senior Post":"32","Number of Posts in FTE":"0.65","Professional/Occupational Group":"Operational Delivery"},{"Unit":"Corporate Services","Grade":"AO","Organisation":"Office For National Statistics","Generic Job Title":"Administrative Officer","Parent Department":"UK Statistics Authority","Payscale Maximum (£)":"21267","Payscale Minimum (£)":"15631","Reporting Senior Post":"32","Number of Posts in FTE":"6.57","Professional/Occupational Group":"Finance"},{"Unit":"Corporate Services","Grade":"EO","Organisation":"Office For National Statistics","Generic Job Title":"Executive Officer","Parent Department":"UK Statistics Authority","Payscale Maximum (£)":"29147","Payscale Minimum (£)":"20239","Reporting Senior Post":"32","Number of Posts in FTE":"13.40","Professional/Occupational Group":"Finance"},{"Unit":"Corporate Services","Grade":"EO","Organisation":"Office For National Statistics","Generic Job Title":"Executive Officer","Parent Department":"UK Statistics Authority","Payscale Maximum (£)":"29147","Payscale Minimum (£)":"20239","Reporting Senior Post":"32","Number of Posts in FTE":"2.57","Professional/Occupational Group":"Operational Delivery"},{"Unit":"Corporate Services","Grade":"Grade 6","Organisation":"Office For National Statistics","Generic Job Title":"Grade 6","Parent Department":"UK Statistics Authority","Payscale Maximum (£)":"67360","Payscale Minimum (£)":"48867","Reporting Senior Post":"32","Number of Posts in FTE":"2.00","Professional/Occupational Group":"Finance"}],"record_count":null,"data_size_bytes":"69088","dataset_count":null,"query_examples":[{"url":"https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","curl":"curl -sL 'https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv' -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://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv","curl":"curl -sL 'https://s3-eu-west-1.amazonaws.com/datagovuk-production-ckan-organogram/legacy/organogram/office-for-national-statistics/31/03/2012/office-for-national-statistics__31-03-2012__statistics_UK-Statistics-Authority-310312v8_1-junior.csv' -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-10-08T20:03:34.789Z","run_id":"64aadb88-b4a5-4a6b-b601-14c53ffc416f","created_at":"2026-07-30T13:46:54.115Z","updated_at":"2026-10-08T20:03:34.789Z","license_raw":null,"license_id":null,"consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"none","basis":"no_person_column_cited","grain":"none","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":["Number of Posts in FTE"],"entity_identifiers":[]},"publication":null,"publication_evidence":null,"notice":"personal data: no cited column names a natural person (the cited columns are all this reads)"}},"datasets":[],"limits":[],"manifest":{"answer_sha256":"b352b15d413a1dac45e28b523189ff548182e845f61b9528868f9c50d2d378b2","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":28,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: data_profile.fields[] (10 rows).","live":false,"live_basis":"This body was replayed from the worker edge cache (x-edge-cache: hit); the bytes, and therefore answer_sha256, are those of the execution that filled the cache.","created_at":"2026-10-12T22:47:56.358Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}