Actually Clean Data ↗

SOURCES, VERSIONS & WHAT CHANGED

Why an industry-code update is more than find and replace

What the 2017 → 2022 industry concordance tells you before updating your records.

1150code-pair relationships
92017 codes with several matches
792022 codes combining several old codes
16same-code pairs with changed titles

One old code can require a real decision

The 2017 code 454110, Electronic Shopping and Mail-Order Houses, connects to 42 different 2022 codes. A blanket replacement would lose the distinction between the activities of individual businesses.

Five of the 42 possible matches
2022 code2022 title
441227Motorcycle, ATV, and All Other Motor Vehicle Dealers
441330Automotive Parts and Accessories Retailers
441340Tire Dealers
444140Hardware Retailers
444180Other Building Material Dealers

What to do with this

Join on the old code, inspect multiple matches, and use the business's activity to choose its new classification. Check your row counts before aggregating customer measures.

What these numbers mean

This compares classification editions, not two releases of our file. The concordance has 1,057 old codes and 1,012 new codes. There are 902 pairs with the same code and title, but a matching title alone does not establish an unchanged definition.

These are mapping counts, not counts of businesses that changed industries. The file contains no 2027 classification.

Official Census concordances · Download summary data

View product details, fields & sample →

Get the prepared crosswalk · $19