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 3217519 2027 2947504
A18 18563949.3 2028 202645553 2027 185639493
A36 15244299 2028 166407985 2027 152442990
A44 2103693.3 2028 22964084 2027 21036933
A50 198741.6 2028 2169479 2027 1987416
A59 571880.2 2028 6242690 2027 5718802
A60 5044.1 2028 55062 2027 50441
A61 305788.4 2028 3338011 2027 3057884
A80 164776.9 2028 1798716 2027 1647769
A81 42670.1 2028 465790 2027 426701
A87 453405.3 2028 4949409 2027 4534053
A89 3744207.5 2028 40872061 2027 37442075
A90 1728256.2 2028 18865783 2027 17282562
A91 56191 2028 613386 2027 561910
A92 1485396.8 2028 16214710 2027 14853968
A93 937.5 2028 10254 2027 9375
A94 344408.3 2028 3759589 2027 3444083
B01 529484.1 2028 5771185 2027 5294841
B21 14138383.6 2028 154335723 2027 141383836
B22 1048837.3 2028 11465185 2027 10488373
B30 9784943.6 2028 105902601 2027 97849436
B42 9062202.5 2028 98923725 2027 90622025
B46 7782933.6 2028 84959128 2027 77829336
B50 6118380.4 2028 66907183 2027 61183804
B54 136596.1 2028 1491094 2027 1365961
B59 3654914.5 2028 39962409 2027 36549145
B62 886949.1 2028 9682008 2027 8869491
B66 710567.8 2028 7756615 2027 7105678
B79 8587884.8 2028 93746039 2027 85878848
B80 711971.7 2028 7771940 2027 7119717
B89 58608.9 2028 641142 2027 586089
B92 121854.6 2028 1331648 2027 1218546
B93 10848.4 2028 118422 2027 108484
B94 5744297.8 2028 62705216 2027 57442978
D49 120346905.6 2028 1314435026 2027 1203469056
D64 1148323.6 2028 12558492 2027 11483236
E00 373764449.1 2028 4075681292 2027 3737644491
I89 3912268.3 2028 42756262 2027 39122683
M00 -168853737.1 2028 -1842503919 2027 -1688537371
O99 22180746.8 2028 242126817 2027 221807468
Q79 129690235.7 2028 1415727996 2027 1296902357
R00 310853140.8 2028 3392507348 2027 3108531408
R01 7863026.3 2028 85934307 2027 78630263
R02 1845147.2086007 2028 24054797 2027 22900249
R03 1895277.6 2028 20689201 2027 18952776
R95 24512094.4 2028 267576310 2027 245120944
R98 1769245.3 2028 19313223 2027 17692453
R99 13990745.3 2028 152724101 2027 139907453
S01 379655.5 2028 4144377 2027 3796555
S03 183644.5 2028 2005646 2027 1836445
S04 9062063.9 2028 98922214 2027 90620639
S05 10213100.343466 2028 127132957 2027 120545494
2029x45038x0.075405921680993
S11 47486463.1 2028 518366055 2027 474864631
S12 2601357.7 2028 28396685 2027 26013577
S14 1388961.2 2028 15162012 2027 13889612
S16 45555119 2028 497283317 2027 455551190
S21 13630389.4 2028 148790422 2027 136303894
S22 721959 2028 7880192 2027 7219590
S23 7146939.8 2028 78016571 2027 71469398
S24 0 2028 0 2027 0
S25 4471224.8 2028 48808247 2027 44712248
S29 1551564.7 2028 16937004 2027 15515647
S31 601134.4 2028 6562061 2027 6011344
S32 11965521.9 2028 130616591 2027 119655219
S36 18543002.2 2028 202416894 2027 185430022
S44 19600441.9 2028 213960000 2027 196004419
S50 2397326 2028 26169403 2027 23973260
S52 78098.9 2028 852534 2027 780989
S53 1415299.6 2028 15449524 2027 14152996
S59 4248454.4 2028 46376468 2027 42484544
S60 2567.7 2028 28029 2027 25677
S61 1099771.2 2028 12005190 2027 10997712
S62 3186546.8 2028 34784600 2027 31865468
S66 1857071.3 2028 20271939 2027 18570713
S67 2244678.8 2028 24503093 2027 22446788
S72 0 2028 0 2027 0
S73 0 2028 0 2027 0
S74 124690810.7 2028 1361134856 2027 1246908107
S77 376458.1 2028 4109454 2027 3764581
S79 12655521.4 2028 138148683 2027 126555214
S80 257964.6 2028 2815962 2027 2579646
S81 147483.3 2028 1609861 2027 1474833
S85 229751.1 2028 2507981 2027 2297511
S87 438790.3 2028 4789870 2027 4387903
S89 12996181.6 2028 141867362 2027 129961816
S90 1395033 2028 15228289 2027 13950330
S91 77316.5 2028 843992 2027 773165
S92 1602217.4 2028 17489933 2027 16022174
S93 2410 2028 26328 2027 24100
S94 1884893.8 2028 20619888 2027 18848938
S95 48902897.3 2028 533828590 2027 489028973
T00 479706877.9 2028 5235011267 2027 4797068779
T01 3333517.2 2028 36388940 2027 33335172
T09 66502111.9 2028 725942376 2027 665021119
T10 1271731.3 2028 13882320 2027 12717313
T13 8472319.1 2028 92484512 2027 84723191
T15 1861774 2028 20323269 2027 18617740
T16 2349547.5 2028 25647044 2027 23495475
T19 15252964.3 2028 166502576 2027 152529643
T24 5051836.3 2028 55146248 2027 50518363
T40 86089214.5 2028 939756738 2027 860892145
T41 22271653.1 2028 243119081 2027 222716531
U01 1720.3 2028 18806 2027 17203
U11 275060.6 2028 3002584 2027 2750606
U20 2822228.6 2028 30860327 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","70153856","3512269","66641587"),
("2029","US","A18","g","hist","r","278441436","221209502","57231934"),
("2029","US","A36","g","hist","r","543753453","181652284","362101169"),
("2029","US","A44","g","hist","r","55577701","25067777","30509924"),
("2029","US","A50","g","hist","r","19154975","2368221","16786754"),
("2029","US","A59","g","hist","r","13468521","6814570","6653951"),
("2029","US","A60","g","hist","r","8645304","60106","8585198"),
("2029","US","A61","g","hist","r","32374725","3643799","28730926"),
("2029","US","A80","g","hist","r","154857100","1963493","152893607"),
("2029","US","A81","g","hist","r","49917649","508460","49409189"),
("2029","US","A87","g","hist","r","18019982","5402814","12617168"),
("2029","US","A89","g","hist","r","230547012","44616269","185930743"),
("2029","US","A90","g","hist","r","25926111","20594039","5332072"),
("2029","US","A91","g","hist","r","166778919","669577","166109342"),
("2029","US","A92","g","hist","r","213525128","17700107","195825021"),
("2029","US","A93","g","hist","r","22825733","11192","22814541"),
("2029","US","A94","g","hist","r","27094729","4103997","22990732"),
("2029","US","B01","g","hist","s","6300669","6300669","0"),
("2029","US","B21","g","hist","s","168474107","168474107","0"),
("2029","US","B22","g","hist","s","12514022","12514022","0"),
("2029","US","B30","g","hist","s","115687545","115687545","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","73025563","73025563","0"),
("2029","US","B54","g","hist","s","1627690","1627690","0"),
("2029","US","B59","g","hist","s","43617324","43617324","0"),
("2029","US","B62","g","hist","s","10568957","10568957","0"),
("2029","US","B66","g","hist","s","8467183","8467183","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","699751","699751","0"),
("2029","US","B92","g","hist","s","1453503","1453503","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","4718681601","1434781932","3283899669"),
("2029","US","D64","g","hist","s","65510591","13706816","51803775"),
("2029","US","E00","g","hist","s","9888274183","4449445741","5438828442"),
("2029","US","I89","g","hist","s","159453102","46668530","112784572"),
("2029","US","M00","g","hist","r","-2011357656","-2011357656","0"),
("2029","US","O99","g","hist","r","443981394","264307564","179673830"),
("2029","US","Q79","g","hist","","1686477914","1545418232","141059682"),
("2029","US","R00","g","hist","r","7497459104","3703360489","3794098615"),
("2029","US","R01","g","hist","r","93887699","93797333","90366"),
("2029","US","R02","g","hist","r","41490535","25899944","15590591"),
("2029","US","R03","g","hist","r","22584479","22584479","0"),
("2029","US","R95","g","hist","r","337024618","292088404","44936214"),
("2029","US","R98","g","hist","r","21082468","21082468","0"),
("2029","US","R99","g","hist","r","295745113","166714846","129030267"),
("2029","US","S01","g","hist","s","41960769","4524033","37436736"),
("2029","US","S03","g","hist","s","8038102","2189291","5848811"),
("2029","US","S04","g","hist","s","179093787","107984278","71109509"),
("2029","US","S05","g","hist","s","137346057","147702763.01734","0"),
("2029","US","S11","g","hist","s","709838426","565852518","143985908"),
("2029","US","S12","g","hist","s","2112695732","30998043","2081697689"),
("2029","US","S14","g","hist","s","16550973","16550973","0"),
("2029","US","S16","g","hist","s","630065648","542838436","87227212"),
("2029","US","S21","g","hist","s","167447061","162420811","5026250"),
("2029","US","S22","g","hist","s","8660426","8602151","58275"),
("2029","US","S23","g","hist","s","141537174","85163511","56373663"),
("2029","US","S24","g","hist","s","147183501","0","147183501"),
("2029","US","S25","g","hist","s","114939082","53279472","61659610"),
("2029","US","S29","g","hist","s","110070178","18488569","91581609"),
("2029","US","S31","g","hist","s","37570296","7163195","30407101"),
("2029","US","S32","g","hist","s","322645292","142582113","180063179"),
("2029","US","S36","g","hist","s","583485148","220959896","362525252"),
("2029","US","S44","g","hist","s","384654371","233560442","151093929"),
("2029","US","S50","g","hist","s","181911063","28566729","153344334"),
("2029","US","S52","g","hist","s","32313033","930633","31382400"),
("2029","US","S53","g","hist","s","16864824","16864824","0"),
("2029","US","S59","g","hist","s","86005475","50624922","35380553"),
("2029","US","S60","g","hist","s","3912994","30597","3882397"),
("2029","US","S61","g","hist","s","117449767","13104961","104344806"),
("2029","US","S62","g","hist","s","294943635","37971147","256972488"),
("2029","US","S66","g","hist","s","37296607","22129010","15167597"),
("2029","US","S67","g","hist","s","54019351","26747772","27271579"),
("2029","US","S72","g","hist","s","0","0","0"),
("2029","US","S73","g","hist","s","0","0","0"),
("2029","US","S74","g","hist","s","1498825994","1485825667","13000327"),
("2029","US","S77","g","hist","s","4485912","4485912","0"),
("2029","US","S79","g","hist","s","255591663","150804204","104787459"),
("2029","US","S80","g","hist","s","149548891","3073927","146474964"),
("2029","US","S81","g","hist","s","60124218","1757344","58366874"),
("2029","US","S85","g","hist","s","2737732","2737732","0"),
("2029","US","S87","g","hist","s","12831778","5228660","7603118"),
("2029","US","S89","g","hist","s","496668618","154863544","341805074"),
("2029","US","S90","g","hist","s","21037291","16623322","4413969"),
("2029","US","S91","g","hist","s","163047470","921309","162126161"),
("2029","US","S92","g","hist","s","206913559","19092150","187821409"),
("2029","US","S93","g","hist","s","21366806","28738","21338068"),
("2029","US","S94","g","hist","s","159786841","22504782","137282059"),
("2029","US","S95","g","hist","s","700282700","582731487","117551213"),
("2029","US","T00","g","hist","r","9508816760","5714718145","3794098615"),
("2029","US","T01","g","hist","r","1418867581","39722457","1379145124"),
("2029","US","T09","g","hist","r","1171827414","792444488","379382926"),
("2029","US","T10","g","hist","r","17676974","15154051","2522923"),
("2029","US","T13","g","hist","r","106648010","100956831","5691179"),
("2029","US","T15","g","hist","r","57399949","22185043","35214906"),
("2029","US","T16","g","hist","r","28406880","27996592","410288"),
("2029","US","T19","g","hist","r","242809791","181755540","61054251"),
("2029","US","T24","g","hist","r","65538656","60198084","5340572"),
("2029","US","T40","g","hist","r","1139125469","1025845953","113279516"),
("2029","US","T41","g","hist","r","298536088","265390734","33145354"),
("2029","US","U01","g","hist","r","44998479","20526","44977953"),
("2029","US","U11","g","hist","r","10697164","3277645","7419519"),
("2029","US","U20","g","hist","r","44647746","33682556","10965190")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","M00","g","hist","r","-2011357658","-2011357658","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","T00","g","hist","r","9508371881","5714273268","3794098613")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","R00","g","hist","r","7497014223","3702915610","3794098613")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2029","US","E00","g","hist","s","9896789441.0173","4457960999.0173","5438828442")
Done