Best Design Approach

[Doll Hargrove]

I set up a mysql database to capture census data for a genealogy project. The 1866 census itself lists the first and last name. It also includes an age breakdown as follows: Under 10, 10 to 20, 20 to 30, 30 to 40, etc. Beneath each heading is the number of each age within the household. It is the same for the females as well.

The database currently is not set up by the age group but instead has a heading as "MALES"--in correlation to the above age breaks as follows: 0010001000--meaning that there is 1 male 20 to 30 years of age and 1 male 60 t0 70 years of age.

My question is it best to capture this information as stated above or include the actual breakdown? I wanted to add info on the age breakdwon as an intro do the data. I'm very concerned about the output and the amount of space will be taken up.

Doll