The Playground Amateur Radio Club reformats FCC database dumps to comma-separated values (CSV) for public consumption:

"FRN","CallSign","LicenseStatus","RadioSvcCode","OperatorClass","GroupCode","RegionCode","GrantDate","ExpiredDate","CanceledDate",
"EntityName","FirstName","MiddleInitial","LastName","NameSuffix",
"Phone","Email","StreetAddress","City","State","ZipCode","PoBox","Attention",
"PrevCallSign","PrevOpClass"

FRN: the licensee's FCC registration number

CallSign: the licensee's call sign

LicenseStatus: the "A"ctive, "E"xpired, "C"anceled, or "T"erminated status of the license

RadioSvcCode: a two-letter code designating the specific radio service; "HA" for Amateur, "ZA" for General Mobile Radio Service

OperatorClass: the license class held by the operator; "N"ovice, "T"echnician, "G"eneral, "A"dvanced, "E"xtra

GroupCode: a one-letter group, "A" to "D", corresponding to the call sign's format e.g., Group C for a "1x3" format

RegionCode: a numeric geographic region assigned to the call sign

GrantDate: the date the FCC last granted the license; renewals qualify as a new grant

ExpiredDate: the date the license will expire, or did expire

CanceledDate: the date the FCC canceled the license, or blank if not applicable

EntityName: the name of a club, agency, or corporate entity holding the license; blank if it's a person

FirstName: the licensee's first name

MiddleInitial: the licensee's middle initial (either blank or one letter)

LastName: the licensee's last name

NameSuffix: the licensee's name suffix e.g., Jr., Sr., III, IV

Phone: the licensee's telephone number (the FCC suppresses this in data dumps)

Email: the licensee's email address (the FCC suppresses this in data dumps)

StreetAddress: the licensee's physical street address

City: the licensee's city of residence

State: the licensee's state of residence

ZipCode: the licensee's postal ZIP code

PoBox: the licensee's post office box, if they use one instead of a street address

Attention: a designated point of contact or attention line for mailing purposes

PrevCallSign: the call sign previously held by the licensee, or blank if not applicable

PrevOpClass: the previous operator class held by the licensee before an upgrade, or blank if not applicable
