Extract recorded geolocations of a given tracker

Configuration
1

I’m a newbie to HA.
I have a fon configured to send geolocations via the companion app.
I would like to extract this information directly from the database via SQLite with a statement similar to:

SELECT WhatEverFields FROM WhatEverTable
WHERE entity_id = ‘DEVICE_TRACKER_ID’
AND last_updated BETWEEN ‘START_TIME’ AND ‘END_TIME’;

result should be a table of the geolocations for this specific tracker that are recorded in the given time interval.

Any ideas?

TIA, mpe42

2

I can’t help with the tables and fields but be aware that the SQL sensor state value is limited to a maximum of 255 characters.

4

isn’t there really anyone having a knowledge of the structure of the database?
Is there any documentation available? I can “read” databases if I have an idea what “page”…
any developer?