gistfile1.txt

sqlite> select state_id, created, state from states where entity_id = 'sensor.0x04cf8cdf3c77656a_illuminance' and created > '2021-03-24 01' order by state_id limit 40;
state_id    created                     state
----------  --------------------------  ----------
15748089    2021-03-24 02:33:23.770811  0
15751204    2021-03-24 03:00:33.952611  0
15751482    2021-03-24 03:03:23.234313  0
15751485    2021-03-24 03:03:23.238100  3011
15751830    2021-03-24 03:06:22.438813  3011
15751833    2021-03-24 03:06:22.440488  4772
15752210    2021-03-24 03:09:46.574502  4772
15752213    2021-03-24 03:09:46.578411  6021
15752551    2021-03-24 03:12:45.886183  6021
15752554    2021-03-24 03:12:45.889916  6990
15752819    2021-03-24 03:15:00.304859  6990
15752826    2021-03-24 03:15:00.306401  7782
15752851    2021-03-24 03:15:15.223335  7782
15752854    2021-03-24 03:15:15.227417  6990
15752898    2021-03-24 03:15:30.162729  6990
15752903    2021-03-24 03:15:30.166756  7782
15752929    2021-03-24 03:15:50.083620  7782
15752934    2021-03-24 03:15:50.087442  6990
15752961    2021-03-24 03:16:05.023674  6990
15752966    2021-03-24 03:16:05.027546  7782
15753064    2021-03-24 03:17:04.779120  7782
15753067    2021-03-24 03:17:04.782762  8451
15753095    2021-03-24 03:17:19.717292  8451
15753098    2021-03-24 03:17:19.721619  7782
15753139    2021-03-24 03:17:39.629153  7782
15753142    2021-03-24 03:17:39.630787  8451
15753304    2021-03-24 03:19:14.318419  8451
15753307    2021-03-24 03:19:14.321973  9031
15753456    2021-03-24 03:20:33.917278  9031
15753459    2021-03-24 03:20:33.920791  9543
15753483    2021-03-24 03:20:48.858104  9543
15753486    2021-03-24 03:20:48.862300  9031
15753516    2021-03-24 03:21:03.794927  9031
15753519    2021-03-24 03:21:03.798806  9543
15753722    2021-03-24 03:23:14.240546  9543
15753728    2021-03-24 03:23:14.246439  10414
15753979    2021-03-24 03:25:37.699812  10414
15753982    2021-03-24 03:25:37.703482  11140
15754160    2021-03-24 03:27:17.238005  11140
15754164    2021-03-24 03:27:17.241870  11761
sqlite>