Robbie Hott

Discussion

  1. Paper

To Do

Notes

  1. Definitions
    • Root marriage: the anchor marriage of the marital unit, usually the husband and first wife.
    • Root+1 marriage: the marital unit, as previously defined. The husband and all his currently-married wives
    • Root+ marriage: the tribe / dynasty for a given person. The entire priesthood line. Does this also include biological line? I don’t think so.
  2. History of marriage for a woman: one possible scenario that would be interesting to capture
    1. She is civil married to a husband, then later gets sealed (for eternity) to him
    2. Later, she is sealed to someone else
      • Case 1: she wanted to change up, and got sealed for eternity to someone else (in which case there would be a divorce/cancellation of the first sealing)
      • Case 2: she became a widow (first husband died), and therefore she was married (for time) into another marriage (this would have been a caretaker marriage for her).
        • She could have children with this second husband. The priesthood lineage would follow from her sealed for eternity husband/marriage. Therefore, the child would have two types of parent relations
          1. Biological parent: the parents the child was born to (the second husband). Property rights for the child will follow from the second husband (caretaker husband).
          2. Eternal (Priesthood) parent: the parents sealed for time of this child. Since the mother was sealed for time to her first husband, her children will always have that man as the eternal/priesthood parent. This father would be the man from the mother’s first marriage (sealed for eternity). Priesthood rights (office?) and lineage would follow the first husband’s line (sealed eterenity)
        • Interesting example and discussion (useful below)
          • If the woman’s first marriage has a higher priesthood status, then when she marries into another marriage, her children in the latter marriage are part of her first husbands line/lineage. However, the other children in this second marriage that are not blood relations to her are not included in that line.
          • Alternatively, her blood-related children are not included in the priesthood/patriarchal line of her second husband, unless she has been sealed for eternity to him.
  3. Two types of tribes (and relationships)
    1. Priesthood
      • Priesthood / Patriarchal Father and Mother (PF,PM)
    2. Biological
      • Biological Father and Mother (BF, BM)
  4. We’d want to show these two times of lineages and how the interact
    • Right now, we can show biological relationships
    • One diagram: parents of chord are only those sealed for eternity (at that given time point). The children on the right are only those who are Patriarchal children of those parents.
    • Another view: drqw the biological sankey diagram as is, but highlight in the biological diagram the patriarchal/priesthood lines
      • Therefore, we can see which children aren’t included in the patriarchal line when their mothers have been married twice, etc
    • Another: start with the patriarchal marriage, and show how the children’s biological lineages follow (start patriarchal and go out biological)
    • Or, show the biological diagram / organization, but only show the biological lines of those children who are priesthood/patriarchal children of the parents in the marriage (those sealed fro time)
      • So children and their descendents of a caretaker marriage would not be included in this diagram.
  5. Birth right goes to the oldest living son
    • The first child at the time it’s being given, which might not be the actual first child of the marriage, if that original child has died
    • First child temporal definition: oldest surviving child at that given time point
  6. Every relationship in the database needs a temporal aspect (Start and end dates)
  7. Questions Kathleen wants to ask about the group of people we’re looking at (AQ and wives)
    1. How long have they been members of the church? (length of time from baptism to death)
    2. How long before they were members? (length of time from birth to baptism)
    3. Who was born at the same place they were baptised? (shared site of baptism and birth)
    4. Root goes to root+1? Unclear.
    5. Age of each person at the time of their marriage and rank of wife (if woman)? Which wife were they to their husband?
    6. Commonalities among wives in a root+1 marriage? Were these women married to the same man similar in certain areas?
    7. Commonalities of first (root) wives across the marriages?
    8. What office do the people hold when they enter plural marriages? (when they take their second wife)
Robbie Hott

Discussion

  1. Paper submission to DHF2014
    • Travel
    • Deadlines, paper info
  2. Importing data into DB
    • Jill’s Marriage/Person data completed
    • Looking at Joseph’s Excel sheet. Will need some more work to convert.
      • Do we want to develop a front-end to the DB? Is there an automated way to do this?
    • Importing XML from Brown book
  3. Temporal Data Structures & Measures
  4. Bright Monday letter?

To Do

  1. Add many changes to the database
    • Join table of person to marriage (M0)
      • PersonID
      • MarriageID
      • Role
        • husband
        • wife
        • proxyHusband
        • proxyWife
        • officiator
      • Root marriage?
    • Occupation table
      • ID
      • Name/Description
    • Occupation Join
      • PersonID
      • OccupationID
      • StartDate
      • EndDate
    • Add role to ChurchOrgMembership
    • More join tables based on people!
  2. Where are we getting the occupation/property info? With the marriages?
  3. Document the sematics of the database tables with a sentence or two
    • Table Name, brief description, list of fields and description
    • Look for auto generator based on schema of database
  4. For Joseph’s Spreadsheet
    • Get the list and stick in the AQ (mine for just AQ)
      • Add to join table and QL
      • Display list of AQ in a page
    • Grab these from the DB:
      • Show our columns from Jill’s data and his columns next to each other for quality check and assurance
  5. Think:
    • Ways to get a working set of data we’re interested in
      • Separate database?
      • SQL Views! Look into them in PGSql. Can they be edited?
    • People, M0, M1, M2 marriages, church orgs
      • “shopping carts”

Notes

  1. Levels of marriages
    • M0 = 2 person marriage
    • M1 = group marriage, consisting of a few M0 marriages
    • M2 = tribe
    • …
Robbie Hott

Agenda

  1. Discuss database organization
  2. Start grabbing Jill’s data now?

Notes

  1. General discussion
    • Sealings and Marriages
      • should only be 1 officiator for sealing
      • 2 witnesses for sealing
      • will put anomalies for additional officiators of marriages in the notes
    • Need ecclesiastical title and dates in the database (use in Church Org Membership table)
  2. Brown book:
    • Endowment dates: Dec 1845, Jan-Feb 1846
  3. Discussion with Rick Turley
    1. How to show types of marriages (color?)
      • sealings (time, eternity) vs civil
      • suggests using color for the connection
      • What we should do – chords among parents in a marriage for the sealing types (colors for types)
    2. Track settlement companies as well as pioneer companies
      • We should keep track of where they settle, so we can see how the company led to a social network and marriages based on where they settled (settlement/pioneer company -> marriages?)
    3. Initial groups to consider
      • AQ (good church group)
      • Relief society
      • 1-2 Pioneer companies (on-foot group that moves)
        • Advanced company (will give sealings)
        • Vanguard company (Kimball, but he goes back)
        • The Big Company (combination of a few companies)
          • 1847, following Vanguard company
        • Giant companies (under Pratt, Taylor)
          • This is The Big Company above, I think
      • Good families
        • all members of 12 and 1st presidency can be tracked through 1860
        • Benjamin Franklin Johnson (huge family) BYUID=1515
        • Amasa Mason Lyman BYUID=33365
        • Aaron Johnson BYUID=1318
        • Oliver Huntington BYUID=289
    4. Pre 1908-tithing records are available
      • arranged by locality
      • identifies person by surname, first name, and lists their contribution
  4. Questions to continue considering:
    • How to denote root marriage in database?
  5. Demonstration to LDS Archives
    • Visualizations of:
      • sealed and blood relationships
        • Annointed Quorum
        • Heber C Kimball company
          • Show adopted sons and who might spin off into towns
      • Brigham Young
      • Heber C Kimball
        • lots of adoptions
      • Aaron Johnson BYUID=1318
      • Oliver Huntington BYUID=289

To Do

  1. Get nicer way to grab marriage IDs to Joseph
    • send: http://ford.cs.virginia.edu/nauvoo/
  2. ask worthy about getting someone to help with scripting in Jill’s data and Brown data
    • Kathleen will pay for someone to make it faster
  3. Finish database organization, import Jill’s data
Robbie Hott

Agenda

  1. Rekeying the pdf will be fairly inexpensive $0.55/KB
  2. Database organization
    • Birth and death places should be linked to places
    • Baptisms should go where?
    • Double check on missions
    • Double check on church organizations
    • Burial Place

Notes

  1. Database changes
    • “washing and annointing” to “initiatory”
    • Person table:
      • scratch the LDS member field
      • add burialplace and gather from Jill
    • NonMaritalTempleRites:
      • remove copyofblessing
      • Add cancellation date
      • remove baptism
    • Baptism Table
      • Type: conversion, proxy, health, second
        • conversion (or child baptism)
        • proxy (temple baptism, for preparation for temple rites)
        • health
        • second (second or later baptism, such as baptism after excommunication, to return to church)
      • Person
      • Proxy
      • Officiator (person)
      • Place
      • Date
      • ExcommunicationDate
    • Change MaritalSealings to Marriage
      • Note: Sealing is eternity, so time and civil aren’t sealings
  2. Interesting statements and questions
    • Look at connections between people/marriages as places (rather than people)
    • interesting people: Herber C Kendall and Brigham Young and Willard Richcards
Robbie Hott

Coming soon