National Incorporated Places and Counties

This dataset contains a listing of incorporated places (cities and towns) and counties within the United States including the GNIS code, FIPS code, name, entity type and primary point (location) for the entity. The types of entities listed in this dataset are based on codes provided by the U.S. Census Bureau, and include the following:

1. C1 - An active incorporated place that does not serve as a county subdivision equivalent;

2. C2 - An active incorporated place legally coextensive with a county subdivision but treated as independent of any county subdivision;

3. C3 - A consolidated city;

4. C4 - An active incorporated place with an alternate official common name;

5. C5 - An active incorporated place that is independent of any county subdivision and serves as a county subdivision equivalent;

6. C6 - An active incorporated place that partially is independent of any county subdivision and serves as a county subdivision equivalent or partially coextensive with a county subdivision but treated as independent of any county subdivision;

7. C7 - An incorporated place that is independent of any county;

8. C8 - The balance of a consolidated city excluding the separately incorporated place(s) within that consolidated government;

9. C9 - An inactive or nonfunctioning incorporated place;

10. H1 - An active county or statistically equivalent entity;

11. H4 - A legally defined inactive or nonfunctioning county or statistically equivalent entity;

12. H5 - A census areas in Alaska, a statistical county equivalent entity; and

13. H6 - A county or statistically equivalent entity that is areally coextensive or governmentally consolidated with an incorporated place, part of an incorporated place, or a consolidated city.

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 \"mydata-iowa-gov/national-incorporated-places-and-counties-djvt-gf3t\".\"national_incorporated_places_and_counties\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.