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 375680.1 2030 4100954 2029 3756801
A18 17698671.8 2030 191801307 2029 176986718
A36 19595794.8 2030 213909265 2029 195957948
A44 2218606.9 2030 24218938 2029 22186069
A50 99513.768890504 2030 1263412 2029 1204331
A59 677421.9 2030 7394792 2029 6774219
A60 4522.2 2030 48480 2029 45222
A61 381324.4 2030 4162568 2029 3813244
A80 189540.6 2030 2069040 2029 1895406
A81 7226.7863980082 2030 119207 2029 115909
A87 239611.37758157 2030 2995277 2029 2851329
A89 3676621.4 2030 39887614 2029 36766214
A90 1493496.5 2030 15982471 2029 14934965
A91 56216.4 2030 609906 2029 562164
A92 929440.43413821 2030 10865937 2029 10280365
A93 1761 2030 19223 2029 17610
A94 502866.9 2030 5489561 2029 5028669
B01 588742.78982005 2030 6381975 2029 5992944
B21 16847410.7 2030 183907679 2029 168474107
B22 1204386.6 2030 12890293 2029 12043866
B30 10836667.588508 2030 120253296 2029 113193243
B42 10798592.8 2030 117878301 2029 107985928
B46 9274206.2 2030 101237975 2029 92742062
B50 6996451.3 2030 74869904 2029 69964513
B54 162769 2030 1776799 2029 1627690
B59 4186078.1 2030 44798383 2029 41860781
B62 1056895.7 2030 11537158 2029 10568957
B66 842389.9 2030 9195595 2029 8423899
B79 10233392.4 2030 111708528 2029 102333924
B80 848391.2 2030 9261106 2029 8483912
B89 66754.3 2030 714243 2029 667543
B92 140124.1 2030 1502578 2029 1401241
B93 12927 2030 141112 2029 129270
B94 6844951.4 2030 74720036 2029 68449514
D49 164818540.1 2030 1799245801 2029 1648185401
D64 1924223.3 2030 21004976 2029 19242233
E00 406041344.6 2030 4414674641 2029 4060413446
I89 6065294.4 2030 66209238 2029 60652944
M00 -200318341.2 2030 -2180522210 2029 -2003183412
O99 4943868.6646199 2030 79934117 2029 77619536
Q79 153615483.3 2030 1676947323 2029 1536154833
R00 359222470.9 2030 4791219485 2029 3592224709
R01 8743348.8 2030 93566912 2029 87433488
R02 79984995 2030 858021331 2029 799849950
R03 1923493.7 2030 20856443 2029 19234937
R95 98122527.1 2030 1064524736 2029 981225271
R98 2275995.4 2030 24844948 2029 22759954
R99 3080468.7789746 2030 49844452 2029 48403651
S01 518954.6 2030 5664950 2029 5189546
S03 369987.6 2030 4038980 2029 3699876
S04 11036215.3 2030 120472208 2029 110362153
S05 6853202.9501711 2030 90585002 2029 86645608
2031x50640x0.060168320562743
S11 48553291.7 2030 526777254 2029 485532917
S12 3740882.2 2030 40835771 2029 37408822
S14 993658.11995984 2030 11446974 2029 10814808
S16 53853225.3 2030 587866102 2029 538532253
S21 9595091.2941459 2030 111313749 2029 105237468
S22 1057062.4 2030 11538978 2029 10570624
S23 9499004.3 2030 103691893 2029 94990043
S24 0 2030 0 2029 0
S25 3349059.8272389 2030 37579443 2029 35412554
S29 1904757.1 2030 20792481 2029 19047571
S31 901458.9 2030 9840801 2029 9014589
S32 5811397.1233184 2030 74453208 2029 71027313
S36 23616674.8 2030 257801513 2029 236166748
S44 24580170.7 2030 268319110 2029 245801707
S50 1358963.2819703 2030 16666505 2029 15838485
S52 86314.5 2030 942255 2029 863145
S53 1789224.4 2030 19531317 2029 17892244
S59 5548810.7 2030 60571262 2029 55488107
S60 2938.5 2030 32077 2029 29385
S61 1455133.1 2030 15884350 2029 14551331
S62 3777706 2030 41237740 2029 37777060
S66 2339515.6 2030 25538340 2029 23395156
S67 2466902 2030 26929998 2029 24669020
S72 0 2030 0 2029 0
S73 0 2030 0 2029 0
S74 137035207.4 2030 1495948310 2029 1370352074
S77 444094.3 2030 4847769 2029 4440943
S79 13908418.8 2030 151831605 2029 139084188
S80 292413.6 2030 3192010 2029 2924136
S81 193041.6 2030 2107258 2029 1930416
S85 118481.80965752 2030 1492201 2029 1421424
S87 544992.2 2030 5949178 2029 5449922
S89 12179060.7 2030 131607175 2029 121790607
S90 1394317.9 2030 15127206 2029 13943179
S91 120677.2 2030 1317375 2029 1206772
S92 1282419.3650349 2030 13867916 2029 13019304
S93 1636.855350195 2030 20333 2029 19345
S94 3266060.2 2030 35652575 2029 32660602
S95 60418666.2 2030 659535008 2029 604186662
T00 559540812.1 2030 6971741695 2029 5595408121
T01 -2161699.85 2030 35628679 2029 43233997
T09 -40433075.4 2030 709949854 2029 808661508
T10 -737013.2 2030 10252802 2029 14740264
T13 -5171592.55 2030 84126980 2029 103431851
T15 -1319120.8 2030 23184769 2029 26382416
T16 -1357543.25 2030 16767971 2029 27150865
T19 -5596534.85 2030 61226636 2029 111930697
T24 3084371.1 2030 246798387 2029 30843711
T40 60599251.6 2030 1089767635 2029 605992516
T41 16571088.8 2030 736080686 2029 165710888
U01 3996.6 2030 43629 2029 39966
U11 98890.281927359 2030 1398375 2029 1344829
U20 11428250.2 2030 123986927 2029 114282502
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","93673750","4476634","89197116"),
("2031","US","A18","g","hist","r","273119442","209499979","63619463"),
("2031","US","A36","g","hist","r","377334120","233505060","143829060"),
("2031","US","A44","g","hist","r","55526816","26437545","29089271"),
("2031","US","A50","g","hist","r","14249576","1362926","12886650"),
("2031","US","A59","g","hist","r","10819314","8072214","2747100"),
("2031","US","A60","g","hist","r","6040260","53002","5987258"),
("2031","US","A61","g","hist","r","33703760","4543892","29159868"),
("2031","US","A80","g","hist","r","149255273","2258581","146996692"),
("2031","US","A81","g","hist","r","38147999","126434","38021565"),
("2031","US","A87","g","hist","r","15709477","3234888","12474589"),
("2031","US","A89","g","hist","r","266973338","43564235","223409103"),
("2031","US","A90","g","hist","r","25774827","17475968","8298859"),
("2031","US","A91","g","hist","r","194780833","666122","194114711"),
("2031","US","A92","g","hist","r","169335847","11795377","157540470"),
("2031","US","A93","g","hist","r","8888763","20984","8867779"),
("2031","US","A94","g","hist","r","33294821","5992428","27302393"),
("2031","US","B01","g","hist","s","6970718","6970718","0"),
("2031","US","B21","g","hist","s","200755090","200755090","0"),
("2031","US","B22","g","hist","s","14094680","14094680","0"),
("2031","US","B30","g","hist","s","131089964","131089964","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","81866355","81866355","0"),
("2031","US","B54","g","hist","s","1939568","1939568","0"),
("2031","US","B59","g","hist","s","48984461","48984461","0"),
("2031","US","B62","g","hist","s","12594054","12594054","0"),
("2031","US","B66","g","hist","s","10037985","10037985","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","780997","780997","0"),
("2031","US","B92","g","hist","s","1642702","1642702","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","6612117418","1964064341","4648053077"),
("2031","US","D64","g","hist","s","130018903","22929199","107089704"),
("2031","US","E00","g","hist","s","11180391293","4820715986","6359675307"),
("2031","US","I89","g","hist","s","244451483","72274532","172176951"),
("2031","US","M00","g","hist","r","-2380840551","-2380840551","0"),
("2031","US","O99","g","hist","r","203286666","84877986","118408680"),
("2031","US","Q79","g","hist","","1993722239","1830562806","163159433"),
("2031","US","R00","g","hist","r","8600374807","5150441956","3449932851"),
("2031","US","R01","g","hist","r","102674888","102310261","364627"),
("2031","US","R02","g","hist","r","1143429076","938006326","205422750"),
("2031","US","R03","g","hist","r","22779937","22779937","0"),
("2031","US","R95","g","hist","r","1383752468","1162647263","221105205"),
("2031","US","R98","g","hist","r","27120943","27120943","0"),
("2031","US","R99","g","hist","r","71051203","52924921","18126282"),
("2031","US","S01","g","hist","s","103904626","6183905","97720721"),
("2031","US","S03","g","hist","s","6814994","4408968","2406026"),
("2031","US","S04","g","hist","s","209273460","131508423","77765037"),
("2031","US","S05","g","hist","s","97615391","103300898.1535","177186"),
("2031","US","S11","g","hist","s","724958738","575330546","149628192"),
("2031","US","S12","g","hist","s","2249583936","44576653","2205007283"),
("2031","US","S14","g","hist","s","12440632","12440632","0"),
("2031","US","S16","g","hist","s","764670807","641719327","122951480"),
("2031","US","S21","g","hist","s","131685232","120908840","10776392"),
("2031","US","S22","g","hist","s","12743532","12596040","147492"),
("2031","US","S23","g","hist","s","225092931","113190897","111902034"),
("2031","US","S24","g","hist","s","180170102","0","180170102"),
("2031","US","S25","g","hist","s","123025451","40928503","82096948"),
("2031","US","S29","g","hist","s","113344903","22697238","90647665"),
("2031","US","S31","g","hist","s","43687779","10742260","32945519"),
("2031","US","S32","g","hist","s","289823147","80264605","209558542"),
("2031","US","S36","g","hist","s","467946961","281418188","186528773"),
("2031","US","S44","g","hist","s","578512934","292899281","285613653"),
("2031","US","S50","g","hist","s","170591534","18025468","152566066"),
("2031","US","S52","g","hist","s","44074685","1028570","43046115"),
("2031","US","S53","g","hist","s","21320541","21320541","0"),
("2031","US","S59","g","hist","s","109413706","66120073","43293633"),
("2031","US","S60","g","hist","s","5017646","35016","4982630"),
("2031","US","S61","g","hist","s","173231279","17339483","155891796"),
("2031","US","S62","g","hist","s","382844028","45015446","337828582"),
("2031","US","S66","g","hist","s","50548002","27877856","22670146"),
("2031","US","S67","g","hist","s","60443184","29396900","31046284"),
("2031","US","S72","g","hist","s","0","0","0"),
("2031","US","S73","g","hist","s","0","0","0"),
("2031","US","S74","g","hist","s","1647783257","1632983517","14799740"),
("2031","US","S77","g","hist","s","5291863","5291863","0"),
("2031","US","S79","g","hist","s","285031317","165740024","119291293"),
("2031","US","S80","g","hist","s","224717550","3484424","221233126"),
("2031","US","S81","g","hist","s","79814598","2300300","77514298"),
("2031","US","S85","g","hist","s","1610683","1610683","0"),
("2031","US","S87","g","hist","s","21143245","6494170","14649075"),
("2031","US","S89","g","hist","s","561719480","143786236","417933244"),
("2031","US","S90","g","hist","s","18285516","16521524","1763992"),
("2031","US","S91","g","hist","s","278451851","1438052","277013799"),
("2031","US","S92","g","hist","s","185333000","15150335","170182665"),
("2031","US","S93","g","hist","s","8021137","21970","7999167"),
("2031","US","S94","g","hist","s","266668297","38918635","227749662"),
("2031","US","S95","g","hist","s","894437273","719953674","174483599"),
("2031","US","T00","g","hist","r","10981215358","7531282507","3449932851"),
("2031","US","T01","g","hist","r","1332586370","33466979","1299119391"),
("2031","US","T09","g","hist","r","821609555","669516779","152092776"),
("2031","US","T10","g","hist","r","10269521","9515789","753732"),
("2031","US","T13","g","hist","r","82650419","78955387","3695032"),
("2031","US","T15","g","hist","r","48560373","21865648","26694725"),
("2031","US","T16","g","hist","r","15643839","15410428","233411"),
("2031","US","T19","g","hist","r","75525894","55630101","19895793"),
("2031","US","T24","g","hist","r","273443103","249882758","23560345"),
("2031","US","T40","g","hist","r","1298018610","1150366887","147651723"),
("2031","US","T41","g","hist","r","839164971","752651775","86513196"),
("2031","US","U01","g","hist","r","26824038","47626","26776412"),
("2031","US","U11","g","hist","r","10502346","1497265","9005081"),
("2031","US","U20","g","hist","r","252653442","135415177","117238265")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","M00","g","hist","r","-2380347342","-2380347342","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","T00","g","hist","r","10804770752","7355676584","3449094168")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","R00","g","hist","r","8424423410","4975329242","3449094168")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2031","US","E00","g","hist","s","11181674268.153","4821998959.1535","6359675309")
Done