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

445.35 kB
41,680 rows
18 columns

CREATE TABLE c0c1888c_1be8_4de1_b757_ca3e67423e1a (
  "n__id" BIGINT  -- Id,
  "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

521.91 kB
43,376 rows
18 columns

CREATE TABLE dec48274_a9d2_457b_a79a_8db485d7ddb7 (
  "n__id" BIGINT  -- Id,
  "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

463.08 kB
35,883 rows
18 columns

CREATE TABLE n_09d5c21d_a992_43f1_bb72_5753a5e2210b (
  "n__id" BIGINT  -- Id,
  "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

434.8 kB
40,223 rows
18 columns

CREATE TABLE n_4c24f305_af89_4649_83ed_f84ddb16bdde (
  "n__id" BIGINT  -- Id,
  "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

561.21 kB
41,165 rows
18 columns

CREATE TABLE n_4df60a66_9558_41c6_92e1_af70a06232a0 (
  "n__id" BIGINT  -- Id,
  "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

416.83 kB
38,489 rows
18 columns

CREATE TABLE n_9196a14d_f6d1_4781_8995_83d027b8c084 (
  "n__id" BIGINT  -- Id,
  "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
);