return to Menu
0 secs
US
B74 85062682 2026 928553270 2025 850626820
B74
B78 0 2026 0 2025 0
A01 263825.3 2026 2879862 2025 2638253
A18 14658752.8 2026 159995222 2025 146587528
A36 13205400.9 2026 144148437 2025 132054009
A44 1727546.6 2026 18857841 2025 17275466
A50 50716.95003861 2026 1124256 2025 1103834
A59 499502 2026 5452489 2025 4995020
A60 3394.8 2026 36462 2025 33948
A61 265109.2 2026 2893918 2025 2651092
A80 142330.9 2026 1553618 2025 1423309
A81 946.18495127781 2026 118720 2025 121205
A87 320246 2026 3485241 2025 3202460
A89 2596300.1 2026 27988461 2025 25963001
A90 1330810.5 2026 14537894 2025 13308105
A91 45096.6 2026 492211 2025 450966
A92 1319126.9 2026 14399186 2025 13191269
A93 569.78277309379 2026 8996 2025 8660
A94 340536.6 2026 3716994 2025 3405366
B01 244933.62025582 2026 5006005 2025 4894961
B21 11864968.6 2026 129518867 2025 118649686
B22 634583.61785727 2026 9768124 2025 9386552
B30 3730289.8621918 2026 93300904 2025 92109955
B42 7605025 2026 83017000 2025 76050250
B46 6531417.1 2026 71297919 2025 65314171
B50 3448082.3975271 2026 57233785 2025 55282374
B54 114631 2026 1251330 2025 1146310
B59 2117166.7920702 2026 34132637 2025 32904842
B62 744325.8 2026 8125165 2025 7443258
B66 596310.9 2026 6509367 2025 5963109
B79 7206938 2026 78671910 2025 72069380
B80 597487 2026 6522230 2025 5974870
B89 30731.58591469 2026 550529 2025 534322
B92 77604.244216636 2026 1131023 2025 1082497
B93 9104 2026 99380 2025 91040
B94 4820598 2026 52622380 2025 48205980
D49 113734063.7 2026 1222893713 2025 1137340637
D64 1393538.1 2026 15211475 2025 13935381
E00 304172306.3 2026 3320901957 2025 3041723063
I89 3779668.5210559 2026 41086053 2025 38312137
M00 -143432401 2026 -1552677293 2025 -1434324010
O99 507969.95859034 2026 63465123 2025 64791276
Q79 117049261.6 2026 1277722175 2025 1170492616
R00 208117878.58405 2026 2469924230 2025 2323273324
R01 2350410.4352126 2026 60888230 2025 60199415
R02 34431385.2 2026 374640318 2025 344313852
R03 1694214.1 2026 18491414 2025 16942141
R95 45891396.7 2026 501587719 2025 458913967
R98 1287433.6 2026 14075487 2025 12874336
R99 577732.77876395 2026 47644274 2025 48433110
S01 320447.3 2026 3500746 2025 3204473
S03 1586541.9 2026 17082933 2025 15865419
S04 7581821 2026 82764147 2025 75818210
S05 5442609.7 2026 69023008 2025 54426097
2027x46901x-0.023811010510979
S11 38067763.1 2026 415498591 2025 380677631
S12 2324412.8 2026 25373185 2025 23244128
S14 991563.1 2026 10838899 2025 9915631
S16 37879041.6 2026 413493458 2025 378790416
S21 5367108.8888007 2026 84028608 2025 80842819
S22 200549.01163134 2026 4961237 2025 4895601
S23 6402994.8 2026 69893606 2025 64029948
S24 0 2026 0 2025 0
S25 3815403.5 2026 41648888 2025 38154035
S29 1279257.6 2026 13964641 2025 12792576
S31 631640.9 2026 6894543 2025 6316409
S32 5071200.2527975 2026 74752043 2025 71605739
S36 15980085.8 2026 174437236 2025 159800858
S44 17160078.8 2026 187317243 2025 171600788
S50 1849889.2 2026 20201426 2025 18498892
S52 65362.1 2026 713501 2025 653621
S53 1132137.6 2026 12357045 2025 11321376
S59 3848841.6 2026 42012328 2025 38488416
S60 2258.9 2026 24658 2025 22589
S61 983600.6 2026 10736666 2025 9836006
S62 2651242.5 2026 28941393 2025 26512425
S66 1476848.7 2026 16119472 2025 14768487
S72 0 2026 0 2025 0
S73 0 2026 0 2025 0
S74 101832857.6 2026 1111618292 2025 1018328576
S77 315851.3 2026 3448730 2025 3158513
S79 15216404 2026 166103883 2025 152164040
S80 95944.668135949 2026 1566947 2025 1511897
S81 167392.9 2026 1827166 2025 1673929
S85 210917.8 2026 2302304 2025 2109178
S87 421354.1 2026 4599161 2025 4213541
S89 10077902.9 2026 110041734 2025 100779029
S90 1125926.6 2026 12288810 2025 11259266
S91 74162.8 2026 809536 2025 741628
S92 1366811.3 2026 14920068 2025 13668113
S93 2466.8 2026 26938 2025 24668
S94 2485447.1 2026 27131564 2025 24854471
S95 39960935.2 2026 433486300 2025 399609352
T00 363803184.16146 2026 4022601523 2025 3757597334
T01 2736266.3 2026 29868990 2025 27362663
T09 54521360.2 2026 595149419 2025 545213602
T10 954324.4 2026 10425781 2025 9543244
T13 6150237.6 2026 67248312 2025 61502376
T15 1579806.9 2026 17245420 2025 15798069
T16 889385.97755312 2026 16655314 2025 16207468
T19 1097866.4055407 2026 56798275 2025 57308006
T24 3918379.2 2026 42773319 2025 39183792
T40 16102752.154262 2026 434726803 2025 430523144
T41 11720878.840128 2026 151088964 2025 143181270
U01 2235.8 2026 24406 2025 22358
U11 67519.544027263 2026 1554390 2025 1528893
U20 5993081.8 2026 65470183 2025 59930818
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","B74","g","hist","s","1013615952","1013615952","0"),
("2027","US","B78","g","hist","s","0","0","0"),
("2027","US","A01","g","hist","r","53632056","3143687","50488369"),
("2027","US","A18","g","hist","r","219686355","174653975","45032380"),
("2027","US","A36","g","hist","r","344781217","157353838","187427379"),
("2027","US","A44","g","hist","r","36470559","20585388","15885171"),
("2027","US","A50","g","hist","r","11715397","1174973","10540424"),
("2027","US","A59","g","hist","r","10542062","5951991","4590071"),
("2027","US","A60","g","hist","r","6629447","39857","6589590"),
("2027","US","A61","g","hist","r","24977556","3159027","21818529"),
("2027","US","A80","g","hist","r","123660221","1695949","121964272"),
("2027","US","A81","g","hist","r","36335161","119666","36215495"),
("2027","US","A87","g","hist","r","14163916","3805487","10358429"),
("2027","US","A89","g","hist","r","130544521","30584761","99959760"),
("2027","US","A90","g","hist","r","18894516","15868705","3025811"),
("2027","US","A91","g","hist","r","135084550","537308","134547242"),
("2027","US","A92","g","hist","r","172341546","15718313","156623233"),
("2027","US","A93","g","hist","r","17027179","9566","17017613"),
("2027","US","A94","g","hist","r","21354174","4057531","17296643"),
("2027","US","B01","g","hist","s","5250939","5250939","0"),
("2027","US","B21","g","hist","s","141383836","141383836","0"),
("2027","US","B22","g","hist","s","10402708","10402708","0"),
("2027","US","B30","g","hist","s","97031194","97031194","0"),
("2027","US","B42","g","hist","s","90622025","90622025","0"),
("2027","US","B46","g","hist","s","77829336","77829336","0"),
("2027","US","B50","g","hist","s","60681867","60681867","0"),
("2027","US","B54","g","hist","s","1365961","1365961","0"),
("2027","US","B59","g","hist","s","36249804","36249804","0"),
("2027","US","B62","g","hist","s","8869491","8869491","0"),
("2027","US","B66","g","hist","s","7105678","7105678","0"),
("2027","US","B79","g","hist","s","85878848","85878848","0"),
("2027","US","B80","g","hist","s","7119717","7119717","0"),
("2027","US","B89","g","hist","s","581261","581261","0"),
("2027","US","B92","g","hist","s","1208627","1208627","0"),
("2027","US","B93","g","hist","s","108484","108484","0"),
("2027","US","B94","g","hist","s","57442978","57442978","0"),
("2027","US","D49","g","hist","s","4297943757","1336627777","2961315980"),
("2027","US","D64","g","hist","s","45194159","16605013","28589146"),
("2027","US","E00","g","hist","s","7827455374","3625074263","4202381111"),
("2027","US","I89","g","hist","s","137391717","44865722","92525995"),
("2027","US","M00","g","hist","r","-1696109694","-1696109694","0"),
("2027","US","O99","g","hist","r","118840960","63973093","54867867"),
("2027","US","Q79","g","hist","","1503671759","1394771437","108900322"),
("2027","US","R00","g","hist","r","5187668466","2678042109","2509626357"),
("2027","US","R01","g","hist","r","63382370","63238640","143730"),
("2027","US","R02","g","hist","r","471347124","409071703","62275421"),
("2027","US","R03","g","hist","r","20185628","20185628","0"),
("2027","US","R95","g","hist","r","610062155","547479116","62583039"),
("2027","US","R98","g","hist","r","15362921","15362921","0"),
("2027","US","R99","g","hist","r","59268561","48222007","11046554"),
("2027","US","S01","g","hist","s","54609191","3821193","50787998"),
("2027","US","S03","g","hist","s","23554926","18669475","4885451"),
("2027","US","S04","g","hist","s","145182677","90345968","54836709"),
("2027","US","S05","g","hist","s","74604710","72692516.387095","139092"),
("2027","US","S11","g","hist","s","557279148","453566354","103712794"),
("2027","US","S12","g","hist","s","1521149967","27697598","1493452369"),
("2027","US","S14","g","hist","s","11830462","11830462","0"),
("2027","US","S16","g","hist","s","522859399","451372500","71486899"),
("2027","US","S21","g","hist","s","96847334","89395717","7451617"),
("2027","US","S22","g","hist","s","5262825","5161786","101039"),
("2027","US","S23","g","hist","s","145416691","76296601","69120090"),
("2027","US","S24","g","hist","s","111481178","0","111481178"),
("2027","US","S25","g","hist","s","96494915","45464292","51030623"),
("2027","US","S29","g","hist","s","76802821","15243899","61558922"),
("2027","US","S31","g","hist","s","29857611","7526184","22331427"),
("2027","US","S32","g","hist","s","202779335","79823243","122956092"),
("2027","US","S36","g","hist","s","428936369","190417322","238519047"),
("2027","US","S44","g","hist","s","362238042","204477322","157760720"),
("2027","US","S50","g","hist","s","115032466","22051315","92981151"),
("2027","US","S52","g","hist","s","23706522","778863","22927659"),
("2027","US","S53","g","hist","s","13489183","13489183","0"),
("2027","US","S59","g","hist","s","75410375","45861170","29549205"),
("2027","US","S60","g","hist","s","3072800","26917","3045883"),
("2027","US","S61","g","hist","s","102796461","11720267","91076194"),
("2027","US","S62","g","hist","s","241899434","31592636","210306798"),
("2027","US","S66","g","hist","s","30132109","17596321","12535788"),
("2027","US","S72","g","hist","s","0","0","0"),
("2027","US","S73","g","hist","s","0","0","0"),
("2027","US","S74","g","hist","s","1223252180","1213451150","9801030"),
("2027","US","S77","g","hist","s","3764581","3764581","0"),
("2027","US","S79","g","hist","s","280419581","181320287","99099294"),
("2027","US","S80","g","hist","s","136807186","1662892","135144294"),
("2027","US","S81","g","hist","s","52887358","1994559","50892799"),
("2027","US","S85","g","hist","s","2513222","2513222","0"),
("2027","US","S87","g","hist","s","12813136","5020515","7792621"),
("2027","US","S89","g","hist","s","347555474","120119637","227435837"),
("2027","US","S90","g","hist","s","16271210","13414737","2856473"),
("2027","US","S91","g","hist","s","170308281","883699","169424582"),
("2027","US","S92","g","hist","s","177942890","16286879","161656011"),
("2027","US","S93","g","hist","s","15994756","29405","15965351"),
("2027","US","S94","g","hist","s","175369093","29617011","145752082"),
("2027","US","S95","g","hist","s","577466874","473447235","104019639"),
("2027","US","T00","g","hist","r","6896031064","4386404707","2509626357"),
("2027","US","T01","g","hist","r","1028768398","32605256","996163142"),
("2027","US","T09","g","hist","r","866490622","649670779","216819843"),
("2027","US","T10","g","hist","r","12634722","11380105","1254617"),
("2027","US","T13","g","hist","r","76270981","73398550","2872431"),
("2027","US","T15","g","hist","r","46004044","18825227","27178817"),
("2027","US","T16","g","hist","r","17947046","17544700","402346"),
("2027","US","T19","g","hist","r","94708572","57896141","36812431"),
("2027","US","T24","g","hist","r","49576168","46691698","2884470"),
("2027","US","T40","g","hist","r","518328809","450829555","67499254"),
("2027","US","T41","g","hist","r","179598354","162809843","16788511"),
("2027","US","U01","g","hist","r","23886493","26642","23859851"),
("2027","US","U11","g","hist","r","6942088","1621910","5320178"),
("2027","US","U20","g","hist","r","115519747","71463265","44056482")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","M00","g","hist","r","-1686773537","-1686773537","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","T00","g","hist","r","6849677578","4340051222","2509626356")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","R00","g","hist","r","5162904041","2653277685","2509626356")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","E00","g","hist","s","7820479933.3871","3618098819.3871","4202381114")
Done