We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 10 columns, instead of 9 in line 9.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ENGTYPE_2,GID_0,GID_1,GID_2,HASC_2,NAME_0,NAME_1,NAME_2,TYPE_2,sumloss | |
Unitary Authority,GBR,GBR.4_1,GBR.4.1_1,GB.AY,United Kingdom,Wales,Anglesey,Unitary Authority,1354920.733 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.2_1,GB.BG,United Kingdom,Wales,Blaenau Gwent,Unitary Authority,1781997.673 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.3_1,GB.BJ,United Kingdom,Wales,Bridgend,Unitary Authority,7436187.485 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.4_1,GB.CP,United Kingdom,Wales,Caerphilly,Unitary Authority,4037362.859 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.5_1,GB.CA,United Kingdom,Wales,Cardiff,Unitary Authority,142124.9505 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.6_1,GB.CI,United Kingdom,Wales,Carmarthenshire,Unitary Authority,4.38E+07 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.9_1,GB.DI,United Kingdom,Wales,Denbighshire,Unitary Authority,2.70E+07 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.10_1,GB.FL,United Kingdom,Wales,Flintshire,Unitary Authority,2012407.391 | |
Unitary Authority,GBR,GBR.4_1,GBR.4.17_1,GB.PO,United Kingdom,Wales,Powys,Unitary Authority |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
NAME_2 | TYPE_2 | sumgain | |
---|---|---|---|
Anglesey | Unitary Authority | 1588488.76 | |
Blaenau Gwent | Unitary Authority | 1594541.61 | |
Bridgend | Unitary Authority | 2849181.79 | |
Caerphilly | Unitary Authority | 2020087.90 | |
Cardiff | Unitary Authority | 74016.04 | |
Carmarthenshire | Unitary Authority | 26481828.17 | |
Denbighshire | Unitary Authority | 11425173.81 | |
Flintshire | Unitary Authority | 1112308.29 | |
Powys | Unitary Authority | 79875014.34 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
NAME_2 | net | ||
---|---|---|---|
1 | Anglesey | -23.3568022728296 | |
2 | Blaenau Gwent | 18.7456058787865 | |
3 | Bridgend | 458.700569604013 | |
4 | Caerphilly | 201.727496349332 | |
5 | Cardiff | 6.81089095827589 | |
6 | Carmarthenshire | 1727.71018151123 | |
7 | Denbighshire | 1557.24021521561 | |
8 | Flintshire | 90.0099099414542 | |
9 | Powys | 7326.06409260615 |