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:
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.
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.