return to Menu
0 secs
US
B74 120783287.4 2030 1318480002 2029 1207832874
B74
B78 0 2030 0 2029 0
0 2030 0 2029 0
A01 374604.2 2030 4089209 2029 3746042
A18 20571844 2030 224563901 2029 205718440
A36 18750406.6 2030 204680934 2029 187504066
A44 2441470.8 2030 26651291 2029 24414708
A50 126112.4 2030 1377018 2029 1261124
A59 709243.9 2030 7742163 2029 7092439
A60 4480.2 2030 48907 2029 44802
A61 376432.2 2030 4109164 2029 3764322
A80 201138.2 2030 2195641 2029 2011382
A81 12817.4 2030 138850 2029 128174
A87 433502.5 2030 4732164 2029 4335025
A89 3450650.2 2030 37667888 2029 34506502
A90 1846827.2 2030 20160106 2029 18468272
A91 63241 2030 690344 2029 632410
A92 1873006.3 2030 20445886 2029 18730063
A93 1038.8 2030 11333 2029 10388
A94 483498.3 2030 5277906 2029 4834983
B01 554315 2030 6052906 2029 5543150
B21 16847410.7 2030 183907679 2029 168474107
B22 1133178.1 2030 12361056 2029 11331781
B30 10662760.2 2030 116415268 2029 106627602
B42 10798592.8 2030 117878301 2029 107985928
B46 9274206.2 2030 101237975 2029 92742062
B50 6550670.7 2030 71477823 2029 65506707
B54 162769 2030 1776799 2029 1627690
B59 3926656.5 2030 42841007 2029 39266565
B62 1056895.7 2030 11537158 2029 10568957
B66 842753.1 2030 9199560 2029 8427531
B79 10233392.4 2030 111708528 2029 102333924
B80 848391.2 2030 9261106 2029 8483912
B89 62208.7 2030 678985 2029 622087
B92 132487.3 2030 1445747 2029 1324873
B93 12927 2030 141112 2029 129270
B94 6844951.4 2030 74720036 2029 68449514
D49 150401114.7 2030 1641806611 2029 1504011147
D64 1948081 2030 21265408 2029 19480810
E00 259885668.3 2030 2835320677 2029 2598856683
I89 5038217.4 2030 54998003 2029 50382174
M00 -198828204.6 2030 -2170384330 2029 -1988282046
O99 6852830.6 2030 74238283 2029 68528306
Q79 166202079.9 2030 1814275165 2029 1662020799
R00 305006541.3 2030 3328415560 2029 3050065413
R01 6932662.7 2030 75696897 2029 69326627
R02 47873501 2030 522590535 2029 478735010
R03 2369493.9 2030 25865586 2029 23694939
R95 64572497.1 2030 704878413 2029 645724971
R98 1772689.2 2030 19350802 2029 17726892
R99 5123307.9 2030 55535502 2029 51233079
S01 444515.8 2030 4852368 2029 4445158
S03 2165643.9 2030 23640438 2029 21656439
S04 10765698 2030 117519218 2029 107656980
S05 6810865.7 2030 72888544 2029 68108657
2031x50640x0.060168320562743
S11 53455951.8 2030 583529460 2029 534559518
S12 3284991.9 2030 35859234 2029 32849919
S14 1353636.3 2030 14776417 2029 13536363
S16 53785909.6 2030 587131281 2029 537859096
S21 9717757.2 2030 106011458 2029 97177572
S22 567663.5 2030 6197539 2029 5676635
S23 9091562.2 2030 99244218 2029 90915622
S24 0 2030 0 2029 0
S25 5417561 2030 59138528 2029 54175610
S29 1809930.9 2030 19757350 2029 18099309
S31 896825.6 2030 9789820 2029 8968256
S32 8742554.3 2030 95349697 2029 87425543
S36 22690277.8 2030 247688883 2029 226902778
S44 24365677.8 2030 265977683 2029 243656778
S50 2575618.1 2030 28115648 2029 25756181
S52 92809.9 2030 1013120 2029 928099
S53 1591187.8 2030 17369534 2029 15911878
S59 5464852 2030 59654760 2029 54648520
S60 3207.5 2030 35013 2029 32075
S61 1396596.1 2030 15245354 2029 13965961
S62 3764603.9 2030 41094717 2029 37646039
S66 2075325.7 2030 22654422 2029 20753257
S72 0 2030 0 2029 0
S73 0 2030 0 2029 0
S77 440340.7 2030 4806794 2029 4403407
S80 179852.1 2030 1962340 2029 1798521
S81 237673.2 2030 2594460 2029 2376732
S85 299477.4 2030 3269119 2029 2994774
S87 598248.3 2030 6530526 2029 5982483
S89 14046699.3 2030 153334873 2029 140466993
S90 1575668.9 2030 17200128 2029 15756689
S91 105302.3 2030 1149488 2029 1053023
S92 1940757.4 2030 21185463 2029 19407574
S93 3360.9 2030 36688 2029 33609
S94 3529186.8 2030 38524885 2029 35291868
S95 53756512.4 2030 586813335 2029 537565124
T00 503834745.9 2030 5498799890 2029 5038347459
T01 3867053 2030 42213060 2029 38670530
T09 77052023.6 2030 841106054 2029 770520236
T10 1323562.3 2030 14448106 2029 13235623
T13 8458769.9 2030 92336532 2029 84587699
T15 2232736.3 2030 24372728 2029 22327363
T16 1868751.3 2030 20399955 2029 18687513
T19 6129886 2030 66617825 2029 61298860
T24 5475972.2 2030 59776151 2029 54759722
T40 49288516.6 2030 538228600 2029 492885166
T41 18016211.2 2030 196650812 2029 180162112
U01 3174.7 2030 34655 2029 31747
U11 176268.7 2030 1924495 2029 1762687
U20 8468816 2030 92446277 2029 84688160
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","B74","g","hist","s","1439263289","1439263289","0"),
("2031","US","B78","g","hist","s","0","0","0"),
("2031","US","","g","hist","","0","0","0"),
("2031","US","A01","g","hist","r","94787637","4463813","90323824"),
("2031","US","A18","g","hist","r","325114206","245135745","79978461"),
("2031","US","A36","g","hist","r","521672093","223431341","298240752"),
("2031","US","A44","g","hist","r","54586454","29092762","25493692"),
("2031","US","A50","g","hist","r","18073932","1503130","16570802"),
("2031","US","A59","g","hist","r","16133543","8451407","7682136"),
("2031","US","A60","g","hist","r","11840865","53387","11787478"),
("2031","US","A61","g","hist","r","43545344","4485596","39059748"),
("2031","US","A80","g","hist","r","205491955","2396779","203095176"),
("2031","US","A81","g","hist","r","59530530","151667","59378863"),
("2031","US","A87","g","hist","r","23252982","5165667","18087315"),
("2031","US","A89","g","hist","r","197309615","41118538","156191077"),
("2031","US","A90","g","hist","r","26842604","22006933","4835671"),
("2031","US","A91","g","hist","r","221658939","753585","220905354"),
("2031","US","A92","g","hist","r","290339099","22318892","268020207"),
("2031","US","A93","g","hist","r","30547439","12372","30535067"),
("2031","US","A94","g","hist","r","36681384","5761404","30919980"),
("2031","US","B01","g","hist","s","6607221","6607221","0"),
("2031","US","B21","g","hist","s","200755090","200755090","0"),
("2031","US","B22","g","hist","s","13494234","13494234","0"),
("2031","US","B30","g","hist","s","127078028","127078028","0"),
("2031","US","B42","g","hist","s","128676894","128676894","0"),
("2031","US","B46","g","hist","s","110512181","110512181","0"),
("2031","US","B50","g","hist","s","78028494","78028494","0"),
("2031","US","B54","g","hist","s","1939568","1939568","0"),
("2031","US","B59","g","hist","s","46767664","46767664","0"),
("2031","US","B62","g","hist","s","12594054","12594054","0"),
("2031","US","B66","g","hist","s","10042313","10042313","0"),
("2031","US","B79","g","hist","s","121941920","121941920","0"),
("2031","US","B80","g","hist","s","10109497","10109497","0"),
("2031","US","B89","g","hist","s","741194","741194","0"),
("2031","US","B92","g","hist","s","1578234","1578234","0"),
("2031","US","B93","g","hist","s","154039","154039","0"),
("2031","US","B94","g","hist","s","81564987","81564987","0"),
("2031","US","D49","g","hist","s","6475594740","1792207726","4683387014"),
("2031","US","D64","g","hist","s","62056369","23213489","38842880"),
("2031","US","E00","g","hist","s","9952434517","3095206345","6857228172"),
("2031","US","I89","g","hist","s","203603225","60036220","143567005"),
("2031","US","M00","g","hist","r","-2369212535","-2369212535","0"),
("2031","US","O99","g","hist","r","154202557","81091114","73111443"),
("2031","US","Q79","g","hist","","2157269049","1980477245","176791804"),
("2031","US","R00","g","hist","r","7733826747","3633422101","4100404646"),
("2031","US","R01","g","hist","r","82825128","82629560","195568"),
("2031","US","R02","g","hist","r","680559150","570464036","110095114"),
("2031","US","R03","g","hist","r","28235080","28235080","0"),
("2031","US","R95","g","hist","r","880111164","769450910","110660254"),
("2031","US","R98","g","hist","r","21123491","21123491","0"),
("2031","US","R99","g","hist","r","74689566","60658810","14030756"),
("2031","US","S01","g","hist","s","89904785","5296884","84607901"),
("2031","US","S03","g","hist","s","33971850","25806082","8165768"),
("2031","US","S04","g","hist","s","218377342","128284916","90092426"),
("2031","US","S05","g","hist","s","79935226","84494789.649542","235816"),
("2031","US","S11","g","hist","s","803279368","636985412","166293956"),
("2031","US","S12","g","hist","s","2545208572","39144226","2506064346"),
("2031","US","S14","g","hist","s","16130053","16130053","0"),
("2031","US","S16","g","hist","s","755807429","640917191","114890238"),
("2031","US","S21","g","hist","s","128796264","115729215","13067049"),
("2031","US","S22","g","hist","s","6940538","6765203","175335"),
("2031","US","S23","g","hist","s","227766560","108335780","119430780"),
("2031","US","S24","g","hist","s","184750395","0","184750395"),
("2031","US","S25","g","hist","s","150144116","64556089","85588027"),
("2031","US","S29","g","hist","s","122214837","21567281","100647556"),
("2031","US","S31","g","hist","s","47110718","10686646","36424072"),
("2031","US","S32","g","hist","s","303222493","104092251","199130242"),
("2031","US","S36","g","hist","s","662579850","270379161","392200689"),
("2031","US","S44","g","hist","s","557510525","290343361","267167164"),
("2031","US","S50","g","hist","s","181257766","30691266","150566500"),
("2031","US","S52","g","hist","s","38776080","1105930","37670150"),
("2031","US","S53","g","hist","s","18960722","18960722","0"),
("2031","US","S59","g","hist","s","118253396","65119612","53133784"),
("2031","US","S60","g","hist","s","4829130","38221","4790909"),
("2031","US","S61","g","hist","s","173724225","16641950","157082275"),
("2031","US","S62","g","hist","s","394459574","44859321","349600253"),
("2031","US","S66","g","hist","s","45602904","24729748","20873156"),
("2031","US","S72","g","hist","s","0","0","0"),
("2031","US","S73","g","hist","s","0","0","0"),
("2031","US","S77","g","hist","s","5247135","5247135","0"),
("2031","US","S80","g","hist","s","232630173","2142192","230487981"),
("2031","US","S81","g","hist","s","87587242","2832133","84755109"),
("2031","US","S85","g","hist","s","3568596","3568596","0"),
("2031","US","S87","g","hist","s","20358449","7128774","13229675"),
("2031","US","S89","g","hist","s","539606162","167381572","372224590"),
("2031","US","S90","g","hist","s","23481888","18775797","4706091"),
("2031","US","S91","g","hist","s","292641751","1254790","291386961"),
("2031","US","S92","g","hist","s","307879910","23126220","284753690"),
("2031","US","S93","g","hist","s","28716963","40049","28676914"),
("2031","US","S94","g","hist","s","302845441","42054072","260791369"),
("2031","US","S95","g","hist","s","807469778","640569847","166899931"),
("2031","US","T00","g","hist","r","10103039282","6002634636","4100404646"),
("2031","US","T01","g","hist","r","1657443545","46080113","1611363432"),
("2031","US","T09","g","hist","r","1276439002","918158078","358280924"),
("2031","US","T10","g","hist","r","17761917","15771668","1990249"),
("2031","US","T13","g","hist","r","105381954","100795302","4586652"),
("2031","US","T15","g","hist","r","71551769","26605464","44946305"),
("2031","US","T16","g","hist","r","22872748","22268706","604042"),
("2031","US","T19","g","hist","r","133853792","72747711","61106081"),
("2031","US","T24","g","hist","r","69598391","65252123","4346268"),
("2031","US","T40","g","hist","r","695117378","587517117","107600261"),
("2031","US","T41","g","hist","r","241512064","214667023","26845041"),
("2031","US","U01","g","hist","r","38628513","37830","38590683"),
("2031","US","U11","g","hist","r","10386824","2100764","8286060"),
("2031","US","U20","g","hist","r","174235258","100915093","73320165")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","M00","g","hist","r","-2369212534","-2369212534","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","T00","g","hist","r","10103039282","6002634635","4100404647")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","R00","g","hist","r","7733826748","3633422101","4100404647")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","E00","g","hist","s","9957229897.6495","3100001725.6495","6857228172")
Done