About this Dataset

DPSCS Facility-Specific Data Template - 2005 To 2015

The Department of Public Safety and Correctional Services (DPSCS) submits these data to the Governor's Office each month for each of Maryland's prisons and jails. This dataset shows totals across those facilities: population totals, contraband seizures, searches, assaults, hearing officer reports, disciplinary action, identification document issuance, and IWIF statistics. Statistical analyses and data formatting are performed by Department of Information Technology (DoIT).
Organization: State of Maryland
Last updated: 2022-02-07T23:35:35.612077
Tags: assault, contraband, correctional-officer, corrections, department-of-public-safety-and-correctional-services, doc, dpscs, hearing-officer, jail, prison, public-safety
Tables

Table 1

@usgov.state_of_maryland_dpscs_facility_specific_template_2005_to_2015.table_1
2.78 MB
2,070 rows
232 columns
CREATE TABLE table_1 (
  "month_number" BIGINT,
  "row_identifier" VARCHAR,
  "facility" VARCHAR,
  "region" VARCHAR,
  "month" VARCHAR,
  "calendar_year" VARCHAR,
  "fiscal_year" VARCHAR,
  "population_adp" DOUBLE  -- Population - ADP,
  "population_adp_analysis" VARCHAR  -- Population - ADP : Analysis,
  "inmates_with_current_release_dates_within_next_3_months" DOUBLE,
  "inmates_with_current_release_dates_within_next_3_month_a0d7308d" VARCHAR  -- Inmates With Current Release Dates Within Next 3 Months: Analysis,
  "escapes" DOUBLE,
  "escapes_analysis" VARCHAR  -- Escapes: Analysis,
  "walk_offs" DOUBLE,
  "walk_offs_analysis" VARCHAR  -- Walk-Offs: Analysis,
  "firm_assaults_on_staff_serious_physical_assault" DOUBLE  -- FIRM Assaults On Staff : Serious Physical Assault,
  "firm_assaults_on_staff_serious_physical_assault_analysis" VARCHAR  -- FIRM Assaults On Staff : Serious Physical Assault: Analysis,
  "firm_assaults_on_staff_serious_weapon_assault" DOUBLE  -- FIRM Assaults On Staff : Serious Weapon Assault,
  "firm_assaults_on_staff_serious_weapon_assault_analysis" VARCHAR  -- FIRM Assaults On Staff : Serious Weapon Assault: Analysis,
  "firm_assaults_on_staff_sexual_assault" DOUBLE  -- FIRM Assaults On Staff : Sexual Assault,
  "firm_assaults_on_staff_sexual_assault_analysis" VARCHAR  -- FIRM Assaults On Staff : Sexual Assault: Analysis,
  "firm_assaults_on_staff_less_serious_physical_assault" DOUBLE  -- FIRM Assaults On Staff : Less Serious Physical Assault,
  "firm_assaults_on_staff_less_serious_physical_assault_analysis" VARCHAR  -- FIRM Assaults On Staff : Less Serious Physical Assault: Analysis,
  "firm_assaults_on_staff_less_serious_weapon_assault" DOUBLE  -- FIRM Assaults On Staff : Less Serious Weapon Assault,
  "firm_assaults_on_staff_less_serious_weapon_assault_analysis" VARCHAR  -- FIRM Assaults On Staff : Less Serious Weapon Assault: Analysis,
  "firm_assaults_on_staff_bodily_fluid_assault" DOUBLE  -- FIRM Assaults On Staff : Bodily Fluid Assault,
  "firm_assaults_on_staff_bodily_fluid_assault_analysis" VARCHAR  -- FIRM Assaults On Staff : Bodily Fluid Assault: Analysis,
  "firm_assaults_on_staff_inappropriate_physical_contact" DOUBLE  -- FIRM Assaults On Staff : Inappropriate Physical Contact,
  "firm_assaults_on_staff_inappropriate_physical_contact_analysis" VARCHAR  -- FIRM Assaults On Staff : Inappropriate Physical Contact: Analysis,
  "firm_assaults_on_staff_total" DOUBLE  -- FIRM Assaults On Staff : Total,
  "firm_assaults_on_staff_total_analysis" VARCHAR  -- FIRM Assaults On Staff : Total: Analysis,
  "firm_assaults_on_staff_staff_homicide" DOUBLE  -- FIRM Assaults On Staff : Staff Homicide,
  "firm_assaults_on_staff_staff_homicide_analysis" VARCHAR  -- FIRM Assaults On Staff : Staff Homicide: Analysis,
  "firm_assaults_on_inmates_serious_physical_assault" DOUBLE  -- FIRM Assaults On Inmates: Serious Physical Assault,
  "firm_assaults_on_inmates_serious_physical_assault_analysis" VARCHAR  -- FIRM Assaults On Inmates: Serious Physical Assault: Analysis,
  "firm_assaults_on_inmates_serious_weapon_assault" DOUBLE  -- FIRM Assaults On Inmates: Serious Weapon Assault,
  "firm_assaults_on_inmates_serious_weapon_assault_analysis" VARCHAR  -- FIRM Assaults On Inmates: Serious Weapon Assault: Analysis,
  "firm_assaults_on_inmates_sexual_assault" DOUBLE  -- FIRM Assaults On Inmates: Sexual Assault,
  "firm_assaults_on_inmates_sexual_assault_analysis" VARCHAR  -- FIRM Assaults On Inmates: Sexual Assault: Analysis,
  "firm_assaults_on_inmates_less_serious_physical_assault" DOUBLE  -- FIRM Assaults On Inmates: Less Serious Physical Assault,
  "firm_assaults_on_inmates_less_serious_physical_assault_analysis" VARCHAR  -- FIRM Assaults On Inmates: Less Serious Physical Assault: Analysis,
  "firm_assaults_on_inmates_less_serious_weapon_assault" DOUBLE  -- FIRM Assaults On Inmates: Less Serious Weapon Assault,
  "firm_assaults_on_inmates_less_serious_weapon_assault_analysis" VARCHAR  -- FIRM Assaults On Inmates: Less Serious Weapon Assault: Analysis,
  "firm_assaults_on_inmates_bodily_fluid_assault" DOUBLE  -- FIRM Assaults On Inmates: Bodily Fluid Assault,
  "firm_assaults_on_inmates_bodily_fluid_assault_analysis" VARCHAR  -- FIRM Assaults On Inmates: Bodily Fluid Assault: Analysis,
  "firm_assaults_on_inmates_total" DOUBLE  -- FIRM Assaults On Inmates: Total,
  "firm_assaults_on_inmates_total_analysis" VARCHAR  -- FIRM Assaults On Inmates: Total: Analysis,
  "firm_assaults_on_inmates_inmate_homicide" DOUBLE  -- FIRM Assaults On Inmates: Inmate Homicide,
  "firm_assaults_on_inmates_inmate_homicide_analysis" VARCHAR  -- FIRM Assaults On Inmates: Inmate Homicide: Analysis,
  "firm_assaults_on_inmates_suicides" DOUBLE  -- FIRM Assaults On Inmates: Suicides,
  "firm_assaults_on_inmates_suicides_analysis" VARCHAR  -- FIRM Assaults On Inmates: Suicides: Analysis,
  "housing_areas_searched_non_routine" DOUBLE  -- Housing Areas Searched (Non-Routine),
  "housing_areas_searched_non_routine_analysis" VARCHAR  -- Housing Areas Searched (Non-Routine): Analysis,
  "contraband_found_on_inmates_or_in_facility_cds" DOUBLE  -- Contraband Found On Inmates Or In Facility: CDS,
  "contraband_found_on_inmates_or_in_facility_cds_analysis" VARCHAR  -- Contraband Found On Inmates Or In Facility: CDS: Analysis,
  "contraband_found_on_inmates_or_in_facility_cell_phones" DOUBLE  -- Contraband Found On Inmates Or In Facility: Cell Phones,
  "contraband_found_on_inmates_or_in_facility_cell_phones_analysis" VARCHAR  -- Contraband Found On Inmates Or In Facility: Cell Phones: Analysis,
  "contraband_found_on_inmates_or_in_facility_commercial_knives" DOUBLE  -- Contraband Found On Inmates Or In Facility: Commercial Knives,
  "contraband_found_on_inmates_or_in_facility_commercial__c9c21a03" VARCHAR  -- Contraband Found On Inmates Or In Facility: Commercial Knives: Analysis,
  "contraband_found_on_inmates_or_in_facility_inmate_made_knives" DOUBLE  -- Contraband Found On Inmates Or In Facility: Inmate Made Knives,
  "contraband_found_on_inmates_or_in_facility_inmate_made_ffda6039" VARCHAR  -- Contraband Found On Inmates Or In Facility: Inmate Made Knives: Analysis,
  "contraband_found_on_inmates_or_in_facility_money" DOUBLE  -- Contraband Found On Inmates Or In Facility: Money,
  "contraband_found_on_inmates_or_in_facility_money_analysis" VARCHAR  -- Contraband Found On Inmates Or In Facility: Money: Analysis,
  "contraband_found_on_inmates_or_in_facility_tobacco" DOUBLE  -- Contraband Found On Inmates Or In Facility: Tobacco,
  "contraband_found_on_inmates_or_in_facility_tobacco_analysis" VARCHAR  -- Contraband Found On Inmates Or In Facility: Tobacco: Analysis,
  "contraband_found_on_inmates_or_in_facility_total" DOUBLE  -- Contraband Found On Inmates Or In Facility: Total,
  "contraband_found_on_inmates_or_in_facility_total_analysis" VARCHAR  -- Contraband Found On Inmates Or In Facility: Total: Analysis,
  "contraband_found_on_staff_cds" DOUBLE  -- Contraband Found On Staff: CDS,
  "contraband_found_on_staff_cds_analysis" VARCHAR  -- Contraband Found On Staff: CDS: Analysis,
  "contraband_found_on_staff_cell_phones" DOUBLE  -- Contraband Found On Staff: Cell Phones,
  "contraband_found_on_staff_cell_phones_analysis" VARCHAR  -- Contraband Found On Staff: Cell Phones: Analysis,
  "contraband_found_on_staff_commercial_knives" DOUBLE  -- Contraband Found On Staff: Commercial Knives,
  "contraband_found_on_staff_commercial_knives_analysis" VARCHAR  -- Contraband Found On Staff: Commercial Knives: Analysis,
  "contraband_found_on_staff_tobacco" DOUBLE  -- Contraband Found On Staff: Tobacco,
  "contraband_found_on_staff_tobacco_analysis" VARCHAR  -- Contraband Found On Staff: Tobacco: Analysis,
  "contraband_found_on_staff_total" DOUBLE  -- Contraband Found On Staff: Total,
  "contraband_found_on_staff_total_analysis" VARCHAR  -- Contraband Found On Staff: Total: Analysis,
  "hearing_officer_reports_alcohol_use_possession" DOUBLE  -- Hearing Officer Reports: Alcohol Use/Possession,
  "hearing_officer_reports_alcohol_use_possession_analysis" VARCHAR  -- Hearing Officer Reports: Alcohol Use/Possession: Analysis,
  "hearing_officer_reports_drug_use_cases" DOUBLE  -- Hearing Officer Reports: Drug Use Cases,
  "hearing_officer_reports_drug_use_cases_analysis" VARCHAR  -- Hearing Officer Reports: Drug Use Cases: Analysis,
  "hearing_officer_reports_contraband_weapons" DOUBLE  -- Hearing Officer Reports: Contraband: Weapons,
  "hearing_officer_reports_contraband_weapons_analysis" VARCHAR  -- Hearing Officer Reports: Contraband: Weapons: Analysis,
  "hearing_officer_reports_drugs_paraphernalia" DOUBLE  -- Hearing Officer Reports: Drugs/Paraphernalia,
  "hearing_officer_reports_drugs_paraphernalia_analysis" VARCHAR  -- Hearing Officer Reports: Drugs/Paraphernalia: Analysis,
  "hearing_officer_reports_money" DOUBLE  -- Hearing Officer Reports: Money,
  "hearing_officer_reports_money_analysis" VARCHAR  -- Hearing Officer Reports: Money: Analysis,
  "hearing_officer_reports_total" DOUBLE  -- Hearing Officer Reports: Total,
  "hearing_officer_reports_total_analysis" VARCHAR  -- Hearing Officer Reports: Total: Analysis,
  "iiu_cases_assigned_investigations_of_inmates_number_of_7dba1ceb" DOUBLE  -- IIU - Cases Assigned: Investigations Of Inmates: Number Of Criminal Cases,
  "iiu_cases_assigned_investigations_of_inmates_number_of_44d00539" VARCHAR  -- IIU - Cases Assigned: Investigations Of Inmates: Number Of Criminal Cases : Analysis,
  "iiu_cases_assigned_investigations_of_inmates_number_of_eb73be14" DOUBLE  -- IIU - Cases Assigned: Investigations Of Inmates: Number Of Administrative Cases,
  "iiu_cases_assigned_investigations_of_inmates_number_of_7bdeb039" VARCHAR  -- IIU - Cases Assigned: Investigations Of Inmates: Number Of Administrative Cases: Analysis,
  "iiu_cases_assigned_investigations_of_inmates_number_of_0ddc6bd8" DOUBLE  -- IIU - Cases Assigned: Investigations Of Inmates: Number Of Incident Report Cases,
  "iiu_cases_assigned_investigations_of_inmates_number_of_62dec791" VARCHAR  -- IIU - Cases Assigned: Investigations Of Inmates: Number Of Incident Report Cases: Analysis,
  "iiu_cases_assigned_investigations_of_inmates_total_cas_0b038fe9" DOUBLE  -- IIU - Cases Assigned: Investigations Of Inmates: Total Cases Assigned,
  "iiu_cases_assigned_investigations_of_inmates_total_cas_ff70d7cd" VARCHAR  -- IIU - Cases Assigned: Investigations Of Inmates: Total Cases Assigned: Analysis,
  "iiu_cases_assigned_investigations_of_staff_number_of_c_a6888d31" DOUBLE  -- IIU - Cases Assigned: Investigations Of Staff: Number Of Criminal Cases,
  "iiu_cases_assigned_investigations_of_staff_number_of_c_45b732b2" VARCHAR  -- IIU - Cases Assigned: Investigations Of Staff: Number Of Criminal Cases : Analysis,
  "iiu_cases_assigned_investigations_of_staff_number_of_a_8d7aab0d" DOUBLE  -- IIU - Cases Assigned: Investigations Of Staff: Number Of Administrative Cases
);