Cocaine,Opioids,Cannabis And Illicit Drugs

CREATE TABLE death_rate_amphetamine (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_amphetamine_use_disorders_sex_both_age_age_stan_465866c5" DOUBLE  -- Deaths - Amphetamine Use Disorders - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE death_rate_from_opioid_use (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_opioid_use_disorders_sex_both_age_age_standardized_rate" DOUBLE  -- Deaths - Opioid Use Disorders - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE death_rates_cocaine (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cocaine_use_disorders_sex_both_age_age_standard_8eb604ca" DOUBLE  -- Deaths - Cocaine Use Disorders - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE death_rates_from_drug_use_disorders (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_age_standardized_rate" DOUBLE  -- Deaths - Drug Use Disorders - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE deaths_drug_overdoses (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_opioid_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Opioid Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_cocaine_use_disorders_sex_both_age_all_ages_number" BIGINT  -- Deaths - Cocaine 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)
);

CREATE TABLE deaths_due_to_illicit_drug_use_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_15__8e21ae41" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: 15-49 Years (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_50__b4bba410" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: 50-69 Years (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_und_cbcc5844" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_5_1_0b52f46c" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: 5-14 Years (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_70__7c57f377" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: 70+ Years (Number)
);

CREATE TABLE deaths_from_drug_use_disorders_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_under_5_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: Under 5 (Number),
  "deaths_drug_use_disorders_sex_both_age_70_years_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: 70+ Years (Number),
  "deaths_drug_use_disorders_sex_both_age_15_49_years_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: 15-49 Years (Number),
  "deaths_drug_use_disorders_sex_both_age_50_69_years_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: 50-69 Years (Number),
  "deaths_drug_use_disorders_sex_both_age_5_14_years_number" BIGINT  -- Deaths - Drug Use Disorders - Sex: Both - Age: 5-14 Years (Number)
);

CREATE TABLE deaths_illicit_drugs (
  "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_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)
);

CREATE TABLE drug_disorder_dalys_rate (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_drug_use_disorder_fa9ea1cc" DOUBLE  -- DALYs (Disability-Adjusted Life Years) - Drug Use Disorders - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE drug_overdose_death_rates (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "any_opioids_cdc_wonder_2017" DOUBLE  -- Any Opioids (CDC WONDER (2017)),
  "cocaine_cdc_wonder_2017" DOUBLE  -- Cocaine (CDC WONDER (2017)),
  "heroin_cdc_wonder_2017" DOUBLE  -- Heroin (CDC WONDER (2017)),
  "opioid_pain_relievers_cdc_wonder_2017" DOUBLE  -- Opioid Pain Relievers (CDC WONDER (2017))
);

CREATE TABLE mental_health_as_risk_for_drug_dependency (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "increased_risk_of_illicit_drug_dependency" DOUBLE
);

CREATE TABLE prevalence_of_drug_use_disorders_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_drug_use_disorders_sex_both_age_30_to_34_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 30 To 34 (Percent),
  "prevalence_drug_use_disorders_sex_both_age_10_to_14_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 10 To 14 (Percent),
  "prevalence_drug_use_disorders_sex_both_age_15_to_19_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 15 To 19 (Percent),
  "prevalence_drug_use_disorders_sex_both_age_25_to_29_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 25 To 29 (Percent),
  "prevalence_drug_use_disorders_sex_both_age_all_ages_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: All Ages (Percent),
  "prevalence_drug_use_disorders_sex_both_age_20_to_24_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 20 To 24 (Percent),
  "prevalence_drug_use_disorders_sex_both_age_70_years_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 70+ Years (Percent),
  "prevalence_drug_use_disorders_sex_male_age_5_14_years_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Male - Age: 5-14 Years (Percent),
  "prevalence_drug_use_disorders_sex_both_age_15_49_years_percent" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: 15-49 Years (Percent),
  "prevalence_drug_use_disorders_sex_both_age_age_standar_590453ec" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: Age-standardized (Percent)
);

CREATE TABLE prevalence_of_drug_use_disorders_males_vs_females (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_drug_use_disorders_sex_male_age_age_standar_482b0da2" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Male - Age: Age-standardized (Percent),
  "prevalence_drug_use_disorders_sex_female_age_age_stand_2a9f1421" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Female - Age: Age-standardized (Percent),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

CREATE TABLE share_with_drug_use_disorders (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_drug_use_disorders_sex_both_age_age_standar_590453ec" DOUBLE  -- Prevalence - Drug Use Disorders - Sex: Both - Age: Age-standardized (Percent)
);