"Job Postings - US" on Snowflake
| Field | Type | Comment |
|---|---|---|
| ID | CHAR(24) | Unique identification string for each job posting |
| COMPANY_REPORTED | STRING | Name of the company from the job posting |
| COUNTY_IDS | ARRAY(INTEGER) | Five digit county FIPS codes for the location of the job posting |
| COUNTRY_ID_ALPHA3 | VARCHAR(3) | Three letter ID code for the country of the job posting |
| COUNTRY_ID_NUMERIC | INTEGER | Integer ID code for the country of the job posting |
| MINIMUM_EDUCATION_LEVEL | INTEGER | Integer code for the minimum required education level found in the job posting. 0 = Unspecified/other; 5 = High school diploma or equivalent; 10 = Associate's degree; 15 = Bachelor's degree; 20 = Master's degree; 25 = Doctoral or professional degree |
| END_DATE | DATE | The date the job posting was closed |
| JOB_TYPE_IDS | ARRAY(INTEGER) | Integer codes for the job types of the job posting |
| JOB_TYPE_LABELS | ARRAY(VARCHAR(100)) | Labels for the job types of the job posting |
| LOCATION_REPORTED | STRING | The location string listed in the job posting |
| END_MANUALLY_SET | BOOLEAN | The end date of this job was manually set by Chmura |
| MINIMUM_YEARS_OF_EXPERIENCE_LABEL | STRING | Label for the minimum years of experience bucket for the job posting |
| MINIMUM_YEARS_OF_EXPERIENCE_VALUE | INTEGER | Integer code for the minimum years of experience requirement bucket |
| MSA_IDS | ARRAY(INTEGER) | MSA FIPS codes for the location of the job posting |
| PROGRAM_IDS | ARRAY(INTEGER) | Integer ID codes for the degree programs listed in the job posting |
| PROGRAM_LABELS | ARRAY(STRING) | Labels for the degree programs |
| HARD_SKILL_IDS | ARRAY(INTEGER) | Integer ID codes for the hard skills listed in the job posting |
| HARD_SKILL_LABELS | ARRAY(STRING) | Labels for the hard skills listed in the job posting |
| SOFT_SKILL_IDS | ARRAY(INTEGER) | Integer ID codes for the soft skills listed in the job posting |
| SOFT_SKILL_LABELS | ARRAY(STRING) | Labels for the soft skills listed in the job posting |
| SOC_LABEL | STRING | Label for the 8 digit SOC code the job posting has been classified to |
| SOC_ONET | VARCHAR(10) | 8 digit SOC code the job posting has been classified to |
| SOC_2 | VARCHAR(7) | 2 digit SOC code the job posting has been classified to |
| SOC_4 | VARCHAR(7) | 3 digit SOC code the job posting has been classified to |
| SOC_6 | VARCHAR(7) | 5 digit SOC code the job posting has been classified to |
| SOC_7 | VARCHAR(7) | 6 digit SOC code the job posting has been classified to |
| STAFFING_COMPANY | BOOLEAN | Flag indicating whether the job is from a staffing company |
| START_DATE | DATE | The date the job posting was posted |
| STATE_IDS | ARRAY(INTEGER) | State FIPS codes for US-based jobs |
| BODY_TEXT | STRING | The full text of the posting's job description |
| TITLE_REPORTED | STRING | The job title for the job posting |
| URL | STRING | The URL the job posting can be found at |
| WAGES_YEARLY | INTEGER | Annual wage identified in the job posting, when available (If reported as hourly, this is a conversion from the hourly wage) |
| WAGES_HOURLY | FLOAT | Hourly wage identified in the job posting, when available (If reported as annual, this is a conversion from the annual wage) |
Updated 4 months ago