5

In looking at the Census ACS data there are several columns that have line numbers ending in .5 or .7. Their table_ids are duplicates of ones immediately before or after, making some import more difficult than it should be.

They seem to not have corresponding data in the distributed CSV data, either.

4

Before seeing this, I actually verified this answer just earlier today with Paul Overberg, one of the leading Census journalists around: the "fractional line numbers" represent "headers": that is, they are labels that group together subsequent rows but which don't have values themselves.

His example was the "Median income in the past 12 months --" line in this: segment of American Fact Finder view (from http://factfinder2.census.gov/bkmk/table/1.0/en/ACS/11_1YR/B07411)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.