About this Dataset

GP Practice Prescribing Data - Presentation Level

Warning: Large file size (over 1GB). Each monthly data set is large (over 10 million rows), but can be viewed in standard software such as Microsoft WordPad (save by right-clicking on the file name and selecting 'Save Target As', or equivalent on Mac OSX). It is then possible to select the required rows of data and copy and paste the information into another software application, such as a spreadsheet. What does the data cover? General practice prescribing data is a list of all medicines, dressings and appliances that are prescribed and dispensed each month. A record will only be produced when this has occurred and there is no record for a zero total. For each practice in England, including GP Practices, the following information is presented at presentation level for each medicine, dressing and appliance, (by presentation name): - the total number of items prescribed and dispensed - the total net ingredient cost - the total actual cost - the total quantity The data covers NHS prescriptions written in England and dispensed in the community in the UK. Prescriptions written in England but dispensed outside England are included. The data includes prescriptions written by GPs and other non-medical prescribers (such as nurses and pharmacists) who are attached to GP practices. Practices are identified only by their national code, so an additional data file - linked to the first by the practice code - provides further detail in relation to the practice. Presentations are identified only by their BNF code, so an additional data file - linked to the first by the BNF code - provides the chemical name for that presentation.
Publisher name: NHS Digital
Publisher URL: http://data.europa.eu/88u/.well-known/genid/aea2bd8a30505f40a0ac3fc98f4e0dac
Last updated: 2025-01-28T04:04:24Z

Tables

June 2011 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2011_practice_names_and_addresses

615.27 kB
10,201 rows
9 columns

CREATE TABLE june_2011_practice_names_and_addresses (
  "n_201106" BIGINT  -- 201106,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

June 2011 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2011_practice_prescribing_data

137.11 MB
10,124,676 rows
11 columns

CREATE TABLE june_2011_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2012 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2012_chemical_names_and_bnf_codes

67.6 kB
3,287 rows
4 columns

CREATE TABLE june_2012_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201206" VARCHAR  -- 201206,
  "n" VARCHAR
);

June 2012 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2012_practice_names_and_addresses

596.12 kB
10,051 rows
9 columns

CREATE TABLE june_2012_practice_names_and_addresses (
  "n_201206" BIGINT  -- 201206,
  "y00217" VARCHAR,
  "selby_miu" VARCHAR,
  "selby_war_memorial_hosp" VARCHAR  -- SELBY WAR MEMORIAL HOSP.,
  "doncaster_road" VARCHAR,
  "selby" VARCHAR,
  "n" VARCHAR,
  "yo8_9bx" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

June 2012 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2012_practice_prescribing_data

133.14 MB
9,896,651 rows
11 columns

CREATE TABLE june_2012_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2013 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2013_chemical_names_and_bnf_codes

68.54 kB
3,330 rows
4 columns

CREATE TABLE june_2013_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201306" VARCHAR  -- 201306,
  "n" VARCHAR
);

June 2013 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2013_practice_names_and_addresses

591.74 kB
9,796 rows
8 columns

CREATE TABLE june_2013_practice_names_and_addresses (
  "n_201306" BIGINT  -- 201306,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR
);

June 2013 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2013_practice_prescribing_data

133.48 MB
9,917,174 rows
11 columns

CREATE TABLE june_2013_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2014 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2014_chemical_names_and_bnf_codes

69.28 kB
3,360 rows
4 columns

CREATE TABLE june_2014_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201406" VARCHAR  -- 201406,
  "n" VARCHAR
);

June 2014 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2014_practice_names_and_addresses

593.78 kB
9,920 rows
8 columns

CREATE TABLE june_2014_practice_names_and_addresses (
  "n_201406" BIGINT  -- 201406,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR
);

June 2014 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2014_practice_prescribing_data

137.4 MB
10,141,653 rows
11 columns

CREATE TABLE june_2014_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2015 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2015_chemical_names_and_bnf_codes

70.23 kB
3,410 rows
4 columns

CREATE TABLE june_2015_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201506" VARCHAR  -- 201506,
  "n" VARCHAR
);

June 2015 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2015_practice_names_and_addresses

591.4 kB
9,897 rows
8 columns

CREATE TABLE june_2015_practice_names_and_addresses (
  "n_201506" BIGINT  -- 201506,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR
);

June 2015 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2015_practice_prescribing_data

140.45 MB
10,245,224 rows
11 columns

CREATE TABLE june_2015_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2016 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2016_chemical_names_and_bnf_codes

70.84 kB
3,443 rows
4 columns

CREATE TABLE june_2016_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201606" VARCHAR  -- 201606,
  "n" VARCHAR
);

June 2016 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2016_practice_names_and_addresses

605.24 kB
9,870 rows
9 columns

CREATE TABLE june_2016_practice_names_and_addresses (
  "n_201606" BIGINT  -- 201606,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton_on_tees" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR,
  "n" VARCHAR
);

June 2016 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2016_practice_prescribing_data

140.25 MB
10,240,053 rows
11 columns

CREATE TABLE june_2016_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2017 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2017_chemical_names_and_bnf_codes

71.55 kB
3,474 rows
4 columns

CREATE TABLE june_2017_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201706" VARCHAR  -- 201706,
  "n" VARCHAR
);

June 2017 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2017_practice_names_and_addresses

582.8 kB
9,774 rows
8 columns

CREATE TABLE june_2017_practice_names_and_addresses (
  "n_201706" BIGINT  -- 201706,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton_on_tees" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR
);

June 2017 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2017_practice_prescribing_data

139.83 MB
10,144,514 rows
11 columns

CREATE TABLE june_2017_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

June 2018 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.june_2018_chemical_names_and_bnf_codes

72.46 kB
3,507 rows
4 columns

CREATE TABLE june_2018_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201806" VARCHAR  -- 201806,
  "n" VARCHAR
);

June 2018 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.june_2018_practice_names_and_addresses

569.98 kB
9,552 rows
8 columns

CREATE TABLE june_2018_practice_names_and_addresses (
  "n_201806" BIGINT  -- 201806,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton_on_tees" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR
);

June 2018 Practice Prescribing Data

@ukgov.prescribing_by_gp_practice_presentation_level.june_2018_practice_prescribing_data

134.12 MB
9,780,870 rows
11 columns

CREATE TABLE june_2018_practice_prescribing_data (
  "n__sha" VARCHAR  -- SHA,
  "pct" VARCHAR,
  "practice" VARCHAR,
  "bnf_code" VARCHAR,
  "bnf_name" VARCHAR,
  "items" BIGINT,
  "nic" DOUBLE,
  "act_cost" DOUBLE,
  "quantity" BIGINT,
  "period" BIGINT,
  "n" VARCHAR
);

March 2011 Chemical Names And BNF Codes

@ukgov.prescribing_by_gp_practice_presentation_level.march_2011_chemical_names_and_bnf_codes

67.64 kB
3,290 rows
4 columns

CREATE TABLE march_2011_chemical_names_and_bnf_codes (
  "chem_sub" VARCHAR,
  "name" VARCHAR,
  "n__201103" VARCHAR  -- 201103,
  "n" VARCHAR
);

March 2011 Practice Names And Addresses

@ukgov.prescribing_by_gp_practice_presentation_level.march_2011_practice_names_and_addresses

619.46 kB
10,290 rows
9 columns

CREATE TABLE march_2011_practice_names_and_addresses (
  "n_201103" BIGINT  -- 201103,
  "a81001" VARCHAR,
  "the_densham_surgery" VARCHAR,
  "the_health_centre" VARCHAR,
  "lawson_street" VARCHAR,
  "stockton" VARCHAR,
  "cleveland" VARCHAR,
  "ts18_1hu" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);