Hi there, I am having a hard time getting me table to join to my census tract tiger files. I want to join the C16001 table to my census tract provided by my county. The csv tables for LEP do not have the GEOID code. and they do not have the census tract clean and there is so much detail that I cannot make the join. I know I need to go through and clean the data however the tables I have used in the past made joining easy. I am in the wrong place to get these CSV's? In the past there was a an ID to the top of the csv page along with IDs to base the join on. Below is the file I have used in the past (2019), can you help me out. I am about to throw my computer out the window.
Jennifer, I think the trick is to choose the .zip option for the download and not the .csv. The .csv file within the zip file does have the geoids at the end of the data. You might have to unblock pop-ups to get the zip file downloaded.
Awesome! Thank you so much.