For this case study, we'll use data obtained from the city of Seattle, WA, open source database. Seattle is one of the many cities committed to providing easy access to their data through an online portal:
- Open a web browser and go to http://data.seattle.gov. You should see a page similar to the following screenshot, but keep in mind that websites change frequently so your version may look different:
- For this case study, we are interested in obtaining crime data, which can be found in a file named Seattle Policy Department Policy Report Incident. You can navigate directly to this file at https://data.seattle.gov/Public-Safety/Seattle-Police-Department-Police-Report-Incident/7ais-f98f.
- You can also use the search textbox and type in the term Seattle Police Department Police Report Incident. The report should be the first item returned in the search results.
- From the incident...