The Brooklyn Historical Society has a photo of the week blog post and this week’s post is a photo of the Abraham & Strauss department store, circa 1895. My great-grandmother Dolly worked at the A&S as a young woman, circa 1920. She earned about $5 per week.The thing I really like about the photo posted this week by the BHS is the display appears to be a complicated display of handkerchiefs and linens. The store, early on, specialized in “silks and dress goods, cloths, laces, embroideries, cloaks, shawls, linens, gloves, china and glass, sterling silver, bronzes, ribbons, house furnishings, upholsteries, art embroideries, books, furniture, carpets, and stationary.” The display is beautiful, with its geometric design. Additionally, my aunt Lulu, how is named after my great-grandmother, has her own business that was started reselling antique handkerchiefs. There is a symmetry across generations that mimics the beautiful design in the window. It’s really quite stunning.
One of the first thing you see when the DNA test results come back is your ethnic breakdown. Now, from what I’ve read this is based on DNA testing of people who live in those regions now – so there is some margin of error for using this test to confirm my ethnic mix. And there were a few surprises….
West Europe, Ireland and Great Britain are no surprise at all. Much of my records research supports family roots in those regions. The Scandinavian was a complete surprise. As far as I know, there is not confirmed family ancestry from the Scandinavian region. However, when you click on the link for Scandinavia, there is more information that may explain why I’m seeing it show up in my profile.
Netherlands and seafarers…. On my father’s side of the family, my Noteboom ancestors were all seafarers from the Northeastern part of the Netherlands (on the border of Germany, near the major port town of Bremen). It’s quite possible that farther back in our ancestry than I have traced, our Dutch roots stretch to Scandinavia. The other explanation (and one my brothers would probably enjoy) is that we have Viking roots! (I joke…. sort of.)
The other big surprise is the mix of Iberian, Eastern Europe and Italy/Greece roots. But this could possibly explain the other surprise, which was the absence of Native American ancestry (as in 0%). Now in reading about Native American ancestry in DNA, if the ancestry is far enough back, there may not be enough DNA to register the ethnicity. And the ancestor I believe to be our Native American connection is my 3rd Great-Grandmother, and assuming she was 100% Native American (which is not confirmed), that means I only have 3.125% of her DNA. If she was less than 100% Native American, then my share of her DNA is even smaller.
But how does that explain the Iberian/Eastern Europe/Italy/Greece DNA? Those ethnicities also tend to show up in people whose DNA has Native American ancestry.
So maybe the Native American DNA is too diluted to register, and/or it’s registering as the other European ethnicities that influenced Native American ancestry.
The thing I’m most excited about is the possible matches to others with trees on Ancestry.com. I’m hoping that I will be able to connect to people who have more information about certain branches of my family tree, so that I can break down those brick walls. There are some familiar faces – people I’ve already connected with through my research. It’s nice to have those familial connections confirmed. I’m looking forward to exploring this new option for researching my family history.
I’ve been away for a little while – been incredibly busy with a major work project, which included a lot of hours and travel. Left me too exhausted and with too little time to spend on researching my family tree. However, in May, I came across a blog post that inspired me to spend some time organizing. Michele Simmons Lewis on her blog Ancestoring describes an Excel trick for working with the data in her Ancestry.com family tree. At the end, it produces a spreadsheet with a list of all your ancestors, along with their birth and death dates/places. Part of the beauty of the list is the list of names will contain a hyperlink to the individual profiles on Ancestry.com. Here’s an example of what my list looks like:
Then I took the spreadsheet a few steps further – in part because I’m a complete Excel geek and because I like to use data to solve problems. My next step, I added some extra columns:
- Relationship (to me)
- Side of the Family (Maternal, Paternal and N/A). N/A is for my siblings, their spouses, children, etc. who don’t belong to actually one side of the family or the other.
- Copies of Citations/Docs Downloaded. (I’ll get more into this below.)
- File location (for the MRIN/Marriage Record Identification Number, which I use for organizing my computer file folders)
In addition to the columns, I do a couple of other things to the data to make it easier to work with:
- Create a table for the range of data. Excel behaves differently when working with data within a table that makes it easier to work with, especially when the data is very similar and when working with formulas. To do this, highlight all the rows and columns of data in the spreadsheet. On the Home tab, select Format as Table, then select the table format that you want/like. I prefer a table that has alternating colors for the lines because I find that easier to read.
- Then I add a Filter to the column headers. Highlight the row of headers, and select Filter on the Data tab. Once the filter is set, you can click on any of the down arrows next to a column header to:
- Sort by that column
- Filter by certain data, such as a surname, and hide all the other rows of data.
Once I had the data formatted the way I wanted it, I was ready to get to work. Using the hyperlinked name for each member of my family tree, I noted their relationship to me (concentrating only on direct ancestors and their siblings – I bypassed any cousins x times removed) and what side of the family they fell on. This is easy in the Ancestry.com individual profile, as the relationship is noted in the header information.
But the main purpose of this list is to keep track of downloading copies of the records attached to my ancestors’ profiles to my computer to retain my own digital copy of all their records. I’m still working my way through this, but I’ve got a good head start. Once I’ve download the attached records of a particular profile, I mark the row as “Complete” under the column: Copies of Citations/Docs Downloaded. I also save a .pdf of the citation page from Ancestry.com for each record, including any index citations, in the ancestor profile. I then put the path for the file folder on my computer in the last column so that I know where to find these files later.
The next trick I use in Excel is Conditional Formatting. Whenever I enter the word “Complete” in the Download column, it will highlight the row in green so I can easily see which ancestors I’ve completed downloading the documents for. If the ancestor doesn’t have any source citations in their profile, I mark the column as “None”. Any marked with “None” get highlighted in red.
To use Conditional Formatting to highlight a whole row, based on the contents of a single cell:
- Highlight the row of data.
- Select Conditional Formatting from the Home tab.
- Select New Rule
- In the New Formatting Rule dialog box, select “Use a formula to determine which cells to format”.
- Enter the formula entering an equal sign, click on the cell that will contain the data you want to base the formatting on. In this case, I select the cell F59 for the Download column for row 59. This is where I will note “Complete” or “None”. Enter another equal sign, then the text (in quotes) that you will base the formatting on, in this case, “Complete”.
- Click on the Format… button to select the formatting you want applied to the row, such as fill, font color and border.
- Click OK.
- Repeat the process for “None”.
- Click OK to exit out of the Conditional Formatting dialog box.
- Select the Format Painter tool and copy the formatting to all rows in the spreadsheet.
Now that the spreadsheet is formatted the way I wanted, I worked my way through my family tree, surname by surname, noting the relationship and side of the family.
Now I can easily produce to do lists for research and downloading records for parts of my family tree by filtering the list based on surname, relationship type, side of the family, etc., depending on what part of my family tree I want to concentrate on.
And in the habit of playing with data, I also created some fun tables of summary information at the bottom of my spreadsheet, using some easy Countif formulas:
Counts by Side of the Family:
For example, to count the Maternal line, the formula is =countif(Range of Data, Cell with the word Maternal in it). The formula will count all cells that contain the matching word from the data table.
Count by Complete Downloads
For example, to count the Complete Download, the formula is =countif(Range of Data, “Complete”). The formula will count all cells that contain the word “Complete” from the data table. Then count the total number of rows by with the CountA formula, written as: =counta(range of data). In the last column, divide the Total Complete by the Total Count to get the percentage completed.
Count by Relationship Type
For example, to count the number of 2nd Great Uncles, the formula is =countif(Range of Data, Cell with the phrase “2nd Great Uncle” in it). The formula will count all cells that contain the matching phrase from the data table.
A note about the “$” in some of the formulas: this hard codes the cell referenced in the formula, so that if you drag the formula down to copy it to additional cells, that part of the formula remains constant and only the non-$ numbers adjust.
So many thanks to Michele Simmons Lewis for the inspiration to riff off in order to get organized with my research.
I just the received the marriage certificates for Walter Noteboom and his first and third wives.
The Marriage Certificate of Walter Noteboom and Beta Friederike Christiane Nullmeyer
Certificate of Marriage.
State of New York
I hereby Certify, that Wolter Noteboom [and] Beta Friederika Christiane Nullmeyer; were joined in Marriage by me, in accordance with the Laws of the State of New York, in the City of [blank] this 11th day of November 1876.
Witnesses to the Marriage,
Attest Fr. W.T. Steimle
Official Station Pastor of the German Ev. Cath. Zion Church [Zion German Evangelical Lutheran Church]
Residence 391 Jay Street
- Full Name of Groom, Wolter Noteboom
- Place of Residence, New York
- Age, 32 years
- Occupation, Shipping Clerk
- Place of Birth, Winschoten, Netherlands
- Father’s Name, Wolter Noteboom
- Mother’s maiden Name, Hinderina de Weerdt
- of Groom’s Marriage, 1
- Full Name of Bride, Beta Friedericke Christiane Nullmeyer
Maiden Name, if a Widow, ——–
- Place of Residence, Brooklyn
- Age, 26
- Place of Birth, Bremen, Germany
- Father’s Name, Albert Nullmeyer
- Mother’s Maiden Name, Meta Dorothea Koch
- of Bride’s Marriage, 1
N.B. – At Nos. 4 and 13 state if Colored; if other races, specify what. At Nos. 9 and 17 state whether 1st, 2d, 3d, &c., Marriage of each.
Brooklyn, 11 November 1876
We, the Groom and Bride named in the above Certificate, hereby Certify that the information given is correct, to the best of our knowledge and belief.
Wolter Noteboom, Groom
Beta Nullmeyer, Bride
Signed in the presence of A. Giese
And Charles Lermann
Canarsia L T
The Marriage Certificate of Walter Noteboom and Kate Dulk
City of New York
State of New York
Certificate Number 3938
I hereby certify, that, Walter Noteboom and Katie A. Dülk were joined in Marriage by me in accordance with the laws of the State of New York, in the Borough of Brooklyn, City of New York, this 25 day of June 1901.
Witnesses to the Marriage
Anna H.E. Noteboom
Signature of the Person performing the Ceremony
|Date of Marriage||June 25th, 1901|
|Groom’s First Name||Wolter Noteboom|
|Residence||64 Van Siclen Ave.|
|Single or Widowed||Widowed|
|Father’s Name||Wolter Noteboom|
|Mother’s Maiden Name||Henderina De Weerdt|
|Number of Groom’s Marriage||Third|
|Bride’s Full Name||Katie A. Dülk|
|Residence||168 Schenck Ave.|
|Single or Widowed||Single|
|Maiden Name if a Widow||———–|
|Birthplace||New York City|
|Father’s Name||Peter Dülk|
|Mother’s Maiden Name||Anna Brill|
|Number of Bride’s Marriage||First|
|Name of Person performing ceremony||F.S. Moore|
|Official Station||Rector [illegible]|
|Residence||122 [illegible] Ave.|
We, the Groom and Bride named in this Certificate, hereby certify, that the information given therein is correct, to the best of our knowledge and belief.
Walter Noteboom, Groom
Katie A. Dülk, Bride
Signed in the presence of Michael Dülk
And Anna H.E. Noteboom
- 52 Ancestors: #1 – The Life of Walter Noteboom (rootsofkinship.com)
- Death Registration for Wolter Noteboom (rootsofkinship.com)
- Walter Noteboom’s Netherlands Birth Registration (rootsofkinship.com)
- Death Certificates for Walter and Christiane Noteboom (rootsofkinship.com)
The first church service was held on the first Sunday in Advent in 1855 (December 2nd), with twelve worshipers in attendance. The service was held in a hall at Nassau and Fulton Streets. The congregation was comprised of recent German immigrants, who wished to maintain their traditions as Lutheran Christians. The services were conducted in German. In the early days, the church was very small, with no more than four worshippers in atttendance. However, the congregation grew quickly, welcoming the many recent Germans who immigrated to the New York area and necessitating the move to a new home at 189 Washington Street in May 1856. Before the end of the year, the church was incorporated and purchased its permanent home at 125 Henry Street for $14,500. The Henry Street church was originally built as a Dutch Reform church in 1839, making it the oldest church in Brooklyn Heights that is still being used.1
Pastor Friedrich Wilhelm Tobias Steimle was born in 1827 in Wurttemberg, Germany, and earned his missionary education in Basel. He arrived in New York in January 1851, and served as an assistant pastor to Dr. Stohlmann until 1855, when he began the Zion German Evangelical Lutheran Church. He was licensed by the Ministry of New York, and helped found the German New York Synod for which he served as President for six years. He passed away on 28 February 1880 at almost 53 years of age.2
“Church Marriages“, The German Genealogy Group, http://www.germangenealogygroup.com, Accessed: 2 Feb 2015.
Nicum, John. Geschichte des Evangelisch – Lutherischen Ministeriums vom Staate New York und Angrenzenden Staaten und Ländern (History of the Evangelical – Lutheran Ministry of the State of New York and Adjacent States and countries), New York: Lutheran Church, New York Ministry, 1888, page 351, digital images, Google Books (https://books.google.com/books?id=eo0sAAAAYAAJ&source=gbs_navlinks_s, Accessed: 2 February 2015). ↩
- Nicum, 375. ↩