return to Menu
0 secs
US
B74 109006916.85 2032 1554007412 2031 1439263289
B74
B78 0 2032 0 2031 0
0 2032 0 2031 0
A01 338080.3 2032 4819687 2031 4463813
A18 18566089.4 2032 264678997 2031 245135745
A36 16922242.65 2032 241244228 2031 223431341
A44 2203427.15 2032 31412159 2031 29092762
A50 113815.7 2032 1622936 2031 1503130
A59 640092.9 2032 9125189 2031 8451407
A60 4043.2 2032 57643 2031 53387
A61 339729.5 2032 4843206 2031 4485596
A80 181526.95 2032 2587860 2031 2396779
A81 11567.2 2032 163843 2031 151667
A87 391236.6 2032 5577495 2031 5165667
A89 3114212.1 2032 44396656 2031 41118538
A90 1666761.7 2032 23761419 2031 22006933
A91 57075.05 2032 813664 2031 753585
A92 1690388.2 2032 24098248 2031 22318892
A93 937.65 2032 13359 2031 12372
A94 436356.85 2032 6220727 2031 5761404
B01 500269.05 2032 7133820 2031 6607221
B21 15204788 2032 216760130 2031 200755090
B22 1022693.05 2032 14570753 2031 13494234
B30 9623140.9 2032 137207650 2031 127078028
B42 9745729.85 2032 138935557 2031 128676894
B46 8369971.2 2032 119322677 2031 110512181
B50 5911980.15 2032 84251631 2031 78028494
B54 146899.45 2032 2094199 2031 1939568
B59 3543807.8 2032 50497988 2031 46767664
B62 953848.45 2032 13598105 2031 12594054
B66 760584.25 2032 10842928 2031 10042313
B79 9235635.9 2032 131663642 2031 121941920
B80 765672.45 2032 10915468 2031 10109497
B89 56144.05 2032 800293 2031 741194
B92 119569.85 2032 1704097 2031 1578234
B93 11666.95 2032 166320 2031 154039
B94 6177567.85 2032 88067690 2031 81564987
D49 135737006.05 2032 1935088785 2031 1792207726
D64 1758143.15 2032 25064166 2031 23213489
E00 148129959.35 2032 3255927999 2031 3100001726
I89 4546990.7 2032 64822526 2031 60036220
M00 -236921253.4 2032 -2558099327 2031 -2369212534
O99 6184679.55 2032 87601303 2031 81091114
Q79 149997377.2 2032 2138369221 2031 1980477245
R00 275268403.3 2032 3923178315 2031 3633422101
R01 6256728.5 2032 89215590 2031 82629560
R02 43205834.7 2032 615943862 2031 570464036
R03 2138468.05 2032 30486099 2031 28235080
R95 58276678.4 2032 830794782 2031 769450910
R98 1599852.25 2032 22807546 2031 21123491
R99 4623785.85 2032 65525953 2031 60658810
S01 401175.5 2032 5719174 2031 5296884
S03 1954493.9 2032 27863444 2031 25806082
S04 9716042.35 2032 138512329 2031 128284916
S05 -4224739.5 2032 0 2031 84494790
2033xxNAN
S11 48243996.3 2032 687768566 2031 636985412
S12 2964704.9 2032 42264968 2031 39144226
S14 1221656.3 2032 17416007 2031 16130053
S16 48541784.25 2032 692013806 2031 640917191
S21 8770275.55 2032 124961084 2031 115729215
S22 512316.95 2032 7304484 2031 6765203
S23 8205134.8 2032 116972764 2031 108335780
S24 0 2032 0 2031 0
S25 4889348.85 2032 69702772 2031 64556089
S29 1633462.3 2032 23286715 2031 21567281
S31 809385.75 2032 11538631 2031 10686646
S32 7890154.7 2032 112397677 2031 104092251
S36 20477975.8 2032 291934925 2031 270379161
S44 21990024.3 2032 313490755 2031 290343361
S50 2324495.15 2032 33138103 2031 30691266
S52 83761.5 2032 1194100 2031 1105930
S53 1436047.55 2032 20472351 2031 18960722
S59 4932028.55 2032 70311221 2031 65119612
S60 2895.6 2032 41269 2031 38221
S61 1260427.7 2032 17968716 2031 16641950
S62 3397555.3 2032 48435695 2031 44859321
S66 1872982 2032 26701308 2031 24729748
S72 0 2032 0 2031 0
S73 0 2032 0 2031 0
S77 397407.8 2032 5665459 2031 5247135
S80 162316.05 2032 2313051 2031 2142192
S81 214499.55 2032 3057922 2031 2832133
S85 270277.85 2032 3853099 2031 3568596
S87 539919.2 2032 7697110 2031 7128774
S89 12677145.8 2032 180725936 2031 167381572
S90 1422041.7 2032 20272683 2031 18775797
S91 95035.15 2032 1354827 2031 1254790
S92 1751533.05 2032 24969939 2031 23126220
S93 3033.35 2032 43242 2031 40049
S94 3185091.6 2032 45406800 2031 42054072
S95 48515251.7 2032 691638533 2031 640569847
T00 454710856.65 2032 6481277642 2031 6002634635
T01 3490015 2032 49753813 2031 46080113
T09 69539451.85 2032 991357501 2031 918158078
T10 1194514.8 2032 17029052 2031 15771668
T13 7634040.4 2032 108831134 2031 100795302
T15 2015044.05 2032 28726563 2031 26605464
T16 1686547.35 2032 24044019 2031 22268706
T19 5532222.4 2032 78571103 2031 72747711
T24 4942064.35 2032 70454296 2031 65252123
T40 44482886.45 2032 634341208 2031 587517117
T41 16259630 2032 231782423 2031 214667023
U01 2865.2 2032 40846 2031 37830
U11 159083.2 2032 2268220 2031 2100764
U20 7643106.25 2032 108960468 2031 100915093
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2033","US","B74","g","hist","s","1663014329","1663014329","0"),
("2033","US","B78","g","hist","s","0","0","0"),
("2033","US","","g","hist","","0","0","0"),
("2033","US","A01","g","hist","r","119529539","5157767","114371772"),
("2033","US","A18","g","hist","r","384417440","283245086","101172354"),
("2033","US","A36","g","hist","r","629937160","258166471","371770689"),
("2033","US","A44","g","hist","r","65440714","33615586","31825128"),
("2033","US","A50","g","hist","r","22350165","1736752","20613413"),
("2033","US","A59","g","hist","r","19421859","9765282","9656577"),
("2033","US","A60","g","hist","r","14987371","61686","14925685"),
("2033","US","A61","g","hist","r","54644181","5182936","49461245"),
("2033","US","A80","g","hist","r","257855366","2769387","255085979"),
("2033","US","A81","g","hist","r","74566368","175410","74390958"),
("2033","US","A87","g","hist","r","28845089","5968732","22876357"),
("2033","US","A89","g","hist","r","241600181","47510868","194089313"),
("2033","US","A90","g","hist","r","31460510","25428181","6032329"),
("2033","US","A91","g","hist","r","277687439","870739","276816700"),
("2033","US","A92","g","hist","r","363885344","25788636","338096708"),
("2033","US","A93","g","hist","r","38686529","14297","38672232"),
("2033","US","A94","g","hist","r","45807287","6657084","39150203"),
("2033","US","B01","g","hist","s","7634089","7634089","0"),
("2033","US","B21","g","hist","s","231964918","231964918","0"),
("2033","US","B22","g","hist","s","15593446","15593446","0"),
("2033","US","B30","g","hist","s","146830791","146830791","0"),
("2033","US","B42","g","hist","s","148681287","148681287","0"),
("2033","US","B46","g","hist","s","127692648","127692648","0"),
("2033","US","B50","g","hist","s","90163611","90163611","0"),
("2033","US","B54","g","hist","s","2241098","2241098","0"),
("2033","US","B59","g","hist","s","54041796","54041796","0"),
("2033","US","B62","g","hist","s","14551953","14551953","0"),
("2033","US","B66","g","hist","s","11603512","11603512","0"),
("2033","US","B79","g","hist","s","140899278","140899278","0"),
("2033","US","B80","g","hist","s","11681140","11681140","0"),
("2033","US","B89","g","hist","s","856437","856437","0"),
("2033","US","B92","g","hist","s","1823667","1823667","0"),
("2033","US","B93","g","hist","s","177987","177987","0"),
("2033","US","B94","g","hist","s","94245258","94245258","0"),
("2033","US","D49","g","hist","s","7902765131","2070825791","5831939340"),
("2033","US","D64","g","hist","s","73827678","26822309","47005369"),
("2033","US","E00","g","hist","s","12022570272","3404057958","8618512314"),
("2033","US","I89","g","hist","s","247553230","69369517","178183713"),
("2033","US","M00","g","hist","r","-2795020580","-2795020580","0"),
("2033","US","O99","g","hist","r","181213478","93785983","87427495"),
("2033","US","Q79","g","hist","","2509491237","2288366598","221124639"),
("2033","US","R00","g","hist","r","9329761837","4198446718","5131315119"),
("2033","US","R01","g","hist","r","95707302","95472319","234983"),
("2033","US","R02","g","hist","r","798314009","659149697","139164312"),
("2033","US","R03","g","hist","r","32624567","32624567","0"),
("2033","US","R95","g","hist","r","1028954582","889071460","139883122"),
("2033","US","R98","g","hist","r","24407398","24407398","0"),
("2033","US","R99","g","hist","r","86652075","70149739","16502336"),
("2033","US","S01","g","hist","s","112394459","6120350","106274109"),
("2033","US","S03","g","hist","s","40080278","29817938","10262340"),
("2033","US","S04","g","hist","s","261135473","148228371","112907102"),
("2033","US","S05","g","hist","s","-3928766","NAN","295974"),
("2033","US","S11","g","hist","s","943574087","736012562","207561525"),
("2033","US","S12","g","hist","s","3196721725","45229673","3151492052"),
("2033","US","S14","g","hist","s","18637663","18637663","0"),
("2033","US","S16","g","hist","s","884013496","740555590","143457906"),
("2033","US","S21","g","hist","s","150226365","133731360","16495005"),
("2033","US","S22","g","hist","s","8037745","7816801","220944"),
("2033","US","S23","g","hist","s","275565512","125177899","150387613"),
("2033","US","S24","g","hist","s","231864550","0","231864550"),
("2033","US","S25","g","hist","s","182214339","74592121","107622218"),
("2033","US","S29","g","hist","s","150954639","24920177","126034462"),
("2033","US","S31","g","hist","s","57941461","12348017","45593444"),
("2033","US","S32","g","hist","s","369252490","120287832","248964658"),
("2033","US","S36","g","hist","s","804001547","312412901","491588646"),
("2033","US","S44","g","hist","s","671947786","335480779","336467007"),
("2033","US","S50","g","hist","s","223706041","35462598","188243443"),
("2033","US","S52","g","hist","s","48487831","1277862","47209969"),
("2033","US","S53","g","hist","s","21908399","21908399","0"),
("2033","US","S59","g","hist","s","142545736","75243250","67302486"),
("2033","US","S60","g","hist","s","6004386","44165","5960221"),
("2033","US","S61","g","hist","s","217625131","19229144","198395987"),
("2033","US","S62","g","hist","s","490805913","51833250","438972663"),
("2033","US","S66","g","hist","s","54790516","28574290","26216226"),
("2033","US","S72","g","hist","s","0","0","0"),
("2033","US","S73","g","hist","s","0","0","0"),
("2033","US","S77","g","hist","s","6062867","6062867","0"),
("2033","US","S80","g","hist","s","293073110","2475367","290597743"),
("2033","US","S81","g","hist","s","109725875","3272422","106453453"),
("2033","US","S85","g","hist","s","4123377","4123377","0"),
("2033","US","S87","g","hist","s","24904891","8237029","16667862"),
("2033","US","S89","g","hist","s","659592944","193403082","466189862"),
("2033","US","S90","g","hist","s","27595277","21694725","5900552"),
("2033","US","S91","g","hist","s","369311617","1449862","367861755"),
("2033","US","S92","g","hist","s","387038744","26721472","360317272"),
("2033","US","S93","g","hist","s","36367647","46275","36321372"),
("2033","US","S94","g","hist","s","378820074","48591892","330228182"),
("2033","US","S95","g","hist","s","948495717","740153785","208341932"),
("2033","US","T00","g","hist","r","12067303618","6935988499","5131315119"),
("2033","US","T01","g","hist","r","2067461137","53243828","2014217309"),
("2033","US","T09","g","hist","r","1510332526","1060896953","449435573"),
("2033","US","T10","g","hist","r","20703196","18223567","2479629"),
("2033","US","T13","g","hist","r","122186036","116465174","5720862"),
("2033","US","T15","g","hist","r","87130432","30741607","56388825"),
("2033","US","T16","g","hist","r","26475839","25730566","745273"),
("2033","US","T19","g","hist","r","160812655","84103325","76709330"),
("2033","US","T24","g","hist","r","80762377","75396360","5366017"),
("2033","US","T40","g","hist","r","812993807","678824094","134169713"),
("2033","US","T41","g","hist","r","281533394","248042053","33491341"),
("2033","US","U01","g","hist","r","48281481","43711","48237770"),
("2033","US","U11","g","hist","r","12718062","2427303","10290759"),
("2033","US","U20","g","hist","r","208329526","116603574","91725952")Query failed:
Incorrect integer value: 'NAN' for column 'state_spending' at row 55