Skip to content

Instantly share code, notes, and snippets.

Avatar

Torsten Mohrbach tmohrbach

View GitHub Profile
@tmohrbach
tmohrbach / ble-covid19-filter.sql
Last active Jul 16, 2020
SQL Filter for Service UUID Exposure Notification
View 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