Capturing Switch States about ltss HOT 2 CLOSED

SELECT * FROM ltss WHERE entity_id LIKE 'switch.%' AND time BETWEEN NOW()-'24h'::interval AND NOW();;
             time              |              entity_id               |    state    |                     attributes                     | location 
-------------------------------+--------------------------------------+-------------+----------------------------------------------------+----------
 2024-05-13 14:29:21.435496+00 | switch.adguard_home_protection       | on          | {"friendly_name": "AdGuard Home Protection"}       | 
 2024-05-13 14:29:21.64909+00  | switch.adguard_home_parental_control | off         | {"friendly_name": "AdGuard Home Parental control"} | 
 2024-05-13 14:29:21.970905+00 | switch.adguard_home_safe_search      | off         | {"friendly_name": "AdGuard Home Safe search"}      | 
 2024-05-13 14:29:22.29841+00  | switch.adguard_home_query_log        | on          | {"friendly_name": "AdGuard Home Query log"}        | 
 2024-05-13 14:29:22.07979+00  | switch.adguard_home_safe_browsing    | off         | {"friendly_name": "AdGuard Home Safe browsing"}    | 
 2024-05-13 14:29:22.189361+00 | switch.adguard_home_filtering        | on          | {"friendly_name": "AdGuard Home Filtering"}        | 
 2024-05-13 14:50:42.931188+00 | switch.p1_meter_cloud_connection     | unavailable | {"friendly_name": "P1 meter Cloud connection"}     | 
 2024-05-13 14:50:49.445734+00 | switch.p1_meter_cloud_connection     | on          | {"friendly_name": "P1 meter Cloud connection"}     | 
 2024-05-13 21:36:32.344857+00 | switch.adguard_home_safe_search      | off         | {"friendly_name": "AdGuard Home Safe search"}      | 
 2024-05-13 21:36:31.382792+00 | switch.p1_meter_cloud_connection     | on          | {"friendly_name": "P1 meter Cloud connection"}     | 
 2024-05-13 21:36:31.807034+00 | switch.adguard_home_protection       | on          | {"friendly_name": "AdGuard Home Protection"}       | 
 2024-05-13 21:36:32.021015+00 | switch.adguard_home_parental_control | off         | {"friendly_name": "AdGuard Home Parental control"} | 
 2024-05-13 21:36:32.464407+00 | switch.adguard_home_safe_browsing    | off         | {"friendly_name": "AdGuard Home Safe browsing"}    | 
 2024-05-13 21:36:32.688528+00 | switch.adguard_home_query_log        | on          | {"friendly_name": "AdGuard Home Query log"}        | 
 2024-05-13 21:36:32.579823+00 | switch.adguard_home_filtering        | on          | {"friendly_name": "AdGuard Home Filtering"}        | 
 2024-05-13 21:46:29.681763+00 | switch.p1_meter_cloud_connection     | on          | {"friendly_name": "P1 meter Cloud connection"}