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 339051.2 2032 4833530 2031 4476634
A18 15973051.1 2032 226313717 2031 209499979
A36 17685204.75 2032 252121065 2031 233505060
A44 2002293.15 2032 28545222 2031 26437545
A50 89811.1 2032 1457464 2031 1362926
A59 611373.45 2032 8715765 2031 8072214
A60 4081.2 2032 57298 2031 53002
A61 344145.1 2032 4906150 2031 4543892
A80 171060.8 2032 2438645 2031 2258581
A81 6522.7 2032 133300 2031 126434
A87 216248.5 2032 3462518 2031 3234888
A89 3318150.5 2032 47057025 2031 43564235
A90 1347880.9 2032 18894790 2031 17475968
A91 50734.75 2032 719527 2031 666122
A92 838819.6 2032 12678345 2031 11795377
A93 1589.35 2032 22657 2031 20984
A94 453837.8 2032 6470152 2031 5992428
B01 531340.7 2032 7530024 2031 6970718
B21 15204788 2032 216760130 2031 200755090
B22 1086959.6 2032 15238848 2031 14094680
B30 9780093.25 2032 141384799 2031 131089964
B42 9745729.85 2032 138935557 2031 128676894
B46 8369971.2 2032 119322677 2031 110512181
B50 6314296.6 2032 88512983 2031 81866355
B54 146899.45 2032 2094199 2031 1939568
B59 3777935.3 2032 52961235 2031 48984461
B62 953848.45 2032 13598105 2031 12594054
B66 760257.45 2032 10838256 2031 10037985
B79 9235635.9 2032 131663642 2031 121941920
B80 765672.45 2032 10915468 2031 10109497
B89 60245.2 2032 844413 2031 780997
B92 126462.1 2032 1775820 2031 1642702
B93 11666.95 2032 166320 2031 154039
B94 6177567.85 2032 88067690 2031 81564987
D49 148748732.35 2032 2120641954 2031 1964064341
D64 1736611.4 2032 24757211 2031 22929199
E00 257998245 2032 5093576059 2031 4821998959
I89 5473927.55 2032 78036561 2031 72274532
M00 -238034734.2 2032 -2570181217 2031 -2380347342
O99 4461842.2 2032 89574662 2031 84877986
Q79 138637973.55 2032 1976497515 2031 1830562806
R00 172695879.2 2032 5157114378 2031 4975329242
R01 7890872.9 2032 110616443 2031 102310261
R02 72186457.75 2032 1013992071 2031 938006326
R03 1735953.05 2032 24607256 2031 22779937
R95 88555580.95 2032 1255863664 2031 1162647263
R98 2054085.25 2032 29283138 2031 27120943
R99 2780123.7 2032 55851367 2031 52924921
S01 468356.65 2032 6676912 2031 6183905
S03 333914.55 2032 4760457 2031 4408968
S04 9960183.8 2032 141992827 2031 131508423
S05 -5165044.9 2032 0 2031 103300898
2033xxNAN
S11 43819345.65 2032 621456173 2031 575330546
S12 3376146.1 2032 48130491 2031 44576653
S14 896776.25 2032 13384607 2031 12440632
S16 48602535.8 2032 692879891 2031 641719327
S21 8659569.2 2032 130024176 2031 120908840
S22 953998.55 2032 13600249 2031 12596040
S23 8572851.3 2032 122214951 2031 113190897
S24 0 2032 0 2031 0
S25 3022526.65 2032 44110110 2031 40928503
S29 1719043.05 2032 24506757 2031 22697238
S31 813566.7 2032 11598646 2031 10742260
S32 5244785.65 2032 85785432 2031 80264605
S36 21314048.95 2032 303854029 2031 281418188
S44 22183603.9 2032 316250443 2031 292899281
S50 1226464.25 2032 19316483 2031 18025468
S52 77899.05 2032 1110569 2031 1028570
S53 1614774.85 2032 23020304 2031 21320541
S59 5007801.5 2032 71391443 2031 66120073
S60 2652.4 2032 37808 2031 35016
S61 1313257.2 2032 18721859 2031 17339483
S62 3409379.95 2032 48604267 2031 45015446
S66 2111413 2032 30100396 2031 27877856
S67 2226379.15 2032 31740457 2031 29396900
S72 0 2032 0 2031 0
S73 0 2032 0 2031 0
S74 123674274.65 2032 1763166964 2031 1632983517
S77 400794.55 2032 5713752 2031 5291863
S79 12552348.1 2032 178953022 2031 165740024
S80 263903.35 2032 3762217 2031 3484424
S81 174220.5 2032 2483690 2031 2300300
S85 106930.1 2032 1723241 2031 1610683
S87 491854.9 2032 7011912 2031 6494170
S89 10991602.6 2032 155356344 2031 143786236
S90 1258371.9 2032 17846126 2031 16521524
S91 108910.85 2032 1552695 2031 1438052
S92 1157383.1 2032 16368633 2031 15150335
S93 1477.25 2032 23525 2031 21970
S94 2947619.15 2032 42021392 2031 38918635
S95 54527846.35 2032 777351407 2031 719953674
T00 353038060.45 2032 7727295595 2031 7355676584
T01 -1673348.95 2032 31685545 2031 33466979
T09 -33475838.95 2032 634019286 2031 669516779
T10 -475789.45 2032 9003149 2031 9515789
T13 -3947769.35 2032 74749038 2031 78955387
T15 -1093282.4 2032 20706410 2031 21865648
T16 -770521.4 2032 14572029 2031 15410428
T19 -2781505.05 2032 52568769 2031 55630101
T24 2783644.4 2032 252812910 2031 249882758
T40 54690824.55 2032 1207936176 2031 1150366887
T41 14955408.25 2032 768394310 2031 752651775
U01 3607.15 2032 51423 2031 47626
U11 89248.7 2032 1591211 2031 1497265
U20 10313996.1 2032 146272015 2031 135415177
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","116853150","5172581","111680569"),
("2033","US","A18","g","hist","r","320749307","242286768","78462539"),
("2033","US","A36","g","hist","r","433277384","269806270","163471114"),
("2033","US","A44","g","hist","r","66139574","30547515","35592059"),
("2033","US","A50","g","hist","r","16902957","1547275","15355682"),
("2033","US","A59","g","hist","r","12446076","9327138","3118938"),
("2033","US","A60","g","hist","r","7236671","61379","7175292"),
("2033","US","A61","g","hist","r","41044825","5250295","35794530"),
("2033","US","A80","g","hist","r","180429198","2609706","177819492"),
("2033","US","A81","g","hist","r","45432049","139823","45292226"),
("2033","US","A87","g","hist","r","18912193","3678767","15233426"),
("2033","US","A89","g","hist","r","325873077","50375176","275497901"),
("2033","US","A90","g","hist","r","30509090","20242671","10266419"),
("2033","US","A91","g","hist","r","237663502","770262","236893240"),
("2033","US","A92","g","hist","r","202859547","13517165","189342382"),
("2033","US","A93","g","hist","r","10101532","24246","10077286"),
("2033","US","A94","g","hist","r","40699213","6923990","33775223"),
("2033","US","B01","g","hist","s","8061365","8061365","0"),
("2033","US","B21","g","hist","s","231964918","231964918","0"),
("2033","US","B22","g","hist","s","16325808","16325808","0"),
("2033","US","B30","g","hist","s","151164892","151164892","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","94827280","94827280","0"),
("2033","US","B54","g","hist","s","2241098","2241098","0"),
("2033","US","B59","g","hist","s","56739170","56739170","0"),
("2033","US","B62","g","hist","s","14551953","14551953","0"),
("2033","US","B66","g","hist","s","11598513","11598513","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","904658","904658","0"),
("2033","US","B92","g","hist","s","1902282","1902282","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","7944054452","2269390686","5674663766"),
("2033","US","D64","g","hist","s","158962768","26493822","132468946"),
("2033","US","E00","g","hist","s","13154654993","5351574304","7803080689"),
("2033","US","I89","g","hist","s","294890806","83510489","211380317"),
("2033","US","M00","g","hist","r","-2808215951","-2808215951","0"),
("2033","US","O99","g","hist","r","233900568","94036504","139864064"),
("2033","US","Q79","g","hist","","2314055797","2115135489","198920308"),
("2033","US","R00","g","hist","r","9034641015","5329810257","3704830758"),
("2033","US","R01","g","hist","r","118957339","118507316","450023"),
("2033","US","R02","g","hist","r","1332639696","1086178529","246461167"),
("2033","US","R03","g","hist","r","26343209","26343209","0"),
("2033","US","R95","g","hist","r","1611444201","1344419245","267024956"),
("2033","US","R98","g","hist","r","31337223","31337223","0"),
("2033","US","R99","g","hist","r","78651972","58631491","20020481"),
("2033","US","S01","g","hist","s","128188881","7145269","121043612"),
("2033","US","S03","g","hist","s","7807334","5094372","2712962"),
("2033","US","S04","g","hist","s","246701396","151953011","94748385"),
("2033","US","S05","g","hist","s","-4955066","NAN","209979"),
("2033","US","S11","g","hist","s","846841967","665275519","181566448"),
("2033","US","S12","g","hist","s","2750671493","51506637","2699164856"),
("2033","US","S14","g","hist","s","14281383","14281383","0"),
("2033","US","S16","g","hist","s","892499362","741482427","151016935"),
("2033","US","S21","g","hist","s","152013855","138683745","13330110"),
("2033","US","S22","g","hist","s","14735904","14554248","181656"),
("2033","US","S23","g","hist","s","268368647","130787802","137580845"),
("2033","US","S24","g","hist","s","221338389","0","221338389"),
("2033","US","S25","g","hist","s","148263751","47132637","101131114"),
("2033","US","S29","g","hist","s","136582604","26225800","110356804"),
("2033","US","S31","g","hist","s","52567968","12412213","40155755"),
("2033","US","S32","g","hist","s","347955450","91030218","256925232"),
("2033","US","S36","g","hist","s","540460595","325168078","215292517"),
("2033","US","S44","g","hist","s","696092576","338434047","357658529"),
("2033","US","S50","g","hist","s","206855777","20542947","186312830"),
("2033","US","S52","g","hist","s","54360906","1188468","53172438"),
("2033","US","S53","g","hist","s","24635079","24635079","0"),
("2033","US","S59","g","hist","s","129844646","76399245","53445401"),
("2033","US","S60","g","hist","s","6122598","40460","6082138"),
("2033","US","S61","g","hist","s","214340804","20035116","194305688"),
("2033","US","S62","g","hist","s","467524243","52013647","415510596"),
("2033","US","S66","g","hist","s","60257356","32211809","28045547"),
("2033","US","S67","g","hist","s","71852688","33966836","37885852"),
("2033","US","S72","g","hist","s","0","0","0"),
("2033","US","S73","g","hist","s","0","0","0"),
("2033","US","S74","g","hist","s","1904901399","1886841239","18060160"),
("2033","US","S77","g","hist","s","6114547","6114547","0"),
("2033","US","S79","g","hist","s","337076811","191505370","145571441"),
("2033","US","S80","g","hist","s","277801639","4026120","273775519"),
("2033","US","S81","g","hist","s","97845857","2657911","95187946"),
("2033","US","S85","g","hist","s","1830171","1830171","0"),
("2033","US","S87","g","hist","s","25667380","7503767","18163613"),
("2033","US","S89","g","hist","s","681209825","166347947","514861878"),
("2033","US","S90","g","hist","s","21104344","19104498","1999846"),
("2033","US","S91","g","hist","s","346400009","1661606","344738403"),
("2033","US","S92","g","hist","s","223909944","17526016","206383928"),
("2033","US","S93","g","hist","s","9099454","25002","9074452"),
("2033","US","S94","g","hist","s","329677580","44969011","284708569"),
("2033","US","S95","g","hist","s","1046060527","831879253","214181274"),
("2033","US","T00","g","hist","r","11785164413","8080333655","3704830758"),
("2033","US","T01","g","hist","r","1223267312","30012196","1193255116"),
("2033","US","T09","g","hist","r","736705567","600543447","136162120"),
("2033","US","T10","g","hist","r","9201535","8527360","674175"),
("2033","US","T13","g","hist","r","74114985","70801269","3313716"),
("2033","US","T15","g","hist","r","43549963","19613128","23936835"),
("2033","US","T16","g","hist","r","14010288","13801508","208780"),
("2033","US","T19","g","hist","r","67585267","49787264","17798003"),
("2033","US","T24","g","hist","r","283082165","255596554","27485611"),
("2033","US","T40","g","hist","r","1429951410","1262627001","167324409"),
("2033","US","T41","g","hist","r","883329507","783349718","99979789"),
("2033","US","U01","g","hist","r","31752505","55030","31697475"),
("2033","US","U11","g","hist","r","12665994","1680460","10985534"),
("2033","US","U20","g","hist","r","297331267","156586011","140745256")Query failed:
Incorrect integer value: 'NAN' for column 'state_spending' at row 55