Hi Christian,
Yeh to your point, these are not FIPS codes. OSM codes (https://osmcode.org/) are a different standard and probably too granular for our needs in which we need to translate zip codes to some region level.
Per FIPS (https://transition.fcc.gov/oet/info/maps/census/fips/fips.txt), for Middlesex County, NJ, the FIPS code should be 34023 which is a pre-coordinated code that contains the state code “34” and the county code for that state “023”.
Where would I find this code for Middlesex County, NJ within Athena if available?
I guess in your other suggestion, the request to bring in code mappings from zip to FIPS county/state can potentially be done and there is a cross-walk mapping (potentially outdated since the last release was in 2018). If I get instructions on how to to incorporate that mapping into Athena, then I suppose I can try. Just let me know.
Thanks!
May