CKW Smart Meter Data - Electricity Consumption in Canton Lucerne
| Files | Size | Format | Created | Updated | License | Source |
|---|---|---|---|---|---|---|
| 1 | 43.9 MB | parquet | about 1 year ago | Creative Commons Attribution 4.0 International | CKW Open Data - Smart Meter Dataset A |
Anonymised and aggregated smart meter data measuring electricity consumption from the CKW Group, a distribution system operator supplying more than 200,000 end customers in Central Switzerland. This dataset contains a small sample of CKW data set A, with 15-minute interval electricity consumption measurements from individual smart meters, stored as parquet files organized by smart meter ID. The original data covers the period from January 2021 to April 2024.
Data Views
Error in datapackage:
Data Files
| File | Description | Size | Last modified | Download |
|---|---|---|---|---|
smart-meter-timeseries | Individual smart meter electricity consumption time series data. Each parquet file is named with the anonymized smart meter ID (e.g., 027ceb7b8fd77a4b11b3b497e9f0b174.parquet) and contains all consumption measurements for that specific meter across the covered time period. | 43.9 MB | smart-meter-timeseries |
Data Previews
smart-meter-timeseries
Schema
| name | type | format | description |
|---|---|---|---|
| id | string | Anonymized smart meter counter ID (MD5 hash) | |
| timestamp | datetime | default | UTC timestamp at the beginning of the 15-minute measurement window (ISO-8601 format) |
| value_kwh | number | Electricity consumption in kilowatt-hours (kWh) during the 15-minute time window |
This data set contains a small sample of the CKW data set A sorted per smart meter ID, stored as parquet files named with the id field of the corresponding smart meter anonymised data. Example: 027ceb7b8fd77a4b11b3b497e9f0b174.parquet
Data
Description
Sources
Preparation
Processing
Setup workflow to work remotely from VM hosted in Switch engines.
In order to authenticate to git and be able to clone the repository, first make sure you have
- a github account
- a personal access token
- a ssh key pair
- a ssh key pair added to your github account
- a ssh key pair added to your ssh-agent
- create a new ssh key pair
ssh-keygen -t rsa -b 4096 -C "hintisberg"
ssh-keygen -t ecdsa -C "hintisberg in braulio's github account"
copy the public key to your clipboard
pbcopy < ~/.ssh/id_rsa.pub
Or simply with cat ~/.ssh/id_rsa.pub and then copy from the terminal output.
use standard output to copy the public key to your clipboard and then put it to clipboard
cat ~/.ssh/id_rsa.pub | pbcopy
copy to cliboard without pbcopy
cat ~/.ssh/id_rsa.pub