2022 Connecticut Relationship File Record Layouts

2022 118th Congressional District (CD) 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
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
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
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 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_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
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
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 the 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
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 the 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 - November 1, 2024