Mental Health
Mental disorders by countries and Date
@kaggle.amirhoseinmousavian_mental_health
Mental disorders by countries and Date
@kaggle.amirhoseinmousavian_mental_health
Mental health is an essential part of people’s lives and society. Poor mental health affects our well-being, our ability to work, and our relationships with friends, family, and community.
Mental health conditions are not uncommon. Hundreds of millions suffer from them yearly, and many more do over their lifetimes. It’s estimated that 1 in 3 women and 1 in 5 men will experience major depression in their lives. Other conditions, such as schizophrenia and bipolar disorder, are less common but still have a large impact on people’s lives.
Mental illnesses are treatable, and the impact they have can be reduced. Despite this, treatment is often lacking or poor quality, and many feel uncomfortable sharing their symptoms with healthcare professionals or people they know. This also makes it difficult to estimate the actual prevalence of mental illnesses.
To support them, it’s essential to have good data to understand these conditions – how, when, and why they occur, how many people are affected by them, and how they can be treated effectively and safely.
Saloni Dattani, Lucas Rodés-Guirao, Hannah Ritchie and Max Roser (2023) - "Mental Health". Published online at OurWorldInData.org. Retrieved from [Online Resource]
CREATE TABLE eating_disorders_prevalence (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"eating_disorders_share_of_population_sex_both_age_age__acd592a8" DOUBLE -- Eating Disorders (share Of Population) - Sex: Both - Age: Age-standardized
);CREATE TABLE eating_disorders_prevalence_by_age (
"entityname" VARCHAR,
"year" VARCHAR
);CREATE TABLE eating_disorders_prevalence_males_vs_females (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"eating_disorders_share_of_population_sex_male_age_age__5a20980a" DOUBLE -- Eating Disorders (share Of Population) - Sex: Male - Age: Age-standardized,
"eating_disorders_share_of_population_sex_female_age_ag_97ed0139" DOUBLE -- Eating Disorders (share Of Population) - Sex: Female - Age: Age-standardized,
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE estimated_prevalence_vs_burden_mental_illnesses (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_share_of_population" DOUBLE -- Prevalence (share Of Population),
"dalys_rate" DOUBLE -- DALYs (rate)
);CREATE TABLE experienced_calmness_a_lot_of_the_day_yesterday_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"experience_calmness_yesterday_dimension_age_15_24_answer_yes" DOUBLE -- Experience Calmness Yesterday - Dimension: (Age?) 15-24 - Answer: Yes,
"experience_calmness_yesterday_dimension_age_25_34_answer_yes" DOUBLE -- Experience Calmness Yesterday - Dimension: (Age?) 25-34 - Answer: Yes,
"experience_calmness_yesterday_dimension_age_35_44_answer_yes" DOUBLE -- Experience Calmness Yesterday - Dimension: (Age?) 35-44 - Answer: Yes,
"experience_calmness_yesterday_dimension_age_45_64_answer_yes" DOUBLE -- Experience Calmness Yesterday - Dimension: (Age?) 45-64 - Answer: Yes,
"experience_calmness_yesterday_dimension_age_65_answer_yes" DOUBLE -- Experience Calmness Yesterday - Dimension: (Age?) 65+ - Answer: Yes
);CREATE TABLE experienced_calmness_a_lot_of_the_day_yesterday_by_gender (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"experience_calmness_yesterday_dimension_gender_male_answer_yes" DOUBLE -- Experience Calmness Yesterday - Dimension: (Gender?) Male - Answer: Yes,
"experience_calmness_yesterday_dimension_gender_female__8955b33f" DOUBLE -- Experience Calmness Yesterday - Dimension: (Gender?) Female - Answer: Yes,
"population" DOUBLE,
"continent" VARCHAR
);CREATE TABLE extremely_important_fund_research_anxiety_depression_v_40643ae2 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh4b_important_for_national_government__5699e552" DOUBLE -- Share - Question: Mh4b - Important For National Government To Fund Research On Anxiety/depression - Answer: Extremely Important - Gender: All - Age Group: All,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE -- GDP Per Capita, PPP (constant 2017 International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE friends_family_anxious_depressed (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh6_friends_family_have_been_anxious_de_4a3aa476" DOUBLE -- Share - Question: Mh6 - Friends/family Have Been Anxious/depressed - Answer: Yes - Gender: All - Age Group: All
);CREATE TABLE importance_government_funding_research_anxiety_depression (
"entityname" VARCHAR,
"year" VARCHAR
);CREATE TABLE importance_science_treating_anxiety_depression (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh3b_how_much_science_helps_to_treat_an_6fb814e1" DOUBLE -- Share - Question: Mh3b - How Much Science Helps To Treat Anxiety Or Depression - Answer: A Lot - Gender: All - Age Group: All
);CREATE TABLE mental_health_units_in_general_hospitals (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"indicator_mental_health_units_in_general_hospitals_per_705f8326" DOUBLE -- Indicator:Mental Health Units In General Hospitals (per 100–000 Population)
);CREATE TABLE mental_illnesses_prevalence (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"schizophrenia_disorders_share_of_population_sex_both_a_fb8a3540" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: Age-standardized,
"depressive_disorders_share_of_population_sex_both_age__d4092667" DOUBLE -- Depressive Disorders (share Of Population) - Sex: Both - Age: Age-standardized,
"anxiety_disorders_share_of_population_sex_both_age_age_0c123002" DOUBLE -- Anxiety Disorders (share Of Population) - Sex: Both - Age: Age-standardized,
"bipolar_disorders_share_of_population_sex_both_age_age_7ee526c4" DOUBLE -- Bipolar Disorders (share Of Population) - Sex: Both - Age: Age-standardized,
"eating_disorders_share_of_population_sex_both_age_age__acd592a8" DOUBLE -- Eating Disorders (share Of Population) - Sex: Both - Age: Age-standardized
);CREATE TABLE mental_illness_estimated_cases (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"current_number_of_cases_of_anxiety_disorders_in_both_s_9ae1b9f4" DOUBLE -- Current Number Of Cases Of Anxiety Disorders, In Both Sexes Aged All Ages,
"current_number_of_cases_of_depressive_disorders_in_bot_53f1ae7a" DOUBLE -- Current Number Of Cases Of Depressive Disorders, In Both Sexes Aged All Ages,
"current_number_of_cases_of_schizophrenia_in_both_sexes_a52009a3" DOUBLE -- Current Number Of Cases Of Schizophrenia, In Both Sexes Aged All Ages,
"current_number_of_cases_of_bipolar_disorder_in_both_se_059b9b3b" DOUBLE -- Current Number Of Cases Of Bipolar Disorder, In Both Sexes Aged All Ages,
"current_number_of_cases_of_eating_disorders_in_both_se_1e15a4e7" DOUBLE -- Current Number Of Cases Of Eating Disorders, In Both Sexes Aged All Ages
);CREATE TABLE men_women_friends_family_anxious_depressed (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh6_friends_family_have_been_anxious_de_558c805a" DOUBLE -- Share - Question: Mh6 - Friends/family Have Been Anxious/depressed - Answer: Yes - Gender: Male - Age Group: All,
"share_question_mh6_friends_family_have_been_anxious_de_ab71ba9b" DOUBLE -- Share - Question: Mh6 - Friends/family Have Been Anxious/depressed - Answer: Yes - Gender: Female - Age Group: All,
"population" DOUBLE,
"continent" VARCHAR
);CREATE TABLE number_of_countries_with_primary_on_prevalence_of_ment_75a28353 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"number_of_countries_with_primary_on_prevalence_of_ment_c780954b" BIGINT -- Number Of Countries With Primary Data On Prevalence Of Mental Disorders
);CREATE TABLE perceived_comfort_speaking_anxiety_depression (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh5_someone_local_comfortable_speaking__c9000a1d" DOUBLE -- Share - Question: Mh5 - Someone Local Comfortable Speaking About Anxiety/depression With Someone They Know - Answer: Very Comfortable - Gender: All - Age Group: All,
"share_question_mh5_someone_local_comfortable_speaking__e9465a6f" DOUBLE -- Share - Question: Mh5 - Someone Local Comfortable Speaking About Anxiety/depression With Someone They Know - Answer: Somewhat Comfortable - Gender: All - Age Group: All,
"share_question_mh5_someone_local_comfortable_speaking__8a324631" DOUBLE -- Share - Question: Mh5 - Someone Local Comfortable Speaking About Anxiety/depression With Someone They Know - Answer: Not At All Comfortable - Gender: All - Age Group: All,
"share_question_mh5_someone_local_comfortable_speaking__a25540af" DOUBLE -- Share - Question: Mh5 - Someone Local Comfortable Speaking About Anxiety/depression With Someone They Know - Answer: Don\u0027t Know/Refused - Gender: All - Age Group: All
);CREATE TABLE perceived_comfort_speaking_anxiety_depression_vs_talke_8317c477 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh8c_talked_to_friends_or_family_when_a_73cb70f2" DOUBLE -- Share - Question: Mh8c - Talked To Friends Or Family When Anxious/depressed - Answer: Yes - Gender: All - Age Group: All,
"share_question_mh5_someone_local_comfortable_speaking__c9000a1d" DOUBLE -- Share - Question: Mh5 - Someone Local Comfortable Speaking About Anxiety/depression With Someone They Know - Answer: Very Comfortable - Gender: All - Age Group: All,
"population" DOUBLE,
"continent" VARCHAR
);CREATE TABLE psychiatrists_working_in_the_mental_health_sector (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"indicator_psychiatrists_working_in_mental_health_secto_ce20b66f" DOUBLE -- Indicator:Psychiatrists Working In Mental Health Sector (per 100–000 Population)
);CREATE TABLE schizophrenia_prevalence (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"schizophrenia_disorders_share_of_population_sex_both_a_fb8a3540" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: Age-standardized
);CREATE TABLE schizophrenia_prevalence_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"schizophrenia_disorders_share_of_population_sex_both_a_57290de2" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 5-14 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_47e4cd51" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 15-19 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_ab7a57a6" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 20-24 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_8c04602f" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 25-29 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_ef5565ce" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 30-34 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_15e56c65" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 35-39 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_c3f00ffc" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 40-44 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_8e0d683d" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 45-49 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_64fd3bd6" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 50-54 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_3caa1b2c" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 55-59 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_6d467cb2" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 60-64 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_d75bd975" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 65-69 Years,
"schizophrenia_disorders_share_of_population_sex_both_a_a46ebacb" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: 70+ Years,
"schizophrenia_disorders_share_of_population_sex_both_a_2c812e78" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: All Ages,
"schizophrenia_disorders_share_of_population_sex_both_a_fb8a3540" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Both - Age: Age-standardized
);CREATE TABLE schizophrenia_prevalence_males_vs_females (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"schizophrenia_disorders_share_of_population_sex_male_a_dd7e0801" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Male - Age: Age-standardized,
"schizophrenia_disorders_share_of_population_sex_female_cc42e4a4" DOUBLE -- Schizophrenia Disorders (share Of Population) - Sex: Female - Age: Age-standardized,
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE science_helps_a_lot_treating_anxiety_depression_vs_gdp_70a9dc65 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh3b_how_much_science_helps_to_treat_an_6fb814e1" DOUBLE -- Share - Question: Mh3b - How Much Science Helps To Treat Anxiety Or Depression - Answer: A Lot - Gender: All - Age Group: All,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE -- GDP Per Capita, PPP (constant 2017 International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE share_who_report_lifetime_anxiety_or_depression (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh7a_have_been_anxious_depressed_answer_81406ca6" DOUBLE -- Share - Question: Mh7a - Have Been Anxious/depressed - Answer: Yes - Gender: All - Age Group: All
);CREATE TABLE share_who_say_its_extremely_important_for_the_national_40b0b2af (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_question_mh4b_important_for_national_government__5699e552" DOUBLE -- Share - Question: Mh4b - Important For National Government To Fund Research On Anxiety/depression - Answer: Extremely Important - Gender: All - Age Group: All
);CREATE TABLE stand_alone_policy_or_plan_for_mental_health (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"indicator_stand_alone_policy_or_plan_for_mental_health" VARCHAR
);Anyone who has the link will be able to view this.