delete from uk_spending_allocation where spend_rev = 's'
last buff
replace uk_spending_allocation values
("47","GKEOI","f","s"),
("48","GKEAR","f","s"),
("48","GCEAR","f","s"),
("49","GKEAN","f","s"),
("51","GKEWM","f","s"),
("52","GKEWW","f","s"),
("53","GKEPA","f","s"),
("54","GKEBL","f","s"),
("55","GKEER","f","s"),
("56","GKEBN","f","s"),
("56","GKENV","f","s"),
("56","GCENV","f","s"),
("61","GKHHD","f","s"),
("62","GKHCD","f","s"),
("63","GKHWS","f","s"),
("64","GKHSL","f","s"),
("65","GKHRD","f","s"),
("66","GKHNE","f","s"),
("73","GKHME","f","s"),
("75","GKHHR","f","s"),
("74","GKHHC","f","s"),
("76","GKHEA","f","s"),
("81","GKRRS","f","s"),
("82","GKRCS","f","s"),
("83","GKRBP","f","s"),
("84","GKRRC","f","s"),
("85","GKRRD","f","s"),
("86","GKRNE","f","s"),
("86","GKRCR","f","s"),
("86","GCRCR","f","s"),
("91","GKEPE","f","s"),
("92","GKESE","f","s"),
("93","GKEPS","f","s"),
("94","GKETE","f","s"),
("95","GKEND","f","s"),
("95","GKEDT","f","s"),
("95","GCEDT","f","s"),
("96","GKESS","f","s"),
("97","GKERD","f","s"),
("98","GKEDN","f","s"),
("A1","GKSSD","f","s"),
("A2","GKSOA","f","s"),
("A3","GKSSU","f","s"),
("A4","GKSFC","f","s"),
("A5","GKSUE","f","s"),
("A6","GKSHO","f","s"),
("A7","GKSSE","f","s"),
("A8","GKSRD","f","s"),
("A9","GKSNE","f","s"),
("A9","GKSPG","f","s"),
("A9","GCSPG","f","s"),
("F1","GKTOT","f","s"),
("P1","GDP","f","s"),
("P1","GDP","c","s"),
("Q1","GDD","f","s"),
("Q1","GDD","c","s")
Done