Skip to content

Instantly share code, notes, and snippets.

@bessarabov
Created November 26, 2020 09:57
Show Gist options
  • Save bessarabov/e578b8096fe2ee60f6a62df0176734ac to your computer and use it in GitHub Desktop.
Save bessarabov/e578b8096fe2ee60f6a62df0176734ac to your computer and use it in GitHub Desktop.
sqlite> select state, created from states where entity_id = 'sensor.0x00158d000309a2c3_temperature' order by created desc limit 100;
state|created
25.75|2020-11-26 09:34:15.002952
25.75|2020-11-26 09:34:14.980620
25.87|2020-11-26 09:34:14.977223
25.87|2020-11-26 09:22:00.327637
25.87|2020-11-26 09:22:00.302111
25.82|2020-11-26 09:22:00.299691
25.82|2020-11-26 09:18:59.082958
25.82|2020-11-26 09:18:59.041144
25.82|2020-11-26 09:18:59.037892
25.68|2020-11-26 09:18:59.034479
25.68|2020-11-26 09:12:35.995193
25.31|2020-11-26 09:12:35.991758
25.31|2020-11-26 09:06:03.341156
25.31|2020-11-26 09:06:03.302921
25.28|2020-11-26 09:06:03.297481
25.28|2020-11-26 09:05:12.743875
25.28|2020-11-26 09:05:12.710135
25.26|2020-11-26 09:05:12.703480
25.26|2020-11-26 09:04:52.387726
25.26|2020-11-26 09:04:52.381956
25.26|2020-11-26 09:04:52.355483
24.98|2020-11-26 09:04:52.351731
24.98|2020-11-26 08:58:49.880769
24.98|2020-11-26 08:58:49.838488
24.97|2020-11-26 08:58:49.832712
24.97|2020-11-26 08:58:19.396927
24.97|2020-11-26 08:58:19.375358
24.95|2020-11-26 08:58:19.372988
24.95|2020-11-26 08:58:09.105577
24.95|2020-11-26 08:58:09.063455
24.95|2020-11-26 08:58:09.040791
24.91|2020-11-26 08:58:09.035145
24.91|2020-11-26 08:57:58.769178
24.91|2020-11-26 08:57:58.761524
24.91|2020-11-26 08:57:58.720161
24.87|2020-11-26 08:57:58.713460
24.87|2020-11-26 08:54:37.242543
24.87|2020-11-26 08:54:37.237793
24.87|2020-11-26 08:54:37.206054
24.85|2020-11-26 08:54:37.203099
24.85|2020-11-26 08:54:26.968267
24.85|2020-11-26 08:54:26.957856
24.85|2020-11-26 08:54:26.932445
24.87|2020-11-26 08:54:26.928985
24.87|2020-11-26 08:31:48.317798
24.87|2020-11-26 08:31:48.307994
24.87|2020-11-26 08:31:48.298146
24.87|2020-11-26 08:17:02.167050
24.91|2020-11-26 08:17:02.162228
24.91|2020-11-26 07:45:00.160731
24.91|2020-11-26 07:45:00.144837
24.84|2020-11-26 07:45:00.142311
24.84|2020-11-26 07:20:30.968169
24.84|2020-11-26 07:20:30.938984
24.84|2020-11-26 07:20:30.900600
24.85|2020-11-26 07:20:30.894953
24.85|2020-11-26 07:19:19.814136
24.95|2020-11-26 07:19:19.810345
24.95|2020-11-26 07:00:22.572114
24.95|2020-11-26 07:00:22.568495
25.08|2020-11-26 07:00:22.565099
25.08|2020-11-26 06:37:54.165348
25.08|2020-11-26 06:37:54.158810
25.08|2020-11-26 06:37:54.120434
25.11|2020-11-26 06:37:54.115744
25.11|2020-11-26 06:37:43.874193
25.11|2020-11-26 06:37:43.867435
25.11|2020-11-26 06:37:43.827320
25.15|2020-11-26 06:37:43.822396
25.15|2020-11-26 06:32:21.594064
25.15|2020-11-26 06:32:21.587879
25.15|2020-11-26 06:32:21.548486
25.21|2020-11-26 06:32:21.540788
25.21|2020-11-26 06:27:49.173073
25.55|2020-11-26 06:27:49.169471
25.55|2020-11-26 05:54:16.803056
25.55|2020-11-26 05:54:16.797315
25.55|2020-11-26 05:54:16.794417
25.76|2020-11-26 05:54:16.790023
25.76|2020-11-26 05:37:09.981295
25.99|2020-11-26 05:37:09.976735
25.99|2020-11-26 05:20:13.660877
25.99|2020-11-26 05:20:13.658889
25.45|2020-11-26 05:20:13.656526
25.45|2020-11-26 05:01:06.523427
25.45|2020-11-26 05:01:06.520020
24.88|2020-11-26 05:01:06.516630
24.88|2020-11-26 04:47:11.230753
24.88|2020-11-26 04:47:11.194496
24.8|2020-11-26 04:47:11.187838
24.8|2020-11-26 04:46:20.606993
24.8|2020-11-26 04:46:10.368509
24.8|2020-11-26 04:46:10.345096
24.8|2020-11-26 04:46:10.325239
24.73|2020-11-26 04:46:10.322893
24.73|2020-11-26 04:43:58.767552
24.7|2020-11-26 04:43:58.760711
24.7|2020-11-26 03:47:27.252633
24.75|2020-11-26 03:47:27.247906
24.75|2020-11-26 03:39:44.242464
sqlite>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment