Create github ready files for Congressional district files

[sonoshah]

Using the raw data, create github ready files that we can work with in R.

• model the final file structure to be similar to what is displayed currently on the old Quick Stats

ALL RAW FILES ARE IN OUR DROPBOX in the redesign --> congressional district folder

The existing congressional district tables on the website are:

AA + NHPI Proportion of district population

Combine these files:

• [x] B02001 for: AA Alone , NHPI Alone , State population

• [x] B02011 and B02012 for Asian & NHPI Combo

• [x] final file should have columns like the one here:

Detailed Origin By Congressional District (AA, count) (ASIAN ALONE)

• [x] Use B02015

Detailed Origin By Congressional District (AA, proportion of AA) (ASIAN ALONE)

• denominator is AA pop
• [x] Use B02015

Detailed Origin By Congressional District (NHPI, count) (NHPI ALONE)

• [x] Use B02016

Detailed Origin By Congressional District (NHPI, proportion of NHPI) (NHPI ALONE)

• denominator is NHPI pop
• [x] Use B02016

CVAP (using AA + NHPI ALONE)

• [x] Use B05003D + B05003E

LEP (AA + NHPI ALONE)

• [x] B16005D + B16005E

Note that this is different from the tables used for LEP for other geographies. I had to use this one since the other one was not available for Congressional District.

EDU (AA + NHPI ALONE)

• [x] Use B15002D + B15002E

[SunnyYShao]

finish creating all github ready congressional district data