| Name | n3a2_yelp_com |
|---|---|
| Data | 5.66G (- 48K) |
| Tables | 12 (- 1) |
| Columns | 57 (- 4) |
| Table Rows | 25,529,351 (+ 0) |
| Media | 66.78G (+ 0B) |
| Files | 2,122,668 (+ 0) |
| Last Commit | 2023-06-19 19:07:11 (+ 169 d) |
This is a fields-rich restaurants, nightlife bars database of 7,250,679 business records and 6,732,104 unique phone numbers in the world, classified by 24 categories (Restaurants, Shopping, Nightlife, Home Services, Automotive, Health & Spas, Health & Medical, Arts & Entertainment, etc.) This businesses database is filled with business location details, such as longitude and latitude, contact information such as phone numbers and detailed street addresses across 67 areas in the world. The whole restaurants, spas database consists of 12 tables.
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| business | 7,250,679 | title |
100%
|
| neighborhood |
49.63%
|
||
| address |
99.8%
|
||
| phone |
92.85%
|
||
| star_rating |
36.07%
|
||
| latitude |
99.54%
|
||
| longitude |
99.54%
|
||
| category_1 | 24 | title |
100%
|
| category_2 | 1,382 | title |
100%
|
| category_1_id |
0%
|
||
| city | 219 | title |
100%
|
| region_id |
100%
|
||
| city_x_category_1 | 4,654 | city_id |
100%
|
| category_1_id |
100%
|
||
| city_x_category_1_x_category_2 | 230,318 | city_x_category_1_id |
100%
|
| category_2_id |
100%
|
||
| city_x_category_1_x_category_2_x_business | 18,028,910 | city_x_category_1_x_category_2_id |
100%
|
| business_id |
100%
|
||
| city_x_category_1_x_category_2_x_district | 1,908 | city_x_category_1_x_category_2_id |
100%
|
| district_id |
100%
|
||
| city_x_category_1_x_category_2_x_district_x_business | 9,338 | city_x_category_1_x_category_2_x_district_id |
100%
|
| business_id |
100%
|
||
| district | 1,852 | title |
100%
|
| city_id |
0%
|
||
| region | 67 | title |
100%
|
| Size (Bytes) | Files |
|---|---|
| 66.78G | 2,122,668 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 5.66G (- 48K) | 12 (- 1) | 57 (- 4) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2023-01-01 (+ 95 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2022-09-27 (+ 271 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2021-12-30 (+ 115 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2021-09-05 (+ 150 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2021-04-08 (+ 68 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2021-01-29 (+ 120 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2020-10-01 (+ 38 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2020-08-23 (+ 141 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2020-04-04 (+ 196 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2019-09-21 (+ 197 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2019-03-07 (+ 43 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2019-01-23 (+ 44 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-12-09 (+ 29 d) | 5.66G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-11-09 (+ 27 d) | 5.66G (+ 737.45M) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-10-13 (+ 29 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-09-13 (+ 34 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-08-09 (+ 27 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-07-12 (+ 31 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-06-10 (+ 31 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-05-10 (+ 28 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-04-11 (+ 38 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-03-03 (+ 35 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2018-01-27 (+ 29 d) | 4.94G (+ 0B) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 0B) | 2,122,668 (+ 0) |
| 2017-12-29 (+ 20 d) | 4.94G (+ 2.94G) | 13 (+ 0) | 61 (+ 0) | 25,529,351 (+ 0) | 66.78G (+ 2.74G) | 2,122,668 (+ 234,860) |
| 2017-12-08 (+ 9 d) | 2G (+ 0B) | 13 (+ 0) | 61 (+ 2) | 25,529,351 (+ 0) | 64.04G (+ 2.75G) | 1,887,808 (+ 165,192) |
| 2017-11-28 (+ 19 d) | 2G (+ 0B) | 13 (+ 0) | 59 (+ 0) | 25,529,351 (+ 0) | 61.29G (+ 6.92G) | 1,722,616 (+ 303,029) |
| 2017-11-09 (+ 10 d) | 2G (+ 0B) | 13 (+ 0) | 59 (+ 0) | 25,529,351 (+ 0) | 54.37G (+ 4.22G) | 1,419,587 (+ 168,040) |
| 2017-10-29 (+ 19 d) | 2G (+ 0B) | 13 (+ 0) | 59 (+ 0) | 25,529,351 (+ 0) | 50.15G (+ 706.09M) | 1,251,547 (+ 291,029) |
| 2017-10-10 (+ 31 d) | 2G (+ 0B) | 13 (+ 0) | 59 (+ 0) | 25,529,351 (+ 0) | 49.47G (+ 2.70G) | 960,518 (+ 379,430) |
| 2017-09-08 | 2G | 13 | 59 | 25,529,351 | 46.77G | 581,088 |
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.
