return to Menu
0 secs
US
B74 62359235 2024 779264500 2023 713623200
B74
B78 0 2024 0 2023 0
A01 169350.8 2024 2253476 2023 2075212
A18 11391726.45 2024 142716439 2023 130725148
A36 9354638.6 2024 117195541 2023 107348553
A44 1295316.45 2024 16173219 2023 14809728
A50 122265.95 2024 1527918 2023 1399217
A59 352786.3 2024 4396680 2023 4025326
A60 3104.6 2024 38748 2023 35480
A61 189912.6 2024 2351049 2023 2151141
A80 70988.75 2024 1257562 2023 1182837
A81 26143.05 2024 328036 2023 300517
A87 280855.15 2024 3485934 2023 3190297
A89 2059796.65 2024 28617289 2023 26449082
A90 991428.55 2024 13213015 2023 12169406
A91 32868.1 2024 429683 2023 395085
A92 910232.05 2024 11419362 2023 10461223
A93 -357.2 2024 8470 2023 8846
A94 212455.15 2024 2646228 2023 2422591
B01 -260142.5 2024 4927815 2023 5202850
B21 8657350 2024 108691805 2023 99578805
B22 -315415.2 2024 9274284 2023 9606300
B30 -4993935 2024 94266100 2023 99878700
B42 5548000 2024 69667500 2023 63827500
B46 4817070 2024 59837483 2023 54766883
B50 -2183318.5 2024 54928670 2023 57226900
B54 84645 2024 1050200 2023 961100
B59 -1226576.35 2024 32625417 2023 33916550
B62 548340 2024 6819071 2023 6241871
B66 405660.45 2024 5432311 2023 5005300
B79 5305275 2024 66025300 2023 60440800
B80 437855 2024 5473600 2023 5012700
B89 -24023.6 2024 533662 2023 558950
B92 -31397.5 2024 1064850 2023 1097900
B93 6650 2024 83400 2023 76400
B94 3556990 2024 44164000 2023 40419800
D49 -20951411.15 2024 1027440659 2023 1049494776
D64 -424350.75 2024 10344366 2023 10791051
E00 234435327.55 2024 2843928310 2023 2597154281
I89 -1039642 2024 34264186 2023 35358546
M00 -111715106.9 2024 -1331878586 2023 -1117151069
O99 12886559.05 2024 169593405 2023 156028606
Q79 34197121.5 2024 1017967232 2023 981970262
R00 -152150497.65 2024 2407226873 2023 3043009953
R01 -2105044.2 2024 68902890 2023 71118726
R02 -1446950.65 2024 24611261 2023 28939013
R03 515386.4 2024 14704566 2023 14162054
R95 4668396.9 2024 192279008 2023 187364906
R98 1084261.6 2024 13601525 2023 12460197
R99 8686734.45 2024 107567394 2023 98423463
S01 119194.6 2024 2931723 2023 2806255
S03 -84892.95 2024 1695344 2023 1784705
S04 5577373.05 2024 69669038 2023 63798119
S05 3611579.9 2024 56436921 2023 36115799
2025xx-1
S11 29138934.85 2024 364681310 2023 334008747
S12 979695.1 2024 19946410 2023 18915152
S14 853834.35 2024 10678227 2023 9779454
S16 27958882.85 2024 350220255 2023 320789852
S21 8396036.35 2024 104790890 2023 95952957
S22 37025.3 2024 5832632 2023 5793658
S23 4167805.8 2024 54646774 2023 50259610
S24 0 2024 0 2023 0
S25 2748834.5 2024 34374454 2023 31480944
S29 951303.4 2024 11928090 2023 10926718
S31 205196.2 2024 4627707 2023 4411711
S32 7329472.3 2024 91987706 2023 84272472
S36 11393364.25 2024 142556682 2023 130563667
S44 12162066.25 2024 150696685 2023 137894510
S50 1484568.8 2024 18431418 2023 16868714
S52 48044.35 2024 600421 2023 549848
S53 876599.2 2024 10881295 2023 9958559
S59 2608833.95 2024 32661542 2023 29915401
S60 1587.45 2024 19741 2023 18070
S61 676915.85 2024 8455032 2023 7742489
S62 1959100.45 2024 24497947 2023 22435736
S66 1143971.95 2024 14277231 2023 13073050
S67 1379843.65 2024 17256915 2023 15804448
S72 0 2024 0 2023 0
S73 0 2024 0 2023 0
S74 76649645.15 2024 958613228 2023 877929391
S77 142854.35 2024 2885630 2023 2735257
S79 7779572.8 2024 97294661 2023 89105637
S80 158517 2024 1983206 2023 1816346
S81 17646.25 2024 1174503 2023 1155928
S85 129627.5 2024 1756309 2023 1619859
S87 268620.1 2024 3373287 2023 3090529
S89 8048669.8 2024 99918906 2023 91446622
S90 768539.55 2024 10662454 2023 9853465
S91 32028.3 2024 590313 2023 556599
S92 982270.55 2024 12317489 2023 11283520
S93 -503.5 2024 20779 2023 21309
S94 -778321.7 2024 17176599 2023 17995885
S95 9313693.6 2024 383606577 2023 373802689
T00 306908656.3 2024 3739105459 2023 3069086563
T01 2051701.7 2024 25628044 2023 23468358
T09 40962248.2 2024 511270318 2023 468152162
T10 779141.55 2024 9776740 2023 8956591
T13 5204394.5 2024 65134203 2023 59655893
T15 1013150.3 2024 14228656 2023 13162182
T16 339683.9 2024 18612187 2023 18254625
T19 9356545.25 2024 117261857 2023 107412862
T24 3092051.45 2024 38836939 2023 35582148
T40 52809220.35 2024 661837326 2023 606248673
T41 11987041.1 2024 170199237 2023 157581299
U01 -529.15 2024 15238 2023 15795
U11 170268.5 2024 2114749 2023 1935519
U20 -980002.9 2024 25271689 2023 26303271
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","B74","g","hist","s","841623735","841623735","0"),
("2025","US","B78","g","hist","s","0","0","0"),
("2025","US","A01","g","hist","r","36580185","2422827","34157358"),
("2025","US","A18","g","hist","r","183449313","154108165","29341148"),
("2025","US","A36","g","hist","r","312562213","126550180","186012033"),
("2025","US","A44","g","hist","r","33104865","17468535","15636330"),
("2025","US","A50","g","hist","r","10817902","1650184","9167718"),
("2025","US","A59","g","hist","r","8233134","4749466","3483668"),
("2025","US","A60","g","hist","r","4445620","41853","4403767"),
("2025","US","A61","g","hist","r","17265202","2540962","14724240"),
("2025","US","A80","g","hist","r","85701953","1328551","84373402"),
("2025","US","A81","g","hist","r","27412939","354179","27058760"),
("2025","US","A87","g","hist","r","10356557","3766789","6589768"),
("2025","US","A89","g","hist","r","127989118","30677086","97312032"),
("2025","US","A90","g","hist","r","16981651","14204444","2777207"),
("2025","US","A91","g","hist","r","94405620","462551","93943069"),
("2025","US","A92","g","hist","r","116349482","12329594","104019888"),
("2025","US","A93","g","hist","r","11704547","8113","11696434"),
("2025","US","A94","g","hist","r","14647350","2858683","11788667"),
("2025","US","B01","g","hist","s","4667673","4667673","0"),
("2025","US","B21","g","hist","s","117349155","117349155","0"),
("2025","US","B22","g","hist","s","8958869","8958869","0"),
("2025","US","B30","g","hist","s","89272165","89272165","0"),
("2025","US","B42","g","hist","s","75215500","75215500","0"),
("2025","US","B46","g","hist","s","64654553","64654553","0"),
("2025","US","B50","g","hist","s","52745352","52745352","0"),
("2025","US","B54","g","hist","s","1134845","1134845","0"),
("2025","US","B59","g","hist","s","31398841","31398841","0"),
("2025","US","B62","g","hist","s","7367411","7367411","0"),
("2025","US","B66","g","hist","s","5837971","5837971","0"),
("2025","US","B79","g","hist","s","71330575","71330575","0"),
("2025","US","B80","g","hist","s","5911455","5911455","0"),
("2025","US","B89","g","hist","s","509638","509638","0"),
("2025","US","B92","g","hist","s","1033453","1033453","0"),
("2025","US","B93","g","hist","s","90050","90050","0"),
("2025","US","B94","g","hist","s","47720990","47720990","0"),
("2025","US","D49","g","hist","s","3040011569","1006489248","2033522321"),
("2025","US","D64","g","hist","s","40594064","9920015","30674049"),
("2025","US","E00","g","hist","s","6030072252","3078363638","2951708614"),
("2025","US","I89","g","hist","s","102088607","33224544","68864063"),
("2025","US","M00","g","hist","r","-1443593693","-1443593693","0"),
("2025","US","O99","g","hist","r","278345243","182479964","95865279"),
("2025","US","Q79","g","hist","","1133034348","1052164354","80869994"),
("2025","US","R00","g","hist","r","4296854892","2255076375","2041778517"),
("2025","US","R01","g","hist","r","66877447","66797846","79601"),
("2025","US","R02","g","hist","r","36678480","23164310","13514170"),
("2025","US","R03","g","hist","r","15219952","15219952","0"),
("2025","US","R95","g","hist","r","224037114","196947405","27089709"),
("2025","US","R98","g","hist","r","14685787","14685787","0"),
("2025","US","R99","g","hist","r","182466757","116254128","66212629"),
("2025","US","S01","g","hist","s","28529398","3050918","25478480"),
("2025","US","S03","g","hist","s","4871412","1610451","3260961"),
("2025","US","S04","g","hist","s","114752641","75246411","39506230"),
("2025","US","S05","g","hist","s","60048501","0","0"),
("2025","US","S11","g","hist","s","474379850","393820245","80559605"),
("2025","US","S12","g","hist","s","1120038074","20926105","1099111969"),
("2025","US","S14","g","hist","s","11532061","11532061","0"),
("2025","US","S16","g","hist","s","429138390","378179138","50959252"),
("2025","US","S21","g","hist","s","116216991","113186926","3030065"),
("2025","US","S22","g","hist","s","5905825","5869657","36168"),
("2025","US","S23","g","hist","s","89258158","58814580","30443578"),
("2025","US","S24","g","hist","s","80361231","0","80361231"),
("2025","US","S25","g","hist","s","71225110","37123289","34101821"),
("2025","US","S29","g","hist","s","61827370","12879393","48947977"),
("2025","US","S31","g","hist","s","21605429","4832903","16772526"),
("2025","US","S32","g","hist","s","197125325","99317178","97808147"),
("2025","US","S36","g","hist","s","345148211","153950046","191198165"),
("2025","US","S44","g","hist","s","252287611","162858751","89428860"),
("2025","US","S50","g","hist","s","100200746","19915987","80284759"),
("2025","US","S52","g","hist","s","17771762","648465","17123297"),
("2025","US","S53","g","hist","s","11757894","11757894","0"),
("2025","US","S59","g","hist","s","53746079","35270376","18475703"),
("2025","US","S60","g","hist","s","2313382","21328","2292054"),
("2025","US","S61","g","hist","s","65414059","9131948","56282111"),
("2025","US","S62","g","hist","s","169842078","26457047","143385031"),
("2025","US","S66","g","hist","s","23893153","15421203","8471950"),
("2025","US","S67","g","hist","s","33881174","18636759","15244415"),
("2025","US","S72","g","hist","s","0","0","0"),
("2025","US","S73","g","hist","s","0","0","0"),
("2025","US","S74","g","hist","s","1042529866","1035262873","7266993"),
("2025","US","S77","g","hist","s","3028484","3028484","0"),
("2025","US","S79","g","hist","s","163648882","105074234","58574648"),
("2025","US","S80","g","hist","s","84079133","2141723","81937410"),
("2025","US","S81","g","hist","s","34399005","1192149","33206856"),
("2025","US","S85","g","hist","s","1885937","1885937","0"),
("2025","US","S87","g","hist","s","8091726","3641907","4449819"),
("2025","US","S89","g","hist","s","289863850","107967576","181896274"),
("2025","US","S90","g","hist","s","13742096","11430994","2311102"),
("2025","US","S91","g","hist","s","94047165","622341","93424824"),
("2025","US","S92","g","hist","s","112561392","13299760","99261632"),
("2025","US","S93","g","hist","s","10956770","20276","10936494"),
("2025","US","S94","g","hist","s","93412420","16398277","77014143"),
("2025","US","S95","g","hist","s","463785793","392920271","70865522"),
("2025","US","T00","g","hist","r","6087792632","4046014115","2041778517"),
("2025","US","T01","g","hist","r","791944830","27679746","764265084"),
("2025","US","T09","g","hist","r","746972000","552232566","194739434"),
("2025","US","T10","g","hist","r","11849239","10555882","1293357"),
("2025","US","T13","g","hist","r","73258415","70338598","2919817"),
("2025","US","T15","g","hist","r","34643007","15241806","19401201"),
("2025","US","T16","g","hist","r","19233506","18951871","281635"),
("2025","US","T19","g","hist","r","157971493","126618402","31353091"),
("2025","US","T24","g","hist","r","44820322","41928990","2891332"),
("2025","US","T40","g","hist","r","774626572","714646546","59980026"),
("2025","US","T41","g","hist","r","199198704","182186278","17012426"),
("2025","US","U01","g","hist","r","23074284","14709","23059575"),
("2025","US","U11","g","hist","r","6570094","2285018","4285076"),
("2025","US","U20","g","hist","r","32638197","24291686","8346511")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","M00","g","hist","r","-1413616849","-1413616849","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","T00","g","hist","r","6036698829","3994713096","2041985733")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","R00","g","hist","r","4623081980","2581096247","2041985733")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","E00","g","hist","s","5954330263","3002621650","2951708613")
Done