return to Menu
0 secs
US
B74 110647127.9 2029 1194683840 2028 1106471279
B74
B78 0 2029 0 2028 0
0 2029 0 2028 0
A01 321751.9 2029 3474033 2028 3217519
A18 20264555.3 2029 218801310 2028 202645553
A36 16640798.5 2029 179674730 2028 166407985
A44 2296408.4 2029 24794877 2028 22964084
A50 216947.9 2029 2342439 2028 2169479
A59 624269 2029 6740384 2028 6242690
A60 5506.2 2029 59452 2028 55062
A61 333801.1 2029 3604132 2028 3338011
A80 179205.3 2029 1935453 2028 1792053
A81 46579 2029 502925 2028 465790
A87 494940.9 2029 5343997 2028 4949409
A89 4087206.1 2029 44130548 2028 40872061
A90 1886578.3 2029 20369843 2028 18865783
A91 61338.6 2029 662288 2028 613386
A92 1621471 2029 17507415 2028 16214710
A93 888.49067461804 2029 10262 2028 9680
A94 375958.9 2029 4059320 2028 3759589
B01 458005.94618289 2029 5703774 2028 5418006
B21 15433572.3 2029 166640016 2028 154335723
B22 1057672.3537946 2029 11615670 2028 10902182
B30 7662491.1451233 2029 103716164 2028 99220651
B42 9892372.5 2029 106810340 2028 98923725
B46 8495912.8 2029 91732430 2028 84959128
B50 5914433.5006545 2029 67221041 2028 63309301
B54 149109.4 2029 1609970 2028 1491094
B59 3590872.6390709 2029 40277466 2028 37884089
B62 968200.8 2029 10453899 2028 9682008
B66 775661.5 2029 8375005 2028 7756615
B79 9374603.9 2029 101219870 2028 93746039
B80 777194 2029 8391552 2028 7771940
B89 54341.922772292 2029 639042 2028 603838
B92 126785.53713246 2029 1357751 2028 1271031
B93 11842.2 2029 127863 2028 118422
B94 6270521.6 2029 67704342 2028 62705216
D49 126375396.4 2029 1356735646 2028 1263753964
D64 1099198.3601402 2029 12593451 2028 11869910
E00 298727941.20366 2029 4047419266 2028 3872294896
I89 4047079.8861281 2029 43542426 2028 40781222
M00 -182913166.4 2029 -1969451131 2028 -1829131664
O99 24212681.7 2029 261430199 2028 242126817
Q79 152254365.5 2029 1643927262 2028 1522543655
R00 338547450.5 2029 3652802679 2028 3385474505
R01 8122418.8655666 2029 87488862 2028 81950615
R02 1479731.3004945 2029 24011223 2028 23280160
R03 2047632.5 2029 22125929 2028 20476325
R95 26324201.1 2029 284574609 2028 263242011
R98 1931322.3 2029 20852955 2028 19313223
R99 15272410.1 2029 164899917 2028 152724101
S01 411790 2029 4448331 2028 4117900
S03 163117.63431302 2029 1987273 2028 1883979
S04 9892221.4 2029 106808710 2028 98922214
S05 -6143395.9 2029 0 2028 122867918
2030x47766x0.060571073315867
S11 51836605.5 2029 559692408 2028 518366055
S12 2825423.2 2029 30518185 2028 28254232
S14 1516201.2 2029 16370792 2028 15162012
S16 49728331.7 2029 536928838 2028 497283317
S21 14879042.2 2029 160652624 2028 148790422
S22 773945.1 2029 8367023 2028 7739451
S23 7801657.1 2029 84236385 2028 78016571
S24 0 2029 0 2028 0
S25 4880824.7 2029 52699446 2028 48808247
S29 1693700.4 2029 18287293 2028 16937004
S31 652901 2029 7052191 2028 6529010
S32 13061659.1 2029 141029894 2028 130616591
S36 20241689.4 2029 218554422 2028 202416894
S44 21396000 2029 231017802 2028 213960000
S50 2616940.3 2029 28255739 2028 26169403
S52 85253.4 2029 920502 2028 852534
S53 1544952.4 2029 16681226 2028 15449524
S59 4637646.8 2029 50073796 2028 46376468
S60 2802.9 2029 30263 2028 28029
S61 1200519 2029 12962294 2028 12005190
S62 3478460 2029 37557775 2028 34784600
S66 2027193.9 2029 21888104 2028 20271939
S72 0 2029 0 2028 0
S73 0 2029 0 2028 0
S77 408884.6 2029 4416475 2028 4088846
S80 281596.2 2029 3040462 2028 2815962
S81 158347.6 2029 1711753 2028 1583476
S85 250798.1 2029 2707928 2028 2507981
S87 478987 2029 5171739 2028 4789870
S89 14186736.2 2029 153177631 2028 141867362
S90 1522828.9 2029 16442350 2028 15228289
S91 83977.6 2029 907062 2028 839776
S92 1748993.3 2029 18884304 2028 17489933
S93 2523.9 2029 27040 2028 25239
S94 1743409.6399177 2029 20542951 2028 19414942
S95 52518143.9 2029 567741075 2028 525181439
T00 521460616.9 2029 5622253810 2028 5214606169
T01 3638894 2029 39290020 2028 36388940
T09 72594237.6 2029 783817570 2028 725942376
T10 1388232 2029 14989077 2028 13882320
T13 9248451.2 2029 99857767 2028 92484512
T15 2032326.9 2029 21943522 2028 20323269
T16 2522842.2 2029 27272413 2028 25228422
T19 16650257.6 2029 179776862 2028 166502576
T24 5514624.8 2029 59542739 2028 55146248
T40 93975673.8 2029 1014678101 2028 939756738
T41 24311908.1 2029 262501504 2028 243119081
U01 1727.4030766618 2029 19037 2028 17874
U11 300258.4 2029 3241963 2028 3002584
U20 2748317.1514342 2029 31049611 2028 29225480
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","B74","g","hist","s","1305330968","1305330968","0"),
("2030","US","B78","g","hist","s","0","0","0"),
("2030","US","","g","hist","","0","0","0"),
("2030","US","A01","g","hist","r","75528952","3795785","71733167"),
("2030","US","A18","g","hist","r","300944556","239065865","61878691"),
("2030","US","A36","g","hist","r","582373444","196315529","386057915"),
("2030","US","A44","g","hist","r","59865971","27091285","32774686"),
("2030","US","A50","g","hist","r","19966044","2559387","17406657"),
("2030","US","A59","g","hist","r","14325708","7364653","6961055"),
("2030","US","A60","g","hist","r","9252444","64958","9187486"),
("2030","US","A61","g","hist","r","34754776","3937933","30816843"),
("2030","US","A80","g","hist","r","160297202","2114658","158182544"),
("2030","US","A81","g","hist","r","51752628","549504","51203124"),
("2030","US","A87","g","hist","r","19044954","5838938","13206016"),
("2030","US","A89","g","hist","r","242743092","48217754","194525338"),
("2030","US","A90","g","hist","r","27847882","22256421","5591461"),
("2030","US","A91","g","hist","r","171648746","723627","170925119"),
("2030","US","A92","g","hist","r","223380879","19128886","204251993"),
("2030","US","A93","g","hist","r","24681327","11150","24670177"),
("2030","US","A94","g","hist","r","29373543","4435279","24938264"),
("2030","US","B01","g","hist","s","6161780","6161780","0"),
("2030","US","B21","g","hist","s","182073588","182073588","0"),
("2030","US","B22","g","hist","s","12673342","12673342","0"),
("2030","US","B30","g","hist","s","111378655","111378655","0"),
("2030","US","B42","g","hist","s","116702713","116702713","0"),
("2030","US","B46","g","hist","s","100228343","100228343","0"),
("2030","US","B50","g","hist","s","73135475","73135475","0"),
("2030","US","B54","g","hist","s","1759079","1759079","0"),
("2030","US","B59","g","hist","s","43868339","43868339","0"),
("2030","US","B62","g","hist","s","11422100","11422100","0"),
("2030","US","B66","g","hist","s","9150667","9150667","0"),
("2030","US","B79","g","hist","s","110594474","110594474","0"),
("2030","US","B80","g","hist","s","9168746","9168746","0"),
("2030","US","B89","g","hist","s","693384","693384","0"),
("2030","US","B92","g","hist","s","1484537","1484537","0"),
("2030","US","B93","g","hist","s","139705","139705","0"),
("2030","US","B94","g","hist","s","73974864","73974864","0"),
("2030","US","D49","g","hist","s","4790166591","1483111042","3307055549"),
("2030","US","D64","g","hist","s","66435803","13692649","52743154"),
("2030","US","E00","g","hist","s","9857974447","4346147207","5511827240"),
("2030","US","I89","g","hist","s","161568461","47589506","113978955"),
("2030","US","M00","g","hist","r","-2152364297","-2152364297","0"),
("2030","US","O99","g","hist","r","472875090","285642881","187232209"),
("2030","US","Q79","g","hist","","1948246010","1796181628","152064382"),
("2030","US","R00","g","hist","r","7975340037","3991350130","3983989907"),
("2030","US","R01","g","hist","r","95700561","95611281","89280"),
("2030","US","R02","g","hist","r","40433226","25490954","14942272"),
("2030","US","R03","g","hist","r","24173562","24173562","0"),
("2030","US","R95","g","hist","r","356452885","310898810","45554075"),
("2030","US","R98","g","hist","r","22784277","22784277","0"),
("2030","US","R99","g","hist","r","320699337","180172327","140527010"),
("2030","US","S01","g","hist","s","41622537","4860121","36762416"),
("2030","US","S03","g","hist","s","8187909","2150391","6037518"),
("2030","US","S04","g","hist","s","190162043","116700931","73461112"),
("2030","US","S05","g","hist","s","-6143396","-6515508.0895244","0"),
("2030","US","S11","g","hist","s","760045462","611529014","148516448"),
("2030","US","S12","g","hist","s","2207345271","33343608","2174001663"),
("2030","US","S14","g","hist","s","17886993","17886993","0"),
("2030","US","S16","g","hist","s","675747996","586657170","89090826"),
("2030","US","S21","g","hist","s","180627030","175531666","5095364"),
("2030","US","S22","g","hist","s","9199624","9140968","58656"),
("2030","US","S23","g","hist","s","150633907","92038042","58595865"),
("2030","US","S24","g","hist","s","152626773","0","152626773"),
("2030","US","S25","g","hist","s","121342046","57580271","63761775"),
("2030","US","S29","g","hist","s","115380680","19980993","95399687"),
("2030","US","S31","g","hist","s","39167096","7705092","31462004"),
("2030","US","S32","g","hist","s","341020447","154091553","186928894"),
("2030","US","S36","g","hist","s","617482182","238796111","378686071"),
("2030","US","S44","g","hist","s","406262695","252413802","153848893"),
("2030","US","S50","g","hist","s","191293980","30872679","160421301"),
("2030","US","S52","g","hist","s","33553383","1005755","32547628"),
("2030","US","S53","g","hist","s","18226178","18226178","0"),
("2030","US","S59","g","hist","s","91744494","54711443","37033051"),
("2030","US","S60","g","hist","s","3988636","33066","3955570"),
("2030","US","S61","g","hist","s","122648348","14162813","108485535"),
("2030","US","S62","g","hist","s","306253839","41036235","265217604"),
("2030","US","S66","g","hist","s","39565973","23915298","15650675"),
("2030","US","S72","g","hist","s","0","0","0"),
("2030","US","S73","g","hist","s","0","0","0"),
("2030","US","S77","g","hist","s","4825360","4825360","0"),
("2030","US","S80","g","hist","s","154411921","3322058","151089863"),
("2030","US","S81","g","hist","s","61848430","1870101","59978329"),
("2030","US","S85","g","hist","s","2958726","2958726","0"),
("2030","US","S87","g","hist","s","13413030","5650726","7762304"),
("2030","US","S89","g","hist","s","523742123","167364367","356377756"),
("2030","US","S90","g","hist","s","22582802","17965179","4617623"),
("2030","US","S91","g","hist","s","167108726","991040","166117686"),
("2030","US","S92","g","hist","s","216744364","20633297","196111067"),
("2030","US","S93","g","hist","s","22981629","29564","22952065"),
("2030","US","S94","g","hist","s","163804117","22286361","141517756"),
("2030","US","S95","g","hist","s","739426737","620259219","119167518"),
("2030","US","T00","g","hist","r","10127704334","6143714427","3983989907"),
("2030","US","T01","g","hist","r","1468477345","42928914","1425548431"),
("2030","US","T09","g","hist","r","1270201603","856411808","413789795"),
("2030","US","T10","g","hist","r","19102153","16377309","2724844"),
("2030","US","T13","g","hist","r","115297635","109106218","6191417"),
("2030","US","T15","g","hist","r","60421968","23975849","36446119"),
("2030","US","T16","g","hist","r","30197177","29795255","401922"),
("2030","US","T19","g","hist","r","261576910","196427120","65149790"),
("2030","US","T24","g","hist","r","70605490","65057364","5548126"),
("2030","US","T40","g","hist","r","1226886802","1108653775","118233027"),
("2030","US","T41","g","hist","r","322951258","286813412","36137846"),
("2030","US","U01","g","hist","r","48678470","20764","48657706"),
("2030","US","U11","g","hist","r","11140488","3542221","7598267"),
("2030","US","U20","g","hist","r","44259237","33797928","10461309")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","M00","g","hist","r","-2149367992","-2149367992","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","T00","g","hist","r","10123612729","6139622823","3983989906")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","R00","g","hist","r","7974244737","3990254831","3983989906")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","E00","g","hist","s","8346664342.9105","2848515609.9105","5498148733")
Done