Two links that explain howSSN's have been designed and employed across the USA.
https://www.ssa.gov/policy/docs/ssb/v69n2/v69n2p55.html
List of area numbers assigned to each state.
042 is indeed a Connecticut designated number.
Second link: https://medicalbillingrcm.com/ssn-allocation-list/