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 294750.4 2028 3217519 2027 2947504
A18 18563949.3 2028 202645553 2027 185639493
A36 15244299 2028 166407985 2027 152442990
A44 2103693.3 2028 22964084 2027 21036933
A50 198741.6 2028 2169479 2027 1987416
A59 571880.2 2028 6242690 2027 5718802
A60 5044.1 2028 55062 2027 50441
A61 305788.4 2028 3338011 2027 3057884
A80 164110.6 2028 1792053 2027 1641106
A81 42670.1 2028 465790 2027 426701
A87 453405.3 2028 4949409 2027 4534053
A89 3744207.5 2028 40872061 2027 37442075
A90 1728256.2 2028 18865783 2027 17282562
A91 56191 2028 613386 2027 561910
A92 1485396.8 2028 16214710 2027 14853968
A93 883.4875058062 2028 9680 2027 9067
A94 344408.3 2028 3759589 2027 3444083
B01 454317.68401684 2028 5418006 2027 5117198
B21 14138383.6 2028 154335723 2027 141383836
B22 1015114.2 2028 10902182 2027 10151142
B30 7582192.736633 2028 99220651 2027 94488532
B42 9062202.5 2028 98923725 2027 90622025
B46 7782933.6 2028 84959128 2027 77829336
B50 5881244.5984994 2028 63309301 2027 59191680
B54 136596.1 2028 1491094 2027 1365961
B59 3536474.5 2028 37884089 2027 35364745
B62 886949.1 2028 9682008 2027 8869491
B66 710567.8 2028 7756615 2027 7105678
B79 8587884.8 2028 93746039 2027 85878848
B80 711971.7 2028 7771940 2027 7119717
B89 53989.095168492 2028 603838 2027 566781
B92 117974.7 2028 1271031 2027 1179747
B93 10848.4 2028 118422 2027 108484
B94 5744297.8 2028 62705216 2027 57442978
D49 116587850.9 2028 1263753964 2027 1165878509
D64 1092804.855738 2028 11869910 2027 11108288
E00 355193439.8 2028 3872294896 2027 3551934398
I89 3787469.2 2028 40781222 2027 37874692
M00 -168142696.2 2028 -1829131664 2027 -1681426962
O99 22180746.8 2028 242126817 2027 221807468
Q79 139477143.7 2028 1522543655 2027 1394771437
R00 310407643.1 2028 3385474505 2027 3104076431
R01 7612088.1 2028 81950615 2027 76120881
R02 1455291.2352448 2028 23280160 2027 22510620
R03 1873990 2028 20476325 2027 18739900
R95 24078664.5 2028 263242011 2027 240786645
R98 1769245.3 2028 19313223 2027 17692453
R99 13990745.3 2028 152724101 2027 139907453
S01 377007.8 2028 4117900 2027 3770078
S03 161902.66705075 2028 1883979 2027 1775249
S04 9062063.9 2028 98922214 2027 90620639
S05 10172515.944021 2028 122867918 2027 116183510
2029x45038x0.075405921680993
S11 47486463.1 2028 518366055 2027 474864631
S12 2587112.4 2028 28254232 2027 25871124
S14 1388961.2 2028 15162012 2027 13889612
S16 45555119 2028 497283317 2027 455551190
S21 13630389.4 2028 148790422 2027 136303894
S22 707884.9 2028 7739451 2027 7078849
S23 7146939.8 2028 78016571 2027 71469398
S24 0 2028 0 2027 0
S25 4471224.8 2028 48808247 2027 44712248
S29 1551564.7 2028 16937004 2027 15515647
S31 597829.3 2028 6529010 2027 5978293
S32 11965521.9 2028 130616591 2027 119655219
S36 18543002.2 2028 202416894 2027 185430022
S44 19600441.9 2028 213960000 2027 196004419
S50 2397326 2028 26169403 2027 23973260
S52 78098.9 2028 852534 2027 780989
S53 1415299.6 2028 15449524 2027 14152996
S59 4248454.4 2028 46376468 2027 42484544
S60 2567.7 2028 28029 2027 25677
S61 1099771.2 2028 12005190 2027 10997712
S62 3186546.8 2028 34784600 2027 31865468
S66 1857071.3 2028 20271939 2027 18570713
S72 0 2028 0 2027 0
S73 0 2028 0 2027 0
S77 374397.3 2028 4088846 2027 3743973
S80 257964.6 2028 2815962 2027 2579646
S81 144844.8 2028 1583476 2027 1448448
S85 229751.1 2028 2507981 2027 2297511
S87 438790.3 2028 4789870 2027 4387903
S89 12996181.6 2028 141867362 2027 129961816
S90 1395033 2028 15228289 2027 13950330
S91 76894.9 2028 839776 2027 768949
S92 1602217.4 2028 17489933 2027 16022174
S93 2334.3 2028 25239 2027 23343
S94 1731993.3158318 2028 19414942 2027 18227564
S95 48038182.2 2028 525181439 2027 480381822
T00 478550339.3 2028 5214606169 2027 4785503393
T01 3333517.2 2028 36388940 2027 33335172
T09 66502111.9 2028 725942376 2027 665021119
T10 1271731.3 2028 13882320 2027 12717313
T13 8472319.1 2028 92484512 2027 84723191
T15 1861774 2028 20323269 2027 18617740
T16 2307685.3 2028 25228422 2027 23076853
T19 15252964.3 2028 166502576 2027 152529643
T24 5051836.3 2028 55146248 2027 50518363
T40 86089214.5 2028 939756738 2027 860892145
T41 22271653.1 2028 243119081 2027 222716531
U01 1665 2028 17874 2027 16650
U11 275060.6 2028 3002584 2027 2750606
U20 2730534.2 2028 29225480 2027 27305342
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","67976710","3512269","64464441"),
("2029","US","A18","g","hist","r","276780809","221209502","55571307"),
("2029","US","A36","g","hist","r","529075815","181652284","347423531"),
("2029","US","A44","g","hist","r","54530399","25067777","29462622"),
("2029","US","A50","g","hist","r","18183397","2368221","15815176"),
("2029","US","A59","g","hist","r","13103995","6814570","6289425"),
("2029","US","A60","g","hist","r","8323733","60106","8263627"),
("2029","US","A61","g","hist","r","31352764","3643799","27708965"),
("2029","US","A80","g","hist","r","145880848","1956164","143924684"),
("2029","US","A81","g","hist","r","47047682","508460","46539222"),
("2029","US","A87","g","hist","r","17330959","5402814","11928145"),
("2029","US","A89","g","hist","r","220365593","44616269","175749324"),
("2029","US","A90","g","hist","r","25641957","20594039","5047918"),
("2029","US","A91","g","hist","r","156722682","669577","156053105"),
("2029","US","A92","g","hist","r","202592260","17700107","184892153"),
("2029","US","A93","g","hist","r","22165629","10563","22155066"),
("2029","US","A94","g","hist","r","26489338","4103997","22385341"),
("2029","US","B01","g","hist","s","5872324","5872324","0"),
("2029","US","B21","g","hist","s","168474107","168474107","0"),
("2029","US","B22","g","hist","s","11917296","11917296","0"),
("2029","US","B30","g","hist","s","106802844","106802844","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","69190546","69190546","0"),
("2029","US","B54","g","hist","s","1627690","1627690","0"),
("2029","US","B59","g","hist","s","41420564","41420564","0"),
("2029","US","B62","g","hist","s","10568957","10568957","0"),
("2029","US","B66","g","hist","s","8467183","8467183","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","657827","657827","0"),
("2029","US","B92","g","hist","s","1389006","1389006","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","4441266134","1380341815","3060924319"),
("2029","US","D64","g","hist","s","61441603","12962715","48478888"),
("2029","US","E00","g","hist","s","9230556487","4227488336","5003068151"),
("2029","US","I89","g","hist","s","149829112","44568691","105260421"),
("2029","US","M00","g","hist","r","-1997274360","-1997274360","0"),
("2029","US","O99","g","hist","r","433892025","264307564","169584461"),
("2029","US","Q79","g","hist","","1800527902","1662020799","138507103"),
("2029","US","R00","g","hist","r","7304008903","3695882148","3608126755"),
("2029","US","R01","g","hist","r","89649067","89562703","86364"),
("2029","US","R02","g","hist","r","39255016","24735451","14519565"),
("2029","US","R03","g","hist","r","22350315","22350315","0"),
("2029","US","R95","g","hist","r","329306708","287320676","41986032"),
("2029","US","R98","g","hist","r","21082468","21082468","0"),
("2029","US","R99","g","hist","r","292780167","166714846","126065321"),
("2029","US","S01","g","hist","s","39074964","4494908","34580056"),
("2029","US","S03","g","hist","s","7547028","2045882","5501146"),
("2029","US","S04","g","hist","s","174886112","107984278","66901834"),
("2029","US","S05","g","hist","s","133040434","143072470.54661","0"),
("2029","US","S11","g","hist","s","701241007","565852518","135388489"),
("2029","US","S12","g","hist","s","1997231385","30841344","1966390041"),
("2029","US","S14","g","hist","s","16550973","16550973","0"),
("2029","US","S16","g","hist","s","624561774","542838436","81723338"),
("2029","US","S21","g","hist","s","167117077","162420811","4696266"),
("2029","US","S22","g","hist","s","8501646","8447336","54310"),
("2029","US","S23","g","hist","s","138321504","85163511","53157993"),
("2029","US","S24","g","hist","s","138667562","0","138667562"),
("2029","US","S25","g","hist","s","111311732","53279472","58032260"),
("2029","US","S29","g","hist","s","104915950","18488569","86427381"),
("2029","US","S31","g","hist","s","35751251","7126839","28624412"),
("2029","US","S32","g","hist","s","312296219","142582113","169714106"),
("2029","US","S36","g","hist","s","563433364","220959896","342473468"),
("2029","US","S44","g","hist","s","374961902","233560442","141401460"),
("2029","US","S50","g","hist","s","173510250","28566729","144943521"),
("2029","US","S52","g","hist","s","30498818","930633","29568185"),
("2029","US","S53","g","hist","s","16864824","16864824","0"),
("2029","US","S59","g","hist","s","84073782","50624922","33448860"),
("2029","US","S60","g","hist","s","3664741","30597","3634144"),
("2029","US","S61","g","hist","s","111506961","13104961","98402000"),
("2029","US","S62","g","hist","s","279653251","37971147","241682104"),
("2029","US","S66","g","hist","s","36392901","22129010","14263891"),
("2029","US","S72","g","hist","s","0","0","0"),
("2029","US","S73","g","hist","s","0","0","0"),
("2029","US","S77","g","hist","s","4463243","4463243","0"),
("2029","US","S80","g","hist","s","140804871","3073927","137730944"),
("2029","US","S81","g","hist","s","56534608","1728321","54806287"),
("2029","US","S85","g","hist","s","2737732","2737732","0"),
("2029","US","S87","g","hist","s","12350946","5228660","7122286"),
("2029","US","S89","g","hist","s","477540016","154863544","322676472"),
("2029","US","S90","g","hist","s","20795457","16623322","4172135"),
("2029","US","S91","g","hist","s","152989981","916671","152073310"),
("2029","US","S92","g","hist","s","196497001","19092150","177404851"),
("2029","US","S93","g","hist","s","20656116","27573","20628543"),
("2029","US","S94","g","hist","s","150203715","21146935","129056780"),
("2029","US","S95","g","hist","s","683053287","573219621","109833666"),
("2029","US","T00","g","hist","r","9301283263","5693156508","3608126755"),
("2029","US","T01","g","hist","r","1337527719","39722457","1297805262"),
("2029","US","T09","g","hist","r","1163570463","792444488","371125975"),
("2029","US","T10","g","hist","r","17601542","15154051","2447491"),
("2029","US","T13","g","hist","r","106512001","100956831","5555170"),
("2029","US","T15","g","hist","r","55338578","22185043","33153535"),
("2029","US","T16","g","hist","r","27914763","27536107","378656"),
("2029","US","T19","g","hist","r","240378268","181755540","58622728"),
("2029","US","T24","g","hist","r","65233022","60198084","5034938"),
("2029","US","T40","g","hist","r","1132827507","1025845953","106981554"),
("2029","US","T41","g","hist","r","297804387","265390734","32413653"),
("2029","US","U01","g","hist","r","43713723","19539","43694184"),
("2029","US","U11","g","hist","r","10235793","3277645","6958148"),
("2029","US","U20","g","hist","r","41981714","31956014","10025700")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","M00","g","hist","r","-1995309688","-1995309688","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","T00","g","hist","r","9298522796","5690396039","3608126757")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","R00","g","hist","r","7303213108","3695086351","3608126757")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","E00","g","hist","s","7776549003.5466","2785940147.5466","4990608856")
Done