Load State and Local Spending Update
Year = 2023

return to Menu

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

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","AL","B89","a","hist","uscb","s","754715","0","0"), ("2023","AL","B01","a","hist","uscb","s","46150","0","0"), ("2023","AL","B21","a","hist","uscb","s","3810072","0","0"), ("2023","AL","B22","a","hist","uscb","s","58661","0","0"), ("2023","AL","B30","a","hist","uscb","s","93544","0","0"), ("2023","AL","B42","a","hist","uscb","s","568399","0","0"), ("2023","AL","B46","a","hist","uscb","s","1160050","0","0"), ("2023","AL","B50","a","hist","uscb","s","43257","0","0"), ("2023","AL","B59","a","hist","uscb","s","135820","0","0"), ("2023","AL","B79","a","hist","uscb","s","10285294","0","0"), ("2023","AL","B80","a","hist","uscb","s","497","0","0")
x02 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","AK","B89","a","hist","uscb","s","445999","0","0"), ("2023","AK","B01","a","hist","uscb","s","202031","0","0"), ("2023","AK","B21","a","hist","uscb","s","644887","0","0"), ("2023","AK","B22","a","hist","uscb","s","25836","0","0"), ("2023","AK","B30","a","hist","uscb","s","13127","0","0"), ("2023","AK","B42","a","hist","uscb","s","357841","0","0"), ("2023","AK","B46","a","hist","uscb","s","870653","0","0"), ("2023","AK","B50","a","hist","uscb","s","37590","0","0"), ("2023","AK","B59","a","hist","uscb","s","193387","0","0"), ("2023","AK","B79","a","hist","uscb","s","2336053","0","0"), ("2023","AK","B80","a","hist","uscb","s","5917","0","0")
x04 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","AR","B89","a","hist","uscb","s","549053","0","0"), ("2023","AR","B01","a","hist","uscb","s","2386","0","0"), ("2023","AR","B21","a","hist","uscb","s","3474298","0","0"), ("2023","AR","B22","a","hist","uscb","s","120410","0","0"), ("2023","AR","B30","a","hist","uscb","s","0","0","0"), ("2023","AR","B42","a","hist","uscb","s","799693","0","0"), ("2023","AR","B46","a","hist","uscb","s","1113146","0","0"), ("2023","AR","B50","a","hist","uscb","s","127347","0","0"), ("2023","AR","B59","a","hist","uscb","s","152310","0","0"), ("2023","AR","B79","a","hist","uscb","s","21260982","0","0"), ("2023","AR","B80","a","hist","uscb","s","29919","0","0")
x05 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","CA","B89","a","hist","uscb","s","436758","0","0"), ("2023","CA","B01","a","hist","uscb","s","200","0","0"), ("2023","CA","B21","a","hist","uscb","s","1370207","0","0"), ("2023","CA","B22","a","hist","uscb","s","165330","0","0"), ("2023","CA","B30","a","hist","uscb","s","0","0","0"), ("2023","CA","B42","a","hist","uscb","s","705109","0","0"), ("2023","CA","B46","a","hist","uscb","s","992637","0","0"), ("2023","CA","B50","a","hist","uscb","s","40325","0","0"), ("2023","CA","B59","a","hist","uscb","s","119383","0","0"), ("2023","CA","B79","a","hist","uscb","s","7168068","0","0"), ("2023","CA","B80","a","hist","uscb","s","16889","0","0")
x06 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","CO","B89","a","hist","uscb","s","3751775","0","0"), ("2023","CO","B01","a","hist","uscb","s","0","0","0"), ("2023","CO","B21","a","hist","uscb","s","12464876","0","0"), ("2023","CO","B22","a","hist","uscb","s","189372","0","0"), ("2023","CO","B30","a","hist","uscb","s","0","0","0"), ("2023","CO","B42","a","hist","uscb","s","2374720","0","0"), ("2023","CO","B46","a","hist","uscb","s","8591539","0","0"), ("2023","CO","B50","a","hist","uscb","s","481980","0","0"), ("2023","CO","B59","a","hist","uscb","s","483648","0","0"), ("2023","CO","B79","a","hist","uscb","s","104545771","0","0"), ("2023","CO","B80","a","hist","uscb","s","954630","0","0")
x08 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","DE","B89","a","hist","uscb","s","563777","0","0"), ("2023","DE","B01","a","hist","uscb","s","0","0","0"), ("2023","DE","B21","a","hist","uscb","s","2853815","0","0"), ("2023","DE","B22","a","hist","uscb","s","94078","0","0"), ("2023","DE","B30","a","hist","uscb","s","0","0","0"), ("2023","DE","B42","a","hist","uscb","s","3008483","0","0"), ("2023","DE","B46","a","hist","uscb","s","839019","0","0"), ("2023","DE","B50","a","hist","uscb","s","440604","0","0"), ("2023","DE","B59","a","hist","uscb","s","195273","0","0"), ("2023","DE","B79","a","hist","uscb","s","8388915","0","0"), ("2023","DE","B80","a","hist","uscb","s","11882","0","0")
x09 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","DC","B89","a","hist","uscb","s","795439","0","0"), ("2023","DC","B01","a","hist","uscb","s","172","0","0"), ("2023","DC","B21","a","hist","uscb","s","1109226","0","0"), ("2023","DC","B22","a","hist","uscb","s","31050","0","0"), ("2023","DC","B30","a","hist","uscb","s","0","0","0"), ("2023","DC","B42","a","hist","uscb","s","1247095","0","0"), ("2023","DC","B46","a","hist","uscb","s","902751","0","0"), ("2023","DC","B50","a","hist","uscb","s","189699","0","0"), ("2023","DC","B59","a","hist","uscb","s","52550","0","0"), ("2023","DC","B79","a","hist","uscb","s","7267259","0","0"), ("2023","DC","B80","a","hist","uscb","s","21015","0","0")
x10 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","FL","B89","a","hist","uscb","s","190856","0","0"), ("2023","FL","B01","a","hist","uscb","s","0","0","0"), ("2023","FL","B21","a","hist","uscb","s","406577","0","0"), ("2023","FL","B22","a","hist","uscb","s","18474","0","0"), ("2023","FL","B30","a","hist","uscb","s","0","0","0"), ("2023","FL","B42","a","hist","uscb","s","409752","0","0"), ("2023","FL","B46","a","hist","uscb","s","345799","0","0"), ("2023","FL","B50","a","hist","uscb","s","94455","0","0"), ("2023","FL","B59","a","hist","uscb","s","23381","0","0"), ("2023","FL","B79","a","hist","uscb","s","2458942","0","0"), ("2023","FL","B80","a","hist","uscb","s","37120","0","0")
x11 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

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

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","HI","B89","a","hist","uscb","s","3368900","0","0"), ("2023","HI","B01","a","hist","uscb","s","0","0","0"), ("2023","HI","B21","a","hist","uscb","s","10880057","0","0"), ("2023","HI","B22","a","hist","uscb","s","264715","0","0"), ("2023","HI","B30","a","hist","uscb","s","0","0","0"), ("2023","HI","B42","a","hist","uscb","s","3483952","0","0"), ("2023","HI","B46","a","hist","uscb","s","3529161","0","0"), ("2023","HI","B50","a","hist","uscb","s","958552","0","0"), ("2023","HI","B59","a","hist","uscb","s","247380","0","0"), ("2023","HI","B79","a","hist","uscb","s","26160876","0","0"), ("2023","HI","B80","a","hist","uscb","s","50640","0","0")
x13 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","ID","B89","a","hist","uscb","s","1604305","0","0"), ("2023","ID","B01","a","hist","uscb","s","43132","0","0"), ("2023","ID","B21","a","hist","uscb","s","5187554","0","0"), ("2023","ID","B22","a","hist","uscb","s","26681","0","0"), ("2023","ID","B30","a","hist","uscb","s","0","0","0"), ("2023","ID","B42","a","hist","uscb","s","5035687","0","0"), ("2023","ID","B46","a","hist","uscb","s","2029459","0","0"), ("2023","ID","B50","a","hist","uscb","s","556818","0","0"), ("2023","ID","B59","a","hist","uscb","s","177873","0","0"), ("2023","ID","B79","a","hist","uscb","s","10887620","0","0"), ("2023","ID","B80","a","hist","uscb","s","51461","0","0")
x15 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","IN","B89","a","hist","uscb","s","461344","0","0"), ("2023","IN","B01","a","hist","uscb","s","95367","0","0"), ("2023","IN","B21","a","hist","uscb","s","960532","0","0"), ("2023","IN","B22","a","hist","uscb","s","40830","0","0"), ("2023","IN","B30","a","hist","uscb","s","0","0","0"), ("2023","IN","B42","a","hist","uscb","s","285972","0","0"), ("2023","IN","B46","a","hist","uscb","s","264591","0","0"), ("2023","IN","B50","a","hist","uscb","s","120083","0","0"), ("2023","IN","B59","a","hist","uscb","s","65020","0","0"), ("2023","IN","B79","a","hist","uscb","s","2546997","0","0"), ("2023","IN","B80","a","hist","uscb","s","22445","0","0")
x16 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","IA","B89","a","hist","uscb","s","159465","0","0"), ("2023","IA","B01","a","hist","uscb","s","256","0","0"), ("2023","IA","B21","a","hist","uscb","s","481919","0","0"), ("2023","IA","B22","a","hist","uscb","s","18062","0","0"), ("2023","IA","B30","a","hist","uscb","s","0","0","0"), ("2023","IA","B42","a","hist","uscb","s","552815","0","0"), ("2023","IA","B46","a","hist","uscb","s","508387","0","0"), ("2023","IA","B50","a","hist","uscb","s","124842","0","0"), ("2023","IA","B59","a","hist","uscb","s","54219","0","0"), ("2023","IA","B79","a","hist","uscb","s","2593418","0","0"), ("2023","IA","B80","a","hist","uscb","s","12805","0","0")
x17 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","KS","B89","a","hist","uscb","s","1368186","0","0"), ("2023","KS","B01","a","hist","uscb","s","86450","0","0"), ("2023","KS","B21","a","hist","uscb","s","6036995","0","0"), ("2023","KS","B22","a","hist","uscb","s","201994","0","0"), ("2023","KS","B30","a","hist","uscb","s","0","0","0"), ("2023","KS","B42","a","hist","uscb","s","915942","0","0"), ("2023","KS","B46","a","hist","uscb","s","2256383","0","0"), ("2023","KS","B50","a","hist","uscb","s","463509","0","0"), ("2023","KS","B59","a","hist","uscb","s","116972","0","0"), ("2023","KS","B79","a","hist","uscb","s","24292722","0","0"), ("2023","KS","B80","a","hist","uscb","s","210016","0","0")
x18 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","KY","B89","a","hist","uscb","s","454800","0","0"), ("2023","KY","B01","a","hist","uscb","s","315","0","0"), ("2023","KY","B21","a","hist","uscb","s","2627972","0","0"), ("2023","KY","B22","a","hist","uscb","s","93735","0","0"), ("2023","KY","B30","a","hist","uscb","s","0","0","0"), ("2023","KY","B42","a","hist","uscb","s","1770269","0","0"), ("2023","KY","B46","a","hist","uscb","s","1368118","0","0"), ("2023","KY","B50","a","hist","uscb","s","738349","0","0"), ("2023","KY","B59","a","hist","uscb","s","140786","0","0"), ("2023","KY","B79","a","hist","uscb","s","16355871","0","0"), ("2023","KY","B80","a","hist","uscb","s","68842","0","0")
x19 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","LA","B89","a","hist","uscb","s","431855","0","0"), ("2023","LA","B01","a","hist","uscb","s","198","0","0"), ("2023","LA","B21","a","hist","uscb","s","1284131","0","0"), ("2023","LA","B22","a","hist","uscb","s","64171","0","0"), ("2023","LA","B30","a","hist","uscb","s","0","0","0"), ("2023","LA","B42","a","hist","uscb","s","619529","0","0"), ("2023","LA","B46","a","hist","uscb","s","830080","0","0"), ("2023","LA","B50","a","hist","uscb","s","209326","0","0"), ("2023","LA","B59","a","hist","uscb","s","122974","0","0"), ("2023","LA","B79","a","hist","uscb","s","6799910","0","0"), ("2023","LA","B80","a","hist","uscb","s","40004","0","0")
x20 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","ME","B89","a","hist","uscb","s","257562","0","0"), ("2023","ME","B01","a","hist","uscb","s","131","0","0"), ("2023","ME","B21","a","hist","uscb","s","1263887","0","0"), ("2023","ME","B22","a","hist","uscb","s","41481","0","0"), ("2023","ME","B30","a","hist","uscb","s","0","0","0"), ("2023","ME","B42","a","hist","uscb","s","1053123","0","0"), ("2023","ME","B46","a","hist","uscb","s","489905","0","0"), ("2023","ME","B50","a","hist","uscb","s","92467","0","0"), ("2023","ME","B59","a","hist","uscb","s","80302","0","0"), ("2023","ME","B79","a","hist","uscb","s","3870586","0","0"), ("2023","ME","B80","a","hist","uscb","s","28837","0","0")
x21 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MD","B89","a","hist","uscb","s","812355","0","0"), ("2023","MD","B01","a","hist","uscb","s","1058","0","0"), ("2023","MD","B21","a","hist","uscb","s","2650610","0","0"), ("2023","MD","B22","a","hist","uscb","s","165373","0","0"), ("2023","MD","B30","a","hist","uscb","s","11902","0","0"), ("2023","MD","B42","a","hist","uscb","s","502118","0","0"), ("2023","MD","B46","a","hist","uscb","s","1131641","0","0"), ("2023","MD","B50","a","hist","uscb","s","317252","0","0"), ("2023","MD","B59","a","hist","uscb","s","207501","0","0"), ("2023","MD","B79","a","hist","uscb","s","15683043","0","0"), ("2023","MD","B80","a","hist","uscb","s","0","0","0")
x22 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MA","B89","a","hist","uscb","s","2579185","0","0"), ("2023","MA","B01","a","hist","uscb","s","1102","0","0"), ("2023","MA","B21","a","hist","uscb","s","3310062","0","0"), ("2023","MA","B22","a","hist","uscb","s","161666","0","0"), ("2023","MA","B30","a","hist","uscb","s","0","0","0"), ("2023","MA","B42","a","hist","uscb","s","487303","0","0"), ("2023","MA","B46","a","hist","uscb","s","1291033","0","0"), ("2023","MA","B50","a","hist","uscb","s","27542","0","0"), ("2023","MA","B59","a","hist","uscb","s","155573","0","0"), ("2023","MA","B79","a","hist","uscb","s","14366974","0","0"), ("2023","MA","B80","a","hist","uscb","s","1818","0","0")
x23 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MI","B89","a","hist","uscb","s","224582","0","0"), ("2023","MI","B01","a","hist","uscb","s","1139","0","0"), ("2023","MI","B21","a","hist","uscb","s","482259","0","0"), ("2023","MI","B22","a","hist","uscb","s","54673","0","0"), ("2023","MI","B30","a","hist","uscb","s","0","0","0"), ("2023","MI","B42","a","hist","uscb","s","233804","0","0"), ("2023","MI","B46","a","hist","uscb","s","364228","0","0"), ("2023","MI","B50","a","hist","uscb","s","35053","0","0"), ("2023","MI","B59","a","hist","uscb","s","59385","0","0"), ("2023","MI","B79","a","hist","uscb","s","3641468","0","0"), ("2023","MI","B80","a","hist","uscb","s","23587","0","0")
x24 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MN","B89","a","hist","uscb","s","2267489","0","0"), ("2023","MN","B01","a","hist","uscb","s","68222","0","0"), ("2023","MN","B21","a","hist","uscb","s","2981360","0","0"), ("2023","MN","B22","a","hist","uscb","s","116262","0","0"), ("2023","MN","B30","a","hist","uscb","s","0","0","0"), ("2023","MN","B42","a","hist","uscb","s","2115541","0","0"), ("2023","MN","B46","a","hist","uscb","s","843426","0","0"), ("2023","MN","B50","a","hist","uscb","s","608536","0","0"), ("2023","MN","B59","a","hist","uscb","s","57654","0","0"), ("2023","MN","B79","a","hist","uscb","s","12025752","0","0"), ("2023","MN","B80","a","hist","uscb","s","38526","0","0")
x25 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MS","B89","a","hist","uscb","s","2155361","0","0"), ("2023","MS","B01","a","hist","uscb","s","94621","0","0"), ("2023","MS","B21","a","hist","uscb","s","2690911","0","0"), ("2023","MS","B22","a","hist","uscb","s","138195","0","0"), ("2023","MS","B30","a","hist","uscb","s","0","0","0"), ("2023","MS","B42","a","hist","uscb","s","1661880","0","0"), ("2023","MS","B46","a","hist","uscb","s","732803","0","0"), ("2023","MS","B50","a","hist","uscb","s","1437789","0","0"), ("2023","MS","B59","a","hist","uscb","s","52183","0","0"), ("2023","MS","B79","a","hist","uscb","s","15396608","0","0"), ("2023","MS","B80","a","hist","uscb","s","105669","0","0")
x26 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MO","B89","a","hist","uscb","s","1410239","0","0"), ("2023","MO","B01","a","hist","uscb","s","160493","0","0"), ("2023","MO","B21","a","hist","uscb","s","4648717","0","0"), ("2023","MO","B22","a","hist","uscb","s","265996","0","0"), ("2023","MO","B30","a","hist","uscb","s","0","0","0"), ("2023","MO","B42","a","hist","uscb","s","5022620","0","0"), ("2023","MO","B46","a","hist","uscb","s","1170239","0","0"), ("2023","MO","B50","a","hist","uscb","s","850404","0","0"), ("2023","MO","B59","a","hist","uscb","s","91872","0","0"), ("2023","MO","B79","a","hist","uscb","s","20209922","0","0"), ("2023","MO","B80","a","hist","uscb","s","455","0","0")
x27 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","MT","B89","a","hist","uscb","s","650783","0","0"), ("2023","MT","B01","a","hist","uscb","s","64036","0","0"), ("2023","MT","B21","a","hist","uscb","s","2308977","0","0"), ("2023","MT","B22","a","hist","uscb","s","90172","0","0"), ("2023","MT","B30","a","hist","uscb","s","0","0","0"), ("2023","MT","B42","a","hist","uscb","s","791648","0","0"), ("2023","MT","B46","a","hist","uscb","s","991496","0","0"), ("2023","MT","B50","a","hist","uscb","s","55367","0","0"), ("2023","MT","B59","a","hist","uscb","s","69111","0","0"), ("2023","MT","B79","a","hist","uscb","s","14481231","0","0"), ("2023","MT","B80","a","hist","uscb","s","29766","0","0")
x28 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NE","B89","a","hist","uscb","s","478930","0","0"), ("2023","NE","B01","a","hist","uscb","s","0","0","0"), ("2023","NE","B21","a","hist","uscb","s","1446758","0","0"), ("2023","NE","B22","a","hist","uscb","s","95776","0","0"), ("2023","NE","B30","a","hist","uscb","s","1938","0","0"), ("2023","NE","B42","a","hist","uscb","s","1067720","0","0"), ("2023","NE","B46","a","hist","uscb","s","787753","0","0"), ("2023","NE","B50","a","hist","uscb","s","74656","0","0"), ("2023","NE","B59","a","hist","uscb","s","149195","0","0"), ("2023","NE","B79","a","hist","uscb","s","7308260","0","0"), ("2023","NE","B80","a","hist","uscb","s","14532","0","0")
x29 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NV","B89","a","hist","uscb","s","511622","0","0"), ("2023","NV","B01","a","hist","uscb","s","23031","0","0"), ("2023","NV","B21","a","hist","uscb","s","2927768","0","0"), ("2023","NV","B22","a","hist","uscb","s","49757","0","0"), ("2023","NV","B30","a","hist","uscb","s","0","0","0"), ("2023","NV","B42","a","hist","uscb","s","3117868","0","0"), ("2023","NV","B46","a","hist","uscb","s","1422547","0","0"), ("2023","NV","B50","a","hist","uscb","s","341507","0","0"), ("2023","NV","B59","a","hist","uscb","s","129110","0","0"), ("2023","NV","B79","a","hist","uscb","s","11291957","0","0"), ("2023","NV","B80","a","hist","uscb","s","119813","0","0")
x30 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NH","B89","a","hist","uscb","s","317033","0","0"), ("2023","NH","B01","a","hist","uscb","s","9354","0","0"), ("2023","NH","B21","a","hist","uscb","s","503683","0","0"), ("2023","NH","B22","a","hist","uscb","s","31770","0","0"), ("2023","NH","B30","a","hist","uscb","s","0","0","0"), ("2023","NH","B42","a","hist","uscb","s","796739","0","0"), ("2023","NH","B46","a","hist","uscb","s","716655","0","0"), ("2023","NH","B50","a","hist","uscb","s","69323","0","0"), ("2023","NH","B59","a","hist","uscb","s","100357","0","0"), ("2023","NH","B79","a","hist","uscb","s","2120912","0","0"), ("2023","NH","B80","a","hist","uscb","s","9834","0","0")
x31 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NJ","B89","a","hist","uscb","s","378430","0","0"), ("2023","NJ","B01","a","hist","uscb","s","38524","0","0"), ("2023","NJ","B21","a","hist","uscb","s","400715","0","0"), ("2023","NJ","B22","a","hist","uscb","s","0","0","0"), ("2023","NJ","B30","a","hist","uscb","s","0","0","0"), ("2023","NJ","B42","a","hist","uscb","s","23555","0","0"), ("2023","NJ","B46","a","hist","uscb","s","568352","0","0"), ("2023","NJ","B50","a","hist","uscb","s","0","0","0"), ("2023","NJ","B59","a","hist","uscb","s","78266","0","0"), ("2023","NJ","B79","a","hist","uscb","s","4404474","0","0"), ("2023","NJ","B80","a","hist","uscb","s","14163","0","0")
x32 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NM","B89","a","hist","uscb","s","208912","0","0"), ("2023","NM","B01","a","hist","uscb","s","0","0","0"), ("2023","NM","B21","a","hist","uscb","s","900094","0","0"), ("2023","NM","B22","a","hist","uscb","s","90917","0","0"), ("2023","NM","B30","a","hist","uscb","s","373408","0","0"), ("2023","NM","B42","a","hist","uscb","s","1182710","0","0"), ("2023","NM","B46","a","hist","uscb","s","437590","0","0"), ("2023","NM","B50","a","hist","uscb","s","10424","0","0"), ("2023","NM","B59","a","hist","uscb","s","58148","0","0"), ("2023","NM","B79","a","hist","uscb","s","5092862","0","0"), ("2023","NM","B80","a","hist","uscb","s","9501","0","0")
x33 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NY","B89","a","hist","uscb","s","739841","0","0"), ("2023","NY","B01","a","hist","uscb","s","2466","0","0"), ("2023","NY","B21","a","hist","uscb","s","290921","0","0"), ("2023","NY","B22","a","hist","uscb","s","29945","0","0"), ("2023","NY","B30","a","hist","uscb","s","0","0","0"), ("2023","NY","B42","a","hist","uscb","s","38844","0","0"), ("2023","NY","B46","a","hist","uscb","s","224338","0","0"), ("2023","NY","B50","a","hist","uscb","s","126883","0","0"), ("2023","NY","B59","a","hist","uscb","s","44082","0","0"), ("2023","NY","B79","a","hist","uscb","s","1773863","0","0"), ("2023","NY","B80","a","hist","uscb","s","0","0","0")
x34 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","NC","B89","a","hist","uscb","s","4834601","0","0"), ("2023","NC","B01","a","hist","uscb","s","979","0","0"), ("2023","NC","B21","a","hist","uscb","s","2641551","0","0"), ("2023","NC","B22","a","hist","uscb","s","194223","0","0"), ("2023","NC","B30","a","hist","uscb","s","0","0","0"), ("2023","NC","B42","a","hist","uscb","s","3950978","0","0"), ("2023","NC","B46","a","hist","uscb","s","1306119","0","0"), ("2023","NC","B50","a","hist","uscb","s","501876","0","0"), ("2023","NC","B59","a","hist","uscb","s","49103","0","0"), ("2023","NC","B79","a","hist","uscb","s","16198750","0","0"), ("2023","NC","B80","a","hist","uscb","s","50222","0","0")
x35 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","ND","B89","a","hist","uscb","s","583951","0","0"), ("2023","ND","B01","a","hist","uscb","s","2","0","0"), ("2023","ND","B21","a","hist","uscb","s","1683849","0","0"), ("2023","ND","B22","a","hist","uscb","s","16585","0","0"), ("2023","ND","B30","a","hist","uscb","s","0","0","0"), ("2023","ND","B42","a","hist","uscb","s","221399","0","0"), ("2023","ND","B46","a","hist","uscb","s","539136","0","0"), ("2023","ND","B50","a","hist","uscb","s","93267","0","0"), ("2023","ND","B59","a","hist","uscb","s","106611","0","0"), ("2023","ND","B79","a","hist","uscb","s","9178133","0","0"), ("2023","ND","B80","a","hist","uscb","s","13916","0","0")
x36 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","OH","B89","a","hist","uscb","s","8900561","0","0"), ("2023","OH","B01","a","hist","uscb","s","40","0","0"), ("2023","OH","B21","a","hist","uscb","s","6159505","0","0"), ("2023","OH","B22","a","hist","uscb","s","315162","0","0"), ("2023","OH","B30","a","hist","uscb","s","0","0","0"), ("2023","OH","B42","a","hist","uscb","s","5469277","0","0"), ("2023","OH","B46","a","hist","uscb","s","2043615","0","0"), ("2023","OH","B50","a","hist","uscb","s","3033320","0","0"), ("2023","OH","B59","a","hist","uscb","s","609455","0","0"), ("2023","OH","B79","a","hist","uscb","s","73555946","0","0"), ("2023","OH","B80","a","hist","uscb","s","474139","0","0")
x37 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","OK","B89","a","hist","uscb","s","1298092","0","0"), ("2023","OK","B01","a","hist","uscb","s","21949","0","0"), ("2023","OK","B21","a","hist","uscb","s","3722430","0","0"), ("2023","OK","B22","a","hist","uscb","s","167931","0","0"), ("2023","OK","B30","a","hist","uscb","s","0","0","0"), ("2023","OK","B42","a","hist","uscb","s","2365962","0","0"), ("2023","OK","B46","a","hist","uscb","s","1576637","0","0"), ("2023","OK","B50","a","hist","uscb","s","359703","0","0"), ("2023","OK","B59","a","hist","uscb","s","108621","0","0"), ("2023","OK","B79","a","hist","uscb","s","21670934","0","0"), ("2023","OK","B80","a","hist","uscb","s","133639","0","0")
x38 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","OR","B89","a","hist","uscb","s","211891","0","0"), ("2023","OR","B01","a","hist","uscb","s","154","0","0"), ("2023","OR","B21","a","hist","uscb","s","590981","0","0"), ("2023","OR","B22","a","hist","uscb","s","12610","0","0"), ("2023","OR","B30","a","hist","uscb","s","0","0","0"), ("2023","OR","B42","a","hist","uscb","s","240360","0","0"), ("2023","OR","B46","a","hist","uscb","s","521396","0","0"), ("2023","OR","B50","a","hist","uscb","s","20648","0","0"), ("2023","OR","B59","a","hist","uscb","s","72563","0","0"), ("2023","OR","B79","a","hist","uscb","s","1089511","0","0"), ("2023","OR","B80","a","hist","uscb","s","22073","0","0")
x39 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","PA","B89","a","hist","uscb","s","932466","0","0"), ("2023","PA","B01","a","hist","uscb","s","0","0","0"), ("2023","PA","B21","a","hist","uscb","s","3416623","0","0"), ("2023","PA","B22","a","hist","uscb","s","199335","0","0"), ("2023","PA","B30","a","hist","uscb","s","0","0","0"), ("2023","PA","B42","a","hist","uscb","s","4031806","0","0"), ("2023","PA","B46","a","hist","uscb","s","1920154","0","0"), ("2023","PA","B50","a","hist","uscb","s","178555","0","0"), ("2023","PA","B59","a","hist","uscb","s","130255","0","0"), ("2023","PA","B79","a","hist","uscb","s","27420252","0","0"), ("2023","PA","B80","a","hist","uscb","s","165606","0","0")
x40 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","RI","B89","a","hist","uscb","s","407506","0","0"), ("2023","RI","B01","a","hist","uscb","s","944","0","0"), ("2023","RI","B21","a","hist","uscb","s","2043677","0","0"), ("2023","RI","B22","a","hist","uscb","s","52394","0","0"), ("2023","RI","B30","a","hist","uscb","s","0","0","0"), ("2023","RI","B42","a","hist","uscb","s","313892","0","0"), ("2023","RI","B46","a","hist","uscb","s","1112633","0","0"), ("2023","RI","B50","a","hist","uscb","s","223118","0","0"), ("2023","RI","B59","a","hist","uscb","s","132568","0","0"), ("2023","RI","B79","a","hist","uscb","s","9966445","0","0"), ("2023","RI","B80","a","hist","uscb","s","0","0","0")
x41 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","SC","B89","a","hist","uscb","s","891343","0","0"), ("2023","SC","B01","a","hist","uscb","s","1162","0","0"), ("2023","SC","B21","a","hist","uscb","s","2560224","0","0"), ("2023","SC","B22","a","hist","uscb","s","81463","0","0"), ("2023","SC","B30","a","hist","uscb","s","0","0","0"), ("2023","SC","B42","a","hist","uscb","s","845540","0","0"), ("2023","SC","B46","a","hist","uscb","s","670350","0","0"), ("2023","SC","B50","a","hist","uscb","s","102879","0","0"), ("2023","SC","B59","a","hist","uscb","s","157071","0","0"), ("2023","SC","B79","a","hist","uscb","s","12278233","0","0"), ("2023","SC","B80","a","hist","uscb","s","0","0","0")
x42 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","SD","B89","a","hist","uscb","s","1231567","0","0"), ("2023","SD","B01","a","hist","uscb","s","8940","0","0"), ("2023","SD","B21","a","hist","uscb","s","4841909","0","0"), ("2023","SD","B22","a","hist","uscb","s","140171","0","0"), ("2023","SD","B30","a","hist","uscb","s","0","0","0"), ("2023","SD","B42","a","hist","uscb","s","4165454","0","0"), ("2023","SD","B46","a","hist","uscb","s","2570077","0","0"), ("2023","SD","B50","a","hist","uscb","s","56650","0","0"), ("2023","SD","B59","a","hist","uscb","s","209041","0","0"), ("2023","SD","B79","a","hist","uscb","s","31270767","0","0"), ("2023","SD","B80","a","hist","uscb","s","63028","0","0")
x44 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","TX","B89","a","hist","uscb","s","283904","0","0"), ("2023","TX","B01","a","hist","uscb","s","32837","0","0"), ("2023","TX","B21","a","hist","uscb","s","275157","0","0"), ("2023","TX","B22","a","hist","uscb","s","20799","0","0"), ("2023","TX","B30","a","hist","uscb","s","477","0","0"), ("2023","TX","B42","a","hist","uscb","s","1168466","0","0"), ("2023","TX","B46","a","hist","uscb","s","359524","0","0"), ("2023","TX","B50","a","hist","uscb","s","12583","0","0"), ("2023","TX","B59","a","hist","uscb","s","26887","0","0"), ("2023","TX","B79","a","hist","uscb","s","2362235","0","0"), ("2023","TX","B80","a","hist","uscb","s","34605","0","0")
x45 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","UT","B89","a","hist","uscb","s","551505","0","0"), ("2023","UT","B01","a","hist","uscb","s","311","0","0"), ("2023","UT","B21","a","hist","uscb","s","1994544","0","0"), ("2023","UT","B22","a","hist","uscb","s","48623","0","0"), ("2023","UT","B30","a","hist","uscb","s","0","0","0"), ("2023","UT","B42","a","hist","uscb","s","1638458","0","0"), ("2023","UT","B46","a","hist","uscb","s","1045611","0","0"), ("2023","UT","B50","a","hist","uscb","s","199267","0","0"), ("2023","UT","B59","a","hist","uscb","s","79512","0","0"), ("2023","UT","B79","a","hist","uscb","s","9452940","0","0"), ("2023","UT","B80","a","hist","uscb","s","0","0","0")
x46 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","VT","B89","a","hist","uscb","s","173021","0","0"), ("2023","VT","B01","a","hist","uscb","s","38274","0","0"), ("2023","VT","B21","a","hist","uscb","s","340973","0","0"), ("2023","VT","B22","a","hist","uscb","s","11417","0","0"), ("2023","VT","B30","a","hist","uscb","s","0","0","0"), ("2023","VT","B42","a","hist","uscb","s","440662","0","0"), ("2023","VT","B46","a","hist","uscb","s","591393","0","0"), ("2023","VT","B50","a","hist","uscb","s","51194","0","0"), ("2023","VT","B59","a","hist","uscb","s","56653","0","0"), ("2023","VT","B79","a","hist","uscb","s","1140179","0","0"), ("2023","VT","B80","a","hist","uscb","s","526","0","0")
x47 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","VA","B89","a","hist","uscb","s","926761","0","0"), ("2023","VA","B01","a","hist","uscb","s","26304","0","0"), ("2023","VA","B21","a","hist","uscb","s","1726664","0","0"), ("2023","VA","B22","a","hist","uscb","s","93763","0","0"), ("2023","VA","B30","a","hist","uscb","s","392057","0","0"), ("2023","VA","B42","a","hist","uscb","s","2619228","0","0"), ("2023","VA","B46","a","hist","uscb","s","1233112","0","0"), ("2023","VA","B50","a","hist","uscb","s","523746","0","0"), ("2023","VA","B59","a","hist","uscb","s","359022","0","0"), ("2023","VA","B79","a","hist","uscb","s","12123331","0","0"), ("2023","VA","B80","a","hist","uscb","s","48734","0","0")
x48 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","WA","B89","a","hist","uscb","s","3677976","0","0"), ("2023","WA","B01","a","hist","uscb","s","253","0","0"), ("2023","WA","B21","a","hist","uscb","s","10381106","0","0"), ("2023","WA","B22","a","hist","uscb","s","87858","0","0"), ("2023","WA","B30","a","hist","uscb","s","0","0","0"), ("2023","WA","B42","a","hist","uscb","s","10973167","0","0"), ("2023","WA","B46","a","hist","uscb","s","5201152","0","0"), ("2023","WA","B50","a","hist","uscb","s","103860","0","0"), ("2023","WA","B59","a","hist","uscb","s","458583","0","0"), ("2023","WA","B79","a","hist","uscb","s","37474935","0","0"), ("2023","WA","B80","a","hist","uscb","s","121403","0","0")
x49 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","WV","B89","a","hist","uscb","s","315899","0","0"), ("2023","WV","B01","a","hist","uscb","s","100","0","0"), ("2023","WV","B21","a","hist","uscb","s","1552758","0","0"), ("2023","WV","B22","a","hist","uscb","s","13163","0","0"), ("2023","WV","B30","a","hist","uscb","s","1077","0","0"), ("2023","WV","B42","a","hist","uscb","s","789068","0","0"), ("2023","WV","B46","a","hist","uscb","s","573044","0","0"), ("2023","WV","B50","a","hist","uscb","s","9381","0","0"), ("2023","WV","B59","a","hist","uscb","s","73834","0","0"), ("2023","WV","B79","a","hist","uscb","s","5120964","0","0"), ("2023","WV","B80","a","hist","uscb","s","21239","0","0")
x50 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","WI","B89","a","hist","uscb","s","216967","0","0"), ("2023","WI","B01","a","hist","uscb","s","4557","0","0"), ("2023","WI","B21","a","hist","uscb","s","456565","0","0"), ("2023","WI","B22","a","hist","uscb","s","0","0","0"), ("2023","WI","B30","a","hist","uscb","s","0","0","0"), ("2023","WI","B42","a","hist","uscb","s","139914","0","0"), ("2023","WI","B46","a","hist","uscb","s","347744","0","0"), ("2023","WI","B50","a","hist","uscb","s","61959","0","0"), ("2023","WI","B59","a","hist","uscb","s","69002","0","0"), ("2023","WI","B79","a","hist","uscb","s","1721367","0","0"), ("2023","WI","B80","a","hist","uscb","s","0","0","0")
x51 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

replace government_spending (year,state,code,source,fy,author,spend_rev,spending,state_spending,local_spending) values ("2023","WY","B89","a","hist","uscb","s","423692","0","0"), ("2023","WY","B01","a","hist","uscb","s","165","0","0"), ("2023","WY","B21","a","hist","uscb","s","3410564","0","0"), ("2023","WY","B22","a","hist","uscb","s","31847","0","0"), ("2023","WY","B30","a","hist","uscb","s","1268","0","0"), ("2023","WY","B42","a","hist","uscb","s","2294915","0","0"), ("2023","WY","B46","a","hist","uscb","s","1254689","0","0"), ("2023","WY","B50","a","hist","uscb","s","71962","0","0"), ("2023","WY","B59","a","hist","uscb","s","78435","0","0"), ("2023","WY","B79","a","hist","uscb","s","14575404","0","0"), ("2023","WY","B80","a","hist","uscb","s","80726","0","0")
x53 B89 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80

Done