return to Menu
0 secs
US
B74 120783287.4 2030 1318480002 2029 1207832874
B74
B78 0 2030 0 2029 0
0 2030 0 2029 0
A01 351226.9 2030 3834021 2029 3512269
A18 22120950.2 2030 241474057 2029 221209502
A36 18165228.4 2030 198293083 2029 181652284
A44 2506777.7 2030 27364185 2029 25067777
A50 236822.1 2030 2585169 2029 2368221
A59 681457 2030 7438839 2029 6814570
A60 6010.6 2030 65612 2029 60106
A61 364379.9 2030 3977600 2029 3643799
A80 196349.3 2030 2143365 2029 1963493
A81 50846 2030 555039 2029 508460
A87 540281.4 2030 5897755 2029 5402814
A89 4461626.9 2030 48703475 2029 44616269
A90 2059403.9 2030 22480617 2029 20594039
A91 66957.7 2030 730916 2029 669577
A92 1770010.7 2030 19321578 2029 17700107
A93 1119.2 2030 12197 2029 11192
A94 410399.7 2030 4479956 2029 4103997
B01 630066.9 2030 6863785 2029 6300669
B21 16847410.7 2030 183907679 2029 168474107
B22 1251402.2 2030 13643799 2029 12514022
B30 11568754.5 2030 126017714 2029 115687545
B42 10798592.8 2030 117878301 2029 107985928
B46 9274206.2 2030 101237975 2029 92742062
B50 7302556.3 2030 79591782 2029 73025563
B54 162769 2030 1776799 2029 1627690
B59 4361732.4 2030 47545263 2029 43617324
B62 1056895.7 2030 11537158 2029 10568957
B66 846718.3 2030 9242845 2029 8467183
B79 10233392.4 2030 111708528 2029 102333924
B80 848391.2 2030 9261106 2029 8483912
B89 69975.1 2030 762430 2029 699751
B92 145350.3 2030 1585133 2029 1453503
B93 12927 2030 141112 2029 129270
B94 6844951.4 2030 74720036 2029 68449514
D49 143478193.2 2030 1565282831 2029 1434781932
D64 1370681.6 2030 14938159 2029 13706816
E00 371381894.21195 2030 4679724699 2029 4457960999
I89 4666853 2030 50892406 2029 46668530
M00 -201135765.8 2030 -2195121444 2029 -2011357658
O99 26430756.4 2030 288520246 2029 264307564
Q79 154541823.2 2030 1686991032 2029 1545418232
R00 370291561 2030 4041943601 2029 3702915610
R01 9379733.3 2030 102285540 2029 93797333
R02 2589994.4 2030 28243262 2029 25899944
R03 2258447.9 2030 24653399 2029 22584479
R95 29208840.4 2030 318846035 2029 292088404
R98 2108246.8 2030 23013790 2029 21082468
R99 16671484.6 2030 181987256 2029 166714846
S01 452403.3 2030 4938471 2029 4524033
S03 218929.1 2030 2385006 2029 2189291
S04 10798427.8 2030 117876499 2029 107984278
S05 14770276.3 2030 168532022 2029 147702763
2031x50640x0.060168320562743
S11 56585251.8 2030 617689124 2029 565852518
S12 3099804.3 2030 33837712 2029 30998043
S14 1655097.3 2030 18067174 2029 16550973
S16 54283843.6 2030 592566768 2029 542838436
S21 16242081.1 2030 177299853 2029 162420811
S22 860215.1 2030 9390170 2029 8602151
S23 8516351.1 2030 92965168 2029 85163511
S24 0 2030 0 2029 0
S25 5327947.2 2030 58160297 2029 53279472
S29 1848856.9 2030 20182269 2029 18488569
S31 716319.5 2030 7819401 2029 7163195
S32 14258211.3 2030 155643772 2029 142582113
S36 22095989.6 2030 241201585 2029 220959896
S44 23356044.2 2030 254956442 2029 233560442
S50 2856672.9 2030 31183669 2029 28566729
S52 93063.3 2030 1015886 2029 930633
S53 1686482.4 2030 18409776 2029 16864824
S59 5062492.2 2030 55262569 2029 50624922
S60 3059.7 2030 33400 2029 30597
S61 1310496.1 2030 14305480 2029 13104961
S62 3797114.7 2030 41449607 2029 37971147
S66 2212901 2030 24156204 2029 22129010
S72 0 2030 0 2029 0
S73 0 2030 0 2029 0
S74 148582566.7 2030 1621939153 2029 1485825667
S77 448591.2 2030 4896857 2029 4485912
S80 307392.7 2030 3355523 2029 3073927
S81 175734.4 2030 1918330 2029 1757344
S85 273773.2 2030 2988530 2029 2737732
S87 522866 2030 5707647 2029 5228660
S89 15486354.4 2030 169050280 2029 154863544
S90 1662332.2 2030 18146151 2029 16623322
S91 92130.9 2030 1005708 2029 921309
S92 1909215 2030 20841143 2029 19092150
S93 2873.8 2030 31350 2029 28738
S94 2250478.2 2030 24520154 2029 22504782
S95 58273148.7 2030 636114346 2029 582731487
T00 571427326.8 2030 6237065045 2029 5714273268
T01 3972245.7 2030 43361351 2029 39722457
T09 79244448.8 2030 865038726 2029 792444488
T10 1515405.1 2030 16542283 2029 15154051
T13 10095683.1 2030 110205282 2029 100956831
T15 2218504.3 2030 24217370 2029 22185043
T16 2799659.2 2030 30561296 2029 27996592
T19 18175554 2030 198405798 2029 181755540
T24 6019808.4 2030 65712709 2029 60198084
T40 102584595.3 2030 1119821627 2029 1025845953
T41 26539073.4 2030 289702642 2029 265390734
U01 2052.6 2030 22378 2029 20526
U11 327764.5 2030 3577903 2029 3277645
U20 3368255.6 2030 36713279 2029 33682556
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","B74","g","hist","s","1439263289","1439263289","0"),
("2031","US","B78","g","hist","s","0","0","0"),
("2031","US","","g","hist","","0","0","0"),
("2031","US","A01","g","hist","r","95441669","4185248","91256421"),
("2031","US","A18","g","hist","r","341963903","263595007","78368896"),
("2031","US","A36","g","hist","r","712082174","216458311","495623863"),
("2031","US","A44","g","hist","r","71650636","29870963","41779673"),
("2031","US","A50","g","hist","r","25789875","2821991","22967884"),
("2031","US","A59","g","hist","r","17211875","8120296","9091579"),
("2031","US","A60","g","hist","r","11825946","71623","11754323"),
("2031","US","A61","g","hist","r","43685523","4341980","39343543"),
("2031","US","A80","g","hist","r","211573546","2339714","209233832"),
("2031","US","A81","g","hist","r","68213351","605885","67607466"),
("2031","US","A87","g","hist","r","23676094","6438036","17238058"),
("2031","US","A89","g","hist","r","307207631","53165102","254042529"),
("2031","US","A90","g","hist","r","31825964","24540021","7285943"),
("2031","US","A91","g","hist","r","228212456","797874","227414582"),
("2031","US","A92","g","hist","r","288779740","21091589","267688151"),
("2031","US","A93","g","hist","r","31253721","13316","31240405"),
("2031","US","A94","g","hist","r","36371369","4890356","31481013"),
("2031","US","B01","g","hist","s","7493852","7493852","0"),
("2031","US","B21","g","hist","s","200755090","200755090","0"),
("2031","US","B22","g","hist","s","14895201","14895201","0"),
("2031","US","B30","g","hist","s","137586469","137586469","0"),
("2031","US","B42","g","hist","s","128676894","128676894","0"),
("2031","US","B46","g","hist","s","110512181","110512181","0"),
("2031","US","B50","g","hist","s","86894338","86894338","0"),
("2031","US","B54","g","hist","s","1939568","1939568","0"),
("2031","US","B59","g","hist","s","51906995","51906995","0"),
("2031","US","B62","g","hist","s","12594054","12594054","0"),
("2031","US","B66","g","hist","s","10089563","10089563","0"),
("2031","US","B79","g","hist","s","121941920","121941920","0"),
("2031","US","B80","g","hist","s","10109497","10109497","0"),
("2031","US","B89","g","hist","s","832405","832405","0"),
("2031","US","B92","g","hist","s","1730483","1730483","0"),
("2031","US","B93","g","hist","s","154039","154039","0"),
("2031","US","B94","g","hist","s","81564987","81564987","0"),
("2031","US","D49","g","hist","s","6204375809","1708761024","4495614785"),
("2031","US","D64","g","hist","s","87289108","16308841","70980267"),
("2031","US","E00","g","hist","s","12183554186","5051106593","7132447593"),
("2031","US","I89","g","hist","s","210153639","55559259","154594380"),
("2031","US","M00","g","hist","r","-2396257210","-2396257210","0"),
("2031","US","O99","g","hist","r","560596068","314951002","245645066"),
("2031","US","Q79","g","hist","","2034663333","1841532855","193130478"),
("2031","US","R00","g","hist","r","9603859467","4412235162","5191624305"),
("2031","US","R01","g","hist","r","111781280","111665273","116007"),
("2031","US","R02","g","hist","r","50912001","30833256","20078745"),
("2031","US","R03","g","hist","r","26911847","26911847","0"),
("2031","US","R95","g","hist","r","409645518","348054875","61590643"),
("2031","US","R98","g","hist","r","25122037","25122037","0"),
("2031","US","R99","g","hist","r","375339079","198658741","176680338"),
("2031","US","S01","g","hist","s","55762634","5390874","50371760"),
("2031","US","S03","g","hist","s","10609384","2603935","8005449"),
("2031","US","S04","g","hist","s","225998859","128674927","97323932"),
("2031","US","S05","g","hist","s","183302298","194331289.42595","0"),
("2031","US","S11","g","hist","s","871364117","674274376","197089741"),
("2031","US","S12","g","hist","s","2882016647","36937516","2845079131"),
("2031","US","S14","g","hist","s","19722271","19722271","0"),
("2031","US","S16","g","hist","s","766338394","646850612","119487782"),
("2031","US","S21","g","hist","s","200431032","193541934","6889098"),
("2031","US","S22","g","hist","s","10330146","10250385","79761"),
("2031","US","S23","g","hist","s","178584307","101481519","77102788"),
("2031","US","S24","g","hist","s","201376996","0","201376996"),
("2031","US","S25","g","hist","s","147872137","63488244","84383893"),
("2031","US","S29","g","hist","s","147245957","22031126","125214831"),
("2031","US","S31","g","hist","s","50147315","8535721","41611594"),
("2031","US","S32","g","hist","s","416223193","169901983","246321210"),
("2031","US","S36","g","hist","s","758747340","263297575","495449765"),
("2031","US","S44","g","hist","s","485336158","278312486","207023672"),
("2031","US","S50","g","hist","s","243561421","34040342","209521079"),
("2031","US","S52","g","hist","s","44045527","1108949","42936578"),
("2031","US","S53","g","hist","s","20096258","20096258","0"),
("2031","US","S59","g","hist","s","108663072","60325061","48338011"),
("2031","US","S60","g","hist","s","5355742","36460","5319282"),
("2031","US","S61","g","hist","s","158323759","15615976","142707783"),
("2031","US","S62","g","hist","s","396977629","45246722","351730907"),
("2031","US","S66","g","hist","s","47130108","26369105","20761003"),
("2031","US","S72","g","hist","s","0","0","0"),
("2031","US","S73","g","hist","s","0","0","0"),
("2031","US","S74","g","hist","s","1788316455","1770521720","17794735"),
("2031","US","S77","g","hist","s","5345448","5345448","0"),
("2031","US","S80","g","hist","s","204159089","3662916","200496173"),
("2031","US","S81","g","hist","s","82010393","2094064","79916329"),
("2031","US","S85","g","hist","s","3262303","3262303","0"),
("2031","US","S87","g","hist","s","16645942","6230513","10415429"),
("2031","US","S89","g","hist","s","651803701","184536634","467267067"),
("2031","US","S90","g","hist","s","25839494","19808483","6031011"),
("2031","US","S91","g","hist","s","223131643","1097839","222033804"),
("2031","US","S92","g","hist","s","279455747","22750358","256705389"),
("2031","US","S93","g","hist","s","29253890","34224","29219666"),
("2031","US","S94","g","hist","s","214692636","26770632","187922004"),
("2031","US","S95","g","hist","s","855505981","694387495","161118486"),
("2031","US","T00","g","hist","r","12000116677","6808492372","5191624305"),
("2031","US","T01","g","hist","r","1934817421","47333597","1887483824"),
("2031","US","T09","g","hist","r","1463770450","944283175","519487275"),
("2031","US","T10","g","hist","r","21512405","18057688","3454717"),
("2031","US","T13","g","hist","r","128093854","120300965","7792889"),
("2031","US","T15","g","hist","r","74625893","26435874","48190019"),
("2031","US","T16","g","hist","r","33912057","33360955","551102"),
("2031","US","T19","g","hist","r","300154542","216581352","83573190"),
("2031","US","T24","g","hist","r","79037469","71732517","7304952"),
("2031","US","T40","g","hist","r","1377240657","1222406222","154834435"),
("2031","US","T41","g","hist","r","361627481","316241715","45385766"),
("2031","US","U01","g","hist","r","61613457","24431","61589026"),
("2031","US","U11","g","hist","r","14067193","3905668","10161525"),
("2031","US","U20","g","hist","r","54540168","40081535","14458633")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","M00","g","hist","r","-2396257208","-2396257208","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","T00","g","hist","r","11998698040","6808492370","5190205670")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","R00","g","hist","r","9602440832","4412235162","5190205670")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","E00","g","hist","s","12375316624.426","5118794591.426","7256522033")
Done