-
Notifications
You must be signed in to change notification settings - Fork 0
/
lacuna.html
172 lines (166 loc) · 15.2 KB
/
lacuna.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
<!doctype html>
<html lang="en">
<head>
<title>LIRNEasia · Visualizations</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="author" content="Viren Dias">
<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
<link rel="stylesheet" href="https://unpkg.com/material-components-web@latest/dist/material-components-web.min.css">
<link rel="stylesheet" href="./css/app.css">
</head>
<body class="mdc-typography">
<header class="mdc-top-app-bar mdc-top-app-bar--short mdc-top-app-bar--short-collapsed mdc-top-app-bar--short-has-action-item" data-mdc-auto-init="MDCTopAppBar" style="top: 0px;">
<div class="mdc-top-app-bar__row">
<section class="mdc-top-app-bar__section mdc-top-app-bar__section--align-start">
<a href="./" class="mdc-icon-button material-icons mdc-top-app-bar__navigation-icon">home</a>
</section>
<section class="mdc-top-app-bar__section mdc-top-app-bar__section--align-end">
<a href="https://lirneasia.net" target="_blank" class="mdc-button mdc-button--unelevated" data-mdc-auto-init="MDCRipple">
<div class="mdc-button__ripple"></div>
<span class="mdc-button__label">LIRNEasia</span>
</a>
</section>
</div>
</header>
<main>
<h3 class="mdc-typography--headline2 style="font-size: 0.5rem;">Household electricity consumption dataset (LACUNA)</h3>
<div class="container">
<p class="mdc-typography--body1" align="center">This repository contains a subset of a larger two-part dataset,
combining domestic electricity consumption data with survey responses from the same households. The dataset
was compiled with support from the LACUNA Fund.</p>
<img class="responsive-image" src="./resources/dataset_structure.png" alt="Description of the full-dataset (This repository currently contains a subset)">
<ul>
<li>EC-1: Data from a longitudinal survey (with 3 rounds of data collection over one year) capturing the drivers,
attitudes and behaviour around domestic energy consumption of over 4,000 consumers of the Lanka Electricity Company
(LECO). These 4,000 consumers will be divided into two primary groups:
<ul>
<li> 2000 households with smart electricity meters </li>
<li> 2000 households with traditional meters containing end-of-month consumption data </li>
</ul>The survey is representative for both smart-metered and non-smart- metered households of the electricity provider's
customer base at +/- 2.2% margin of error at 95% confidence interval. </li>
<li>EC-2: Electricity consumption data for a 20-month period for the same 4,000 households on which the survey is
conducted. For the smart metered households, this will include detailed electricity profile across different
parameters (e.g., power, voltage, current). For non- smart metered households, it will only be end-of-month
total consumption. </li>
</ul>
</div>
<h2 class="mdc-typography--headline4">Dataset Overview</h2>
<table class="mdc-data-table__table" style="width:100%; border-collapse: collapse; margin-top: 20px;">
<thead>
<tr>
<th style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Data Type</th>
<th style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">File Name</th>
<th style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Description</th>
<th style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Data Quality Profiling / Exploratory Data Analysis</th>
<th style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Data Dictionary</th>
<th style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Download Link</th>
</tr>
</thead>
<tbody>
<!-- Consumption Data Rows -->
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;" rowspan="2">EC-2</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Smart Meter Data</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Household electricity consumption recorded every 15 minutes via smart meters.</td>
<!-- <td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="link-to-smart-meter-data.csv" target="_blank">View</a></td> -->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"></td>
<!-- <td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;" rowspan="2"><a href="link-to-smart-meter-data.csv" target="_blank">Download EC2 Dictionary</a></td> -->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;" rowspan="2"><a href="./resources/data_dictionary/EC2_dict.docx" download="EC2_dictionary.docx" target="_blank">Download EC2 Dictionary</a></td></td>
<!-- <td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Household_id, Date, Time, Import kWh (kWh), Export kWh (kWh), Import kvarh (kvarh), Export kvarh (kvarh), Phase A Inst. Current (A), Phase ABC Power factor, Avg. Import kW (kW), Avg. Export kW (kW), etc</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="https://github.com/LIRNEasia/d3-visualizations/tree/master/resources/lacuna_dataset/consumption/smart_meter_data" >Download</a></td>
</tr>
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Non-Smart Meter Data</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Monthly household electricity consumption data</td>
<!-- <td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="link-to-smart-meter-data.csv" target="_blank">View</a></td> -->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Household_id, Date, Consumption</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/lacuna_dataset/consumption/non_smart_meter_data.csv" download="non_smart_meter_data.csv" target="_blank">Download</a></td>
</tr>
<!-- Survey Data Rows -->
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;" rowspan="8">EC-1 - Wave 1</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Demographics</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Household demographic details collected in Wave 1.</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_demographics.html" target="_blank">View</a></td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;" rowspan="8"><a href="./resources/data_dictionary/w1-data-dictionary.xlsx" download="w1-data-dictionary.xlsx" target="_blank">Download EC1 Dictionary</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Household_id, Member_id, Age, Gender, Education level, Occupation, etc.</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_demographics.csv" download="w1_demographics.csv" target="_blank">Download</a>
</td>
</tr>
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Household Information and History</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Information about the household, structure, materials used and build history</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_household_information_and_history.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">No_of_electricity_meters, LECO CSC area, built_year, type_of_household, floor_area, etc</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_household_information_and_history.csv" download="w1_household_information_and_history.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Appliance Usage</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Details on appliance usage patterns in the household.</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_appliances.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Appliance type, No of appliances of the type, hours used during last week </td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_appliances.csv" download="w1_appliances.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Room Roster</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Information about the rooms in the household</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_room_roster.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Room type, Roof material used, floor material, no of windows, no of lights, ACs, Fans in the room</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_room_roster.csv" download="w1_room_roster.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
<tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Light Roster</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Information about the light bulbs in the household</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_light_roster.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Room_id, type_of_the_bulb, wattage_of_the_bulb, No_of_hours_used_last_week(daytime), No_of_hours_used_last_week(nighttime)</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_light_roster.csv" download="w1_light_roster.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Fan Roster</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Information about the Fans in the household</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_fan_roster.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Room_id, type_of_the_fan, No_of_hours_used_last_week(daytime), No_of_hours_used_last_week(nighttime)</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_fan_roster.csv" download="w1_fan_roster.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">AC Roster</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Information about the ACs in the household</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_ac_roster.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Room_id, type_of_the_AC, inverter_or_not, is_the_room_fully_sealed, wattage_of_the_ac, btu, No_of_hours_used_last_week(daytime), No_of_hours_used_last_week(nighttime)</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_ac_roster.csv" download="w1_ac_roster.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
</tr>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Other</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">Information about methods of household electricity generation, water heating and cooking</td>
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;"><a href="./resources/data_profiling/w1_electricity_generation_water_heating_cooking.html" target="_blank">View</a></td>
<!--<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">generation of electricity using solar power, energy source used for heating and cooling</td>-->
<td style="border: 1px solid #ddd; padding: 8px; word-wrap: break-word; white-space: normal;">
<a href="./resources/lacuna_dataset/survey_wave1/w1_electricity_generation_water_heating_cooking.csv" download="w1_electricity_generation_water_heating_cooking.csv" target="_blank">Download</a>
</td>
</tr>
</tr>
<!-- Repeat Survey Rows for Wave 2, Wave 3, etc. -->
</tbody>
</table>
</main>
</body>
</html>