return to Menu
0 secs
US
B74 109006916.85 2032 1540858378 2031 1426114255
B74
B78 0 2032 0 2031 0
0 2032 0 2031 0
A01 316982.7 2032 4480678 2031 4147012
A18 19964157.85 2032 282201718 2031 261186815
A36 16394118.65 2032 231737724 2031 214480757
A44 2262367.05 2032 31979502 2031 29598063
A50 213731.95 2032 3021190 2031 2796209
A59 615014.8 2032 8693494 2031 8046110
A60 5424.5 2032 76679 2031 70969
A61 328852.95 2032 4648474 2031 4302313
A80 176543.25 2032 2496109 2031 2310274
A81 45888.8 2032 648654 2031 600350
A87 487603.65 2032 6892486 2031 6379219
A89 4026618.7 2032 56917927 2031 52679381
A90 1858612.3 2032 26272259 2031 24315825
A91 60429.5 2032 854195 2031 790585
A92 1597434.5 2032 22580407 2031 20898897
A93 849.3 2032 12985 2031 12091
A94 370386 2032 5235559 2031 4845679
B01 439143.2 2032 7110621 2031 6648365
B21 15204788 2032 214926039 2031 198920999
B22 1040996.7 2032 14922587 2031 13826801
B30 7375116 2032 127313809 2031 119550529
B42 9745729.85 2032 137759969 2031 127501306
B46 8369971.2 2032 118313045 2031 109502549
B50 5648952.7 2032 85340968 2031 79394702
B54 146899.45 2032 2076479 2031 1921848
B59 3458261.25 2032 51340482 2031 47700207
B62 953848.45 2032 13483047 2031 12478996
B66 764162.9 2032 10801767 2031 9997385
B79 9235635.9 2032 130549588 2031 120827866
B80 765672.45 2032 10823108 2031 10017137
B89 51975.45 2032 805686 2031 750975
B92 125358.2 2032 1755394 2031 1623438
B93 11666.95 2032 164913 2031 152632
B94 6177567.85 2032 87322518 2031 80819815
D49 124575849.35 2032 1752277697 2031 1621145224
D64 1050199.35 2032 15961778 2031 14856305
E00 252016535.8 2032 3369808506 2031 3104527942
I89 4022324.7 2032 56280401 2031 52046375
M00 -234527342.4 2032 -2531383584 2031 -2345273424
O99 23853757.1 2032 337182855 2031 312073637
Q79 149997377.2 2032 2120275684 2031 1962383708
R00 332429452.05 2032 4708523452 2031 4358597713
R01 8083034.15 2032 113076008 2031 104567551
R02 1437783.2 2032 28597522 2031 27084066
R03 2017116 2032 28531874 2031 26408594
R95 25930691.75 2032 366926343 2031 339630878
R98 1902693.25 2032 26895359 2031 24892524
R99 15046015.45 2032 212681723 2031 196843812
S01 405665.2 2032 5736628 2031 5309612
S03 156250.3 2032 2487995 2031 2323521
S04 9745581.65 2032 137757866 2031 127499359
S05 -1449158.1 2032 0 2031 -14491581
2033xxNAN
S11 51068189.55 2032 721870255 2031 668114266
S12 2783430.65 2032 39357669 2031 36427742
S14 1493724.9 2032 21114432 2031 19542090
S16 48991169.4 2032 692510666 2031 640941014
S21 14658478.15 2032 207203724 2031 191773747
S22 762372.15 2032 10788199 2031 9985702
S23 7686006.35 2032 108644926 2031 100554393
S24 0 2032 0 2031 0
S25 4808472.5 2032 67969768 2031 62908218
S29 1668593.3 2032 23586264 2031 21829850
S31 643197.5 2032 9094826 2031 8417776
S32 12868035 2032 181895064 2031 168349764
S36 19941631.45 2032 281883292 2031 260892101
S44 21078829.9 2032 297958088 2031 275769846
S50 2578147.05 2032 36443191 2031 33729352
S52 83989.5 2032 1187228 2031 1098818
S53 1522050.1 2032 21514818 2031 19912660
S59 4568898.65 2032 64583302 2031 59773935
S60 2761.65 2032 39033 2031 36126
S61 1182722.45 2032 16718280 2031 15473309
S62 3426896.05 2032 48440609 2031 44833350
S66 1997143.2 2032 28230455 2031 26128199
S72 0 2032 0 2031 0
S73 0 2032 0 2031 0
S77 402807.6 2032 5695692 2031 5271684
S80 277421.85 2032 3921474 2031 3629451
S81 155980.5 2032 2207123 2031 2042933
S85 247079.8 2032 3492583 2031 3232499
S87 471886.85 2032 6670315 2031 6173592
S89 13976434.2 2032 197562757 2031 182850721
S90 1500254.25 2032 21206726 2031 19627511
S91 82729.8 2032 1169791 2031 1082707
S92 1723066.3 2032 24356266 2031 22542512
S93 2488.05 2032 34940 2031 32321
S94 1667630.95 2032 25889552 2031 24134151
S95 51733070.8 2032 732037045 2031 677581181
T00 509234104.05 2032 7239907036 2031 6703871137
T01 3584952.3 2032 50674794 2031 46901160
T09 71518115.65 2032 1010938484 2031 935656257
T10 1367653.25 2032 19332349 2031 17892714
T13 9111354.05 2032 128792800 2031 119201901
T15 2002200.05 2032 28301932 2031 26194353
T16 2485133.5 2032 35164796 2031 32548866
T19 16403437.2 2032 231869450 2031 214602674
T24 5432877.1 2032 76795990 2031 71077172
T40 92582596.75 2032 1308693735 2031 1211238370
T41 23951513.05 2032 338564604 2031 313352485
U01 1693.85 2032 24424 2031 22641
U11 295808.15 2032 4181363 2031 3869986
U20 2626701.55 2032 39473350 2031 36708401
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2033","US","B74","g","hist","s","1649865295","1649865295","0"),
("2033","US","B78","g","hist","s","0","0","0"),
("2033","US","","g","hist","","0","0","0"),
("2033","US","A01","g","hist","r","103254982","4797661","98457321"),
("2033","US","A18","g","hist","r","387198282","302165876","85032406"),
("2033","US","A36","g","hist","r","776701445","248131843","528569602"),
("2033","US","A44","g","hist","r","79202366","34241869","44960497"),
("2033","US","A50","g","hist","r","26659411","3234922","23424489"),
("2033","US","A59","g","hist","r","18771486","9308509","9462977"),
("2033","US","A60","g","hist","r","12673115","82104","12591011"),
("2033","US","A61","g","hist","r","47234878","4977327","42257551"),
("2033","US","A80","g","hist","r","214987407","2672652","212314755"),
("2033","US","A81","g","hist","r","69551997","694543","68857454"),
("2033","US","A87","g","hist","r","25342607","7380090","17962517"),
("2033","US","A89","g","hist","r","325405785","60944546","264461239"),
("2033","US","A90","g","hist","r","35742992","28130871","7612121"),
("2033","US","A91","g","hist","r","228884469","914625","227969844"),
("2033","US","A92","g","hist","r","300900633","24177842","276722791"),
("2033","US","A93","g","hist","r","33916281","13834","33902447"),
("2033","US","A94","g","hist","r","39905207","5605945","34299262"),
("2033","US","B01","g","hist","s","7549764","7549764","0"),
("2033","US","B21","g","hist","s","230130827","230130827","0"),
("2033","US","B22","g","hist","s","15963584","15963584","0"),
("2033","US","B30","g","hist","s","134688925","134688925","0"),
("2033","US","B42","g","hist","s","147505699","147505699","0"),
("2033","US","B46","g","hist","s","126683016","126683016","0"),
("2033","US","B50","g","hist","s","90989921","90989921","0"),
("2033","US","B54","g","hist","s","2223378","2223378","0"),
("2033","US","B59","g","hist","s","54798743","54798743","0"),
("2033","US","B62","g","hist","s","14436895","14436895","0"),
("2033","US","B66","g","hist","s","11565930","11565930","0"),
("2033","US","B79","g","hist","s","139785224","139785224","0"),
("2033","US","B80","g","hist","s","11588780","11588780","0"),
("2033","US","B89","g","hist","s","857661","857661","0"),
("2033","US","B92","g","hist","s","1880752","1880752","0"),
("2033","US","B93","g","hist","s","176580","176580","0"),
("2033","US","B94","g","hist","s","93500086","93500086","0"),
("2033","US","D49","g","hist","s","6174845432","1876853546","4297991886"),
("2033","US","D64","g","hist","s","86477357","17011977","69465380"),
("2033","US","E00","g","hist","s","11033929265","3621825042","7412104223"),
("2033","US","I89","g","hist","s","209072930","60302726","148770204"),
("2033","US","M00","g","hist","r","-2765910926","-2765910926","0"),
("2033","US","O99","g","hist","r","614432844","361036612","253396232"),
("2033","US","Q79","g","hist","","2473971846","2270273061","203698785"),
("2033","US","R00","g","hist","r","10433747345","5040952904","5392794441"),
("2033","US","R01","g","hist","r","121264969","121159042","105927"),
("2033","US","R02","g","hist","r","47586771","30035305","17551466"),
("2033","US","R03","g","hist","r","30548990","30548990","0"),
("2033","US","R95","g","hist","r","452542431","392857035","59685396"),
("2033","US","R98","g","hist","r","28798052","28798052","0"),
("2033","US","R99","g","hist","r","421209816","227727738","193482078"),
("2033","US","S01","g","hist","s","52419793","6142293","46277500"),
("2033","US","S03","g","hist","s","10726687","2644245","8082442"),
("2033","US","S04","g","hist","s","245935462","147503448","98432014"),
("2033","US","S05","g","hist","s","-1449158","NAN","0"),
("2033","US","S11","g","hist","s","971578347","772938445","198639902"),
("2033","US","S12","g","hist","s","2991704454","42141100","2949563354"),
("2033","US","S14","g","hist","s","22608157","22608157","0"),
("2033","US","S16","g","hist","s","859284763","741501835","117782928"),
("2033","US","S21","g","hist","s","228538202","221862202","6676000"),
("2033","US","S22","g","hist","s","11626750","11550571","76179"),
("2033","US","S23","g","hist","s","195402664","116330932","79071732"),
("2033","US","S24","g","hist","s","205405454","0","205405454"),
("2033","US","S25","g","hist","s","158312242","72778241","85534001"),
("2033","US","S29","g","hist","s","154313503","25254857","129058646"),
("2033","US","S31","g","hist","s","51971494","9738024","42233470"),
("2033","US","S32","g","hist","s","446653036","194763099","251889937"),
("2033","US","S36","g","hist","s","815737828","301824923","513912905"),
("2033","US","S44","g","hist","s","521687480","319036918","202650562"),
("2033","US","S50","g","hist","s","257099984","39021338","218078646"),
("2033","US","S52","g","hist","s","45081056","1271218","43809838"),
("2033","US","S53","g","hist","s","23036868","23036868","0"),
("2033","US","S59","g","hist","s","119525632","69152201","50373431"),
("2033","US","S60","g","hist","s","5255867","41795","5214072"),
("2033","US","S61","g","hist","s","164338647","17901002","146437645"),
("2033","US","S62","g","hist","s","406843471","51867505","354975966"),
("2033","US","S66","g","hist","s","51169387","30227598","20941789"),
("2033","US","S72","g","hist","s","0","0","0"),
("2033","US","S73","g","hist","s","0","0","0"),
("2033","US","S77","g","hist","s","6098500","6098500","0"),
("2033","US","S80","g","hist","s","206290173","4198896","202091277"),
("2033","US","S81","g","hist","s","82232357","2363104","79869253"),
("2033","US","S85","g","hist","s","3739663","3739663","0"),
("2033","US","S87","g","hist","s","17399251","7142202","10257049"),
("2033","US","S89","g","hist","s","694153151","211539191","482613960"),
("2033","US","S90","g","hist","s","28984151","22706980","6277171"),
("2033","US","S91","g","hist","s","221701213","1252521","220448692"),
("2033","US","S92","g","hist","s","292092488","26079332","266013156"),
("2033","US","S93","g","hist","s","31534280","37428","31496852"),
("2033","US","S94","g","hist","s","216705377","27557183","189148194"),
("2033","US","S95","g","hist","s","939904580","783770116","156134464"),
("2033","US","T00","g","hist","r","13141935581","7749141140","5392794441"),
("2033","US","T01","g","hist","r","1965619605","54259746","1911359859"),
("2033","US","T09","g","hist","r","1652393899","1082456600","569937299"),
("2033","US","T10","g","hist","r","24443357","20700002","3743355"),
("2033","US","T13","g","hist","r","146426217","137904154","8522063"),
("2033","US","T15","g","hist","r","79242919","30304132","48938787"),
("2033","US","T16","g","hist","r","38154272","37649930","504342"),
("2033","US","T19","g","hist","r","337492120","248272887","89219233"),
("2033","US","T24","g","hist","r","89711150","82228867","7482283"),
("2033","US","T40","g","hist","r","1561581278","1401276332","160304946"),
("2033","US","T41","g","hist","r","412286040","362516117","49769923"),
("2033","US","U01","g","hist","r","66900745","26118","66874627"),
("2033","US","U11","g","hist","r","14554389","4477171","10077218"),
("2033","US","U20","g","hist","r","54766572","42100052","12666520")Query failed:
Incorrect integer value: 'NAN' for column 'state_spending' at row 55