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 316982.7 2032 4518914 2031 4185248
A18 19964157.85 2032 284609910 2031 263595007
A36 16394118.65 2032 233715278 2031 216458311
A44 2262367.05 2032 32252402 2031 29870963
A50 213731.95 2032 3046972 2031 2821991
A59 615014.8 2032 8767680 2031 8120296
A60 5424.5 2032 77333 2031 71623
A61 328852.95 2032 4688141 2031 4341980
A80 177205.4 2032 2526246 2031 2339714
A81 45888.8 2032 654189 2031 605885
A87 487603.65 2032 6951303 2031 6438036
A89 4026618.7 2032 57403648 2031 53165102
A90 1858612.3 2032 26496455 2031 24540021
A91 60429.5 2032 861484 2031 797874
A92 1597434.5 2032 22773099 2031 21091589
A93 1009.85 2032 14379 2031 13316
A94 370386 2032 5280236 2031 4890356
B01 568635.8 2032 8092416 2031 7493852
B21 15204788 2032 216760130 2031 200755090
B22 1129390.4 2032 16084033 2031 14895201
B30 10440801.15 2032 148576786 2031 137586469
B42 9745729.85 2032 138935557 2031 128676894
B46 8369971.2 2032 119322677 2031 110512181
B50 6590556.6 2032 93831766 2031 86894338
B54 146899.45 2032 2094199 2031 1939568
B59 3936462.75 2032 56050640 2031 51906995
B62 953848.45 2032 13598105 2031 12594054
B66 764162.9 2032 10893945 2031 10089563
B79 9235635.9 2032 131663642 2031 121941920
B80 765672.45 2032 10915468 2031 10109497
B89 63152.2 2032 898881 2031 832405
B92 131178.85 2032 1868566 2031 1730483
B93 11666.95 2032 166320 2031 154039
B94 6177567.85 2032 88067690 2031 81564987
D49 129489068.85 2032 1845065307 2031 1708761024
D64 1237040.6 2032 17610989 2031 16308841
E00 188362011.9 2032 5317070393 2031 5118794591
I89 4211834.5 2032 59992769 2031 55559259
M00 -239625720.8 2032 -2587336183 2031 -2396257208
O99 23853757.1 2032 340060220 2031 314951002
Q79 139473995.4 2032 1988347587 2031 1841532855
R00 334188135.75 2032 4764012147 2031 4412235162
R01 8465208.7 2032 120576019 2031 111665273
R02 2337469.3 2032 33293750 2031 30833256
R03 2038249.7 2032 29057373 2031 26911847
R95 26360978.1 2032 375803273 2031 348054875
R98 1902693.25 2032 27124872 2031 25122037
R99 15046015.45 2032 214496652 2031 198658741
S01 408293.85 2032 5820657 2031 5390874
S03 197583.85 2032 2811918 2031 2603935
S04 9745581.65 2032 138933434 2031 128674927
S05 -9716564.45 2032 0 2031 194331289
2033xxNAN
S11 51068189.55 2032 728030365 2031 674274376
S12 2797573.3 2032 39882330 2031 36937516
S14 1493724.9 2032 21294613 2031 19722271
S16 48991169.4 2032 698420264 2031 646850612
S21 14658478.15 2032 208971911 2031 193541934
S22 776343.8 2032 11067589 2031 10250385
S23 7686006.35 2032 109572052 2031 101481519
S24 0 2032 0 2031 0
S25 4808472.5 2032 68549794 2031 63488244
S29 1668593.3 2032 23787540 2031 22031126
S31 646478.8 2032 9216225 2031 8535721
S32 12868035 2032 183447283 2031 169901983
S36 19941631.45 2032 284288766 2031 263297575
S44 21078829.9 2032 300500728 2031 278312486
S50 2578147.05 2032 36754181 2031 34040342
S52 83989.5 2032 1197359 2031 1108949
S53 1522050.1 2032 21698416 2031 20096258
S59 4568898.65 2032 65134428 2031 60325061
S60 2761.65 2032 39367 2031 36460
S61 1182722.45 2032 16860947 2031 15615976
S62 3426896.05 2032 48853981 2031 45246722
S66 1997143.2 2032 28471361 2031 26369105
S72 0 2032 0 2031 0
S73 0 2032 0 2031 0
S74 134095767.05 2032 1911675159 2031 1770521720
S77 404852.95 2032 5771609 2031 5345448
S80 277421.85 2032 3954939 2031 3662916
S81 158599.65 2032 2261011 2031 2094064
S85 247079.8 2032 3522387 2031 3262303
S87 471886.85 2032 6727236 2031 6230513
S89 13976434.2 2032 199248670 2031 184536634
S90 1500254.25 2032 21387698 2031 19808483
S91 83147.8 2032 1185363 2031 1097839
S92 1723066.3 2032 24564112 2031 22750358
S93 2593.5 2032 36954 2031 34224
S94 2031056.3 2032 28908586 2031 26770632
S95 52591517.4 2032 749746987 2031 694387495
T00 515713162 2032 7351348330 2031 6808492370
T01 3584952.3 2032 51107231 2031 47333597
T09 71518115.65 2032 1019565402 2031 944283175
T10 1367653.25 2032 19497323 2031 18057688
T13 9111354.05 2032 129891864 2031 120300965
T15 2002200.05 2032 28543453 2031 26435874
T16 2526692.2 2032 36020631 2031 33360955
T19 16403437.2 2032 233848128 2031 216581352
T24 5432877.1 2032 77451335 2031 71732517
T40 92582596.75 2032 1319861587 2031 1222406222
T41 23951513.05 2032 341453834 2031 316241715
U01 1852.5 2032 26381 2031 24431
U11 295808.15 2032 4217045 2031 3905668
U20 3039850.85 2032 43281378 2031 40081535
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","120783025","4835897","115947128"),
("2033","US","A18","g","hist","r","404147397","304574068","99573329"),
("2033","US","A36","g","hist","r","879891743","250109397","629782346"),
("2033","US","A44","g","hist","r","87598370","34514769","53083601"),
("2033","US","A50","g","hist","r","32446853","3260704","29186149"),
("2033","US","A59","g","hist","r","20927631","9382695","11544936"),
("2033","US","A60","g","hist","r","15017898","82758","14935140"),
("2033","US","A61","g","hist","r","55005345","5016994","49988351"),
("2033","US","A80","g","hist","r","268584364","2703451","265880913"),
("2033","US","A81","g","hist","r","86613649","700078","85913571"),
("2033","US","A87","g","hist","r","29327787","7438907","21888880"),
("2033","US","A89","g","hist","r","384024307","61430267","322594040"),
("2033","US","A90","g","hist","r","37607445","28355067","9252378"),
("2033","US","A91","g","hist","r","289880007","921914","288958093"),
("2033","US","A92","g","hist","r","364374663","24370534","340004129"),
("2033","US","A93","g","hist","r","39708582","15389","39693193"),
("2033","US","A94","g","hist","r","45649701","5650622","39999079"),
("2033","US","B01","g","hist","s","8661052","8661052","0"),
("2033","US","B21","g","hist","s","231964918","231964918","0"),
("2033","US","B22","g","hist","s","17213423","17213423","0"),
("2033","US","B30","g","hist","s","159017587","159017587","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","100422323","100422323","0"),
("2033","US","B54","g","hist","s","2241098","2241098","0"),
("2033","US","B59","g","hist","s","59987103","59987103","0"),
("2033","US","B62","g","hist","s","14551953","14551953","0"),
("2033","US","B66","g","hist","s","11658108","11658108","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","962033","962033","0"),
("2033","US","B92","g","hist","s","1999745","1999745","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","7686853988","1974554376","5712299612"),
("2033","US","D64","g","hist","s","109021595","18848030","90173565"),
("2033","US","E00","g","hist","s","14722503199","5505432405","9217070794"),
("2033","US","I89","g","hist","s","260585667","64204604","196381063"),
("2033","US","M00","g","hist","r","-2826961904","-2826961904","0"),
("2033","US","O99","g","hist","r","675942922","363913977","312028945"),
("2033","US","Q79","g","hist","","2373214671","2127821582","245393089"),
("2033","US","R00","g","hist","r","11691491473","5098200283","6593291190"),
("2033","US","R01","g","hist","r","129183695","129041228","142467"),
("2033","US","R02","g","hist","r","60334136","35631219","24702917"),
("2033","US","R03","g","hist","r","31095623","31095623","0"),
("2033","US","R95","g","hist","r","480403762","402164251","78239511"),
("2033","US","R98","g","hist","r","29027565","29027565","0"),
("2033","US","R99","g","hist","r","454028718","229542667","224486051"),
("2033","US","S01","g","hist","s","69687428","6228951","63458477"),
("2033","US","S03","g","hist","s","13181935","3009502","10172433"),
("2033","US","S04","g","hist","s","272349022","148679016","123670006"),
("2033","US","S05","g","hist","s","-9716564","NAN","0"),
("2033","US","S11","g","hist","s","1029535076","779098555","250436521"),
("2033","US","S12","g","hist","s","3655999181","42679903","3613319278"),
("2033","US","S14","g","hist","s","22788338","22788338","0"),
("2033","US","S16","g","hist","s","899216897","747411433","151805464"),
("2033","US","S21","g","hist","s","232381714","223630389","8751325"),
("2033","US","S22","g","hist","s","11945284","11843933","101351"),
("2033","US","S23","g","hist","s","215216985","117258058","97958927"),
("2033","US","S24","g","hist","s","255896211","0","255896211"),
("2033","US","S25","g","hist","s","180587046","73358267","107228779"),
("2033","US","S29","g","hist","s","184513947","25456133","159057814"),
("2033","US","S31","g","hist","s","62740129","9862704","52877425"),
("2033","US","S32","g","hist","s","509296438","196315318","312981120"),
("2033","US","S36","g","hist","s","933452231","304230397","629221834"),
("2033","US","S44","g","hist","s","584583532","321579558","263003974"),
("2033","US","S50","g","hist","s","305392624","39332328","266060296"),
("2033","US","S52","g","hist","s","55841631","1281349","54560282"),
("2033","US","S53","g","hist","s","23220466","23220466","0"),
("2033","US","S59","g","hist","s","131082751","69703327","61379424"),
("2033","US","S60","g","hist","s","6799838","42129","6757709"),
("2033","US","S61","g","hist","s","199349978","18043669","181306309"),
("2033","US","S62","g","hist","s","499220091","52280877","446939214"),
("2033","US","S66","g","hist","s","56849101","30468504","26380597"),
("2033","US","S72","g","hist","s","0","0","0"),
("2033","US","S73","g","hist","s","0","0","0"),
("2033","US","S74","g","hist","s","2068382282","2045770926","22611356"),
("2033","US","S77","g","hist","s","6176462","6176462","0"),
("2033","US","S80","g","hist","s","258997508","4232361","254765147"),
("2033","US","S81","g","hist","s","103960867","2419611","101541256"),
("2033","US","S85","g","hist","s","3769467","3769467","0"),
("2033","US","S87","g","hist","s","20431508","7199123","13232385"),
("2033","US","S89","g","hist","s","806742351","213225104","593517247"),
("2033","US","S90","g","hist","s","30546439","22887952","7658487"),
("2033","US","S91","g","hist","s","283370057","1268511","282101546"),
("2033","US","S92","g","hist","s","352314291","26287178","326027113"),
("2033","US","S93","g","hist","s","37164968","39548","37125420"),
("2033","US","S94","g","hist","s","269724648","30939642","238785006"),
("2033","US","S95","g","hist","s","1007009715","802338504","204671211"),
("2033","US","T00","g","hist","r","14460352682","7867061492","6593291190"),
("2033","US","T01","g","hist","r","2453149276","54692183","2398457093"),
("2033","US","T09","g","hist","r","1751132167","1091083518","660048649"),
("2033","US","T10","g","hist","r","25254437","20864976","4389461"),
("2033","US","T13","g","hist","r","148904689","139003218","9901471"),
("2033","US","T15","g","hist","r","91782794","30545653","61237141"),
("2033","US","T16","g","hist","r","39240978","38547323","693655"),
("2033","US","T19","g","hist","r","356445356","250251565","106193791"),
("2033","US","T24","g","hist","r","92165528","82884212","9281316"),
("2033","US","T40","g","hist","r","1609096792","1412444184","196652608"),
("2033","US","T41","g","hist","r","423071466","365405347","57666119"),
("2033","US","U01","g","hist","r","78281591","28234","78253357"),
("2033","US","U11","g","hist","r","17423311","4512853","12910458"),
("2033","US","U20","g","hist","r","64341666","46321229","18020437")Query failed:
Incorrect integer value: 'NAN' for column 'state_spending' at row 55