return to Menu
0 secs
US
B74 114744122.65 2031 1439263289 2030 1318480002
B74
B78 0 2031 0 2030 0
0 2031 0 2030 0
A01 356896 2031 4476634 2030 4100954
A18 16813738.4 2031 209499979 2030 191801307
A36 18616005.25 2031 233505060 2030 213909265
A44 2107676.65 2031 26437545 2030 24218938
A50 94538.3 2031 1362926 2030 1263412
A59 643550.9 2031 8072214 2030 7394792
A60 4295.9 2031 53002 2030 48480
A61 362257.8 2031 4543892 2030 4162568
A80 180063.95 2031 2258581 2030 2069040
A81 6865.65 2031 126434 2030 119207
A87 227630.45 2031 3234888 2030 2995277
A89 3492789.95 2031 43564235 2030 39887614
A90 1418822.15 2031 17475968 2030 15982471
A91 53405.2 2031 666122 2030 609906
A92 882968 2031 11795377 2030 10865937
A93 1672.95 2031 20984 2030 19223
A94 477723.65 2031 5992428 2030 5489561
B01 559305.85 2031 6970718 2030 6381975
B21 16005040.45 2031 200755090 2030 183907679
B22 1144167.65 2031 14094680 2030 12890293
B30 10294834.6 2031 131089964 2030 120253296
B42 10258663.35 2031 128676894 2030 117878301
B46 8810495.7 2031 110512181 2030 101237975
B50 6646628.45 2031 81866355 2030 74869904
B54 154630.55 2031 1939568 2030 1776799
B59 3976774.1 2031 48984461 2030 44798383
B62 1004051.2 2031 12594054 2030 11537158
B66 800270.5 2031 10037985 2030 9195595
B79 9721722.4 2031 121941920 2030 111708528
B80 805971.45 2031 10109497 2030 9261106
B89 63416.3 2031 780997 2030 714243
B92 133117.8 2031 1642702 2030 1502578
B93 12280.65 2031 154039 2030 141112
B94 6502703.45 2031 81564987 2030 74720036
D49 156577613 2031 1964064341 2030 1799245801
D64 1828011.85 2031 22929199 2030 21004976
E00 386958102.1 2031 4821998959 2030 4414674641
I89 5762029.3 2031 72274532 2030 66209238
M00 -218052221 2031 -2380347342 2030 -2180522210
O99 4696675.55 2031 84877986 2030 79934117
Q79 145934708.85 2031 1830562806 2030 1676947323
R00 174904269.15 2031 4975329242 2030 4791219485
R01 8306181.55 2031 102310261 2030 93566912
R02 75985745.25 2031 938006326 2030 858021331
R03 1827319.3 2031 22779937 2030 20856443
R95 93216400.65 2031 1162647263 2030 1064524736
R98 2162195.25 2031 27120943 2030 24844948
R99 2926445.55 2031 52924921 2030 49844452
S01 493007.25 2031 6183905 2030 5664950
S03 351488.6 2031 4408968 2030 4038980
S04 10484404.25 2031 131508423 2030 120472208
S05 9058500.2 2031 103300898 2030 90585002
2032xx-1
S11 46125627.4 2031 575330546 2030 526777254
S12 3553837.9 2031 44576653 2030 40835771
S14 943975.1 2031 12440632 2030 11446974
S16 51160563.75 2031 641719327 2030 587866102
S21 9115336.45 2031 120908840 2030 111313749
S22 1004208.9 2031 12596040 2030 11538978
S23 9024053.8 2031 113190897 2030 103691893
S24 0 2031 0 2030 0
S25 3181607 2031 40928503 2030 37579443
S29 1809519.15 2031 22697238 2030 20792481
S31 856386.05 2031 10742260 2030 9840801
S32 5520827.15 2031 80264605 2030 74453208
S36 22435841.25 2031 281418188 2030 257801513
S44 23351162.45 2031 292899281 2030 268319110
S50 1291014.85 2031 18025468 2030 16666505
S52 81999.25 2031 1028570 2030 942255
S53 1699762.8 2031 21320541 2030 19531317
S59 5271370.45 2031 66120073 2030 60571262
S60 2792.05 2031 35016 2030 32077
S61 1382376.35 2031 17339483 2030 15884350
S62 3588820.7 2031 45015446 2030 41237740
S66 2222540.2 2031 27877856 2030 25538340
S67 2343556.9 2031 29396900 2030 26929998
S72 0 2031 0 2030 0
S73 0 2031 0 2030 0
S74 130183446.65 2031 1632983517 2030 1495948310
S77 421889.3 2031 5291863 2030 4847769
S79 13212998.05 2031 165740024 2030 151831605
S80 277793.3 2031 3484424 2030 3192010
S81 183389.9 2031 2300300 2030 2107258
S85 112557.9 2031 1610683 2030 1492201
S87 517742.4 2031 6494170 2030 5949178
S89 11570107.95 2031 143786236 2030 131607175
S90 1324602.1 2031 16521524 2030 15127206
S91 114643.15 2031 1438052 2030 1317375
S92 1218298.05 2031 15150335 2030 13867916
S93 1555.15 2031 21970 2030 20333
S94 3102757 2031 38918635 2030 35652575
S95 57397732.7 2031 719953674 2030 659535008
T00 364738144.55 2031 7355676584 2030 6971741695
T01 -1781433.95 2031 33466979 2030 35628679
T09 -35497492.7 2031 669516779 2030 709949854
T10 -512640.1 2031 9515789 2030 10252802
T13 -4206349 2031 78955387 2030 84126980
T15 -1159238.45 2031 21865648 2030 23184769
T16 -838398.55 2031 15410428 2030 16767971
T19 -3061331.8 2031 55630101 2030 61226636
T24 2930152.45 2031 249882758 2030 246798387
T40 57569289.4 2031 1150366887 2030 1089767635
T41 15742534.55 2031 752651775 2030 736080686
U01 3797.15 2031 47626 2030 43629
U11 93945.5 2031 1497265 2030 1398375
U20 10856837.5 2031 135415177 2030 123986927
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","B74","g","hist","s","1554007412","1554007412","0"),
("2032","US","B78","g","hist","s","0","0","0"),
("2032","US","","g","hist","","0","0","0"),
("2032","US","A01","g","hist","r","105560622","4833530","100727092"),
("2032","US","A18","g","hist","r","297545014","226313717","71231297"),
("2032","US","A36","g","hist","r","406022973","252121065","153901908"),
("2032","US","A44","g","hist","r","60969256","28545222","32424034"),
("2032","US","A50","g","hist","r","15610284","1457464","14152820"),
("2032","US","A59","g","hist","r","11653551","8715765","2937786"),
("2032","US","A60","g","hist","r","6653804","57298","6596506"),
("2032","US","A61","g","hist","r","37468409","4906150","32562259"),
("2032","US","A80","g","hist","r","165241901","2438645","162803256"),
("2032","US","A81","g","hist","r","41883409","133300","41750109"),
("2032","US","A87","g","hist","r","17351895","3462518","13889377"),
("2032","US","A89","g","hist","r","297178332","47057025","250121307"),
("2032","US","A90","g","hist","r","28202654","18894790","9307864"),
("2032","US","A91","g","hist","r","216771945","719527","216052418"),
("2032","US","A92","g","hist","r","186527488","12678345","173849143"),
("2032","US","A93","g","hist","r","9510696","22657","9488039"),
("2032","US","A94","g","hist","r","37091945","6470152","30621793"),
("2032","US","B01","g","hist","s","7530024","7530024","0"),
("2032","US","B21","g","hist","s","216760130","216760130","0"),
("2032","US","B22","g","hist","s","15238848","15238848","0"),
("2032","US","B30","g","hist","s","141384799","141384799","0"),
("2032","US","B42","g","hist","s","138935557","138935557","0"),
("2032","US","B46","g","hist","s","119322677","119322677","0"),
("2032","US","B50","g","hist","s","88512983","88512983","0"),
("2032","US","B54","g","hist","s","2094199","2094199","0"),
("2032","US","B59","g","hist","s","52961235","52961235","0"),
("2032","US","B62","g","hist","s","13598105","13598105","0"),
("2032","US","B66","g","hist","s","10838256","10838256","0"),
("2032","US","B79","g","hist","s","131663642","131663642","0"),
("2032","US","B80","g","hist","s","10915468","10915468","0"),
("2032","US","B89","g","hist","s","844413","844413","0"),
("2032","US","B92","g","hist","s","1775820","1775820","0"),
("2032","US","B93","g","hist","s","166320","166320","0"),
("2032","US","B94","g","hist","s","88067690","88067690","0"),
("2032","US","D49","g","hist","s","7295162051","2120641954","5174520097"),
("2032","US","D64","g","hist","s","144861911","24757211","120104700"),
("2032","US","E00","g","hist","s","12308840256","5208957061","7099883195"),
("2032","US","I89","g","hist","s","270317802","78036561","192281241"),
("2032","US","M00","g","hist","r","-2598399563","-2598399563","0"),
("2032","US","O99","g","hist","r","218986103","89574662","129411441"),
("2032","US","Q79","g","hist","","2157995858","1976497515","181498343"),
("2032","US","R00","g","hist","r","8723807669","5150233511","3573574158"),
("2032","US","R01","g","hist","r","111024863","110616443","408420"),
("2032","US","R02","g","hist","r","1240460163","1013992071","226468092"),
("2032","US","R03","g","hist","r","24607256","24607256","0"),
("2032","US","R95","g","hist","r","1500517459","1255863664","244653795"),
("2032","US","R98","g","hist","r","29283138","29283138","0"),
("2032","US","R99","g","hist","r","74949033","55851367","19097666"),
("2032","US","S01","g","hist","s","116358090","6676912","109681178"),
("2032","US","S03","g","hist","s","7323886","4760457","2563429"),
("2032","US","S04","g","hist","s","228467273","141992827","86474446"),
("2032","US","S05","g","hist","s","112553401","0","194003"),
("2032","US","S11","g","hist","s","787462958","621456173","166006785"),
("2032","US","S12","g","hist","s","2506551914","48130491","2458421423"),
("2032","US","S14","g","hist","s","13384607","13384607","0"),
("2032","US","S16","g","hist","s","830223912","692879891","137344021"),
("2032","US","S21","g","hist","s","142110167","130024176","12085991"),
("2032","US","S22","g","hist","s","13765261","13600249","165012"),
("2032","US","S23","g","hist","s","247285606","122214951","125070655"),
("2032","US","S24","g","hist","s","201282044","0","201282044"),
("2032","US","S25","g","hist","s","135968169","44110110","91858059"),
("2032","US","S29","g","hist","s","125261673","24506757","100754916"),
("2032","US","S31","g","hist","s","48241722","11598646","36643076"),
("2032","US","S32","g","hist","s","319634584","85785432","233849152"),
("2032","US","S36","g","hist","s","505133440","303854029","201279411"),
("2032","US","S44","g","hist","s","638810186","316250443","322559743"),
("2032","US","S50","g","hist","s","189188582","19316483","169872099"),
("2032","US","S52","g","hist","s","49349670","1110569","48239101"),
("2032","US","S53","g","hist","s","23020304","23020304","0"),
("2032","US","S59","g","hist","s","119891111","71391443","48499668"),
("2032","US","S60","g","hist","s","5584288","37808","5546480"),
("2032","US","S61","g","hist","s","194313087","18721859","175591228"),
("2032","US","S62","g","hist","s","426269779","48604267","377665512"),
("2032","US","S66","g","hist","s","55527158","30100396","25426762"),
("2032","US","S67","g","hist","s","66294212","31740457","34553755"),
("2032","US","S72","g","hist","s","0","0","0"),
("2032","US","S73","g","hist","s","0","0","0"),
("2032","US","S74","g","hist","s","1779638714","1763166964","16471750"),
("2032","US","S77","g","hist","s","5713752","5713752","0"),
("2032","US","S79","g","hist","s","311721314","178953022","132768292"),
("2032","US","S80","g","hist","s","251940160","3762217","248177943"),
("2032","US","S81","g","hist","s","89061397","2483690","86577707"),
("2032","US","S85","g","hist","s","1723241","1723241","0"),
("2032","US","S87","g","hist","s","23463314","7011912","16451402"),
("2032","US","S89","g","hist","s","622996580","155356344","467640236"),
("2032","US","S90","g","hist","s","19731069","17846126","1884943"),
("2032","US","S91","g","hist","s","313297060","1552695","311744365"),
("2032","US","S92","g","hist","s","205116048","16368633","188747415"),
("2032","US","S93","g","hist","s","8574120","23525","8550595"),
("2032","US","S94","g","hist","s","298980750","42021392","256959358"),
("2032","US","S95","g","hist","s","972192788","777351407","194841381"),
("2032","US","T00","g","hist","r","11293988887","7720414729","3573574158"),
("2032","US","T01","g","hist","r","1276515564","31685545","1244830019"),
("2032","US","T09","g","hist","r","777786045","634019286","143766759"),
("2032","US","T10","g","hist","r","9715011","9003149","711862"),
("2032","US","T13","g","hist","r","78247506","74749038","3498468"),
("2032","US","T15","g","hist","r","45977981","20706410","25271571"),
("2032","US","T16","g","hist","r","14792480","14572029","220451"),
("2032","US","T19","g","hist","r","71361562","52568769","18792793"),
("2032","US","T24","g","hist","r","278386212","252812910","25573302"),
("2032","US","T40","g","hist","r","1365676456","1207936176","157740280"),
("2032","US","T41","g","hist","r","861813451","768394310","93419141"),
("2032","US","U01","g","hist","r","29351457","51423","29300034"),
("2032","US","U11","g","hist","r","11611909","1591211","10020698"),
("2032","US","U20","g","hist","r","275565147","146272015","129293132")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","M00","g","hist","r","-2570181217","-2570181217","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","T00","g","hist","r","11307536732","7727295595","3580241137")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","R00","g","hist","r","8737355515","5157114378","3580241137")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","E00","g","hist","s","12193459255","5093576059","7099883196")
Done