return to Menu
0 secs
US
B74 71362320 2024 779264500 2023 713623200
B74
B78 0 2024 0 2023 0
A01 222160.6 2024 2416092 2023 2221606
A18 11228504.839603 2024 133320406 2023 125105877
A36 11109729.2 2024 120944280 2023 111097292
A44 1451711.9 2024 15735966 2023 14517119
A50 -32386.1523342 2024 1119068 2023 1183418
A59 420333.3 2024 4574687 2023 4203333
A60 939.63290336984 2024 32363 2023 32249
A61 222834.9 2024 2428257 2023 2228349
A80 120219.6 2024 1295819 2023 1202196
A81 -7103.4 2024 128308 2023 142068
A87 137562.3186799 2024 3005555 2023 2942022
A89 828367.35871878 2024 24644265 2023 24438674
A90 842945.93107872 2024 12227316 2023 11670628
A91 34221.361824127 2024 410118 2023 385185
A92 1112102.7 2024 12079166 2023 11121027
A93 -88.528852992935 2024 8573 2023 8898
A94 289087.2 2024 3116279 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 32877993.260647 2024 1082871380 2023 1077543532
D64 1001661.9694411 2024 12688508 2023 11977221
E00 220935094.8 2024 2648839257 2023 2209350948
I89 991522.7214853 2024 36589551 2023 36535215
M00 -111715106.9 2024 -1331878586 2023 -1117151069
O99 -3794428.95 2024 68585705 2023 75888579
Q79 98197026.2 2024 1072295590 2023 981970262
R00 -152150497.65 2024 2223313376 2023 3043009953
R01 -1997186.8192273 2024 61702841 2023 65473572
R02 16574774.782223 2024 325137251 2023 316481748
R03 1239784.0463575 2024 15404947 2023 14516457
R95 28761596.349014 2024 426737515 2023 408001024
R98 698678.5368043 2024 11941795 2023 11529247
R99 -2781417.6 2024 51056387 2023 55628352
S01 201432.81738397 2024 2945721 2023 2813338
S03 572876.36878628 2024 15171140 2023 14978336
S04 6358844.6 2024 69459365 2023 63588446
S05 2687695.8 2024 41048588 2023 26876958
2025x52553x0.37292962014734
S11 29381886.079854 2024 346246207 2023 324680315
S12 1953554.1 2024 21172439 2023 19535541
S14 477164.27257138 2024 9256381 2023 9004393
S16 31760001.2 2024 347030415 2023 317600012
S21 -772712.59433089 2024 79980389 2023 82956420
S22 -152209.98948783 2024 5007738 2023 5303367
S23 5393367.1 2024 58636581 2023 53933671
S24 0 2024 0 2023 0
S25 3205502.3 2024 34948533 2023 32055023
S29 1071927.6 2024 11670691 2023 10719276
S31 535072.2 2024 5781337 2023 5350722
S32 -335876.89258477 2024 70504562 2023 72764542
S36 13437076.6 2024 146363781 2023 134370766
S44 14436237.5 2024 157164550 2023 144362375
S50 1242446.9926092 2024 16928116 2023 16078009
S52 54822.5 2024 598798 2023 548225
S53 883482.82393061 2024 10298356 2023 9646839
S59 3249297.7 2024 35239118 2023 32492977
S60 1901.6 2024 20687 2023 19016
S61 829405.7 2024 9006600 2023 8294057
S62 2222746.7 2024 24289678 2023 22227467
S66 1150117.4341964 2024 13433741 2023 12586336
S72 0 2024 0 2023 0
S73 0 2024 0 2023 0
S74 85431412.8 2024 932897163 2023 854314128
S77 216979.71433431 2024 2885630 2023 2735257
S80 -19315.88603446 2024 1500476 2023 1561381
S81 141554.5 2024 1532374 2023 1415545
S85 177916.6 2024 1931261 2023 1779166
S87 357343.9 2024 3856197 2023 3573439
S89 6895494.2105295 2024 92098944 2023 87330861
S90 831922.68315762 2024 10237156 2023 9638258
S91 62543.6 2024 679084 2023 625436
S92 1148558.5 2024 12519554 2023 11485585
S93 1157.50694219 2024 23056 2023 22461
S94 2083541.7 2024 22770929 2023 20835417
S95 15651924.246499 2024 376503652 2023 370208505
T00 306908656.3 2024 3555191962 2023 3069086563
T01 2299393.4 2024 24924223 2023 22993934
T09 45855435.4 2024 496585218 2023 458554354
T10 597795.07554698 2024 8774675 2023 8382682
T13 3257285.5179476 2024 57125302 2023 55241234
T15 1324555.3 2024 14393416 2023 13245553
T16 -359886.60950043 2024 16232919 2023 17050681
T19 -3137879.4792299 2024 59966023 2023 64890520
T24 2802407.3137039 2024 35691440 2023 33706625
T40 -15049706.916301 2024 442035576 2023 469829902
T41 1064454.6724295 2024 139299376 2023 141945517
U01 1879.6 2024 20478 2023 18796
U11 -45173.47500591 2024 1555635 2023 1645250
U20 4093894.0865892 2024 55393651 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","39334392","2638253","36696139"),
("2025","US","A18","g","hist","r","177480238","144548911","32931327"),
("2025","US","A36","g","hist","r","279044845","132054009","146990836"),
("2025","US","A44","g","hist","r","29549922","17187678","12362244"),
("2025","US","A50","g","hist","r","9442121","1086682","8355439"),
("2025","US","A59","g","hist","r","8427601","4995020","3432581"),
("2025","US","A60","g","hist","r","4822715","33303","4789412"),
("2025","US","A61","g","hist","r","18510464","2651092","15859372"),
("2025","US","A80","g","hist","r","93079297","1416039","91663258"),
("2025","US","A81","g","hist","r","27749132","121205","27627927"),
("2025","US","A87","g","hist","r","10608275","3143117","7465158"),
("2025","US","A89","g","hist","r","105134417","25472632","79661785"),
("2025","US","A90","g","hist","r","15434037","13070262","2363775"),
("2025","US","A91","g","hist","r","102953742","444339","102509403"),
("2025","US","A92","g","hist","r","127715321","13191269","114524052"),
("2025","US","A93","g","hist","r","12381241","8484","12372757"),
("2025","US","A94","g","hist","r","15975936","3405366","12570570"),
("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","3450888109","1115749373","2335138736"),
("2025","US","D64","g","hist","s","39050481","13690170","25360311"),
("2025","US","E00","g","hist","s","5951330939","2869774352","3081556587"),
("2025","US","I89","g","hist","s","111764416","37581074","74183342"),
("2025","US","M00","g","hist","r","-1443593693","-1443593693","0"),
("2025","US","O99","g","hist","r","117130422","64791276","52339146"),
("2025","US","Q79","g","hist","","1254348480","1170492616","83855864"),
("2025","US","R00","g","hist","r","3952803680","2071162878","1881640802"),
("2025","US","R01","g","hist","r","59840725","59705654","135071"),
("2025","US","R02","g","hist","r","387507538","341712026","45795512"),
("2025","US","R03","g","hist","r","16644731","16644731","0"),
("2025","US","R95","g","hist","r","501510134","455499111","46011023"),
("2025","US","R98","g","hist","r","12640474","12640474","0"),
("2025","US","R99","g","hist","r","59550278","48274969","11275309"),
("2025","US","S01","g","hist","s","41301551","3147154","38154397"),
("2025","US","S03","g","hist","s","19402237","15744016","3658221"),
("2025","US","S04","g","hist","s","117571263","75818210","41753053"),
("2025","US","S05","g","hist","s","43843631","60046839.778776","107347"),
("2025","US","S11","g","hist","s","456407210","375628093","80779117"),
("2025","US","S12","g","hist","s","1137071307","23125993","1113945314"),
("2025","US","S14","g","hist","s","9733545","9733545","0"),
("2025","US","S16","g","hist","s","434351394","378790416","55560978"),
("2025","US","S21","g","hist","s","84740821","79207676","5533145"),
("2025","US","S22","g","hist","s","4931478","4855528","75950"),
("2025","US","S23","g","hist","s","116246679","64029948","52216731"),
("2025","US","S24","g","hist","s","84177263","0","84177263"),
("2025","US","S25","g","hist","s","76236116","38154035","38082081"),
("2025","US","S29","g","hist","s","59830138","12742619","47087519"),
("2025","US","S31","g","hist","s","23436731","6316409","17120322"),
("2025","US","S32","g","hist","s","165060047","70168685","94891362"),
("2025","US","S36","g","hist","s","341263930","159800858","181463072"),
("2025","US","S44","g","hist","s","288194072","171600788","116593284"),
("2025","US","S50","g","hist","s","89936992","18170563","71766429"),
("2025","US","S52","g","hist","s","18110110","653621","17456489"),
("2025","US","S53","g","hist","s","11181839","11181839","0"),
("2025","US","S59","g","hist","s","59977276","38488416","21488860"),
("2025","US","S60","g","hist","s","2436003","22589","2413414"),
("2025","US","S61","g","hist","s","75888371","9836006","66052365"),
("2025","US","S62","g","hist","s","184836834","26512425","158324409"),
("2025","US","S66","g","hist","s","24005888","14583858","9422030"),
("2025","US","S72","g","hist","s","0","0","0"),
("2025","US","S73","g","hist","s","0","0","0"),
("2025","US","S74","g","hist","s","1025875605","1018328576","7547029"),
("2025","US","S77","g","hist","s","3102610","3102610","0"),
("2025","US","S80","g","hist","s","100642927","1481160","99161767"),
("2025","US","S81","g","hist","s","39919154","1673929","38245225"),
("2025","US","S85","g","hist","s","2109178","2109178","0"),
("2025","US","S87","g","hist","s","9958144","4213541","5744603"),
("2025","US","S89","g","hist","s","272799853","98994438","173805415"),
("2025","US","S90","g","hist","s","13238204","11069079","2169125"),
("2025","US","S91","g","hist","s","123980513","741628","123238885"),
("2025","US","S92","g","hist","s","130454052","13668113","116785939"),
("2025","US","S93","g","hist","s","11633224","24214","11609010"),
("2025","US","S94","g","hist","s","130792295","24854471","105937824"),
("2025","US","S95","g","hist","s","473123312","392155576","80967736"),
("2025","US","T00","g","hist","r","5743741420","3862100618","1881640802"),
("2025","US","T01","g","hist","r","796872604","27223616","769648988"),
("2025","US","T09","g","hist","r","706616930","542440653","164176277"),
("2025","US","T10","g","hist","r","10359133","9372470","986663"),
("2025","US","T13","g","hist","r","62628255","60382588","2245667"),
("2025","US","T15","g","hist","r","36282309","15717971","20564338"),
("2025","US","T16","g","hist","r","16204563","15873032","331531"),
("2025","US","T19","g","hist","r","84580611","56828144","27752467"),
("2025","US","T24","g","hist","r","40863680","38493847","2369833"),
("2025","US","T40","g","hist","r","479837095","426985869","52851226"),
("2025","US","T41","g","hist","r","153472571","140363831","13108740"),
("2025","US","U01","g","hist","r","18458692","22358","18436334"),
("2025","US","U11","g","hist","r","5762223","1510462","4251761"),
("2025","US","U20","g","hist","r","94177429","59487545","34689884")
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","5668525714","3735390932","1933134782")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","R00","g","hist","r","4237073959","2303939177","1933134782")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2025","US","E00","g","hist","s","5959650846.7788","2883099530.7788","3076551316")
Done