Auto Workers V1

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.

Browse Metadata

Dataset Tables

CAR_ClosedRepurposed Table

Car Closed Repurposed
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