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
    Childcare and early years provider survey
  2. Step 2 (current) Choose a subject

    Choose a subject to create your table from, more information on the data coverage can be found by viewing more details
    More details for Mean and median hourly fee by child age and provider type (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    Mean and median fee broken down by child age and by provider type.

    More details for Mean and median hourly fee for children under age two by provider type (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of mean and median fees for children aged under 2 broken down by provider type.  Median fees are only available for 2022.  Only a very small proportion of children aged under 2 are enrolled at school-based providers so figures for school-based providers are based on small sample sizes.

    More details for Proportion of providers increasing fees in the last 12 months, by provider type and age-group (2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the proportion of providers who reported increasing fees in the previous 12 months, broken down by child age and by provider type.  Only a very small proportion of children aged under 2 are enrolled at school-based providers so figures for fees for under 2s enrolled at school-based providers are based on small sample sizes.

    More details for Mean and median hourly fee for two-year-old children by provider type (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of mean and median fees for children aged 2 broken down by provider type. Median fees are only available for 2022.

    More details for Mean and median hourly fee for three- and four-year-old preschool children by provider type (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of mean and median fees for children aged 3 and 4 broken down by provider type.  Median fees are only available for 2022.

    More details for Mean and median hourly fee by child age and region (2022)

    This subject includes the following data:

    Geographic levels
    Regional
    Time period
    2022
    Content

    Mean and median fee broken down by child age and region.  

    More details for Mean and median hourly fee for children under age two by region (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    Regional
    Time period
    2018 to 2022
    Content

    Mean and median fee broken down by child age and provider type.

    More details for Mean and median hourly fee for two-year-old children by region (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    Regional
    Time period
    2018 to 2022
    Content

    A time series of mean and median fees for children aged 2 broken down by region.

    More details for Mean and median hourly fee for three- and four-year-old preschool children by region (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    Regional
    Time period
    2018 to 2022
    Content

    A time series of mean and median fees for children aged 3 and 4 broken down by region.

    More details for Mean and median hourly fee by Local Authority for two-year-old children (2022)

    This subject includes the following data:

    Geographic levels
    Local authority
    Time period
    2022
    Content

    Mean and median fees for children aged 2 broken down by local authority.  In order to help interpret the mean, the table shows 95% confidence intervals.  Based on the responses we received to the survey, we can be 95% confident that the mean for all providers in the local authority lies between the lower and upper values.  Figures for some local authorities are based on small sample sizes (less than 30).

    More details for Mean and median hourly fee by Local Authority for three and four year old preschool children (2022)

    This subject includes the following data:

    Geographic levels
    Local authority
    Time period
    2022
    Content

    Mean and median fees for children aged 3 and 4 broken down by local authority.  In order to help interpret the mean, the table shows 95% confidence intervals.  Based on the responses we received to the survey, we can be 95% confident that the mean for all providers in the local authority lies between the lower and upper values.  Figures for some local authorities are based on small sample sizes (less than 30).

    More details for Number of providers (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the number of providers, broken down by provider type.  Due to a small change in the way that private and voluntary group-based providers are defined, private and voluntary group-based provider figures for 2021 and 2022 are not directly comparable (all group-based provider figures, however, are unaffected).

    More details for Number of providers by region (2022)

    This subject includes the following data:

    Geographic levels
    Regional
    Time period
    2022
    Content

    A breakdown of the number of providers by region.

    More details for Proportion of providers offering other services (group based providers and school based providers) (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of providers offering services in addition to childcare and early years provision, and the types of services that they offer, broken down by provider type.

    More details for Proportion of providers that are part of a chain (group based providers) (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The proportion of group-based providers that are part of a chain of providers.

    More details for Proportion of providers providing care during both term time and school holiday (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of providers providing care during both term time and school holidays, broken down by provider type.

    More details for Average number of weeks providers expect to be open during the year (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The average number of weeks that providers expect to be open during the year, broken down by provider type.

    More details for Mean provider opening hours (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    Mean provider opening hours, broken down by provider type.

    More details for Number of registered places by region (2022)

    This subject includes the following data:

    Geographic levels
    Regional
    Time period
    2022
    Content

    The number of Ofsted-registered places, broken down by region and provider type.

    More details for Total registered places (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the number of Ofsted-registered places, broken down by provider type. Due to a small change in the way that private and voluntary group-based providers are defined, private and voluntary group-based provider figures for 2021 and 2022 are not directly comparable (all group-based provider figures, however, are unaffected).

    More details for Average registered places per provider (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the average number of Ofsted-registered places broken down by provider type.

    More details for Total booked places (2019, 2021, and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2019 to 2022
    Content

    A time series of the number of booked places, broken down by provider type.

    More details for Total number of spare places and average spare places per provider (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The number of spare (or “surplus”) places, and the average number of surplus places per provider, broken down by provider type.  A provider has “surplus” places if it is willing and able to take an additional child or children, over and above those children that are already booked.

    More details for Proportion of providers with one or more surplus place (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of providers that have spare (or “surplus”) places, broken down by provider type.  A provider has “surplus” places if it is willing and able to take an additional child or children, over and above those children that are already booked.

    More details for Proportion of places that are surplus (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of places that are spare (or “surplus”) broken down by provider type.  A provider has “surplus” places if it is willing and able to take an additional child or children, over and above those children that are already booked.

    More details for Change in rate occupancy in the last year (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    Change in occupancy rates in the last year, as reported by providers, broken down by provider type.

    More details for Number of bookings for childminders being for their own child/children (per childminder) (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The number of childminders that care for one, two or more than two of their own children, as well as providing care to other children.

    More details for Proportion of childminders employing an assistant (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the proportion of childminders that employ an assistant.

    More details for Number of paid childcare provider staff (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the number of paid provider staff, broken down by provider type.  Temporary staff are included but volunteer staff and apprentices are excluded.  Due to a small change in the way that private and voluntary group-based providers are defined, private and voluntary group-based provider figures for 2021 and 2022 are not directly comparable (all group-based provider figures, however, are unaffected).

    More details for Mean number of staff per provider (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the mean number of paid staff per provider, broken down by provider type.   Temporary staff are included but volunteer staff and apprentices are excluded. 

    More details for Proportion of providers employing temporary staff and the number of temporary staff they employ (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The proportion of providers that employ temporary staff, and the number of temporary staff that they employ, in 2021 and 2022.

    More details for Proportion of providers employing volunteer staff and the number of volunteer staff they employ (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The proportion of providers that employ volunteer staff, and the number of volunteer staff that they employ, in 2021 and 2022.

    More details for Proportion of providers employing apprentices and the number of apprentices they employ (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The proportion of providers that employ apprentices, and the number of apprentices that they employ, in 2021 and 2022.

    More details for Proportion of apprentices employed on each level of apprenticeship (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The proportion of apprentices employed at Level 2 and the proportion employed at Level 3 in 2021 and 2022

    More details for Number of staff recruited and leaving the provider in the last 12 months (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The number of staff recruited and leaving in the last 12 months.  Refers to the number recruited to and leaving a particular provider, not the number recruited to and leaving the childcare and early years profession.

    More details for Staff turnover rate (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    Staff turnover rates, broken down by provider type.  Staff turnover rates are the number of staff who left employment during the period expressed as a percentage of the total number of staff employed at the start of the period.

    More details for Proportion of staff qualified to different levels (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the proportion of paid staff qualified to different levels.  Temporary staff are included but volunteer staff and apprentices are excluded.  

    More details for Proportion of staff with highest qualification at level 3 who hold the Early Years Educator qualification (2018, 2019, 2021, and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the proportion of staff with highest qualification at Level 3 who hold the Early Years Educator qualification.

    More details for Proportion of staff qualified to Level 6 who hold different Level 6 qualifications (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The proportion of staff qualified to Level 6 who hold different Level 6 qualifications in 2021 and 2022.

    More details for Childcare staff by gender (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    A breakdown of paid staff by gender and provider type.  Temporary staff are included but volunteer staff and apprentices are excluded.  

    More details for Childcare staff by ethnicity (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    A breakdown of paid staff by ethnicity and provider type.  Temporary staff are included but volunteer staff and apprentices are excluded.  

    More details for Childcare staff by age group (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    A breakdown of paid staff by age group and provider type.  Temporary staff are included but volunteer staff and apprentices are excluded.  

    More details for Proportion of staff earning below NLW (2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2019 to 2022
    Content

    The proportion of paid staff aged 23 and over earning below the National Living Wage. Refers to gross pay, before tax and National Insurance are deducted.  Temporary staff are included but volunteer staff and apprentices are excluded.  

    More details for Staff:child ratios for under 2s (group-based providers) (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    Ratio of staff to children aged under 2 in group-based providers in 2021 and 2022.

    More details for Staff:child ratios for 2 year olds (group-based providers) (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    Ratio of staff to children aged 2 in group-based providers in 2021 and 2022.

    More details for Staff:child ratios for 3 to 4 year olds (school-based and group-based providers) (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    Ratio of staff to children aged 3 and 4 in group-based and school-based providers in 2021 and 2022.

    More details for Proportion of providers that are aware of and have used the "exceptional circumstances" allowance regarding staff to child ratios (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    Proportion of providers that are aware of and have used the exceptional circumstances allowance regarding staff to child ratios.

    More details for Breakdown of provider costs (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    A breakdown of provider costs by type of cost.  Childminder costs are not comparable with costs in other provider types and are not shown in the table.

    More details for Number and proportion of providers providing childcare to one or more 2-year-old funded through the 15-hour entitlement (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The number and proportion of providers providing childcare to one or more 2 year old funded through the 15-hour entitlement in 2021 and 2022.  See Section 7 of the release for more details of the different entitlements.

    More details for Number and proportion of providers providing childcare to one or more 3- to 4-year-old funded through the 15-hour entitlement (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The number and proportion of providers providing childcare to one or more 3- to 4-year-old funded through the 15-hour entitlement in 2021 and 2022.  See Section 7 of the release for more details of the different entitlements.

    More details for Number and proportion of providers providing childcare to one or more 3- to 4-year-old funded through the 30-hour entitlement (2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2021 to 2022
    Content

    The number and proportion of providers providing childcare to one or more 3- to 4-year-old funded through the 30-hour entitlement in 2021 and 2022.  See Section 7 of the release for more details of the different entitlements.

    More details for Proportion of providers providing entitlements throughout the year (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of providers that provide entitlements throughout the year.  See Section 7 of the release for more details of the different entitlements.

    More details for Proportion of providers providing entitlement without any restrictions (2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of providers that provide entitlements without any restrictions.  See Section 7 of the release for more details of the different entitlements.

    More details for Proportion of providers signed up to receive Tax-Free Childcare payments (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the proportion of providers that are signed up to receive Tax-Free Childcare payments.  See Section 7 of the release for more details of Tax-Free Childcare.

    More details for Proportion of providers caring for at least one child with SEND (2018, 2019, 2021 and 2022)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2018 to 2022
    Content

    A time series of the proportion of providers caring for at least one child with SEND.

    More details for Proportion of providers that employ and / or have access to a Special Educational Needs Co-ordinator (SENCO)

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    The proportion of providers that employ and / or have access to a Special Educational Need Co-ordinator (SENCO).

    More details for Headlines

    This subject includes the following data:

    Geographic levels
    National
    Time period
    2022
    Content

    Headline statistics from the 2022 SCEYP.