Others titles
- US Big Cities ED Visits For Asthma And Firearms Injuries
- ED Visits For Asthma And Firearms Injuries In US Cities
Keywords
- US Big Cities ED Visits
- Age Adjusted ED Visits
- Asthma ED Visits
- Firearm-Related Injuries ED Visits
- Emergency Room Visits
Big Cities Age-Adjusted ED Visits Rates
This dataset contains estimates of Emergency Department visit rates for asthma and firearms related injuries shared by the Big Cities Health Coalition members represented by the largest metropolitan health departments in the United States. The estimated values of age-adjusted visit rates cover the 2010-2017 period and are described by gender and race/ethnicity.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The source of data is represented by The Big Cities Health Coalition (BCHC), a forum for the leaders of America’s largest metropolitan health departments to exchange strategies and jointly address issues to promote and protect the health and safety of the people they serve. BCHC is a project of the National Association of County and City Health Officials (NACCHO), which represents the nation’s 2,800 local governmental health departments.
Most of the data come directly from cities, while some were secured from the U.S. Census or other similar publicly available dataset where city data were available. For the most part, jurisdictions reported their three most recent years of data, which were 2015, 2016, and 2017. Data prior to 2010 were not included, even if it meant a jurisdiction only had two years of data available. The nature of the data varies considerably. When data were not provided or available, the appropriate space was left blank. Not all health departments were able to provide data for all indicators and, in cases where denominators were too small, certain rates for subpopulations were not displayed.
Most data were reviewed by individual cities as well. Where sample sizes allow, indicators are broken down into subpopulations for race and ethnicity categories. For most jurisdictions, the default options were White (Non-Hispanic), Black (Non-Hispanic), Hispanic, Asian/Pacific Islander, American Indian/Alaska Native, and Other. In areas where certain populations were too small, the various subpopulations were included in the “other” category with any additional racial/ethnic minorities. In many of the California cities, as well as Seattle, reported numbers only represent Asians; Pacific Islanders are not included. Some jurisdictions also report mixed-race numbers, and where they do, those numbers are reported as “Multi-racial”.
In most cases, the 2000 standard population age was used. The ratio used as a denominator is the population from a location, year, of specified gender and race/ethnicity and is multiplied by 10,000.
Asthma Emergency Department (ED) visits rates are reported per 10,000 people, using 2010 U.S. Census figures, age-adjusted to the year 2000 standard population (except where noted). ICD-9-CM Codes include: 493.0 – Extrinsic asthma; 493.1 – Intrinsic asthma; 493.2 – Chronic obstructive asthma; 493.8 – Other forms of asthma; 493.9 – Asthma unspecified.
Firearm Related Emergency Department (ED) Visit Rate are per 100,000 people, using 2010 Census figures, age-adjusted to the year 2000 standard population. ICD-9-CM Codes included: E922.0-E922.3, E922.8, E922.9 – Accident caused by firearm missile; E955.0-E955.4 – Suicide and self-inflicted injury by firearms; E965.0-E965.4 – Assault by firearms; E985.0-E985.4 – Injury by firearms, undetermined whether accidentally, or purposefully inflicted; E970 – Injury due to legal intervention by firearms; E979.4 – Terrorism involving firearms.
Dataset contains the BCHC requested methodology for every indicator, along with sources of data used by the BCHC member and notes about the methods and data. In order to ease the comparison of the health conditions or injuries caused by the estimated values of age-adjusted ED visits rates that were determined, health conditions or injury causes included in the assessment or in the requested methodology were accompanied by the list of all ICD-9 corresponding codes.
About this Dataset
Data Info
Date Created | 2015-11 |
---|---|
Last Modified | 2019-03-04 |
Version | 2019-03-04 |
Update Frequency |
Irregular |
Temporal Coverage |
2010-2017 |
Spatial Coverage |
United States |
Source | John Snow Labs; Big Cities Health Coalition; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | US Big Cities ED Visits, Age Adjusted ED Visits, Asthma ED Visits, Firearm-Related Injuries ED Visits, Emergency Room Visits |
Other Titles | US Big Cities ED Visits For Asthma And Firearms Injuries, ED Visits For Asthma And Firearms Injuries In US Cities |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Health_Condition_Or_Injury_Cause | One of the health conditions or injuries cause which determined the Emergency Department visit | string | required : 1 |
Health_Condition_Or_Injury_Cause_ICD_9_Codes | The complete list of ICD-9 codes corresponding to health condition or injuries cause which determined the Emergency Department visit | string | - |
Year | The year in the interval 2010-2015 to which the estimated value of age-adjusted ED visits rate corresponds | date | required : 1 |
Gender | The type of gender to which the estimated value of age-adjusted ED visits rate corresponds | string | enum : Array ( [0] => Male [1] => Female [2] => Both ) required : 1 |
Race_Ethnicity | The race/ethnicity (White Non-Hispanic, Black Non-Hispanic, Hispanic, Asian/Pacific Islander, American Indian/Alaska Native or Other) to which the estimated value of age-adjusted ED visits rate corresponds or all of them | string | required : 1 |
Age_Adjusted_ED_Visits_Rate_Per_10000 | The estimated value of the age-adjusted ED visits rate for a health condition or injury among the population from a location, gender, race/ethnicity or all between the interval years 2010-2015 | number | level : Ratio |
Lower_Limit_95_Percent_Confidence_Interval | The lower limit of the confidence interval, for the estimated value of age-adjusted ED visits rate, determined with a degree of 95% confidence | number | level : Ratio |
Upper_Limit_95_Percent_Confidence_Interval | The upper limit of the confidence interval, for the estimated value of age-adjusted ED visits rate, determined with a degree of 95% confidence | number | level : Ratio |
City_Or_County_Name | The name of the city to which the estimated value of age-adjusted ED visits rate corresponds or US level | string | - |
State | The name of US state where the city or county, to which the estimated value of age-adjusted ED visits rate corresponds, is located | string | - |
State_Abbreviation | The abbreviated name of US state where the city or county, to which the estimated value of age-adjusted ED visits rate corresponds, is located | string | - |
BCHC_Requested_Methodology_For_Data | The Big Cities Health Coalition requested methodology for the estimation of age-adjusted ED visits rate for a health condition or an injury cause | string | required : 1 |
Data_Sources | The sources of data used for the estimation of age-adjusted ED visits rate for a health condition or an injury cause for a specific location and year | string | - |
Methods_And_Data_Notes | Notes about the method used to estimate the level of age-adjusted ED visits rate and data used in the process | string | - |
Data Preview
Health Condition Or Injury Cause | Health Condition Or Injury Cause ICD 9 Codes | Year | Gender | Race Ethnicity | Age Adjusted ED Visits Rate Per 10000 | Lower Limit 95 Percent Confidence Interval | Upper Limit 95 Percent Confidence Interval | City Or County Name | State | State Abbreviation | BCHC Requested Methodology For Data | Data Sources | Methods And Data Notes |
Asthma | 493.0-493.9 | 2010 | Male | All | 80.7 | 77.04 | 84.39 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Both | All | 86.02 | 83.36 | 88.68 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Female | All | 90.19 | 86.37 | 94.0 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Both | Asian/PI | 28.78 | 25.2 | 32.36 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Both | Black | 239.02 | 227.08 | 250.98 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Both | Hispanic | 67.02 | 62.7 | 71.34 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Both | Other | 30.1 | 24.82 | 35.38 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2010 | Both | White | 39.71 | 37.15 | 42.29 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2011 | Male | All | 76.75 | 73.2 | 80.31 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |
Asthma | 493.0-493.9 | 2011 | Both | All | 81.51 | 78.91 | 84.1 | Sacramento | California | CA | Age-adjusted rate of asthma-related ED visits using ICD-9-CM Codes: 493.0, 493.1, 493.2, 493.8, 493.0. (Numerator = Asthma-Related ED visits, Denominator = 2010 census population). Compute rates per 10,000, age adjusted using the 2000 US standard population. | California Health and Human Services Agency, Office of Statewide Health Planning and Development. American Community Survey 5-years estimates 2010-2014. | Age-Adjusted rate per 10,000 using the 2010 US standard population. ICD-9 Codes E922.0-E922.3, E922.8, E922.9, E955.0-E955.4, E965.0-E965.4, E985.0-E985.4, E970, E979.4 for City of Sacramento. City of Sacramento was approximated using the following zip codes: 95811, 95814, 95815, 95816, 95817, 95818, 95819, 95820, 95822, 95823, 95824, 95826, 95828, 95831, 95832, 95833, 95834, 95835, 95838. Other category includes Other, AI/AN, and unknown. Asian includes Asian and Native Hawaiian or Other Pacific Islander. 2010 data. |