Prince George's County Full And Part Time Jobs By Industry: Historic 2001 To 2018 And Projected 2020 To 2040

CREATE TABLE table_1 (
  "date_created" VARCHAR,
  "year" BIGINT,
  "total_employment" BIGINT,
  "n__farm_employment" BIGINT  -- Farm Employment,
  "n__forestry_fishing_related_activities_and_other" VARCHAR  -- Forestry, Fishing, Related Activities, And Other,
  "n__mining" VARCHAR  -- Mining,
  "n__utilities" VARCHAR  -- Utilities,
  "n__construction" BIGINT  -- Construction,
  "n__manufacturing" BIGINT  -- Manufacturing,
  "n__wholesale_trade" BIGINT  -- Wholesale Trade,
  "n__retail_trade" BIGINT  -- Retail Trade,
  "n__transportation_and_warehousing" VARCHAR  -- Transportation And Warehousing,
  "n__information" BIGINT  -- Information,
  "n__finance_and_insurance" BIGINT  -- Finance And Insurance,
  "n__real_estate_and_rental_and_leasing" BIGINT  -- Real Estate And Rental And Leasing,
  "n__professional_and_technical_services" BIGINT  -- Professional And Technical Services,
  "n__management_of_companies_and_enterprises" BIGINT  -- Management Of Companies And Enterprises,
  "n__administrative_and_waste_services" BIGINT  -- Administrative And Waste Services,
  "n__educational_services" BIGINT  -- Educational Services,
  "n__health_care_and_social_assistance" BIGINT  -- Health Care And Social Assistance,
  "n__arts_entertainment_and_recreation" BIGINT  -- Arts, Entertainment, And Recreation,
  "n__accommodation_and_food_services" BIGINT  -- Accommodation And Food Services,
  "n__other_services_except_public_administration" BIGINT  -- Other Services, Except Public Administration,
  "government_and_government_enterprises" BIGINT,
  "federal_civilian" BIGINT  -- Federal, Civilian,
  "military" BIGINT,
  "state_and_local" BIGINT,
  "employment_state" BIGINT,
  "local" BIGINT
);