return to Menu
0 secs
US
B74 110647127.9 2029 1207832874 2028 1106471279
B74
B78 0 2029 0 2028 0
0 2029 0 2028 0
A01 343167.3 2029 3746042 2028 3431673
A18 18845460.7 2029 205718440 2028 188454607
A36 17176868.2 2029 187504066 2028 171768682
A44 2236582.6 2029 24414708 2028 22365826
A50 116940.2 2029 1260078 2028 1169402
A59 649724 2029 7092439 2028 6497240
A60 4104.7 2029 44802 2028 41047
A61 344841.9 2029 3764322 2028 3448419
A80 184258.7 2029 2011382 2028 1842587
A81 10783.898658705 2029 128066 2028 121123
A87 397138.6 2029 4335025 2028 3971386
A89 3161386.2 2029 34506502 2028 31613862
A90 1691834.2 2029 18468272 2028 16918342
A91 57933.8 2029 632410 2028 579338
A92 1715823.2 2029 18730063 2028 17158232
A93 953.2 2029 10380 2028 9532
A94 442923 2029 4834983 2028 4429230
B01 514358.2 2029 5538548 2028 5143582
B21 15433572.3 2029 168474107 2028 154335723
B22 1038566.7 2029 11322489 2028 10385667
B30 9876022.2 2029 106539246 2028 98760222
B42 9892372.5 2029 107985928 2028 98923725
B46 8495912.8 2029 92742062 2028 84959128
B50 6025018.9 2029 65452804 2028 60250189
B54 149109.4 2029 1627690 2028 1491094
B59 3606709.3 2029 39234298 2028 36067093
B62 968200.8 2029 10568957 2028 9682008
B66 772029.3 2029 8427531 2028 7720293
B79 9374603.9 2029 102333924 2028 93746039
B80 777194 2029 8483912 2028 7771940
B89 57411.4 2029 621574 2028 574114
B92 121172.5 2029 1324574 2028 1211725
B93 11842.2 2029 129270 2028 118422
B94 6270521.6 2029 68449514 2028 62705216
D49 137795463.8 2029 1504011147 2028 1377954638
D64 1784598.4 2029 19480810 2028 17845984
E00 -195408114.85 2029 2597453135 2028 3908162297
I89 4615829.2 2029 50382174 2028 46158292
M00 -182291515.8 2029 -1988092814 2028 -1822915158
O99 5767910.5078862 2029 68470372 2028 64755873
Q79 152254365.5 2029 1662020799 2028 1522543655
R00 280588598.5 2029 3049427656 2028 2805885985
R01 6427777 2029 69269120 2028 64277770
R02 43855524.7 2029 478735010 2028 438555247
R03 2170647 2029 23694939 2028 21706470
R95 59153442.4 2029 645724971 2028 591534424
R98 1623910.2 2029 17726892 2028 16239102
R99 4345703.6950674 2029 51189798 2028 48377502
S01 407210.2 2029 4445158 2028 4072102
S03 1983999 2029 21656439 2028 19839990
S04 9862238.3 2029 107656980 2028 98622383
S05 1863180.5359283 2029 66862570 2028 67202967
2030x47766x0.060571073315867
S11 48969942.2 2029 534559518 2028 489699422
S12 3009315.4 2029 32849919 2028 30093154
S14 1240054.2 2029 13536363 2028 12400542
S16 49272184.6 2029 537859096 2028 492721846
S21 8913632.7 2029 97097825 2028 89136327
S22 525606 2029 5671933 2028 5256060
S23 8328596.2 2029 90915622 2028 83285962
S24 0 2029 0 2028 0
S25 4962918.1 2029 54175610 2028 49629181
S29 1658041.4 2029 18099309 2028 16580414
S31 821563.8 2029 8968256 2028 8215638
S32 7995687.6 2029 87354009 2028 79956876
S36 20786104.6 2029 226902778 2028 207861046
S44 22320904.6 2029 243656778 2028 223209046
S50 2359466.9 2029 25756181 2028 23594669
S52 85021.3 2029 928099 2028 850213
S53 1457655.7 2029 15911878 2028 14576557
S59 5006240.3 2029 54648520 2028 50062403
S60 2938.3 2029 32075 2028 29383
S61 1279393.4 2029 13965961 2028 12793934
S62 3448677.5 2029 37646039 2028 34486775
S66 1901164.8 2029 20753257 2028 19011648
S72 0 2029 0 2028 0
S73 0 2029 0 2028 0
S77 403386.7 2029 4403407 2028 4033867
S80 165296.9 2029 1797043 2028 1652969
S81 217727.6 2029 2376732 2028 2177276
S85 274345.2 2029 2994774 2028 2743452
S87 548043.1 2029 5982483 2028 5480431
S89 12867879.6 2029 140466993 2028 128678796
S90 1443439.4 2029 15756689 2028 14434394
S91 96465.3 2029 1053023 2028 964653
S92 1777888.6 2029 19407574 2028 17778886
S93 3078.9 2029 33609 2028 30789
S94 3233016.7 2029 35291868 2028 32330167
S95 49248211.4 2029 537565124 2028 492482114
T00 462880114.3 2029 5037520470 2028 4628801143
T01 3542529.9 2029 38670530 2028 35425299
T09 70585818.2 2029 770520236 2028 705858182
T10 1212483.3 2029 13235623 2028 12124833
T13 7748833.2 2029 84587699 2028 77488332
T15 2045365.1 2029 22327363 2028 20453651
T16 1727899.6 2029 18672055 2028 17278996
T19 5370588.9783308 2029 61247236 2028 57702325
T24 5016428.8 2029 54759722 2028 50164288
T40 45752765.2 2029 492475835 2028 457527652
T41 16488700.3 2029 180162112 2028 164887003
U01 2908.3 2029 31747 2028 29083
U11 163268 2029 1761227 2028 1632680
U20 7758116.9 2029 84688160 2028 77581169
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","B74","g","hist","s","1318480002","1318480002","0"),
("2030","US","B78","g","hist","s","0","0","0"),
("2030","US","","g","hist","","0","0","0"),
("2030","US","A01","g","hist","r","81431685","4089209","77342476"),
("2030","US","A18","g","hist","r","293101664","224563901","68537763"),
("2030","US","A36","g","hist","r","463229412","204680934","258548478"),
("2030","US","A44","g","hist","r","48727204","26651291","22075913"),
("2030","US","A50","g","hist","r","15765574","1377018","14388556"),
("2030","US","A59","g","hist","r","14358474","7742163","6616311"),
("2030","US","A60","g","hist","r","10142346","48907","10093439"),
("2030","US","A61","g","hist","r","37554069","4109164","33444905"),
("2030","US","A80","g","hist","r","177225607","2195641","175029966"),
("2030","US","A81","g","hist","r","51414018","138850","51275168"),
("2030","US","A87","g","hist","r","20234301","4732164","15502137"),
("2030","US","A89","g","hist","r","173401078","37667888","135733190"),
("2030","US","A90","g","hist","r","24349808","20160106","4189702"),
("2030","US","A91","g","hist","r","191414135","690344","190723791"),
("2030","US","A92","g","hist","r","250638023","20445886","230192137"),
("2030","US","A93","g","hist","r","26153868","11333","26142535"),
("2030","US","A94","g","hist","r","31755121","5277906","26477215"),
("2030","US","B01","g","hist","s","6052906","6052906","0"),
("2030","US","B21","g","hist","s","183907679","183907679","0"),
("2030","US","B22","g","hist","s","12361056","12361056","0"),
("2030","US","B30","g","hist","s","116415268","116415268","0"),
("2030","US","B42","g","hist","s","117878301","117878301","0"),
("2030","US","B46","g","hist","s","101237975","101237975","0"),
("2030","US","B50","g","hist","s","71477823","71477823","0"),
("2030","US","B54","g","hist","s","1776799","1776799","0"),
("2030","US","B59","g","hist","s","42841007","42841007","0"),
("2030","US","B62","g","hist","s","11537158","11537158","0"),
("2030","US","B66","g","hist","s","9199560","9199560","0"),
("2030","US","B79","g","hist","s","111708528","111708528","0"),
("2030","US","B80","g","hist","s","9261106","9261106","0"),
("2030","US","B89","g","hist","s","678985","678985","0"),
("2030","US","B92","g","hist","s","1445747","1445747","0"),
("2030","US","B93","g","hist","s","141112","141112","0"),
("2030","US","B94","g","hist","s","74720036","74720036","0"),
("2030","US","D49","g","hist","s","5705192369","1641806611","4063385758"),
("2030","US","D64","g","hist","s","55702086","21265408","34436678"),
("2030","US","E00","g","hist","s","8197493820","2402045020","5795448800"),
("2030","US","I89","g","hist","s","179878526","54998003","124880523"),
("2030","US","M00","g","hist","r","-2170384330","-2170384330","0"),
("2030","US","O99","g","hist","r","139621763","74238283","65383480"),
("2030","US","Q79","g","hist","","1967135614","1814275165","152860449"),
("2030","US","R00","g","hist","r","6873924026","3330016255","3543907771"),
("2030","US","R01","g","hist","r","75871188","75696897","174291"),
("2030","US","R02","g","hist","r","616993774","522590535","94403239"),
("2030","US","R03","g","hist","r","25865586","25865586","0"),
("2030","US","R95","g","hist","r","799763840","704878413","94885427"),
("2030","US","R98","g","hist","r","19350802","19350802","0"),
("2030","US","R99","g","hist","r","68232072","55535502","12696570"),
("2030","US","S01","g","hist","s","77764610","4852368","72912242"),
("2030","US","S03","g","hist","s","30674453","23640438","7034015"),
("2030","US","S04","g","hist","s","195296029","117519218","77776811"),
("2030","US","S05","g","hist","s","68929093","72888543.502509","203342"),
("2030","US","S11","g","hist","s","727546726","583529460","144017266"),
("2030","US","S12","g","hist","s","2193514562","35859234","2157655328"),
("2030","US","S14","g","hist","s","14776417","14776417","0"),
("2030","US","S16","g","hist","s","686600376","587131281","99469095"),
("2030","US","S21","g","hist","s","117228059","106011458","11216601"),
("2030","US","S22","g","hist","s","6348254","6197539","150715"),
("2030","US","S23","g","hist","s","201964157","99244218","102719939"),
("2030","US","S24","g","hist","s","159317653","0","159317653"),
("2030","US","S25","g","hist","s","132832255","59138528","73693727"),
("2030","US","S29","g","hist","s","106700773","19757350","86943423"),
("2030","US","S31","g","hist","s","41264164","9789820","31474344"),
("2030","US","S32","g","hist","s","267578770","95349697","172229073"),
("2030","US","S36","g","hist","s","586238853","247688883","338549970"),
("2030","US","S44","g","hist","s","495736025","265977683","229758342"),
("2030","US","S50","g","hist","s","158343718","28115648","130228070"),
("2030","US","S52","g","hist","s","33533570","1013120","32520450"),
("2030","US","S53","g","hist","s","17369534","17369534","0"),
("2030","US","S59","g","hist","s","105140122","59654760","45485362"),
("2030","US","S60","g","hist","s","4194715","35013","4159702"),
("2030","US","S61","g","hist","s","150026030","15245354","134780676"),
("2030","US","S62","g","hist","s","342450754","41094717","301356037"),
("2030","US","S66","g","hist","s","40643330","22654422","17988908"),
("2030","US","S72","g","hist","s","0","0","0"),
("2030","US","S73","g","hist","s","0","0","0"),
("2030","US","S77","g","hist","s","4806794","4806794","0"),
("2030","US","S80","g","hist","s","200002406","1962340","198040066"),
("2030","US","S81","g","hist","s","75636563","2594460","73042103"),
("2030","US","S85","g","hist","s","3269119","3269119","0"),
("2030","US","S87","g","hist","s","17904229","6530526","11373703"),
("2030","US","S89","g","hist","s","474835969","153334873","321501096"),
("2030","US","S90","g","hist","s","21261436","17200128","4061308"),
("2030","US","S91","g","hist","s","251254509","1149488","250105021"),
("2030","US","S92","g","hist","s","265149095","21185463","243963632"),
("2030","US","S93","g","hist","s","24587039","36688","24550351"),
("2030","US","S94","g","hist","s","261833494","38524885","223308609"),
("2030","US","S95","g","hist","s","731342415","586813335","144529080"),
("2030","US","T00","g","hist","r","9044308355","5500400584","3543907771"),
("2030","US","T01","g","hist","r","1436111511","42213060","1393898451"),
("2030","US","T09","g","hist","r","1150180690","841106054","309074636"),
("2030","US","T10","g","hist","r","16174182","14448106","1726076"),
("2030","US","T13","g","hist","r","96310925","92336532","3974393"),
("2030","US","T15","g","hist","r","63142234","24372728","38769506"),
("2030","US","T16","g","hist","r","20927759","20399955","527804"),
("2030","US","T19","g","hist","r","119301100","66617825","52683275"),
("2030","US","T24","g","hist","r","63571947","59776151","3795796"),
("2030","US","T40","g","hist","r","631486377","538228600","93257777"),
("2030","US","T41","g","hist","r","219908107","196650812","23257295"),
("2030","US","U01","g","hist","r","33417734","34655","33383079"),
("2030","US","U11","g","hist","r","9128396","1924495","7203901"),
("2030","US","U20","g","hist","r","155830795","92446277","63384518")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","M00","g","hist","r","-2170384330","-2170384330","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","T00","g","hist","r","9042707659","5498799890","3543907769")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","R00","g","hist","r","6872323329","3328415560","3543907769")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","E00","g","hist","s","8741788179.5025","2835320676.5025","5906467503")
Done