Download English Prescribing Dataset (EPD) Filtered Records Step-by-Step | Scribe

    Download English Prescribing Dataset (EPD) Filtered Records Step-by-Step

    • katenord |
    • 20 steps |
    • 6 minutes
    • NhsbsaNhsbsa
    information ordinal icon
    This guide explains how to use the NHSBSA Open Data Portal's filters to refine datasets by fields such as medication name, prescribing organisation, or time period. Filters can be selected from dropdown menus or entered manually, saving time when dealing with long lists. After applying all necessary filters, click **"Data Explorer Options"** and select **"Download Filtered Records"**—avoiding the green **"Download"** button at the top. For more details, continue reading or contact [[\[[email protected]]]\](mailto:[email protected]) for assistance.
    1
    Navigate to [https://opendata.nhsbsa.net/#home-page](https://opendata.nhsbsa.net/#home-page)
    2
    Click "Community Prescribing & Dispensing"
    3
    Click "English Prescribing Dataset (EPD)"
    4
    Click "English Prescribing Dataset (EPD) - For your required time period"
    5
    Click "Add Filter"
    6
    Click the drop-down menu.
    7
    Scroll to view selectable options in the field drop-down menu or start typing in the text box to return any matching results.
    8
    Click the drop-down menu for your selected field to start applying those filters in the same way as we just mentioned; scrolling through the list or free-typing to return matches.
    9
    Choose your value filter for the field.
    information ordinal icon
    By applying this one filter, the number of records has dropped significantly—18 million to 743k. This allows the dataset to be opened and worked with in database programs like Microsoft Excel.
    10
    You can add multiple filters to further reduce the file size and narrow down to what you need. \ \ Click to 'Add' another filter and repeat steps 8 & 9.
    information ordinal icon
    Tip! You can 'free-type' or 'select' your chosen value from the drop-down list
    11
    Free-typing shown in action:
    12
    Type "NHS NORTH"
    13
    Any partial or exact matches are returned.
    14
    Choose your value to filter this field on.
    information ordinal icon
    Tip! You can apply more than one value to any filtered field.
    15
    Select the drop down arrow on the next box along
    16
    Click this text field.