Skip to content

Instantly share code, notes, and snippets.

David Kane drkane

Block or report user

Report or block drkane

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View prepare-chord-diagram.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@drkane
drkane / normalise_string.py
Created Aug 29, 2018
normalise a pandas series string (built for the names of charities/other organisations)
View normalise_string.py
# takes a pandas series
def normalize_string(s):
s = s.astype(str)
s = s.str.lower()
# replace apostrophes
def replace_apos(match):
return match.group(0).replace("'", "")
s = s.str.replace(r'\'s\b', replace_apos)
@drkane
drkane / kingston-lsoa.geojson
Last active Jun 11, 2018
Lower Super Output Area boundaries for Royal Borough of Kingston Upon Thames. Contains National Statistics data © Crown copyright and database right 2018 Contains OS data © Crown copyright and database right 2018 From ONS geoportal: http://geoportal.statistics.gov.uk/datasets/lower-layer-super-output-areas-december-2011-full-clipped-boundaries-…
View kingston-lsoa.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@drkane
drkane / kingston-wards.geojson
Last active Jun 10, 2018
Ward boundaries for Royal Borough of Kingston Upon Thames. From ONS geoportal: http://geoportal.statistics.gov.uk/datasets/wards-december-2017-full-clipped-boundaries-in-great-britain Contains National Statistics data © Crown copyright and database right 2018 Contains OS data © Crown copyright and database right 2018
View kingston-wards.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View gender-pay-gap-with-charity-no.csv
We can't make this file beautiful and searchable because it's too large.
EmployerName,Address,CompanyNumber,SicCodes,DiffMeanHourlyPercent,DiffMedianHourlyPercent,DiffMeanBonusPercent,DiffMedianBonusPercent,MaleBonusPercent,FemaleBonusPercent,MaleLowerQuartile,FemaleLowerQuartile,MaleLowerMiddleQuartile,FemaleLowerMiddleQuartile,MaleUpperMiddleQuartile,FemaleUpperMiddleQuartile,MaleTopQuartile,FemaleTopQuartile,CompanyLinkToGPGInfo,ResponsiblePerson,EmployerSize,CurrentName,CharityNumber,CharityIncome,OrgType,OrgSubType,PaidMore,FemaleWorkforce
"""Bryanston School"",Incorporated","Bryanston House, Blandford, Dorset, United Kingdom, DT11 0PX",00226143,85310,18.0,28.2,0.0,0.0,0.0,0.0,24.4,75.6,50.8,49.2,49.2,50.8,51.5,48.5,https://www.bryanston.co.uk/employment,Nick McRobb (Bursar and Clerk to the Governors),500 to 999,"""Bryanston School"",Incorporated",306210,23130767.0,Charity,,Men,56.025
@drkane
drkane / charity-reregistrations.csv
Created Feb 9, 2018
Charities registered in England and Wales that are the result of re-registration of an older charity
View charity-reregistrations.csv
Old charity number New charity number
306072 1115974
View academy-trusts-company-number.csv
Type Entity Company Number OSCAR CPID
Academy Trust Gateway Learning Community 05853746 CAD022
Academy Trust John Henry Newman Catholic College, The 07414011 CAD022
Academy Trust Abbey Multi Academy Trust 07705552 CAD022
Academy Trust Abbey School (Faversham), The 07697086 CAD022
Academy Trust St. Thomas More High School 07696989 CAD022
Academy Trust Peaslake Free School Limited 07925067 CAD022
Academy Trust Peatmoor Community Primary School 08714452 CAD022
Academy Trust Abney Trust 09912859 CAD022
Academy Trust Fulwell Infant School Academy 08277622 CAD022
@drkane
drkane / ccew-oscr-activities-readacross.csv
Created Mar 3, 2017
Read-across for activity, beneficiary and purpose categories for Charities from those used by the Charity Commission for England and Wales (CCEW) to the Office of the Scottish Charity Regulator (OSCR). NB These are many-to-many relationships, and lots of the categories don't match exactly.
View ccew-oscr-activities-readacross.csv
ccew-classno ccew-classtext oscr-group oscr-label
201 CHILDREN/YOUNG PEOPLE beneficiaries Children / young people
202 ELDERLY/OLD PEOPLE beneficiaries Older people
203 PEOPLE WITH DISABILITIES beneficiaries People with disabilities or health problems
204 PEOPLE OF A PARTICULAR ETHNIC OR RACIAL ORIGIN beneficiaries People of a particular ethnic or racial origin
205 OTHER CHARITIES OR VOLUNTARY BODIES beneficiaries Other charities / voluntary bodies
206 OTHER DEFINED GROUPS beneficiaries Other defined groups
207 THE GENERAL PUBLIC/MANKIND beneficiaries No specific group, or for the benefit of the community"
101 GENERAL CHARITABLE PURPOSES purposes Any other purpose that may reasonably be regarded as analogous to any of the preceding purposes
102 EDUCATION/TRAINING purposes The advancement of education
@drkane
drkane / part-b-hierarchy.md
Last active Feb 7, 2017
Charity Commission Part B fields
View part-b-hierarchy.md

extract_partb

Annual Return Detail table. Row for each AR for each registered main charity. Contains a row for each year for each charity, with more detailed financial information. Charities only have to fill in this information if their income is greater than £500,000 in that year.

Field name Data type Description Note
@drkane
drkane / cc-aoo-gss-iso.csv
Last active Mar 22, 2017
Charity Commission area of operation codes with GSS and ISO country codes
View cc-aoo-gss-iso.csv
aootype aookey aooname aoosort welsh master GSS ISO3166-1 ISO3166-2:GB ContinentCode oldCode
A 1 THROUGHOUT ENGLAND AND WALES At least 10 authorities in England and Wales N K04000001 GB GB-EAW EU 941
A 2 THROUGHOUT ENGLAND At least 10 authorities in England only N E92000001 GB GB-ENG EU 921
A 3 THROUGHOUT WALES At least 10 authorities in Wales only N W92000004 GB GB-WLS EU 924
A 4 THROUGHOUT LONDON At least 10 authorities in Greater London N E12000007 GB EU H
B 1 BRACKNELL FOREST BRACKNELL FOREST N E06000036 GB GB-BRC EU 00MA
B 2 WEST BERKSHIRE WEST BERKSHIRE N E06000037 GB GB-WBK EU 00MB
B 3 READING READING N E06000038 GB GB-RDG EU 00MC
B 4 SLOUGH SLOUGH N E06000039 GB GB-SLG EU 00MD
B 5 WINDSOR AND MAIDENHEAD WINDSOR AND MAIDENHEAD N E06000040 GB GB-WNM EU 00ME
You can’t perform that action at this time.