====== Project Wifi Scanner: Data Scan 2 ======
I imported and prepared the data as described on the [[Projects/Wifi Scanner]] page.

The main date range is 1st Nov 2019 to Dec 31st 2019 (but also includes up to Jan 5th 2020).

Extracting a basic count of all activity:
<code sql>
select count(mac), date(seen_time) from wifi_data where date(seen_time) between '2019-11-01' and '2020-01-06' group by date(seen_time);
</code>
Extracting a basic count of all unique devices:
<code sql>
select count(distinct mac), date(seen_time) from wifi_data where date(seen_time) between '2019-11-01' and '2020-01-06' group by date(seen_time);
</code>