In each monthly release of this publication, the data is presented in two formats, the Summary document, which contains an 18 month timeseries with daily and regional counts for the most recent month, and zip files. The contents of the zip files are outlined here to provide support for their use.
Daily counts, at CCG level:
The csv files include data for each calendar month during the 18 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. The data is aggregated to CCG level, with NHS Geographies included. There is also a coverage file included, providing the number of practice or patients included in the publication and the total number for the CCG 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 CCG level:
The csv files include data for each Regional Local Office for the 18 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. The data is aggregated to CCG level, with NHS Geographies up to regional local office included. These files can be used to look at appointments data for a particular region during the full reporting period. For example, you can look at the monthly timeseries count of face-to-face appointments by CCG for a chosen STP.
Fields included
CCG_CODE
CCG_ONS_CODE
STP_CODE
REGIONAL_LOCAL_OFFICE_ONS_CODE
Appointment_Date/Appointment_Month1
APPT_STATUS
HCP_TYPE
APPT_MODE
TIME_BETWEEN_BOOK_AND_APPT
COUNT_OF_APPOINTMENTS
1 Daily csv files contain Appointment_Date. Regional csv files contain Appointment_Month.