Is it possible to get the unemployment rate by census tract level? I could not find it in the census reporter.
Thanks!
Robin
That's a measure you'd have to calculate yourself.table B23025: Unemployed / table B23025: In Labor Force
Good luck.
Robin, you can get table B23025 for all US tracts at once on the MCDC site.
https://mcdc.missouri.edu/cgi-bin/uexplore?/data/acs2019/base_tables_5yr
Use the dataset ustracts21_24 for table B23025: https…
Yikes! I see what you mean. I think I will leave it out of my project and stick with what I have. Thanks!
PolicyMap has this pre-baked, if you have access to it: https://plcy.mp/H3XG8Vw
Thanks Bernie. Unfortunately PolicyMap will not let me signup.
Use the dataset ustracts21_24 for table B23025: https://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=utils.uex2dex.sas&path=/data/acs2019/base_tables_5yr&dset=ustracts21_24&view=0
Find the variables you need, in your case it's B23025i3 (Civilian labor force) and B23025i5 (unemployed). Save as a CSV, then just use Excel to do the math.
Let me know if you need assistance with this data tool.
Depending on which census tracts you're interested in, the City Health Dashboard has this available for download as well (the measure is called "Unemployment - annual, neighborhood-level"). www.cityhealthdashboard.com/
Hi Robin. I work at PolicyMap and would be happy to help you sign up and subscribe. Feel free to message me directly! In the meantime, if you would like to explore the unemployment data by census tract, our latest mapping platform (which we are just in the process of releasing) will let you see the values without needing to sign in: https://www.policymap.com/newmaps#/. To find the unemployment data you can either search in the data search bar or go to the Economy Menu > Employment and Unemployment > Unemployment > Census ACS Civilians Unemployed. The shortcut link that Bernie posted above sends you to our old platform which is still accurate but lacks some of the new features.
Found it! Thank you so much!