Project 1: First Examination of data
The data had the range of health indicators and a wide range of headings. These are shown in the table below.
| Column name | Explanation | Value Type |
|---|---|---|
| GHO(Code) | Unique Code for each indicator | String |
| GHO(Display) | Health indicator | String |
| First Record | Year of first record | Integer |
| Final Record | Year of Final Record | Integer |
| GHO(URL) | URL of Global Health Obersvatory indicator | String |
| Datasource(CODE) | An ID similar to GHO(CODE). Only present in some indicators. Unique for each entry | String |
| Datasource(Display) | Only present in indicators with Datasource(Code). Share the same value. | String |
| Datasource(URL) | Only present in indicators with Datasource(Code). Reference URL for source for each entry. | String |
| Publishstate(Code) | States whether the entry is either Void or Published | String |
| Publishstate(Display) | States whether the entry is either Void or Published, similar to Publishstate(Code) | String |
| Publishstate(URL) | Blank for all entries | N/A |
| Year(Code) | Year of record entry | Integer/String |
| Year(Display) | Year of record entry | Integer/String |
| Year(URL) | Blank for all entries | N/A |
| Region(Code) | Gives the code for the region of the world. All cases entries are in China, so all the codes are WPR. | String |
| Region(Display) | Gives the code for the region of the world. All cases entries are in China, so all the displays are Western Pacific. | String |
| Region(URL) | Blank for all entries | N/A |
| WorldBankIncomeGroup(Code) | World Bank code for the income group for which the indicator was measured. Only present for certain | String |
| WorldbankIncomeGroup(Display) | Income group for which the indicator was measured. | String |
| WorldBankIncomeGroup(URL) | Blank for all entries. | N/A |
| Country(Code) | Country code; all codes were for China (CHN). | N/A |
| Country(Display) | Country Name. All entries were China | N/A |
| Sex(Code) | Code for each sex and a seperate code for both sexes, only present in certain indicators. | String |
| Sex(Display) | Full display for both sexes | String |
| Sex(URL) | Blank for all entries. | N/A |
| Display Value | Value for each entry. In some entries a range is given. | Single/String |
| Numeric | Value for each entry. When a range is given in display value the average is given in numeric. | Single |
| Low | Only used when a range is given for display value. Shows the lowest number of the range | Single |
| High | Only used when a range is given for display value. Shows the highest number of the range | Single |
| StdErr | Blank for all entries. | N/A |
| StdDev | Blank for all entries. | N/A |
| Comments | Additional information for each entry. Onlt present in a handful of entries. | String |
The remove duplicates function was used on the entire data base to determine the number of unique entries, this gave 112 unique health indicators. These ranged from the number of reported cases of cholera to General government expenditure on health as a percentage of total government expenditure.
A full list is shown below:
Antenatal care coverage - at least one visit (%)
Antiretroviral therapy coverage among people with advanced HIV infection (%), WHO 2006 guidelines
Antiretroviral therapy coverage among people with HIV infection eligible for ART according to 2010 guidelines (%)
Births attended by skilled health personnel (%)
Births by caesarean section (%)
Cellular subscribers (per 100 population)
Children aged <5 years overweight (%)
Children aged <5 years stunted (%)
Children aged <5 years wasted for age (%)
Cholera - number of reported cases
Cholera case fatality rate
Civil registration coverage of cause-of-death (%)
Community health workers density (per 10 000 population)
Contraceptive prevalence (%)
Crude birth rate (per 1000 population)
Crude death rate (per 1000 population)
Deaths due to tuberculosis among HIV-negative people (per 100 000 population)
Density of pharmaceutical personnel (per 10 000 population)
Dentistry personnel density (per 10 000 population)
Diphtheria - number of reported cases
Diphtheria tetanus toxoid and pertussis (DTP3) immunization coverage among 1-year-olds (%)
Distribution of causes of death among children aged <5 years (%) - Birth asphyxia
Distribution of causes of death among children aged <5 years (%) - Congenital anomalies
Distribution of causes of death among children aged <5 years (%) - Diarrhoea
Distribution of causes of death among children aged <5 years (%) - HIV/AIDS
Distribution of causes of death among children aged <5 years (%) - Injuries
Distribution of causes of death among children aged <5 years (%) - Malaria
Distribution of causes of death among children aged <5 years (%) - Measles
Distribution of causes of death among children aged <5 years (%) - Neonatal sepsis
Distribution of causes of death among children aged <5 years (%) - Other diseases
Distribution of causes of death among children aged <5 years (%) - Pneumonia
Distribution of causes of death among children aged <5 years (%) - Prematurity
Distribution of years of life lost by broader causes (%) - Injuries
Estimated number of malaria cases
Estimated number of malaria deaths
Estimated percentage of pregnant women living with HIV who received antiretrovirals for preventing mother-to-child transmission
External resources for health as a percentage of total expenditure on health
General government expenditure on health as a percentage of total expenditure on health
General government expenditure on health as a percentage of total government expenditure
Gross national income per capita (PPP int. $)
H5N1 influenza - number of reported cases
Hepatitis B (HepB3) immunization coverage among 1-year-olds (%)
Hospital beds (per 10 000 population)
Incidence of tuberculosis (per 100 000 population per year)
Infant mortality rate (probability of dying between birth and age 1 per 1000 live births)
Japanese encephalitis - number of reported cases
Life expectancy at age 60 (years)
Life expectancy at birth (years)
Literacy rate among adults aged >= 15 years (%)
Low-birth-weight newborns (%)
Malaria - number of reported confirmed cases
Malaria - number of reported deaths
Maternal mortality ratio (per 100 000 live births)
Measles - number of reported cases
Measles-containing-vaccine first-dose (MCV1) immunization coverage among 1-year-olds (%)
Median availability of selected generic medicines (%) - Private
Median availability of selected generic medicines (%) - Public
Median consumer price ratio of selected generic medicines - Private
Median consumer price ratio of selected generic medicines - Public
Mental hospitals (per 100 000 population)
Most recent census (year)
Mumps - number of reported cases
Neonatal mortality rate (per 1000 live births)
Neonatal tetanus - number of reported cases
Number of community health workers
Number of dentistry personnel
Number of infant deaths (thousands)
Number of neonatal deaths (thousands)
Number of new leprosy cases
Number of nursing and midwifery personnel
Number of pharmaceutical personnel
Number of reported cases of cholera
Number of reported deaths from cholera
Number of under-five deaths (thousands)
Nursing and midwifery personnel density (per 10 000 population)
Out-of-pocket expenditure as a percentage of private expenditure on health
Per capita government expenditure on health (PPP int. $)
Per capita government expenditure on health at average exchange rate (US$)
Per capita total expenditure on health (PPP int. $)
Per capita total expenditure on health at average exchange rate (US$)
Pertussis - number of reported cases
Physicians density (per 10 000 population)
Plague - number of reported cases
Poliomyelitis - number of reported cases
Population (in thousands) total
Population living in urban areas (%)
Population living on <$1 (PPP int. $) a day (%)
Population median age (years)
Population proportion over 60 (%)
Population proportion under 15 (%)
Prevalence of HIV among adults aged 15 to 49 (%)
Prevalence of smoking any tobacco product among persons aged >= 15 years
Prevalence of tuberculosis (per 100 000 population)
Private expenditure on health as a percentage of total expenditure on health
Private prepaid plans as a percentage of private expenditure on health
Psychiatrists working in mental health sector (per 100 000 population)
Rubella - number of reported cases
Smear-positive tuberculosis treatment-success rate (%)
Social security expenditure on health as a percentage of general government expenditure on health
Total (recorded+unrecorded) alcohol per capita (15+) consumption
Total density per million population: Radiotherapy units
Total expenditure on health as a percentage of gross domestic product
Total fertility rate (per woman)
Total tetanus - number of reported cases
Tuberculosis - new and relapse cases
Tuberculosis treatment coverage
Under-five mortality rate (probability of dying by age 5 per 1000 live births)
Unmet need for family planning (%)
Yellow fever - number of reported cases