To Do

1. LATER Look up phpmyadmin for Joseph to use interacting with Database
2. DONE Organize the database
   • Worthy sent schema documents (or use UML-like syntax)
   • Build schema, then present to Worthy and Kathleen
   • Write script that copies data from the current organization (Jill’s DB) to our new schema
   • Update visualizations and api accordingly
3. DONE: Email Jill and ask what the problems were with the dates
   • Specifically note that not asking for work to be done, but asking for what happened so we can take care of it on our end.
4. DONE: Add duplicate field to person table (those that are duplicates will point to the original person)
5. Prepare abstract for University of Kansas Digital Humanities Forum: Deadline June 15
   • Provide a sentence on one or two directions the paper may go in along with the general information on the meeting
   • We have this marriage data, this humanities question, and we want to look at and analyze that data in cool ways (maybe include sankey or chord diagram, if possible). Kathleen would have to craft some of the humanities side of the abstract.

Interesting Names

• Mercy and Mary Fielding
• Robert Blashel Thompson (40865)
• Hyrum Smith (20563)
• Williard Richards
• Franklin D Richards (Son of Phineas Richards)
  • id: 468
  • Elizabeth Fate

Interesting Viz

• Brigham Young, Orson Spenser, and Albert Carrington, who’s children marry link
• Same as above, but including BY Jr link

Database Organization

Fields to consider about each person:

• Display Name
• Authoritative Name
• Alternate Name and Type w/ prefix and suffix
• Birth
• Birth Place
• Death
• Death Place
• Nonmember
• Baptism
• Baptism Place
• Baptism Officiator
• Baptism Proxy
• Male Priesthood Office
• Male Church Office
• Female Church Office
• RS date
• Washing and Anointing
• Endowment
• Marriage Time
• M Sealed Eternity
• M Sealed Time
• Officiator
• Proxy
• Child Natural
• Parent Natural Child
• Child Adopted - Multiple
• Second Anointing
• Divorce
• Cancellation
• Pioneer Company
• Pioneer Company Office
• Nauvoo Plat or Address
• Mission Date
• Mission Place
• Private Note Fields
• Private Note Fields
• Image
• Journal (T/F)

Also need to consider the following changes:

• Need alternate names
  • First, Middle, Last, Prefix, Suffix, Type
  • Type defines what kind of name it is:
    1. Maiden name
    2. Alternate Spelling
    3. Display Name
    4. Authoritative Name
  • Want a display name, authoritative name, and alternate names
• Separate events table that has significant life events
  • Could have just a baptism table
  • Data that would go inside this/these table(s)
    1. Baptisms: dates, officiator, participants, proxies, etc
    2. Marriages
    3. Sealings
• Always have note fields
  • Private Notes: note to self to add to the table
  • Public Notes: interesting notes that are available to the public
• Want to add a “Not a member of LDS” field
• Companies in crossing the plains
  • People had titles, this needs to be added to the entries
  • Who was in the office of the company? Who were the officers and what titles did they have?

Discussion

1. Sankey: Need to split people. For example, Mercy Fielding was married to Hyrum Smith and Robert Thompson during her lifetime.
2. Getting the Anointed Quorum together (Joseph is getting the list).

Publication Venues

University of Kansas Digital Humanities Forum: Deadline June 15