This US yellow pages database is filled with 1,681,284 businesses records across the United States. Each record is comprised of title, address, primary phone number, longitude, latitude, categories, products services, additional contacts, specialties, hours, in business since, address information, brands, additional information, payment options, certification affiliations, languages spoken, emergency service, additional locations and website urls.
All these business are classified into 19 categories, such as Travel & Transportation, Computers & Electronics, Automotive, Sports & Recreation, Media & Communications, Arts & Entertainment, Legal & Financial, Shopping, Health & Medicine, Real Estate, Business & Professional Services, Home & Garden, Food & Dining, Clothing & Accessories, Community & Government, Industry & Agriculture, Education, Personal Care & Services and Construction & Contractors. The whole America yellow pages database consists of 10 tables.
| Name | n3zm_Yellowpages_superpages_com |
|---|---|
| Data | 3.16G (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 68 (+ 0) |
| Table Rows | 16,235,660 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| business | 1,681,284 | title |
100%
|
| address |
36.44%
|
||
| primary_phone |
36.97%
|
||
| longitude |
37.4%
|
||
| latitude |
37.4%
|
||
| categories |
36.16%
|
||
| additional_contacts |
5.48%
|
||
| products_services |
19.67%
|
||
| specialties |
10.09%
|
||
| hours |
14.26%
|
||
| in_business_since |
10.78%
|
||
| address_info |
19.69%
|
||
| brands |
7.69%
|
||
| additional_information |
5.12%
|
||
| payment_options |
3.54%
|
||
| certification_affiliations |
1.36%
|
||
| languages_spoken |
0.96%
|
||
| emergency_service |
10.09%
|
||
| additional_locations |
1.36%
|
||
| website_url |
22.24%
|
||
| category_1 | 19 | title |
100%
|
| category_2 | 1,900 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_2_x_state | 92,420 | category_2_id |
100%
|
| state_id |
100%
|
||
| category_2_x_state_x_city | 0 | category_2_x_state_id |
0%
|
| city_id |
0%
|
||
| category_3 | 288,437 | title |
100%
|
| category_2_id |
100%
|
||
| category_2 |
100%
|
||
| category_4 | 3,621,566 | title |
100%
|
| category_3_id |
100%
|
||
| category_3 |
100%
|
||
| category_4_x_business | 10,549,983 | category_4_id |
100%
|
| business_id |
100%
|
||
| city | 0 | title |
0%
|
| state | 51 | title |
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.
