Personal data project

Three years of habit tracking

Since January 2023 I have logged daily habits — sleep, routine, study, chores — in Loop Habit Tracker. This is what the data says, analysed with a Python pipeline and Postgres. The underlying records stay private; what follows are the findings.

trend

How regular my bedtime is

Measured as the average distance from each month's typical bedtime, the most consistent month varied by 0.6 hours (2024-05); the latest sits at 1.2. This is a spread, not a time -- it says how steady the routine is without saying when it happens.

The query behind this
SELECT r.entry_date, r.value
        FROM repetitions r
        JOIN habits h ON h.id = r.habit_id
        WHERE h.unit = 'HH:MM' AND h.name ILIKE '%sleep%' AND r.value IS NOT NULL
        ORDER BY r.entry_date