Company Layoffs - Generated
Dataset contains random generated data about company layoffs.
@kaggle.noskeris_company_layoffs_generated
Company Layoffs Data
@kaggle.noskeris_company_layoffs_generated.company_layoffs_data
- 67.21 KB
- 1000 rows
- 12 columns
company_idCompany ID | industry_typeIndustry Type | company_sizeCompany Size | revenue_millionsRevenue Millions | number_of_employeesNumber Of Employees | layoff_monthLayoff Month | layoff_reasonLayoff Reason | layoff_countLayoff Count | market_share_percentageMarket Share Percentage | ceo_tenure_yearsCEO Tenure Years | stock_price_dollarsStock Price Dollars | profit_margin_percentageProfit Margin Percentage |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Finance | Large | 506.6194756929831 | 2387 | 4 | Restructuring | 68 | 23.8299688935644 | 1.102748286095272 | 131.394209223072 | 10.081348276110829 |
| 2 | Finance | Large | 564.1960598267256 | 3971 | 9 | Mergers & Acquisitions | 95 | 34.20776884381435 | 5.844439497844938 | 144.05648998324307 | 11.9023802794417 |
| 3 | Technology | Large | 784.9495269023844 | 2517 | 4 | Financial difficulties | 126 | 34.35887907027428 | 6.7625304480264194 | 106.41156944002046 | 8.882994949891614 |
| 4 | Healthcare | Medium | 547.0489529991148 | 1088 | 5 | Financial difficulties | 75 | 20.0467153711324 | 6.0493332654752345 | 151.27260612868443 | 10.247058883140364 |
| 5 | Technology | Large | 502.2783488902589 | 3083 | 10 | Financial difficulties | 55 | 14.150817507104556 | 5.5244861694405705 | 145.38254183479728 | 9.901549678872357 |
| 6 | Finance | Medium | 481.4036916819823 | 1599 | 3 | Mergers & Acquisitions | 82 | 20.98360058915144 | 7.119292699982841 | 123.37841098039176 | 7.819513163552135 |
| 7 | Healthcare | Large | 707.0802764456521 | 2918 | 11 | Financial difficulties | 101 | 35.43400318266384 | 3.2660491147703388 | 104.15387259866311 | 13.192383843488985 |
| 8 | Technology | Large | 710.1689402217108 | 2046 | 10 | Financial difficulties | 113 | 27.88972841346754 | 0.5425950880023338 | 100.10436629223794 | 12.591305027469708 |
| 9 | Finance | Large | 561.69558930015 | 2972 | 7 | Financial difficulties | 65 | 26.3218280728051 | 2.3349638627881006 | 102.94883626379932 | 16.70475820007526 |
| 10 | Finance | Large | 758.9395255450193 | 3321 | 4 | Financial difficulties | 123 | 28.86313264482711 | 2.822283336441483 | 62.87458542190439 | 11.189371305450326 |
CREATE TABLE company_layoffs_data (
"company_id" BIGINT,
"industry_type" VARCHAR,
"company_size" VARCHAR,
"revenue_millions" DOUBLE,
"number_of_employees" BIGINT,
"layoff_month" BIGINT,
"layoff_reason" VARCHAR,
"layoff_count" BIGINT,
"market_share_percentage" DOUBLE,
"ceo_tenure_years" DOUBLE,
"stock_price_dollars" DOUBLE,
"profit_margin_percentage" DOUBLE
);