Name: Drugs Use
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Drugs Use

A drug is any chemical substance that causes a change in an organism's physiology or psychology when consumed. Drugs are typically distinguished from food and substances that provide nutritional support. Wikipedia

@article{owiddruguse,
author = {Hannah Ritchie and Max Roser},
title = {Drug Use},
journal = {Our World in Data},
year = {2019},
note = {https://ourworldindata.org/drug-use}
}

Tables

Alcohol Drug Use Disorders Share Total Disease

@kaggle.programmerrdai_drugs_use.alcohol_drug_use_disorders_share_total_disease

74.32 kB
6,840 rows
4 columns

CREATE TABLE alcohol_drug_use_disorders_share_total_disease (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_substance_use_dis_ec873260" DOUBLE  -- DALYs (Disability-Adjusted Life Years) - Substance Use Disorders - Sex: Both - Age: All Ages (Percent)
);

Alcohol Or Drug Use Disorders Male Vs Female

@kaggle.programmerrdai_drugs_use.alcohol_or_drug_use_disorders_male_vs_female

146.45 kB
6,921 rows
6 columns

CREATE TABLE alcohol_or_drug_use_disorders_male_vs_female (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_substance_use_disorders_sex_male_age_age_st_7d503aa2" DOUBLE  -- Prevalence - Substance Use Disorders - Sex: Male - Age: Age-standardized (Percent),
  "prevalence_substance_use_disorders_sex_female_age_age__6f33c628" DOUBLE  -- Prevalence - Substance Use Disorders - Sex: Female - Age: Age-standardized (Percent),
  "continent" VARCHAR
);

Death Rates Substance Disorders

@kaggle.programmerrdai_drugs_use.death_rates_substance_disorders

74.32 kB
6,840 rows
4 columns

CREATE TABLE death_rates_substance_disorders (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_substance_use_disorders_sex_both_age_age_standa_faf26953" DOUBLE  -- Deaths - Substance Use Disorders - Sex: Both - Age: Age-standardized (Rate)
);

Deaths Substance Disorders

@kaggle.programmerrdai_drugs_use.deaths_substance_disorders

78.76 kB
6,840 rows
9 columns

CREATE TABLE deaths_substance_disorders (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cocaine_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Cocaine Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_drug_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_opioid_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Opioid Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_alcohol_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Alcohol Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_other_drug_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Other Drug Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_amphetamine_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Amphetamine Use Disorders - Sex: Both - Age: All Ages (Number)
);

Deaths Substance Disorders Age

@kaggle.programmerrdai_drugs_use.deaths_substance_disorders_age

55.2 kB
6,840 rows
8 columns

CREATE TABLE deaths_substance_disorders_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_substance_use_disorders_sex_both_age_70_years_number" BIGINT  -- Deaths - Substance Use Disorders - Sex: Both - Age: 70+ Years (Number),
  "deaths_substance_use_disorders_sex_both_age_50_69_years_number" BIGINT  -- Deaths - Substance Use Disorders - Sex: Both - Age: 50-69 Years (Number),
  "deaths_substance_use_disorders_sex_both_age_15_49_years_number" BIGINT  -- Deaths - Substance Use Disorders - Sex: Both - Age: 15-49 Years (Number),
  "deaths_substance_use_disorders_sex_both_age_under_5_number" BIGINT  -- Deaths - Substance Use Disorders - Sex: Both - Age: Under 5 (Number),
  "deaths_substance_use_disorders_sex_both_age_5_14_years_number" BIGINT  -- Deaths - Substance Use Disorders - Sex: Both - Age: 5-14 Years (Number)
);

Share With Alcohol Or Drug Use Disorders

@kaggle.programmerrdai_drugs_use.share_with_alcohol_or_drug_use_disorders

74.32 kB
6,840 rows
4 columns

CREATE TABLE share_with_alcohol_or_drug_use_disorders (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_substance_use_disorders_sex_both_age_age_st_59cdd33c" DOUBLE  -- Prevalence - Substance Use Disorders - Sex: Both - Age: Age-standardized (Percent)
);

Share With Alcohol Vs Drug Use Disorder

@kaggle.programmerrdai_drugs_use.share_with_alcohol_vs_drug_use_disorder

547.61 kB
56,395 rows
7 columns

CREATE TABLE share_with_alcohol_vs_drug_use_disorder (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_alcohol_use_disorders_sex_both_age_age_stan_2a60c121" DOUBLE  -- Prevalence - Alcohol Use Disorders - Sex: Both - Age: Age-standardized (Percent),
  "prevalence_drug_use_disorders_sex_both_age_age_standar_590453ec" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: Age-standardized (Percent),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Substances Risk Factor Vs Direct Deaths

@kaggle.programmerrdai_drugs_use.substances_risk_factor_vs_direct_deaths

127.85 kB
6,840 rows
8 columns

CREATE TABLE substances_risk_factor_vs_direct_deaths (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_alcohol_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Alcohol Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_tobacco_sex_both_age_all__8cdc14f0" BIGINT  -- Deaths - Cause: All Causes - Risk: Tobacco - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_all_ff53b46e" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_alcohol_use_sex_both_age__c423e43f" BIGINT  -- Deaths - Cause: All Causes - Risk: Alcohol Use - Sex: Both - Age: All Ages (Number)
);