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
);

CREATE TABLE death_rate_from_opioid_use (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_opioid_use_disorders_sex_both_age_age_standardized_rate" DOUBLE
);

CREATE TABLE death_rates_cocaine (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cocaine_use_disorders_sex_both_age_age_standard_8eb604ca" DOUBLE
);

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
);

CREATE TABLE deaths_drug_overdoses (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_opioid_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_cocaine_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
);

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_50__b4bba410" BIGINT,
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_und_cbcc5844" BIGINT,
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_5_1_0b52f46c" BIGINT,
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_70__7c57f377" BIGINT
);

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_70_years_number" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_15_49_years_number" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_50_69_years_number" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_5_14_years_number" BIGINT
);

CREATE TABLE deaths_illicit_drugs (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_drug_use_disorders_sex_both_age_all_ages_number" BIGINT,
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_all_ff53b46e" BIGINT
);

CREATE TABLE drug_disorder_dalys_rate (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "dalys_disability_adjusted_life_years_drug_use_disorder_fa9ea1cc" DOUBLE
);

CREATE TABLE drug_overdose_death_rates (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "any_opioids_cdc_wonder_2017" DOUBLE,
  "cocaine_cdc_wonder_2017" DOUBLE,
  "heroin_cdc_wonder_2017" DOUBLE,
  "opioid_pain_relievers_cdc_wonder_2017" DOUBLE
);

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_10_to_14_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_15_to_19_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_25_to_29_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_all_ages_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_20_to_24_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_70_years_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_male_age_5_14_years_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_15_49_years_percent" DOUBLE,
  "prevalence_drug_use_disorders_sex_both_age_age_standar_590453ec" DOUBLE
);

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_female_age_age_stand_2a9f1421" DOUBLE,
  "population_historical_estimates" DOUBLE,
  "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
);