Case #: GS-261688 - County names error on B1903

Hi,

I hope this is OK. I plan on posting when I find errors. Two county names are spelled differently on B1903. They are, Bayamón Municipio, Puerto Rico and Doña Ana County, New Mexico. The special characters are presented differently. I use names to match data sets and this is how I found out. In the other 30 tables all names matched exactly.

Parents
  • I'd strongly recommend you use the GEOID/FIPS codes rather than names, for precisely this reason. Some file formats don't do well with diacritical marks (you can see how they came out in your post). Often, even when they do appear to be formatted correctly, software still won't match them. That's why the GEOIDs exist, and are standard across all datasets you'll ever find at the county-equivalent level.

  • Thanks for all the feedback. When I download the files none of them have codes. I am not at the point of using an API or R etc. I just am downloading the data tables and trying to match them up. If you know of any way to add the codes to these downloads please let me know.  Thanks!

  • I find it hard to believe that any data set downloaded from data.census.gov would not include geocodes. 

Reply Children