KJ7RRV

randomopendata

More #RandomOpenData! Feel free to use this data for whatever you would like. This data is published in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose.

This breaks the number of current FCC-issued US #HamRadio licenses by state and license class.

This data is obtained by scraping the ARRL's FCC License Counts page, which is in turn based on data published by the FCC.

Because this data will change over time, I included both the data in JSON format and a Python script to obtain the data. I update the JSON data when I think about it, but it's better to use the script to get the data yourself if you need it to be up to date.

Scraper program

#!/usr/bin/env python3

# ham_stats.py - get statistics on US amateur radio licenses by state and class
#
# Copyright 2023 Samuel Sloniker KJ7RRV
#
# Permission to use, copy, modify, and/or distribute this software for any
# purpose with or without fee is hereby granted.
#
# THE SOFTWARE IS PROVIDED “AS IS” AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH
# REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
# AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT,
# INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
# LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR
# OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
# PERFORMANCE OF THIS SOFTWARE.

import json
import datetime
import requests
import bs4

page = requests.get("http://www.arrl.org/fcc-license-counts")
soup = bs4.BeautifulSoup(page.text, features="lxml")

date = datetime.datetime.strptime(
    soup.find(id="content").find("em").text.split(" ")[-1], "%d-%b-%Y"
).strftime("%Y-%m-%d")

classes = [cell.text for cell in soup.find("tr")][1:]
table_data = {
    row.find("td").text.replace("*", ""): {
        classes[number]: int("0" + cell.text)
        for number, cell in enumerate(row.find_all("td")[1:])
    }
    for row in soup.find_all("tr")[1:]
}

print(json.dumps({"date": date, "data": table_data}))

Current data as of April 19, 2023

{"date": "2023-10-19", "data": {"Alabama": {"Novice": 67, "Tech": 5445, "Tech-Plus": 0, "General": 3158, "Advanced": 537, "Extra": 2882, "Total": 12089}, "Alaska": {"Novice": 15, "Tech": 1565, "Tech-Plus": 0, "General": 887, "Advanced": 147, "Extra": 661, "Total": 3275}, "Arizona": {"Novice": 112, "Tech": 11136, "Tech-Plus": 0, "General": 5121, "Advanced": 1002, "Extra": 4565, "Total": 21936}, "Arkansas": {"Novice": 39, "Tech": 4107, "Tech-Plus": 0, "General": 1960, "Advanced": 312, "Extra": 1616, "Total": 8034}, "California": {"Novice": 648, "Tech": 58946, "Tech-Plus": 0, "General": 19532, "Advanced": 3434, "Extra": 15521, "Total": 98081}, "Colorado": {"Novice": 90, "Tech": 10653, "Tech-Plus": 0, "General": 4555, "Advanced": 708, "Extra": 3748, "Total": 19754}, "Connecticut": {"Novice": 121, "Tech": 3122, "Tech-Plus": 0, "General": 1891, "Advanced": 387, "Extra": 1686, "Total": 7207}, "Delaware": {"Novice": 20, "Tech": 768, "Tech-Plus": 0, "General": 509, "Advanced": 86, "Extra": 416, "Total": 1799}, "District of Columbia": {"Novice": 4, "Tech": 254, "Tech-Plus": 0, "General": 114, "Advanced": 20, "Extra": 118, "Total": 510}, "Florida": {"Novice": 437, "Tech": 18293, "Tech-Plus": 0, "General": 11839, "Advanced": 2533, "Extra": 9971, "Total": 43073}, "Georgia": {"Novice": 110, "Tech": 8791, "Tech-Plus": 0, "General": 4971, "Advanced": 829, "Extra": 4101, "Total": 18802}, "Guam": {"Novice": 1, "Tech": 104, "Tech-Plus": 0, "General": 50, "Advanced": 8, "Extra": 102, "Total": 265}, "Hawaii": {"Novice": 29, "Tech": 2030, "Tech-Plus": 0, "General": 770, "Advanced": 146, "Extra": 687, "Total": 3662}, "Idaho": {"Novice": 28, "Tech": 6483, "Tech-Plus": 0, "General": 2535, "Advanced": 246, "Extra": 1618, "Total": 10910}, "Illinois": {"Novice": 257, "Tech": 8576, "Tech-Plus": 0, "General": 5290, "Advanced": 1010, "Extra": 4386, "Total": 19519}, "Indiana": {"Novice": 168, "Tech": 7240, "Tech-Plus": 0, "General": 4148, "Advanced": 717, "Extra": 3179, "Total": 15452}, "Iowa": {"Novice": 55, "Tech": 2987, "Tech-Plus": 0, "General": 1685, "Advanced": 403, "Extra": 1493, "Total": 6623}, "Kansas": {"Novice": 70, "Tech": 3381, "Tech-Plus": 0, "General": 1936, "Advanced": 289, "Extra": 1535, "Total": 7211}, "Kentucky": {"Novice": 72, "Tech": 4573, "Tech-Plus": 0, "General": 2546, "Advanced": 408, "Extra": 2025, "Total": 9624}, "Louisiana": {"Novice": 60, "Tech": 2623, "Tech-Plus": 0, "General": 1689, "Advanced": 335, "Extra": 1354, "Total": 6061}, "Maine": {"Novice": 38, "Tech": 1853, "Tech-Plus": 0, "General": 1261, "Advanced": 213, "Extra": 1107, "Total": 4472}, "Maryland": {"Novice": 100, "Tech": 4768, "Tech-Plus": 0, "General": 2811, "Advanced": 541, "Extra": 2662, "Total": 10882}, "Massachusetts": {"Novice": 147, "Tech": 5746, "Tech-Plus": 0, "General": 3487, "Advanced": 661, "Extra": 3275, "Total": 13316}, "Michigan": {"Novice": 176, "Tech": 9764, "Tech-Plus": 0, "General": 5349, "Advanced": 988, "Extra": 4675, "Total": 20952}, "Minnesota": {"Novice": 108, "Tech": 5280, "Tech-Plus": 0, "General": 2970, "Advanced": 600, "Extra": 2509, "Total": 11467}, "Mississippi": {"Novice": 23, "Tech": 2174, "Tech-Plus": 0, "General": 1359, "Advanced": 223, "Extra": 1262, "Total": 5041}, "Missouri": {"Novice": 98, "Tech": 7503, "Tech-Plus": 0, "General": 3866, "Advanced": 637, "Extra": 3079, "Total": 15183}, "Montana": {"Novice": 27, "Tech": 2244, "Tech-Plus": 0, "General": 1172, "Advanced": 171, "Extra": 821, "Total": 4435}, "Nebraska": {"Novice": 28, "Tech": 1697, "Tech-Plus": 0, "General": 1038, "Advanced": 221, "Extra": 752, "Total": 3736}, "Nevada": {"Novice": 37, "Tech": 4505, "Tech-Plus": 0, "General": 1888, "Advanced": 318, "Extra": 1527, "Total": 8275}, "New Hampshire": {"Novice": 52, "Tech": 2437, "Tech-Plus": 0, "General": 1489, "Advanced": 261, "Extra": 1480, "Total": 5719}, "New Jersey": {"Novice": 196, "Tech": 5944, "Tech-Plus": 0, "General": 3232, "Advanced": 710, "Extra": 3072, "Total": 13154}, "New Mexico": {"Novice": 27, "Tech": 3256, "Tech-Plus": 0, "General": 1469, "Advanced": 272, "Extra": 1332, "Total": 6356}, "New York": {"Novice": 400, "Tech": 11825, "Tech-Plus": 0, "General": 6805, "Advanced": 1363, "Extra": 5923, "Total": 26316}, "North Carolina": {"Novice": 145, "Tech": 10303, "Tech-Plus": 0, "General": 5876, "Advanced": 1018, "Extra": 5131, "Total": 22473}, "North Dakota": {"Novice": 10, "Tech": 743, "Tech-Plus": 0, "General": 419, "Advanced": 63, "Extra": 300, "Total": 1535}, "Ohio": {"Novice": 319, "Tech": 12255, "Tech-Plus": 0, "General": 7404, "Advanced": 1294, "Extra": 6107, "Total": 27379}, "Oklahoma": {"Novice": 44, "Tech": 5003, "Tech-Plus": 0, "General": 2527, "Advanced": 376, "Extra": 1985, "Total": 9935}, "Oregon": {"Novice": 101, "Tech": 11190, "Tech-Plus": 0, "General": 4967, "Advanced": 707, "Extra": 3578, "Total": 20543}, "Pennsylvania": {"Novice": 276, "Tech": 10644, "Tech-Plus": 0, "General": 6351, "Advanced": 1293, "Extra": 5579, "Total": 24143}, "Puerto Rico": {"Novice": 100, "Tech": 2917, "Tech-Plus": 0, "General": 1195, "Advanced": 172, "Extra": 702, "Total": 5086}, "Rhode Island": {"Novice": 21, "Tech": 837, "Tech-Plus": 0, "General": 486, "Advanced": 90, "Extra": 460, "Total": 1894}, "South Carolina": {"Novice": 59, "Tech": 4690, "Tech-Plus": 0, "General": 2732, "Advanced": 471, "Extra": 2361, "Total": 10313}, "South Dakota": {"Novice": 16, "Tech": 887, "Tech-Plus": 0, "General": 598, "Advanced": 116, "Extra": 485, "Total": 2102}, "Tennessee": {"Novice": 112, "Tech": 9281, "Tech-Plus": 0, "General": 5196, "Advanced": 813, "Extra": 4372, "Total": 19774}, "Texas": {"Novice": 293, "Tech": 26659, "Tech-Plus": 0, "General": 13308, "Advanced": 2289, "Extra": 11236, "Total": 53785}, "Utah": {"Novice": 35, "Tech": 12721, "Tech-Plus": 0, "General": 3267, "Advanced": 307, "Extra": 2133, "Total": 18463}, "Vermont": {"Novice": 14, "Tech": 973, "Tech-Plus": 0, "General": 526, "Advanced": 103, "Extra": 496, "Total": 2112}, "Virgin Islands": {"Novice": 0, "Tech": 117, "Tech-Plus": 0, "General": 71, "Advanced": 10, "Extra": 53, "Total": 251}, "Virginia": {"Novice": 179, "Tech": 9406, "Tech-Plus": 0, "General": 5353, "Advanced": 935, "Extra": 4804, "Total": 20677}, "Washington": {"Novice": 187, "Tech": 18746, "Tech-Plus": 0, "General": 8128, "Advanced": 1136, "Extra": 5717, "Total": 33914}, "West Virginia": {"Novice": 41, "Tech": 3054, "Tech-Plus": 0, "General": 1444, "Advanced": 213, "Extra": 1244, "Total": 5996}, "Wisconsin": {"Novice": 93, "Tech": 4802, "Tech-Plus": 0, "General": 3217, "Advanced": 561, "Extra": 2553, "Total": 11226}, "Wyoming": {"Novice": 10, "Tech": 1014, "Tech-Plus": 0, "General": 646, "Advanced": 114, "Extra": 471, "Total": 2255}, "Other": {"Novice": 1, "Tech": 284, "Tech-Plus": 0, "General": 95, "Advanced": 7, "Extra": 201, "Total": 588}, "TOTAL": {"Novice": 5916, "Tech": 376599, "Tech-Plus": 0, "General": 187188, "Advanced": 32824, "Extra": 155108, "Total": 757635}}}

#Programming #FOSS

This is the first of a series of posts of #RandomOpenData. These posts will contain public-domain data in JSON and other readily-usable, machine-readable formats.

Feel free to use this data for whatever you would like. This data is published in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose.

Array of state names

["Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming"]

Array of state abbreviations

["AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DE", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NB", "NV", "NH", "NJ", "NM", "NY", "NC", "ND", "OH", "OK", "OR", "PA", "RI", "SC", "SD", "TN", "TX", "UT", "VT", "VA", "WA", "WV", "WI", "WY"]

Dictionary of states to abbreviations

{"Alabama": "AL", "Alaska": "AK", "Arizona": "AZ", "Arkansas": "AR", "California": "CA", "Colorado": "CO", "Connecticut": "CT", "Delaware": "DE", "Florida": "FL", "Georgia": "GA", "Hawaii": "HI", "Idaho": "ID", "Illinois": "IL", "Indiana": "IN", "Iowa": "IA", "Kansas": "KS", "Kentucky": "KY", "Louisiana": "LA", "Maine": "ME", "Maryland": "MD", "Massachusetts": "MA", "Michigan": "MI", "Minnesota": "MN", "Mississippi": "MS", "Missouri": "MO", "Montana": "MT", "Nebraska": "NB", "Nevada": "NV", "New Hampshire": "NH", "New Jersey": "NJ", "New Mexico": "NM", "New York": "NY", "North Carolina": "NC", "North Dakota": "ND", "Ohio": "OH", "Oklahoma": "OK", "Oregon": "OR", "Pennsylvania": "PA", "Rhode Island": "RI", "South Carolina": "SC", "South Dakota": "SD", "Tennessee": "TN", "Texas": "TX", "Utah": "UT", "Vermont": "VT", "Virginia": "VA", "Washington": "WA", "West Virginia": "WV", "Wisconsin": "WI", "Wyoming": "WY"}

Dictionary of abbreviations to states

{"AL": "Alabama", "AK": "Alaska", "AZ": "Arizona", "AR": "Arkansas", "CA": "California", "CO": "Colorado", "CT": "Connecticut", "DE": "Delaware", "FL": "Florida", "GA": "Georgia", "HI": "Hawaii", "ID": "Idaho", "IL": "Illinois", "IN": "Indiana", "IA": "Iowa", "KS": "Kansas", "KY": "Kentucky", "LA": "Louisiana", "ME": "Maine", "MD": "Maryland", "MA": "Massachusetts", "MI": "Michigan", "MN": "Minnesota", "MS": "Mississippi", "MO": "Missouri", "MT": "Montana", "NB": "Nebraska", "NV": "Nevada", "NH": "New Hampshire", "NJ": "New Jersey", "NM": "New Mexico", "NY": "New York", "NC": "North Carolina", "ND": "North Dakota", "OH": "Ohio", "OK": "Oklahoma", "OR": "Oregon", "PA": "Pennsylvania", "RI": "Rhode Island", "SC": "South Carolina", "SD": "South Dakota", "TN": "Tennessee", "TX": "Texas", "UT": "Utah", "VT": "Vermont", "VA": "Virginia", "WA": "Washington", "WV": "West Virginia", "WI": "Wisconsin", "WY": "Wyoming"}

#Programming #FOSS