Checks

Half Hourly Variables

var_id product region min max
0 15 AGILE-18-02-21 A 2019-01-01 00:00 2021-11-28 22:30
1 16 AGILE-18-02-21 B 2019-01-01 00:00 2021-11-28 22:30
2 17 AGILE-18-02-21 C 2019-01-01 00:00 2021-11-28 22:30
3 18 AGILE-18-02-21 D 2019-01-01 00:00 2021-11-28 22:30
4 19 AGILE-18-02-21 E 2019-01-01 00:00 2021-11-28 22:30
5 20 AGILE-18-02-21 F 2019-01-01 00:00 2021-11-28 22:30
6 21 AGILE-18-02-21 G 2019-01-01 00:00 2021-11-28 22:30
7 22 AGILE-18-02-21 H 2019-01-01 00:00 2021-11-28 22:30
8 23 AGILE-18-02-21 J 2019-01-01 00:00 2021-11-28 22:30
9 24 AGILE-18-02-21 K 2019-01-01 00:00 2021-11-28 22:30
10 25 AGILE-18-02-21 L 2019-01-01 00:00 2021-11-28 22:30
11 26 AGILE-18-02-21 M 2019-01-01 00:00 2021-11-28 22:30
12 27 AGILE-18-02-21 N 2019-01-01 00:00 2021-11-28 22:30
13 28 AGILE-18-02-21 P 2019-01-01 00:00 2021-11-28 22:30
14 47 AGILE-OUTGOING-19-05-13 A 2019-01-01 00:00 2021-11-28 22:30
15 48 AGILE-OUTGOING-19-05-13 B 2019-01-01 00:00 2021-11-28 22:30
16 49 AGILE-OUTGOING-19-05-13 C 2019-01-01 00:00 2021-11-28 22:30
17 50 AGILE-OUTGOING-19-05-13 D 2019-01-01 00:00 2021-11-28 22:30
18 51 AGILE-OUTGOING-19-05-13 E 2019-01-01 00:00 2021-11-28 22:30
19 52 AGILE-OUTGOING-19-05-13 F 2019-01-01 00:00 2021-11-28 22:30
20 53 AGILE-OUTGOING-19-05-13 G 2019-01-01 00:00 2021-11-28 22:30
21 54 AGILE-OUTGOING-19-05-13 H 2019-01-01 00:00 2021-11-28 22:30
22 55 AGILE-OUTGOING-19-05-13 J 2019-01-01 00:00 2021-11-28 22:30
23 56 AGILE-OUTGOING-19-05-13 K 2019-01-01 00:00 2021-11-28 22:30
24 57 AGILE-OUTGOING-19-05-13 L 2019-01-01 00:00 2021-11-28 22:30
25 58 AGILE-OUTGOING-19-05-13 M 2019-01-01 00:00 2021-11-28 22:30
26 59 AGILE-OUTGOING-19-05-13 N 2019-01-01 00:00 2021-11-28 22:30
27 60 AGILE-OUTGOING-19-05-13 P 2019-01-01 00:00 2021-11-28 22:30
28 31 CO2_National Z 2019-01-01 00:00 2021-11-28 03:00
29 33 GO-18-06-12 A 2019-01-01 00:00 2021-11-29 00:00
30 34 GO-18-06-12 B 2019-01-01 00:00 2021-11-29 00:00
31 35 GO-18-06-12 C 2019-01-01 00:00 2021-11-29 00:00
32 36 GO-18-06-12 D 2019-01-01 00:00 2021-11-29 00:00
33 37 GO-18-06-12 E 2019-01-01 00:00 2021-11-29 00:00
34 38 GO-18-06-12 F 2019-01-01 00:00 2021-11-29 00:00
35 39 GO-18-06-12 G 2019-01-01 00:00 2021-11-29 00:00
36 40 GO-18-06-12 H 2019-01-01 00:00 2021-11-29 00:00
37 41 GO-18-06-12 J 2019-01-01 00:00 2021-11-29 00:00
38 42 GO-18-06-12 K 2019-01-01 00:00 2021-11-29 00:00
39 43 GO-18-06-12 L 2019-01-01 00:00 2021-11-29 00:00
40 44 GO-18-06-12 M 2019-01-01 00:00 2021-11-29 00:00
41 45 GO-18-06-12 N 2019-01-01 00:00 2021-11-29 00:00
42 46 GO-18-06-12 P 2019-01-01 00:00 2021-11-29 00:00
43 29 Profile_1 Z 2019-01-01 00:00 2022-03-31 22:30
44 30 Profile_2 Z 2019-01-01 00:00 2022-03-31 22:30

Gaps in hh variables - see below

No duplicates in hh variables

Daily Variables

var_id product region min max
0 75 SILVER-2017-1 A 2019-01-01 2021-11-28
1 61 SILVER-2017-1 A 2019-01-01 2021-11-28
2 62 SILVER-2017-1 B 2019-01-01 2021-11-28
3 76 SILVER-2017-1 B 2019-01-01 2021-11-28
4 63 SILVER-2017-1 C 2019-01-01 2021-11-28
5 77 SILVER-2017-1 C 2019-01-01 2021-11-28
6 64 SILVER-2017-1 D 2019-01-01 2021-11-28
7 78 SILVER-2017-1 D 2019-01-01 2021-11-28
8 79 SILVER-2017-1 E 2019-01-01 2021-11-28
9 65 SILVER-2017-1 E 2019-01-01 2021-11-28
10 66 SILVER-2017-1 F 2019-01-01 2021-11-28
11 80 SILVER-2017-1 F 2019-01-01 2021-11-28
12 81 SILVER-2017-1 G 2019-01-01 2021-11-28
13 67 SILVER-2017-1 G 2019-01-01 2021-11-28
14 82 SILVER-2017-1 H 2019-01-01 2021-11-28
15 68 SILVER-2017-1 H 2019-01-01 2021-11-28
16 83 SILVER-2017-1 J 2019-01-01 2021-11-28
17 69 SILVER-2017-1 J 2019-01-01 2021-11-28
18 70 SILVER-2017-1 K 2019-01-01 2021-11-28
19 84 SILVER-2017-1 K 2019-01-01 2021-11-28
20 71 SILVER-2017-1 L 2019-01-01 2021-11-28
21 85 SILVER-2017-1 L 2019-01-01 2021-11-28
22 72 SILVER-2017-1 M 2019-01-01 2021-11-28
23 86 SILVER-2017-1 M 2019-01-01 2021-11-28
24 87 SILVER-2017-1 N 2019-01-01 2021-11-28
25 73 SILVER-2017-1 N 2019-01-01 2021-11-28
26 88 SILVER-2017-1 P 2019-01-01 2021-11-28
27 74 SILVER-2017-1 P 2019-01-01 2021-11-28

No gaps in daily variables

No duplicates in daily variables

Missing variable values

var_id product region period period_id
0 31 CO2_National Z 2021-04-19 22:30 40317
1 31 CO2_National Z 2021-04-19 23:00 40318
2 31 CO2_National Z 2021-04-19 17:00 40306