Preparing for Ancestry Sync

TMG –> RootsMagic Cleanup

Randy Seaver recently discussed the upcoming ability of RootsMagic to sync with Ancestry and what he is and isn’t doing to prepare for that in his blog post, “Dear Randy: What are you doing to prepare for the RootsMagic program sync with your Ancestry family tree?” While reading Randy’s blog, I realized that I was in the middle of such a preparation with my work on my census facts.

My genealogy data was migrated from The Master Genealogist version 9 to RootsMagic. When I selected The Master Genealogist (around version 4 or earlier), it was because I wanted something that allowed me to add citations for each event. Thru the TMG community, I developed my research and documentation skills. I also applied several TMG ‘hacks’ — especially if they helped visualize the events in someone’s life.

tmgcensusOne of those ‘hacks’ was a modification to the census tag developed by Terry Reigel. It took me some time to implement this hack, but once completed, it allowed me to see the family in the timeline for the head of the household.

Since RootsMagic would not handle the ‘split sentences’ in the census-head or census-enum tags, I did have to modify the sentences. I was able to do this in TMG prior to the migration. Because, I liked how the census tags worked, I did not modify them in TMG but let them migrate into RootsMagic as custom event (fact) types.

As I began to learn to use RootsMagic with Family Search, I realized that my custom fact types were not lining up with the corresponding fact type on Family Search. Since the tree on Family Search is a community tree, I’m very hesitant about making changes – but also want to see more documentation for my ancestors. Thus, the conflict — my custom fact types would ‘foul up’ the Family Search tree but the census records have not been sourced. Because of that conflict, I decided to figure out how to revert my custom fact types (census-head and census-enum) to the standard type.

Knowing that there wasn’t an easy way to do this from within RootsMagic I turned to the SQLite Tools for RootsMagic community. There, I found directions on how to setup SQLiteSpy so that it would read and modify the tables in the RootsMagic database. Once I had this software downloaded and correctly configured, I used the SQL script, Facts – Change Fact Type to change all of my census-head and census-enum fact types to the standard census fact type. Since this SQL script directly modifies the database, I copied the database and worked with the copy FIRST. That allowed me to make sure the script was doing what I wanted without the danger of corrupting my data. Once I knew it was working, I backed up the data and then ran the script on the original copy of the data.

After running the script, the census citations in my RootsMagic database lined up with any census citations on Family  Search. Step one accomplished!

Besides changing the custom fact type to the standard, I had two other potential issueds with my census facts. The first involved the sentences. It appears that what was in the memo field in TMG was dumped into the note field in RootsMagic while the sentences pull the information from the description field. Thus, all of the information I had entered about the individual wasn’t being pulled for the sentence. Since almost all of my census facts had witnesses associated with each fact, individual reports and web output was showing extra sentences/facts for other members of the household.

So, my next step was to move the info in the note field to the description field while also removing any witnesses. Since I couldn’t get the SQL scripts for this process to work (they do exist), I resorted to doing this one person at a time. With over 10,000 census entries this is no small task. I started with my ancestors who were living in 1850 and worked thru their descendants. However, I’ve been researching several neighbors and other potentially connected families and their descendants. Thus, I needed some sort of report that would help me know who was left to do.

The SQLite Tools for RootsMagic came thru again! On their site, I found a link to the “People who share a fact with a principal list” script. This particular script just creates a list, it doesn’t modify the database. However, the script must be run with the RootsMagic database closed. I have the script saved in my SQL directory. Each time I want to run it, I open the script with Notepad and then copy and paste it into SQLiteSpy. Once executed, the script will create a list. I copy the info in that list and paste it into a blank Excel spreadsheet. That way, I can close SQLiteSpy and open RootsMagic and still have a list to work with.

Once the data is in Excel, I do a multilevel sort: Fact, Surname1, Given1, RIN1. This allows me to easily delete everything but the census records. Armed with that list, I just work my way thru the records. I’m down to about 1300 census events.

Will this be worth it? Because this is cleaning up my data and making it easier to see corresponding census records on Family Search, I will continue until finished. I’m also hoping that by using the standard ‘census’ fact type, this data will also line up with Ancestry. My wish is that all of my census data will keep me from having shaky leaves for those same census records.




Tackling the Hirams – Pt 1

Recently, I was notified by Ancestry of a DNA match for a descendant of Jane Currey Gutridge who lived in Champaign County, Ohio. Since Jane Currey is a known descendant of Hiram Mirick Currey – the treasurer of Ohio in 1820, this match was HUGE news.

I have a lot of data to support my ancestor also being a descendant of Hiram Mirick Currey. Unfortunately, I haven’t found a will or probate record to provide direct evidence of this relationship.

Now, that I have DNA evidence to support the lineage, I’m doing a ‘go-over’ on this line starting with my great-grandfather, Hiram Miles Currey.  Please let me know if you have CORRECTIONS or have additional information to share.

Hiram Miles Currey


Hiram was born on 23 Oct 1866 in Missouri.13,4

He was enumerated with Hiram M. Currey on the census on 20 Jul 1870 in Kickapoo Township, Leavenworth County, Kansas as a 3 year old white male born Kansas and was listed as Hiram Curry.4, 5

He was enumerated with Hiram M. Currey on the census in Jul 1875 in Kickapoo Township, Leavenworth County, Kansas as a 7 year old male born Kansas and was listed as H. M. Curry Jr.5, 6

Hiram was enumerated with Hiram M. Currey on the census in Jul 1880 in Delaware Township, Leavenworth County, Kansas as a 13 year old white son born KS and was listed as Hiram Currey.6

In  7 May 1881, he was educated  at Nine Mile School in Leavenworth County, Kansas.7, 8

He was enumerated with Hiram M. Currey on the census in Jul 1885 in Delaware Township, Leavenworth County, Kansas as a 15 year old single male born KS and was listed as Hiram Curry.8

Hiram was educated  between 1890 and 1891 at William Jewell College in Liberty, Clay County, Missouri.9

He  and family visited his parents the Saturday and Sunday before 3 Jan 1896 in Lansing, Leavenworth County, Kansas.10

He is head of household on the census in Jun 1900 in Delaware Township, Leavenworth County, Kansas as a 33 year old married white male magnetic healer who was born in 10/1866 in Kansas and has been married 11 years and was listed as Hiram Carrey. Enumerated with Hiram were Winnie Mae Hutchinson, Henry Currey, Herbert Miles Currey, and Myrtle Irene Currey.11

He  resided in 1902 in Lansing, Leavenworth County, Kansas .12

He is head of household on the census in Jul 1905 in Lansing, Leavenworth County, Kansas as a 34 year old white male born KS who came to KS from MO and was listed as H. M. Curry. Enumerated with Hiram were Winnie Mae Hutchinson, Henry Currey, Herbert Miles Currey, Myrtle Irene Currey, Mary Lela Currey, and Winnie Letha Currey.13

He was placed on ballot for office of clerk district court by socialist party in Leavenworth County, Kansas on 20 Sep 1906.1415

In Jul 1908 in Leavenworth, Leavenworth County, Kansas,  he has purchased a wagon, team and harness and is trying to purchase another team before leaving for western Kansas.1617

Hiram is head of household on the census in Jul 1910 in Rooks County, Kansas as a 44 year old white male born KS and was listed as Hiram M. Currey. Enumerated with Hiram were Winnie Mae Hutchinson, Herbert Miles Currey, Myrtle Irene Currey, Mary Lela Currey, Winnie Letha Currey, and Earnest Oran Currey.18

He lived at South Chestnut in Olathe, Johnson County, Kansas on 2 Oct 1913.19

He lived at 3840 Euclid Av in Kansas City, Jackson County, Missouri in 1915.20

Hiram lived at Euclid in Kansas City, Jackson County, Missouri in 1916.21

He lived at 4108 Penn Av in Kansas City, Jackson County, Missouri in 1919.22

He was  on the census in Jan 1920 in 5th Precinct, Kansas City Ward 4, Jackson County, Missouri as as a 50 year old widower born in Kansas and employed as a baker at a cone factory who was listed as Hiram Curry.23

Hiram is head of household on the census on 1 Jul 1925 in Logan, Gray County, Kansas . Enumerated with Hiram were Earnest Oran Currey and Alma Jean Currey.24, 25

He was enumerated with Myrtle Irene Currey on the census on 19 Apr 1930 in Dodge City, Ford, County Kansas as a 63 year old male born Kansas who works as a carpenter in building construction and was listed as H. Miles Curry.25

He was enumerated with Leon Russel Crawford on the census on 1 Apr 1940 in Dodge City, Ford, County Kansas as as a 74 year old widower living in the household of Leon Crawford who was identified as Hiram M. Currey, father-in-law.26

Hiram died on 15 Sep 1943 in Dodge City, Ford, County Kansas at the age of 76.23,27

He was buried on 18 Sep 1943 at Maple Grove Cemetery in Dodge City, Ford, County Kansas.3,2830


  1. Hiram Currey, Hiram Currey Family Bible (New York: American Bible Society, 1880); Marcia Philbrick, Seneca, KS, Family Record — Births: Children of H.M. and A. J. Curry “Hiram Miles was borned October the 23d AD 1866”. Bible does not indicate place of birth.
  2. Hiram M. Currey, death certificate (Standard Certificate of Death) 229 2924 (18 September 1943), Division of Vital Statistics, Kansas State Department of Health, Topeka, Kansas.
  3. Hiram M. Currey Funeral Program, Dodge City, Kansas, 18 Sept 1943, Philbrick Family Collection, privately held by Marcia Philbrick, , Seneca, Kansas, 2016. passed down from Winnie Crawford to Marcia Philbrick.
  4. 1870 U.S. Census, Leavenworth County, Kansas, population schedule, Kickapoo Township, Leavenworth County, page 16 (image 16 of 47), household 125, Hiram M. Curry; digital image, ( : viewed online August 2016); NARA microfilm publicatin T132.
  5. 1875 Kansas Census, Leavenworth County, Kansas, kansas state census, Kickapoo Township, Leavenworth County, Kansas, page 31, household 1, H. M. Currey; digital image, ( : viewed online September 2016); Kansas State Historical SOciety.
  6. 1880 U.S. Census, Leavenworth County, Kansas, population schedule, Delaware Township, Leavenworth County, Kansas, enumeration district (ED) SD 3, ED 147, page 78 (image 15 of 34), household 141, Hiram M. Currey (continued on next page); digital image, ( : viewed online August 2016); NARA microfilm publication T9.
  7. , “Nine Mile School 7 May 1881,” Rootin Around newsletter of the Leavenworth County Genealogical Society,7 (October 1867): .
  8. 1885 Kansas State Census, Leavenworth County, Kansas, state census, Delaware Township, Leavenworth County, Kansas, page 61 (image 31 of 133), household 129, H. M. Curry; digital image, ( : viewed online August 2016); Kansas State Historical Society.
  9. William Jewell College, “William Jewell College Catalog – Academic Department,” 1891 – p. 12 / 1890 – p. 11, Hiram M. Currey; William Jewell College, Liberty, Missouri.
  10. Lansing News, Lansing, KS, “Nine Mile Items” 3 Jan 1896 page 8 col. 2.
  11. 1900 U.S. Census, Leavenworth County, Kansas, population schedule, Delaware Township, Leavenworth County, Kansas, enumeration district (ED) SD , ED 83, sheet 20A, household 364, Hiram M. Currey; digital image, ( : viewed online September 2016); NARA T623.
  12. 1902 Wing’s City Directory of Leavenworth, Kansas with an Alphabetical List of Its Residents (N.p.: Fred C. Wing & Co., 1902), (image 168 of 185), image 168 of 185; leavenworth, kansas, ( : viewed online September 2016), Lansing Directory – Currey Hiram M.
  13. 1905 Kansas State Census, Leavenworth County, Kansas, state census, Lansing, Leavenworth County, Kansas, page 2, line 17, H. M. Curry; digital image, ( : viewed online September 2016); Kansas State Historical Society.
  14. “Socialist Ticket for Coming Election,” The Leavenworth Times (Leavenworth, Kansas), 20 September 1906, nominees for office; digital image, ( : viewed online September 2016).
  15. “Socialist Ticket,” The Leavenworth Post (Leavenworth, Kansas), 28 September 1906, list of nominees; digital image, ( : viewed online September 2016).
  16. “Delaware,” Local News, The Leavenworth Times (Leavenworth, Kansas), 24 July 1908; digital image, ( : viewed online September 2016).
  17. “Delaware,” local news, The Leavenworth Times (Leavenworth, Kansas), 17 July 1908; digital image, ( : viewed online September 2016).
  18. 1910 U.S. Census, Rooks County, Kansas, population schedule, Twin Mound Township, Rooks County, Kansas, enumeration district (ED) SD 6, ED 168, Sheet 11A, houeshold 201, Hiram M. Currey; digital images, ( : viewed online September 2016); NARA microfilm publication T6224.
  19. , Olathe Mirror, Olathe, Kansas, 2 October 1913, page 3, col. 5.
  20. 1915 Kansas City Missouri City Directory containing an Alphabetical List of Business Firms, Coroporations and Private Citizens: 1915 Kansas City Missouri City Directory (Kansas City: Gate City Directory Co., 1915), image 314 of 1403, Curry, HIram; digital image,, (: viewed online September 206).
  21. 1916 Kansas City, Missouri City Directory Containing an Alphabetical LIst of Business Firms Corporations and Private Citizens: 1916 Kansas City, MIssouri Citi Directory (Kansas City: Gate City Directory Co., 1916), image 292 of 1278, CUrrey, HIram and Currey, Myrtle; digital image,, (: viewed online September 2016).
  22. 1919 Kansas City Missouri City Directory (Kansas City: Gate City Directory, 1919), imae 357, Hiram M. Currey; digital image, ( : viewed online September 2016).
  23. 1920 U.S. Census, Jackson County, Missouri, population schedule, 5th Precinct, Ward 4, Kansas City, Jackson County, Kansas, enumeration district (ED) SD 5, ED 62, sheet 5A (image 9 of 23), dwelling 78, Hiram Curry; digital image, ( : viewed online September 2016); NARA microfilm publication T625.
  24. 1925 Kansas Census, Gray County Kansas, state census, Logan, Gray County, Kansas, image 8 of 30, household 43, H. M. Currey; digital image, Ancestry.Com ( : viewed online September 2016).
  25. 1930 U.S. Census, Ford County, Kansas, population schedule, 1st Ward, Dodge City, Ford County, Kansas, enumeration district (ED) SD 7, ED 29-5, Sheet 16B, household 362, Gaskill Myrtle; digital image, ( : viewed online September 2016); NARA T626.
  26. 1940 U. S. Census, Ford County, Kansas, population scheudle, Ward 1, enumeration district (ED) SD 7, ED 29-6A, page 17A, Hiram M. Currey; digital image, ( : viewed online March 2016).
  27. Dodge City Daily Globe, Dodge City, Kansas, Wednesday, Sept. 15, 1943, page 2, col. 3.
  28. Tombstone, Maple Grove Cemetery, Dodge City Kansas read by Marcia Philbrick, 1996. ()
  29. Computer Printout for Maple Grove Cemetery (Dodge City, KS: Dodge City, Kansas, 5/29/1985), Rec. 9399 22 lot 10 block 73 section 9 (Crawford.KS.080)
  30. Find a Grave, database and images, Find a Grave ( : viewed online June 2016), memorial for Hiram Miles Currey (1866-1943), Find a Grave Memorial no. # 35623901, created by Jason Townsend, citing Maple Grove Cemetery, Dodge City, Ford, Kansas United States; accompanying photograph by Kathy Hesser, Hiram Miles Currey.

Valuing Education

As a retired teacher, married to a retired teacher and surrounded by teachers in my family, education is the one political issue that I follow fairly closely.

As the election approaches and Kansans prepare to elect members of the Kansas House and Senate, education may be the one issue that separates the candidates.

No matter who is elected, the Kansas Legislature is scheduled to tackle the issue of how to fund education in Kansas beginning in January. As Kansans, we have been asked to contribute to the conversation thru email.

Education is expensive and figuring out a formula to fund it is complicated. Ask yourself how you would answer the following questions and then voice your opinion. Email before Nov. 30th.

Should all high school students have the chance to become a Kansas State Scholar?

Students across Kansas are recognized as Kansas State Scholars if they take a set of required courses. The list of courses includes two years of the same foreign language and a set list of science courses: biology, chemistry and physics. Thus, high schools need to be able to offer their students the opportunity to take these courses. Because of the differing nature of biological and physical sciences, it is very difficult to find a science teacher that has the background to teach both the biology and the chemistry and physics. This is compounded by the fact that there might not be enough sections to fill a teacher’s schedule or the teacher would have smaller class sizes. Some districts have utilized interactive distance learning technology to help provide these courses — particularly the foreign languages. Thus, there can be an additional expense either due to lower pupil/teacher ratio or to increased cost for the technology or both to provide these opportunities.

Should all high schools offer career and technical education programs?

What used to be called vocational education is now called career and technical education. The choice of what CTE programs to offer is a local decision but may include programs in business, finance, marketing, consumer services, childhood education, computers, design, web design, engineering, health science, GIS, production, cabinetmaking, automotive and agriculture. Typically, each program includes at least three courses: introductory, technical and application. Often times the 3rd year courses (application level) will have smaller class sizes — especially when compared to required courses such as English. Thus, when the pupils/teacher ratio is used, they are considered more expensive. In addition, these programs often require specialized facilities, equipment or software which adds to the cost of offering a program.

Should schools offer programs in the fine arts?

Most schools do offer fine arts. However, quite a few districts cut their teaching staff and thus the offerings in these areas when the financial crunch first hit. Thus, we are limiting the ability for students to experience different areas of the fine arts or for those who enjoy the arts to have the opportunity to develop their potential and excel.

Should schools have technology?

I know there are a lot of people that don’t understand why school districts are working to give each student a device (tablet or laptop). However, I see people all of the time pulling out their phones to look something up. Whether as an adult or as a student information has moved to the Internet. This includes library card catalogs, magazine databases (think Readers Guide to Periodical Literature), encyclopedias and textbooks. Isn’t it our responsibility to teach students how to find accurate information? Yes, some schools do have classes share computer technology. However, that takes time away from instruction to get the students to a device. Providing access to this information is more than the device. Behind each device is some sort of connection — whether wireless or wired  — and an Internet account.

Should schools offer extra-curricular programs including athletics?

When discussing school funding, the cost of athletics always comes up. Athletics and other extra-curricular programs offer students the opportunity to develop leadership skills and to learn to work with others. For some students, athletics is what keeps them in school until graduation. Booster clubs, gate receipts and parents already shoulder a portion of the cost of athletic programs. This support would likely increase if districts cut the budgets for athletic programs.

Should students have to ride a bus more than an hour to get to/from school?

If you want small schools to close and consolidate with their neighbors, then you need to be willing to have children — especially younger children — on the bus for more than an hour one way.

Should schools have a full time counselor in the building?

Should schools have access to a school nurse?

Should schools offer all day kindergarten?

Should schools have smaller classes for grades 1-3?

Should schools offer pre-school?

Should every Kansas child have the right to an education?

This is just a few of the questions that have to be answered in regards to school funding — especially where my background is at the high school level and not elementary. There are no easy answers.

Voice your opinion by emailing before Nov. 30th. You might also send your thoughts to current legislators and those seeking office.

Unions in the Tree

Today’s Topeka Capital Journal editorial got me to thinking about the role of a union in my life and the union activities of my ancestors.

Both my grandfather, Leon Crawford, and great-grandfather, Judson Crawford,  worked for the railroad – for the Atchison, Topeka and Santa Fe railroad. I don’t remember my grandfather talking about union activities but he was a lifelong member of the Brotherhood of Railroad Trainmen.


My father, Eugene Crawford,  went into teaching instead of joining his father at the railroad yards. However, my father did follow his father’s footsteps when it came to professional involvement. As a young teacher in Dodge City, he attended the Garden City section of the Kansas State Teachers Association and was elected as a delegate to the state assembly. (“Agree Convention, Hunting Don’t Mix,” Garden City Telegram (Garden City, Kansas), 7 Nov 1958,

Elected Delegate

In addition to his involvement in the teacher’s association, my father was active in the Kansas Association of Teachers of Science (KATS) and the National Science Teachers Association (NSTA).


As my science teaching methods teacher, I’m sure my father encouraged my to be active in my profession. However, it was his example that led me to not only join but participate in KNEA (Kansas National Education Association) and the professional organizations associated with my teaching assignment.

It was even his car and gasoline that allowed us to attend the regional conventions of the National Science Teachers Association during those early years of our career. Education has mad big strides from those early years when there wasn’t any form of reimbursement for attending professional conferences. Whether it was the annual KATS (Kansas Association of Teachers of Science) Kamp at Rock Springs or regional and national meetings, the cost of registration, lodging, meals and transportation were the responsibility of the teacher. Not only did teachers have to pay for everything, they had us use precious personal leave or take leave without pay to attend. For us, the addition of professional leave was a major victory in the contract negotiations. The bonus came a year or two later when reimbursement for some of the expense was granted.

In those years, I called KNEA a professional organization because it fought for my professional rights. I never really considered it a union until more recently. Besides working to grant teachers the ability to be active professionally, the local association worked to broaden definitions of sick leave. One of the first steps in this process was to allow a teacher to use his/her sick leave to be with a family member during an illness. Prior to that change, teachers had to use their personal leave (that’s why it was so precious) or be docked pay to stay home with a sick child or be at the hospital bed of a child, sibling or parent. The next step was to allow sick leave to be used for funerals of immediate family members.

The changes in the definition of sick leave and the recognition of the needs for professional leave and reimbursement were the contract items most important to me. However, over the years, NVTA (Nemaha Valley Teachers Association) worked hard for other changes that affected the work day. These changes included a 25 minute duty-free lunch period and time set aside daily for preparation and planning. (USD 115 2016-2017 Negotiated Agreement)

On this Labor Day, I’m thankful for all of those that have gone before me — working for working conditions and benefits that are now taken for granted.

Elwood Kansas & the Mighty Mo

In trying to locate more information on a cemetery at Elwood, Kansas, my husband unearthed some interesting maps of Elwood in relation to the Missouri River.

The Kansas Memory site has several maps that help place the river in relation to the city of Elwood. A map of Elwood dated between 1870 and 1890 places the river at the East and North edges of the town.

This map is a fairly detailed map of the town showing street names and parks. It does not indicate a cemetery.

The 1882 plat book of Doniphan County also indicates that Elwood was bordered by the Missouri River on the North.

Likewise, the 1904 Plat Book of Doniphan County has the northern edge of Elwood on the banks of the Missouri River.

Below is a current day image from Google maps showing the northern edge of Elwood. The Missouri River is along the right of the image. The state boundary line in the upper left corner of the image is following an oxbow lake. The railroad tracks and Vermont Street can be used as comparison points between the current day image and the early map (1870-1890). The map from the 1870-1890 time period indicates that there were 12 blocks north of Vermont Street. In looking at today’s image, it is easy to imagine the river making a curve and going along the very North edge of Elwood.


If the GPS coordinates of the Elwood cemetery are correct, then it is very doubtful that this cemetery existed in 1896 in the stated location. Based on these early maps, the suggested location of the Elwood Cemetery would have either been in the river or on the Missouri side of the river in 1896.


Another mystery child!

In my post, Who Is Jenny Neal, I wrote about finding a 13 year old child living with my great-grandparents that I could not explain. While filling in census gaps, I found another ‘mystery child’. This child is a 3 year old female living with my grandparents at 510 Avenue G in Dodge City, Kansas in 1925. (Ancestry image)


I sincerely doubt that this child is my aunt. My grandmother, Winnie, was responsible for getting me started in genealogy. Even though grandma told me about the baby she lost (Betty Jean), she never mentioned having a 4th child – born after Betty Jean but not part of the family in 1930.

For many years, grandma was the caretaker of the Crawford family plot. Buried in the Crawford family plot are two other children of Leon R and Winnie Crawford: Betty Jean (b1921/d1921) and uncle LR. However, there isn’t a burial for anyone matching this child.

Even though family pictures exist from the time period. there isn’t a photo identifying this child – especially as a child of Winnie and Leon.

So, who is this child?

Is she related to Jenny Neal?