return to Menu
United States 332,100,166 333,996,304 336,755,052 340,003,797 340,003,797 gr=1.0052383532646
Northeast 57,234,503 57,174,375 57,458,539 57,940,522 57,940,522 gr=1.0017523487275
Midwest 68,867,096 68,872,112 69,132,050 69,518,281 69,518,281 gr=1.003515406257
South 127,380,165 129,066,102 130,894,372 132,662,072 132,662,072 gr=1.0088338059427
West 78,618,402 78,883,715 79,270,091 79,882,922 79,882,922 gr=1.0032952224757
Alabama 5,050,058 5,076,868 5,117,850 5,163,055 5,163,055 gr=1.0058169049139
Alaska 734,590 733,659 734,654 736,537 736,537 gr=1.0009951977973
Arizona 7,274,022 7,370,065 7,452,073 7,556,424 7,556,424 gr=1.0089187689838
Arkansas 3,027,127 3,047,429 3,069,856 3,096,080 3,096,080 gr=1.0060434484897
California 39,152,927 39,125,347 39,181,667 39,364,774 39,364,774 gr=0.99975955660256
Colorado 5,814,368 5,853,355 5,912,240 5,988,502 5,988,502 gr=1.0040175322643
Connecticut 3,607,765 3,618,707 3,641,369 3,674,449 3,674,449 gr=1.003822886098
Delaware 1,005,130 1,020,279 1,035,354 1,050,123 1,050,123 gr=1.0093598559407
District of Columbia 669,637 674,501 682,559 691,310 691,310 gr=1.00337764534
Florida 21,836,698 22,413,989 22,929,248 23,265,838 23,265,838 gr=1.0084535962126
Georgia 10,793,038 10,929,992 11,063,669 11,204,208 11,204,208 gr=1.0087949099124
Hawaii 1,446,909 1,437,812 1,434,950 1,434,952 1,434,952 gr=0.99851423601626
Idaho 1,904,855 1,942,951 1,970,497 2,000,872 2,000,872 gr=1.014424211044
Illinois 12,703,354 12,609,577 12,633,389 12,703,033 12,703,033 gr=1.0012680436239
Indiana 6,814,223 6,841,491 6,881,373 6,934,754 6,934,754 gr=1.0055631389376
Iowa 3,199,037 3,201,890 3,214,739 3,230,454 3,230,454 gr=1.0024556919863
Kansas 2,938,966 2,938,034 2,949,749 2,965,252 2,965,252 gr=1.0040360819249
Kentucky 4,508,348 4,521,238 4,549,953 4,584,046 4,584,046 gr=1.0049776987404
Louisiana 4,628,595 4,600,892 4,598,777 4,614,878 4,614,878 gr=1.0007174620868
Maine 1,379,009 1,391,585 1,401,992 1,408,438 1,408,438 gr=1.0045696012178
Maryland 6,176,035 6,183,257 6,204,927 6,245,314 6,245,314 gr=1.0032076849939
Massachusetts 6,996,721 7,025,465 7,073,479 7,138,560 7,138,560 gr=1.0021746682804
Michigan 10,042,362 10,043,906 10,062,124 10,099,962 10,099,962 gr=1.0027645648568
Minnesota 5,714,055 5,727,565 5,752,998 5,797,405 5,797,405 gr=1.0056922019421
Mississippi 2,947,603 2,941,237 2,942,470 2,950,172 2,950,172 gr=1.0013517855908
Missouri 6,172,551 6,179,285 6,205,956 6,243,544 6,243,544 gr=1.0043239865051
Montana 1,106,416 1,121,533 1,130,612 1,137,557 1,137,557 gr=1.0062739713263
Nebraska 1,964,697 1,972,595 1,988,172 2,005,591 2,005,591 gr=1.006190195309
Nevada 3,148,472 3,177,672 3,211,077 3,253,543 3,253,543 gr=1.0088042481688
New Hampshire 1,387,907 1,396,647 1,401,530 1,408,518 1,408,518 gr=1.004844808515
New Jersey 9,266,509 9,298,402 9,395,315 9,506,354 9,506,354 gr=1.0044034758226
New Mexico 2,117,300 2,112,859 2,119,349 2,126,774 2,126,774 gr=0.9994000302806
New York 19,835,345 19,713,025 19,786,543 20,001,419 20,001,419 gr=1.0000503964244
North Carolina 10,565,503 10,705,768 10,871,849 11,052,061 11,052,061 gr=1.0132017910506
North Dakota 777,977 780,191 787,071 793,387 793,387 gr=1.0075259614791
Ohio 11,761,443 11,764,950 11,808,390 11,860,621 11,860,621 gr=1.0033631459938
Oklahoma 3,992,760 4,025,327 4,062,716 4,097,758 4,097,758 gr=1.0062302361438
Oregon 4,254,691 4,245,964 4,250,392 4,265,324 4,265,324 gr=1.0019370158047
Pennsylvania 13,016,628 12,984,655 13,009,406 13,045,848 13,045,848 gr=1.0010412508255
Rhode Island 1,097,381 1,098,275 1,101,183 1,110,415 1,110,415 gr=1.0036977166195
South Carolina 5,194,346 5,288,957 5,390,798 5,490,316 5,490,316 gr=1.0145634604638
South Dakota 896,303 909,156 917,739 927,110 927,110 gr=1.0086117073486
Tennessee 6,966,687 7,063,325 7,153,029 7,251,291 7,251,291 gr=1.0087963646749
Texas 29,572,672 30,118,002 30,719,247 31,318,578 31,318,578 gr=1.0124923615625
Utah 3,339,874 3,393,928 3,449,259 3,502,983 3,502,983 gr=1.0102544031758
Vermont 647,238 647,614 647,722 646,521 646,521 gr=0.9971261567683
Virginia 8,660,007 8,681,038 8,732,034 8,819,642 8,819,642 gr=1.0068557204476
Washington 7,744,316 7,786,828 7,838,655 7,927,958 7,927,958 gr=1.009215740043
West Virginia 1,785,921 1,774,003 1,770,036 1,767,402 1,767,402 gr=0.99928991819631
Wisconsin 5,882,128 5,903,472 5,930,350 5,957,168 5,957,168 gr=1.0026218834184
Wyoming 579,662 581,742 584,666 586,722 586,722 gr=1.0034616053259
Puerto Rico 3,262,731 3,220,148 3,203,794 3,202,521 3,202,521 gr=0.99447747571366
United States
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","US","POP","a","hist","s","uscb","331578104"),
("2020","US","POP","a","hist","r","uscb","331578104"),
("2021","US","POP","a","hist","s","uscb","332100166"),
("2021","US","POP","a","hist","r","uscb","332100166"),
("2022","US","POP","a","hist","s","uscb","333996304"),
("2022","US","POP","a","hist","r","uscb","333996304"),
("2023","US","POP","a","hist","s","uscb","336755052"),
("2023","US","POP","a","hist","r","uscb","336755052"),
("2024","US","POP","e","hist","s","uscb","340003797"),
("2024","US","POP","e","hist","r","uscb","340003797"),
("2025","US","POP","e","hist","s","uscb","341784857"),
("2025","US","POP","e","hist","r","uscb","341784857"),
("2026","US","POP","g","hist","s","uscb","343575246"),
("2026","US","POP","g","hist","r","uscb","343575246"),
("2027","US","POP","g","hist","s","uscb","345375015"),
("2027","US","POP","g","hist","r","uscb","345375015"),
("2028","US","POP","g","hist","s","uscb","347184211"),
("2028","US","POP","g","hist","r","uscb","347184211"),
("2029","US","POP","g","hist","s","uscb","349002885"),
("2029","US","POP","g","hist","r","uscb","349002885"),
("2030","US","POP","g","hist","s","uscb","350831085"),
("2030","US","POP","g","hist","r","uscb","350831085")
Northeast
Midwest
South
West
Alabama
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","AL","POP","a","hist","s","uscb","5032962"),
("2020","AL","POP","a","hist","r","uscb","5032962"),
("2021","AL","POP","a","hist","s","uscb","5050058"),
("2021","AL","POP","a","hist","r","uscb","5050058"),
("2022","AL","POP","a","hist","s","uscb","5076868"),
("2022","AL","POP","a","hist","r","uscb","5076868"),
("2023","AL","POP","a","hist","s","uscb","5117850"),
("2023","AL","POP","a","hist","r","uscb","5117850"),
("2024","AL","POP","e","hist","s","uscb","5163055"),
("2024","AL","POP","e","hist","r","uscb","5163055"),
("2025","AL","POP","e","hist","s","uscb","5193088"),
("2025","AL","POP","e","hist","r","uscb","5193088"),
("2026","AL","POP","g","hist","s","uscb","5223295"),
("2026","AL","POP","g","hist","r","uscb","5223295"),
("2027","AL","POP","g","hist","s","uscb","5253679"),
("2027","AL","POP","g","hist","r","uscb","5253679"),
("2028","AL","POP","g","hist","s","uscb","5284239"),
("2028","AL","POP","g","hist","r","uscb","5284239"),
("2029","AL","POP","g","hist","s","uscb","5314977"),
("2029","AL","POP","g","hist","r","uscb","5314977"),
("2030","AL","POP","g","hist","s","uscb","5345893"),
("2030","AL","POP","g","hist","r","uscb","5345893")
Alaska
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","AK","POP","a","hist","s","uscb","732906"),
("2020","AK","POP","a","hist","r","uscb","732906"),
("2021","AK","POP","a","hist","s","uscb","734590"),
("2021","AK","POP","a","hist","r","uscb","734590"),
("2022","AK","POP","a","hist","s","uscb","733659"),
("2022","AK","POP","a","hist","r","uscb","733659"),
("2023","AK","POP","a","hist","s","uscb","734654"),
("2023","AK","POP","a","hist","r","uscb","734654"),
("2024","AK","POP","e","hist","s","uscb","736537"),
("2024","AK","POP","e","hist","r","uscb","736537"),
("2025","AK","POP","e","hist","s","uscb","737270"),
("2025","AK","POP","e","hist","r","uscb","737270"),
("2026","AK","POP","g","hist","s","uscb","738003"),
("2026","AK","POP","g","hist","r","uscb","738003"),
("2027","AK","POP","g","hist","s","uscb","738738"),
("2027","AK","POP","g","hist","r","uscb","738738"),
("2028","AK","POP","g","hist","s","uscb","739473"),
("2028","AK","POP","g","hist","r","uscb","739473"),
("2029","AK","POP","g","hist","s","uscb","740209"),
("2029","AK","POP","g","hist","r","uscb","740209"),
("2030","AK","POP","g","hist","s","uscb","740945"),
("2030","AK","POP","g","hist","r","uscb","740945")
Arizona
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","AZ","POP","a","hist","s","uscb","7186647"),
("2020","AZ","POP","a","hist","r","uscb","7186647"),
("2021","AZ","POP","a","hist","s","uscb","7274022"),
("2021","AZ","POP","a","hist","r","uscb","7274022"),
("2022","AZ","POP","a","hist","s","uscb","7370065"),
("2022","AZ","POP","a","hist","r","uscb","7370065"),
("2023","AZ","POP","a","hist","s","uscb","7452073"),
("2023","AZ","POP","a","hist","r","uscb","7452073"),
("2024","AZ","POP","e","hist","s","uscb","7556424"),
("2024","AZ","POP","e","hist","r","uscb","7556424"),
("2025","AZ","POP","e","hist","s","uscb","7623818"),
("2025","AZ","POP","e","hist","r","uscb","7623818"),
("2026","AZ","POP","g","hist","s","uscb","7691813"),
("2026","AZ","POP","g","hist","r","uscb","7691813"),
("2027","AZ","POP","g","hist","s","uscb","7760414"),
("2027","AZ","POP","g","hist","r","uscb","7760414"),
("2028","AZ","POP","g","hist","s","uscb","7829627"),
("2028","AZ","POP","g","hist","r","uscb","7829627"),
("2029","AZ","POP","g","hist","s","uscb","7899458"),
("2029","AZ","POP","g","hist","r","uscb","7899458"),
("2030","AZ","POP","g","hist","s","uscb","7969912"),
("2030","AZ","POP","g","hist","r","uscb","7969912")
Arkansas
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","AR","POP","a","hist","s","uscb","3014399"),
("2020","AR","POP","a","hist","r","uscb","3014399"),
("2021","AR","POP","a","hist","s","uscb","3027127"),
("2021","AR","POP","a","hist","r","uscb","3027127"),
("2022","AR","POP","a","hist","s","uscb","3047429"),
("2022","AR","POP","a","hist","r","uscb","3047429"),
("2023","AR","POP","a","hist","s","uscb","3069856"),
("2023","AR","POP","a","hist","r","uscb","3069856"),
("2024","AR","POP","e","hist","s","uscb","3096080"),
("2024","AR","POP","e","hist","r","uscb","3096080"),
("2025","AR","POP","e","hist","s","uscb","3114791"),
("2025","AR","POP","e","hist","r","uscb","3114791"),
("2026","AR","POP","g","hist","s","uscb","3133615"),
("2026","AR","POP","g","hist","r","uscb","3133615"),
("2027","AR","POP","g","hist","s","uscb","3152552"),
("2027","AR","POP","g","hist","r","uscb","3152552"),
("2028","AR","POP","g","hist","s","uscb","3171605"),
("2028","AR","POP","g","hist","r","uscb","3171605"),
("2029","AR","POP","g","hist","s","uscb","3190772"),
("2029","AR","POP","g","hist","r","uscb","3190772"),
("2030","AR","POP","g","hist","s","uscb","3210055"),
("2030","AR","POP","g","hist","r","uscb","3210055")
California
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","CA","POP","a","hist","s","uscb","39527808"),
("2020","CA","POP","a","hist","r","uscb","39527808"),
("2021","CA","POP","a","hist","s","uscb","39152927"),
("2021","CA","POP","a","hist","r","uscb","39152927"),
("2022","CA","POP","a","hist","s","uscb","39125347"),
("2022","CA","POP","a","hist","r","uscb","39125347"),
("2023","CA","POP","a","hist","s","uscb","39181667"),
("2023","CA","POP","a","hist","r","uscb","39181667"),
("2024","CA","POP","e","hist","s","uscb","39364774"),
("2024","CA","POP","e","hist","r","uscb","39364774"),
("2025","CA","POP","e","hist","s","uscb","39355309"),
("2025","CA","POP","e","hist","r","uscb","39355309"),
("2026","CA","POP","g","hist","s","uscb","39345846"),
("2026","CA","POP","g","hist","r","uscb","39345846"),
("2027","CA","POP","g","hist","s","uscb","39336385"),
("2027","CA","POP","g","hist","r","uscb","39336385"),
("2028","CA","POP","g","hist","s","uscb","39326927"),
("2028","CA","POP","g","hist","r","uscb","39326927"),
("2029","CA","POP","g","hist","s","uscb","39317471"),
("2029","CA","POP","g","hist","r","uscb","39317471"),
("2030","CA","POP","g","hist","s","uscb","39308018"),
("2030","CA","POP","g","hist","r","uscb","39308018")
Colorado
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","CO","POP","a","hist","s","uscb","5786873"),
("2020","CO","POP","a","hist","r","uscb","5786873"),
("2021","CO","POP","a","hist","s","uscb","5814368"),
("2021","CO","POP","a","hist","r","uscb","5814368"),
("2022","CO","POP","a","hist","s","uscb","5853355"),
("2022","CO","POP","a","hist","r","uscb","5853355"),
("2023","CO","POP","a","hist","s","uscb","5912240"),
("2023","CO","POP","a","hist","r","uscb","5912240"),
("2024","CO","POP","e","hist","s","uscb","5988502"),
("2024","CO","POP","e","hist","r","uscb","5988502"),
("2025","CO","POP","e","hist","s","uscb","6012561"),
("2025","CO","POP","e","hist","r","uscb","6012561"),
("2026","CO","POP","g","hist","s","uscb","6036716"),
("2026","CO","POP","g","hist","r","uscb","6036716"),
("2027","CO","POP","g","hist","s","uscb","6060969"),
("2027","CO","POP","g","hist","r","uscb","6060969"),
("2028","CO","POP","g","hist","s","uscb","6085319"),
("2028","CO","POP","g","hist","r","uscb","6085319"),
("2029","CO","POP","g","hist","s","uscb","6109767"),
("2029","CO","POP","g","hist","r","uscb","6109767"),
("2030","CO","POP","g","hist","s","uscb","6134313"),
("2030","CO","POP","g","hist","r","uscb","6134313")
Connecticut
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","CT","POP","a","hist","s","uscb","3579643"),
("2020","CT","POP","a","hist","r","uscb","3579643"),
("2021","CT","POP","a","hist","s","uscb","3607765"),
("2021","CT","POP","a","hist","r","uscb","3607765"),
("2022","CT","POP","a","hist","s","uscb","3618707"),
("2022","CT","POP","a","hist","r","uscb","3618707"),
("2023","CT","POP","a","hist","s","uscb","3641369"),
("2023","CT","POP","a","hist","r","uscb","3641369"),
("2024","CT","POP","e","hist","s","uscb","3674449"),
("2024","CT","POP","e","hist","r","uscb","3674449"),
("2025","CT","POP","e","hist","s","uscb","3688496"),
("2025","CT","POP","e","hist","r","uscb","3688496"),
("2026","CT","POP","g","hist","s","uscb","3702596"),
("2026","CT","POP","g","hist","r","uscb","3702596"),
("2027","CT","POP","g","hist","s","uscb","3716751"),
("2027","CT","POP","g","hist","r","uscb","3716751"),
("2028","CT","POP","g","hist","s","uscb","3730960"),
("2028","CT","POP","g","hist","r","uscb","3730960"),
("2029","CT","POP","g","hist","s","uscb","3745223"),
("2029","CT","POP","g","hist","r","uscb","3745223"),
("2030","CT","POP","g","hist","s","uscb","3759540"),
("2030","CT","POP","g","hist","r","uscb","3759540")
Delaware
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","DE","POP","a","hist","s","uscb","991890"),
("2020","DE","POP","a","hist","r","uscb","991890"),
("2021","DE","POP","a","hist","s","uscb","1005130"),
("2021","DE","POP","a","hist","r","uscb","1005130"),
("2022","DE","POP","a","hist","s","uscb","1020279"),
("2022","DE","POP","a","hist","r","uscb","1020279"),
("2023","DE","POP","a","hist","s","uscb","1035354"),
("2023","DE","POP","a","hist","r","uscb","1035354"),
("2024","DE","POP","e","hist","s","uscb","1050123"),
("2024","DE","POP","e","hist","r","uscb","1050123"),
("2025","DE","POP","e","hist","s","uscb","1059952"),
("2025","DE","POP","e","hist","r","uscb","1059952"),
("2026","DE","POP","g","hist","s","uscb","1069872"),
("2026","DE","POP","g","hist","r","uscb","1069872"),
("2027","DE","POP","g","hist","s","uscb","1079886"),
("2027","DE","POP","g","hist","r","uscb","1079886"),
("2028","DE","POP","g","hist","s","uscb","1089994"),
("2028","DE","POP","g","hist","r","uscb","1089994"),
("2029","DE","POP","g","hist","s","uscb","1100196"),
("2029","DE","POP","g","hist","r","uscb","1100196"),
("2030","DE","POP","g","hist","s","uscb","1110494"),
("2030","DE","POP","g","hist","r","uscb","1110494")
District of Columbia
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","DC","POP","a","hist","s","uscb","670958"),
("2020","DC","POP","a","hist","r","uscb","670958"),
("2021","DC","POP","a","hist","s","uscb","669637"),
("2021","DC","POP","a","hist","r","uscb","669637"),
("2022","DC","POP","a","hist","s","uscb","674501"),
("2022","DC","POP","a","hist","r","uscb","674501"),
("2023","DC","POP","a","hist","s","uscb","682559"),
("2023","DC","POP","a","hist","r","uscb","682559"),
("2024","DC","POP","e","hist","s","uscb","691310"),
("2024","DC","POP","e","hist","r","uscb","691310"),
("2025","DC","POP","e","hist","s","uscb","693645"),
("2025","DC","POP","e","hist","r","uscb","693645"),
("2026","DC","POP","g","hist","s","uscb","695987"),
("2026","DC","POP","g","hist","r","uscb","695987"),
("2027","DC","POP","g","hist","s","uscb","698338"),
("2027","DC","POP","g","hist","r","uscb","698338"),
("2028","DC","POP","g","hist","s","uscb","700697"),
("2028","DC","POP","g","hist","r","uscb","700697"),
("2029","DC","POP","g","hist","s","uscb","703064"),
("2029","DC","POP","g","hist","r","uscb","703064"),
("2030","DC","POP","g","hist","s","uscb","705438"),
("2030","DC","POP","g","hist","r","uscb","705438")
Florida
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","FL","POP","a","hist","s","uscb","21591325"),
("2020","FL","POP","a","hist","r","uscb","21591325"),
("2021","FL","POP","a","hist","s","uscb","21836698"),
("2021","FL","POP","a","hist","r","uscb","21836698"),
("2022","FL","POP","a","hist","s","uscb","22413989"),
("2022","FL","POP","a","hist","r","uscb","22413989"),
("2023","FL","POP","a","hist","s","uscb","22929248"),
("2023","FL","POP","a","hist","r","uscb","22929248"),
("2024","FL","POP","e","hist","s","uscb","23265838"),
("2024","FL","POP","e","hist","r","uscb","23265838"),
("2025","FL","POP","e","hist","s","uscb","23462518"),
("2025","FL","POP","e","hist","r","uscb","23462518"),
("2026","FL","POP","g","hist","s","uscb","23660860"),
("2026","FL","POP","g","hist","r","uscb","23660860"),
("2027","FL","POP","g","hist","s","uscb","23860880"),
("2027","FL","POP","g","hist","r","uscb","23860880"),
("2028","FL","POP","g","hist","s","uscb","24062590"),
("2028","FL","POP","g","hist","r","uscb","24062590"),
("2029","FL","POP","g","hist","s","uscb","24266005"),
("2029","FL","POP","g","hist","r","uscb","24266005"),
("2030","FL","POP","g","hist","s","uscb","24471140"),
("2030","FL","POP","g","hist","r","uscb","24471140")
Georgia
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","GA","POP","a","hist","s","uscb","10732595"),
("2020","GA","POP","a","hist","r","uscb","10732595"),
("2021","GA","POP","a","hist","s","uscb","10793038"),
("2021","GA","POP","a","hist","r","uscb","10793038"),
("2022","GA","POP","a","hist","s","uscb","10929992"),
("2022","GA","POP","a","hist","r","uscb","10929992"),
("2023","GA","POP","a","hist","s","uscb","11063669"),
("2023","GA","POP","a","hist","r","uscb","11063669"),
("2024","GA","POP","e","hist","s","uscb","11204208"),
("2024","GA","POP","e","hist","r","uscb","11204208"),
("2025","GA","POP","e","hist","s","uscb","11302748"),
("2025","GA","POP","e","hist","r","uscb","11302748"),
("2026","GA","POP","g","hist","s","uscb","11402154"),
("2026","GA","POP","g","hist","r","uscb","11402154"),
("2027","GA","POP","g","hist","s","uscb","11502435"),
("2027","GA","POP","g","hist","r","uscb","11502435"),
("2028","GA","POP","g","hist","s","uscb","11603598"),
("2028","GA","POP","g","hist","r","uscb","11603598"),
("2029","GA","POP","g","hist","s","uscb","11705651"),
("2029","GA","POP","g","hist","r","uscb","11705651"),
("2030","GA","POP","g","hist","s","uscb","11808601"),
("2030","GA","POP","g","hist","r","uscb","11808601")
Hawaii
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","HI","POP","a","hist","s","uscb","1451130"),
("2020","HI","POP","a","hist","r","uscb","1451130"),
("2021","HI","POP","a","hist","s","uscb","1446909"),
("2021","HI","POP","a","hist","r","uscb","1446909"),
("2022","HI","POP","a","hist","s","uscb","1437812"),
("2022","HI","POP","a","hist","r","uscb","1437812"),
("2023","HI","POP","a","hist","s","uscb","1434950"),
("2023","HI","POP","a","hist","r","uscb","1434950"),
("2024","HI","POP","e","hist","s","uscb","1434952"),
("2024","HI","POP","e","hist","r","uscb","1434952"),
("2025","HI","POP","e","hist","s","uscb","1432820"),
("2025","HI","POP","e","hist","r","uscb","1432820"),
("2026","HI","POP","g","hist","s","uscb","1430691"),
("2026","HI","POP","g","hist","r","uscb","1430691"),
("2027","HI","POP","g","hist","s","uscb","1428565"),
("2027","HI","POP","g","hist","r","uscb","1428565"),
("2028","HI","POP","g","hist","s","uscb","1426442"),
("2028","HI","POP","g","hist","r","uscb","1426442"),
("2029","HI","POP","g","hist","s","uscb","1424323"),
("2029","HI","POP","g","hist","r","uscb","1424323"),
("2030","HI","POP","g","hist","s","uscb","1422207"),
("2030","HI","POP","g","hist","r","uscb","1422207")
Idaho
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","ID","POP","a","hist","s","uscb","1849328"),
("2020","ID","POP","a","hist","r","uscb","1849328"),
("2021","ID","POP","a","hist","s","uscb","1904855"),
("2021","ID","POP","a","hist","r","uscb","1904855"),
("2022","ID","POP","a","hist","s","uscb","1942951"),
("2022","ID","POP","a","hist","r","uscb","1942951"),
("2023","ID","POP","a","hist","s","uscb","1970497"),
("2023","ID","POP","a","hist","r","uscb","1970497"),
("2024","ID","POP","e","hist","s","uscb","2000872"),
("2024","ID","POP","e","hist","r","uscb","2000872"),
("2025","ID","POP","e","hist","s","uscb","2029733"),
("2025","ID","POP","e","hist","r","uscb","2029733"),
("2026","ID","POP","g","hist","s","uscb","2059010"),
("2026","ID","POP","g","hist","r","uscb","2059010"),
("2027","ID","POP","g","hist","s","uscb","2088709"),
("2027","ID","POP","g","hist","r","uscb","2088709"),
("2028","ID","POP","g","hist","s","uscb","2118837"),
("2028","ID","POP","g","hist","r","uscb","2118837"),
("2029","ID","POP","g","hist","s","uscb","2149400"),
("2029","ID","POP","g","hist","r","uscb","2149400"),
("2030","ID","POP","g","hist","s","uscb","2180403"),
("2030","ID","POP","g","hist","r","uscb","2180403")
Illinois
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","IL","POP","a","hist","s","uscb","12795348"),
("2020","IL","POP","a","hist","r","uscb","12795348"),
("2021","IL","POP","a","hist","s","uscb","12703354"),
("2021","IL","POP","a","hist","r","uscb","12703354"),
("2022","IL","POP","a","hist","s","uscb","12609577"),
("2022","IL","POP","a","hist","r","uscb","12609577"),
("2023","IL","POP","a","hist","s","uscb","12633389"),
("2023","IL","POP","a","hist","r","uscb","12633389"),
("2024","IL","POP","e","hist","s","uscb","12703033"),
("2024","IL","POP","e","hist","r","uscb","12703033"),
("2025","IL","POP","e","hist","s","uscb","12719141"),
("2025","IL","POP","e","hist","r","uscb","12719141"),
("2026","IL","POP","g","hist","s","uscb","12735269"),
("2026","IL","POP","g","hist","r","uscb","12735269"),
("2027","IL","POP","g","hist","s","uscb","12751418"),
("2027","IL","POP","g","hist","r","uscb","12751418"),
("2028","IL","POP","g","hist","s","uscb","12767587"),
("2028","IL","POP","g","hist","r","uscb","12767587"),
("2029","IL","POP","g","hist","s","uscb","12783777"),
("2029","IL","POP","g","hist","r","uscb","12783777"),
("2030","IL","POP","g","hist","s","uscb","12799987"),
("2030","IL","POP","g","hist","r","uscb","12799987")
Indiana
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","IN","POP","a","hist","s","uscb","6790290"),
("2020","IN","POP","a","hist","r","uscb","6790290"),
("2021","IN","POP","a","hist","s","uscb","6814223"),
("2021","IN","POP","a","hist","r","uscb","6814223"),
("2022","IN","POP","a","hist","s","uscb","6841491"),
("2022","IN","POP","a","hist","r","uscb","6841491"),
("2023","IN","POP","a","hist","s","uscb","6881373"),
("2023","IN","POP","a","hist","r","uscb","6881373"),
("2024","IN","POP","e","hist","s","uscb","6934754"),
("2024","IN","POP","e","hist","r","uscb","6934754"),
("2025","IN","POP","e","hist","s","uscb","6973333"),
("2025","IN","POP","e","hist","r","uscb","6973333"),
("2026","IN","POP","g","hist","s","uscb","7012126"),
("2026","IN","POP","g","hist","r","uscb","7012126"),
("2027","IN","POP","g","hist","s","uscb","7051136"),
("2027","IN","POP","g","hist","r","uscb","7051136"),
("2028","IN","POP","g","hist","s","uscb","7090362"),
("2028","IN","POP","g","hist","r","uscb","7090362"),
("2029","IN","POP","g","hist","s","uscb","7129807"),
("2029","IN","POP","g","hist","r","uscb","7129807"),
("2030","IN","POP","g","hist","s","uscb","7169471"),
("2030","IN","POP","g","hist","r","uscb","7169471")
Iowa
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","IA","POP","a","hist","s","uscb","3191081"),
("2020","IA","POP","a","hist","r","uscb","3191081"),
("2021","IA","POP","a","hist","s","uscb","3199037"),
("2021","IA","POP","a","hist","r","uscb","3199037"),
("2022","IA","POP","a","hist","s","uscb","3201890"),
("2022","IA","POP","a","hist","r","uscb","3201890"),
("2023","IA","POP","a","hist","s","uscb","3214739"),
("2023","IA","POP","a","hist","r","uscb","3214739"),
("2024","IA","POP","e","hist","s","uscb","3230454"),
("2024","IA","POP","e","hist","r","uscb","3230454"),
("2025","IA","POP","e","hist","s","uscb","3238387"),
("2025","IA","POP","e","hist","r","uscb","3238387"),
("2026","IA","POP","g","hist","s","uscb","3246339"),
("2026","IA","POP","g","hist","r","uscb","3246339"),
("2027","IA","POP","g","hist","s","uscb","3254311"),
("2027","IA","POP","g","hist","r","uscb","3254311"),
("2028","IA","POP","g","hist","s","uscb","3262303"),
("2028","IA","POP","g","hist","r","uscb","3262303"),
("2029","IA","POP","g","hist","s","uscb","3270314"),
("2029","IA","POP","g","hist","r","uscb","3270314"),
("2030","IA","POP","g","hist","s","uscb","3278345"),
("2030","IA","POP","g","hist","r","uscb","3278345")
Kansas
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","KS","POP","a","hist","s","uscb","2938274"),
("2020","KS","POP","a","hist","r","uscb","2938274"),
("2021","KS","POP","a","hist","s","uscb","2938966"),
("2021","KS","POP","a","hist","r","uscb","2938966"),
("2022","KS","POP","a","hist","s","uscb","2938034"),
("2022","KS","POP","a","hist","r","uscb","2938034"),
("2023","KS","POP","a","hist","s","uscb","2949749"),
("2023","KS","POP","a","hist","r","uscb","2949749"),
("2024","KS","POP","e","hist","s","uscb","2965252"),
("2024","KS","POP","e","hist","r","uscb","2965252"),
("2025","KS","POP","e","hist","s","uscb","2977220"),
("2025","KS","POP","e","hist","r","uscb","2977220"),
("2026","KS","POP","g","hist","s","uscb","2989236"),
("2026","KS","POP","g","hist","r","uscb","2989236"),
("2027","KS","POP","g","hist","s","uscb","3001301"),
("2027","KS","POP","g","hist","r","uscb","3001301"),
("2028","KS","POP","g","hist","s","uscb","3013414"),
("2028","KS","POP","g","hist","r","uscb","3013414"),
("2029","KS","POP","g","hist","s","uscb","3025576"),
("2029","KS","POP","g","hist","r","uscb","3025576"),
("2030","KS","POP","g","hist","s","uscb","3037788"),
("2030","KS","POP","g","hist","r","uscb","3037788")
Kentucky
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","KY","POP","a","hist","s","uscb","4508271"),
("2020","KY","POP","a","hist","r","uscb","4508271"),
("2021","KY","POP","a","hist","s","uscb","4508348"),
("2021","KY","POP","a","hist","r","uscb","4508348"),
("2022","KY","POP","a","hist","s","uscb","4521238"),
("2022","KY","POP","a","hist","r","uscb","4521238"),
("2023","KY","POP","a","hist","s","uscb","4549953"),
("2023","KY","POP","a","hist","r","uscb","4549953"),
("2024","KY","POP","e","hist","s","uscb","4584046"),
("2024","KY","POP","e","hist","r","uscb","4584046"),
("2025","KY","POP","e","hist","s","uscb","4606864"),
("2025","KY","POP","e","hist","r","uscb","4606864"),
("2026","KY","POP","g","hist","s","uscb","4629795"),
("2026","KY","POP","g","hist","r","uscb","4629795"),
("2027","KY","POP","g","hist","s","uscb","4652841"),
("2027","KY","POP","g","hist","r","uscb","4652841"),
("2028","KY","POP","g","hist","s","uscb","4676001"),
("2028","KY","POP","g","hist","r","uscb","4676001"),
("2029","KY","POP","g","hist","s","uscb","4699277"),
("2029","KY","POP","g","hist","r","uscb","4699277"),
("2030","KY","POP","g","hist","s","uscb","4722669"),
("2030","KY","POP","g","hist","r","uscb","4722669")
Louisiana
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","LA","POP","a","hist","s","uscb","4652145"),
("2020","LA","POP","a","hist","r","uscb","4652145"),
("2021","LA","POP","a","hist","s","uscb","4628595"),
("2021","LA","POP","a","hist","r","uscb","4628595"),
("2022","LA","POP","a","hist","s","uscb","4600892"),
("2022","LA","POP","a","hist","r","uscb","4600892"),
("2023","LA","POP","a","hist","s","uscb","4598777"),
("2023","LA","POP","a","hist","r","uscb","4598777"),
("2024","LA","POP","e","hist","s","uscb","4614878"),
("2024","LA","POP","e","hist","r","uscb","4614878"),
("2025","LA","POP","e","hist","s","uscb","4618189"),
("2025","LA","POP","e","hist","r","uscb","4618189"),
("2026","LA","POP","g","hist","s","uscb","4621502"),
("2026","LA","POP","g","hist","r","uscb","4621502"),
("2027","LA","POP","g","hist","s","uscb","4624818"),
("2027","LA","POP","g","hist","r","uscb","4624818"),
("2028","LA","POP","g","hist","s","uscb","4628136"),
("2028","LA","POP","g","hist","r","uscb","4628136"),
("2029","LA","POP","g","hist","s","uscb","4631456"),
("2029","LA","POP","g","hist","r","uscb","4631456"),
("2030","LA","POP","g","hist","s","uscb","4634779"),
("2030","LA","POP","g","hist","r","uscb","4634779")
Maine
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","ME","POP","a","hist","s","uscb","1364546"),
("2020","ME","POP","a","hist","r","uscb","1364546"),
("2021","ME","POP","a","hist","s","uscb","1379009"),
("2021","ME","POP","a","hist","r","uscb","1379009"),
("2022","ME","POP","a","hist","s","uscb","1391585"),
("2022","ME","POP","a","hist","r","uscb","1391585"),
("2023","ME","POP","a","hist","s","uscb","1401992"),
("2023","ME","POP","a","hist","r","uscb","1401992"),
("2024","ME","POP","e","hist","s","uscb","1408438"),
("2024","ME","POP","e","hist","r","uscb","1408438"),
("2025","ME","POP","e","hist","s","uscb","1414874"),
("2025","ME","POP","e","hist","r","uscb","1414874"),
("2026","ME","POP","g","hist","s","uscb","1421339"),
("2026","ME","POP","g","hist","r","uscb","1421339"),
("2027","ME","POP","g","hist","s","uscb","1427834"),
("2027","ME","POP","g","hist","r","uscb","1427834"),
("2028","ME","POP","g","hist","s","uscb","1434358"),
("2028","ME","POP","g","hist","r","uscb","1434358"),
("2029","ME","POP","g","hist","s","uscb","1440913"),
("2029","ME","POP","g","hist","r","uscb","1440913"),
("2030","ME","POP","g","hist","s","uscb","1447497"),
("2030","ME","POP","g","hist","r","uscb","1447497")
Maryland
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MD","POP","a","hist","s","uscb","6178387"),
("2020","MD","POP","a","hist","r","uscb","6178387"),
("2021","MD","POP","a","hist","s","uscb","6176035"),
("2021","MD","POP","a","hist","r","uscb","6176035"),
("2022","MD","POP","a","hist","s","uscb","6183257"),
("2022","MD","POP","a","hist","r","uscb","6183257"),
("2023","MD","POP","a","hist","s","uscb","6204927"),
("2023","MD","POP","a","hist","r","uscb","6204927"),
("2024","MD","POP","e","hist","s","uscb","6245314"),
("2024","MD","POP","e","hist","r","uscb","6245314"),
("2025","MD","POP","e","hist","s","uscb","6265347"),
("2025","MD","POP","e","hist","r","uscb","6265347"),
("2026","MD","POP","g","hist","s","uscb","6285444"),
("2026","MD","POP","g","hist","r","uscb","6285444"),
("2027","MD","POP","g","hist","s","uscb","6305605"),
("2027","MD","POP","g","hist","r","uscb","6305605"),
("2028","MD","POP","g","hist","s","uscb","6325832"),
("2028","MD","POP","g","hist","r","uscb","6325832"),
("2029","MD","POP","g","hist","s","uscb","6346123"),
("2029","MD","POP","g","hist","r","uscb","6346123"),
("2030","MD","POP","g","hist","s","uscb","6366480"),
("2030","MD","POP","g","hist","r","uscb","6366480")
Massachusetts
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MA","POP","a","hist","s","uscb","6985320"),
("2020","MA","POP","a","hist","r","uscb","6985320"),
("2021","MA","POP","a","hist","s","uscb","6996721"),
("2021","MA","POP","a","hist","r","uscb","6996721"),
("2022","MA","POP","a","hist","s","uscb","7025465"),
("2022","MA","POP","a","hist","r","uscb","7025465"),
("2023","MA","POP","a","hist","s","uscb","7073479"),
("2023","MA","POP","a","hist","r","uscb","7073479"),
("2024","MA","POP","e","hist","s","uscb","7138560"),
("2024","MA","POP","e","hist","r","uscb","7138560"),
("2025","MA","POP","e","hist","s","uscb","7154084"),
("2025","MA","POP","e","hist","r","uscb","7154084"),
("2026","MA","POP","g","hist","s","uscb","7169641"),
("2026","MA","POP","g","hist","r","uscb","7169641"),
("2027","MA","POP","g","hist","s","uscb","7185233"),
("2027","MA","POP","g","hist","r","uscb","7185233"),
("2028","MA","POP","g","hist","s","uscb","7200858"),
("2028","MA","POP","g","hist","r","uscb","7200858"),
("2029","MA","POP","g","hist","s","uscb","7216518"),
("2029","MA","POP","g","hist","r","uscb","7216518"),
("2030","MA","POP","g","hist","s","uscb","7232211"),
("2030","MA","POP","g","hist","r","uscb","7232211")
Michigan
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MI","POP","a","hist","s","uscb","10072294"),
("2020","MI","POP","a","hist","r","uscb","10072294"),
("2021","MI","POP","a","hist","s","uscb","10042362"),
("2021","MI","POP","a","hist","r","uscb","10042362"),
("2022","MI","POP","a","hist","s","uscb","10043906"),
("2022","MI","POP","a","hist","r","uscb","10043906"),
("2023","MI","POP","a","hist","s","uscb","10062124"),
("2023","MI","POP","a","hist","r","uscb","10062124"),
("2024","MI","POP","e","hist","s","uscb","10099962"),
("2024","MI","POP","e","hist","r","uscb","10099962"),
("2025","MI","POP","e","hist","s","uscb","10127884"),
("2025","MI","POP","e","hist","r","uscb","10127884"),
("2026","MI","POP","g","hist","s","uscb","10155883"),
("2026","MI","POP","g","hist","r","uscb","10155883"),
("2027","MI","POP","g","hist","s","uscb","10183959"),
("2027","MI","POP","g","hist","r","uscb","10183959"),
("2028","MI","POP","g","hist","s","uscb","10212114"),
("2028","MI","POP","g","hist","r","uscb","10212114"),
("2029","MI","POP","g","hist","s","uscb","10240346"),
("2029","MI","POP","g","hist","r","uscb","10240346"),
("2030","MI","POP","g","hist","s","uscb","10268656"),
("2030","MI","POP","g","hist","r","uscb","10268656")
Minnesota
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MN","POP","a","hist","s","uscb","5710562"),
("2020","MN","POP","a","hist","r","uscb","5710562"),
("2021","MN","POP","a","hist","s","uscb","5714055"),
("2021","MN","POP","a","hist","r","uscb","5714055"),
("2022","MN","POP","a","hist","s","uscb","5727565"),
("2022","MN","POP","a","hist","r","uscb","5727565"),
("2023","MN","POP","a","hist","s","uscb","5752998"),
("2023","MN","POP","a","hist","r","uscb","5752998"),
("2024","MN","POP","e","hist","s","uscb","5797405"),
("2024","MN","POP","e","hist","r","uscb","5797405"),
("2025","MN","POP","e","hist","s","uscb","5830405"),
("2025","MN","POP","e","hist","r","uscb","5830405"),
("2026","MN","POP","g","hist","s","uscb","5863592"),
("2026","MN","POP","g","hist","r","uscb","5863592"),
("2027","MN","POP","g","hist","s","uscb","5896969"),
("2027","MN","POP","g","hist","r","uscb","5896969"),
("2028","MN","POP","g","hist","s","uscb","5930536"),
("2028","MN","POP","g","hist","r","uscb","5930536"),
("2029","MN","POP","g","hist","s","uscb","5964294"),
("2029","MN","POP","g","hist","r","uscb","5964294"),
("2030","MN","POP","g","hist","s","uscb","5998244"),
("2030","MN","POP","g","hist","r","uscb","5998244")
Mississippi
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MS","POP","a","hist","s","uscb","2958385"),
("2020","MS","POP","a","hist","r","uscb","2958385"),
("2021","MS","POP","a","hist","s","uscb","2947603"),
("2021","MS","POP","a","hist","r","uscb","2947603"),
("2022","MS","POP","a","hist","s","uscb","2941237"),
("2022","MS","POP","a","hist","r","uscb","2941237"),
("2023","MS","POP","a","hist","s","uscb","2942470"),
("2023","MS","POP","a","hist","r","uscb","2942470"),
("2024","MS","POP","e","hist","s","uscb","2950172"),
("2024","MS","POP","e","hist","r","uscb","2950172"),
("2025","MS","POP","e","hist","s","uscb","2954160"),
("2025","MS","POP","e","hist","r","uscb","2954160"),
("2026","MS","POP","g","hist","s","uscb","2958153"),
("2026","MS","POP","g","hist","r","uscb","2958153"),
("2027","MS","POP","g","hist","s","uscb","2962152"),
("2027","MS","POP","g","hist","r","uscb","2962152"),
("2028","MS","POP","g","hist","s","uscb","2966156"),
("2028","MS","POP","g","hist","r","uscb","2966156"),
("2029","MS","POP","g","hist","s","uscb","2970165"),
("2029","MS","POP","g","hist","r","uscb","2970165"),
("2030","MS","POP","g","hist","s","uscb","2974181"),
("2030","MS","POP","g","hist","r","uscb","2974181")
Missouri
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MO","POP","a","hist","s","uscb","6155074"),
("2020","MO","POP","a","hist","r","uscb","6155074"),
("2021","MO","POP","a","hist","s","uscb","6172551"),
("2021","MO","POP","a","hist","r","uscb","6172551"),
("2022","MO","POP","a","hist","s","uscb","6179285"),
("2022","MO","POP","a","hist","r","uscb","6179285"),
("2023","MO","POP","a","hist","s","uscb","6205956"),
("2023","MO","POP","a","hist","r","uscb","6205956"),
("2024","MO","POP","e","hist","s","uscb","6243544"),
("2024","MO","POP","e","hist","r","uscb","6243544"),
("2025","MO","POP","e","hist","s","uscb","6270541"),
("2025","MO","POP","e","hist","r","uscb","6270541"),
("2026","MO","POP","g","hist","s","uscb","6297654"),
("2026","MO","POP","g","hist","r","uscb","6297654"),
("2027","MO","POP","g","hist","s","uscb","6324885"),
("2027","MO","POP","g","hist","r","uscb","6324885"),
("2028","MO","POP","g","hist","s","uscb","6352234"),
("2028","MO","POP","g","hist","r","uscb","6352234"),
("2029","MO","POP","g","hist","s","uscb","6379701"),
("2029","MO","POP","g","hist","r","uscb","6379701"),
("2030","MO","POP","g","hist","s","uscb","6407287"),
("2030","MO","POP","g","hist","r","uscb","6407287")
Montana
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","MT","POP","a","hist","s","uscb","1087156"),
("2020","MT","POP","a","hist","r","uscb","1087156"),
("2021","MT","POP","a","hist","s","uscb","1106416"),
("2021","MT","POP","a","hist","r","uscb","1106416"),
("2022","MT","POP","a","hist","s","uscb","1121533"),
("2022","MT","POP","a","hist","r","uscb","1121533"),
("2023","MT","POP","a","hist","s","uscb","1130612"),
("2023","MT","POP","a","hist","r","uscb","1130612"),
("2024","MT","POP","e","hist","s","uscb","1137557"),
("2024","MT","POP","e","hist","r","uscb","1137557"),
("2025","MT","POP","e","hist","s","uscb","1144694"),
("2025","MT","POP","e","hist","r","uscb","1144694"),
("2026","MT","POP","g","hist","s","uscb","1151875"),
("2026","MT","POP","g","hist","r","uscb","1151875"),
("2027","MT","POP","g","hist","s","uscb","1159102"),
("2027","MT","POP","g","hist","r","uscb","1159102"),
("2028","MT","POP","g","hist","s","uscb","1166374"),
("2028","MT","POP","g","hist","r","uscb","1166374"),
("2029","MT","POP","g","hist","s","uscb","1173692"),
("2029","MT","POP","g","hist","r","uscb","1173692"),
("2030","MT","POP","g","hist","s","uscb","1181056"),
("2030","MT","POP","g","hist","r","uscb","1181056")
Nebraska
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NE","POP","a","hist","s","uscb","1963318"),
("2020","NE","POP","a","hist","r","uscb","1963318"),
("2021","NE","POP","a","hist","s","uscb","1964697"),
("2021","NE","POP","a","hist","r","uscb","1964697"),
("2022","NE","POP","a","hist","s","uscb","1972595"),
("2022","NE","POP","a","hist","r","uscb","1972595"),
("2023","NE","POP","a","hist","s","uscb","1988172"),
("2023","NE","POP","a","hist","r","uscb","1988172"),
("2024","NE","POP","e","hist","s","uscb","2005591"),
("2024","NE","POP","e","hist","r","uscb","2005591"),
("2025","NE","POP","e","hist","s","uscb","2018006"),
("2025","NE","POP","e","hist","r","uscb","2018006"),
("2026","NE","POP","g","hist","s","uscb","2030497"),
("2026","NE","POP","g","hist","r","uscb","2030497"),
("2027","NE","POP","g","hist","s","uscb","2043067"),
("2027","NE","POP","g","hist","r","uscb","2043067"),
("2028","NE","POP","g","hist","s","uscb","2055714"),
("2028","NE","POP","g","hist","r","uscb","2055714"),
("2029","NE","POP","g","hist","s","uscb","2068439"),
("2029","NE","POP","g","hist","r","uscb","2068439"),
("2030","NE","POP","g","hist","s","uscb","2081243"),
("2030","NE","POP","g","hist","r","uscb","2081243")
Nevada
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NV","POP","a","hist","s","uscb","3116851"),
("2020","NV","POP","a","hist","r","uscb","3116851"),
("2021","NV","POP","a","hist","s","uscb","3148472"),
("2021","NV","POP","a","hist","r","uscb","3148472"),
("2022","NV","POP","a","hist","s","uscb","3177672"),
("2022","NV","POP","a","hist","r","uscb","3177672"),
("2023","NV","POP","a","hist","s","uscb","3211077"),
("2023","NV","POP","a","hist","r","uscb","3211077"),
("2024","NV","POP","e","hist","s","uscb","3253543"),
("2024","NV","POP","e","hist","r","uscb","3253543"),
("2025","NV","POP","e","hist","s","uscb","3282188"),
("2025","NV","POP","e","hist","r","uscb","3282188"),
("2026","NV","POP","g","hist","s","uscb","3311085"),
("2026","NV","POP","g","hist","r","uscb","3311085"),
("2027","NV","POP","g","hist","s","uscb","3340236"),
("2027","NV","POP","g","hist","r","uscb","3340236"),
("2028","NV","POP","g","hist","s","uscb","3369645"),
("2028","NV","POP","g","hist","r","uscb","3369645"),
("2029","NV","POP","g","hist","s","uscb","3399312"),
("2029","NV","POP","g","hist","r","uscb","3399312"),
("2030","NV","POP","g","hist","s","uscb","3429240"),
("2030","NV","POP","g","hist","r","uscb","3429240")
New Hampshire
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NH","POP","a","hist","s","uscb","1378752"),
("2020","NH","POP","a","hist","r","uscb","1378752"),
("2021","NH","POP","a","hist","s","uscb","1387907"),
("2021","NH","POP","a","hist","r","uscb","1387907"),
("2022","NH","POP","a","hist","s","uscb","1396647"),
("2022","NH","POP","a","hist","r","uscb","1396647"),
("2023","NH","POP","a","hist","s","uscb","1401530"),
("2023","NH","POP","a","hist","r","uscb","1401530"),
("2024","NH","POP","e","hist","s","uscb","1408518"),
("2024","NH","POP","e","hist","r","uscb","1408518"),
("2025","NH","POP","e","hist","s","uscb","1415342"),
("2025","NH","POP","e","hist","r","uscb","1415342"),
("2026","NH","POP","g","hist","s","uscb","1422199"),
("2026","NH","POP","g","hist","r","uscb","1422199"),
("2027","NH","POP","g","hist","s","uscb","1429089"),
("2027","NH","POP","g","hist","r","uscb","1429089"),
("2028","NH","POP","g","hist","s","uscb","1436013"),
("2028","NH","POP","g","hist","r","uscb","1436013"),
("2029","NH","POP","g","hist","s","uscb","1442970"),
("2029","NH","POP","g","hist","r","uscb","1442970"),
("2030","NH","POP","g","hist","s","uscb","1449961"),
("2030","NH","POP","g","hist","r","uscb","1449961")
New Jersey
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NJ","POP","a","hist","s","uscb","9270476"),
("2020","NJ","POP","a","hist","r","uscb","9270476"),
("2021","NJ","POP","a","hist","s","uscb","9266509"),
("2021","NJ","POP","a","hist","r","uscb","9266509"),
("2022","NJ","POP","a","hist","s","uscb","9298402"),
("2022","NJ","POP","a","hist","r","uscb","9298402"),
("2023","NJ","POP","a","hist","s","uscb","9395315"),
("2023","NJ","POP","a","hist","r","uscb","9395315"),
("2024","NJ","POP","e","hist","s","uscb","9506354"),
("2024","NJ","POP","e","hist","r","uscb","9506354"),
("2025","NJ","POP","e","hist","s","uscb","9548215"),
("2025","NJ","POP","e","hist","r","uscb","9548215"),
("2026","NJ","POP","g","hist","s","uscb","9590260"),
("2026","NJ","POP","g","hist","r","uscb","9590260"),
("2027","NJ","POP","g","hist","s","uscb","9632490"),
("2027","NJ","POP","g","hist","r","uscb","9632490"),
("2028","NJ","POP","g","hist","s","uscb","9674907"),
("2028","NJ","POP","g","hist","r","uscb","9674907"),
("2029","NJ","POP","g","hist","s","uscb","9717510"),
("2029","NJ","POP","g","hist","r","uscb","9717510"),
("2030","NJ","POP","g","hist","s","uscb","9760301"),
("2030","NJ","POP","g","hist","r","uscb","9760301")
New Mexico
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NM","POP","a","hist","s","uscb","2118446"),
("2020","NM","POP","a","hist","r","uscb","2118446"),
("2021","NM","POP","a","hist","s","uscb","2117300"),
("2021","NM","POP","a","hist","r","uscb","2117300"),
("2022","NM","POP","a","hist","s","uscb","2112859"),
("2022","NM","POP","a","hist","r","uscb","2112859"),
("2023","NM","POP","a","hist","s","uscb","2119349"),
("2023","NM","POP","a","hist","r","uscb","2119349"),
("2024","NM","POP","e","hist","s","uscb","2126774"),
("2024","NM","POP","e","hist","r","uscb","2126774"),
("2025","NM","POP","e","hist","s","uscb","2125498"),
("2025","NM","POP","e","hist","r","uscb","2125498"),
("2026","NM","POP","g","hist","s","uscb","2124222"),
("2026","NM","POP","g","hist","r","uscb","2124222"),
("2027","NM","POP","g","hist","s","uscb","2122948"),
("2027","NM","POP","g","hist","r","uscb","2122948"),
("2028","NM","POP","g","hist","s","uscb","2121674"),
("2028","NM","POP","g","hist","r","uscb","2121674"),
("2029","NM","POP","g","hist","s","uscb","2120401"),
("2029","NM","POP","g","hist","r","uscb","2120401"),
("2030","NM","POP","g","hist","s","uscb","2119129"),
("2030","NM","POP","g","hist","r","uscb","2119129")
New York
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NY","POP","a","hist","s","uscb","20122262"),
("2020","NY","POP","a","hist","r","uscb","20122262"),
("2021","NY","POP","a","hist","s","uscb","19835345"),
("2021","NY","POP","a","hist","r","uscb","19835345"),
("2022","NY","POP","a","hist","s","uscb","19713025"),
("2022","NY","POP","a","hist","r","uscb","19713025"),
("2023","NY","POP","a","hist","s","uscb","19786543"),
("2023","NY","POP","a","hist","r","uscb","19786543"),
("2024","NY","POP","e","hist","s","uscb","20001419"),
("2024","NY","POP","e","hist","r","uscb","20001419"),
("2025","NY","POP","e","hist","s","uscb","20002427"),
("2025","NY","POP","e","hist","r","uscb","20002427"),
("2026","NY","POP","g","hist","s","uscb","20003435"),
("2026","NY","POP","g","hist","r","uscb","20003435"),
("2027","NY","POP","g","hist","s","uscb","20004443"),
("2027","NY","POP","g","hist","r","uscb","20004443"),
("2028","NY","POP","g","hist","s","uscb","20005451"),
("2028","NY","POP","g","hist","r","uscb","20005451"),
("2029","NY","POP","g","hist","s","uscb","20006459"),
("2029","NY","POP","g","hist","r","uscb","20006459"),
("2030","NY","POP","g","hist","s","uscb","20007467"),
("2030","NY","POP","g","hist","r","uscb","20007467")
North Carolina
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","NC","POP","a","hist","s","uscb","10450215"),
("2020","NC","POP","a","hist","r","uscb","10450215"),
("2021","NC","POP","a","hist","s","uscb","10565503"),
("2021","NC","POP","a","hist","r","uscb","10565503"),
("2022","NC","POP","a","hist","s","uscb","10705768"),
("2022","NC","POP","a","hist","r","uscb","10705768"),
("2023","NC","POP","a","hist","s","uscb","10871849"),
("2023","NC","POP","a","hist","r","uscb","10871849"),
("2024","NC","POP","e","hist","s","uscb","11052061"),
("2024","NC","POP","e","hist","r","uscb","11052061"),
("2025","NC","POP","e","hist","s","uscb","11197968"),
("2025","NC","POP","e","hist","r","uscb","11197968"),
("2026","NC","POP","g","hist","s","uscb","11345801"),
("2026","NC","POP","g","hist","r","uscb","11345801"),
("2027","NC","POP","g","hist","s","uscb","11495586"),
("2027","NC","POP","g","hist","r","uscb","11495586"),
("2028","NC","POP","g","hist","s","uscb","11647348"),
("2028","NC","POP","g","hist","r","uscb","11647348"),
("2029","NC","POP","g","hist","s","uscb","11801114"),
("2029","NC","POP","g","hist","r","uscb","11801114"),
("2030","NC","POP","g","hist","s","uscb","11956910"),
("2030","NC","POP","g","hist","r","uscb","11956910")
North Dakota
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","ND","POP","a","hist","s","uscb","779612"),
("2020","ND","POP","a","hist","r","uscb","779612"),
("2021","ND","POP","a","hist","s","uscb","777977"),
("2021","ND","POP","a","hist","r","uscb","777977"),
("2022","ND","POP","a","hist","s","uscb","780191"),
("2022","ND","POP","a","hist","r","uscb","780191"),
("2023","ND","POP","a","hist","s","uscb","787071"),
("2023","ND","POP","a","hist","r","uscb","787071"),
("2024","ND","POP","e","hist","s","uscb","793387"),
("2024","ND","POP","e","hist","r","uscb","793387"),
("2025","ND","POP","e","hist","s","uscb","799358"),
("2025","ND","POP","e","hist","r","uscb","799358"),
("2026","ND","POP","g","hist","s","uscb","805373"),
("2026","ND","POP","g","hist","r","uscb","805373"),
("2027","ND","POP","g","hist","s","uscb","811435"),
("2027","ND","POP","g","hist","r","uscb","811435"),
("2028","ND","POP","g","hist","s","uscb","817541"),
("2028","ND","POP","g","hist","r","uscb","817541"),
("2029","ND","POP","g","hist","s","uscb","823694"),
("2029","ND","POP","g","hist","r","uscb","823694"),
("2030","ND","POP","g","hist","s","uscb","829893"),
("2030","ND","POP","g","hist","r","uscb","829893")
Ohio
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","OH","POP","a","hist","s","uscb","11798534"),
("2020","OH","POP","a","hist","r","uscb","11798534"),
("2021","OH","POP","a","hist","s","uscb","11761443"),
("2021","OH","POP","a","hist","r","uscb","11761443"),
("2022","OH","POP","a","hist","s","uscb","11764950"),
("2022","OH","POP","a","hist","r","uscb","11764950"),
("2023","OH","POP","a","hist","s","uscb","11808390"),
("2023","OH","POP","a","hist","r","uscb","11808390"),
("2024","OH","POP","e","hist","s","uscb","11860621"),
("2024","OH","POP","e","hist","r","uscb","11860621"),
("2025","OH","POP","e","hist","s","uscb","11900510"),
("2025","OH","POP","e","hist","r","uscb","11900510"),
("2026","OH","POP","g","hist","s","uscb","11940533"),
("2026","OH","POP","g","hist","r","uscb","11940533"),
("2027","OH","POP","g","hist","s","uscb","11980690"),
("2027","OH","POP","g","hist","r","uscb","11980690"),
("2028","OH","POP","g","hist","s","uscb","12020983"),
("2028","OH","POP","g","hist","r","uscb","12020983"),
("2029","OH","POP","g","hist","s","uscb","12061412"),
("2029","OH","POP","g","hist","r","uscb","12061412"),
("2030","OH","POP","g","hist","s","uscb","12101976"),
("2030","OH","POP","g","hist","r","uscb","12101976")
Oklahoma
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","OK","POP","a","hist","s","uscb","3965243"),
("2020","OK","POP","a","hist","r","uscb","3965243"),
("2021","OK","POP","a","hist","s","uscb","3992760"),
("2021","OK","POP","a","hist","r","uscb","3992760"),
("2022","OK","POP","a","hist","s","uscb","4025327"),
("2022","OK","POP","a","hist","r","uscb","4025327"),
("2023","OK","POP","a","hist","s","uscb","4062716"),
("2023","OK","POP","a","hist","r","uscb","4062716"),
("2024","OK","POP","e","hist","s","uscb","4097758"),
("2024","OK","POP","e","hist","r","uscb","4097758"),
("2025","OK","POP","e","hist","s","uscb","4123288"),
("2025","OK","POP","e","hist","r","uscb","4123288"),
("2026","OK","POP","g","hist","s","uscb","4148977"),
("2026","OK","POP","g","hist","r","uscb","4148977"),
("2027","OK","POP","g","hist","s","uscb","4174826"),
("2027","OK","POP","g","hist","r","uscb","4174826"),
("2028","OK","POP","g","hist","s","uscb","4200836"),
("2028","OK","POP","g","hist","r","uscb","4200836"),
("2029","OK","POP","g","hist","s","uscb","4227008"),
("2029","OK","POP","g","hist","r","uscb","4227008"),
("2030","OK","POP","g","hist","s","uscb","4253343"),
("2030","OK","POP","g","hist","r","uscb","4253343")
Oregon
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","OR","POP","a","hist","s","uscb","4243544"),
("2020","OR","POP","a","hist","r","uscb","4243544"),
("2021","OR","POP","a","hist","s","uscb","4254691"),
("2021","OR","POP","a","hist","r","uscb","4254691"),
("2022","OR","POP","a","hist","s","uscb","4245964"),
("2022","OR","POP","a","hist","r","uscb","4245964"),
("2023","OR","POP","a","hist","s","uscb","4250392"),
("2023","OR","POP","a","hist","r","uscb","4250392"),
("2024","OR","POP","e","hist","s","uscb","4265324"),
("2024","OR","POP","e","hist","r","uscb","4265324"),
("2025","OR","POP","e","hist","s","uscb","4273586"),
("2025","OR","POP","e","hist","r","uscb","4273586"),
("2026","OR","POP","g","hist","s","uscb","4281864"),
("2026","OR","POP","g","hist","r","uscb","4281864"),
("2027","OR","POP","g","hist","s","uscb","4290158"),
("2027","OR","POP","g","hist","r","uscb","4290158"),
("2028","OR","POP","g","hist","s","uscb","4298468"),
("2028","OR","POP","g","hist","r","uscb","4298468"),
("2029","OR","POP","g","hist","s","uscb","4306794"),
("2029","OR","POP","g","hist","r","uscb","4306794"),
("2030","OR","POP","g","hist","s","uscb","4315136"),
("2030","OR","POP","g","hist","r","uscb","4315136")
Pennsylvania
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","PA","POP","a","hist","s","uscb","12995576"),
("2020","PA","POP","a","hist","r","uscb","12995576"),
("2021","PA","POP","a","hist","s","uscb","13016628"),
("2021","PA","POP","a","hist","r","uscb","13016628"),
("2022","PA","POP","a","hist","s","uscb","12984655"),
("2022","PA","POP","a","hist","r","uscb","12984655"),
("2023","PA","POP","a","hist","s","uscb","13009406"),
("2023","PA","POP","a","hist","r","uscb","13009406"),
("2024","PA","POP","e","hist","s","uscb","13045848"),
("2024","PA","POP","e","hist","r","uscb","13045848"),
("2025","PA","POP","e","hist","s","uscb","13059432"),
("2025","PA","POP","e","hist","r","uscb","13059432"),
("2026","PA","POP","g","hist","s","uscb","13073030"),
("2026","PA","POP","g","hist","r","uscb","13073030"),
("2027","PA","POP","g","hist","s","uscb","13086642"),
("2027","PA","POP","g","hist","r","uscb","13086642"),
("2028","PA","POP","g","hist","s","uscb","13100268"),
("2028","PA","POP","g","hist","r","uscb","13100268"),
("2029","PA","POP","g","hist","s","uscb","13113909"),
("2029","PA","POP","g","hist","r","uscb","13113909"),
("2030","PA","POP","g","hist","s","uscb","13127564"),
("2030","PA","POP","g","hist","r","uscb","13127564")
Rhode Island
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","RI","POP","a","hist","s","uscb","1096487"),
("2020","RI","POP","a","hist","r","uscb","1096487"),
("2021","RI","POP","a","hist","s","uscb","1097381"),
("2021","RI","POP","a","hist","r","uscb","1097381"),
("2022","RI","POP","a","hist","s","uscb","1098275"),
("2022","RI","POP","a","hist","r","uscb","1098275"),
("2023","RI","POP","a","hist","s","uscb","1101183"),
("2023","RI","POP","a","hist","r","uscb","1101183"),
("2024","RI","POP","e","hist","s","uscb","1110415"),
("2024","RI","POP","e","hist","r","uscb","1110415"),
("2025","RI","POP","e","hist","s","uscb","1114521"),
("2025","RI","POP","e","hist","r","uscb","1114521"),
("2026","RI","POP","g","hist","s","uscb","1118642"),
("2026","RI","POP","g","hist","r","uscb","1118642"),
("2027","RI","POP","g","hist","s","uscb","1122778"),
("2027","RI","POP","g","hist","r","uscb","1122778"),
("2028","RI","POP","g","hist","s","uscb","1126930"),
("2028","RI","POP","g","hist","r","uscb","1126930"),
("2029","RI","POP","g","hist","s","uscb","1131097"),
("2029","RI","POP","g","hist","r","uscb","1131097"),
("2030","RI","POP","g","hist","s","uscb","1135279"),
("2030","RI","POP","g","hist","r","uscb","1135279")
South Carolina
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","SC","POP","a","hist","s","uscb","5131992"),
("2020","SC","POP","a","hist","r","uscb","5131992"),
("2021","SC","POP","a","hist","s","uscb","5194346"),
("2021","SC","POP","a","hist","r","uscb","5194346"),
("2022","SC","POP","a","hist","s","uscb","5288957"),
("2022","SC","POP","a","hist","r","uscb","5288957"),
("2023","SC","POP","a","hist","s","uscb","5390798"),
("2023","SC","POP","a","hist","r","uscb","5390798"),
("2024","SC","POP","e","hist","s","uscb","5490316"),
("2024","SC","POP","e","hist","r","uscb","5490316"),
("2025","SC","POP","e","hist","s","uscb","5570274"),
("2025","SC","POP","e","hist","r","uscb","5570274"),
("2026","SC","POP","g","hist","s","uscb","5651396"),
("2026","SC","POP","g","hist","r","uscb","5651396"),
("2027","SC","POP","g","hist","s","uscb","5733700"),
("2027","SC","POP","g","hist","r","uscb","5733700"),
("2028","SC","POP","g","hist","s","uscb","5817202"),
("2028","SC","POP","g","hist","r","uscb","5817202"),
("2029","SC","POP","g","hist","s","uscb","5901921"),
("2029","SC","POP","g","hist","r","uscb","5901921"),
("2030","SC","POP","g","hist","s","uscb","5987873"),
("2030","SC","POP","g","hist","r","uscb","5987873")
South Dakota
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","SD","POP","a","hist","s","uscb","887808"),
("2020","SD","POP","a","hist","r","uscb","887808"),
("2021","SD","POP","a","hist","s","uscb","896303"),
("2021","SD","POP","a","hist","r","uscb","896303"),
("2022","SD","POP","a","hist","s","uscb","909156"),
("2022","SD","POP","a","hist","r","uscb","909156"),
("2023","SD","POP","a","hist","s","uscb","917739"),
("2023","SD","POP","a","hist","r","uscb","917739"),
("2024","SD","POP","e","hist","s","uscb","927110"),
("2024","SD","POP","e","hist","r","uscb","927110"),
("2025","SD","POP","e","hist","s","uscb","935094"),
("2025","SD","POP","e","hist","r","uscb","935094"),
("2026","SD","POP","g","hist","s","uscb","943146"),
("2026","SD","POP","g","hist","r","uscb","943146"),
("2027","SD","POP","g","hist","s","uscb","951268"),
("2027","SD","POP","g","hist","r","uscb","951268"),
("2028","SD","POP","g","hist","s","uscb","959460"),
("2028","SD","POP","g","hist","r","uscb","959460"),
("2029","SD","POP","g","hist","s","uscb","967723"),
("2029","SD","POP","g","hist","r","uscb","967723"),
("2030","SD","POP","g","hist","s","uscb","976057"),
("2030","SD","POP","g","hist","r","uscb","976057")
Tennessee
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","TN","POP","a","hist","s","uscb","6927736"),
("2020","TN","POP","a","hist","r","uscb","6927736"),
("2021","TN","POP","a","hist","s","uscb","6966687"),
("2021","TN","POP","a","hist","r","uscb","6966687"),
("2022","TN","POP","a","hist","s","uscb","7063325"),
("2022","TN","POP","a","hist","r","uscb","7063325"),
("2023","TN","POP","a","hist","s","uscb","7153029"),
("2023","TN","POP","a","hist","r","uscb","7153029"),
("2024","TN","POP","e","hist","s","uscb","7251291"),
("2024","TN","POP","e","hist","r","uscb","7251291"),
("2025","TN","POP","e","hist","s","uscb","7315076"),
("2025","TN","POP","e","hist","r","uscb","7315076"),
("2026","TN","POP","g","hist","s","uscb","7379422"),
("2026","TN","POP","g","hist","r","uscb","7379422"),
("2027","TN","POP","g","hist","s","uscb","7444334"),
("2027","TN","POP","g","hist","r","uscb","7444334"),
("2028","TN","POP","g","hist","s","uscb","7509817"),
("2028","TN","POP","g","hist","r","uscb","7509817"),
("2029","TN","POP","g","hist","s","uscb","7575876"),
("2029","TN","POP","g","hist","r","uscb","7575876"),
("2030","TN","POP","g","hist","s","uscb","7642516"),
("2030","TN","POP","g","hist","r","uscb","7642516")
Texas
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","TX","POP","a","hist","s","uscb","29237895"),
("2020","TX","POP","a","hist","r","uscb","29237895"),
("2021","TX","POP","a","hist","s","uscb","29572672"),
("2021","TX","POP","a","hist","r","uscb","29572672"),
("2022","TX","POP","a","hist","s","uscb","30118002"),
("2022","TX","POP","a","hist","r","uscb","30118002"),
("2023","TX","POP","a","hist","s","uscb","30719247"),
("2023","TX","POP","a","hist","r","uscb","30719247"),
("2024","TX","POP","e","hist","s","uscb","31318578"),
("2024","TX","POP","e","hist","r","uscb","31318578"),
("2025","TX","POP","e","hist","s","uscb","31709821"),
("2025","TX","POP","e","hist","r","uscb","31709821"),
("2026","TX","POP","g","hist","s","uscb","32105951"),
("2026","TX","POP","g","hist","r","uscb","32105951"),
("2027","TX","POP","g","hist","s","uscb","32507030"),
("2027","TX","POP","g","hist","r","uscb","32507030"),
("2028","TX","POP","g","hist","s","uscb","32913120"),
("2028","TX","POP","g","hist","r","uscb","32913120"),
("2029","TX","POP","g","hist","s","uscb","33324282"),
("2029","TX","POP","g","hist","r","uscb","33324282"),
("2030","TX","POP","g","hist","s","uscb","33740581"),
("2030","TX","POP","g","hist","r","uscb","33740581")
Utah
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","UT","POP","a","hist","s","uscb","3283970"),
("2020","UT","POP","a","hist","r","uscb","3283970"),
("2021","UT","POP","a","hist","s","uscb","3339874"),
("2021","UT","POP","a","hist","r","uscb","3339874"),
("2022","UT","POP","a","hist","s","uscb","3393928"),
("2022","UT","POP","a","hist","r","uscb","3393928"),
("2023","UT","POP","a","hist","s","uscb","3449259"),
("2023","UT","POP","a","hist","r","uscb","3449259"),
("2024","UT","POP","e","hist","s","uscb","3502983"),
("2024","UT","POP","e","hist","r","uscb","3502983"),
("2025","UT","POP","e","hist","s","uscb","3538904"),
("2025","UT","POP","e","hist","r","uscb","3538904"),
("2026","UT","POP","g","hist","s","uscb","3575193"),
("2026","UT","POP","g","hist","r","uscb","3575193"),
("2027","UT","POP","g","hist","s","uscb","3611854"),
("2027","UT","POP","g","hist","r","uscb","3611854"),
("2028","UT","POP","g","hist","s","uscb","3648892"),
("2028","UT","POP","g","hist","r","uscb","3648892"),
("2029","UT","POP","g","hist","s","uscb","3686309"),
("2029","UT","POP","g","hist","r","uscb","3686309"),
("2030","UT","POP","g","hist","s","uscb","3724110"),
("2030","UT","POP","g","hist","r","uscb","3724110")
Vermont
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","VT","POP","a","hist","s","uscb","642965"),
("2020","VT","POP","a","hist","r","uscb","642965"),
("2021","VT","POP","a","hist","s","uscb","647238"),
("2021","VT","POP","a","hist","r","uscb","647238"),
("2022","VT","POP","a","hist","s","uscb","647614"),
("2022","VT","POP","a","hist","r","uscb","647614"),
("2023","VT","POP","a","hist","s","uscb","647722"),
("2023","VT","POP","a","hist","r","uscb","647722"),
("2024","VT","POP","e","hist","s","uscb","646521"),
("2024","VT","POP","e","hist","r","uscb","646521"),
("2025","VT","POP","e","hist","s","uscb","644663"),
("2025","VT","POP","e","hist","r","uscb","644663"),
("2026","VT","POP","g","hist","s","uscb","642810"),
("2026","VT","POP","g","hist","r","uscb","642810"),
("2027","VT","POP","g","hist","s","uscb","640963"),
("2027","VT","POP","g","hist","r","uscb","640963"),
("2028","VT","POP","g","hist","s","uscb","639120"),
("2028","VT","POP","g","hist","r","uscb","639120"),
("2029","VT","POP","g","hist","s","uscb","637284"),
("2029","VT","POP","g","hist","r","uscb","637284"),
("2030","VT","POP","g","hist","s","uscb","635452"),
("2030","VT","POP","g","hist","r","uscb","635452")
Virginia
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","VA","POP","a","hist","s","uscb","8637303"),
("2020","VA","POP","a","hist","r","uscb","8637303"),
("2021","VA","POP","a","hist","s","uscb","8660007"),
("2021","VA","POP","a","hist","r","uscb","8660007"),
("2022","VA","POP","a","hist","s","uscb","8681038"),
("2022","VA","POP","a","hist","r","uscb","8681038"),
("2023","VA","POP","a","hist","s","uscb","8732034"),
("2023","VA","POP","a","hist","r","uscb","8732034"),
("2024","VA","POP","e","hist","s","uscb","8819642"),
("2024","VA","POP","e","hist","r","uscb","8819642"),
("2025","VA","POP","e","hist","s","uscb","8880107"),
("2025","VA","POP","e","hist","r","uscb","8880107"),
("2026","VA","POP","g","hist","s","uscb","8940986"),
("2026","VA","POP","g","hist","r","uscb","8940986"),
("2027","VA","POP","g","hist","s","uscb","9002283"),
("2027","VA","POP","g","hist","r","uscb","9002283"),
("2028","VA","POP","g","hist","s","uscb","9064000"),
("2028","VA","POP","g","hist","r","uscb","9064000"),
("2029","VA","POP","g","hist","s","uscb","9126140"),
("2029","VA","POP","g","hist","r","uscb","9126140"),
("2030","VA","POP","g","hist","s","uscb","9188707"),
("2030","VA","POP","g","hist","r","uscb","9188707")
Washington
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","WA","POP","a","hist","s","uscb","7726812"),
("2020","WA","POP","a","hist","r","uscb","7726812"),
("2021","WA","POP","a","hist","s","uscb","7744316"),
("2021","WA","POP","a","hist","r","uscb","7744316"),
("2022","WA","POP","a","hist","s","uscb","7786828"),
("2022","WA","POP","a","hist","r","uscb","7786828"),
("2023","WA","POP","a","hist","s","uscb","7838655"),
("2023","WA","POP","a","hist","r","uscb","7838655"),
("2024","WA","POP","e","hist","s","uscb","7927958"),
("2024","WA","POP","e","hist","r","uscb","7927958"),
("2025","WA","POP","e","hist","s","uscb","8001020"),
("2025","WA","POP","e","hist","r","uscb","8001020"),
("2026","WA","POP","g","hist","s","uscb","8074755"),
("2026","WA","POP","g","hist","r","uscb","8074755"),
("2027","WA","POP","g","hist","s","uscb","8149170"),
("2027","WA","POP","g","hist","r","uscb","8149170"),
("2028","WA","POP","g","hist","s","uscb","8224270"),
("2028","WA","POP","g","hist","r","uscb","8224270"),
("2029","WA","POP","g","hist","s","uscb","8300063"),
("2029","WA","POP","g","hist","r","uscb","8300063"),
("2030","WA","POP","g","hist","s","uscb","8376554"),
("2030","WA","POP","g","hist","r","uscb","8376554")
West Virginia
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","WV","POP","a","hist","s","uscb","1791670"),
("2020","WV","POP","a","hist","r","uscb","1791670"),
("2021","WV","POP","a","hist","s","uscb","1785921"),
("2021","WV","POP","a","hist","r","uscb","1785921"),
("2022","WV","POP","a","hist","s","uscb","1774003"),
("2022","WV","POP","a","hist","r","uscb","1774003"),
("2023","WV","POP","a","hist","s","uscb","1770036"),
("2023","WV","POP","a","hist","r","uscb","1770036"),
("2024","WV","POP","e","hist","s","uscb","1767402"),
("2024","WV","POP","e","hist","r","uscb","1767402"),
("2025","WV","POP","e","hist","s","uscb","1766147"),
("2025","WV","POP","e","hist","r","uscb","1766147"),
("2026","WV","POP","g","hist","s","uscb","1764892"),
("2026","WV","POP","g","hist","r","uscb","1764892"),
("2027","WV","POP","g","hist","s","uscb","1763639"),
("2027","WV","POP","g","hist","r","uscb","1763639"),
("2028","WV","POP","g","hist","s","uscb","1762387"),
("2028","WV","POP","g","hist","r","uscb","1762387"),
("2029","WV","POP","g","hist","s","uscb","1761135"),
("2029","WV","POP","g","hist","r","uscb","1761135"),
("2030","WV","POP","g","hist","s","uscb","1759885"),
("2030","WV","POP","g","hist","r","uscb","1759885")
Wisconsin
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","WI","POP","a","hist","s","uscb","5897371"),
("2020","WI","POP","a","hist","r","uscb","5897371"),
("2021","WI","POP","a","hist","s","uscb","5882128"),
("2021","WI","POP","a","hist","r","uscb","5882128"),
("2022","WI","POP","a","hist","s","uscb","5903472"),
("2022","WI","POP","a","hist","r","uscb","5903472"),
("2023","WI","POP","a","hist","s","uscb","5930350"),
("2023","WI","POP","a","hist","r","uscb","5930350"),
("2024","WI","POP","e","hist","s","uscb","5957168"),
("2024","WI","POP","e","hist","r","uscb","5957168"),
("2025","WI","POP","e","hist","s","uscb","5972787"),
("2025","WI","POP","e","hist","r","uscb","5972787"),
("2026","WI","POP","g","hist","s","uscb","5988446"),
("2026","WI","POP","g","hist","r","uscb","5988446"),
("2027","WI","POP","g","hist","s","uscb","6004147"),
("2027","WI","POP","g","hist","r","uscb","6004147"),
("2028","WI","POP","g","hist","s","uscb","6019890"),
("2028","WI","POP","g","hist","r","uscb","6019890"),
("2029","WI","POP","g","hist","s","uscb","6035673"),
("2029","WI","POP","g","hist","r","uscb","6035673"),
("2030","WI","POP","g","hist","s","uscb","6051498"),
("2030","WI","POP","g","hist","r","uscb","6051498")
Wyoming
replace into government_spending (year,state,code,source,fy,spend_rev,author, spending) values ("2020","WY","POP","a","hist","s","uscb","577669"),
("2020","WY","POP","a","hist","r","uscb","577669"),
("2021","WY","POP","a","hist","s","uscb","579662"),
("2021","WY","POP","a","hist","r","uscb","579662"),
("2022","WY","POP","a","hist","s","uscb","581742"),
("2022","WY","POP","a","hist","r","uscb","581742"),
("2023","WY","POP","a","hist","s","uscb","584666"),
("2023","WY","POP","a","hist","r","uscb","584666"),
("2024","WY","POP","e","hist","s","uscb","586722"),
("2024","WY","POP","e","hist","r","uscb","586722"),
("2025","WY","POP","e","hist","s","uscb","588753"),
("2025","WY","POP","e","hist","r","uscb","588753"),
("2026","WY","POP","g","hist","s","uscb","590791"),
("2026","WY","POP","g","hist","r","uscb","590791"),
("2027","WY","POP","g","hist","s","uscb","592836"),
("2027","WY","POP","g","hist","r","uscb","592836"),
("2028","WY","POP","g","hist","s","uscb","594888"),
("2028","WY","POP","g","hist","r","uscb","594888"),
("2029","WY","POP","g","hist","s","uscb","596947"),
("2029","WY","POP","g","hist","r","uscb","596947"),
("2030","WY","POP","g","hist","s","uscb","599013"),
("2030","WY","POP","g","hist","r","uscb","599013")
Puerto Rico
Done