Name Headcount Analytics
Version 1.47
Description Headcount Analytics provides a detailed view of a company's headcount trends. Some key highlights: > Monthly headcount values along with additions & departures each month, with history starting from 2010 > Deep dive into this data broken down by roles and levels > Analyze hiring & layoff trends with growth rates & churn rates > Track geographical composition via data availability by Country, US States and Metros > Gain competitive edge with analysis of employee movement data. This data provides a valuable way to track a company's growth, especially when company's financials are not publicly available. Combine it with our Rounds of Funding or M&A Data to generate custom metrics and get deeper insights.
Timeseries Available from 2010-01-01
Types
Name Category Services Description Count
DepartmentType entity linkspeaker_phone Unique identifier for the type of department in a company. A single department encompasses multiple roles. <1K
HeadCountAccuracyThreshold entity linkspeaker_phone This table stores the details of the entities which breach the accuracy threshold of +/- 40%, when vendor headcount data for the latest month is compared with the latest available self-sourced headcount data. <1K
HeadCountAverageTenure entity linkspeaker_phone The average employee tenure by role, level and department at a given company. 4.1 M
HeadCountAverageTenureUncons entity linkspeaker_phone The average employee tenure by role, level and department at a given company, not aggregated as per the corporate structure applicable for that company. 157.2 K
HeadCountByMetro entity linkspeaker_phone The headcount data by state and city i.e. USA Only. 4.9 M
HeadCountByMetroUncons entity linkspeaker_phone The headcount data for a company by state and city i.e. USA Only. This is not aggregated as per the corporate structure applicable for that company. 79.3 K
HeadCountByMonth entity linktimelinespeaker_phone The headcount data by role (department) and level (profile). 4.0 M
HeadCountByMonthByLevel entity linktimelinespeaker_phone Headcount data by month, broken down by level. History available since 2010. 4.1 M
HeadCountByMonthByRoleDepartment entity linktimelinespeaker_phone Headcount data by month, broken down by role and department. History available since 2010. 4.1 M
HeadCountByMonthBySubRoleUncons entity linktimelinespeaker_phone This table represents the headcount information for a given company broken down by sub-role, and on a by-month basis. This table does NOT contain historical data starting from 2010, but instead, history is built on a go-forward basis. 397.8 K
HeadCountByNextEmployer entity linkspeaker_phone Headcount movement data from current company to next company by role and department. This table represents the movement of N number of employees from 'XYZ' role in a current company to the next company. 72.8 M
HeadCountByNextEmployerLtm entity linkspeaker_phone Headcount movement data from current company to next company by role and department. This table represents the movement of N number of employees from 'XYZ' role in a current company to the next company over the last twelve months. 273.3 K
HeadCountByPreviousEmployer entity linkspeaker_phone Headcount movement data from previous company to current company by role and department. This table represents the movement of N number of employees from a previous company into 'XYZ' role of the current company. 74.9 M
HeadCountByPreviousEmployerLtm entity linkspeaker_phone Headcount movement data from previous company to current company by role and department. This table represents the movement of N number of employees from a previous company into 'XYZ' role of the current company over the last twelve months. 88.8 K
HeadCountByState entity linkspeaker_phone The headcount data by state i.e. USA Only. 3.4 M
HeadCountByStateUncons entity linkspeaker_phone The headcount data for a company by state i.e. USA Only. This is not aggregated as per the corporate structure applicable for that company. 70.8 K
HeadCountByTerritory entity linkspeaker_phone The headcount data by territory. 4.6 M
HeadCountByTerritoryUncons entity linkspeaker_phone The headcount data for a company by territory, not aggregated as per the corporate structure applicable for that company. 802.0 K
HeadCountByTitle entity linkspeaker_phone Headcount data by job title. This table contains headcount values against job titles, which is also mapped to roles & sub-roles. Roles are also used in HeadCountByMonthByRoleDepartment table. Employee count values by role are aggregated from this data. 76.3 M
HeadCountMonthly entity linktimelinespeaker_phone Headcount data by month, history available since 2010. 4.1 M
HeadCountTenure entity linkspeaker_phone The average employee tenure by role or level at a given company. 3.8 M
HeadcountCompany entity linktimelinespeaker_phone The headcount mapping with CiqCompanyId and KeyInstn. 4.1 M
RoleType entity linkspeaker_phone Unique identifier for the type of role in a company. A single role encompasses multiple sub-roles. <1K
SubRoleType entity linkspeaker_phone Unique identifier for the type of sub-role in a company. <1K
24 rows of 24 total
Diagrams
Class
Entity Relationship