For our final project, I have chosen the 1800 Census for the City of Albany. I selected this dataset because it provides a relatively detailed breakdown of the population as opposed to other available censuses. The dataset provides a count of each person residing within city limits, and offers both qualitative (text) and quantitative (numeric) data regarding the other members of their households.
Each row of data in the census begins with the person’s full name before providing counts of who else resides in their home. These quantitative counts are divided into twelve categories, in order:
- Free White Males < 10 Years (Min: 0 | Max: 5)
- Free White Males 10-16 Years (Min: 0 | Max: 5)
- Free White Males 16-26 Years(Min: 0 | Max: 10)
- Free White Males 26-45 Years (Min: 0 | Max: 14)
- Free White Males 45+ Years (Min: 0 | Max: 10)
- Free White Females < 10 Years (Min: 0 | Max: 14)
- Free White Females 10-16 Years (Min: 0 | Max: 4)
- Free White Females 16-26 Years (Min: 0 | Max: 4)
- Free White Females 26-45 Years (Min: 0 | Max: 10)
- Free White Females 45+ Years (Min: 0 | Max: 10)
- Other Free Persons [Except Untaxed Indians] (Min: 0 | Max: 9)
- Slaves (Min: 0 | Max: 11)
In addition to these counts, there are two qualitative columns of data: Head of Household Race and Head of Household Gender. For Head of Household Race, only two possibilities occur: White and Black. Similarly, there are only two possibilities for Head of Household Gender: either f (female) or m (male).
I plan to analyze three primary relationships between two or several data columns. First, I am going to examine the relationship (and any related trends) between the Total Number of Free White Males and the Total Number of Slaves in a household. I am seeking to answer whether or not the volume of the former affects the latter in any way. I will make the comparison using averages for Free White Men and Slaves in each household.
Second, I am going to investigate the relationship between Households with a Female Head of Household and the Distribution of Other Members of the Household. I am looking to see whether there are identifiable trends in occupant distribution for homes run by a dominant female. I will find the average counts of all members in households that fall in this category.
Third, along the same vein as the last, I will study the relationship between Households with a Black Head of Household and the Distribution of Other Members of the Household. Again, I will find the total number of counts for each category of occupant only for homes where the head of household is African American (Black). The purpose of this examination is to spot trends relating to the race of the head of household.