return to Menu
0 secs
US
B74 85062682 2026 928553270 2025 850626820
B74
B78 0 2026 0 2025 0
A01 247354.6 2026 2885790 2025 2473546
A18 -7789447.7 2026 133049909 2025 155788954
A36 12793039.6 2026 150028785 2025 127930396
A44 -813852.47307226 2026 16319016 2025 17654192
A50 -83392 2026 1136208 2025 1667840
A59 320663.15217293 2026 4990429 2025 4799213
A60 -2116.5 2026 36939 2025 42330
A61 256616.3 2026 2927481 2025 2566163
A80 34018.307668689 2026 1378391 2025 1382998
A81 -17904.4 2026 110244 2025 358088
A87 -190248.2 2026 2516143 2025 3804964
A89 -1057706.0355575 2026 29445396 2025 31422138
A90 -725177.3 2026 11346139 2025 14503546
A91 -23577.55 2026 410704 2025 471551
A92 -623274.2 2026 8492814 2025 12465484
A93 850.5 2026 13246 2025 8505
A94 289025.7 2026 3852872 2025 2890257
B01 7774.4688598219 2026 4763475 2025 4894961
B21 11864968.6 2026 129518867 2025 118649686
B22 191115.65963045 2026 9314613 2025 9386552
B30 1513924.9924033 2026 91034346 2025 92109955
B42 7605025 2026 83017000 2025 76050250
B46 6531417.1 2026 71297919 2025 65314171
B50 816417.65805794 2026 54542522 2025 55282374
B54 114631 2026 1251330 2025 1146310
B59 555208.83033961 2026 32535306 2025 32904842
B62 744325.8 2026 8125165 2025 7443258
B66 596310.9 2026 6479099 2025 5963109
B79 7206938 2026 78671910 2025 72069380
B80 597487 2026 6522230 2025 5974870
B89 5118.6322491004 2026 524336 2025 534322
B92 26765.567429937 2026 1079033 2025 1082497
B93 9104 2026 99380 2025 91040
B94 4820598 2026 52622380 2025 48205980
D49 105369312.5 2026 1232536361 2025 1053693125
D64 1039796.3 2026 14294600 2025 10397963
E00 24107142.798897 2026 3049714342 2025 3113758949
I89 3480305.3 2026 46137913 2025 34803053
M00 -143432401 2026 -1545347917 2025 -1434324010
O99 -9306989.75 2026 85020627 2025 186139795
Q79 106562453.66977 2026 1164486802 2025 1086459667
R00 261845715.8 2026 3033704427 2025 2618457158
R01 6997230.2 2026 78115806 2025 69972302
R02 2316431 2026 641038869 2025 23164310
R03 -794261.6 2026 13293176 2025 15885232
R95 20567285.5 2026 764176847 2025 205672855
R98 1484754.5 2026 17287672 2025 14847545
R99 -5870487 2026 47812517 2025 117409740
S01 318335.1 2026 3948179 2025 3183351
S03 53898.076487012 2026 1695982 2025 1688975
S04 7604885 2026 84657636 2025 76048850
S05 -3736125.4 2026 60980462 2025 74722508
2027x46901x-0.023811010510979
S11 -19925196.6 2026 357661644 2025 398503932
S12 2182499.8 2026 28386862 2025 21824998
S14 -582808.6 2026 9052116 2025 11656172
S16 38229924 2026 413990966 2025 382299240
S21 -5719309.3 2026 94637623 2025 114386186
S22 613565.7 2026 7978401 2025 6135657
S23 5997666.2 2026 72710839 2025 59976662
S24 0 2026 0 2025 0
S25 -1876127.4 2026 26436398 2025 37522548
S29 1302076.2 2026 14583738 2025 13020762
S31 504173.2 2026 6901660 2025 5041732
S32 -5020747.65 2026 64770028 2025 100414953
S36 15561304.9 2026 180883589 2025 155613049
S44 16448613.6 2026 188762919 2025 164486136
S50 -1005914.45 2026 13945012 2025 20118289
S52 -7292.1398988785 2026 629279 2025 655406
S53 1187715.1 2026 13652585 2025 11877151
S59 3565308.2 2026 42577822 2025 35653082
S60 -858.74191894518 2026 20056 2025 21548
S61 922928.1 2026 11141387 2025 9229281
S62 2674152.1 2026 29034764 2025 26741521
S66 1558453.6 2026 17849005 2025 15584536
S67 -409303.72365797 2026 17882191 2025 18837360
S72 0 2026 0 2025 0
S73 0 2026 0 2025 0
S74 -22736663.023543 2026 993346953 2025 1046406167
S77 300669.40642923 2026 3376019 2025 3158513
S79 -2307662.006664 2026 100819969 2025 106205225
S80 89172.618103906 2026 2194366 2025 2164841
S81 -12965.017732251 2026 1196844 2025 1245584
S85 -96404.55 2026 1212581 2025 1928091
S87 279447.60229401 2026 3863222 2025 3682340
S89 -5453178.4 2026 91669891 2025 109063568
S90 -585369.35 2026 10169975 2025 11707387
S91 64890.6 2026 918178 2025 648906
S92 -672292.05 2026 9594999 2025 13445841
S93 -1061.55 2026 16601 2025 21231
S94 1719283 2026 23801707 2025 17192830
S95 41032799.4 2026 464032281 2025 410327994
T00 405278116.8 2026 4579052344 2025 4052781168
T01 2797488 2026 33424716 2025 27974880
T09 55808553.4 2026 625727883 2025 558085534
T10 1046076.981567 2026 11438155 2025 10672399
T13 7109979.2 2026 80130944 2025 71099792
T15 1562446.8 2026 20302506 2025 15624468
T16 1094573.0066136 2026 20353295 2025 19797891
T19 -6400157.15 2026 73617865 2025 128003143
T24 4239515.4 2026 45666811 2025 42395154
T40 -36123109.65 2026 563755870 2025 722462193
T41 18691028.6 2026 217937194 2025 186910286
U01 1541.3 2026 30271 2025 15413
U11 -115415.05 2026 1205708 2025 2308301
U20 2545861.5 2026 88604036 2025 25458615
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","B74","g","hist","s","1013615952","1013615952","0"),
("2027","US","B78","g","hist","s","0","0","0"),
("2027","US","A01","g","hist","r","48700016","3133145","45566871"),
("2027","US","A18","g","hist","r","149278486","125260461","24018025"),
("2027","US","A36","g","hist","r","266956617","162821825","104134792"),
("2027","US","A44","g","hist","r","32014033","15505164","16508869"),
("2027","US","A50","g","hist","r","8254305","1052816","7201489"),
("2027","US","A59","g","hist","r","7215392","5311092","1904300"),
("2027","US","A60","g","hist","r","2863197","34823","2828374"),
("2027","US","A61","g","hist","r","15507890","3184097","12323793"),
("2027","US","A80","g","hist","r","71250228","1412409","69837819"),
("2027","US","A81","g","hist","r","20115760","92340","20023420"),
("2027","US","A87","g","hist","r","7719377","2325895","5393482"),
("2027","US","A89","g","hist","r","162551530","28387690","134163840"),
("2027","US","A90","g","hist","r","15193706","10620962","4572744"),
("2027","US","A91","g","hist","r","99794690","387126","99407564"),
("2027","US","A92","g","hist","r","82641169","7869540","74771629"),
("2027","US","A93","g","hist","r","6077725","14097","6063628"),
("2027","US","A94","g","hist","r","16528056","4141898","12386158"),
("2027","US","B01","g","hist","s","4771249","4771249","0"),
("2027","US","B21","g","hist","s","141383836","141383836","0"),
("2027","US","B22","g","hist","s","9505729","9505729","0"),
("2027","US","B30","g","hist","s","92548271","92548271","0"),
("2027","US","B42","g","hist","s","90622025","90622025","0"),
("2027","US","B46","g","hist","s","77829336","77829336","0"),
("2027","US","B50","g","hist","s","55358940","55358940","0"),
("2027","US","B54","g","hist","s","1365961","1365961","0"),
("2027","US","B59","g","hist","s","33090515","33090515","0"),
("2027","US","B62","g","hist","s","8869491","8869491","0"),
("2027","US","B66","g","hist","s","7075410","7075410","0"),
("2027","US","B79","g","hist","s","85878848","85878848","0"),
("2027","US","B80","g","hist","s","7119717","7119717","0"),
("2027","US","B89","g","hist","s","529455","529455","0"),
("2027","US","B92","g","hist","s","1105799","1105799","0"),
("2027","US","B93","g","hist","s","108484","108484","0"),
("2027","US","B94","g","hist","s","57442978","57442978","0"),
("2027","US","D49","g","hist","s","3989188742","1337905674","2651283068"),
("2027","US","D64","g","hist","s","72802294","15334396","57467898"),
("2027","US","E00","g","hist","s","6391002710","3073821485","3317181225"),
("2027","US","I89","g","hist","s","152758972","49618218","103140754"),
("2027","US","M00","g","hist","r","-1688780318","-1688780318","0"),
("2027","US","O99","g","hist","r","160410488","75713637","84696851"),
("2027","US","Q79","g","hist","","1366505415","1271049256","95456159"),
("2027","US","R00","g","hist","r","5393894294","3295550143","2098344151"),
("2027","US","R01","g","hist","r","85283091","85113036","170055"),
("2027","US","R02","g","hist","r","769480093","643355300","126124793"),
("2027","US","R03","g","hist","r","12498914","12498914","0"),
("2027","US","R95","g","hist","r","916447259","784744133","131703126"),
("2027","US","R98","g","hist","r","18772427","18772427","0"),
("2027","US","R99","g","hist","r","57832159","41942030","15890129"),
("2027","US","S01","g","hist","s","55497256","4266514","51230742"),
("2027","US","S03","g","hist","s","3456402","1749880","1706522"),
("2027","US","S04","g","hist","s","131406146","92262521","39143625"),
("2027","US","S05","g","hist","s","57372888","55881291.489999","128551"),
("2027","US","S11","g","hist","s","416273599","337736447","78537152"),
("2027","US","S12","g","hist","s","1127094418","30569362","1096525056"),
("2027","US","S14","g","hist","s","8469307","8469307","0"),
("2027","US","S16","g","hist","s","523706517","452220890","71485627"),
("2027","US","S21","g","hist","s","93985361","88918314","5067047"),
("2027","US","S22","g","hist","s","8665384","8591967","73417"),
("2027","US","S23","g","hist","s","141224655","78708505","62516150"),
("2027","US","S24","g","hist","s","97169533","0","97169533"),
("2027","US","S25","g","hist","s","68316908","24560271","43756637"),
("2027","US","S29","g","hist","s","62403527","15885814","46517713"),
("2027","US","S31","g","hist","s","24542095","7405833","17136262"),
("2027","US","S32","g","hist","s","178436840","59749280","118687560"),
("2027","US","S36","g","hist","s","319857047","196444894","123412153"),
("2027","US","S44","g","hist","s","348046019","205211533","142834486"),
("2027","US","S50","g","hist","s","96763210","12939098","83824112"),
("2027","US","S52","g","hist","s","25526886","621987","24904899"),
("2027","US","S53","g","hist","s","14840300","14840300","0"),
("2027","US","S59","g","hist","s","65858706","46143130","19715576"),
("2027","US","S60","g","hist","s","2909871","19197","2890674"),
("2027","US","S61","g","hist","s","93864765","12064315","81800450"),
("2027","US","S62","g","hist","s","213610514","31708916","181901598"),
("2027","US","S66","g","hist","s","31980609","19407459","12573150"),
("2027","US","S67","g","hist","s","34041331","17472887","16568444"),
("2027","US","S72","g","hist","s","0","0","0"),
("2027","US","S73","g","hist","s","0","0","0"),
("2027","US","S74","g","hist","s","978508454","970610290","7898164"),
("2027","US","S77","g","hist","s","3676688","3676688","0"),
("2027","US","S79","g","hist","s","162174381","98512307","63662074"),
("2027","US","S80","g","hist","s","119664423","2283539","117380884"),
("2027","US","S81","g","hist","s","41682533","1183879","40498654"),
("2027","US","S85","g","hist","s","1116176","1116176","0"),
("2027","US","S87","g","hist","s","12044661","4142670","7901991"),
("2027","US","S89","g","hist","s","328464706","86216713","242247993"),
("2027","US","S90","g","hist","s","10813273","9584606","1228667"),
("2027","US","S91","g","hist","s","140960789","983069","139977720"),
("2027","US","S92","g","hist","s","81866605","8922707","72943898"),
("2027","US","S93","g","hist","s","5508024","15539","5492485"),
("2027","US","S94","g","hist","s","131014839","25520990","105493849"),
("2027","US","S95","g","hist","s","605995073","505065080","100929993"),
("2027","US","T00","g","hist","r","7082674612","4984330461","2098344151"),
("2027","US","T01","g","hist","r","868113684","36222204","831891480"),
("2027","US","T09","g","hist","r","805314713","681536436","123778277"),
("2027","US","T10","g","hist","r","13112530","12484232","628298"),
("2027","US","T13","g","hist","r","89727417","87240923","2486494"),
("2027","US","T15","g","hist","r","37452762","21864953","15587809"),
("2027","US","T16","g","hist","r","21648335","21447868","200467"),
("2027","US","T19","g","hist","r","83652850","67217708","16435142"),
("2027","US","T24","g","hist","r","64243728","49906326","14337402"),
("2027","US","T40","g","hist","r","616873294","527632760","89240534"),
("2027","US","T41","g","hist","r","289203382","236628223","52575159"),
("2027","US","U01","g","hist","r","16191550","31812","16159738"),
("2027","US","U11","g","hist","r","6420095","1090293","5329802"),
("2027","US","U20","g","hist","r","165019019","91149898","73869121")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","M00","g","hist","r","-1672277095","-1672277095","0")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","T00","g","hist","r","6866189803","4755681455","2110508348")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","R00","g","hist","r","5193912708","3083404360","2110508348")
replace government_spending (year,state,code,source,fy,spend_rev,spending,state_spending,local_spending) values
("2027","US","E00","g","hist","s","6410534884.49","3082560615.49","3327974269")
Done