Master Table
Last updated
Last updated
COLUMN ID | COLUMN DESCRIPTION | DATA TYPE | DATA REPRESENTATION | GROUP NAME | SOURCE NAME |
---|---|---|---|---|---|
ZIP_CODE
US Zip Code
TEXT
TEXT
UNIVERSE
ATERIO
CITY_NAME
City name
TEXT
TEXT
UNIVERSE
ATERIO
COUNTY_NAME
County name
TEXT
TEXT
UNIVERSE
ATERIO
COUNTY_FIPS_CODE
Federal Information Processing Standards (FIPS) code for counties
TEXT
TEXT
UNIVERSE
ATERIO
STATE_CODE
State code
TEXT
TEXT
UNIVERSE
ATERIO
ATERIO_UNIQUE_ID
Aterio Unique ID for the record
TEXT
OTHER
UNIVERSE
ATERIO
LOCATION_LATITUDE
Latitude coordinate location
FLOAT
OTHER
UNIVERSE
CENSUS
LOCATION_LONGITUDE
Longitude coordinate location
FLOAT
OTHER
UNIVERSE
CENSUS
AREA_LAND_SQ_MI
Land area in square miles
FLOAT
OTHER
UNIVERSE
CENSUS
AREA_WATER_SQ_MI
Water area in square miles
FLOAT
OTHER
UNIVERSE
CENSUS
CBSA_CODE
Core-based Statistical Area Code
TEXT
OTHER
UNIVERSE
CENSUS
CBSA_TITLE
Core-based Statistical Area Title
TEXT
OTHER
UNIVERSE
CENSUS
STATISTICAL_AREA_TYPE_NAME
Type of CBSA (Metropolitan Statistical Area or Micropolitan Statistical Area)
TEXT
OTHER
UNIVERSE
CENSUS
PLACE_FIPS_CODE
City FIPS Code
TEXT
OTHER
UNIVERSE
CENSUS
IDX_POPULATION_MIGRATION
Index measuring population and migration trends
NUMBER
INDEX
POPULATION & MIGRATION
ATERIO
TOT_CENSUS_POP_2010
Population count for Census year 2010
NUMBER
QUANTITY
POPULATION & MIGRATION
CENSUS
TOT_CENSUS_POP_2011
Population count for Census year 2011
NUMBER
QUANTITY
POPULATION & MIGRATION
CENSUS