Domestic Electrical Load Survey Secure Data 1994-2014
South Africa, 1995 - 2014
Eskom, Stellenbosch University, University of Cape Town
Identification
Survey ID Number
zaf-eskom-uct-us-delss-1994-2014-v1
Title
Domestic Electrical Load Survey Secure Data 1994-2014
Country
| Name | Country code |
|---|---|
| South Africa | ZAF |
Study type
Household Survey [hh]
Abstract
This dataset contains sensitive data that has not been disclosed in the online version of the Domestic Electrical Load Survey (DELS) 1994-2014 dataset. In contrast to the DELS dataset, the DELS Secure Data contains partially anonymised survey responses with only the names of respondents and home owners removed. The DELSS contains street and postal addresses, as well as GPS level location data for households from 2000 onwards. The GPS data is obtained through an auxiliary dataset, the Site Reference database. Like the DELS, the DELSS dataset has been retrieved and anonymised from the original SQL database with the python package delretrieve.
Kind of Data
Sample survey data
Unit of Analysis
Households and individuals
Version
Version Description
v1: Edited, partially anonymised data for use in DataFirst's secure research data centre https://www.datafirst.uct.ac.za/services/secure-data-services
Version Date
2019-05-13
Version Notes
Version 1
Scope
Notes
The scope of the South African Domestic Electrical Load Survey Secure Data includes:
HOUSEHOLD: Household characteristics, occupant demographics of gender and age, education, employment, income, income sources, number of household occupants with income, dwelling ownership, gender of head of household,
DWELLING: Dwelling characteristics, wall material, roof material, floor area, ceiling, insulation, rooms, water source, out-buildings, circuit breaker, business use
APPLIANCES: Appliance characteristics, stove, hotplate, kettle, heater, iron, geyser, washing machine, TV, HiFi radio, lights, fridge, freezer, microwave, tumble dryer, broken appliances, appliance usage
BEHAVIOUR: Cooking, heating, alternative fuels, paraffin, gas, wood, charcoal, coal,
ELECTRICITY: Time electrified, power quality, lights dimming, power outages, power trips
HOUSEHOLD: Household characteristics, occupant demographics of gender and age, education, employment, income, income sources, number of household occupants with income, dwelling ownership, gender of head of household,
DWELLING: Dwelling characteristics, wall material, roof material, floor area, ceiling, insulation, rooms, water source, out-buildings, circuit breaker, business use
APPLIANCES: Appliance characteristics, stove, hotplate, kettle, heater, iron, geyser, washing machine, TV, HiFi radio, lights, fridge, freezer, microwave, tumble dryer, broken appliances, appliance usage
BEHAVIOUR: Cooking, heating, alternative fuels, paraffin, gas, wood, charcoal, coal,
ELECTRICITY: Time electrified, power quality, lights dimming, power outages, power trips
Keywords
| Keyword |
|---|
| electrical |
| household |
| load data |
| domestic |
| electrification |
| power quality |
| electricity |
| consumption |
| energy |
| rural |
| residential |
| appliance |
Coverage
Geographic Coverage
The study had national coverage.
Geographic Unit
The lowest unit of geographic aggregation in the secure (restricted-access) version of the data is street address, and household GPS coordinates from 2000 onwards.
Universe
The survey covers electrified households that received electricity either directly from Eskom or from their local municipality. Particular attention was devoted to rural and low income households, as well as surveying households electrified over a range of years, thus having had access to electricity from recent times to several decades.
Producers and sponsors
Primary investigators
| Name | Affiliation |
|---|---|
| Eskom | Government of South Africa |
| Stellenbosch University | |
| University of Cape Town |
Producers
| Name | Affiliation | Role |
|---|---|---|
| Council for Scientific and Industrial Research | Technical assistance | |
| Marcus Dekenah Consulting | Data collection, technical assistance | |
| Schalk Heunis | Enerweb | [Technical assistance in] sampling methodology/selection, data processing, data quality control, statistical analysis, data analysis (1995 - 2014) |
| Wiebke Toussaint | University of Cape Town | [Technical assistance in] data science, data stewardship, data archiving, data publishing (2017 - 2019) |
Funding Agency/Sponsor
| Name | Abbreviation | Role |
|---|---|---|
| Department of Minerals and Energy Affairs (now: Department of Energy) | DMEA | Funder from 1994 - 1997 |
| Eskom Research | Eskom | Funder from 1998 - 2014 |
| South African National Energy Development Initiative | SANEDI | Funder in 2019 for data archiving |
Other Identifications/Acknowledgments
| Name | Affiliation | Role |
|---|---|---|
| City of Cape Town | Government of South Africa | provided data loggers and human resources for data collection (1997 - 2006) |
| City of Johannesburg | Government of South Africa | provided data loggers and human resources for data collection (1996 - 2000) |
| City of Tshwane | Government of South Africa | provided data loggers and human resources for data collection (2001 - 2003, 2005 - 2009) |
| eThekwini Municipality | Government of South Africa | provided data loggers and human resources for data collection (1995, 1997 - 2002, 2005, 2006) |
| Msunduzi Municipality | Government of South Africa | provided data loggers and human resources for data collection (1996, 1997) |
| Mantsopa Municipality | Government of South Africa | provided data loggers and human resources for data collection (1996, 1997) |
| Nelson Mandela Bay Municipality | Government of South Africa | provided data loggers and human resources for data collection (1995, 1997 - 2006) |
| Stellenbosch Municipality | Government of South Africa | provided data loggers and human resources for data collection (1994) |
Sampling
Sampling Procedure
See sampling procedure for DELS 1994-2014
Data Collection
Dates of Data Collection
| Start | End | Cycle |
|---|---|---|
| 2014 | 2014 | Final data collection |
| 1995-05-01 | 1995-08-31 | G1994 |
| 1995-05-01 | 1995-08-31 | G1995 |
| 1996-05-01 | 1996-08-31 | G1996 |
| 1997-05-01 | 1997-08-31 | G1997 |
| 1998-05-01 | 1998-08-31 | G1998 |
| 1999-05-01 | 1999-08-31 | G1999 |
| 2000-05-01 | 2000-08-31 | G2000 |
| 2001-05-01 | 2001-08-31 | G2001 |
| 2002-05-01 | 2002-08-31 | G2002 |
| 2003-05-01 | 2003-08-31 | G2003 |
| 2004-05-01 | 2004-08-31 | G2004 |
| 2005-05-01 | 2005-08-31 | G2005 |
| 2006-05-01 | 2006-08-31 | G2006 |
| 2008-05-01 | 2008-08-31 | G2008 |
| 2009-05-01 | 2009-08-31 | G2009 |
| 2010-05-01 | 2010-08-31 | G2010 |
| 2012-05-01 | 2012-08-31 | G2012 |
| 2013-05-01 | 2013-08-31 | G2013 |
| 2014-05-01 | 2014-08-31 | G2014 |
Data Collection Mode
Face-to-face [f2f]
Data Collection Notes
See notes on data collection for DELS 1994-2014.
Data Processing
Data Editing
This dataset has been produced by extracting only the survey responses from the original NRS Load Research SQL database using the saveAnswers function from the delretrieve python package (https://github.com/wiebket/delretrieve: release v1.0). Full instructions on how to use delretrieve to extract data are in the README file contained in the package.
PARTIAL DE-IDENTIFICATION
Partial de-identification was done in the process of extracting the data from the SQL database with the delretrieve package. Only the names of respondents and home owners have been removed from the survey responses by replacing responses with an 'a' in the dataset. Documents with full details of the variables that have been anonymised are included as external resources.
MISSING VALUES
Other than partial de-identification no post-processing was done and all database records, including missing values, are stored exactly as retrieved.
PARTIAL DE-IDENTIFICATION
Partial de-identification was done in the process of extracting the data from the SQL database with the delretrieve package. Only the names of respondents and home owners have been removed from the survey responses by replacing responses with an 'a' in the dataset. Documents with full details of the variables that have been anonymised are included as external resources.
MISSING VALUES
Other than partial de-identification no post-processing was done and all database records, including missing values, are stored exactly as retrieved.
Data Appraisal
Data Appraisal
See notes on data quality for DELS 1994-2014
Access policy
Access authority
| Name | Affiliation | URL | |
|---|---|---|---|
| DataFirst | University of Cape Town | support@data1st.org | support.data1st.org |
Contacts
| Name | Affiliation | URL | |
|---|---|---|---|
| DataFirst | University of Cape Town | support@data1st.org | support.data1st.org |
Access conditions
Secure Research Data Centre access https://www.datafirst.uct.ac.za/services/secure-data-services
Citation requirements
Eskom, Stellenbosch University, University of Cape Town. Domestic Electrical Load Survey-Secure Data 1994-2014 [dataset]. version 1. Johannesburg: Eskom, Cape Town: UCT, Stellenbosch: US [producers], 2014. Cape Town: DataFirst [distributor], 2019.10.25828/7jtv-mc31
Metadata production
Producers
| Name | Abbreviation | Affiliation | Role |
|---|---|---|---|
| Energy Research Centre | ERC | University of Cape Town | Metadata producer |
Date of Metadata Production
2019-05-28
DDI Document version
V2