return to Menu
0 secs
US
B74 110647127.9 2029 1207832874 2028 1106471279
B74
B78 0 2029 0 2028 0
0 2029 0 2028 0
A01 321751.9 2029 3512269 2028 3217519
A18 20264555.3 2029 221209502 2028 202645553
A36 16640798.5 2029 181652284 2028 166407985
A44 2296408.4 2029 25067777 2028 22964084
A50 216947.9 2029 2368221 2028 2169479
A59 624269 2029 6814570 2028 6242690
A60 5506.2 2029 60106 2028 55062
A61 333801.1 2029 3643799 2028 3338011
A80 179871.6 2029 1963493 2028 1798716
A81 46579 2029 508460 2028 465790
A87 494940.9 2029 5402814 2028 4949409
A89 4087206.1 2029 44616269 2028 40872061
A90 1886578.3 2029 20594039 2028 18865783
A91 61338.6 2029 669577 2028 613386
A92 1621471 2029 17700107 2028 16214710
A93 1004.5 2029 11192 2028 10045
A94 375958.9 2029 4103997 2028 3759589
B01 563116 2029 6300669 2028 5631160
B21 15433572.3 2029 168474107 2028 154335723
B22 1129776.6 2029 12514022 2028 11297766
B30 10330168.5 2029 115687545 2028 103301685
B42 9892372.5 2029 107985928 2028 98923725
B46 8495912.8 2029 92742062 2028 84959128
B50 6566218.7 2029 73025563 2028 65662187
B54 149109.4 2029 1627690 2028 1491094
B59 3927939 2029 43617324 2028 39279390
B62 968200.8 2029 10568957 2028 9682008
B66 775661.5 2029 8467183 2028 7756615
B79 9374603.9 2029 102333924 2028 93746039
B80 777194 2029 8483912 2028 7771940
B89 62678.5 2029 699751 2028 626785
B92 131629.9 2029 1453503 2028 1316299
B93 11842.2 2029 129270 2028 118422
B94 6270521.6 2029 68449514 2028 62705216
D49 130500899.2 2029 1434781932 2028 1305008992
D64 1231343.3 2029 13706816 2028 12313433
E00 389690517.7 2029 4457960999 2028 3896905177
I89 4223875.5 2029 46668530 2028 42238755
M00 -183763783.8 2029 -2011357658 2028 -1837637838
O99 24212681.7 2029 264307564 2028 242126817
Q79 141572799.6 2029 1545418232 2028 1415727996
R00 339027989.5 2029 3702915610 2028 3390279895
R01 8488206.5 2029 93797333 2028 84882065
R02 2343317.9 2029 25899944 2028 23433179
R03 2068920.1 2029 22584479 2028 20689201
R95 26757631 2029 292088404 2028 267576310
R98 1931322.3 2029 21082468 2028 19313223
R99 15272410.1 2029 166714846 2028 152724101
S01 414437.7 2029 4524033 2028 4144377
S03 195715.1 2029 2189291 2028 1957151
S04 9892221.4 2029 107984278 2028 98922214
S05 11204099.7 2029 147702763 2028 112040997
2030x47766x0.060571073315867
S11 51836605.5 2029 565852518 2028 518366055
S12 2839668.5 2029 30998043 2028 28396685
S14 1516201.2 2029 16550973 2028 15162012
S16 49728331.7 2029 542838436 2028 497283317
S21 14879042.2 2029 162420811 2028 148790422
S22 788019.2 2029 8602151 2028 7880192
S23 7801657.1 2029 85163511 2028 78016571
S24 0 2029 0 2028 0
S25 4880824.7 2029 53279472 2028 48808247
S29 1693700.4 2029 18488569 2028 16937004
S31 656206.1 2029 7163195 2028 6562061
S32 13061659.1 2029 142582113 2028 130616591
S36 20241689.4 2029 220959896 2028 202416894
S44 21396000 2029 233560442 2028 213960000
S50 2616940.3 2029 28566729 2028 26169403
S52 85253.4 2029 930633 2028 852534
S53 1544952.4 2029 16864824 2028 15449524
S59 4637646.8 2029 50624922 2028 46376468
S60 2802.9 2029 30597 2028 28029
S61 1200519 2029 13104961 2028 12005190
S62 3478460 2029 37971147 2028 34784600
S66 2027193.9 2029 22129010 2028 20271939
S72 0 2029 0 2028 0
S73 0 2029 0 2028 0
S74 136113485.6 2029 1485825667 2028 1361134856
S77 410945.4 2029 4485912 2028 4109454
S80 281596.2 2029 3073927 2028 2815962
S81 160986.1 2029 1757344 2028 1609861
S85 250798.1 2029 2737732 2028 2507981
S87 478987 2029 5228660 2028 4789870
S89 14186736.2 2029 154863544 2028 141867362
S90 1522828.9 2029 16623322 2028 15228289
S91 84399.2 2029 921309 2028 843992
S92 1748993.3 2029 19092150 2028 17489933
S93 2611.6 2029 28738 2028 26116
S94 2015372.3 2029 22504782 2028 20153723
S95 53382859 2029 582731487 2028 533828590
T00 522791773.3 2029 5714273268 2028 5227917733
T01 3638894 2029 39722457 2028 36388940
T09 72594237.6 2029 792444488 2028 725942376
T10 1388232 2029 15154051 2028 13882320
T13 9248451.2 2029 100956831 2028 92484512
T15 2032326.9 2029 22185043 2028 20323269
T16 2564704.4 2029 27996592 2028 25647044
T19 16650257.6 2029 181755540 2028 166502576
T24 5514624.8 2029 60198084 2028 55146248
T40 93975673.8 2029 1025845953 2028 939756738
T41 24311908.1 2029 265390734 2028 243119081
U01 1852.3 2029 20526 2028 18523
U11 300258.4 2029 3277645 2028 3002584
U20 3030722.6 2029 33682556 2028 30307226
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","B74","g","hist","s","1318480002","1318480002","0"),
("2030","US","B78","g","hist","s","0","0","0"),
("2030","US","","g","hist","","0","0","0"),
("2030","US","A01","g","hist","r","81762125","3834021","77928104"),
("2030","US","A18","g","hist","r","308396566","241474057","66922509"),
("2030","US","A36","g","hist","r","621496712","198293083","423203629"),
("2030","US","A44","g","hist","r","63041873","27364185","35677688"),
("2030","US","A50","g","hist","r","22196365","2585169","19611196"),
("2030","US","A59","g","hist","r","15206069","7438839","7767230"),
("2030","US","A60","g","hist","r","10102895","65612","10037283"),
("2030","US","A61","g","hist","r","37574958","3977600","33597358"),
("2030","US","A80","g","hist","r","180798476","2143365","178655111"),
("2030","US","A81","g","hist","r","58280667","555039","57725628"),
("2030","US","A87","g","hist","r","20625248","5897755","14727493"),
("2030","US","A89","g","hist","r","265741140","48703475","217037665"),
("2030","US","A90","g","hist","r","28705057","22480617","6224440"),
("2030","US","A91","g","hist","r","194923630","730916","194192714"),
("2030","US","A92","g","hist","r","247972764","19321578","228651186"),
("2030","US","A93","g","hist","r","26689694","12197","26677497"),
("2030","US","A94","g","hist","r","31362823","4479956","26882867"),
("2030","US","B01","g","hist","s","6863785","6863785","0"),
("2030","US","B21","g","hist","s","183907679","183907679","0"),
("2030","US","B22","g","hist","s","13643799","13643799","0"),
("2030","US","B30","g","hist","s","126017714","126017714","0"),
("2030","US","B42","g","hist","s","117878301","117878301","0"),
("2030","US","B46","g","hist","s","101237975","101237975","0"),
("2030","US","B50","g","hist","s","79591782","79591782","0"),
("2030","US","B54","g","hist","s","1776799","1776799","0"),
("2030","US","B59","g","hist","s","47545263","47545263","0"),
("2030","US","B62","g","hist","s","11537158","11537158","0"),
("2030","US","B66","g","hist","s","9242845","9242845","0"),
("2030","US","B79","g","hist","s","111708528","111708528","0"),
("2030","US","B80","g","hist","s","9261106","9261106","0"),
("2030","US","B89","g","hist","s","762430","762430","0"),
("2030","US","B92","g","hist","s","1585133","1585133","0"),
("2030","US","B93","g","hist","s","141112","141112","0"),
("2030","US","B94","g","hist","s","74720036","74720036","0"),
("2030","US","D49","g","hist","s","5404117682","1565282831","3838834851"),
("2030","US","D64","g","hist","s","75557671","14938159","60619512"),
("2030","US","E00","g","hist","s","11178572576","4847651517","6330921059"),
("2030","US","I89","g","hist","s","182929872","50892406","132037466"),
("2030","US","M00","g","hist","r","-2195121442","-2195121442","0"),
("2030","US","O99","g","hist","r","498330559","288520246","209810313"),
("2030","US","Q79","g","hist","","1851909574","1686991032","164918542"),
("2030","US","R00","g","hist","r","8475941924","4041943600","4433998324"),
("2030","US","R01","g","hist","r","102387264","102285540","101724"),
("2030","US","R02","g","hist","r","45825828","28243262","17582566"),
("2030","US","R03","g","hist","r","24653399","24653399","0"),
("2030","US","R95","g","hist","r","371449435","318846035","52603400"),
("2030","US","R98","g","hist","r","23013790","23013790","0"),
("2030","US","R99","g","hist","r","332861541","181987256","150874285"),
("2030","US","S01","g","hist","s","48245876","4938471","43307405"),
("2030","US","S03","g","hist","s","9220693","2385006","6835687"),
("2030","US","S04","g","hist","s","200978529","117876499","83102030"),
("2030","US","S05","g","hist","s","158906863","168532022.24917","0"),
("2030","US","S11","g","hist","s","785981683","617689124","168292559"),
("2030","US","S12","g","hist","s","2464212310","33837712","2430374598"),
("2030","US","S14","g","hist","s","18067174","18067174","0"),
("2030","US","S16","g","hist","s","694609108","592566768","102042340"),
("2030","US","S21","g","hist","s","183183701","177299853","5883848"),
("2030","US","S22","g","hist","s","9458276","9390170","68106"),
("2030","US","S23","g","hist","s","158809581","92965168","65844413"),
("2030","US","S24","g","hist","s","171946920","0","171946920"),
("2030","US","S25","g","hist","s","130212268","58160297","72051971"),
("2030","US","S29","g","hist","s","127128283","20182269","106946014"),
("2030","US","S31","g","hist","s","43349575","7819401","35530174"),
("2030","US","S32","g","hist","s","365981225","155643772","210337453"),
("2030","US","S36","g","hist","s","664439707","241201585","423238122"),
("2030","US","S44","g","hist","s","431761328","254956442","176804886"),
("2030","US","S50","g","hist","s","210184253","31183669","179000584"),
("2030","US","S52","g","hist","s","37677860","1015886","36661974"),
("2030","US","S53","g","hist","s","18409776","18409776","0"),
("2030","US","S59","g","hist","s","96560681","55262569","41298112"),
("2030","US","S60","g","hist","s","4576203","33400","4542803"),
("2030","US","S61","g","hist","s","136177351","14305480","121871871"),
("2030","US","S62","g","hist","s","341786016","41449607","300336409"),
("2030","US","S66","g","hist","s","41883688","24156204","17727484"),
("2030","US","S72","g","hist","s","0","0","0"),
("2030","US","S73","g","hist","s","0","0","0"),
("2030","US","S74","g","hist","s","1637133823","1621939153","15194670"),
("2030","US","S77","g","hist","s","4896857","4896857","0"),
("2030","US","S80","g","hist","s","174556703","3355523","171201180"),
("2030","US","S81","g","hist","s","70161284","1918330","68242954"),
("2030","US","S85","g","hist","s","2988530","2988530","0"),
("2030","US","S87","g","hist","s","14602452","5707647","8894805"),
("2030","US","S89","g","hist","s","568166103","169050280","399115823"),
("2030","US","S90","g","hist","s","23298633","18146151","5152482"),
("2030","US","S91","g","hist","s","190614280","1005708","189608572"),
("2030","US","S92","g","hist","s","240125898","20841143","219284755"),
("2030","US","S93","g","hist","s","24983402","31350","24952052"),
("2030","US","S94","g","hist","s","184985746","24520154","160465592"),
("2030","US","S95","g","hist","s","773722589","636114346","137608243"),
("2030","US","T00","g","hist","r","10671063365","6237065041","4433998324"),
("2030","US","T01","g","hist","r","1655016150","43361351","1611654799"),
("2030","US","T09","g","hist","r","1308649416","865038726","443610690"),
("2030","US","T10","g","hist","r","19492415","16542283","2950132"),
("2030","US","T13","g","hist","r","116859935","110205282","6654653"),
("2030","US","T15","g","hist","r","65364408","24217370","41147038"),
("2030","US","T16","g","hist","r","31035446","30561296","474150"),
("2030","US","T19","g","hist","r","269768138","198405798","71362340"),
("2030","US","T24","g","hist","r","71950798","65712709","6238089"),
("2030","US","T40","g","hist","r","1252082149","1119821627","132260522"),
("2030","US","T41","g","hist","r","328459337","289702642","38756695"),
("2030","US","U01","g","hist","r","52615813","22378","52593435"),
("2030","US","U11","g","hist","r","12255524","3577903","8677621"),
("2030","US","U20","g","hist","r","49249211","36713279","12535932")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","M00","g","hist","r","-2195121444","-2195121444","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","T00","g","hist","r","10669869627","6237065045","4432804582")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","R00","g","hist","r","8474748183","4041943601","4432804582")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2030","US","E00","g","hist","s","10877920813.249","4679724699.2492","6198196114")
Done