Global Health Expenditure Database, WHO: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
The data are available here: http://apps.who.int/nha/database
The data are available here: http://apps.who.int/nha/database


We pull three series from this site: HealthExpGov%Tot, HealthExpPriv%Tot, HealthExpTot%GDP
We pull three series from this site: HealthExpGov%Tot, HealthExpPriv%Tot, HealthExpTot%GDP. These tables were updated in April of 2025.
 
{| class="wikitable"
|Tables
|Definition
|Unit
|Years
|Source
|Original Source
|Preprocessor
|Preprocessor Name
|Code
|Decimal Points
|-
|HealthExpTot%GDP
|Current health expenditure (CHE) as percentage of gross domestic product  (GDP) (%)
|Percent
|2000-2023
|WHO Global Health Expenditure Database
|<nowiki>https://apps.who.int/nha/database</nowiki>
|1
|HEALTH
|che_gdp
|2
|-
|HealthExpPriv%Tot
|Domestic private health expenditure (PVT-D) as percentage of current  health expenditure (CHE) (%)
|Percent
|2000-2023
|WHO Global Health Expenditure Database
|<nowiki>https://apps.who.int/nha/database</nowiki>
|1
|HEALTH
|pvtd_che
|2
|-
|HealthExpGov%Tot
|Domestic General Government Health Expenditure (GGHE-D) as % Current  Health Expenditure (CHE)
|Percent
|2000-2023
|WHO Global Health Expenditure Database
|<nowiki>https://apps.who.int/nha/database</nowiki>
|1
|HEALTH
|gghed_che
|2
|}
November 2024 Update:  
November 2024 Update:  


Line 16: Line 60:
# SeriesHealthExpCapDomPublic%GDP
# SeriesHealthExpCapDomPublic%GDP
# SeriesHealthExpCapDomPrivate%GDP
# SeriesHealthExpCapDomPrivate%GDP
As of right now they are not in IFs. They may need to be updated as codes between these and the three processors may be similar.


== Notes ==
== Notes ==

Latest revision as of 18:13, 28 April 2025

The data are available here: http://apps.who.int/nha/database

We pull three series from this site: HealthExpGov%Tot, HealthExpPriv%Tot, HealthExpTot%GDP. These tables were updated in April of 2025.

Tables Definition Unit Years Source Original Source Preprocessor Preprocessor Name Code Decimal Points
HealthExpTot%GDP Current health expenditure (CHE) as percentage of gross domestic product (GDP) (%) Percent 2000-2023 WHO Global Health Expenditure Database https://apps.who.int/nha/database 1 HEALTH che_gdp 2
HealthExpPriv%Tot Domestic private health expenditure (PVT-D) as percentage of current health expenditure (CHE) (%) Percent 2000-2023 WHO Global Health Expenditure Database https://apps.who.int/nha/database 1 HEALTH pvtd_che 2
HealthExpGov%Tot Domestic General Government Health Expenditure (GGHE-D) as % Current Health Expenditure (CHE) Percent 2000-2023 WHO Global Health Expenditure Database https://apps.who.int/nha/database 1 HEALTH gghed_che 2

November 2024 Update:

Created 9 tables:

  1. SeriesHealthExpCurrTot%GDP
  2. SeriesHealthExpCurrDomPrivate%GDP
  3. SeriesHealthExpCurrDomGenGovt%GDP
  4. SeriesHealthExpCurrExt%GDP
  5. SeriesHealthExpCapTot%GDP
  6. SeriesHealthExpCapDomTot%GDP
  7. SeriesHealthExpCapExt%GDP
  8. SeriesHealthExpCapDomPublic%GDP
  9. SeriesHealthExpCapDomPrivate%GDP

As of right now they are not in IFs. They may need to be updated as codes between these and the three processors may be similar.

Notes

  • WDI Revision states that indicators SH.XPD.TOTL.ZS Health expenditure, total (% of GDP) and SH.XPD.PRIV.ZS Health expenditure, private (% of GDP) have been deleted in April of 2018.
  • To replace these we pulled Current health expenditure (CHE) as percentage of gross domestic product (GDP) (%) for HealthExpTot%GDP and Domestic private health expenditure (PVT-D) as percentage of current health expenditure (CHE) (%) for HealthExpPriv%Tot

Pulling Data

There are two ways you can pull data. The first way is through the Global Health Expenditure Database bulk data download.

Go to https://apps.who.int/nha/database/Select/Indicators/en

1) Select download all data in XLSX format

Global health Expenditure Database.png

2) Search for your indicator in the tab 'Codebook'

Global health Expenditure Database excel sheet.png

3) The variable code is the first column, use this code to found your data in the tab 'Data'. For example the code 'che_gdp' refers to Current Health Expenditure (CHE) as % Gross Domestic Product (GDP)

Please do not pull the data through their interface as that data is not accurate. The bulk data will be the most accurate data.


The second way is to use GHO indicators page

Go to: https://www.who.int/data/gho/data/indicators

1) Search your indicator. It is very case sensitive.

WHO Indicator.png

2) The excel file you need will be in the tab Data

WHO Data.png

3) On the right side there will be the link that states EXPORT DATA in CSV. Right click on that link and save the link. You will get the csv excel file doing this.

WHO Data Link.png


Note: The aggregation rule for these three series is set to "none" which creates issues when viewing historical data.