In the area codes database, there are 355 area codes records and 169,914 phone number prefixes of America. In table area code, there are area code, state, major city and time zone in each. Each record of phone number prefix contains prefix, usage, primary city, carrier and introduced. The whole United States area codes data set consists of 3 tables.
| Name | n3_chennan_area_code_allareacodes_com |
|---|---|
| Data | 62.80M (+ 0B) |
| Tables | 3 (+ 0) |
| Columns | 18 (+ 0) |
| Table Rows | 340,183 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| area_code | 355 | area_code |
100%
|
| state |
89.01%
|
||
| major_city |
100%
|
||
| time_zone |
95.77%
|
||
| area_code_x_phone_number_prefix | 169,914 | area_code_id |
100%
|
| phone_number_prefix_id |
100%
|
||
| phone_number_prefix | 169,914 | prefix |
100%
|
| usage |
100%
|
||
| primary_city |
99.41%
|
||
| carrier |
100%
|
||
| introduced |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
