Baselight

Maryland Correctional Enterprises: Employees, Wait Lists, Business Units, Staff Members, Work Orders, And Revenues

State of Maryland

@usgov.state_of_maryland_maryland_correctional_enterprises_em_cdb7c39d

Loading...
Loading...

About this Dataset

Maryland Correctional Enterprises: Employees, Wait Lists, Business Units, Staff Members, Work Orders, And Revenues

This dataset shows all data which Maryland Correctional Enterprises reported from May 2007 through July 2015. After which time the Performance Improvement Office asked the Dept of Public Safety and Corrections (DPSCS) to stop reporting it because there was plenty of historical data and marginal utility in continuing to report in on the Portal unless they have a need to. DPSCS will start reporting on it again if there is demand for updated data.
Organization: State of Maryland
Last updated: 2020-11-10T17:25:11.615279
Tags: dpscs, employment, inmate-employment

Tables

Table 1

@usgov.state_of_maryland_maryland_correctional_enterprises_em_cdb7c39d.table_1
  • 158.78 kB
  • 99 rows
  • 129 columns
Loading...
CREATE TABLE table_1 (
  "month" VARCHAR,
  "mcih_number_of_business_units" BIGINT  -- MCIH: Number Of Business Units,
  "rci_number_of_business_units" BIGINT  -- RCI: Number Of Business Units,
  "wci_number_of_business_units" BIGINT  -- WCI: Number Of Business Units,
  "mctc_number_of_business_units" BIGINT  -- MCTC: Number Of Business Units,
  "jci_mhc_number_of_business_units" BIGINT  -- JCI / (MHC): Number Of Business Units,
  "patuxent_number_of_business_units" BIGINT  -- Patuxent: Number Of Business Units,
  "mcij_number_of_business_units" BIGINT  -- MCIJ: Number Of Business Units,
  "mciw_number_of_business_units" BIGINT  -- MCIW: Number Of Business Units,
  "bpruw_number_of_business_units" BIGINT  -- BPRUW : Number Of Business Units,
  "jpru_number_of_business_units" BIGINT  -- JPRU: Number Of Business Units,
  "cmcf_number_of_business_units" BIGINT  -- CMCF: Number Of Business Units,
  "nbci_number_of_business_units" BIGINT  -- NBCI: Number Of Business Units,
  "eci_number_of_business_units" BIGINT  -- ECI: Number Of Business Units,
  "mce_total_number_of_business_units" BIGINT  -- MCE TOTAL: Number Of Business Units,
  "mcih_inmates_employed" BIGINT  -- MCIH: Inmates Employed,
  "rci_inmates_employed" BIGINT  -- RCI: Inmates Employed,
  "wci_inmates_employed" BIGINT  -- WCI: Inmates Employed,
  "mctc_inmates_employed" BIGINT  -- MCTC: Inmates Employed,
  "jci_mhc_inmates_employed" BIGINT  -- JCI / (MHC): Inmates Employed,
  "patuxent_inmates_employed" BIGINT  -- Patuxent: Inmates Employed,
  "mcij_inmates_employed" BIGINT  -- MCIJ: Inmates Employed,
  "mciw_inmates_employed" BIGINT  -- MCIW: Inmates Employed,
  "bpruw_inmates_employed" BIGINT  -- BPRUW: Inmates Employed,
  "drcf_inmates_employed" BIGINT  -- DRCF: Inmates Employed,
  "cmcf_inmates_employed" BIGINT  -- CMCF: Inmates Employed,
  "eci_inmates_employed" BIGINT  -- ECI: Inmates Employed,
  "phpru_inmates_employed" BIGINT  -- PHPRU: Inmates Employed,
  "nbci_inmates_employed" DOUBLE  -- NBCI: Inmates Employed,
  "mce_total_inmates_employed" BIGINT  -- MCE TOTAL: Inmates Employed,
  "mcih_inmates_eligible_but_not_employed_wait_list" BIGINT  -- MCIH: Inmates Eligible But Not Employed (Wait List),
  "rci_inmates_eligible_but_not_employed_wait_list" BIGINT  -- RCI: Inmates Eligible But Not Employed (Wait List),
  "wci_inmates_eligible_but_not_employed_wait_list" BIGINT  -- WCI: Inmates Eligible But Not Employed (Wait List),
  "mctc_inmates_eligible_but_not_employed_wait_list" BIGINT  -- MCTC: Inmates Eligible But Not Employed (Wait List),
  "jci_inmates_eligible_but_not_employed_wait_list" BIGINT  -- JCI: Inmates Eligible But Not Employed (Wait List),
  "patuxent_inmates_eligible_but_not_employed_wait_list" BIGINT  -- Patuxent: Inmates Eligible But Not Employed (Wait List),
  "mcij_inmates_eligible_but_not_employed_wait_list" BIGINT  -- MCIJ: Inmates Eligible But Not Employed (Wait List),
  "mciw_inmates_eligible_but_not_employed_wait_list" BIGINT  -- MCIW: Inmates Eligible But Not Employed (Wait List),
  "bpruw_inmates_eligible_but_not_employed_wait_list" BIGINT  -- BPRUW -: Inmates Eligible But Not Employed (Wait List),
  "drcf_central_warehouse_inmates_eligible_but_not_employ_f556b844" BIGINT  -- DRCF - Central Warehouse: Inmates Eligible But Not Employed (Wait List),
  "cmcf_inmates_eligible_but_not_employed_wait_list" BIGINT  -- CMCF: Inmates Eligible But Not Employed (Wait List),
  "eci_inmates_eligible_but_not_employed_wait_list" BIGINT  -- ECI: Inmates Eligible But Not Employed (Wait List),
  "nbci_inmates_eligible_but_not_employed_wait_list" DOUBLE  -- NBCI: Inmates Eligible But Not Employed (Wait List),
  "mce_total_inmates_eligible_but_not_employed_wait_list" BIGINT  -- MCE TOTAL: Inmates Eligible But Not Employed (Wait List),
  "mcih_mce_staff_members" BIGINT  -- MCIH: MCE Staff Members,
  "rci_mce_staff_members" BIGINT  -- RCI: MCE Staff Members,
  "wci_mce_staff_members" BIGINT  -- WCI: MCE Staff Members,
  "mctc_mce_staff_members" BIGINT  -- MCTC: MCE Staff Members,
  "jci_mce_staff_members" BIGINT  -- JCI: MCE Staff Members,
  "patuxent_mce_staff_members" BIGINT  -- Patuxent: MCE Staff Members,
  "mcij_mce_staff_members" BIGINT  -- MCIJ: MCE Staff Members,
  "mciw_mce_staff_members" BIGINT  -- MCIW: MCE Staff Members,
  "baltimore_city_quick_copy_mce_staff_members" BIGINT  -- Baltimore City - Quick Copy: MCE Staff Members,
  "jessup_central_warehouse_mce_staff_members" BIGINT  -- Jessup - Central Warehouse: MCE Staff Members,
  "cmcf_mce_staff_members" BIGINT  -- CMCF: MCE Staff Members,
  "nbci_mce_staff_members" BIGINT  -- NBCI: MCE Staff Members,
  "eci_mce_staff_members" BIGINT  -- ECI: MCE Staff Members,
  "headquarters_and_field_management_mce_staff_members" BIGINT  -- Headquarters And Field Management: MCE Staff Members,
  "mce_total_mce_staff_members" BIGINT  -- MCE TOTAL: MCE Staff Members,
  "mcih_value_of_mce_work_orders" BIGINT  -- MCIH: Value Of MCE Work Orders,
  "metal_i_and_ii_mcih_value_of_mce_work_orders" DOUBLE  -- Metal I And II - MCIH: Value Of MCE Work Orders,
  "brush_and_carton_mcih_mctc_value_of_mce_work_orders" DOUBLE  -- Brush And Carton - MCIH/MCTC: Value Of MCE Work Orders,
  "picture_frame_mcih_value_of_mce_work_orders" DOUBLE  -- Picture Frame - MCIH: Value Of MCE Work Orders,
  "upholstery_mcih_value_of_mce_work_orders" DOUBLE  -- Upholstery - MCIH: Value Of MCE Work Orders,
  "meat_mcih_value_of_mce_work_orders" DOUBLE  -- Meat - MCIH: Value Of MCE Work Orders,
  "maintainance_services_mcih_value_of_mce_work_orders" DOUBLE  -- Maintainance Services - MCIH: Value Of MCE Work Orders,
  "warehouse_mcih_value_of_mce_work_orders" DOUBLE  -- Warehouse - MCIH: Value Of MCE Work Orders,
  "graphics_rci_value_of_mce_work_orders" DOUBLE  -- Graphics - RCI: Value Of MCE Work Orders,
  "recycling_rci_value_of_mce_work_orders" DOUBLE  -- Recycling - RCI: Value Of MCE Work Orders,
  "agriculture_rci_value_of_mce_work_orders" DOUBLE  -- Agriculture - RCI: Value Of MCE Work Orders,
  "furniture_wci_value_of_mce_work_orders" DOUBLE  -- Furniture - WCI: Value Of MCE Work Orders,
  "partition_mctc_value_of_mce_work_orders" DOUBLE  -- Partition - MCTC: Value Of MCE Work Orders,
  "wood_jci_value_of_mce_work_orders" DOUBLE  -- Wood - JCI: Value Of MCE Work Orders,
  "tag_jci_value_of_mce_work_orders" DOUBLE  -- Tag - JCI: Value Of MCE Work Orders,
  "mattress_jci_value_of_mce_work_orders" DOUBLE  -- Mattress - JCI: Value Of MCE Work Orders,
  "uniform_jci_value_of_mce_work_orders" DOUBLE  -- Uniform - JCI: Value Of MCE Work Orders,
  "sew_jci_value_of_mce_work_orders" DOUBLE  -- Sew - JCI: Value Of MCE Work Orders,
  "sign_patuxent_value_of_mce_work_orders" DOUBLE  -- Sign - Patuxent: Value Of MCE Work Orders,
  "graphics_i_mcij_value_of_mce_work_orders" DOUBLE  -- Graphics I - MCIJ: Value Of MCE Work Orders,
  "graphics_ii_mcij_value_of_mce_work_orders" DOUBLE  -- Graphics II - MCIJ: Value Of MCE Work Orders,
  "quick_copy_mcij_value_of_mce_work_orders" DOUBLE  -- Quick Copy - MCIJ: Value Of MCE Work Orders,
  "sew_flag_mciw_value_of_mce_work_orders" DOUBLE  -- Sew/Flag - MCIW: Value Of MCE Work Orders,
  "mailing_and_distribution_mciw_value_of_mce_work_orders" DOUBLE  -- Mailing And Distribution - MCIW: Value Of MCE Work Orders,
  "data_entry_mciw_value_of_mce_work_orders" DOUBLE  -- Data Entry - MCIW: Value Of MCE Work Orders,
  "design_and_planning_mciw_value_of_mce_work_orders" DOUBLE  -- Design And Planning - MCIW: Value Of MCE Work Orders,
  "quick_copy_baltimore_value_of_mce_work_orders" DOUBLE  -- Quick Copy - Baltimore: Value Of MCE Work Orders,
  "central_warehouse_jessup_value_of_mce_work_orders" DOUBLE  -- Central Warehouse - Jessup: Value Of MCE Work Orders,
  "consolidated_laundry_units_value_of_mce_work_orders" DOUBLE  -- Consolidated Laundry Units: Value Of MCE Work Orders,
  "furniture_restoration_eci_value_of_mce_work_orders" DOUBLE  -- Furniture Restoration - ECI: Value Of MCE Work Orders,
  "graphics_eci_value_of_mce_work_orders" DOUBLE  -- Graphics - ECI: Value Of MCE Work Orders,
  "textiles_eci_value_of_mce_work_orders" DOUBLE  -- Textiles - ECI: Value Of MCE Work Orders,
  "cleaning_products_value_of_mce_work_orders" DOUBLE  -- Cleaning Products : Value Of MCE Work Orders,
  "upholstery_re_upholstery_value_of_mce_work_orders" DOUBLE  -- Upholstery/Re-upholstery: Value Of MCE Work Orders,
  "mce_total_value_of_mce_work_orders" DOUBLE  -- MCE TOTAL: Value Of MCE Work Orders,
  "metal_i_and_ii_mcih_value_of_mce_revenues" DOUBLE  -- Metal I And II - MCIH: Value Of MCE Revenues,
  "brush_and_carton_mcih_mctc_value_of_mce_revenues" DOUBLE  -- Brush And Carton - MCIH/MCTC: Value Of MCE Revenues,
  "picture_frame_mcih_value_of_mce_revenues" DOUBLE  -- Picture Frame - MCIH: Value Of MCE Revenues,
  "upholstery_mcih_value_of_mce_revenues" DOUBLE  -- Upholstery - MCIH: Value Of MCE Revenues,
  "meat_mcih_value_of_mce_revenues" DOUBLE  -- Meat - MCIH: Value Of MCE Revenues,
  "maintainance_services_mcih_value_of_mce_revenues" DOUBLE  -- Maintainance Services - MCIH: Value Of MCE Revenues
);

Share link

Anyone who has the link will be able to view this.