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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"opendata-maryland-gov/maryland-counties-match-tool-for-data-quality-gwin-swf7\".\"maryland_counties_match_tool_for_data_quality\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.