SQLite Recorder Data Location in home-assistant_v2.db

I’ve created an MQTT link to HASSIO using Ambient temperature sensors and and Arduino Uno. During testing, I had the temperature readings initialized to 212F for the first reading. Well, the recorder recorded that and now I wish to remove those readings from the recorder data. I downloaded SQLite and connected to \\config\home-assistant_v2.db using Samba Share. I opened the database I can see the tables and would assume the data would be located under recorder_runs. But I can’t seem to find it. Where would I look to either edit or delete those temperature records? Am I not looking in the correct place? How can I delete those erroneous records?

You could probably use the purge functionality of the recorder somehow?

It does purge, but I’d rather get to the data especially during testing because it really throws off the graphsfridge


I have tried to stop hassio and delete the database several times.

The home-assistant.db is just created again automatic with the same date time “18. ‎oktober ‎2018, ‏‎14:23:47”

This is a error in the log file:

2018-10-18 13:42:41 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.OperationalError) no such table: events [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)'] [parameters: ('state_changed', '{"entity_id": "zwave.kontakt_varmtvannstank_switch", "old_state": {"entity_id": "zwave.kontakt_varmtvannstank_switch", "state": "initializing", "attr ... (1682 characters truncated) ... T11:40:57.632202+00:00", "last_updated": "2018-10-18T11:42:40.991981+00:00", "context": {"id": "ad04a1e5d4d1457a8b2d0b97f8b210cd", "user_id": null}}}', 'LOCAL', '2018-10-18 11:42:40.992238', '2018-10-18 11:42:41.069784', 'ad04a1e5d4d1457a8b2d0b97f8b210cd', None)] (Background on this error at: http://sqlalche.me/e/e3q8)