Query a data set
query_dataset.RdCreate and send a query to the EES API. Queries can be supplied and run in one of 4 ways:
Supplying a json query in a file to be sent with the POST method.
Supplying a json query in a string variable to be sent with the POST method.
Supplying parameters (time_periods, geographies, filter_items, indicators) to build a json query is then sent with the POST method.
Supplying parameters (time_periods, geographies, filter_items, indicators) to build a json query is then sent with the GET method.
In all cases, the data set id must be supplied explicitly using the dataset_id.
Details on the format of each parameter for the latter two methods are as follows.
indicators
This must be supplied as a vector of sqids, which can be identified from the meta data using
get_meta().
time_periods
Time periods should be supplied as a vector of periods and codes in the form:
"period|code"
For example, selecting the 2023 and 2024 academic years would require:
time_period = c("2023|AY", "2024|AY")
geographies
Geographies can be supplied as a vector or a data frame depending on the complexity of the desired query.
A vector will run a query returning any rows meeting any of the given
geographies, i.e. geographies = c("NAT", "REG") will return all national and regional level
rows, whilst c("NAT", "REG|code|E120000001") will return all national level rows and all North
East rows. Specific locations are required to be supplied in the format
"LEVEL|identifier_type|identifier", where identifier type can be either code or id and the
corresponding identifier is then the standard ONS code or the sqid given in the meta data
respectively. Using England as an example, these would be:
"NAT|code|E92000001""NAT|id|dP0Zw"
If you require a more complex selection, for example all LAs in a given region, then a data
frame should be supplied, with a row for each selection. Note however, that this will only work
when using the default POST method. The GET method is much more limited and can not process
more complex queries.
The geography query data frame should contain the following columns:
return_level: the geographic level to return (e.g. LA in the example above).
search_level: the geographic level of the search location (e.g. REG in the example above).
identifier_type: "code" or "id".
identifier: the code or id (sqid) for the search location (e.g. the code or sqid of the region in the above example).
Further rows can be added to add other geography searches to include in results.
An example of a working geographies data frame can be obtained using example_geography_query().
filter_items
Similarly to geographies, criteria for querying on filter items can be provided either via a
vector for simple queries or, for more complex queries, as a list. In both cases, vector or
list, filter items can only be supplied as sqids, i.e. the ids found in the meta data using
get_meta(dataset_id).
Providing a vector of sqids will effectively run a query returning any rows containing any of the listed sqids. This therefore does not allow narrow searches based on a row or set of rows matching multiple criteria.
Providing a list structure can provide a more narrow query selecting individual rows based on
a combination of criteria. For example if we want rows that contain sqid1 in one column and
sqid2 in another, then we would pass a list of:
filter_query <- list(column1 = c("sqid1"), column2 = c("sqid2"))
Note that the naming of the entries in the list is not necessary, but may help in creating more
readable code.
If we wish to create a query whereby we receive rows containing sqid1 in column 1 and sqid2 or
sqid3 in column 2, then the required list would be:
filter_query <- list(column1 = c("sqid1"), column2 = c("sqid2", "sqid3"))
In this way, we can build up combinations of OR and AND criteria for a query across multiple filter columns.
Note again that the more complex querying using a list variable will only function when using
the POST method.
Controlling paging
You can request a specific set of rows using the page and page_size parameters. Keeping the default of page = NULL will return all rows matching the query. Setting page and page_size to numerical values will attempt to return a subset of rows, with page_size defining the number of rows and page defining which subset of rows to return from the query (i.e. page = 1, page_size = 20 will return the first 20 rows, page = 2 and page_size = 20 will return the second 20 rows and so on).
Usage
query_dataset(
dataset_id,
indicators = NULL,
time_periods = NULL,
geographies = NULL,
geographic_levels = NULL,
locations = NULL,
filter_items = NULL,
json_query = NULL,
method = "POST",
dataset_version = NULL,
ees_environment = NULL,
api_version = NULL,
page_size = 10000,
page = NULL,
debug = FALSE,
verbose = FALSE
)Arguments
- dataset_id
ID of data set to be connected to. This is required if the endpoint is one of "get-summary", "get-meta", "get-csv", "get-data" or "post-data"
- indicators
Indicators required as a string or vector of strings (required)
- time_periods
Time periods required as a string ("period|code") or vector of strings
- geographies
String, vector or data frame containing the geographic levels and locations to be queried.
- geographic_levels
Geographic levels required as a string or vector of strings
- locations
Location code required as a string or vector of strings
- filter_items
Filter items required as a string or vector of strings
- json_query
Optional path to a json file containing the query parameters
- method
The API query method to be used. Can be "POST" or "GET". Default: "POST".
- dataset_version
Version of data set to be connected to
- ees_environment
EES ees_environment to connect to: "dev", "test", "preprod" or "prod"
- api_version
EES API version
- page_size
Number of results to return in a single query
- page
Page number of query results to return
- debug
Run POST query in debug mode. Logical, default = FALSE
- verbose
Run with additional contextual messaging. Logical, default = FALSE
Examples
# Run query_dataset() using a json query string input to json_query (this can also be done by
# passing a filename of a file containing your json query string).
query_dataset(
example_id(group = "attendance"),
json_query = example_json_query()
)
#> code period geographic_level nat_name nat_code reg_name reg_code
#> 1 W23 2024 REG England E92000001 North East E12000001
#> 2 W23 2024 REG England E92000001 North East E12000001
#> 3 W23 2024 REG England E92000001 North West E12000002
#> 4 W23 2024 REG England E92000001 North West E12000002
#> 5 W23 2024 REG England E92000001 North East E12000001
#> 6 W23 2024 REG England E92000001 North East E12000001
#> 7 W23 2024 REG England E92000001 North West E12000002
#> 8 W23 2024 REG England E92000001 North West E12000002
#> attendance_status attendance_type day_number education_phase
#> 1 Absence Authorised Total Secondary
#> 2 Absence Unauthorised Total Secondary
#> 3 Absence Authorised Total Secondary
#> 4 Absence Unauthorised Total Secondary
#> 5 Absence Authorised Total Total
#> 6 Absence Unauthorised Total Total
#> 7 Absence Authorised Total Total
#> 8 Absence Unauthorised Total Total
#> attendance_reason session_count
#> 1 Total 53326
#> 2 Total 64441
#> 3 Total 152262
#> 4 Total 167394
#> 5 Total 107165
#> 6 Total 117871
#> 7 Total 273327
#> 8 Total 273633
# If you don't want to have to write your own json query, the rest of the examples illustrate
# how to use query_dataset() with parameters to construct queries in R.
# Run query_dataset() to select rows containing either of two geographic locations and either of
# two filter items.
query_dataset(
example_id(group = "attendance"),
indicators = example_id("indicator", group = "attendance"),
time_periods = example_id("time_period", group = "attendance"),
geographies = example_id("location_code", group = "attendance"),
filter_items = example_id("filter_item", group = "attendance"),
page = 1,
page_size = 32
)
#> code period geographic_level nat_name nat_code attendance_status
#> 1 W23 2024 NAT England E92000001 Absence
#> 2 W23 2024 NAT England E92000001 Absence
#> 3 W23 2024 NAT England E92000001 Absence
#> 4 W23 2024 NAT England E92000001 Absence
#> 5 W23 2024 NAT England E92000001 Absence
#> 6 W23 2024 NAT England E92000001 Absence
#> 7 W23 2024 NAT England E92000001 Absence
#> 8 W23 2024 NAT England E92000001 Absence
#> 9 W23 2024 NAT England E92000001 Absence
#> 10 W23 2024 NAT England E92000001 Absence
#> 11 W23 2024 NAT England E92000001 Absence
#> 12 W23 2024 NAT England E92000001 Absence
#> 13 W23 2024 NAT England E92000001 Absence
#> 14 W23 2024 NAT England E92000001 Absence
#> 15 W23 2024 NAT England E92000001 Absence
#> 16 W23 2024 NAT England E92000001 Absence
#> 17 W23 2024 NAT England E92000001 Absence
#> 18 W23 2024 NAT England E92000001 Absence
#> 19 W23 2024 NAT England E92000001 Absence
#> 20 W23 2024 NAT England E92000001 Absence
#> 21 W23 2024 NAT England E92000001 Absence
#> 22 W23 2024 NAT England E92000001 Absence
#> 23 W23 2024 NAT England E92000001 Absence
#> 24 W23 2024 NAT England E92000001 Absence
#> attendance_type day_number education_phase attendance_reason
#> 1 Unauthorised 1 Special G unauthorised holiday
#> 2 Unauthorised 1 Primary G unauthorised holiday
#> 3 Unauthorised 1 Secondary G unauthorised holiday
#> 4 Unauthorised 2 Special G unauthorised holiday
#> 5 Unauthorised 2 Primary G unauthorised holiday
#> 6 Unauthorised 2 Secondary G unauthorised holiday
#> 7 Unauthorised 3 Secondary G unauthorised holiday
#> 8 Unauthorised 3 Special G unauthorised holiday
#> 9 Unauthorised 3 Primary G unauthorised holiday
#> 10 Unauthorised 4 Secondary G unauthorised holiday
#> 11 Unauthorised 4 Primary G unauthorised holiday
#> 12 Unauthorised 4 Special G unauthorised holiday
#> 13 Unauthorised 5 Secondary G unauthorised holiday
#> 14 Unauthorised 5 Special G unauthorised holiday
#> 15 Unauthorised 5 Primary G unauthorised holiday
#> 16 Unauthorised Total Special G unauthorised holiday
#> 17 Unauthorised Total Primary G unauthorised holiday
#> 18 Unauthorised Total Secondary G unauthorised holiday
#> 19 Unauthorised 2 Total G unauthorised holiday
#> 20 Unauthorised 3 Total G unauthorised holiday
#> 21 Unauthorised 4 Total G unauthorised holiday
#> 22 Unauthorised 5 Total G unauthorised holiday
#> 23 Unauthorised Total Total G unauthorised holiday
#> 24 Unauthorised 1 Total G unauthorised holiday
#> session_count
#> 1 1574
#> 2 84811
#> 3 44458
#> 4 1443
#> 5 98308
#> 6 37788
#> 7 33274
#> 8 1372
#> 9 86219
#> 10 29610
#> 11 75852
#> 12 1345
#> 13 29339
#> 14 1410
#> 15 77983
#> 16 7144
#> 17 423173
#> 18 174469
#> 19 137539
#> 20 120865
#> 21 106807
#> 22 108732
#> 23 604786
#> 24 130843
# Run query_dataset() using set parameters giving a combination of filter options
example_id("filter_items_short", group = "attendance")
#> $attendance_status
#> [1] "qGJjG"
#>
#> $attendance_type
#> [1] "cZO31" "jgoAM"
#>
#> $education_phase
#> [1] "Poqeb" "dPE0Z"
#>
#> $day_number
#> [1] "AOhGK"
#>
#> $reason
#> [1] "9Ru4v"
#>
query_dataset(
example_id(group = "attendance"),
indicators = example_id("indicator", group = "attendance"),
time_periods = example_id("time_period", group = "attendance"),
geographies = c("NAT"),
filter_items = example_id("filter_items_short", group = "attendance")
)
#> code period geographic_level nat_name nat_code attendance_status
#> 1 W23 2024 NAT England E92000001 Absence
#> 2 W23 2024 NAT England E92000001 Absence
#> 3 W23 2024 NAT England E92000001 Absence
#> 4 W23 2024 NAT England E92000001 Absence
#> attendance_type day_number education_phase attendance_reason session_count
#> 1 Authorised Total Secondary Total 1093633
#> 2 Unauthorised Total Secondary Total 956076
#> 3 Authorised Total Total Total 2249424
#> 4 Unauthorised Total Total Total 1784927
# Run a query with a more complex geography selection. Return data for all of:
# - England
# - Yorkshire and the Humber
# - All LAs in Yorkshire and the Humber
example_geography_query("nat_yorks_yorkslas")
#> return_level search_level identifier_type identifier
#> 1 NAT NAT code E92000001
#> 2 REG REG code E12000003
#> 3 LA REG code E12000003
query_dataset(
example_id(group = "attendance"),
indicators = example_id("indicator", group = "attendance"),
time_periods = example_id("time_period", group = "attendance"),
geographies = example_geography_query("nat_yorks_yorkslas"),
filter_items = example_id("filter_item", group = "attendance")
)
#> code period geographic_level la_name la_code
#> 1 W23 2024 LA Kirklees E08000034
#> 2 W23 2024 LA Leeds E08000035
#> 3 W23 2024 LA York E06000014
#> 4 W23 2024 LA North Yorkshire E06000065
#> 5 W23 2024 LA Doncaster E08000017
#> 6 W23 2024 LA North Lincolnshire E06000013
#> 7 W23 2024 LA North East Lincolnshire E06000012
#> 8 W23 2024 LA Calderdale E08000033
#> 9 W23 2024 LA East Riding of Yorkshire E06000011
#> 10 W23 2024 LA North East Lincolnshire E06000012
#> 11 W23 2024 LA Kirklees E08000034
#> 12 W23 2024 LA Doncaster E08000017
#> 13 W23 2024 LA East Riding of Yorkshire E06000011
#> 14 W23 2024 LA Barnsley E08000016
#> 15 W23 2024 LA Rotherham E08000018
#> 16 W23 2024 LA Calderdale E08000033
#> 17 W23 2024 LA Bradford E08000032
#> 18 W23 2024 LA Bradford E08000032
#> 19 W23 2024 LA Rotherham E08000018
#> 20 W23 2024 LA Barnsley E08000016
#> 21 W23 2024 LA Kingston upon Hull, City of E06000010
#> 22 W23 2024 LA Doncaster E08000017
#> 23 W23 2024 LA North Lincolnshire E06000013
#> 24 W23 2024 LA North Yorkshire E06000065
#> 25 W23 2024 LA Leeds E08000035
#> 26 W23 2024 LA Rotherham E08000018
#> 27 W23 2024 LA Wakefield E08000036
#> 28 W23 2024 LA North Lincolnshire E06000013
#> 29 W23 2024 LA Kingston upon Hull, City of E06000010
#> 30 W23 2024 LA York E06000014
#> 31 W23 2024 LA York E06000014
#> 32 W23 2024 LA Wakefield E08000036
#> 33 W23 2024 LA Sheffield E08000019
#> 34 W23 2024 LA Bradford E08000032
#> 35 W23 2024 LA East Riding of Yorkshire E06000011
#> 36 W23 2024 LA Leeds E08000035
#> 37 W23 2024 LA Barnsley E08000016
#> 38 W23 2024 LA North Yorkshire E06000065
#> 39 W23 2024 LA Wakefield E08000036
#> 40 W23 2024 LA Calderdale E08000033
#> 41 W23 2024 LA Sheffield E08000019
#> 42 W23 2024 LA Kingston upon Hull, City of E06000010
#> 43 W23 2024 LA North East Lincolnshire E06000012
#> 44 W23 2024 LA Sheffield E08000019
#> 45 W23 2024 LA Kirklees E08000034
#> 46 W23 2024 REG <NA> <NA>
#> 47 W23 2024 REG <NA> <NA>
#> 48 W23 2024 REG <NA> <NA>
#> 49 W23 2024 LA Rotherham E08000018
#> 50 W23 2024 LA Rotherham E08000018
#> 51 W23 2024 LA Barnsley E08000016
#> 52 W23 2024 LA York E06000014
#> 53 W23 2024 LA Kingston upon Hull, City of E06000010
#> 54 W23 2024 LA Kirklees E08000034
#> 55 W23 2024 NAT <NA> <NA>
#> 56 W23 2024 NAT <NA> <NA>
#> 57 W23 2024 NAT <NA> <NA>
#> 58 W23 2024 LA North Yorkshire E06000065
#> 59 W23 2024 LA York E06000014
#> 60 W23 2024 LA Wakefield E08000036
#> 61 W23 2024 LA East Riding of Yorkshire E06000011
#> 62 W23 2024 LA Kirklees E08000034
#> 63 W23 2024 LA North Yorkshire E06000065
#> 64 W23 2024 LA Sheffield E08000019
#> 65 W23 2024 LA Calderdale E08000033
#> 66 W23 2024 LA York E06000014
#> 67 W23 2024 LA North East Lincolnshire E06000012
#> 68 W23 2024 LA Bradford E08000032
#> 69 W23 2024 LA East Riding of Yorkshire E06000011
#> 70 W23 2024 LA East Riding of Yorkshire E06000011
#> 71 W23 2024 LA Barnsley E08000016
#> 72 W23 2024 LA North East Lincolnshire E06000012
#> 73 W23 2024 LA Doncaster E08000017
#> 74 W23 2024 LA Kingston upon Hull, City of E06000010
#> 75 W23 2024 LA Kirklees E08000034
#> 76 W23 2024 LA North Lincolnshire E06000013
#> 77 W23 2024 LA Sheffield E08000019
#> 78 W23 2024 LA North East Lincolnshire E06000012
#> 79 W23 2024 LA Doncaster E08000017
#> 80 W23 2024 LA Sheffield E08000019
#> 81 W23 2024 LA Leeds E08000035
#> 82 W23 2024 LA Doncaster E08000017
#> 83 W23 2024 LA North Lincolnshire E06000013
#> 84 W23 2024 LA Barnsley E08000016
#> 85 W23 2024 LA Bradford E08000032
#> 86 W23 2024 LA Wakefield E08000036
#> 87 W23 2024 LA North Yorkshire E06000065
#> 88 W23 2024 LA North Lincolnshire E06000013
#> 89 W23 2024 LA Leeds E08000035
#> 90 W23 2024 LA Leeds E08000035
#> 91 W23 2024 LA Kingston upon Hull, City of E06000010
#> 92 W23 2024 LA Wakefield E08000036
#> 93 W23 2024 LA Calderdale E08000033
#> 94 W23 2024 LA Rotherham E08000018
#> 95 W23 2024 LA Bradford E08000032
#> 96 W23 2024 LA Calderdale E08000033
#> 97 W23 2024 LA Kingston upon Hull, City of E06000010
#> 98 W23 2024 REG <NA> <NA>
#> 99 W23 2024 REG <NA> <NA>
#> 100 W23 2024 REG <NA> <NA>
#> 101 W23 2024 NAT <NA> <NA>
#> 102 W23 2024 NAT <NA> <NA>
#> 103 W23 2024 NAT <NA> <NA>
#> 104 W23 2024 LA York E06000014
#> 105 W23 2024 LA Sheffield E08000019
#> 106 W23 2024 LA Barnsley E08000016
#> 107 W23 2024 LA North East Lincolnshire E06000012
#> 108 W23 2024 LA North Lincolnshire E06000013
#> 109 W23 2024 LA Kirklees E08000034
#> 110 W23 2024 LA Kingston upon Hull, City of E06000010
#> 111 W23 2024 LA East Riding of Yorkshire E06000011
#> 112 W23 2024 LA North East Lincolnshire E06000012
#> 113 W23 2024 LA North East Lincolnshire E06000012
#> 114 W23 2024 LA Wakefield E08000036
#> 115 W23 2024 LA Bradford E08000032
#> 116 W23 2024 LA Kingston upon Hull, City of E06000010
#> 117 W23 2024 LA Rotherham E08000018
#> 118 W23 2024 LA Bradford E08000032
#> 119 W23 2024 LA Leeds E08000035
#> 120 W23 2024 LA Leeds E08000035
#> 121 W23 2024 LA York E06000014
#> 122 W23 2024 LA York E06000014
#> 123 W23 2024 LA Barnsley E08000016
#> 124 W23 2024 LA Calderdale E08000033
#> 125 W23 2024 LA Wakefield E08000036
#> 126 W23 2024 LA East Riding of Yorkshire E06000011
#> 127 W23 2024 LA East Riding of Yorkshire E06000011
#> 128 W23 2024 LA Bradford E08000032
#> 129 W23 2024 LA North Lincolnshire E06000013
#> 130 W23 2024 LA Sheffield E08000019
#> 131 W23 2024 LA Kirklees E08000034
#> 132 W23 2024 LA Calderdale E08000033
#> 133 W23 2024 LA Rotherham E08000018
#> 134 W23 2024 LA Doncaster E08000017
#> 135 W23 2024 LA North Lincolnshire E06000013
#> 136 W23 2024 LA North Yorkshire E06000065
#> 137 W23 2024 LA Leeds E08000035
#> 138 W23 2024 LA Doncaster E08000017
#> 139 W23 2024 LA Sheffield E08000019
#> 140 W23 2024 LA Rotherham E08000018
#> 141 W23 2024 LA Calderdale E08000033
#> 142 W23 2024 LA Wakefield E08000036
#> 143 W23 2024 LA Doncaster E08000017
#> 144 W23 2024 LA North Yorkshire E06000065
#> 145 W23 2024 LA North Yorkshire E06000065
#> 146 W23 2024 LA Kirklees E08000034
#> 147 W23 2024 LA Barnsley E08000016
#> 148 W23 2024 LA North Lincolnshire E06000013
#> 149 W23 2024 REG <NA> <NA>
#> 150 W23 2024 REG <NA> <NA>
#> 151 W23 2024 REG <NA> <NA>
#> 152 W23 2024 NAT <NA> <NA>
#> 153 W23 2024 NAT <NA> <NA>
#> 154 W23 2024 NAT <NA> <NA>
#> 155 W23 2024 LA Doncaster E08000017
#> 156 W23 2024 LA Bradford E08000032
#> 157 W23 2024 LA North East Lincolnshire E06000012
#> 158 W23 2024 LA Kingston upon Hull, City of E06000010
#> 159 W23 2024 LA Rotherham E08000018
#> 160 W23 2024 LA Bradford E08000032
#> 161 W23 2024 LA Barnsley E08000016
#> 162 W23 2024 LA Kirklees E08000034
#> 163 W23 2024 LA North East Lincolnshire E06000012
#> 164 W23 2024 LA Barnsley E08000016
#> 165 W23 2024 LA Sheffield E08000019
#> 166 W23 2024 LA North Lincolnshire E06000013
#> 167 W23 2024 LA Kirklees E08000034
#> 168 W23 2024 LA North Yorkshire E06000065
#> 169 W23 2024 LA Kingston upon Hull, City of E06000010
#> 170 W23 2024 LA North Yorkshire E06000065
#> 171 W23 2024 LA Leeds E08000035
#> 172 W23 2024 LA East Riding of Yorkshire E06000011
#> 173 W23 2024 LA Calderdale E08000033
#> 174 W23 2024 LA Wakefield E08000036
#> 175 W23 2024 LA Rotherham E08000018
#> 176 W23 2024 LA York E06000014
#> 177 W23 2024 LA Doncaster E08000017
#> 178 W23 2024 LA East Riding of Yorkshire E06000011
#> 179 W23 2024 LA Wakefield E08000036
#> 180 W23 2024 LA York E06000014
#> 181 W23 2024 LA Sheffield E08000019
#> 182 W23 2024 LA Kirklees E08000034
#> 183 W23 2024 LA Wakefield E08000036
#> 184 W23 2024 LA Calderdale E08000033
#> 185 W23 2024 LA North Yorkshire E06000065
#> 186 W23 2024 LA Barnsley E08000016
#> 187 W23 2024 LA Sheffield E08000019
#> 188 W23 2024 LA North East Lincolnshire E06000012
#> 189 W23 2024 LA Bradford E08000032
#> 190 W23 2024 LA Leeds E08000035
#> 191 W23 2024 LA York E06000014
#> 192 W23 2024 LA Doncaster E08000017
#> 193 W23 2024 LA Leeds E08000035
#> 194 W23 2024 LA Rotherham E08000018
#> 195 W23 2024 LA North Lincolnshire E06000013
#> 196 W23 2024 LA Kingston upon Hull, City of E06000010
#> 197 W23 2024 LA East Riding of Yorkshire E06000011
#> 198 W23 2024 LA Calderdale E08000033
#> 199 W23 2024 LA Bradford E08000032
#> 200 W23 2024 LA Sheffield E08000019
#> 201 W23 2024 LA York E06000014
#> 202 W23 2024 LA North East Lincolnshire E06000012
#> 203 W23 2024 REG <NA> <NA>
#> 204 W23 2024 REG <NA> <NA>
#> 205 W23 2024 REG <NA> <NA>
#> 206 W23 2024 NAT <NA> <NA>
#> 207 W23 2024 NAT <NA> <NA>
#> 208 W23 2024 NAT <NA> <NA>
#> 209 W23 2024 LA Calderdale E08000033
#> 210 W23 2024 LA North Yorkshire E06000065
#> 211 W23 2024 LA Barnsley E08000016
#> 212 W23 2024 LA Kingston upon Hull, City of E06000010
#> 213 W23 2024 LA Wakefield E08000036
#> 214 W23 2024 LA Leeds E08000035
#> 215 W23 2024 LA North Yorkshire E06000065
#> 216 W23 2024 LA Calderdale E08000033
#> 217 W23 2024 LA North Lincolnshire E06000013
#> 218 W23 2024 LA Wakefield E08000036
#> 219 W23 2024 LA Bradford E08000032
#> 220 W23 2024 LA North East Lincolnshire E06000012
#> 221 W23 2024 LA Sheffield E08000019
#> 222 W23 2024 LA Doncaster E08000017
#> 223 W23 2024 LA York E06000014
#> 224 W23 2024 LA Rotherham E08000018
#> 225 W23 2024 LA Bradford E08000032
#> 226 W23 2024 LA East Riding of Yorkshire E06000011
#> 227 W23 2024 LA Barnsley E08000016
#> 228 W23 2024 LA East Riding of Yorkshire E06000011
#> 229 W23 2024 LA North East Lincolnshire E06000012
#> 230 W23 2024 LA Rotherham E08000018
#> 231 W23 2024 LA North Lincolnshire E06000013
#> 232 W23 2024 LA Wakefield E08000036
#> 233 W23 2024 LA Rotherham E08000018
#> 234 W23 2024 LA Calderdale E08000033
#> 235 W23 2024 LA East Riding of Yorkshire E06000011
#> 236 W23 2024 LA Doncaster E08000017
#> 237 W23 2024 LA Barnsley E08000016
#> 238 W23 2024 LA North Lincolnshire E06000013
#> 239 W23 2024 LA Kirklees E08000034
#> 240 W23 2024 LA Doncaster E08000017
#> 241 W23 2024 LA York E06000014
#> 242 W23 2024 LA Kirklees E08000034
#> 243 W23 2024 LA Kingston upon Hull, City of E06000010
#> 244 W23 2024 LA Leeds E08000035
#> 245 W23 2024 LA Sheffield E08000019
#> 246 W23 2024 LA Leeds E08000035
#> 247 W23 2024 LA Kingston upon Hull, City of E06000010
#> 248 W23 2024 LA North Yorkshire E06000065
#> 249 W23 2024 LA Kirklees E08000034
#> 250 W23 2024 REG <NA> <NA>
#> 251 W23 2024 LA Kirklees E08000034
#> 252 W23 2024 REG <NA> <NA>
#> 253 W23 2024 REG <NA> <NA>
#> 254 W23 2024 NAT <NA> <NA>
#> 255 W23 2024 NAT <NA> <NA>
#> 256 W23 2024 NAT <NA> <NA>
#> 257 W23 2024 LA Leeds E08000035
#> 258 W23 2024 LA York E06000014
#> 259 W23 2024 LA North Yorkshire E06000065
#> 260 W23 2024 LA Doncaster E08000017
#> 261 W23 2024 LA North Lincolnshire E06000013
#> 262 W23 2024 LA North East Lincolnshire E06000012
#> 263 W23 2024 LA Calderdale E08000033
#> 264 W23 2024 LA East Riding of Yorkshire E06000011
#> 265 W23 2024 LA North East Lincolnshire E06000012
#> 266 W23 2024 LA Kirklees E08000034
#> 267 W23 2024 LA Doncaster E08000017
#> 268 W23 2024 LA East Riding of Yorkshire E06000011
#> 269 W23 2024 LA Barnsley E08000016
#> 270 W23 2024 LA Rotherham E08000018
#> 271 W23 2024 LA Calderdale E08000033
#> 272 W23 2024 LA Bradford E08000032
#> 273 W23 2024 LA Bradford E08000032
#> 274 W23 2024 LA Rotherham E08000018
#> 275 W23 2024 LA Barnsley E08000016
#> 276 W23 2024 LA Kingston upon Hull, City of E06000010
#> 277 W23 2024 LA Doncaster E08000017
#> 278 W23 2024 LA North Lincolnshire E06000013
#> 279 W23 2024 LA North Yorkshire E06000065
#> 280 W23 2024 LA Leeds E08000035
#> 281 W23 2024 LA Rotherham E08000018
#> 282 W23 2024 LA Wakefield E08000036
#> 283 W23 2024 LA North Lincolnshire E06000013
#> 284 W23 2024 LA Kingston upon Hull, City of E06000010
#> 285 W23 2024 LA York E06000014
#> 286 W23 2024 LA York E06000014
#> 287 W23 2024 LA Wakefield E08000036
#> 288 W23 2024 LA Sheffield E08000019
#> 289 W23 2024 LA Bradford E08000032
#> 290 W23 2024 LA East Riding of Yorkshire E06000011
#> 291 W23 2024 LA Leeds E08000035
#> 292 W23 2024 LA Barnsley E08000016
#> 293 W23 2024 LA North Yorkshire E06000065
#> 294 W23 2024 LA Wakefield E08000036
#> 295 W23 2024 LA Calderdale E08000033
#> 296 W23 2024 LA Sheffield E08000019
#> 297 W23 2024 LA Kingston upon Hull, City of E06000010
#> 298 W23 2024 LA North East Lincolnshire E06000012
#> 299 W23 2024 LA Sheffield E08000019
#> 300 W23 2024 LA Kirklees E08000034
#> 301 W23 2024 REG <NA> <NA>
#> 302 W23 2024 REG <NA> <NA>
#> 303 W23 2024 REG <NA> <NA>
#> 304 W23 2024 REG <NA> <NA>
#> 305 W23 2024 REG <NA> <NA>
#> 306 W23 2024 REG <NA> <NA>
#> 307 W23 2024 REG <NA> <NA>
#> 308 W23 2024 REG <NA> <NA>
#> 309 W23 2024 NAT <NA> <NA>
#> 310 W23 2024 NAT <NA> <NA>
#> 311 W23 2024 NAT <NA> <NA>
#> 312 W23 2024 NAT <NA> <NA>
#> 313 W23 2024 NAT <NA> <NA>
#> 314 W23 2024 NAT <NA> <NA>
#> 315 W23 2024 NAT <NA> <NA>
#> 316 W23 2024 REG <NA> <NA>
#> 317 W23 2024 NAT <NA> <NA>
#> 318 W23 2024 NAT <NA> <NA>
#> la_oldCode nat_name nat_code reg_name reg_code
#> 1 382 England E92000001 Yorkshire and The Humber E12000003
#> 2 383 England E92000001 Yorkshire and The Humber E12000003
#> 3 816 England E92000001 Yorkshire and The Humber E12000003
#> 4 815 England E92000001 Yorkshire and The Humber E12000003
#> 5 371 England E92000001 Yorkshire and The Humber E12000003
#> 6 813 England E92000001 Yorkshire and The Humber E12000003
#> 7 812 England E92000001 Yorkshire and The Humber E12000003
#> 8 381 England E92000001 Yorkshire and The Humber E12000003
#> 9 811 England E92000001 Yorkshire and The Humber E12000003
#> 10 812 England E92000001 Yorkshire and The Humber E12000003
#> 11 382 England E92000001 Yorkshire and The Humber E12000003
#> 12 371 England E92000001 Yorkshire and The Humber E12000003
#> 13 811 England E92000001 Yorkshire and The Humber E12000003
#> 14 370 England E92000001 Yorkshire and The Humber E12000003
#> 15 372 England E92000001 Yorkshire and The Humber E12000003
#> 16 381 England E92000001 Yorkshire and The Humber E12000003
#> 17 380 England E92000001 Yorkshire and The Humber E12000003
#> 18 380 England E92000001 Yorkshire and The Humber E12000003
#> 19 372 England E92000001 Yorkshire and The Humber E12000003
#> 20 370 England E92000001 Yorkshire and The Humber E12000003
#> 21 810 England E92000001 Yorkshire and The Humber E12000003
#> 22 371 England E92000001 Yorkshire and The Humber E12000003
#> 23 813 England E92000001 Yorkshire and The Humber E12000003
#> 24 815 England E92000001 Yorkshire and The Humber E12000003
#> 25 383 England E92000001 Yorkshire and The Humber E12000003
#> 26 372 England E92000001 Yorkshire and The Humber E12000003
#> 27 384 England E92000001 Yorkshire and The Humber E12000003
#> 28 813 England E92000001 Yorkshire and The Humber E12000003
#> 29 810 England E92000001 Yorkshire and The Humber E12000003
#> 30 816 England E92000001 Yorkshire and The Humber E12000003
#> 31 816 England E92000001 Yorkshire and The Humber E12000003
#> 32 384 England E92000001 Yorkshire and The Humber E12000003
#> 33 373 England E92000001 Yorkshire and The Humber E12000003
#> 34 380 England E92000001 Yorkshire and The Humber E12000003
#> 35 811 England E92000001 Yorkshire and The Humber E12000003
#> 36 383 England E92000001 Yorkshire and The Humber E12000003
#> 37 370 England E92000001 Yorkshire and The Humber E12000003
#> 38 815 England E92000001 Yorkshire and The Humber E12000003
#> 39 384 England E92000001 Yorkshire and The Humber E12000003
#> 40 381 England E92000001 Yorkshire and The Humber E12000003
#> 41 373 England E92000001 Yorkshire and The Humber E12000003
#> 42 810 England E92000001 Yorkshire and The Humber E12000003
#> 43 812 England E92000001 Yorkshire and The Humber E12000003
#> 44 373 England E92000001 Yorkshire and The Humber E12000003
#> 45 382 England E92000001 Yorkshire and The Humber E12000003
#> 46 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 47 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 48 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 49 372 England E92000001 Yorkshire and The Humber E12000003
#> 50 372 England E92000001 Yorkshire and The Humber E12000003
#> 51 370 England E92000001 Yorkshire and The Humber E12000003
#> 52 816 England E92000001 Yorkshire and The Humber E12000003
#> 53 810 England E92000001 Yorkshire and The Humber E12000003
#> 54 382 England E92000001 Yorkshire and The Humber E12000003
#> 55 <NA> England E92000001 <NA> <NA>
#> 56 <NA> England E92000001 <NA> <NA>
#> 57 <NA> England E92000001 <NA> <NA>
#> 58 815 England E92000001 Yorkshire and The Humber E12000003
#> 59 816 England E92000001 Yorkshire and The Humber E12000003
#> 60 384 England E92000001 Yorkshire and The Humber E12000003
#> 61 811 England E92000001 Yorkshire and The Humber E12000003
#> 62 382 England E92000001 Yorkshire and The Humber E12000003
#> 63 815 England E92000001 Yorkshire and The Humber E12000003
#> 64 373 England E92000001 Yorkshire and The Humber E12000003
#> 65 381 England E92000001 Yorkshire and The Humber E12000003
#> 66 816 England E92000001 Yorkshire and The Humber E12000003
#> 67 812 England E92000001 Yorkshire and The Humber E12000003
#> 68 380 England E92000001 Yorkshire and The Humber E12000003
#> 69 811 England E92000001 Yorkshire and The Humber E12000003
#> 70 811 England E92000001 Yorkshire and The Humber E12000003
#> 71 370 England E92000001 Yorkshire and The Humber E12000003
#> 72 812 England E92000001 Yorkshire and The Humber E12000003
#> 73 371 England E92000001 Yorkshire and The Humber E12000003
#> 74 810 England E92000001 Yorkshire and The Humber E12000003
#> 75 382 England E92000001 Yorkshire and The Humber E12000003
#> 76 813 England E92000001 Yorkshire and The Humber E12000003
#> 77 373 England E92000001 Yorkshire and The Humber E12000003
#> 78 812 England E92000001 Yorkshire and The Humber E12000003
#> 79 371 England E92000001 Yorkshire and The Humber E12000003
#> 80 373 England E92000001 Yorkshire and The Humber E12000003
#> 81 383 England E92000001 Yorkshire and The Humber E12000003
#> 82 371 England E92000001 Yorkshire and The Humber E12000003
#> 83 813 England E92000001 Yorkshire and The Humber E12000003
#> 84 370 England E92000001 Yorkshire and The Humber E12000003
#> 85 380 England E92000001 Yorkshire and The Humber E12000003
#> 86 384 England E92000001 Yorkshire and The Humber E12000003
#> 87 815 England E92000001 Yorkshire and The Humber E12000003
#> 88 813 England E92000001 Yorkshire and The Humber E12000003
#> 89 383 England E92000001 Yorkshire and The Humber E12000003
#> 90 383 England E92000001 Yorkshire and The Humber E12000003
#> 91 810 England E92000001 Yorkshire and The Humber E12000003
#> 92 384 England E92000001 Yorkshire and The Humber E12000003
#> 93 381 England E92000001 Yorkshire and The Humber E12000003
#> 94 372 England E92000001 Yorkshire and The Humber E12000003
#> 95 380 England E92000001 Yorkshire and The Humber E12000003
#> 96 381 England E92000001 Yorkshire and The Humber E12000003
#> 97 810 England E92000001 Yorkshire and The Humber E12000003
#> 98 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 99 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 100 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 101 <NA> England E92000001 <NA> <NA>
#> 102 <NA> England E92000001 <NA> <NA>
#> 103 <NA> England E92000001 <NA> <NA>
#> 104 816 England E92000001 Yorkshire and The Humber E12000003
#> 105 373 England E92000001 Yorkshire and The Humber E12000003
#> 106 370 England E92000001 Yorkshire and The Humber E12000003
#> 107 812 England E92000001 Yorkshire and The Humber E12000003
#> 108 813 England E92000001 Yorkshire and The Humber E12000003
#> 109 382 England E92000001 Yorkshire and The Humber E12000003
#> 110 810 England E92000001 Yorkshire and The Humber E12000003
#> 111 811 England E92000001 Yorkshire and The Humber E12000003
#> 112 812 England E92000001 Yorkshire and The Humber E12000003
#> 113 812 England E92000001 Yorkshire and The Humber E12000003
#> 114 384 England E92000001 Yorkshire and The Humber E12000003
#> 115 380 England E92000001 Yorkshire and The Humber E12000003
#> 116 810 England E92000001 Yorkshire and The Humber E12000003
#> 117 372 England E92000001 Yorkshire and The Humber E12000003
#> 118 380 England E92000001 Yorkshire and The Humber E12000003
#> 119 383 England E92000001 Yorkshire and The Humber E12000003
#> 120 383 England E92000001 Yorkshire and The Humber E12000003
#> 121 816 England E92000001 Yorkshire and The Humber E12000003
#> 122 816 England E92000001 Yorkshire and The Humber E12000003
#> 123 370 England E92000001 Yorkshire and The Humber E12000003
#> 124 381 England E92000001 Yorkshire and The Humber E12000003
#> 125 384 England E92000001 Yorkshire and The Humber E12000003
#> 126 811 England E92000001 Yorkshire and The Humber E12000003
#> 127 811 England E92000001 Yorkshire and The Humber E12000003
#> 128 380 England E92000001 Yorkshire and The Humber E12000003
#> 129 813 England E92000001 Yorkshire and The Humber E12000003
#> 130 373 England E92000001 Yorkshire and The Humber E12000003
#> 131 382 England E92000001 Yorkshire and The Humber E12000003
#> 132 381 England E92000001 Yorkshire and The Humber E12000003
#> 133 372 England E92000001 Yorkshire and The Humber E12000003
#> 134 371 England E92000001 Yorkshire and The Humber E12000003
#> 135 813 England E92000001 Yorkshire and The Humber E12000003
#> 136 815 England E92000001 Yorkshire and The Humber E12000003
#> 137 383 England E92000001 Yorkshire and The Humber E12000003
#> 138 371 England E92000001 Yorkshire and The Humber E12000003
#> 139 373 England E92000001 Yorkshire and The Humber E12000003
#> 140 372 England E92000001 Yorkshire and The Humber E12000003
#> 141 381 England E92000001 Yorkshire and The Humber E12000003
#> 142 384 England E92000001 Yorkshire and The Humber E12000003
#> 143 371 England E92000001 Yorkshire and The Humber E12000003
#> 144 815 England E92000001 Yorkshire and The Humber E12000003
#> 145 815 England E92000001 Yorkshire and The Humber E12000003
#> 146 382 England E92000001 Yorkshire and The Humber E12000003
#> 147 370 England E92000001 Yorkshire and The Humber E12000003
#> 148 813 England E92000001 Yorkshire and The Humber E12000003
#> 149 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 150 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 151 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 152 <NA> England E92000001 <NA> <NA>
#> 153 <NA> England E92000001 <NA> <NA>
#> 154 <NA> England E92000001 <NA> <NA>
#> 155 371 England E92000001 Yorkshire and The Humber E12000003
#> 156 380 England E92000001 Yorkshire and The Humber E12000003
#> 157 812 England E92000001 Yorkshire and The Humber E12000003
#> 158 810 England E92000001 Yorkshire and The Humber E12000003
#> 159 372 England E92000001 Yorkshire and The Humber E12000003
#> 160 380 England E92000001 Yorkshire and The Humber E12000003
#> 161 370 England E92000001 Yorkshire and The Humber E12000003
#> 162 382 England E92000001 Yorkshire and The Humber E12000003
#> 163 812 England E92000001 Yorkshire and The Humber E12000003
#> 164 370 England E92000001 Yorkshire and The Humber E12000003
#> 165 373 England E92000001 Yorkshire and The Humber E12000003
#> 166 813 England E92000001 Yorkshire and The Humber E12000003
#> 167 382 England E92000001 Yorkshire and The Humber E12000003
#> 168 815 England E92000001 Yorkshire and The Humber E12000003
#> 169 810 England E92000001 Yorkshire and The Humber E12000003
#> 170 815 England E92000001 Yorkshire and The Humber E12000003
#> 171 383 England E92000001 Yorkshire and The Humber E12000003
#> 172 811 England E92000001 Yorkshire and The Humber E12000003
#> 173 381 England E92000001 Yorkshire and The Humber E12000003
#> 174 384 England E92000001 Yorkshire and The Humber E12000003
#> 175 372 England E92000001 Yorkshire and The Humber E12000003
#> 176 816 England E92000001 Yorkshire and The Humber E12000003
#> 177 371 England E92000001 Yorkshire and The Humber E12000003
#> 178 811 England E92000001 Yorkshire and The Humber E12000003
#> 179 384 England E92000001 Yorkshire and The Humber E12000003
#> 180 816 England E92000001 Yorkshire and The Humber E12000003
#> 181 373 England E92000001 Yorkshire and The Humber E12000003
#> 182 382 England E92000001 Yorkshire and The Humber E12000003
#> 183 384 England E92000001 Yorkshire and The Humber E12000003
#> 184 381 England E92000001 Yorkshire and The Humber E12000003
#> 185 815 England E92000001 Yorkshire and The Humber E12000003
#> 186 370 England E92000001 Yorkshire and The Humber E12000003
#> 187 373 England E92000001 Yorkshire and The Humber E12000003
#> 188 812 England E92000001 Yorkshire and The Humber E12000003
#> 189 380 England E92000001 Yorkshire and The Humber E12000003
#> 190 383 England E92000001 Yorkshire and The Humber E12000003
#> 191 816 England E92000001 Yorkshire and The Humber E12000003
#> 192 371 England E92000001 Yorkshire and The Humber E12000003
#> 193 383 England E92000001 Yorkshire and The Humber E12000003
#> 194 372 England E92000001 Yorkshire and The Humber E12000003
#> 195 813 England E92000001 Yorkshire and The Humber E12000003
#> 196 810 England E92000001 Yorkshire and The Humber E12000003
#> 197 811 England E92000001 Yorkshire and The Humber E12000003
#> 198 381 England E92000001 Yorkshire and The Humber E12000003
#> 199 380 England E92000001 Yorkshire and The Humber E12000003
#> 200 373 England E92000001 Yorkshire and The Humber E12000003
#> 201 816 England E92000001 Yorkshire and The Humber E12000003
#> 202 812 England E92000001 Yorkshire and The Humber E12000003
#> 203 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 204 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 205 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 206 <NA> England E92000001 <NA> <NA>
#> 207 <NA> England E92000001 <NA> <NA>
#> 208 <NA> England E92000001 <NA> <NA>
#> 209 381 England E92000001 Yorkshire and The Humber E12000003
#> 210 815 England E92000001 Yorkshire and The Humber E12000003
#> 211 370 England E92000001 Yorkshire and The Humber E12000003
#> 212 810 England E92000001 Yorkshire and The Humber E12000003
#> 213 384 England E92000001 Yorkshire and The Humber E12000003
#> 214 383 England E92000001 Yorkshire and The Humber E12000003
#> 215 815 England E92000001 Yorkshire and The Humber E12000003
#> 216 381 England E92000001 Yorkshire and The Humber E12000003
#> 217 813 England E92000001 Yorkshire and The Humber E12000003
#> 218 384 England E92000001 Yorkshire and The Humber E12000003
#> 219 380 England E92000001 Yorkshire and The Humber E12000003
#> 220 812 England E92000001 Yorkshire and The Humber E12000003
#> 221 373 England E92000001 Yorkshire and The Humber E12000003
#> 222 371 England E92000001 Yorkshire and The Humber E12000003
#> 223 816 England E92000001 Yorkshire and The Humber E12000003
#> 224 372 England E92000001 Yorkshire and The Humber E12000003
#> 225 380 England E92000001 Yorkshire and The Humber E12000003
#> 226 811 England E92000001 Yorkshire and The Humber E12000003
#> 227 370 England E92000001 Yorkshire and The Humber E12000003
#> 228 811 England E92000001 Yorkshire and The Humber E12000003
#> 229 812 England E92000001 Yorkshire and The Humber E12000003
#> 230 372 England E92000001 Yorkshire and The Humber E12000003
#> 231 813 England E92000001 Yorkshire and The Humber E12000003
#> 232 384 England E92000001 Yorkshire and The Humber E12000003
#> 233 372 England E92000001 Yorkshire and The Humber E12000003
#> 234 381 England E92000001 Yorkshire and The Humber E12000003
#> 235 811 England E92000001 Yorkshire and The Humber E12000003
#> 236 371 England E92000001 Yorkshire and The Humber E12000003
#> 237 370 England E92000001 Yorkshire and The Humber E12000003
#> 238 813 England E92000001 Yorkshire and The Humber E12000003
#> 239 382 England E92000001 Yorkshire and The Humber E12000003
#> 240 371 England E92000001 Yorkshire and The Humber E12000003
#> 241 816 England E92000001 Yorkshire and The Humber E12000003
#> 242 382 England E92000001 Yorkshire and The Humber E12000003
#> 243 810 England E92000001 Yorkshire and The Humber E12000003
#> 244 383 England E92000001 Yorkshire and The Humber E12000003
#> 245 373 England E92000001 Yorkshire and The Humber E12000003
#> 246 383 England E92000001 Yorkshire and The Humber E12000003
#> 247 810 England E92000001 Yorkshire and The Humber E12000003
#> 248 815 England E92000001 Yorkshire and The Humber E12000003
#> 249 382 England E92000001 Yorkshire and The Humber E12000003
#> 250 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 251 382 England E92000001 Yorkshire and The Humber E12000003
#> 252 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 253 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 254 <NA> England E92000001 <NA> <NA>
#> 255 <NA> England E92000001 <NA> <NA>
#> 256 <NA> England E92000001 <NA> <NA>
#> 257 383 England E92000001 Yorkshire and The Humber E12000003
#> 258 816 England E92000001 Yorkshire and The Humber E12000003
#> 259 815 England E92000001 Yorkshire and The Humber E12000003
#> 260 371 England E92000001 Yorkshire and The Humber E12000003
#> 261 813 England E92000001 Yorkshire and The Humber E12000003
#> 262 812 England E92000001 Yorkshire and The Humber E12000003
#> 263 381 England E92000001 Yorkshire and The Humber E12000003
#> 264 811 England E92000001 Yorkshire and The Humber E12000003
#> 265 812 England E92000001 Yorkshire and The Humber E12000003
#> 266 382 England E92000001 Yorkshire and The Humber E12000003
#> 267 371 England E92000001 Yorkshire and The Humber E12000003
#> 268 811 England E92000001 Yorkshire and The Humber E12000003
#> 269 370 England E92000001 Yorkshire and The Humber E12000003
#> 270 372 England E92000001 Yorkshire and The Humber E12000003
#> 271 381 England E92000001 Yorkshire and The Humber E12000003
#> 272 380 England E92000001 Yorkshire and The Humber E12000003
#> 273 380 England E92000001 Yorkshire and The Humber E12000003
#> 274 372 England E92000001 Yorkshire and The Humber E12000003
#> 275 370 England E92000001 Yorkshire and The Humber E12000003
#> 276 810 England E92000001 Yorkshire and The Humber E12000003
#> 277 371 England E92000001 Yorkshire and The Humber E12000003
#> 278 813 England E92000001 Yorkshire and The Humber E12000003
#> 279 815 England E92000001 Yorkshire and The Humber E12000003
#> 280 383 England E92000001 Yorkshire and The Humber E12000003
#> 281 372 England E92000001 Yorkshire and The Humber E12000003
#> 282 384 England E92000001 Yorkshire and The Humber E12000003
#> 283 813 England E92000001 Yorkshire and The Humber E12000003
#> 284 810 England E92000001 Yorkshire and The Humber E12000003
#> 285 816 England E92000001 Yorkshire and The Humber E12000003
#> 286 816 England E92000001 Yorkshire and The Humber E12000003
#> 287 384 England E92000001 Yorkshire and The Humber E12000003
#> 288 373 England E92000001 Yorkshire and The Humber E12000003
#> 289 380 England E92000001 Yorkshire and The Humber E12000003
#> 290 811 England E92000001 Yorkshire and The Humber E12000003
#> 291 383 England E92000001 Yorkshire and The Humber E12000003
#> 292 370 England E92000001 Yorkshire and The Humber E12000003
#> 293 815 England E92000001 Yorkshire and The Humber E12000003
#> 294 384 England E92000001 Yorkshire and The Humber E12000003
#> 295 381 England E92000001 Yorkshire and The Humber E12000003
#> 296 373 England E92000001 Yorkshire and The Humber E12000003
#> 297 810 England E92000001 Yorkshire and The Humber E12000003
#> 298 812 England E92000001 Yorkshire and The Humber E12000003
#> 299 373 England E92000001 Yorkshire and The Humber E12000003
#> 300 382 England E92000001 Yorkshire and The Humber E12000003
#> 301 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 302 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 303 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 304 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 305 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 306 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 307 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 308 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 309 <NA> England E92000001 <NA> <NA>
#> 310 <NA> England E92000001 <NA> <NA>
#> 311 <NA> England E92000001 <NA> <NA>
#> 312 <NA> England E92000001 <NA> <NA>
#> 313 <NA> England E92000001 <NA> <NA>
#> 314 <NA> England E92000001 <NA> <NA>
#> 315 <NA> England E92000001 <NA> <NA>
#> 316 <NA> England E92000001 Yorkshire and The Humber E12000003
#> 317 <NA> England E92000001 <NA> <NA>
#> 318 <NA> England E92000001 <NA> <NA>
#> attendance_status attendance_type day_number education_phase
#> 1 Absence Unauthorised 1 Special
#> 2 Absence Unauthorised 1 Primary
#> 3 Absence Unauthorised 1 Special
#> 4 Absence Unauthorised 1 Primary
#> 5 Absence Unauthorised 1 Secondary
#> 6 Absence Unauthorised 1 Primary
#> 7 Absence Unauthorised 1 Primary
#> 8 Absence Unauthorised 1 Primary
#> 9 Absence Unauthorised 1 Secondary
#> 10 Absence Unauthorised 1 Secondary
#> 11 Absence Unauthorised 1 Secondary
#> 12 Absence Unauthorised 1 Primary
#> 13 Absence Unauthorised 1 Special
#> 14 Absence Unauthorised 1 Primary
#> 15 Absence Unauthorised 1 Secondary
#> 16 Absence Unauthorised 1 Secondary
#> 17 Absence Unauthorised 1 Special
#> 18 Absence Unauthorised 1 Secondary
#> 19 Absence Unauthorised 1 Primary
#> 20 Absence Unauthorised 1 Special
#> 21 Absence Unauthorised 1 Special
#> 22 Absence Unauthorised 1 Special
#> 23 Absence Unauthorised 1 Special
#> 24 Absence Unauthorised 1 Special
#> 25 Absence Unauthorised 1 Secondary
#> 26 Absence Unauthorised 1 Special
#> 27 Absence Unauthorised 1 Secondary
#> 28 Absence Unauthorised 1 Secondary
#> 29 Absence Unauthorised 1 Secondary
#> 30 Absence Unauthorised 1 Secondary
#> 31 Absence Unauthorised 1 Primary
#> 32 Absence Unauthorised 1 Primary
#> 33 Absence Unauthorised 1 Primary
#> 34 Absence Unauthorised 1 Primary
#> 35 Absence Unauthorised 1 Primary
#> 36 Absence Unauthorised 1 Special
#> 37 Absence Unauthorised 1 Secondary
#> 38 Absence Unauthorised 1 Secondary
#> 39 Absence Unauthorised 1 Special
#> 40 Absence Unauthorised 1 Special
#> 41 Absence Unauthorised 1 Secondary
#> 42 Absence Unauthorised 1 Primary
#> 43 Absence Unauthorised 1 Special
#> 44 Absence Unauthorised 1 Special
#> 45 Absence Unauthorised 1 Primary
#> 46 Absence Unauthorised 1 Secondary
#> 47 Absence Unauthorised 1 Special
#> 48 Absence Unauthorised 1 Primary
#> 49 Absence Unauthorised 2 Primary
#> 50 Absence Unauthorised 2 Secondary
#> 51 Absence Unauthorised 2 Primary
#> 52 Absence Unauthorised 2 Primary
#> 53 Absence Unauthorised 2 Secondary
#> 54 Absence Unauthorised 2 Secondary
#> 55 Absence Unauthorised 1 Special
#> 56 Absence Unauthorised 1 Primary
#> 57 Absence Unauthorised 1 Secondary
#> 58 Absence Unauthorised 2 Secondary
#> 59 Absence Unauthorised 2 Secondary
#> 60 Absence Unauthorised 2 Secondary
#> 61 Absence Unauthorised 2 Special
#> 62 Absence Unauthorised 2 Special
#> 63 Absence Unauthorised 2 Special
#> 64 Absence Unauthorised 2 Special
#> 65 Absence Unauthorised 2 Primary
#> 66 Absence Unauthorised 2 Special
#> 67 Absence Unauthorised 2 Secondary
#> 68 Absence Unauthorised 2 Primary
#> 69 Absence Unauthorised 2 Primary
#> 70 Absence Unauthorised 2 Secondary
#> 71 Absence Unauthorised 2 Secondary
#> 72 Absence Unauthorised 2 Special
#> 73 Absence Unauthorised 2 Primary
#> 74 Absence Unauthorised 2 Special
#> 75 Absence Unauthorised 2 Primary
#> 76 Absence Unauthorised 2 Secondary
#> 77 Absence Unauthorised 2 Primary
#> 78 Absence Unauthorised 2 Primary
#> 79 Absence Unauthorised 2 Special
#> 80 Absence Unauthorised 2 Secondary
#> 81 Absence Unauthorised 2 Secondary
#> 82 Absence Unauthorised 2 Secondary
#> 83 Absence Unauthorised 2 Primary
#> 84 Absence Unauthorised 2 Special
#> 85 Absence Unauthorised 2 Special
#> 86 Absence Unauthorised 2 Primary
#> 87 Absence Unauthorised 2 Primary
#> 88 Absence Unauthorised 2 Special
#> 89 Absence Unauthorised 2 Primary
#> 90 Absence Unauthorised 2 Special
#> 91 Absence Unauthorised 2 Primary
#> 92 Absence Unauthorised 2 Special
#> 93 Absence Unauthorised 2 Special
#> 94 Absence Unauthorised 2 Special
#> 95 Absence Unauthorised 2 Secondary
#> 96 Absence Unauthorised 2 Secondary
#> 97 Absence Unauthorised 3 Special
#> 98 Absence Unauthorised 2 Primary
#> 99 Absence Unauthorised 2 Secondary
#> 100 Absence Unauthorised 2 Special
#> 101 Absence Unauthorised 2 Special
#> 102 Absence Unauthorised 2 Primary
#> 103 Absence Unauthorised 2 Secondary
#> 104 Absence Unauthorised 3 Special
#> 105 Absence Unauthorised 3 Primary
#> 106 Absence Unauthorised 3 Primary
#> 107 Absence Unauthorised 3 Secondary
#> 108 Absence Unauthorised 3 Special
#> 109 Absence Unauthorised 3 Secondary
#> 110 Absence Unauthorised 3 Primary
#> 111 Absence Unauthorised 3 Secondary
#> 112 Absence Unauthorised 3 Primary
#> 113 Absence Unauthorised 3 Special
#> 114 Absence Unauthorised 3 Secondary
#> 115 Absence Unauthorised 3 Secondary
#> 116 Absence Unauthorised 3 Secondary
#> 117 Absence Unauthorised 3 Special
#> 118 Absence Unauthorised 3 Primary
#> 119 Absence Unauthorised 3 Special
#> 120 Absence Unauthorised 3 Secondary
#> 121 Absence Unauthorised 3 Secondary
#> 122 Absence Unauthorised 3 Primary
#> 123 Absence Unauthorised 3 Special
#> 124 Absence Unauthorised 3 Special
#> 125 Absence Unauthorised 3 Primary
#> 126 Absence Unauthorised 3 Special
#> 127 Absence Unauthorised 3 Primary
#> 128 Absence Unauthorised 3 Special
#> 129 Absence Unauthorised 3 Primary
#> 130 Absence Unauthorised 3 Secondary
#> 131 Absence Unauthorised 3 Special
#> 132 Absence Unauthorised 3 Primary
#> 133 Absence Unauthorised 3 Secondary
#> 134 Absence Unauthorised 3 Primary
#> 135 Absence Unauthorised 3 Secondary
#> 136 Absence Unauthorised 3 Secondary
#> 137 Absence Unauthorised 3 Primary
#> 138 Absence Unauthorised 3 Special
#> 139 Absence Unauthorised 3 Special
#> 140 Absence Unauthorised 3 Primary
#> 141 Absence Unauthorised 3 Secondary
#> 142 Absence Unauthorised 3 Special
#> 143 Absence Unauthorised 3 Secondary
#> 144 Absence Unauthorised 3 Special
#> 145 Absence Unauthorised 3 Primary
#> 146 Absence Unauthorised 3 Primary
#> 147 Absence Unauthorised 3 Secondary
#> 148 Absence Unauthorised 4 Special
#> 149 Absence Unauthorised 3 Special
#> 150 Absence Unauthorised 3 Primary
#> 151 Absence Unauthorised 3 Secondary
#> 152 Absence Unauthorised 3 Secondary
#> 153 Absence Unauthorised 3 Special
#> 154 Absence Unauthorised 3 Primary
#> 155 Absence Unauthorised 4 Secondary
#> 156 Absence Unauthorised 4 Secondary
#> 157 Absence Unauthorised 4 Primary
#> 158 Absence Unauthorised 4 Secondary
#> 159 Absence Unauthorised 4 Secondary
#> 160 Absence Unauthorised 4 Special
#> 161 Absence Unauthorised 4 Special
#> 162 Absence Unauthorised 4 Primary
#> 163 Absence Unauthorised 4 Special
#> 164 Absence Unauthorised 4 Primary
#> 165 Absence Unauthorised 4 Primary
#> 166 Absence Unauthorised 4 Primary
#> 167 Absence Unauthorised 4 Secondary
#> 168 Absence Unauthorised 4 Special
#> 169 Absence Unauthorised 4 Special
#> 170 Absence Unauthorised 4 Secondary
#> 171 Absence Unauthorised 4 Secondary
#> 172 Absence Unauthorised 4 Special
#> 173 Absence Unauthorised 4 Primary
#> 174 Absence Unauthorised 4 Special
#> 175 Absence Unauthorised 4 Primary
#> 176 Absence Unauthorised 4 Secondary
#> 177 Absence Unauthorised 4 Special
#> 178 Absence Unauthorised 4 Secondary
#> 179 Absence Unauthorised 4 Primary
#> 180 Absence Unauthorised 4 Primary
#> 181 Absence Unauthorised 4 Secondary
#> 182 Absence Unauthorised 4 Special
#> 183 Absence Unauthorised 4 Secondary
#> 184 Absence Unauthorised 4 Special
#> 185 Absence Unauthorised 4 Primary
#> 186 Absence Unauthorised 4 Secondary
#> 187 Absence Unauthorised 4 Special
#> 188 Absence Unauthorised 4 Secondary
#> 189 Absence Unauthorised 4 Primary
#> 190 Absence Unauthorised 4 Primary
#> 191 Absence Unauthorised 4 Special
#> 192 Absence Unauthorised 4 Primary
#> 193 Absence Unauthorised 4 Special
#> 194 Absence Unauthorised 4 Special
#> 195 Absence Unauthorised 4 Secondary
#> 196 Absence Unauthorised 4 Primary
#> 197 Absence Unauthorised 4 Primary
#> 198 Absence Unauthorised 4 Secondary
#> 199 Absence Unauthorised 5 Primary
#> 200 Absence Unauthorised 5 Primary
#> 201 Absence Unauthorised 5 Special
#> 202 Absence Unauthorised 5 Primary
#> 203 Absence Unauthorised 4 Secondary
#> 204 Absence Unauthorised 4 Primary
#> 205 Absence Unauthorised 4 Special
#> 206 Absence Unauthorised 4 Secondary
#> 207 Absence Unauthorised 4 Primary
#> 208 Absence Unauthorised 4 Special
#> 209 Absence Unauthorised 5 Special
#> 210 Absence Unauthorised 5 Special
#> 211 Absence Unauthorised 5 Secondary
#> 212 Absence Unauthorised 5 Primary
#> 213 Absence Unauthorised 5 Secondary
#> 214 Absence Unauthorised 5 Secondary
#> 215 Absence Unauthorised 5 Primary
#> 216 Absence Unauthorised 5 Secondary
#> 217 Absence Unauthorised 5 Secondary
#> 218 Absence Unauthorised 5 Primary
#> 219 Absence Unauthorised 5 Special
#> 220 Absence Unauthorised 5 Special
#> 221 Absence Unauthorised 5 Secondary
#> 222 Absence Unauthorised 5 Primary
#> 223 Absence Unauthorised 5 Secondary
#> 224 Absence Unauthorised 5 Primary
#> 225 Absence Unauthorised 5 Secondary
#> 226 Absence Unauthorised 5 Secondary
#> 227 Absence Unauthorised 5 Primary
#> 228 Absence Unauthorised 5 Special
#> 229 Absence Unauthorised 5 Secondary
#> 230 Absence Unauthorised 5 Special
#> 231 Absence Unauthorised 5 Special
#> 232 Absence Unauthorised 5 Special
#> 233 Absence Unauthorised 5 Secondary
#> 234 Absence Unauthorised 5 Primary
#> 235 Absence Unauthorised 5 Primary
#> 236 Absence Unauthorised 5 Secondary
#> 237 Absence Unauthorised 5 Special
#> 238 Absence Unauthorised 5 Primary
#> 239 Absence Unauthorised 5 Special
#> 240 Absence Unauthorised 5 Special
#> 241 Absence Unauthorised 5 Primary
#> 242 Absence Unauthorised 5 Primary
#> 243 Absence Unauthorised 5 Special
#> 244 Absence Unauthorised 5 Special
#> 245 Absence Unauthorised 5 Special
#> 246 Absence Unauthorised 5 Primary
#> 247 Absence Unauthorised 5 Secondary
#> 248 Absence Unauthorised 5 Secondary
#> 249 Absence Unauthorised 5 Secondary
#> 250 Absence Unauthorised 5 Primary
#> 251 Absence Unauthorised Total Special
#> 252 Absence Unauthorised 5 Secondary
#> 253 Absence Unauthorised 5 Special
#> 254 Absence Unauthorised 5 Secondary
#> 255 Absence Unauthorised 5 Special
#> 256 Absence Unauthorised 5 Primary
#> 257 Absence Unauthorised Total Primary
#> 258 Absence Unauthorised Total Special
#> 259 Absence Unauthorised Total Primary
#> 260 Absence Unauthorised Total Secondary
#> 261 Absence Unauthorised Total Primary
#> 262 Absence Unauthorised Total Primary
#> 263 Absence Unauthorised Total Primary
#> 264 Absence Unauthorised Total Secondary
#> 265 Absence Unauthorised Total Secondary
#> 266 Absence Unauthorised Total Secondary
#> 267 Absence Unauthorised Total Primary
#> 268 Absence Unauthorised Total Special
#> 269 Absence Unauthorised Total Primary
#> 270 Absence Unauthorised Total Secondary
#> 271 Absence Unauthorised Total Secondary
#> 272 Absence Unauthorised Total Special
#> 273 Absence Unauthorised Total Secondary
#> 274 Absence Unauthorised Total Primary
#> 275 Absence Unauthorised Total Special
#> 276 Absence Unauthorised Total Special
#> 277 Absence Unauthorised Total Special
#> 278 Absence Unauthorised Total Special
#> 279 Absence Unauthorised Total Special
#> 280 Absence Unauthorised Total Secondary
#> 281 Absence Unauthorised Total Special
#> 282 Absence Unauthorised Total Secondary
#> 283 Absence Unauthorised Total Secondary
#> 284 Absence Unauthorised Total Secondary
#> 285 Absence Unauthorised Total Secondary
#> 286 Absence Unauthorised Total Primary
#> 287 Absence Unauthorised Total Primary
#> 288 Absence Unauthorised Total Primary
#> 289 Absence Unauthorised Total Primary
#> 290 Absence Unauthorised Total Primary
#> 291 Absence Unauthorised Total Special
#> 292 Absence Unauthorised Total Secondary
#> 293 Absence Unauthorised Total Secondary
#> 294 Absence Unauthorised Total Special
#> 295 Absence Unauthorised Total Special
#> 296 Absence Unauthorised Total Secondary
#> 297 Absence Unauthorised Total Primary
#> 298 Absence Unauthorised Total Special
#> 299 Absence Unauthorised Total Special
#> 300 Absence Unauthorised Total Primary
#> 301 Absence Unauthorised Total Secondary
#> 302 Absence Unauthorised Total Special
#> 303 Absence Unauthorised Total Primary
#> 304 Absence Unauthorised 2 Total
#> 305 Absence Unauthorised 3 Total
#> 306 Absence Unauthorised 4 Total
#> 307 Absence Unauthorised 5 Total
#> 308 Absence Unauthorised 1 Total
#> 309 Absence Unauthorised Total Special
#> 310 Absence Unauthorised Total Primary
#> 311 Absence Unauthorised Total Secondary
#> 312 Absence Unauthorised 2 Total
#> 313 Absence Unauthorised 3 Total
#> 314 Absence Unauthorised 4 Total
#> 315 Absence Unauthorised 5 Total
#> 316 Absence Unauthorised Total Total
#> 317 Absence Unauthorised Total Total
#> 318 Absence Unauthorised 1 Total
#> attendance_reason session_count
#> 1 G unauthorised holiday 2
#> 2 G unauthorised holiday 1992
#> 3 G unauthorised holiday 4
#> 4 G unauthorised holiday 1340
#> 5 G unauthorised holiday 514
#> 6 G unauthorised holiday 394
#> 7 G unauthorised holiday 324
#> 8 G unauthorised holiday 426
#> 9 G unauthorised holiday 305
#> 10 G unauthorised holiday 226
#> 11 G unauthorised holiday 251
#> 12 G unauthorised holiday 809
#> 13 G unauthorised holiday 8
#> 14 G unauthorised holiday 769
#> 15 G unauthorised holiday 537
#> 16 G unauthorised holiday 302
#> 17 G unauthorised holiday 16
#> 18 G unauthorised holiday 732
#> 19 G unauthorised holiday 983
#> 20 G unauthorised holiday 18
#> 21 G unauthorised holiday 22
#> 22 G unauthorised holiday 12
#> 23 G unauthorised holiday 4
#> 24 G unauthorised holiday 28
#> 25 G unauthorised holiday 920
#> 26 G unauthorised holiday 21
#> 27 G unauthorised holiday 629
#> 28 G unauthorised holiday 160
#> 29 G unauthorised holiday 290
#> 30 G unauthorised holiday 187
#> 31 G unauthorised holiday 478
#> 32 G unauthorised holiday 1002
#> 33 G unauthorised holiday 1521
#> 34 G unauthorised holiday 673
#> 35 G unauthorised holiday 615
#> 36 G unauthorised holiday 42
#> 37 G unauthorised holiday 542
#> 38 G unauthorised holiday 630
#> 39 G unauthorised holiday 0
#> 40 G unauthorised holiday 6
#> 41 G unauthorised holiday 610
#> 42 G unauthorised holiday 497
#> 43 G unauthorised holiday 2
#> 44 G unauthorised holiday 24
#> 45 G unauthorised holiday 683
#> 46 G unauthorised holiday 6835
#> 47 G unauthorised holiday 209
#> 48 G unauthorised holiday 12506
#> 49 G unauthorised holiday 1219
#> 50 G unauthorised holiday 448
#> 51 G unauthorised holiday 837
#> 52 G unauthorised holiday 413
#> 53 G unauthorised holiday 257
#> 54 G unauthorised holiday 238
#> 55 G unauthorised holiday 1574
#> 56 G unauthorised holiday 84811
#> 57 G unauthorised holiday 44458
#> 58 G unauthorised holiday 497
#> 59 G unauthorised holiday 149
#> 60 G unauthorised holiday 549
#> 61 G unauthorised holiday 6
#> 62 G unauthorised holiday 0
#> 63 G unauthorised holiday 14
#> 64 G unauthorised holiday 20
#> 65 G unauthorised holiday 393
#> 66 G unauthorised holiday 4
#> 67 G unauthorised holiday 206
#> 68 G unauthorised holiday 655
#> 69 G unauthorised holiday 877
#> 70 G unauthorised holiday 251
#> 71 G unauthorised holiday 516
#> 72 G unauthorised holiday 2
#> 73 G unauthorised holiday 950
#> 74 G unauthorised holiday 12
#> 75 G unauthorised holiday 859
#> 76 G unauthorised holiday 137
#> 77 G unauthorised holiday 1496
#> 78 G unauthorised holiday 415
#> 79 G unauthorised holiday 12
#> 80 G unauthorised holiday 510
#> 81 G unauthorised holiday 752
#> 82 G unauthorised holiday 459
#> 83 G unauthorised holiday 339
#> 84 G unauthorised holiday 16
#> 85 G unauthorised holiday 16
#> 86 G unauthorised holiday 1308
#> 87 G unauthorised holiday 1364
#> 88 G unauthorised holiday 4
#> 89 G unauthorised holiday 2055
#> 90 G unauthorised holiday 26
#> 91 G unauthorised holiday 604
#> 92 G unauthorised holiday 0
#> 93 G unauthorised holiday x
#> 94 G unauthorised holiday 15
#> 95 G unauthorised holiday 635
#> 96 G unauthorised holiday 236
#> 97 G unauthorised holiday 12
#> 98 G unauthorised holiday 13784
#> 99 G unauthorised holiday 5840
#> 100 G unauthorised holiday 153
#> 101 G unauthorised holiday 1443
#> 102 G unauthorised holiday 98308
#> 103 G unauthorised holiday 37788
#> 104 G unauthorised holiday 2
#> 105 G unauthorised holiday 1305
#> 106 G unauthorised holiday 808
#> 107 G unauthorised holiday 168
#> 108 G unauthorised holiday 2
#> 109 G unauthorised holiday 204
#> 110 G unauthorised holiday 638
#> 111 G unauthorised holiday 215
#> 112 G unauthorised holiday 389
#> 113 G unauthorised holiday 2
#> 114 G unauthorised holiday 483
#> 115 G unauthorised holiday 559
#> 116 G unauthorised holiday 223
#> 117 G unauthorised holiday 15
#> 118 G unauthorised holiday 746
#> 119 G unauthorised holiday 21
#> 120 G unauthorised holiday 640
#> 121 G unauthorised holiday 128
#> 122 G unauthorised holiday 325
#> 123 G unauthorised holiday 24
#> 124 G unauthorised holiday x
#> 125 G unauthorised holiday 1156
#> 126 G unauthorised holiday 6
#> 127 G unauthorised holiday 719
#> 128 G unauthorised holiday 14
#> 129 G unauthorised holiday 339
#> 130 G unauthorised holiday 459
#> 131 G unauthorised holiday 0
#> 132 G unauthorised holiday 281
#> 133 G unauthorised holiday 399
#> 134 G unauthorised holiday 896
#> 135 G unauthorised holiday 137
#> 136 G unauthorised holiday 441
#> 137 G unauthorised holiday 1717
#> 138 G unauthorised holiday 12
#> 139 G unauthorised holiday 22
#> 140 G unauthorised holiday 1126
#> 141 G unauthorised holiday 190
#> 142 G unauthorised holiday 2
#> 143 G unauthorised holiday 432
#> 144 G unauthorised holiday 14
#> 145 G unauthorised holiday 1084
#> 146 G unauthorised holiday 707
#> 147 G unauthorised holiday 477
#> 148 G unauthorised holiday 2
#> 149 G unauthorised holiday 154
#> 150 G unauthorised holiday 12236
#> 151 G unauthorised holiday 5155
#> 152 G unauthorised holiday 33274
#> 153 G unauthorised holiday 1372
#> 154 G unauthorised holiday 86219
#> 155 G unauthorised holiday 414
#> 156 G unauthorised holiday 491
#> 157 G unauthorised holiday 361
#> 158 G unauthorised holiday 210
#> 159 G unauthorised holiday 393
#> 160 G unauthorised holiday 14
#> 161 G unauthorised holiday 26
#> 162 G unauthorised holiday 600
#> 163 G unauthorised holiday 2
#> 164 G unauthorised holiday 751
#> 165 G unauthorised holiday 1164
#> 166 G unauthorised holiday 304
#> 167 G unauthorised holiday 177
#> 168 G unauthorised holiday 10
#> 169 G unauthorised holiday 12
#> 170 G unauthorised holiday 383
#> 171 G unauthorised holiday 565
#> 172 G unauthorised holiday 6
#> 173 G unauthorised holiday 265
#> 174 G unauthorised holiday 2
#> 175 G unauthorised holiday 1027
#> 176 G unauthorised holiday 117
#> 177 G unauthorised holiday 12
#> 178 G unauthorised holiday 156
#> 179 G unauthorised holiday 1017
#> 180 G unauthorised holiday 290
#> 181 G unauthorised holiday 385
#> 182 G unauthorised holiday 0
#> 183 G unauthorised holiday 416
#> 184 G unauthorised holiday x
#> 185 G unauthorised holiday 973
#> 186 G unauthorised holiday 454
#> 187 G unauthorised holiday 18
#> 188 G unauthorised holiday 144
#> 189 G unauthorised holiday 858
#> 190 G unauthorised holiday 1547
#> 191 G unauthorised holiday 2
#> 192 G unauthorised holiday 862
#> 193 G unauthorised holiday 18
#> 194 G unauthorised holiday 14
#> 195 G unauthorised holiday 129
#> 196 G unauthorised holiday 606
#> 197 G unauthorised holiday 597
#> 198 G unauthorised holiday 156
#> 199 G unauthorised holiday 857
#> 200 G unauthorised holiday 1227
#> 201 G unauthorised holiday 2
#> 202 G unauthorised holiday 372
#> 203 G unauthorised holiday 4590
#> 204 G unauthorised holiday 11222
#> 205 G unauthorised holiday 146
#> 206 G unauthorised holiday 29610
#> 207 G unauthorised holiday 75852
#> 208 G unauthorised holiday 1345
#> 209 G unauthorised holiday x
#> 210 G unauthorised holiday 10
#> 211 G unauthorised holiday 436
#> 212 G unauthorised holiday 609
#> 213 G unauthorised holiday 385
#> 214 G unauthorised holiday 543
#> 215 G unauthorised holiday 1027
#> 216 G unauthorised holiday 158
#> 217 G unauthorised holiday 116
#> 218 G unauthorised holiday 989
#> 219 G unauthorised holiday 14
#> 220 G unauthorised holiday 2
#> 221 G unauthorised holiday 364
#> 222 G unauthorised holiday 885
#> 223 G unauthorised holiday 110
#> 224 G unauthorised holiday 1049
#> 225 G unauthorised holiday 474
#> 226 G unauthorised holiday 150
#> 227 G unauthorised holiday 796
#> 228 G unauthorised holiday 0
#> 229 G unauthorised holiday 140
#> 230 G unauthorised holiday 15
#> 231 G unauthorised holiday 2
#> 232 G unauthorised holiday 8
#> 233 G unauthorised holiday 401
#> 234 G unauthorised holiday 316
#> 235 G unauthorised holiday 614
#> 236 G unauthorised holiday 437
#> 237 G unauthorised holiday 28
#> 238 G unauthorised holiday 311
#> 239 G unauthorised holiday 2
#> 240 G unauthorised holiday 16
#> 241 G unauthorised holiday 329
#> 242 G unauthorised holiday 611
#> 243 G unauthorised holiday 17
#> 244 G unauthorised holiday 27
#> 245 G unauthorised holiday 21
#> 246 G unauthorised holiday 1560
#> 247 G unauthorised holiday 226
#> 248 G unauthorised holiday 412
#> 249 G unauthorised holiday 159
#> 250 G unauthorised holiday 11552
#> 251 G unauthorised holiday 4
#> 252 G unauthorised holiday 4511
#> 253 G unauthorised holiday 172
#> 254 G unauthorised holiday 29339
#> 255 G unauthorised holiday 1410
#> 256 G unauthorised holiday 77983
#> 257 G unauthorised holiday 8871
#> 258 G unauthorised holiday 14
#> 259 G unauthorised holiday 5788
#> 260 G unauthorised holiday 2256
#> 261 G unauthorised holiday 1687
#> 262 G unauthorised holiday 1861
#> 263 G unauthorised holiday 1681
#> 264 G unauthorised holiday 1077
#> 265 G unauthorised holiday 884
#> 266 G unauthorised holiday 1029
#> 267 G unauthorised holiday 4402
#> 268 G unauthorised holiday 26
#> 269 G unauthorised holiday 3961
#> 270 G unauthorised holiday 2178
#> 271 G unauthorised holiday 1042
#> 272 G unauthorised holiday 74
#> 273 G unauthorised holiday 2891
#> 274 G unauthorised holiday 5404
#> 275 G unauthorised holiday 112
#> 276 G unauthorised holiday 75
#> 277 G unauthorised holiday 64
#> 278 G unauthorised holiday 14
#> 279 G unauthorised holiday 76
#> 280 G unauthorised holiday 3420
#> 281 G unauthorised holiday 80
#> 282 G unauthorised holiday 2462
#> 283 G unauthorised holiday 679
#> 284 G unauthorised holiday 1206
#> 285 G unauthorised holiday 691
#> 286 G unauthorised holiday 1835
#> 287 G unauthorised holiday 5472
#> 288 G unauthorised holiday 6713
#> 289 G unauthorised holiday 3789
#> 290 G unauthorised holiday 3422
#> 291 G unauthorised holiday 134
#> 292 G unauthorised holiday 2425
#> 293 G unauthorised holiday 2363
#> 294 G unauthorised holiday 12
#> 295 G unauthorised holiday 34
#> 296 G unauthorised holiday 2328
#> 297 G unauthorised holiday 2954
#> 298 G unauthorised holiday 10
#> 299 G unauthorised holiday 105
#> 300 G unauthorised holiday 3460
#> 301 G unauthorised holiday 26931
#> 302 G unauthorised holiday 834
#> 303 G unauthorised holiday 61300
#> 304 G unauthorised holiday 19777
#> 305 G unauthorised holiday 17545
#> 306 G unauthorised holiday 15958
#> 307 G unauthorised holiday 16235
#> 308 G unauthorised holiday 19550
#> 309 G unauthorised holiday 7144
#> 310 G unauthorised holiday 423173
#> 311 G unauthorised holiday 174469
#> 312 G unauthorised holiday 137539
#> 313 G unauthorised holiday 120865
#> 314 G unauthorised holiday 106807
#> 315 G unauthorised holiday 108732
#> 316 G unauthorised holiday 89065
#> 317 G unauthorised holiday 604786
#> 318 G unauthorised holiday 130843
# Run a basic query using GET instead of POST
query_dataset(
example_id(),
method = "GET",
geographic_levels = c("NAT"),
filter_items = example_id("filter_item"),
indicators = example_id("indicator"),
page = 1,
page_size = 10
)
#> Warning: Using GET to query a data set offers limited functionality, we recommend using POST alongside a JSON structured query instead:
#> - query_dataset(..., method = 'POST')
#> code period geographic_level nat_name nat_code establishment_type
#> 1 AY 2023/2024 NAT England E92000001 Primary schools
#> 2 AY 2022/2023 NAT England E92000001 Primary schools
#> 3 AY 2021/2022 NAT England E92000001 Primary schools
#> count_absent_sessions
#> 1 27819920
#> 2 32350550
#> 3 30023935