"Job Postings - Global" 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 |
| 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 |
| 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 |
| 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 |
| STAFFING_COMPANY | BOOLEAN | Flag indicating whether the job is from a staffing company |
| START_DATE | DATE | The date the job posting was posted |
| 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 |
Updated 4 months ago