delete from uk_function_code
buff
replace uk_function_code values
("CKCOT","s","Civil Government, Other"),
("CKCVL","s","Civil List"),
("CKGPS","s","General public services"),
("CKGEL","s","Executive and legislative organs, financial and fiscal affairs, external affairs"),
("CKGFA","s","Foreign economic aid"),
("CKGGS","s","General services"),
("CKGBR","s","Basic research"),
("CKSCT","s","Science and technology"),
("CKGRD","s","R&D general public services"),
("CKGNE","s","General public services n.e.c."),
("CKGOI","s","Other international services"),
("CKPSI","s","Public sector debt interest"),
("CKDEF","s","Defence"),
("CKDMD","s","Military defence"),
("CKDMA","s","Army"),
("CKDMN","s","Royal Navy"),
("CKDMF","s","Royal Air Force"),
("CKDCD","s","Civil defence"),
("CKDFA","s","Foreign military aid"),
("CKDRD","s","R&D defence"),
("CKDNE","s","Defence n.e.c"),
("CKPOS","s","Public order and safety"),
("CKPPO","s","Police services"),
("CKPFI","s","Fire-protection services"),
("CKPLC","s","Law courts"),
("CKPPR","s","Prisons"),
("CKPRD","s","R&D public order and safety"),
("CKPNE","s","Public order and safety n.e.c."),
("CKECA","s","Economic affairs"),
("CKEEC","s","General economic, commercial and labour affairs"),
("CKSBU","s","Support for business"),
("CKEAF","s","Agriculture, forestry, fishing and hunting"),
("CKEMC","s","Fuel and Energy"),
("CKEMC","s","Mining, manufacturing and construction"),
("CKEMP","s","Employment policies"),
("CKETR","s","Transport"),
("CKTRA","s","Transport"),
("CKETN","s","National roads"),
("CKETN","s","National roads"),
("CKETL","s","Local roads"),
("CKETP","s","Local public transport"),
("CKEDL","s","Driver and vehicle licensing and testing"),
("CKEMA","s","UK Maritime Agency"),
("CKEPT","s","Ports"),
("CKECG","s","Marine coastguard shipping civil aviation"),
("CKERL","s","Railway"),
("CKEOT","s","Other transport"),
("CKECM","s","Communication"),
("CKEOI","s","Other industries"),
("CKEAR","s","R&D economic affairs"),
("CKEAN","s","Economic affairs n.e.c"),
("CKENV","s","Environment protection"),
("CKEWM","s","Waste management"),
("CKEWW","s","Waste water management"),
("CKEPA","s","Pollution abatement"),
("CKEBL","s","Protection of biodiversity and landscape"),
("CKEER","s","R&D environment protection"),
("CKEBN","s","Environment protection n.e.c"),
("CKHOU","s","Housing and community amenities"),
("CKHHD","s","Housing development"),
("CKHSH","s","Other social housing"),
("CKHCD","s","Community development"),
("CKHWS","s","Water supply"),
("CKHSL","s","Street lighting"),
("CKHRD","s","R&D housing and community amenities"),
("CKHNE","s","Housing and community amenities n.e.c"),
("CKHEA","s","Health"),
("CKHME","s","Medical services"),
("CKHHR","s","Health research"),
("CKHHC","s","Central and other health services"),
("CKHNC","s","Health n.e.c"),
("CKRCR","s","Recreation, culture and religion"),
("CKRRS","s","Recreational and sporting services"),
("CKRTR","s","Tourism"),
("CKRCS","s","Cultural services"),
("CKREG","s","Regional policy"),
("CKRFI","s","Films"),
("CKRLI","s","Libraries"),
("CKRMG","s","Museums and galleries"),
("CKRBP","s","Broadcasting and publishing services"),
("CKRRC","s","Religious and other community services"),
("CKLOT","s","National Lottery "),
("CKRRD","s","R&D recreation, culture and religion"),
("CKRNE","s","Recreation, culture and religion n.e.c"),
("CKROA","s","Other arts and heritage"),
("CKEDT","s","Education (includes training)"),
("CKEPP","s","Pre-primary education"),
("CKEPE","s","Primary education"),
("CKESE","s","Secondary education"),
("CKEPS","s","Post-secondary non-tertiary education"),
("CKETE","s","Tertiary education"),
("CKEHE","s","Higher Education"),
("CKEFE","s","Further Education"),
("CKESP","s","Schools (Primary, Secondary)"),
("CKEND","s","Education not definable by level"),
("CKESS","s","Subsidiary services to education"),
("CKERD","s","R&D education"),
("CKEDN","s","Education n.e.c"),
("CKSPG","s","Social protection"),
("CKSPS","s","personal social services"),
("CKSSD","s","Sickness and disability "),
("CKSOP","s","Social protection")
buff
replace uk_function_code values
("CKSOA","s","Old age "),
("CKSSU","s","Survivors "),
("CKPEN","s","Pensions"),
("CKPGP","s","Government pensions"),
("CKSFC","s","Family and children"),
("CKSUE","s","Unemployment"),
("CKSHO","s","Housing"),
("CKSII","s","Industrial injury benefits"),
("CKSIS","s","Income support"),
("CKSPP","s","Public sector occupational pensions"),
("CKSSE","s","Social exclusion n.e.c "),
("CKSSF","s","Social Fund"),
("CKSWP","s","War pensions"),
("CKSRD","s","R&D social protection"),
("CKSFM","s","Supply, Food, Misc"),
("CKSNE","s","Social protection n.e.c."),
("CKWEL","s","Public assistance"),
("CKONE","s","Other spending"),
("CKEUT","s","EU transactions"),
("CKAAJ","s","Accounting adjustments"),
("CKTOT","s","Total central government own expenditure"),
("CKPOC","s","Post Office Collections"),
("CKCOL","s","Collection Cost"),
("LKGPS","s","General public services (current)"),
("LKPCS","s","Public and common services (current)"),
("LKPSI","s","Public sector debt interest (current)"),
("LKDEF","s","Defence (current)"),
("LKDCD","s","Civil Defence"),
("LKPOS","s","Public order and safety (current)"),
("LKECA","s","Economic affairs (current)"),
("LKEED","s","enterprise and economic development (current)"),
("LKEEN","s","Fuel and Energy"),
("LKEOI","s","Other industries"),
("LKEPK","s","Parks, pleasure grounds"),
("LKAFF","s","agriculture, fisheries and forestry (current)"),
("LKHIB","s","Highways and Bridges (current)"),
("LKTRA","s","transport (current)"),
("LKENV","s","Environment protection (current)"),
("LKEEP","s","employment policies (current)"),
("LKHOU","s","Housing and community amenities (current)"),
("LKHEA","s","Health (current)"),
("LKCOI","s","Harbours (current)"),
("LKREC","s","Recreation, culture and religion (current)"),
("LKEDU","s","Education (includes training) (current)"),
("LKEDE","s","education (current)"),
("LKEDT","s","training (current)"),
("LKEWW","s","Waste water management"),
("LKHWS","s","Water supply"),
("LKSHO","s","Housing"),
("LKPFI","s","Fire-protection services"),
("LKPPO","s","Police services"),
("LKRCS","s","Libraries, museums, and arts"),
("LKSOP","s","Social protection (current)"),
("LKONE","s","Other spending (current)"),
("LKAAJ","s","Accounting adjustments (current)"),
("LKTOT","s","Total Local Authorities' current expenditure"),
("LCGPS","s","General public services (capital)"),
("LCPCS","s","public and common services (capital)"),
("LCPOS","s","Public order and safety (capital)"),
("LCECA","s","Economic affairs (capital)"),
("LCEED","s","enterprise and economic development (capital)"),
("LCEEP","s","employment policies (capital)"),
("LCEEN","s","Fuel and Energy (capital)"),
("LCAFF","s","agriculture, fisheries and forestry (capital)"),
("LCHIB","s","Highways and Bridges (capital)"),
("LCTRA","s","Transport (capital)"),
("LCENV","s","Environment protection (capital)"),
("LCEPK","s","Parks, pleasure grounds (capital)"),
("LCHOU","s","Housing and community amenities (capital)"),
("LCCOI","s","Harbours (capital)"),
("LCHEA","s","Health (capital)"),
("LCREC","s","Recreation, culture and religion (capital)"),
("LCEDU","s","Education (includes training) (capital)"),
("LCEDE","s","education (capital)"),
("LCEDT","s","training (capital)"),
("LCEWW","s","Waste water management (capital)"),
("LCHWS","s","Water supply (capital)"),
("LCHSL","s","Street lighting (capital)"),
("LCSOP","s","Social protection (capital)"),
("LCSHO","s","Housing (capital)"),
("LCONE","s","Other spending (capital)"),
("LCAAJ","s","Accounting adjustments (capital)"),
("LCTOT","s","Total Local Authorities' capital expenditure"),
("GKDEF","s","Defence"),
("GKINT","s","International development assistance and other international services "),
("GKAFF","s","Agriculture, fisheries, food and forestry "),
("GKEEC","s","Trade, industry, energy, employment and training "),
("GKTRA","s","Transport"),
("GKHOU","s","Housing"),
("GKENV","s","Other environmental services "),
("GKLOP","s","Law, order and protective services "),
("GKEDU","s","Education"),
("GKCMS","s","Culture, Media and Sport "),
("GKHEA","s","Health services"),
("GKPSS","s","Personal social services"),
("GKSSY","s","Social security "),
("GKADM","s","Central administration and associated expenditure"),
("GKPSI","s","General government net debt interest "),
("GKAAJ","s","Other accounting adjustments"),
("GKSFL","s","Allowance for shortfall"),
("GKINR","s","General government interest and dividend receipts "),
("GKLOT","s","National Lottery ")
buff
replace uk_function_code values
("GKONE","s","Other spending"),
("GKPDN","s","Pensions n.e.c."),
("GKPRP","s","Privatisation proceeds "),
("GKTOT","s","General government expenditure "),
("GJW2T","r","Current budget deficit"),
("PCHEA","s","Total Health"),
("PCTRA","s","Total Transport"),
("PCCFC","s","Fire Service College"),
("PCCHT","s","Housing Action Trusts"),
("PCCOS","s","Ordnance Survey"),
("PCCCC","s","QEII Conference Centre"),
("PCCHR","s","Housing Revenue Account"),
("PCCLG","s","Total Communities and Local Government"),
("PCHTO","s","Total Home Office"),
("PCITO","s","Patent Office"),
("PCJLR","s","Land Registry"),
("PCDTO","s","Total Defence"),
("PCFTO","s","Total Foreign and Commonwealth Office"),
("PCITO","s","Total International Development"),
("PCBTO","s","Total Business, Enterprise and Regulatory Reform"),
("PCETO","s","Total Environment Food and Rural Affairs"),
("PCECC","s","Total Energy and Climate Change"),
("PCCMT","s","Total Culture Media and Sport"),
("PCWTO","s","Total Work and Pensions"),
("PCSCM","s","Caledonian MacBrayne"),
("PCSFE","s","Forest Enterprise"),
("PCSAP","s","Highlands and Islands Airports"),
("PCSHR","s","Housing Revenue Account"),
("PCSHT","s","NHS Trusts (Scotland)"),
("PCSWT","s","Scottish Water"),
("PCWHR","s","Wales Housing Revenue Account"),
("PCWDA","s","Welsh Development Agency"),
("PCWFE","s","Forest Enterprise (Wales)"),
("PCWHT","s","NHS Trusts (Wales)"),
("PCNDA","s","Northern Ireland Driver and Vehicle Testing Agency"),
("PCNHE","s","Northern Ireland Housing Executive"),
("PCNHS","s","Northern Ireland HSS Trusts"),
("PCNLS","s","Laganside (NI)"),
("PCNPA","s","Northern Ireland Public Trust Port Authority"),
("PCNTH","s","Northern Ireland Transport Holding Company"),
("PCNWA","s","Northern Ireland Water"),
("PCCDT","s","Total Chancellor's Departments"),
("PCLLU","s","London Underground Limited"),
("PCTSR","s","Total public corporations' capital expenditure on services"),
("PCAAJ","s","Accounting Adjustments"),
("PCTOT","s","Total public corporations' capital expenditure"),
("GKDMD","s","Military Defence"),
("GKDCD","s","Civil Defence"),
("GKDWD","s","War damage compensation, etc."),
("GKTRL","s","Roads and Public Lighting"),
("GKTTC","s","Transport and Communication"),
("GKEES","s","Employment Services"),
("GKEIO","s","Other Industry and Trade"),
("GKGBR","s","Research"),
("GKHPH","s","Public health services"),
("GKELD","s","Land drainage and coastal protection"),
("GKEPK","s","Parks, pleasure grounds"),
("GKEOT","s","Misc local government services"),
("GKPPO","s","Police"),
("GKPFI","s","Fire service"),
("GKPPR","s","Prisons"),
("GKPLC","s","Parliament and law courts"),
("GKECC","s","Child care"),
("GKESM","s","School meals, milk and welfare foods"),
("GKRCS","s","Libraries, museums, and arts"),
("GKHNH","s","National health service"),
("GKHPS","s","Personal social services"),
("GKADM","s","Central administration and associated expenditure"),
("GCCFP","s","Fuel and Power fixed capital formation"),
("GCCIS","s","Iron and Steel fixed capital formation"),
("GCCOT","s","Other Public Corporations fixed capital formation"),
("GCTRA","s","Transport and Communications fixed capital formation"),
("GCHOU","s","Housing fixed capital formation"),
("GCTOT","s","Total Spending (capital)"),
("GKGPS","s","General public services"),
("GKGEL","s","Executive and legislative organs, financial and fiscal affairs, external affairs"),
("GKGFA","s","Foreign economic aid"),
("GCGFA","s","Foreign economic aid (capital)"),
("GKGGS","s","General services"),
("GCGGS","s","General services (capital)"),
("GKGBR","s","Basic research"),
("GKGRD","s","R&D general public services"),
("GKGNE","s","General public services n.e.c."),
("GKDEF","s","Defence"),
("GCDEF","s","Defence (capital)"),
("GKDMD","s","Military defence"),
("GKDCD","s","Civil defence"),
("GKDFA","s","Foreign military aid"),
("GKDRD","s","R&D defence"),
("GKDNE","s","Defence n.e.c"),
("GKPOS","s","Public order and safety"),
("GCPOS","s","Public order and safety (capital)"),
("GKPPO","s","Police services"),
("GKPFI","s","Fire-protection services"),
("GKPLC","s","Law courts"),
("GKPPR","s","Prisons"),
("GKPRD","s","R&D public order and safety"),
("GKPNE","s","Public order and safety n.e.c."),
("GKECA","s","Economic affairs"),
("GKEEC","s","General economic, commercial and labour affairs"),
("GCEEC","s","General economic, commercial and labour affairs (capital)"),
("GKEAF","s","Agriculture, forestry, fishing and hunting")
buff
replace uk_function_code values
("GCEAF","s","Agriculture, forestry, fishing and hunting (capital)"),
("GKEEN","s","Fuel and Energy"),
("GKEMC","s","Mining, manufacturing and construction"),
("GKETR","s","Transport"),
("GKETN","s","national roads"),
("GKETL","s","local roads"),
("GKETP","s","local public transport"),
("GKERL","s","railway"),
("GKEOT","s","other transport"),
("GKECM","s","Communication"),
("GKEOI","s","Other industries"),
("GKEAR","s","R&D economic affairs"),
("GCEAR","s","R&D economic affairs (capital)"),
("GKEAN","s","Economic affairs n.e.c"),
("GKENV","s","Environment protection"),
("GCENV","s","Environment protection (capital)"),
("GKEWM","s","Waste management"),
("GKEWW","s","Waste water management"),
("GKEPA","s","Pollution abatement"),
("GKEBL","s","Protection of biodiversity and landscape"),
("GKEER","s","R&D environment protection"),
("GKEBN","s","Environment protection n.e.c"),
("GKHOU","s","Housing and community amenities"),
("GCHOU","s","Housing and community amenities (capital)"),
("GKHHD","s","Housing development"),
("GKHCD","s","Community development"),
("GKHWS","s","Water supply"),
("GKHSL","s","Street lighting"),
("GKHRD","s","R&D housing and community amenities"),
("GKHNE","s","Housing and community amenities n.e.c"),
("GKHEA","s","Health"),
("GCHEA","s","Health (capital)"),
("GKHME","s","Medical services"),
("GKHHR","s","Health research"),
("GKHHC","s","Central and other health services"),
("GKRCR","s","Recreation, culture and religion"),
("GCRCR","s","Recreation, culture, religion (capital)"),
("GKRRS","s","Recreational and sporting services"),
("GKRCS","s","Cultural services"),
("GKRBP","s","Broadcasting and publishing services"),
("GKRRC","s","Religious and other community services"),
("GKRRD","s","R&D recreation, culture and religion"),
("GKRNE","s","Recreation, culture and religion n.e.c"),
("GKEDT","s","Education (incl. training)"),
("GCEDT","s","Education (incl. training)(capital)"),
("GKEPE","s","Pre-primary and primary education"),
("GKESE","s","Secondary education"),
("GKEPS","s","Post-secondary non-tertiary education"),
("GKETE","s","Tertiary education"),
("GKEND","s"," Education not definable by level"),
("GKESS","s","Subsidiary services to education"),
("GKERD","s","R&D education"),
("GKENE","s","Education n.e.c"),
("GKSPG","s","Social protection"),
("GCSPG","s","Social protection (capital)"),
("GKSPS","s","personal social services"),
("GKSSD","s","Sickness and disability "),
("GKSOA","s","Old age "),
("GKSSU","s","Survivors "),
("GKPEN","s ","Pensions"),
("GKSFC","s","Family and children"),
("GKSUE","s","Unemployment"),
("GKSHO","s","Housing"),
("GKWEL","s","Public assistance"),
("GKSSE","s","Social exclusion n.e.c "),
("GKSRD","s","R&D social protection"),
("GKSNE","s","Social protection n.e.c."),
("GKTOT","s","Total expenditure"),
("NDEBT","s","Public Debt"),
("GJW2T","s","Current budget deficit"),
("GDP","s","Gross Domestic Product (current $)"),
("GDC","s","Gross Domestic Product (real)"),
("GDD","s","Inflation"),
("CNMCU","r","Taxes on income and wealth"),
("CLIBR","r","Income tax"),
("CN445","r","Corporation tax"),
("CACCI","r","Petroleum revenue tax"),
("CMF6Z","r","Misc. taxes on income & wealth"),
("CNMBY","r","Taxes on production"),
("CNZGF","r","Value added tax"),
("CCUDG","r","Fuel duties"),
("CCUKY","r","Business rates"),
("CMM9F","r","Stamp duty land tax"),
("CBKST","r","Stamp taxes on shares"),
("CGTAO","r","Tobacco duties"),
("CMF6V","r","Alcohol duties"),
("CEKED","r","Vehicle excise duties paid by businesses"),
("CCDDZ","r","Vehicle excise duties"),
("CMF6W","r","Other taxes on production"),
("CPRMD","r","Remaining taxes on production"),
("CMF6W","r","Other taxes"),
("CNMCV","r","Other current taxes"),
("CLIQR","r","Other taxes"),
("CHZS7","r","Taxes on capital"),
("CAIIH","r","Compulsory social contributions"),
("CNRLN","r","Gross operating surplus"),
("CGVHE","r","Interest and dividends from private sector and RoW"),
("CANNY","r","Interest and dividents (net) from public sector"),
("CANBU","r","Rent and other current transfers"),
("CANBV","r","Total current receipts"),
("CRTOT","r","Total gross income"),
("CRCUS","r","Customs")
last buff
replace uk_function_code values
("CREXC","r","Excise"),
("CRSTA","r","Stamp duty"),
("CRLAN","r","Land and assessed taxes"),
("CRPIT","r","Property and income tax"),
("CRPRF","r","Profits tax"),
("CRPOS","r","Post Office"),
("CRTLG","r","Telegraph services"),
("CRTLP","r","Telephone services"),
("CRDDT","r","Death duties"),
("CRMVD","r","Motor vehicle duties"),
("CRBRL","r","Broadcast receiving licenses"),
("CROTH","r","Other revenue"),
("LNMYH","r","Taxes on production"),
("LMJBB","r","Council tax/rates"),
("LNRLT","r","Gross operating surplus"),
("LGVHF","r","Interest and dividends from private sector and RoW"),
("LANPZ","r","Interest and dividents (net) from public sector"),
("LANBX","r","Rent and other current transfers"),
("LANBW","r","Total current receipts"),
("LRETO","r","Total receipts"),
("LREOT","r","Other receipts"),
("LRERA","r","Rates"),
("PFCCS","r","Taxes on income and wealth (public corps)"),
("PNRJT","r","Gross operating surplus"),
("PGVHG","r","Interest and dividends from private sector and RoW (public corps)"),
("PANRW","r","Interest and dividents (net) from public sector (public corps)"),
("PANCW","r","Rent and other current transfers (public corps)"),
("PANBZ","r","Total current receipts (public corps)"),
("PNMYE","r","Taxes on production"),
("NDEBT","r","Public Debt")
Done