Broadcast Query (FCCdata.org) - Data Export Function

REC Broadcast Query (FMQ) now allows you to export data to your computer's clipboard.  The data can then be imported into certain applications such as RadioSoft's Commstudy 2. 

This functionality is available only for FCC FM broadcast records.  The data will include the currently displayed records.  On the initial query, FMQ shows all records marked "current".  Clicking on an appliction reference number will only bring up that record only and only that record will be exported when the export button is clicked. 

Once the button is clicked, the button will disappear as the data is already copied.  To make the button reappear, refresh the browser or click a link inside FMQ.

Newly filed applications and amendments that have not been completely processed at the FCC where there is no ERP or HAAT will not appear correctly in tools like Commstudy 2.  It should be back to normal after the next business day.

To move data from REC to Commstudy 2

  • In Broadcast Query, click the [Export facility Data to Clipboard]  button.
  • Click the [OK] button in the box that pops up in the web browser.
  • In Commstudy 2, click the Transmitters button on the task bar.
  • In the Transmitters window, click on [Sites].
  • Select [Import Sites] and click on [From Clipboard].
  • Your site(s) will appear.

Data that will go to the clipboard

The first line will be a header that describes each tab-delimited column. This data is machine readable by Commstudy 2. 

Each additional line is the data that for the facility that is being exported.  Elements are tab delimited.  Within the final column (TxAntenna), items are pipe delimited.

Call Sign Station call sign
State State of license
City City of license
Channel FM channel number (200-300)
ERP_w Effective Radiated Power in Watts
Lat Latitude in degrees, minute, second format.
Lon Longitude in degrees, minute, second format.
Licensee Name of licensee/applicant from FCC Facility file
ARN Application Reference Number
AGL_m Radiation Center Above Ground Level in meters.
GL_m Site elevation (at ground level) in meters.
AMSL_m Radiation Center Above Mean Sea Level in meters.
HAAT_m Height Above Average Terrain in meters.
Class Station Class
Status Application Status
Serv (not used in FM)
Pattern (not used in FM)
Effeciency (not used in FM)
Comments Comments from CDBS
Index (not used in FM)
Towers (not used in FM)
Augs (not used in FM)
Facility_id FCC Facility Identifier.
Tx_Antenna Information on the antenna - pipe delimited - see below.

Antenna Data

The final column (Tx_Antenna) contains pipe delimited data about the antenna.

The first three columns are not used in FM.

The fourth column is the make and model of the antenna.

The fifth column is the antenna rotation multipled by 100 (175 degrees = 17500).

The sixth and seventh columns arenot used in FM.

Starting with the eigth column, is a 36 groups of three columns giving directional antenna information. 

  • First item: Azimuth (direction) multipled by 100.
  • Second item: not used.
  • Third item: Field intensity for that azimuth multiplied by 1000.  (For exmple 0.754 = 754).

 

This data is provided free, as-is with  no warranty implied.  Feel free to us it and work it into your applications!