Amanuensis Monday -- creating databases for statistical analysis

When I first began the research for developing a social history of the locale where my husband's ancestors had settled, I worked extensively with Census data. Looking at raw Census schedules, however, is not a practical way to quickly identify patterns within the pages. I wanted to look at specific pieces of information on one page that would eliminate the extraneous. So I created a database which presents only the information I cared to examine.

Below is a cross-section of my database of the 1910 Census for Township 5, Craven County, NC. The first column records the location: next is a listing of only those persons involved in work of some kind: the third and fourth columns record the type of work engaged: then I made columns for occupation. The first occupation column is farming. . . the second was timber. . . etc.

For this study, I wanted to determine if there was a location where farmers and timber workers were more densely concentrated. This is an area where my husband's ancestors lived. William H. Carter was my husband's grandfather's brother, or my husband's grand uncle. The Georges were my husband's g-grandmother's first cousins, or my husband's first cousins twice removed.

By mapping these statistics on a GIS map from the county tax assessor's office, I am able to reconstruct the beginnings of the social data I need for understanding the workings of a community.

Comments

Honoring our Ancestors: Free Black Patriots of the Revolutionary War

When I was first contacted last October to assist in some research for a member of the DAR who was looking for the burial ground of her ancestor, Isaac Carter, I had no idea it would lead to such a wonderful tribute--with full honors--to our free black ancestors of Craven County, North Carolina. Nor would I have guessed that I would be meeting together with Ms. Maria William Cole, National Vice Chairman Insignia, of the National Society Daughters of the American Revolution, and a host of other dignitaries, from the highest officials of the SAR to state and local political and community service leaders, to pay tribute to these patriots. The turnout exceeded my expectation when this event proceeded on a cold and rainy Sunday afternoon, with close to a hundred and fifty people or more, seated on folding chairs under three canopy tents. The microphone cable lay along the wet grass and soon died out, and we, the speakers, were asked to use our "mother's voices" to make o

How Family History Writing Forces Us to Dig DEEPER

February is Family History Writing Month During the month of February, I went on hiatus from the Civil War Pension File of Isaac Carter in order to participate in the Family History Writing Challenge. My goal was quite ambitious, but I did succeed in setting up the framework of the family history memoir, and wrote a rough draft of the opening scenes. The memoir focuses on a promise I had made to our Cousin Hattie Carter Becton in an interview, following the the 2009 George Family Reunion in North Harlowe, North Carolina. In case you missed the Challenge, you can find the posts here . The site was developed especially for writing challenges, beginning with this year's; so, you may want to go back to the first posts in the archive. March was memoir reading, research & development month Last month I continued working on the writing, but also began focusing on webinars and YouTube videos related to writing memoir. Two really great sites are National Association of Memoir Writ

Those Places Thursday -- Robert Livingston House, Little River, SC

In July of 2008 we attended the Prince Livingston Family Reunion in Wampee, Horry County, South Carolina (my husband's maternal family). During our down time we decided to take a drive through Little River where the plantation owner, Robert Livingston, had once lived. We inquired at the Visitor Center, and learned that the Robert Livingston House had been preserved as an historical landmark. The brochure we received listed several different sites that interested us, but the Livingston House was our first destination. We drove along Highway 17S and drove past the turn off for Lakeside Drive. At the next light we turned around and headed back down the highway until we came to the street. About two-thirds of the way down the road we saw a sign along the roadside: 19th Century Victorian Home for Sale. Was that the house? The number on the mail box was 4441. That's it! We got out of the car and looked around only to find that the owner was at home, and he was in the process

In Black and White: Cross-Cultural Genealogy

Search This Blog