Login
Login

  • Open Data Portal
  • Collections
  • Citations
  • Contact us
    Home / Data Portal / NRSLR / ZAF-ESKOM-SU-UCT-DELS-1994-2014-V1
NRSLR

Domestic Electrical Load Survey 1994-2014

South Africa, 1995 - 2014
Get Microdata
Reference ID
zaf-eskom-su-uct-dels-1994-2014-v1
Producer(s)
Eskom, University of Cape Town, University of Stellenbosch
Collections
NRSLR Programme Domestic Electrical Load Study
Metadata
Documentation in PDF DDI/XML JSON
Created on
May 06, 2019
Last modified
Apr 10, 2020
Page views
80509
Downloads
3605
  • Study Description
  • Data Description
  • Downloads
  • Get Microdata
  • Related Publications
  • Identification
  • Version
  • Scope
  • Coverage
  • Producers and sponsors
  • Sampling
  • survey_instrument
  • Data Collection
  • Data processing
  • Data appraisal
  • Data Access
  • Contacts
  • Metadata production
  • Identification

    Survey ID number

    zaf-eskom-su-uct-dels-1994-2014-v1

    Title

    Domestic Electrical Load Survey 1994-2014

    Country
    Name Country code
    South Africa zaf
    Study type

    Household Survey [hh]

    Series Information

    Eskom, Stellenbosch University & University of Cape Town. Domestic Electrical Load Survey 1994-2014 [dataset]. Version 1. Johannesburg: Eskom, Cape Town: UCT, Stellenbosch: SU [producers], 2014. Cape Town: DataFirst [distributor], 2019. DOI: https://doi.org/10.25828/kzer-gd88

    Abstract

    This dataset contains the survey data collected as a compnent of the National Rationalised Specification Load Research (NRSLR) Programme. The NRSLR Programme is a joint academic-public-private research effort to collect electricity consumption data to inform South Africa’s electrification strategy. The survey, initially known as the National Load Research Tracking Study, was undertaken from 1994 to 2014 and covered South Africa and Namibia. Two questionnaires were used for survey data collection, one from 1994 - 1999 and one from 2000 - 2014.

    The NRS Load Research Programme was started in 1994 to provide inputs towards policy development and technical design guidelines for the domestic electricity distribution business in South Africa. The programme was overseen by the National Rationalised Specification (NRS) 034 Working Group at Eskom. Under this programme the Domestic Electrical Load (DEL) Study (also referred to as the Domestic Load Research Project) was designed and managed to collect electricity meter readings and conduct an annual socio-demographic survey of metered households. The resulting DEL data collection and research outputs present a collaborative, multi-party public-academic-private collaboration.

    Initiated by Dr Ron Herman (Stellenbosch University) and Prof. Trevor Gaunt (University of Cape Town), the study was promoted by the NRS 034 Working Group established within Eskom for this purpose. Early funders and collaborators included the Department of Minerals and Energy Affairs (now Department of Energy), the Council for Scientific and Industrial Research, as well as Stellenbosch, eThekwini and Nelson Mandela Bay Municipalities. From 1994 to 2009 eight municipalities contributed to data collection. Eskom Research, Testing and Development became actively involved in the study in 1997. Eskom survey data is only available from 2000. From 2001 onwards Eskom was the major data contributor and funder of the study. Prior to 1994, the National Energy Council and Development Bank of Southern Africa funded the development of the data loggers used in the study, as well as early research efforts by Dr Ron Herman and J.J. Kritzinger that influenced the study.

    This study made a major contribution to the electrification of South African households and enabled Eskom and municipalities to accurately forecast and right-size new power transmission and distribution infrastructure. The research outputs in power engineering that emerged from the data collected in this study, such as the Hermann-Beta distribution and the Geo-based Load Forecasting Standard, informed the design of South Africa's power system and have been used in the design of power grids in other developing countries.

    Kind of Data

    Sample survey data

    Unit of Analysis

    Households and individuals

    Version

    Version Description

    v1: edited, anonymised data for licensed distribution

    Version Date

    2019-05-13

    Version Notes

    Version 1

    Scope

    Notes

    The scope of the South African Domestic Electrical Load Survey data includes:
    Households: 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
    Behaviours: Cooking, heating, alternative fuels, paraffin, gas, wood, charcoal, coal,
    Electricity: Time electrified, power quality, lights dimming, power outages, power trips

    Keywords
    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 is suburb/settlement.

    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
    University of Cape Town
    University of Stellenbosch
    Producers
    Name Affiliation Role
    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)
    Council for Scientific and Industrial Research University of Cape Town Technical assistance
    Marcus Dekenah Consulting University of Cape Town Data collection, Technical assistance
    Funding Agency/Sponsor
    Name Role
    Department of Minerals and Energy Affairs (now: Department of Energy) Funder from 1994 - 1997
    Eskom Research Funder from 1998 - 2014
    South African National Energy Development Initiative 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

    The household surveys were performed in addition to electrical metering to provide socio-demographic, dwelling, and economic information on the households. The household survey was thus guided by the physical requirements and constraints of domestic electrical load metering. An overview of the sampling methodology for the load metering is described in the metadata for the DELMS dataset. The annual sample design is detailed in project reports (external resources of the DELMS dataset).

    Deviations from the Sample Design

    Every year before the winter survey collection period, site referencing was done to ensure that data loggers were metering the correct households. In the case where errors were encountered (for example if a logger or wire had been moved and reconnected incorrectly after a routine municipal maintenance procedure), the household to be surveyed was updated to correspond with the household that had been metered. Thus the target list for the household survyes was established and validated every year.

    Response Rate

    Survey enumerators were instructed to obtain at least an 80% response rate within a particular location (suburb or settlement). Revisits would be done until this target was reached and individual homes were revisited up to 3 times.

    Weighting

    Data is provided as is and no weightings have been applied.

    survey_instrument

    Questionnaires

    The questionaires were updated once in 1999 to incoporate lessons learned from the early study years. This data thus contains two subsets of survey responses - surveys from 1994 to 1999 capture responses to the first questionaire. Some of the existing questions in the questionaires used from the 2000 were rephrased. Additional questions were also added to the original questionnaire. Data collection was thus consistent from 1994 to 1999, and again from 2000 to 2014.

    Data Collection

    Dates of Data Collection
    Start End Cycle
    1995-05-01 1995-08-31 G1994
    1995-08-31 1996-05-01 G1995
    1996-08-31 1997-05-01 G1996
    1997-08-31 1998-05-01 G1997
    1998-08-31 1999-05-01 G1998
    1999-08-31 2000-05-01 G1999
    2000-08-31 2001-05-01 G2000
    2001-08-31 2002-05-01 G2001
    2002-08-31 2003-05-01 G2002
    2003-08-31 2004-05-01 G2003
    2004-08-31 2005-05-01 G2004
    2005-08-31 2006-05-01 G2005
    2006-08-31 2008-05-01 G2006
    2008-08-31 2009-05-01 G2008
    2009-08-31 2010-05-01 G2009
    2010-08-31 2012-05-01 G2010
    2012-08-31 2013-05-01 G2012
    2013-08-31 2014 G2013
    2014 2014-05-01 Final data collection
    2014-08-31 G2014
    Mode of data collection
    • Face-to-face [f2f]
    Data Collectors
    Name
    van der Bank Research and Training
    Data Collection Notes

    Surveys were done every May to August (inclusive). When access was difficult, briefings with a body corporate, estate managers or the traditional leaders in the area were facilitated to smoothen access to households. The survey was done with a representative household member who provided information about the household. Where possible, this was the head of the family living in the house. Where the family head was not available, this was a resident or visiting family member.

    TRAINING of enumerators
    A briefing session was conducted prior to field surveys every year. Municipal enumerators did not receive special training , as surveys were usually done on the job.

    INTERVIEW LANGUAGE and LENGTH
    Interviews were conducted in the language of the household and translated to English by the enumerator during the survey interaction. Interview length depended on the type of customers and typically took 15 minutes.

    FEEDBACK of field teams
    Feedback was received after data was captured at every site. The field data collection team was responsible for data capturing and bug fixing based on the output of an automated quality checking process.

    PILOT SURVEY
    No official pilot survey was done, but as the study underwent continuous improvement over its entire duration, early surveys can be viewed as pilots.

    CORRECTIVE ACTIONS
    At the end of the winter collection period problems and improvements for the following year were discussed and where possible incorporated. Resampling was not done, but households were visisted up to 3 times to service 'not at home' households.

    Data processing

    Data Editing

    This dataset has been produced by extracting all tables other than the Profiletable from the original NRS Load Research SQL database using the saveTables and saveAnswers functions 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.

    De-identification:
    De-identification was done in the process of extracting the data from the SQL database with the delretrieve package. Personal information has been removed from the survey responses by replacing responses with an 'a' in the dataset. De-identified variables are names of survey respondents and household owners, all street and postal addresses, erf numbers and all telephone numbers. Documents with full details of the variables that have been anonymised are included as external resources.

    Group Table:
    The parent-child hierarchy of the groups table was deconstructed into levels and reconstructed as a 4-level multi-index table with the following levels:
    Level 1 - domestic / non-domestic
    Level 2 - Survey type : Eskom LR, NRS LR, Namibia [domestic] / Clinics, Shops, Schools [non-domestic]
    Level 3 - Years
    Level 4 - Locations

    Missing Values:
    Other than de-identification and reshaping the groups table no post-processing was done and all database records, including missing values, are stored exactly as retrieved.

    Data appraisal

    Data Appraisal

    Throughout the study during the course of the data collection process data editing of survey responses was done in a number of stages before data entry into the database.

    Site referencing:
    Every year the site references were gathered at each site, captured and verified (February - May). This was used to produce the target list for the socio-demographic surveys. Once socio-demographics from surveys were returned, they were used together with the target list to link them to instruments. The link between survey responses and observational profiles in the links table was validated annually.

    Quality control during data collection:
    Surveys were collected one site at a time, typically with 4 enumerators and one controller. The supervisor ensured standardisation of data collection, manage logistics and liaison and to visually verify all returned surveys on the day of data collection, thus identifiying any 'illegal' data entries. Typically the work at each site would take 2 - 3 days to collect up to 60 surveys. Upper management visited every site over a number of years. Thus a portion of sites was visited annually. These visits were planned to coincide with survey collection.

    Missing surveys:
    Eskom got involved in the study in 1997, but Eskom survey data is only available from 2000 onwards. No survey data was collected in 2007 and 2011. Some anecdotal events were recorded in Eskom Annual Reports.

    Data Access

    Access authority
    Name Affiliation URL Email
    DataFirst University of Cape Town support.data1st.org support@data1st.org
    Access conditions

    Licensed use files, available for non-commercial use only

    Citation requirements

    Eskom, Stellenbosch University & University of Cape Town. Domestic Electrical Load Survey 1994-2014 [dataset]. Version 1. Johannesburg: Eskom, Cape Town: UCT, Stellenbosch: SU [producers], 2014. Cape Town: DataFirst [distributor], 2019. DOI: https://doi.org/10.25828/kzer-gd88

    Contacts

    Contacts
    Name Affiliation Email URL
    DataFirst University of Cape Town support@data1st.org support.data1st.org

    Metadata production

    Producers
    Name Affiliation Role
    Energy Research Centre University of Cape Town Metadata producer
    Date of Metadata Production

    2020-04-10

    Metadata version

    DDI Document version

    Version 4

    Back to Catalog
    DataFirst

    © DataFirst, All Rights Reserved.