David A. Windham
david
/
til
1
0
Fork 0
Files
Branch: dev
Branches Tags
til
/
notes
/
health
/
health.md

health.md 5.1 KB
Permalink History Raw

Health

TOC

diet | health | mental

Log

  • 24/12/16 - added an Apple Watch mainly for biometric feedback. will figure out an easy way to automate and export every so often so I can store it here.
  • 24/12/07 - hip injury ( IT band muscles / labral ) likely related to playing tennis - need to consider a more wholistic and low impact regular excersize routine like walking, swimming, pilates, & yoga.
  • 23/12/17 - added a Diet log.
  • 23/12/17 - added a ^ sleep log.
  • 23/12/17 - bout that time of year to start thinking about losing weight so I spent some time this morning converting my health status downloads to a decent format and I figured I'd update this page and figure out a way to keep them in sync.

^ keeping some items private via draft status and .gitignore ( No worries, I'm pretty sure my health insurer is getting a pretty good deal anyway )

Todo

  • lose 15 lbs
  • Shingles Vaccine

Status

  • Age: 50
  • Medications: none ✅ ( trying to keep it this way )
    • occasionally take aspirin
  • Weight: Current: 190 lbs ( Healthy BMI is 130-175 / Ideal - 160 ❌ Target 🎯 - 175)
  • Blood Pressure: 110/70 (23/10/31 - good ✅ )
  • HDL cholesterol: 38mg/dL ( Low ❌ 40-60 mg/dL ) Ratio 4.1 ( Normal ✅ < 4.5 )
    • lose weight 😢 < 15lbs / exercise more
    • more fish/flax/greens & less sugar/carbs
    • possible familial mixed hyperlipidemia ( inherited )
  • LDL cholesterol: Calculated 89 ( Normal ✅ < 129mg/dL )
  • Cholesterol: Calculated - 150 ( Normal ✅ < 200mg/dL )
  • Triglycerides: 130 ( Normal ✅ < 150mg/dL )
  • TSH: 1.654 ( Normal )
  • Urinalysis: ( Normal ✅ 0.550 - 4.780 uIU/mL )
  • Blood Other:
    • previously had high C-reactive proteins indicating inflammation/infection
  • Skin: Too much sun from tennis via dermatologist
  • Colon: clear ✅ 23/05/20 ( doc recommended early since family history )

( Last Metabolic Panel 23/05/18 )

Genetic

  • Age-related macular degeneration ( DNA test )
  • diabetes ( dad's )
  • colon/intestine ( mom's )

TOC

Physical

Diet | exercise | sleep | genetics

Environment

house | weather | air quality | clothing | shoes

Mental

mindset | play | learn | social | meditation | spirit

About

23/12/17 - I'd just like to keep some notes along the way so I have a reference. I'm just like everyone else about this time of year. I have a pretty holistic sorta mindset on health even though I've found myself with some weaknesses over the years. I smoked cigarettes in college and for a few years following. I'm in pretty good shape right now, but I come from a long line of plump little Welshmen so I'm privy to indulge. My eyes have suffered in recent years from screen time and the only DNA marker risk I have is macular degeneration. My dad and a couple of his brothers have onset diabetes so I'm going to try and avoid it altogether with exercise and diet. In regards to wholistic, I find it odd that folks will wear a device to track the thirty minutes of steps they do a day and ignore the other 1410 minutes. Aside from genetics, I think the most important impact on health is your routine, especially lifestyle, diet, sleep, and exercise so I'll start by logging some of those.

Sync

I noticed a project not too long ago on Github that allows for an open-source export of your medical data from MyChart and others. Would like to explore that at some point so I could just sync the blood, lipid panel, and other tests... so I can move that data around at will mainly because I like the control and I think there will end up being decent AI diagnostic tools available in the future.

related

Parsing Apple Health data

If you’ve ever wanted to analyze your own health data, here’s how.

Exporting as XML
  1. Open the Health app.
  2. Tap on your profile in the top right.
  3. Tap Export All Health Data.
  4. Share the archive with yourself (e.g. via AirDrop, Files, Mail, etc.).

Within the archive, you’ll find export.xml. This is where the main metrics are stored.

Converting to JSON

If you open export.xml, you'll see most of the interesting data is contained in the attributes of Record elements. So let's make a small Python script to convert those attributes to JSON.

Save the following to a file called parse.py:

import json
import sys
from xml.etree.ElementTree import iterparse

for _, elem in iterparse(sys.argv[1]):
    if elem.tag == "Record":
        print(json.dumps(elem.attrib))

Then run:

python parse.py export.xml

You should immediately start seeing the data in your terminal.

Converting to CSV

Using jq, we can convert the JSON to CSV:

python parse.py export.xml | jq -r '[.endDate, .type, .unit, .value] | @csv'

If you prefer TSV (e.g. for processing with cut), replace @csv by @tsv.

Save the data to a file and analyze with your favorite software.