该招聘数据库有来自中国282个城市的1,649个招聘信息和53个不同类型的1,187家企业信息。每个招聘信息包含有标题，公司id， 工作性质，城市，区域，发布日期，薪资，工作年限，职位优势，文化水平，金融平台，企业名称，公司全称，企业规模，产业范围等相关字段。整个企业招聘数据库共有16个表。
This jobs database lists 1,649 records from 1,187 companies by 53 company types of 282 cities in China. Each job is comprised of title, company id, job nature, city, district, create time, salary, work year, position advantage, education, finance stage, company name, company fullname, company size, industry field, etc. There are 16 tables in this whole China jobs database.
| Name | n3a2_lagou_com |
|---|---|
| Data | 11.19M (+ 0B) |
| Tables | 16 (+ 0) |
| Columns | 105 (+ 0) |
| Table Rows | 22,271 (+ 0) |
| Media | 180.39M (+ 0B) |
| Files | 1,792 (+ 0) |
Data Samples
Database APIs
Media Files
- company_image Bytes: 117.54M / Files: 740
- company_logo Bytes: 62.86M / Files: 1,052
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 5,508 | title |
100%
|
| city |
100%
|
||
| city | 282 | title |
100%
|
| city_x_company | 1,187 | city_id |
100%
|
| company_id |
100%
|
||
| company | 1,187 | title |
100%
|
| company_short_name |
100%
|
||
| city |
100%
|
||
| industry_field |
100%
|
||
| company_features |
99.92%
|
||
| finance_stage |
100%
|
||
| interview_remark_num |
100%
|
||
| process_rate |
100%
|
||
| approve |
100%
|
||
| country_score |
100%
|
||
| city_score |
100%
|
||
| process |
46.5%
|
||
| gong_si_gui_mo |
46.5%
|
||
| manager_name |
12.38%
|
||
| manager_title |
14.74%
|
||
| manager_content |
8.59%
|
||
| company_content |
46.5%
|
||
| company_history |
12.97%
|
||
| address |
46%
|
||
| latitude |
34.2%
|
||
| longitude |
34.2%
|
||
| province |
33.61%
|
||
| district |
34.04%
|
||
| category_id |
0%
|
||
| company_image_origin | 740 | title |
100%
|
| company_id |
100%
|
||
| company_product | 683 | title |
63.4%
|
| company_id |
100%
|
||
| website |
58.42%
|
||
| product_profile |
31.33%
|
||
| company_type | 53 | title |
100%
|
| company_x_company_type | 846 | company_id |
100%
|
| company_type_id |
100%
|
||
| company_x_fu_li | 2,264 | company_id |
100%
|
| fu_li_id |
100%
|
||
| company_x_job | 0 | company_id |
0%
|
| job_id |
0%
|
||
| fu_li | 197 | title |
100%
|
| job | 1,649 | title |
100%
|
| company_id |
100%
|
||
| job_nature |
100%
|
||
| city |
100%
|
||
| district |
100%
|
||
| create_time |
100%
|
||
| salary |
100%
|
||
| work_year |
100%
|
||
| education |
100%
|
||
| position_advantage |
100%
|
||
| company_label_list |
92.72%
|
||
| finance_stage |
100%
|
||
| company_name |
100%
|
||
| company_fullname |
100%
|
||
| company_size |
100%
|
||
| industry_field |
100%
|
||
| job_advantage |
97.7%
|
||
| job_description |
97.7%
|
||
| website |
97.7%
|
||
| job_label | 668 | title |
100%
|
| job_x_job_label | 7,007 | job_id |
100%
|
| job_label_id |
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 |
|---|---|
| 117.54M | 740 |
COMPANY_LOGO
| Size (Bytes) | Files |
|---|---|
| 62.86M | 1,052 |
