EnergyElectricityPKC

URL: https://data.pkc.gov.uk/dataset/3d8d3d43-35fc-4da1-b52b-0daf6c9c6f72/resource/ed1fd7df-69c5-41a3-b52f-ca111a308d34/download/energyelectricity.csv

Electricity usage data from Perth & Kinross Council owned buildings that have meters where automatic readings are recorded every 30 minutes. Data is for the last 52 week period.

There are no views created for this resource yet.

Data Dictionary

Column Type Label Description
Location text

The name of the building where the meter is located. Some buildings contain more than one meter.

EnergyType text

The type of energy being measured.

Units text Kilowatt hours

The units of the energy being measured. Both electricity and gas are measured in kilowatt hours (kWh). 1 kWh is equivalent to a power consumption of one thousand watts for one hour.

RecordedDate timestamp

The date the energy readings were recorded. The format is day/month/year eg: 01/01/2019

00:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

01:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

01:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

02:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

02:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

03:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

03:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

04:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

04:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

05:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

05:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

06:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

06:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

07:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

07:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

08:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

08:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

09:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

09:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

10:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

10:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

11:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

11:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

12:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

12:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

13:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

13:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

14:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

14:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

15:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

15:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

16:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

16:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

17:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

17:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

18:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

18:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

19:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

19:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

20:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

20:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

21:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

21:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

22:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

22:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

23:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

23:30 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

24:00 numeric Time in 24hr clock format

The time the meter reading was recorded. The format is 24 hour clock. The day begins at midnight, 00:00. The notation 24:00:00 is used to refer to midnight at the end of a given date.

TotalUnits numeric

The total energy consumption in kilowatt hours for that 24 hour period.

Additional Information

Field Value
Last updated December 15, 2019
Created unknown
Format CSV
License Open Government Licence 3.0 (United Kingdom)
Created3 months ago
Media typetext/csv
datastore activeTrue
formatCSV
ided1fd7df-69c5-41a3-b52f-ca111a308d34
last modified13 hours ago
on same domainTrue
package id3d8d3d43-35fc-4da1-b52b-0daf6c9c6f72
revision id04ef5eef-f94d-4b5d-92c4-b2a01307adf2
stateactive
url typeupload