return to Menu
0 secs
US
B74 92855327 2027 1013615952 2026 928553270
B74
B78 0 2027 0 2026 0
0 2027 0 2026
A01 270014.9 2027 2947504 2026 2700149
A18 17006059.8 2027 185639493 2026 170060598
A36 13964995 2027 152442990 2026 139649950
A44 1927151.4 2027 21036933 2026 19271514
A50 182063.2 2027 1987416 2026 1820632
A59 523888.1 2027 5718802 2026 5238881
A60 4620.8 2027 50441 2026 46208
A61 280126.8 2027 3057884 2026 2801268
A80 150341.2 2027 1641712 2026 1503412
A81 39089.2 2027 426701 2026 390892
A87 415355.7 2027 4534053 2026 4153557
A89 3429986.1 2027 37442075 2026 34299861
A90 1583220.7 2027 17282562 2026 15832207
A91 51475.5 2027 561910 2026 514755
A92 1360742 2027 14853968 2026 13607420
A93 605.37274525254 2027 8982 2026 8619
A94 315505.7 2027 3444083 2026 3155057
B01 297711.63599813 2027 5067991 2026 4909344
B21 12951886.7 2027 141383836 2026 129518867
B22 739737.99685114 2027 10056662 2026 9585036
B30 4702419.3089724 2027 93563221 2026 91469937
B42 8301700 2027 90622025 2026 83017000
B46 7129791.9 2027 77829336 2026 71297919
B50 4060468.8517611 2027 58635450 2026 56151504
B54 125133 2027 1365961 2026 1251330
B59 2483219.4215348 2027 35033624 2026 33489340
B62 812516.5 2027 8869491 2026 8125165
B66 650936.7 2027 7105678 2026 6509367
B79 7867191 2027 85878848 2026 78671910
B80 652223 2027 7119717 2026 6522230
B89 36587.891727734 2027 561405 2026 540032
B92 89837.493806022 2027 1168849 2026 1109970
B93 9938 2027 108484 2026 99380
B94 5262238 2027 57442978 2026 52622380
D49 96189174.407904 2027 1155263339 2026 1089283568
D64 751268.94955603 2027 11003677 2026 10548827
E00 340935906.7 2027 3715124575 2026 3409359067
I89 2860876.0122359 2027 37524301 2026 35658528
M00 -154880944.9 2027 -1679454339 2026 -1548809449
O99 20319348.8 2027 221807468 2026 203193488
Q79 127772217.5 2027 1394771437 2026 1277722175
R00 284824305.4 2027 3103035055 2026 2848243054
R01 5738374.2868252 2027 75416422 2026 71678609
R02 632574.00141106 2027 22427756 2026 22446643
R03 1718712 2027 18775643 2026 17187120
R95 22068335.6 2027 241250642 2026 220683356
R98 1620769.8 2027 17692453 2026 16207698
R99 12816647.9 2027 139907453 2026 128166479
S01 345889.5 2027 3777230 2026 3458895
S03 107508.24407498 2027 1758265 2026 1698781
S04 8301575.4 2027 90620639 2026 83015754
S05 7703082.8911081 2027 103629174 2026 98684626
2028x48519x0.034498198332658
S11 43501423.8 2027 474864631 2026 435014238
S12 2370157.4 2027 25884074 2026 23701574
S14 1272399.5 2027 13889612 2026 12723995
S16 41732126.6 2027 455551190 2026 417321266
S21 12486527.5 2027 136303894 2026 124865275
S22 648931.6 2027 7016935 2026 6489316
S23 6547173.2 2027 71469398 2026 65471732
S24 0 2027 0 2026 0
S25 4095999.3 2027 44712248 2026 40959993
S29 1421357.1 2027 15515647 2026 14213571
S31 547712.4 2027 5981297 2026 5477124
S32 10961372.4 2027 119655219 2026 109613724
S36 16986871.7 2027 185430022 2026 169868717
S44 17955580.5 2027 196004419 2026 179555805
S50 2196143.1 2027 23973260 2026 21961431
S52 71544.8 2027 780989 2026 715448
S53 1296528.1 2027 14152996 2026 12965281
S59 3891923.6 2027 42484544 2026 38919236
S60 2352.2 2027 25677 2026 23522
S61 1007478.4 2027 10997712 2026 10074784
S62 2919131.6 2027 31865468 2026 29191316
S66 1701225.9 2027 18570713 2026 17012259
S72 0 2027 0 2026 0
S73 0 2027 0 2026 0
S74 111474698.6 2027 1216866641 2026 1114746986
S77 342999.5 2027 3745846 2026 3429995
S79 16153100 2027 176328944 2026 161531000
S80 236316.2 2027 2579646 2026 2363162
S81 132670.6 2027 1442952 2026 1326706
S85 210470.2 2027 2297511 2026 2104702
S87 401966.9 2027 4387903 2026 4019669
S89 11905545.9 2027 129961816 2026 119055459
S90 1277959.1 2027 13950330 2026 12779591
S91 70444.2 2027 769333 2026 704442
S92 1467759 2027 16022174 2026 14677590
S93 1864.0562207689 2027 23129 2026 21873
S94 1172473.2600525 2027 18054642 2026 17371696
S95 44027472 2027 481307519 2026 440274720
T00 439705250.3 2027 4782489394 2026 4397052503
T01 3053768.4 2027 33335172 2026 30537684
T09 60921256.6 2027 665021119 2026 609212566
T10 1165007.3 2027 12717313 2026 11650073
T13 7761321.2 2027 84723191 2026 77613212
T15 1705529.3 2027 18617740 2026 17055293
T16 2114179.4 2027 23042864 2026 21141794
T19 13972932.9 2027 152529643 2026 139729329
T24 4627884.8 2027 50518363 2026 46278848
T40 78864592.6 2027 860892145 2026 788645926
T41 20402550.2 2027 222716531 2026 204025502
U01 1205.1581674678 2027 16494 2026 15729
U11 251977.6 2027 2750606 2026 2519776
U20 1893082.4297153 2027 27049170 2026 25882305
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","B74","g","hist","s","1106471279","1106471279","0"),
("2028","US","B78","g","hist","s","0","0","0"),
("2028","US","","g","hist","","0","0","0"),
("2028","US","A01","g","hist","r","58066942","3217519","54849423"),
("2028","US","A18","g","hist","r","249852167","202645553","47206614"),
("2028","US","A36","g","hist","r","462713719","166407985","296305734"),
("2028","US","A44","g","hist","r","48050690","22964084","25086606"),
("2028","US","A50","g","hist","r","15822076","2169479","13652597"),
("2028","US","A59","g","hist","r","11634025","6242690","5391335"),
("2028","US","A60","g","hist","r","7097990","55062","7042928"),
("2028","US","A61","g","hist","r","26943928","3338011","23605917"),
("2028","US","A80","g","hist","r","126257835","1792053","124465782"),
("2028","US","A81","g","hist","r","40660217","465790","40194427"),
("2028","US","A87","g","hist","r","15170265","4949409","10220856"),
("2028","US","A89","g","hist","r","191517430","40872061","150645369"),
("2028","US","A90","g","hist","r","23188478","18865783","4322695"),
("2028","US","A91","g","hist","r","136145189","613386","135531803"),
("2028","US","A92","g","hist","r","175083229","16214710","158868519"),
("2028","US","A93","g","hist","r","18828925","9587","18819338"),
("2028","US","A94","g","hist","r","22753074","3759589","18993485"),
("2028","US","B01","g","hist","s","5365703","5365703","0"),
("2028","US","B21","g","hist","s","154335723","154335723","0"),
("2028","US","B22","g","hist","s","10796400","10796400","0"),
("2028","US","B30","g","hist","s","98265640","98265640","0"),
("2028","US","B42","g","hist","s","98923725","98923725","0"),
("2028","US","B46","g","hist","s","84959128","84959128","0"),
("2028","US","B50","g","hist","s","62695919","62695919","0"),
("2028","US","B54","g","hist","s","1491094","1491094","0"),
("2028","US","B59","g","hist","s","37516843","37516843","0"),
("2028","US","B62","g","hist","s","9682008","9682008","0"),
("2028","US","B66","g","hist","s","7756615","7756615","0"),
("2028","US","B79","g","hist","s","93746039","93746039","0"),
("2028","US","B80","g","hist","s","7771940","7771940","0"),
("2028","US","B89","g","hist","s","597993","597993","0"),
("2028","US","B92","g","hist","s","1258686","1258686","0"),
("2028","US","B93","g","hist","s","118422","118422","0"),
("2028","US","B94","g","hist","s","62705216","62705216","0"),
("2028","US","D49","g","hist","s","3954663921","1251452513","2703211408"),
("2028","US","D64","g","hist","s","54208546","11754946","42453600"),
("2028","US","E00","g","hist","s","8517746462","4056060482","4461685980"),
("2028","US","I89","g","hist","s","133094261","40385177","92709084"),
("2028","US","M00","g","hist","r","-1834335284","-1834335284","0"),
("2028","US","O99","g","hist","r","387949598","242126817","145822781"),
("2028","US","Q79","g","hist","","1642485436","1522543655","119941781"),
("2028","US","R00","g","hist","r","6489016958","3387859360","3101157598"),
("2028","US","R01","g","hist","r","81235037","81154796","80241"),
("2028","US","R02","g","hist","r","36616181","23060330","13555851"),
("2028","US","R03","g","hist","r","20494355","20494355","0"),
("2028","US","R95","g","hist","r","300209680","263318978","36890702"),
("2028","US","R98","g","hist","r","19313223","19313223","0"),
("2028","US","R99","g","hist","r","259610823","152724101","106886722"),
("2028","US","S01","g","hist","s","35250106","4123120","31126986"),
("2028","US","S03","g","hist","s","6631608","1865773","4765835"),
("2028","US","S04","g","hist","s","156845962","98922214","57923748"),
("2028","US","S05","g","hist","s","111332257","115173019.28281","0"),
("2028","US","S11","g","hist","s","635729198","518366055","117363143"),
("2028","US","S12","g","hist","s","1716189998","28254231","1687935767"),
("2028","US","S14","g","hist","s","15162012","15162012","0"),
("2028","US","S16","g","hist","s","568673559","497283317","71390242"),
("2028","US","S21","g","hist","s","152916756","148790422","4126334"),
("2028","US","S22","g","hist","s","7713849","7665867","47982"),
("2028","US","S23","g","hist","s","123818622","78016571","45802051"),
("2028","US","S24","g","hist","s","119701055","0","119701055"),
("2028","US","S25","g","hist","s","99013538","48808247","50205291"),
("2028","US","S29","g","hist","s","91275794","16937004","74338790"),
("2028","US","S31","g","hist","s","31281453","6529009","24752444"),
("2028","US","S32","g","hist","s","276989729","130616591","146373138"),
("2028","US","S36","g","hist","s","496340473","202416894","293923579"),
("2028","US","S44","g","hist","s","337777705","213960000","123817705"),
("2028","US","S50","g","hist","s","150416261","26169403","124246858"),
("2028","US","S52","g","hist","s","26373617","852534","25521083"),
("2028","US","S53","g","hist","s","15449524","15449524","0"),
("2028","US","S59","g","hist","s","75036978","46376468","28660510"),
("2028","US","S60","g","hist","s","3208766","28029","3180737"),
("2028","US","S61","g","hist","s","96773371","12005190","84768181"),
("2028","US","S62","g","hist","s","244190583","34784600","209405983"),
("2028","US","S66","g","hist","s","32633144","20271939","12361205"),
("2028","US","S72","g","hist","s","0","0","0"),
("2028","US","S73","g","hist","s","0","0","0"),
("2028","US","S74","g","hist","s","1339130921","1328341340","10789581"),
("2028","US","S77","g","hist","s","4088846","4088846","0"),
("2028","US","S79","g","hist","s","340441397","192482044","147959353"),
("2028","US","S80","g","hist","s","122205930","2815962","119389968"),
("2028","US","S81","g","hist","s","49224954","1575623","47649331"),
("2028","US","S85","g","hist","s","2507981","2507981","0"),
("2028","US","S87","g","hist","s","11013646","4789870","6223776"),
("2028","US","S89","g","hist","s","419211340","141867362","277343978"),
("2028","US","S90","g","hist","s","18804712","15228289","3576423"),
("2028","US","S91","g","hist","s","133355891","839777","132516114"),
("2028","US","S92","g","hist","s","169796836","17489933","152306903"),
("2028","US","S93","g","hist","s","17581262","24993","17556269"),
("2028","US","S94","g","hist","s","131153668","19227115","111926553"),
("2028","US","S95","g","hist","s","621839485","525334991","96504494"),
("2028","US","T00","g","hist","r","8323352242","5222194644","3101157598"),
("2028","US","T01","g","hist","r","1159537958","36388940","1123149018"),
("2028","US","T09","g","hist","r","1040530948","725942376","314588572"),
("2028","US","T10","g","hist","r","15962218","13882320","2079898"),
("2028","US","T13","g","hist","r","97195438","92484512","4710926"),
("2028","US","T15","g","hist","r","48986283","20323269","28663014"),
("2028","US","T16","g","hist","r","25498505","25157043","341462"),
("2028","US","T19","g","hist","r","216491981","166502576","49989405"),
("2028","US","T24","g","hist","r","59486295","55146248","4340047"),
("2028","US","T40","g","hist","r","1031631884","939756738","91875146"),
("2028","US","T41","g","hist","r","270596557","243119081","27477476"),
("2028","US","U01","g","hist","r","37127230","17699","37109531"),
("2028","US","U11","g","hist","r","9068329","3002584","6065745"),
("2028","US","U20","g","hist","r","38160588","28942252","9218336")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","M00","g","hist","r","-1827019750","-1827019750","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","T00","g","hist","r","8312299360","5211141761","3101157599")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","R00","g","hist","r","6485279610","3384122011","3101157599")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","E00","g","hist","s","8518089479.2828","4056403499.2828","4461685980")
Done