cQ, cQ, come in hamfags

>>2526990 (#3188)

I ran the entire 2014-2017 fed employee database against the entire FCC amateur (ham) radio license database, matching by state, first name, last name, and middle when available.

Note that a few "sensitive" agencies like F_I are [Name redacted].

These are all of the possible candidates, mapped in Gulag Earth KML.

All points are disabled (invisible) by default for fast loading - attempting to make visible the entire data set at once is a bad idea.

They are organized by: state AND year of last employment OR year/month of license grant in reverse chronological order.

Don't have GEarth? That's ok. Also included is all of the data in XML and pipe '|' seperated CSV format. A .kmz file is a zip file by another name. Just rename to .zip and you can view the data however you like e.g. CSV in Excel/OpenOffice.

https://anonfile.com/J9s5Y0f9b7/fedhamfags.kmz

Size: 5902590 bytes (5 MB)

SHA256: AD618FD6718B73715BB0FB358739ED73EF562C8F81AB4D42499A0B57216BA61A

>>2649647

Neither A nor B are questions that have quick solutions because:

For 'A' the FCC database contains a large amount of expired/cancelled records

and

For 'B' I don't have an accurate total count of Fed employees due to the [name redacted] issue.

>>2649727

YW. The FCC DB is split into multiple files and there isn't even a status indicator I can search by - for each record I'd have to first determine if there's a name attached to the callsign and then go by grant/expiration/cancellation date (in a different file) and make the active record determination by date range.