https://api.dol.gov/V1/AutoWorkers
This dataset tells you Auto Companies which are closed or repurposed in the last couple of decades. It also shows you how successful or bad the closure process or the repurpose process is and in which state and city these companies found.
Dataset Tables
CAR_ClosedRepurposed Table
| Column Name | Data Type | Column Description |
|---|---|---|
| Column Name id | Data Type bigint | Column Description Primary key of the table - Primary Key |
| Column Name Number_ID | Data Type bigint | Column Description Unique key of the table |
| Column Name Last_Automaker_Owner | Data Type varchar (150) | Column Description Last auto maker owner |
| Column Name Automaker_Plant_Name | Data Type varchar (500) | Column Description Automaker plant name |
| Column Name City | Data Type varchar (50) | Column Description Automaker plant city |
| Column Name State | Data Type varchar (50) | Column Description Automaker plant state |
| Column Name Plant_Product_Category | Data Type varchar (50) | Column Description Plant product category |
| Column Name Year_Closed_Scheduled_To_Close | Data Type varchar (10) | Column Description Year closed or scheduled to be closed |
| Column Name Current_Conditions | Data Type varchar (50) | Column Description Current condition of the plant |
| Column Name Automotive_Other | Data Type varchar (10) | Column Description Automotive other |
| Column Name Industrial_Automotive_MFG | Data Type varchar (10) | Column Description Industrial automotive manfacturing |
| Column Name Commercial | Data Type varchar (10) | Column Description Commercial |
| Column Name Industrial | Data Type varchar (10) | Column Description Industrial |
| Column Name Logistics_And_Warehousing | Data Type varchar (10) | Column Description Logistics and warehousing |
| Column Name Education | Data Type varchar (10) | Column Description Education |
| Column Name Research_and_Development | Data Type varchar (10) | Column Description Research and Development |
| Column Name Recreational | Data Type varchar (10) | Column Description Recreational |
| Column Name Government | Data Type varchar (10) | Column Description Government |
| Column Name Residential | Data Type varchar (10) | Column Description Residential |
| Column Name Vacant | Data Type varchar (10) | Column Description Vacant |
| Column Name Demolished | Data Type varchar (10) | Column Description Demolished |
| Column Name Specific_Reuse_Notes | Data Type varchar (Max) | Column Description Specific reuse notes |
| Column Name Federal_Incentives_Provided | Data Type varchar (Max) | Column Description Federal Incentives provided |
| Column Name State_Incentives_Provided | Data Type varchar (Max) | Column Description State Incentives provided |
| Column Name Local_Incentives_Provided | Data Type varchar (Max) | Column Description Local Incentives Provided |
| Column Name Local_or_Regional_Foundation_Assistance | Data Type varchar (Max) | Column Description Local or Regional Foundation Assistance |
| Column Name SuccessInPropertyValueRestoration5VS1NS | Data Type varchar (30) | Column Description Success In Property Value Restoration 5 is very successfull and 1 is Not at all successful |
| Column Name SuccessInRestoringJobBase5VS1NS | Data Type varchar (30) | Column Description Success In Restoring Job Base 5 is very successful and 1 is not at all successful |