U.S. flag

An official website of the United States government

Skip Header


2022 Connecticut Relationship File Record Layouts

2022 118th Congressional District to 2022 County for Connecticut Relationship File Layout (acs22_cd11822_county22_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_cd118_22 22 OID of 2022 cd118
GEOID_cd118_22 4 GEOID of the 2022 cd118
NAMELSAD_cd118_22 100 Name with translated Legal/Statistical Area Description of 2022 cd118
AREALAND_cd118_22 14 Total Land area of 2022 cd118 in square meters
AREAWATER_cd118_22 14 Total Water area of 2022 cd118 in square meters
MTFCC_cd118_22 5 MAFTIGER feature class code of 2022 cd118
CLASSFP_cd118_22 2 FIPS class code of 2022 cd118
FUNCSTAT_cd118_22 1 Functional status of 2022 cd118
OID_county_22 22 OID of 2022 county
GEOID_county_22 5 GEOID of the 2022 county
NAMELSAD_county_22 100 Name with translated Legal/Statistical Area Description of 2022 county
AREALAND_county_22 14 Land area of 2022 county in square meters
AREAWATER_county_22 14 Water area of 2022 county in square meters
MTFCC_county_22 5 MAFTIGER feature class code of 2022 county
CLASSFP_county_22 2 FIPS class code of 2022 county
FUNCSTAT_county_22 1 Functional status of 2022 county
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters

2022 County Subdivision to 2020 Block Groups for Connecticut Relationship File Layout (acs22_cousub22_blkgrp20_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_cousub_22 22 OID of the 2022 county subdivision
GEOID_cousub_22 10 GEOID of the 2022 county subdivision
NAMELSAD_cousub_22 100 Name with translated Legal/Statistical Area Description of the 2022 county subdivision
AREALAND_cousub_22 14 Total Land area of the 2022 county subdivision in square meters
AREAWATER_cousub_22 14 Total Water area of the 2022 county subdivision in square meters
MTFCC_cousub_22 5 MAFTIGER feature class code of the 2022 county subdivision
CLASSFP_cousub_22 2 FIPS class code of the 2022 county subdivision
FUNCSTAT_cousub_22 1 Functional status of the 2022 county subdivision
OID_blkgrp_20 22 OID of the 2020 block group
GEOID_blkgrp_20 12 GEOID of the 2020 block group
NAMELSAD_blkgrp_20 100 Name with translated Legal/Statistical Area Description of the 2020 block group
AREALAND_blkgrp_20 14 Land area of the 2020 block group in square meters
AREAWATER_blkgrp_20 14 Water area of the 2020 block group in square meters
MTFCC_blkgrp_20 5 MAFTIGER feature class code of the 2020 block group
CLASSFP_blkgrp_20 2 FIPS class code of the 2020 block group
FUNCSTAT_blkgrp_20 1 Functional status of the 2020 block group
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters

2022 County Subdivision to 2020 Public Use Microdata Areas (PUMA) for Connecticut Relationship File Layout (acs22_cousub22_puma520_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_cousub_22 22 OID of the 2022 county subdivision
GEOID_cousub_22 10 GEOID of the 2022 county subdivision
NAMELSAD_cousub_22 100 Name with translated Legal/Statistical Area Description of the 2022 county subdivision
AREALAND_cousub_22 14 Total Land area of the 2022 county subdivision in square meters
AREAWATER_cousub_22 14 Total Water area of the 2022 county subdivision in square meters
MTFCC_cousub_22 5 MAFTIGER feature class code of the 2022 county subdivision
CLASSFP_cousub_22 2 FIPS class code of the 2022 county subdivision
FUNCSTAT_cousub_22 1 Functional status of the 2022 county subdivision
OID_puma5_20 22 OID of the 2020 PUMA5
GEOID_puma5_20 7 GEOID of the 2020 PUMA5
NAMELSAD_puma5_20 100 Name with translated Legal/Statistical Area Description of the 2020 PUMA5
AREALAND_puma5_20 14 Land area of the 2020 PUMA5 in square meters
AREAWATER_puma5_20 14 Water area of the 2020 PUMA5 in square meters
MTFCC_puma5_20 5 MAFTIGER feature class code of the 2020 PUMA5
CLASSFP_puma5_20 2 FIPS class code of the 2020 PUMA5
FUNCSTAT_puma5_20 1 Functional status of the 2020 PUMA5
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters 

2022 County Subdivision to 2022 Census Tract for Connecticut Relationship File Layout (acs22_cousub22_tract22_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_cousub_22 22 OID of the 2022 county subdivision
GEOID_cousub_22 10 GEOID of the 2022 county subdivision
NAMELSAD_cousub_22 100 Name with translated Legal/Statistical Area Description of the 2022 county subdivision
AREALAND_cousub_22 14 Total Land area of the 2022 county subdivision5 in square meters
AREAWATER_cousub_22 14 Total Water area of the 2022 county subdivision in square meters
MTFCC_cousub_22 5 MAFTIGER feature class code of the 2022 county subdivision
CLASSFP_cousub_22 2 FIPS class code of the 2022 county subdivision
FUNCSTAT_cousub_22 1 Functional status of the 2022 county subdivision
OID_tract_22 22 OID of the 2022 tract
GEOID_tract_22 11 GEOID of the 2022 tract
NAMELSAD_tract_22 100 Name with translated Legal/Statistical Area Description of the 2022 tract
AREALAND_tract_22 14 Land area of the 2022 tract in square meters
AREAWATER_tract_22 14 Water area of the 2022 tract in square meters
MTFCC_tract_22 5 MAFTIGER feature class code of the 2022 tract
CLASSFP_tract_22 2 FIPS class code of the 2022 tract
FUNCSTAT_tract_22 1 Functional status of the 2022 tract
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters

2022 County Subdivision to 2020 ZIP Code Tabulation Area (ZCTA) for Connecticut Relationship File Layout (acs22_cousub22_zcta520_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_cousub_22 22 OID of the 2022 county subdivision
GEOID_cousub_22 10 GEOID of the 2022 county subdivision
NAMELSAD_cousub_22 100 Name with translated Legal/Statistical Area Description of the 2022 county subdivision
AREALAND_cousub_22 14 Total Land area of the 2022 county subdivision in square meters
AREAWATER_cousub_22 14 Total Water area of the 2022 county subdivision in square meters
MTFCC_cousub_22 5 MAFTIGER feature class code of the 2022 county subdivision
CLASSFP_cousub_22 2 FIPS class code of the 2022 county subdivision
FUNCSTAT_cousub_22 1 Functional status of the 2022 county subdivision
OID_zcta5_20 22 OID of the 2020 ZCTA5
GEOID_zcta5_20 5 GEOID of the 2020 ZCTA5
NAMELSAD_zcta5_20 100 Name with translated Legal/Statistical Area Description of the 2020 ZCTA5
AREALAND_zcta5_20 14 Land area of the 2020 ZCTA5 in square meters
AREAWATER_zcta5_20 14 Water area of the 2020 ZCTA5 in square meters
MTFCC_zcta5_20 5 MAFTIGER feature class code of the 2020 ZCTA5
CLASSFP_zcta5_20 2 FIPS class code of the 2020 ZCTA5
FUNCSTAT_zcta5_20 1 Functional status of the 2020 ZCTA5
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters

2022 State Legislative District-Lower Chamber (SLDL) to 2022 County for Connecticut Relationship File Layout (acs22_sldl202222_county22_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_sldl2022_22 22 OID of the 2022 SLDL
GEOID_sldl2022_22 5 GEOID of the 2022 SLDL
NAMELSAD_sldl2022_22 100 Name with translated Legal/Statistical Area Description of the 2022 SLDL
AREALAND_sldl2022_22 14 Total Land area of the 2022 SLDL in square meters
AREAWATER_sldl2022_22 14 Total Water area of the 2022 SLDL in square meters
MTFCC_sldl2022_22 5 MAFTIGER feature class code of the 2022 SLDL
CLASSFP_sldl2022_22 2 FIPS class code of the 2022 SLDL
FUNCSTAT_sldl2022_22 1 Functional status of the 2022 SLDL
OID_county_22 22 OID of the 2022 county
GEOID_county_22 5 GEOID of the 2022 county
NAMELSAD_county_22 100 Name with translated Legal/Statistical Area Description of the 2022 county
AREALAND_county_22 14 Land area of the 2022 county in square meters
AREAWATER_county_22 14 Water area of the 2022 county in square meters
MTFCC_county_22 5 MAFTIGER feature class code of the 2022 county
CLASSFP_county_22 2 FIPS class code of 2the 2022 county
FUNCSTAT_county_22 1 Functional status of the 2022 county
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters

2022 State Legislative District-Upper Chamber (SLDU) to 2022 County for Connecticut Relationship File Layout (acs22_sldu202222_county22_st09.txt)

Relationship File Column Name Maximum Length Column Definition
OID_sldu2022_22 22 OID of the 2022 SLDU
GEOID_sldu2022_22 5 GEOID of the 2022 SLDU
NAMELSAD_sldu2022_22 100 Name with translated Legal/Statistical Area Description of the 2022 SLDU
AREALAND_sldu2022_22 14 Total Land area of the 2022 SLDU in square meters
AREAWATER_sldu2022_22 14 Total Water area of the 2022 SLDU in square meters
MTFCC_sldu2022_22 5 MAFTIGER feature class code of the 2022 SLDU
CLASSFP_sldu2022_22 2 FIPS class code of the 2022 SLDU
FUNCSTAT_sldu2022_22 1 Functional status of the 2022 SLDU
OID_county_22 22 OID of the 2022 county
GEOID_county_22 5 GEOID of the 2022 county
NAMELSAD_county_22 100 Name with translated Legal/Statistical Area Description of the 2022 county
AREALAND_county_22 14 Land area of the 2022 county in square meters
AREAWATER_county_22 14 Water area of the 2022 county in square meters
MTFCC_county_22 5 MAFTIGER feature class code of the 2022 county
CLASSFP_county_22 2 FIPS class code of 2the 2022 county
FUNCSTAT_county_22 1 Functional status of the 2022 county
AREALAND_PART 14 Calculated Land area of the overlapping part in square meters
AREAWATER_PART 14 Calculated Water area of the overlapping part in square meters

Page Last Revised - April 27, 2023
Is this page helpful?
Thumbs Up Image Yes Thumbs Down Image No
NO THANKS
255 characters maximum 255 characters maximum reached
Thank you for your feedback.
Comments or suggestions?

Top

Back to Header