该招聘数据库共有15个表，其中有42,489个招聘信息的岗位表；480个记录的城市表；5,691个公司的企业表；595个公司详情记录表（该公司详情表中包含有产业，规模，类型，网站地址，公司地址，交通路线，地区，简介等）；328个专业记录表；803个记录的职位表；306个职位所在城市的记录表；35个记录的地区表以及437个记录的公司福利表。在就业岗位表中，每个就业信息包含有岗位名称，受教育程度，薪资待遇，工作经验，工作所在地，工作时间，工作内容描述，招聘数量，招聘类型，地址等字段。此招聘信息数据库中的所有招聘信息来源于中国35个地区的480个城市。
请注意：该数据库动态性较强，所以可以根据用户需求提供更新。
China jobs database has a total of 42,489 jobs records from 5,691 companies over 480 cities in 35 regions. Each job record consists of title, education, salary, experience, location, time, description, quantity, type, address and salary from/to/other/unit. In table company detail, there are industry, size, type, website, address, subway, area, description and company id in each record.
From this fields-rich jobs database, it also has other important tables, such as major with 328 records; position with 803 records; position city with 306 records and welfare with 437 records. The whole China recruitment database has 15 tables.
Please NOTE: These data are more dynamic so it can be updated as your needs.
| Name | n3_lyz_cjol.com |
|---|---|
| Data | 148.30M (+ 0B) |
| Tables | 15 (+ 0) |
| Columns | 78 (+ 0) |
| Table Rows | 538,550 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 480 | city |
100%
|
| region_id |
100%
|
||
| city_x_job | 51,937 | city_id |
100%
|
| job_id |
100%
|
||
| company | 5,691 | company |
100%
|
| company_detail | 595 | industry |
100%
|
| size |
100%
|
||
| type |
100%
|
||
| website |
83.36%
|
||
| address |
100%
|
||
| subway |
100%
|
||
| area |
100%
|
||
| description |
100%
|
||
| company_id |
100%
|
||
| job | 42,489 | title |
100%
|
| education |
100%
|
||
| salary |
100%
|
||
| experience |
99.94%
|
||
| location |
100%
|
||
| time |
100%
|
||
| description |
99.84%
|
||
| quantity |
99.84%
|
||
| type |
99.84%
|
||
| address |
90.23%
|
||
| salary_from |
99.06%
|
||
| salary_to |
98.94%
|
||
| salary_other |
0.94%
|
||
| salary_unit |
99.06%
|
||
| job_x_company | 42,672 | job_id |
100%
|
| company_id |
100%
|
||
| job_x_major | 51,401 | job_id |
100%
|
| major_id |
100%
|
||
| job_x_position_city | 42,423 | job_id |
100%
|
| position_city_id |
100%
|
||
| job_x_welfare | 288,121 | job_id |
100%
|
| welfare_id |
100%
|
||
| major | 328 | major |
100%
|
| position | 803 | position |
100%
|
| position_city | 306 | city |
100%
|
| position_city_x_position | 10,832 | position_city_id |
100%
|
| position_id |
100%
|
||
| region | 35 | title |
100%
|
| welfare | 437 | 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
No media sets.
