Loading...

Consumption per Municipality and DE35 industry codes Data

Total number of rows: 224,202


2020-01 999 999 2,214 6,845,880
2020-01 999 461 16 1,390,977
2020-01 999 450 76 76,672
2020-01 999 447 51 1,561,895
2020-01 999 446 27 76,545
2020-01 999 445 22 38,353
2020-01 999 442 19 9,193
2020-01 999 441 70 1,585,349
2020-01 999 433 34 33,452
2020-01 999 432 28 37,734
2020-01 999 422 21 5,069
2020-01 999 421 11 26,922
2020-01 999 211 32 19,865
2020-01 999 130 89 22,765
2020-01 999 122 12 10,947
2020-01 999 121 205 60,867
2020-01 999 119 28 39,947
2020-01 999 111 292 56,922
2020-01 860 999 4,676 7,291,961
2020-01 860 450 261 341,285
2020-01 860 447 172 681,912
2020-01 860 446 375 406,196
2020-01 860 445 362 403,913
2020-01 860 444 71 412,419
2020-01 860 443 110 638,211
2020-01 860 442 213 807,271
2020-01 860 441 273 3,333,292
2020-01 860 433 413 774,763
2020-01 860 432 286 767,625
2020-01 860 431 476 1,037,325
2020-01 860 422 123 607,302
2020-01 860 421 554 1,649,610
2020-01 860 410 192 379,119
2020-01 860 390 26 68,255
2020-01 860 370 94 277,069
2020-01 860 360 38 371,309
2020-01 860 350 26 709,398
2020-01 860 340 35 46,258
2020-01 860 330 93 156,121
2020-01 860 320 35 309,594
2020-01 860 310 111 1,766,497
2020-01 860 220 12 8,098
2020-01 860 215 14 1,784
2020-01 860 212 351 609,092
2020-01 860 211 2,873 4,490,781
2020-01 860 130 5,512 1,635,005
2020-01 860 123 231 291,857
2020-01 860 122 1,149 1,174,846
2020-01 860 121 17,255 5,245,392
2020-01 860 119 881 509,867

Data Dictionary

Column Type Label Description
Month date
MunicipalityNo text
Industrycode_DE35 text
MeasurementPoints int4
TotalCon int4

Month

Name Month
Description

Year and month

Comment

-

Example 2017-01
Unit Months
Field Month
Property Constraint
Type date
Size 7
Format Regex
Validation Rules

Municipality number

Name Municipality number
Description

Each of the (currently) 98 Danish municipalityes has a unique number (code), ranging from 101 (Copenhagen) to 860 (Hjoerring).

Comment

The municipality number can be found by searcing "kommunenumre" on the internet.

Example 101
Unit Coded
Field MunicipalityNo
Property Constraint
Type string
Size 3
Format Regex
Validation Rules

Industry code, DE35

Name Industry code, DE35
Description

The DE35 (DE= "Dansk Energi") Industry code

Comment

For further information, please see the dataset "Industry codes, DE35"

Example 131
Unit Coded
Field Industrycode_DE35
Property Constraint
Type string
Size 3
Format Regex
Validation Rules

MeasurementPoints

Name MeasurementPoints
Description

Number of meters. Please note that a customer may have more that one meter.

Comment
Example -
Unit Number
Field MeasurementPoints
Property Constraint
Type integer
Size 6
Format Regex
Validation Rules

Total consumption

Name Total consumption
Description

Total electricity consumption in kWh

Comment
Example 543,45
Unit kWh
Field TotalCon
Property Constraint
Type integer
Size 9
Format Regex
Validation Rules >=0