Usage & Publication License: database price dollar sign85.00

Database of 1,668,040 NPA NXX Codes & Phone Number Prefixes

170,804 phone number prefixes, 1,668,040 NPA NXX codes, 195 country codes, 343 area codes

database structure screenshot of Database of 1,668,040 NPA NXX Codes & Phone Number Prefixes

Description: This is a well-structured telephone area code & phone number prefix database that comes with 1,668,040 NPA NXX codes & 170,804 phone number prefixes from all over the world. In the table of NPA_NXX, each record is comprised of NPA-NXX-X, location and phone company. There are 195 country codes and 343 area codes.

Related DBs:

Database Statistics

  • Size: 181.70 MB
  • Tables: 5
  • Records: 1,668,040
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
npa_nxx 1,668,040
  1. id
  2. prefix_id
  3. npa-nxx-x
  4. location
  5. phone_company
prefix 170,804
  1. id
  2. area_code_id
  3. title
  4. slug
country_code 195
  1. id
  2. title
  3. count
  4. slug
area_code 343
  1. id
  2. title
  3. count
  4. slug
country_area_code 8,239
  1. id
  2. country_code_id
  3. title
  4. slug

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

country_code

  • Country Code 1 - Antigua and Barbuda, Anguilla, Barbados, Bermuda, Bahamas, Canada, Dominica, Dominican Republic, Grenada, Guam, Jamaica, Saint Kitts and Nevis, Cayman Islands, Saint Lucia, Northern Mariana Islands, Montserrat, Puerto Rico, Turks and Caic - 322
  • Country Code 20 - Egypt - 31
  • Country Code 212 - Morocco - 66
  • Country Code 213 - Algeria - 20
  • Country Code 216 - Tunisia - 8
  • Country Code 218 - Libyan Arab Jamahiriya - 95
  • Country Code 220 - Gambia - 6
  • Country Code 221 - Senegal - 2
  • Country Code 222 - Mauritania - 0
  • Country Code 223 - Mali - 0
  • Country Code 224 - Guinea - 20
  • Country Code 225 - C - 0
  • Country Code 226 - Burkina Faso - 3
  • Country Code 227 - Niger - 12
  • Country Code 228 - Togo - 6
  • Country Code 229 - Benin - 6
  • Country Code 230 - Mauritius - 173
  • Country Code 231 - Liberia - 0
  • Country Code 232 - Sierra Leone - 0
  • Country Code 233 - Ghana - 50
  • Country Code 234 - Nigeria - 57
  • Country Code 235 - Chad - 2
  • Country Code 236 - Central African Republic - 0
  • Country Code 237 - Cameroon - 0
  • Country Code 238 - Cape Verde - 0
  • Country Code 239 - S - 1
  • Country Code 240 - Equatorial Guinea - 2
  • Country Code 241 - Gabon - 44
  • Country Code 242 - Congo - 0
  • Country Code 244 - Angola - 17
  • Country Code 245 - Guinea-Bissau - 7
  • Country Code 246 - British Indian Ocean Territory - 10
  • Country Code 247 - Ascension - 8
  • Country Code 249 - Sudan - 143
  • Country Code 250 - Rwanda - 0
  • Country Code 252 - Somalia - 0
  • Country Code 253 - Djibouti - 8
  • Country Code 254 - Kenya - 29
  • Country Code 255 - Tanzania - 7
  • Country Code 256 - Uganda - 13
  • Country Code 257 - Burundi - 9
  • Country Code 260 - Zambia - 8
  • Country Code 261 - Madagascar - 6
  • Country Code 262 - Reunion - 1
  • Country Code 263 - Zimbabwe - 66
  • Country Code 264 - Namibia - 16
  • Country Code 265 - Malawi - 0
  • Country Code 266 - Lesotho - 1
  • Country Code 267 - Botswana - 16
  • Country Code 268 - Swaziland - 36
  • Country Code 269 - Comoros, Mayotte - 24
  • Country Code 27 - South Africa - 51
  • Country Code 290 - Saint Helena - 5
  • Country Code 297 - Aruba - 6
  • Country Code 298 - Faroe Islands - 0
  • Country Code 299 - Greenland - 19
  • Country Code 30 - Greece - 7
  • Country Code 31 - Netherlands - 144
  • Country Code 32 - Belgium - 42
  • Country Code 33 - France - 5
  • Country Code 34 - Spain - 72
  • Country Code 350 - Gibraltar - 0
  • Country Code 351 - Portugal - 51
  • Country Code 352 - Luxembourg - 0
  • Country Code 353 - Ireland - 68
  • Country Code 354 - Iceland - 0
  • Country Code 355 - Albania - 56
  • Country Code 356 - Malta - 0
  • Country Code 357 - Cyprus - 6
  • Country Code 358 - Finland - 13
  • Country Code 359 - Bulgaria - 299
  • Country Code 36 - Hungary - 54
  • Country Code 370 - Lithuania - 47
  • Country Code 371 - Latvia - 28
  • Country Code 372 - Estonia - 29
  • Country Code 373 - Moldova - 44
  • Country Code 374 - Armenia - 0
  • Country Code 375 - Belarus - 0
  • Country Code 376 - Andorra - 2
  • Country Code 377 - Monaco - 1
  • Country Code 378 - San Marino - 10
  • Country Code 380 - Ukraine - 299
  • Country Code 381 - Serbia and Montenegro - 43
  • Country Code 385 - Croatia - 20
  • Country Code 386 - Slovenia - 6
  • Country Code 387 - Bosnia and Herzegovina - 21
  • Country Code 389 - Macedonia - 12
  • Country Code 39 - Italy, Holy See (Vatican City State) - 31
  • Country Code 40 - Romania - 31
  • Country Code 41 - Switzerland - 22
  • Country Code 420 - Czech Republic - 20
  • Country Code 421 - Slovakia - 25
  • Country Code 423 - Liechtenstein - 3
  • Country Code 43 - Austria - 299
  • Country Code 44 - United Kingdom - 299
  • Country Code 45 - Denmark - 7
  • Country Code 46 - Sweden - 264
  • Country Code 47 - Norway - 0
  • Country Code 48 - Poland - 49
  • Country Code 49 - Germany - 299
  • Country Code 500 - Falkland Islands (Malvinas) - 4
  • Country Code 501 - Belize - 6
  • Country Code 502 - Guatemala - 2
  • Country Code 503 - El Salvador - 0
  • Country Code 504 - Honduras - 6
  • Country Code 505 - Nicaragua - 5
  • Country Code 506 - Costa Rica - 0
  • Country Code 507 - Panama - 5
  • Country Code 508 - Saint Pierre and Miquelon - 0
  • Country Code 509 - Haiti - 7
  • Country Code 51 - Peru - 24
  • Country Code 52 - Mexico - 299
  • Country Code 53 - Cuba - 42
  • Country Code 54 - Argentina - 225
  • Country Code 55 - Brazil - 67
  • Country Code 56 - Chile - 25
  • Country Code 57 - Colombia - 48
  • Country Code 58 - Venezuela - 52
  • Country Code 590 - Guadeloupe - 0
  • Country Code 591 - Bolivia - 0
  • Country Code 592 - Guyana - 68
  • Country Code 593 - Ecuador - 6
  • Country Code 594 - French Guiana - 1
  • Country Code 595 - Paraguay - 120
  • Country Code 597 - Suriname - 4
  • Country Code 598 - Uruguay - 103
  • Country Code 599 - Netherlands Antilles - 8
  • Country Code 60 - Malaysia - 14
  • Country Code 61 - Australia, Cocos(Keeling)Island, Christmas Island - 4
  • Country Code 62 - Indonesia - 299
  • Country Code 63 - Philippines - 61
  • Country Code 64 - New Zealand - 5
  • Country Code 65 - Singapore - 13
  • Country Code 66 - Thailand - 25
  • Country Code 672 - Antarctica - 4
  • Country Code 673 - Brunei Darussalam - 4
  • Country Code 674 - Nauru - 0
  • Country Code 675 - Papua New Guinea - 8
  • Country Code 676 - Tonga - 0
  • Country Code 677 - Solomon Islands - 22
  • Country Code 678 - Vanuatu - 9
  • Country Code 679 - Fiji - 8
  • Country Code 680 - Palau - 0
  • Country Code 681 - Wallis and Futuna Islands - 3
  • Country Code 682 - Cook Islands - 1
  • Country Code 683 - Niue - 3
  • Country Code 684 - American Samoa - 0
  • Country Code 685 - Samoa - 22
  • Country Code 686 - Kiribati - 32
  • Country Code 687 - New Caledonia - 15
  • Country Code 688 - Tuvalu - 18
  • Country Code 689 - French Polynesia - 0
  • Country Code 691 - Micronesia - 7
  • Country Code 692 - Marshall Islands - 3
  • Country Code 7 - Kazakhstan, Russian Federation - 190
  • Country Code 81 - Japan - 158
  • Country Code 82 - Korea, Republic of - 31
  • Country Code 84 - Viet Nam - 51
  • Country Code 852 - Hong Kong - 0
  • Country Code 853 - Macao - 0
  • Country Code 855 - Cambodia - 24
  • Country Code 856 - Lao People's Democratic Republic - 6
  • Country Code 86 - China - 299
  • Country Code 871 - Inmarsat Atlantic Ocean-East - 0
  • Country Code 872 - Inmarsat Pacific Ocean - 0
  • Country Code 873 - Inmarsat Indian Ocean - 0
  • Country Code 874 - Inmarsat Atlantic Ocean-West - 0
  • Country Code 880 - Bangladesh - 291
  • Country Code 886 - Taiwan - 31
  • Country Code 90 - Turkey - 82
  • Country Code 91 - India - 299
  • Country Code 92 - Pakistan - 299
  • Country Code 94 - Sri Lanka - 29
  • Country Code 95 - Myanmar - 9
  • Country Code 960 - Maldives - 0
  • Country Code 961 - Lebanon - 7
  • Country Code 962 - Jordan - 4
  • Country Code 963 - Syria - 17
  • Country Code 964 - Iraq - 18
  • Country Code 965 - Kuwait - 83
  • Country Code 966 - Saudi Arabia - 6
  • Country Code 968 - Oman - 7
  • Country Code 971 - United Arab Emirates - 6
  • Country Code 972 - Israel - 5
  • Country Code 973 - Bahrain - 1
  • Country Code 974 - Qatar - 46
  • Country Code 975 - Bhutan - 7
  • Country Code 977 - Nepal - 56
  • Country Code 98 - Iran - 100
  • Country Code 992 - Tajikistan - 6
  • Country Code 993 - Turkmenistan - 11
  • Country Code 994 - Azerbaijan - 69
  • Country Code 995 - Georgia - 58
  • Country Code 996 - Kyrgyz Republic - 53
  • Country Code 998 - Uzbekistan - 13
  • - 0

area_code

  • Area Code 201 - New Jersey - 776
  • Area Code 202 - District of Columbia - 650
  • Area Code 203 - Connecticut - 784
  • Area Code 204 - Manitoba - 705
  • Area Code 205 - Alabama - 680
  • Area Code 206 - Washington - 591
  • Area Code 207 - Maine - 667
  • Area Code 208 - Idaho - 715
  • Area Code 209 - California - 588
  • Area Code 210 - Texas - 644
  • Area Code 212 - New York - 782
  • Area Code 213 - California - 427
  • Area Code 214 - Texas - 773
  • Area Code 215 - Pennsylvania - 781
  • Area Code 216 - Ohio - 490
  • Area Code 217 - Illinois - 726
  • Area Code 218 - Minnesota - 584
  • Area Code 219 - Indiana - 333
  • Area Code 224 - Illinois - 239
  • Area Code 225 - Louisiana - 366
  • Area Code 226 - Ontario - 355
  • Area Code 228 - Mississippi - 228
  • Area Code 229 - Georgia - 452
  • Area Code 231 - Michigan - 471
  • Area Code 234 - Ohio - 79
  • Area Code 236 - British Columbia - 5
  • Area Code 239 - Florida - 340
  • Area Code 240 - Maryland - 516
  • Area Code 248 - Michigan - 714
  • Area Code 249 - Ontario - 11
  • Area Code 250 - British Columbia - 778
  • Area Code 251 - Alabama - 346
  • Area Code 252 - North Carolina - 553
  • Area Code 253 - Washington - 410
  • Area Code 254 - Texas - 442
  • Area Code 256 - Alabama - 708
  • Area Code 260 - Indiana - 340
  • Area Code 262 - Wisconsin - 498
  • Area Code 267 - Pennsylvania - 627
  • Area Code 269 - Michigan - 420
  • - 0

Miscellaneous

Notes:

  • In table NPA_NXX, there are 1,668,080 records that have a NPA-NXX-X, a location & a phone company.
  • There are 8,239 records that have a title and a slug in table country_area_code.

One Payment, Lifetime Updates

This database is being constantly updated with regards to the volume and 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. You can download the updated version from the Download page by the same credentials we sent to you when you made the purchase, for a lifetime.

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
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries.

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. What is opposite to yes?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.