SQL Filter for Service UUID Exposure Notification

ble-covid19-filter.sql

SELECT
    datetime(locations.timestamp, 'unixepoch', 'localtime') AS 'Timestamp', 
    devices.service_data AS 'R. Prox. Identifier',
    locations.rssi AS 'RSSI',
    locations.latitude AS 'Latitude',
    locations.longitude AS 'Longitude'
FROM
    devices
INNER JOIN locations ON devices.id = locations.device_id
WHERE
    devices.service_data LIKE 'fd6f:%'
ORDER BY
    locations.timestamp;