Scanner & Radio Frequencies Reference

Worldwide (Mostly United States) Radio Communications Reference Database

Data Structure

amateur_radio [5,824]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ frequency (100%)
varchar(255)
+ license (82.7%)
varchar(255)
+ type (97.3%)
varchar(255)
+ tone_out (61.3%)
varchar(255)
+ tone_in (63.5%)
varchar(255)
+ alpha_tag (99.7%)
text
+ description (99.7%)
varchar(255)
+ mode (99.7%)
varchar(255)
+ tag (99.7%)
bigint(20) unsigned
+ amateur_section_id (100%)
amateur_section [1,936]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ city_id (100%)
city [4,165]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ state_id (100%)
country [236]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
fcc_callsign [10,048]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ fcc_callsign (100%)
section [6,600]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ city_id (100%)
section_sub [25,390]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ section_id (100%)
mediumtext
+ description (17.8%)
section_sub_frequency [97,647]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ section_sub_id (100%)
varchar(255)
+ frequency (100%)
varchar(255)
+ license (85.7%)
varchar(255)
+ type (97.7%)
varchar(255)
+ tone (60.3%)
varchar(255)
+ alpha_tag (97.8%)
text
+ description (99.9%)
varchar(255)
+ mode (100%)
varchar(255)
+ tag (99.9%)
section_sub_trs [3,135]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (99.9%)
varchar(255)
+ type (99.9%)
mediumtext
+ description (100%)
bigint(20) unsigned
+ system_id (100%)
bigint(20) unsigned
+ section_sub_id (100%)
state [538]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ country_id (100%)
system [5,141]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ system_name (99.8%)
varchar(255)
+ location (99.8%)
varchar(255)
+ county (99.8%)
varchar(255)
+ system_type (99.8%)
varchar(255)
+ system_voice (99.8%)
system_id [2,157]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ system_id_title (100%)
varchar(255)
+ connect_tone (97.6%)
bigint(20) unsigned
+ system_id (100%)
system_site [16,342]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ name (100%)
bigint(20) unsigned
+ system_id (100%)
varchar(255)
+ system_name (99.9%)
varchar(255)
+ site_location (99.9%)
varchar(255)
+ site_number (99.9%)
varchar(255)
+ system_id_title (8.9%)
varchar(255)
+ site_nac (37.4%)
varchar(255)
+ rebanded (5.1%)
varchar(255)
+ site_description (99.9%)
varchar(255)
+ site_county_location (99.9%)
varchar(255)
+ site_neighbors (99.9%)
varchar(255)
+ site_location_2 (99.9%)
varchar(255)
+ site_connect_tone (24.8%)
varchar(255)
+ site_modulation (99.9%)
varchar(255)
+ site_notes (99.9%)
varchar(255)
+ latitude (92.4%)
varchar(255)
+ longitude (92.4%)
varchar(255)
+ range (92.4%)
system_site_fcc_license [13,891]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ system_site_id (100%)
varchar(255)
+ fcc_callsign (100%)
bigint(20) unsigned
+ fcc_callsign_id (100%)
system_site_frequency [93,093]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ system_site_id (100%)
varchar(255)
+ frequency (100%)
talkgroup [142,827]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ dec (100%)
varchar(255)
+ hex (99.4%)
varchar(255)
+ mode (99.1%)
varchar(255)
+ alpha_tag (99.3%)
text
+ description (99.9%)
varchar(255)
+ tag (87.3%)
bigint(20) unsigned
+ system_id (100%)
trunked_radio_system [13,236]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ system_name (100%)
varchar(255)
+ type (100%)
varchar(255)
+ city (99.8%)
bigint(20) unsigned
+ system_id (100%)
bigint(20) unsigned
+ city_id (100%)

Description

This is a very well structured and comprehensive database of radio scanner frequencies across the United States and across the world. Refer to the database tables / entities and their relationships for details.

There are 4,165 cities, 538 states (sub-national areas) and 236 countries.

There are 5,824 amateur radio frequencies indexed by city. There are 10,048 unique FCC callsign. There are 97,647 frequencies and 3,135 trunked radio systems indexed by section_sub, section and then by city.

There are 5,141 systems, 2,157 system ID, 16,342 system sites, 13,891 FCC licenses / FCC callsign, 93,093 frequencies, 142,827 talkgroups, and 13,236 trunked radio systems.

Data Profile

Size 62.27M
Tables 17
Last Commit 2016-09-07 01:06:22

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:06:22 62.27M 17 114 442206

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
amateur_radio 5,824 .001 5.824
amateur_section 1,936 .001 1.936
city 4,165 .001 4.165
country 236 .001 0.236
fcc_callsign 10,048 .001 10.048
section 6,600 .001 6.6
section_sub 25,390 .001 25.39
section_sub_frequency 97,647 .001 97.647
section_sub_trs 3,135 .001 3.135
state 538 .001 0.538
system 5,141 .001 5.141
system_id 2,157 .001 2.157
system_site 16,342 .001 16.342
system_site_fcc_license 13,891 .001 13.891
system_site_frequency 93,093 .001 93.093
talkgroup 142,827 .001 142.827
trunked_radio_system 13,236 .001 13.236
Total Credits 442.206 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.