return to Menu
0 secs
US
B74 85062682 2026 928553270 2025 850626820
B74
B78 0 2026 0 2025 0
A01 263825.3 2026 2865222 2025 2638253
A18 6759666.5339259 2026 148754283 2025 146043586
A36 13205400.9 2026 143773563 2025 132054009
A44 1727546.6 2026 18593711 2025 17275466
A50 -49846.556577946 2026 1012397 2025 1094845
A59 499502 2026 5434689 2025 4995020
A60 -1684.4 2026 29771 2025 33688
A61 265109.2 2026 2886197 2025 2651092
A80 142330.9 2026 1543685 2025 1423309
A81 -6060.25 2026 106867 2025 121205
A87 -158913.35 2026 2896321 2025 3178267
A89 -1288230.45 2026 23203537 2025 25764609
A90 464136.65612036 2026 13304307 2025 13209694
A91 34052.838597372 2026 470844 2025 448941
A92 1319126.9 2026 14333205 2025 13191269
A93 386.43079608625 2026 8739 2025 8591
A94 340536.6 2026 3670166 2025 3405366
B01 83574.540593539 2026 4801084 2025 4855275
B21 11864968.6 2026 129518867 2025 118649686
B22 333095.0630416 2026 9384612 2025 9311872
B30 2399542.0729074 2026 91181487 2025 91355615
B42 7605025 2026 83017000 2025 76050250
B46 6531417.1 2026 71297919 2025 65314171
B50 1658530.2396739 2026 54958505 2025 54840052
B54 114631 2026 1251330 2025 1146310
B59 1055118.5552987 2026 32782070 2025 32642124
B62 744325.8 2026 8125165 2025 7443258
B66 596310.9 2026 6476072 2025 5963109
B79 7206938 2026 78671910 2025 72069380
B80 597487 2026 6522230 2025 5974870
B89 13310.525528552 2026 528390 2025 530025
B92 43048.727469362 2026 1087049 2025 1073923
B93 9104 2026 99380 2025 91040
B94 4820598 2026 52622380 2025 48205980
D49 112862309.7 2026 1231341967 2025 1128623097
D64 1383326.5 2026 15036464 2025 13833265
E00 -152091633.15 2026 1990289803 2025 3041832663
I89 3801757 2026 41800295 2025 38017570
M00 -143273739.3 2026 -1546277483 2025 -1432737393
O99 -3239563.8 2026 57354990 2025 64791276
Q79 117049261.6 2026 1277722175 2025 1170492616
R00 53226003.747781 2026 2300294068 2025 2312380369
R01 -1536407.0742353 2026 56417804 2025 59705654
R02 8019335.1629841 2026 340083275 2025 341712026
R03 1681816.5 2026 18361647 2025 16818165
R95 32775153.405587 2026 475907252 2025 455499111
R98 -486806.48737012 2026 11913034 2025 12778217
R99 -2413748.45 2026 43582395 2025 48274969
S01 318076.4 2026 3441081 2025 3180764
S03 648736.49614543 2026 15954471 2025 15744016
S04 7581821 2026 82785114 2025 75818210
S05 5849550.5 2026 75246222 2025 58495505
2027x47035x-0.11886474334957
S11 27454753.06849 2026 396661400 2025 379507143
S12 2324412.8 2026 25181198 2025 23244128
S14 -492056.15 2026 9006211 2025 9841123
S16 37879041.6 2026 413812442 2025 378790416
S21 -4009939.1 2026 72757147 2025 80198782
S22 -136181.72653438 2026 4576660 2025 4855528
S23 6402994.8 2026 69526200 2025 64029948
S24 0 2026 0 2025 0
S25 3815403.5 2026 41591480 2025 38154035
S29 1279257.6 2026 13844328 2025 12792576
S31 631640.9 2026 6800642 2025 6316409
S32 -3551901.15 2026 64167997 2025 71038023
S36 15980085.8 2026 174056526 2025 159800858
S44 17160078.8 2026 186670456 2025 171600788
S50 533632.10292358 2026 18380118 2025 18362651
S52 65362.1 2026 713663 2025 653621
S53 763144.24062217 2026 11752404 2025 11297093
S59 3848841.6 2026 41754570 2025 38488416
S60 2258.9 2026 24563 2025 22589
S61 983600.6 2026 10681509 2025 9836006
S62 2651242.5 2026 28962220 2025 26512425
S66 845915.19481171 2026 15175315 2025 14734232
S72 0 2026 0 2025 0
S73 0 2026 0 2025 0
S77 313529 2026 3391173 2025 3135290
S80 -74990.75 2026 1363361 2025 1499815
S81 167392.9 2026 1801204 2025 1673929
S85 210917.8 2026 2286373 2025 2109178
S87 421354.1 2026 4550870 2025 4213541
S89 3380908.4610084 2026 100617292 2025 100037805
S90 886454.33425367 2026 11768854 2025 11184230
S91 74162.8 2026 802652 2025 741628
S92 1366811.3 2026 14899861 2025 13668113
S93 2448.2 2026 27493 2025 24482
S94 2485447.1 2026 26847611 2025 24854471
S95 25644684.363013 2026 411391320 2025 396578564
T00 204586357.1979 2026 3846571551 2025 3745117762
T01 2736266.3 2026 29439964 2025 27362663
T09 54521360.2 2026 586011304 2025 545213602
T10 -71057.571207573 2026 9127550 2025 9472622
T13 -2342306.4565715 2026 56892355 2025 61042572
T15 1579806.9 2026 17148976 2025 15798069
T16 -710921.35553824 2026 14887572 2025 16076744
T19 -2841407.2 2026 51597079 2025 56828144
T24 924297.25941295 2026 38722877 2025 38896550
T40 -19663674.379498 2026 394602740 2025 426985869
T41 -7102984.7 2026 127662261 2025 142059694
U01 2235.8 2026 24106 2025 22358
U11 -63102.972339595 2026 1408295 2025 1516420
U20 4295570.0472949 2026 62168340 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","53000197","3129047","49871150"),
("2027","US","A18","g","hist","r","199796026","155513950","44282076"),
("2027","US","A36","g","hist","r","283157300","156978964","126178336"),
("2027","US","A44","g","hist","r","31003600","20321258","10682342"),
("2027","US","A50","g","hist","r","9642739","962550","8680189"),
("2027","US","A59","g","hist","r","10140784","5934191","4206593"),
("2027","US","A60","g","hist","r","6522275","28087","6494188"),
("2027","US","A61","g","hist","r","24697040","3151306","21545734"),
("2027","US","A80","g","hist","r","124446276","1686016","122760260"),
("2027","US","A81","g","hist","r","34432044","100807","34331237"),
("2027","US","A87","g","hist","r","12852474","2737408","10115066"),
("2027","US","A89","g","hist","r","91694356","21915307","69779049"),
("2027","US","A90","g","hist","r","16036056","13768444","2267612"),
("2027","US","A91","g","hist","r","136337863","504897","135832966"),
("2027","US","A92","g","hist","r","175015717","15652332","159363385"),
("2027","US","A93","g","hist","r","16881410","9125","16872285"),
("2027","US","A94","g","hist","r","21115808","4010703","17105105"),
("2027","US","B01","g","hist","s","4884659","4884659","0"),
("2027","US","B21","g","hist","s","141383836","141383836","0"),
("2027","US","B22","g","hist","s","9717707","9717707","0"),
("2027","US","B30","g","hist","s","93581029","93581029","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","56617035","56617035","0"),
("2027","US","B54","g","hist","s","1365961","1365961","0"),
("2027","US","B59","g","hist","s","33837189","33837189","0"),
("2027","US","B62","g","hist","s","8869491","8869491","0"),
("2027","US","B66","g","hist","s","7072383","7072383","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","541701","541701","0"),
("2027","US","B92","g","hist","s","1130098","1130098","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","4463606162","1344204277","3119401885"),
("2027","US","D64","g","hist","s","38654165","16419791","22234374"),
("2027","US","E00","g","hist","s","5660357050","1838198170","3822158880"),
("2027","US","I89","g","hist","s","137579767","45602052","91977715"),
("2027","US","M00","g","hist","r","-1689551222","-1689551222","0"),
("2027","US","O99","g","hist","r","99581976","54115426","45466550"),
("2027","US","Q79","g","hist","","1498191666","1394771437","103420229"),
("2027","US","R00","g","hist","r","4556329305","2353520072","2202809233"),
("2027","US","R01","g","hist","r","55088134","54881397","206737"),
("2027","US","R02","g","hist","r","397961418","348102610","49858808"),
("2027","US","R03","g","hist","r","20043464","20043464","0"),
("2027","US","R95","g","hist","r","566684706","508682405","58002301"),
("2027","US","R98","g","hist","r","11426228","11426228","0"),
("2027","US","R99","g","hist","r","49479216","41168647","8310569"),
("2027","US","S01","g","hist","s","57361162","3759157","53602005"),
("2027","US","S03","g","hist","s","21657871","16603207","5054664"),
("2027","US","S04","g","hist","s","144139175","90366935","53772240"),
("2027","US","S05","g","hist","s","81191622","71456344.75562","95849"),
("2027","US","S11","g","hist","s","520311912","424116153","96195759"),
("2027","US","S12","g","hist","s","1437013159","27505611","1409507548"),
("2027","US","S14","g","hist","s","8514155","8514155","0"),
("2027","US","S16","g","hist","s","523717776","451691484","72026292"),
("2027","US","S21","g","hist","s","75634482","68747208","6887274"),
("2027","US","S22","g","hist","s","4533110","4440478","92632"),
("2027","US","S23","g","hist","s","140994909","75929195","65065714"),
("2027","US","S24","g","hist","s","108488621","0","108488621"),
("2027","US","S25","g","hist","s","98012833","45406884","52605949"),
("2027","US","S29","g","hist","s","69834958","15123586","54711372"),
("2027","US","S31","g","hist","s","28581784","7432283","21149501"),
("2027","US","S32","g","hist","s","170758907","60616096","110142811"),
("2027","US","S36","g","hist","s","398975876","190036612","208939264"),
("2027","US","S44","g","hist","s","366566169","203830535","162735634"),
("2027","US","S50","g","hist","s","94121175","18913750","75207425"),
("2027","US","S52","g","hist","s","22485578","779025","21706553"),
("2027","US","S53","g","hist","s","12515548","12515548","0"),
("2027","US","S59","g","hist","s","74422540","45603412","28819128"),
("2027","US","S60","g","hist","s","2991281","26822","2964459"),
("2027","US","S61","g","hist","s","102392526","11665110","90727416"),
("2027","US","S62","g","hist","s","246275746","31613463","214662283"),
("2027","US","S66","g","hist","s","28895825","16021230","12874595"),
("2027","US","S72","g","hist","s","0","0","0"),
("2027","US","S73","g","hist","s","0","0","0"),
("2027","US","S77","g","hist","s","3704702","3704702","0"),
("2027","US","S80","g","hist","s","139495397","1288370","138207027"),
("2027","US","S81","g","hist","s","55426374","1968597","53457777"),
("2027","US","S85","g","hist","s","2497291","2497291","0"),
("2027","US","S87","g","hist","s","12975942","4972224","8003718"),
("2027","US","S89","g","hist","s","304607754","103998200","200609554"),
("2027","US","S90","g","hist","s","15125787","12655308","2470479"),
("2027","US","S91","g","hist","s","168047424","876815","167170609"),
("2027","US","S92","g","hist","s","172730602","16266672","156463930"),
("2027","US","S93","g","hist","s","15853452","29941","15823511"),
("2027","US","S94","g","hist","s","167488812","29333058","138155754"),
("2027","US","S95","g","hist","s","546178768","437036004","109142764"),
("2027","US","T00","g","hist","r","6253967141","4051157908","2202809233"),
("2027","US","T01","g","hist","r","950854908","32176230","918678678"),
("2027","US","T09","g","hist","r","850209080","640532664","209676416"),
("2027","US","T10","g","hist","r","10094025","9056492","1037533"),
("2027","US","T13","g","hist","r","56569366","54550049","2019317"),
("2027","US","T15","g","hist","r","43864682","18728783","25135899"),
("2027","US","T16","g","hist","r","14404874","14176651","228223"),
("2027","US","T19","g","hist","r","66113627","48755672","17357955"),
("2027","US","T24","g","hist","r","42622916","39647174","2975742"),
("2027","US","T40","g","hist","r","410403667","374939066","35464601"),
("2027","US","T41","g","hist","r","130334178","120559276","9774902"),
("2027","US","U01","g","hist","r","16216341","26342","16189999"),
("2027","US","U11","g","hist","r","6202186","1345192","4856994"),
("2027","US","U20","g","hist","r","105718355","66463910","39254445")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","M00","g","hist","r","-1675676555","-1675676555","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","T00","g","hist","r","6259637161","4032776220","2226860941")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","R00","g","hist","r","4583960606","2357099665","2226860941")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","E00","g","hist","s","6022577873.7556","2122202811.7556","3900375062")
Done