home / james_garmin

sleep

3,662 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: avg_spo2, avg_rr, qualifier, day (date), start (date), end (date)

day ▼ start end total_sleep deep_sleep light_sleep rem_sleep awake avg_spo2 avg_rr avg_stress score qualifier
2015-11-30     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-01     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-02     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-03     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-04     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-05     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-06     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-07     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-08     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-09     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-10     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-11     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-12     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-13     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-14     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-15     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-16     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-17     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-18     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-19     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-20     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-21     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-22     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-23     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-24     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-25     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-26     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-27     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-28     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-29     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-30     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2015-12-31     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-01     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-02     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-03     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-04     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-05     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-06     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-07     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-08     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-09     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-10     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-11     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-12     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-13     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-14     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-15     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-16     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-17     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-18     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-19     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-20     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-21     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-22     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-23     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-24     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-25     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-26     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-27     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-28     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-29     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-30     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-01-31     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-01     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-02     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-03     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-04     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-05     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-06     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-07     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-08     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-09     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-10     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-11     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-12     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-13     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-14     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-15     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-16     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-17     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-18     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-19     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-20     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-21     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-22     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-23     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-24     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-25     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-26     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-27     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-28     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-02-29     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-01     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-02     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-03     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-04     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-05     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-06     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-07     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          
2016-03-08     00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000          

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE sleep (
	day DATE NOT NULL, 
	start DATETIME, 
	"end" DATETIME, 
	total_sleep TIME NOT NULL, 
	deep_sleep TIME NOT NULL, 
	light_sleep TIME NOT NULL, 
	rem_sleep TIME NOT NULL, 
	awake TIME NOT NULL, 
	avg_spo2 FLOAT, 
	avg_rr FLOAT, 
	avg_stress FLOAT, 
	score INTEGER, 
	qualifier VARCHAR, 
	PRIMARY KEY (day)
);
Powered by Datasette · Queries took 47.399ms