return to Menu
0 secs
US
B74 101361595.2 2028 1106471279 2027 1013615952
B74
B78 0 2028 0 2027 0
0 2028 0 2027 0
A01 315270.5 2028 3441530 2027 3152705
A18 14838628.4 2028 162148090 2027 148386284
A36 16444774.3 2028 179513174 2027 164447743
A44 1862064.8 2028 20324004 2027 18620648
A50 78247.124699201 2028 1126084 2027 1080594
A59 568494.1 2028 6205725 2027 5684941
A60 3787.6 2028 41434 2027 37876
A61 320007.5 2028 3493236 2027 3200075
A80 159061.6 2028 1736344 2027 1590616
A81 5356.3205247307 2028 110553 2027 108535
A87 189020.07685386 2028 2662309 2027 2550522
A89 3083777.4 2028 33682437 2027 30837774
A90 1255847 2028 13679118 2027 12558470
A91 47168.6 2028 514995 2027 471686
A92 742939.90499108 2028 9537425 2027 9067701
A93 1477.8 2028 16132 2027 14778
A94 422006.8 2028 4606662 2027 4220068
B01 508609 2028 5484335 2027 5086090
B21 14138383.6 2028 154335723 2027 141383836
B22 1009707.6 2028 11034158 2027 10097076
B30 9630012.5 2028 103563230 2027 96300125
B42 9062202.5 2028 98923725 2027 90622025
B46 7782933.6 2028 84959128 2027 77829336
B50 5886344.3 2028 64078169 2027 58863443
B54 136596.1 2028 1491094 2027 1365961
B59 3517157.8 2028 38343623 2027 35171578
B62 886949.1 2028 9682008 2027 8869491
B66 706935.6 2028 7716963 2027 7069356
B79 8587884.8 2028 93746039 2027 85878848
B80 711971.7 2028 7771940 2027 7119717
B89 56351.9 2028 611191 2027 563519
B92 117366.2 2028 1283875 2027 1173662
B93 10848.4 2028 118422 2027 108484
B94 5744297.8 2028 62705216 2027 57442978
D49 138319219.8 2028 1509866181 2027 1383192198
D64 1614808.3 2028 17627425 2027 16148083
E00 341157235.5 2028 3715650198 2027 3411572355
I89 5090004.8 2028 55562939 2027 50900048
M00 -168262263 2028 -1834921147 2027 -1682622630
O99 3682788.3165436 2028 73936748 2027 72481304
Q79 128918285.8 2028 1407236547 2027 1289182858
R00 311074969.31529 2028 3329220334 2027 3110793562
R01 7350262 2028 80083226 2027 73502620
R02 66996763.7 2028 732853186 2027 669967637
R03 1612745.9 2028 17622191 2027 16127459
R95 82294385.2 2028 898930886 2027 822943852
R98 1910013.4 2028 20849941 2027 19100134
R99 2294214.9590052 2028 46109436 2027 45204399
S01 435506 2028 4754040 2027 4355060
S03 310494.1 2028 3389382 2027 3104941
S04 9261605.8 2028 101100547 2027 92616058
S05 6701103.3905745 2028 73869039 2027 69234204
2029x45038x0.075405921680993
S11 40751987.7 2028 444780929 2027 407519877
S12 3139334.1 2028 34269488 2027 31393341
S14 923542.6 2028 9891265 2027 9235426
S16 45193761 2028 493338492 2027 451937610
S21 8948080.1035047 2028 96289388 2027 90023504
S22 887085.9 2028 9683538 2027 8870859
S23 7971543.9 2028 87018499 2027 79715439
S24 0 2028 0 2027 0
S25 3016174.5 2028 32396379 2027 30161745
S29 1598474 2028 17449097 2027 15984740
S31 756501 2028 8258088 2027 7565010
S32 4560889.8849256 2028 66466423 2027 63842034
S36 19819101.6 2028 216347646 2027 198191016
S44 20627681 2028 225174026 2027 206276810
S50 1076180.8035654 2028 14762304 2027 14112897
S52 72437 2028 790708 2027 724370
S53 1501516.7 2028 16390727 2027 15015167
S59 4656553.8 2028 50831553 2027 46565538
S60 2466 2028 26919 2027 24660
S61 1221144.8 2028 13330186 2027 12211448
S62 3170259.8 2028 34606800 2027 31702598
S66 1963321.3 2028 21431835 2027 19633213
S67 2070299.5 2028 22598720 2027 20702995
S72 0 2028 0 2027 0
S73 0 2028 0 2027 0
S74 115004132.3 2028 1255347942 2027 1150041323
S77 372683.4 2028 4068260 2027 3726834
S79 11672369.9 2028 127411818 2027 116723699
S80 245392.5 2028 2678743 2027 2453925
S81 162001 2028 1768415 2027 1620010
S85 93323.021342843 2028 1328101 2027 1273357
S87 457357.7 2028 4992564 2027 4573577
S89 10208258.5 2028 111582348 2027 102082585
S90 1169810.2 2028 12773369 2027 11698102
S91 101274.3 2028 1105498 2027 1012743
S92 1104638.8 2028 11914665 2027 11046388
S93 1293.0841172328 2028 18052 2027 17282
S94 2740875.6 2028 29919726 2027 27408756
S95 50703204.2 2028 553483458 2027 507032042
T00 479341619.2 2028 5164141481 2027 4793416192
T01 3628551.4 2028 39605446 2027 36285514
T09 67867293 2028 740794215 2027 678672930
T10 1237092.7 2028 13503171 2027 12370927
T13 8680668.8 2028 94751182 2027 86806688
T15 2214261.1 2028 24168155 2027 22142611
T16 2278650.5 2028 24872214 2027 22786505
T19 9393792.2 2028 102536905 2027 93937922
T24 206243.24315468 2028 30637468 2027 31423642
T40 31573089.430311 2028 574419427 2027 559994865
T41 2072889.5612438 2028 163637998 2027 166814593
U01 3354.2 2028 36612 2027 33542
U11 75903.081683124 2028 1268926 2027 1230581
U20 9587867.3 2028 104694635 2027 95878673
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","B74","g","hist","s","1207832874","1207832874","0"),
("2029","US","B78","g","hist","s","0","0","0"),
("2029","US","","g","hist","","0","0","0"),
("2029","US","A01","g","hist","r","70827111","3756801","67070310"),
("2029","US","A18","g","hist","r","226169664","176986718","49182946"),
("2029","US","A36","g","hist","r","322838870","195957948","126880922"),
("2029","US","A44","g","hist","r","44994675","22186069","22808606"),
("2029","US","A50","g","hist","r","11772864","1204331","10568533"),
("2029","US","A59","g","hist","r","9201358","6774219","2427139"),
("2029","US","A60","g","hist","r","4909346","45222","4864124"),
("2029","US","A61","g","hist","r","26546305","3813244","22733061"),
("2029","US","A80","g","hist","r","119451654","1895406","117556248"),
("2029","US","A81","g","hist","r","31313885","115909","31197976"),
("2029","US","A87","g","hist","r","12666137","2851329","9814808"),
("2029","US","A89","g","hist","r","209518658","36766214","172752444"),
("2029","US","A90","g","hist","r","21315298","14934965","6380333"),
("2029","US","A91","g","hist","r","153459031","562164","152896867"),
("2029","US","A92","g","hist","r","137657536","10280365","127377171"),
("2029","US","A93","g","hist","r","7842170","17610","7824560"),
("2029","US","A94","g","hist","r","26019583","5028669","20990914"),
("2029","US","B01","g","hist","s","5992944","5992944","0"),
("2029","US","B21","g","hist","s","168474107","168474107","0"),
("2029","US","B22","g","hist","s","12043866","12043866","0"),
("2029","US","B30","g","hist","s","113193243","113193243","0"),
("2029","US","B42","g","hist","s","107985928","107985928","0"),
("2029","US","B46","g","hist","s","92742062","92742062","0"),
("2029","US","B50","g","hist","s","69964513","69964513","0"),
("2029","US","B54","g","hist","s","1627690","1627690","0"),
("2029","US","B59","g","hist","s","41860781","41860781","0"),
("2029","US","B62","g","hist","s","10568957","10568957","0"),
("2029","US","B66","g","hist","s","8423899","8423899","0"),
("2029","US","B79","g","hist","s","102333924","102333924","0"),
("2029","US","B80","g","hist","s","8483912","8483912","0"),
("2029","US","B89","g","hist","s","667543","667543","0"),
("2029","US","B92","g","hist","s","1401241","1401241","0"),
("2029","US","B93","g","hist","s","129270","129270","0"),
("2029","US","B94","g","hist","s","68449514","68449514","0"),
("2029","US","D49","g","hist","s","5306706866","1648185401","3658521465"),
("2029","US","D64","g","hist","s","101586782","19242233","82344549"),
("2029","US","E00","g","hist","s","9018868138","4056807434","4962060704"),
("2029","US","I89","g","hist","s","194850198","60652944","134197254"),
("2029","US","M00","g","hist","r","-2003183410","-2003183410","0"),
("2029","US","O99","g","hist","r","176116557","77619536","98497021"),
("2029","US","Q79","g","hist","","1664890169","1536154833","128735336"),
("2029","US","R00","g","hist","r","6939489802","3640295303","3299194499"),
("2029","US","R01","g","hist","r","87715007","87433488","281519"),
("2029","US","R02","g","hist","r","966425680","799849950","166575730"),
("2029","US","R03","g","hist","r","19234937","19234937","0"),
("2029","US","R95","g","hist","r","1158546422","981225271","177321151"),
("2029","US","R98","g","hist","r","22759954","22759954","0"),
("2029","US","R99","g","hist","r","65049373","48403651","16645722"),
("2029","US","S01","g","hist","s","80145070","5189546","74955524"),
("2029","US","S03","g","hist","s","5846792","3699876","2146916"),
("2029","US","S04","g","hist","s","171788757","110362153","61426604"),
("2029","US","S05","g","hist","s","80716757","86645607.817479","146615"),
("2029","US","S11","g","hist","s","604558060","485532917","119025143"),
("2029","US","S12","g","hist","s","1764937946","37408822","1727529124"),
("2029","US","S14","g","hist","s","10814808","10814808","0"),
("2029","US","S16","g","hist","s","634283127","538532253","95750874"),
("2029","US","S21","g","hist","s","113523974","105237468","8286506"),
("2029","US","S22","g","hist","s","10684926","10570624","114302"),
("2029","US","S23","g","hist","s","181983104","94990043","86993061"),
("2029","US","S24","g","hist","s","140263805","0","140263805"),
("2029","US","S25","g","hist","s","99015267","35412554","63602713"),
("2029","US","S29","g","hist","s","90749032","19047571","71701461"),
("2029","US","S31","g","hist","s","35021160","9014589","26006571"),
("2029","US","S32","g","hist","s","234752916","71027313","163725603"),
("2029","US","S36","g","hist","s","397005780","236166748","160839032"),
("2029","US","S44","g","hist","s","460505889","245801707","214704182"),
("2029","US","S50","g","hist","s","135868524","15838485","120030039"),
("2029","US","S52","g","hist","s","34047409","863145","33184264"),
("2029","US","S53","g","hist","s","17892244","17892244","0"),
("2029","US","S59","g","hist","s","88900144","55488107","33412037"),
("2029","US","S60","g","hist","s","3952384","29385","3922999"),
("2029","US","S61","g","hist","s","132764916","14551331","118213585"),
("2029","US","S62","g","hist","s","300227521","37777060","262450461"),
("2029","US","S66","g","hist","s","40823777","23395156","17428621"),
("2029","US","S67","g","hist","s","49125645","24669020","24456625"),
("2029","US","S72","g","hist","s","0","0","0"),
("2029","US","S73","g","hist","s","0","0","0"),
("2029","US","S74","g","hist","s","1382010527","1370352074","11658453"),
("2029","US","S77","g","hist","s","4440943","4440943","0"),
("2029","US","S79","g","hist","s","233055581","139084188","93971393"),
("2029","US","S80","g","hist","s","172910494","2924136","169986358"),
("2029","US","S81","g","hist","s","62318871","1930416","60388455"),
("2029","US","S85","g","hist","s","1421424","1421424","0"),
("2029","US","S87","g","hist","s","16665734","5449922","11215812"),
("2029","US","S89","g","hist","s","445539927","121790607","323749320"),
("2029","US","S90","g","hist","s","15504999","13943179","1561820"),
("2029","US","S91","g","hist","s","211871535","1206772","210664763"),
("2029","US","S92","g","hist","s","148535193","13019304","135515889"),
("2029","US","S93","g","hist","s","7095235","19345","7075890"),
("2029","US","S94","g","hist","s","204419234","32660602","171758632"),
("2029","US","S95","g","hist","s","740216590","604186662","136029928"),
("2029","US","T00","g","hist","r","8942677599","5643483100","3299194499"),
("2029","US","T01","g","hist","r","1508681387","43233997","1465447390"),
("2029","US","T09","g","hist","r","1097212927","808661508","288551419"),
("2029","US","T10","g","hist","r","16413619","14740264","1673355"),
("2029","US","T13","g","hist","r","108156735","103431851","4724884"),
("2029","US","T15","g","hist","r","61749453","26382416","35367037"),
("2029","US","T16","g","hist","r","27666837","27150865","515972"),
("2029","US","T19","g","hist","r","155214757","111930697","43284060"),
("2029","US","T24","g","hist","r","41438219","30843711","10594508"),
("2029","US","T40","g","hist","r","659090184","605992516","53097668"),
("2029","US","T41","g","hist","r","202057967","165710888","36347079"),
("2029","US","U01","g","hist","r","22235576","39966","22195610"),
("2029","US","U11","g","hist","r","8442377","1344829","7097548"),
("2029","US","U20","g","hist","r","209253517","114282502","94971015")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","M00","g","hist","r","-2003183412","-2003183412","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","T00","g","hist","r","8894602620","5595408121","3299194499")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","R00","g","hist","r","6891419208","3592224709","3299194499")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","E00","g","hist","s","9022474151.8175","4060413445.8175","4962060706")
Done