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 East
#> 2         2025          Week 3         Regional  England E92000001 North East
#> 3         2025          Week 3         Regional  England E92000001 North East
#> 4         2025          Week 3         Regional  England E92000001 North East
#> 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 West
#> 18        2025          Week 3         Regional  England E92000001 North West
#> 19        2025          Week 3         Regional  England E92000001 North West
#> 20        2025          Week 3         Regional  England E92000001 North West
#> 21        2025          Week 3         Regional  England E92000001 North West
#> 22        2025          Week 3         Regional  England E92000001 North West
#> 23        2025          Week 3         Regional  England E92000001 North West
#> 24        2025          Week 3         Regional  England E92000001 North West
#> 25        2025          Week 3         Regional  England E92000001 North West
#> 26        2025          Week 3         Regional  England E92000001 North West
#> 27        2025          Week 3         Regional  England E92000001 North West
#> 28        2025          Week 3         Regional  England E92000001 North West
#> 29        2025          Week 3         Regional  England E92000001 North West
#> 30        2025          Week 3         Regional  England E92000001 North West
#> 31        2025          Week 3         Regional  England E92000001 North West
#> 32        2025          Week 3         Regional  England E92000001 North West
#>     reg_code                 attendance_reason attendance_status
#> 1  E12000001 All approved educational activity        Attendance
#> 2  E12000001             All possible sessions Possible sessions
#> 3  E12000001            Education off site (b)        Attendance
#> 4  E12000001                     Interview (j)        Attendance
#> 5  E12000001    Approved sporting activity (p)        Attendance
#> 6  E12000001        Educational visit trip (v)        Attendance
#> 7  E12000001               Work experience (w)        Attendance
#> 8  E12000001      Education arranged by LA (k)        Attendance
#> 9  E12000001 All approved educational activity        Attendance
#> 10 E12000001             All possible sessions Possible sessions
#> 11 E12000001            Education off site (b)        Attendance
#> 12 E12000001                     Interview (j)        Attendance
#> 13 E12000001    Approved sporting activity (p)        Attendance
#> 14 E12000001        Educational visit trip (v)        Attendance
#> 15 E12000001               Work experience (w)        Attendance
#> 16 E12000001      Education arranged by LA (k)        Attendance
#> 17 E12000002 All approved educational activity        Attendance
#> 18 E12000002             All possible sessions Possible sessions
#> 19 E12000002            Education off site (b)        Attendance
#> 20 E12000002                     Interview (j)        Attendance
#> 21 E12000002    Approved sporting activity (p)        Attendance
#> 22 E12000002        Educational visit trip (v)        Attendance
#> 23 E12000002               Work experience (w)        Attendance
#> 24 E12000002      Education arranged by LA (k)        Attendance
#> 25 E12000002 All approved educational activity        Attendance
#> 26 E12000002             All possible sessions Possible sessions
#> 27 E12000002            Education off site (b)        Attendance
#> 28 E12000002                     Interview (j)        Attendance
#> 29 E12000002    Approved sporting activity (p)        Attendance
#> 30 E12000002        Educational visit trip (v)        Attendance
#> 31 E12000002               Work experience (w)        Attendance
#> 32 E12000002      Education arranged by LA (k)        Attendance
#>                  attendance_type education_phase time_frame session_count
#> 1  Approved educational activity     All schools       Week         21584
#> 2          All possible sessions     All schools       Week       3237578
#> 3  Approved educational activity     All schools       Week          7216
#> 4  Approved educational activity     All schools       Week             0
#> 5  Approved educational activity     All schools       Week          2896
#> 6  Approved educational activity     All schools       Week          9049
#> 7  Approved educational activity     All schools       Week           519
#> 8  Approved educational activity     All schools       Week          1904
#> 9  Approved educational activity         Primary       Week          7173
#> 10         All possible sessions         Primary       Week       1658991
#> 11 Approved educational activity         Primary       Week          1088
#> 12 Approved educational activity         Primary       Week             0
#> 13 Approved educational activity         Primary       Week          1159
#> 14 Approved educational activity         Primary       Week          4793
#> 15 Approved educational activity         Primary       Week             0
#> 16 Approved educational activity         Primary       Week           133
#> 17 Approved educational activity     All schools       Week         56450
#> 18         All possible sessions     All schools       Week       9714685
#> 19 Approved educational activity     All schools       Week         20796
#> 20 Approved educational activity     All schools       Week             0
#> 21 Approved educational activity     All schools       Week          6720
#> 22 Approved educational activity     All schools       Week         23925
#> 23 Approved educational activity     All schools       Week          2054
#> 24 Approved educational activity     All schools       Week          2955
#> 25 Approved educational activity         Primary       Week         19296
#> 26         All possible sessions         Primary       Week       5175969
#> 27 Approved educational activity         Primary       Week          4707
#> 28 Approved educational activity         Primary       Week             0
#> 29 Approved educational activity         Primary       Week          2963
#> 30 Approved educational activity         Primary       Week         11224
#> 31 Approved educational activity         Primary       Week             0
#> 32 Approved educational activity         Primary       Week           402

# 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         National  England E92000001       <NA>
#> 6         2025          Week 3         National  England E92000001       <NA>
#> 7         2025          Week 3         National  England E92000001       <NA>
#> 8         2025          Week 3         National  England E92000001       <NA>
#> 9         2025          Week 3         National  England E92000001       <NA>
#> 10        2025          Week 3         National  England E92000001       <NA>
#> 11        2025          Week 3         National  England E92000001       <NA>
#> 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         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   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 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 E12000001 All late sessions     Late sessions All late sessions
#> 30 E12000001 All late sessions     Late sessions All late sessions
#> 31 E12000001 All late sessions     Late sessions All late sessions
#> 32 E12000001 All late sessions     Late sessions All late sessions
#>    education_phase time_frame session_count
#> 1      All schools     Monday        351238
#> 2      All schools    Tuesday        339489
#> 3      All schools  Wednesday        332601
#> 4      All schools   Thursday        325478
#> 5      All schools     Friday        290697
#> 6      All schools       Week       1639503
#> 7          Primary     Monday        119171
#> 8          Primary    Tuesday        108143
#> 9          Primary  Wednesday        104015
#> 10         Primary   Thursday        103341
#> 11         Primary     Friday         88855
#> 12     All schools     Monday         15824
#> 13     All schools    Tuesday         15002
#> 14     All schools  Wednesday         14633
#> 15     All schools   Thursday         14208
#> 16     All schools     Friday         12887
#> 17     All schools       Week         72554
#> 18         Primary     Monday          5341
#> 19         Primary    Tuesday          4628
#> 20         Primary  Wednesday          4408
#> 21         Primary   Thursday          4409
#> 22         Primary     Friday          3786
#> 23         Primary       Week         22572
#> 24       Secondary     Monday         10316
#> 25       Secondary    Tuesday         10227
#> 26       Secondary  Wednesday         10074
#> 27       Secondary   Thursday          9671
#> 28       Secondary     Friday          8983
#> 29       Secondary       Week         49271
#> 30         Special     Monday           167
#> 31         Special    Tuesday           147
#> 32         Special  Wednesday           151

# 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        427478
#> 2          All possible sessions     All schools       Week      69869231
#> 3  Approved educational activity     All schools       Week        133255
#> 4  Approved educational activity     All schools       Week             1
#> 5  Approved educational activity     All schools       Week         54001
#> 6  Approved educational activity     All schools       Week        202378
#> 7  Approved educational activity     All schools       Week         11022
#> 8  Approved educational activity     All schools       Week         26821
#> 9  Approved educational activity         Primary       Week        162477
#> 10         All possible sessions         Primary       Week      36942021
#> 11 Approved educational activity         Primary       Week         27262
#> 12 Approved educational activity         Primary       Week             1
#> 13 Approved educational activity         Primary       Week         23549
#> 14 Approved educational activity         Primary       Week        107039
#> 15 Approved educational activity         Primary       Week            58
#> 16 Approved educational activity         Primary       Week          4568

# 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                     la_name
#> 1          2025          Week 3  Local authority                    Barnsley
#> 2          2025          Week 3  Local authority                    Barnsley
#> 3          2025          Week 3  Local authority                    Barnsley
#> 4          2025          Week 3  Local authority                    Barnsley
#> 5          2025          Week 3  Local authority                    Barnsley
#> 6          2025          Week 3  Local authority                    Barnsley
#> 7          2025          Week 3  Local authority                    Barnsley
#> 8          2025          Week 3  Local authority                    Barnsley
#> 9          2025          Week 3  Local authority                    Barnsley
#> 10         2025          Week 3  Local authority                    Barnsley
#> 11         2025          Week 3  Local authority                    Barnsley
#> 12         2025          Week 3  Local authority                    Barnsley
#> 13         2025          Week 3  Local authority                    Barnsley
#> 14         2025          Week 3  Local authority                    Barnsley
#> 15         2025          Week 3  Local authority                   Doncaster
#> 16         2025          Week 3  Local authority                   Doncaster
#> 17         2025          Week 3  Local authority                   Doncaster
#> 18         2025          Week 3  Local authority                   Doncaster
#> 19         2025          Week 3  Local authority                   Doncaster
#> 20         2025          Week 3  Local authority                   Doncaster
#> 21         2025          Week 3  Local authority                   Doncaster
#> 22         2025          Week 3  Local authority                   Doncaster
#> 23         2025          Week 3  Local authority                   Doncaster
#> 24         2025          Week 3  Local authority                   Doncaster
#> 25         2025          Week 3  Local authority                   Doncaster
#> 26         2025          Week 3  Local authority                   Doncaster
#> 27         2025          Week 3  Local authority                   Doncaster
#> 28         2025          Week 3  Local authority                   Doncaster
#> 29         2025          Week 3  Local authority                   Doncaster
#> 30         2025          Week 3  Local authority                   Doncaster
#> 31         2025          Week 3  Local authority                   Doncaster
#> 32         2025          Week 3  Local authority                   Doncaster
#> 33         2025          Week 3  Local authority                   Rotherham
#> 34         2025          Week 3  Local authority                   Rotherham
#> 35         2025          Week 3  Local authority                   Rotherham
#> 36         2025          Week 3  Local authority                   Rotherham
#> 37         2025          Week 3  Local authority                   Rotherham
#> 38         2025          Week 3  Local authority                   Rotherham
#> 39         2025          Week 3  Local authority                   Rotherham
#> 40         2025          Week 3  Local authority                   Rotherham
#> 41         2025          Week 3  Local authority                   Rotherham
#> 42         2025          Week 3  Local authority                   Rotherham
#> 43         2025          Week 3  Local authority                   Rotherham
#> 44         2025          Week 3  Local authority                   Rotherham
#> 45         2025          Week 3  Local authority                   Rotherham
#> 46         2025          Week 3  Local authority                   Rotherham
#> 47         2025          Week 3  Local authority                   Rotherham
#> 48         2025          Week 3  Local authority                   Rotherham
#> 49         2025          Week 3  Local authority                   Rotherham
#> 50         2025          Week 3  Local authority                   Rotherham
#> 51         2025          Week 3  Local authority                   Sheffield
#> 52         2025          Week 3  Local authority                   Sheffield
#> 53         2025          Week 3  Local authority                   Sheffield
#> 54         2025          Week 3  Local authority                   Sheffield
#> 55         2025          Week 3  Local authority                   Sheffield
#> 56         2025          Week 3  Local authority                   Sheffield
#> 57         2025          Week 3  Local authority                   Sheffield
#> 58         2025          Week 3  Local authority                   Sheffield
#> 59         2025          Week 3  Local authority                   Sheffield
#> 60         2025          Week 3  Local authority                   Sheffield
#> 61         2025          Week 3  Local authority                   Sheffield
#> 62         2025          Week 3  Local authority                   Sheffield
#> 63         2025          Week 3  Local authority                   Sheffield
#> 64         2025          Week 3  Local authority                   Sheffield
#> 65         2025          Week 3  Local authority                   Sheffield
#> 66         2025          Week 3  Local authority                   Sheffield
#> 67         2025          Week 3  Local authority                   Sheffield
#> 68         2025          Week 3  Local authority                   Sheffield
#> 69         2025          Week 3  Local authority                    Bradford
#> 70         2025          Week 3  Local authority                    Bradford
#> 71         2025          Week 3  Local authority                    Bradford
#> 72         2025          Week 3  Local authority                    Bradford
#> 73         2025          Week 3  Local authority                    Bradford
#> 74         2025          Week 3  Local authority                    Bradford
#> 75         2025          Week 3  Local authority                    Bradford
#> 76         2025          Week 3  Local authority                    Bradford
#> 77         2025          Week 3  Local authority                    Bradford
#> 78         2025          Week 3  Local authority                    Bradford
#> 79         2025          Week 3  Local authority                    Bradford
#> 80         2025          Week 3  Local authority                    Bradford
#> 81         2025          Week 3  Local authority                    Bradford
#> 82         2025          Week 3  Local authority                    Bradford
#> 83         2025          Week 3  Local authority                    Bradford
#> 84         2025          Week 3  Local authority                    Bradford
#> 85         2025          Week 3  Local authority                    Bradford
#> 86         2025          Week 3  Local authority                    Bradford
#> 87         2025          Week 3  Local authority                  Calderdale
#> 88         2025          Week 3  Local authority                  Calderdale
#> 89         2025          Week 3  Local authority                  Calderdale
#> 90         2025          Week 3  Local authority                  Calderdale
#> 91         2025          Week 3  Local authority                  Calderdale
#> 92         2025          Week 3  Local authority                  Calderdale
#> 93         2025          Week 3  Local authority                  Calderdale
#> 94         2025          Week 3  Local authority                  Calderdale
#> 95         2025          Week 3  Local authority                  Calderdale
#> 96         2025          Week 3  Local authority                  Calderdale
#> 97         2025          Week 3  Local authority                  Calderdale
#> 98         2025          Week 3  Local authority                  Calderdale
#> 99         2025          Week 3  Local authority                  Calderdale
#> 100        2025          Week 3  Local authority                  Calderdale
#> 101        2025          Week 3  Local authority                  Calderdale
#> 102        2025          Week 3  Local authority                  Calderdale
#> 103        2025          Week 3  Local authority                  Calderdale
#> 104        2025          Week 3  Local authority                  Calderdale
#> 105        2025          Week 3  Local authority                    Kirklees
#> 106        2025          Week 3  Local authority                    Kirklees
#> 107        2025          Week 3  Local authority                    Kirklees
#> 108        2025          Week 3  Local authority                    Kirklees
#> 109        2025          Week 3  Local authority                    Kirklees
#> 110        2025          Week 3  Local authority                    Kirklees
#> 111        2025          Week 3  Local authority                    Kirklees
#> 112        2025          Week 3  Local authority                    Kirklees
#> 113        2025          Week 3  Local authority                    Kirklees
#> 114        2025          Week 3  Local authority                    Kirklees
#> 115        2025          Week 3  Local authority                    Kirklees
#> 116        2025          Week 3  Local authority                    Kirklees
#> 117        2025          Week 3  Local authority                    Kirklees
#> 118        2025          Week 3  Local authority                    Kirklees
#> 119        2025          Week 3  Local authority                    Kirklees
#> 120        2025          Week 3  Local authority                    Kirklees
#> 121        2025          Week 3  Local authority                    Kirklees
#> 122        2025          Week 3  Local authority                    Kirklees
#> 123        2025          Week 3  Local authority                       Leeds
#> 124        2025          Week 3  Local authority                       Leeds
#> 125        2025          Week 3  Local authority                       Leeds
#> 126        2025          Week 3  Local authority                       Leeds
#> 127        2025          Week 3  Local authority                       Leeds
#> 128        2025          Week 3  Local authority                       Leeds
#> 129        2025          Week 3  Local authority                       Leeds
#> 130        2025          Week 3  Local authority                       Leeds
#> 131        2025          Week 3  Local authority                       Leeds
#> 132        2025          Week 3  Local authority                       Leeds
#> 133        2025          Week 3  Local authority                       Leeds
#> 134        2025          Week 3  Local authority                       Leeds
#> 135        2025          Week 3  Local authority                       Leeds
#> 136        2025          Week 3  Local authority                       Leeds
#> 137        2025          Week 3  Local authority                       Leeds
#> 138        2025          Week 3  Local authority                       Leeds
#> 139        2025          Week 3  Local authority                       Leeds
#> 140        2025          Week 3  Local authority                       Leeds
#> 141        2025          Week 3  Local authority                   Wakefield
#> 142        2025          Week 3  Local authority                   Wakefield
#> 143        2025          Week 3  Local authority                   Wakefield
#> 144        2025          Week 3  Local authority                   Wakefield
#> 145        2025          Week 3  Local authority                   Wakefield
#> 146        2025          Week 3  Local authority                   Wakefield
#> 147        2025          Week 3  Local authority                   Wakefield
#> 148        2025          Week 3  Local authority                   Wakefield
#> 149        2025          Week 3  Local authority                   Wakefield
#> 150        2025          Week 3  Local authority                   Wakefield
#> 151        2025          Week 3  Local authority                   Wakefield
#> 152        2025          Week 3  Local authority                   Wakefield
#> 153        2025          Week 3  Local authority                   Wakefield
#> 154        2025          Week 3  Local authority                   Wakefield
#> 155        2025          Week 3  Local authority                   Wakefield
#> 156        2025          Week 3  Local authority                   Wakefield
#> 157        2025          Week 3  Local authority                   Wakefield
#> 158        2025          Week 3  Local authority                   Wakefield
#> 159        2025          Week 3         National                        <NA>
#> 160        2025          Week 3         National                        <NA>
#> 161        2025          Week 3         National                        <NA>
#> 162        2025          Week 3         National                        <NA>
#> 163        2025          Week 3         National                        <NA>
#> 164        2025          Week 3         National                        <NA>
#> 165        2025          Week 3         National                        <NA>
#> 166        2025          Week 3         National                        <NA>
#> 167        2025          Week 3         National                        <NA>
#> 168        2025          Week 3         National                        <NA>
#> 169        2025          Week 3         National                        <NA>
#> 170        2025          Week 3         National                        <NA>
#> 171        2025          Week 3         National                        <NA>
#> 172        2025          Week 3         National                        <NA>
#> 173        2025          Week 3         National                        <NA>
#> 174        2025          Week 3         National                        <NA>
#> 175        2025          Week 3         National                        <NA>
#> 176        2025          Week 3         National                        <NA>
#> 177        2025          Week 3         National                        <NA>
#> 178        2025          Week 3         National                        <NA>
#> 179        2025          Week 3         National                        <NA>
#> 180        2025          Week 3         National                        <NA>
#> 181        2025          Week 3         National                        <NA>
#> 182        2025          Week 3         National                        <NA>
#> 183        2025          Week 3         Regional                        <NA>
#> 184        2025          Week 3         Regional                        <NA>
#> 185        2025          Week 3         Regional                        <NA>
#> 186        2025          Week 3  Local authority Kingston upon Hull, City of
#> 187        2025          Week 3  Local authority Kingston upon Hull, City of
#> 188        2025          Week 3  Local authority Kingston upon Hull, City of
#> 189        2025          Week 3  Local authority Kingston upon Hull, City of
#> 190        2025          Week 3  Local authority Kingston upon Hull, City of
#> 191        2025          Week 3  Local authority Kingston upon Hull, City of
#> 192        2025          Week 3  Local authority Kingston upon Hull, City of
#> 193        2025          Week 3  Local authority Kingston upon Hull, City of
#> 194        2025          Week 3  Local authority Kingston upon Hull, City of
#> 195        2025          Week 3  Local authority Kingston upon Hull, City of
#> 196        2025          Week 3  Local authority Kingston upon Hull, City of
#> 197        2025          Week 3  Local authority Kingston upon Hull, City of
#> 198        2025          Week 3  Local authority Kingston upon Hull, City of
#> 199        2025          Week 3  Local authority Kingston upon Hull, City of
#> 200        2025          Week 3  Local authority Kingston upon Hull, City of
#> 201        2025          Week 3  Local authority Kingston upon Hull, City of
#> 202        2025          Week 3  Local authority Kingston upon Hull, City of
#> 203        2025          Week 3  Local authority Kingston upon Hull, City of
#> 204        2025          Week 3  Local authority    East Riding of Yorkshire
#> 205        2025          Week 3  Local authority    East Riding of Yorkshire
#> 206        2025          Week 3  Local authority    East Riding of Yorkshire
#> 207        2025          Week 3  Local authority    East Riding of Yorkshire
#> 208        2025          Week 3  Local authority    East Riding of Yorkshire
#> 209        2025          Week 3         Regional                        <NA>
#> 210        2025          Week 3         Regional                        <NA>
#> 211        2025          Week 3         Regional                        <NA>
#> 212        2025          Week 3         Regional                        <NA>
#> 213        2025          Week 3         Regional                        <NA>
#> 214        2025          Week 3         Regional                        <NA>
#> 215        2025          Week 3         Regional                        <NA>
#> 216        2025          Week 3         Regional                        <NA>
#> 217        2025          Week 3         Regional                        <NA>
#> 218        2025          Week 3         Regional                        <NA>
#> 219        2025          Week 3         Regional                        <NA>
#> 220        2025          Week 3         Regional                        <NA>
#> 221        2025          Week 3         Regional                        <NA>
#> 222        2025          Week 3         Regional                        <NA>
#> 223        2025          Week 3         Regional                        <NA>
#> 224        2025          Week 3         Regional                        <NA>
#> 225        2025          Week 3         Regional                        <NA>
#> 226        2025          Week 3         Regional                        <NA>
#> 227        2025          Week 3         Regional                        <NA>
#> 228        2025          Week 3         Regional                        <NA>
#> 229        2025          Week 3         Regional                        <NA>
#> 230        2025          Week 3  Local authority    East Riding of Yorkshire
#> 231        2025          Week 3  Local authority    East Riding of Yorkshire
#> 232        2025          Week 3  Local authority    East Riding of Yorkshire
#> 233        2025          Week 3  Local authority    East Riding of Yorkshire
#> 234        2025          Week 3  Local authority    East Riding of Yorkshire
#> 235        2025          Week 3  Local authority    East Riding of Yorkshire
#> 236        2025          Week 3  Local authority    East Riding of Yorkshire
#> 237        2025          Week 3  Local authority    East Riding of Yorkshire
#> 238        2025          Week 3  Local authority    East Riding of Yorkshire
#> 239        2025          Week 3  Local authority    East Riding of Yorkshire
#> 240        2025          Week 3  Local authority    East Riding of Yorkshire
#> 241        2025          Week 3  Local authority    East Riding of Yorkshire
#> 242        2025          Week 3  Local authority    East Riding of Yorkshire
#> 243        2025          Week 3  Local authority     North East Lincolnshire
#> 244        2025          Week 3  Local authority     North East Lincolnshire
#> 245        2025          Week 3  Local authority     North East Lincolnshire
#> 246        2025          Week 3  Local authority     North East Lincolnshire
#> 247        2025          Week 3  Local authority     North East Lincolnshire
#> 248        2025          Week 3  Local authority     North East Lincolnshire
#> 249        2025          Week 3  Local authority     North East Lincolnshire
#> 250        2025          Week 3  Local authority     North East Lincolnshire
#> 251        2025          Week 3  Local authority     North East Lincolnshire
#> 252        2025          Week 3  Local authority     North East Lincolnshire
#> 253        2025          Week 3  Local authority     North East Lincolnshire
#> 254        2025          Week 3  Local authority     North East Lincolnshire
#> 255        2025          Week 3  Local authority     North East Lincolnshire
#> 256        2025          Week 3  Local authority     North East Lincolnshire
#> 257        2025          Week 3  Local authority     North East Lincolnshire
#> 258        2025          Week 3  Local authority     North East Lincolnshire
#> 259        2025          Week 3  Local authority     North East Lincolnshire
#> 260        2025          Week 3  Local authority     North East Lincolnshire
#> 261        2025          Week 3  Local authority          North Lincolnshire
#> 262        2025          Week 3  Local authority          North Lincolnshire
#> 263        2025          Week 3  Local authority          North Lincolnshire
#> 264        2025          Week 3  Local authority          North Lincolnshire
#> 265        2025          Week 3  Local authority          North Lincolnshire
#> 266        2025          Week 3  Local authority          North Lincolnshire
#> 267        2025          Week 3  Local authority          North Lincolnshire
#> 268        2025          Week 3  Local authority          North Lincolnshire
#> 269        2025          Week 3  Local authority          North Lincolnshire
#> 270        2025          Week 3  Local authority          North Lincolnshire
#> 271        2025          Week 3  Local authority          North Lincolnshire
#> 272        2025          Week 3  Local authority          North Lincolnshire
#> 273        2025          Week 3  Local authority          North Lincolnshire
#> 274        2025          Week 3  Local authority          North Lincolnshire
#> 275        2025          Week 3  Local authority          North Lincolnshire
#> 276        2025          Week 3  Local authority          North Lincolnshire
#> 277        2025          Week 3  Local authority          North Lincolnshire
#> 278        2025          Week 3  Local authority          North Lincolnshire
#> 279        2025          Week 3  Local authority                        York
#> 280        2025          Week 3  Local authority                        York
#> 281        2025          Week 3  Local authority                        York
#> 282        2025          Week 3  Local authority                        York
#> 283        2025          Week 3  Local authority                        York
#> 284        2025          Week 3  Local authority                        York
#> 285        2025          Week 3  Local authority                        York
#> 286        2025          Week 3  Local authority                        York
#> 287        2025          Week 3  Local authority                        York
#> 288        2025          Week 3  Local authority                        York
#> 289        2025          Week 3  Local authority                        York
#> 290        2025          Week 3  Local authority                        York
#> 291        2025          Week 3  Local authority                        York
#> 292        2025          Week 3  Local authority                        York
#> 293        2025          Week 3  Local authority                        York
#> 294        2025          Week 3  Local authority                        York
#> 295        2025          Week 3  Local authority                        York
#> 296        2025          Week 3  Local authority                        York
#> 297        2025          Week 3  Local authority             North Yorkshire
#> 298        2025          Week 3  Local authority             North Yorkshire
#> 299        2025          Week 3  Local authority             North Yorkshire
#> 300        2025          Week 3  Local authority             North Yorkshire
#> 301        2025          Week 3  Local authority             North Yorkshire
#> 302        2025          Week 3  Local authority             North Yorkshire
#> 303        2025          Week 3  Local authority             North Yorkshire
#> 304        2025          Week 3  Local authority             North Yorkshire
#> 305        2025          Week 3  Local authority             North Yorkshire
#> 306        2025          Week 3  Local authority             North Yorkshire
#> 307        2025          Week 3  Local authority             North Yorkshire
#> 308        2025          Week 3  Local authority             North Yorkshire
#> 309        2025          Week 3  Local authority             North Yorkshire
#> 310        2025          Week 3  Local authority             North Yorkshire
#> 311        2025          Week 3  Local authority             North Yorkshire
#> 312        2025          Week 3  Local authority             North Yorkshire
#> 313        2025          Week 3  Local authority             North Yorkshire
#> 314        2025          Week 3  Local authority             North Yorkshire
#> 315        2025          Week 3  Local authority                    Barnsley
#> 316        2025          Week 3  Local authority                    Barnsley
#> 317        2025          Week 3  Local authority                    Barnsley
#> 318        2025          Week 3  Local authority                    Barnsley
#>       la_code la_oldCode nat_name  nat_code                 reg_name  reg_code
#> 1   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 2   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 3   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 4   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 5   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 6   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 7   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 8   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 9   E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 10  E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 11  E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 12  E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 13  E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 14  E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 15  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 16  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 17  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 18  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 19  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 20  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 21  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 22  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 23  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 24  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 25  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 26  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 27  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 28  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 29  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 30  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 31  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 32  E08000017        371  England E92000001 Yorkshire and The Humber E12000003
#> 33  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 34  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 35  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 36  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 37  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 38  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 39  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 40  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 41  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 42  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 43  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 44  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 45  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 46  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 47  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 48  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 49  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 50  E08000018        372  England E92000001 Yorkshire and The Humber E12000003
#> 51  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 52  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 53  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 54  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 55  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 56  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 57  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 58  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 59  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 60  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 61  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 62  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 63  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 64  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 65  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 66  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 67  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 68  E08000019        373  England E92000001 Yorkshire and The Humber E12000003
#> 69  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 70  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 71  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 72  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 73  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 74  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 75  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 76  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 77  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 78  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 79  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 80  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 81  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 82  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 83  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 84  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 85  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 86  E08000032        380  England E92000001 Yorkshire and The Humber E12000003
#> 87  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 88  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 89  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 90  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 91  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 92  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 93  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 94  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 95  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 96  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 97  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 98  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 99  E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 100 E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 101 E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 102 E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 103 E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 104 E08000033        381  England E92000001 Yorkshire and The Humber E12000003
#> 105 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 106 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 107 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 108 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 109 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 110 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 111 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 112 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 113 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 114 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 115 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 116 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 117 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 118 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 119 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 120 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 121 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 122 E08000034        382  England E92000001 Yorkshire and The Humber E12000003
#> 123 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 124 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 125 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 126 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 127 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 128 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 129 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 130 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 131 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 132 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 133 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 134 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 135 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 136 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 137 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 138 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 139 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 140 E08000035        383  England E92000001 Yorkshire and The Humber E12000003
#> 141 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 142 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 143 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 144 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 145 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 146 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 147 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 148 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 149 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 150 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 151 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 152 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 153 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 154 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 155 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 156 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 157 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 158 E08000036        384  England E92000001 Yorkshire and The Humber E12000003
#> 159      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 160      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 161      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 162      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 163      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 164      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 165      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 166      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 167      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 168      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 169      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 170      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 171      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 172      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 173      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 174      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 175      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 176      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 177      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 178      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 179      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 180      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 181      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 182      <NA>       <NA>  England E92000001                     <NA>      <NA>
#> 183      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 184      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 185      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 186 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 187 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 188 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 189 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 190 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 191 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 192 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 193 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 194 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 195 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 196 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 197 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 198 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 199 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 200 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 201 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 202 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 203 E06000010        810  England E92000001 Yorkshire and The Humber E12000003
#> 204 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 205 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 206 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 207 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 208 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 209      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 210      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 211      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 212      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 213      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 214      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 215      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 216      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 217      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 218      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 219      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 220      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 221      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 222      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 223      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 224      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 225      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 226      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 227      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 228      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 229      <NA>       <NA>  England E92000001 Yorkshire and The Humber E12000003
#> 230 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 231 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 232 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 233 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 234 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 235 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 236 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 237 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 238 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 239 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 240 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 241 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 242 E06000011        811  England E92000001 Yorkshire and The Humber E12000003
#> 243 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 244 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 245 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 246 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 247 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 248 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 249 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 250 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 251 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 252 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 253 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 254 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 255 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 256 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 257 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 258 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 259 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 260 E06000012        812  England E92000001 Yorkshire and The Humber E12000003
#> 261 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 262 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 263 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 264 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 265 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 266 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 267 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 268 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 269 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 270 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 271 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 272 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 273 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 274 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 275 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 276 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 277 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 278 E06000013        813  England E92000001 Yorkshire and The Humber E12000003
#> 279 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 280 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 281 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 282 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 283 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 284 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 285 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 286 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 287 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 288 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 289 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 290 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 291 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 292 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 293 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 294 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 295 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 296 E06000014        816  England E92000001 Yorkshire and The Humber E12000003
#> 297 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 298 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 299 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 300 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 301 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 302 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 303 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 304 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 305 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 306 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 307 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 308 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 309 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 310 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 311 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 312 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 313 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 314 E06000065        815  England E92000001 Yorkshire and The Humber E12000003
#> 315 E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 316 E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 317 E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#> 318 E08000016        370  England E92000001 Yorkshire and The Humber E12000003
#>     attendance_reason attendance_status   attendance_type education_phase
#> 1   All late sessions     Late sessions All late sessions         Primary
#> 2   All late sessions     Late sessions All late sessions         Primary
#> 3   All late sessions     Late sessions All late sessions       Secondary
#> 4   All late sessions     Late sessions All late sessions       Secondary
#> 5   All late sessions     Late sessions All late sessions       Secondary
#> 6   All late sessions     Late sessions All late sessions       Secondary
#> 7   All late sessions     Late sessions All late sessions       Secondary
#> 8   All late sessions     Late sessions All late sessions       Secondary
#> 9   All late sessions     Late sessions All late sessions         Special
#> 10  All late sessions     Late sessions All late sessions         Special
#> 11  All late sessions     Late sessions All late sessions         Special
#> 12  All late sessions     Late sessions All late sessions         Special
#> 13  All late sessions     Late sessions All late sessions         Special
#> 14  All late sessions     Late sessions All late sessions         Special
#> 15  All late sessions     Late sessions All late sessions         Primary
#> 16  All late sessions     Late sessions All late sessions         Primary
#> 17  All late sessions     Late sessions All late sessions         Primary
#> 18  All late sessions     Late sessions All late sessions         Primary
#> 19  All late sessions     Late sessions All late sessions         Primary
#> 20  All late sessions     Late sessions All late sessions         Primary
#> 21  All late sessions     Late sessions All late sessions       Secondary
#> 22  All late sessions     Late sessions All late sessions       Secondary
#> 23  All late sessions     Late sessions All late sessions       Secondary
#> 24  All late sessions     Late sessions All late sessions       Secondary
#> 25  All late sessions     Late sessions All late sessions       Secondary
#> 26  All late sessions     Late sessions All late sessions       Secondary
#> 27  All late sessions     Late sessions All late sessions         Special
#> 28  All late sessions     Late sessions All late sessions         Special
#> 29  All late sessions     Late sessions All late sessions         Special
#> 30  All late sessions     Late sessions All late sessions         Special
#> 31  All late sessions     Late sessions All late sessions         Special
#> 32  All late sessions     Late sessions All late sessions         Special
#> 33  All late sessions     Late sessions All late sessions         Primary
#> 34  All late sessions     Late sessions All late sessions         Primary
#> 35  All late sessions     Late sessions All late sessions         Primary
#> 36  All late sessions     Late sessions All late sessions         Primary
#> 37  All late sessions     Late sessions All late sessions         Primary
#> 38  All late sessions     Late sessions All late sessions         Primary
#> 39  All late sessions     Late sessions All late sessions       Secondary
#> 40  All late sessions     Late sessions All late sessions       Secondary
#> 41  All late sessions     Late sessions All late sessions       Secondary
#> 42  All late sessions     Late sessions All late sessions       Secondary
#> 43  All late sessions     Late sessions All late sessions       Secondary
#> 44  All late sessions     Late sessions All late sessions       Secondary
#> 45  All late sessions     Late sessions All late sessions         Special
#> 46  All late sessions     Late sessions All late sessions         Special
#> 47  All late sessions     Late sessions All late sessions         Special
#> 48  All late sessions     Late sessions All late sessions         Special
#> 49  All late sessions     Late sessions All late sessions         Special
#> 50  All late sessions     Late sessions All late sessions         Special
#> 51  All late sessions     Late sessions All late sessions         Primary
#> 52  All late sessions     Late sessions All late sessions         Primary
#> 53  All late sessions     Late sessions All late sessions         Primary
#> 54  All late sessions     Late sessions All late sessions         Primary
#> 55  All late sessions     Late sessions All late sessions         Primary
#> 56  All late sessions     Late sessions All late sessions         Primary
#> 57  All late sessions     Late sessions All late sessions       Secondary
#> 58  All late sessions     Late sessions All late sessions       Secondary
#> 59  All late sessions     Late sessions All late sessions       Secondary
#> 60  All late sessions     Late sessions All late sessions       Secondary
#> 61  All late sessions     Late sessions All late sessions       Secondary
#> 62  All late sessions     Late sessions All late sessions       Secondary
#> 63  All late sessions     Late sessions All late sessions         Special
#> 64  All late sessions     Late sessions All late sessions         Special
#> 65  All late sessions     Late sessions All late sessions         Special
#> 66  All late sessions     Late sessions All late sessions         Special
#> 67  All late sessions     Late sessions All late sessions         Special
#> 68  All late sessions     Late sessions All late sessions         Special
#> 69  All late sessions     Late sessions All late sessions         Primary
#> 70  All late sessions     Late sessions All late sessions         Primary
#> 71  All late sessions     Late sessions All late sessions         Primary
#> 72  All late sessions     Late sessions All late sessions         Primary
#> 73  All late sessions     Late sessions All late sessions         Primary
#> 74  All late sessions     Late sessions All late sessions         Primary
#> 75  All late sessions     Late sessions All late sessions       Secondary
#> 76  All late sessions     Late sessions All late sessions       Secondary
#> 77  All late sessions     Late sessions All late sessions       Secondary
#> 78  All late sessions     Late sessions All late sessions       Secondary
#> 79  All late sessions     Late sessions All late sessions       Secondary
#> 80  All late sessions     Late sessions All late sessions       Secondary
#> 81  All late sessions     Late sessions All late sessions         Special
#> 82  All late sessions     Late sessions All late sessions         Special
#> 83  All late sessions     Late sessions All late sessions         Special
#> 84  All late sessions     Late sessions All late sessions         Special
#> 85  All late sessions     Late sessions All late sessions         Special
#> 86  All late sessions     Late sessions All late sessions         Special
#> 87  All late sessions     Late sessions All late sessions         Primary
#> 88  All late sessions     Late sessions All late sessions         Primary
#> 89  All late sessions     Late sessions All late sessions         Primary
#> 90  All late sessions     Late sessions All late sessions         Primary
#> 91  All late sessions     Late sessions All late sessions         Primary
#> 92  All late sessions     Late sessions All late sessions         Primary
#> 93  All late sessions     Late sessions All late sessions       Secondary
#> 94  All late sessions     Late sessions All late sessions       Secondary
#> 95  All late sessions     Late sessions All late sessions       Secondary
#> 96  All late sessions     Late sessions All late sessions       Secondary
#> 97  All late sessions     Late sessions All late sessions       Secondary
#> 98  All late sessions     Late sessions All late sessions       Secondary
#> 99  All late sessions     Late sessions All late sessions         Special
#> 100 All late sessions     Late sessions All late sessions         Special
#> 101 All late sessions     Late sessions All late sessions         Special
#> 102 All late sessions     Late sessions All late sessions         Special
#> 103 All late sessions     Late sessions All late sessions         Special
#> 104 All late sessions     Late sessions All late sessions         Special
#> 105 All late sessions     Late sessions All late sessions         Primary
#> 106 All late sessions     Late sessions All late sessions         Primary
#> 107 All late sessions     Late sessions All late sessions         Primary
#> 108 All late sessions     Late sessions All late sessions         Primary
#> 109 All late sessions     Late sessions All late sessions         Primary
#> 110 All late sessions     Late sessions All late sessions         Primary
#> 111 All late sessions     Late sessions All late sessions       Secondary
#> 112 All late sessions     Late sessions All late sessions       Secondary
#> 113 All late sessions     Late sessions All late sessions       Secondary
#> 114 All late sessions     Late sessions All late sessions       Secondary
#> 115 All late sessions     Late sessions All late sessions       Secondary
#> 116 All late sessions     Late sessions All late sessions       Secondary
#> 117 All late sessions     Late sessions All late sessions         Special
#> 118 All late sessions     Late sessions All late sessions         Special
#> 119 All late sessions     Late sessions All late sessions         Special
#> 120 All late sessions     Late sessions All late sessions         Special
#> 121 All late sessions     Late sessions All late sessions         Special
#> 122 All late sessions     Late sessions All late sessions         Special
#> 123 All late sessions     Late sessions All late sessions         Primary
#> 124 All late sessions     Late sessions All late sessions         Primary
#> 125 All late sessions     Late sessions All late sessions         Primary
#> 126 All late sessions     Late sessions All late sessions         Primary
#> 127 All late sessions     Late sessions All late sessions         Primary
#> 128 All late sessions     Late sessions All late sessions         Primary
#> 129 All late sessions     Late sessions All late sessions       Secondary
#> 130 All late sessions     Late sessions All late sessions       Secondary
#> 131 All late sessions     Late sessions All late sessions       Secondary
#> 132 All late sessions     Late sessions All late sessions       Secondary
#> 133 All late sessions     Late sessions All late sessions       Secondary
#> 134 All late sessions     Late sessions All late sessions       Secondary
#> 135 All late sessions     Late sessions All late sessions         Special
#> 136 All late sessions     Late sessions All late sessions         Special
#> 137 All late sessions     Late sessions All late sessions         Special
#> 138 All late sessions     Late sessions All late sessions         Special
#> 139 All late sessions     Late sessions All late sessions         Special
#> 140 All late sessions     Late sessions All late sessions         Special
#> 141 All late sessions     Late sessions All late sessions         Primary
#> 142 All late sessions     Late sessions All late sessions         Primary
#> 143 All late sessions     Late sessions All late sessions         Primary
#> 144 All late sessions     Late sessions All late sessions         Primary
#> 145 All late sessions     Late sessions All late sessions         Primary
#> 146 All late sessions     Late sessions All late sessions         Primary
#> 147 All late sessions     Late sessions All late sessions       Secondary
#> 148 All late sessions     Late sessions All late sessions       Secondary
#> 149 All late sessions     Late sessions All late sessions       Secondary
#> 150 All late sessions     Late sessions All late sessions       Secondary
#> 151 All late sessions     Late sessions All late sessions       Secondary
#> 152 All late sessions     Late sessions All late sessions       Secondary
#> 153 All late sessions     Late sessions All late sessions         Special
#> 154 All late sessions     Late sessions All late sessions         Special
#> 155 All late sessions     Late sessions All late sessions         Special
#> 156 All late sessions     Late sessions All late sessions         Special
#> 157 All late sessions     Late sessions All late sessions         Special
#> 158 All late sessions     Late sessions All late sessions         Special
#> 159 All late sessions     Late sessions All late sessions     All schools
#> 160 All late sessions     Late sessions All late sessions     All schools
#> 161 All late sessions     Late sessions All late sessions     All schools
#> 162 All late sessions     Late sessions All late sessions     All schools
#> 163 All late sessions     Late sessions All late sessions     All schools
#> 164 All late sessions     Late sessions All late sessions     All schools
#> 165 All late sessions     Late sessions All late sessions         Primary
#> 166 All late sessions     Late sessions All late sessions         Primary
#> 167 All late sessions     Late sessions All late sessions         Primary
#> 168 All late sessions     Late sessions All late sessions         Primary
#> 169 All late sessions     Late sessions All late sessions         Primary
#> 170 All late sessions     Late sessions All late sessions         Primary
#> 171 All late sessions     Late sessions All late sessions       Secondary
#> 172 All late sessions     Late sessions All late sessions       Secondary
#> 173 All late sessions     Late sessions All late sessions       Secondary
#> 174 All late sessions     Late sessions All late sessions       Secondary
#> 175 All late sessions     Late sessions All late sessions       Secondary
#> 176 All late sessions     Late sessions All late sessions       Secondary
#> 177 All late sessions     Late sessions All late sessions         Special
#> 178 All late sessions     Late sessions All late sessions         Special
#> 179 All late sessions     Late sessions All late sessions         Special
#> 180 All late sessions     Late sessions All late sessions         Special
#> 181 All late sessions     Late sessions All late sessions         Special
#> 182 All late sessions     Late sessions All late sessions         Special
#> 183 All late sessions     Late sessions All late sessions     All schools
#> 184 All late sessions     Late sessions All late sessions     All schools
#> 185 All late sessions     Late sessions All late sessions     All schools
#> 186 All late sessions     Late sessions All late sessions         Primary
#> 187 All late sessions     Late sessions All late sessions         Primary
#> 188 All late sessions     Late sessions All late sessions         Primary
#> 189 All late sessions     Late sessions All late sessions         Primary
#> 190 All late sessions     Late sessions All late sessions         Primary
#> 191 All late sessions     Late sessions All late sessions         Primary
#> 192 All late sessions     Late sessions All late sessions       Secondary
#> 193 All late sessions     Late sessions All late sessions       Secondary
#> 194 All late sessions     Late sessions All late sessions       Secondary
#> 195 All late sessions     Late sessions All late sessions       Secondary
#> 196 All late sessions     Late sessions All late sessions       Secondary
#> 197 All late sessions     Late sessions All late sessions       Secondary
#> 198 All late sessions     Late sessions All late sessions         Special
#> 199 All late sessions     Late sessions All late sessions         Special
#> 200 All late sessions     Late sessions All late sessions         Special
#> 201 All late sessions     Late sessions All late sessions         Special
#> 202 All late sessions     Late sessions All late sessions         Special
#> 203 All late sessions     Late sessions All late sessions         Special
#> 204 All late sessions     Late sessions All late sessions         Primary
#> 205 All late sessions     Late sessions All late sessions         Primary
#> 206 All late sessions     Late sessions All late sessions         Primary
#> 207 All late sessions     Late sessions All late sessions         Primary
#> 208 All late sessions     Late sessions All late sessions         Primary
#> 209 All late sessions     Late sessions All late sessions     All schools
#> 210 All late sessions     Late sessions All late sessions     All schools
#> 211 All late sessions     Late sessions All late sessions     All schools
#> 212 All late sessions     Late sessions All late sessions         Primary
#> 213 All late sessions     Late sessions All late sessions         Primary
#> 214 All late sessions     Late sessions All late sessions         Primary
#> 215 All late sessions     Late sessions All late sessions         Primary
#> 216 All late sessions     Late sessions All late sessions         Primary
#> 217 All late sessions     Late sessions All late sessions         Primary
#> 218 All late sessions     Late sessions All late sessions       Secondary
#> 219 All late sessions     Late sessions All late sessions       Secondary
#> 220 All late sessions     Late sessions All late sessions       Secondary
#> 221 All late sessions     Late sessions All late sessions       Secondary
#> 222 All late sessions     Late sessions All late sessions       Secondary
#> 223 All late sessions     Late sessions All late sessions       Secondary
#> 224 All late sessions     Late sessions All late sessions         Special
#> 225 All late sessions     Late sessions All late sessions         Special
#> 226 All late sessions     Late sessions All late sessions         Special
#> 227 All late sessions     Late sessions All late sessions         Special
#> 228 All late sessions     Late sessions All late sessions         Special
#> 229 All late sessions     Late sessions All late sessions         Special
#> 230 All late sessions     Late sessions All late sessions         Primary
#> 231 All late sessions     Late sessions All late sessions       Secondary
#> 232 All late sessions     Late sessions All late sessions       Secondary
#> 233 All late sessions     Late sessions All late sessions       Secondary
#> 234 All late sessions     Late sessions All late sessions       Secondary
#> 235 All late sessions     Late sessions All late sessions       Secondary
#> 236 All late sessions     Late sessions All late sessions       Secondary
#> 237 All late sessions     Late sessions All late sessions         Special
#> 238 All late sessions     Late sessions All late sessions         Special
#> 239 All late sessions     Late sessions All late sessions         Special
#> 240 All late sessions     Late sessions All late sessions         Special
#> 241 All late sessions     Late sessions All late sessions         Special
#> 242 All late sessions     Late sessions All late sessions         Special
#> 243 All late sessions     Late sessions All late sessions         Primary
#> 244 All late sessions     Late sessions All late sessions         Primary
#> 245 All late sessions     Late sessions All late sessions         Primary
#> 246 All late sessions     Late sessions All late sessions         Primary
#> 247 All late sessions     Late sessions All late sessions         Primary
#> 248 All late sessions     Late sessions All late sessions         Primary
#> 249 All late sessions     Late sessions All late sessions       Secondary
#> 250 All late sessions     Late sessions All late sessions       Secondary
#> 251 All late sessions     Late sessions All late sessions       Secondary
#> 252 All late sessions     Late sessions All late sessions       Secondary
#> 253 All late sessions     Late sessions All late sessions       Secondary
#> 254 All late sessions     Late sessions All late sessions       Secondary
#> 255 All late sessions     Late sessions All late sessions         Special
#> 256 All late sessions     Late sessions All late sessions         Special
#> 257 All late sessions     Late sessions All late sessions         Special
#> 258 All late sessions     Late sessions All late sessions         Special
#> 259 All late sessions     Late sessions All late sessions         Special
#> 260 All late sessions     Late sessions All late sessions         Special
#> 261 All late sessions     Late sessions All late sessions         Primary
#> 262 All late sessions     Late sessions All late sessions         Primary
#> 263 All late sessions     Late sessions All late sessions         Primary
#> 264 All late sessions     Late sessions All late sessions         Primary
#> 265 All late sessions     Late sessions All late sessions         Primary
#> 266 All late sessions     Late sessions All late sessions         Primary
#> 267 All late sessions     Late sessions All late sessions       Secondary
#> 268 All late sessions     Late sessions All late sessions       Secondary
#> 269 All late sessions     Late sessions All late sessions       Secondary
#> 270 All late sessions     Late sessions All late sessions       Secondary
#> 271 All late sessions     Late sessions All late sessions       Secondary
#> 272 All late sessions     Late sessions All late sessions       Secondary
#> 273 All late sessions     Late sessions All late sessions         Special
#> 274 All late sessions     Late sessions All late sessions         Special
#> 275 All late sessions     Late sessions All late sessions         Special
#> 276 All late sessions     Late sessions All late sessions         Special
#> 277 All late sessions     Late sessions All late sessions         Special
#> 278 All late sessions     Late sessions All late sessions         Special
#> 279 All late sessions     Late sessions All late sessions         Primary
#> 280 All late sessions     Late sessions All late sessions         Primary
#> 281 All late sessions     Late sessions All late sessions         Primary
#> 282 All late sessions     Late sessions All late sessions         Primary
#> 283 All late sessions     Late sessions All late sessions         Primary
#> 284 All late sessions     Late sessions All late sessions         Primary
#> 285 All late sessions     Late sessions All late sessions       Secondary
#> 286 All late sessions     Late sessions All late sessions       Secondary
#> 287 All late sessions     Late sessions All late sessions       Secondary
#> 288 All late sessions     Late sessions All late sessions       Secondary
#> 289 All late sessions     Late sessions All late sessions       Secondary
#> 290 All late sessions     Late sessions All late sessions       Secondary
#> 291 All late sessions     Late sessions All late sessions         Special
#> 292 All late sessions     Late sessions All late sessions         Special
#> 293 All late sessions     Late sessions All late sessions         Special
#> 294 All late sessions     Late sessions All late sessions         Special
#> 295 All late sessions     Late sessions All late sessions         Special
#> 296 All late sessions     Late sessions All late sessions         Special
#> 297 All late sessions     Late sessions All late sessions         Primary
#> 298 All late sessions     Late sessions All late sessions         Primary
#> 299 All late sessions     Late sessions All late sessions         Primary
#> 300 All late sessions     Late sessions All late sessions         Primary
#> 301 All late sessions     Late sessions All late sessions         Primary
#> 302 All late sessions     Late sessions All late sessions         Primary
#> 303 All late sessions     Late sessions All late sessions       Secondary
#> 304 All late sessions     Late sessions All late sessions       Secondary
#> 305 All late sessions     Late sessions All late sessions       Secondary
#> 306 All late sessions     Late sessions All late sessions       Secondary
#> 307 All late sessions     Late sessions All late sessions       Secondary
#> 308 All late sessions     Late sessions All late sessions       Secondary
#> 309 All late sessions     Late sessions All late sessions         Special
#> 310 All late sessions     Late sessions All late sessions         Special
#> 311 All late sessions     Late sessions All late sessions         Special
#> 312 All late sessions     Late sessions All late sessions         Special
#> 313 All late sessions     Late sessions All late sessions         Special
#> 314 All late sessions     Late sessions All late sessions         Special
#> 315 All late sessions     Late sessions All late sessions         Primary
#> 316 All late sessions     Late sessions All late sessions         Primary
#> 317 All late sessions     Late sessions All late sessions         Primary
#> 318 All late sessions     Late sessions All late sessions         Primary
#>     time_frame session_count
#> 1       Friday           319
#> 2         Week          1958
#> 3       Monday           980
#> 4      Tuesday           877
#> 5    Wednesday           776
#> 6     Thursday           793
#> 7       Friday           737
#> 8         Week          4163
#> 9       Monday            13
#> 10     Tuesday             5
#> 11   Wednesday            10
#> 12    Thursday             3
#> 13      Friday             9
#> 14        Week            40
#> 15      Monday           638
#> 16     Tuesday           673
#> 17   Wednesday           557
#> 18    Thursday           669
#> 19      Friday           517
#> 20        Week          3054
#> 21      Monday          1017
#> 22     Tuesday          1192
#> 23   Wednesday           887
#> 24    Thursday          1040
#> 25      Friday           948
#> 26        Week          5084
#> 27      Monday             7
#> 28     Tuesday             3
#> 29   Wednesday             9
#> 30    Thursday             6
#> 31      Friday             6
#> 32        Week            31
#> 33      Monday           662
#> 34     Tuesday           535
#> 35   Wednesday           546
#> 36    Thursday           586
#> 37      Friday           516
#> 38        Week          2845
#> 39      Monday          1352
#> 40     Tuesday          1311
#> 41   Wednesday          1204
#> 42    Thursday          1186
#> 43      Friday          1160
#> 44        Week          6213
#> 45      Monday            24
#> 46     Tuesday            12
#> 47   Wednesday            17
#> 48    Thursday            18
#> 49      Friday             7
#> 50        Week            78
#> 51      Monday          2118
#> 52     Tuesday          1755
#> 53   Wednesday          1502
#> 54    Thursday          1613
#> 55      Friday          1335
#> 56        Week          8323
#> 57      Monday          3770
#> 58     Tuesday          3476
#> 59   Wednesday          3109
#> 60    Thursday          3113
#> 61      Friday          2761
#> 62        Week         16229
#> 63      Monday            20
#> 64     Tuesday            22
#> 65   Wednesday            22
#> 66    Thursday            18
#> 67      Friday            13
#> 68        Week            95
#> 69      Monday           965
#> 70     Tuesday          1669
#> 71   Wednesday          1900
#> 72    Thursday          1845
#> 73      Friday          1459
#> 74        Week          7838
#> 75      Monday          2458
#> 76     Tuesday          3168
#> 77   Wednesday          3402
#> 78    Thursday          3378
#> 79      Friday          2908
#> 80        Week         15314
#> 81      Monday            31
#> 82     Tuesday            43
#> 83   Wednesday            37
#> 84    Thursday            43
#> 85      Friday            35
#> 86        Week           189
#> 87      Monday           421
#> 88     Tuesday           416
#> 89   Wednesday           424
#> 90    Thursday           390
#> 91      Friday           347
#> 92        Week          1998
#> 93      Monday          1953
#> 94     Tuesday          1787
#> 95   Wednesday          1628
#> 96    Thursday          1459
#> 97      Friday          1120
#> 98        Week          7947
#> 99      Monday             4
#> 100    Tuesday            13
#> 101  Wednesday             9
#> 102   Thursday             6
#> 103     Friday             5
#> 104       Week            37
#> 105     Monday           975
#> 106    Tuesday           885
#> 107  Wednesday           833
#> 108   Thursday           860
#> 109     Friday           736
#> 110       Week          4289
#> 111     Monday          1976
#> 112    Tuesday          2041
#> 113  Wednesday          1994
#> 114   Thursday          1899
#> 115     Friday          1723
#> 116       Week          9633
#> 117     Monday             6
#> 118    Tuesday             8
#> 119  Wednesday             7
#> 120   Thursday             3
#> 121     Friday             5
#> 122       Week            29
#> 123     Monday          2411
#> 124    Tuesday          2179
#> 125  Wednesday          2012
#> 126   Thursday          2293
#> 127     Friday          1797
#> 128       Week         10692
#> 129     Monday          4565
#> 130    Tuesday          4220
#> 131  Wednesday          4552
#> 132   Thursday          4145
#> 133     Friday          3801
#> 134       Week         21283
#> 135     Monday           116
#> 136    Tuesday           124
#> 137  Wednesday           112
#> 138   Thursday           132
#> 139     Friday            94
#> 140       Week           578
#> 141     Monday           689
#> 142    Tuesday           578
#> 143  Wednesday           572
#> 144   Thursday           611
#> 145     Friday           495
#> 146       Week          2945
#> 147     Monday          1440
#> 148    Tuesday          1359
#> 149  Wednesday          1311
#> 150   Thursday          1400
#> 151     Friday          1259
#> 152       Week          6769
#> 153     Monday             1
#> 154    Tuesday             1
#> 155  Wednesday             2
#> 156   Thursday             1
#> 157     Friday             2
#> 158       Week             7
#> 159     Monday        351238
#> 160    Tuesday        339489
#> 161  Wednesday        332601
#> 162   Thursday        325478
#> 163     Friday        290697
#> 164       Week       1639503
#> 165     Monday        119171
#> 166    Tuesday        108143
#> 167  Wednesday        104015
#> 168   Thursday        103341
#> 169     Friday         88855
#> 170       Week        523525
#> 171     Monday        228420
#> 172    Tuesday        227692
#> 173  Wednesday        225185
#> 174   Thursday        218840
#> 175     Friday        199159
#> 176       Week       1099296
#> 177     Monday          3647
#> 178    Tuesday          3654
#> 179  Wednesday          3401
#> 180   Thursday          3297
#> 181     Friday          2683
#> 182       Week         16682
#> 183     Monday         37885
#> 184    Tuesday         37134
#> 185  Wednesday         36149
#> 186     Monday           653
#> 187    Tuesday           657
#> 188  Wednesday           591
#> 189   Thursday           675
#> 190     Friday           485
#> 191       Week          3061
#> 192     Monday          1429
#> 193    Tuesday          1434
#> 194  Wednesday          1288
#> 195   Thursday          1451
#> 196     Friday          1226
#> 197       Week          6828
#> 198     Monday             4
#> 199    Tuesday             2
#> 200  Wednesday            11
#> 201   Thursday             6
#> 202     Friday             4
#> 203       Week            27
#> 204     Monday           400
#> 205    Tuesday           314
#> 206  Wednesday           345
#> 207   Thursday           391
#> 208     Friday           298
#> 209   Thursday         36579
#> 210     Friday         31465
#> 211       Week        179212
#> 212     Monday         12065
#> 213    Tuesday         11629
#> 214  Wednesday         11229
#> 215   Thursday         12045
#> 216     Friday          9660
#> 217       Week         56628
#> 218     Monday         25567
#> 219    Tuesday         25231
#> 220  Wednesday         24655
#> 221   Thursday         24263
#> 222     Friday         21601
#> 223       Week        121317
#> 224     Monday           253
#> 225    Tuesday           274
#> 226  Wednesday           265
#> 227   Thursday           271
#> 228     Friday           204
#> 229       Week          1267
#> 230       Week          1748
#> 231     Monday          1061
#> 232    Tuesday          1037
#> 233  Wednesday          1011
#> 234   Thursday          1036
#> 235     Friday           835
#> 236       Week          4980
#> 237     Monday             1
#> 238    Tuesday             1
#> 239  Wednesday             3
#> 240   Thursday             3
#> 241     Friday             1
#> 242       Week             9
#> 243     Monday           266
#> 244    Tuesday           278
#> 245  Wednesday           307
#> 246   Thursday           315
#> 247     Friday           226
#> 248       Week          1392
#> 249     Monday           461
#> 250    Tuesday           469
#> 251  Wednesday           463
#> 252   Thursday           488
#> 253     Friday           430
#> 254       Week          2311
#> 255     Monday             6
#> 256    Tuesday             5
#> 257  Wednesday             1
#> 258   Thursday             3
#> 259     Friday             5
#> 260       Week            20
#> 261     Monday           350
#> 262    Tuesday           253
#> 263  Wednesday           247
#> 264   Thursday           316
#> 265     Friday           213
#> 266       Week          1379
#> 267     Monday           480
#> 268    Tuesday           465
#> 269  Wednesday           430
#> 270   Thursday           491
#> 271     Friday           392
#> 272       Week          2258
#> 273     Monday             6
#> 274    Tuesday             6
#> 275  Wednesday             3
#> 276   Thursday             8
#> 277     Friday             3
#> 278       Week            26
#> 279     Monday           267
#> 280    Tuesday           256
#> 281  Wednesday           252
#> 282   Thursday           307
#> 283     Friday           259
#> 284       Week          1341
#> 285     Monday           770
#> 286    Tuesday           554
#> 287  Wednesday           713
#> 288   Thursday           586
#> 289     Friday           656
#> 290       Week          3279
#> 291     Monday             8
#> 292    Tuesday            10
#> 293  Wednesday             3
#> 294   Thursday             8
#> 295     Friday             7
#> 296       Week            36
#> 297     Monday           780
#> 298    Tuesday           795
#> 299  Wednesday           749
#> 300   Thursday           783
#> 301     Friday           658
#> 302       Week          3765
#> 303     Monday          1855
#> 304    Tuesday          1841
#> 305  Wednesday          1887
#> 306   Thursday          1798
#> 307     Friday          1645
#> 308       Week          9026
#> 309     Monday             6
#> 310    Tuesday            19
#> 311  Wednesday            19
#> 312   Thursday            13
#> 313     Friday             8
#> 314       Week            65
#> 315     Monday           470
#> 316    Tuesday           386
#> 317  Wednesday           392
#> 318   Thursday           391

# 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 21         National  England E92000001
#> 2        2025         Week 20         National  England E92000001
#> 3        2025         Week 18         National  England E92000001
#> 4        2025         Week 15         National  England E92000001
#> 5        2025         Week 14         National  England E92000001
#> 6        2025         Week 12         National  England E92000001
#> 7        2025         Week 10         National  England E92000001
#> 8        2025          Week 8         National  England E92000001
#>   education_phase persistent_absence_percent
#> 1         Primary                      13.42
#> 2         Primary                      13.41
#> 3         Primary                      13.76
#> 4         Primary                       14.1
#> 5         Primary                      14.15
#> 6         Primary                      14.06
#> 7         Primary                      14.41
#> 8         Primary                      14.95