| 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) |
| Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
该招聘数据库共有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.
| 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%
|
No media sets.
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2023-01-01 (+ 95 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2022-09-27 (+ 271 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-12-30 (+ 115 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-09-05 (+ 150 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-04-08 (+ 68 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-01-29 (+ 120 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-10-01 (+ 38 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-08-23 (+ 141 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-04-04 (+ 196 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-09-21 (+ 197 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-03-07 (+ 43 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-01-23 (+ 44 d) | 148.30M (+ 0B) | 15 (+ 0) | 78 (+ 0) | 538,550 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-12-09 (+ 29 d) | 148.30M (- 74.72M) | 15 (- 1) | 78 (- 13) | 538,550 (- 42,489) | 0B (+ 0B) | 0 (+ 0) |
| 2018-11-09 (+ 27 d) | 223.02M (+ 30.83M) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-10-13 (+ 29 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-09-13 (+ 34 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-08-09 (+ 27 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-07-12 (+ 31 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-06-10 (+ 31 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-05-10 (+ 28 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-04-11 (+ 38 d) | 192.19M (+ 0B) | 16 (+ 0) | 91 (+ 0) | 581,039 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-03-03 (+ 35 d) | 192.19M (+ 141.75M) | 16 (+ 1) | 91 (+ 17) | 581,039 (+ 42,489) | 0B (+ 0B) | 0 (+ 0) |
| 2018-01-27 | 50.44M | 15 | 74 | 538,550 | 0B | 0 |
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.
