These files provide the original and adjusted weights (monthly and annualized) The Hamilton Project and the Upjohn Institute used to construct the CPS population adjustment backcast detailed in the post: Who's Missing from the Post-Pandemic Labor Force? The corresponding technical appendix provides a more detailed description of the methods used for the backcast and decomposition. The spreadsheet containing the published and backcast labor market data is also available for download. Please note that these numbers are not seasonally adjusted.
This program is written for Stata and for microdata provided by IPUMS. Please open the file CPS Census Backcast Cells to begin. For those using other base data or programs, it should clarify the variables by which you can merge the backcast file with your data.
Open or import CPS Census Backcast THP Upjohn data (or Excel) file to get a sense for the setup and save.
Use your CPS Monthly microdata. You will need to construct race/ethnicity and age variables to match to the backcast file. These cells were selected to match the smallest cells that The Census Bureau provided to assess the effect of the population adjustments in January 2022 and January 2023.
The Hamilton Project at Brookings produces research and policy proposals on how to create a growing economy that benefits more Americans. Find us on Twitter and at hamiltonproject.org.