Economic - 0812 and 1519 from Pop

[AmandaDoyle]

1) Use only data delivered by Population

• all workflows will build off existing ingestion processes
• incorporate data delivered by population on March 15

[SashaWeinstein]

The 2008-2012 data seems to be missing count of households per income bracket (extremely low income, low income, etc). Both 2008-2012 and 2015-2019 data have the median household income and total income fields

[SashaWeinstein]

@AmandaDoyle sorry forgot to tag you when I came across this issue

[AmandaDoyle]

Sorry - just getting to this.
That's right. Households per income bracket (i.e. the ELI households indicator) is only being reported for 2015-2019. Other indicators are available for both time periods.

[SashaWeinstein]

Awesome, thanks for the clarification

[SashaWeinstein]

Hey @AmandaDoyle how do we label median wages per industry? For example I am looking at median wages for workers in industry "Finance and insurance, and real estate and rental and leasing" which has code "fire". Would median wages by wages_fire_median, wages_fire_median_cv etc?

[SashaWeinstein]

Also how do we call median household income? It's labeled MdHInc in population's spreadsheet and I don't see it in the data dictionary

[SashaWeinstein]

Also found P16t64y_19E, assume the y is years and we can just take it out to have standard age indicator labels?

[SashaWeinstein]

Ok in the source data counts of workers per industry/occupation are crosstabbed by race, but median wages per industry/occupation aren't. This wasn't the pattern I was expecting, wanted to flag so we are on the same page @AmandaDoyle

[SashaWeinstein]

But industry wage is crosstabbed by race. Strange. Industry is the more granular categorization, 13 industries and only 5 occupations