I need to calculate population density at the level of U.S. Census tracts for across a number of states.
I used the instructions here Where to get 2010 Census Block data? to download DP-1 for the states CT, ME, MA, NH, NY, RI, and VT, but some of the values in the column for Total Population show up like this:
2114(r39570)
This evidently means that the value has been revised. I went back to American FactFinder to view the data, and by clicking on the value "(r39570)", I'm able to confirm that these indicate that the value has been revised:
As far as I can tell, the correct value, which is evidently 1120 in this example, does not appear anywhere in the .csv that I imported.
How can I get the correct values onto my computer and appropriately imported into QGIS so that I can perform the correct spatial calculations?