return to Menu
0 secs
US
B74 101361595.2 2028 1106471279 2027 1013615952
B74
B78 0 2028 0 2027 0
0 2028 0 2027 0
A01 294750.4 2028 3403160 2027 2947504
A18 -9281974.65 2028 116757431 2027 185639493
A36 15244299 2028 176786820 2027 152442990
A44 -1051846.65 2028 14541588 2027 21036933
A50 -99370.8 2028 961784 2027 1987416
A59 -8608.2468833556 2028 5533741 2027 5718802
A60 -2522.05 2028 32513 2027 50441
A61 305788.4 2028 3464224 2027 3057884
A80 -82388.45 2028 1361169 2027 1647769
A81 -21335.05 2028 72795 2027 426701
A87 -226702.65 2028 2118217 2027 4534053
A89 -1872103.75 2028 26672697 2027 37442075
A90 -864128.1 2028 9829352 2027 17282562
A91 -28095.5 2028 361388 2027 561910
A92 -742698.4 2028 7189169 2027 14853968
A93 937.5 2028 14976 2027 9375
A94 344408.3 2028 4457404 2027 3444083
B01 -264742.05 2028 4686621 2027 5294841
B21 14138383.6 2028 154335723 2027 141383836
B22 -524418.65 2028 9532167 2027 10488373
B30 -309403.49275313 2028 94517631 2027 97849436
B42 9062202.5 2028 98923725 2027 90622025
B46 7782933.6 2028 84959128 2027 77829336
B50 -3059190.2 2028 55183522 2027 61183804
B54 136596.1 2028 1491094 2027 1365961
B59 -1827457.25 2028 33060289 2027 36549145
B62 886949.1 2028 9682008 2027 8869491
B66 710567.8 2028 7726347 2027 7105678
B79 8587884.8 2028 93746039 2027 85878848
B80 711971.7 2028 7771940 2027 7119717
B89 -29304.45 2028 524792 2027 586089
B92 -60927.3 2028 1113910 2027 1218546
B93 10848.4 2028 118422 2027 108484
B94 5744297.8 2028 62705216 2027 57442978
D49 120346905.6 2028 1448871644 2027 1203469056
D64 1148323.6 2028 16409652 2027 11483236
E00 -185902429.1 2028 3084328555 2027 3718048582
I89 3912268.3 2028 53251797 2027 39122683
M00 -168853737.1 2028 -1809141498 2027 -1688537371
O99 -11090373.4 2028 65553963 2027 221807468
Q79 127078155.86486 2028 1386569239 2027 1296902357
R00 120295143.13798 2028 3135435872 2027 3108531408
R01 7863026.3 2028 92417080 2027 78630263
R02 2290024.9 2028 645615734 2027 22900249
R03 -947638.8 2028 11630701 2027 18952776
R95 24512094.4 2028 807199499 2027 245120944
R98 1769245.3 2028 20393197 2027 17692453
R99 -6995372.65 2028 35533706 2027 139907453
S01 379655.5 2028 4614336 2027 3796555
S03 36972.155280908 2028 1817556 2027 1836445
S04 9062063.9 2028 100564096 2027 90620639
S05 -5047479.25 2028 52907015 2027 100949585
2029x51223x0.055730744656732
S11 -23743231.55 2028 315985735 2027 474864631
S12 2601357.7 2028 32952470 2027 26013577
S14 -694480.6 2028 7833107 2027 13889612
S16 45555119 2028 493953017 2027 455551190
S21 -6815194.7 2028 82675050 2027 136303894
S22 721959 2028 9252569 2027 7219590
S23 7146939.8 2028 85255678 2027 71469398
S24 0 2028 0 2027 0
S25 -2235612.4 2028 22512271 2027 44712248
S29 1551564.7 2028 17307171 2027 15515647
S31 601134.4 2028 7956550 2027 6011344
S32 -5982760.95 2028 54268594 2027 119655219
S36 18543002.2 2028 213431766 2027 185430022
S44 19600441.9 2028 223167114 2027 196004419
S50 -1198663 2028 11841026 2027 23973260
S52 -39049.45 2028 586215 2027 780989
S53 1415299.6 2028 16136828 2027 14152996
S59 4248454.4 2028 50035054 2027 42484544
S60 -1283.85 2028 18021 2027 25677
S61 1099771.2 2028 13071793 2027 10997712
S62 3186546.8 2028 34628048 2027 31865468
S66 1857071.3 2028 21108685 2027 18570713
S67 -1122339.4 2028 16444734 2027 22446788
S72 -0 2028 0 2027 0
S73 -0 2028 0 2027 0
S74 -62345405.35 2028 913496916 2027 1246908107
S77 344398.57745778 2028 3999890 2027 3764581
S79 -6327760.7 2028 92715572 2027 126555214
S80 -128982.3 2028 2274131 2027 2579646
S81 -73741.65 2028 1116365 2027 1474833
S85 -114875.55 2028 1010941 2027 2297511
S87 124517.39553069 2028 4379679 2027 4387903
S89 -6498090.8 2028 80263940 2027 129961816
S90 -697516.5 2028 8945626 2027 13950330
S91 77316.5 2028 1053896 2027 773165
S92 -801108.7 2028 8188828 2027 16022174
S93 -1205 2028 14425 2027 24100
S94 1884893.8 2028 27291940 2027 18848938
S95 48902897.3 2028 549864697 2027 489028973
T00 289531528.35971 2028 4944577370 2027 4797068779
T01 3333517.2 2028 39275972 2027 33335172
T09 66502111.9 2028 742457693 2027 665021119
T10 1271731.3 2028 13638788 2027 12717313
T13 8472319.1 2028 95002244 2027 84723191
T15 1861774 2028 23570482 2027 18617740
T16 -750553.85119875 2028 22005536 2027 23495475
T19 -7626482.15 2028 60231242 2027 152529643
T24 5051836.3 2028 54534211 2027 50518363
T40 -43044607.25 2028 488200464 2027 860892145
T41 22271653.1 2028 257030773 2027 222716531
U01 1720.3 2028 33415 2027 17203
U11 -137530.3 2028 964304 2027 2750606
U20 2822228.6 2028 93787939 2027 28222286
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","B74","g","hist","s","1207832874","1207832874","0"),
("2029","US","B78","g","hist","s","0","0","0"),
("2029","US","","g","hist","","0","0","0"),
("2029","US","A01","g","hist","r","57853724","3697910","54155814"),
("2029","US","A18","g","hist","r","127619351","107475456","20143895"),
("2029","US","A36","g","hist","r","271656661","192031119","79625542"),
("2029","US","A44","g","hist","r","27933323","13489741","14443582"),
("2029","US","A50","g","hist","r","6901040","862413","6038627"),
("2029","US","A59","g","hist","r","6977679","5525133","1452546"),
("2029","US","A60","g","hist","r","2277233","29991","2247242"),
("2029","US","A61","g","hist","r","14148942","3770012","10378930"),
("2029","US","A80","g","hist","r","60471857","1278781","59193076"),
("2029","US","A81","g","hist","r","16647594","51460","16596134"),
("2029","US","A87","g","hist","r","6429356","1891514","4537842"),
("2029","US","A89","g","hist","r","202074322","24800593","177273729"),
("2029","US","A90","g","hist","r","14983330","8965224","6018106"),
("2029","US","A91","g","hist","r","88036879","333293","87703586"),
("2029","US","A92","g","hist","r","67831586","6446471","61385115"),
("2029","US","A93","g","hist","r","4535186","15914","4519272"),
("2029","US","A94","g","hist","r","15631693","4801812","10829881"),
("2029","US","B01","g","hist","s","4421879","4421879","0"),
("2029","US","B21","g","hist","s","168474107","168474107","0"),
("2029","US","B22","g","hist","s","9007748","9007748","0"),
("2029","US","B30","g","hist","s","94208228","94208228","0"),
("2029","US","B42","g","hist","s","107985928","107985928","0"),
("2029","US","B46","g","hist","s","92742062","92742062","0"),
("2029","US","B50","g","hist","s","52124332","52124332","0"),
("2029","US","B54","g","hist","s","1627690","1627690","0"),
("2029","US","B59","g","hist","s","31232832","31232832","0"),
("2029","US","B62","g","hist","s","10568957","10568957","0"),
("2029","US","B66","g","hist","s","8436915","8436915","0"),
("2029","US","B79","g","hist","s","102333924","102333924","0"),
("2029","US","B80","g","hist","s","8483912","8483912","0"),
("2029","US","B89","g","hist","s","495488","495488","0"),
("2029","US","B92","g","hist","s","1052983","1052983","0"),
("2029","US","B93","g","hist","s","129270","129270","0"),
("2029","US","B94","g","hist","s","68449514","68449514","0"),
("2029","US","D49","g","hist","s","5142556152","1569218550","3573337602"),
("2029","US","D64","g","hist","s","89962611","17557976","72404635"),
("2029","US","E00","g","hist","s","6129937063","2898426126","3231510937"),
("2029","US","I89","g","hist","s","193333286","57164065","136169221"),
("2029","US","M00","g","hist","r","-1977995235","-1977995235","0"),
("2029","US","O99","g","hist","r","126852060","54463590","72388470"),
("2029","US","Q79","g","hist","","1625763764","1513647395","112116369"),
("2029","US","R00","g","hist","r","5175916799","3255731015","1920185784"),
("2029","US","R01","g","hist","r","100481636","100280106","201530"),
("2029","US","R02","g","hist","r","779420824","647905759","131515065"),
("2029","US","R03","g","hist","r","10683062","10683062","0"),
("2029","US","R95","g","hist","r","976489154","831711593","144777561"),
("2029","US","R98","g","hist","r","22162442","22162442","0"),
("2029","US","R99","g","hist","r","35694211","28538333","7155878"),
("2029","US","S01","g","hist","s","67828453","4993992","62834461"),
("2029","US","S03","g","hist","s","3151808","1854528","1297280"),
("2029","US","S04","g","hist","s","143802819","109626160","34176659"),
("2029","US","S05","g","hist","s","47988087","50526783.580206","128551"),
("2029","US","S11","g","hist","s","360687747","292242503","68445244"),
("2029","US","S12","g","hist","s","990181972","35553828","954628144"),
("2029","US","S14","g","hist","s","7138626","7138626","0"),
("2029","US","S16","g","hist","s","635975644","539508136","96467508"),
("2029","US","S21","g","hist","s","82389317","75859855","6529462"),
("2029","US","S22","g","hist","s","10065154","9974528","90626"),
("2029","US","S23","g","hist","s","170455359","92402618","78052741"),
("2029","US","S24","g","hist","s","98733768","0","98733768"),
("2029","US","S25","g","hist","s","72778439","20276659","52501780"),
("2029","US","S29","g","hist","s","59097579","18858736","40238843"),
("2029","US","S31","g","hist","s","23577401","8557684","15019717"),
("2029","US","S32","g","hist","s","169275036","48285833","120989203"),
("2029","US","S36","g","hist","s","330688627","231974768","98713859"),
("2029","US","S44","g","hist","s","429158391","242767556","186390835"),
("2029","US","S50","g","hist","s","84055417","10642363","73413054"),
("2029","US","S52","g","hist","s","34144033","547166","33596867"),
("2029","US","S53","g","hist","s","17552128","17552128","0"),
("2029","US","S59","g","hist","s","71599919","54283508","17316411"),
("2029","US","S60","g","hist","s","3584345","16737","3567608"),
("2029","US","S61","g","hist","s","124712982","14171564","110541418"),
("2029","US","S62","g","hist","s","252476836","37814595","214662241"),
("2029","US","S66","g","hist","s","39787780","22965756","16822024"),
("2029","US","S67","g","hist","s","30137632","15322395","14815237"),
("2029","US","S72","g","hist","s","0","0","0"),
("2029","US","S73","g","hist","s","0","0","0"),
("2029","US","S74","g","hist","s","858213931","851151511","7062420"),
("2029","US","S77","g","hist","s","4344289","4344289","0"),
("2029","US","S79","g","hist","s","143313427","86387811","56925616"),
("2029","US","S80","g","hist","s","160587875","2145149","158442726"),
("2029","US","S81","g","hist","s","45408123","1042623","44365500"),
("2029","US","S85","g","hist","s","896065","896065","0"),
("2029","US","S87","g","hist","s","14585671","4504196","10081475"),
("2029","US","S89","g","hist","s","376862111","73765849","303096262"),
("2029","US","S90","g","hist","s","9177090","8248110","928980"),
("2029","US","S91","g","hist","s","187226212","1131213","186094999"),
("2029","US","S92","g","hist","s","67523199","7387719","60135480"),
("2029","US","S93","g","hist","s","4061284","13220","4048064"),
("2029","US","S94","g","hist","s","172928924","29176834","143752090"),
("2029","US","S95","g","hist","s","733899751","598767594","135132157"),
("2029","US","T00","g","hist","r","7154294682","5234108898","1920185784"),
("2029","US","T01","g","hist","r","784877910","42609489","742268421"),
("2029","US","T09","g","hist","r","907057081","808959805","98097276"),
("2029","US","T10","g","hist","r","15368036","14910519","457517"),
("2029","US","T13","g","hist","r","105575812","103474563","2101249"),
("2029","US","T15","g","hist","r","38570288","25432256","13138032"),
("2029","US","T16","g","hist","r","21423510","21254982","168528"),
("2029","US","T19","g","hist","r","64907319","52604760","12302559"),
("2029","US","T24","g","hist","r","75397085","59586047","15811038"),
("2029","US","T40","g","hist","r","565324246","445155857","120168389"),
("2029","US","T41","g","hist","r","340852220","279302426","61549794"),
("2029","US","U01","g","hist","r","13150238","35135","13115103"),
("2029","US","U11","g","hist","r","7059628","826774","6232854"),
("2029","US","U20","g","hist","r","174061279","96610168","77451111")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","M00","g","hist","r","-1950602771","-1950602771","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","T00","g","hist","r","7131531414","5140865681","1990665733")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","R00","g","hist","r","5180928643","3190262910","1990665733")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","E00","g","hist","s","6597809744.5802","3086733370.5802","3511076374")
Done