These queries make use of the county cross reference to organize cases by county. As before, The datasets used in this query can be downloaded here:

Query ch10.4 Incidents at location visit query on data.world

This query sorts the incidents by location, using the geographic information about counties from dbpedia (latitude, longitude), and reporting each case based on a location in the country. The locations are approximate, since we only have county information for each one.

Query ch10.5 Counting complaint types by location visit query on data.world

The previous query isn't very useful, since there is one result for each case, and there are thousands of cases. This query aggregates the answers, counting the number of each type of case per county, and cross referencing that number to the approximate location.