Bulgarian Admissions To Correctional Facilities Jan 2018 - Nov 2024
@eufairpresons.bulgarian_admissions_to_correctional_facilities_jan_20_91638aaa
@eufairpresons.bulgarian_admissions_to_correctional_facilities_jan_20_91638aaa
Semantically annotated data conforming to the RRAO ontology (http://w3id.org/rrao#), related to admissions to correctional facilities (n=76,520) of imprisoned persons (m=33,171) from Jan 2018 up to Nov. 2024 (a period of six years and ten months). The data was extracted from the Execution of Sentences Information System (ESIS), a centralised system managed by the General Directorate Execution of Sentences, which operates across all prison facilities and probation services in Bulgaria. Sensitive information kept in the dataset has been anonymized
Last updated: 2025-03-22T20:07:24Z
CREATE TABLE bulgarian_admissions_to_correctional_facilities_jan_20_91638aaa (
"n_1" DOUBLE -- 1,
"n_1_1_1" VARCHAR -- 1.1.1,
"n_1_1_3" DOUBLE -- 1.1.3,
"n_1_1_4" DOUBLE -- 1.1.4,
"n_1_2" VARCHAR -- 1.2,
"n_1_4" DOUBLE -- 1.4,
"n_1_5" VARCHAR -- 1.5,
"n_1_6" VARCHAR -- 1.6,
"n_1_7" VARCHAR -- 1.7,
"n_1_9" VARCHAR -- 1.9,
"n_1_10" VARCHAR -- 1.10,
"n_1_11" VARCHAR -- 1.11,
"n_2_2_1" VARCHAR -- 2.2.1,
"n_2_2_2" DOUBLE -- 2.2.2,
"n_2_5_1" VARCHAR -- 2.5.1,
"n_2_5_2" VARCHAR -- 2.5.2,
"n_2_6" VARCHAR -- 2.6,
"n_2_10" VARCHAR -- 2.10,
"n_3_2_1" VARCHAR -- 3.2.1,
"n_3_2_2" DOUBLE -- 3.2.2,
"n_3_3_5" VARCHAR -- 3.3.5,
"n_3_4" DOUBLE -- 3.4,
"n_3_4_1" VARCHAR -- 3.4.1,
"n_3_4_2" VARCHAR -- 3.4.2,
"n_3_4_4" VARCHAR -- 3.4.4,
"n_3_4_4_1" VARCHAR -- 3.4.4.1,
"n_3_4_4_2" VARCHAR -- 3.4.4.2,
"n_3_4_4_3" VARCHAR -- 3.4.4.3,
"n_3_4_4_4" VARCHAR -- 3.4.4.4,
"n_3_4_4_5" VARCHAR -- 3.4.4.5,
"n_3_4_4_6" VARCHAR -- 3.4.4.6,
"n_4_2_1" VARCHAR -- 4.2.1,
"n_4_2_2" DOUBLE -- 4.2.2,
"n_4_3" VARCHAR -- 4.3,
"n_4_4" DOUBLE -- 4.4,
"n_4_4_1" VARCHAR -- 4.4.1,
"n_4_4_2" VARCHAR -- 4.4.2,
"n_5_2_1" VARCHAR -- 5.2.1,
"n_5_2_2" DOUBLE -- 5.2.2,
"n_5_3" VARCHAR -- 5.3,
"n_5_3_1" VARCHAR -- 5.3.1,
"n_5_3_2" VARCHAR -- 5.3.2,
"n_5_3_3" VARCHAR -- 5.3.3,
"n_5_4" VARCHAR -- 5.4,
"n_5_7" VARCHAR -- 5.7,
"n_5_8" VARCHAR -- 5.8,
"n_5_12" DOUBLE -- 5.12,
"n_5_13" VARCHAR -- 5.13,
"n_5_14" VARCHAR -- 5.14,
"n_5_15" VARCHAR -- 5.15,
"n_5_16" VARCHAR -- 5.16,
"n_6_1" VARCHAR -- 6.1,
"n_6_1_1" DOUBLE -- 6.1.1,
"complete_prisoner_id" BIGINT,
"prison_id" DOUBLE,
"record_id" BIGINT,
"age_of_entering_prison" VARCHAR,
"age_of_release" VARCHAR,
"probation" VARCHAR,
"way_of_release" VARCHAR,
"n_2_2_1_court_id" DOUBLE -- 2.2.1 Court Id,
"n_3_2_1_court_id" DOUBLE -- 3.2.1 Court Id,
"n_4_2_1_court_id" DOUBLE -- 4.2.1 Court Id,
"n_5_2_1_court_id" DOUBLE -- 5.2.1. Court Id
);Anyone who has the link will be able to view this.