NPA NXX Codes & Phone Number Prefixes

Phone number prefixes, NPA NXX codes, country codes, and area codes

Data Structure

area_code [343]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
country_area_code [8,239]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ country_code_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
country_code [195]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (81%)
varchar(255)
+ slug (100%)
npa_nxx [1,668,040]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ prefix_id (100%)
varchar(255)
+ npa_nxx_x (100%)
varchar(255)
+ location (100%)
varchar(255)
+ phone_company (100%)
prefix [170,804]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ area_code_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)

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.

Data Profile

Size 274.78M
Tables 5
Last Commit 2016-12-07 00:21:57

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:21:57 274.78M 5 26 1847621
2016-09-05 04:35:09 274.78M 5 26 1847621

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
area_code 343 .001 0.343
country_area_code 8,239 .001 8.239
country_code 195 .001 0.195
npa_nxx 1,668,040 .001 1668.04
prefix 170,804 .001 170.804
Total Credits 1847.621 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.