DataUSA / datausa-tracker

0 stars 0 forks source link

ACS 2018 5-year data checks #288

Closed jspeis closed 4 years ago

jspeis commented 4 years ago

We will need to wait for the jade release and then we can spin up a k server for testing the v6 backend which has the latest data.

jspeis commented 4 years ago

@innerstage some a very quick check reveals some issues:

The acs.acs_ygpsar_poverty_by_gender_age_race_5 appears to be off ... looking at year-by-year totals:

sql>select "year",sum(mea) from acs.acs_ygpsar_poverty_by_gender_age_race_5 group by "year";
+------+----------+
| year | L3       |
+======+==========+
| 2013 | 18766800 |
| 2014 | 18787080 |
| 2015 | 18800080 |
| 2016 | 18785208 |
| 2017 | 18186480 |
| 2018 |  1903668 |
+------+----------+

Seems like the number of records drops off a cliff on 2018? Can you double check this and examine the cause? I would expect this number to be higher than 2017 because we are adding Congressional Districts