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 355873.8 2031 4463813 2030 4089209
A18 19543251.8 2031 245135745 2030 224563901
A36 17812886.65 2031 223431341 2030 204680934
A44 2319397.45 2031 29092762 2030 26651291
A50 119806.4 2031 1503130 2030 1377018
A59 673781.8 2031 8451407 2030 7742163
A60 4256 2031 53387 2030 48907
A61 357610.4 2031 4485596 2030 4109164
A80 191081.1 2031 2396779 2030 2195641
A81 12176.15 2031 151667 2030 138850
A87 411827.85 2031 5165667 2030 4732164
A89 3278117.5 2031 41118538 2030 37667888
A90 1754485.65 2031 22006933 2030 20160106
A91 60078.95 2031 753585 2030 690344
A92 1779355.7 2031 22318892 2030 20445886
A93 987.05 2031 12372 2030 11333
A94 459323.1 2031 5761404 2030 5277906
B01 526599.25 2031 6607221 2030 6052906
B21 16005040.45 2031 200755090 2030 183907679
B22 1076519.1 2031 13494234 2030 12361056
B30 10129622 2031 127078028 2030 116415268
B42 10258663.35 2031 128676894 2030 117878301
B46 8810495.7 2031 110512181 2030 101237975
B50 6223137.45 2031 78028494 2030 71477823
B54 154630.55 2031 1939568 2030 1776799
B59 3730324.15 2031 46767664 2030 42841007
B62 1004051.2 2031 12594054 2030 11537158
B66 800615.35 2031 10042313 2030 9199560
B79 9721722.4 2031 121941920 2030 111708528
B80 805971.45 2031 10109497 2030 9261106
B89 59098.55 2031 741194 2030 678985
B92 125862.65 2031 1578234 2030 1445747
B93 12280.65 2031 154039 2030 141112
B94 6502703.45 2031 81564987 2030 74720036
D49 142881059.25 2031 1792207726 2030 1641806611
D64 1850676.95 2031 23213489 2030 21265408
E00 251446996.55 2031 3100001726 2030 2835320677
I89 4786306.15 2031 60036220 2030 54998003
M00 -217038433 2031 -2369212534 2030 -2170384330
O99 6510189.45 2031 81091114 2030 74238283
Q79 157891976 2031 1980477245 2030 1814275165
R00 289756213.95 2031 3633422101 2030 3328415560
R01 6586029.85 2031 82629560 2030 75696897
R02 45479825.95 2031 570464036 2030 522590535
R03 2251019.3 2031 28235080 2030 25865586
R95 61343872.15 2031 769450910 2030 704878413
R98 1684054.55 2031 21123491 2030 19350802
R99 4867142.6 2031 60658810 2030 55535502
S01 422290.2 2031 5296884 2030 4852368
S03 2057361.8 2031 25806082 2030 23640438
S04 10227413.1 2031 128284916 2030 117519218
S05 7288854.4 2031 84494790 2030 72888544
2032xx-1
S11 50783154.4 2031 636985412 2030 583529460
S12 3120742.4 2031 39144226 2030 35859234
S14 1285954.2 2031 16130053 2030 14776417
S16 51096614.5 2031 640917191 2030 587131281
S21 9231869.15 2031 115729215 2030 106011458
S22 539280.8 2031 6765203 2030 6197539
S23 8636983.9 2031 108335780 2030 99244218
S24 0 2031 0 2030 0
S25 5146682.95 2031 64556089 2030 59138528
S29 1719434.45 2031 21567281 2030 19757350
S31 851984.7 2031 10686646 2030 9789820
S32 8305426.3 2031 104092251 2030 95349697
S36 21555764.1 2031 270379161 2030 247688883
S44 23147394.1 2031 290343361 2030 265977683
S50 2446837.1 2031 30691266 2030 28115648
S52 88169.5 2031 1105930 2030 1013120
S53 1511628.6 2031 18960722 2030 17369534
S59 5191609.4 2031 65119612 2030 59654760
S60 3047.6 2031 38221 2030 35013
S61 1326766.2 2031 16641950 2030 15245354
S62 3576373.8 2031 44859321 2030 41094717
S66 1971559.7 2031 24729748 2030 22654422
S72 0 2031 0 2030 0
S73 0 2031 0 2030 0
S77 418323.95 2031 5247135 2030 4806794
S80 170859.4 2031 2142192 2030 1962340
S81 225789.35 2031 2832133 2030 2594460
S85 284503.15 2031 3568596 2030 3269119
S87 568335.6 2031 7128774 2030 6530526
S89 13344364.05 2031 167381572 2030 153334873
S90 1496885.55 2031 18775797 2030 17200128
S91 100036.9 2031 1254790 2030 1149488
S92 1843719.15 2031 23126220 2030 21185463
S93 3192.95 2031 40049 2030 36688
S94 3352727.65 2031 42054072 2030 38524885
S95 51068686.4 2031 640569847 2030 586813335
T00 478643007.75 2031 6002634635 2030 5498799890
T01 3673700.35 2031 46080113 2030 42213060
T09 73199422.8 2031 918158078 2030 841106054
T10 1257383.9 2031 15771668 2030 14448106
T13 8035831.5 2031 100795302 2030 92336532
T15 2121099.2 2031 26605464 2030 24372728
T16 1775313.45 2031 22268706 2030 20399955
T19 5823391.7 2031 72747711 2030 66617825
T24 5202173.4 2031 65252123 2030 59776151
T40 46824091.15 2031 587517117 2030 538228600
T41 17115400.45 2031 214667023 2030 196650812
U01 3016.25 2031 37830 2030 34655
U11 167455.55 2031 2100764 2030 1924495
U20 8045375.2 2031 100915093 2030 92446277
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","107475792","4819687","102656105"),
("2032","US","A18","g","hist","r","355526121","264678997","90847124"),
("2032","US","A36","g","hist","r","577192640","241244228","335948412"),
("2032","US","A44","g","hist","r","60152741","31412159","28740582"),
("2032","US","A50","g","hist","r","20266872","1622936","18643936"),
("2032","US","A59","g","hist","r","17819859","9125189","8694670"),
("2032","US","A60","g","hist","r","13454458","57643","13396815"),
("2032","US","A61","g","hist","r","49237055","4843206","44393849"),
("2032","US","A80","g","hist","r","232344986","2587860","229757126"),
("2032","US","A81","g","hist","r","67241216","163843","67077373"),
("2032","US","A87","g","hist","r","26120729","5577495","20543234"),
("2032","US","A89","g","hist","r","220022726","44396656","175626070"),
("2032","US","A90","g","hist","r","29210761","23761419","5449342"),
("2032","US","A91","g","hist","r","250391503","813664","249577839"),
("2032","US","A92","g","hist","r","328055122","24098248","303956874"),
("2032","US","A93","g","hist","r","34721331","13359","34707972"),
("2032","US","A94","g","hist","r","41361334","6220727","35140607"),
("2032","US","B01","g","hist","s","7133820","7133820","0"),
("2032","US","B21","g","hist","s","216760130","216760130","0"),
("2032","US","B22","g","hist","s","14570753","14570753","0"),
("2032","US","B30","g","hist","s","137207650","137207650","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","84251631","84251631","0"),
("2032","US","B54","g","hist","s","2094199","2094199","0"),
("2032","US","B59","g","hist","s","50497988","50497988","0"),
("2032","US","B62","g","hist","s","13598105","13598105","0"),
("2032","US","B66","g","hist","s","10842928","10842928","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","800293","800293","0"),
("2032","US","B92","g","hist","s","1704097","1704097","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","7207476992","1935088785","5272388207"),
("2032","US","D64","g","hist","s","68092938","25064166","43028772"),
("2032","US","E00","g","hist","s","11111899531","3351448723","7760450808"),
("2032","US","I89","g","hist","s","226141689","64822526","161319163"),
("2032","US","M00","g","hist","r","-2586250967","-2586250967","0"),
("2032","US","O99","g","hist","r","168054311","87601303","80453008"),
("2032","US","Q79","g","hist","","2337895812","2138369221","199526591"),
("2032","US","R00","g","hist","r","8552254996","3923178315","4629076681"),
("2032","US","R01","g","hist","r","89431371","89215590","215781"),
("2032","US","R02","g","hist","r","740946257","615943862","125002395"),
("2032","US","R03","g","hist","r","30486099","30486099","0"),
("2032","US","R95","g","hist","r","956441122","830794782","125646340"),
("2032","US","R98","g","hist","r","22807546","22807546","0"),
("2032","US","R99","g","hist","r","80824186","65525953","15298233"),
("2032","US","S01","g","hist","s","101437951","5719174","95718777"),
("2032","US","S03","g","hist","s","37104377","27863444","9240933"),
("2032","US","S04","g","hist","s","240304589","138512329","101792260"),
("2032","US","S05","g","hist","s","92050310","0","266666"),
("2032","US","S11","g","hist","s","875225378","687768566","187456812"),
("2032","US","S12","g","hist","s","2879317881","42264968","2837052913"),
("2032","US","S14","g","hist","s","17416007","17416007","0"),
("2032","US","S16","g","hist","s","821554130","692013806","129540324"),
("2032","US","S21","g","hist","s","139786059","124961084","14824975"),
("2032","US","S22","g","hist","s","7503208","7304484","198724"),
("2032","US","S23","g","hist","s","252278843","116972764","135306079"),
("2032","US","S24","g","hist","s","208911500","0","208911500"),
("2032","US","S25","g","hist","s","166590384","69702772","96887612"),
("2032","US","S29","g","hist","s","136953197","23286715","113666482"),
("2032","US","S31","g","hist","s","52664945","11538631","41126314"),
("2032","US","S32","g","hist","s","337084030","112397677","224686353"),
("2032","US","S36","g","hist","s","735103797","291934925","443168872"),
("2032","US","S44","g","hist","s","616196300","313490755","302705545"),
("2032","US","S50","g","hist","s","203026112","33138103","169888009"),
("2032","US","S52","g","hist","s","43756465","1194100","42562365"),
("2032","US","S53","g","hist","s","20472351","20472351","0"),
("2032","US","S59","g","hist","s","130711006","70311221","60399785"),
("2032","US","S60","g","hist","s","5431825","41269","5390556"),
("2032","US","S61","g","hist","s","196237510","17968716","178268794"),
("2032","US","S62","g","hist","s","443867953","48435695","395432258"),
("2032","US","S66","g","hist","s","50314500","26701308","23613192"),
("2032","US","S72","g","hist","s","0","0","0"),
("2032","US","S73","g","hist","s","0","0","0"),
("2032","US","S77","g","hist","s","5665459","5665459","0"),
("2032","US","S80","g","hist","s","263626551","2313051","261313500"),
("2032","US","S81","g","hist","s","98940387","3057922","95882465"),
("2032","US","S85","g","hist","s","3853099","3853099","0"),
("2032","US","S87","g","hist","s","22689958","7697110","14992848"),
("2032","US","S89","g","hist","s","601137845","180725936","420411909"),
("2032","US","S90","g","hist","s","25591318","20272683","5318635"),
("2032","US","S91","g","hist","s","331959631","1354827","330604804"),
("2032","US","S92","g","hist","s","348474184","24969939","323504245"),
("2032","US","S93","g","hist","s","32640391","43242","32597149"),
("2032","US","S94","g","hist","s","341806791","45406800","296399991"),
("2032","US","S95","g","hist","s","879790772","691638533","188152239"),
("2032","US","T00","g","hist","r","11110354324","6481277643","4629076681"),
("2032","US","T01","g","hist","r","1867708977","49753813","1817955164"),
("2032","US","T09","g","hist","r","1396384399","991357501","405026898"),
("2032","US","T10","g","hist","r","19270265","17029052","2241213"),
("2032","US","T13","g","hist","r","113999432","108831134","5168298"),
("2032","US","T15","g","hist","r","79540827","28726563","50814264"),
("2032","US","T16","g","hist","r","24720487","24044019","676468"),
("2032","US","T19","g","hist","r","147678850","78571103","69107747"),
("2032","US","T24","g","hist","r","75323512","70454296","4869216"),
("2032","US","T40","g","hist","r","755566829","634341208","121225621"),
("2032","US","T41","g","hist","r","262035823","231782423","30253400"),
("2032","US","U01","g","hist","r","43578753","40846","43537907"),
("2032","US","U11","g","hist","r","11582331","2268220","9314111"),
("2032","US","U20","g","hist","r","191719498","108960468","82759030")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","M00","g","hist","r","-2558099327","-2558099327","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","T00","g","hist","r","11110354326","6481277642","4629076684")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","R00","g","hist","r","8552254999","3923178315","4629076684")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","E00","g","hist","s","11016378808","3255927999","7760450809")
Done