Hi all. Thanks for the many suggestions and questions. The original data was from the ACS, b17020 a-i, poverty status by age, one table for each race. This is public domain data. I'm attaching here a modified data set for b17020b, Black or African American Alone. The columns in this data set are:
cos = the code we use for county
total = total number of children under 18 (sum of ages under 6 + age 6-11 + ages 12-17
underpov = total number of children under 18 below poverty level
region = I assigning counties to either NYC or ROS (Rest Of State - New York State excluding New York City)
I had downloaded one data file with data by county, and another file for NY State, and another file for NY City, so this data set has all three. But the Census has no category for ROS, so I wanted to make a row for total and underpov for ROS.
Our codes for NYS = 999, code for NYC = 102, and code for ROS = 888.
I hope this helps.
... View more