Skip to content

Instantly share code, notes, and snippets.

View broadpeter's full-sized avatar

broadpeter

1 follower · 1 following
View GitHub Profile
@broadpeter
broadpeter / tests202005.csv
Last active June 6, 2020 11:50
tests202005
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 7 in line 6.
,number,date,series,ground,result,date1,series1,home,away,homeseries,opponent,wld,year,yearposition
1,1,15/03/1877,1876-1877 Australia v. England,Melbourne Cricket Ground,Australia won by 45 runs,1877-03-15, Australia v England,Australia,England,A,Australia,Lost,1877,1
2,2,31/03/1877,1876-1877 Australia v. England,Melbourne Cricket Ground,England won by 4 wickets,1877-03-31, Australia v England,Australia,England,A,Australia,Won,1877,2
3,3,02/01/1879,1878-1879 Australia v. England,Melbourne Cricket Ground,Australia won by 10 wickets,1879-01-02, Australia v England,Australia,England,A,Australia,Lost,1879,1
4,4,06/09/1880,1880 England v. Australia,Kennington Oval,England won by 5 wickets,1880-09-06, England v Australia,England,Australia,H,Australia,Won,1880,1
5,5,31/12/1881,1881-1882 Australia v. England,Melbourne Cricket Ground,Match Drawn,1881-12-31, Australia v England,Australia,England,A,Australia,Drawn,1881,1
6,6,17/02/1882,1881-1882 Australia v. England,Sydney Cricket Ground,Australia won by 5 wickets,1882
@broadpeter
broadpeter / g19majorities
Last active December 16, 2019 16:46
const_id,const_name,Winner17,elected_mp_party_name,elected_mp_name,elected_mp_votes,majority17text,valid,invalid,electorate,turnout_pct,Winner15,ge17_majority,ge17_turnout,nameshort,majority17,n,q2,r2
E14000530,Aldershot,Con,Conservative and Unionist Party,Leo Docherty,27980,16698,47932,,72617,66,Con,11473,64.4,Ald," 16,698 ",Aldershot,-2.5,-11
E14000531,Aldridge-Brownhills,Con,Conservative and Unionist Party,Wendy Morton,27850,19836,39342,,60138,65.4,Con,14307,66.8,Ald," 19,836 ",Aldridge-Brownhills,-2.5,-1
E14000532,Altrincham and Sale West,Con,Conservative and Unionist Party,Graham Brady,26311,6139,54763,,73146,74.9,Con,6426,72.3,Alt," 6,139 ",Altrincham and Sale West,-6.5,3
E14000533,Amber Valley,Con,Conservative and Unionist Party,Nigel Mills,29096,16886,45567,,69976,65.1,Con,8300,67.5,Amb," 16,886 ",Amber Valley,0,2
E14000534,Arundel and South Downs,Con,Conservative and Unionist Party,Andrew Griffith,35566,22521,61408,,,,Con,23883,76,Aru," 22,521 ",Arundel and South Downs,0.5,-15
E14000535,Ashfield,Con,
@broadpeter
broadpeter / electionmap4
Last active December 13, 2019 16:54
,n,q,r,a,u,e,p,name,17,15,q2,r2,majority17,nameshort,1719by,Winner15,,1719allchange,X,Winner17,ccode,first19
E14000530,Aldershot,-3,-11,SE,UKJ,72430,106193,Aldershot,Con,Con,-2.5,-11,"11,473",Ald,,Con,,,Con,Con,E14000530,Con
E14000531,Aldridge-Brownhills,-3,-1,WM,UKG,60215,77532,Aldridge-Brownhills,Con,Con,-2.5,-1,"14,307",Ald,,Con,,,Con,Con,E14000531,Con
E14000532,Altrincham and Sale West,-7,3,NW,UKD,71511,101457,Altrincham and Sale West,Con,Con,-6.5,3,"6,426",Alt,,Con,,,Con,Con,E14000532,Con
E14000533,Amber Valley,0,2,EM,UKF,69510,90132,Amber Valley,Con,Con,0,2,"8,300",Amb,,Con,,,Con,Con,E14000533,Con
E14000534,Arundel and South Downs,0,-15,SE,UKJ,77242,100501,Arundel and South Downs,Con,Con,0.5,-15,"23,883",Aru,,Con,,,Con,Con,,Con
E14000535,Ashfield,1,2,EM,UKF,77091,106495,Ashfield,Lab,Lab,1,2,441,Ash,,Lab,,,Lab,Con,E14000535,Con
E14000536,Ashford,12,-13,SE,UKJ,85177,122178,Ashford,Con,Con,12.5,-13,"17,478",Ash,,Con,,,Con,Con,E14000536,Con
E14000537,Ashton-under-Lyne,-5,6,NW,UKD,68343,92289,Ashton-Under-Ly
@broadpeter
broadpeter / electionmap19v1.csv
Last active December 13, 2019 13:40
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 23 columns, instead of 9 in line 8.
,n,q,r,a,u,e,p,name,17,15,q2,r2,majority17,nameshort,1719by,Winner15,,1719allchange,X,Winner17,ccode,first19
E14000530,Aldershot,-3,-11,SE,UKJ,72430,106193,Aldershot,Con,Con,-2.5,-11,"11,473",Ald,,Con,,,Con,Con,E14000530,Con
E14000531,Aldridge-Brownhills,-3,-1,WM,UKG,60215,77532,Aldridge-Brownhills,Con,Con,-2.5,-1,"14,307",Ald,,Con,,,Con,Con,E14000531,Con
E14000532,Altrincham and Sale West,-7,3,NW,UKD,71511,101457,Altrincham and Sale West,Con,Con,-6.5,3,"6,426",Alt,,Con,,,Con,Con,E14000532,Con
E14000533,Amber Valley,0,2,EM,UKF,69510,90132,Amber Valley,Con,Con,0,2,"8,300",Amb,,Con,,,Con,Con,E14000533,Con
E14000534,Arundel and South Downs,0,-15,SE,UKJ,77242,100501,Arundel and South Downs,Con,Con,0.5,-15,"23,883",Aru,,Con,,,Con,Con,,Con
E14000535,Ashfield,1,2,EM,UKF,77091,106495,Ashfield,Lab,Lab,1,2,441,Ash,,Lab,,,Lab,Con,E14000535,Con
E14000536,Ashford,12,-13,SE,UKJ,85177,122178,Ashford,Con,Con,12.5,-13,"17,478",Ash,,Con,,,Con,Con,E14000536,Con
E14000537,Ashton-under-Lyne,-5,6,NW,UKD,68343,92289,Ashton-Under-Ly
@broadpeter
broadpeter / electionmap4.csv
Created December 8, 2019 17:39
Added NI
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 18 columns, instead of 17 in line 9.
,n,q,r,a,u,e,p,name,Winner17,Winner15,q2,r2,majority17,nameshort,byelection,preelection2019,majority17text
E14000530,Aldershot,-3,-11,SE,UKJ,72430,106193,Aldershot,Con,Con,-2.5,-11,"11,473",Ald,,Con,11473
E14000531,Aldridge-Brownhills,-3,-1,WM,UKG,60215,77532,Aldridge-Brownhills,Con,Con,-2.5,-1,"14,307",Ald,,Con,14307
E14000532,Altrincham and Sale West,-7,3,NW,UKD,71511,101457,Altrincham and Sale West,Con,Con,-6.5,3,"6,426",Alt,,Con,6426
E14000533,Amber Valley,0,2,EM,UKF,69510,90132,Amber Valley,Con,Con,0,2,"8,300",Amb,,Con,8300
E14000534,Arundel and South Downs,0,-15,SE,UKJ,77242,100501,Arundel and South Downs,Con,Con,0.5,-15,"23,883",Aru,,Con,23883
E14000535,Ashfield,1,2,EM,UKF,77091,106495,Ashfield,Lab,Lab,1,2,441,Ash,,Lab,441
E14000536,Ashford,12,-13,SE,UKJ,85177,122178,Ashford,Con,Con,12.5,-13,"17,478",Ash,,Con,17478
E14000537,Ashton-under-Lyne,-5,6,NW,UKD,68343,92289,Ashton-Under-Lyne,Lab,Lab,-5,6,"11,295",Ash,,Lab,11295
E14000538,Aylesbury,2,-6,SE,UKJ,80315,121812,Aylesbury,Con,Con,2,-6,"14,656",Ayl,,C
@broadpeter
broadpeter / electionmap3.csv
Created December 7, 2019 19:09
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 18 columns, instead of 17 in line 9.
,n,q,r,a,u,e,p,name,Winner17,Winner15,q2,r2,majority17,nameshort,byelection,preelection2019,majority17text
E14000530,Aldershot,-3,-11,SE,UKJ,72430,106193,Aldershot,Con,Con,-2.5,-11,"11,473",Ald,,Con,11473
E14000531,Aldridge-Brownhills,-3,-1,WM,UKG,60215,77532,Aldridge-Brownhills,Con,Con,-2.5,-1,"14,307",Ald,,Con,14307
E14000532,Altrincham and Sale West,-7,3,NW,UKD,71511,101457,Altrincham and Sale West,Con,Con,-6.5,3,"6,426",Alt,,Con,6426
E14000533,Amber Valley,0,2,EM,UKF,69510,90132,Amber Valley,Con,Con,0,2,"8,300",Amb,,Con,8300
E14000534,Arundel and South Downs,0,-15,SE,UKJ,77242,100501,Arundel and South Downs,Con,Con,0.5,-15,"23,883",Aru,,Con,23883
E14000535,Ashfield,1,2,EM,UKF,77091,106495,Ashfield,Lab,Lab,1,2,441,Ash,,Lab,441
E14000536,Ashford,12,-13,SE,UKJ,85177,122178,Ashford,Con,Con,12.5,-13,"17,478",Ash,,Con,17478
E14000537,Ashton-under-Lyne,-5,6,NW,UKD,68343,92289,Ashton-Under-Lyne,Lab,Lab,-5,6,"11,295",Ash,,Lab,11295
E14000538,Aylesbury,2,-6,SE,UKJ,80315,121812,Aylesbury,Con,Con,2,-6,"14,656",Ayl,,C
@broadpeter
broadpeter / electionmap2.csv
Created December 7, 2019 14:48
n q r a u e p name Winner17 Winner15 q2 r2 majority17 nameshort
E14000530 Aldershot -3 -11 SE UKJ 72430 106193 Aldershot Con Con -2.5 -11 11,473 Ald
E14000531 Aldridge-Brownhills -3 -1 WM UKG 60215 77532 Aldridge-Brownhills Con Con -2.5 -1 14,307 Ald
E14000532 Altrincham and Sale West -7 3 NW UKD 71511 101457 Altrincham and Sale West Con Con -6.5 3 6,426 Alt
E14000533 Amber Valley 0 2 EM UKF 69510 90132 Amber Valley Con Con 0 2 8,300 Amb
E14000534 Arundel and South Downs 0 -15 SE UKJ 77242 100501 Arundel and South Downs Con Con 0.5 -15 23,883 Aru
E14000535 Ashfield 1 2 EM UKF 77091 106495 Ashfield Lab Lab 1 2 441 Ash
E14000536 Ashford 12 -13 SE UKJ 85177 122178 Ashford Con Con 12.5 -13 17,478 Ash
E14000537 Ashton-under-Lyne -5 6 NW UKD 68343 92289 Ashton-Under-Lyne Lab Lab -5 6 11,295 Ash
E14000538 Aylesbury 2 -6 SE UKJ 80315 121812 Aylesbury Con Con 2 -6 14,656 Ayl
@broadpeter
broadpeter / electionmap.csv
Created December 7, 2019 14:42
Election map data
n q r a u e p name Winner17 Winner15 q2 r2 majority17
E14000530 Aldershot -3 -11 SE UKJ 72430 106193 Aldershot Con Con -2.5 -11 11,473
E14000531 Aldridge-Brownhills -3 -1 WM UKG 60215 77532 Aldridge-Brownhills Con Con -2.5 -1 14,307
E14000532 Altrincham and Sale West -7 3 NW UKD 71511 101457 Altrincham and Sale West Con Con -6.5 3 6,426
E14000533 Amber Valley 0 2 EM UKF 69510 90132 Amber Valley Con Con 0 2 8,300
E14000534 Arundel and South Downs 0 -15 SE UKJ 77242 100501 Arundel and South Downs Con Con 0.5 -15 23,883
E14000535 Ashfield 1 2 EM UKF 77091 106495 Ashfield Lab Lab 1 2 441
E14000536 Ashford 12 -13 SE UKJ 85177 122178 Ashford Con Con 12.5 -13 17,478
E14000537 Ashton-under-Lyne -5 6 NW UKD 68343 92289 Ashton-Under-Lyne Lab Lab -5 6 11,295
E14000538 Aylesbury 2 -6 SE UKJ 80315 121812 Aylesbury Con Con 2 -6 14,656
@broadpeter
broadpeter / electionmap.csv
Created December 7, 2019 14:42
Election map data
E14000530 Aldershot -3 -11 SE UKJ 72430 106193 Aldershot Con Con -2.5 -11 11,473
E14000531 Aldridge-Brownhills -3 -1 WM UKG 60215 77532 Aldridge-Brownhills Con Con -2.5 -1 14,307
E14000532 Altrincham and Sale West -7 3 NW UKD 71511 101457 Altrincham and Sale West Con Con -6.5 3 6,426
E14000533 Amber Valley 0 2 EM UKF 69510 90132 Amber Valley Con Con 0 2 8,300
E14000534 Arundel and South Downs 0 -15 SE UKJ 77242 100501 Arundel and South Downs Con Con 0.5 -15 23,883
E14000535 Ashfield 1 2 EM UKF 77091 106495 Ashfield Lab Lab 1 2 441
E14000536 Ashford 12 -13 SE UKJ 85177 122178 Ashford Con Con 12.5 -13 17,478
E14000537 Ashton-under-Lyne -5 6 NW UKD 68343 92289 Ashton-Under-Lyne Lab Lab -5 6 11,295
E14000538 Aylesbury 2 -6 SE UKJ 80315 121812 Aylesbury Con Con 2 -6 14,656
@broadpeter
broadpeter / monattempt.json
Last active April 24, 2019 21:00
Attempt at monuments json
{
"nodes": [
{"id": "PR", "group": 1},
{"id": "RVV", "group":2},
{"id": "LBL", "group": 2},
{"id": "GDL", "group": 3},
{"id": "MSR", "group": 3}
],
"links": [
{"source": "PR", "target": "RVV", "value": 46},