| 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) |
| Last Commit | 2023-06-19 19:57:45 (+ 169 d) |
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.
| 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%
|
No media sets.
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2023-01-01 (+ 95 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2022-09-27 (+ 271 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-12-30 (+ 115 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-09-05 (+ 150 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-04-08 (+ 68 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-01-29 (+ 120 d) | 3.16G (+ 3.05M) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-10-01 (+ 38 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-08-23 (+ 141 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-04-04 (+ 196 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-09-21 (+ 197 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-03-07 (+ 43 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-01-23 (+ 44 d) | 3.16G (+ 0B) | 10 (+ 0) | 68 (+ 0) | 16,235,660 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-12-09 (+ 29 d) | 3.16G (+ 12.11M) | 10 (+ 2) | 68 (+ 8) | 16,235,660 (+ 92,216) | 0B (+ 0B) | 0 (+ 0) |
| 2018-11-09 (+ 27 d) | 3.15G (+ 1.97G) | 8 (+ 2) | 60 (+ 8) | 16,143,444 (- 5,662) | 0B (+ 0B) | 0 (+ 0) |
| 2018-10-13 (+ 30 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-09-13 (+ 34 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-08-09 (+ 27 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-07-12 (+ 31 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-06-10 (+ 31 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-05-10 (+ 28 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-04-11 (+ 38 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-03-03 (+ 35 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 16,149,106 (+ 2,283,150) | 0B (+ 0B) | 0 (+ 0) |
| 2018-01-27 (+ 29 d) | 1.17G (+ 0B) | 6 (+ 0) | 52 (+ 0) | 13,865,956 (+ 5,189,654) | 0B (+ 0B) | 0 (+ 0) |
| 2017-12-29 (+ 20 d) | 1.17G (+ 26.20M) | 6 (+ 0) | 52 (+ 0) | 8,676,302 (+ 4,209,021) | 0B (+ 0B) | 0 (+ 0) |
| 2017-12-08 (+ 9 d) | 1.15G (+ 767.61M) | 6 (+ 0) | 52 (+ 20) | 4,467,281 (+ 982,628) | 0B (+ 0B) | 0 (+ 0) |
| 2017-11-28 (+ 19 d) | 406.38M (+ 0B) | 6 (+ 0) | 32 (+ 0) | 3,484,653 (+ 820) | 0B (+ 0B) | 0 (+ 0) |
| 2017-11-09 (+ 10 d) | 406.38M (+ 0B) | 6 (+ 0) | 32 (+ 0) | 3,483,833 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2017-10-29 (+ 19 d) | 406.38M (+ 0B) | 6 (+ 0) | 32 (+ 0) | 3,483,833 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2017-10-10 (+ 31 d) | 406.38M (+ 322.19M) | 6 (+ 0) | 32 (+ 1) | 3,483,833 (+ 3,218,381) | 0B (+ 0B) | 0 (+ 0) |
| 2017-09-08 | 84.19M | 6 | 31 | 265,452 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.
