return to Menu
0 secs
US
B74 101361595.2 2028 1106471279 2027 1013615952
B74
B78 0 2028 0 2027 0
0 2028 0 2027 0
A01 314368.7 2028 3431673 2027 3143687
A18 17263832.6 2028 188454607 2027 172638326
A36 15735383.8 2028 171768682 2027 157353838
A44 2048882.1 2028 22365826 2027 20488821
A50 91722.415037684 2028 1169402 2027 1111146
A59 595199.1 2028 6497240 2027 5951991
A60 3754.7 2028 41047 2027 37547
A61 315902.7 2028 3448419 2027 3159027
A80 168795.2 2028 1842587 2027 1687952
A81 7051.245259893 2028 121123 2027 117667
A87 363638.5 2028 3971386 2027 3636385
A89 2892639.5 2028 31613862 2027 28926395
A90 1549930.3 2028 16918342 2027 15499303
A91 53071.6 2028 579338 2027 530716
A92 1571831.3 2028 17158232 2027 15718313
A93 856.083337329 2028 9532 2027 8943
A94 405753.1 2028 4429230 2027 4057531
B01 399567.81016422 2028 5143582 2027 4891419
B21 14138383.6 2028 154335723 2027 141383836
B22 946113.57443324 2028 10385667 2027 9729853
B30 7867380.3873912 2028 98760222 2027 93712828
B42 9062202.5 2028 98923725 2027 90622025
B46 7782933.6 2028 84959128 2027 77829336
B50 5256518.4793194 2028 60250189 2027 56689999
B54 136596.1 2028 1491094 2027 1365961
B59 3199472.4855062 2028 36067093 2027 33880301
B62 886949.1 2028 9682008 2027 8869491
B66 707238.3 2028 7720293 2027 7072383
B79 8587884.8 2028 93746039 2027 85878848
B80 711971.7 2028 7771940 2027 7119717
B89 47973.35392649 2028 574114 2027 542416
B92 113147.5 2028 1211725 2027 1131475
B93 10848.4 2028 118422 2027 108484
B94 5744297.8 2028 62705216 2027 57442978
D49 126056509.4 2028 1377954638 2027 1260565094
D64 1634825.6 2028 17845984 2027 16348256
E00 359957792.9 2028 3908162297 2027 3599577929
I89 4223882.4 2028 46158292 2027 42238824
M00 -167594542.8 2028 -1822915158 2027 -1675945428
O99 3772432.9633805 2028 64755873 2027 62905424
Q79 139477143.7 2028 1522543655 2027 1394771437
R00 260027984.9 2028 2805885985 2027 2600279849
R01 5048856.5393166 2028 64277770 2027 61068061
R02 40179763.3 2028 438555247 2027 401797633
R03 1988468.7 2028 21706470 2027 19884687
R95 54190546.9 2028 591534424 2027 541905469
R98 1487790.1 2028 16239102 2027 14877901
R99 2855576.983204 2028 48377502 2027 46955829
S01 373056.3 2028 4072102 2027 3730563
S03 1816448.9 2028 19839990 2027 18164489
S04 9034596.8 2028 98622383 2027 90345968
S05 -3869991.45 2028 67202967 2027 77399829
2029x45038x0.075405921680993
S11 44860096.2 2028 489699422 2027 448600962
S12 2756764.9 2028 30093154 2027 27567649
S14 1135821 2028 12400542 2027 11358210
S16 45137250 2028 492721846 2027 451372500
S21 8041245.015858 2028 89136327 2027 83590768
S22 420575.4159884 2028 5256060 2027 4985467
S23 7629660.1 2028 83285962 2027 76296601
S24 0 2028 0 2027 0
S25 4546429.2 2028 49629181 2027 45464292
S29 1518894.6 2028 16580414 2027 15188946
S31 752618.4 2028 8215638 2027 7526184
S32 7468667.1122619 2028 79956876 2027 74713435
S36 19041732.2 2028 207861046 2027 190417322
S44 20447732.2 2028 223209046 2027 204477322
S50 2161512.4 2028 23594669 2027 21615124
S52 77886.3 2028 850213 2027 778863
S53 1335321.3 2028 14576557 2027 13353213
S59 4586117 2028 50062403 2027 45861170
S60 2691.7 2028 29383 2027 26917
S61 1172026.7 2028 12793934 2027 11720267
S62 3159263.6 2028 34486775 2027 31592636
S66 1741608.6 2028 19011648 2027 17416086
S72 0 2028 0 2027 0
S73 0 2028 0 2027 0
S77 369539.8 2028 4033867 2027 3695398
S80 145552.42002427 2028 1652969 2027 1553885
S81 199455.9 2028 2177276 2027 1994559
S85 251322.2 2028 2743452 2027 2513222
S87 502051.5 2028 5480431 2027 5020515
S89 11788196.8 2028 128678796 2027 117881968
S90 1322294.8 2028 14434394 2027 13222948
S91 88369.9 2028 964653 2027 883699
S92 1628687.9 2028 17778886 2027 16286879
S93 2819.9 2028 30789 2027 28199
S94 2961701.1 2028 32330167 2027 29617011
S95 45083009.9 2028 492482114 2027 450830099
T00 427622527.7 2028 4628801143 2027 4276225277
T01 3245230.5 2028 35425299 2027 32452305
T09 64662053.5 2028 705858182 2027 646620535
T10 1110790.3 2028 12124833 2027 11107903
T13 7099367.4 2028 77488332 2027 70993674
T15 1873711.9 2028 20453651 2027 18737119
T16 1408517.4452764 2028 17278996 2027 16362174
T19 3596535.2001776 2028 57702325 2027 55806052
T24 4595434.4 2028 50164288 2027 45954344
T40 35357513.891802 2028 457527652 2027 435291680
T41 15275109.3 2028 164887003 2027 152751093
U01 2664.2 2028 29083 2027 26642
U11 130007.19452269 2028 1632680 2027 1549295
U20 7106991 2028 77581169 2027 71069910
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","B74","g","hist","s","1207832874","1207832874","0"),
("2029","US","B78","g","hist","s","0","0","0"),
("2029","US","","g","hist","","0","0","0"),
("2029","US","A01","g","hist","r","70219749","3746042","66473707"),
("2029","US","A18","g","hist","r","264690894","205718440","58972454"),
("2029","US","A36","g","hist","r","413617320","187504066","226113254"),
("2029","US","A44","g","hist","r","43690968","24414708","19276260"),
("2029","US","A50","g","hist","r","13872702","1261124","12611578"),
("2029","US","A59","g","hist","r","12825998","7092439","5733559"),
("2029","US","A60","g","hist","r","8719904","44802","8675102"),
("2029","US","A61","g","hist","r","32507846","3764322","28743524"),
("2029","US","A80","g","hist","r","153826077","2011382","151814695"),
("2029","US","A81","g","hist","r","44726653","128174","44598479"),
("2029","US","A87","g","hist","r","17676300","4335025","13341275"),
("2029","US","A89","g","hist","r","153611613","34506502","119105111"),
("2029","US","A90","g","hist","r","22129458","18468272","3661186"),
("2029","US","A91","g","hist","r","166480497","632410","165848087"),
("2029","US","A92","g","hist","r","217424259","18730063","198694196"),
("2029","US","A93","g","hist","r","22474216","10388","22463828"),
("2029","US","A94","g","hist","r","27592713","4834983","22757730"),
("2029","US","B01","g","hist","s","5543150","5543150","0"),
("2029","US","B21","g","hist","s","168474107","168474107","0"),
("2029","US","B22","g","hist","s","11331781","11331781","0"),
("2029","US","B30","g","hist","s","106627602","106627602","0"),
("2029","US","B42","g","hist","s","107985928","107985928","0"),
("2029","US","B46","g","hist","s","92742062","92742062","0"),
("2029","US","B50","g","hist","s","65506707","65506707","0"),
("2029","US","B54","g","hist","s","1627690","1627690","0"),
("2029","US","B59","g","hist","s","39266565","39266565","0"),
("2029","US","B62","g","hist","s","10568957","10568957","0"),
("2029","US","B66","g","hist","s","8427531","8427531","0"),
("2029","US","B79","g","hist","s","102333924","102333924","0"),
("2029","US","B80","g","hist","s","8483912","8483912","0"),
("2029","US","B89","g","hist","s","622087","622087","0"),
("2029","US","B92","g","hist","s","1324873","1324873","0"),
("2029","US","B93","g","hist","s","129270","129270","0"),
("2029","US","B94","g","hist","s","68449514","68449514","0"),
("2029","US","D49","g","hist","s","5061648941","1504011147","3557637794"),
("2029","US","D64","g","hist","s","50524212","19480810","31043402"),
("2029","US","E00","g","hist","s","9520491511","4268120090","5252371421"),
("2029","US","I89","g","hist","s","160106948","50382174","109724774"),
("2029","US","M00","g","hist","r","-1990509701","-1990509701","0"),
("2029","US","O99","g","hist","r","128140597","68528306","59612291"),
("2029","US","Q79","g","hist","","1795216010","1662020799","133195211"),
("2029","US","R00","g","hist","r","6152142188","3065913970","3086228218"),
("2029","US","R01","g","hist","r","69484821","69326627","158194"),
("2029","US","R02","g","hist","r","560033013","478735010","81298003"),
("2029","US","R03","g","hist","r","23694939","23694939","0"),
("2029","US","R95","g","hist","r","727435274","645724971","81710303"),
("2029","US","R98","g","hist","r","17726892","17726892","0"),
("2029","US","R99","g","hist","r","62984203","51233079","11751124"),
("2029","US","S01","g","hist","s","67681842","4445158","63236684"),
("2029","US","S03","g","hist","s","27753404","21656439","6096965"),
("2029","US","S04","g","hist","s","175281494","107656980","67624514"),
("2029","US","S05","g","hist","s","63509485","68108657.42808","176509"),
("2029","US","S11","g","hist","s","660333632","534559518","125774114"),
("2029","US","S12","g","hist","s","1901754723","32849919","1868904804"),
("2029","US","S14","g","hist","s","13536363","13536363","0"),
("2029","US","S16","g","hist","s","624691059","537859096","86831963"),
("2029","US","S21","g","hist","s","106851795","97177572","9674223"),
("2029","US","S22","g","hist","s","5806882","5676635","130247"),
("2029","US","S23","g","hist","s","179758365","90915622","88842743"),
("2029","US","S24","g","hist","s","138305426","0","138305426"),
("2029","US","S25","g","hist","s","118012932","54175610","63837322"),
("2029","US","S29","g","hist","s","93760195","18099309","75660886"),
("2029","US","S31","g","hist","s","36370107","8968256","27401851"),
("2029","US","S32","g","hist","s","237563403","87425543","150137860"),
("2029","US","S36","g","hist","s","521216350","226902778","294313572"),
("2029","US","S44","g","hist","s","442342811","243656778","198686033"),
("2029","US","S50","g","hist","s","139282915","25756181","113526734"),
("2029","US","S52","g","hist","s","29203375","928099","28275276"),
("2029","US","S53","g","hist","s","15911878","15911878","0"),
("2029","US","S59","g","hist","s","93727135","54648520","39078615"),
("2029","US","S60","g","hist","s","3677715","32075","3645640"),
("2029","US","S61","g","hist","s","130143377","13965961","116177416"),
("2029","US","S62","g","hist","s","299112233","37646039","261466194"),
("2029","US","S66","g","hist","s","36356385","20753257","15603128"),
("2029","US","S72","g","hist","s","0","0","0"),
("2029","US","S73","g","hist","s","0","0","0"),
("2029","US","S77","g","hist","s","4403407","4403407","0"),
("2029","US","S80","g","hist","s","172841721","1798521","171043200"),
("2029","US","S81","g","hist","s","65729711","2376732","63352979"),
("2029","US","S85","g","hist","s","2994774","2994774","0"),
("2029","US","S87","g","hist","s","15813673","5982483","9831190"),
("2029","US","S89","g","hist","s","420196691","140466993","279729698"),
("2029","US","S90","g","hist","s","19286088","15756689","3529399"),
("2029","US","S91","g","hist","s","216744269","1053023","215691246"),
("2029","US","S92","g","hist","s","229253200","19407574","209845626"),
("2029","US","S93","g","hist","s","21127666","33609","21094057"),
("2029","US","S94","g","hist","s","227217191","35291868","191925323"),
("2029","US","S95","g","hist","s","663770436","537565124","126205312"),
("2029","US","T00","g","hist","r","8142651889","5056423671","3086228218"),
("2029","US","T01","g","hist","r","1254045688","38670530","1215375158"),
("2029","US","T09","g","hist","r","1038971336","770520236","268451100"),
("2029","US","T10","g","hist","r","14746017","13235623","1510394"),
("2029","US","T13","g","hist","r","88061277","84587699","3473578"),
("2029","US","T15","g","hist","r","55996431","22327363","33669068"),
("2029","US","T16","g","hist","r","19154146","18687513","466633"),
("2029","US","T19","g","hist","r","107020440","61298860","45721580"),
("2029","US","T24","g","hist","r","58113286","54759722","3353564"),
("2029","US","T40","g","hist","r","574416712","492885166","81531546"),
("2029","US","T41","g","hist","r","200483546","180162112","20321434"),
("2029","US","U01","g","hist","r","29139883","31747","29108136"),
("2029","US","U11","g","hist","r","8087883","1762687","6325196"),
("2029","US","U20","g","hist","r","139905352","84688160","55217192")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","M00","g","hist","r","-1988282046","-1988282046","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","T00","g","hist","r","8124575675","5038347459","3086228216")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","R00","g","hist","r","6136293629","3050065413","3086228216")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","E00","g","hist","s","7718032894.4281","2598856683.4281","5119176211")
Done