return to Menu



Base year:2021-22
Base Source: outturn
Spend Code GKEOT overlimit
Spend Code NDEBT overlimit
Spend Code GDP overlimit
Spend Code GDD overlimit

Code Orphans:

replace uk_government_spending (year,state,code,source,author,fy,spend_rev,spending) values ("2022","UK","LKPCS","a","hmt","hist","s","4865"), ("2022","UK","LKPSI","a","hmt","hist","s","802"), ("2022","UK","LKDEF","a","hmt","hist","s","125"), ("2022","UK","LKPOS","a","hmt","hist","s","16959"), ("2022","UK","LKEED","a","hmt","hist","s","1171"), ("2022","UK","LKAFF","a","hmt","hist","s","104"), ("2022","UK","LKTRA","a","hmt","hist","s","4475"), ("2022","UK","LKENV","a","hmt","hist","s","6297"), ("2022","UK","LKHOU","a","hmt","hist","s","2505"), ("2022","UK","LKHEA","a","hmt","hist","s","4269"), ("2022","UK","LKREC","a","hmt","hist","s","3240"), ("2022","UK","LKEDE","a","hmt","hist","s","44776"), ("2022","UK","LKSOP","a","hmt","hist","s","56193"), ("2022","UK","LKAAJ","a","hmt","hist","s","33419"), ("2022","UK","LKTOT","a","hmt","hist","s","179201"), ("2022","UK","LCPCS","a","hmt","hist","s","1650"), ("2022","UK","LCPOS","a","hmt","hist","s","941"), ("2022","UK","LCEED","a","hmt","hist","s","1258"), ("2022","UK","LCAFF","a","hmt","hist","s","225"), ("2022","UK","LCTRA","a","hmt","hist","s","6841"), ("2022","UK","LCENV","a","hmt","hist","s","882"), ("2022","UK","LCHOU","a","hmt","hist","s","3262"), ("2022","UK","LCHEA","a","hmt","hist","s","26"), ("2022","UK","LCREC","a","hmt","hist","s","1529"), ("2022","UK","LCEDE","a","hmt","hist","s","3306"), ("2022","UK","LCSOP","a","hmt","hist","s","396"), ("2022","UK","LCAAJ","a","hmt","hist","s","626"), ("2022","UK","LCTOT","a","hmt","hist","s","20943"), ("2022","UK","LCEEP","a","hmt","hist","s","0"), ("2023","UK","LKPCS","a","hmt","hist","s","5100"), ("2023","UK","LKPSI","a","hmt","hist","s","870"), ("2023","UK","LKDEF","a","hmt","hist","s","90"), ("2023","UK","LKPOS","a","hmt","hist","s","18222"), ("2023","UK","LKEED","a","hmt","hist","s","1535"), ("2023","UK","LKAFF","a","hmt","hist","s","130"), ("2023","UK","LKTRA","a","hmt","hist","s","3978"), ("2023","UK","LKENV","a","hmt","hist","s","6719"), ("2023","UK","LKHOU","a","hmt","hist","s","2953"), ("2023","UK","LKHEA","a","hmt","hist","s","3905"), ("2023","UK","LKREC","a","hmt","hist","s","3518"), ("2023","UK","LKEDE","a","hmt","hist","s","47794"), ("2023","UK","LKSOP","a","hmt","hist","s","59528"), ("2023","UK","LKAAJ","a","hmt","hist","s","38450"), ("2023","UK","LKTOT","a","hmt","hist","s","192791"), ("2023","UK","LCPCS","a","hmt","hist","s","1233"), ("2023","UK","LCPOS","a","hmt","hist","s","900"), ("2023","UK","LCEED","a","hmt","hist","s","846"), ("2023","UK","LCAFF","a","hmt","hist","s","346"), ("2023","UK","LCTRA","a","hmt","hist","s","7898"), ("2023","UK","LCENV","a","hmt","hist","s","1113"), ("2023","UK","LCHOU","a","hmt","hist","s","3735"), ("2023","UK","LCHEA","a","hmt","hist","s","45"), ("2023","UK","LCREC","a","hmt","hist","s","1380"), ("2023","UK","LCEDE","a","hmt","hist","s","3222"), ("2023","UK","LCSOP","a","hmt","hist","s","456"), ("2023","UK","LCAAJ","a","hmt","hist","s","-57"), ("2023","UK","LCTOT","a","hmt","hist","s","21118"), ("2023","UK","LCEEP","a","hmt","hist","s","0"), ("2024","UK","LKPCS","a","hmt","hist","s","5535"), ("2024","UK","LKPSI","a","hmt","hist","s","1105"), ("2024","UK","LKDEF","a","hmt","hist","s","69"), ("2024","UK","LKPOS","a","hmt","hist","s","19719"), ("2024","UK","LKEED","a","hmt","hist","s","1532"), ("2024","UK","LKAFF","a","hmt","hist","s","152"), ("2024","UK","LKTRA","a","hmt","hist","s","4076"), ("2024","UK","LKENV","a","hmt","hist","s","7224"), ("2024","UK","LKHOU","a","hmt","hist","s","3205"), ("2024","UK","LKHEA","a","hmt","hist","s","3952"), ("2024","UK","LKREC","a","hmt","hist","s","3662"), ("2024","UK","LKEDE","a","hmt","hist","s","51168"), ("2024","UK","LKSOP","a","hmt","hist","s","65446"), ("2024","UK","LKAAJ","a","hmt","hist","s","39636"), ("2024","UK","LKTOT","a","hmt","hist","s","206481"), ("2024","UK","LCPCS","a","hmt","hist","s","1342"), ("2024","UK","LCPOS","a","hmt","hist","s","1112"), ("2024","UK","LCEED","a","hmt","hist","s","644"), ("2024","UK","LCAFF","a","hmt","hist","s","368"), ("2024","UK","LCTRA","a","hmt","hist","s","8583"), ("2024","UK","LCENV","a","hmt","hist","s","1246"), ("2024","UK","LCHOU","a","hmt","hist","s","3739"), ("2024","UK","LCHEA","a","hmt","hist","s","28"), ("2024","UK","LCREC","a","hmt","hist","s","1845"), ("2024","UK","LCEDE","a","hmt","hist","s","3679"), ("2024","UK","LCSOP","a","hmt","hist","s","561"), ("2024","UK","LCAAJ","a","hmt","hist","s","-57"), ("2024","UK","LCTOT","a","hmt","hist","s","23090"), ("2024","UK","LCEEP","a","hmt","hist","s","0"), ("2025","UK","LKPCS","a","hmt","hist","s","5472"), ("2025","UK","LKPSI","a","hmt","hist","s","1098"), ("2025","UK","LKDEF","a","hmt","hist","s","72"), ("2025","UK","LKPOS","a","hmt","hist","s","21082"), ("2025","UK","LKEED","a","hmt","hist","s","2014"), ("2025","UK","LKAFF","a","hmt","hist","s","136"), ("2025","UK","LKTRA","a","hmt","hist","s","4518"), ("2025","UK","LKENV","a","hmt","hist","s","7526"), ("2025","UK","LKHOU","a","hmt","hist","s","3206"), ("2025","UK","LKHEA","a","hmt","hist","s","4182"), ("2025","UK","LKREC","a","hmt","hist","s","3598"), ("2025","UK","LKEDE","a","hmt","hist","s","56305"), ("2025","UK","LKSOP","a","hmt","hist","s","68830"), ("2025","UK","LKAAJ","a","hmt","hist","s","41412"), ("2025","UK","LKTOT","a","hmt","hist","s","219451"), ("2025","UK","LCPCS","a","hmt","hist","s","2226"), ("2025","UK","LCPOS","a","hmt","hist","s","1260"), ("2025","UK","LCEED","a","hmt","hist","s","720"), ("2025","UK","LCAFF","a","hmt","hist","s","361"), ("2025","UK","LCTRA","a","hmt","hist","s","8027"), ("2025","UK","LCENV","a","hmt","hist","s","1103"), ("2025","UK","LCHOU","a","hmt","hist","s","3587"), ("2025","UK","LCHEA","a","hmt","hist","s","31"), ("2025","UK","LCREC","a","hmt","hist","s","2155"), ("2025","UK","LCEDE","a","hmt","hist","s","4209"), ("2025","UK","LCSOP","a","hmt","hist","s","658"), ("2025","UK","LCAAJ","a","hmt","hist","s","411"), ("2025","UK","LCTOT","a","hmt","hist","s","24748"), ("2025","UK","LCEEP","a","hmt","hist","s","0"), ("2026","UK","LKPCS","e","hmt","hist","s","5817"), ("2026","UK","LKPSI","e","hmt","hist","s","1132"), ("2026","UK","LKDEF","e","hmt","hist","s","64"), ("2026","UK","LKPOS","e","hmt","hist","s","22122"), ("2026","UK","LKEED","e","hmt","hist","s","1225"), ("2026","UK","LKAFF","e","hmt","hist","s","144"), ("2026","UK","LKTRA","e","hmt","hist","s","4869"), ("2026","UK","LKENV","e","hmt","hist","s","7926"), ("2026","UK","LKHOU","e","hmt","hist","s","3530"), ("2026","UK","LKHEA","e","hmt","hist","s","4229"), ("2026","UK","LKREC","e","hmt","hist","s","3493"), ("2026","UK","LKEDE","e","hmt","hist","s","57973"), ("2026","UK","LKSOP","e","hmt","hist","s","68326"), ("2026","UK","LKAAJ","e","hmt","hist","s","46650"), ("2026","UK","LKTOT","e","hmt","hist","s","227499"), ("2026","UK","LCPCS","e","hmt","hist","s","1866"), ("2026","UK","LCPOS","e","hmt","hist","s","1271"), ("2026","UK","LCEED","e","hmt","hist","s","798"), ("2026","UK","LCAFF","e","hmt","hist","s","382"), ("2026","UK","LCTRA","e","hmt","hist","s","9503"), ("2026","UK","LCENV","e","hmt","hist","s","1145"), ("2026","UK","LCHOU","e","hmt","hist","s","4676"), ("2026","UK","LCHEA","e","hmt","hist","s","53"), ("2026","UK","LCREC","e","hmt","hist","s","2040"), ("2026","UK","LCEDE","e","hmt","hist","s","3694"), ("2026","UK","LCSOP","e","hmt","hist","s","599"), ("2026","UK","LCAAJ","e","hmt","hist","s","-1334"), ("2026","UK","LCTOT","e","hmt","hist","s","24692"), ("2026","UK","LCEEP","e","hmt","hist","s","0"), ("2027","UK","LKPCS","g","hmt","hist","s","6184"), ("2027","UK","LKPSI","g","hmt","hist","s","1167"), ("2027","UK","LKDEF","g","hmt","hist","s","64"), ("2027","UK","LKPOS","g","hmt","hist","s","23213"), ("2027","UK","LKEED","g","hmt","hist","s","1225"), ("2027","UK","LKAFF","g","hmt","hist","s","152"), ("2027","UK","LKTRA","g","hmt","hist","s","5247"), ("2027","UK","LKENV","g","hmt","hist","s","8347"), ("2027","UK","LKHOU","g","hmt","hist","s","3883"), ("2027","UK","LKHEA","g","hmt","hist","s","4277"), ("2027","UK","LKREC","g","hmt","hist","s","3493"), ("2027","UK","LKEDE","g","hmt","hist","s","59690"), ("2027","UK","LKSOP","g","hmt","hist","s","68326"), ("2027","UK","LKAAJ","g","hmt","hist","s","51315"), ("2027","UK","LKTOT","g","hmt","hist","s","235842"), ("2027","UK","LCPCS","g","hmt","hist","s","1866"), ("2027","UK","LCPOS","g","hmt","hist","s","1282"), ("2027","UK","LCEED","g","hmt","hist","s","878"), ("2027","UK","LCAFF","g","hmt","hist","s","404"), ("2027","UK","LCTRA","g","hmt","hist","s","10453"), ("2027","UK","LCENV","g","hmt","hist","s","1189"), ("2027","UK","LCHOU","g","hmt","hist","s","5144"), ("2027","UK","LCHEA","g","hmt","hist","s","58"), ("2027","UK","LCREC","g","hmt","hist","s","2040"), ("2027","UK","LCEDE","g","hmt","hist","s","3694"), ("2027","UK","LCSOP","g","hmt","hist","s","599"), ("2027","UK","LCAAJ","g","hmt","hist","s","-1334"), ("2027","UK","LCTOT","g","hmt","hist","s","24692"), ("2027","UK","LCEEP","g","hmt","hist","s","0"), ("2028","UK","LKPCS","g","hmt","hist","s","6574"), ("2028","UK","LKPSI","g","hmt","hist","s","1203"), ("2028","UK","LKDEF","g","hmt","hist","s","64"), ("2028","UK","LKPOS","g","hmt","hist","s","24358"), ("2028","UK","LKEED","g","hmt","hist","s","1225"), ("2028","UK","LKAFF","g","hmt","hist","s","161"), ("2028","UK","LKTRA","g","hmt","hist","s","5655"), ("2028","UK","LKENV","g","hmt","hist","s","8791"), ("2028","UK","LKHOU","g","hmt","hist","s","4271"), ("2028","UK","LKHEA","g","hmt","hist","s","4325"), ("2028","UK","LKREC","g","hmt","hist","s","3493"), ("2028","UK","LKEDE","g","hmt","hist","s","61459"), ("2028","UK","LKSOP","g","hmt","hist","s","68326"), ("2028","UK","LKAAJ","g","hmt","hist","s","56447"), ("2028","UK","LKTOT","g","hmt","hist","s","244491"), ("2028","UK","LCPCS","g","hmt","hist","s","1866"), ("2028","UK","LCPOS","g","hmt","hist","s","1293"), ("2028","UK","LCEED","g","hmt","hist","s","966"), ("2028","UK","LCAFF","g","hmt","hist","s","428"), ("2028","UK","LCTRA","g","hmt","hist","s","11499"), ("2028","UK","LCENV","g","hmt","hist","s","1234"), ("2028","UK","LCHOU","g","hmt","hist","s","5658"), ("2028","UK","LCHEA","g","hmt","hist","s","64"), ("2028","UK","LCREC","g","hmt","hist","s","2040"), ("2028","UK","LCEDE","g","hmt","hist","s","3694"), ("2028","UK","LCSOP","g","hmt","hist","s","599"), ("2028","UK","LCAAJ","g","hmt","hist","s","-1334"), ("2028","UK","LCTOT","g","hmt","hist","s","24692"), ("2028","UK","LCEEP","g","hmt","hist","s","0"), ("2029","UK","LKPCS","g","hmt","hist","s","6988"), ("2029","UK","LKPSI","g","hmt","hist","s","1240"), ("2029","UK","LKDEF","g","hmt","hist","s","64"), ("2029","UK","LKPOS","g","hmt","hist","s","25560"), ("2029","UK","LKEED","g","hmt","hist","s","1225"), ("2029","UK","LKAFF","g","hmt","hist","s","171"), ("2029","UK","LKTRA","g","hmt","hist","s","6094"), ("2029","UK","LKENV","g","hmt","hist","s","9258"), ("2029","UK","LKHOU","g","hmt","hist","s","4698"), ("2029","UK","LKHEA","g","hmt","hist","s","4373"), ("2029","UK","LKREC","g","hmt","hist","s","3493"), ("2029","UK","LKEDE","g","hmt","hist","s","63279"), ("2029","UK","LKSOP","g","hmt","hist","s","68326"), ("2029","UK","LKAAJ","g","hmt","hist","s","62091"), ("2029","UK","LKTOT","g","hmt","hist","s","253458"), ("2029","UK","LCPCS","g","hmt","hist","s","1866"), ("2029","UK","LCPOS","g","hmt","hist","s","1305"), ("2029","UK","LCEED","g","hmt","hist","s","1062"), ("2029","UK","LCAFF","g","hmt","hist","s","453"), ("2029","UK","LCTRA","g","hmt","hist","s","12648"), ("2029","UK","LCENV","g","hmt","hist","s","1281"), ("2029","UK","LCHOU","g","hmt","hist","s","6224"), ("2029","UK","LCHEA","g","hmt","hist","s","71"), ("2029","UK","LCREC","g","hmt","hist","s","2040"), ("2029","UK","LCEDE","g","hmt","hist","s","3694"), ("2029","UK","LCSOP","g","hmt","hist","s","599"), ("2029","UK","LCAAJ","g","hmt","hist","s","-1334"), ("2029","UK","LCTOT","g","hmt","hist","s","24692"), ("2029","UK","LCEEP","g","hmt","hist","s","0")

Done