search

NYCPlanning / db-equitable-development-tool

Data Repo for the equitable development tool (EDDT)
MIT License
0 stars 0 forks source link

Employment by occupation #69

Open AmandaDoyle opened 2 years ago

AmandaDoyle commented 2 years ago

Description: Management, business, science, and arts; Service; Sales and office; Natural Resources, construction, and maintenance; Production, transportation, and material moving

Do not compare with 2000, Legislation states 'Employment by occupation or industry sector'

Logic:

Source(s): ACS PUMS

Year(s):

Geographies:

Race and ethnicity breakdown: Yes Denominator: civilian employed population 16-64

SME: DCP Population Division

Questions:

Roadblocks:

SashaWeinstein commented 2 years ago

For the 2008-2012 dataset there are multiple OCCP variables. I've added a screenshot of the occupancy variables below.

Screen Shot 2022-01-26 at 5 39 55 PM

I'm hoping that it's like PUMA where each record has only one of these and it's easy to combine them all to one column. Want to document now so we are aware of this issue if it comes up later

SashaWeinstein commented 2 years ago

Currently this indicator doesn't apply the civilian filter. I found information on whether some is in the civilian workforce in the "Employment Status Recode" variable ESR.

Screen Shot 2022-01-28 at 9 12 49 AM

Using this to filter for civilian workers