# USA **URL:** https://forum.ipums.org/c/usa/24.md?page=4 [Latest](https://forum.ipums.org/latest.md) · [Categories](https://forum.ipums.org/categories.md) **Page:** 5 --- ## [1970 form 1 or form 2 for employment](https://forum.ipums.org/t/1970-form-1-or-form-2-for-employment/6522)
**Author:** [@Sarah\_Eckhardt](https://forum.ipums.org/u/Sarah_Eckhardt)\ **Replies:** 1\ **Last updated:** [May 9, 2025, 8:16pm UTC](https://forum.ipums.org/t/1970-form-1-or-form-2-for-employment/6522 "2025-05-09T20:16:05Z")
Hello, I want to estimate employment by industry by state using the 1970 census. Should I use data from the form 1 1% state sample or form 2 1% state sample? Estimates differ substantially depending on which form. Am I … --- ## [2000 tract to 2000 MSA](https://forum.ipums.org/t/2000-tract-to-2000-msa/6520)
**Author:** [@Abigail\_Sanchez](https://forum.ipums.org/u/Abigail_Sanchez)\ **Replies:** 1\ **Last updated:** [May 8, 2025, 8:39pm UTC](https://forum.ipums.org/t/2000-tract-to-2000-msa/6520 "2025-05-08T20:39:20Z")
Hi, I’ve been trying to link 2000 tract-level data to 2000 MSA, the best file is a text file relationship file from 2003 (which from what I gather uses 2000 tract definitions), attached below. But wanted to see if there… --- ## [Please check values of PWCOUNTY in NYS in the 2023 5-year data](https://forum.ipums.org/t/please-check-values-of-pwcounty-in-nys-in-the-2023-5-year-data/6503)
**Author:** [@You\_Zheng](https://forum.ipums.org/u/You_Zheng)\ **Replies:** 6\ **Last updated:** [May 8, 2025, 8:27pm UTC](https://forum.ipums.org/t/please-check-values-of-pwcounty-in-nys-in-the-2023-5-year-data/6503 "2025-05-08T20:27:58Z")
I recently downloaded the 2023 5-year ACS data from IPUMS and noticed that the variable PWCOUNTY (county of work) seems to have all zero values for cases in New York State. I double-checked my extract and my R code, and … --- ## [Control totals for IPUMS 1850 complete U.S. Census microdata](https://forum.ipums.org/t/control-totals-for-ipums-1850-complete-u-s-census-microdata/6509)
**Author:** [@Jim\_Roeber](https://forum.ipums.org/u/Jim_Roeber)\ **Replies:** 4\ **Last updated:** [May 2, 2025, 8:18pm UTC](https://forum.ipums.org/t/control-totals-for-ipums-1850-complete-u-s-census-microdata/6509 "2025-05-02T20:18:09Z")
Hi! I’m new to IPUMS. I recently downloaded what I thought was the complete 1850 U.S. census microdata from IPUMS. Based on another source (Wikipedia) I expected this file to contain ~20M records (i.e., 23,191,876 tot… --- ## [Discrepancy in 2022 PERWTs](https://forum.ipums.org/t/discrepancy-in-2022-perwts/6480)
**Author:** [@NELOY\_KUNDU](https://forum.ipums.org/u/NELOY_KUNDU)\ **Replies:** 2\ **Last updated:** [April 28, 2025, 1:33am UTC](https://forum.ipums.org/t/discrepancy-in-2022-perwts/6480 "2025-04-28T01:33:34Z")
Hi IPUMS support–thank you so much for all that you do! I’m so thankful that we can consult experts on using your valuable datasets. I am using 2022 ACS data for a project in which I am trying to get joint distributions… --- ## [Difference between bpld code 46500: Other USSR/Russia and bpld code 46590: USSR, ns](https://forum.ipums.org/t/difference-between-bpld-code-46500-other-ussr-russia-and-bpld-code-46590-ussr-ns/6490)
**Author:** [@Abdullah\_Shamim](https://forum.ipums.org/u/Abdullah_Shamim)\ **Replies:** 2\ **Last updated:** [April 23, 2025, 3:47pm UTC](https://forum.ipums.org/t/difference-between-bpld-code-46500-other-ussr-russia-and-bpld-code-46590-ussr-ns/6490 "2025-04-23T15:47:20Z")
Hello, I have a question about the ipums USA bpld codes 46500 and 46590. Why are there two residual categories for USSR? Does 46500 just contain Russia after a particular sample while code 46590 remains the sole residua… --- ## [NCHILD vs published tables](https://forum.ipums.org/t/nchild-vs-published-tables/6475)
**Author:** [@Robert\_Gebeloff](https://forum.ipums.org/u/Robert_Gebeloff)\ **Replies:** 1\ **Last updated:** [April 15, 2025, 1:56pm UTC](https://forum.ipums.org/t/nchild-vs-published-tables/6475 "2025-04-15T13:56:50Z")
Hi. Can anybody explain why the 2023 ACS published table estimates 37.8 million households with 1 or more people under 18, but if i filter for relate=1, IPUMS NCHILD variable seems to there are 49 million households wh… --- ## [Huge Discrepancy with Historical Data](https://forum.ipums.org/t/huge-discrepancy-with-historical-data/5905)
**Author:** [@Anthony\_Capote](https://forum.ipums.org/u/Anthony_Capote)\ **Replies:** 1\ **Last updated:** [May 30, 2024, 11:11pm UTC](https://forum.ipums.org/t/huge-discrepancy-with-historical-data/5905 "2024-05-30T23:11:52Z")
I am working with historical ACS data from 1950 onward to look at population trends in New York City. When working with the 1960 data and the CITY variable, I got a pretty accurate total count of people living in New Yor… --- ## [IPUMS USA and IPUMS CPS Mismatch](https://forum.ipums.org/t/ipums-usa-and-ipums-cps-mismatch/6447)
**Author:** [@S\_D](https://forum.ipums.org/u/S_D)\ **Replies:** 1\ **Last updated:** [April 4, 2025, 3:42pm UTC](https://forum.ipums.org/t/ipums-usa-and-ipums-cps-mismatch/6447 "2025-04-04T15:42:15Z")
Hi, I computed shares of Black residents in poverty by state in 2015 in IPUMS USA: 1850-2023 and IPUMS CPS: ASEC 1962-present and am getting vastly different figures. I ran a query to compute the general US population a… --- ## [Handling 1970 data](https://forum.ipums.org/t/handling-1970-data/6442)
**Author:** [@S\_D](https://forum.ipums.org/u/S_D)\ **Replies:** 1\ **Last updated:** [April 1, 2025, 9:08pm UTC](https://forum.ipums.org/t/handling-1970-data/6442 "2025-04-01T21:08:55Z")
Hi, I’m trying to get my analysis from a downloaded extract to match with the results from the online tool for IPUMS USA 1850-2023. I get exact matches except for 1970. While downloading the extract, I’m going with the… --- ## [Extraction problem](https://forum.ipums.org/t/extraction-problem/6367)
**Author:** [@Daniel\_Korobko](https://forum.ipums.org/u/Daniel_Korobko)\ **Replies:** 4\ **Last updated:** [March 31, 2025, 9:25pm UTC](https://forum.ipums.org/t/extraction-problem/6367 "2025-03-31T21:25:58Z")
Hello everyone, i try to extract some data and it does something weird: it writes that the predicted file size is 700 MB which makes sense, but then when i extract i get less than a 100MB empty file. i made sure im on… --- ## [Download only specific occupation counts?](https://forum.ipums.org/t/download-only-specific-occupation-counts/6427)
**Author:** [@Jackie\_Calhoun](https://forum.ipums.org/u/Jackie_Calhoun)\ **Replies:** 1\ **Last updated:** [March 26, 2025, 5:01pm UTC](https://forum.ipums.org/t/download-only-specific-occupation-counts/6427 "2025-03-26T17:01:10Z")
Hello - is there a way to download the data only for a specific occupation code? I’m interested in the data for only nurse practitioners (occupational code: 29-1171). Thank you! --- ## [Expand TAXID to all ACS years](https://forum.ipums.org/t/expand-taxid-to-all-acs-years/6417)
**Author:** [@John\_Klopfer](https://forum.ipums.org/u/John_Klopfer)\ **Replies:** 2\ **Last updated:** [March 26, 2025, 12:38am UTC](https://forum.ipums.org/t/expand-taxid-to-all-acs-years/6417 "2025-03-26T00:38:47Z")
Hello, May I have your help expanding TAXID and other TAXSIM inputs from the years where it is currently available (2009-19) to all ACS years? The documentation (https://usa.ipums.org/usa-action/variables/TAXID#descript… --- ## [Leave Module Weights](https://forum.ipums.org/t/leave-module-weights/6170)
**Author:** [@Arash\_P](https://forum.ipums.org/u/Arash_P)\ **Replies:** 2\ **Last updated:** [March 17, 2025, 5:00pm UTC](https://forum.ipums.org/t/leave-module-weights/6170 "2025-03-17T17:00:18Z")
Hi everyone, I’m currently analyzing the correlation between Paid Leave and various demographic variables and have been using the Leave Module Weights for this analysis. I have a couple of questions regarding the corre… --- ## [I need to calculate a consistent metro definition between the 1990 Census & 2016 ACS. Any ideas for a crosswalk?](https://forum.ipums.org/t/i-need-to-calculate-a-consistent-metro-definition-between-the-1990-census-2016-acs-any-ideas-for-a-crosswalk/2502)
**Author:** [@elizabeth\_la\_jeuness](https://forum.ipums.org/u/elizabeth_la_jeuness)\ **Replies:** 9\ **Last updated:** [March 13, 2025, 2:33pm UTC](https://forum.ipums.org/t/i-need-to-calculate-a-consistent-metro-definition-between-the-1990-census-2016-acs-any-ideas-for-a-crosswalk/2502 "2025-03-13T14:33:07Z")
We frequently use the missouri data center MABLE/Geocorr to get PUMA to Metro crosswalks, but I see that their 1990 crosswalk tool does not correspond to anything in a later geography. This leaves me wondering how I can … --- ## [Filter for PUMA #](https://forum.ipums.org/t/filter-for-puma/6383)
**Author:** [@Chip\_Halbach](https://forum.ipums.org/u/Chip_Halbach)\ **Replies:** 4\ **Last updated:** [March 12, 2025, 10:41pm UTC](https://forum.ipums.org/t/filter-for-puma/6383 "2025-03-12T22:41:58Z")
For Extract Data it doesn’t look like I can use a PUMA # as a filter when I try to Extract Cases. I have to extract data for an entire metro area or state when I just need data for an individual PUMA. Is that right, and … --- ## [IPUMS API Connection Error Message: 'Connection aborted.'](https://forum.ipums.org/t/ipums-api-connection-error-message-connection-aborted/6391)
**Author:** [@Christopher\_Compton](https://forum.ipums.org/u/Christopher_Compton)\ **Replies:** 1\ **Last updated:** [March 12, 2025, 7:07pm UTC](https://forum.ipums.org/t/ipums-api-connection-error-message-connection-aborted/6391 "2025-03-12T19:07:33Z")
Hello! I have code that I use commonly to download data through the IPUMS API, specifically using the ipumspy python library. When using the code now, I get the following error message consistently after pulling data fo… --- ## [1870 Census RACE and BPL](https://forum.ipums.org/t/1870-census-race-and-bpl/6393)
**Author:** [@Samuel\_Niu](https://forum.ipums.org/u/Samuel_Niu)\ **Replies:** 1\ **Last updated:** [March 7, 2025, 8:08pm UTC](https://forum.ipums.org/t/1870-census-race-and-bpl/6393 "2025-03-07T20:08:03Z")
Hello, I’m working with the full count 1870 census and noticed some disparities between the IPUMS data and the federal census as available on census.gov or ancestry.com. Namely, I was trying to find the number of Chinese… --- ## [Regarding the survey command](https://forum.ipums.org/t/regarding-the-survey-command/6386)
**Author:** [@HIMANI\_Sharma](https://forum.ipums.org/u/HIMANI_Sharma)\ **Replies:** 2\ **Last updated:** [March 10, 2025, 1:39pm UTC](https://forum.ipums.org/t/regarding-the-survey-command/6386 "2025-03-10T13:39:28Z")
Hello, I am facing a question about the survey command: I want to get the estimates for the population using the survey command. I am using the 1970-2023 files Following is my code: svyset \[pw=perwt\] gen a=0 replace… --- ## [Rural/urban data to estimate older adult POP](https://forum.ipums.org/t/rural-urban-data-to-estimate-older-adult-pop/6394)
**Author:** [@Rachel\_Upton](https://forum.ipums.org/u/Rachel_Upton)\ **Replies:** 1\ **Last updated:** [March 7, 2025, 7:57pm UTC](https://forum.ipums.org/t/rural-urban-data-to-estimate-older-adult-pop/6394 "2025-03-07T19:57:41Z")
Hello. I am trying to identify whether it’s possible to select the most recent 5-Year ACS data such that one can obtain both a national- and a county-level estimate (count or percentage estimate) for the older adult popu… --- ## [Insurance how to define each](https://forum.ipums.org/t/insurance-how-to-define-each/6376)
**Author:** [@Xiaolei\_Li](https://forum.ipums.org/u/Xiaolei_Li)\ **Replies:** 1\ **Last updated:** [March 4, 2025, 1:21am UTC](https://forum.ipums.org/t/insurance-how-to-define-each/6376 "2025-03-04T01:21:47Z")
I’m finding that the insurance identified from HINSCAID, HINSCARE variables are very low especially HINSCARE. Is HINSCARE for medicare ffs? If I want to categorize commercial, medicaid, medicare, other (military, VA, tr… --- ## [IND1990 missing from the 2023 five-year sample](https://forum.ipums.org/t/ind1990-missing-from-the-2023-five-year-sample/6381)
**Author:** [@Robert\_Gebeloff](https://forum.ipums.org/u/Robert_Gebeloff)\ **Replies:** 1\ **Last updated:** [March 3, 2025, 10:15pm UTC](https://forum.ipums.org/t/ind1990-missing-from-the-2023-five-year-sample/6381 "2025-03-03T22:15:34Z")
Hi… Is the IND1990 variable going to be added eventually to the 2023 five-year sample? Thanks --- ## [Comparability of enumeration district](https://forum.ipums.org/t/comparability-of-enumeration-district/6380)
**Author:** [@mf18](https://forum.ipums.org/u/mf18)\ **Replies:** 1\ **Last updated:** [March 3, 2025, 8:16pm UTC](https://forum.ipums.org/t/comparability-of-enumeration-district/6380 "2025-03-03T20:16:40Z")
How comparable are enumeration districts across time (1880-1910)? For instance, would the identifier (stateicp + countyicp + enumdist) correspond to the same enumeration district between 1900 and 1910? --- ## [Calculating Weighted Proportions of Co-Ethnics within each PUMA](https://forum.ipums.org/t/calculating-weighted-proportions-of-co-ethnics-within-each-puma/6358)
**Author:** [@Cesar\_Ramirez](https://forum.ipums.org/u/Cesar_Ramirez)\ **Replies:** 2\ **Last updated:** [February 23, 2025, 5:58am UTC](https://forum.ipums.org/t/calculating-weighted-proportions-of-co-ethnics-within-each-puma/6358 "2025-02-23T05:58:03Z")
Hi! I’m using several iterations of the IPUMS USA for an RA project (2007 3 yr; 2010 3 yr; 2013 3 yr; 2018 5 yr; 2022 5 yr), and one of the variables were are trying to construct is the weighted proportion of coethnics w… --- ## [VALUEH description, codes missing details?](https://forum.ipums.org/t/valueh-description-codes-missing-details/6362)
**Author:** [@watso220](https://forum.ipums.org/u/watso220)\ **Replies:** 1\ **Last updated:** [February 21, 2025, 4:46pm UTC](https://forum.ipums.org/t/valueh-description-codes-missing-details/6362 "2025-02-21T16:46:29Z")
Hello, I am using VALUEH for ACS 2009,2010,2011 microdata. The variable’s description, codes, and questionaire text seems to be missing some context. For example, the questionaire page shows the 2006 and then 2011 quest… --- ## [MIGRATE1 in 2022 and 2023 ACS](https://forum.ipums.org/t/migrate1-in-2022-and-2023-acs/6226)
**Author:** [@Adam\_Blandin](https://forum.ipums.org/u/Adam_Blandin)\ **Replies:** 6\ **Last updated:** [February 14, 2025, 2:52pm UTC](https://forum.ipums.org/t/migrate1-in-2022-and-2023-acs/6226 "2025-02-14T14:52:25Z")
Hello, I noticed that MIGRATE1 is currently not available for years 2022 and 2023. However, MIGRATE1 was previously available for 2022, and I believe it should still be possible to construct this for 2023. Is there a rea… --- ## [2020CT to 2010 CT using relationship file](https://forum.ipums.org/t/2020ct-to-2010-ct-using-relationship-file/6347)
**Author:** [@Anna\_Ivanov](https://forum.ipums.org/u/Anna_Ivanov)\ **Replies:** 1\ **Last updated:** [February 12, 2025, 3:04am UTC](https://forum.ipums.org/t/2020ct-to-2010-ct-using-relationship-file/6347 "2025-02-12T03:04:52Z")
Hi, I have created a 2010CT to 2020CT crosswalk using the US Census Relationship file for multiple health disparities variables. I would like to compare the 2020 crosswalk data to the original 2010 CT data in Arcgis. Ca… --- ## [Median household incomes are way off expected values](https://forum.ipums.org/t/median-household-incomes-are-way-off-expected-values/6341)
**Author:** [@Brandon\_Istenes](https://forum.ipums.org/u/Brandon_Istenes)\ **Replies:** 2\ **Last updated:** [February 11, 2025, 3:01am UTC](https://forum.ipums.org/t/median-household-incomes-are-way-off-expected-values/6341 "2025-02-11T03:01:14Z")
I’m trying to calculate some basic income-related statistics to sanity-check my ACS data use. However, the estimates I’m getting for household median incomes are quite far from those reported by the Census Bureau, specif… --- ## [IPUMS 1950 1% census county information](https://forum.ipums.org/t/ipums-1950-1-census-county-information/6336)
**Author:** [@Giulia\_Ferrero](https://forum.ipums.org/u/Giulia_Ferrero)\ **Replies:** 1\ **Last updated:** [February 7, 2025, 9:54pm UTC](https://forum.ipums.org/t/ipums-1950-1-census-county-information/6336 "2025-02-07T21:54:01Z")
Hello, i am trying to build a cross-sectional dataset merging the following waves at county level: 1930, 1940, 1950 and 1960. However, I noticed that once aggregated at county level, the 1950 census only has information… --- ## [Matching PUMAS to local educational agency adress](https://forum.ipums.org/t/matching-pumas-to-local-educational-agency-adress/6329)
**Author:** [@Franz\_Janssen](https://forum.ipums.org/u/Franz_Janssen)\ **Replies:** 2\ **Last updated:** [February 6, 2025, 8:57pm UTC](https://forum.ipums.org/t/matching-pumas-to-local-educational-agency-adress/6329 "2025-02-06T20:57:29Z")
Hi everyone, i want to use PUMAs (smallest geographical unit) for my analysis of educational inequality in the US from 2005-2015. 1)How can i deal with the change in PUMA definition from 2005-2011 versus 2012-2020? 2)… [Previous page](https://forum.ipums.org/c/usa/24.md?page=3) [Next page](https://forum.ipums.org/c/usa/24.md?page=5)