return to Menu
0 secs
US
B74 120783287.4 2030 1305330968 2029 1207832874
B74
B78 0 2030 0 2029 0
0 2030 0 2029 0
A01 351226.9 2030 3795785 2029 3512269
A18 22120950.2 2030 239065865 2029 221209502
A36 18165228.4 2030 196315529 2029 181652284
A44 2506777.7 2030 27091285 2029 25067777
A50 236822.1 2030 2559387 2029 2368221
A59 681457 2030 7364653 2029 6814570
A60 6010.6 2030 64958 2029 60106
A61 364379.9 2030 3937933 2029 3643799
A80 195616.4 2030 2114658 2029 1956164
A81 50846 2030 549504 2029 508460
A87 540281.4 2030 5838938 2029 5402814
A89 4461626.9 2030 48217754 2029 44616269
A90 2059403.9 2030 22256421 2029 20594039
A91 66957.7 2030 723627 2029 669577
A92 1770010.7 2030 19128886 2029 17700107
A93 940.55203878792 2030 11150 2029 10563
A94 410399.7 2030 4435279 2029 4103997
B01 486584.82552131 2030 6161780 2029 5872324
B21 16847410.7 2030 182073588 2029 168474107
B22 1153458.8112158 2030 12673342 2029 11917296
B30 8171873.7304445 2030 111378655 2029 106802844
B42 10798592.8 2030 116702713 2029 107985928
B46 9274206.2 2030 100228343 2029 92742062
B50 6259227.1675088 2030 73135475 2029 69190546
B54 162769 2030 1759079 2029 1627690
B59 3831868.4420484 2030 43868339 2029 41420564
B62 1056895.7 2030 11422100 2029 10568957
B66 846718.3 2030 9150667 2029 8467183
B79 10233392.4 2030 110594474 2029 102333924
B80 848391.2 2030 9168746 2029 8483912
B89 57590.643028065 2030 693384 2029 657827
B92 138900.6 2030 1484537 2029 1389006
B93 12927 2030 139705 2029 129270
B94 6844951.4 2030 73974864 2029 68449514
D49 138034181.5 2030 1483111042 2029 1380341815
D64 1163656.4227361 2030 13692649 2029 12962715
E00 157267535.05141 2030 2848515610 2029 2785940148
I89 4456869.1 2030 47589506 2029 44568691
M00 -199530968.8 2030 -2149367992 2029 -1995309688
O99 26430756.4 2030 285642881 2029 264307564
Q79 166202079.9 2030 1796181628 2029 1662020799
R00 369508635.1 2030 3990254831 2029 3695086351
R01 8956270.3 2030 95611281 2029 89562703
R02 1593112.4470627 2030 25490954 2029 24735451
R03 2235031.5 2030 24173562 2029 22350315
R95 28732067.6 2030 310898810 2029 287320676
R98 2108246.8 2030 22784277 2029 21082468
R99 16671484.6 2030 180172327 2029 166714846
S01 449490.8 2030 4860121 2029 4494908
S03 173130.10588262 2030 2150391 2029 2045882
S04 10798427.8 2030 116700931 2029 107984278
S05 -7153623.55 2030 -6515508 2029 143072471
2031x50640x0.060168320562743
S11 56585251.8 2030 611529014 2029 565852518
S12 3084134.4 2030 33343608 2029 30841344
S14 1655097.3 2030 17886993 2029 16550973
S16 54283843.6 2030 586657170 2029 542838436
S21 16242081.1 2030 175531666 2029 162420811
S22 844733.6 2030 9140968 2029 8447336
S23 8516351.1 2030 92038042 2029 85163511
S24 0 2030 0 2029 0
S25 5327947.2 2030 57580271 2029 53279472
S29 1848856.9 2030 19980993 2029 18488569
S31 712683.9 2030 7705092 2029 7126839
S32 14258211.3 2030 154091553 2029 142582113
S36 22095989.6 2030 238796111 2029 220959896
S44 23356044.2 2030 252413802 2029 233560442
S50 2856672.9 2030 30872679 2029 28566729
S52 93063.3 2030 1005755 2029 930633
S53 1686482.4 2030 18226178 2029 16864824
S59 5062492.2 2030 54711443 2029 50624922
S60 3059.7 2030 33066 2029 30597
S61 1310496.1 2030 14162813 2029 13104961
S62 3797114.7 2030 41036235 2029 37971147
S66 2212901 2030 23915298 2029 22129010
S72 0 2030 0 2029 0
S73 0 2030 0 2029 0
S77 446324.3 2030 4825360 2029 4463243
S80 307392.7 2030 3322058 2029 3073927
S81 172832.1 2030 1870101 2029 1728321
S85 273773.2 2030 2958726 2029 2737732
S87 522866 2030 5650726 2029 5228660
S89 15486354.4 2030 167364367 2029 154863544
S90 1662332.2 2030 17965179 2029 16623322
S91 91667.1 2030 991040 2029 916671
S92 1909215 2030 20633297 2029 19092150
S93 2757.3 2030 29564 2029 27573
S94 1847790.4008129 2030 22286361 2029 21146935
S95 57321962.1 2030 620259219 2029 573219621
T00 569039603.9 2030 6139622823 2029 5690396039
T01 3972245.7 2030 42928914 2029 39722457
T09 79244448.8 2030 856411808 2029 792444488
T10 1515405.1 2030 16377309 2029 15154051
T13 10095683.1 2030 109106218 2029 100956831
T15 2218504.3 2030 23975849 2029 22185043
T16 2753610.7 2030 29795255 2029 27536107
T19 18175554 2030 196427120 2029 181755540
T24 6019808.4 2030 65057364 2029 60198084
T40 102584595.3 2030 1108653775 2029 1025845953
T41 26539073.4 2030 286813412 2029 265390734
U01 1876.8063168962 2030 20764 2029 19539
U11 327764.5 2030 3542221 2029 3277645
U20 2910472.6083414 2030 33797928 2029 31956014
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","B74","g","hist","s","1426114255","1426114255","0"),
("2031","US","B78","g","hist","s","0","0","0"),
("2031","US","","g","hist","","0","0","0"),
("2031","US","A01","g","hist","r","85248857","4147012","81101845"),
("2031","US","A18","g","hist","r","331182496","261186815","69995681"),
("2031","US","A36","g","hist","r","650498948","214480757","436018191"),
("2031","US","A44","g","hist","r","66644725","29598063","37046662"),
("2031","US","A50","g","hist","r","22312535","2796209","19516326"),
("2031","US","A59","g","hist","r","15884263","8046110","7838153"),
("2031","US","A60","g","hist","r","10451628","70969","10380659"),
("2031","US","A61","g","hist","r","39129921","4302313","34827608"),
("2031","US","A80","g","hist","r","179469930","2310274","177159656"),
("2031","US","A81","g","hist","r","57992547","600350","57392197"),
("2031","US","A87","g","hist","r","21252720","6379219","14873501"),
("2031","US","A89","g","hist","r","271722125","52679381","219042744"),
("2031","US","A90","g","hist","r","30615668","24315825","6299843"),
("2031","US","A91","g","hist","r","191713855","790585","190923270"),
("2031","US","A92","g","hist","r","250556954","20898897","229658057"),
("2031","US","A93","g","hist","r","27918822","12091","27906731"),
("2031","US","A94","g","hist","r","33065625","4845679","28219946"),
("2031","US","B01","g","hist","s","6648365","6648365","0"),
("2031","US","B21","g","hist","s","198920999","198920999","0"),
("2031","US","B22","g","hist","s","13826801","13826801","0"),
("2031","US","B30","g","hist","s","119550529","119550529","0"),
("2031","US","B42","g","hist","s","127501306","127501306","0"),
("2031","US","B46","g","hist","s","109502549","109502549","0"),
("2031","US","B50","g","hist","s","79394702","79394702","0"),
("2031","US","B54","g","hist","s","1921848","1921848","0"),
("2031","US","B59","g","hist","s","47700207","47700207","0"),
("2031","US","B62","g","hist","s","12478996","12478996","0"),
("2031","US","B66","g","hist","s","9997385","9997385","0"),
("2031","US","B79","g","hist","s","120827866","120827866","0"),
("2031","US","B80","g","hist","s","10017137","10017137","0"),
("2031","US","B89","g","hist","s","750975","750975","0"),
("2031","US","B92","g","hist","s","1623438","1623438","0"),
("2031","US","B93","g","hist","s","152632","152632","0"),
("2031","US","B94","g","hist","s","80819815","80819815","0"),
("2031","US","D49","g","hist","s","5275593003","1621145224","3654447779"),
("2031","US","D64","g","hist","s","73461764","14856305","58605459"),
("2031","US","E00","g","hist","s","9174906632","3005783145","6169123487"),
("2031","US","I89","g","hist","s","178222087","52046375","126175712"),
("2031","US","M00","g","hist","r","-2348898961","-2348898961","0"),
("2031","US","O99","g","hist","r","522500946","312073637","210427309"),
("2031","US","Q79","g","hist","","2132549546","1962383708","170165838"),
("2031","US","R00","g","hist","r","8837637521","4359763466","4477874055"),
("2031","US","R01","g","hist","r","104662667","104567551","95116"),
("2031","US","R02","g","hist","r","42941042","27084066","15856976"),
("2031","US","R03","g","hist","r","26408594","26408594","0"),
("2031","US","R95","g","hist","r","390138966","339630878","50508088"),
("2031","US","R98","g","hist","r","24892524","24892524","0"),
("2031","US","R99","g","hist","r","355935263","196843812","159091451"),
("2031","US","S01","g","hist","s","45407728","5309612","40098116"),
("2031","US","S03","g","hist","s","9077927","2323521","6754406"),
("2031","US","S04","g","hist","s","209714512","127499359","82215153"),
("2031","US","S05","g","hist","s","-13669132","-14491580.71599","0"),
("2031","US","S11","g","hist","s","834202477","668114266","166088211"),
("2031","US","S12","g","hist","s","2482317815","36427742","2445890073"),
("2031","US","S14","g","hist","s","19542090","19542090","0"),
("2031","US","S16","g","hist","s","740090421","640941014","99149407"),
("2031","US","S21","g","hist","s","197423234","191773747","5649487"),
("2031","US","S22","g","hist","s","10050501","9985702","64799"),
("2031","US","S23","g","hist","s","166328476","100554393","65774083"),
("2031","US","S24","g","hist","s","171129378","0","171129378"),
("2031","US","S25","g","hist","s","134302675","62908218","71394457"),
("2031","US","S29","g","hist","s","129029347","21829850","107199497"),
("2031","US","S31","g","hist","s","43655929","8417776","35238153"),
("2031","US","S32","g","hist","s","378052030","168349764","209702266"),
("2031","US","S36","g","hist","s","686984599","260892101","426092498"),
("2031","US","S44","g","hist","s","446727124","275769846","170957278"),
("2031","US","S50","g","hist","s","214363570","33729352","180634218"),
("2031","US","S52","g","hist","s","37594635","1098818","36495817"),
("2031","US","S53","g","hist","s","19912660","19912660","0"),
("2031","US","S59","g","hist","s","101483719","59773935","41709784"),
("2031","US","S60","g","hist","s","4432889","36126","4396763"),
("2031","US","S61","g","hist","s","137263703","15473309","121790394"),
("2031","US","S62","g","hist","s","341517514","44833350","296684164"),
("2031","US","S66","g","hist","s","43633778","26128199","17505579"),
("2031","US","S72","g","hist","s","0","0","0"),
("2031","US","S73","g","hist","s","0","0","0"),
("2031","US","S77","g","hist","s","5271684","5271684","0"),
("2031","US","S80","g","hist","s","172598863","3629451","168969412"),
("2031","US","S81","g","hist","s","68994417","2042933","66951484"),
("2031","US","S85","g","hist","s","3232499","3232499","0"),
("2031","US","S87","g","hist","s","14810478","6173592","8636886"),
("2031","US","S89","g","hist","s","583483062","182850721","400632341"),
("2031","US","S90","g","hist","s","24826921","19627511","5199410"),
("2031","US","S91","g","hist","s","186247196","1082707","185164489"),
("2031","US","S92","g","hist","s","243159132","22542512","220616620"),
("2031","US","S93","g","hist","s","25979929","32321","25947608"),
("2031","US","S94","g","hist","s","182349694","24134151","158215543"),
("2031","US","S95","g","hist","s","809708189","677581181","132127008"),
("2031","US","T00","g","hist","r","11186536482","6708662427","4477874055"),
("2031","US","T01","g","hist","r","1642760346","46901160","1595859186"),
("2031","US","T09","g","hist","r","1404186632","935656257","468530375"),
("2031","US","T10","g","hist","r","20974617","17892714","3081903"),
("2031","US","T13","g","hist","r","126210372","119201901","7008471"),
("2031","US","T15","g","hist","r","67020023","26194353","40825670"),
("2031","US","T16","g","hist","r","32986693","32548866","437827"),
("2031","US","T19","g","hist","r","288190481","214602674","73587807"),
("2031","US","T24","g","hist","r","77303355","71077172","6226183"),
("2031","US","T40","g","hist","r","1344220536","1211238370","132982166"),
("2031","US","T41","g","hist","r","354269324","313352485","40916839"),
("2031","US","U01","g","hist","r","55066647","22641","55044006"),
("2031","US","U11","g","hist","r","12337298","3869986","8467312"),
("2031","US","U20","g","hist","r","47942790","36708401","11234389")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","M00","g","hist","r","-2345273424","-2345273424","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","T00","g","hist","r","11181745193","6703871137","4477874056")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","R00","g","hist","r","8836471769","4358597713","4477874056")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","E00","g","hist","s","9273651428.284","3104527942.284","6169123486")
Done