internal-sandiegocounty-data-socrata/2020-injuries-4s2v-fpws
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 2 hours ago

2020 Injuries

Data by medical encounter for the following conditions by age, race/ethnicity, and gender:

Assaults

Disorders of the Teeth and Jaw

Drowning

Falls

Firearm-Related Injuries

Heat-Related Illnesses and Injuries

Hip Fractures

Homicide (See Assault Death)

Injuries

Motor Vehicle Injuries

Motor Vehicle Injuries to Pedalcyclist

Motor Vehicle Injuries to Pedestrian

Poisoning

Unintentional Injuries

Rates per 100,000 population. Age-adjusted rates per 100,000 2000 US standard population.

Blank Cells: Rates not calculated for fewer than 11 events. Rates not calculated in cases where zip code is unknown. Geography not reported where there are no cases reported in a given year. SES: Is the median household income by SRA community. Data for SRAs only.

*The COVID-19 pandemic was associated with increases in all-cause mortality. COVID-19 deaths have affected the patterns of mortality including those of Injury conditions.

Data sources: California Department of Public Health, Center for Health Statistics, Office of Health Information and Research, Vital Records Business Intelligence System (VRBIS). California Department of Health Care Access and Information (HCAI), Emergency Department Database and Patient Discharge Database, 2020. SANDAG Population Estimates, 2020 (vintage: 09/2022). Population estimates were derived using the 2010 Census and data should be considered preliminary.

Prepared by: County of San Diego, Health and Human Services Agency, Public Health Services, Community Health Statistics Unit, February 2023.

2020 Community Profile Data Guide and Data Dictionary Dashboard: https://public.tableau.com/app/profile/chsu/viz/2020CommunityProfilesDataGuideandDataDictionaryDashboard_16763944288860/HomePage

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 \"internal-sandiegocounty-data-socrata/2020-injuries-4s2v-fpws\".\"2020_injuries\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 2020_injuries
     
     
     
     
     
Upstream Metadata