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 13 tables.
| Name | n3a2_yelp_com |
|---|---|
| Data | 5.66G (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 61 (+ 0) |
| Table Rows | 25,529,351 (+ 0) |
| Media | 66.78G (+ 0B) |
| Files | 2,122,668 (+ 0) |
Tables & Columns
| 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%
|
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
BUSINESS_IMAGE
| Size (Bytes) | Files |
|---|---|
| 66.78G | 2,122,668 |
