How to Create Filtered Views of Open Data
The County’s Open Data Portal hosts over 500 datasets that range from restaurant health inspection results and affordable housing projects to employee salary data and secured property taxes information. The catalog feature helps you browse and find data related to your topics of interest, but what if you want to find information inside a large dataset? See below to find out how you can create filtered views of the data you find most useful. Find the Open Data portal here: https://data.smcgov.org/browse.
It’s possible to search within a dataset using the search box at the top of a dataset view to see if the dataset contains information you’re interested in.
It’s also possible to find just the restaurant health inspections for Starbucks within the County and monitor that data for new entries.
The blue filter button on the top right of each dataset view is the most effective way to select specific data within a dataset.
To create a filter, click or tap “+Add a New Filter condition” and select the column you want to filter on. In this case, we’ll look for restaurant health inspection results for Starbucks.
This creates a new filtered view. We could add more filter conditions, like date, to see only restaurant health inspection results for Starbucks in 2017.
Once you’ve filtered the dataset down to the data you want, you can save the filtered view using the “Save As” button on the top left of the screen. Make sure to give it a name that makes sense to you. A quick note: to save filtered views, you need to create a free Socrata account.