In each monthly release of this publication, the data is presented in two formats, the summary document, which contains a 30 month timeseries with daily and regional counts for the most recent month, and zipped CSV files. The contents of the zip files are outlined here to provide support for their use. Metadata for each of the CSV files can be found here.
Daily counts at sub ICB location level:
The csv files include data for each calendar month during the 30 month reporting period. The data is aggregated to daily counts, including breakdowns for appointment status, healthcare professional, mode of appointment and time between booking and appointment date. The data is aggregated to sub ICB location level, with NHS geographies included.
There is also a coverage file included, providing the number of practices or patients included in the publication and the total number for the sub ICB location for each month in the reporting period.
These files can be used to look at appointments across all regions for a particular day, week or month. For example, you can look at the daily count of telephone appointments with an appointment status of attended by NHS commissioning region.
Regional counts at sub ICB location level:
The csv files include data for each ICB for the 30 month reporting period. The data is aggregated to monthly counts, including breakdowns for appointment status, healthcare professional, mode of appointment and time between booking and appointment date. The data is aggregated to sub ICB location level, with NHS geographies up to NHS commissioning region included. These files can be used to look at appointments data for a particular geography during the full reporting period. For example, you can look at the monthly timeseries count of face-to-face appointments by sub ICB location for a chosen ICB.
COVID vaccination appointments (NIMS):
The csv file includes COVID-19 vaccination activity carried out by PCNs or practices from the NIMS vaccination dataset for each calendar month during the 30 month reporting period. The data includes a national, regional, ICB and sub ICB location breakdown of vaccine appointment counts, including ONS codes. This file can be used to look at COVID-19 vaccine appointments data for a particular region during the full reporting period. For example, you can look at the monthly timeseries count of vaccine appointments by sub ICB location for a chosen ICB.
National categorisation, SDS role groups and actual duration CSVs:
Additional CSVs were added from March 2022 for each of the following measures: national categories, SDS role and actual duration. The data includes a national, regional, ICB and sub ICB location breakdown of appointment counts, including ONS codes.
National overview CSV:
A national overview CSV file is available from September 2022. This contains counts of appointments broken down by month, status, HCP type, mode, service setting, context type and national category at national level. This allows combinations of measures to be applied that aren’t available in other files. For example it is possible to identify the number of appointments with a HCP type of GP for a specific national category.