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 320108 2029 3481242 2028 3201080
A18 20264555.3 2029 220957181 2028 202645553
A36 16640798.5 2029 180928801 2028 166407985
A44 2296408.4 2029 25048737 2028 22964084
A50 216947.9 2029 2362671 2028 2169479
A59 624269 2029 6814288 2028 6242690
A60 5501.8 2029 59978 2028 55018
A61 333801.1 2029 3637096 2028 3338011
A80 177369.2 2029 1935783 2028 1773692
A81 46579 2029 506053 2028 465790
A87 494940.9 2029 5390934 2028 4949409
A89 4066253.9 2029 44343091 2028 40662539
A90 1876938 2029 20459872 2028 18769380
A91 61029.5 2029 665571 2028 610295
A92 1621471 2029 17666420 2028 16214710
A93 943.2 2029 10216 2028 9432
A94 375727 2029 4054875 2028 3757270
B01 527501.7 2029 5725524 2028 5275017
B21 15433572.3 2029 168474107 2028 154335723
B22 1063231.8 2029 11620605 2028 10632318
B30 9957413.7 2029 107823204 2028 99574137
B42 9892372.5 2029 107985928 2028 98923725
B46 8495912.8 2029 92742062 2028 84959128
B50 6171232.1 2029 67472225 2028 61712321
B54 149109.4 2029 1627690 2028 1491094
B59 3693525.2 2029 40377214 2028 36935252
B62 968200.8 2029 10568957 2028 9682008
B66 771696.3 2029 8423899 2028 7716963
B79 9374603.9 2029 102333924 2028 93746039
B80 777194 2029 8483912 2028 7771940
B89 58833.3 2029 641843 2028 588333
B92 124002.6 2029 1354926 2028 1240026
B93 11842.2 2029 129270 2028 118422
B94 6270521.6 2029 68449514 2028 62705216
D49 123379783.9 2029 1335752817 2028 1233797839
D64 1156922.2 2029 12537045 2028 11569222
E00 406121036.3 2029 4435460057 2028 4061210363
I89 3978366.9 2029 43072639 2028 39783669
M00 -182647997 2029 -1993074822 2028 -1826479970
O99 24089079.5 2029 261887928 2028 240890795
Q79 139426118.1 2029 1521978169 2028 1394261181
R00 337890102.1 2029 3674076925 2028 3378901021
R01 7994465.9 2029 86968680 2028 79944659
R02 -35131.779762208 2029 22295046 2028 23099499
R03 2018887.2 2029 22023915 2028 20188872
R95 25927887 2029 277397780 2028 259278870
R98 1931322.3 2029 20997359 2028 19313223
R99 15272410.1 2029 166028251 2028 152724101
S01 406257.7 2029 4389853 2028 4062577
S03 183476.7 2029 1988423 2028 1834767
S04 9892221.4 2029 107961201 2028 98922214
S05 11958250.5 2029 138680735 2028 119582505
2030x47766x0.060571073315867
S11 51781356.7 2029 564743959 2028 517813567
S12 2795730.8 2029 30172112 2028 27957308
S14 1516201.2 2029 16522909 2028 15162012
S16 49728331.7 2029 542808323 2028 497283317
S21 14879042.2 2029 162142347 2028 148790422
S22 755188.4 2029 8153236 2028 7551884
S23 7761842.7 2029 84152861 2028 77618427
S24 0 2029 0 2028 0
S25 4880824.7 2029 53191251 2028 48808247
S29 1693700.4 2029 18474525 2028 16937004
S31 645155.6 2029 6961268 2028 6451556
S32 13061659.1 2029 142236827 2028 130616591
S36 20241689.4 2029 220225655 2028 202416894
S44 21396000 2029 233039064 2028 213960000
S50 2616940.3 2029 28509670 2028 26169403
S52 85253.4 2029 930132 2028 852534
S53 1544952.4 2029 16817641 2028 15449524
S59 4637646.8 2029 50365079 2028 46376468
S60 2802.9 2029 30587 2028 28029
S61 1200519 2029 13025245 2028 12005190
S62 3478460 2029 37969790 2028 34784600
S66 2027193.9 2029 22072540 2028 20271939
S72 0 2029 0 2028 0
S73 0 2029 0 2028 0
S77 404590.7 2029 4416497 2028 4045907
S80 281596.2 2029 3072700 2028 2815962
S81 155294.8 2029 1682127 2028 1552948
S85 249514.9 2029 2717630 2028 2495149
S87 478987 2029 5220491 2028 4789870
S89 14186736.2 2029 154677746 2028 141867362
S90 1515023.1 2029 16522568 2028 15150231
S91 83103.6 2029 896521 2028 831036
S92 1748993.3 2029 19061720 2028 17489933
S93 2463.2 2029 26701 2028 24632
S94 1891596 2029 20505946 2028 18915960
S95 51727477.1 2029 562949592 2028 517274771
T00 520538099.1 2029 5667151747 2028 5205380991
T01 3638894 2029 39681558 2028 36388940
T09 72594237.6 2029 791625262 2028 725942376
T10 1388232 2029 15127706 2028 13882320
T13 9248451.2 2029 100830417 2028 92484512
T15 2021900.1 2029 22064123 2028 20219001
T16 2479934.4 2029 27027994 2028 24799344
T19 16650257.6 2029 181072689 2028 166502576
T24 5514624.8 2029 58929310 2028 55146248
T40 93975673.8 2029 1025599862 2028 939756738
T41 24187075.7 2029 259693067 2028 241870757
U01 1742.7 2029 18829 2028 17427
U11 300258.4 2029 3267531 2028 3002584
U20 2849063.2 2029 30614589 2028 28490632
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","78329305","3801350","74527955"),
("2030","US","A18","g","hist","r","304880007","241221736","63658271"),
("2030","US","A36","g","hist","r","597948756","197569600","400379156"),
("2030","US","A44","g","hist","r","61483114","27345145","34137969"),
("2030","US","A50","g","hist","r","20209128","2579619","17629509"),
("2030","US","A59","g","hist","r","14753892","7438557","7315335"),
("2030","US","A60","g","hist","r","9628526","65480","9563046"),
("2030","US","A61","g","hist","r","35927456","3970897","31956559"),
("2030","US","A80","g","hist","r","158971143","2113152","156857991"),
("2030","US","A81","g","hist","r","52325207","552632","51772575"),
("2030","US","A87","g","hist","r","19346650","5885875","13460775"),
("2030","US","A89","g","hist","r","245391153","48409345","196981808"),
("2030","US","A90","g","hist","r","27988312","22336810","5651502"),
("2030","US","A91","g","hist","r","173309975","726601","172583374"),
("2030","US","A92","g","hist","r","228624533","19287891","209336642"),
("2030","US","A93","g","hist","r","25398885","11159","25387726"),
("2030","US","A94","g","hist","r","29933402","4430602","25502800"),
("2030","US","B01","g","hist","s","6253026","6253026","0"),
("2030","US","B21","g","hist","s","183907679","183907679","0"),
("2030","US","B22","g","hist","s","12683837","12683837","0"),
("2030","US","B30","g","hist","s","117780618","117780618","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","73643457","73643457","0"),
("2030","US","B54","g","hist","s","1776799","1776799","0"),
("2030","US","B59","g","hist","s","44070739","44070739","0"),
("2030","US","B62","g","hist","s","11537158","11537158","0"),
("2030","US","B66","g","hist","s","9195595","9195595","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","700676","700676","0"),
("2030","US","B92","g","hist","s","1478929","1478929","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","5113928462","1459132601","3654795861"),
("2030","US","D64","g","hist","s","69681469","13693967","55987502"),
("2030","US","E00","g","hist","s","10635899743","4841581093","5794318650"),
("2030","US","I89","g","hist","s","171351996","47051006","124300990"),
("2030","US","M00","g","hist","r","-2175722819","-2175722819","0"),
("2030","US","O99","g","hist","r","479575997","285977008","193598989"),
("2030","US","Q79","g","hist","","1802997985","1661404287","141593698"),
("2030","US","R00","g","hist","r","8041893822","4011967027","4029926795"),
("2030","US","R01","g","hist","r","95071537","94963146","108391"),
("2030","US","R02","g","hist","r","39271372","22259914","17011458"),
("2030","US","R03","g","hist","r","24042802","24042802","0"),
("2030","US","R95","g","hist","r","350495564","303325667","47169897"),
("2030","US","R98","g","hist","r","22928681","22928681","0"),
("2030","US","R99","g","hist","r","323430382","181300661","142129721"),
("2030","US","S01","g","hist","s","46329055","4796111","41532944"),
("2030","US","S03","g","hist","s","8485785","2171900","6313885"),
("2030","US","S04","g","hist","s","189779985","117853422","71926563"),
("2030","US","S05","g","hist","s","150638986","159763351.06523","0"),
("2030","US","S11","g","hist","s","761715062","616525316","145189746"),
("2030","US","S12","g","hist","s","2224444160","32967843","2191476317"),
("2030","US","S14","g","hist","s","18039110","18039110","0"),
("2030","US","S16","g","hist","s","689059592","592536655","96522937"),
("2030","US","S21","g","hist","s","182470353","177021389","5448964"),
("2030","US","S22","g","hist","s","8971737","8908424","63313"),
("2030","US","S23","g","hist","s","151723987","91914704","59809283"),
("2030","US","S24","g","hist","s","156628200","0","156628200"),
("2030","US","S25","g","hist","s","126193662","58072076","68121586"),
("2030","US","S29","g","hist","s","116234465","20168225","96066240"),
("2030","US","S31","g","hist","s","38507815","7606424","30901391"),
("2030","US","S32","g","hist","s","342767301","155298486","187468815"),
("2030","US","S36","g","hist","s","638648553","240467344","398181209"),
("2030","US","S44","g","hist","s","418073514","254435064","163638450"),
("2030","US","S50","g","hist","s","194360258","31126610","163233648"),
("2030","US","S52","g","hist","s","35602941","1015385","34587556"),
("2030","US","S53","g","hist","s","18362593","18362593","0"),
("2030","US","S59","g","hist","s","92798722","55002726","37795996"),
("2030","US","S60","g","hist","s","4223747","33390","4190357"),
("2030","US","S61","g","hist","s","128094659","14225764","113868895"),
("2030","US","S62","g","hist","s","323438562","41448250","281990312"),
("2030","US","S66","g","hist","s","40701481","24099734","16601747"),
("2030","US","S72","g","hist","s","0","0","0"),
("2030","US","S73","g","hist","s","0","0","0"),
("2030","US","S77","g","hist","s","4821088","4821088","0"),
("2030","US","S80","g","hist","s","163513624","3354296","160159328"),
("2030","US","S81","g","hist","s","66077042","1837422","64239620"),
("2030","US","S85","g","hist","s","2967145","2967145","0"),
("2030","US","S87","g","hist","s","13909056","5699478","8209578"),
("2030","US","S89","g","hist","s","533267456","168864482","364402974"),
("2030","US","S90","g","hist","s","22887473","18037591","4849882"),
("2030","US","S91","g","hist","s","176202092","979625","175222467"),
("2030","US","S92","g","hist","s","220763540","20810713","199952827"),
("2030","US","S93","g","hist","s","23705474","29164","23676310"),
("2030","US","S94","g","hist","s","170968902","22397542","148571360"),
("2030","US","S95","g","hist","s","744462012","614677069","129784943"),
("2030","US","T00","g","hist","r","10217616641","6187689846","4029926795"),
("2030","US","T01","g","hist","r","1450778855","43320452","1407458403"),
("2030","US","T09","g","hist","r","1288836225","864219500","424616725"),
("2030","US","T10","g","hist","r","19318049","16515938","2802111"),
("2030","US","T13","g","hist","r","116471359","110078868","6392491"),
("2030","US","T15","g","hist","r","60412334","24086023","36326311"),
("2030","US","T16","g","hist","r","29864018","29507928","356090"),
("2030","US","T19","g","hist","r","265240673","197722947","67517726"),
("2030","US","T24","g","hist","r","69945596","64443935","5501661"),
("2030","US","T40","g","hist","r","1243902055","1119575536","124326519"),
("2030","US","T41","g","hist","r","319143814","283880143","35263671"),
("2030","US","U01","g","hist","r","50281516","20572","50260944"),
("2030","US","U11","g","hist","r","11391126","3567789","7823337"),
("2030","US","U20","g","hist","r","45192906","33463652","11729254")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","M00","g","hist","r","-2175722820","-2175722820","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","T00","g","hist","r","10215271561","6185344766","4029926795")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","R00","g","hist","r","8039548741","4009621946","4029926795")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","E00","g","hist","s","8681032450.0652","3035888760.0652","5645143690")
Done