I am NOT Navajo. My work in the records of the Navajo arises from my desire to trace my Cornish Keam cousins. Thomas Varker Keam (1842-1904) was born in Cornwall and eventually came to New Mexico and Arizona and married a Navajo woman. So this work arises from my efforts to trace his descendants.
The vast majority of the work that I have done so far is within the scope of the Leupp Agency of the Bureau of Indian Affairs in Arizona. There are also Keams (TVK went by both Keam and Keams, and it is the Keams form that has passed down among his descendants.) in Grey Mountain in the Western Navajo district. I have made a few brief efforts on them, but all of the systematic work that I have done is on the Leupp Navajo records.
Indian Census Rolls - Leupp Agency Navajo
It became clear that I really needed to have the Indian Census Roll records in a form that was easy to use. So I downloaded them into PDF files. The years for which images are available are: 1915-1917, 1920-1925, 1927, 1929 (in one PDF file) and 1930, 1932, 1933-1935 (in the other PDF file). (I really have not checked all the years ... these dates are taken from the National Archives pamphlet M-595.)
It then became clear to me that I needed a way to link the same people in all the censuses. The spelling of their names and clans varied, and the names sometimes changed as a person progressed in life. So some method of connecting them -- beyond what a lineage-linked database supported -- was needed. So I began transcribing the complete censuses into separate spreadsheets for each year, starting with the 1915 census.
I completed the 1915 census spreadsheet and then began the 1916 census spreadsheet. But in doing the 1916 spreadsheet, I am also copying and pasting the 1916 information on the lines of the 1915 census, so that the 1915 census has both the 1915 and 1916 information for each person who was in the 1915 census.
The 1915 census had 850 people on 34 pages. The 1916 census had 1,442 people on 71 pages. So just under 600 people appear for the first time in the 1916 census. While there were some new births (and one death) since the 1915 census, these additional people were mostly entire households that were not included in the 1915 census.
Havng the complete 1915 census transcription in the spreadsheet allowed me to do some simple demographic analysis.
I have not yet completed the clan name standardization for either census. I initially created a standard name, based on one of the 1916 spellings. But I want to use the standard spellings and translataions from the 1983 book "Saad Ahaah Sinil: Dual Language: A Navajo-English Dictionary: Revised Edition", edited by Martha Austin and Regina Lynch with revisions by Regina Lynch (see http://maiidinebizaad.weebly.com/uploads/6/8/5/7/6857372/saad_ahaah_sinil.pdf ). However the first priority is the transcription, so that the clan standardization and analysis will come later.
Some observations for tracing family history
Why do all this extra work instead of focusing only on the descendants of Thomas Varker Keam? This is a valid question - and one that I have asked myself more than once as I have done the tedious work of the transcriptions of the complete censuses. I first began doing this kind of project with two related Cornish communities, one in Columbus, Ontario in Canada, and the other in St. Blazey in Cornwall. It became clear to me as I did more family research on these communities that people who I had originally ignored when using a narrow focus turned out to be people who were in fact part of or important to the family history. In such tightly-knit communities, the relationships between people were well known among them. Even though we do not see them without a lot of work now, they were part of the very fabric of life for our family members who lived there. Once I had realized this, it was a method -- extremely laborious and often relegated to efforts in fits and spurts as my resources allowed -- that I applied to more communities of my family's history. And it led to me writing my book on the subject "Family Thickets: Deep Family and Local History".