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,
  "n__forestry_fishing_related_activities_and_other" VARCHAR,
  "n__mining" VARCHAR,
  "n__utilities" VARCHAR,
  "n__construction" BIGINT,
  "n__manufacturing" BIGINT,
  "n__wholesale_trade" BIGINT,
  "n__retail_trade" BIGINT,
  "n__transportation_and_warehousing" VARCHAR,
  "n__information" BIGINT,
  "n__finance_and_insurance" BIGINT,
  "n__real_estate_and_rental_and_leasing" BIGINT,
  "n__professional_and_technical_services" BIGINT,
  "n__management_of_companies_and_enterprises" BIGINT,
  "n__administrative_and_waste_services" BIGINT,
  "n__educational_services" BIGINT,
  "n__health_care_and_social_assistance" BIGINT,
  "n__arts_entertainment_and_recreation" BIGINT,
  "n__accommodation_and_food_services" BIGINT,
  "n__other_services_except_public_administration" BIGINT,
  "government_and_government_enterprises" BIGINT,
  "federal_civilian" BIGINT,
  "military" BIGINT,
  "state_and_local" BIGINT,
  "employment_state" BIGINT,
  "local" BIGINT
);