Skip to content

Instantly share code, notes, and snippets.

@broadpeter
broadpeter / popdensity
Created September 26, 2018 11:12
pop density nuts 3 2016
code,name,density
BE100,Arr. de Bruxelles-Capitale / Arr. van Brussel-Hoofdstad,"7,408.6"
BE211,Arr. Antwerpen,"1,082.2"
BE212,Arr. Mechelen,679.7
BE213,Arr. Turnhout,338.9
BE221,Arr. Hasselt,476.4
BE222,Arr. Maaseik,276.8
BE223,Arr. Tongeren,322.3
BE231,Arr. Aalst,605.0
BE232,Arr. Dendermonde,587.9
@broadpeter
broadpeter / populationdensity.tsv
Created September 24, 2018 18:06
pop density
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 28 columns, instead of 20 in line 6.
unit,geo\time 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990
HAB_KM2,AL 105.2 b 105.5 105.5 : : : : : : : : : : : : : : : : : : : : : : : :
HAB_KM2,AL0 105.2 b 105.5 105.5 : : : : : : : : : : : : : : : : : : : : : : : :
HAB_KM2,AT 105.9 b 104.9 103.7 102.9 102.3 101.8 101.5 101.2 100.9 100.6 100.3 99.8 : 98.5 98.0 : 97.2 : 96.7 96.6 96.5 96.3 96.2 95.8 95.0 94.0 :
HAB_KM2,AT1 164.8 b 163.3 161.0 159.4 158.0 156.9 156.1 155.4 154.7 153.8 153.1 152.0 : 149.2 148.0 : 146.1 : 145.2 145.1 144.9 144.8 144.8 144.3 143.1 141.5 :
HAB_KM2,AT11 77.1 b 79.0 78.5 78.2 78.0 77.7 77.4 77.2 76.8 76.2 76.0 75.7 : 75.2 75.1 : 74.5 : 74.2 74.3 74.4 74.4 74.2 73.9 73.6 73.1 :
HAB_KM2,AT111 54.4 b 54.3 54.1 54.1 54.1 54.1 54.1 54.0 54.0 53.8 53.8 53.8 : 54.1 54.2 : 54.6 :
@broadpeter
broadpeter / euro2.json
Created September 24, 2018 16:19
euro test 2 20/1
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@broadpeter
broadpeter / euro.json
Created September 24, 2018 16:13
eu nuts 3
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@broadpeter
broadpeter / testjson2.json
Created September 22, 2018 13:59
us test 1
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@broadpeter
broadpeter / testline.csv
Created September 22, 2018 11:16
testline
year month average
1958 3 315.71
1958 4 317.45
1958 5 317.5
1958 6 -99.99
1958 7 315.86
1958 8 314.93
1958 9 313.2
1958 10 -99.99
1958 11 313.33
@broadpeter
broadpeter / switching.csv
Last active August 22, 2018 09:46
switching
month region ladcd ladnm pop total largetolarge largetoinde indetolarge indetoinde
April 2018 East Midlands E06000015 Derby 257034 2150 520 768 251 611
April 2018 East Midlands E06000016 Leicester 353540 2354 575 711 288 780
April 2018 East Midlands E06000017 Rutland 39474 309 87 122 34 66
April 2018 East Midlands E06000018 Nottingham 329209 2859 453 852 353 1201
April 2018 East Midlands E07000032 Amber Valley 125898 864 273 318 114 159
April 2018 East Midlands E07000033 Bolsover 79098 563 145 200 60 158
April 2018 East Midlands E07000034 Chesterfield 104579 816 202 320 98 196
April 2018 East Midlands E07000035 Derbyshire Dales 71849 457 143 194 44 76
April 2018 East Midlands E07000036 Erewash 115314 860 298 286 97 179
@broadpeter
broadpeter / tests3.csv
Created August 6, 2018 15:00
Tests with alternative x position
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 25 columns, instead of 24 in line 3.
"","X","number","date","series","ground","result","date1","series0","series1","home","away","homeseries","opponent","wld","year","period","position","yearposition","y1000","wldnumber","y1000123","unique","xstart","positionnew"
"1",1,1,"15/03/1877","1876-1877 Australia v. England","Melbourne Cricket Ground","Australia won by 45 runs","1877-03-15","1876-1877 Australia v. England"," Australia v England","Australia","England","A","Australia","Lose",1877,"(1875,1880]",1,1,18770,3,18773,1,11,12
"2",2,2,"31/03/1877","1876-1877 Australia v. England","Melbourne Cricket Ground","England won by 4 wickets","1877-03-31","1876-1877 Australia v. England"," Australia v England","Australia","England","A","Australia","Win",1877,"(1875,1880]",2,2,18770,1,18771,1,0,1
"3",3,3,"02/01/1879","1878-1879 Australia v. England","Melbourne Cricket Ground","Australia won by 10 wickets","1879-01-02","1878-1879 Australia v. England"," Australia v England","Australia","England","A","Australia","Lose",1879,"(1875,1880]",3,1,18790,3,18793,1,11
@broadpeter
broadpeter / counciltax2.csv
Created August 3, 2018 18:07
Council tax with numeric
council type county region adopted lacode Number
Adur District Council District West Sussex South East No E07000223 3
Allerdale Borough Council District Cumbria North West Considering E07000026 2
Amber Valley Borough Council District Derbyshire East Midlands No E07000032 3
Arun District Council District West Sussex South East No E07000224 3
Ashfield District Council District Nottinghamshire East Midlands Yes E07000170 1
Ashford Borough Council District Kent South East No E07000105 3
Aylesbury Vale District Council District Buckinghamshire South East Yes E07000004 1
Babergh District Council District Suffolk East No E07000200 3
Barking & Dagenham London Borough Greater London Greater London Yes E09000002 1