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

Below are the 1790-1840 county-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 County-level Datasets Available
Data file format
SAS SPSS Stata CSV
1790 County .sas7bdat file .sav file .dta file .csv file
1800 County .sas7bdat file .sav file .dta file .csv file
1810 County .sas7bdat file .sav file .dta file .csv file
1820 County .sas7bdat file .sav file .dta file .csv file
1830 County .sas7bdat file .sav file .dta file .csv file
1840 County .sas7bdat file .sav file .dta file .csv file
1790-1840 County .sas7bdat file .sav file .dta file .csv file

Back to Top

Below is a summary of variable availability for each sample year.

County Variables by Sample Year Availability
County-Level Variables
Description 1790 1800 1810 1820 1830 1840
RECTYPE_CRecord TypeXXXXXX
YEARYearXXXXXX
REGIONCensus RegionXXXXXX
STATEFIPState FIPS CodeXXXXXX
STATEICPState ICPSR CodeXXXXXX
COUNTYCounty CodeXXXXXX
CNTYPOPFCounty Free PopulationXXXXXX
CNTYPOPSCounty Slave PopulationXXXXXX
QCOUNTYMissing CountyXXXXXX
White Males
NWMLT5_CNumber of White Males Under 5 Years of Age    XX
NWM5_CNumber of White Males Age 5 to 9    XX
NWMLT10_CNumber of Free white Males Under Age 10 XXX  
NWM10_CNumber of Free White Males Age 10 through 15 XXX  
NWM1014_CNumber of White Males Age 10 to 14    XX
NWMLT15_CNumber of Free White Males Age 15 and underX     
NWMGT16_CNumber of Free white males Age 16 and overX     
NWM15_CNumber of White Males Age 15 to 19    XX
NWM16_CNumber of Free White Males Age 16 through 25 XXX  
NWM1618_CNumber of Free White Males Age 16 through 18   X  
NWM20_CNumber of White Males Age 20 to 29    XX
NWM26_CNumber of Free White Males Age 26 through 44 XXX  
NWM30_CNumber of White Males Age 30 to 39    XX
NWM40_CNumber of White Males Age 40 to 49    XX
NWM45_CNumber of Free White Males Age 45 and over XXX  
NWM50_CNumber of White Males Age 50 to 59    XX
NWM60_CNumber of White Males Age 60 to 69    XX
NWM70_CNumber of White Males Age 70 to 79    XX
NWM80_CNumber of White Males Age 80 to 89    XX
NWM90_CNumber of White Males Age 90 to 99    XX
NWM100_CNumber of White Males Over 100 Years of Age    XX
White Females
NWFLT5_CNumber of White Females Under 5 Years of Age    XX
NWF5_CNumber of White Females Age 5 to 9    XX
NWFLT10_CNumber of Free White Females Under Age 10 XXX  
NWF1014_CNumber of White Females Age 10 to 14    XX
NWF10_CNumber of Free White Females Age 10 through 15 XXX  
NWF15_CNumber of White Females Age 15 to 19    XX
NWF16_CNumber of Free White Females Age 16 through 25 XXX  
NWF20_CNumber of White Females Age 20 to 29    XX
NWF26_CNumber of Free White Females Age 26 through 44 XXX  
NWF30_CNumber of White Females Age 30 to 39    XX
NWF40_CNumber of White Females Age 40 to 49    XX
NWF45_CNumber of Free White Females Age 45 and over XXX  
NWF50_CNumber of White Females Age 50 to 59    XX
NWF60_CNumber of White Females Age 60 to 69    XX
NWF70_CNumber of White Females Age 70 to 79    XX
NWF80_CNumber of White Females Age 80 to 89    XX
NWF90_CNumber of White Females Age 90 to 99    XX
NWF100_CNumber of White Females Over 100 Years of Age    XX
NWF_CNumber of Free white femalesX     
Black Males
NBMLT10_CNumber of Black Males Under 10 Years of Age    XX
NBMLT14_CNumber of Colored Males Under Age 14   X  
NBM10_CNumber of Black Males Age 10 to 23    XX
NBM14_CNumber of Colored Males Age 14 through 25   X  
NBM24_CNumber of Black Males Age 24 to 35    XX
NBM36_CNumber of Black Males Age 36 to 54    XX
NBM26_CNumber of Colored Males Age 26 through 44   X  
NBM45_CNumber of Colored Males After 45 and over   X  
NBM55_CNumber of Black Males Age 55 to 99    XX
NBM100_CNumber of Black Males Over 100 Years of Age    XX
Black Females
NBFLT10_CNumber of Black Females Under 10 Years of Age    XX
NBFLT14_CNumber of Colored Females Under Age 14   X  
NBF10_CNumber of Black Females Age 10 to 23    XX
NBF14_CNumber of Colored Females Age 14 through 25   X  
NBF24_CNumber of Black Females Age 24 to 35    XX
NBF36_CNumber of Black Females Age 36 to 54    XX
NBF26_CNumber of Colored Females Age 26 through 44   X  
NBF45_CNumber of Colored Females Age 45 and over   X  
NBF55_CNumber of Black Females Age 55 to 99    XX
NBF100_CNumber of Black Females Over 100 Years of Age    XX
Male Slaves
NSMLT10_CNumber of Male Slaves Under 10 Years of Age    XX
NSMLT14_CNumber of Male Slaves Under Age 14   X  
NSM10_CNumber of Male Slaves Age 10 to 23    XX
NSM14_CNumber of Male Slaves Age 14 through 25   X  
NSM24_CNumber of Male Slaves Age 24 to 35    XX
NSM26_CNumber of Male Slaves Age 26 through 44   X  
NSM36_CNumber of Male Slaves Age 36 to 54    XX
NSM45_CNumber of Male Slaves After 45 and over   X  
NSM55_CNumber of Male Slaves Age 55 to 99    XX
NSM100_CNumber of Male Slaves Over 100 Years of Age    XX
Female Slaves
NSFLT10_CNumber of Female Slaves Under 10 years of Age    XX
NSFLT14_CNumber of Female Slaves Under Age 14   X  
NSF10_CNumber of Female Slaves Age 10 to 23    XX
NSF14_CNumber of Female Slaves Age 14 through 25   X  
NSF24_CNumber of Female Slaves Age 24 to 35    XX
NSF26_CNumber of Female Slaves Age 26 through 44   X  
NSF36_CNumber of Female Slaves Age 36 to 54    XX
NSF45_CNumber of Female Slaves After 45 and over   X  
NSF55_CNumber of Female Slaves Age 55 to 99    XX
NSF100_CNumber of Female Slaves Over 100 Years of Age    XX
Other Free Persons
NOTHFREE_CNumber of other free persons except Indians not taxedXXXX  
Disabilities
NWBLIND_CNumber of White Blind    XX
NWDEALT14_CNumber of White Deaf and Dumb Under 14 Years of Age    XX
NWDEAF14_CNumber of White Deaf and Dumb Age 14 to 24    XX
NWDEAF25_CNumber of White Deaf and Dumb Over 25 Years of Age    XX
NWINSAPR_CNumber of White Insane and idiots at private charge     X
NWINSAPU_CNumber of White Insane and idiots at public charge     X
NBINSAPR_CNumber of Black Insane and idiots at private charge     X
NBINSAPU_CNumber of Black Insane and idiots at public charge     X
NSBBLIND_CNumber of Slave and Black Blind    X 
NSBDEAF_CNumber of Black Deaf and Dumb     X
NSBDEAL14_CNumber of Slave and Black Deaf and Dumb Under 14 Years of Age    X 
NSBDEAF14_CNumber of Slave and Black Deaf and Dumb Age 14 to 24    X 
NSBDEAF25_CNumber of Slave and Black Deaf and Dumb Over 25 Years of Age    X 
Foreigners
NFOREIGN_CNumber of Foreigners not naturalized   X  
NWFOREIGN_CNumber of White Aliens    X 
Industry
NINDAGR_CNumber Engaged in Agriculture   X X
NINDCOM_CNumber Engaged in Commerce   X X
NINDENG_CNumber of persons employed in Learned professioned or engineers     X
NINDMFG_CNumber Engaged in Manufactures   X X
NINDMIN_CNumber of persons employed in mining     X
NINDOCN_CNumber of persons employed in navigation of the ocean     X
NINDRIV_CNumber of persons employed in navigation of canals, lakes, and rivers     X
Education
NUNIV_CUniversity or College     X
NUNIVSTU_CNumber of University or College students     X
NACAD_CAcademies and Grammar Schools     X
NACADSTU_CNumber of Scholars     X
NPRIMSCH_CPrimary and Common Schools     X
NPRIMSTU_CNumber of Scholars     X
NPUBLSTU_CNumber of Scholars at public charge     X
NLIT_CNumber of family over age 21 who can not read or write     X
Veterans
VETERAN_CNumber of Pensioners in County     X
Totals
NCHILD_CTotal Number of Children under Age 10 in County    XX
NMALE_CTotal Number of Males in County   XXX
NFEMALE_CTotal Number of Females in County   XXX
NUMPERHH_CTotal Number of Free Persons in CountyXXXXXX
NSLAVE_CTotal Number of Slave Persons in CountyXXXXXX
NTOTAL_CTotal Number of people in CountyXXXXXX

Back to Top