return to Menu
0 secs
US
B74 92855327 2027 1013615952 2026 928553270
B74
B78 0 2027 0 2026 0
0 2027 0 2026
A01 287986.2 2027 3143687 2026 2879862
A18 15788095.2 2027 172335843 2026 157880952
A36 14414843.7 2027 157353838 2026 144148437
A44 1876127.5 2027 20480043 2026 18761275
A50 60363.921153049 2027 1113787 2026 1084931
A59 545248.9 2027 5951991 2026 5452489
A60 3508.5 2027 37765 2026 35085
A61 289391.8 2027 3159027 2026 2893918
A80 154562.1 2027 1687225 2026 1545621
A81 3456.4077036415 2027 117667 2026 117693
A87 335772.5 2027 3656056 2026 3357725
A89 2693972.2 2027 29091280 2026 26939722
A90 1422004.8 2027 15527074 2026 14220048
A91 48535.1 2027 529785 2026 485351
A92 1439918.6 2027 15718313 2026 14399186
A93 625.47794592867 2027 9004 2026 8626
A94 371699.4 2027 4057531 2026 3716994
B01 273895.95648596 2027 4927979 2026 4793132
B21 12951886.7 2027 141383836 2026 129518867
B22 695665.18121938 2027 9796554 2026 9369354
B30 4898402.2887592 2027 93281226 2026 91029928
B42 8301700 2027 90622025 2026 83017000
B46 7129791.9 2027 77829336 2026 71297919
B50 3798100.3054746 2027 57088829 2026 54868659
B54 125133 2027 1365961 2026 1251330
B59 2327681.8173287 2027 34116348 2026 32728590
B62 812516.5 2027 8869491 2026 8125165
B66 647607.2 2027 7069356 2026 6476072
B79 7867191 2027 85878848 2026 78671910
B80 652223 2027 7119717 2026 6522230
B89 34028.486588551 2027 546328 2026 527522
B92 84797.510652442 2027 1139077 2026 1085289
B93 9938 2027 108484 2026 99380
B94 5262238 2027 57442978 2026 52622380
D49 117677493.7 2027 1267852269 2026 1176774937
D64 1495902.1 2027 16328038 2026 14959021
E00 315051325.4 2027 3419062958 2026 3150513254
I89 3952646.8 2027 42486484 2026 39526468
M00 -154595676 2027 -1676263478 2026 -1545956760
O99 1850448.6339729 2027 62905424 2026 62916551
Q79 127772217.5 2027 1394771437 2026 1277722175
R00 135866613.36376 2027 2494264758 2026 2428922353
R01 3112185.4908152 2027 60785552 2026 59402519
R02 36658206.8 2027 400520676 2026 366582068
R03 1818522.6 2027 19849699 2026 18185226
R95 49498484.7 2027 540534758 2026 494984847
R98 1364173.1 2027 14905778 2026 13641731
R99 1421672.8709016 2027 46955829 2026 46921605
S01 342254.7 2027 3737262 2026 3422547
S03 1670862.7 2027 18095026 2026 16708627
S04 8276414.7 2027 90345968 2026 82764147
S05 -1937405.2060861 2027 77527064 2026 81980745
2028x41880x-0.10959923461252
S11 41025271.4 2027 447815523 2026 410252714
S12 2524323.7 2027 27555836 2026 25243237
S14 1044674.5 2027 11418155 2026 10446745
S16 41349345.8 2027 451372500 2026 413493458
S21 5889874.0337928 2027 84167286 2026 80588512
S22 262677.58421313 2027 4962537 2026 4840575
S23 6989360.6 2027 76296601 2026 69893606
S24 0 2027 0 2026 0
S25 4164888.8 2027 45464292 2026 41648888
S29 1390968.8 2027 15183950 2026 13909688
S31 689454.3 2027 7526184 2026 6894543
S32 5544899.6090951 2027 75217518 2026 71723166
S36 17443723.6 2027 190417322 2026 174437236
S44 18731724.3 2027 204477322 2026 187317243
S50 1983605.7 2027 21653113 2026 19836057
S52 71350.1 2027 778863 2026 713501
S53 1221167.5 2027 13329859 2026 12211675
S59 4201232.8 2027 45861170 2026 42012328
S60 2465.8 2027 26917 2026 24658
S61 1073666.6 2027 11720267 2026 10736666
S62 2894139.3 2027 31592636 2026 28941393
S66 1592723.2 2027 17385618 2026 15927232
S72 0 2027 0 2026 0
S73 0 2027 0 2026 0
S74 111161829.2 2027 1213451150 2026 1111618292
S77 339117.3 2027 3701434 2026 3391173
S80 105572.4280226 2027 1564758 2026 1502358
S81 182716.6 2027 1994559 2026 1827166
S85 230230.4 2027 2513222 2026 2302304
S87 459916.1 2027 5020515 2026 4599161
S89 10818839.4 2027 118087838 2026 108188394
S90 1209279.5 2027 13199703 2026 12092795
S91 80953.6 2027 883699 2026 809536
S92 1492006.8 2027 16286879 2026 14920068
S93 2596.1 2027 28351 2026 25961
S94 2713156.4 2027 29617011 2026 27131564
S95 41749579.6 2027 453313292 2026 417495796
T00 309249246.25284 2027 4170528236 2026 3974879113
T01 631630.36694112 2027 29463379 2026 29716038
T09 50116823.676808 2027 625378517 2026 592099175
T10 308426.91866325 2027 10197716 2026 10190628
T13 -1680101.4446531 2027 61408401 2026 65089277
T15 -416731.34077476 2027 16213729 2026 17157313
T16 -472995.86569647 2027 14990254 2026 15954963
T19 -2254989.3022116 2027 51390471 2026 55364519
T24 2663948.6348389 2027 43512116 2026 42062991
T40 -16686701.871278 2027 394247151 2026 424089538
T41 -5542729.9211298 2027 135081800 2026 145122899
U01 2440.6 2027 26642 2026 24406
U11 83755.819127746 2027 1547840 2026 1507878
U20 6496511.3 2027 70913868 2026 64965113
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","60451213","3431673","57019540"),
("2028","US","A18","g","hist","r","238786848","188123938","50662910"),
("2028","US","A36","g","hist","r","372510472","171768682","200741790"),
("2028","US","A44","g","hist","r","39429676","22356171","17073505"),
("2028","US","A50","g","hist","r","12407659","1174151","11233508"),
("2028","US","A59","g","hist","r","11517926","6497240","5020686"),
("2028","US","A60","g","hist","r","7482655","41274","7441381"),
("2028","US","A61","g","hist","r","28102223","3448419","24653804"),
("2028","US","A80","g","hist","r","134963538","1841787","133121751"),
("2028","US","A81","g","hist","r","39393386","121123","39272263"),
("2028","US","A87","g","hist","r","15551153","3991829","11559324"),
("2028","US","A89","g","hist","r","138053176","31785252","106267924"),
("2028","US","A90","g","hist","r","20195612","16949079","3246533"),
("2028","US","A91","g","hist","r","146565466","578320","145987146"),
("2028","US","A92","g","hist","r","190102573","17158232","172944341"),
("2028","US","A93","g","hist","r","19272733","9629","19263104"),
("2028","US","A94","g","hist","r","23951789","4429230","19522559"),
("2028","US","B01","g","hist","s","5201875","5201875","0"),
("2028","US","B21","g","hist","s","154335723","154335723","0"),
("2028","US","B22","g","hist","s","10492219","10492219","0"),
("2028","US","B30","g","hist","s","98179628","98179628","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","60886929","60886929","0"),
("2028","US","B54","g","hist","s","1491094","1491094","0"),
("2028","US","B59","g","hist","s","36444030","36444030","0"),
("2028","US","B62","g","hist","s","9682008","9682008","0"),
("2028","US","B66","g","hist","s","7716963","7716963","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","580356","580356","0"),
("2028","US","B92","g","hist","s","1223875","1223875","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","4549262341","1385529763","3163732578"),
("2028","US","D64","g","hist","s","46606271","17823940","28782331"),
("2028","US","E00","g","hist","s","8225710597","3734114283","4491596314"),
("2028","US","I89","g","hist","s","144525429","46439131","98086298"),
("2028","US","M00","g","hist","r","-1830859154","-1830859154","0"),
("2028","US","O99","g","hist","r","119906657","64755873","55150784"),
("2028","US","Q79","g","hist","","1640149000","1522543655","117605345"),
("2028","US","R00","g","hist","r","5305741583","2630131371","2675610212"),
("2028","US","R01","g","hist","r","64043302","63897737","145565"),
("2028","US","R02","g","hist","r","507103654","437178883","69924771"),
("2028","US","R03","g","hist","r","21668222","21668222","0"),
("2028","US","R95","g","hist","r","660309179","590033243","70275936"),
("2028","US","R98","g","hist","r","16269951","16269951","0"),
("2028","US","R99","g","hist","r","59517134","48377502","11139632"),
("2028","US","S01","g","hist","s","59523521","4079517","55444004"),
("2028","US","S03","g","hist","s","25106699","19765889","5340810"),
("2028","US","S04","g","hist","s","158137954","98622383","59515571"),
("2028","US","S05","g","hist","s","75743108","67305090.228978","153449"),
("2028","US","S11","g","hist","s","600270094","488840794","111429300"),
("2028","US","S12","g","hist","s","1665452527","30080160","1635372367"),
("2028","US","S14","g","hist","s","12462830","12462830","0"),
("2028","US","S16","g","hist","s","569601506","492721846","76879660"),
("2028","US","S21","g","hist","s","98395286","90057160","8338126"),
("2028","US","S22","g","hist","s","5337777","5225215","112562"),
("2028","US","S23","g","hist","s","160148848","83285962","76862886"),
("2028","US","S24","g","hist","s","121434128","0","121434128"),
("2028","US","S25","g","hist","s","105497234","49629181","55868053"),
("2028","US","S29","g","hist","s","83251131","16574919","66676212"),
("2028","US","S31","g","hist","s","32379301","8215638","24163663"),
("2028","US","S32","g","hist","s","213414399","80762418","132651981"),
("2028","US","S36","g","hist","s","466823296","207861046","258962250"),
("2028","US","S44","g","hist","s","396635651","223209046","173426605"),
("2028","US","S50","g","hist","s","123944888","23636719","100308169"),
("2028","US","S52","g","hist","s","25734640","850213","24884427"),
("2028","US","S53","g","hist","s","14551027","14551027","0"),
("2028","US","S59","g","hist","s","83565705","50062403","33503302"),
("2028","US","S60","g","hist","s","3276211","29383","3246828"),
("2028","US","S61","g","hist","s","113700478","12793934","100906544"),
("2028","US","S62","g","hist","s","263866075","34486775","229379300"),
("2028","US","S66","g","hist","s","32660518","18978341","13682177"),
("2028","US","S72","g","hist","s","0","0","0"),
("2028","US","S73","g","hist","s","0","0","0"),
("2028","US","S74","g","hist","s","1335197461","1324612979","10584482"),
("2028","US","S77","g","hist","s","4040551","4040551","0"),
("2028","US","S80","g","hist","s","150682862","1670330","149012532"),
("2028","US","S81","g","hist","s","57728122","2177276","55550846"),
("2028","US","S85","g","hist","s","2743452","2743452","0"),
("2028","US","S87","g","hist","s","14055968","5480431","8575537"),
("2028","US","S89","g","hist","s","375351612","128906677","246444935"),
("2028","US","S90","g","hist","s","17512806","14408983","3103823"),
("2028","US","S91","g","hist","s","188447998","964653","187483345"),
("2028","US","S92","g","hist","s","199278157","17778886","181499271"),
("2028","US","S93","g","hist","s","18117524","30947","18086577"),
("2028","US","S94","g","hist","s","196956464","32330167","164626297"),
("2028","US","S95","g","hist","s","606853345","495062872","111790473"),
("2028","US","T00","g","hist","r","7155387694","4479777482","2675610212"),
("2028","US","T01","g","hist","r","1112317418","30095009","1082222409"),
("2028","US","T09","g","hist","r","902727028","675495341","227231687"),
("2028","US","T10","g","hist","r","11824335","10506143","1318192"),
("2028","US","T13","g","hist","r","62623096","59728300","2894796"),
("2028","US","T15","g","hist","r","44218739","15796998","28421741"),
("2028","US","T16","g","hist","r","14860727","14517258","343469"),
("2028","US","T19","g","hist","r","73019288","49135482","23883806"),
("2028","US","T24","g","hist","r","49538996","46176065","3362931"),
("2028","US","T40","g","hist","r","427993038","377560449","50432589"),
("2028","US","T41","g","hist","r","144035257","129539070","14496187"),
("2028","US","U01","g","hist","r","25756369","29083","25727286"),
("2028","US","U11","g","hist","r","7280074","1631596","5648478"),
("2028","US","U20","g","hist","r","125644199","77410379","48233820")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","M00","g","hist","r","-1823531478","-1823531478","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","T00","g","hist","r","7112617060","4437006848","2675610212")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","R00","g","hist","r","5289085582","2613475370","2675610212")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","E00","g","hist","s","8203228118.229","3711631801.229","4491596317")
Done