这是一个中国黄页数据库，共包含有63,006家公司记录且每个记录中包含有经营范围，联系电话，联系人，移动电话，座机，邮编，地址，行业，地点，公司类型，成立时间，公司简介，规模，业务类型，资本，网址，传真，邮件和生产范围。这些公司来自47个行业并且被分为3个主分类和21个二级分类。在表生产中有54,274个记录且每个生产记录中包含有公司，产品，价格，描述，订货量和存储量。在媒体文件夹中存有53,965张生产图片，共计大小39.62M。该中国企业黄页数据库共有12个表。
With 63,006 companies of China, classified by 3 categories and further into 21 sub-categories, this is a China companies yellow pages database you will need.
Each company is comprised of company, business range, description, telephone, linkman, mobile telephone, contact telephone, post code, address, industry, location, company type, establish time, company introduce, company type 2, company size, business type, capital, company website, fax, email address and production range. All these companies are from 47 industries and has 54,274 production records with company, product, description, price, book count from and store count in each. It also comes with 53,965 production images in the 39.62M media set.
The whole Chinese yellow pages data set totaly has 12 tables.
| Name | n3_lyz_yellowurl.cn_company |
|---|---|
| Data | 361.28M (+ 186.91M) |
| Tables | 12 (+ 0) |
| Columns | 77 (+ 0) |
| Table Rows | 1,152,397 (+ 0) |
| Media | 39.62M (+ 0B) |
| Files | 881 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| cate_1 | 3 | category |
100%
|
| cate_2 | 21 | category |
100%
|
| cate_1_id |
100%
|
||
| cate_3 | 647 | cate_2_id |
100%
|
| category |
100%
|
||
| count |
100%
|
||
| cate_4 | 13,147 | cate_3_id |
100%
|
| category |
100%
|
||
| count |
100%
|
||
| cate_4_x_company | 819,275 | company_id |
100%
|
| cate_4_id |
100%
|
||
| company | 63,006 | company |
100%
|
| business_range |
87.86%
|
||
| description |
12.14%
|
||
| telephone |
99.96%
|
||
| linkman |
15.8%
|
||
| mobile_telephone |
37.87%
|
||
| contact_telephone |
87.76%
|
||
| post_code |
13.04%
|
||
| address |
66.49%
|
||
| industry |
0%
|
||
| location |
0%
|
||
| company_type |
0.01%
|
||
| establish_time |
0.03%
|
||
| company_introduce |
0%
|
||
| company_type_2 |
87.44%
|
||
| company_size |
17.19%
|
||
| business_type |
3.56%
|
||
| capital |
11.34%
|
||
| company_web |
87.76%
|
||
| fax |
22.72%
|
||
|
3.11%
|
|||
| production_range |
48.21%
|
||
| company_x_industry_1 | 148,012 | company_id |
100%
|
| industry_1_id |
100%
|
||
| industry_1 | 47 | industry_1 |
100%
|
| industry_2 | 0 | industury_2 |
0%
|
| industry_1_id |
0%
|
||
| production | 54,274 | company_id |
100%
|
| product |
100%
|
||
| description |
96.94%
|
||
| price |
98.8%
|
||
| book_count_from |
24.53%
|
||
| store_count |
64.76%
|
||
| production_image_slug | 53,965 | production_id |
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
PRODUCTION_IMAGE
| Size (Bytes) | Files |
|---|---|
| 39.62M | 881 |
