base-data-manager/test/fixtures/fitbit-2026-02.md

fitbit-2026-02

Manual edits / notes

• Some many of these files are category-2020-04-13.json or .csv and then there's like 100 files. I had to manually delete all the extras and just keep one or two around. Im not keeping 2 for all of them because it's too much manual editing right now

• Social

  • badge.json kept some of the type names

• Sleep

  • sleep_score.csv Manually kept magnitude of last index as scrubber was not good at preserving that
  • sleep-xxx.json Pretty sure there are multiple shapes on this based on the type. In the UI it presents them differently (one showing just asleep/not asleep, the other showing like rem and such)
    • TODO - I only have one of the types in the export data in the fixture im pretty sure. Need to add the other one

• Physical Activity

  • time_in_heart_rate_zones-xxx.json WHY DOES THIS USE MM/DD/YY DATES, ughhhhh
  • swim_lengths_data-xxx.json I don't really swim so I dont know why there's so much data in here
  • sedentary_minutes-xxx.json Hmm, this one has a lot of 1440, even though I did not wear my fitbit for a lot of those days or it failed to sync, so probably just defaults... I see that in a lot of this data
  • resting_heart_rate-xxx.json Yeah... This one has a bunch of null objects in it. So if you want to parse any of this data, you're going to have to filter out all the days you weren't wearing your device manually
    • I also added an extra entry to this file for the nulls to show up in the export with
  • exercise-100.json These are weird, seems to be a suffix of like -\d+. Not really any specific pattern either, I only see 0 and 100 in here
  • distance-xxx.json This one seems to be minute-by-minute, but only for some minutes. It's kinda weird. Idk if these are supposed to be like number since last message, or number since last minute (but the last minute was missed), or what...
  • calories-xxx.json Why does the default value here seem to be 0.95 for everything, ugh
  • Active Zone Minutes - xxx.csv Added stuff the types back to this
    • UGH this uses 2020-04-13T10:10 for the times, wtf why

• Personal & Account

  • weight-xxx.json this uses MM/DD/YY and HH:MM:ss seperately. Manually had to fix

• Heart

  • afib_ppg_enrollment.csv Another off the wall date format Fri Dec 19 06:32:30 UTC 2025. Going to manually edit this

• Biometrics

  • Glucose xxx.csv no data in all of these. they're not even proper csvs when there's no data... ugh. The only info is that there's year and month inside the filename

• Google Data

  • There's so much overlap here with the other stuff, but some of it looks better handled, others don't
  • Physical Activity/daily_heart_rate_zones.csv - Fuck this file, JSON embedded in CSV why, they did not need to do this...