http://simonwillison.net/2019-07-22T03:34:38+00:00Simon Willison2019-07-22T03:34:38+00:002019-07-22T03:34:38+00:00https://simonwillison.net/2019/Jul/22/healthkit-sqlite/#atom-tag

<p><strong><a href="https://github.com/dogsheep/healthkit-to-sqlite">healthkit-to-sqlite</a></strong></p> Ever since I got an Apple Watch I’ve been itching to get my hands on the step tracking and health data that it’s been collecting for me. I know it’s there in a SQLite database on my wrist, but I couldn’t figure out how to get it! A few days ago I stumbled across the “Export Health Data” button in the iOS Health app, and it turns out it creates a zip file containing XML with a full dump of the data collected by Apple Health. healthkit-to-sqlite is the tool I’ve built that can read that export and use it to create a SQLite database ready to be queried and explored with Datasette. It’s a pretty basic implementation but it’s already giving me access to over 3 million rows of data. Lots of potential here for interesting work with personal analytics. <p>Tags: <a href="https://simonwillison.net/tags/health">health</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/datasette">datasette</a>, <a href="https://simonwillison.net/tags/dogsheep">dogsheep</a></p>

2007-07-01T21:22:45+00:002007-07-01T21:22:45+00:00https://simonwillison.net/2007/Jul/1/google/#atom-tag

<p><strong><a href="http://google-health-ads.blogspot.com/2007/07/my-opinion-and-googles.html">Google Health Advertising Blog: My opinion and Google&#x27;s</a></strong></p> A follow up to the post I linked to earlier. <p><small></small>Via <a href="http://www.techcrunch.com/2007/07/01/google-faux-pas-retracted/">TechCrunch</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/google">google</a>, <a href="https://simonwillison.net/tags/google-health">google-health</a>, <a href="https://simonwillison.net/tags/health">health</a>, <a href="https://simonwillison.net/tags/sicko">sicko</a></p>