Skip to contents

Create 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 single string, a vector of strings, a list or a data frame depending on user preference and the complexity of the desired query.

The user can supply a single string containing the desired geographic level (e.g. "NAT", "REG", "LA") or a specific location (e.g. "NAT|code|E92000001", "REG|code|E12000001") and the query will search for rows at that single level or location.

Specific locations are required to be supplied in the format "location_level|location_id_type|location_id", where location_id_type can be either code or id and the corresponding location_id 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"

Using 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.

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 work best when using the default POST method. The GET method is much more limited and may struggle to process more complex queries.

The geography query data frame should contain the following columns:

  • geographic_level: the geographic level to return (e.g. LA in the example above).

  • location_level: the geographic level of the search location (e.g. REG in the example above).

  • location_id_type: "code" or "id".

  • location_id: 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().

A list object will also be understood, provided it only contains the named items geographic_level and / or location. This are defined similarly to the vector form above:

  • list(geographic_level=c("REG", "LA"), locations = c("REG|code|E12000001")

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,
  filter_items = NULL,
  json_query = NULL,
  method = "POST",
  dataset_version = NULL,
  preview_token = NULL,
  ees_environment = NULL,
  api_version = NULL,
  page_size = 10000,
  parse = TRUE,
  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-dataset-versions", "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.

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

preview_token

Preview token required for access to private data sets

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

parse

Logical flag to activate parsing of the results. Default: TRUE

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

Value

Data frame containing query results

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()
)
#>    time_period time_identifier geographic_level nat_name  nat_code   reg_name
#> 1         2025          Week 3         Regional  England E92000001 North West
#> 2         2025          Week 3         Regional  England E92000001 North West
#> 3         2025          Week 3         Regional  England E92000001 North West
#> 4         2025          Week 3         Regional  England E92000001 North West
#> 5         2025          Week 3         Regional  England E92000001 North West
#> 6         2025          Week 3         Regional  England E92000001 North West
#> 7         2025          Week 3         Regional  England E92000001 North West
#> 8         2025          Week 3         Regional  England E92000001 North West
#> 9         2025          Week 3         Regional  England E92000001 North West
#> 10        2025          Week 3         Regional  England E92000001 North West
#> 11        2025          Week 3         Regional  England E92000001 North West
#> 12        2025          Week 3         Regional  England E92000001 North West
#> 13        2025          Week 3         Regional  England E92000001 North West
#> 14        2025          Week 3         Regional  England E92000001 North West
#> 15        2025          Week 3         Regional  England E92000001 North West
#> 16        2025          Week 3         Regional  England E92000001 North West
#> 17        2025          Week 3         Regional  England E92000001 North East
#> 18        2025          Week 3         Regional  England E92000001 North East
#> 19        2025          Week 3         Regional  England E92000001 North East
#> 20        2025          Week 3         Regional  England E92000001 North East
#> 21        2025          Week 3         Regional  England E92000001 North East
#> 22        2025          Week 3         Regional  England E92000001 North East
#> 23        2025          Week 3         Regional  England E92000001 North East
#> 24        2025          Week 3         Regional  England E92000001 North East
#> 25        2025          Week 3         Regional  England E92000001 North East
#> 26        2025          Week 3         Regional  England E92000001 North East
#> 27        2025          Week 3         Regional  England E92000001 North East
#> 28        2025          Week 3         Regional  England E92000001 North East
#> 29        2025          Week 3         Regional  England E92000001 North East
#> 30        2025          Week 3         Regional  England E92000001 North East
#> 31        2025          Week 3         Regional  England E92000001 North East
#> 32        2025          Week 3         Regional  England E92000001 North East
#>     reg_code                 attendance_reason attendance_status
#> 1  E12000002 All approved educational activity        Attendance
#> 2  E12000002             All possible sessions Possible sessions
#> 3  E12000002            Education off site (b)        Attendance
#> 4  E12000002                     Interview (j)        Attendance
#> 5  E12000002    Approved sporting activity (p)        Attendance
#> 6  E12000002        Educational visit trip (v)        Attendance
#> 7  E12000002               Work experience (w)        Attendance
#> 8  E12000002      Education arranged by LA (k)        Attendance
#> 9  E12000002 All approved educational activity        Attendance
#> 10 E12000002             All possible sessions Possible sessions
#> 11 E12000002            Education off site (b)        Attendance
#> 12 E12000002                     Interview (j)        Attendance
#> 13 E12000002    Approved sporting activity (p)        Attendance
#> 14 E12000002        Educational visit trip (v)        Attendance
#> 15 E12000002               Work experience (w)        Attendance
#> 16 E12000002      Education arranged by LA (k)        Attendance
#> 17 E12000001 All approved educational activity        Attendance
#> 18 E12000001             All possible sessions Possible sessions
#> 19 E12000001            Education off site (b)        Attendance
#> 20 E12000001                     Interview (j)        Attendance
#> 21 E12000001    Approved sporting activity (p)        Attendance
#> 22 E12000001        Educational visit trip (v)        Attendance
#> 23 E12000001               Work experience (w)        Attendance
#> 24 E12000001      Education arranged by LA (k)        Attendance
#> 25 E12000001 All approved educational activity        Attendance
#> 26 E12000001             All possible sessions Possible sessions
#> 27 E12000001            Education off site (b)        Attendance
#> 28 E12000001                     Interview (j)        Attendance
#> 29 E12000001    Approved sporting activity (p)        Attendance
#> 30 E12000001        Educational visit trip (v)        Attendance
#> 31 E12000001               Work experience (w)        Attendance
#> 32 E12000001      Education arranged by LA (k)        Attendance
#>                  attendance_type education_phase time_frame session_count
#> 1  Approved educational activity     All schools       Week         56505
#> 2          All possible sessions     All schools       Week       9729751
#> 3  Approved educational activity     All schools       Week         20820
#> 4  Approved educational activity     All schools       Week             0
#> 5  Approved educational activity     All schools       Week          6697
#> 6  Approved educational activity     All schools       Week         23967
#> 7  Approved educational activity     All schools       Week          2054
#> 8  Approved educational activity     All schools       Week          2967
#> 9  Approved educational activity         Primary       Week         19314
#> 10         All possible sessions         Primary       Week       5176216
#> 11 Approved educational activity         Primary       Week          4716
#> 12 Approved educational activity         Primary       Week             0
#> 13 Approved educational activity         Primary       Week          2938
#> 14 Approved educational activity         Primary       Week         11257
#> 15 Approved educational activity         Primary       Week             0
#> 16 Approved educational activity         Primary       Week           403
#> 17 Approved educational activity     All schools       Week         21475
#> 18         All possible sessions     All schools       Week       3237909
#> 19 Approved educational activity     All schools       Week          7107
#> 20 Approved educational activity     All schools       Week             0
#> 21 Approved educational activity     All schools       Week          2906
#> 22 Approved educational activity     All schools       Week          8971
#> 23 Approved educational activity     All schools       Week           519
#> 24 Approved educational activity     All schools       Week          1972
#> 25 Approved educational activity         Primary       Week          7091
#> 26         All possible sessions         Primary       Week       1659146
#> 27 Approved educational activity         Primary       Week          1084
#> 28 Approved educational activity         Primary       Week             0
#> 29 Approved educational activity         Primary       Week          1159
#> 30 Approved educational activity         Primary       Week          4715
#> 31 Approved educational activity         Primary       Week             0
#> 32 Approved educational activity         Primary       Week           133

# 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 = c("NAT|code|E92000001", "REG|code|E12000001"),
  filter_items = example_id("filter_item", group = "attendance"),
  page = 1,
  page_size = 32
)
#>    time_period time_identifier geographic_level nat_name  nat_code   reg_name
#> 1         2025          Week 3         National  England E92000001       <NA>
#> 2         2025          Week 3         National  England E92000001       <NA>
#> 3         2025          Week 3         National  England E92000001       <NA>
#> 4         2025          Week 3         National  England E92000001       <NA>
#> 5         2025          Week 3         Regional  England E92000001 North East
#> 6         2025          Week 3         Regional  England E92000001 North East
#> 7         2025          Week 3         Regional  England E92000001 North East
#> 8         2025          Week 3         Regional  England E92000001 North East
#> 9         2025          Week 3         Regional  England E92000001 North East
#> 10        2025          Week 3         Regional  England E92000001 North East
#> 11        2025          Week 3         Regional  England E92000001 North East
#> 12        2025          Week 3         Regional  England E92000001 North East
#> 13        2025          Week 3         Regional  England E92000001 North East
#> 14        2025          Week 3         Regional  England E92000001 North East
#> 15        2025          Week 3         Regional  England E92000001 North East
#> 16        2025          Week 3         Regional  England E92000001 North East
#> 17        2025          Week 3         Regional  England E92000001 North East
#> 18        2025          Week 3         Regional  England E92000001 North East
#> 19        2025          Week 3         Regional  England E92000001 North East
#> 20        2025          Week 3         Regional  England E92000001 North East
#> 21        2025          Week 3         Regional  England E92000001 North East
#> 22        2025          Week 3         Regional  England E92000001 North East
#> 23        2025          Week 3         Regional  England E92000001 North East
#> 24        2025          Week 3         Regional  England E92000001 North East
#> 25        2025          Week 3         Regional  England E92000001 North East
#> 26        2025          Week 3         Regional  England E92000001 North East
#> 27        2025          Week 3         Regional  England E92000001 North East
#> 28        2025          Week 3         Regional  England E92000001 North East
#> 29        2025          Week 3         National  England E92000001       <NA>
#> 30        2025          Week 3         National  England E92000001       <NA>
#> 31        2025          Week 3         National  England E92000001       <NA>
#> 32        2025          Week 3         National  England E92000001       <NA>
#>     reg_code attendance_reason attendance_status   attendance_type
#> 1       <NA> All late sessions     Late sessions All late sessions
#> 2       <NA> All late sessions     Late sessions All late sessions
#> 3       <NA> All late sessions     Late sessions All late sessions
#> 4       <NA> All late sessions     Late sessions All late sessions
#> 5  E12000001 All late sessions     Late sessions All late sessions
#> 6  E12000001 All late sessions     Late sessions All late sessions
#> 7  E12000001 All late sessions     Late sessions All late sessions
#> 8  E12000001 All late sessions     Late sessions All late sessions
#> 9  E12000001 All late sessions     Late sessions All late sessions
#> 10 E12000001 All late sessions     Late sessions All late sessions
#> 11 E12000001 All late sessions     Late sessions All late sessions
#> 12 E12000001 All late sessions     Late sessions All late sessions
#> 13 E12000001 All late sessions     Late sessions All late sessions
#> 14 E12000001 All late sessions     Late sessions All late sessions
#> 15 E12000001 All late sessions     Late sessions All late sessions
#> 16 E12000001 All late sessions     Late sessions All late sessions
#> 17 E12000001 All late sessions     Late sessions All late sessions
#> 18 E12000001 All late sessions     Late sessions All late sessions
#> 19 E12000001 All late sessions     Late sessions All late sessions
#> 20 E12000001 All late sessions     Late sessions All late sessions
#> 21 E12000001 All late sessions     Late sessions All late sessions
#> 22 E12000001 All late sessions     Late sessions All late sessions
#> 23 E12000001 All late sessions     Late sessions All late sessions
#> 24 E12000001 All late sessions     Late sessions All late sessions
#> 25 E12000001 All late sessions     Late sessions All late sessions
#> 26 E12000001 All late sessions     Late sessions All late sessions
#> 27 E12000001 All late sessions     Late sessions All late sessions
#> 28 E12000001 All late sessions     Late sessions All late sessions
#> 29      <NA> All late sessions     Late sessions All late sessions
#> 30      <NA> All late sessions     Late sessions All late sessions
#> 31      <NA> All late sessions     Late sessions All late sessions
#> 32      <NA> All late sessions     Late sessions All late sessions
#>    education_phase time_frame session_count
#> 1      All schools     Monday        351534
#> 2      All schools    Tuesday        339756
#> 3      All schools  Wednesday        332987
#> 4      All schools   Thursday        325941
#> 5      All schools     Monday         15836
#> 6      All schools    Tuesday         14998
#> 7      All schools  Wednesday         14651
#> 8      All schools   Thursday         14235
#> 9      All schools     Friday         12933
#> 10     All schools       Week         72653
#> 11         Primary     Monday          5343
#> 12         Primary    Tuesday          4628
#> 13         Primary  Wednesday          4411
#> 14         Primary   Thursday          4411
#> 15         Primary     Friday          3786
#> 16         Primary       Week         22579
#> 17       Secondary     Monday         10326
#> 18       Secondary    Tuesday         10223
#> 19       Secondary  Wednesday         10089
#> 20       Secondary   Thursday          9695
#> 21       Secondary     Friday          9029
#> 22       Secondary       Week         49362
#> 23         Special     Monday           167
#> 24         Special    Tuesday           147
#> 25         Special  Wednesday           151
#> 26         Special   Thursday           129
#> 27         Special     Friday           118
#> 28         Special       Week           712
#> 29     All schools     Friday        291093
#> 30     All schools       Week       1641311
#> 31         Primary     Monday        119186
#> 32         Primary    Tuesday        108155

# Run query_dataset() using set parameters giving a combination of filter options
example_filter_list_input <- example_id("filter_items_short", group = "attendance")
print(example_filter_list_input)
#> $attendance_type
#> [1] "P9Aeb" "VPw5X"
#> 
#> $education_phase
#> [1] "rbyNj" "GBMgr"
#> 
#> $time_frame
#> [1] "5ezdi"
#> 
query_dataset(
  example_id(group = "attendance"),
  indicators = example_id("indicator", group = "attendance"),
  time_periods = example_id("time_period", group = "attendance"),
  geographies = "NAT",
  filter_items = example_filter_list_input
)
#>    time_period time_identifier geographic_level nat_name  nat_code
#> 1         2025          Week 3         National  England E92000001
#> 2         2025          Week 3         National  England E92000001
#> 3         2025          Week 3         National  England E92000001
#> 4         2025          Week 3         National  England E92000001
#> 5         2025          Week 3         National  England E92000001
#> 6         2025          Week 3         National  England E92000001
#> 7         2025          Week 3         National  England E92000001
#> 8         2025          Week 3         National  England E92000001
#> 9         2025          Week 3         National  England E92000001
#> 10        2025          Week 3         National  England E92000001
#> 11        2025          Week 3         National  England E92000001
#> 12        2025          Week 3         National  England E92000001
#> 13        2025          Week 3         National  England E92000001
#> 14        2025          Week 3         National  England E92000001
#> 15        2025          Week 3         National  England E92000001
#> 16        2025          Week 3         National  England E92000001
#>                    attendance_reason attendance_status
#> 1  All approved educational activity        Attendance
#> 2              All possible sessions Possible sessions
#> 3             Education off site (b)        Attendance
#> 4                      Interview (j)        Attendance
#> 5     Approved sporting activity (p)        Attendance
#> 6         Educational visit trip (v)        Attendance
#> 7                Work experience (w)        Attendance
#> 8       Education arranged by LA (k)        Attendance
#> 9  All approved educational activity        Attendance
#> 10             All possible sessions Possible sessions
#> 11            Education off site (b)        Attendance
#> 12                     Interview (j)        Attendance
#> 13    Approved sporting activity (p)        Attendance
#> 14        Educational visit trip (v)        Attendance
#> 15               Work experience (w)        Attendance
#> 16      Education arranged by LA (k)        Attendance
#>                  attendance_type education_phase time_frame session_count
#> 1  Approved educational activity     All schools       Week        427615
#> 2          All possible sessions     All schools       Week      69957685
#> 3  Approved educational activity     All schools       Week        133079
#> 4  Approved educational activity     All schools       Week             1
#> 5  Approved educational activity     All schools       Week         54027
#> 6  Approved educational activity     All schools       Week        202641
#> 7  Approved educational activity     All schools       Week         11025
#> 8  Approved educational activity     All schools       Week         26842
#> 9  Approved educational activity         Primary       Week        162411
#> 10         All possible sessions         Primary       Week      36957552
#> 11 Approved educational activity         Primary       Week         27316
#> 12 Approved educational activity         Primary       Week             1
#> 13 Approved educational activity         Primary       Week         23469
#> 14 Approved educational activity         Primary       Week        107016
#> 15 Approved educational activity         Primary       Week            57
#> 16 Approved educational activity         Primary       Week          4552

# 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
query_dataset(
  example_id(group = "attendance"),
  indicators = example_id("indicator", group = "attendance"),
  time_periods = example_id("time_period", group = "attendance"),
  geographies = data.frame(
    geographic_level = c("NAT", "REG", "LA"),
    locations = c("NAT|code|E92000001", "REG|code|E12000003", "REG|code|E12000003")
  ),
  filter_items = example_id("filter_item", group = "attendance")
)
#>     time_period time_identifier geographic_level nat_name  nat_code
#> 1          2025          Week 3         National  England E92000001
#> 2          2025          Week 3         National  England E92000001
#> 3          2025          Week 3         National  England E92000001
#> 4          2025          Week 3         National  England E92000001
#> 5          2025          Week 3         National  England E92000001
#> 6          2025          Week 3         National  England E92000001
#> 7          2025          Week 3         National  England E92000001
#> 8          2025          Week 3         National  England E92000001
#> 9          2025          Week 3         National  England E92000001
#> 10         2025          Week 3         National  England E92000001
#> 11         2025          Week 3         National  England E92000001
#> 12         2025          Week 3         National  England E92000001
#> 13         2025          Week 3         National  England E92000001
#> 14         2025          Week 3         National  England E92000001
#> 15         2025          Week 3         National  England E92000001
#> 16         2025          Week 3         National  England E92000001
#> 17         2025          Week 3         National  England E92000001
#> 18         2025          Week 3         National  England E92000001
#> 19         2025          Week 3         National  England E92000001
#> 20         2025          Week 3         National  England E92000001
#> 21         2025          Week 3         National  England E92000001
#> 22         2025          Week 3         National  England E92000001
#> 23         2025          Week 3         National  England E92000001
#> 24         2025          Week 3         National  England E92000001
#> 25         2025          Week 3         Regional  England E92000001
#> 26         2025          Week 3         Regional  England E92000001
#> 27         2025          Week 3  Local authority  England E92000001
#> 28         2025          Week 3  Local authority  England E92000001
#> 29         2025          Week 3  Local authority  England E92000001
#> 30         2025          Week 3  Local authority  England E92000001
#> 31         2025          Week 3  Local authority  England E92000001
#> 32         2025          Week 3  Local authority  England E92000001
#> 33         2025          Week 3  Local authority  England E92000001
#> 34         2025          Week 3  Local authority  England E92000001
#> 35         2025          Week 3  Local authority  England E92000001
#> 36         2025          Week 3  Local authority  England E92000001
#> 37         2025          Week 3  Local authority  England E92000001
#> 38         2025          Week 3  Local authority  England E92000001
#> 39         2025          Week 3  Local authority  England E92000001
#> 40         2025          Week 3  Local authority  England E92000001
#> 41         2025          Week 3  Local authority  England E92000001
#> 42         2025          Week 3  Local authority  England E92000001
#> 43         2025          Week 3  Local authority  England E92000001
#> 44         2025          Week 3  Local authority  England E92000001
#> 45         2025          Week 3  Local authority  England E92000001
#> 46         2025          Week 3  Local authority  England E92000001
#> 47         2025          Week 3  Local authority  England E92000001
#> 48         2025          Week 3  Local authority  England E92000001
#> 49         2025          Week 3         Regional  England E92000001
#> 50         2025          Week 3         Regional  England E92000001
#> 51         2025          Week 3         Regional  England E92000001
#> 52         2025          Week 3         Regional  England E92000001
#> 53         2025          Week 3         Regional  England E92000001
#> 54         2025          Week 3         Regional  England E92000001
#> 55         2025          Week 3         Regional  England E92000001
#> 56         2025          Week 3         Regional  England E92000001
#> 57         2025          Week 3         Regional  England E92000001
#> 58         2025          Week 3         Regional  England E92000001
#> 59         2025          Week 3         Regional  England E92000001
#> 60         2025          Week 3         Regional  England E92000001
#> 61         2025          Week 3         Regional  England E92000001
#> 62         2025          Week 3         Regional  England E92000001
#> 63         2025          Week 3         Regional  England E92000001
#> 64         2025          Week 3         Regional  England E92000001
#> 65         2025          Week 3         Regional  England E92000001
#> 66         2025          Week 3         Regional  England E92000001
#> 67         2025          Week 3         Regional  England E92000001
#> 68         2025          Week 3         Regional  England E92000001
#> 69         2025          Week 3         Regional  England E92000001
#> 70         2025          Week 3         Regional  England E92000001
#> 71         2025          Week 3  Local authority  England E92000001
#> 72         2025          Week 3  Local authority  England E92000001
#> 73         2025          Week 3  Local authority  England E92000001
#> 74         2025          Week 3  Local authority  England E92000001
#> 75         2025          Week 3  Local authority  England E92000001
#> 76         2025          Week 3  Local authority  England E92000001
#> 77         2025          Week 3  Local authority  England E92000001
#> 78         2025          Week 3  Local authority  England E92000001
#> 79         2025          Week 3  Local authority  England E92000001
#> 80         2025          Week 3  Local authority  England E92000001
#> 81         2025          Week 3  Local authority  England E92000001
#> 82         2025          Week 3  Local authority  England E92000001
#> 83         2025          Week 3  Local authority  England E92000001
#> 84         2025          Week 3  Local authority  England E92000001
#> 85         2025          Week 3  Local authority  England E92000001
#> 86         2025          Week 3  Local authority  England E92000001
#> 87         2025          Week 3  Local authority  England E92000001
#> 88         2025          Week 3  Local authority  England E92000001
#> 89         2025          Week 3  Local authority  England E92000001
#> 90         2025          Week 3  Local authority  England E92000001
#> 91         2025          Week 3  Local authority  England E92000001
#> 92         2025          Week 3  Local authority  England E92000001
#> 93         2025          Week 3  Local authority  England E92000001
#> 94         2025          Week 3  Local authority  England E92000001
#> 95         2025          Week 3  Local authority  England E92000001
#> 96         2025          Week 3  Local authority  England E92000001
#> 97         2025          Week 3  Local authority  England E92000001
#> 98         2025          Week 3  Local authority  England E92000001
#> 99         2025          Week 3  Local authority  England E92000001
#> 100        2025          Week 3  Local authority  England E92000001
#> 101        2025          Week 3  Local authority  England E92000001
#> 102        2025          Week 3  Local authority  England E92000001
#> 103        2025          Week 3  Local authority  England E92000001
#> 104        2025          Week 3  Local authority  England E92000001
#> 105        2025          Week 3  Local authority  England E92000001
#> 106        2025          Week 3  Local authority  England E92000001
#> 107        2025          Week 3  Local authority  England E92000001
#> 108        2025          Week 3  Local authority  England E92000001
#> 109        2025          Week 3  Local authority  England E92000001
#> 110        2025          Week 3  Local authority  England E92000001
#> 111        2025          Week 3  Local authority  England E92000001
#> 112        2025          Week 3  Local authority  England E92000001
#> 113        2025          Week 3  Local authority  England E92000001
#> 114        2025          Week 3  Local authority  England E92000001
#> 115        2025          Week 3  Local authority  England E92000001
#> 116        2025          Week 3  Local authority  England E92000001
#> 117        2025          Week 3  Local authority  England E92000001
#> 118        2025          Week 3  Local authority  England E92000001
#> 119        2025          Week 3  Local authority  England E92000001
#> 120        2025          Week 3  Local authority  England E92000001
#> 121        2025          Week 3  Local authority  England E92000001
#> 122        2025          Week 3  Local authority  England E92000001
#> 123        2025          Week 3  Local authority  England E92000001
#> 124        2025          Week 3  Local authority  England E92000001
#> 125        2025          Week 3  Local authority  England E92000001
#> 126        2025          Week 3  Local authority  England E92000001
#> 127        2025          Week 3  Local authority  England E92000001
#> 128        2025          Week 3  Local authority  England E92000001
#> 129        2025          Week 3  Local authority  England E92000001
#> 130        2025          Week 3  Local authority  England E92000001
#> 131        2025          Week 3  Local authority  England E92000001
#> 132        2025          Week 3  Local authority  England E92000001
#> 133        2025          Week 3  Local authority  England E92000001
#> 134        2025          Week 3  Local authority  England E92000001
#> 135        2025          Week 3  Local authority  England E92000001
#> 136        2025          Week 3  Local authority  England E92000001
#> 137        2025          Week 3  Local authority  England E92000001
#> 138        2025          Week 3  Local authority  England E92000001
#> 139        2025          Week 3  Local authority  England E92000001
#> 140        2025          Week 3  Local authority  England E92000001
#> 141        2025          Week 3  Local authority  England E92000001
#> 142        2025          Week 3  Local authority  England E92000001
#> 143        2025          Week 3  Local authority  England E92000001
#> 144        2025          Week 3  Local authority  England E92000001
#> 145        2025          Week 3  Local authority  England E92000001
#> 146        2025          Week 3  Local authority  England E92000001
#> 147        2025          Week 3  Local authority  England E92000001
#> 148        2025          Week 3  Local authority  England E92000001
#> 149        2025          Week 3  Local authority  England E92000001
#> 150        2025          Week 3  Local authority  England E92000001
#> 151        2025          Week 3  Local authority  England E92000001
#> 152        2025          Week 3  Local authority  England E92000001
#> 153        2025          Week 3  Local authority  England E92000001
#> 154        2025          Week 3  Local authority  England E92000001
#> 155        2025          Week 3  Local authority  England E92000001
#> 156        2025          Week 3  Local authority  England E92000001
#> 157        2025          Week 3  Local authority  England E92000001
#> 158        2025          Week 3  Local authority  England E92000001
#> 159        2025          Week 3  Local authority  England E92000001
#> 160        2025          Week 3  Local authority  England E92000001
#> 161        2025          Week 3  Local authority  England E92000001
#> 162        2025          Week 3  Local authority  England E92000001
#> 163        2025          Week 3  Local authority  England E92000001
#> 164        2025          Week 3  Local authority  England E92000001
#> 165        2025          Week 3  Local authority  England E92000001
#> 166        2025          Week 3  Local authority  England E92000001
#> 167        2025          Week 3  Local authority  England E92000001
#> 168        2025          Week 3  Local authority  England E92000001
#> 169        2025          Week 3  Local authority  England E92000001
#> 170        2025          Week 3  Local authority  England E92000001
#> 171        2025          Week 3  Local authority  England E92000001
#> 172        2025          Week 3  Local authority  England E92000001
#> 173        2025          Week 3  Local authority  England E92000001
#> 174        2025          Week 3  Local authority  England E92000001
#> 175        2025          Week 3  Local authority  England E92000001
#> 176        2025          Week 3  Local authority  England E92000001
#> 177        2025          Week 3  Local authority  England E92000001
#> 178        2025          Week 3  Local authority  England E92000001
#> 179        2025          Week 3  Local authority  England E92000001
#> 180        2025          Week 3  Local authority  England E92000001
#> 181        2025          Week 3  Local authority  England E92000001
#> 182        2025          Week 3  Local authority  England E92000001
#> 183        2025          Week 3  Local authority  England E92000001
#> 184        2025          Week 3  Local authority  England E92000001
#> 185        2025          Week 3  Local authority  England E92000001
#> 186        2025          Week 3  Local authority  England E92000001
#> 187        2025          Week 3  Local authority  England E92000001
#> 188        2025          Week 3  Local authority  England E92000001
#> 189        2025          Week 3  Local authority  England E92000001
#> 190        2025          Week 3  Local authority  England E92000001
#> 191        2025          Week 3  Local authority  England E92000001
#> 192        2025          Week 3  Local authority  England E92000001
#> 193        2025          Week 3  Local authority  England E92000001
#> 194        2025          Week 3  Local authority  England E92000001
#> 195        2025          Week 3  Local authority  England E92000001
#> 196        2025          Week 3  Local authority  England E92000001
#> 197        2025          Week 3  Local authority  England E92000001
#> 198        2025          Week 3  Local authority  England E92000001
#> 199        2025          Week 3  Local authority  England E92000001
#> 200        2025          Week 3  Local authority  England E92000001
#> 201        2025          Week 3  Local authority  England E92000001
#> 202        2025          Week 3  Local authority  England E92000001
#> 203        2025          Week 3  Local authority  England E92000001
#> 204        2025          Week 3  Local authority  England E92000001
#> 205        2025          Week 3  Local authority  England E92000001
#> 206        2025          Week 3  Local authority  England E92000001
#> 207        2025          Week 3  Local authority  England E92000001
#> 208        2025          Week 3  Local authority  England E92000001
#> 209        2025          Week 3  Local authority  England E92000001
#> 210        2025          Week 3  Local authority  England E92000001
#> 211        2025          Week 3  Local authority  England E92000001
#> 212        2025          Week 3  Local authority  England E92000001
#> 213        2025          Week 3  Local authority  England E92000001
#> 214        2025          Week 3  Local authority  England E92000001
#> 215        2025          Week 3  Local authority  England E92000001
#> 216        2025          Week 3  Local authority  England E92000001
#> 217        2025          Week 3  Local authority  England E92000001
#> 218        2025          Week 3  Local authority  England E92000001
#> 219        2025          Week 3  Local authority  England E92000001
#> 220        2025          Week 3  Local authority  England E92000001
#> 221        2025          Week 3  Local authority  England E92000001
#> 222        2025          Week 3  Local authority  England E92000001
#> 223        2025          Week 3  Local authority  England E92000001
#> 224        2025          Week 3  Local authority  England E92000001
#> 225        2025          Week 3  Local authority  England E92000001
#> 226        2025          Week 3  Local authority  England E92000001
#> 227        2025          Week 3  Local authority  England E92000001
#> 228        2025          Week 3  Local authority  England E92000001
#> 229        2025          Week 3  Local authority  England E92000001
#> 230        2025          Week 3  Local authority  England E92000001
#> 231        2025          Week 3  Local authority  England E92000001
#> 232        2025          Week 3  Local authority  England E92000001
#> 233        2025          Week 3  Local authority  England E92000001
#> 234        2025          Week 3  Local authority  England E92000001
#> 235        2025          Week 3  Local authority  England E92000001
#> 236        2025          Week 3  Local authority  England E92000001
#> 237        2025          Week 3  Local authority  England E92000001
#> 238        2025          Week 3  Local authority  England E92000001
#> 239        2025          Week 3  Local authority  England E92000001
#> 240        2025          Week 3  Local authority  England E92000001
#> 241        2025          Week 3  Local authority  England E92000001
#> 242        2025          Week 3  Local authority  England E92000001
#> 243        2025          Week 3  Local authority  England E92000001
#> 244        2025          Week 3  Local authority  England E92000001
#> 245        2025          Week 3  Local authority  England E92000001
#> 246        2025          Week 3  Local authority  England E92000001
#> 247        2025          Week 3  Local authority  England E92000001
#> 248        2025          Week 3  Local authority  England E92000001
#> 249        2025          Week 3  Local authority  England E92000001
#> 250        2025          Week 3  Local authority  England E92000001
#> 251        2025          Week 3  Local authority  England E92000001
#> 252        2025          Week 3  Local authority  England E92000001
#> 253        2025          Week 3  Local authority  England E92000001
#> 254        2025          Week 3  Local authority  England E92000001
#> 255        2025          Week 3  Local authority  England E92000001
#> 256        2025          Week 3  Local authority  England E92000001
#> 257        2025          Week 3  Local authority  England E92000001
#> 258        2025          Week 3  Local authority  England E92000001
#> 259        2025          Week 3  Local authority  England E92000001
#> 260        2025          Week 3  Local authority  England E92000001
#> 261        2025          Week 3  Local authority  England E92000001
#> 262        2025          Week 3  Local authority  England E92000001
#> 263        2025          Week 3  Local authority  England E92000001
#> 264        2025          Week 3  Local authority  England E92000001
#> 265        2025          Week 3  Local authority  England E92000001
#> 266        2025          Week 3  Local authority  England E92000001
#> 267        2025          Week 3  Local authority  England E92000001
#> 268        2025          Week 3  Local authority  England E92000001
#> 269        2025          Week 3  Local authority  England E92000001
#> 270        2025          Week 3  Local authority  England E92000001
#> 271        2025          Week 3  Local authority  England E92000001
#> 272        2025          Week 3  Local authority  England E92000001
#> 273        2025          Week 3  Local authority  England E92000001
#> 274        2025          Week 3  Local authority  England E92000001
#> 275        2025          Week 3  Local authority  England E92000001
#> 276        2025          Week 3  Local authority  England E92000001
#> 277        2025          Week 3  Local authority  England E92000001
#> 278        2025          Week 3  Local authority  England E92000001
#> 279        2025          Week 3  Local authority  England E92000001
#> 280        2025          Week 3  Local authority  England E92000001
#> 281        2025          Week 3  Local authority  England E92000001
#> 282        2025          Week 3  Local authority  England E92000001
#> 283        2025          Week 3  Local authority  England E92000001
#> 284        2025          Week 3  Local authority  England E92000001
#> 285        2025          Week 3  Local authority  England E92000001
#> 286        2025          Week 3  Local authority  England E92000001
#> 287        2025          Week 3  Local authority  England E92000001
#> 288        2025          Week 3  Local authority  England E92000001
#> 289        2025          Week 3  Local authority  England E92000001
#> 290        2025          Week 3  Local authority  England E92000001
#> 291        2025          Week 3  Local authority  England E92000001
#> 292        2025          Week 3  Local authority  England E92000001
#> 293        2025          Week 3  Local authority  England E92000001
#> 294        2025          Week 3  Local authority  England E92000001
#> 295        2025          Week 3  Local authority  England E92000001
#> 296        2025          Week 3  Local authority  England E92000001
#> 297        2025          Week 3  Local authority  England E92000001
#> 298        2025          Week 3  Local authority  England E92000001
#> 299        2025          Week 3  Local authority  England E92000001
#> 300        2025          Week 3  Local authority  England E92000001
#> 301        2025          Week 3  Local authority  England E92000001
#> 302        2025          Week 3  Local authority  England E92000001
#> 303        2025          Week 3  Local authority  England E92000001
#> 304        2025          Week 3  Local authority  England E92000001
#> 305        2025          Week 3  Local authority  England E92000001
#> 306        2025          Week 3  Local authority  England E92000001
#> 307        2025          Week 3  Local authority  England E92000001
#> 308        2025          Week 3  Local authority  England E92000001
#> 309        2025          Week 3  Local authority  England E92000001
#> 310        2025          Week 3  Local authority  England E92000001
#> 311        2025          Week 3  Local authority  England E92000001
#> 312        2025          Week 3  Local authority  England E92000001
#> 313        2025          Week 3  Local authority  England E92000001
#> 314        2025          Week 3  Local authority  England E92000001
#> 315        2025          Week 3  Local authority  England E92000001
#> 316        2025          Week 3  Local authority  England E92000001
#> 317        2025          Week 3  Local authority  England E92000001
#> 318        2025          Week 3  Local authority  England E92000001
#>                     reg_name  reg_code                     la_name   la_code
#> 1                       <NA>      <NA>                        <NA>      <NA>
#> 2                       <NA>      <NA>                        <NA>      <NA>
#> 3                       <NA>      <NA>                        <NA>      <NA>
#> 4                       <NA>      <NA>                        <NA>      <NA>
#> 5                       <NA>      <NA>                        <NA>      <NA>
#> 6                       <NA>      <NA>                        <NA>      <NA>
#> 7                       <NA>      <NA>                        <NA>      <NA>
#> 8                       <NA>      <NA>                        <NA>      <NA>
#> 9                       <NA>      <NA>                        <NA>      <NA>
#> 10                      <NA>      <NA>                        <NA>      <NA>
#> 11                      <NA>      <NA>                        <NA>      <NA>
#> 12                      <NA>      <NA>                        <NA>      <NA>
#> 13                      <NA>      <NA>                        <NA>      <NA>
#> 14                      <NA>      <NA>                        <NA>      <NA>
#> 15                      <NA>      <NA>                        <NA>      <NA>
#> 16                      <NA>      <NA>                        <NA>      <NA>
#> 17                      <NA>      <NA>                        <NA>      <NA>
#> 18                      <NA>      <NA>                        <NA>      <NA>
#> 19                      <NA>      <NA>                        <NA>      <NA>
#> 20                      <NA>      <NA>                        <NA>      <NA>
#> 21                      <NA>      <NA>                        <NA>      <NA>
#> 22                      <NA>      <NA>                        <NA>      <NA>
#> 23                      <NA>      <NA>                        <NA>      <NA>
#> 24                      <NA>      <NA>                        <NA>      <NA>
#> 25  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 26  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 27  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 28  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 29  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 30  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 31  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 32  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 33  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 34  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 35  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 36  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 37  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 38  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 39  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 40  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 41  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 42  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 43  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 44  Yorkshire and The Humber E12000003 Kingston upon Hull, City of E06000010
#> 45  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 46  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 47  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 48  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 49  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 50  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 51  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 52  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 53  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 54  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 55  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 56  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 57  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 58  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 59  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 60  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 61  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 62  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 63  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 64  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 65  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 66  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 67  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 68  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 69  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 70  Yorkshire and The Humber E12000003                        <NA>      <NA>
#> 71  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 72  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 73  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 74  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 75  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 76  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 77  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 78  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 79  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 80  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 81  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 82  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 83  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 84  Yorkshire and The Humber E12000003    East Riding of Yorkshire E06000011
#> 85  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 86  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 87  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 88  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 89  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 90  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 91  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 92  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 93  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 94  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 95  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 96  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 97  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 98  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 99  Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 100 Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 101 Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 102 Yorkshire and The Humber E12000003     North East Lincolnshire E06000012
#> 103 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 104 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 105 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 106 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 107 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 108 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 109 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 110 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 111 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 112 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 113 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 114 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 115 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 116 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 117 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 118 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 119 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 120 Yorkshire and The Humber E12000003          North Lincolnshire E06000013
#> 121 Yorkshire and The Humber E12000003                        York E06000014
#> 122 Yorkshire and The Humber E12000003                        York E06000014
#> 123 Yorkshire and The Humber E12000003                        York E06000014
#> 124 Yorkshire and The Humber E12000003                        York E06000014
#> 125 Yorkshire and The Humber E12000003                        York E06000014
#> 126 Yorkshire and The Humber E12000003                        York E06000014
#> 127 Yorkshire and The Humber E12000003                        York E06000014
#> 128 Yorkshire and The Humber E12000003                        York E06000014
#> 129 Yorkshire and The Humber E12000003                        York E06000014
#> 130 Yorkshire and The Humber E12000003                        York E06000014
#> 131 Yorkshire and The Humber E12000003                        York E06000014
#> 132 Yorkshire and The Humber E12000003                        York E06000014
#> 133 Yorkshire and The Humber E12000003                        York E06000014
#> 134 Yorkshire and The Humber E12000003                        York E06000014
#> 135 Yorkshire and The Humber E12000003                        York E06000014
#> 136 Yorkshire and The Humber E12000003                        York E06000014
#> 137 Yorkshire and The Humber E12000003                        York E06000014
#> 138 Yorkshire and The Humber E12000003                        York E06000014
#> 139 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 140 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 141 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 142 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 143 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 144 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 145 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 146 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 147 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 148 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 149 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 150 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 151 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 152 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 153 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 154 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 155 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 156 Yorkshire and The Humber E12000003             North Yorkshire E06000065
#> 157 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 158 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 159 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 160 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 161 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 162 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 163 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 164 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 165 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 166 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 167 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 168 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 169 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 170 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 171 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 172 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 173 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 174 Yorkshire and The Humber E12000003                    Barnsley E08000016
#> 175 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 176 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 177 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 178 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 179 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 180 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 181 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 182 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 183 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 184 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 185 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 186 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 187 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 188 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 189 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 190 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 191 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 192 Yorkshire and The Humber E12000003                   Doncaster E08000017
#> 193 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 194 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 195 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 196 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 197 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 198 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 199 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 200 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 201 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 202 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 203 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 204 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 205 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 206 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 207 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 208 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 209 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 210 Yorkshire and The Humber E12000003                   Rotherham E08000018
#> 211 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 212 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 213 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 214 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 215 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 216 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 217 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 218 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 219 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 220 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 221 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 222 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 223 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 224 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 225 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 226 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 227 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 228 Yorkshire and The Humber E12000003                   Sheffield E08000019
#> 229 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 230 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 231 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 232 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 233 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 234 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 235 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 236 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 237 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 238 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 239 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 240 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 241 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 242 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 243 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 244 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 245 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 246 Yorkshire and The Humber E12000003                    Bradford E08000032
#> 247 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 248 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 249 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 250 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 251 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 252 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 253 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 254 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 255 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 256 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 257 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 258 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 259 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 260 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 261 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 262 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 263 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 264 Yorkshire and The Humber E12000003                  Calderdale E08000033
#> 265 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 266 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 267 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 268 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 269 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 270 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 271 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 272 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 273 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 274 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 275 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 276 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 277 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 278 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 279 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 280 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 281 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 282 Yorkshire and The Humber E12000003                    Kirklees E08000034
#> 283 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 284 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 285 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 286 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 287 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 288 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 289 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 290 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 291 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 292 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 293 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 294 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 295 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 296 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 297 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 298 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 299 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 300 Yorkshire and The Humber E12000003                       Leeds E08000035
#> 301 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 302 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 303 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 304 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 305 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 306 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 307 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 308 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 309 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 310 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 311 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 312 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 313 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 314 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 315 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 316 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 317 Yorkshire and The Humber E12000003                   Wakefield E08000036
#> 318 Yorkshire and The Humber E12000003                   Wakefield E08000036
#>     la_oldCode attendance_reason attendance_status   attendance_type
#> 1         <NA> All late sessions     Late sessions All late sessions
#> 2         <NA> All late sessions     Late sessions All late sessions
#> 3         <NA> All late sessions     Late sessions All late sessions
#> 4         <NA> All late sessions     Late sessions All late sessions
#> 5         <NA> All late sessions     Late sessions All late sessions
#> 6         <NA> All late sessions     Late sessions All late sessions
#> 7         <NA> All late sessions     Late sessions All late sessions
#> 8         <NA> All late sessions     Late sessions All late sessions
#> 9         <NA> All late sessions     Late sessions All late sessions
#> 10        <NA> All late sessions     Late sessions All late sessions
#> 11        <NA> All late sessions     Late sessions All late sessions
#> 12        <NA> All late sessions     Late sessions All late sessions
#> 13        <NA> All late sessions     Late sessions All late sessions
#> 14        <NA> All late sessions     Late sessions All late sessions
#> 15        <NA> All late sessions     Late sessions All late sessions
#> 16        <NA> All late sessions     Late sessions All late sessions
#> 17        <NA> All late sessions     Late sessions All late sessions
#> 18        <NA> All late sessions     Late sessions All late sessions
#> 19        <NA> All late sessions     Late sessions All late sessions
#> 20        <NA> All late sessions     Late sessions All late sessions
#> 21        <NA> All late sessions     Late sessions All late sessions
#> 22        <NA> All late sessions     Late sessions All late sessions
#> 23        <NA> All late sessions     Late sessions All late sessions
#> 24        <NA> All late sessions     Late sessions All late sessions
#> 25        <NA> All late sessions     Late sessions All late sessions
#> 26        <NA> All late sessions     Late sessions All late sessions
#> 27         810 All late sessions     Late sessions All late sessions
#> 28         810 All late sessions     Late sessions All late sessions
#> 29         810 All late sessions     Late sessions All late sessions
#> 30         810 All late sessions     Late sessions All late sessions
#> 31         810 All late sessions     Late sessions All late sessions
#> 32         810 All late sessions     Late sessions All late sessions
#> 33         810 All late sessions     Late sessions All late sessions
#> 34         810 All late sessions     Late sessions All late sessions
#> 35         810 All late sessions     Late sessions All late sessions
#> 36         810 All late sessions     Late sessions All late sessions
#> 37         810 All late sessions     Late sessions All late sessions
#> 38         810 All late sessions     Late sessions All late sessions
#> 39         810 All late sessions     Late sessions All late sessions
#> 40         810 All late sessions     Late sessions All late sessions
#> 41         810 All late sessions     Late sessions All late sessions
#> 42         810 All late sessions     Late sessions All late sessions
#> 43         810 All late sessions     Late sessions All late sessions
#> 44         810 All late sessions     Late sessions All late sessions
#> 45         811 All late sessions     Late sessions All late sessions
#> 46         811 All late sessions     Late sessions All late sessions
#> 47         811 All late sessions     Late sessions All late sessions
#> 48         811 All late sessions     Late sessions All late sessions
#> 49        <NA> All late sessions     Late sessions All late sessions
#> 50        <NA> All late sessions     Late sessions All late sessions
#> 51        <NA> All late sessions     Late sessions All late sessions
#> 52        <NA> All late sessions     Late sessions All late sessions
#> 53        <NA> All late sessions     Late sessions All late sessions
#> 54        <NA> All late sessions     Late sessions All late sessions
#> 55        <NA> All late sessions     Late sessions All late sessions
#> 56        <NA> All late sessions     Late sessions All late sessions
#> 57        <NA> All late sessions     Late sessions All late sessions
#> 58        <NA> All late sessions     Late sessions All late sessions
#> 59        <NA> All late sessions     Late sessions All late sessions
#> 60        <NA> All late sessions     Late sessions All late sessions
#> 61        <NA> All late sessions     Late sessions All late sessions
#> 62        <NA> All late sessions     Late sessions All late sessions
#> 63        <NA> All late sessions     Late sessions All late sessions
#> 64        <NA> All late sessions     Late sessions All late sessions
#> 65        <NA> All late sessions     Late sessions All late sessions
#> 66        <NA> All late sessions     Late sessions All late sessions
#> 67        <NA> All late sessions     Late sessions All late sessions
#> 68        <NA> All late sessions     Late sessions All late sessions
#> 69        <NA> All late sessions     Late sessions All late sessions
#> 70        <NA> All late sessions     Late sessions All late sessions
#> 71         811 All late sessions     Late sessions All late sessions
#> 72         811 All late sessions     Late sessions All late sessions
#> 73         811 All late sessions     Late sessions All late sessions
#> 74         811 All late sessions     Late sessions All late sessions
#> 75         811 All late sessions     Late sessions All late sessions
#> 76         811 All late sessions     Late sessions All late sessions
#> 77         811 All late sessions     Late sessions All late sessions
#> 78         811 All late sessions     Late sessions All late sessions
#> 79         811 All late sessions     Late sessions All late sessions
#> 80         811 All late sessions     Late sessions All late sessions
#> 81         811 All late sessions     Late sessions All late sessions
#> 82         811 All late sessions     Late sessions All late sessions
#> 83         811 All late sessions     Late sessions All late sessions
#> 84         811 All late sessions     Late sessions All late sessions
#> 85         812 All late sessions     Late sessions All late sessions
#> 86         812 All late sessions     Late sessions All late sessions
#> 87         812 All late sessions     Late sessions All late sessions
#> 88         812 All late sessions     Late sessions All late sessions
#> 89         812 All late sessions     Late sessions All late sessions
#> 90         812 All late sessions     Late sessions All late sessions
#> 91         812 All late sessions     Late sessions All late sessions
#> 92         812 All late sessions     Late sessions All late sessions
#> 93         812 All late sessions     Late sessions All late sessions
#> 94         812 All late sessions     Late sessions All late sessions
#> 95         812 All late sessions     Late sessions All late sessions
#> 96         812 All late sessions     Late sessions All late sessions
#> 97         812 All late sessions     Late sessions All late sessions
#> 98         812 All late sessions     Late sessions All late sessions
#> 99         812 All late sessions     Late sessions All late sessions
#> 100        812 All late sessions     Late sessions All late sessions
#> 101        812 All late sessions     Late sessions All late sessions
#> 102        812 All late sessions     Late sessions All late sessions
#> 103        813 All late sessions     Late sessions All late sessions
#> 104        813 All late sessions     Late sessions All late sessions
#> 105        813 All late sessions     Late sessions All late sessions
#> 106        813 All late sessions     Late sessions All late sessions
#> 107        813 All late sessions     Late sessions All late sessions
#> 108        813 All late sessions     Late sessions All late sessions
#> 109        813 All late sessions     Late sessions All late sessions
#> 110        813 All late sessions     Late sessions All late sessions
#> 111        813 All late sessions     Late sessions All late sessions
#> 112        813 All late sessions     Late sessions All late sessions
#> 113        813 All late sessions     Late sessions All late sessions
#> 114        813 All late sessions     Late sessions All late sessions
#> 115        813 All late sessions     Late sessions All late sessions
#> 116        813 All late sessions     Late sessions All late sessions
#> 117        813 All late sessions     Late sessions All late sessions
#> 118        813 All late sessions     Late sessions All late sessions
#> 119        813 All late sessions     Late sessions All late sessions
#> 120        813 All late sessions     Late sessions All late sessions
#> 121        816 All late sessions     Late sessions All late sessions
#> 122        816 All late sessions     Late sessions All late sessions
#> 123        816 All late sessions     Late sessions All late sessions
#> 124        816 All late sessions     Late sessions All late sessions
#> 125        816 All late sessions     Late sessions All late sessions
#> 126        816 All late sessions     Late sessions All late sessions
#> 127        816 All late sessions     Late sessions All late sessions
#> 128        816 All late sessions     Late sessions All late sessions
#> 129        816 All late sessions     Late sessions All late sessions
#> 130        816 All late sessions     Late sessions All late sessions
#> 131        816 All late sessions     Late sessions All late sessions
#> 132        816 All late sessions     Late sessions All late sessions
#> 133        816 All late sessions     Late sessions All late sessions
#> 134        816 All late sessions     Late sessions All late sessions
#> 135        816 All late sessions     Late sessions All late sessions
#> 136        816 All late sessions     Late sessions All late sessions
#> 137        816 All late sessions     Late sessions All late sessions
#> 138        816 All late sessions     Late sessions All late sessions
#> 139        815 All late sessions     Late sessions All late sessions
#> 140        815 All late sessions     Late sessions All late sessions
#> 141        815 All late sessions     Late sessions All late sessions
#> 142        815 All late sessions     Late sessions All late sessions
#> 143        815 All late sessions     Late sessions All late sessions
#> 144        815 All late sessions     Late sessions All late sessions
#> 145        815 All late sessions     Late sessions All late sessions
#> 146        815 All late sessions     Late sessions All late sessions
#> 147        815 All late sessions     Late sessions All late sessions
#> 148        815 All late sessions     Late sessions All late sessions
#> 149        815 All late sessions     Late sessions All late sessions
#> 150        815 All late sessions     Late sessions All late sessions
#> 151        815 All late sessions     Late sessions All late sessions
#> 152        815 All late sessions     Late sessions All late sessions
#> 153        815 All late sessions     Late sessions All late sessions
#> 154        815 All late sessions     Late sessions All late sessions
#> 155        815 All late sessions     Late sessions All late sessions
#> 156        815 All late sessions     Late sessions All late sessions
#> 157        370 All late sessions     Late sessions All late sessions
#> 158        370 All late sessions     Late sessions All late sessions
#> 159        370 All late sessions     Late sessions All late sessions
#> 160        370 All late sessions     Late sessions All late sessions
#> 161        370 All late sessions     Late sessions All late sessions
#> 162        370 All late sessions     Late sessions All late sessions
#> 163        370 All late sessions     Late sessions All late sessions
#> 164        370 All late sessions     Late sessions All late sessions
#> 165        370 All late sessions     Late sessions All late sessions
#> 166        370 All late sessions     Late sessions All late sessions
#> 167        370 All late sessions     Late sessions All late sessions
#> 168        370 All late sessions     Late sessions All late sessions
#> 169        370 All late sessions     Late sessions All late sessions
#> 170        370 All late sessions     Late sessions All late sessions
#> 171        370 All late sessions     Late sessions All late sessions
#> 172        370 All late sessions     Late sessions All late sessions
#> 173        370 All late sessions     Late sessions All late sessions
#> 174        370 All late sessions     Late sessions All late sessions
#> 175        371 All late sessions     Late sessions All late sessions
#> 176        371 All late sessions     Late sessions All late sessions
#> 177        371 All late sessions     Late sessions All late sessions
#> 178        371 All late sessions     Late sessions All late sessions
#> 179        371 All late sessions     Late sessions All late sessions
#> 180        371 All late sessions     Late sessions All late sessions
#> 181        371 All late sessions     Late sessions All late sessions
#> 182        371 All late sessions     Late sessions All late sessions
#> 183        371 All late sessions     Late sessions All late sessions
#> 184        371 All late sessions     Late sessions All late sessions
#> 185        371 All late sessions     Late sessions All late sessions
#> 186        371 All late sessions     Late sessions All late sessions
#> 187        371 All late sessions     Late sessions All late sessions
#> 188        371 All late sessions     Late sessions All late sessions
#> 189        371 All late sessions     Late sessions All late sessions
#> 190        371 All late sessions     Late sessions All late sessions
#> 191        371 All late sessions     Late sessions All late sessions
#> 192        371 All late sessions     Late sessions All late sessions
#> 193        372 All late sessions     Late sessions All late sessions
#> 194        372 All late sessions     Late sessions All late sessions
#> 195        372 All late sessions     Late sessions All late sessions
#> 196        372 All late sessions     Late sessions All late sessions
#> 197        372 All late sessions     Late sessions All late sessions
#> 198        372 All late sessions     Late sessions All late sessions
#> 199        372 All late sessions     Late sessions All late sessions
#> 200        372 All late sessions     Late sessions All late sessions
#> 201        372 All late sessions     Late sessions All late sessions
#> 202        372 All late sessions     Late sessions All late sessions
#> 203        372 All late sessions     Late sessions All late sessions
#> 204        372 All late sessions     Late sessions All late sessions
#> 205        372 All late sessions     Late sessions All late sessions
#> 206        372 All late sessions     Late sessions All late sessions
#> 207        372 All late sessions     Late sessions All late sessions
#> 208        372 All late sessions     Late sessions All late sessions
#> 209        372 All late sessions     Late sessions All late sessions
#> 210        372 All late sessions     Late sessions All late sessions
#> 211        373 All late sessions     Late sessions All late sessions
#> 212        373 All late sessions     Late sessions All late sessions
#> 213        373 All late sessions     Late sessions All late sessions
#> 214        373 All late sessions     Late sessions All late sessions
#> 215        373 All late sessions     Late sessions All late sessions
#> 216        373 All late sessions     Late sessions All late sessions
#> 217        373 All late sessions     Late sessions All late sessions
#> 218        373 All late sessions     Late sessions All late sessions
#> 219        373 All late sessions     Late sessions All late sessions
#> 220        373 All late sessions     Late sessions All late sessions
#> 221        373 All late sessions     Late sessions All late sessions
#> 222        373 All late sessions     Late sessions All late sessions
#> 223        373 All late sessions     Late sessions All late sessions
#> 224        373 All late sessions     Late sessions All late sessions
#> 225        373 All late sessions     Late sessions All late sessions
#> 226        373 All late sessions     Late sessions All late sessions
#> 227        373 All late sessions     Late sessions All late sessions
#> 228        373 All late sessions     Late sessions All late sessions
#> 229        380 All late sessions     Late sessions All late sessions
#> 230        380 All late sessions     Late sessions All late sessions
#> 231        380 All late sessions     Late sessions All late sessions
#> 232        380 All late sessions     Late sessions All late sessions
#> 233        380 All late sessions     Late sessions All late sessions
#> 234        380 All late sessions     Late sessions All late sessions
#> 235        380 All late sessions     Late sessions All late sessions
#> 236        380 All late sessions     Late sessions All late sessions
#> 237        380 All late sessions     Late sessions All late sessions
#> 238        380 All late sessions     Late sessions All late sessions
#> 239        380 All late sessions     Late sessions All late sessions
#> 240        380 All late sessions     Late sessions All late sessions
#> 241        380 All late sessions     Late sessions All late sessions
#> 242        380 All late sessions     Late sessions All late sessions
#> 243        380 All late sessions     Late sessions All late sessions
#> 244        380 All late sessions     Late sessions All late sessions
#> 245        380 All late sessions     Late sessions All late sessions
#> 246        380 All late sessions     Late sessions All late sessions
#> 247        381 All late sessions     Late sessions All late sessions
#> 248        381 All late sessions     Late sessions All late sessions
#> 249        381 All late sessions     Late sessions All late sessions
#> 250        381 All late sessions     Late sessions All late sessions
#> 251        381 All late sessions     Late sessions All late sessions
#> 252        381 All late sessions     Late sessions All late sessions
#> 253        381 All late sessions     Late sessions All late sessions
#> 254        381 All late sessions     Late sessions All late sessions
#> 255        381 All late sessions     Late sessions All late sessions
#> 256        381 All late sessions     Late sessions All late sessions
#> 257        381 All late sessions     Late sessions All late sessions
#> 258        381 All late sessions     Late sessions All late sessions
#> 259        381 All late sessions     Late sessions All late sessions
#> 260        381 All late sessions     Late sessions All late sessions
#> 261        381 All late sessions     Late sessions All late sessions
#> 262        381 All late sessions     Late sessions All late sessions
#> 263        381 All late sessions     Late sessions All late sessions
#> 264        381 All late sessions     Late sessions All late sessions
#> 265        382 All late sessions     Late sessions All late sessions
#> 266        382 All late sessions     Late sessions All late sessions
#> 267        382 All late sessions     Late sessions All late sessions
#> 268        382 All late sessions     Late sessions All late sessions
#> 269        382 All late sessions     Late sessions All late sessions
#> 270        382 All late sessions     Late sessions All late sessions
#> 271        382 All late sessions     Late sessions All late sessions
#> 272        382 All late sessions     Late sessions All late sessions
#> 273        382 All late sessions     Late sessions All late sessions
#> 274        382 All late sessions     Late sessions All late sessions
#> 275        382 All late sessions     Late sessions All late sessions
#> 276        382 All late sessions     Late sessions All late sessions
#> 277        382 All late sessions     Late sessions All late sessions
#> 278        382 All late sessions     Late sessions All late sessions
#> 279        382 All late sessions     Late sessions All late sessions
#> 280        382 All late sessions     Late sessions All late sessions
#> 281        382 All late sessions     Late sessions All late sessions
#> 282        382 All late sessions     Late sessions All late sessions
#> 283        383 All late sessions     Late sessions All late sessions
#> 284        383 All late sessions     Late sessions All late sessions
#> 285        383 All late sessions     Late sessions All late sessions
#> 286        383 All late sessions     Late sessions All late sessions
#> 287        383 All late sessions     Late sessions All late sessions
#> 288        383 All late sessions     Late sessions All late sessions
#> 289        383 All late sessions     Late sessions All late sessions
#> 290        383 All late sessions     Late sessions All late sessions
#> 291        383 All late sessions     Late sessions All late sessions
#> 292        383 All late sessions     Late sessions All late sessions
#> 293        383 All late sessions     Late sessions All late sessions
#> 294        383 All late sessions     Late sessions All late sessions
#> 295        383 All late sessions     Late sessions All late sessions
#> 296        383 All late sessions     Late sessions All late sessions
#> 297        383 All late sessions     Late sessions All late sessions
#> 298        383 All late sessions     Late sessions All late sessions
#> 299        383 All late sessions     Late sessions All late sessions
#> 300        383 All late sessions     Late sessions All late sessions
#> 301        384 All late sessions     Late sessions All late sessions
#> 302        384 All late sessions     Late sessions All late sessions
#> 303        384 All late sessions     Late sessions All late sessions
#> 304        384 All late sessions     Late sessions All late sessions
#> 305        384 All late sessions     Late sessions All late sessions
#> 306        384 All late sessions     Late sessions All late sessions
#> 307        384 All late sessions     Late sessions All late sessions
#> 308        384 All late sessions     Late sessions All late sessions
#> 309        384 All late sessions     Late sessions All late sessions
#> 310        384 All late sessions     Late sessions All late sessions
#> 311        384 All late sessions     Late sessions All late sessions
#> 312        384 All late sessions     Late sessions All late sessions
#> 313        384 All late sessions     Late sessions All late sessions
#> 314        384 All late sessions     Late sessions All late sessions
#> 315        384 All late sessions     Late sessions All late sessions
#> 316        384 All late sessions     Late sessions All late sessions
#> 317        384 All late sessions     Late sessions All late sessions
#> 318        384 All late sessions     Late sessions All late sessions
#>     education_phase time_frame session_count
#> 1       All schools     Monday        351534
#> 2       All schools    Tuesday        339756
#> 3       All schools  Wednesday        332987
#> 4       All schools   Thursday        325941
#> 5       All schools     Friday        291093
#> 6       All schools       Week       1641311
#> 7           Primary     Monday        119186
#> 8           Primary    Tuesday        108155
#> 9           Primary  Wednesday        104042
#> 10          Primary   Thursday        103412
#> 11          Primary     Friday         88889
#> 12          Primary       Week        523684
#> 13        Secondary     Monday        228689
#> 14        Secondary    Tuesday        227938
#> 15        Secondary  Wednesday        225532
#> 16        Secondary   Thursday        219220
#> 17        Secondary     Friday        199514
#> 18        Secondary       Week       1100893
#> 19          Special     Monday          3659
#> 20          Special    Tuesday          3663
#> 21          Special  Wednesday          3413
#> 22          Special   Thursday          3309
#> 23          Special     Friday          2690
#> 24          Special       Week         16734
#> 25      All schools     Monday         37867
#> 26      All schools    Tuesday         37113
#> 27          Primary     Monday           655
#> 28          Primary    Tuesday           656
#> 29          Primary  Wednesday           592
#> 30          Primary   Thursday           675
#> 31          Primary     Friday           486
#> 32          Primary       Week          3064
#> 33        Secondary     Monday          1429
#> 34        Secondary    Tuesday          1434
#> 35        Secondary  Wednesday          1289
#> 36        Secondary   Thursday          1450
#> 37        Secondary     Friday          1226
#> 38        Secondary       Week          6828
#> 39          Special     Monday             4
#> 40          Special    Tuesday             2
#> 41          Special  Wednesday            11
#> 42          Special   Thursday             6
#> 43          Special     Friday             4
#> 44          Special       Week            27
#> 45          Primary     Monday           400
#> 46          Primary    Tuesday           314
#> 47          Primary  Wednesday           343
#> 48          Primary   Thursday           391
#> 49      All schools  Wednesday         36144
#> 50      All schools   Thursday         36575
#> 51      All schools     Friday         31466
#> 52      All schools       Week        179165
#> 53          Primary     Monday         12071
#> 54          Primary    Tuesday         11636
#> 55          Primary  Wednesday         11219
#> 56          Primary   Thursday         12043
#> 57          Primary     Friday          9663
#> 58          Primary       Week         56632
#> 59        Secondary     Monday         25538
#> 60        Secondary    Tuesday         25199
#> 61        Secondary  Wednesday         24658
#> 62        Secondary   Thursday         24261
#> 63        Secondary     Friday         21599
#> 64        Secondary       Week        121255
#> 65          Special     Monday           258
#> 66          Special    Tuesday           278
#> 67          Special  Wednesday           267
#> 68          Special   Thursday           271
#> 69          Special     Friday           204
#> 70          Special       Week          1278
#> 71          Primary     Friday           298
#> 72          Primary       Week          1746
#> 73        Secondary     Monday          1061
#> 74        Secondary    Tuesday          1038
#> 75        Secondary  Wednesday          1011
#> 76        Secondary   Thursday          1036
#> 77        Secondary     Friday           835
#> 78        Secondary       Week          4981
#> 79          Special     Monday             1
#> 80          Special    Tuesday             1
#> 81          Special  Wednesday             3
#> 82          Special   Thursday             3
#> 83          Special     Friday             1
#> 84          Special       Week             9
#> 85          Primary     Monday           266
#> 86          Primary    Tuesday           278
#> 87          Primary  Wednesday           307
#> 88          Primary   Thursday           315
#> 89          Primary     Friday           226
#> 90          Primary       Week          1392
#> 91        Secondary     Monday           461
#> 92        Secondary    Tuesday           469
#> 93        Secondary  Wednesday           463
#> 94        Secondary   Thursday           488
#> 95        Secondary     Friday           430
#> 96        Secondary       Week          2311
#> 97          Special     Monday             6
#> 98          Special    Tuesday             5
#> 99          Special  Wednesday             1
#> 100         Special   Thursday             3
#> 101         Special     Friday             5
#> 102         Special       Week            20
#> 103         Primary     Monday           351
#> 104         Primary    Tuesday           253
#> 105         Primary  Wednesday           247
#> 106         Primary   Thursday           316
#> 107         Primary     Friday           213
#> 108         Primary       Week          1380
#> 109       Secondary     Monday           480
#> 110       Secondary    Tuesday           466
#> 111       Secondary  Wednesday           431
#> 112       Secondary   Thursday           490
#> 113       Secondary     Friday           392
#> 114       Secondary       Week          2259
#> 115         Special     Monday             6
#> 116         Special    Tuesday             6
#> 117         Special  Wednesday             3
#> 118         Special   Thursday             8
#> 119         Special     Friday             3
#> 120         Special       Week            26
#> 121         Primary     Monday           268
#> 122         Primary    Tuesday           257
#> 123         Primary  Wednesday           252
#> 124         Primary   Thursday           307
#> 125         Primary     Friday           260
#> 126         Primary       Week          1344
#> 127       Secondary     Monday           770
#> 128       Secondary    Tuesday           554
#> 129       Secondary  Wednesday           712
#> 130       Secondary   Thursday           586
#> 131       Secondary     Friday           656
#> 132       Secondary       Week          3278
#> 133         Special     Monday             8
#> 134         Special    Tuesday            10
#> 135         Special  Wednesday             3
#> 136         Special   Thursday             8
#> 137         Special     Friday             7
#> 138         Special       Week            36
#> 139         Primary     Monday           782
#> 140         Primary    Tuesday           795
#> 141         Primary  Wednesday           749
#> 142         Primary   Thursday           783
#> 143         Primary     Friday           659
#> 144         Primary       Week          3768
#> 145       Secondary     Monday          1855
#> 146       Secondary    Tuesday          1841
#> 147       Secondary  Wednesday          1887
#> 148       Secondary   Thursday          1798
#> 149       Secondary     Friday          1643
#> 150       Secondary       Week          9024
#> 151         Special     Monday             6
#> 152         Special    Tuesday            19
#> 153         Special  Wednesday            19
#> 154         Special   Thursday            13
#> 155         Special     Friday             8
#> 156         Special       Week            65
#> 157         Primary     Monday           470
#> 158         Primary    Tuesday           386
#> 159         Primary  Wednesday           391
#> 160         Primary   Thursday           391
#> 161         Primary     Friday           320
#> 162         Primary       Week          1958
#> 163       Secondary     Monday           978
#> 164       Secondary    Tuesday           876
#> 165       Secondary  Wednesday           776
#> 166       Secondary   Thursday           793
#> 167       Secondary     Friday           736
#> 168       Secondary       Week          4159
#> 169         Special     Monday            13
#> 170         Special    Tuesday             5
#> 171         Special  Wednesday            10
#> 172         Special   Thursday             3
#> 173         Special     Friday             9
#> 174         Special       Week            40
#> 175         Primary     Monday           638
#> 176         Primary    Tuesday           674
#> 177         Primary  Wednesday           557
#> 178         Primary   Thursday           669
#> 179         Primary     Friday           518
#> 180         Primary       Week          3056
#> 181       Secondary     Monday          1017
#> 182       Secondary    Tuesday          1191
#> 183       Secondary  Wednesday           887
#> 184       Secondary   Thursday          1040
#> 185       Secondary     Friday           948
#> 186       Secondary       Week          5083
#> 187         Special     Monday             7
#> 188         Special    Tuesday             3
#> 189         Special  Wednesday             9
#> 190         Special   Thursday             6
#> 191         Special     Friday             6
#> 192         Special       Week            31
#> 193         Primary     Monday           663
#> 194         Primary    Tuesday           536
#> 195         Primary  Wednesday           546
#> 196         Primary   Thursday           586
#> 197         Primary     Friday           516
#> 198         Primary       Week          2847
#> 199       Secondary     Monday          1353
#> 200       Secondary    Tuesday          1311
#> 201       Secondary  Wednesday          1203
#> 202       Secondary   Thursday          1186
#> 203       Secondary     Friday          1160
#> 204       Secondary       Week          6213
#> 205         Special     Monday            24
#> 206         Special    Tuesday            12
#> 207         Special  Wednesday            17
#> 208         Special   Thursday            18
#> 209         Special     Friday             7
#> 210         Special       Week            78
#> 211         Primary     Monday          2114
#> 212         Primary    Tuesday          1755
#> 213         Primary  Wednesday          1496
#> 214         Primary   Thursday          1609
#> 215         Primary     Friday          1333
#> 216         Primary       Week          8307
#> 217       Secondary     Monday          3770
#> 218       Secondary    Tuesday          3476
#> 219       Secondary  Wednesday          3111
#> 220       Secondary   Thursday          3111
#> 221       Secondary     Friday          2760
#> 222       Secondary       Week         16228
#> 223         Special     Monday            20
#> 224         Special    Tuesday            22
#> 225         Special  Wednesday            22
#> 226         Special   Thursday            18
#> 227         Special     Friday            13
#> 228         Special       Week            95
#> 229         Primary     Monday           965
#> 230         Primary    Tuesday          1669
#> 231         Primary  Wednesday          1900
#> 232         Primary   Thursday          1846
#> 233         Primary     Friday          1460
#> 234         Primary       Week          7840
#> 235       Secondary     Monday          2426
#> 236       Secondary    Tuesday          3139
#> 237       Secondary  Wednesday          3400
#> 238       Secondary   Thursday          3375
#> 239       Secondary     Friday          2908
#> 240       Secondary       Week         15248
#> 241         Special     Monday            31
#> 242         Special    Tuesday            43
#> 243         Special  Wednesday            37
#> 244         Special   Thursday            43
#> 245         Special     Friday            35
#> 246         Special       Week           189
#> 247         Primary     Monday           421
#> 248         Primary    Tuesday           416
#> 249         Primary  Wednesday           424
#> 250         Primary   Thursday           390
#> 251         Primary     Friday           347
#> 252         Primary       Week          1998
#> 253       Secondary     Monday          1957
#> 254       Secondary    Tuesday          1788
#> 255       Secondary  Wednesday          1631
#> 256       Secondary   Thursday          1464
#> 257       Secondary     Friday          1119
#> 258       Secondary       Week          7959
#> 259         Special     Monday             4
#> 260         Special    Tuesday            13
#> 261         Special  Wednesday             9
#> 262         Special   Thursday             6
#> 263         Special     Friday             5
#> 264         Special       Week            37
#> 265         Primary     Monday           975
#> 266         Primary    Tuesday           885
#> 267         Primary  Wednesday           834
#> 268         Primary   Thursday           860
#> 269         Primary     Friday           736
#> 270         Primary       Week          4290
#> 271       Secondary     Monday          1973
#> 272       Secondary    Tuesday          2038
#> 273       Secondary  Wednesday          1993
#> 274       Secondary   Thursday          1900
#> 275       Secondary     Friday          1723
#> 276       Secondary       Week          9627
#> 277         Special     Monday             6
#> 278         Special    Tuesday             8
#> 279         Special  Wednesday             7
#> 280         Special   Thursday             3
#> 281         Special     Friday             5
#> 282         Special       Week            29
#> 283         Primary     Monday          2413
#> 284         Primary    Tuesday          2182
#> 285         Primary  Wednesday          2009
#> 286         Primary   Thursday          2294
#> 287         Primary     Friday          1795
#> 288         Primary       Week         10693
#> 289       Secondary     Monday          4568
#> 290       Secondary    Tuesday          4219
#> 291       Secondary  Wednesday          4554
#> 292       Secondary   Thursday          4146
#> 293       Secondary     Friday          3804
#> 294       Secondary       Week         21291
#> 295         Special     Monday           121
#> 296         Special    Tuesday           128
#> 297         Special  Wednesday           114
#> 298         Special   Thursday           132
#> 299         Special     Friday            94
#> 300         Special       Week           589
#> 301         Primary     Monday           690
#> 302         Primary    Tuesday           580
#> 303         Primary  Wednesday           572
#> 304         Primary   Thursday           611
#> 305         Primary     Friday           496
#> 306         Primary       Week          2949
#> 307       Secondary     Monday          1440
#> 308       Secondary    Tuesday          1359
#> 309       Secondary  Wednesday          1310
#> 310       Secondary   Thursday          1398
#> 311       Secondary     Friday          1259
#> 312       Secondary       Week          6766
#> 313         Special     Monday             1
#> 314         Special    Tuesday             1
#> 315         Special  Wednesday             2
#> 316         Special   Thursday             1
#> 317         Special     Friday             2
#> 318         Special       Week             7

# Run a basic query using GET instead of POST
query_dataset(
  example_id(),
  method = "GET",
  geographies = "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')
#>    time_period time_identifier geographic_level nat_name  nat_code
#> 1         2025         Week 30         National  England E92000001
#> 2         2025         Week 28         National  England E92000001
#> 3         2025         Week 26         National  England E92000001
#> 4         2025         Week 24         National  England E92000001
#> 5         2025         Week 21         National  England E92000001
#> 6         2025         Week 20         National  England E92000001
#> 7         2025         Week 18         National  England E92000001
#> 8         2025         Week 15         National  England E92000001
#> 9         2025         Week 14         National  England E92000001
#> 10        2025         Week 12         National  England E92000001
#>    education_phase persistent_absence_percent
#> 1          Primary                       13.5
#> 2          Primary                      13.41
#> 3          Primary                      13.46
#> 4          Primary                      13.57
#> 5          Primary                      13.42
#> 6          Primary                      13.41
#> 7          Primary                      13.76
#> 8          Primary                       14.1
#> 9          Primary                      14.15
#> 10         Primary                      14.06