AE7Q new license counts #114

New Issue

matt · 2024-02-28T14:16:46-06:00

matt commented

2024-02-28 14:16:46 -06:00

To track new licenses over time, can we scrape the table under "Retrieving license grants issued on"? Note the date in the URL for easy downloading.

https://www.ae7q.com/query/list/ProcessDate.php?DATE=2024-2-02

This goes back to one of the W5YI Report comments that the only way to really measure growth is to measure the number of new hams.

To track new licenses over time, can we scrape the table under "Retrieving license grants issued on"? Note the date in the URL for easy downloading. https://www.ae7q.com/query/list/ProcessDate.php?DATE=2024-2-02 This goes back to one of the W5YI Report comments that the only way to really measure growth is to measure the number of new hams.

W1CDN commented

2024-04-21 21:23:54 -05:00

Looks like new license info goes back to 1994-05-24, but renewals and callsign changes aren't being tracked: https://www.ae7q.com/query/list/ProcessDate.php?DATE=1994-05-24

Looks like renewals started being tracked on 1999-08-28: https://www.ae7q.com/query/list/ProcessDate.php?DATE=1999-08-28

Sometime in 2001, vanity callsigns added to that table.

Table structure seems consistent over time.

Looks like new license info goes back to 1994-05-24, but renewals and callsign changes aren't being tracked: https://www.ae7q.com/query/list/ProcessDate.php?DATE=1994-05-24 Looks like renewals started being tracked on 1999-08-28: https://www.ae7q.com/query/list/ProcessDate.php?DATE=1999-08-28 Sometime in 2001, vanity callsigns added to that table. Table structure seems consistent over time.

W1CDN added the

data-new

label 2024-09-16 11:44:22 -05:00

W1CDN commented

2024-09-21 13:07:08 -05:00

I summarized down to here so far. How should I structure the final CSV file?

Shared on fedi: https://mastodon.radio/@W1CDN/113176909232406655

I summarized down to here so far. How should I structure the final CSV file? Shared on fedi: https://mastodon.radio/@W1CDN/113176909232406655 ![](/attachments/e8f9c8aa-1d81-4623-bb94-fbdd3c177ead)

image.png

186 KiB

W1CDN commented

2024-09-21 13:14:45 -05:00

"License Status" is current status of that license as of query date, so if you query back a ways, you will see lots of expired licenses, which isn't indicative of what the status was on that date.

Looks like SYSGRT was introduced on https://www.ae7q.com/query/list/ProcessDate.php?DATE=2004-11-29.

"License Status" is *current* status of that license as of query date, so if you query back a ways, you will see lots of expired licenses, which isn't indicative of what the status was on that date. Looks like SYSGRT was introduced on https://www.ae7q.com/query/list/ProcessDate.php?DATE=2004-11-29.

W1CDN commented

2024-09-21 19:19:30 -05:00

Basics are here, data is in since 2024-08-01.
Need to add plot(s) to readme when I have more data.
81e5fbef6c

Basics are here, data is in since 2024-08-01. Need to add plot(s) to readme when I have more data. https://amiok.net/gitea/W1CDN/ham-radio-licenses/commit/81e5fbef6c12ba59337f063b36d534e6b44aa69c

W1CDN commented

2024-09-21 22:39:53 -05:00

Added one plot to readme, will download historical data over time, new data scraped daily as part of cron job.

Sign in to join this conversation.