Invalid state of some sensor: how to check it in DB?

Configuration
5

Thank you so much.
By “issue” I meant a “question”, “point” (wrong translation from Russian).

As for editing a wrong value in DB - I am thinking about not the best but working variant:

  1. Stop HA container.
  2. Move db-file to some shared folder.
  3. Move db-file from this shared folder on some Windows-machine.
  4. Open db-file in SQLite Expert.
  5. Open a table with states.
  6. Filter a “state” column with “99999” value (found 1 record with an expected timestamp).
  7. Manually edit a “state” value.
  8. Move db-file back to it’s place.
  9. Start HA.

This is not a statistical data, so I could just wait for 10 days…

Same method was also used to fix statistics.