AE7Q new license counts #114
Loading…
Reference in New Issue
Block a user
No description provided.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
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.
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.
I summarized down to here so far. How should I structure the final CSV file?
Shared on fedi: https://mastodon.radio/@W1CDN/113176909232406655
"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.
Basics are here, data is in since 2024-08-01.
Need to add plot(s) to readme when I have more data.
81e5fbef6cAdded one plot to readme, will download historical data over time, new data scraped daily as part of cron job.
This script wasn't working, but I think is fixed in
1b58d335f8. It needs to query the previous date, not the current date.