Download Data

Download and take away data

The data on My NHS is available to download as CSV files below. Please select the 'About CSV Files' tab above for help with downloading and utilising the data.

  • Ankle replacement raw data (CSV, approx. < 1 MB)
  • Bariatric surgery raw data (CSV, approx. < 1 MB)
  • Cardiac surgery raw data (CSV, approx. < 1 MB)
  • Care homes with nursing raw data (CSV, approx. 1-5 MB)
  • Care homes without nursing raw data (CSV, approx. < 10 MB)
  • CCG - Better care (CSV, approx. < 1 MB)
  • CCG - Better health (CSV, approx. < 1 MB)
  • CCG - Sustainability (CSV, approx. < 1 MB)
  • CCG - Well-led (CSV, approx. < 1 MB)
  • CCG - Year-end 2015 assurance assessment (CSV, approx. < 1 MB)
  • Colorectal cancer surgery raw data (CSV, approx. < 1 MB)
  • Dentists raw data (CSV, approx. < 1 MB)
  • Digital maturity raw data (CSV, approx. < 1 MB)
  • Elbow & Shoulder replacement raw data (CSV, approx. < 1 MB)
  • GP Practices raw data (CSV, approx. < 10 MB)
  • Health and wellbeing outcomes raw data (CSV, approx. < 1 MB)
  • Heart attack raw data (CSV, approx. < 1 MB)
  • Hip fracture raw data (CSV, approx. < 1 MB)
  • Hip replacement raw data (CSV, approx. < 1 MB)
  • Hospitals raw data (CSV, approx. 1-5 MB)
  • Integrated health and social care raw data (CSV, approx. < 1 MB)
  • Knee replacement raw data (CSV, approx. < 1 MB)
  • Lung cancer raw data (CSV, approx. < 1 MB)
  • Major Trauma Surgery raw data (CSV, approx. < 1 MB)
  • Maternity raw data (CSV, approx. < 1 MB)
  • Mental health trusts raw data (CSV, approx. < 1 MB)
  • Neurosurgery raw data (CSV, approx. < 1 MB)
  • Oesophago-gastric cancer surgery raw data (CSV, approx. < 1 MB)
  • Psychological therapies (IAPT) raw data (CSV, approx. < 1 MB)
  • Public health programmes raw data (CSV, approx. < 1 MB)
  • Social care outcomes raw data (CSV, approx. < 1 MB)
  • Stroke care raw data (CSV, approx. < 1 MB)
  • Urology raw data (CSV, approx. < 1 MB)
  • Vascular raw data (CSV, approx. < 1 MB)
  • My NHS transparency roadmap (PDF, 170 KB)

The downloads are available under the Open Government Licence v2.0.

About our data download

PDF version of this page | PDF, approx. 109kb

NHS Choices data downloads are presented as comma-separated values (CSV). To avoid confusion with the many commas that appear in organisation addresses, the separator value we use is the NOT symbol.

To make use of the data, open it in a spreadsheet application such as Microsoft Excel. You can then split the content into separate columns and use a lookup command to find the data you are interested in.

The following information applies to Excel 2010. For help on other versions of Excel, please visit Microsoft support page

To import delimited content

1. Download and save the required *.csv file to your chosen location.
2. Start Excel with a blank worksheet open.
3. Select 'Data' on the toolbar, and then 'From Text' (to the left of the screen)
4. Browse for the *.csv file you want to open, and click 'Import'.

In the Text import wizard

1. Step 1, Ensure the 'Delimited' option is selected. Click Next.
2. Step 2, In the delimiters section, tick 'Other ' and enter a NOT symbol ¬, The text qualifier box should show the double-quote symbol. Click Finish
3. Import the data to the worksheet

Please be aware, some of the files may take longer to import depending on the file size.

VLOOKUP

Where data extracts have an identifier in common, for example the OrganisationID, you can look up data from one spreadsheet and copy it into another. VLOOKUP in Excel look for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.

The information below has been obtained from Microsoft web site

Lookup_value

The value to search in the first column of the table array. Lookup_value can be a value or a reference. If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.

Table_arry

Two or more columns of data. Use a reference to a range or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase text are equivalent.

Col_index_num

The column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is:

  • Less than 1, VLOOKUP returns the #VALUE! error value.
  • Greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.

Range_lookup

A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:

  • If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.

The values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP may not give the correct value. You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.

  • If FALSE, VLOOKUP will only find an exact match. In this case, the values in the first column of table_array do not need to be sorted. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.

Missing Data

The content offered as CSV downloads is always the latest we have. Because it comes from numerous sources, changes frequently and is supplied to us from local, regional and national levels, there will always be cases where data is incomplete. Where data is missing so that fields are blank, it could be that the data is not yet available or has not yet been supplied to us. In the case of individual services, for example, many profiles are updated by local web editors. If the local editor has not, for instance, added an email address, then the email address in the service's CSV file will be blank. We do, however, go to great lengths to ensure all our data is as complete as possible.

Syndication

Another way of accessing NHS data is through our syndication services, which allows you to pull content from the NHS Choices website via a feed. Any information you syndicate will remain up to date, regardless of any changes we make. Visit the Syndication page for more information

We want your feedback

We will continually add to this performance information, listen to what you want, and work to make it as clear as possible. Contact us to suggest any improvements or provide any feedback.