Name: Alcohol & Drug Treatment Services - Australia
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Alcohol & Drug Treatment Services - Australia

The Alcohol and Other Drug Treatment Services (AODTS) National Minimum Data Set (NMDS) is an annual collection of information regarding the clients who use alcohol and other drug treatment services, the types of drug problems for which treatment is sought and the types of treatment they receive.

From 2015-2021.

Tables

C0c1888c 1be8–4de1 B757 Ca3e67423e1a

@kaggle.joebeachcapital_alcohol_and_drug_treatment_services_australia.c0c1888c_1be8_4de1_b757_ca3e67423e1a

434.91 KB
41680 rows
18 columns


CREATE TABLE c0c1888c_1be8_4de1_b757_ca3e67423e1a (
  "n__id" BIGINT,
  "sector" VARCHAR,
  "area" VARCHAR,
  "sex" BIGINT,
  "agegroup" VARCHAR,
  "country_of_birth" VARCHAR,
  "indigenous_groupings" BIGINT,
  "clienttype" BIGINT,
  "sor_groupings" BIGINT,
  "monthofcommencement" VARCHAR,
  "monthofcessation" VARCHAR,
  "treatmentdurationdays" BIGINT,
  "rfc_grouping" BIGINT,
  "treatmentdeliverysetting" BIGINT,
  "injectingdruguse" BIGINT,
  "principaldrugofconcern" BIGINT,
  "maintreatmenttype" BIGINT,
  "accommodation_groupings" BIGINT
);

Dec48274 A9d2–457b A79a 8db485d7ddb7

@kaggle.joebeachcapital_alcohol_and_drug_treatment_services_australia.dec48274_a9d2_457b_a79a_8db485d7ddb7

509.67 KB
43376 rows
18 columns


CREATE TABLE dec48274_a9d2_457b_a79a_8db485d7ddb7 (
  "n__id" BIGINT,
  "sector" VARCHAR,
  "area" VARCHAR,
  "sex" BIGINT,
  "agegroup" VARCHAR,
  "country_of_birth" VARCHAR,
  "indiggrouping" BIGINT,
  "client_type" BIGINT,
  "sorgrouping" BIGINT,
  "month_of_commencement" TIMESTAMP,
  "month_of_cessation" TIMESTAMP,
  "treatment_duration_days" BIGINT,
  "rfcgrouping" BIGINT,
  "treatment_delivery_setting" BIGINT,
  "injecting_drug_use" BIGINT,
  "principal_drug_of_concern" BIGINT,
  "main_treatment_type" BIGINT,
  "current_accomodation_groupings" BIGINT
);

N 09d5c21d A992–43f1 Bb72–5753a5e2210b

@kaggle.joebeachcapital_alcohol_and_drug_treatment_services_australia.n_09d5c21d_a992_43f1_bb72_5753a5e2210b

452.23 KB
35883 rows
18 columns


CREATE TABLE n_09d5c21d_a992_43f1_bb72_5753a5e2210b (
  "n__id" BIGINT,
  "sector" VARCHAR,
  "area" VARCHAR,
  "sex" BIGINT,
  "age_group" VARCHAR,
  "country_of_birth" VARCHAR,
  "indigenous_group" BIGINT,
  "client_type" BIGINT,
  "sor_groupings" BIGINT,
  "month_of_commencement" TIMESTAMP,
  "month_of_cessation" TIMESTAMP,
  "treatment_duration_days" BIGINT,
  "rfc_grouping" BIGINT,
  "treatment_delivery_setting" BIGINT,
  "injecting_drug_use" BIGINT,
  "principal_drug_of_concern" BIGINT,
  "main_treatment_type" BIGINT,
  "accom_groupings" BIGINT
);

N 4c24f305 Af89–4649–83ed F84ddb16bdde

@kaggle.joebeachcapital_alcohol_and_drug_treatment_services_australia.n_4c24f305_af89_4649_83ed_f84ddb16bdde

424.61 KB
40223 rows
18 columns


CREATE TABLE n_4c24f305_af89_4649_83ed_f84ddb16bdde (
  "n__id" BIGINT,
  "sector" VARCHAR,
  "area" VARCHAR,
  "sex" BIGINT,
  "agegroup" VARCHAR,
  "country_of_birth" VARCHAR,
  "indigenous_groupings" BIGINT,
  "clienttype" BIGINT,
  "sor_groupings" BIGINT,
  "monthofcommencement" VARCHAR,
  "monthofcessation" VARCHAR,
  "treatmentdurationdays" BIGINT,
  "rfc_grouping" BIGINT,
  "treatmentdeliverysetting" BIGINT,
  "injectingdruguse" BIGINT,
  "principaldrugofconcern" BIGINT,
  "maintreatmenttype" BIGINT,
  "accommodation_groupings" BIGINT
);

N 4df60a66–9558–41c6–92e1 Af70a06232a0

@kaggle.joebeachcapital_alcohol_and_drug_treatment_services_australia.n_4df60a66_9558_41c6_92e1_af70a06232a0

548.05 KB
41165 rows
18 columns


CREATE TABLE n_4df60a66_9558_41c6_92e1_af70a06232a0 (
  "n__id" BIGINT,
  "sector" VARCHAR,
  "area" VARCHAR,
  "sex" BIGINT,
  "agegroup" VARCHAR,
  "country_of_birth" VARCHAR,
  "indigenous_group" BIGINT,
  "client_type" BIGINT,
  "sor_groupings" BIGINT,
  "month_of_commencement" TIMESTAMP,
  "month_of_cessation" TIMESTAMP,
  "treatmentdays" DOUBLE,
  "rfc_grouping" BIGINT,
  "treatment_delivery_setting" BIGINT,
  "injecting_drug_use" BIGINT,
  "principal_drug_of_concern" BIGINT,
  "main_treatment_type" BIGINT,
  "accom_groupings" BIGINT
);

N 9196a14d F6d1–4781–8995–83d027b8c084

@kaggle.joebeachcapital_alcohol_and_drug_treatment_services_australia.n_9196a14d_f6d1_4781_8995_83d027b8c084

407.06 KB
38489 rows
18 columns


CREATE TABLE n_9196a14d_f6d1_4781_8995_83d027b8c084 (
  "n__id" BIGINT,
  "sector" VARCHAR,
  "area" VARCHAR,
  "sex" BIGINT,
  "agegroup" VARCHAR,
  "country_of_birth" VARCHAR,
  "indigenous_group" BIGINT,
  "client_type" BIGINT,
  "sor_groupings" BIGINT,
  "month_of_commencement" VARCHAR,
  "monthofcessation" VARCHAR,
  "treatmentdays" BIGINT,
  "rfc_grouping" BIGINT,
  "treatment_delivery_setting" BIGINT,
  "injecting_drug_use" BIGINT,
  "principal_drug_of_concern" BIGINT,
  "main_treatment_type" BIGINT,
  "accommodation_groupings" BIGINT
);