return to Menu
0 secs
US
B74 114744122.65 2031 1426114255 2030 1305330968
B74
B78 0 2031 0 2030 0
0 2031 0 2030 0
A01 333665.65 2031 4147012 2030 3795785
A18 21014902.5 2031 261186815 2030 239065865
A36 17256966.6 2031 214480757 2030 196315529
A44 2381439.1 2031 29598063 2030 27091285
A50 224980.9 2031 2796209 2030 2559387
A59 647384.15 2031 8046110 2030 7364653
A60 5710.45 2031 70969 2030 64958
A61 346161 2031 4302313 2030 3937933
A80 185835.2 2031 2310274 2030 2114658
A81 48303.7 2031 600350 2030 549504
A87 513266.95 2031 6379219 2030 5838938
A89 4238545.65 2031 52679381 2030 48217754
A90 1956433.8 2031 24315825 2030 22256421
A91 63610.1 2031 790585 2030 723627
A92 1681510.45 2031 20898897 2030 19128886
A93 893.95 2031 12091 2030 11150
A94 389880 2031 4845679 2030 4435279
B01 462255.75 2031 6648365 2030 6161780
B21 16005040.45 2031 198920999 2030 182073588
B22 1095786.05 2031 13826801 2030 12673342
B30 7763280.3 2031 119550529 2030 111378655
B42 10258663.35 2031 127501306 2030 116702713
B46 8810495.7 2031 109502549 2030 100228343
B50 5946265.65 2031 79394702 2030 73135475
B54 154630.55 2031 1921848 2030 1759079
B59 3640274.6 2031 47700207 2030 43868339
B62 1004051.2 2031 12478996 2030 11422100
B66 804382.1 2031 9997385 2030 9150667
B79 9721722.4 2031 120827866 2030 110594474
B80 805971.45 2031 10017137 2030 9168746
B89 54711.45 2031 750975 2030 693384
B92 131955.95 2031 1623438 2030 1484537
B93 12280.65 2031 152632 2030 139705
B94 6502703.45 2031 80819815 2030 73974864
D49 131132472.9 2031 1621145224 2030 1483111042
D64 1105473.2 2031 14856305 2030 13692649
E00 243211715.4 2031 3104527942 2030 2848515610
I89 4234025.55 2031 52046375 2030 47589506
M00 -214936799.2 2031 -2345273424 2030 -2149367992
O99 25109218.2 2031 312073637 2030 285642881
Q79 157891976 2031 1962383708 2030 1796181628
R00 349925737.9 2031 4358597713 2030 3990254831
R01 8508456.5 2031 104567551 2030 95611281
R02 1513456.4 2031 27084066 2030 25490954
R03 2123280.4 2031 26408594 2030 24173562
R95 27295464.6 2031 339630878 2030 310898810
R98 2002834.65 2031 24892524 2030 22784277
R99 15837910.75 2031 196843812 2030 180172327
S01 427016.45 2031 5309612 2030 4860121
S03 164473.5 2031 2323521 2030 2150391
S04 10258506.6 2031 127499359 2030 116700931
S05 -651550.8 2031 -14491581 2030 -6515508
2032xx-1
S11 53755989.4 2031 668114266 2030 611529014
S12 2929927.3 2031 36427742 2030 33343608
S14 1572342.15 2031 19542090 2030 17886993
S16 51569651.8 2031 640941014 2030 586657170
S21 15429976.95 2031 191773747 2030 175531666
S22 802497.3 2031 9985702 2030 9140968
S23 8090533.45 2031 100554393 2030 92038042
S24 0 2031 0 2030 0
S25 5061549.65 2031 62908218 2030 57580271
S29 1756414.15 2031 21829850 2030 19980993
S31 677049.8 2031 8417776 2030 7705092
S32 13545300.45 2031 168349764 2030 154091553
S36 20991190.5 2031 260892101 2030 238796111
S44 22188241.8 2031 275769846 2030 252413802
S50 2713839.35 2031 33729352 2030 30872679
S52 88409.85 2031 1098818 2030 1005755
S53 1602157.9 2031 19912660 2030 18226178
S59 4809367.4 2031 59773935 2030 54711443
S60 2907 2031 36126 2030 33066
S61 1244971.2 2031 15473309 2030 14162813
S62 3607259.25 2031 44833350 2030 41036235
S66 2102255.95 2031 26128199 2030 23915298
S72 0 2031 0 2030 0
S73 0 2031 0 2030 0
S77 424007.8 2031 5271684 2030 4825360
S80 292023.35 2031 3629451 2030 3322058
S81 164190.4 2031 2042933 2030 1870101
S85 260084.35 2031 3232499 2030 2958726
S87 496722.7 2031 6173592 2030 5650726
S89 14712036.3 2031 182850721 2030 167364367
S90 1579215.4 2031 19627511 2030 17965179
S91 87083.65 2031 1082707 2030 991040
S92 1813754.25 2031 22542512 2030 20633297
S93 2619.15 2031 32321 2030 29564
S94 1755400.5 2031 24134151 2030 22286361
S95 54455863.9 2031 677581181 2030 620259219
T00 536035898.3 2031 6703871137 2030 6139622823
T01 3773633.7 2031 46901160 2030 42928914
T09 75282226.55 2031 935656257 2030 856411808
T10 1439634.75 2031 17892714 2030 16377309
T13 9590898.85 2031 119201901 2030 109106218
T15 2107578.8 2031 26194353 2030 23975849
T16 2615930.45 2031 32548866 2030 29795255
T19 17266776.3 2031 214602674 2030 196427120
T24 5718817.6 2031 71077172 2030 65057364
T40 97455365.25 2031 1211238370 2030 1108653775
T41 25212119.35 2031 313352485 2030 286813412
U01 1783.15 2031 22641 2030 20764
U11 311376.75 2031 3869986 2030 3542221
U20 2764949.35 2031 36708401 2030 33797928
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","B74","g","hist","s","1540858378","1540858378","0"),
("2032","US","B78","g","hist","s","0","0","0"),
("2032","US","","g","hist","","0","0","0"),
("2032","US","A01","g","hist","r","94482767","4480678","90002089"),
("2032","US","A18","g","hist","r","359908540","282201718","77706822"),
("2032","US","A36","g","hist","r","715218177","231737724","483480453"),
("2032","US","A44","g","hist","r","73084541","31979502","41105039"),
("2032","US","A50","g","hist","r","24541702","3021190","21520512"),
("2032","US","A59","g","hist","r","17364890","8693494","8671396"),
("2032","US","A60","g","hist","r","11590852","76679","11514173"),
("2032","US","A61","g","hist","r","43286309","4648474","38637835"),
("2032","US","A80","g","hist","r","197684021","2496109","195187912"),
("2032","US","A81","g","hist","r","63920470","648654","63271816"),
("2032","US","A87","g","hist","r","23350098","6892486","16457612"),
("2032","US","A89","g","hist","r","299252207","56917927","242334280"),
("2032","US","A90","g","hist","r","33245065","26272259","6972806"),
("2032","US","A91","g","hist","r","210775708","854195","209921513"),
("2032","US","A92","g","hist","r","276374225","22580407","253793818"),
("2032","US","A93","g","hist","r","30994442","12985","30981457"),
("2032","US","A94","g","hist","r","36573103","5235559","31337544"),
("2032","US","B01","g","hist","s","7110621","7110621","0"),
("2032","US","B21","g","hist","s","214926039","214926039","0"),
("2032","US","B22","g","hist","s","14922587","14922587","0"),
("2032","US","B30","g","hist","s","127313809","127313809","0"),
("2032","US","B42","g","hist","s","137759969","137759969","0"),
("2032","US","B46","g","hist","s","118313045","118313045","0"),
("2032","US","B50","g","hist","s","85340968","85340968","0"),
("2032","US","B54","g","hist","s","2076479","2076479","0"),
("2032","US","B59","g","hist","s","51340482","51340482","0"),
("2032","US","B62","g","hist","s","13483047","13483047","0"),
("2032","US","B66","g","hist","s","10801767","10801767","0"),
("2032","US","B79","g","hist","s","130549588","130549588","0"),
("2032","US","B80","g","hist","s","10823108","10823108","0"),
("2032","US","B89","g","hist","s","805686","805686","0"),
("2032","US","B92","g","hist","s","1755394","1755394","0"),
("2032","US","B93","g","hist","s","164913","164913","0"),
("2032","US","B94","g","hist","s","87322518","87322518","0"),
("2032","US","D49","g","hist","s","5736748095","1752277697","3984470398"),
("2032","US","D64","g","hist","s","80136427","15961778","64174649"),
("2032","US","E00","g","hist","s","10154289158","3347739657","6806549501"),
("2032","US","I89","g","hist","s","194043032","56280401","137762631"),
("2032","US","M00","g","hist","r","-2560210223","-2560210223","0"),
("2032","US","O99","g","hist","r","569645509","337182855","232462654"),
("2032","US","Q79","g","hist","","2307637905","2120275684","187362221"),
("2032","US","R00","g","hist","r","9655587450","4708523451","4947063999"),
("2032","US","R01","g","hist","r","113176668","113076008","100660"),
("2032","US","R02","g","hist","r","45323467","28597522","16725945"),
("2032","US","R03","g","hist","r","28531874","28531874","0"),
("2032","US","R95","g","hist","r","422140743","366926343","55214400"),
("2032","US","R98","g","hist","r","26895359","26895359","0"),
("2032","US","R99","g","hist","r","389409393","212681723","176727670"),
("2032","US","S01","g","hist","s","49003659","5736628","43267031"),
("2032","US","S03","g","hist","s","9923445","2487995","7435450"),
("2032","US","S04","g","hist","s","228289358","137757866","90531492"),
("2032","US","S05","g","hist","s","-15143132","-0","0"),
("2032","US","S11","g","hist","s","904651641","721870255","182781386"),
("2032","US","S12","g","hist","s","2743541732","39357669","2704184063"),
("2032","US","S14","g","hist","s","21114432","21114432","0"),
("2032","US","S16","g","hist","s","801215725","692510666","108705059"),
("2032","US","S21","g","hist","s","213379628","207203724","6175904"),
("2032","US","S22","g","hist","s","10858834","10788199","70635"),
("2032","US","S23","g","hist","s","181238316","108644926","72593390"),
("2032","US","S24","g","hist","s","188706853","0","188706853"),
("2032","US","S25","g","hist","s","146615273","67969768","78645505"),
("2032","US","S29","g","hist","s","141995581","23586264","118409317"),
("2032","US","S31","g","hist","s","47920321","9094826","38825495"),
("2032","US","S32","g","hist","s","413232033","181895064","231336969"),
("2032","US","S36","g","hist","s","753011896","281883292","471128604"),
("2032","US","S44","g","hist","s","485168332","297958088","187210244"),
("2032","US","S50","g","hist","s","236279680","36443191","199836489"),
("2032","US","S52","g","hist","s","41433825","1187228","40246597"),
("2032","US","S53","g","hist","s","21514818","21514818","0"),
("2032","US","S59","g","hist","s","110735982","64583302","46152680"),
("2032","US","S60","g","hist","s","4854929","39033","4815896"),
("2032","US","S61","g","hist","s","151148290","16718280","134430010"),
("2032","US","S62","g","hist","s","375018005","48440609","326577396"),
("2032","US","S66","g","hist","s","47498193","28230455","19267738"),
("2032","US","S72","g","hist","s","0","0","0"),
("2032","US","S73","g","hist","s","0","0","0"),
("2032","US","S77","g","hist","s","5695692","5695692","0"),
("2032","US","S80","g","hist","s","189876458","3921474","185954984"),
("2032","US","S81","g","hist","s","75783104","2207123","73575981"),
("2032","US","S85","g","hist","s","3492583","3492583","0"),
("2032","US","S87","g","hist","s","16138054","6670315","9467739"),
("2032","US","S89","g","hist","s","640236954","197562757","442674197"),
("2032","US","S90","g","hist","s","26958834","21206726","5752108"),
("2032","US","S91","g","hist","s","204428743","1169791","203258952"),
("2032","US","S92","g","hist","s","268253161","24356266","243896895"),
("2032","US","S93","g","hist","s","28828314","34940","28793374"),
("2032","US","S94","g","hist","s","199967993","25889552","174078441"),
("2032","US","S95","g","hist","s","876475569","732037045","144438524"),
("2032","US","T00","g","hist","r","12186971034","7239907035","4947063999"),
("2032","US","T01","g","hist","r","1808329197","50674794","1757654403"),
("2032","US","T09","g","hist","r","1531472410","1010938484","520533926"),
("2032","US","T10","g","hist","r","22753458","19332349","3421109"),
("2032","US","T13","g","hist","r","136577472","128792800","7784672"),
("2032","US","T15","g","hist","r","73288175","28301932","44986243"),
("2032","US","T16","g","hist","r","35636733","35164796","471937"),
("2032","US","T19","g","hist","r","313473373","231869450","81603923"),
("2032","US","T24","g","hist","r","83666327","76795990","6870337"),
("2032","US","T40","g","hist","r","1455687583","1308693735","146993848"),
("2032","US","T41","g","hist","r","384021486","338564604","45456882"),
("2032","US","U01","g","hist","r","61135415","24424","61110991"),
("2032","US","U11","g","hist","r","13474268","4181363","9292905"),
("2032","US","U20","g","hist","r","51442165","39473350","11968815")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","M00","g","hist","r","-2531383584","-2531383584","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","T00","g","hist","r","12186971033","7239907036","4947063997")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","R00","g","hist","r","9655587449","4708523452","4947063997")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2032","US","E00","g","hist","s","10176358011","3369808506","6806549505")
Done