return to Menu
0 secs
US
B74 71362320 2024 779264500 2023 713623200
B74
B78 0 2024 0 2023 0
A01 222160.6 2024 2437026 2023 2221606
A18 6954843.180525 2024 128940253 2023 125105877
A36 11109729.2 2024 127199502 2023 111097292
A44 934954.24156515 2024 15093166 2023 14517119
A50 29800.282592388 2024 1182804 2023 1183418
A59 269088.54350248 2024 4368462 2023 4203333
A60 2926.1331781052 2024 34399 2023 32249
A61 222834.9 2024 2469541 2023 2228349
A80 66453.343861529 2024 1238654 2023 1202196
A81 -5768.9055603709 2024 132415 2023 142068
A87 -85991.163121897 2024 2776431 2023 2942022
A89 2434950.4315988 2024 26290881 2023 24438674
A90 319570.43114123 2024 11690899 2023 11670628
A91 19930.463236677 2024 395471 2023 385185
A92 -556051.35 2024 9619833 2023 11121027
A93 889.8 2024 11504 2023 8898
A94 289087.2 2024 3298985 2023 2890872
B01 -134698.73214877 2024 4927815 2023 5202850
B21 9957880.5 2024 108691805 2023 99578805
B22 -77179.639502009 2024 9274284 2023 9606300
B30 -2910485.2611825 2024 94266100 2023 99878700
B42 6382750 2024 69667500 2023 63827500
B46 5476688.3 2024 59837483 2023 54766883
B50 -772324.13268721 2024 54928670 2023 57226900
B54 96110 2024 1050200 2023 961100
B59 -388502.5423103 2024 32625417 2023 33916550
B62 624187.1 2024 6819071 2023 6241871
B66 500530 2024 5432311 2023 5005300
B79 6044080 2024 66025300 2023 60440800
B80 501270 2024 5473600 2023 5012700
B89 -10315.019835054 2024 533662 2023 558950
B92 -4043.8911827279 2024 1064850 2023 1097900
B93 7640 2024 83400 2023 76400
B94 4041980 2024 44164000 2023 40419800
D49 39499631.897694 2024 1089658017 2023 1077543532
D64 786081.80799543 2024 12467556 2023 11977221
E00 180566098.92124 2024 2336248950 2023 2209350948
I89 3514607.3570223 2024 39175506 2023 36535215
M00 -111715106.9 2024 -1096510238 2023 -1117151069
O99 7588857.9 2024 85958616 2023 75888579
Q79 60346417.131243 2024 1017967232 2023 981970262
R00 -152150497.65 2024 2036999215 2023 3043009953
R01 4488098.4779902 2024 68349727 2023 65473572
R02 31648174.8 2024 606929568 2023 316481748
R03 -148906.48509101 2024 13981653 2023 14516457
R95 40800102.4 2024 704035542 2023 408001024
R98 1152924.7 2024 14774594 2023 11529247
R99 -480459.16698553 2024 53671346 2023 55628352
S01 281333.8 2024 3371976 2023 2813338
S03 -748916.8 2024 2426829 2023 14978336
S04 6358844.6 2024 71331887 2023 63588446
S05 2687695.8 2024 36059137 2023 26876958
2025x52553x0.37292962014734
S11 19885178.57023 2024 336512860 2023 324680315
S12 1953554.1 2024 24427229 2023 19535541
S14 404312.59476506 2024 9181714 2023 9004393
S16 31760001.2 2024 347208939 2023 317600012
S21 8295642 2024 89940880 2023 82956420
S22 530336.7 2024 6861297 2023 5303367
S23 5393367.1 2024 61822402 2023 53933671
S24 0 2024 0 2023 0
S25 -1509178.4741 2024 29664299 2023 32055023
S29 1071927.6 2024 12319001 2023 10719276
S31 535072.2 2024 5901149 2023 5350722
S32 -730595.2777249 2024 70100008 2023 72764542
S36 13437076.6 2024 153190844 2023 134370766
S44 14436237.5 2024 159257012 2023 144362375
S50 -389214.18270769 2024 15255797 2023 16078009
S52 36101.992297166 2024 570793 2023 548225
S53 964683.9 2024 11599771 2023 9646839
S59 3249297.7 2024 36062370 2023 32492977
S60 551.89810521892 2024 19081 2023 19016
S61 829405.7 2024 9466478 2023 8294057
S62 2222746.7 2024 24362222 2023 22227467
S66 1258633.6 2024 15162648 2023 12586336
S67 970394.72359047 2024 16369316 2023 15790470
S72 0 2024 0 2023 0
S73 0 2024 0 2023 0
S74 53904930.542412 2024 909307546 2023 877152958
S77 216979.71433431 2024 2885630 2023 2735257
S79 5471092.8152405 2024 92290370 2023 89026833
S80 156138.1 2024 1907053 2023 1561381
S81 -70777.25 2024 1244048 2023 1415545
S85 -88958.3 2024 1389844 2023 1779166
S87 47473.994582775 2024 3528015 2023 3573439
S89 4623477.4515623 2024 89770313 2023 87330861
S90 450965.3981525 2024 9846706 2023 9638258
S91 62543.6 2024 796266 2023 625436
S92 -480178.17204817 2024 10691051 2023 11485585
S93 -1123.05 2024 18769 2023 22461
S94 882158.97815276 2024 21191006 2023 20835417
S95 32092097.097307 2024 393353482 2023 370208505
T00 166103057.29213 2024 3158526145 2023 3069086563
T01 961593.72342552 2024 23374108 2023 22993934
T09 19160879.864114 2024 466119937 2023 458554354
T10 207980.49707719 2024 8375147 2023 8382682
T13 4378173.1764059 2024 58274120 2023 55241234
T15 917924.9828511 2024 13837624 2023 13245553
T16 -852534.05 2024 15629148 2023 17050681
T19 1860237.169776 2024 65088683 2023 64890520
T24 3370662.5 2024 165406390 2023 33706625
T40 46982990.2 2024 644732109 2023 469829902
T41 14194551.7 2024 479325719 2023 141945517
U01 1879.6 2024 26858 2023 18796
U11 -82262.5 2024 1393707 2023 1645250
U20 5258211.9 2024 80802749 2023 52582119
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","B74","g","hist","s","850626820","850626820","0"),
("2025","US","B78","g","hist","s","0","0","0"),
("2025","US","A01","g","hist","r","37533313","2659187","34874126"),
("2025","US","A18","g","hist","r","161338005","135895096","25442909"),
("2025","US","A36","g","hist","r","260424915","138309231","122115684"),
("2025","US","A44","g","hist","r","30883988","16028120","14855868"),
("2025","US","A50","g","hist","r","9210346","1212604","7997742"),
("2025","US","A59","g","hist","r","6881780","4637551","2244229"),
("2025","US","A60","g","hist","r","3290827","37325","3253502"),
("2025","US","A61","g","hist","r","15612747","2692376","12920371"),
("2025","US","A80","g","hist","r","76929048","1305107","75623941"),
("2025","US","A81","g","hist","r","22824249","126646","22697603"),
("2025","US","A87","g","hist","r","8474282","2690440","5783842"),
("2025","US","A89","g","hist","r","130249129","28725831","101523298"),
("2025","US","A90","g","hist","r","15501225","12010469","3490756"),
("2025","US","A91","g","hist","r","92585649","415401","92170248"),
("2025","US","A92","g","hist","r","94027965","9063782","84964183"),
("2025","US","A93","g","hist","r","7202883","12394","7190489"),
("2025","US","A94","g","hist","r","14757836","3588072","11169764"),
("2025","US","B01","g","hist","s","4793116","4793116","0"),
("2025","US","B21","g","hist","s","118649686","118649686","0"),
("2025","US","B22","g","hist","s","9197104","9197104","0"),
("2025","US","B30","g","hist","s","91355615","91355615","0"),
("2025","US","B42","g","hist","s","76050250","76050250","0"),
("2025","US","B46","g","hist","s","65314171","65314171","0"),
("2025","US","B50","g","hist","s","54156346","54156346","0"),
("2025","US","B54","g","hist","s","1146310","1146310","0"),
("2025","US","B59","g","hist","s","32236914","32236914","0"),
("2025","US","B62","g","hist","s","7443258","7443258","0"),
("2025","US","B66","g","hist","s","5932841","5932841","0"),
("2025","US","B79","g","hist","s","72069380","72069380","0"),
("2025","US","B80","g","hist","s","5974870","5974870","0"),
("2025","US","B89","g","hist","s","523347","523347","0"),
("2025","US","B92","g","hist","s","1060806","1060806","0"),
("2025","US","B93","g","hist","s","91040","91040","0"),
("2025","US","B94","g","hist","s","48205980","48205980","0"),
("2025","US","D49","g","hist","s","3295460133","1129157649","2166302484"),
("2025","US","D64","g","hist","s","58345138","13253638","45091500"),
("2025","US","E00","g","hist","s","5357227281","2516815049","2840412232"),
("2025","US","I89","g","hist","s","120285401","42690113","77595288"),
("2025","US","M00","g","hist","r","-2071868599","-1208225345","-863643254"),
("2025","US","O99","g","hist","r","181368364","93547474","87820890"),
("2025","US","Q79","g","hist","","1158230035","1078313649","79916386"),
("2025","US","R00","g","hist","r","3388507840","1884848717","1503659123"),
("2025","US","R01","g","hist","r","72975116","72837825","137291"),
("2025","US","R02","g","hist","r","759132381","638577743","120554638"),
("2025","US","R03","g","hist","r","13832747","13832747","0"),
("2025","US","R95","g","hist","r","865560110","744835644","120724466"),
("2025","US","R98","g","hist","r","15927519","15927519","0"),
("2025","US","R99","g","hist","r","75452383","53190887","22261496"),
("2025","US","S01","g","hist","s","44270983","3653310","40617673"),
("2025","US","S03","g","hist","s","3708284","1677912","2030372"),
("2025","US","S04","g","hist","s","115596206","77690732","37905474"),
("2025","US","S05","g","hist","s","38875384","53196674.712603","128551"),
("2025","US","S11","g","hist","s","433506992","356398039","77108953"),
("2025","US","S12","g","hist","s","1068488727","26380783","1042107944"),
("2025","US","S14","g","hist","s","9586027","9586027","0"),
("2025","US","S16","g","hist","s","433859199","378968940","54890259"),
("2025","US","S21","g","hist","s","102075572","98236522","3839050"),
("2025","US","S22","g","hist","s","7450290","7391634","58656"),
("2025","US","S23","g","hist","s","117743785","67215769","50528016"),
("2025","US","S24","g","hist","s","81239657","0","81239657"),
("2025","US","S25","g","hist","s","63385985","28155121","35230864"),
("2025","US","S29","g","hist","s","59364771","13390929","45973842"),
("2025","US","S31","g","hist","s","22631299","6436221","16195078"),
("2025","US","S32","g","hist","s","168225802","69369413","98856389"),
("2025","US","S36","g","hist","s","308736514","166627921","142108593"),
("2025","US","S44","g","hist","s","280448593","173693250","106755343"),
("2025","US","S50","g","hist","s","91761969","14866583","76895386"),
("2025","US","S52","g","hist","s","19080061","606895","18473166"),
("2025","US","S53","g","hist","s","12564455","12564455","0"),
("2025","US","S59","g","hist","s","57103394","39311668","17791726"),
("2025","US","S60","g","hist","s","2411165","19633","2391532"),
("2025","US","S61","g","hist","s","70825419","10295884","60529535"),
("2025","US","S62","g","hist","s","174503411","26584969","147918442"),
("2025","US","S66","g","hist","s","25736160","16421282","9314878"),
("2025","US","S67","g","hist","s","32364222","17339711","15024511"),
("2025","US","S72","g","hist","s","0","0","0"),
("2025","US","S73","g","hist","s","0","0","0"),
("2025","US","S74","g","hist","s","970374645","963212477","7162168"),
("2025","US","S77","g","hist","s","3102610","3102610","0"),
("2025","US","S79","g","hist","s","155491168","97761463","57729705"),
("2025","US","S80","g","hist","s","90078852","2063191","88015661"),
("2025","US","S81","g","hist","s","35173087","1173271","33999816"),
("2025","US","S85","g","hist","s","1300886","1300886","0"),
("2025","US","S87","g","hist","s","9687305","3575489","6111816"),
("2025","US","S89","g","hist","s","282778394","94393790","188384604"),
("2025","US","S90","g","hist","s","11751855","10297671","1454184"),
("2025","US","S91","g","hist","s","104936495","858810","104077685"),
("2025","US","S92","g","hist","s","92866877","10210873","82656004"),
("2025","US","S93","g","hist","s","6564590","17646","6546944"),
("2025","US","S94","g","hist","s","103618462","22073165","81545297"),
("2025","US","S95","g","hist","s","502688454","425445579","77242875"),
("2025","US","T00","g","hist","r","6297048145","3324629202","2972418943"),
("2025","US","T01","g","hist","r","776237241","24335702","751901539"),
("2025","US","T09","g","hist","r","627792899","485280817","142512082"),
("2025","US","T10","g","hist","r","9336052","8583127","752925"),
("2025","US","T13","g","hist","r","65231032","62652293","2578739"),
("2025","US","T15","g","hist","r","31898731","14755549","17143182"),
("2025","US","T16","g","hist","r","15006463","14776614","229849"),
("2025","US","T19","g","hist","r","86413892","66948920","19464972"),
("2025","US","T24","g","hist","r","181975101","168777053","13198048"),
("2025","US","T40","g","hist","r","757468279","691715099","65753180"),
("2025","US","T41","g","hist","r","539548631","493520271","46028360"),
("2025","US","U01","g","hist","r","18409946","28738","18381208"),
("2025","US","U11","g","hist","r","5741018","1311445","4429573"),
("2025","US","U20","g","hist","r","156443630","86060961","70382669")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","M00","g","hist","r","-1431451755","-1431451755","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","T00","g","hist","r","6809371367","4797522171","2011849196")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","R00","g","hist","r","5377919612","3366070416","2011849196")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","E00","g","hist","s","5844902184.7126","2925709122.7126","2919193062")
Done