I was looking for labor force participation rate and total labor force numbers for both native born and foreign born populations for each country in New Jersey from ACS 2022 (both 1 year and 5 year). Seems like there is no data for Cape May (countyfip 9
Cumberland (countyfip 11)
Salem (countryfip 33)
Are data not available for these counties?
In the public use ACS microdata, the smallest identifiable geographic area is the Public Use Microdata Area (PUMA). PUMAs are defined based on population, and include around (and no fewer than) 100,000 residents. IPUMS geographers are sometimes able to identify counties and other geographic areas like metropolitan statistical areas based on PUMA, but their ability to do so depends on how the PUMA boundaries overlap with county boundaries. This means that not all counties are identifiable in the ACS microdata. Additionally, PUMA boundaries change, usually every ten years, to account for changes in population distribution and density. So, some counties are identifiable in some years of data but not others. The 2022 1-year ACS uses 2020 PUMA definitions. The 2022 5-year ACS uses both the 2020 PUMA definitions (for data drawn from the 2022 ACS) and the 2010 PUMA definitions (for data drawn from the 2018-2021 ACS). You can read more about how PUMA definitions vary in some multi-year files in the PUMA description.
In this spreadsheet, linked in the description of COUNTYFIP on IPUMS USA, you can view the list of U.S. counties and which IPUMS USA samples they are identifiable in. Cape May County, NJ is identifiable in the 2000 census 5% sample, 2000 census 1% unweighted sample, 2005 ACS, and 2006-2011 ACS. It is not identifiable in the 2018-2022 ACS. You can see from the spreadsheet that the other counties you listed are not identifiable in the 2022 1-year or 2022 5-year ACS samples either (and Salem County seems to never be identified in IPUMS data from 1950 onward).
IPUMS NHGIS provides summary data from the ACS, U.S. decennial census, and other sources, aggregated at a variety of geographic levels, including county. These data, which are called summary data, allow users to determine information like population size or the number of households meeting certain criteria, at granular geographic levels. In microdata, which IPUMS USA provides, each row or observation is a person or household. In the summary data that IPUMS NHGIS provides, each row or observation is a specific geographic area, such as Cumberland County, NJ, or a particular school district, and each column (variable) provides information about that specific area. You can use the NHGIS data finder (see this short video tutorial as an introduction) to find tables that meet your criteria, such as geographic level (county), year (2022), and topic (labor force participation and employment status or nativity and place of birth). Unfortunately there are no tables in IPUMS NHGIS that give the population of each county by labor force status and foreign/native born status. However, there are tables of foreign/native born populations by county, and tables that break down counties’ populations by labor force status. So, you may still find IPUMS NHGIS to be a useful resource.