这是一个综合招聘信息数据库，共有20表，其中267,182就业岗位是由来自8大行业的56,519知名企业提供。这些公司全部来自中国34个地区的345个繁华城市。在此数据库中，招聘岗位按照行业和职位分别有三个不同的三级分类，其中包含8大主行业分类，32个二级行业分类和94,302个三级分类；6个顶级职位分类，18个二级职位分类和61,516个三级职位分类。在岗位表中有岗位名称，工作时间，地区，类型，受教育程度，性别，工作经历，驾照，工作内容描述和薪资待遇字段。公司表中包含公司名称，简介，企业认证，地区，行业，类型，公司建立时间和注册资本。在这个全国大型招聘信息数据库中还包括公司联系相关信息，如公司联系人，手机，座机，邮件地址，企业网址，公司地址等。除此之外，还提供了31个公司福利信息。
请注意：该数据库动态性较强，所以可以根据用户需求提供更新。
This is a comprehensive jobs database with 267,182 records from 56,519 companies in 345 popular cities over 34 regions of China. Each job record consists of title, time, location, type, education, experience, gender, driving license, description and salary from/to/other. In table company, there are title, description, certification, location, industry, type, etc. In this recruitment database, there are 50,526 company related information containing contacter, mobile phone, telephone number, email, website address, etc. in each of company. But beyond that, this China jobs database also comes with 31 companies welfare.
All these jobs are from 8 industries; further grouped by 32 sub-industries and catalogued in 94,302 tertiary classifications by industries. These jobs also has another classifications which are 6 categories in top; 18 secondary classifications and cataloged in 61,516 tertiary classifications by positions. The whole recruitment database has 20 tables.
Please NOTE: These data are more dynamic so it can be updated as your needs.
| Name | n3_lyz_chinahr.com |
|---|---|
| Data | 1.48G (+ 0B) |
| Tables | 20 (+ 0) |
| Columns | 108 (+ 0) |
| Table Rows | 9,401,421 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_industry_1 | 8 | title |
100%
|
| category_industry_2 | 32 | title |
100%
|
| category_industry_1_id |
100%
|
||
| category_industry_3 | 94,302 | title |
100%
|
| category_industry_2_id |
100%
|
||
| category_industry_3_x_job | 2,545,516 | category_industry_3_id |
100%
|
| job_id |
100%
|
||
| category_position_1 | 6 | title |
100%
|
| category_position_2 | 18 | title |
100%
|
| category_position_1_id |
100%
|
||
| category_position_3 | 61,516 | title |
100%
|
| category_position_2_id |
100%
|
||
| category_position_3_x_job | 3,904,044 | category_position_3_id |
100%
|
| job_id |
100%
|
||
| city | 345 | city_no |
100%
|
| city_name |
100%
|
||
| region_id |
100%
|
||
| city_x_category_industry_1 | 2,760 | city_id |
100%
|
| category_industry_1_id |
100%
|
||
| city_x_category_position_1 | 2,070 | city_id |
100%
|
| category_position_1_id |
100%
|
||
| company | 56,519 | title |
100%
|
| description |
93.59%
|
||
| certification |
93.64%
|
||
| location |
93.63%
|
||
| industry |
93.52%
|
||
| type |
93.16%
|
||
| establish |
29.13%
|
||
| registered_capital |
27.11%
|
||
| company_connection | 50,526 | contacter |
47.47%
|
| moble_telephone |
28.3%
|
||
| telephone |
19.37%
|
||
|
26.19%
|
|||
| website |
25.9%
|
||
| address |
99.9%
|
||
| company_id |
100%
|
||
| company_welfare | 31 | title |
100%
|
| company_x_company_welfare | 295,173 | company_id |
100%
|
| company_welfare_id |
100%
|
||
| job | 267,182 | title |
100%
|
| time |
100%
|
||
| location |
97.55%
|
||
| type |
97.56%
|
||
| education |
97.55%
|
||
| expericenc |
97.18%
|
||
| gender |
97.56%
|
||
| driving_license |
94.65%
|
||
| description |
97.55%
|
||
| salary_from |
97.46%
|
||
| salary_to |
97.46%
|
||
| salary_other |
2.54%
|
||
| job_welfare | 31 | title |
100%
|
| job_x_company | 260,643 | job_id |
100%
|
| company_id |
100%
|
||
| job_x_job_welfare | 1,860,665 | job_id |
100%
|
| job_welfare_id |
100%
|
||
| region | 34 | region_no |
100%
|
| region_name |
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.
