Household Energy Database: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(Added pulling instructions)
(Added images to steps)
 
Line 24: Line 24:


== Steps to Pull Data From the Household Energy Database ==
== Steps to Pull Data From the Household Energy Database ==
'''Step 1:''' Navigate to the Household Energy Database home page
'''Step 1:''' Navigate to the [https://www.who.int/data/gho/data/themes/air-pollution/who-household-energy-db#:~:text=The%20Household%20energy%20database%20monitors,cooking%2C%20heating%20and%20lighting%20fuels. Household Energy Database home page]


[[File:HED STEP1.png|frameless|750x750px]]


'''Step 2:''' Scroll down to the indicators section (shown below) and click the desired indicator. As an example, we will be looking for '''population with primary reliance on clean fuels and technologies for cooking'''.


'''Step 2:''' Scroll down to the indicators section and click the desired indicator. As an example, we will be looking for '''population with primary reliance on clean fuels and technologies for cooking'''.


[[File:HED STEP2.png|frameless|750x750px]]
You will be navigated here:
You will be navigated here:
[[File:HED STEP 2A.png|frameless|750x750px]]




'''Step 3:''' Click the tab titled "Data"
'''Step 3:''' Click the tab titled "Data"
[[File:HED STEP3.png|frameless|750x750px]]




You will be navigated to this view:
You will be navigated to this view:
[[File:HED STEP3A.png|frameless|750x750px]]




'''Step 4:''' Right click the link in the corner of the page (circled below) and open the link as a new tab to download the data in a .csv format
'''Step 4:''' Right click the link in the corner of the page (circled below) and open the link as a new tab to download the data in a .csv format
[[File:HED STEP4.png|frameless|750x750px]]

Latest revision as of 03:35, 17 February 2023

Summary

The Household Energy Database monitors household energy use. The database contains nationally representative data from surveys and censuses on cooking, heating and lighting fuels. A proportion of the available surveys also include questions on stove type, time spent collecting fuel, and incidence of acute lower respiratory infection. The database is used to calculate national, rural and urban estimates for use of clean fuels and technologies (as well as the population affected), which WHO reports for Sustainable Development Goal Indicator 7.1.2. The database is regularly updated with new data from national censuses and large-scale household surveys such as the World Bank’s Living Standard and Measurement Survey and UNICEF’s Multiple Cluster Indicator Survey (MICS). The database is currently being upgraded in association with international and national surveys and censuses to include more data on heating and lighting fuels and technologies and emission rates, and to disaggregate data by sex and age whenever possible.


The Data Team uses the Household Energy Database for these series:

  • SeriesEnvSolidFuels
  • SeriesEnvCookingFuelBiogas%HHTotal
  • SeriesEnvCookingFuelBiomass%HHtotal
  • SeriesEnvCookingFuelCharcoal%HHTotal
  • SeriesEnvCookingFuelClean%HHtotal
  • SeriesEnvCookingFuelCoal%HHTotal
  • SeriesEnvCookingFuelCropWaste%HHTotal
  • SeriesEnvCookingFuelDung%HHTotal
  • SeriesEnvCookingFuelElec%HHTotal
  • SeriesEnvCookingFuelKerosene%HHTotal
  • SeriesEnvCookingFuelLNG%HHTotal
  • SeriesEnvCookingFuelLPG%HHTotal
  • SeriesEnvCookingFuelSolid%HHTotal
  • SeriesEnvCookingFuelWood%HHTotal


To pull data from the Household Energy Database for uploading into IFs, please follow the instructions below.

Steps to Pull Data From the Household Energy Database

Step 1: Navigate to the Household Energy Database home page

HED STEP1.png


Step 2: Scroll down to the indicators section and click the desired indicator. As an example, we will be looking for population with primary reliance on clean fuels and technologies for cooking.

HED STEP2.png You will be navigated here:

HED STEP 2A.png


Step 3: Click the tab titled "Data"

HED STEP3.png


You will be navigated to this view:

HED STEP3A.png


Step 4: Right click the link in the corner of the page (circled below) and open the link as a new tab to download the data in a .csv format

HED STEP4.png