https://neil.mckillop.org/ 2026-04-30T22:31:41+0100 https://neil.mckillop.org/ https://neil.mckillop.org/lib/tpl/dokuwiki/images/favicon.ico text/html 2019-10-11T17:45:36+0100 Anonymous (anonymous@undisclosed.example.com) https://neil.mckillop.org/projects/wifi/scan_1?rev=1570812336&do=diff Project Wifi Scanner: Data Scan 1 I was curious to see how much I could detect with an off the shelf setup (standard PCIe wifi card with an external 10cm antenna) running in my living room for a week. Here are the numbers so far: Raw size: 2,077,031,816 bytes (2.0Gb) (14,991,993 lines of tcpdump data) text/html 2020-04-01T03:23:07+0100 Anonymous (anonymous@undisclosed.example.com) https://neil.mckillop.org/projects/wifi/scan_2?rev=1585707787&do=diff Project Wifi Scanner: Data Scan 2 I imported and prepared the data as described on the 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: 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); text/html 2020-04-16T00:09:28+0100 Anonymous (anonymous@undisclosed.example.com) https://neil.mckillop.org/projects/wifi/scan_3?rev=1586992168&do=diff Project Wifi Scanner: Data Scan 3a Full scan of Feb 1st to April 10th 2020 - are people self isolating for COVID-19? Seems so. I loaded data in as below. Then exported the basics to a CSV in MySQL: SELECT DATE(seen_time),COUNT(DISTINCT mac) FROM simple_data WHERE DATE(seen_time) BETWEEN '2020-02-01' AND '2020-04-31' GROUP BY DATE(seen_time) INTO OUTFILE '/tmp/feb-apr-plot.csv'