Hello everyone.
I am trying to ascertain the unemployment rate for a particular census tract. I am new to all of this have not been able to capture it using the information in the discussions. Could someone break down to me (in English for us who are challenged), how to get this number? Thanks-
Try using the PolicyMap PolicyMap - Dig Deeper. It's easy to use and has lots of great information.
Robin
Thanks Robin!
There are 26 ACS tables with "EMPLOYMENT STATUS" in the title.
B23025 EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER
B23001 SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER
Are 2 examples. If you want other variables in addition for example EDUCATIONAL ATTAINMENT see for example B23006.
The search on data.census.gov returns too many matched for "EMPLOYMENT STATUS"
At the risk of over doing it here is the list that I get from the ACS metadata data file:
[1] "B23008 AGE OF OWN CHILDREN UNDER 18 YEARS IN FAMILIES AND SUBFAMILIES BY LIVING ARRANGEMENTS BY EMPLOYMENT STATUS OF PARENTS" [2] "B23003 PRESENCE OF OWN CHILDREN UNDER 18 YEARS BY AGE OF OWN CHILDREN UNDER 18 YEARS BY EMPLOYMENT STATUS FOR FEMALES 20 TO 64 YEARS" [3] "B10058 EMPLOYMENT STATUS OF GRANDPARENTS LIVING WITH OWN GRANDCHILDREN UNDER 18 YEARS BY RESPONSIBILITY FOR OWN GRANDCHILDREN AND AGE OF GRANDPARENT" [4] "C23002G SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (TWO OR MORE RACES)" [5] "C18120 EMPLOYMENT STATUS BY DISABILITY STATUS" [6] "C23002B SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (BLACK OR AFRICAN AMERICAN ALONE)" [7] "B99231 ALLOCATION OF EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER" [8] "C23002F SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (SOME OTHER RACE ALONE)" [9] "B14005 SEX BY SCHOOL ENROLLMENT BY EDUCATIONAL ATTAINMENT BY EMPLOYMENT STATUS FOR THE POPULATION 16 TO 19 YEARS" [10] "C23002H SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (WHITE ALONE, NOT HISPANIC OR LATINO)" [11] "B21005 AGE BY VETERAN STATUS BY EMPLOYMENT STATUS FOR THE CIVILIAN POPULATION 18 TO 64 YEARS" [12] "B23024 POVERTY STATUS IN THE PAST 12 MONTHS BY DISABILITY STATUS BY EMPLOYMENT STATUS FOR THE POPULATION 20 TO 64 YEARS" [13] "C23002C SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (AMERICAN INDIAN AND ALASKA NATIVE ALONE)" [14] "B26114 GROUP QUARTERS TYPE (3 TYPES) BY EMPLOYMENT STATUS" [15] "B27011 HEALTH INSURANCE COVERAGE STATUS AND TYPE BY EMPLOYMENT STATUS" [16] "C23002I SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (HISPANIC OR LATINO)" [17] "C23002D SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (ASIAN ALONE)" [18] "B17005 POVERTY STATUS IN THE PAST 12 MONTHS OF INDIVIDUALS BY SEX BY EMPLOYMENT STATUS" [19] "B23006 EDUCATIONAL ATTAINMENT BY EMPLOYMENT STATUS FOR THE POPULATION 25 TO 64 YEARS" [20] "B23025 EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER" [21] "B23001 SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER" [22] "B26214 GROUP QUARTERS TYPE (5 TYPES) BY EMPLOYMENT STATUS" [23] "C23002A SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (WHITE ALONE)" [24] "B16010 EDUCATIONAL ATTAINMENT AND EMPLOYMENT STATUS BY LANGUAGE SPOKEN AT HOME FOR THE POPULATION 25 YEARS AND OVER" [25] "B23007 PRESENCE OF OWN CHILDREN UNDER 18 YEARS BY FAMILY TYPE BY EMPLOYMENT STATUS" [26] "C23002E SEX BY AGE BY EMPLOYMENT STATUS FOR THE POPULATION 16 YEARS AND OVER (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE)"
These tables should be available at the census tract level. To get the official Bureau of Labor (BLS) statistics number you have to know who is in the labor force. These tables have a "NOT IN LABOR FORCE" row. I don't know if the ACS definitions agree with the BLS so you should research this.
It is useful if you put some background in your data users group profile so that people can better formulate answers to match your background.
Best Dave Dorer