U.S. 1790-1840 Household-level Complete Count Data Download and Variable Availability

Below are the 1790-1840 household-level data files in SAS, SPSS, Stata, and CSV format followed by the variable availability for each year. Known issues with the data are documented on this page.

To access the files, users must log in with their IPUMS-USA email address and password. Click here to register for an account.

Complete Count Household-level Datasets Available
Data file format
SAS SPSS Stata CSV
1790 Household .sas7bdat file
.sav file
.dta file
.csv file
1800 Household .sas7bdat file
.sav file
.dta file
.csv file
1810 Household .sas7bdat file
.sav file
.dta file
.csv file
1820 Household .sas7bdat file
.sav file
.dta file
.csv file
1830 Household .sas7bdat file
.sav file
.dta file
.csv file
1840 Household .sas7bdat file
.sav file
.dta file
.csv file
1790-1840 Household .sas7bdat file
.sav file
.dta file
.csv file

Below is a summary of variable availability by sample year.

Household Variables by Sample Year Availability
Household-Level Variables
Description 1790 1800 1810 1820 1830 1840
RECTYPE_HRecord TypeXXXXXX
YEARYearXXXXXX
SERIALHousehold Serial NumberXXXXXX
STATEICPState ICPSR Code      
COUNTYCounty CodeXXXXXX
CITYCityXXXXXX
CITYPOPCity PopulationXXXXXX
White Males
NWMLT5Number of White Males Under 5 Years of Age    XX
NWM5Number of White Males Age 5 to 9    XX
NWMLT10Number of Free white Males Under Age 10 XXX  
NWM10Number of Free White Males Age 10 through 15 XXX  
NWM1014Number of White Males Age 10 to 14    XX
NWMLT15Number of Free White Males Age 15 and underX     
NWMGT16Number of Free white males Age 16 and overX     
NWM15Number of White Males Age 15 to 19    XX
NWM16Number of Free White Males Age 16 through 25 XXX  
NWM1618Number of Free White Males Age 16 through 18   X  
NWM20Number of White Males Age 20 to 29    XX
NWM26Number of Free White Males Age 26 through 44 XXX  
NWM30Number of White Males Age 30 to 39    XX
NWM40Number of White Males Age 40 to 49    XX
NWM45Number of Free White Males Age 45 and over XXX  
NWM50Number of White Males Age 50 to 59    XX
NWM60Number of White Males Age 60 to 69    XX
NWM70Number of White Males Age 70 to 79    XX
NWM80Number of White Males Age 80 to 89    XX
NWM90Number of White Males Age 90 to 99    XX
NWM100Number of White Males Over 100 Years of Age     XX
White Females
NWFLT5Number of White Females Under 5 Years of Age    XX
NWF5Number of White Females Age 5 to 9    XX
NWFLT10Number of Free White Females Under Age 10 XXX  
NWF1014Number of White Females Age 10 to 14     XX
NWF10Number of Free White Females Age 10 through 15 XXX  
NWF15Number of White Females Age 15 to 19    XX
NWF16Number of Free White Females Age 16 through 25 XXX  
NWF20Number of White Females Age 20 to 29    XX
NWF26Number of Free White Females Age 26 through 44 XXX  
NWF30Number of White Females Age 30 to 39    XX
NWF40Number of White Females Age 40 to 49    XX
NWF45Number of Free White Females Age 45 and over XXX  
NWF50Number of White Females Age 50 to 59    XX
NWF60Number of White Females Age 60 to 69    XX
NWF70Number of White Females Age 70 to 79    XX
NWF80Number of White Females Age 80 to 89    XX
NWF90Number of White Females Age 90 to 99    XX
NWF100Number of White Females Over 100 Years of Age     XX
NWFNumber of Free white femalesX     
Black Males
NBMLT10Number of Black Males Under 10 Years of Age    XX
NBMLT14Number of Colored Males Under Age 14   X  
NBM10Number of Black Males Age 10 to 23     XX
NBM14Number of Colored Males Age 14 through 25   X  
NBM24Number of Black Males Age 24 to 35     XX
NBM36Number of Black Males Age 36 to 54     XX
NBM26Number of Colored Males Age 26 through 44   X  
NBM45Number of Colored Males After 45 and over   X  
NBM55Number of Black Males Age 55 to 99     XX
NBM100Number of Black Males Over 100 Years of Age     XX
Black Females
NBFLT10Number of Black Females Under 10 Years of Age    XX
NBFLT14Number of Colored Females Under Age 14   X  
NBF10Number of Black Females Age 10 to 23     XX
NBF14Number of Colored Females Age 14 through 25   X  
NBF24Number of Black Females Age 24 to 35     XX
NBF36Number of Black Females Age 36 to 54     XX
NBF26Number of Colored Females Age 26 through 44   X  
NBF45Number of Colored Females After 45 and over   X  
NBF55Number of Black Females Age 55 to 99     XX
NBF100Number of Black Females Over 100 Years of Age     XX
Male Slaves
NSMLT10Number of Male Slaves Under 10 Years of Age    XX
NSMLT14Number of Male Slaves Under Age 14   X  
NSM10Number of Male Slaves Age 10 to 23     XX
NSM14Number of Male Slaves Age 14 through 25   X  
NSM24Number of Male Slaves Age 24 to 35     XX
NSM26Number of Male Slaves Age 26 through 44   X  
NSM36Number of Male Slaves Age 36 to 54     XX
NSM45Number of Male Slaves After 45 and over   X  
NSM55Number of Male Slaves Age 55 to 99     XX
NSM100Number of Male Slaves Over 100 Years of Age     XX
Female Slaves
NSFLT10Number of Female Slaves Under 10 years of Age     XX
NSFLT14Number of Female Slaves Under Age 14   X  
NSF10Number of Female Slaves Age 10 to 23     XX
NSF14Number of Female Slaves Age 14 through 25   X  
NSF24Number of Female Slaves Age 24 to 35     XX
NSF26Number of Female Slaves Age 26 through 44   X  
NSF36Number of Female Slaves Age 36 to 54     XX
NSF45Number of Female Slaves After 45 and over   X  
NSF55Number of Female Slaves Age 55 to 99     XX
NSF100Number of Female Slaves Over 100 Years of Age     XX
Other Free Persons
NOTHFREENumber of other free persons except Indians not taxedXXXX  
Disabilities
NWBLINDNumber of White Blind    XX
NWDEAFLT14Number of White Deaf and Dumb Under 14 Years of Age    XX
NWDEAF14Number of White Deaf and Dumb Age 14 to 24    XX
NWDEAF25Number of White Deaf and Dumb Over 25 Years of Age     XX
NWINSANPRINumber of White Insane and idiots at private charge     X
NWINSANPUBNumber of White Insane and idiots at public charge     X
NBINSANPRINumber of Black Insane and idiots at private charge     X
NBINSANPUBNumber of Black Insane and idiots at public charge     X
NSBBLINDNumber of Slave and Black Blind    XX
NSBDEAFNumber of Black Deaf and Dumb     X
NSBDEAFLT14Number of Slave and Black Deaf and Dumb Under 14 Years of Age     X 
NSBDEAF14Number of Slave and Black Deaf and Dumb Age 14 to 24    X 
NSBDEAF25Number of Slave and Black Deaf and Dumb Over 25 Years of Age     X 
Foreigners
NFOREIGNNumber of Foreigners not naturlized   X  
NWFOREIGNNumber of White Aliens    X 
Industry
NINDAGRNumber Engaged in Agriculture   X X
NINDCOMNumber Engaged in Commerce   X X
NINDENGNumber of persons employed in Learned professioned or engineers     X
NINDMFGNumber Engaged in Manufactures   X X
NINDMINNumber of persons employed in mining     X
NINDOCNNumber of persons employed in navigation of the ocean     X
NINDRIVNumber of persons employed in navigation of canals, lakes, and rivers     X
Education
NUNIVUniversity or College     X
NUNIVSTUNumber of University or College students     X
NACADAcademies and Grammar Schools     X
NACADSTUNumber of Scholars     X
NPRIMSCHPrimary and Common Schools     X
NPRIMSTUNumber of Scholars     X
NPUBLSTUNumber of Scholars at public charge     X
NLITNumber of family over age 21 who can not read or write     X
Veterans
VETERANNumber of Pensioners in Household     X
VETAGEAge of First Pensioner in Household     X
VETAGE2Age of Second Pensioner in Household     X
VETAGE3Age of Third Pensioner in Household     X
VETAGE4Age of Fourth Pensioner in Household     X
VETAGE5Age of Fifth Pensioner in Household     X
Flags
QCOUNTYMissing CountyXXXXXX
QINDUSTRYIndustry Flag   X X
QOTHEROther Persons FlagXXXXXX
QSLAVESlaves FlagXXXXXX
Totals
NCHILDTotal Number of Children under Age 10 in Household    XX
NMALETotal Number of Males in Household   XXX
NFEMALETotal Number of Females in Household   XXX
NUMPERHHTotal Number of Free Persons in HouseholdXXXXXX
NSLAVETotal Number of Slave Persons in HouseholdXXXXXX
NTOTALTotal Number of people in HouseholdXXXXXX