该招聘数据库为来自山东地区53种行业下的11,790家企业提供的517种岗位的95,266条人才招聘信息。每条招聘信息详细的包括了职位内容，学历要求，薪水待遇以及招聘单位的福利内容。
In the jobs database, there are 95,266 records from 11,790 companies in 53 industries over 197 regions of Shan Dong province in China. Each record is comprised of position, salary, education, experience, age, type, quantity, update time, etc. In table company, it has description, type, size, website and address. It also comes with 19 welfare records for these jobs in this data. The whole Shan Dong jobs database totally has 13 tables.
| Name | n3_lyz_qlrc.com |
|---|---|
| Data | 238M (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 68 (+ 0) |
| Table Rows | 1,029,052 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_position_1 | 12 | position |
100%
|
| category_position_2 | 48 | position |
100%
|
| category_position_1_id |
100%
|
||
| category_position_3 | 517 | position |
100%
|
| category_position_2_id |
100%
|
||
| category_position_3_x_job | 157,738 | category_position_3_id |
100%
|
| job_id |
100%
|
||
| company | 11,790 | company |
100%
|
| description |
99.8%
|
||
| type |
99.79%
|
||
| size |
99.8%
|
||
| web_site |
34.48%
|
||
| adress |
89.68%
|
||
| company_x_industry | 17,059 | industry_id |
100%
|
| company_id |
100%
|
||
| industry | 53 | industry |
100%
|
| job | 95,266 | position |
100%
|
| position_duty |
90.54%
|
||
| position_requirment |
90.54%
|
||
| salary_from |
86.69%
|
||
| salary_to |
86.69%
|
||
| salary_unit |
86.69%
|
||
| salary_other |
3.85%
|
||
| education |
90.54%
|
||
| experience |
90.54%
|
||
| age |
90.54%
|
||
| type |
90.54%
|
||
| quantity |
90.54%
|
||
| update_time |
85.52%
|
||
| job_x_company | 54,254 | job_id |
100%
|
| company_id |
100%
|
||
| job_x_region | 86,254 | job_id |
100%
|
| region_id |
100%
|
||
| job_x_welfare | 605,845 | job_id |
100%
|
| welfare_id |
100%
|
||
| region | 197 | region |
100%
|
| welfare | 19 | 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
No media sets.
