query_dataset
Query DfE Explore Education Statistics datasets using indicator and filter IDs to retrieve UK school data on absence, exclusions, performance, admissions, and workforce.
Instructions
Query a DfE Explore Education Statistics dataset with specific indicators and filters. Use get_dataset_metadata first to discover available indicator and filter IDs. This tool enables access to school-level data on absence, exclusions, performance, admissions, workforce, and more. Time periods use format 'YYYY|CODE' where CODE is: AY (academic year), CY (calendar year), FY (financial year), etc. Geographic levels include: NAT (national), REG (regional), LA (local authority), SCH (school). Locations use format 'LEVEL|id_type|id_value' e.g. 'LA|code|823'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (default: 1) | |
| filters | No | Filter option IDs (from get_dataset_metadata) | |
| locations | No | Locations in 'LEVEL|id_type|id_value' format | |
| page_size | No | Results per page (default: 100, max: 1000) | |
| dataset_id | Yes | Dataset ID from get_publication_datasets | |
| indicators | Yes | List of indicator IDs to retrieve (from get_dataset_metadata) | |
| time_periods | No | Time periods in 'YYYY|CODE' format, e.g. ['2023|AY'] | |
| geographic_levels | No | Geographic levels: NAT, REG, LA, SCH, etc. |