这是一个中国招聘岗位和企业信息的集合，该集合包含有3,495,381个就业岗位信息和249,066家企业信息。在岗位招聘表中包含有名称，企业id，工作地点，工资，发布日期等信息。在公司记录表中包含有名称，公司性质，公司地点，所属行业，职位数等重要的企业信息。除此之外，该中国岗位招聘和企业数据库的企业图片媒体文件夹中还包含有144,183张企业图片。整个数据库共有7个表。
This is a jobs and companies database with 3,495,381 and 249,066 records in each from China. In table job, there are title, company id, gong zuo di dian, gong zi, fa bu ri qi, etc. The company record has title, gong si xing zhi, gong si di dian, suo shu hang ye, zhi wei shu, etc. This China jobs and companies database also comes with 144,183 company images in the 143.10M media package. The whole jobs & companies API has 7 tables.
| Name | n3a2_51job_com |
|---|---|
| Data | 11.50G (+ 170.02M) |
| Tables | 7 (+ 0) |
| Columns | 44 (+ 0) |
| Table Rows | 18,917,747 (+ 2,559,833) |
| Media | 143.15M (+ 0B) |
| Files | 1,081 (+ 0) |
Data Samples
Database APIs
Media Files
- company_image Bytes: 49.12K / Files: 1
- company_image_b Bytes: 143.10M / Files: 1,080
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| company | 249,066 | title |
100%
|
| description |
74.61%
|
||
| company_type |
99.94%
|
||
| city |
97.85%
|
||
| size_from |
69.61%
|
||
| size_to |
95.64%
|
||
| address |
72.85%
|
||
| zipcode |
71.24%
|
||
| website |
0%
|
||
| company_image_origin | 144,183 | company_id |
100%
|
| job | 3,495,381 | title |
100%
|
| company_id |
100%
|
||
| area |
100%
|
||
| salary_from |
97.57%
|
||
| salary_to |
98.56%
|
||
| salary_unit |
98.56%
|
||
| time |
100%
|
||
| quantity |
98.17%
|
||
| tag |
98.17%
|
||
| experience |
68.18%
|
||
| experience_from |
22.37%
|
||
| experience_to |
22.37%
|
||
| degree |
62.4%
|
||
| address |
78.34%
|
||
| other |
12.39%
|
||
| description |
78.79%
|
||
| job_x_welfare | 15,005,472 | job_id |
100%
|
| welfare_id |
100%
|
||
| welfare | 23,645 | welfare |
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
COMPANY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 49.12K | 1 |
COMPANY_IMAGE_B
| Size (Bytes) | Files |
|---|---|
| 143.10M | 1,080 |
