Database
Scanner Frequencies and Radio Frequency Reference Database
Worldwide (Mostly United States) Radio Communications Reference Database in MySQL and CSV
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.
Database Statistics
- Size: 32.80 MB
- Tables: 17
- Records: 93,093
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Database Structure
Table | Records | Fields |
---|---|---|
amateur_radio | 5,824 |
|
amateur_section | 1,936 |
|
city | 4,165 |
|
country | 236 |
|
fcc_callsign | 10,048 |
|
section | 6,600 |
|
section_sub | 25,390 |
|
section_sub_frequency | 97,647 |
|
section_sub_trs | 3,135 |
|
state | 538 |
|
system | 5,141 |
|
system_id | 2,157 |
|
system_site | 16,342 |
|
system_site_fcc_license | 13,891 |
|
system_site_frequency | 93,093 |
|
talkgroup | 142,827 |
|
trunked_radio_system | 13,236 |
|
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
country
- United States
- Canada
- Australia
- Mexico
- Afghanistan
- Albania
- Algeria
- American Samoa
- Andorra
- Angola
- Anguilla
- Antarctica
- Antigua and Barbuda
- Argentina
- Armenia
- Aruba
- Austria
- Azerbaidjan
- Bahamas
- Bahrain
- Bangladesh
- Barbados
- Belarus
- Belgium
- Belize
- Benin
- Bermuda
- Bhutan
- Bolivia
- Bosnia-Herzegovina
- Botswana
- Bouvet Island
- Brazil
- British Indian Ocean Territory
- Brunei Darussalam
- Bulgaria
- Burkina Faso
- Burundi
- Cambodia
- Cameroon
- Cape Verde
- Cayman Islands
- Central African Republic
- Chad
- Chile
- China
- Cocos (Keeling) Islands
- Colombia
- Comoros
- Congo
- Cook Islands
- Costa Rica
- Croatia
- Cuba
- Cyprus
- Czech Republic
- Denmark
- Djibouti
- Dominica
- Dominican Republic
- East Timor
- Ecuador
- Egypt
- El Salvador
- Equatorial Guinea
- Eritrea
- Estonia
- Ethiopia
- Falkland Islands
- Faroe Islands
- Fiji
- Finland
- Former Czechoslovakia
- Former USSR
- France
- French Guyana
- French Southern Territories
- Gabon
- Gambia
- Georgia
- Germany
- Ghana
- Gibraltar
- Greece
- Greenland
- Grenada
- Guadeloupe (French)
- Guam (USA)
- Guatemala
- Guinea
- Guinea Bissau
- Guyana
- Haiti
- Heard and McDonald Islands
- Holy See (Vatican City State)
- Honduras
- Hong Kong
- Hungary
- Iceland
- India
- Indonesia
- Iran
- Iraq
- Ireland
- Israel
- Italy
- Ivory Coast (Cote D'Ivoire)
- Jamaica
- Japan
- Jordan
- Kazakhstan
- Kenya
- Kiribati
- Kuwait
- Kyrgyz Republic (Kyrgyzstan)
- Laos
- Latvia
- Lebanon
- Lesotho
- Liberia
- Libya
- Liechtenstein
- Lithuania
- Luxembourg
- Macau
- Macedonia
- Madagascar
- Malawi
- Malaysia
- Maldives
- Mali
- Malta
- Marshall Islands
- Martinique (French)
- Mauritania
- Mauritius
- Mayotte
- Micronesia
- Moldavia
- Monaco
- Mongolia
- Montserrat
- Morocco
- Mozambique
- Myanmar
- Namibia
- Nauru
- Nepal
- Netherlands
- Netherlands Antilles
- Neutral Zone
- New Caledonia (French)
- New Zealand
- Nicaragua
- Niger
- Nigeria
- Niue
- North Korea
- Northern Mariana Islands
- Norway
- Oman
- Pakistan
- Palau
- Panama
- Papua New Guinea
- Paraguay
- Peru
- Philippines
- Pitcairn Island
- Poland
- Polynesia (French)
- Portugal
- Qatar
- Romania
- Russian Federation
- Rwanda
- S. Georgia & S. Sandwich Isls.
- Saint Helena
- Saint Kitts & Nevis Anguilla
- Saint Lucia
- Saint Pierre and Miquelon
- Saint Tome (Sao Tome) and Principe
- Saint Vincent & Grenadines
- Samoa
- San Marino
- Saudi Arabia
- Senegal
- Serbia
- Seychelles
- Sierra Leone
- Singapore
- Slovak Republic
- Slovenia
- Solomon Islands
- Somalia
- South Africa
- South Korea
- Spain
- Sri Lanka
- Sudan
- Suriname
- Svalbard and Jan Mayen Islands
- Swaziland
- Sweden
- Switzerland
- Syria
- Tadjikistan
- Taiwan
- Tanzania
- Thailand
- Togo
- Tokelau
- Tonga
- Trinidad and Tobago
- Tunisia
- Turkey
- Turkmenistan
- Turks and Caicos Islands
- Tuvalu
- Uganda
- Ukraine
- United Arab Emirates
- United Kingdom
- Uruguay
- USA Minor Outlying Islands
- Uzbekistan
- Vanuatu
- Venezuela
- Vietnam
- Virgin Islands (British)
- Wallis and Futuna Islands
- Western Sahara
- Yemen
- Zaire
- Zambia
- Zimbabwe
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.