Icon for Socrata external plugin
Open repository in Console
Updated almost 5 years ago
Indexed 5 hours ago

Maryland Counties Match Tool for Data Quality

Data standardization is an important part of effective management. However, sometimes people have data that doesn't match. This dataset includes different ways that counties might get written by different people. It can be used as a lookup table when you need County to be your unique identifier. For example, it allows you to match St. Mary's, St Marys, and Saint Mary's so that you can use it with disparate data from other data sets.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"opendata-maryland-gov/maryland-counties-match-tool-for-data-quality-gwin-swf7\".\"maryland_counties_match_tool_for_data_quality\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • maryland_counties_match_tool_for_data_quality
Upstream Metadata