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 15999522.2 2027 174653975 2026 159995222
A36 14414843.7 2027 157353838 2026 144148437
A44 1885784.1 2027 20585388 2026 18857841
A50 82261.220313696 2027 1174973 2026 1124256
A59 545248.9 2027 5951991 2026 5452489
A60 3646.2 2027 39857 2026 36462
A61 289391.8 2027 3159027 2026 2893918
A80 155361.8 2027 1695949 2026 1553618
A81 4369.6101350914 2027 119666 2026 118720
A87 348524.1 2027 3805487 2026 3485241
A89 2798846.1 2027 30584761 2026 27988461
A90 1453789.4 2027 15868705 2026 14537894
A91 49221.1 2027 537308 2026 492211
A92 1439918.6 2027 15718313 2026 14399186
A93 818.96165454084 2027 9566 2026 8996
A94 371699.4 2027 4057531 2026 3716994
B01 384990.6893825 2027 5250939 2026 5006005
B21 12951886.7 2027 141383836 2026 129518867
B22 904585.15473398 2027 10402708 2026 9768124
B30 6358163.502228 2027 97031194 2026 93300904
B42 8301700 2027 90622025 2026 83017000
B46 7129791.9 2027 77829336 2026 71297919
B50 5035754.3393108 2027 60681867 2026 57233785
B54 125133 2027 1365961 2026 1251330
B59 3062733.5501276 2027 36249804 2026 34132637
B62 812516.5 2027 8869491 2026 8125165
B66 650936.7 2027 7105678 2026 6509367
B79 7867191 2027 85878848 2026 78671910
B80 652223 2027 7119717 2026 6522230
B89 46054.864643536 2027 581261 2026 550529
B92 108780.00396642 2027 1208627 2026 1131023
B93 9938 2027 108484 2026 99380
B94 5262238 2027 57442978 2026 52622380
D49 122289371.3 2027 1336627777 2026 1222893713
D64 1521147.5 2027 16605013 2026 15211475
E00 332090195.7 2027 3618098819 2026 3320901957
I89 4108605.3 2027 44865722 2026 41086053
M00 -155267729.3 2027 -1686773537 2026 -1552677293
O99 2338109.8890733 2027 63973093 2026 63465123
Q79 127772217.5 2027 1394771437 2026 1277722175
R00 246992423 2027 2653277685 2026 2469924230
R01 4067125.0932796 2027 63238640 2026 60888230
R02 37464031.8 2027 409071703 2026 374640318
R03 1849141.4 2027 20185628 2026 18491414
R95 50158771.9 2027 547479116 2026 501587719
R98 1407548.7 2027 15362921 2026 14075487
R99 1947524.778549 2027 48222007 2026 47644274
S01 350074.6 2027 3821193 2026 3500746
S03 1708293.3 2027 18669475 2026 17082933
S04 8276414.7 2027 90345968 2026 82764147
S05 5594477.693257 2027 72692516 2026 69023008
2028x48519x0.034498198332658
S11 41549859.1 2027 453566354 2026 415498591
S12 2537318.5 2027 27697598 2026 25373185
S14 1083889.9 2027 11830462 2026 10838899
S16 41349345.8 2027 451372500 2026 413493458
S21 7691674.6818926 2027 89395717 2026 84028608
S22 340239.05825274 2027 5161786 2026 4961237
S23 6989360.6 2027 76296601 2026 69893606
S24 0 2027 0 2026 0
S25 4164888.8 2027 45464292 2026 41648888
S29 1396464.1 2027 15243899 2026 13964641
S31 689454.3 2027 7526184 2026 6894543
S32 7132911.6991005 2027 79823243 2026 74752043
S36 17443723.6 2027 190417322 2026 174437236
S44 18731724.3 2027 204477322 2026 187317243
S50 2020142.6 2027 22051315 2026 20201426
S52 71350.1 2027 778863 2026 713501
S53 1235704.5 2027 13489183 2026 12357045
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 1611947.2 2027 17596321 2026 16119472
S72 0 2027 0 2026 0
S73 0 2027 0 2026 0
S74 111161829.2 2027 1213451150 2026 1111618292
S77 344873 2027 3764581 2026 3448730
S79 16610388.3 2027 181320287 2026 166103883
S80 139379.90195931 2027 1662892 2026 1566947
S81 182716.6 2027 1994559 2026 1827166
S85 230230.4 2027 2513222 2026 2302304
S87 459916.1 2027 5020515 2026 4599161
S89 11004173.4 2027 120119637 2026 110041734
S90 1228881 2027 13414737 2026 12288810
S91 80953.6 2027 883699 2026 809536
S92 1492006.8 2027 16286879 2026 14920068
S93 2693.8 2027 29405 2026 26938
S94 2713156.4 2027 29617011 2026 27131564
S95 43348630 2027 473447235 2026 433486300
T00 402260152.3 2027 4340051222 2026 4022601523
T01 2986899 2027 32605256 2026 29868990
T09 59514941.9 2027 649670779 2026 595149419
T10 1042578.1 2027 11380105 2026 10425781
T13 6724831.2 2027 73398550 2026 67248312
T15 1724542 2027 18825227 2026 17245420
T16 1353800.4016959 2027 17544700 2026 16655314
T19 2722249.2077765 2027 57896141 2026 56798275
T24 4277331.9 2027 46691698 2026 42773319
T40 28373917.373679 2027 450829555 2026 434726803
T41 15108896.4 2027 162809843 2026 151088964
U01 2440.6 2027 26642 2026 24406
U11 111187.469801 2027 1621910 2026 1554390
U20 6547018.3 2027 71463265 2026 65470183
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","62237903","3431673","58806230"),
("2028","US","A18","g","hist","r","243011992","190653497","52358495"),
("2028","US","A36","g","hist","r","384386076","171768682","212617394"),
("2028","US","A44","g","hist","r","40536798","22471172","18065626"),
("2028","US","A50","g","hist","r","13171964","1257234","11914730"),
("2028","US","A59","g","hist","r","11783654","6497240","5286414"),
("2028","US","A60","g","hist","r","7718741","43503","7675238"),
("2028","US","A61","g","hist","r","28860994","3448419","25412575"),
("2028","US","A80","g","hist","r","142102149","1851311","140250838"),
("2028","US","A81","g","hist","r","41574716","124036","41450680"),
("2028","US","A87","g","hist","r","16217751","4154011","12063740"),
("2028","US","A89","g","hist","r","146175447","33383607","112791840"),
("2028","US","A90","g","hist","r","20759357","17322494","3436863"),
("2028","US","A91","g","hist","r","154646852","586529","154060323"),
("2028","US","A92","g","hist","r","198779012","17158232","181620780"),
("2028","US","A93","g","hist","r","19829849","10385","19819464"),
("2028","US","A94","g","hist","r","24575926","4429230","20146696"),
("2028","US","B01","g","hist","s","5635930","5635930","0"),
("2028","US","B21","g","hist","s","154335723","154335723","0"),
("2028","US","B22","g","hist","s","11307293","11307293","0"),
("2028","US","B30","g","hist","s","103389358","103389358","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","65717621","65717621","0"),
("2028","US","B54","g","hist","s","1491094","1491094","0"),
("2028","US","B59","g","hist","s","39312538","39312538","0"),
("2028","US","B62","g","hist","s","9682008","9682008","0"),
("2028","US","B66","g","hist","s","7756615","7756615","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","627316","627316","0"),
("2028","US","B92","g","hist","s","1317407","1317407","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","4812190530","1458917148","3353273382"),
("2028","US","D64","g","hist","s","49161196","18126161","31035035"),
("2028","US","E00","g","hist","s","8786228055","3950189015","4836039040"),
("2028","US","I89","g","hist","s","153166296","48974327","104191969"),
("2028","US","M00","g","hist","r","-1842041266","-1842041266","0"),
("2028","US","O99","g","hist","r","124459838","66311203","58148635"),
("2028","US","Q79","g","hist","","1646816373","1522543655","124272718"),
("2028","US","R00","g","hist","r","5765146054","2900270108","2864875946"),
("2028","US","R01","g","hist","r","67459029","67305765","153264"),
("2028","US","R02","g","hist","r","518824763","446535735","72289028"),
("2028","US","R03","g","hist","r","22034769","22034769","0"),
("2028","US","R95","g","hist","r","670288943","597637888","72651055"),
("2028","US","R98","g","hist","r","16770470","16770470","0"),
("2028","US","R99","g","hist","r","61579904","50169532","11410372"),
("2028","US","S01","g","hist","s","62581583","4171268","58410315"),
("2028","US","S03","g","hist","s","26002118","20377768","5624350"),
("2028","US","S04","g","hist","s","161424366","98622383","62801983"),
("2028","US","S05","g","hist","s","78446112","80987754.24588","159118"),
("2028","US","S11","g","hist","s","613033072","495116213","117916859"),
("2028","US","S12","g","hist","s","1751631135","30234917","1721396218"),
("2028","US","S14","g","hist","s","12914352","12914352","0"),
("2028","US","S16","g","hist","s","574055474","492721846","81333628"),
("2028","US","S21","g","hist","s","105712495","97087392","8625103"),
("2028","US","S22","g","hist","s","5618549","5502025","116524"),
("2028","US","S23","g","hist","s","162878841","83285962","79592879"),
("2028","US","S24","g","hist","s","128009410","0","128009410"),
("2028","US","S25","g","hist","s","108439495","49629181","58810314"),
("2028","US","S29","g","hist","s","87038303","16640363","70397940"),
("2028","US","S31","g","hist","s","33735206","8215638","25519568"),
("2028","US","S32","g","hist","s","227167929","86956155","140211774"),
("2028","US","S36","g","hist","s","481095881","207861046","273234835"),
("2028","US","S44","g","hist","s","405560895","223209046","182351849"),
("2028","US","S50","g","hist","s","130097692","24071458","106026234"),
("2028","US","S52","g","hist","s","27108592","850213","26258379"),
("2028","US","S53","g","hist","s","14724888","14724888","0"),
("2028","US","S59","g","hist","s","84474507","50062403","34412104"),
("2028","US","S60","g","hist","s","3472909","29383","3443526"),
("2028","US","S61","g","hist","s","118664262","12793934","105870328"),
("2028","US","S62","g","hist","s","276199003","34486775","241712228"),
("2028","US","S66","g","hist","s","33623283","19208268","14415015"),
("2028","US","S72","g","hist","s","0","0","0"),
("2028","US","S73","g","hist","s","0","0","0"),
("2028","US","S74","g","hist","s","1335797525","1324612979","11184546"),
("2028","US","S77","g","hist","s","4109454","4109454","0"),
("2028","US","S79","g","hist","s","311018850","197930675","113088175"),
("2028","US","S80","g","hist","s","158352912","1802272","156550640"),
("2028","US","S81","g","hist","s","60702373","2177276","58525097"),
("2028","US","S85","g","hist","s","2743452","2743452","0"),
("2028","US","S87","g","hist","s","14494646","5480431","9014215"),
("2028","US","S89","g","hist","s","391294392","131123810","260170582"),
("2028","US","S90","g","hist","s","17917768","14643618","3274150"),
("2028","US","S91","g","hist","s","197736661","964653","196772008"),
("2028","US","S92","g","hist","s","206039028","17778886","188260142"),
("2028","US","S93","g","hist","s","18625468","32099","18593369"),
("2028","US","S94","g","hist","s","202093831","32330167","169763664"),
("2028","US","S95","g","hist","s","635085528","516795865","118289663"),
("2028","US","T00","g","hist","r","7607187320","4742311374","2864875946"),
("2028","US","T01","g","hist","r","1171148370","35592155","1135556215"),
("2028","US","T09","g","hist","r","957932855","709185721","248747134"),
("2028","US","T10","g","hist","r","13844626","12422683","1421943"),
("2028","US","T13","g","hist","r","83385213","80123381","3261832"),
("2028","US","T15","g","hist","r","51738102","20549769","31188333"),
("2028","US","T16","g","hist","r","19347323","18898500","448823"),
("2028","US","T19","g","hist","r","102909492","60618390","42291102"),
("2028","US","T24","g","hist","r","54190010","50969030","3220980"),
("2028","US","T40","g","hist","r","555815117","479203472","76611645"),
("2028","US","T41","g","hist","r","196991035","177918739","19072296"),
("2028","US","U01","g","hist","r","27226742","29083","27197659"),
("2028","US","U11","g","hist","r","7730583","1733097","5997486"),
("2028","US","U20","g","hist","r","128091556","78010283","50081273")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","M00","g","hist","r","-1837830029","-1837830029","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","T00","g","hist","r","7575679007","4710803061","2864875946")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","R00","g","hist","r","5737848978","2872973032","2864875946")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2028","US","E00","g","hist","s","8786394314.2459","3950355276.2459","4836039038")
Done