Sound-based Database Search Tool to "Church of the Assumption, Syracuse, NY 1844-1860 Baptisms," F. Richard Barr, transcriber. TreeTalks, December 2006

Intro

Query the Index

Search by Surname

Surname:
Given (not required; for reference only):

Search by Given name


Given:
Surname (not required; for reference only):

Search by Date (birth or baptismal)


Date: Month: Year:
Name (not required; for reference only):

At the current time, there are 2981 rows in the database, and the last existing entry in the database is ID2986: Greiner, Johanna, ( ); 064. Note that occasionally the database administrator may work ahead for specific queries, and the name shown may not be where the admin is alphabetically.

Last alphabetical entry: Groman, Maria Jr, , 101.

Important note: The database is not structured to handle phonetic symbols, such as ü, and will return them as if the symbol is not there.

Though I'm pretty fast with queries now that I've gotten the database in order, if you haven't heard anything after two months, you may want to send a tickler e-mail

Return to the top

Introduction

The names listed in the index are taken from "Church of the Assumption, Syracuse, NY 1844-1860 Baptisms," compiled by F. Richard Barr in TreeTalks (December 2006). Mr. Barr transcribed records owned by the Franciscan Friars, and compiled them into the journal issue, which is copyrighted by both him and the Central New York Genealogical Society. The database searches by soundex, metaphone, german soundex and experimental values, and names and information are in the process of being added to the database.

Page table of contents:

Explanation and Format of Results

The search form above will return the soundex, metaphone and german soundex codes even if there are no exact matches in the index. Matches for surname queries are displayed in groups of exact, metaphone, soundex, german soundex, and experimental, and all groups except for experimental are sorted alphabetically by surname; the experimental group is sorted by given name. Displayed results for given name queries are (for now) in exact, metaphone and soundex groups, and these are also sorted by surname.

If entry data has been entered for a person, a radio button will be available for you to click on, which will display the entry information when submitted. If there is no radio button, e-mail me at obstinatesnooper (at) gmail (dot) com, so that I can look up the information manually in the journal and e-mail it back to you, or copy the journal page and send it by snail mail.

When the priests recorded the baptisms, they followed the same format for each entry: Child name, son / daughter of father and mother[, his wife (optional)] [, of location (optional)], born date; baptized date. Rev. name officiated. Sponsors: first and second. By hooking into a database, for example, instead of having to request through e-mail that I type out Josť, Francis from page 048, you can automatically get something like the following:

Entry:
35  
Original page & year: [84] 1855 Journal page: 048
Officiated by: Rev. Frederick Müller
 
    Florian Jose  
     
Francis Jose  
 
b. 18 May 1855   Catharine  
bp. 27 May 1855  
 
 
  Sponsors: Jonuah Francois and Francis Jose
Barr, F. Richard, transcriber. "Church of the Assumption, Syracuse, NY, 1844-1860 Baptisms." TreeTalks, December 2006.

where "Entry" is the entry number as assigned by the pastor who wrote recorded the information, and the original page and year is as noted by Mr. Barr.

Return to the top

About the database and query scripts

The database searches by soundex, metaphone, german soundex and experimental values. in addition to a regular LIKE surname query. (If your ancestor is filed under "McGrath" and you search for "Grath", you will get results. Likewise, if your ancestor is stored as "Phettiplace" and you search for "Place", you will get results. However, it does not work in reverse: if "Grath" is in the index but not "McGrath", and you search for "McGrath", you will get no results.) Both the metaphone and soundex functions are included in the PHP programming language. I used the metaphone as included; however, I wrote my own soundex function, because the one included with php ignores the H and W rule1, 2 used extensively by genealogists and family historians. Many of the soundex descriptions I came across in my search for the rules also neglect this rule3:

If "H" or "W" separate two consonants that have the same soundex code, the consonant to the right of the vowel is not coded. Example: Ashcraft is coded A-261. It is not coded A-226.

So, if I were to query "Ashcraft" with the php included soundex function, I would get A226. If you were to run it with the query I wrote, you'd get A-261.

In May of 2009, I found a php function, written by Nicolas Zimmer <nicolas dot zimmer at einfachmarke.de>, for german soundex returns, which I added to the site. (code.)

I am still working on the script that will allow you to search, for example, for "Ioset" 4 and get "Jose" 5 in your search results. If you think that's a bit of a stretch, know that there's a good possibility that someone made a connection with those two names. I'm also working on how to get it to recognize "Graff" 6 as "Grath" 7, and other associated alternate spellings for other surnames.

  1.  The soundex function included with PHP (http://php.net/manual/en/function.soundex.php) is based on Donald Knuth's The Art of Computer Programming (http://www-cs-faculty.stanford.edu/~uno/taocp.html), instead of on genealogical research.
  2.  U.S. National Archives and Records Administration. "The Soundex Indexing System" (Genealogist / Family Historians at archives.gov). Online: National Archives and Records Administration, 30 May 2007), <http://www.archives.gov/publications/general-info-leaflets/55-census.html>, accessed 11 February 2011.
  3.  A notable exception is Eastman's Soundex Calculator.
  4.  [soundex: I-230; metaphone: IST; german: 82]
  5.  [soundex: J-200; metaphone: JS; german: 8]
  6.  [soundex: G-610; metaphone: KRF; german: 473]
  7.  [soundex: G-630; metaphone: KR0; german: 472]

The names listed herein are taken from "Church of the Assumption, Syracuse, NY 1844-1860 Baptisms," compiled by F. Richard Barr in TreeTalks (December 2006). Mr. Barr transcribed records owned by the Franciscan Friars, and compiled them into the journal issue, which is copyrighted by both him and the Central New York Genealogical Society. In his introduction, Mr. Barr describes idem sonans: "having the same sound":

In all cases the researcher must remember the prime caveat of genealogy: idem sonans. This means "having the same sound," and refers here to last names. These records include French and Irish names, possibly written by German-speaking priests so they may be difficult to recognize. Even the same priest also gave surnames in many variant spellings. Some records were very abbreviated; others were more complete. At times the place of national origin of the family is listed but in most cases this is lacking....

Hence the idea for a database to search the index by sound, and then also display the entry information. I have written permission for the website and database from Mr. Barr. Anyone who has any concerns, please contact me at the e-mail address <obstinatesnooper at nnettsplace dot com> with a subject that contains some phrase similar to "Legal Concerns regarding Baptisms Database".

Return to the top

Additional Tools

I programmed a search tool of sorts that pulls surname off of a site, assigns them soundex and metaphone values, spits out suggested name alterations and then does a search on google for the first 31 names at a site that you specify. You can also copy and paste pertinent spellings into Google, and I made a suggestion to Google that they incorporate sound data into their search results; if you think it's a good idea, you should suggest it to. Sound Search

Site Updates

12 February 2012: Added names and entry data, rearranged the front page.
21 August 2011: Added a summary; removed some struck text; added names.
13 February 2011: Added a function to search by birth and baptismal dates.
12 February 2011: Added Dick Barr's e-mail to results list. Revised print style. Adjusted disclaimer. Clarified search process description. Adjusted title of site.
11 February 2011: Updated NARA's soundex-indexing link. Removed old 'struck' text. Figured out how to program and search removing and adding prefixes. Added a dash into displayed soundexes for looks.
4 September 2010: Began converting pages to HTML5 and CSS3.
21 Mar 2010: Happy Spring! Added a link for sound search; added an info box on the results page; adjusted the experimental result query string
19 March 2010: Fixed a query error; added another experimental sound calculation; fixed Rev. Frederick Müller's name
27 February 2010: Given search works!
28 February 2010: Updated print css.

Return to the top

Locations of visitors to this page

Citations:
Journal issue: Barr, F. Richard. "Church of the Assumption, Syracuse, NY 1844-1860 Baptisms." TreeTalks, December 2006.

Information on purchasing this issue from the CNYGS.

Website: Otis, Jeanette M. Sound-based Database Search Tool to "Church of the Assumption, Syracuse, NY 1844-1860 Baptisms," F. Richard Barr, transcriber. TreeTalks, December 2006. Updated 12 February 2012. Accessed: 29 July 2014. <http://www.nnettsplace.com/syracusebaptisms/>.

From the introduction: (by Tree Talks Committee)

Whether or not your Catholic ancestors lived in Syracuse in the 1840's through 1860's, you may find them in these baptismal records. German immigrants to Central New York incorporated the Church of the Assumption in 1844. Irish immigrants also contributed to the tremendous growth of the parish in the first twenty-five years. And Catholics from the surrounding counties were often baptized by Assumption priests due to the scarcity of Catholic churches during this time. So you will find mention of baptisms from counties surrounding Onondaga County, as well....

Link to this site

<a href="http://www.nnettsplace.com/syracusebaptisms/" title="Search the index"><u>Sound-based Database Search Tool to "Church of the Assumption, Syracuse, NY 1844-1860 Baptisms"</u>. Barr, F. Richard, transcriber. <i>TreeTalks</i>, December 2006.</a>