Counties Subdivisions - United States of America

Name: Counties Subdivisions - United States of America
Creator: opendatasoft

APIQuery nowOpen workbench🇫🇷France

This dataset is part of the Geographical repository maintained by Opendatasoft. This dataset contains data for counties subdivisions and equivalent entities in United States of America. County subdivisions are the primary divisions of counties and their equivalent entities for the reporting of Ce...

⬇ Export CSV List records Select & filter API base URL Read the docs

Trust score

How is this computed?

poor

Weighted across five axes. Tap a ring for what it measures.

Data schema (14 fields)

Filterable via the API (12)

yearste_codeste_namecoty_codecoty_namecousub_codecousub_namecousub_area_codecousub_typecousub_name_longcousub_fp_codecousub_gnis_code

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	—
—	geo_shapeShape	geo_shape	—
—	year	date	—
—	ste_codeOfficial Code State	text	—
—	ste_nameOfficial Name State	text	—
—	coty_codeOfficial Code County	text	—
—	coty_nameOfficial Name County	text	—
—	cousub_codeOfficial Code County Subdivision	text	—
—	cousub_nameOfficial Name County Subdivision	text	—
—	cousub_area_codeIso 3166-3 Area Code	text	—
100%	cousub_typeType	text	—
101%	cousub_name_longName with legal/statistical area description	text	—
100%	cousub_fp_codeCounty Subdivision FIPS Code	text	—
100%	cousub_gnis_codeCounty Subdivision GNIS Code	text	—

Schema captured from opendatasoft 2 hours ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1year: 2023 · ste_code: ["41"]

{
  "year": "2023",
  "ste_code": [
    "41"
  ],
  "ste_name": [
    "Oregon"
  ],
  "coty_code": [
    "41047"
  ],
  "coty_name": [
    "Marion"
  ],
  "geo_shape": "[large value omitted]",
  "cousub_code": [
    "4104791428"
  ],
  "cousub_name": [
    "Jefferson"
  ],
  "cousub_type": "CCD",
  "geo_point_2d": {
    "lat": 44.77589484952142,
    "lon": -122.9880226717442
  },
  "cousub_fp_code": "91428",
  "cousub_area_code": "USA",
  "cousub_gnis_code": "01938032",
  "cousub_name_long": [
    "Jefferson CCD"
  ]
}

Record 2year: 2023 · ste_code: ["42"]

{
  "year": "2023",
  "ste_code": [
    "42"
  ],
  "ste_name": [
    "Pennsylvania"
  ],
  "coty_code": [
    "42007"
  ],
  "coty_name": [
    "Beaver"
  ],
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -80.503248,
            40.64396399906742
          ],
          [
            -80.505596,
            40.64738599906739
          ],
          [
            -80.512352,
            40.644908999067404
          ],
          [
            -80.511055,
            40.641376999067425
          ],
          [
            -80.506923,
            40.64280199906743
          ],
          [
            -80.503248,
            40.64396399906742
          ]
        ]
      ]
    },
    "properties": {}
  },
  "cousub_code": [
    "4200729392"
  ],
  "cousub_name": [
    "Glasgow"
  ],
  "cousub_type": "borough",
  "geo_point_2d": {
    "lat": 40.64439703768809,
    "lon": -80.50801229748332
  },
  "cousub_fp_code": "29392",
  "cousub_area_code": "USA",
  "cousub_gnis_code": "01214877",
  "cousub_name_long": [
    "Glasgow borough"
  ]
}

Record 3year: 2023 · ste_code: ["42"]

{
  "year": "2023",
  "ste_code": [
    "42"
  ],
  "ste_name": [
    "Pennsylvania"
  ],
  "coty_code": [
    "42051"
  ],
  "coty_name": [
    "Fayette"
  ],
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -79.910054,
            39.7283779990724
          ],
          [
            -79.904156,
            39.7277839990724
          ],
          [
            -79.896765,
            39.73396499907237
          ],
          [
            -79.895262,
            39.74079299907232
          ],
          [
            -79.903438,
            39.743076999072315
          ],
          [
            -79.903919,
            39.73780899907235
          ],
          [
            -79.910054,
            39.7283779990724
          ]
        ]
      ]
    },
    "properties": {}
  },
  "cousub_code": [
    "4205161864"
  ],
  "cousub_name": [
    "Point Marion"
  ],
  "cousub_type": "borough",
  "geo_point_2d": {
    "lat": 39.73514613020282,
    "lon": -79.90190763405016
  },
  "cousub_fp_code": "61864",
  "cousub_area_code": "USA",
  "cousub_gnis_code": "01215236",
  "cousub_name_long": [
    "Point Marion borough"
  ]
}

Record 4year: 2023 · ste_code: ["42"]

{
  "year": "2023",
  "ste_code": [
    "42"
  ],
  "ste_name": [
    "Pennsylvania"
  ],
  "coty_code": [
    "42077"
  ],
  "coty_name": [
    "Lehigh"
  ],
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -75.380396,
            40.5066579990681
          ],
          [
            -75.382333,
            40.51643299906805
          ],
          [
            -75.390793,
            40.51642399906805
          ],
          [
            -75.399807,
            40.51174999906807
          ],
          [
            -75.398821,
            40.5052889990681
          ],
          [
            -75.388292,
            40.50169699906813
          ],
          [
            -75.386717,
            40.50266899906811
          ],
          [
            -75.382017,
            40.50563099906811
          ],
          [
            -75.380396,
            40.5066579990681
          ]
        ]
      ]
    },
    "properties": {}
  },
  "cousub_code": [
    "4207716056"
  ],
  "cousub_name": [
    "Coopersburg"
  ],
  "cousub_type": "borough",
  "geo_point_2d": {
    "lat": 40.50949829143573,
    "lon": -75.389727488074
  },
  "cousub_fp_code": "16056",
  "cousub_area_code": "USA",
  "cousub_gnis_code": "01215374",
  "cousub_name_long": [
    "Coopersburg borough"
  ]
}

Record 5year: 2023 · ste_code: ["42"]

{
  "year": "2023",
  "ste_code": [
    "42"
  ],
  "ste_name": [
    "Pennsylvania"
  ],
  "coty_code": [
    "42117"
  ],
  "coty_name": [
    "Tioga"
  ],
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -77.048276,
            41.91337399906207
          ],
          [
            -77.045331,
            41.85602299906226
          ],
          [
            -77.024738,
            41.856099999062266
          ],
          [
            -77.023727,
            41.83354899906235
          ],
          [
            -76.904024,
            41.83811899906233
          ],
          [
            -76.911778,
            41.89668999906214
          ],
          [
            -76.914221,
            41.914939999062064
          ],
          [
            -77.048276,
            41.91337399906207
          ]
        ],
        [
          [
            -76.963779,
            41.86044899906225
          ],
          [
            -76.963405,
            41.868619999062226
          ],
          [
            -76.953269,
            41.86949699906222
          ],
          [
            -76.951321,
            41.85824299906226
          ],
          [
            -76.963779,
            41.86044899906225
          ]
        ]
      ]
    },
    "properties": {}
  },
  "cousub_code": [
    "4211766912"
  ],
  "cousub_name": [
    "Rutland"
  ],
  "cousub_type": "township",
  "geo_point_2d": {
    "lat": 41.87596480228431,
    "lon": -76.97578761189439
  },
  "cousub_fp_code": "66912",
  "cousub_area_code": "USA",
  "cousub_gnis_code": "01217121",
  "cousub_name_long": [
    "Rutland township"
  ]
}

Live sample captured at profiling time — values may have changed upstream.

Using the API

Configuration

Base URL: https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/georef-united-states-of-america-county-subdivision

License

Terms stated by the source (not a recognized license):

https://en.wikipedia.org/wiki/Public_domain

Query examples

curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/georef-united-states-of-america-county-subdivision/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

10 000 000 req/day

per ipmeasured

observed 2 hours ago

Dataset

Volume & freshness

Records

36k

36367

Update cadence

Annual

declared upstream

Last upstream update

2 years ago

2024-06-06

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.