return to Menu
0 secs
US
B74 85062682 2026 928553270 2025 850626820
B74
B78 0 2026 0 2025 0
A01 247354.6 2026 2700149 2025 2473546
A18 15578895.4 2026 170060598 2025 155788954
A36 12793039.6 2026 139649950 2025 127930396
A44 1765419.2 2026 19271514 2025 17654192
A50 166784 2026 1820632 2025 1667840
A59 479921.3 2026 5238881 2025 4799213
A60 4233 2026 46208 2025 42330
A61 256616.3 2026 2801268 2025 2566163
A80 137694.1 2026 1503412 2025 1376941
A81 35808.8 2026 390892 2025 358088
A87 380496.4 2026 4153557 2025 3804964
A89 3142213.8 2026 34299861 2025 31422138
A90 1450354.6 2026 15832207 2025 14503546
A91 47155.1 2026 514755 2025 471551
A92 1246548.4 2026 13607420 2025 12465484
A93 400.63147190923 2026 8619 2025 8450
A94 289025.7 2026 3155057 2025 2890257
B01 180827.43677094 2026 4909344 2025 4862946
B21 11864968.6 2026 129518867 2025 118649686
B22 512782.86803956 2026 9585036 2025 9326307
B30 2517979.9406375 2026 91469937 2025 91501418
B42 7605025 2026 83017000 2025 76050250
B46 6531417.1 2026 71297919 2025 65314171
B50 2728754.2573485 2026 56151504 2025 54925547
B54 114631 2026 1251330 2025 1146310
B59 1689456.7618365 2026 33489340 2025 32692904
B62 744325.8 2026 8125165 2025 7443258
B66 596310.9 2026 6509367 2025 5963109
B79 7206938 2026 78671910 2025 72069380
B80 597487 2026 6522230 2025 5974870
B89 23760.69292123 2026 540032 2025 530855
B92 63588.614790009 2026 1109970 2025 1075580
B93 9104 2026 99380 2025 91040
B94 4820598 2026 52622380 2025 48205980
D49 70492771.132141 2026 1089283568 2025 1047019489
D64 500997.42989625 2026 10548827 2025 10330763
E00 311649990.6 2026 3409359067 2025 3116499906
I89 2017411.6490087 2026 35658528 2025 34580479
M00 -143304406.4 2026 -1548809449 2025 -1433044064
O99 18613979.5 2026 203193488 2025 186139795
Q79 117049261.6 2026 1277722175 2025 1170492616
R00 261762285.5 2026 2848243054 2025 2617622855
R01 4042794.8244026 2026 71678609 2025 69524721
R02 -56534.422611562 2026 22446643 2025 23164310
R03 1578975.4 2026 17187120 2025 15789754
R95 20442427.9 2026 220683356 2025 204424279
R98 1484754.5 2026 16207698 2025 14847545
R99 11740974 2026 128166479 2025 117409740
S01 316431.5 2026 3458895 2025 3164315
S03 67098.392380952 2026 1698781 2025 1677961
S04 7604885 2026 83015754 2025 76048850
S05 8030946.6 2026 98684626 2025 80309466
2027x46901x-0.023811010510979
S11 39850393.2 2026 435014238 2025 398503932
S12 2169549.5 2026 23701574 2025 21695495
S14 1165617.2 2026 12723995 2025 11656172
S16 38229924 2026 417321266 2025 382299240
S21 11438618.6 2026 124865275 2025 114386186
S22 552720.4151136 2026 6489316 2025 6097778
S23 5997666.2 2026 65471732 2025 59976662
S24 0 2026 0 2025 0
S25 3752254.8 2026 40959993 2025 37522548
S29 1302076.2 2026 14213571 2025 13020762
S31 501168.5 2026 5477124 2025 5011685
S32 10041495.3 2026 109613724 2025 100414953
S36 15561304.9 2026 169868717 2025 155613049
S44 16448613.6 2026 179555805 2025 164486136
S50 2011828.9 2026 21961431 2025 20118289
S52 65540.6 2026 715448 2025 655406
S53 1187715.1 2026 12965281 2025 11877151
S59 3565308.2 2026 38919236 2025 35653082
S60 2154.8 2026 23522 2025 21548
S61 922928.1 2026 10074784 2025 9229281
S62 2674152.1 2026 29191316 2025 26741521
S66 1558453.6 2026 17012259 2025 15584536
S72 0 2026 0 2025 0
S73 0 2026 0 2025 0
S74 102119654.5 2026 1114746986 2025 1021196545
S77 313977.8 2026 3429995 2025 3139778
S79 14797943.9 2026 161531000 2025 147979439
S80 216484.1 2026 2363162 2025 2164841
S81 121266.82662963 2026 1326706 2025 1237957
S85 192809.1 2026 2104702 2025 1928091
S87 368234 2026 4019669 2025 3682340
S89 10906356.8 2026 119055459 2025 109063568
S90 1170738.7 2026 12779591 2025 11707387
S91 64507.4 2026 704442 2025 645074
S92 1344584.1 2026 14677590 2025 13445841
S93 1347.420453077 2026 21873 2025 21096
S94 759816.43390644 2026 17371696 2025 17081244
S95 40783702 2026 440274720 2025 407837020
T00 405066691.9 2026 4397052503 2025 4050666919
T01 2797488 2026 30537684 2025 27974880
T09 55808553.4 2026 609212566 2025 558085534
T10 1067239.9 2026 11650073 2025 10672399
T13 7109979.2 2026 77613212 2025 71099792
T15 1562446.8 2026 17055293 2025 15624468
T16 1967702.7 2026 21141794 2025 19677027
T19 12800314.3 2026 139729329 2025 128003143
T24 4239515.4 2026 46278848 2025 42395154
T40 72246219.3 2026 788645926 2025 722462193
T41 18691028.6 2026 204025502 2025 186910286
U01 832.37988416988 2026 15729 2025 15314
U11 230830.1 2026 2519776 2025 2308301
U20 1279415.3342329 2026 25882305 2025 25294446
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","50446311","2947504","47498807"),
("2027","US","A18","g","hist","r","226500768","185639493","40861275"),
("2027","US","A36","g","hist","r","409537660","152442990","257094670"),
("2027","US","A44","g","hist","r","42766157","21036933","21729224"),
("2027","US","A50","g","hist","r","14033169","1987416","12045753"),
("2027","US","A59","g","hist","r","10429873","5718802","4711071"),
("2027","US","A60","g","hist","r","6155472","50441","6105031"),
("2027","US","A61","g","hist","r","23508201","3057884","20450317"),
("2027","US","A80","g","hist","r","111723875","1641106","110082769"),
("2027","US","A81","g","hist","r","35913272","426701","35486571"),
("2027","US","A87","g","hist","r","13460400","4534053","8926347"),
("2027","US","A89","g","hist","r","169069699","37442075","131627624"),
("2027","US","A90","g","hist","r","21054492","17282562","3771930"),
("2027","US","A91","g","hist","r","121124239","561910","120562329"),
("2027","US","A92","g","hist","r","154133924","14853968","139279956"),
("2027","US","A93","g","hist","r","16298505","9020","16289485"),
("2027","US","A94","g","hist","r","19878950","3444083","16434867"),
("2027","US","B01","g","hist","s","5090171","5090171","0"),
("2027","US","B21","g","hist","s","141383836","141383836","0"),
("2027","US","B22","g","hist","s","10097819","10097819","0"),
("2027","US","B30","g","hist","s","93987917","93987917","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","58880258","58880258","0"),
("2027","US","B54","g","hist","s","1365961","1365961","0"),
("2027","US","B59","g","hist","s","35178797","35178797","0"),
("2027","US","B62","g","hist","s","8869491","8869491","0"),
("2027","US","B66","g","hist","s","7105678","7105678","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","563793","563793","0"),
("2027","US","B92","g","hist","s","1173559","1173559","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","3617912516","1159776339","2458136177"),
("2027","US","D64","g","hist","s","49232049","11049824","38182225"),
("2027","US","E00","g","hist","s","7649056895","3721009058","3928047837"),
("2027","US","I89","g","hist","s","121686235","37675940","84010295"),
("2027","US","M00","g","hist","r","-1692113855","-1692113855","0"),
("2027","US","O99","g","hist","r","349779826","221807468","127972358"),
("2027","US","Q79","g","hist","","1501046168","1394771437","106274731"),
("2027","US","R00","g","hist","r","5831990152","3110005340","2721984812"),
("2027","US","R01","g","hist","r","75799009","75721404","77605"),
("2027","US","R02","g","hist","r","35575667","22390109","13185558"),
("2027","US","R03","g","hist","r","18766095","18766095","0"),
("2027","US","R95","g","hist","r","274450430","241125784","33324646"),
("2027","US","R98","g","hist","r","17692453","17692453","0"),
("2027","US","R99","g","hist","r","232288554","139907453","92381101"),
("2027","US","S01","g","hist","s","32770834","3775327","28995507"),
("2027","US","S03","g","hist","s","5991117","1765879","4225238"),
("2027","US","S04","g","hist","s","141931384","90620639","51310745"),
("2027","US","S05","g","hist","s","106715573","104174567.36961","0"),
("2027","US","S11","g","hist","s","579000593","474864631","104135962"),
("2027","US","S12","g","hist","s","1503651175","25871124","1477780051"),
("2027","US","S14","g","hist","s","13889612","13889612","0"),
("2027","US","S16","g","hist","s","519550307","455551190","63999117"),
("2027","US","S21","g","hist","s","140031355","136303894","3727461"),
("2027","US","S22","g","hist","s","7085692","7042036","43656"),
("2027","US","S23","g","hist","s","111776167","71469398","40306769"),
("2027","US","S24","g","hist","s","105606798","0","105606798"),
("2027","US","S25","g","hist","s","89138826","44712248","44426578"),
("2027","US","S29","g","hist","s","80780254","15515647","65264607"),
("2027","US","S31","g","hist","s","27868129","5978293","21889836"),
("2027","US","S32","g","hist","s","248639810","119655219","128984591"),
("2027","US","S36","g","hist","s","442694379","185430022","257264357"),
("2027","US","S44","g","hist","s","307353333","196004419","111348914"),
("2027","US","S50","g","hist","s","132543440","23973260","108570180"),
("2027","US","S52","g","hist","s","23293643","780989","22512654"),
("2027","US","S53","g","hist","s","14152996","14152996","0"),
("2027","US","S59","g","hist","s","67514159","42484544","25029615"),
("2027","US","S60","g","hist","s","2884340","25677","2858663"),
("2027","US","S61","g","hist","s","85574954","10997712","74577242"),
("2027","US","S62","g","hist","s","217552268","31865468","185686800"),
("2027","US","S66","g","hist","s","29534440","18570713","10963727"),
("2027","US","S72","g","hist","s","0","0","0"),
("2027","US","S73","g","hist","s","0","0","0"),
("2027","US","S74","g","hist","s","1226427155","1216866641","9560514"),
("2027","US","S77","g","hist","s","3743973","3743973","0"),
("2027","US","S79","g","hist","s","304606747","176328944","128277803"),
("2027","US","S80","g","hist","s","108509509","2579646","105929863"),
("2027","US","S81","g","hist","s","43894361","1447973","42446388"),
("2027","US","S85","g","hist","s","2297511","2297511","0"),
("2027","US","S87","g","hist","s","9969736","4387903","5581833"),
("2027","US","S89","g","hist","s","373210925","129961816","243249109"),
("2027","US","S90","g","hist","s","17075543","13950330","3125213"),
("2027","US","S91","g","hist","s","119174908","768949","118405959"),
("2027","US","S92","g","hist","s","149394912","16022174","133372738"),
("2027","US","S93","g","hist","s","15227822","23220","15204602"),
("2027","US","S94","g","hist","s","117505963","18131512","99374451"),
("2027","US","S95","g","hist","s","568234269","481058422","87175847"),
("2027","US","T00","g","hist","r","7524104007","4802119195","2721984812"),
("2027","US","T01","g","hist","r","1027666108","33335172","994330936"),
("2027","US","T09","g","hist","r","936799413","665021119","271778294"),
("2027","US","T10","g","hist","r","14517841","12717313","1800528"),
("2027","US","T13","g","hist","r","88796129","84723191","4072938"),
("2027","US","T15","g","hist","r","43958804","18617740","25341064"),
("2027","US","T16","g","hist","r","23428292","23109497","318795"),
("2027","US","T19","g","hist","r","195894158","152529643","43364515"),
("2027","US","T24","g","hist","r","54339906","50518363","3821543"),
("2027","US","T40","g","hist","r","941380248","860892145","80488103"),
("2027","US","T41","g","hist","r","246457407","222716531","23740876"),
("2027","US","U01","g","hist","r","32136039","16561","32119478"),
("2027","US","U11","g","hist","r","8173384","2750606","5422778"),
("2027","US","U20","g","hist","r","35972032","27161720","8810312")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","M00","g","hist","r","-1680339451","-1680339451","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","T00","g","hist","r","7505795783","4783810975","2721984808")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","R00","g","hist","r","5825456332","3103471524","2721984808")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","E00","g","hist","s","7643965899.3696","3715918063.3696","3928047836")
Done