search

censusreporter / census-api

The home for the API that powers the Census Reporter project.
MIT License
166 stars 50 forks source link

Tables B992704 and B992705 Return same value #69

Closed jboyda closed 6 years ago

jboyda commented 6 years ago

Calling B992704 and B992705 returns the same value for "Total".

I struggle to believe its a coincidence for every geoID considered B992704 is employer provided healthcare and B992705 is self purchased healthcare

JoeGermuska commented 6 years ago

The "total" column in an ACS table is the total number of people in the universe for that table. The universe is the same for those two tables, so the total should be the same.

Also, please be aware that tables with numbers beginning with 99 are technical tables giving information about how the survey was conducted. They should not be understood to reflect actual estimates about the number of people who had one kind of health care or the other.

See https://www.census.gov/programs-surveys/acs/methodology/sample-size-and-data-quality/item-allocation-rates-definitions.html for more about allocation.