novascotia-ca/numbers-and-rates-of-suicide-fatalities-in-ns-by-n3dv-9n4b
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 18 days ago
‧
Indexed 44 minutes ago

Numbers and Rates of Suicide Fatalities in NS by Year, Sex, and Zone of Residence

Numbers and rates of suicide fatalities in NS by year, month, sex, and health zone of residence

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"novascotia-ca/numbers-and-rates-of-suicide-fatalities-in-ns-by-n3dv-9n4b\".\"numbers_and_rates_of_suicide_fatalities_in_ns_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • numbers_and_rates_of_suicide_fatalities_in_ns_by
     
    Left sidebar is currently unimplemented
     
     
     
     
    Right sidebar is currently unimplemented
Upstream Metadata
Detailed MetadataLanguageengFrequencyMonthlyDepartmentJusticeTime Period Coverage2009-PresentUsage ConsiderationsData are current as of April 1, 2024 (when data for 2023 onward were updated as necessary). Data are extracted from a live database environment and are provisional and subject to change. Some case investigations in recent years remain ongoing. NS totals may be greater than sum of zones, as totals include cases from out of province and a small proportion where location of residence is under investigation. Data include NSMES cases for which manner of death was determined to be suicide and recorded as suicide on the Medical Certificate of Death by the Medical Examiner. Data for recent months and for the previous year are preliminary and counts and associated rates are likely to increase as case investigations are completed. Case review found that >90% of suicide deaths excluding those caused by drug toxicity were certified post-autopsy, which occurs within days of a reported death. Acccordingly, monitoring of suicide excluding drug toxicity provides a largely accurate, timely indicator of non-drug toxicity suicide. As such, counts of deaths by suicide excluding drug toxicity deaths is provided in addition to counts of total suicide deaths. Indicators of probable and confirmed drug toxicity deaths (including accident and suicide deaths) are also available on the data.novascotia.ca site for concurrent monitoring. Data provided here may differ from Vital Statistics data sources due to differences in reporting timeframes (e.g. a death certified as suicide may appear under the 'not elsewhere classified' classification if the death was not certified by the time of data submission for a particular report. Geocoding of address data has resulted in reclassification of zone of residence for a small number of cases (compared to prior releases of data). Population data have been updated with the most recent available data from Statistics Canada (17-10-0134-01; rate data may differ slightly from previous releases).Geographic Region NameNova Scotia

About

Numbers and Rates of Suicide Fatalities in NS by Year, Sex, and Zone of Residence
18 days ago (updated)
44 minutes ago (indexed)
Loading...

Topics

  • medical examiner
  • mortality
  • suicide

Source

License

Nova Scotia Open Government Licence