I’m a new user and trying to locate data down to the county level for the state of Hawaii - my searches all come up with only a “zero” code for counties in Hawaii. When I do searches counties for other states are listed by code, but nothing for Hawaii. Does that data not exist or am I missing something?
IPUMS USA provides census and survey microdata where each record is a single respondent person or household. If you are looking for county-level statistics, then the geographically aggregated summary data on IPUMS NHGIS may be a better fit.
The county of residence for respondent households is not directly identified in the microdata from 1950-onwards due to concerns regarding respondent confidentiality. IPUMS identifies the county of residence in the variable COUNTYFIP using publicly available geography identifiers (see PUMA). However, as the description tab for COUNTYFIP notes, only certain counties can be identified in the data from 1950-onwards and the tab includes an Identified Counties sheet that documents which counties are identified in what samples. Hawaii and Honolulu counties are the only counties in the state that can be identified in this period; at least one of them is available in all samples from 1950-onwards except the 1950 1% sample, the 1960 1% metro samples, and the 2000 1% sample. Both counties are identified in ACS data from 2005-onwards.
I took a look at your recent extracts and noticed that you requested the data in .csv format. Due to the size and complexity of the microdata, we recommend that users analyze the data using a statistics package (IPUMS provides support for Stata, R, SAS, and SPSS). A significant limitation of Excel is its row limit of 1,048,576; Excel will not display any rows beyond this even if there are additional records in the data. For comparison, each of the 1-year ACS files contain approximately 3 million person records.
If you want to continue with Excel, you can use the Select Cases feature (see screenshot below) to request an extract that only includes cases from Hawaii (which will fit within the row limit). This option is available after submitting your data cart, but before submitting your extract. If you have access to a stats package such as Stata, R, SPSS, or SAS, we highly recommend using one of these to analyze your data since they do not have a set row limit and provide additional tools for analysis. Otherwise, we also provide an online analysis tool that can run simple analyses in place of a stats package. We highly recommend that new users practice analyzing the data using the online tool or a stats package with our detailed data training exercises.
Mahalo for the response and the assistance.
I will use the select cases while I explore the other packages with our IT department.
Again, thanks.
Chris