return to Menu
0 secs
US
B74 77926450 2025 850626820 2024 779264500
B74
B78 0 2025 0 2024 0
A01 241609.2 2025 2638253 2024 2416092
A18 13407694 2025 146043586 2024 134076940
A36 12094428 2025 132054009 2024 120944280
A44 1582375.4 2025 17275466 2024 15823754
A50 2296.0562385645 2025 1094845 2024 1123200
A59 457468.7 2025 4995020 2024 4574687
A60 1972.9986692772 2025 33688 2024 32558
A61 242825.7 2025 2651092 2024 2428257
A80 130308.9 2025 1423309 2024 1303089
A81 -3511.5719125582 2025 121205 2024 128308
A87 232037.42141735 2025 3178267 2024 3023346
A89 1611868.3425061 2025 25764609 2024 24792050
A90 1218924.0284065 2025 13209694 2024 12297890
A91 41244.7 2025 448941 2024 412447
A92 1207916.6 2025 13191269 2024 12079166
A93 195.1871131489 2025 8591 2024 8627
A94 311627.9 2025 3405366 2024 3116279
B01 30838.132102669 2025 4855275 2024 4959277
B21 10869180.5 2025 118649686 2024 108691805
B22 229158.11758725 2025 9311872 2024 9332374
B30 -325686.99900566 2025 91355615 2024 94266100
B42 6966750 2025 76050250 2024 69667500
B46 5983748.3 2025 65314171 2024 59837483
B50 1051332.6097213 2025 54840052 2024 55274730
B54 105020 2025 1146310 2024 1050200
B59 692601.42759381 2025 32642124 2024 32830515
B62 681907.1 2025 7443258 2024 6819071
B66 546257.9 2025 5963109 2024 5462579
B79 6602530 2025 72069380 2024 66025300
B80 547360 2025 5974870 2024 5473600
B89 7485.9748570301 2025 530025 2024 537042
B92 30986.970785032 2025 1073923 2024 1071489
B93 8340 2025 91040 2024 83400
B94 4416400 2025 48205980 2024 44164000
D49 67409073.325486 2025 1128623097 2024 1089387452
D64 1276093.6 2025 13833265 2024 12760936
E00 279130092.8 2025 3041832663 2024 2791300928
I89 2161832.6742505 2025 38017570 2024 36810485
M00 -133252931.5 2025 -1432737393 2024 -1332529315
O99 -1874724.5725965 2025 64791276 2024 68585705
Q79 107229559 2025 1170492616 2024 1072295590
R00 140848936.24859 2025 2312380369 2024 2229110490
R01 -303135.16836491 2025 59705654 2024 61702841
R02 24870042.206513 2025 341712026 2024 325137251
R03 1549273.1 2025 16818165 2024 15492731
R95 39485735.512557 2025 455499111 2024 426737515
R98 1069557.2701863 2025 12778217 2024 12011514
R99 -1353363.7713697 2025 48274969 2024 51056387
S01 292058.593472 2025 3180764 2024 2962733
S03 964611.01266559 2025 15744016 2024 15171140
S04 6945936.5 2025 75818210 2024 69459365
S05 3991864.3 2025 58495505 2024 39918643
2026x53380x0.2779200880994
S11 34820959.9 2025 379507143 2024 348209599
S12 2129057.4 2025 23244128 2024 21290574
S14 766542.9259764 2025 9841123 2024 9310832
S16 34703041.5 2025 378790416 2024 347030415
S21 1872281.5826956 2025 80198782 2024 80482040
S22 -14952.712579018 2025 4855528 2024 5007738
S23 5863658.1 2025 64029948 2024 58636581
S24 0 2025 0 2024 0
S25 3494853.3 2025 38154035 2024 34948533
S29 1172064.8 2025 12792576 2024 11720648
S31 578133.7 2025 6316409 2024 5781337
S32 1985547.3626033 2025 71038023 2024 70944580
S36 14636378.1 2025 159800858 2024 146363781
S44 15716455 2025 171600788 2024 157164550
S50 1702534.2 2025 18362651 2024 17025342
S52 59879.8 2025 653621 2024 598798
S53 1035669.2 2025 11297093 2024 10356692
S59 3523911.8 2025 38488416 2024 35239118
S60 2068.7 2025 22589 2024 20687
S61 900660 2025 9836006 2024 9006600
S62 2428967.8 2025 26512425 2024 24289678
S66 1350985.3 2025 14734232 2024 13509853
S72 0 2025 0 2024 0
S73 0 2025 0 2024 0
S74 93289716.3 2025 1018328576 2024 932897163
S77 290217.1 2025 3135290 2024 2902171
S79 13939842.7 2025 152164040 2024 139398427
S80 30448.504685999 2025 1499815 2024 1509918
S81 153237.4 2025 1673929 2024 1532374
S85 193126.1 2025 2109178 2024 1931261
S87 385619.7 2025 4213541 2024 3856197
S89 9262704.7 2025 100037805 2024 92627047
S90 1029544 2025 11184230 2024 10295440
S91 67908.4 2025 741628 2024 679084
S92 1251955.4 2025 13668113 2024 12519554
S93 1879.1905254466 2025 24482 2024 23192
S94 2277092.9 2025 24854471 2024 22770929
S95 27533383.665289 2025 396578564 2024 378742360
T00 274301935.04662 2025 3745117762 2024 3561639805
T01 2506327 2025 27362663 2024 25063270
T09 49935816.7 2025 545213602 2024 499358167
T10 867819.43129796 2025 9472622 2024 8825367
T13 5033945.4958577 2025 61042572 2024 57459355
T15 1447351.4 2025 15798069 2024 14473514
T16 182943.13737561 2025 16076744 2024 16336028
T19 -1463624.5683599 2025 56828144 2024 59966023
T24 3589526.9 2025 38896550 2024 35895269
T40 -2896330.5028362 2025 426985869 2024 442035576
T41 5599970.8126966 2025 142059694 2024 140157742
U01 2047.8 2025 22358 2024 20478
U11 370.2725144052 2025 1516420 2024 1558651
U20 5477568.0831295 2025 59487545 2024 55393651
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2026","US","B74","g","hist","s","928553270","928553270","0"),
("2026","US","B78","g","hist","s","0","0","0"),
("2026","US","A01","g","hist","r","45373376","2879862","42493514"),
("2026","US","A18","g","hist","r","197414343","159451280","37963063"),
("2026","US","A36","g","hist","r","307344148","144148437","163195711"),
("2026","US","A44","g","hist","r","32644729","18857841","13786888"),
("2026","US","A50","g","hist","r","10316272","1097141","9219131"),
("2026","US","A59","g","hist","r","9371342","5452489","3918853"),
("2026","US","A60","g","hist","r","5581535","35661","5545874"),
("2026","US","A61","g","hist","r","21262529","2893918","18368611"),
("2026","US","A80","g","hist","r","105894426","1553618","104340808"),
("2026","US","A81","g","hist","r","31290842","117693","31173149"),
("2026","US","A87","g","hist","r","12140467","3410304","8730163"),
("2026","US","A89","g","hist","r","115002716","27376477","87626239"),
("2026","US","A90","g","hist","r","17058940","14428618","2630322"),
("2026","US","A91","g","hist","r","116242105","490186","115751919"),
("2026","US","A92","g","hist","r","146907964","14399186","132508778"),
("2026","US","A93","g","hist","r","14349027","8786","14340241"),
("2026","US","A94","g","hist","r","18270144","3716994","14553150"),
("2026","US","B01","g","hist","s","4886113","4886113","0"),
("2026","US","B21","g","hist","s","129518867","129518867","0"),
("2026","US","B22","g","hist","s","9541030","9541030","0"),
("2026","US","B30","g","hist","s","91029928","91029928","0"),
("2026","US","B42","g","hist","s","83017000","83017000","0"),
("2026","US","B46","g","hist","s","71297919","71297919","0"),
("2026","US","B50","g","hist","s","55891385","55891385","0"),
("2026","US","B54","g","hist","s","1251330","1251330","0"),
("2026","US","B59","g","hist","s","33334725","33334725","0"),
("2026","US","B62","g","hist","s","8125165","8125165","0"),
("2026","US","B66","g","hist","s","6509367","6509367","0"),
("2026","US","B79","g","hist","s","78671910","78671910","0"),
("2026","US","B80","g","hist","s","6522230","6522230","0"),
("2026","US","B89","g","hist","s","537511","537511","0"),
("2026","US","B92","g","hist","s","1104910","1104910","0"),
("2026","US","B93","g","hist","s","99380","99380","0"),
("2026","US","B94","g","hist","s","52622380","52622380","0"),
("2026","US","D49","g","hist","s","3780406613","1196032170","2584374443"),
("2026","US","D64","g","hist","s","41369700","15109359","26260341"),
("2026","US","E00","g","hist","s","6913438795","3320962756","3592476039"),
("2026","US","I89","g","hist","s","121496494","40179403","81317091"),
("2026","US","M00","g","hist","r","-1565990325","-1565990325","0"),
("2026","US","O99","g","hist","r","114698911","62916551","51782360"),
("2026","US","Q79","g","hist","","1371822270","1277722175","94100095"),
("2026","US","R00","g","hist","r","4621109163","2453229305","2167879858"),
("2026","US","R01","g","hist","r","59537245","59402519","134726"),
("2026","US","R02","g","hist","r","419196558","366582068","52614490"),
("2026","US","R03","g","hist","r","18367438","18367438","0"),
("2026","US","R95","g","hist","r","547854390","494984847","52869543"),
("2026","US","R98","g","hist","r","13847774","13847774","0"),
("2026","US","R99","g","hist","r","57826996","46921605","10905391"),
("2026","US","S01","g","hist","s","46914788","3472823","43441965"),
("2026","US","S03","g","hist","s","20881874","16708627","4173247"),
("2026","US","S04","g","hist","s","129928374","82764147","47164227"),
("2026","US","S05","g","hist","s","62607174","79853864.09758","119805"),
("2026","US","S11","g","hist","s","504372660","414328103","90044557"),
("2026","US","S12","g","hist","s","1299085248","25373185","1273712063"),
("2026","US","S14","g","hist","s","10607666","10607666","0"),
("2026","US","S16","g","hist","s","475504133","413493458","62010675"),
("2026","US","S21","g","hist","s","88390879","82071064","6319815"),
("2026","US","S22","g","hist","s","4926686","4840575","86111"),
("2026","US","S23","g","hist","s","128918982","69893606","59025376"),
("2026","US","S24","g","hist","s","95555165","0","95555165"),
("2026","US","S25","g","hist","s","85179945","41648888","43531057"),
("2026","US","S29","g","hist","s","67011090","13964641","53046449"),
("2026","US","S31","g","hist","s","26155905","6894543","19261362"),
("2026","US","S32","g","hist","s","179367898","73023570","106344328"),
("2026","US","S36","g","hist","s","379515488","174437236","205078252"),
("2026","US","S44","g","hist","s","321364088","187317243","134046845"),
("2026","US","S50","g","hist","s","100488109","20065185","80422924"),
("2026","US","S52","g","hist","s","20432868","713501","19719367"),
("2026","US","S53","g","hist","s","12332762","12332762","0"),
("2026","US","S59","g","hist","s","66934262","42012328","24921934"),
("2026","US","S60","g","hist","s","2688227","24658","2663569"),
("2026","US","S61","g","hist","s","87537622","10736666","76800956"),
("2026","US","S62","g","hist","s","208983531","28941393","180042138"),
("2026","US","S66","g","hist","s","26809925","16085217","10724708"),
("2026","US","S72","g","hist","s","0","0","0"),
("2026","US","S73","g","hist","s","0","0","0"),
("2026","US","S74","g","hist","s","1120087300","1111618292","8469008"),
("2026","US","S77","g","hist","s","3425507","3425507","0"),
("2026","US","S79","g","hist","s","251734968","166103883","85631085"),
("2026","US","S80","g","hist","s","116026799","1530264","114496535"),
("2026","US","S81","g","hist","s","45364400","1827166","43537234"),
("2026","US","S85","g","hist","s","2302304","2302304","0"),
("2026","US","S87","g","hist","s","11213664","4599161","6614503"),
("2026","US","S89","g","hist","s","305209685","109300510","195909175"),
("2026","US","S90","g","hist","s","14667878","12213774","2454104"),
("2026","US","S91","g","hist","s","143848355","809536","143038819"),
("2026","US","S92","g","hist","s","151532429","14920068","136612361"),
("2026","US","S93","g","hist","s","13485637","26361","13459276"),
("2026","US","S94","g","hist","s","149811517","27131564","122679953"),
("2026","US","S95","g","hist","s","514399475","424111948","90287527"),
("2026","US","T00","g","hist","r","6187299555","4019419697","2167879858"),
("2026","US","T01","g","hist","r","891847414","29868990","861978424"),
("2026","US","T09","g","hist","r","781208677","595149419","186059258"),
("2026","US","T10","g","hist","r","11434121","10340441","1093680"),
("2026","US","T13","g","hist","r","68574305","66076517","2497788"),
("2026","US","T15","g","hist","r","40561123","17245420","23315703"),
("2026","US","T16","g","hist","r","16617455","16259687","357768"),
("2026","US","T19","g","hist","r","86897573","55364519","31533054"),
("2026","US","T24","g","hist","r","45047720","42486077","2561643"),
("2026","US","T40","g","hist","r","482822382","424089538","58732844"),
("2026","US","T41","g","hist","r","162250804","147659665","14591139"),
("2026","US","U01","g","hist","r","20671178","24406","20646772"),
("2026","US","U11","g","hist","r","6186076","1516790","4669286"),
("2026","US","U20","g","hist","r","103224231","64965113","38259118")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2026","US","M00","g","hist","r","-1547879888","-1547879888","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2026","US","T00","g","hist","r","6155162774","3987282916","2167879858")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2026","US","R00","g","hist","r","4607282886","2439403028","2167879858")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2026","US","E00","g","hist","s","6916643274.0976","3324167235.0976","3592476039")
Done