Drugs Use by Kaggle | Healthcare

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

72.58 KB
6840 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
);

Alcohol Or Drug Use Disorders Male Vs Female

@kaggle.programmerrdai_drugs_use.alcohol_or_drug_use_disorders_male_vs_female

143.02 KB
6921 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_female_age_age__6f33c628" DOUBLE,
  "continent" VARCHAR
);

Death Rates Substance Disorders

@kaggle.programmerrdai_drugs_use.death_rates_substance_disorders

72.58 KB
6840 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 Disorders Age

@kaggle.programmerrdai_drugs_use.deaths_substance_disorders_age

53.9 KB
6840 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_50_69_years_number" BIGINT,
  "deaths_substance_use_disorders_sex_both_age_15_49_years_number" BIGINT,
  "deaths_substance_use_disorders_sex_both_age_under_5_number" BIGINT,
  "deaths_substance_use_disorders_sex_both_age_5_14_years_number" BIGINT
);

Deaths Substance Disorders

@kaggle.programmerrdai_drugs_use.deaths_substance_disorders

76.92 KB
6840 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_drug_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_opioid_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_alcohol_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_other_drug_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_amphetamine_use_disorders_sex_both_age_all_ages_number" BIGINT
);

Share With Alcohol Or Drug Use Disorders

@kaggle.programmerrdai_drugs_use.share_with_alcohol_or_drug_use_disorders

72.58 KB
6840 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
);

Share With Alcohol Vs Drug Use Disorder

@kaggle.programmerrdai_drugs_use.share_with_alcohol_vs_drug_use_disorder

534.77 KB
56395 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_drug_use_disorders_sex_both_age_age_standar_590453ec" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "continent" VARCHAR
);

Substances Risk Factor Vs Direct Deaths

@kaggle.programmerrdai_drugs_use.substances_risk_factor_vs_direct_deaths

124.85 KB
6840 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_alcohol_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_cause_all_causes_risk_tobacco_sex_both_age_all__8cdc14f0" BIGINT,
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_all_ff53b46e" BIGINT,
  "deaths_cause_all_causes_risk_alcohol_use_sex_both_age__c423e43f" BIGINT
);