JasonHowell
commented
2 years ago Looking at Sqarql queries.
Closed TahaRana97 closed 2 years ago
JasonHowell
commented
2 years ago Looking at Sqarql queries.
charlesons
commented
2 years ago For the figure Carbon dioxide (CO2) emissions (territorial basis) per capita by local authority, UK, 2019, (tonnes of carbon dioxide) we will need to bring the data into PmD first and then connect to it with a SPARQL data connector. This is because Chart Builder does not presently accept map data in CSV form.
charlesons
commented
2 years ago The CSV data (from emissions-06.csv in the CCv1 codebase) is:
la_uri,la_notation,emissions_per_capita
http://statistics.data.gov.uk/id/statistical-geography/E06000001,Hartlepool,6.2
http://statistics.data.gov.uk/id/statistical-geography/E06000002,Middlesbrough,4.2
http://statistics.data.gov.uk/id/statistical-geography/E06000003,Redcar and Cleveland,18.2
http://statistics.data.gov.uk/id/statistical-geography/E06000004,Stockton-on-Tees,13.8
http://statistics.data.gov.uk/id/statistical-geography/E06000005,Darlington,4.9
http://statistics.data.gov.uk/id/statistical-geography/E06000006,Halton,5.6
http://statistics.data.gov.uk/id/statistical-geography/E06000007,Warrington,6.4
http://statistics.data.gov.uk/id/statistical-geography/E06000008,Blackburn with Darwen,4.4
http://statistics.data.gov.uk/id/statistical-geography/E06000009,Blackpool,3.4
http://statistics.data.gov.uk/id/statistical-geography/E06000010,"Kingston upon Hull, City of",4.2
http://statistics.data.gov.uk/id/statistical-geography/E06000011,East Riding of Yorkshire,8
http://statistics.data.gov.uk/id/statistical-geography/E06000012,North East Lincolnshire,7.4
http://statistics.data.gov.uk/id/statistical-geography/E06000013,North Lincolnshire,40
http://statistics.data.gov.uk/id/statistical-geography/E06000014,York,3.8
http://statistics.data.gov.uk/id/statistical-geography/E06000015,Derby,4.1
http://statistics.data.gov.uk/id/statistical-geography/E06000016,Leicester,3.4
http://statistics.data.gov.uk/id/statistical-geography/E06000017,Rutland,26
http://statistics.data.gov.uk/id/statistical-geography/E06000018,Nottingham,3.3
http://statistics.data.gov.uk/id/statistical-geography/E06000019,"Herefordshire, County of",5.2
http://statistics.data.gov.uk/id/statistical-geography/E06000020,Telford and Wrekin,5.1
http://statistics.data.gov.uk/id/statistical-geography/E06000021,Stoke-on-Trent,4.9
http://statistics.data.gov.uk/id/statistical-geography/E06000022,Bath and North East Somerset,3.5
http://statistics.data.gov.uk/id/statistical-geography/E06000023,"Bristol, City of",3.2
http://statistics.data.gov.uk/id/statistical-geography/E06000024,North Somerset,5.4
http://statistics.data.gov.uk/id/statistical-geography/E06000025,South Gloucestershire,5.8
http://statistics.data.gov.uk/id/statistical-geography/E06000026,Plymouth,3.3
http://statistics.data.gov.uk/id/statistical-geography/E06000027,Torbay,3.1
http://statistics.data.gov.uk/id/statistical-geography/E06000030,Swindon,4.6
http://statistics.data.gov.uk/id/statistical-geography/E06000031,Peterborough,5.5
http://statistics.data.gov.uk/id/statistical-geography/E06000032,Luton,3
http://statistics.data.gov.uk/id/statistical-geography/E06000033,Southend-on-Sea,2.9
http://statistics.data.gov.uk/id/statistical-geography/E06000034,Thurrock,5.3
http://statistics.data.gov.uk/id/statistical-geography/E06000035,Medway,2.9
http://statistics.data.gov.uk/id/statistical-geography/E06000036,Bracknell Forest,3.5
http://statistics.data.gov.uk/id/statistical-geography/E06000037,West Berkshire,7.3
http://statistics.data.gov.uk/id/statistical-geography/E06000038,Reading,3.2
http://statistics.data.gov.uk/id/statistical-geography/E06000039,Slough,4.6
http://statistics.data.gov.uk/id/statistical-geography/E06000040,Windsor and Maidenhead,5.2
http://statistics.data.gov.uk/id/statistical-geography/E06000041,Wokingham,4.2
http://statistics.data.gov.uk/id/statistical-geography/E06000042,Milton Keynes,4.8
http://statistics.data.gov.uk/id/statistical-geography/E06000043,Brighton and Hove,2.8
http://statistics.data.gov.uk/id/statistical-geography/E06000044,Portsmouth,3.5
http://statistics.data.gov.uk/id/statistical-geography/E06000045,Southampton,2.9
http://statistics.data.gov.uk/id/statistical-geography/E06000046,Isle of Wight,3.3
http://statistics.data.gov.uk/id/statistical-geography/E06000047,County Durham,4.5
http://statistics.data.gov.uk/id/statistical-geography/E06000049,Cheshire East,6.5
http://statistics.data.gov.uk/id/statistical-geography/E06000050,Cheshire West and Chester,11.2
http://statistics.data.gov.uk/id/statistical-geography/E06000051,Shropshire,5.5
http://statistics.data.gov.uk/id/statistical-geography/E06000052,Cornwall,4.6
http://statistics.data.gov.uk/id/statistical-geography/E06000053,Isles of Scilly,3.8
http://statistics.data.gov.uk/id/statistical-geography/E06000054,Wiltshire,5.2
http://statistics.data.gov.uk/id/statistical-geography/E06000055,Bedford,4.2
http://statistics.data.gov.uk/id/statistical-geography/E06000056,Central Bedfordshire,5.4
http://statistics.data.gov.uk/id/statistical-geography/E06000057,Northumberland,2.1
http://statistics.data.gov.uk/id/statistical-geography/E06000058,"Bournemouth, Christchurch and Poole",3.3
http://statistics.data.gov.uk/id/statistical-geography/E06000059,Dorset,4.4
http://statistics.data.gov.uk/id/statistical-geography/E06000060,Buckinghamshire,4.8
http://statistics.data.gov.uk/id/statistical-geography/E07000008,Cambridge,3.9
http://statistics.data.gov.uk/id/statistical-geography/E07000009,East Cambridgeshire,14.9
http://statistics.data.gov.uk/id/statistical-geography/E07000010,Fenland,14.2
http://statistics.data.gov.uk/id/statistical-geography/E07000011,Huntingdonshire,9
http://statistics.data.gov.uk/id/statistical-geography/E07000012,South Cambridgeshire,7.6
http://statistics.data.gov.uk/id/statistical-geography/E07000026,Allerdale,6.5
http://statistics.data.gov.uk/id/statistical-geography/E07000027,Barrow-in-Furness,5.7
http://statistics.data.gov.uk/id/statistical-geography/E07000028,Carlisle,5.1
http://statistics.data.gov.uk/id/statistical-geography/E07000029,Copeland,3.2
http://statistics.data.gov.uk/id/statistical-geography/E07000030,Eden,18.4
http://statistics.data.gov.uk/id/statistical-geography/E07000031,South Lakeland,8.2
http://statistics.data.gov.uk/id/statistical-geography/E07000032,Amber Valley,5.2
http://statistics.data.gov.uk/id/statistical-geography/E07000033,Bolsover,12.2
http://statistics.data.gov.uk/id/statistical-geography/E07000034,Chesterfield,4.2
http://statistics.data.gov.uk/id/statistical-geography/E07000035,Derbyshire Dales,6.9
http://statistics.data.gov.uk/id/statistical-geography/E07000036,Erewash,4.5
http://statistics.data.gov.uk/id/statistical-geography/E07000037,High Peak,31.9
http://statistics.data.gov.uk/id/statistical-geography/E07000038,North East Derbyshire,4.9
http://statistics.data.gov.uk/id/statistical-geography/E07000039,South Derbyshire,6.2
http://statistics.data.gov.uk/id/statistical-geography/E07000040,East Devon,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000041,Exeter,3.1
http://statistics.data.gov.uk/id/statistical-geography/E07000042,Mid Devon,6.2
http://statistics.data.gov.uk/id/statistical-geography/E07000043,North Devon,4.5
http://statistics.data.gov.uk/id/statistical-geography/E07000044,South Hams,5.8
http://statistics.data.gov.uk/id/statistical-geography/E07000045,Teignbridge,5.3
http://statistics.data.gov.uk/id/statistical-geography/E07000046,Torridge,3.8
http://statistics.data.gov.uk/id/statistical-geography/E07000047,West Devon,6
http://statistics.data.gov.uk/id/statistical-geography/E07000061,Eastbourne,2.7
http://statistics.data.gov.uk/id/statistical-geography/E07000062,Hastings,2.6
http://statistics.data.gov.uk/id/statistical-geography/E07000063,Lewes,3.6
http://statistics.data.gov.uk/id/statistical-geography/E07000064,Rother,4
http://statistics.data.gov.uk/id/statistical-geography/E07000065,Wealden,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000066,Basildon,3.9
http://statistics.data.gov.uk/id/statistical-geography/E07000067,Braintree,4.5
http://statistics.data.gov.uk/id/statistical-geography/E07000068,Brentwood,5.9
http://statistics.data.gov.uk/id/statistical-geography/E07000069,Castle Point,2.9
http://statistics.data.gov.uk/id/statistical-geography/E07000070,Chelmsford,4.6
http://statistics.data.gov.uk/id/statistical-geography/E07000071,Colchester,3.9
http://statistics.data.gov.uk/id/statistical-geography/E07000072,Epping Forest,7.1
http://statistics.data.gov.uk/id/statistical-geography/E07000073,Harlow,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000074,Maldon,4
http://statistics.data.gov.uk/id/statistical-geography/E07000075,Rochford,3.2
http://statistics.data.gov.uk/id/statistical-geography/E07000076,Tendring,3.8
http://statistics.data.gov.uk/id/statistical-geography/E07000077,Uttlesford,8
http://statistics.data.gov.uk/id/statistical-geography/E07000078,Cheltenham,3.3
http://statistics.data.gov.uk/id/statistical-geography/E07000079,Cotswold,6.2
http://statistics.data.gov.uk/id/statistical-geography/E07000080,Forest of Dean,5.1
http://statistics.data.gov.uk/id/statistical-geography/E07000081,Gloucester,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000082,Stroud,6
http://statistics.data.gov.uk/id/statistical-geography/E07000083,Tewkesbury,7.3
http://statistics.data.gov.uk/id/statistical-geography/E07000084,Basingstoke and Deane,5.3
http://statistics.data.gov.uk/id/statistical-geography/E07000085,East Hampshire,4.8
http://statistics.data.gov.uk/id/statistical-geography/E07000086,Eastleigh,4.2
http://statistics.data.gov.uk/id/statistical-geography/E07000087,Fareham,3.9
http://statistics.data.gov.uk/id/statistical-geography/E07000088,Gosport,2.4
http://statistics.data.gov.uk/id/statistical-geography/E07000089,Hart,4.9
http://statistics.data.gov.uk/id/statistical-geography/E07000090,Havant,3.2
http://statistics.data.gov.uk/id/statistical-geography/E07000091,New Forest,5.2
http://statistics.data.gov.uk/id/statistical-geography/E07000092,Rushmoor,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000093,Test Valley,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000094,Winchester,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000095,Broxbourne,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000096,Dacorum,4
http://statistics.data.gov.uk/id/statistical-geography/E07000098,Hertsmere,6.1
http://statistics.data.gov.uk/id/statistical-geography/E07000099,North Hertfordshire,4.6
http://statistics.data.gov.uk/id/statistical-geography/E07000102,Three Rivers,5.7
http://statistics.data.gov.uk/id/statistical-geography/E07000103,Watford,3.4
http://statistics.data.gov.uk/id/statistical-geography/E07000105,Ashford,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000106,Canterbury,3.3
http://statistics.data.gov.uk/id/statistical-geography/E07000107,Dartford,5.2
http://statistics.data.gov.uk/id/statistical-geography/E07000108,Dover,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000109,Gravesham,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000110,Maidstone,4.4
http://statistics.data.gov.uk/id/statistical-geography/E07000111,Sevenoaks,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000112,Folkestone and Hythe,3.8
http://statistics.data.gov.uk/id/statistical-geography/E07000113,Swale,7.7
http://statistics.data.gov.uk/id/statistical-geography/E07000114,Thanet,3.6
http://statistics.data.gov.uk/id/statistical-geography/E07000115,Tonbridge and Malling,5.2
http://statistics.data.gov.uk/id/statistical-geography/E07000116,Tunbridge Wells,3.3
http://statistics.data.gov.uk/id/statistical-geography/E07000117,Burnley,4.5
http://statistics.data.gov.uk/id/statistical-geography/E07000118,Chorley,5.5
http://statistics.data.gov.uk/id/statistical-geography/E07000119,Fylde,6
http://statistics.data.gov.uk/id/statistical-geography/E07000120,Hyndburn,4.7
http://statistics.data.gov.uk/id/statistical-geography/E07000121,Lancaster,5.7
http://statistics.data.gov.uk/id/statistical-geography/E07000122,Pendle,4.5
http://statistics.data.gov.uk/id/statistical-geography/E07000123,Preston,4.9
http://statistics.data.gov.uk/id/statistical-geography/E07000124,Ribble Valley,15.2
http://statistics.data.gov.uk/id/statistical-geography/E07000125,Rossendale,4.9
http://statistics.data.gov.uk/id/statistical-geography/E07000126,South Ribble,6
http://statistics.data.gov.uk/id/statistical-geography/E07000127,West Lancashire,8.1
http://statistics.data.gov.uk/id/statistical-geography/E07000128,Wyre,6.1
http://statistics.data.gov.uk/id/statistical-geography/E07000129,Blaby,5.8
http://statistics.data.gov.uk/id/statistical-geography/E07000130,Charnwood,4.4
http://statistics.data.gov.uk/id/statistical-geography/E07000131,Harborough,6.1
http://statistics.data.gov.uk/id/statistical-geography/E07000132,Hinckley and Bosworth,5.4
http://statistics.data.gov.uk/id/statistical-geography/E07000133,Melton,5.6
http://statistics.data.gov.uk/id/statistical-geography/E07000134,North West Leicestershire,10.9
http://statistics.data.gov.uk/id/statistical-geography/E07000135,Oadby and Wigston,3.1
http://statistics.data.gov.uk/id/statistical-geography/E07000136,Boston,4.5
http://statistics.data.gov.uk/id/statistical-geography/E07000137,East Lindsey,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000138,Lincoln,3.2
http://statistics.data.gov.uk/id/statistical-geography/E07000139,North Kesteven,6.8
http://statistics.data.gov.uk/id/statistical-geography/E07000140,South Holland,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000141,South Kesteven,6.2
http://statistics.data.gov.uk/id/statistical-geography/E07000142,West Lindsey,6.4
http://statistics.data.gov.uk/id/statistical-geography/E07000143,Breckland,5.9
http://statistics.data.gov.uk/id/statistical-geography/E07000144,Broadland,5.5
http://statistics.data.gov.uk/id/statistical-geography/E07000145,Great Yarmouth,3.6
http://statistics.data.gov.uk/id/statistical-geography/E07000146,King's Lynn and West Norfolk,12.6
http://statistics.data.gov.uk/id/statistical-geography/E07000147,North Norfolk,5.8
http://statistics.data.gov.uk/id/statistical-geography/E07000148,Norwich,3.2
http://statistics.data.gov.uk/id/statistical-geography/E07000149,South Norfolk,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000150,Corby,5.5
http://statistics.data.gov.uk/id/statistical-geography/E07000151,Daventry,9.5
http://statistics.data.gov.uk/id/statistical-geography/E07000152,East Northamptonshire,4.8
http://statistics.data.gov.uk/id/statistical-geography/E07000153,Kettering,5.8
http://statistics.data.gov.uk/id/statistical-geography/E07000154,Northampton,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000155,South Northamptonshire,8.9
http://statistics.data.gov.uk/id/statistical-geography/E07000156,Wellingborough,4.6
http://statistics.data.gov.uk/id/statistical-geography/E07000163,Craven,6.3
http://statistics.data.gov.uk/id/statistical-geography/E07000164,Hambleton,8.4
http://statistics.data.gov.uk/id/statistical-geography/E07000165,Harrogate,6.6
http://statistics.data.gov.uk/id/statistical-geography/E07000166,Richmondshire,7.5
http://statistics.data.gov.uk/id/statistical-geography/E07000167,Ryedale,7.3
http://statistics.data.gov.uk/id/statistical-geography/E07000168,Scarborough,4.4
http://statistics.data.gov.uk/id/statistical-geography/E07000169,Selby,8.6
http://statistics.data.gov.uk/id/statistical-geography/E07000170,Ashfield,4.6
http://statistics.data.gov.uk/id/statistical-geography/E07000171,Bassetlaw,6.9
http://statistics.data.gov.uk/id/statistical-geography/E07000172,Broxtowe,6.2
http://statistics.data.gov.uk/id/statistical-geography/E07000173,Gedling,3.6
http://statistics.data.gov.uk/id/statistical-geography/E07000174,Mansfield,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000175,Newark and Sherwood,7.3
http://statistics.data.gov.uk/id/statistical-geography/E07000176,Rushcliffe,6.1
http://statistics.data.gov.uk/id/statistical-geography/E07000177,Cherwell,7.9
http://statistics.data.gov.uk/id/statistical-geography/E07000178,Oxford,4
http://statistics.data.gov.uk/id/statistical-geography/E07000179,South Oxfordshire,5.6
http://statistics.data.gov.uk/id/statistical-geography/E07000180,Vale of White Horse,5.9
http://statistics.data.gov.uk/id/statistical-geography/E07000181,West Oxfordshire,4.9
http://statistics.data.gov.uk/id/statistical-geography/E07000187,Mendip,7
http://statistics.data.gov.uk/id/statistical-geography/E07000188,Sedgemoor,7.4
http://statistics.data.gov.uk/id/statistical-geography/E07000189,South Somerset,5.4
http://statistics.data.gov.uk/id/statistical-geography/E07000192,Cannock Chase,3.6
http://statistics.data.gov.uk/id/statistical-geography/E07000193,East Staffordshire,5.8
http://statistics.data.gov.uk/id/statistical-geography/E07000194,Lichfield,6.5
http://statistics.data.gov.uk/id/statistical-geography/E07000195,Newcastle-under-Lyme,5.5
http://statistics.data.gov.uk/id/statistical-geography/E07000196,South Staffordshire,7.8
http://statistics.data.gov.uk/id/statistical-geography/E07000197,Stafford,6.6
http://statistics.data.gov.uk/id/statistical-geography/E07000198,Staffordshire Moorlands,11.7
http://statistics.data.gov.uk/id/statistical-geography/E07000199,Tamworth,3.3
http://statistics.data.gov.uk/id/statistical-geography/E07000200,Babergh,5.3
http://statistics.data.gov.uk/id/statistical-geography/E07000202,Ipswich,2.8
http://statistics.data.gov.uk/id/statistical-geography/E07000203,Mid Suffolk,6.1
http://statistics.data.gov.uk/id/statistical-geography/E07000207,Elmbridge,4.7
http://statistics.data.gov.uk/id/statistical-geography/E07000208,Epsom and Ewell,2.9
http://statistics.data.gov.uk/id/statistical-geography/E07000209,Guildford,4.8
http://statistics.data.gov.uk/id/statistical-geography/E07000210,Mole Valley,5.5
http://statistics.data.gov.uk/id/statistical-geography/E07000211,Reigate and Banstead,4.7
http://statistics.data.gov.uk/id/statistical-geography/E07000212,Runnymede,6.5
http://statistics.data.gov.uk/id/statistical-geography/E07000213,Spelthorne,3.9
http://statistics.data.gov.uk/id/statistical-geography/E07000214,Surrey Heath,5.9
http://statistics.data.gov.uk/id/statistical-geography/E07000215,Tandridge,6.4
http://statistics.data.gov.uk/id/statistical-geography/E07000216,Waverley,4
http://statistics.data.gov.uk/id/statistical-geography/E07000217,Woking,3.9
http://statistics.data.gov.uk/id/statistical-geography/E07000218,North Warwickshire,13.8
http://statistics.data.gov.uk/id/statistical-geography/E07000219,Nuneaton and Bedworth,3.7
http://statistics.data.gov.uk/id/statistical-geography/E07000220,Rugby,16.4
http://statistics.data.gov.uk/id/statistical-geography/E07000221,Stratford-on-Avon,8.5
http://statistics.data.gov.uk/id/statistical-geography/E07000222,Warwick,6
http://statistics.data.gov.uk/id/statistical-geography/E07000223,Adur,3.3
http://statistics.data.gov.uk/id/statistical-geography/E07000224,Arun,3.2
http://statistics.data.gov.uk/id/statistical-geography/E07000225,Chichester,5.2
http://statistics.data.gov.uk/id/statistical-geography/E07000226,Crawley,5.1
http://statistics.data.gov.uk/id/statistical-geography/E07000227,Horsham,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000228,Mid Sussex,4
http://statistics.data.gov.uk/id/statistical-geography/E07000229,Worthing,2.8
http://statistics.data.gov.uk/id/statistical-geography/E07000234,Bromsgrove,6.7
http://statistics.data.gov.uk/id/statistical-geography/E07000235,Malvern Hills,6.1
http://statistics.data.gov.uk/id/statistical-geography/E07000236,Redditch,3.8
http://statistics.data.gov.uk/id/statistical-geography/E07000237,Worcester,3.3
http://statistics.data.gov.uk/id/statistical-geography/E07000238,Wychavon,7.4
http://statistics.data.gov.uk/id/statistical-geography/E07000239,Wyre Forest,3.8
http://statistics.data.gov.uk/id/statistical-geography/E07000240,St Albans,5.8
http://statistics.data.gov.uk/id/statistical-geography/E07000241,Welwyn Hatfield,4.8
http://statistics.data.gov.uk/id/statistical-geography/E07000242,East Hertfordshire,4.2
http://statistics.data.gov.uk/id/statistical-geography/E07000243,Stevenage,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000244,East Suffolk,4.3
http://statistics.data.gov.uk/id/statistical-geography/E07000245,West Suffolk,8.9
http://statistics.data.gov.uk/id/statistical-geography/E07000246,Somerset West and Taunton,4.7
http://statistics.data.gov.uk/id/statistical-geography/E08000001,Bolton,4.2
http://statistics.data.gov.uk/id/statistical-geography/E08000002,Bury,4.5
http://statistics.data.gov.uk/id/statistical-geography/E08000003,Manchester,3.7
http://statistics.data.gov.uk/id/statistical-geography/E08000004,Oldham,3.3
http://statistics.data.gov.uk/id/statistical-geography/E08000005,Rochdale,4.3
http://statistics.data.gov.uk/id/statistical-geography/E08000006,Salford,4.8
http://statistics.data.gov.uk/id/statistical-geography/E08000007,Stockport,4.1
http://statistics.data.gov.uk/id/statistical-geography/E08000008,Tameside,3.6
http://statistics.data.gov.uk/id/statistical-geography/E08000009,Trafford,6.2
http://statistics.data.gov.uk/id/statistical-geography/E08000010,Wigan,3.8
http://statistics.data.gov.uk/id/statistical-geography/E08000011,Knowsley,5.4
http://statistics.data.gov.uk/id/statistical-geography/E08000012,Liverpool,3.6
http://statistics.data.gov.uk/id/statistical-geography/E08000013,St. Helens,6.3
http://statistics.data.gov.uk/id/statistical-geography/E08000014,Sefton,4.3
http://statistics.data.gov.uk/id/statistical-geography/E08000015,Wirral,3.7
http://statistics.data.gov.uk/id/statistical-geography/E08000016,Barnsley,5.4
http://statistics.data.gov.uk/id/statistical-geography/E08000017,Doncaster,6.4
http://statistics.data.gov.uk/id/statistical-geography/E08000018,Rotherham,6
http://statistics.data.gov.uk/id/statistical-geography/E08000019,Sheffield,3.8
http://statistics.data.gov.uk/id/statistical-geography/E08000021,Newcastle upon Tyne,4.1
http://statistics.data.gov.uk/id/statistical-geography/E08000022,North Tyneside,4
http://statistics.data.gov.uk/id/statistical-geography/E08000023,South Tyneside,3.3
http://statistics.data.gov.uk/id/statistical-geography/E08000024,Sunderland,4.2
http://statistics.data.gov.uk/id/statistical-geography/E08000025,Birmingham,3.6
http://statistics.data.gov.uk/id/statistical-geography/E08000026,Coventry,3.4
http://statistics.data.gov.uk/id/statistical-geography/E08000027,Dudley,3.5
http://statistics.data.gov.uk/id/statistical-geography/E08000028,Sandwell,4.2
http://statistics.data.gov.uk/id/statistical-geography/E08000029,Solihull,5.9
http://statistics.data.gov.uk/id/statistical-geography/E08000030,Walsall,3.7
http://statistics.data.gov.uk/id/statistical-geography/E08000031,Wolverhampton,3.5
http://statistics.data.gov.uk/id/statistical-geography/E08000032,Bradford,3.8
http://statistics.data.gov.uk/id/statistical-geography/E08000033,Calderdale,4.8
http://statistics.data.gov.uk/id/statistical-geography/E08000034,Kirklees,4.3
http://statistics.data.gov.uk/id/statistical-geography/E08000035,Leeds,4.9
http://statistics.data.gov.uk/id/statistical-geography/E08000036,Wakefield,5.8
http://statistics.data.gov.uk/id/statistical-geography/E08000037,Gateshead,5.1
http://statistics.data.gov.uk/id/statistical-geography/E09000001,City of London,65.9
http://statistics.data.gov.uk/id/statistical-geography/E09000002,Barking and Dagenham,2.6
http://statistics.data.gov.uk/id/statistical-geography/E09000003,Barnet,3.1
http://statistics.data.gov.uk/id/statistical-geography/E09000004,Bexley,3.3
http://statistics.data.gov.uk/id/statistical-geography/E09000005,Brent,2.8
http://statistics.data.gov.uk/id/statistical-geography/E09000006,Bromley,3
http://statistics.data.gov.uk/id/statistical-geography/E09000007,Camden,3.6
http://statistics.data.gov.uk/id/statistical-geography/E09000008,Croydon,2.8
http://statistics.data.gov.uk/id/statistical-geography/E09000009,Ealing,3.2
http://statistics.data.gov.uk/id/statistical-geography/E09000010,Enfield,3.3
http://statistics.data.gov.uk/id/statistical-geography/E09000011,Greenwich,2.7
http://statistics.data.gov.uk/id/statistical-geography/E09000012,Hackney,2.2
http://statistics.data.gov.uk/id/statistical-geography/E09000013,Hammersmith and Fulham,3.5
http://statistics.data.gov.uk/id/statistical-geography/E09000014,Haringey,2.4
http://statistics.data.gov.uk/id/statistical-geography/E09000015,Harrow,2.5
http://statistics.data.gov.uk/id/statistical-geography/E09000016,Havering,3.6
http://statistics.data.gov.uk/id/statistical-geography/E09000017,Hillingdon,4.6
http://statistics.data.gov.uk/id/statistical-geography/E09000018,Hounslow,3.6
http://statistics.data.gov.uk/id/statistical-geography/E09000019,Islington,2.7
http://statistics.data.gov.uk/id/statistical-geography/E09000020,Kensington and Chelsea,4.8
http://statistics.data.gov.uk/id/statistical-geography/E09000021,Kingston upon Thames,3.3
http://statistics.data.gov.uk/id/statistical-geography/E09000022,Lambeth,2.7
http://statistics.data.gov.uk/id/statistical-geography/E09000023,Lewisham,2.4
http://statistics.data.gov.uk/id/statistical-geography/E09000024,Merton,2.9
http://statistics.data.gov.uk/id/statistical-geography/E09000025,Newham,2.9
http://statistics.data.gov.uk/id/statistical-geography/E09000026,Redbridge,2.6
http://statistics.data.gov.uk/id/statistical-geography/E09000027,Richmond upon Thames,3.1
http://statistics.data.gov.uk/id/statistical-geography/E09000028,Southwark,2.9
http://statistics.data.gov.uk/id/statistical-geography/E09000029,Sutton,2.7
http://statistics.data.gov.uk/id/statistical-geography/E09000030,Tower Hamlets,3.6
http://statistics.data.gov.uk/id/statistical-geography/E09000031,Waltham Forest,2.3
http://statistics.data.gov.uk/id/statistical-geography/E09000032,Wandsworth,2.6
http://statistics.data.gov.uk/id/statistical-geography/E09000033,Westminster,6.5
http://statistics.data.gov.uk/id/statistical-geography/N09000001,Antrim and Newtownabbey,6.6
http://statistics.data.gov.uk/id/statistical-geography/N09000002,"Armagh City, Banbridge and Craigavon",7.3
http://statistics.data.gov.uk/id/statistical-geography/N09000003,Belfast,4.2
http://statistics.data.gov.uk/id/statistical-geography/N09000004,Causeway Coast and Glens,8.4
http://statistics.data.gov.uk/id/statistical-geography/N09000005,Derry City and Strabane,8.2
http://statistics.data.gov.uk/id/statistical-geography/N09000006,Fermanagh and Omagh,13.7
http://statistics.data.gov.uk/id/statistical-geography/N09000007,Lisburn and Castlereagh,5.8
http://statistics.data.gov.uk/id/statistical-geography/N09000008,Mid and East Antrim,7.8
http://statistics.data.gov.uk/id/statistical-geography/N09000009,Mid Ulster,13.1
http://statistics.data.gov.uk/id/statistical-geography/N09000010,"Newry, Mourne and Down",7.1
http://statistics.data.gov.uk/id/statistical-geography/N09000011,Ards and North Down,4.1
http://statistics.data.gov.uk/id/statistical-geography/S12000005,Clackmannanshire,10.1
http://statistics.data.gov.uk/id/statistical-geography/S12000006,Dumfries and Galloway,6.3
http://statistics.data.gov.uk/id/statistical-geography/S12000008,East Ayrshire,4.1
http://statistics.data.gov.uk/id/statistical-geography/S12000010,East Lothian,10.5
http://statistics.data.gov.uk/id/statistical-geography/S12000011,East Renfrewshire,4.1
http://statistics.data.gov.uk/id/statistical-geography/S12000013,Na h-Eileanan Siar,21.3
http://statistics.data.gov.uk/id/statistical-geography/S12000014,Falkirk,14
http://statistics.data.gov.uk/id/statistical-geography/S12000017,Highland,5.8
http://statistics.data.gov.uk/id/statistical-geography/S12000018,Inverclyde,3.8
http://statistics.data.gov.uk/id/statistical-geography/S12000019,Midlothian,4.5
http://statistics.data.gov.uk/id/statistical-geography/S12000020,Moray,6.5
http://statistics.data.gov.uk/id/statistical-geography/S12000021,North Ayrshire,6.2
http://statistics.data.gov.uk/id/statistical-geography/S12000023,Orkney Islands,12.4
http://statistics.data.gov.uk/id/statistical-geography/S12000026,Scottish Borders,6.1
http://statistics.data.gov.uk/id/statistical-geography/S12000027,Shetland Islands,21.6
http://statistics.data.gov.uk/id/statistical-geography/S12000028,South Ayrshire,4.2
http://statistics.data.gov.uk/id/statistical-geography/S12000029,South Lanarkshire,5.1
http://statistics.data.gov.uk/id/statistical-geography/S12000030,Stirling,6.6
http://statistics.data.gov.uk/id/statistical-geography/S12000033,Aberdeen City,5.1
http://statistics.data.gov.uk/id/statistical-geography/S12000034,Aberdeenshire,6.5
http://statistics.data.gov.uk/id/statistical-geography/S12000035,Argyll and Bute,3.1
http://statistics.data.gov.uk/id/statistical-geography/S12000036,City of Edinburgh,4
http://statistics.data.gov.uk/id/statistical-geography/S12000038,Renfrewshire,4.8
http://statistics.data.gov.uk/id/statistical-geography/S12000039,West Dunbartonshire,5
http://statistics.data.gov.uk/id/statistical-geography/S12000040,West Lothian,5.8
http://statistics.data.gov.uk/id/statistical-geography/S12000041,Angus,5.8
http://statistics.data.gov.uk/id/statistical-geography/S12000042,Dundee City,3.9
http://statistics.data.gov.uk/id/statistical-geography/S12000045,East Dunbartonshire,3.7
http://statistics.data.gov.uk/id/statistical-geography/S12000047,Fife,6.8
http://statistics.data.gov.uk/id/statistical-geography/S12000048,Perth and Kinross,6.3
http://statistics.data.gov.uk/id/statistical-geography/S12000049,Glasgow City,3.8
http://statistics.data.gov.uk/id/statistical-geography/S12000050,North Lanarkshire,5.3
http://statistics.data.gov.uk/id/statistical-geography/W06000001,Isle of Anglesey,5.7
http://statistics.data.gov.uk/id/statistical-geography/W06000002,Gwynedd,5.3
http://statistics.data.gov.uk/id/statistical-geography/W06000003,Conwy,4.7
http://statistics.data.gov.uk/id/statistical-geography/W06000004,Denbighshire,4.9
http://statistics.data.gov.uk/id/statistical-geography/W06000005,Flintshire,10.6
http://statistics.data.gov.uk/id/statistical-geography/W06000006,Wrexham,6.6
http://statistics.data.gov.uk/id/statistical-geography/W06000008,Ceredigion,6.4
http://statistics.data.gov.uk/id/statistical-geography/W06000009,Pembrokeshire,6
http://statistics.data.gov.uk/id/statistical-geography/W06000010,Carmarthenshire,5.7
http://statistics.data.gov.uk/id/statistical-geography/W06000011,Swansea,4.2
http://statistics.data.gov.uk/id/statistical-geography/W06000012,Neath Port Talbot,50
http://statistics.data.gov.uk/id/statistical-geography/W06000013,Bridgend,5.4
http://statistics.data.gov.uk/id/statistical-geography/W06000014,Vale of Glamorgan,8.4
http://statistics.data.gov.uk/id/statistical-geography/W06000015,Cardiff,4.4
http://statistics.data.gov.uk/id/statistical-geography/W06000016,Rhondda Cynon Taf,4.3
http://statistics.data.gov.uk/id/statistical-geography/W06000018,Caerphilly,3.9
http://statistics.data.gov.uk/id/statistical-geography/W06000019,Blaenau Gwent,4.2
http://statistics.data.gov.uk/id/statistical-geography/W06000020,Torfaen,4.4
http://statistics.data.gov.uk/id/statistical-geography/W06000021,Monmouthshire,6.6
http://statistics.data.gov.uk/id/statistical-geography/W06000022,Newport,6.7
http://statistics.data.gov.uk/id/statistical-geography/W06000023,Powys,6
http://statistics.data.gov.uk/id/statistical-geography/W06000024,Merthyr Tydfil,4.2
Note - this ticket is complete except for the map mentioned in the above two comments. The map is awaiting data from PMD
charlesons
commented
2 years ago @rossbowen is looking into calculating the per capita emissions
charlesons
commented
2 years ago Two solutions to chart 6 issue:
Fix up the CSV data connector - issue #132 created
Create the SPARQL query for per capita emissions as commented above
peterfrenchons
commented
2 years ago Moved 2 QA items from #438 into this active card.
peterfrenchons
commented
2 years ago Marking as complete. All charts done and in QA with CC team
QA items to look at again (from #438):