Data Dictionary - Analytics Files
Mar 26, 2024
3650
The purpose of this document is to describe the fields and data included in the following files:
- core_company_analytics
- core_ticker_analytics_v2
Note that other aggregates are available upon request.
Core Company Analytics File
| Field Name | Data Type | Description |
| day | date | Date that the row applies to. |
| company_id | string/varchar | The unique identifier for each company-scrape |
| company_name | string/varchar | Readable name of the company |
| created_job_count | integer | The number of jobs that were created on that day. This is measured by the number of unique job URLs on a career site that our scrape found. |
| deleted_job_count | integer | This is measured by the number of unique job URLs that are no longer on a career site that were on the career site on the previous scrape. |
| unique_job_count | integer | This is the number of active jobs on that day. This is measured by the number of unique active job URLs on career sites. |
| active_duration | decimal/float | The mean of the duration (today – job creation date) in days for all jobs that are active on this day. For this calculation the max duration is 180 days. |
Core Ticker Analytics File
| Field Name | Data Type | Description |
| day | date | The date this row applies to. |
| stock_ticker | text/varchar | This is the primary stock ticker for that row. Several company_ids may roll up to a single ticker. Format is stock_ticker | stock_exchange | stock_exchange_country. |
| created_job_count | integer | The number of jobs that were created on that day. This is measured by the number of unique job URLs on a career site that our scrape found. |
| deleted_job_count | integer | This is measured by the number of unique job URLs that are no longer on a career site that were on the career site on the previous scrape. |
| unique_job_count | integer | This is the number of active jobs on that day. This is measured by the number of unique active job URLs on career sites. |
| active_duration | decimal/float | The mean of the duration (today – job creation date) in days for all jobs that are active on this day. For this calculation the max duration is 180 days. |
