We have detected that you are using Internet Explorer to visit this website. Internet Explorer is now being phased out by Microsoft. As a result, NHS Digital no longer supports any version of Internet Explorer for our web-based products, as it involves considerable extra effort and expense, which cannot be justified from public funds. Some features on this site will not work. You should use a modern browser such as Edge, Chrome, Firefox, or Safari. If you have difficulty installing or accessing a different browser, contact your IT support team.
Download registers to .csv file
Alongside the API endpoints, users can choose to download registers to a .csv.
Once you've chosen the relevant schema option (which will usually be ‘dbo’), you can choose the register you are interested in by selecting from the drop-down list. You'll be presented with a summary of the metadata associated with the registers - for example, field name and data type. You can choose to query the data by choosing to view the following records:
The default view is ‘Latest’. Once you've chosen either of the above options, and selected the blue ‘Query’ option, you'll be presented with a limited view of the data and offered the option to ‘Download’ the data.
Some registers such as POSTCODE and ONS_POPULATION_V2 are very large, containing millions of records, and will result in the creation of several .csv files.
Most of our registers are history versioned “Type 2” (see ‘Supporting information’ pages for more information) and when selected you will have the options to select either “Latest”, “Archived” or “All” data for the register. Please see example below.
However some of our registers employ a full refresh update method (see ‘Supporting information’ pages for more information); when these table are selected you will only have the option to query “All” data for the register, please see example below.