How to Filter Data
How to Filter Data Using Data Explorer Tool
Users can perform a search of any of the datasets in the Data Explorer tool.
Example search: How do I find general information about my doctor?
- Access the data at openpaymentsdata.cms.gov.
- Click on the file labeled, “General Payment Data with Identifying Recipient Information – Detailed Dataset 2013 Reporting Year.” This will display a table where the first column reads, “General_Transaction_ID.”
- To the right of the table you will see a sidebar labeled, “Filter.”
- In the first white box, you will see “Teaching_Hospital_Name” and a down arrow next to it. Click the first down arrow (circled in red on the screenshot). This will open up a dropdown menu where you can “Select a column to filter by.” Scroll down the list using the scroll bar on the right until you see “Physician_First_Name.”
- Select “Physician_First_Name” and enter the first name of your doctor into the text box that appears under “Physician_First_Name.” Press Enter or Return.
- In the second white box, you will see “Physician_Last_Name.” Enter the last name of your doctor into the text box that appears under it. Press Enter or Return.
You will now see a filtered list of results for the doctor you entered.
Save this search: You can save the applied filters by clicking “Save As” in the upper left-hand side of the screen. This eliminates the need to have to repeat the steps listed here in the future.
Export this search: You can also export this information by clicking on the blue button in the upper right-hand side of the screen labeled “Export.” In the “Download As” area that appears on the right side of the screen, select the format you'd like to save your file as. These formats include CSV, XLS and PDF formats, among others.
Print this search: You can also print the information from the Export side bar by clicking on the blue box labeled “Print.”
Further refine search results: To refine search results, click the second down arrow.
This will open up a dropdown menu where you can “Select an operation to filter by.” Scroll and select how you want to narrow your results using terms like “contains” or “starts with.”