Load State and Local Spending Update
Year = 2022

return to Menu

x01 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","AL","B01","a","hist","uscb","s","39475","39475","0"), ("2022","AL","B21","a","hist","uscb","s","3300637","3300637","0"), ("2022","AL","B22","a","hist","uscb","s","53182","53182","0"), ("2022","AL","B30","a","hist","uscb","s","82094","82094","0"), ("2022","AL","B42","a","hist","uscb","s","2824249","2824249","0"), ("2022","AL","B46","a","hist","uscb","s","976950","976950","0"), ("2022","AL","B50","a","hist","uscb","s","215010","215010","0"), ("2022","AL","B59","a","hist","uscb","s","97594","97594","0"), ("2022","AL","B79","a","hist","uscb","s","10446104","10446104","0"), ("2022","AL","B80","a","hist","uscb","s","24531","24531","0"), ("2022","AL","B89","a","hist","uscb","s","2169640","671554","1498086")
x02 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","AK","B01","a","hist","uscb","s","193236","193236","0"), ("2022","AK","B21","a","hist","uscb","s","704808","704808","0"), ("2022","AK","B22","a","hist","uscb","s","45161","45161","0"), ("2022","AK","B30","a","hist","uscb","s","11634","11634","0"), ("2022","AK","B42","a","hist","uscb","s","1039779","1039779","0"), ("2022","AK","B46","a","hist","uscb","s","741297","741297","0"), ("2022","AK","B50","a","hist","uscb","s","90104","90104","0"), ("2022","AK","B59","a","hist","uscb","s","159070","159070","0"), ("2022","AK","B79","a","hist","uscb","s","2349735","2349735","0"), ("2022","AK","B80","a","hist","uscb","s","2192","2192","0"), ("2022","AK","B89","a","hist","uscb","s","823955","387414","436541")
x04 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","AR","B01","a","hist","uscb","s","5697","5697","0"), ("2022","AR","B21","a","hist","uscb","s","3462171","3462171","0"), ("2022","AR","B22","a","hist","uscb","s","127401","127401","0"), ("2022","AR","B30","a","hist","uscb","s","0","0","0"), ("2022","AR","B42","a","hist","uscb","s","3566108","3566108","0"), ("2022","AR","B46","a","hist","uscb","s","868090","868090","0"), ("2022","AR","B50","a","hist","uscb","s","272698","272698","0"), ("2022","AR","B59","a","hist","uscb","s","128630","128630","0"), ("2022","AR","B79","a","hist","uscb","s","21740946","21740946","0"), ("2022","AR","B80","a","hist","uscb","s","4039","4039","0"), ("2022","AR","B89","a","hist","uscb","s","2239264","376620","1862644")
x05 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","CA","B01","a","hist","uscb","s","0","0","0"), ("2022","CA","B21","a","hist","uscb","s","1239209","1239209","0"), ("2022","CA","B22","a","hist","uscb","s","99870","99870","0"), ("2022","CA","B30","a","hist","uscb","s","0","0","0"), ("2022","CA","B42","a","hist","uscb","s","2008192","2008192","0"), ("2022","CA","B46","a","hist","uscb","s","754536","754536","0"), ("2022","CA","B50","a","hist","uscb","s","75861","75861","0"), ("2022","CA","B59","a","hist","uscb","s","73639","73639","0"), ("2022","CA","B79","a","hist","uscb","s","7804303","7804303","0"), ("2022","CA","B80","a","hist","uscb","s","12437","12437","0"), ("2022","CA","B89","a","hist","uscb","s","1565701","410160","1155541")
x06 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","CO","B01","a","hist","uscb","s","457","457","0"), ("2022","CO","B21","a","hist","uscb","s","23242330","23242330","0"), ("2022","CO","B22","a","hist","uscb","s","262771","262771","0"), ("2022","CO","B30","a","hist","uscb","s","0","0","0"), ("2022","CO","B42","a","hist","uscb","s","1888447","1888447","0"), ("2022","CO","B46","a","hist","uscb","s","6231291","6231291","0"), ("2022","CO","B50","a","hist","uscb","s","137245","137245","0"), ("2022","CO","B59","a","hist","uscb","s","356252","356252","0"), ("2022","CO","B79","a","hist","uscb","s","95553522","95553522","0"), ("2022","CO","B80","a","hist","uscb","s","225811","225811","0"), ("2022","CO","B89","a","hist","uscb","s","33764602","4458545","29306057")
x08 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","DE","B01","a","hist","uscb","s","0","0","0"), ("2022","DE","B21","a","hist","uscb","s","2433236","2433236","0"), ("2022","DE","B22","a","hist","uscb","s","108859","108859","0"), ("2022","DE","B30","a","hist","uscb","s","0","0","0"), ("2022","DE","B42","a","hist","uscb","s","2648860","2648860","0"), ("2022","DE","B46","a","hist","uscb","s","687829","687829","0"), ("2022","DE","B50","a","hist","uscb","s","313583","313583","0"), ("2022","DE","B59","a","hist","uscb","s","252556","252556","0"), ("2022","DE","B79","a","hist","uscb","s","8316005","8316005","0"), ("2022","DE","B80","a","hist","uscb","s","12818","12818","0"), ("2022","DE","B89","a","hist","uscb","s","3607111","1212376","2394735")
x09 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","DC","B01","a","hist","uscb","s","7352","7352","0"), ("2022","DC","B21","a","hist","uscb","s","1181577","1181577","0"), ("2022","DC","B22","a","hist","uscb","s","27868","27868","0"), ("2022","DC","B30","a","hist","uscb","s","0","0","0"), ("2022","DC","B42","a","hist","uscb","s","1685506","1685506","0"), ("2022","DC","B46","a","hist","uscb","s","552237","552237","0"), ("2022","DC","B50","a","hist","uscb","s","254511","254511","0"), ("2022","DC","B59","a","hist","uscb","s","63656","63656","0"), ("2022","DC","B79","a","hist","uscb","s","6935338","6935338","0"), ("2022","DC","B80","a","hist","uscb","s","14949","14949","0"), ("2022","DC","B89","a","hist","uscb","s","1469579","773471","696108")
x10 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","FL","B01","a","hist","uscb","s","0","0","0"), ("2022","FL","B21","a","hist","uscb","s","430860","430860","0"), ("2022","FL","B22","a","hist","uscb","s","19610","19610","0"), ("2022","FL","B30","a","hist","uscb","s","0","0","0"), ("2022","FL","B42","a","hist","uscb","s","451403","451403","0"), ("2022","FL","B46","a","hist","uscb","s","473593","473593","0"), ("2022","FL","B50","a","hist","uscb","s","159374","159374","0"), ("2022","FL","B59","a","hist","uscb","s","23764","23764","0"), ("2022","FL","B79","a","hist","uscb","s","2213828","2213828","0"), ("2022","FL","B80","a","hist","uscb","s","15031","15031","0"), ("2022","FL","B89","a","hist","uscb","s","379353","299599","79754")
x11 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","GA","B01","a","hist","uscb","s","0","0","0"), ("2022","GA","B21","a","hist","uscb","s","0","0","0"), ("2022","GA","B22","a","hist","uscb","s","0","0","0"), ("2022","GA","B30","a","hist","uscb","s","0","0","0"), ("2022","GA","B42","a","hist","uscb","s","0","0","0"), ("2022","GA","B46","a","hist","uscb","s","0","0","0"), ("2022","GA","B50","a","hist","uscb","s","0","0","0"), ("2022","GA","B59","a","hist","uscb","s","0","0","0"), ("2022","GA","B79","a","hist","uscb","s","0","0","0"), ("2022","GA","B80","a","hist","uscb","s","0","0","0"), ("2022","GA","B89","a","hist","uscb","s","7464202","0","7464202")
x12 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","HI","B01","a","hist","uscb","s","0","0","0"), ("2022","HI","B21","a","hist","uscb","s","10241352","10241352","0"), ("2022","HI","B22","a","hist","uscb","s","224028","224028","0"), ("2022","HI","B30","a","hist","uscb","s","0","0","0"), ("2022","HI","B42","a","hist","uscb","s","9684996","9684996","0"), ("2022","HI","B46","a","hist","uscb","s","2059880","2059880","0"), ("2022","HI","B50","a","hist","uscb","s","566930","566930","0"), ("2022","HI","B59","a","hist","uscb","s","240016","240016","0"), ("2022","HI","B79","a","hist","uscb","s","28085370","28085370","0"), ("2022","HI","B80","a","hist","uscb","s","41120","41120","0"), ("2022","HI","B89","a","hist","uscb","s","12256929","3295051","8961878")
x13 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","ID","B01","a","hist","uscb","s","41603","41603","0"), ("2022","ID","B21","a","hist","uscb","s","5222904","5222904","0"), ("2022","ID","B22","a","hist","uscb","s","23527","23527","0"), ("2022","ID","B30","a","hist","uscb","s","0","0","0"), ("2022","ID","B42","a","hist","uscb","s","4062419","4062419","0"), ("2022","ID","B46","a","hist","uscb","s","1414198","1414198","0"), ("2022","ID","B50","a","hist","uscb","s","399597","399597","0"), ("2022","ID","B59","a","hist","uscb","s","160161","160161","0"), ("2022","ID","B79","a","hist","uscb","s","11611084","11611084","0"), ("2022","ID","B80","a","hist","uscb","s","27499","27499","0"), ("2022","ID","B89","a","hist","uscb","s","3244444","483003","2761441")
x15 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","IN","B01","a","hist","uscb","s","12451","12451","0"), ("2022","IN","B21","a","hist","uscb","s","1006143","1006143","0"), ("2022","IN","B22","a","hist","uscb","s","35621","35621","0"), ("2022","IN","B30","a","hist","uscb","s","0","0","0"), ("2022","IN","B42","a","hist","uscb","s","1050777","1050777","0"), ("2022","IN","B46","a","hist","uscb","s","341801","341801","0"), ("2022","IN","B50","a","hist","uscb","s","102367","102367","0"), ("2022","IN","B59","a","hist","uscb","s","31962","31962","0"), ("2022","IN","B79","a","hist","uscb","s","2315250","2315250","0"), ("2022","IN","B80","a","hist","uscb","s","12308","12308","0"), ("2022","IN","B89","a","hist","uscb","s","676756","170352","506404")
x16 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","IA","B01","a","hist","uscb","s","213","213","0"), ("2022","IA","B21","a","hist","uscb","s","525761","525761","0"), ("2022","IA","B22","a","hist","uscb","s","770","770","0"), ("2022","IA","B30","a","hist","uscb","s","0","0","0"), ("2022","IA","B42","a","hist","uscb","s","842551","842551","0"), ("2022","IA","B46","a","hist","uscb","s","370059","370059","0"), ("2022","IA","B50","a","hist","uscb","s","88158","88158","0"), ("2022","IA","B59","a","hist","uscb","s","72853","72853","0"), ("2022","IA","B79","a","hist","uscb","s","3095380","3095380","0"), ("2022","IA","B80","a","hist","uscb","s","7665","7665","0"), ("2022","IA","B89","a","hist","uscb","s","652815","335593","317222")
x17 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","KS","B01","a","hist","uscb","s","95433","95433","0"), ("2022","KS","B21","a","hist","uscb","s","5732125","5732125","0"), ("2022","KS","B22","a","hist","uscb","s","315083","315083","0"), ("2022","KS","B30","a","hist","uscb","s","0","0","0"), ("2022","KS","B42","a","hist","uscb","s","9729855","9729855","0"), ("2022","KS","B46","a","hist","uscb","s","1704231","1704231","0"), ("2022","KS","B50","a","hist","uscb","s","867300","867300","0"), ("2022","KS","B59","a","hist","uscb","s","104339","104339","0"), ("2022","KS","B79","a","hist","uscb","s","22258482","22258482","0"), ("2022","KS","B80","a","hist","uscb","s","85972","85972","0"), ("2022","KS","B89","a","hist","uscb","s","7892927","1674115","6218812")
x18 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","KY","B01","a","hist","uscb","s","754","754","0"), ("2022","KY","B21","a","hist","uscb","s","2382948","2382948","0"), ("2022","KY","B22","a","hist","uscb","s","103866","103866","0"), ("2022","KY","B30","a","hist","uscb","s","0","0","0"), ("2022","KY","B42","a","hist","uscb","s","4015632","4015632","0"), ("2022","KY","B46","a","hist","uscb","s","1181753","1181753","0"), ("2022","KY","B50","a","hist","uscb","s","552361","552361","0"), ("2022","KY","B59","a","hist","uscb","s","79953","79953","0"), ("2022","KY","B79","a","hist","uscb","s","15752862","15752862","0"), ("2022","KY","B80","a","hist","uscb","s","38292","38292","0"), ("2022","KY","B89","a","hist","uscb","s","1270530","345610","924920")
x19 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","LA","B01","a","hist","uscb","s","512","512","0"), ("2022","LA","B21","a","hist","uscb","s","1517589","1517589","0"), ("2022","LA","B22","a","hist","uscb","s","66782","66782","0"), ("2022","LA","B30","a","hist","uscb","s","0","0","0"), ("2022","LA","B42","a","hist","uscb","s","1728219","1728219","0"), ("2022","LA","B46","a","hist","uscb","s","650305","650305","0"), ("2022","LA","B50","a","hist","uscb","s","236644","236644","0"), ("2022","LA","B59","a","hist","uscb","s","91551","91551","0"), ("2022","LA","B79","a","hist","uscb","s","5550512","5550512","0"), ("2022","LA","B80","a","hist","uscb","s","23755","23755","0"), ("2022","LA","B89","a","hist","uscb","s","1343807","412658","931149")
x20 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","ME","B01","a","hist","uscb","s","0","0","0"), ("2022","ME","B21","a","hist","uscb","s","1193293","1193293","0"), ("2022","ME","B22","a","hist","uscb","s","47134","47134","0"), ("2022","ME","B30","a","hist","uscb","s","0","0","0"), ("2022","ME","B42","a","hist","uscb","s","2009679","2009679","0"), ("2022","ME","B46","a","hist","uscb","s","533216","533216","0"), ("2022","ME","B50","a","hist","uscb","s","283804","283804","0"), ("2022","ME","B59","a","hist","uscb","s","68329","68329","0"), ("2022","ME","B79","a","hist","uscb","s","3760725","3760725","0"), ("2022","ME","B80","a","hist","uscb","s","14299","14299","0"), ("2022","ME","B89","a","hist","uscb","s","884772","239803","644969")
x21 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MD","B01","a","hist","uscb","s","0","0","0"), ("2022","MD","B21","a","hist","uscb","s","2952329","2952329","0"), ("2022","MD","B22","a","hist","uscb","s","148221","148221","0"), ("2022","MD","B30","a","hist","uscb","s","9283","9283","0"), ("2022","MD","B42","a","hist","uscb","s","1815673","1815673","0"), ("2022","MD","B46","a","hist","uscb","s","1012556","1012556","0"), ("2022","MD","B50","a","hist","uscb","s","466658","466658","0"), ("2022","MD","B59","a","hist","uscb","s","108157","108157","0"), ("2022","MD","B79","a","hist","uscb","s","13541275","13541275","0"), ("2022","MD","B80","a","hist","uscb","s","0","0","0"), ("2022","MD","B89","a","hist","uscb","s","2031666","435557","1596109")
x22 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MA","B01","a","hist","uscb","s","502","502","0"), ("2022","MA","B21","a","hist","uscb","s","3250480","3250480","0"), ("2022","MA","B22","a","hist","uscb","s","204110","204110","0"), ("2022","MA","B30","a","hist","uscb","s","0","0","0"), ("2022","MA","B42","a","hist","uscb","s","541079","541079","0"), ("2022","MA","B46","a","hist","uscb","s","882075","882075","0"), ("2022","MA","B50","a","hist","uscb","s","31378","31378","0"), ("2022","MA","B59","a","hist","uscb","s","116282","116282","0"), ("2022","MA","B79","a","hist","uscb","s","12795778","12795778","0"), ("2022","MA","B80","a","hist","uscb","s","14176","14176","0"), ("2022","MA","B89","a","hist","uscb","s","4043684","2581179","1462505")
x23 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MI","B01","a","hist","uscb","s","0","0","0"), ("2022","MI","B21","a","hist","uscb","s","493124","493124","0"), ("2022","MI","B22","a","hist","uscb","s","61216","61216","0"), ("2022","MI","B30","a","hist","uscb","s","0","0","0"), ("2022","MI","B42","a","hist","uscb","s","802618","802618","0"), ("2022","MI","B46","a","hist","uscb","s","295450","295450","0"), ("2022","MI","B50","a","hist","uscb","s","172747","172747","0"), ("2022","MI","B59","a","hist","uscb","s","45499","45499","0"), ("2022","MI","B79","a","hist","uscb","s","3357598","3357598","0"), ("2022","MI","B80","a","hist","uscb","s","12300","12300","0"), ("2022","MI","B89","a","hist","uscb","s","426383","166516","259867")
x24 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MN","B01","a","hist","uscb","s","18690","18690","0"), ("2022","MN","B21","a","hist","uscb","s","3357743","3357743","0"), ("2022","MN","B22","a","hist","uscb","s","102039","102039","0"), ("2022","MN","B30","a","hist","uscb","s","0","0","0"), ("2022","MN","B42","a","hist","uscb","s","3901048","3901048","0"), ("2022","MN","B46","a","hist","uscb","s","773834","773834","0"), ("2022","MN","B50","a","hist","uscb","s","757466","757466","0"), ("2022","MN","B59","a","hist","uscb","s","52683","52683","0"), ("2022","MN","B79","a","hist","uscb","s","11570594","11570594","0"), ("2022","MN","B80","a","hist","uscb","s","38429","38429","0"), ("2022","MN","B89","a","hist","uscb","s","4626991","2198045","2428946")
x25 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MS","B01","a","hist","uscb","s","60033","60033","0"), ("2022","MS","B21","a","hist","uscb","s","2766042","2766042","0"), ("2022","MS","B22","a","hist","uscb","s","177803","177803","0"), ("2022","MS","B30","a","hist","uscb","s","0","0","0"), ("2022","MS","B42","a","hist","uscb","s","2797011","2797011","0"), ("2022","MS","B46","a","hist","uscb","s","559597","559597","0"), ("2022","MS","B50","a","hist","uscb","s","1157258","1157258","0"), ("2022","MS","B59","a","hist","uscb","s","54342","54342","0"), ("2022","MS","B79","a","hist","uscb","s","15642994","15642994","0"), ("2022","MS","B80","a","hist","uscb","s","55900","55900","0"), ("2022","MS","B89","a","hist","uscb","s","6772930","2424224","4348706")
x26 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MO","B01","a","hist","uscb","s","97687","97687","0"), ("2022","MO","B21","a","hist","uscb","s","4241519","4241519","0"), ("2022","MO","B22","a","hist","uscb","s","311772","311772","0"), ("2022","MO","B30","a","hist","uscb","s","0","0","0"), ("2022","MO","B42","a","hist","uscb","s","7243589","7243589","0"), ("2022","MO","B46","a","hist","uscb","s","1050243","1050243","0"), ("2022","MO","B50","a","hist","uscb","s","1346736","1346736","0"), ("2022","MO","B59","a","hist","uscb","s","75429","75429","0"), ("2022","MO","B79","a","hist","uscb","s","18441312","18441312","0"), ("2022","MO","B80","a","hist","uscb","s","319","319","0"), ("2022","MO","B89","a","hist","uscb","s","4631358","1275411","3355947")
x27 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","MT","B01","a","hist","uscb","s","56094","56094","0"), ("2022","MT","B21","a","hist","uscb","s","3127572","3127572","0"), ("2022","MT","B22","a","hist","uscb","s","81021","81021","0"), ("2022","MT","B30","a","hist","uscb","s","0","0","0"), ("2022","MT","B42","a","hist","uscb","s","3830999","3830999","0"), ("2022","MT","B46","a","hist","uscb","s","868528","868528","0"), ("2022","MT","B50","a","hist","uscb","s","27094","27094","0"), ("2022","MT","B59","a","hist","uscb","s","45013","45013","0"), ("2022","MT","B79","a","hist","uscb","s","11220106","11220106","0"), ("2022","MT","B80","a","hist","uscb","s","20819","20819","0"), ("2022","MT","B89","a","hist","uscb","s","2624619","698177","1926442")
x28 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NE","B01","a","hist","uscb","s","0","0","0"), ("2022","NE","B21","a","hist","uscb","s","1563046","1563046","0"), ("2022","NE","B22","a","hist","uscb","s","69028","69028","0"), ("2022","NE","B30","a","hist","uscb","s","19869","19869","0"), ("2022","NE","B42","a","hist","uscb","s","1966911","1966911","0"), ("2022","NE","B46","a","hist","uscb","s","535770","535770","0"), ("2022","NE","B50","a","hist","uscb","s","259466","259466","0"), ("2022","NE","B59","a","hist","uscb","s","115745","115745","0"), ("2022","NE","B79","a","hist","uscb","s","6393814","6393814","0"), ("2022","NE","B80","a","hist","uscb","s","11451","11451","0"), ("2022","NE","B89","a","hist","uscb","s","1321451","459161","862290")
x29 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NV","B01","a","hist","uscb","s","43531","43531","0"), ("2022","NV","B21","a","hist","uscb","s","2600524","2600524","0"), ("2022","NV","B22","a","hist","uscb","s","52016","52016","0"), ("2022","NV","B30","a","hist","uscb","s","0","0","0"), ("2022","NV","B42","a","hist","uscb","s","5531915","5531915","0"), ("2022","NV","B46","a","hist","uscb","s","927110","927110","0"), ("2022","NV","B50","a","hist","uscb","s","559534","559534","0"), ("2022","NV","B59","a","hist","uscb","s","91637","91637","0"), ("2022","NV","B79","a","hist","uscb","s","10101310","10101310","0"), ("2022","NV","B80","a","hist","uscb","s","51748","51748","0"), ("2022","NV","B89","a","hist","uscb","s","1756018","422427","1333591")
x30 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NH","B01","a","hist","uscb","s","420","420","0"), ("2022","NH","B21","a","hist","uscb","s","469919","469919","0"), ("2022","NH","B22","a","hist","uscb","s","23418","23418","0"), ("2022","NH","B30","a","hist","uscb","s","0","0","0"), ("2022","NH","B42","a","hist","uscb","s","796342","796342","0"), ("2022","NH","B46","a","hist","uscb","s","483533","483533","0"), ("2022","NH","B50","a","hist","uscb","s","63545","63545","0"), ("2022","NH","B59","a","hist","uscb","s","72259","72259","0"), ("2022","NH","B79","a","hist","uscb","s","2217791","2217791","0"), ("2022","NH","B80","a","hist","uscb","s","5467","5467","0"), ("2022","NH","B89","a","hist","uscb","s","524347","182562","341785")
x31 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NJ","B01","a","hist","uscb","s","30017","30017","0"), ("2022","NJ","B21","a","hist","uscb","s","322653","322653","0"), ("2022","NJ","B22","a","hist","uscb","s","30537","30537","0"), ("2022","NJ","B30","a","hist","uscb","s","0","0","0"), ("2022","NJ","B42","a","hist","uscb","s","522504","522504","0"), ("2022","NJ","B46","a","hist","uscb","s","488368","488368","0"), ("2022","NJ","B50","a","hist","uscb","s","0","0","0"), ("2022","NJ","B59","a","hist","uscb","s","62575","62575","0"), ("2022","NJ","B79","a","hist","uscb","s","4325242","4325242","0"), ("2022","NJ","B80","a","hist","uscb","s","12003","12003","0"), ("2022","NJ","B89","a","hist","uscb","s","910999","258874","652125")
x32 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NM","B01","a","hist","uscb","s","0","0","0"), ("2022","NM","B21","a","hist","uscb","s","745784","745784","0"), ("2022","NM","B22","a","hist","uscb","s","112161","112161","0"), ("2022","NM","B30","a","hist","uscb","s","371805","371805","0"), ("2022","NM","B42","a","hist","uscb","s","3292056","3292056","0"), ("2022","NM","B46","a","hist","uscb","s","286644","286644","0"), ("2022","NM","B50","a","hist","uscb","s","61789","61789","0"), ("2022","NM","B59","a","hist","uscb","s","43285","43285","0"), ("2022","NM","B79","a","hist","uscb","s","4116496","4116496","0"), ("2022","NM","B80","a","hist","uscb","s","9501","9501","0"), ("2022","NM","B89","a","hist","uscb","s","1786014","270865","1515149")
x33 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NY","B01","a","hist","uscb","s","9114","9114","0"), ("2022","NY","B21","a","hist","uscb","s","321690","321690","0"), ("2022","NY","B22","a","hist","uscb","s","31457","31457","0"), ("2022","NY","B30","a","hist","uscb","s","0","0","0"), ("2022","NY","B42","a","hist","uscb","s","34389","34389","0"), ("2022","NY","B46","a","hist","uscb","s","206314","206314","0"), ("2022","NY","B50","a","hist","uscb","s","104814","104814","0"), ("2022","NY","B59","a","hist","uscb","s","17040","17040","0"), ("2022","NY","B79","a","hist","uscb","s","1895381","1895381","0"), ("2022","NY","B80","a","hist","uscb","s","0","0","0"), ("2022","NY","B89","a","hist","uscb","s","1492004","1332479","159525")
x34 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","NC","B01","a","hist","uscb","s","1129","1129","0"), ("2022","NC","B21","a","hist","uscb","s","2693073","2693073","0"), ("2022","NC","B22","a","hist","uscb","s","313891","313891","0"), ("2022","NC","B30","a","hist","uscb","s","0","0","0"), ("2022","NC","B42","a","hist","uscb","s","5209824","5209824","0"), ("2022","NC","B46","a","hist","uscb","s","1033774","1033774","0"), ("2022","NC","B50","a","hist","uscb","s","361312","361312","0"), ("2022","NC","B59","a","hist","uscb","s","44302","44302","0"), ("2022","NC","B79","a","hist","uscb","s","14618388","14618388","0"), ("2022","NC","B80","a","hist","uscb","s","171","171","0"), ("2022","NC","B89","a","hist","uscb","s","6384004","4155065","2228939")
x35 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","ND","B01","a","hist","uscb","s","172","172","0"), ("2022","ND","B21","a","hist","uscb","s","1381385","1381385","0"), ("2022","ND","B22","a","hist","uscb","s","13220","13220","0"), ("2022","ND","B30","a","hist","uscb","s","0","0","0"), ("2022","ND","B42","a","hist","uscb","s","338587","338587","0"), ("2022","ND","B46","a","hist","uscb","s","531572","531572","0"), ("2022","ND","B50","a","hist","uscb","s","76908","76908","0"), ("2022","ND","B59","a","hist","uscb","s","78701","78701","0"), ("2022","ND","B79","a","hist","uscb","s","9725341","9725341","0"), ("2022","ND","B80","a","hist","uscb","s","7779","7779","0"), ("2022","ND","B89","a","hist","uscb","s","1267606","419912","847694")
x36 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","OH","B01","a","hist","uscb","s","3066","3066","0"), ("2022","OH","B21","a","hist","uscb","s","6123624","6123624","0"), ("2022","OH","B22","a","hist","uscb","s","505464","505464","0"), ("2022","OH","B30","a","hist","uscb","s","0","0","0"), ("2022","OH","B42","a","hist","uscb","s","17952501","17952501","0"), ("2022","OH","B46","a","hist","uscb","s","1725897","1725897","0"), ("2022","OH","B50","a","hist","uscb","s","3104710","3104710","0"), ("2022","OH","B59","a","hist","uscb","s","312732","312732","0"), ("2022","OH","B79","a","hist","uscb","s","67704517","67704517","0"), ("2022","OH","B80","a","hist","uscb","s","179422","179422","0"), ("2022","OH","B89","a","hist","uscb","s","19913884","2618375","17295509")
x37 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","OK","B01","a","hist","uscb","s","14815","14815","0"), ("2022","OK","B21","a","hist","uscb","s","4391942","4391942","0"), ("2022","OK","B22","a","hist","uscb","s","111253","111253","0"), ("2022","OK","B30","a","hist","uscb","s","0","0","0"), ("2022","OK","B42","a","hist","uscb","s","6146989","6146989","0"), ("2022","OK","B46","a","hist","uscb","s","1286801","1286801","0"), ("2022","OK","B50","a","hist","uscb","s","80881","80881","0"), ("2022","OK","B59","a","hist","uscb","s","104912","104912","0"), ("2022","OK","B79","a","hist","uscb","s","17840827","17840827","0"), ("2022","OK","B80","a","hist","uscb","s","80535","80535","0"), ("2022","OK","B89","a","hist","uscb","s","6163684","2214098","3949586")
x38 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","OR","B01","a","hist","uscb","s","568","568","0"), ("2022","OR","B21","a","hist","uscb","s","529558","529558","0"), ("2022","OR","B22","a","hist","uscb","s","11992","11992","0"), ("2022","OR","B30","a","hist","uscb","s","0","0","0"), ("2022","OR","B42","a","hist","uscb","s","222980","222980","0"), ("2022","OR","B46","a","hist","uscb","s","311118","311118","0"), ("2022","OR","B50","a","hist","uscb","s","15065","15065","0"), ("2022","OR","B59","a","hist","uscb","s","41397","41397","0"), ("2022","OR","B79","a","hist","uscb","s","1144063","1144063","0"), ("2022","OR","B80","a","hist","uscb","s","7780","7780","0"), ("2022","OR","B89","a","hist","uscb","s","533834","192206","341628")
x39 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","PA","B01","a","hist","uscb","s","0","0","0"), ("2022","PA","B21","a","hist","uscb","s","3970745","3970745","0"), ("2022","PA","B22","a","hist","uscb","s","232422","232422","0"), ("2022","PA","B30","a","hist","uscb","s","0","0","0"), ("2022","PA","B42","a","hist","uscb","s","9137319","9137319","0"), ("2022","PA","B46","a","hist","uscb","s","1347990","1347990","0"), ("2022","PA","B50","a","hist","uscb","s","117306","117306","0"), ("2022","PA","B59","a","hist","uscb","s","70411","70411","0"), ("2022","PA","B79","a","hist","uscb","s","24178836","24178836","0"), ("2022","PA","B80","a","hist","uscb","s","117692","117692","0"), ("2022","PA","B89","a","hist","uscb","s","4402579","727966","3674613")
x40 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","RI","B01","a","hist","uscb","s","1087","1087","0"), ("2022","RI","B21","a","hist","uscb","s","2470876","2470876","0"), ("2022","RI","B22","a","hist","uscb","s","61447","61447","0"), ("2022","RI","B30","a","hist","uscb","s","0","0","0"), ("2022","RI","B42","a","hist","uscb","s","1511435","1511435","0"), ("2022","RI","B46","a","hist","uscb","s","745140","745140","0"), ("2022","RI","B50","a","hist","uscb","s","170424","170424","0"), ("2022","RI","B59","a","hist","uscb","s","88965","88965","0"), ("2022","RI","B79","a","hist","uscb","s","9108778","9108778","0"), ("2022","RI","B80","a","hist","uscb","s","0","0","0"), ("2022","RI","B89","a","hist","uscb","s","1149351","358664","790687")
x41 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","SC","B01","a","hist","uscb","s","362","362","0"), ("2022","SC","B21","a","hist","uscb","s","1484103","1484103","0"), ("2022","SC","B22","a","hist","uscb","s","99704","99704","0"), ("2022","SC","B30","a","hist","uscb","s","0","0","0"), ("2022","SC","B42","a","hist","uscb","s","3529625","3529625","0"), ("2022","SC","B46","a","hist","uscb","s","566802","566802","0"), ("2022","SC","B50","a","hist","uscb","s","171987","171987","0"), ("2022","SC","B59","a","hist","uscb","s","133357","133357","0"), ("2022","SC","B79","a","hist","uscb","s","11257262","11257262","0"), ("2022","SC","B80","a","hist","uscb","s","0","0","0"), ("2022","SC","B89","a","hist","uscb","s","2665311","510374","2154937")
x42 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","SD","B01","a","hist","uscb","s","12787","12787","0"), ("2022","SD","B21","a","hist","uscb","s","4632907","4632907","0"), ("2022","SD","B22","a","hist","uscb","s","130921","130921","0"), ("2022","SD","B30","a","hist","uscb","s","0","0","0"), ("2022","SD","B42","a","hist","uscb","s","8074546","8074546","0"), ("2022","SD","B46","a","hist","uscb","s","1877317","1877317","0"), ("2022","SD","B50","a","hist","uscb","s","51201","51201","0"), ("2022","SD","B59","a","hist","uscb","s","157537","157537","0"), ("2022","SD","B79","a","hist","uscb","s","29215121","29215121","0"), ("2022","SD","B80","a","hist","uscb","s","66684","66684","0"), ("2022","SD","B89","a","hist","uscb","s","6300371","1013326","5287045")
x44 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","TX","B01","a","hist","uscb","s","36656","36656","0"), ("2022","TX","B21","a","hist","uscb","s","258281","258281","0"), ("2022","TX","B22","a","hist","uscb","s","23982","23982","0"), ("2022","TX","B30","a","hist","uscb","s","7","7","0"), ("2022","TX","B42","a","hist","uscb","s","1806179","1806179","0"), ("2022","TX","B46","a","hist","uscb","s","306740","306740","0"), ("2022","TX","B50","a","hist","uscb","s","6893","6893","0"), ("2022","TX","B59","a","hist","uscb","s","17292","17292","0"), ("2022","TX","B79","a","hist","uscb","s","2367900","2367900","0"), ("2022","TX","B80","a","hist","uscb","s","55762","55762","0"), ("2022","TX","B89","a","hist","uscb","s","693640","442542","251098")
x45 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","UT","B01","a","hist","uscb","s","273","273","0"), ("2022","UT","B21","a","hist","uscb","s","1893470","1893470","0"), ("2022","UT","B22","a","hist","uscb","s","131661","131661","0"), ("2022","UT","B30","a","hist","uscb","s","0","0","0"), ("2022","UT","B42","a","hist","uscb","s","4721799","4721799","0"), ("2022","UT","B46","a","hist","uscb","s","840554","840554","0"), ("2022","UT","B50","a","hist","uscb","s","373915","373915","0"), ("2022","UT","B59","a","hist","uscb","s","54880","54880","0"), ("2022","UT","B79","a","hist","uscb","s","8756445","8756445","0"), ("2022","UT","B80","a","hist","uscb","s","14693","14693","0"), ("2022","UT","B89","a","hist","uscb","s","1655794","560357","1095437")
x46 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","VT","B01","a","hist","uscb","s","42025","42025","0"), ("2022","VT","B21","a","hist","uscb","s","373748","373748","0"), ("2022","VT","B22","a","hist","uscb","s","12150","12150","0"), ("2022","VT","B30","a","hist","uscb","s","0","0","0"), ("2022","VT","B42","a","hist","uscb","s","1505939","1505939","0"), ("2022","VT","B46","a","hist","uscb","s","364291","364291","0"), ("2022","VT","B50","a","hist","uscb","s","35554","35554","0"), ("2022","VT","B59","a","hist","uscb","s","37311","37311","0"), ("2022","VT","B79","a","hist","uscb","s","969110","969110","0"), ("2022","VT","B80","a","hist","uscb","s","404","404","0"), ("2022","VT","B89","a","hist","uscb","s","431303","98866","332437")
x47 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","VA","B01","a","hist","uscb","s","27834","27834","0"), ("2022","VA","B21","a","hist","uscb","s","2172745","2172745","0"), ("2022","VA","B22","a","hist","uscb","s","85839","85839","0"), ("2022","VA","B30","a","hist","uscb","s","341195","341195","0"), ("2022","VA","B42","a","hist","uscb","s","2494887","2494887","0"), ("2022","VA","B46","a","hist","uscb","s","1153938","1153938","0"), ("2022","VA","B50","a","hist","uscb","s","535661","535661","0"), ("2022","VA","B59","a","hist","uscb","s","176276","176276","0"), ("2022","VA","B79","a","hist","uscb","s","10137824","10137824","0"), ("2022","VA","B80","a","hist","uscb","s","38372","38372","0"), ("2022","VA","B89","a","hist","uscb","s","2487197","852091","1635106")
x48 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","WA","B01","a","hist","uscb","s","1291","1291","0"), ("2022","WA","B21","a","hist","uscb","s","9830961","9830961","0"), ("2022","WA","B22","a","hist","uscb","s","104197","104197","0"), ("2022","WA","B30","a","hist","uscb","s","0","0","0"), ("2022","WA","B42","a","hist","uscb","s","18131396","18131396","0"), ("2022","WA","B46","a","hist","uscb","s","4529698","4529698","0"), ("2022","WA","B50","a","hist","uscb","s","74062","74062","0"), ("2022","WA","B59","a","hist","uscb","s","340737","340737","0"), ("2022","WA","B79","a","hist","uscb","s","42828555","42828555","0"), ("2022","WA","B80","a","hist","uscb","s","85384","85384","0"), ("2022","WA","B89","a","hist","uscb","s","12994668","3017309","9977359")
x49 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","WV","B01","a","hist","uscb","s","246","246","0"), ("2022","WV","B21","a","hist","uscb","s","1747384","1747384","0"), ("2022","WV","B22","a","hist","uscb","s","11182","11182","0"), ("2022","WV","B30","a","hist","uscb","s","2739","2739","0"), ("2022","WV","B42","a","hist","uscb","s","908780","908780","0"), ("2022","WV","B46","a","hist","uscb","s","419332","419332","0"), ("2022","WV","B50","a","hist","uscb","s","10942","10942","0"), ("2022","WV","B59","a","hist","uscb","s","63466","63466","0"), ("2022","WV","B79","a","hist","uscb","s","4930014","4930014","0"), ("2022","WV","B80","a","hist","uscb","s","30896","30896","0"), ("2022","WV","B89","a","hist","uscb","s","2013427","575828","1437599")
x50 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","WI","B01","a","hist","uscb","s","3579","3579","0"), ("2022","WI","B21","a","hist","uscb","s","450962","450962","0"), ("2022","WI","B22","a","hist","uscb","s","0","0","0"), ("2022","WI","B30","a","hist","uscb","s","0","0","0"), ("2022","WI","B42","a","hist","uscb","s","1341106","1341106","0"), ("2022","WI","B46","a","hist","uscb","s","273696","273696","0"), ("2022","WI","B50","a","hist","uscb","s","62322","62322","0"), ("2022","WI","B59","a","hist","uscb","s","25093","25093","0"), ("2022","WI","B79","a","hist","uscb","s","1653123","1653123","0"), ("2022","WI","B80","a","hist","uscb","s","0","0","0"), ("2022","WI","B89","a","hist","uscb","s","427851","327813","100038")
x51 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2022","WY","B01","a","hist","uscb","s","907","907","0"), ("2022","WY","B21","a","hist","uscb","s","2925493","2925493","0"), ("2022","WY","B22","a","hist","uscb","s","27378","27378","0"), ("2022","WY","B30","a","hist","uscb","s","1124","1124","0"), ("2022","WY","B42","a","hist","uscb","s","3125030","3125030","0"), ("2022","WY","B46","a","hist","uscb","s","1286212","1286212","0"), ("2022","WY","B50","a","hist","uscb","s","103423","103423","0"), ("2022","WY","B59","a","hist","uscb","s","49390","49390","0"), ("2022","WY","B79","a","hist","uscb","s","13380834","13380834","0"), ("2022","WY","B80","a","hist","uscb","s","70321","70321","0"), ("2022","WY","B89","a","hist","uscb","s","2463508","315653","2147855")
x53 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

Done