Baselight

Air Pollution And Hospitalization

Air Pollution and Hospitalization in Vitória Metropolitan Zone, ES, Brazil

@kaggle.pedroberger_pollution_and_hospitalization

Loading...
Loading...

About this Dataset

Air Pollution And Hospitalization

Data on hospitalization of children and elderly and air pollution in the region of Grande Vitória, ES, Brazil.

The data represent the quantitative of hospital care (hospitalizations and emergency care) by ICD-10 (International Classification of Diseases) related to respiratory diseases (subclassification J) of children aged 28 days to 12 incomplete years, residents in the municipalities of Vitória, Vila Velha, Cariacica, and Serra, from ES, Brazil, in the period from January 1, 2015 to December 31, 2018. The data were obtained from the Department of Informatics of the Unified Health System (DATASUS). The municipalities were chosen for having at least one air quality monitoring station of the Automatic Air Quality Monitoring Network - RAMQAr.

The air pollutants analyzed were: inhalable particulate matter (MP10), respirable particulate matter (MP2.5), sulfur dioxide (SO2), nitrogen dioxide (NO2), and ozone (O3). The daily averages of the pollutants were obtained from data collected at the stations of the RAMQAr monitoring system, managed by the State Institute of Environment and Water Resources (IEMA), which provides spreadsheets with the hourly concentration of pollutants in 𝜇𝑔/m3.

We considered the 24-hour averages for the pollutants MP10, MP2.5 and SO2, the 24-hour maximum for NO2 and the 8-hour moving average for O3.

The database contains pollution data from two regions of the state of Espírito Santo, Brazil. The southern region (called "Sul") and the metropolitan region (called GV).

The variables you listed represent the hospitalizations and pollutants in each area.

When it ends with the acronym Kid, it refers to the number of children under 12 years old hospitalized that day.

When it ends with the abbreviation Old, it refers to the number of people over the age of 65 hospitalized that day.

When it has the abbreviation I it indicates that the hospitalization was for respiratory causes ( ICD-10 letter I)

When it has the abbreviation I it indicates that the hospitalization was for heart problems (ICD-10 letter J)

For example:

SIH_South_I_Old represents the number of hospital admissions of elderly people over 65 years old for respiratory problems in the "South" region

SIH_GV_J_Kid represents the number of hospital admissions of children under 12 years old for heart problems.

Finally, the rest of the base represent the average reading of pollutants at all stations per day in each region.

Example:

pm25 = particulate matter less than 2.5
pm10 = particulate matter less than 10
so2 = sulfur dioxide
no2 = NO2

Tables

Pollutants And Hosp

@kaggle.pedroberger_pollution_and_hospitalization.pollutants_and_hosp
  • 174.12 KB
  • 1462 rows
  • 21 columns
Loading...

CREATE TABLE pollutants_and_hosp (
  "data" TIMESTAMP,
  "sih_sul_i_old" BIGINT,
  "sih_sul_j_old" BIGINT,
  "sih_sul_i_kid" BIGINT,
  "sih_sul_j_kid" BIGINT,
  "sih_gv_i_old" BIGINT,
  "sih_gv_j_old" BIGINT,
  "sih_gv_i_kid" BIGINT,
  "sih_gv_j_kid" BIGINT,
  "pm25_gv" DOUBLE,
  "pm10_gv" DOUBLE,
  "so2_gv" DOUBLE,
  "no2_gv" DOUBLE,
  "co_gv" DOUBLE,
  "o3_gv" DOUBLE,
  "co_sul" DOUBLE,
  "o3_sul" DOUBLE,
  "no2_sul" DOUBLE,
  "so2_sul" DOUBLE,
  "pm10_sul" DOUBLE,
  "pm25_sul" DOUBLE
);

Share link

Anyone who has the link will be able to view this.