return to Menu
0 secs
US
B74 85062682 2026 928553270 2025 850626820
B74
B78 0 2026 0 2025 0
A01 263825.3 2026 2879862 2025 2638253
A18 14454891.1 2026 157880952 2025 144548911
A36 13205400.9 2026 144148437 2025 132054009
A44 1718767.8 2026 18761275 2025 17187678
A50 28855.997468663 2026 1084931 2025 1086682
A59 499502 2026 5452489 2025 4995020
A60 2679.8519945859 2026 35085 2025 33303
A61 265109.2 2026 2893918 2025 2651092
A80 141603.9 2026 1545621 2025 1416039
A81 -25.659196272044 2026 117693 2025 121205
A87 298331.4516751 2026 3357725 2025 3143117
A89 2151558.2835682 2026 26939722 2025 25472632
A90 1307026.2 2026 14220048 2025 13070262
A91 44433.9 2026 485351 2025 444339
A92 1319126.9 2026 14399186 2025 13191269
A93 377.55207083648 2026 8626 2025 8484
A94 340536.6 2026 3716994 2025 3405366
B01 134847.49835295 2026 4793132 2025 4793116
B21 11864968.6 2026 129518867 2025 118649686
B22 427200.35074195 2026 9369354 2025 9197104
B30 2251297.6209593 2026 91029928 2025 91355615
B42 7605025 2026 83017000 2025 76050250
B46 6531417.1 2026 71297919 2025 65314171
B50 2220169.8436669 2026 54868659 2025 54156346
B54 114631 2026 1251330 2025 1146310
B59 1387757.6462159 2026 32728590 2025 32236914
B62 744325.8 2026 8125165 2025 7443258
B66 593284.1 2026 6476072 2025 5932841
B79 7206938 2026 78671910 2025 72069380
B80 597487 2026 6522230 2025 5974870
B89 18805.608417783 2026 527522 2025 523347
B92 53788.368120339 2026 1085289 2025 1060806
B93 9104 2026 99380 2025 91040
B94 4820598 2026 52622380 2025 48205980
D49 91077331.866718 2026 1176774937 2025 1115749373
D64 1369017 2026 14959021 2025 13690170
E00 288309953.1 2026 3150513254 2025 2883099531
I89 2960016.174919 2026 39526468 2025 37581074
M00 -143145175.5 2026 -1545956760 2025 -1431451755
O99 -11126.543874479 2026 62916551 2025 64791276
Q79 117049261.6 2026 1277722175 2025 1170492616
R00 -110273326.87023 2026 2428922353 2025 2616922006
R01 1383033.1397813 2026 59402519 2025 59705654
R02 33938607.826237 2026 366582068 2025 341712026
R03 1664473.1 2026 18185226 2025 16644731
R95 45549911.1 2026 494984847 2025 455499111
R98 1264047.4 2026 13641731 2025 12640474
R99 34223.58560412 2026 46921605 2025 48274969
S01 314715.4 2026 3422547 2025 3147154
S03 1386399.3396805 2026 16708627 2025 15744016
S04 7581821 2026 82764147 2025 75818210
S05 6004684 2026 81980745 2025 60046840
2027x47035x-0.11886474334957
S11 37562809.3 2026 410252714 2025 375628093
S12 2312599.3 2026 25243237 2025 23125993
S14 971410.19565854 2026 10446745 2025 9733545
S16 37879041.6 2026 413493458 2025 378790416
S21 3578774.1817332 2026 80588512 2025 79207676
S22 121961.53474255 2026 4840575 2025 4855528
S23 6402994.8 2026 69893606 2025 64029948
S24 0 2026 0 2025 0
S25 3815403.5 2026 41648888 2025 38154035
S29 1274261.9 2026 13909688 2025 12742619
S31 631640.9 2026 6894543 2025 6316409
S32 3494351.9832539 2026 71723166 2025 70168685
S36 15980085.8 2026 174437236 2025 159800858
S44 17160078.8 2026 187317243 2025 171600788
S50 1817056.3 2026 19836057 2025 18170563
S52 65362.1 2026 713501 2025 653621
S53 1118183.9 2026 12211675 2025 11181839
S59 3848841.6 2026 42012328 2025 38488416
S60 2258.9 2026 24658 2025 22589
S61 983600.6 2026 10736666 2025 9836006
S62 2651242.5 2026 28941393 2025 26512425
S66 1458385.8 2026 15927232 2025 14583858
S72 0 2026 0 2025 0
S73 0 2026 0 2025 0
S74 101832857.6 2026 1111618292 2025 1018328576
S77 310261 2026 3391173 2025 3102610
S80 62399.899192876 2026 1502358 2025 1481160
S81 167392.9 2026 1827166 2025 1673929
S85 210917.8 2026 2302304 2025 2109178
S87 421354.1 2026 4599161 2025 4213541
S89 9899443.8 2026 108188394 2025 98994438
S90 1106907.9 2026 12092795 2025 11069079
S91 74162.8 2026 809536 2025 741628
S92 1366811.3 2026 14920068 2025 13668113
S93 2389.9410284009 2026 25961 2025 24214
S94 2485447.1 2026 27131564 2025 24854471
S95 35817495.977153 2026 417495796 2025 392155576
T00 41994673.791851 2026 3974879113 2025 4048373761
T01 -252658.8812943 2026 29716038 2025 30861912
T09 33279342.295052 2026 592099175 2025 574600851
T10 7088.1445541588 2026 10190628 2025 10484920
T13 -3680876.2 2026 65089277 2025 73617524
T15 -943584.05 2026 17157313 2025 18871681
T16 -964708.65 2026 15954963 2025 19294173
T19 -3974047.9 2026 55364519 2025 79480958
T24 1449125.3581644 2026 42062991 2025 41783117
T40 -29842386.8 2026 424089538 2025 596847736
T41 -10041098.9 2026 145122899 2025 200821978
U01 2235.8 2026 24406 2025 22358
U11 39962.278514811 2026 1507878 2025 1510462
U20 5948754.5 2026 64965113 2025 59487545
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","B74","g","hist","s","1013615952","1013615952","0"),
("2027","US","B78","g","hist","s","0","0","0"),
("2027","US","A01","g","hist","r","52340063","3143687","49196376"),
("2027","US","A18","g","hist","r","216146968","172335843","43811125"),
("2027","US","A36","g","hist","r","335969756","157353838","178615918"),
("2027","US","A44","g","hist","r","35629208","20480043","15149165"),
("2027","US","A50","g","hist","r","11148639","1113787","10034852"),
("2027","US","A59","g","hist","r","10345120","5951991","4393129"),
("2027","US","A60","g","hist","r","6458285","37765","6420520"),
("2027","US","A61","g","hist","r","24428130","3159027","21269103"),
("2027","US","A80","g","hist","r","118367178","1687225","116679953"),
("2027","US","A81","g","hist","r","34717853","117667","34600186"),
("2027","US","A87","g","hist","r","13637308","3656056","9981252"),
("2027","US","A89","g","hist","r","124208733","29091280","95117453"),
("2027","US","A90","g","hist","r","18411676","15527074","2884602"),
("2027","US","A91","g","hist","r","129090907","529785","128561122"),
("2027","US","A92","g","hist","r","165914887","15718313","150196574"),
("2027","US","A93","g","hist","r","16621750","9004","16612746"),
("2027","US","A94","g","hist","r","20903517","4057531","16845986"),
("2027","US","B01","g","hist","s","4927979","4927979","0"),
("2027","US","B21","g","hist","s","141383836","141383836","0"),
("2027","US","B22","g","hist","s","9796554","9796554","0"),
("2027","US","B30","g","hist","s","93281226","93281226","0"),
("2027","US","B42","g","hist","s","90622025","90622025","0"),
("2027","US","B46","g","hist","s","77829336","77829336","0"),
("2027","US","B50","g","hist","s","57088829","57088829","0"),
("2027","US","B54","g","hist","s","1365961","1365961","0"),
("2027","US","B59","g","hist","s","34116348","34116348","0"),
("2027","US","B62","g","hist","s","8869491","8869491","0"),
("2027","US","B66","g","hist","s","7069356","7069356","0"),
("2027","US","B79","g","hist","s","85878848","85878848","0"),
("2027","US","B80","g","hist","s","7119717","7119717","0"),
("2027","US","B89","g","hist","s","546328","546328","0"),
("2027","US","B92","g","hist","s","1139077","1139077","0"),
("2027","US","B93","g","hist","s","108484","108484","0"),
("2027","US","B94","g","hist","s","57442978","57442978","0"),
("2027","US","D49","g","hist","s","4088515803","1267852269","2820663534"),
("2027","US","D64","g","hist","s","43241801","16328038","26913763"),
("2027","US","E00","g","hist","s","7370730924","3438823207","3931907717"),
("2027","US","I89","g","hist","s","130480032","42486484","87993548"),
("2027","US","M00","g","hist","r","-1689101936","-1689101936","0"),
("2027","US","O99","g","hist","r","115615491","62905424","52710067"),
("2027","US","Q79","g","hist","","1498726769","1394771437","103955332"),
("2027","US","R00","g","hist","r","4677755566","2318649026","2359106540"),
("2027","US","R01","g","hist","r","60923740","60785552","138188"),
("2027","US","R02","g","hist","r","461093257","400520676","60572581"),
("2027","US","R03","g","hist","r","19849699","19849699","0"),
("2027","US","R95","g","hist","r","601407132","540534758","60872374"),
("2027","US","R98","g","hist","r","14905778","14905778","0"),
("2027","US","R99","g","hist","r","57816570","46955829","10860741"),
("2027","US","S01","g","hist","s","52326553","3737262","48589291"),
("2027","US","S03","g","hist","s","22770327","18095026","4675301"),
("2027","US","S04","g","hist","s","142745896","90345968","52399928"),
("2027","US","S05","g","hist","s","88120439","77527063.563413","135010"),
("2027","US","S11","g","hist","s","546715422","447815523","98899899"),
("2027","US","S12","g","hist","s","1457256682","27555836","1429700846"),
("2027","US","S14","g","hist","s","11418155","11418155","0"),
("2027","US","S16","g","hist","s","519555315","451372500","68182815"),
("2027","US","S21","g","hist","s","91412216","84167286","7244930"),
("2027","US","S22","g","hist","s","5060723","4962537","98186"),
("2027","US","S23","g","hist","s","143450592","76296601","67153991"),
("2027","US","S24","g","hist","s","106606790","0","106606790"),
("2027","US","S25","g","hist","s","94314403","45464292","48850111"),
("2027","US","S29","g","hist","s","73983012","15183950","58799062"),
("2027","US","S31","g","hist","s","28852081","7526184","21325897"),
("2027","US","S32","g","hist","s","192566446","75217518","117348928"),
("2027","US","S36","g","hist","s","418353864","190417322","227936542"),
("2027","US","S44","g","hist","s","355625204","204477322","151147882"),
("2027","US","S50","g","hist","s","110393114","21653113","88740001"),
("2027","US","S52","g","hist","s","22687777","778863","21908914"),
("2027","US","S53","g","hist","s","13329859","13329859","0"),
("2027","US","S59","g","hist","s","74745586","45861170","28884416"),
("2027","US","S60","g","hist","s","2926821","26917","2899904"),
("2027","US","S61","g","hist","s","99120604","11720267","87400337"),
("2027","US","S62","g","hist","s","232757467","31592636","201164831"),
("2027","US","S66","g","hist","s","29378200","17385618","11992582"),
("2027","US","S72","g","hist","s","0","0","0"),
("2027","US","S73","g","hist","s","0","0","0"),
("2027","US","S74","g","hist","s","1222807131","1213451150","9355981"),
("2027","US","S77","g","hist","s","3701434","3701434","0"),
("2027","US","S80","g","hist","s","131125034","1564758","129560276"),
("2027","US","S81","g","hist","s","50682748","1994559","48688189"),
("2027","US","S85","g","hist","s","2513222","2513222","0"),
("2027","US","S87","g","hist","s","12488135","5020515","7467620"),
("2027","US","S89","g","hist","s","335345607","118087838","217257769"),
("2027","US","S90","g","hist","s","15929892","13199703","2730189"),
("2027","US","S91","g","hist","s","163429131","883699","162545432"),
("2027","US","S92","g","hist","s","172877557","16286879","156590678"),
("2027","US","S93","g","hist","s","15623993","28351","15595642"),
("2027","US","S94","g","hist","s","171653012","29617011","142036001"),
("2027","US","S95","g","hist","s","552511476","453313292","99198184"),
("2027","US","T00","g","hist","r","6375980327","4016873787","2359106540"),
("2027","US","T01","g","hist","r","986080636","29463379","956617257"),
("2027","US","T09","g","hist","r","826230034","625378517","200851517"),
("2027","US","T10","g","hist","r","11375315","10197716","1177599"),
("2027","US","T13","g","hist","r","64008248","61408401","2599847"),
("2027","US","T15","g","hist","r","41339172","16213729","25125443"),
("2027","US","T16","g","hist","r","15314299","14990254","324045"),
("2027","US","T19","g","hist","r","74523809","51390471","23133338"),
("2027","US","T24","g","hist","r","46502244","43512116","2990128"),
("2027","US","T40","g","hist","r","442291503","394247151","48044352"),
("2027","US","T41","g","hist","r","148470077","135081800","13388277"),
("2027","US","U01","g","hist","r","22795874","26642","22769232"),
("2027","US","U11","g","hist","r","6608955","1547840","5061115"),
("2027","US","U20","g","hist","r","113639999","70913868","42726131")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","M00","g","hist","r","-1676263478","-1676263478","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","T00","g","hist","r","6539988156","4170528236","2369459920")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","R00","g","hist","r","4863724678","2494264758","2369459920")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","E00","g","hist","s","7350970676.5634","3419062957.5634","3931907719")
Done