Name: Suicidal Behaviors And Attempts
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Suicidal Behaviors And Attempts

Suicidal Behaviors and Attempts

Lethality, Risk Factors, and Statuses

By [source]

About this dataset

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

Before you begin your analysis, it is important that you are familiar with the dataset:

The columns include: User (a unique identifier for each user), Post (provides text of each post), Label (indicates whether a post is associated with suicidal behavior or not).

Each row in this dataset provides detailed information regarding one user’s post on Reddit related to suicide.

Now that you have an understanding of what’s included in this set, let's dive into working with it! First off, we recommend exploring within Jupyter Notebook given its ease of use and interactive nature - just open up a new notebook in Kaggle Notebooks. Here are some helpful tips:

Explore Data Types : Take some time getting familiarized with what type of data is found in each column by using various commands such as .dtypes or .info(). Knowing which type each column holds will make it easier when filtering columns later on. You could also explore any missing values using .isnull().sum() command which provides a good indication if any preprocessing such as filling missing values needs to take place prior to analysis.

Analyze Labels & Posts : Have a better understanding of labels attached to posts using value_counts() command which helps summarize proportions between these two variables so that more informed decisions can be made later on during analysis/modeling stages. Having an understanding when dealing real world problems often requires analyzing different aspects/labels associated before proceeding further so take your time here! For example, grouping posts based on labels can be done via groupby(Label).

Visualize your Results : Visualization makes findings easier to interpret; try leveraging matplotlib packages such as plt xy or seaborn sns heatmap; alternatively use Tableau externally once data preparation has been completed previously within Jupyter Notebook along side Python libraries like Scikit Learn or Numpy used for modeling techniques such machine learning algorithm implementations or complex computations like linear algebraic analyses respectively should there ever come an instance were

Research Ideas

Analyzing which risk factors associated with suicidal behavior are most prevalent in certain demographic groups, such as gender and age.

Examining the potential outcomes of different methods of self-harm and understanding their lethality levels to create more effective prevention and response strategies.

Creating predictive models for mental health workers to use when assessing individuals at risk of suicide so they can identify individuals who may need immediate intervention or follow up care

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: 500_Reddit_users_posts_labels.csv

Column name	Description
User	Unique identifier for each user. (String)
Post	Text of the post. (String)
Label	Label indicating whether the post is related to suicidal behavior or not. (Boolean)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

N 500 Reddit Users Posts Labels

@kaggle.thedevastator_suicidal_behaviors_and_attempts.n_500_reddit_users_posts_labels

2.16 MB
500 rows
3 columns

CREATE TABLE n_500_reddit_users_posts_labels (
  "user" VARCHAR,
  "post" VARCHAR,
  "label" VARCHAR
);

Suicidal Attempt

@kaggle.thedevastator_suicidal_behaviors_and_attempts.suicidal_attempt

86.45 kB
124 columns

CREATE TABLE suicidal_attempt (
  "suicidal_deliberate_poisoning" VARCHAR,
  "n__suicide_by_self_administered_drug" VARCHAR  -- Suicide By Self-administered Drug,
  "n__suicide_while_incarcerated" VARCHAR  -- Suicide While Incarcerated,
  "n__assisted_suicide" VARCHAR  -- Assisted Suicide,
  "n__suicide_attempt_by_adequate_means" VARCHAR  -- Suicide Attempt By Adequate Means,
  "n__suicide_attempt_by_inadequate_means" VARCHAR  -- Suicide Attempt By Inadequate Means,
  "n__suicide_suspected" VARCHAR  -- Suicide Suspected,
  "n__suicide_by_multiple_means" VARCHAR  -- Suicide By Multiple Means,
  "n__self_inflicted_poisoning_by_solid_and_liquid_substances" VARCHAR  -- Self-inflicted Poisoning By Solid And Liquid Substances,
  "n__suicide_and_self_inflicted_poisoning_by_analgesics" VARCHAR  -- Suicide And Self-inflicted Poisoning By Analgesics,
  "n__antipyretics_and_anti_rheumatics" VARCHAR  -- Antipyretics And Anti-rheumatics,
  "n__suicide_and_self_inflicted_poisoning_by_barbiturates" VARCHAR  -- Suicide And Self-inflicted Poisoning By Barbiturates,
  "n__suicide_and_self_inflicted_injury_by_amylobarbitone" VARCHAR  -- Suicide And Self-inflicted Injury By Amylobarbitone,
  "n__suicide_and_self_inflicted_injury_by_barbitone" VARCHAR  -- Suicide And Self-inflicted Injury By Barbitone,
  "n__suicide_and_self_inflicted_injury_by_butabarbitone" VARCHAR  -- Suicide And Self-inflicted Injury By Butabarbitone,
  "n__suicide_and_self_inflicted_injury_by_pentabarbitone" VARCHAR  -- Suicide And Self-inflicted Injury By Pentabarbitone,
  "n__suicide_and_self_inflicted_injury_by_phenobarbitone" VARCHAR  -- Suicide And Self-inflicted Injury By Phenobarbitone,
  "n__suicide_and_self_inflicted_injury_by_quinalbarbitone" VARCHAR  -- Suicide And Self-inflicted Injury By Quinalbarbitone,
  "n__suicide_and_self_inflicted_poisoning_by_gases_in_do_09308cfb" VARCHAR  -- Suicide And Self-inflicted Poisoning By Gases In Domestic Use,
  "n__suicide_and_self_inflicted_poisoning_by_gas_distrib_daec3aae" VARCHAR  -- Suicide And Self-inflicted Poisoning By Gas Distributed By Pipeline,
  "n__suicide_and_self_inflicted_poisoning_by_liquefied_p_6af2b481" VARCHAR  -- Suicide And Self-inflicted Poisoning By Liquefied Petroleum Gas Distributed In Mobile Containers,
  "n__suicide_and_self_inflicted_injury_by_hanging" VARCHAR  -- Suicide And Self-inflicted Injury By Hanging,
  "n__suicide_and_self_inflicted_injury_by_strangulation__bd7a4842" VARCHAR  -- Suicide And Self-inflicted Injury By Strangulation And Suffocation,
  "n__suicide_and_self_inflicted_injury_by_drowning" VARCHAR  -- Suicide And Self-inflicted Injury By Drowning,
  "n__suicide_or_self_inflicted_injury_by_firearms_and_explosives" VARCHAR  -- Suicide Or Self-inflicted Injury By Firearms And Explosives,
  "n__suicide_or_self_inflicted_injury_by_handgun" VARCHAR  -- Suicide Or Self-inflicted Injury By Handgun,
  "n__suicide_or_self_inflicted_injury_by_shotgun" VARCHAR  -- Suicide Or Self-inflicted Injury By Shotgun,
  "n__suicide_or_self_inflicted_injury_by_hunting_rifle" VARCHAR  -- Suicide Or Self-inflicted Injury By Hunting Rifle,
  "n__suicide_or_self_inflicted_injury_by_military_firearm" VARCHAR  -- Suicide Or Self-inflicted Injury By Military Firearm,
  "n__suicide_or_self_inflicted_injury_by_cutting_and_stabbing" VARCHAR  -- Suicide Or Self-inflicted Injury By Cutting And Stabbing,
  "n__suicide_or_self_injury_by_jumping_from_a_height" VARCHAR  -- Suicide Or Self-injury By Jumping From A Height,
  "n__suicide_and_self_inflicted_injury_by_jumping_from_r_27d13c1a" VARCHAR  -- Suicide And Self-inflicted Injury By Jumping From Residential Premises,
  "n__suicide_and_self_inflicted_injury_by_jumping_from_n_e6045fd2" VARCHAR  -- Suicide And Self-inflicted Injury By Jumping From Natural Sites,
  "n__suicide_and_self_inflicted_injury_by_jumping_or_lyi_c4069709" VARCHAR  -- Suicide And Self-inflicted Injury By Jumping Or Lying Before Moving Object,
  "n__suicide_or_self_injury_by_burning_or_fire" VARCHAR  -- Suicide Or Self-injury By Burning Or Fire,
  "n__suicide_or_self_injury_by_scalding" VARCHAR  -- Suicide Or Self-injury By Scalding,
  "n__suicide_or_self_injury_by_exposure_to_cold" VARCHAR  -- Suicide Or Self-injury By Exposure To Cold,
  "n__suicide_or_self_injury_by_electric_current" VARCHAR  -- Suicide Or Self-injury By Electric Current,
  "n__suicide_or_self_inflicted_injury_by_crashing_motor_vehicle" VARCHAR  -- Suicide Or Self-inflicted Injury By Crashing Motor Vehicle,
  "n__suicide_or_self_inflicted_injury_by_crashing_of_aircraft" VARCHAR  -- Suicide Or Self-inflicted Injury By Crashing Of Aircraft,
  "n__suicide_and_self_inflicted_injury_by_caustic_substances" VARCHAR  -- Suicide And Self-inflicted Injury By Caustic Substances,
  "n__suicide_or_self_injury_by_jumping_from_high_man_mad_7c7021f7" VARCHAR  -- Suicide Or Self-injury By Jumping From High Man-made Structure,
  "n__suicide_or_self_injury_by_jumping_from_high_building" VARCHAR  -- Suicide Or Self-injury By Jumping From High Building,
  "n__suicide_or_self_injury_by_jumping_from_bridge" VARCHAR  -- Suicide Or Self-injury By Jumping From Bridge,
  "n__suicide_or_self_injury_by_jumping_from_high_natural_feature" VARCHAR  -- Suicide Or Self-injury By Jumping From High Natural Feature,
  "n__suicide_or_self_injury_by_jumping_off_cliff" VARCHAR  -- Suicide Or Self-injury By Jumping Off Cliff,
  "n__suicide_or_self_injury_associated_with_moving_vehicles" VARCHAR  -- Suicide Or Self-injury Associated With Moving Vehicles,
  "n__suicide_or_self_injury_by_placing_self_in_path_of_m_a40a7748" VARCHAR  -- Suicide Or Self-injury By Placing Self In Path Of Moving Vehicle,
  "n__suicide_or_self_injury_by_placing_self_in_path_of_m_3f97f3fe" VARCHAR  -- Suicide Or Self-injury By Placing Self In Path Of Moving Motor Vehicle,
  "n__suicide_or_self_injury_by_placing_self_in_path_of_m_14a234c6" VARCHAR  -- Suicide Or Self-injury By Placing Self In Path Of Moving Railway Vehicle,
  "n__suicide_or_self_injury_by_igniting_gasoline_soaked__bccd87d0" VARCHAR  -- Suicide Or Self-injury By Igniting Gasoline Soaked Clothing Concept,
  "n__suicide_or_self_injury_by_arson" VARCHAR  -- Suicide Or Self-injury By Arson,
  "n__suicide_and_self_inflicted_injury_by_suffocation_by_1b92f324" VARCHAR  -- Suicide And Self-inflicted Injury By Suffocation By Plastic Bag,
  "n__attempt_suicide_by_car_exhaust" VARCHAR  -- Attempt Suicide By Car Exhaust,
  "n__drug_overdose" VARCHAR  -- Drug Overdose,
  "n__attempt_circumstances" VARCHAR  -- Attempt Circumstances,
  "n__patient_suicide_while_being_cared_for_in_a_healthca_a4767f63" VARCHAR  -- Patient Suicide While Being Cared For In A Healthcare Facility,
  "n__psychotic_disorder" VARCHAR  -- Psychotic Disorder,
  "n__psychotic_episode" VARCHAR  -- Psychotic Episode,
  "n__isolation" VARCHAR  -- Isolation,
  "n__i_feel_alone" VARCHAR  -- I Feel Alone,
  "n__i_feel_worthless" VARCHAR  -- I Feel Worthless,
  "n__nothing_helps" VARCHAR  -- Nothing Helps,
  "n__kill_me" VARCHAR  -- Kill Me,
  "n__there_s_nothing_left" VARCHAR  -- There’s Nothing Left,
  "n__rat_poison" VARCHAR  -- Rat Poison,
  "n__draino" VARCHAR  -- Draino,
  "n__institutionalized" VARCHAR  -- Institutionalized,
  "n__5150" VARCHAR  -- 5150,
  "n__5250" VARCHAR  -- 5250,
  "n__involuntary_hold" VARCHAR  -- Involuntary Hold,
  "n__psychiatric_hospitalization" VARCHAR  -- Psychiatric Hospitalization,
  "n__attempt_physical_damage" VARCHAR  -- Attempt Physical Damage,
  "n__surface_scratches" VARCHAR  -- Surface Scratches,
  "n__lethargic_speech" VARCHAR  -- Lethargic Speech,
  "n__first_degree_burns" VARCHAR  -- First-degree Burns,
  "n__mild_bleeding" VARCHAR  -- Mild Bleeding,
  "n__major_bleeding" VARCHAR  -- Major Bleeding,
  "n__bled_out" VARCHAR  -- Bled Out,
  "n__sprains" VARCHAR  -- Sprains,
  "n__conscious_but_sleepy" VARCHAR  -- Conscious But Sleepy,
  "n__somewhat_responsive" VARCHAR  -- Somewhat Responsive,
  "n__second_degree_burns" VARCHAR  -- Second-degree Burns,
  "n__bleeding_of_major_vessel" VARCHAR  -- Bleeding Of Major Vessel,
  "n__comatose_with_reflexes_intact" VARCHAR  -- Comatose With Reflexes Intact,
  "n__comatose" VARCHAR  -- Comatose,
  "n__third_degree_burns" VARCHAR  -- Third-degree Burns,
  "n__extensive_blood_loss" VARCHAR  -- Extensive Blood Loss,
  "n__major_fractures" VARCHAR  -- Major Fractures,
  "n__medical_hospitalization" VARCHAR  -- Medical Hospitalization,
  "n__intensive_care" VARCHAR  -- Intensive Care,
  "n__comatose_without_reflexes" VARCHAR  -- Comatose Without Reflexes,
  "n__unstable_vital_signs" VARCHAR  -- Unstable Vital Signs,
  "n__major_damage" VARCHAR  -- Major Damage,
  "n__lethality_of_actual_attempt" VARCHAR  -- Lethality Of Actual Attempt,
  "n__letha_attempt" VARCHAR  -- Letha Attempt,
  "n__potential_for_very_serious_lethality" VARCHAR  -- Potential For Very Serious Lethality,
  "n__put_gun_in_mouth_and_pulled_the_trigger" VARCHAR  -- Put Gun In Mouth And Pulled The Trigger,
  "n__laying_on_train_tracks" VARCHAR  -- Laying On Train Tracks,
  "n__alive_before_arriving" VARCHAR  -- Alive Before Arriving
);

Suicidal Behavior

@kaggle.thedevastator_suicidal_behaviors_and_attempts.suicidal_behavior

91.66 kB
146 columns

CREATE TABLE suicidal_behavior (
  "suicidal" VARCHAR,
  "n__suicidal_behavior" VARCHAR  -- Suicidal Behavior,
  "n__threatening_suicide" VARCHAR  -- Threatening Suicide,
  "n__previous_known_suicide_attempt" VARCHAR  -- Previous Known Suicide Attempt,
  "n__first_known_suicide_attempt" VARCHAR  -- First Known Suicide Attempt,
  "n__concerned_friends" VARCHAR  -- Concerned Friends,
  "n__concerned_family" VARCHAR  -- Concerned Family,
  "n__concerned_teacher" VARCHAR  -- Concerned Teacher,
  "n__concerned_authority" VARCHAR  -- Concerned Authority,
  "n__concerned_coworkers" VARCHAR  -- Concerned Coworkers,
  "n__history_of_attempted_suicide" VARCHAR  -- History Of Attempted Suicide,
  "n__anti_suicide_psychotherapy" VARCHAR  -- Anti-suicide Psychotherapy,
  "n__suicide_intent_score_scale" VARCHAR  -- Suicide Intent Score Scale,
  "n__suicide_intent_score_subscale" VARCHAR  -- Suicide Intent Score Subscale,
  "n__suicide_high_risk" VARCHAR  -- Suicide High Risk,
  "n__pierce_suicide_intent_scale_score" VARCHAR  -- Pierce Suicide Intent Scale Score,
  "n__suicide_prevention" VARCHAR  -- Suicide Prevention,
  "n__cutting" VARCHAR  -- Cutting,
  "n__self_harm" VARCHAR  -- Self-harm,
  "n__emotionally_unstable_personality_disorder" VARCHAR  -- Emotionally Unstable Personality Disorder,
  "n__severe_depressive_episode_with_psychotic_symptoms" VARCHAR  -- Severe Depressive Episode With Psychotic Symptoms,
  "n__post_schizophrenic_depression" VARCHAR  -- Post-schizophrenic Depression,
  "n__personal_history_of_self_harm" VARCHAR  -- Personal History Of Self-harm,
  "n__intentional_self_harm" VARCHAR  -- Intentional Self-harm,
  "n__intentional_production_or_feigning_of_symptoms_or_d_d66fbc91" VARCHAR  -- Intentional Production Or Feigning Of Symptoms Or Disabilities,
  "n__factitious_disorder" VARCHAR  -- Factitious Disorder,
  "n__intentional_self_harm_by_sharp_object" VARCHAR  -- Intentional Self-harm By Sharp Object,
  "n__intentional_self_harm_by_blunt_object" VARCHAR  -- Intentional Self-harm By Blunt Object,
  "n__intentional_self_harm_by_steam" VARCHAR  -- Intentional Self-harm By Steam,
  "n__hot_vapours_and_hot_objects" VARCHAR  -- Hot Vapours And Hot Objects,
  "n__intentional_self_harm_by_other_and_unspecified_fire_07702e84" VARCHAR  -- Intentional Self-harm By Other And Unspecified Firearm Discharge,
  "n__intentional_self_harm_by_explosive_material" VARCHAR  -- Intentional Self-harm By Explosive Material,
  "n__sequelae_of_intentional_self_harm" VARCHAR  -- Sequelae Of Intentional Self-harm,
  "n__assault" VARCHAR  -- Assault,
  "n__intentional_self_harm_by_crashing_of_motor_vehicle" VARCHAR  -- Intentional Self-harm By Crashing Of Motor Vehicle,
  "n__exposure_to_inanimate_mechanical_forces" VARCHAR  -- Exposure To Inanimate Mechanical Forces,
  "n__intentional_self_harm_by_smoke_fire_and_flames" VARCHAR  -- Intentional Self-harm By Smoke Fire And Flames,
  "n__intentional_self_harm_by_handgun_discharge" VARCHAR  -- Intentional Self-harm By Handgun Discharge,
  "n__intentional_self_harm_by_rifle" VARCHAR  -- Intentional Self-harm By Rifle,
  "n__intentional_self_harm_by_shotgun" VARCHAR  -- Intentional Self-harm By Shotgun,
  "n__falls" VARCHAR  -- Falls,
  "n__transport_accidents" VARCHAR  -- Transport Accidents,
  "n__intentional_self_harm_by_jumping_or_lying_before_mo_16d2d176" VARCHAR  -- Intentional Self-harm By Jumping Or Lying Before Moving Object,
  "n__intentional_self_harm_by_jumping_from_a_high_place" VARCHAR  -- Intentional Self-harm By Jumping From A High Place,
  "n__intentional_self_harm_by_hanging" VARCHAR  -- Intentional Self-harm By Hanging,
  "n__intentional_self_harm_by_strangulation_or_suffocation" VARCHAR  -- Intentional Self-harm By Strangulation Or Suffocation,
  "n__intentional_self_harm_by_drowning_or_submersion" VARCHAR  -- Intentional Self-harm By Drowning Or Submersion,
  "n__intentional_self_harm_1" VARCHAR  -- Intentional Self-harm.1,
  "n__accidental_poisoning_by_and_exposure_to_noxious_substances" VARCHAR  -- Accidental Poisoning By And Exposure To Noxious Substances,
  "n__potentially_self_injurious_act" VARCHAR  -- Potentially Self-injurious Act,
  "n__wish_to_die_as_a_result_of_act" VARCHAR  -- Wish To Die As A Result Of Act,
  "n__method_to_kill_myself" VARCHAR  -- Method To Kill Myself,
  "n__intent_or_desire_to_die_associated_with_the_act" VARCHAR  -- Intent Or Desire To Die Associated With The Act,
  "n__may_or_may_not_be_involving_injury_or_harm" VARCHAR  -- May Or May Not Be Involving Injury Or Harm,
  "n__potential_injury_or_harm" VARCHAR  -- Potential Injury Or Harm,
  "n__gun_is_in_mouth" VARCHAR  -- Gun Is In Mouth,
  "n__gun_in_mouth" VARCHAR  -- Gun In Mouth,
  "n__incomplete_attempt" VARCHAR  -- Incomplete Attempt,
  "n__a_highly_lethal_act" VARCHAR  -- A Highly Lethal Act,
  "n__inferred_suicide" VARCHAR  -- Inferred Suicide,
  "n__harm_myself" VARCHAR  -- Harm Myself,
  "n__could_have_died" VARCHAR  -- Could Have Died,
  "n__self_injurious" VARCHAR  -- Self-injurious,
  "n__self_harm_to_relieve_stress" VARCHAR  -- Self-harm To Relieve Stress,
  "n__self_harm_to_feel_better" VARCHAR  -- Self-harm To Feel Better,
  "n__self_harm_to_get_sympathy" VARCHAR  -- Self-harm To Get Sympathy,
  "n__self_harm_to_get_something_to_happen" VARCHAR  -- Self-harm To Get Something To Happen,
  "n__interrupted_attempt" VARCHAR  -- Interrupted Attempt,
  "n__pills_in_hand" VARCHAR  -- Pills In Hand,
  "n__stopped_from_ingesting" VARCHAR  -- Stopped From Ingesting,
  "n__pointed_gun_at_myself" VARCHAR  -- Pointed Gun At Myself,
  "n__gun_taken_away" VARCHAR  -- Gun Taken Away,
  "n__prevented_from_pulling_trigger" VARCHAR  -- Prevented From Pulling Trigger,
  "n__couldn_t_pull_trigger" VARCHAR  -- Couldn’t Pull Trigger,
  "n__person_is_poised_to_jump" VARCHAR  -- Person Is Poised To Jump,
  "n__grabbed_from_ledge" VARCHAR  -- Grabbed From Ledge,
  "n__taken_from_ledge" VARCHAR  -- Taken From Ledge,
  "n__noose_around_neck" VARCHAR  -- Noose Around Neck,
  "n__someone_stopped_me" VARCHAR  -- Someone Stopped Me,
  "n__something_stopped_me" VARCHAR  -- Something Stopped Me,
  "n__taking_steps" VARCHAR  -- Taking Steps,
  "n__self_destructive" VARCHAR  -- Self-destructive,
  "n__stopped_myself" VARCHAR  -- Stopped Myself,
  "n__suicidal_act" VARCHAR  -- Suicidal Act,
  "n__suicidal_preparation" VARCHAR  -- Suicidal Preparation,
  "n__imminent_plans" VARCHAR  -- Imminent Plans,
  "n__tonight_is_the_night" VARCHAR  -- Tonight Is The Night,
  "n__today_is_the_day" VARCHAR  -- Today Is The Day,
  "n__preparatory_act" VARCHAR  -- Preparatory Act,
  "n__buying_pills" VARCHAR  -- Buying Pills,
  "n__bought_pills" VARCHAR  -- Bought Pills,
  "n__purchasing_a_gun" VARCHAR  -- Purchasing A Gun,
  "n__purchased_a_gun" VARCHAR  -- Purchased A Gun,
  "n__giving_things_away" VARCHAR  -- Giving Things Away,
  "n__gave_things_away" VARCHAR  -- Gave Things Away,
  "n__writing_a_suicide_note" VARCHAR  -- Writing A Suicide Note,
  "n__wrote_a_note" VARCHAR  -- Wrote A Note,
  "n__writing_a_note" VARCHAR  -- Writing A Note,
  "n__collecting_pills" VARCHAR  -- Collecting Pills,
  "n__collected_pills" VARCHAR  -- Collected Pills
);

Suicidal Ideation

@kaggle.thedevastator_suicidal_behaviors_and_attempts.suicidal_ideation

322.21 kB
472 columns

CREATE TABLE suicidal_ideation (
  "suicidal_thoughts" VARCHAR,
  "n__feeling_suicidal" VARCHAR  -- Feeling Suicidal,
  "n__potential_suicide_care" VARCHAR  -- Potential Suicide Care,
  "n__suicide_low_risk" VARCHAR  -- Suicide Low Risk,
  "n__beck_scale_for_suicide_ideation" VARCHAR  -- Beck Scale For Suicide Ideation,
  "n__self_control_behavior_suicide" VARCHAR  -- Self-control Behavior Suicide,
  "n__moderate_suicide_risk" VARCHAR  -- Moderate Suicide Risk,
  "n__proactive_therapy" VARCHAR  -- Proactive Therapy,
  "n__post_partum_depression" VARCHAR  -- Post-partum Depression,
  "n__tends_not_to_tolerate_boredom" VARCHAR  -- Tends Not To Tolerate Boredom,
  "n__helpless" VARCHAR  -- Helpless,
  "n__powerless" VARCHAR  -- Powerless,
  "n__borderline_poverty" VARCHAR  -- Borderline Poverty,
  "n__depressive_delusion_of_poverty" VARCHAR  -- Depressive Delusion Of Poverty,
  "n__poor" VARCHAR  -- Poor,
  "n__tends_to_take_pleasure_in_the_suffering_of_others" VARCHAR  -- Tends To Take Pleasure In The Suffering Of Others,
  "n__feeling_hopeless" VARCHAR  -- Feeling Hopeless,
  "n__at_risk_for_hopelessness" VARCHAR  -- At Risk For Hopelessness,
  "n__dementia_associated_with_alcoholism" VARCHAR  -- Dementia Associated With Alcoholism,
  "n__primary_degenerative_dementia_of_the_alzheimer_type" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type,
  "n__senile_onset" VARCHAR  -- Senile Onset,
  "n__with_delirium" VARCHAR  -- With Delirium,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_1" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.1,
  "n__presenile_onset" VARCHAR  -- Presenile Onset,
  "n__uncomplicated" VARCHAR  -- Uncomplicated,
  "n__dialysis_dementia" VARCHAR  -- Dialysis Dementia,
  "n__multi_infarct_dementia_with_delirium" VARCHAR  -- Multi-infarct Dementia With Delirium,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_2" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.2,
  "n__presenile_onset_1" VARCHAR  -- Presenile Onset.1,
  "n__with_depression" VARCHAR  -- With Depression,
  "n__presenile_dementia" VARCHAR  -- Presenile Dementia,
  "n__multi_infarct_dementia_with_depression" VARCHAR  -- Multi-infarct Dementia With Depression,
  "n__senile_dementia" VARCHAR  -- Senile Dementia,
  "n__multi_infarct_dementia_with_delusions" VARCHAR  -- Multi-infarct Dementia With Delusions,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_3" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.3,
  "n__senile_onset_1" VARCHAR  -- Senile Onset.1,
  "n__with_depression_1" VARCHAR  -- With Depression.1,
  "n__progressive_supranuclear_ophthalmoplegia" VARCHAR  -- Progressive Supranuclear Ophthalmoplegia,
  "n__inhalant_induced_persisting_dementia" VARCHAR  -- Inhalant-induced Persisting Dementia,
  "n__general_paresis" VARCHAR  -- General Paresis,
  "n__neurosyphilis" VARCHAR  -- Neurosyphilis,
  "n__dementia" VARCHAR  -- Dementia,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_4" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.4,
  "n__presenile_onset_2" VARCHAR  -- Presenile Onset.2,
  "n__with_delusions" VARCHAR  -- With Delusions,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_5" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.5,
  "n__senile_onset_2" VARCHAR  -- Senile Onset.2,
  "n__with_delusions_1" VARCHAR  -- With Delusions.1,
  "n__multi_infarct_dementia" VARCHAR  -- Multi-infarct Dementia,
  "n__sedative" VARCHAR  -- Sedative,
  "n__hypnotic_or_anxiolytic_induced_persisting_dementia" VARCHAR  -- Hypnotic Or Anxiolytic-induced Persisting Dementia,
  "n__parkinson_dementia_complex_of_guam" VARCHAR  -- Parkinson-dementia Complex Of Guam,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_6" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.6,
  "n__presenile_onset_3" VARCHAR  -- Presenile Onset.3,
  "n__with_delirium_1" VARCHAR  -- With Delirium.1,
  "n__primary_degenerative_dementia_of_the_alzheimer_type_7" VARCHAR  -- Primary Degenerative Dementia Of The Alzheimer Type.7,
  "n__senile_onset_3" VARCHAR  -- Senile Onset.3,
  "n__uncomplicated_1" VARCHAR  -- Uncomplicated.1,
  "n__multi_infarct_dementia_1" VARCHAR  -- Multi-infarct Dementia.1,
  "n__uncomplicated_2" VARCHAR  -- Uncomplicated.2,
  "n__childhood_disintegrative_disorder" VARCHAR  -- Childhood Disintegrative Disorder,
  "n__dementia_paralytica_juvenilis" VARCHAR  -- Dementia Paralytica Juvenilis,
  "n__subcortical_leukoencephalopathy" VARCHAR  -- Subcortical Leukoencephalopathy,
  "n__kohlschutter_s_syndrome" VARCHAR  -- Kohlschutter\u0027s Syndrome,
  "n__psychoactive_substance_induced_organic_dementia" VARCHAR  -- Psychoactive Substance-induced Organic Dementia,
  "n__family_history_senile_dementia" VARCHAR  -- Family History: Senile Dementia,
  "n__history_of_dementia" VARCHAR  -- History Of Dementia,
  "n__dementia_test" VARCHAR  -- Dementia Test,
  "n__ten_item_dementia_test" VARCHAR  -- Ten Item Dementia Test,
  "n__thirty_seven_item_dementia_test" VARCHAR  -- Thirty-seven Item Dementia Test,
  "n__uncomplicated_senile_dementia" VARCHAR  -- Uncomplicated Senile Dementia,
  "n__uncomplicated_presenile_dementia" VARCHAR  -- Uncomplicated Presenile Dementia,
  "n__presenile_dementia_with_delirium" VARCHAR  -- Presenile Dementia With Delirium,
  "n__presenile_dementia_with_paranoia" VARCHAR  -- Presenile Dementia With Paranoia,
  "n__presenile_dementia_with_depression" VARCHAR  -- Presenile Dementia With Depression,
  "n__senile_dementia_with_depressive_or_paranoid_features" VARCHAR  -- Senile Dementia With Depressive Or Paranoid Features,
  "n__senile_dementia_with_paranoia" VARCHAR  -- Senile Dementia With Paranoia,
  "n__senile_dementia_with_depression" VARCHAR  -- Senile Dementia With Depression,
  "n__senile_dementia_with_delirium" VARCHAR  -- Senile Dementia With Delirium,
  "n__uncomplicated_arteriosclerotic_dementia" VARCHAR  -- Uncomplicated Arteriosclerotic Dementia,
  "n__arteriosclerotic_dementia_with_delirium" VARCHAR  -- Arteriosclerotic Dementia With Delirium,
  "n__arteriosclerotic_dementia_with_paranoia" VARCHAR  -- Arteriosclerotic Dementia With Paranoia,
  "n__arteriosclerotic_dementia_with_depression" VARCHAR  -- Arteriosclerotic Dementia With Depression,
  "n__drug_induced_dementia" VARCHAR  -- Drug-induced Dementia,
  "n__dementia_associated_with_another_disease" VARCHAR  -- Dementia Associated With Another Disease,
  "n__language_disorder_of_dementia" VARCHAR  -- Language Disorder Of Dementia,
  "n__amyotrophic_lateral_sclerosis_with_dementia" VARCHAR  -- Amyotrophic Lateral Sclerosis With Dementia,
  "n__frontotemporal_dementia" VARCHAR  -- Frontotemporal Dementia,
  "n__post_traumatic_dementia" VARCHAR  -- Post-traumatic Dementia,
  "n__punch_drunk_syndrome" VARCHAR  -- Punch Drunk Syndrome,
  "n__vascular_dementia_of_acute_onset" VARCHAR  -- Vascular Dementia Of Acute Onset,
  "n__subcortical_vascular_dementia" VARCHAR  -- Subcortical Vascular Dementia,
  "n__mixed_cortical_and_subcortical_vascular_dementia" VARCHAR  -- Mixed Cortical And Subcortical Vascular Dementia,
  "n__semantic_dementia" VARCHAR  -- Semantic Dementia,
  "n__patchy_dementia" VARCHAR  -- Patchy Dementia,
  "n__epileptic_dementia" VARCHAR  -- Epileptic Dementia,
  "n__arizona_battery_for_communication_disorders_of_dementia" VARCHAR  -- Arizona Battery For Communication Disorders Of Dementia,
  "n__blessed_dementia_rating_scale" VARCHAR  -- Blessed Dementia Rating Scale,
  "n__clinical_dementia_rating_scale" VARCHAR  -- Clinical Dementia Rating Scale,
  "n__kendrick_battery_for_detection_of_dementia_in_the_elderly" VARCHAR  -- Kendrick Battery For Detection Of Dementia In The Elderly
);

Suicidal Indicator

@kaggle.thedevastator_suicidal_behaviors_and_attempts.suicidal_indicator

1.09 MB
1,535 columns

CREATE TABLE suicidal_indicator (
  "pessimistic_character" VARCHAR,
  "n__suicide_of_relative" VARCHAR  -- Suicide Of Relative,
  "n__family_history_of_suicide" VARCHAR  -- Family History Of Suicide,
  "n__suicide_of_close_relative" VARCHAR  -- Suicide Of Close Relative,
  "n__suicide_risk_assessment" VARCHAR  -- Suicide Risk Assessment,
  "n__at_risk_for_suicide" VARCHAR  -- At Risk For Suicide,
  "n__adjustment_disorder" VARCHAR  -- Adjustment Disorder,
  "n__depressed_mood" VARCHAR  -- Depressed Mood,
  "n__disturbance_of_emotions" VARCHAR  -- Disturbance Of Emotions,
  "n__disturbance_of_conduct" VARCHAR  -- Disturbance Of Conduct,
  "n__poor_grades" VARCHAR  -- Poor Grades,
  "n__bad_grades" VARCHAR  -- Bad Grades,
  "n__failing_grades" VARCHAR  -- Failing Grades,
  "n__fired_from_work" VARCHAR  -- Fired From Work,
  "n__academic_inhibition" VARCHAR  -- Academic Inhibition,
  "n__physical_complaints" VARCHAR  -- Physical Complaints,
  "n__work_inhibition" VARCHAR  -- Work Inhibition,
  "n__work_complaints" VARCHAR  -- Work Complaints,
  "n__hate_my_job" VARCHAR  -- Hate My Job,
  "n__hate_school" VARCHAR  -- Hate School,
  "n__anxious_mood" VARCHAR  -- Anxious Mood,
  "n__communication_disorder" VARCHAR  -- Communication Disorder,
  "n__depressive_adjustment_reaction" VARCHAR  -- Depressive Adjustment Reaction,
  "n__antisocial_behavior" VARCHAR  -- Antisocial Behavior,
  "n__antisocial_disorder" VARCHAR  -- Antisocial Disorder,
  "n__insomnia" VARCHAR  -- Insomnia,
  "n__embarrassed" VARCHAR  -- Embarrassed,
  "n__caucasian" VARCHAR  -- Caucasian,
  "n__white" VARCHAR  -- White,
  "n__native_american" VARCHAR  -- Native American,
  "n__first_nations" VARCHAR  -- First Nations,
  "n__alcoholism" VARCHAR  -- Alcoholism,
  "n__drug_abuse" VARCHAR  -- Drug Abuse,
  "n__bulimia" VARCHAR  -- Bulimia,
  "n__bulimia_nervosa" VARCHAR  -- Bulimia Nervosa,
  "n__purging" VARCHAR  -- Purging,
  "n__binge_and_purge" VARCHAR  -- Binge And Purge,
  "n__eating_disorder" VARCHAR  -- Eating Disorder,
  "n__history_of_bulimia_nervosa" VARCHAR  -- History Of Bulimia Nervosa,
  "n__bulimia_nervosa_in_remission" VARCHAR  -- Bulimia Nervosa In Remission,
  "n__sexually_provocative_behavior" VARCHAR  -- Sexually Provocative Behavior,
  "n__provocative_behavior" VARCHAR  -- Provocative Behavior,
  "n__divorce" VARCHAR  -- Divorce,
  "n__divorced_parents" VARCHAR  -- Divorced Parents,
  "n__divorced_parents_sharing_house" VARCHAR  -- Divorced Parents Sharing House,
  "n__anorexia_nervosa" VARCHAR  -- Anorexia Nervosa,
  "n__anorexia_nervosa_binge_eating_purging_type" VARCHAR  -- Anorexia Nervosa Binge-eating Purging Type,
  "n__anorexia" VARCHAR  -- Anorexia,
  "n__loss_of_appetite" VARCHAR  -- Loss Of Appetite,
  "n__mood_anorexia" VARCHAR  -- Mood Anorexia,
  "n__hypertrichosis" VARCHAR  -- Hypertrichosis,
  "n__acute_nervous_system_disorder" VARCHAR  -- Acute Nervous System Disorder,
  "n__disorder_of_autonomic_nervous_system" VARCHAR  -- Disorder Of Autonomic Nervous System,
  "n__disorder_of_the_peripheral_nervous_system" VARCHAR  -- Disorder Of The Peripheral Nervous System,
  "n__disorder_of_parasympathetic_nervous_system" VARCHAR  -- Disorder Of Parasympathetic Nervous System,
  "n__disorder_of_sympathetic_nervous_system" VARCHAR  -- Disorder Of Sympathetic Nervous System,
  "n__central_nervous_system_disorder_of_water_regulation" VARCHAR  -- Central Nervous System Disorder Of Water Regulation,
  "n__disorder_of_peripheral_autonomic_nervous_system" VARCHAR  -- Disorder Of Peripheral Autonomic Nervous System,
  "n__inherited_metabolic_disorder_of_nervous_system" VARCHAR  -- Inherited Metabolic Disorder Of Nervous System,
  "n__chronic_nervous_system_disorder" VARCHAR  -- Chronic Nervous System Disorder,
  "n__infectious_disorder_of_the_peripheral_nervous_system" VARCHAR  -- Infectious Disorder Of The Peripheral Nervous System,
  "n__hereditary_disorder_of_nervous_system" VARCHAR  -- Hereditary Disorder Of Nervous System,
  "n__slow_viral_central_nervous_system_infection" VARCHAR  -- Slow Viral Central Nervous System Infection,
  "n__chagas_disease_with_nervous_system_involvement" VARCHAR  -- Chagas\u0027 Disease With Nervous System Involvement,
  "n__cysticercosis_of_central_nervous_system" VARCHAR  -- Cysticercosis Of Central Nervous System,
  "n__late_effects_of_central_nervous_system_tuberculosis" VARCHAR  -- Late Effects Of Central Nervous System Tuberculosis,
  "n__malignant_neoplasm_of_peripheral_nerves_and_autonom_462d239d" VARCHAR  -- Malignant Neoplasm Of Peripheral Nerves And Autonomic Nervous System,
  "n__phlebitis_of_central_nervous_system_venous_sinuses" VARCHAR  -- Phlebitis Of Central Nervous System Venous Sinuses,
  "n__thrombophlebitis_of_central_nervous_system_venous_sinuses" VARCHAR  -- Thrombophlebitis Of Central Nervous System Venous Sinuses,
  "n__nervous_system_complication_from_surgically_implanted_device" VARCHAR  -- Nervous System Complication From Surgically Implanted Device,
  "n__hereditary_degenerative_disease_of_central_nervous_system" VARCHAR  -- Hereditary Degenerative Disease Of Central Nervous System,
  "n__inflammatory_disease_of_the_central_nervous_system" VARCHAR  -- Inflammatory Disease Of The Central Nervous System,
  "n__disease_of_nervous_system_complicating_pregnancy" VARCHAR  -- Disease Of Nervous System Complicating Pregnancy,
  "n__childbirth_and_puerperium" VARCHAR  -- Childbirth And Puerperium,
  "n__fetus_with_central_nervous_system_malformation" VARCHAR  -- Fetus With Central Nervous System Malformation,
  "n__obstetric_anesthesia_with_central_nervous_system_co_3b4cdb1a" VARCHAR  -- Obstetric Anesthesia With Central Nervous System Complications,
  "n__tuberculosis_of_central_nervous_system" VARCHAR  -- Tuberculosis Of Central Nervous System,
  "n__late_effect_of_nervous_system_injury" VARCHAR  -- Late Effect Of Nervous System Injury,
  "n__central_nervous_system_muscle_tone_depressant_poisoning" VARCHAR  -- Central Nervous System Muscle-tone Depressant Poisoning,
  "n__central_nervous_system_complications_of_care" VARCHAR  -- Central Nervous System Complications Of Care,
  "n__accidental_poisoning_caused_by_central_nervous_syst_717a32d5" VARCHAR  -- Accidental Poisoning Caused By Central Nervous System Stimulants,
  "n__overlapping_malignant_neoplasm_of_brain_and_other_p_30ea0d5b" VARCHAR  -- Overlapping Malignant Neoplasm Of Brain And Other Parts Of The Central Nervous System,
  "n__neoplasm_of_uncertain_behavior_of_peripheral_nerves_452e4e3a" VARCHAR  -- Neoplasm Of Uncertain Behavior Of Peripheral Nerves And Peripheral Autonomic Nervous System,
  "n__primary_malignant_neoplasm_of_peripheral_nerves_and_5307f516" VARCHAR  -- Primary Malignant Neoplasm Of Peripheral Nerves And Peripheral Autonomic Nervous System,
  "n__overlapping_malignant_neoplasm_of_peripheral_nerves_ce5a162d" VARCHAR  -- Overlapping Malignant Neoplasm Of Peripheral Nerves And Autonomic Nervous System,
  "n__system_disorder_of_the_nervous_system" VARCHAR  -- System Disorder Of The Nervous System,
  "n__chronic_inflammatory_demyelinating_polyradiculoneur_960f7c08" VARCHAR  -- Chronic Inflammatory Demyelinating Polyradiculoneuropathy With Central Nervous System Demyelination,
  "n__isolated_angiitis_of_central_nervous_system" VARCHAR  -- Isolated Angiitis Of Central Nervous System,
  "n__granulomatous_angiitis_of_central_nervous_system" VARCHAR  -- Granulomatous Angiitis Of Central Nervous System,
  "n__congenital_and_developmental_anomalies_of_the_nervous_system" VARCHAR  -- Congenital And Developmental Anomalies Of The Nervous System,
  "n__late_secondary_abnormalities_of_the_central_nervous_system" VARCHAR  -- Late Secondary Abnormalities Of The Central Nervous System,
  "n__tumor_like_lesion_of_nervous_system" VARCHAR  -- Tumor-like Lesion Of Nervous System,
  "n__central_nervous_system_candidiasis" VARCHAR  -- Central Nervous System Candidiasis,
  "n__mechanical_complication_of_nervous_system_device" VARCHAR  -- Mechanical Complication Of Nervous System Device,
  "n__herpes_zoster_with_nervous_system_complication" VARCHAR  -- Herpes Zoster With Nervous System Complication,
  "n__rubella_infection_of_central_nervous_system" VARCHAR  -- Rubella Infection Of Central Nervous System,
  "n__early_secondary_malformation_of_the_central_nervous_system" VARCHAR  -- Early Secondary Malformation Of The Central Nervous System,
  "n__vascular_malformation_of_the_nervous_system" VARCHAR  -- Vascular Malformation Of The Nervous System,
  "n__metastasis_to_nervous_system_and_eye" VARCHAR  -- Metastasis To Nervous System And Eye,
  "n__fetus_with_central_nervous_system_malformation_1" VARCHAR  -- Fetus With Central Nervous System Malformation.1
);