Suicides 2018

data.sandiegocounty.gov | Last Updated 24 Apr 2019

This dataset includes all San Diego County accidental deaths, homicides, suicides, in-custody deaths, and a very small percentage of sudden or unexpected natural deaths in which the decedent had not seen a health care provider in the last 20 days of life.

Tags: death, deceased, died, decedent, fatality, fatalities, accident, homicide, suicide, natural causes, coroner

This dataset has the following 34 columns:

Column NameAPI Column NameData TypeDescription
Row Numberrow_numbernumberA non-identifiable row number has been added to distinguish individual case records.
YearyearnumberThe year the Medical Examiner took jurisdiction of the case for investigation.
Age in Yearsage_in_yearsnumberThe age of the decedent at time of death, represented in whole years; individuals under the age of 1 are listed at age 0 years.
Death Datedeath_datecalendar_dateDecedent's date of death.
Security Statussecurity_statustextIndicates if record is sealed or access free.
GendergendertextGender
RaceracetextRace/Ethnicity as determined by the Medical Examiner.
Ethnic Group (Standardized)ethnic_grouptextEthnic Group categorization based upon the indicated race/ethnicity.
Manner of DeathmannertextThis is the manner of death category: Natural, Accident, Homicide, Suicide, or Undetermined.
Manner Typemanner_typetextThis is the type or method of death determined by the Medical Examiner.
Manner Sub Typemanner_sub_typetextThis is the sub-type or sub-method of death determined by the Medical Examiner.
Cause of Deathcod_stringtextA description of the cause of death.
Contributing Conditionscontributing_conditionstextThis includes conditions that contributed to the cause of death.
How Injury Occurredhow_injury_occurredtextA description as to how the injury leading to death occurred.
Event Dateevent_datetextDate when the event causing death occurred.
Event Timeevent_timetextTime when the event causing death occurred.
Event Placeevent_placetextPlace where the event causing death occurred.
Event Place Typeevent_place_typetextGeneral categorization of Event Place.
Event Cityevent_citytextCity where the event causing death occurred.
Event Zipevent_ziptextZip code where the event causing death occurred.
Death Placedeath_placetextPlace where death occurred.
Death Place Typedeath_place_typetextGeneral categorization of Death Place.
Death Citydeath_citytextCity where death occurred.
Death Zipdeath_ziptextZip code where death occurred.
Res Cityres_citytextDecedent's city of residence.
Res Zipres_ziptextDecedent's Zip code of residence.
Age Group Option 1age_group_option_1textIncludes age groupings in 10 year increments, beginning with 0-9
Age Group Option 2age_group_option_2textIncludes child and young adult age groupings in 5 year increments through age 24, then in 10 year increments beginning with 25-34..
Age Group Option 3age_group_option_3textIncludes a child age grouping from age 0-14 and then 10 increments beginning with 15-24.
Manner Type (Standardized)manner_type_standardized_textA standardized Manner Type of death to provide consistency due to categorizations that may have changed over time.
Manner Sub Type (Standardized)manner_sub_type_standardized_textA standardized Manner Sub Type of death to provide consistency due to categorizations that may have changed over time.
Opioid Relatedopioid_relatedtextIndicates if an Opioid is listed in the Cause of Death, Contributing Conditions, or How Injury Occurred column. Currently includes the following: opiate, opioid, U-47700, tramadol, oxymorphone, oxycodone, morphine, mitragynine, methadone, hydromorphone, hydrocodone, heroid, fentanyl, dihydrocodeine, codeine, buprenorphine, carfentanil
Coronado Bridge Related (Suicide Cases)coronado_bridge_related_suicide_cases_textIndicate if the event location was the Coronado Bay Bridge.
QuarterquartertextCalendar year quarter based on the date of death or the quarter in which the Medical Examiner took jurisdiction if outside of the current year.