About this Dataset

Asthma Emergency Department Visit Rates

This dataset contains counts and rates (per 10,000 residents) of asthma emergency department (ED) visits among Californians. The table “Asthma Emergency Department Visit Rates by County” contains statewide and county-level data stratified by age group (all ages, 0-17, 18+, 0-4, 5-17, 18-64, 65+) and race/ethnicity (white, black, Hispanic, Asian/Pacific Islander, American Indian/Alaskan Native). The table “Asthma Emergency Department Visit Rates by ZIP Code” contains zip-code level data stratified by age group (all ages, 0-17, 18+). The data are derived from the Department of Health Care Access and Information emergency department database. These data include emergency department visits from all licensed hospitals in California. These data are based only on primary discharge diagnosis codes. On October 1, 2015, diagnostic coding for asthma transitioned from ICD9-CM (493) to ICD10-CM (J45). Because of this change, CDPH and CDC do not recommend comparing data from 2015 (or earlier) to 2016 (or later). NOTE: Rates are calculated from the total number of asthma emergency department visits (not the unique number of individuals).
Organization: State of California
Last updated: 2024-11-26T22:45:43.918058
Tags: asthma, asthma-attack, asthma-emergency-department-visits, california-breathing, california-department-of-public-health, chronic-disease, department-of-health-care-access-and-information, disease-of-repiratory-system, ed-visits, emergency-department, hcai, health-effects, health-outcome, icd9-cm-493-0, respiratory-disease, tracking-indicator

Tables

Asthma ED Visit Rates By ZIP Code 2013-Present

@usgov.ca_gov_asthma_emergency_department_visit_rates_2b2fe.asthma_ed_visit_rates_by_zip_code_2013_present

65.88 KB
11402 rows
6 columns


CREATE TABLE asthma_ed_visit_rates_by_zip_code_2013_present (
  "year" BIGINT,
  "zip_code" BIGINT,
  "county" VARCHAR,
  "age_group" VARCHAR,
  "number_of_asthma_ed_visits" BIGINT,
  "age_adjusted_rate_of_asthma_ed_v" DOUBLE
);

Asthma ED Visit Rates By Zip Code And Age Groups 2013-present

@usgov.ca_gov_asthma_emergency_department_visit_rates_2b2fe.asthma_ed_visit_rates_by_zip_code_and_age_groups_2013_present

92.07 KB
19190 rows
6 columns


CREATE TABLE asthma_ed_visit_rates_by_zip_code_and_age_groups_2013_present (
  "year" BIGINT,
  "zip_code" BIGINT,
  "county" VARCHAR,
  "age_group" VARCHAR,
  "number_of_asthma_ed_visits" BIGINT,
  "age_adjusted_rate_of_asthma_ed_v" DOUBLE
);