core_pudl__codes_subdivisions

package: pudl

Code table containing descriptions of categorical codes for states, provinces, and other sub-national political subdivisions.

Processing:

Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.

Source:

The Public Utility Data Liberation (PUDL) Project

Primary key:

country_code, subdivision_code

Columns
country_code

Three letter ISO-3166 country code (e.g. USA or CAN).

country_name

Full country name (e.g. United States of America).

subdivision_code

Two-letter ISO-3166 political subdivision code (e.g. US state or Canadian province abbreviations like CA or AB).

subdivision_name

Full name of political subdivision (e.g. US state or Canadian province names like California or Alberta.

subdivision_type

ISO-3166 political subdivision type. E.g. state, province, outlying_area.

timezone_approx

IANA timezone name of the timezone which encompasses the largest portion of the population in the associated geographic area.

state_id_fips

Two digit state FIPS code.

division_name_us_census

Longer human readable name describing the US Census division.

division_code_us_census

Three-letter US Census division code as it appears in the bulk electricity data published by the EIA. Note that EIA splits the Pacific division into distinct contiguous (CA, OR, WA) and non-contiguous (AK, HI) states. For reference see this US Census region and division map: https://www2.census.gov/geo/pdfs/maps-data/maps/reference/us_regdiv.pdf

region_name_us_census

Human-readable name of a US Census region.

is_epacems_state

Indicates whether the associated state reports data within the EPA's Continuous Emissions Monitoring System.