Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

  1. Step 1 Choose a publication

    Publication
    Pupil absence in schools in England: autumn and spring terms
  2. Step 2 View a featured table or create your own

    Subject
    01 - Absence rates by geographic level - Autumn and Spring combined
  3. Step 3 Choose locations

    National
    • England
  4. Step 4 Choose time period

    Time period
    2016/17 Autumn and Spring Term to 2020/21 Autumn and Spring Term
  5. Step 5 Choose your filters

    Indicators
    • Authorised holiday rate
    • Authorised other rate
    • Authorised reasons rate
    • Excluded rate
    • Illness rate
    • Late rate
    • Medical appointments rate
    • No reason yet rate
    • Overall reasons rate
    • Religious observance rate
    • Study leave rate
    • Traveller rate
    • Unauthorised holiday rate
    • Unauthorised other rate
    • Unauthorised reasons rate
    School type
    • Total
  6. Step 6 (current) Explore data

    Re-order table headers

    Drag and drop the options below to re-order the table headers. Hold the Ctrl key and click to select multiple items to drag and drop. For keyboard users, select and deselect a draggable item with space and use the arrow keys to move a selected item.

    To move an item with your keyboard, select or deselect the item with Space and use the Up and Down arrow keys to move the selected item. To move multiple items, you can press Ctrl and Enter to add an item to your selected items. If you are using a screen reader disable scan mode.

    Row groups
    Row group 1
    Authorised holiday rate
    Excluded rate
    Illness rate
    Medical appointments rate
    Religious observance rate
    Study leave rate
    Traveller rate
    Authorised other rate
    Authorised reasons rate
    Late rate
    Unauthorised holiday rate
    Unauthorised other rate
    No reason yet rate
    Unauthorised reasons rate
    Overall reasons rate
    Column groups
    Column group 1
    2016/17 Autumn and Spring Term
    2017/18 Autumn and Spring Term
    2018/19 Autumn and Spring Term
    2020/21 Autumn and Spring Term
    This is the latest data
    WarningSome rows and columns are not shown in this table as the data does not exist in the underlying file.
    '01 - Absence rates by geographic level - Autumn and Spring combined' in England between 2016/17 Autumn and Spring Term and 2020/21 Autumn and Spring Term
    2016/17 Autumn and Spring Term2017/18 Autumn and Spring Term2018/19 Autumn and Spring Term2020/21 Autumn and Spring Term
    Authorised holiday rate0.1%0.1%0.1%0.0%
    Excluded rate0.1%0.1%0.1%0.0%
    Illness rate2.7%2.8%2.6%1.7%
    Medical appointments rate0.3%0.3%0.3%0.1%
    Religious observance rate0.1%0.0%0.0%0.0%
    Study leave rate0.0%0.0%0.0%0.0%
    Traveller rate0.0%0.0%0.0%0.0%
    Authorised other rate0.3%0.3%0.3%1.0%
    Authorised reasons rate3.4%3.5%3.3%3.0%
    Late rate0.1%0.1%0.1%0.0%
    Unauthorised holiday rate0.3%0.3%0.3%0.1%
    Unauthorised other rate0.7%0.8%0.8%0.8%
    No reason yet rate0.1%0.1%0.0%0.1%
    Unauthorised reasons rate1.1%1.2%1.2%1.0%
    Overall reasons rate4.5%4.7%4.5%4.0%

    Save table

    Download Table

    Select file format: