About this Dataset

Asthma ED Visit Rates By ZIP

Asthma ED Visit Rates by ZIP

Counts and Rates by Age Group in California

About this dataset

This dataset presents a comprehensive look into the prevalence of asthma among Californian residents in terms of emergency department visits. Using age-adjusted rates and county FIPS codes, it offers an accurate snapshot of the prevalence rates per 10,000 people and provides key insights into how this condition affects certain age groups by ZIP Code. With its easy to use associated map view, this dataset allows users to quickly gain deeper knowledge about this important health issue and craft meaningful solutions to address it

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains counts and rates of asthma related emergency department visits by ZIP Code and age group in California. This data can be useful when doing research on asthma related trends or attempting to find correlations between environmental factors, prevalence of disease and geography.

Select a year for analysis - the latest year for which data is available is the default selection, but other years are also listed in the dropdown menu.

Select an Age Group to analyze - use the provided dropdown menus to select one or more age groups (all ages, 0-17, 18+) if you wish to analyze two different age groups in your analysis.

Define a geographical area by selecting a ZIP code or County Fips code from which you wish to obtain your dataset from based on its availability or importance in your research question .

View and download relevant data - after selecting all of the desired criteria (year,Age group(s), ZIP code/County FIPS Code) click “View Data” then “Download” at the bottom right corner of window that opens up
5 Analyze information found - use software such as Microsoft Excel or open source programs like Openoffice Calc to gain insight into your downloaded dataset through statistics calculations, graphs etc.. In particular look out for anomalies that could signify further investigation

Research Ideas

Identifying the geographic clusters of asthma sufferers by analyzing the rate of emergency department visits with geographic mapping.

Developing outreach initiatives to areas with a high rate of ED visits for asthma to provide education, interventions and resources designed towards increasing preventive care and reducing preventable complications due to lack of access or knowledge about available services in these communities.

Assessing disparities in ED visit rates for asthma between age groups as well as between urban and rural areas or different socio-economic groups within counties or ZIP codes in order to identify areas where there is a need for increased interventions, services and other resources related to asthma care in order to reduce the burden or severity of this chronic condition among particularly vulnerable population groups

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: Open Database License (ODbL) v1.0

You are free to:

Share - copy and redistribute the material in any medium or format.

Adapt - remix, transform, and build upon the material for any purpose, even commercially.

You must:

Give appropriate credit - Provide a link to the license, and indicate if changes were made.

ShareAlike - You must distribute your contributions under the same license as the original.

Keep intact - all notices that refer to this license, including copyright notices.

No Derivatives - If you remix, transform, or build upon the material, you may not distribute the modified material.

No additional restrictions - You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.

Columns

File: Asthma_Emergency_Department_Visit_Rates_by_ZIP_Code.csv

Column name	Description
Year	The year the data was collected. (Integer)
ZIP code	The ZIP code of the area the data was collected from. (String)
Age Group	The age group of the individuals included in the data. (String)
Number of Visits	The number of emergency department visits for asthma reported in the given area and age group. (Integer)
Age-adjusted rate	The age-adjusted rate of emergency department visits for asthma reported in the given area and age group. (Float)
County Fips code	The FIPS code of the county the data was collected from. (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Health.

Tables

Asthma Emergency Department Visit Rates By Zip Code

@kaggle.thedevastator_asthma_ed_visit_rates_by_zip.asthma_emergency_department_visit_rates_by_zip_code

177.52 KB
7086 rows
8 columns


CREATE TABLE asthma_emergency_department_visit_rates_by_zip_code (
  "index" BIGINT,
  "year" BIGINT,
  "zip_code" VARCHAR,
  "age_group" VARCHAR,
  "number_of_visits" DOUBLE,
  "age_adjusted_rate" DOUBLE,
  "county_fips_code" BIGINT,
  "county" VARCHAR
);