Each month 3 files data files are released (2 months following the dispensing date). Monthly data is available from August 2010 to date.
Similar prescribing data is available by quarter or by year, but at PCT, CCG and England level.
As well as practice level data, PCT and CCG data sets include prescribing that cannot be attributed to specific practices and CCGs respectively. PCA data also includes dentists and all hospital prescriptions dispensed in the community where these prescriptions were dispensed in England (including prescriptions written in the three other UK countries).
Practice prescribing data file
CSV file of practice level prescribing data at presentation level this is the main data file at (warning - this is a large file with over 10 million records every month). Presentation level data is available from August 2010. This csv file contains the following items:
Practice prescribing data file
SHA1 |
SHA or AT code - 3 characters |
PCT2 |
PCT or CCG code - 3 characters |
PRACTICE |
ANNNNN Practice code - 6 characters |
BNF CODE |
British National Formulary (BNF) code - 15 characters |
BNF NAME |
BNF presentation name - 40 characters |
ITEMS |
Prescription items dispensed - whole numbers |
NIC |
Net ingredient cost - pounds and pence |
ACT COST |
Actual cost - pounds and pence |
QUANTITY |
Quantity - whole numbers |
PERIOD |
YYYYMM |
1 For data covering August 2010 to March 2013, the SHA field refers to Strategic Health Authority. Following changes to the NHS structure, from April 2013 onwards, the SHA field refers to Area Team.
2 For data covering August 2010 to March 2013, the PCT field refers to Primary Care Trust. Following changes to the NHS structure, from April 2013 onwards, the PCT field refers to Clinical Commissioning Group (CCG).
Practice level prescribing - practice codes, names and addresses file
CSV file which can be used to translate the Practice Code in the main data file.
Practice codes, names, addresses file
PERIOD |
YYYYMM |
Practice Code |
ANNNNN practice code - 6 characters |
Practice Name |
Name of surgery |
Address 1 |
ANY VILLA SURGERY |
Address 2 |
1 ANY ROAD |
Address 3 |
ANYTOWN |
Address 4 |
ANYSHIRE |
Postcode |
XX2 7XX |
Practice level prescribing chemical names and bnf code file
CSV file can be used to translate the presentation level 15 character BNF code of the main data file in to chemical level by using the first 9 characters. For dressings and appliances, where the concept of a "chemical" is not appropriate, only the 4 digit code is used.
summary="Chemical names and bnf code file
CHEM SUB |
Chemical BNF code - 9 characters |
NAME |
Chemical Name - 60 characters |