Load State and Local Spending Update
Year = 2023

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 ("2023","AL","B01","a","hist","uscb","s","25055","0","0"), ("2023","AL","B21","a","hist","uscb","s","3635222","0","0"), ("2023","AL","B22","a","hist","uscb","s","57270","0","0"), ("2023","AL","B30","a","hist","uscb","s","96366","0","0"), ("2023","AL","B42","a","hist","uscb","s","1016182","0","0"), ("2023","AL","B46","a","hist","uscb","s","957613","0","0"), ("2023","AL","B50","a","hist","uscb","s","146977","0","0"), ("2023","AL","B59","a","hist","uscb","s","117368","0","0"), ("2023","AL","B79","a","hist","uscb","s","10983411","0","0"), ("2023","AL","B80","a","hist","uscb","s","17643","0","0"), ("2023","AL","B89","a","hist","uscb","s","614907","0","0")
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 ("2023","AK","B01","a","hist","uscb","s","102262","0","0"), ("2023","AK","B21","a","hist","uscb","s","594961","0","0"), ("2023","AK","B22","a","hist","uscb","s","27395","0","0"), ("2023","AK","B30","a","hist","uscb","s","12213","0","0"), ("2023","AK","B42","a","hist","uscb","s","649938","0","0"), ("2023","AK","B46","a","hist","uscb","s","855897","0","0"), ("2023","AK","B50","a","hist","uscb","s","58629","0","0"), ("2023","AK","B59","a","hist","uscb","s","169246","0","0"), ("2023","AK","B79","a","hist","uscb","s","2383954","0","0"), ("2023","AK","B80","a","hist","uscb","s","1666","0","0"), ("2023","AK","B89","a","hist","uscb","s","478719","0","0")
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 ("2023","AR","B01","a","hist","uscb","s","1208","0","0"), ("2023","AR","B21","a","hist","uscb","s","3350387","0","0"), ("2023","AR","B22","a","hist","uscb","s","128034","0","0"), ("2023","AR","B30","a","hist","uscb","s","0","0","0"), ("2023","AR","B42","a","hist","uscb","s","659735","0","0"), ("2023","AR","B46","a","hist","uscb","s","935976","0","0"), ("2023","AR","B50","a","hist","uscb","s","103853","0","0"), ("2023","AR","B59","a","hist","uscb","s","140303","0","0"), ("2023","AR","B79","a","hist","uscb","s","23929245","0","0"), ("2023","AR","B80","a","hist","uscb","s","13452","0","0"), ("2023","AR","B89","a","hist","uscb","s","492200","0","0")
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 ("2023","CA","B01","a","hist","uscb","s","0","0","0"), ("2023","CA","B21","a","hist","uscb","s","1152919","0","0"), ("2023","CA","B22","a","hist","uscb","s","110742","0","0"), ("2023","CA","B30","a","hist","uscb","s","0","0","0"), ("2023","CA","B42","a","hist","uscb","s","1277716","0","0"), ("2023","CA","B46","a","hist","uscb","s","951138","0","0"), ("2023","CA","B50","a","hist","uscb","s","51818","0","0"), ("2023","CA","B59","a","hist","uscb","s","80950","0","0"), ("2023","CA","B79","a","hist","uscb","s","8094469","0","0"), ("2023","CA","B80","a","hist","uscb","s","16889","0","0"), ("2023","CA","B89","a","hist","uscb","s","361319","0","0")
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 ("2023","CO","B01","a","hist","uscb","s","0","0","0"), ("2023","CO","B21","a","hist","uscb","s","15394224","0","0"), ("2023","CO","B22","a","hist","uscb","s","183568","0","0"), ("2023","CO","B30","a","hist","uscb","s","0","0","0"), ("2023","CO","B42","a","hist","uscb","s","2110710","0","0"), ("2023","CO","B46","a","hist","uscb","s","0","0","0"), ("2023","CO","B50","a","hist","uscb","s","438679","0","0"), ("2023","CO","B59","a","hist","uscb","s","369282","0","0"), ("2023","CO","B79","a","hist","uscb","s","102666694","0","0"), ("2023","CO","B80","a","hist","uscb","s","132453","0","0"), ("2023","CO","B89","a","hist","uscb","s","12151651","0","0")
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 ("2023","DE","B01","a","hist","uscb","s","0","0","0"), ("2023","DE","B21","a","hist","uscb","s","2733081","0","0"), ("2023","DE","B22","a","hist","uscb","s","153044","0","0"), ("2023","DE","B30","a","hist","uscb","s","0","0","0"), ("2023","DE","B42","a","hist","uscb","s","2434761","0","0"), ("2023","DE","B46","a","hist","uscb","s","702672","0","0"), ("2023","DE","B50","a","hist","uscb","s","368103","0","0"), ("2023","DE","B59","a","hist","uscb","s","322445","0","0"), ("2023","DE","B79","a","hist","uscb","s","8220313","0","0"), ("2023","DE","B80","a","hist","uscb","s","10693","0","0"), ("2023","DE","B89","a","hist","uscb","s","140187","0","0")
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 ("2023","DC","B01","a","hist","uscb","s","240","0","0"), ("2023","DC","B21","a","hist","uscb","s","1113196","0","0"), ("2023","DC","B22","a","hist","uscb","s","29223","0","0"), ("2023","DC","B30","a","hist","uscb","s","0","0","0"), ("2023","DC","B42","a","hist","uscb","s","1578680","0","0"), ("2023","DC","B46","a","hist","uscb","s","712697","0","0"), ("2023","DC","B50","a","hist","uscb","s","172718","0","0"), ("2023","DC","B59","a","hist","uscb","s","54207","0","0"), ("2023","DC","B79","a","hist","uscb","s","7376319","0","0"), ("2023","DC","B80","a","hist","uscb","s","3487","0","0"), ("2023","DC","B89","a","hist","uscb","s","743643","0","0")
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 ("2023","FL","B01","a","hist","uscb","s","0","0","0"), ("2023","FL","B21","a","hist","uscb","s","371837","0","0"), ("2023","FL","B22","a","hist","uscb","s","10284","0","0"), ("2023","FL","B30","a","hist","uscb","s","0","0","0"), ("2023","FL","B42","a","hist","uscb","s","388447","0","0"), ("2023","FL","B46","a","hist","uscb","s","330690","0","0"), ("2023","FL","B50","a","hist","uscb","s","157946","0","0"), ("2023","FL","B59","a","hist","uscb","s","20936","0","0"), ("2023","FL","B79","a","hist","uscb","s","2552341","0","0"), ("2023","FL","B80","a","hist","uscb","s","11372","0","0"), ("2023","FL","B89","a","hist","uscb","s","219003","0","0")
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 ("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"), ("2023","GA","B89","a","hist","uscb","s","0","0","0")
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 ("2023","HI","B01","a","hist","uscb","s","0","0","0"), ("2023","HI","B21","a","hist","uscb","s","12191674","0","0"), ("2023","HI","B22","a","hist","uscb","s","218393","0","0"), ("2023","HI","B30","a","hist","uscb","s","0","0","0"), ("2023","HI","B42","a","hist","uscb","s","2973847","0","0"), ("2023","HI","B46","a","hist","uscb","s","2476959","0","0"), ("2023","HI","B50","a","hist","uscb","s","1138391","0","0"), ("2023","HI","B59","a","hist","uscb","s","243093","0","0"), ("2023","HI","B79","a","hist","uscb","s","31102306","0","0"), ("2023","HI","B80","a","hist","uscb","s","98132","0","0"), ("2023","HI","B89","a","hist","uscb","s","2894028","0","0")
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 ("2023","ID","B01","a","hist","uscb","s","44509","0","0"), ("2023","ID","B21","a","hist","uscb","s","5216915","0","0"), ("2023","ID","B22","a","hist","uscb","s","18877","0","0"), ("2023","ID","B30","a","hist","uscb","s","0","0","0"), ("2023","ID","B42","a","hist","uscb","s","5320093","0","0"), ("2023","ID","B46","a","hist","uscb","s","2116029","0","0"), ("2023","ID","B50","a","hist","uscb","s","916089","0","0"), ("2023","ID","B59","a","hist","uscb","s","169681","0","0"), ("2023","ID","B79","a","hist","uscb","s","13613914","0","0"), ("2023","ID","B80","a","hist","uscb","s","50598","0","0"), ("2023","ID","B89","a","hist","uscb","s","839262","0","0")
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 ("2023","IN","B01","a","hist","uscb","s","51916","0","0"), ("2023","IN","B21","a","hist","uscb","s","894844","0","0"), ("2023","IN","B22","a","hist","uscb","s","37453","0","0"), ("2023","IN","B30","a","hist","uscb","s","0","0","0"), ("2023","IN","B42","a","hist","uscb","s","420699","0","0"), ("2023","IN","B46","a","hist","uscb","s","299126","0","0"), ("2023","IN","B50","a","hist","uscb","s","114306","0","0"), ("2023","IN","B59","a","hist","uscb","s","56642","0","0"), ("2023","IN","B79","a","hist","uscb","s","2566423","0","0"), ("2023","IN","B80","a","hist","uscb","s","12607","0","0"), ("2023","IN","B89","a","hist","uscb","s","603732","0","0")
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 ("2023","IA","B01","a","hist","uscb","s","256","0","0"), ("2023","IA","B21","a","hist","uscb","s","470893","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","498898","0","0"), ("2023","IA","B46","a","hist","uscb","s","508387","0","0"), ("2023","IA","B50","a","hist","uscb","s","114918","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"), ("2023","IA","B89","a","hist","uscb","s","162041","0","0")
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 ("2023","KS","B01","a","hist","uscb","s","99778","0","0"), ("2023","KS","B21","a","hist","uscb","s","6025161","0","0"), ("2023","KS","B22","a","hist","uscb","s","251021","0","0"), ("2023","KS","B30","a","hist","uscb","s","0","0","0"), ("2023","KS","B42","a","hist","uscb","s","1157162","0","0"), ("2023","KS","B46","a","hist","uscb","s","1995365","0","0"), ("2023","KS","B50","a","hist","uscb","s","512177","0","0"), ("2023","KS","B59","a","hist","uscb","s","106346","0","0"), ("2023","KS","B79","a","hist","uscb","s","23310727","0","0"), ("2023","KS","B80","a","hist","uscb","s","52203","0","0"), ("2023","KS","B89","a","hist","uscb","s","1679759","0","0")
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 ("2023","KY","B01","a","hist","uscb","s","456","0","0"), ("2023","KY","B21","a","hist","uscb","s","2543921","0","0"), ("2023","KY","B22","a","hist","uscb","s","103214","0","0"), ("2023","KY","B30","a","hist","uscb","s","0","0","0"), ("2023","KY","B42","a","hist","uscb","s","2283156","0","0"), ("2023","KY","B46","a","hist","uscb","s","1218835","0","0"), ("2023","KY","B50","a","hist","uscb","s","766148","0","0"), ("2023","KY","B59","a","hist","uscb","s","92079","0","0"), ("2023","KY","B79","a","hist","uscb","s","17452080","0","0"), ("2023","KY","B80","a","hist","uscb","s","67766","0","0"), ("2023","KY","B89","a","hist","uscb","s","439342","0","0")
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 ("2023","LA","B01","a","hist","uscb","s","390","0","0"), ("2023","LA","B21","a","hist","uscb","s","1240533","0","0"), ("2023","LA","B22","a","hist","uscb","s","60712","0","0"), ("2023","LA","B30","a","hist","uscb","s","0","0","0"), ("2023","LA","B42","a","hist","uscb","s","1622076","0","0"), ("2023","LA","B46","a","hist","uscb","s","743098","0","0"), ("2023","LA","B50","a","hist","uscb","s","227593","0","0"), ("2023","LA","B59","a","hist","uscb","s","105484","0","0"), ("2023","LA","B79","a","hist","uscb","s","5853370","0","0"), ("2023","LA","B80","a","hist","uscb","s","47451","0","0"), ("2023","LA","B89","a","hist","uscb","s","419679","0","0")
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 ("2023","ME","B01","a","hist","uscb","s","954","0","0"), ("2023","ME","B21","a","hist","uscb","s","1100949","0","0"), ("2023","ME","B22","a","hist","uscb","s","36641","0","0"), ("2023","ME","B30","a","hist","uscb","s","0","0","0"), ("2023","ME","B42","a","hist","uscb","s","1195103","0","0"), ("2023","ME","B46","a","hist","uscb","s","576077","0","0"), ("2023","ME","B50","a","hist","uscb","s","217043","0","0"), ("2023","ME","B59","a","hist","uscb","s","80063","0","0"), ("2023","ME","B79","a","hist","uscb","s","4040507","0","0"), ("2023","ME","B80","a","hist","uscb","s","22487","0","0"), ("2023","ME","B89","a","hist","uscb","s","238362","0","0")
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 ("2023","MD","B01","a","hist","uscb","s","1477","0","0"), ("2023","MD","B21","a","hist","uscb","s","2527510","0","0"), ("2023","MD","B22","a","hist","uscb","s","164532","0","0"), ("2023","MD","B30","a","hist","uscb","s","11076","0","0"), ("2023","MD","B42","a","hist","uscb","s","525347","0","0"), ("2023","MD","B46","a","hist","uscb","s","959664","0","0"), ("2023","MD","B50","a","hist","uscb","s","406411","0","0"), ("2023","MD","B59","a","hist","uscb","s","134254","0","0"), ("2023","MD","B79","a","hist","uscb","s","14775368","0","0"), ("2023","MD","B80","a","hist","uscb","s","0","0","0"), ("2023","MD","B89","a","hist","uscb","s","703237","0","0")
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 ("2023","MA","B01","a","hist","uscb","s","546","0","0"), ("2023","MA","B21","a","hist","uscb","s","3391823","0","0"), ("2023","MA","B22","a","hist","uscb","s","172574","0","0"), ("2023","MA","B30","a","hist","uscb","s","0","0","0"), ("2023","MA","B42","a","hist","uscb","s","434223","0","0"), ("2023","MA","B46","a","hist","uscb","s","919248","0","0"), ("2023","MA","B50","a","hist","uscb","s","31971","0","0"), ("2023","MA","B59","a","hist","uscb","s","137737","0","0"), ("2023","MA","B79","a","hist","uscb","s","14307064","0","0"), ("2023","MA","B80","a","hist","uscb","s","8953","0","0"), ("2023","MA","B89","a","hist","uscb","s","2836774","0","0")
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 ("2023","MI","B01","a","hist","uscb","s","2593","0","0"), ("2023","MI","B21","a","hist","uscb","s","503433","0","0"), ("2023","MI","B22","a","hist","uscb","s","42538","0","0"), ("2023","MI","B30","a","hist","uscb","s","0","0","0"), ("2023","MI","B42","a","hist","uscb","s","229828","0","0"), ("2023","MI","B46","a","hist","uscb","s","328692","0","0"), ("2023","MI","B50","a","hist","uscb","s","280103","0","0"), ("2023","MI","B59","a","hist","uscb","s","61886","0","0"), ("2023","MI","B79","a","hist","uscb","s","3598180","0","0"), ("2023","MI","B80","a","hist","uscb","s","23458","0","0"), ("2023","MI","B89","a","hist","uscb","s","259519","0","0")
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 ("2023","MN","B01","a","hist","uscb","s","20520","0","0"), ("2023","MN","B21","a","hist","uscb","s","3110684","0","0"), ("2023","MN","B22","a","hist","uscb","s","111124","0","0"), ("2023","MN","B30","a","hist","uscb","s","0","0","0"), ("2023","MN","B42","a","hist","uscb","s","3554748","0","0"), ("2023","MN","B46","a","hist","uscb","s","739057","0","0"), ("2023","MN","B50","a","hist","uscb","s","619584","0","0"), ("2023","MN","B59","a","hist","uscb","s","50901","0","0"), ("2023","MN","B79","a","hist","uscb","s","11174552","0","0"), ("2023","MN","B80","a","hist","uscb","s","53281","0","0"), ("2023","MN","B89","a","hist","uscb","s","2037527","0","0")
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 ("2023","MS","B01","a","hist","uscb","s","28505","0","0"), ("2023","MS","B21","a","hist","uscb","s","2454000","0","0"), ("2023","MS","B22","a","hist","uscb","s","153521","0","0"), ("2023","MS","B30","a","hist","uscb","s","0","0","0"), ("2023","MS","B42","a","hist","uscb","s","1709266","0","0"), ("2023","MS","B46","a","hist","uscb","s","685742","0","0"), ("2023","MS","B50","a","hist","uscb","s","1245714","0","0"), ("2023","MS","B59","a","hist","uscb","s","52696","0","0"), ("2023","MS","B79","a","hist","uscb","s","16932216","0","0"), ("2023","MS","B80","a","hist","uscb","s","103482","0","0"), ("2023","MS","B89","a","hist","uscb","s","1567957","0","0")
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 ("2023","MO","B01","a","hist","uscb","s","126157","0","0"), ("2023","MO","B21","a","hist","uscb","s","4126590","0","0"), ("2023","MO","B22","a","hist","uscb","s","244309","0","0"), ("2023","MO","B30","a","hist","uscb","s","0","0","0"), ("2023","MO","B42","a","hist","uscb","s","5809221","0","0"), ("2023","MO","B46","a","hist","uscb","s","1193495","0","0"), ("2023","MO","B50","a","hist","uscb","s","1080413","0","0"), ("2023","MO","B59","a","hist","uscb","s","89234","0","0"), ("2023","MO","B79","a","hist","uscb","s","19102409","0","0"), ("2023","MO","B80","a","hist","uscb","s","114","0","0"), ("2023","MO","B89","a","hist","uscb","s","1199779","0","0")
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 ("2023","MT","B01","a","hist","uscb","s","63914","0","0"), ("2023","MT","B21","a","hist","uscb","s","2483490","0","0"), ("2023","MT","B22","a","hist","uscb","s","97419","0","0"), ("2023","MT","B30","a","hist","uscb","s","0","0","0"), ("2023","MT","B42","a","hist","uscb","s","1943902","0","0"), ("2023","MT","B46","a","hist","uscb","s","989598","0","0"), ("2023","MT","B50","a","hist","uscb","s","34966","0","0"), ("2023","MT","B59","a","hist","uscb","s","51681","0","0"), ("2023","MT","B79","a","hist","uscb","s","12996483","0","0"), ("2023","MT","B80","a","hist","uscb","s","22412","0","0"), ("2023","MT","B89","a","hist","uscb","s","595951","0","0")
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 ("2023","NE","B01","a","hist","uscb","s","0","0","0"), ("2023","NE","B21","a","hist","uscb","s","1463929","0","0"), ("2023","NE","B22","a","hist","uscb","s","81760","0","0"), ("2023","NE","B30","a","hist","uscb","s","20557","0","0"), ("2023","NE","B42","a","hist","uscb","s","915234","0","0"), ("2023","NE","B46","a","hist","uscb","s","792863","0","0"), ("2023","NE","B50","a","hist","uscb","s","160928","0","0"), ("2023","NE","B59","a","hist","uscb","s","111238","0","0"), ("2023","NE","B79","a","hist","uscb","s","7256192","0","0"), ("2023","NE","B80","a","hist","uscb","s","10439","0","0"), ("2023","NE","B89","a","hist","uscb","s","461015","0","0")
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 ("2023","NV","B01","a","hist","uscb","s","31519","0","0"), ("2023","NV","B21","a","hist","uscb","s","2879829","0","0"), ("2023","NV","B22","a","hist","uscb","s","45498","0","0"), ("2023","NV","B30","a","hist","uscb","s","0","0","0"), ("2023","NV","B42","a","hist","uscb","s","2955435","0","0"), ("2023","NV","B46","a","hist","uscb","s","1174408","0","0"), ("2023","NV","B50","a","hist","uscb","s","537069","0","0"), ("2023","NV","B59","a","hist","uscb","s","102537","0","0"), ("2023","NV","B79","a","hist","uscb","s","12491734","0","0"), ("2023","NV","B80","a","hist","uscb","s","24370","0","0"), ("2023","NV","B89","a","hist","uscb","s","453847","0","0")
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 ("2023","NH","B01","a","hist","uscb","s","6287","0","0"), ("2023","NH","B21","a","hist","uscb","s","467776","0","0"), ("2023","NH","B22","a","hist","uscb","s","29077","0","0"), ("2023","NH","B30","a","hist","uscb","s","0","0","0"), ("2023","NH","B42","a","hist","uscb","s","964475","0","0"), ("2023","NH","B46","a","hist","uscb","s","594826","0","0"), ("2023","NH","B50","a","hist","uscb","s","65036","0","0"), ("2023","NH","B59","a","hist","uscb","s","84499","0","0"), ("2023","NH","B79","a","hist","uscb","s","2227227","0","0"), ("2023","NH","B80","a","hist","uscb","s","5467","0","0"), ("2023","NH","B89","a","hist","uscb","s","278311","0","0")
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 ("2023","NJ","B01","a","hist","uscb","s","29823","0","0"), ("2023","NJ","B21","a","hist","uscb","s","371936","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","80707","0","0"), ("2023","NJ","B46","a","hist","uscb","s","485582","0","0"), ("2023","NJ","B50","a","hist","uscb","s","0","0","0"), ("2023","NJ","B59","a","hist","uscb","s","72958","0","0"), ("2023","NJ","B79","a","hist","uscb","s","4616271","0","0"), ("2023","NJ","B80","a","hist","uscb","s","15524","0","0"), ("2023","NJ","B89","a","hist","uscb","s","249010","0","0")
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 ("2023","NM","B01","a","hist","uscb","s","0","0","0"), ("2023","NM","B21","a","hist","uscb","s","898307","0","0"), ("2023","NM","B22","a","hist","uscb","s","115957","0","0"), ("2023","NM","B30","a","hist","uscb","s","450933","0","0"), ("2023","NM","B42","a","hist","uscb","s","1069607","0","0"), ("2023","NM","B46","a","hist","uscb","s","330286","0","0"), ("2023","NM","B50","a","hist","uscb","s","149857","0","0"), ("2023","NM","B59","a","hist","uscb","s","43567","0","0"), ("2023","NM","B79","a","hist","uscb","s","4493860","0","0"), ("2023","NM","B80","a","hist","uscb","s","9501","0","0"), ("2023","NM","B89","a","hist","uscb","s","312875","0","0")
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 ("2023","NY","B01","a","hist","uscb","s","9816","0","0"), ("2023","NY","B21","a","hist","uscb","s","310287","0","0"), ("2023","NY","B22","a","hist","uscb","s","29354","0","0"), ("2023","NY","B30","a","hist","uscb","s","0","0","0"), ("2023","NY","B42","a","hist","uscb","s","39029","0","0"), ("2023","NY","B46","a","hist","uscb","s","225326","0","0"), ("2023","NY","B50","a","hist","uscb","s","114886","0","0"), ("2023","NY","B59","a","hist","uscb","s","35791","0","0"), ("2023","NY","B79","a","hist","uscb","s","1932963","0","0"), ("2023","NY","B80","a","hist","uscb","s","0","0","0"), ("2023","NY","B89","a","hist","uscb","s","879985","0","0")
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 ("2023","NC","B01","a","hist","uscb","s","1140","0","0"), ("2023","NC","B21","a","hist","uscb","s","2434910","0","0"), ("2023","NC","B22","a","hist","uscb","s","211183","0","0"), ("2023","NC","B30","a","hist","uscb","s","0","0","0"), ("2023","NC","B42","a","hist","uscb","s","5222146","0","0"), ("2023","NC","B46","a","hist","uscb","s","1082229","0","0"), ("2023","NC","B50","a","hist","uscb","s","390037","0","0"), ("2023","NC","B59","a","hist","uscb","s","43076","0","0"), ("2023","NC","B79","a","hist","uscb","s","16038598","0","0"), ("2023","NC","B80","a","hist","uscb","s","45278","0","0"), ("2023","NC","B89","a","hist","uscb","s","4671923","0","0")
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 ("2023","ND","B01","a","hist","uscb","s","5","0","0"), ("2023","ND","B21","a","hist","uscb","s","1672962","0","0"), ("2023","ND","B22","a","hist","uscb","s","15179","0","0"), ("2023","ND","B30","a","hist","uscb","s","0","0","0"), ("2023","ND","B42","a","hist","uscb","s","277873","0","0"), ("2023","ND","B46","a","hist","uscb","s","461163","0","0"), ("2023","ND","B50","a","hist","uscb","s","103892","0","0"), ("2023","ND","B59","a","hist","uscb","s","98148","0","0"), ("2023","ND","B79","a","hist","uscb","s","9918014","0","0"), ("2023","ND","B80","a","hist","uscb","s","14419","0","0"), ("2023","ND","B89","a","hist","uscb","s","525324","0","0")
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 ("2023","OH","B01","a","hist","uscb","s","1334","0","0"), ("2023","OH","B21","a","hist","uscb","s","6122766","0","0"), ("2023","OH","B22","a","hist","uscb","s","342211","0","0"), ("2023","OH","B30","a","hist","uscb","s","0","0","0"), ("2023","OH","B42","a","hist","uscb","s","5598209","0","0"), ("2023","OH","B46","a","hist","uscb","s","2141929","0","0"), ("2023","OH","B50","a","hist","uscb","s","3084737","0","0"), ("2023","OH","B59","a","hist","uscb","s","439290","0","0"), ("2023","OH","B79","a","hist","uscb","s","70916181","0","0"), ("2023","OH","B80","a","hist","uscb","s","334559","0","0"), ("2023","OH","B89","a","hist","uscb","s","6612381","0","0")
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 ("2023","OK","B01","a","hist","uscb","s","32623","0","0"), ("2023","OK","B21","a","hist","uscb","s","4156510","0","0"), ("2023","OK","B22","a","hist","uscb","s","97151","0","0"), ("2023","OK","B30","a","hist","uscb","s","0","0","0"), ("2023","OK","B42","a","hist","uscb","s","2317477","0","0"), ("2023","OK","B46","a","hist","uscb","s","1521589","0","0"), ("2023","OK","B50","a","hist","uscb","s","429982","0","0"), ("2023","OK","B59","a","hist","uscb","s","126162","0","0"), ("2023","OK","B79","a","hist","uscb","s","17682444","0","0"), ("2023","OK","B80","a","hist","uscb","s","123418","0","0"), ("2023","OK","B89","a","hist","uscb","s","2169491","0","0")
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 ("2023","OR","B01","a","hist","uscb","s","83","0","0"), ("2023","OR","B21","a","hist","uscb","s","555990","0","0"), ("2023","OR","B22","a","hist","uscb","s","6219","0","0"), ("2023","OR","B30","a","hist","uscb","s","0","0","0"), ("2023","OR","B42","a","hist","uscb","s","247612","0","0"), ("2023","OR","B46","a","hist","uscb","s","382462","0","0"), ("2023","OR","B50","a","hist","uscb","s","22117","0","0"), ("2023","OR","B59","a","hist","uscb","s","51453","0","0"), ("2023","OR","B79","a","hist","uscb","s","1322998","0","0"), ("2023","OR","B80","a","hist","uscb","s","6262","0","0"), ("2023","OR","B89","a","hist","uscb","s","240680","0","0")
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 ("2023","PA","B01","a","hist","uscb","s","0","0","0"), ("2023","PA","B21","a","hist","uscb","s","3302629","0","0"), ("2023","PA","B22","a","hist","uscb","s","153779","0","0"), ("2023","PA","B30","a","hist","uscb","s","0","0","0"), ("2023","PA","B42","a","hist","uscb","s","5704572","0","0"), ("2023","PA","B46","a","hist","uscb","s","1570355","0","0"), ("2023","PA","B50","a","hist","uscb","s","231456","0","0"), ("2023","PA","B59","a","hist","uscb","s","98587","0","0"), ("2023","PA","B79","a","hist","uscb","s","25205228","0","0"), ("2023","PA","B80","a","hist","uscb","s","48135","0","0"), ("2023","PA","B89","a","hist","uscb","s","777614","0","0")
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 ("2023","RI","B01","a","hist","uscb","s","1036","0","0"), ("2023","RI","B21","a","hist","uscb","s","2072879","0","0"), ("2023","RI","B22","a","hist","uscb","s","54697","0","0"), ("2023","RI","B30","a","hist","uscb","s","0","0","0"), ("2023","RI","B42","a","hist","uscb","s","1512066","0","0"), ("2023","RI","B46","a","hist","uscb","s","891945","0","0"), ("2023","RI","B50","a","hist","uscb","s","207644","0","0"), ("2023","RI","B59","a","hist","uscb","s","134667","0","0"), ("2023","RI","B79","a","hist","uscb","s","10884733","0","0"), ("2023","RI","B80","a","hist","uscb","s","0","0","0"), ("2023","RI","B89","a","hist","uscb","s","425226","0","0")
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 ("2023","SC","B01","a","hist","uscb","s","2056","0","0"), ("2023","SC","B21","a","hist","uscb","s","2290904","0","0"), ("2023","SC","B22","a","hist","uscb","s","65316","0","0"), ("2023","SC","B30","a","hist","uscb","s","0","0","0"), ("2023","SC","B42","a","hist","uscb","s","546607","0","0"), ("2023","SC","B46","a","hist","uscb","s","685761","0","0"), ("2023","SC","B50","a","hist","uscb","s","93564","0","0"), ("2023","SC","B59","a","hist","uscb","s","81458","0","0"), ("2023","SC","B79","a","hist","uscb","s","12820856","0","0"), ("2023","SC","B80","a","hist","uscb","s","0","0","0"), ("2023","SC","B89","a","hist","uscb","s","885541","0","0")
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 ("2023","SD","B01","a","hist","uscb","s","11103","0","0"), ("2023","SD","B21","a","hist","uscb","s","4808548","0","0"), ("2023","SD","B22","a","hist","uscb","s","139934","0","0"), ("2023","SD","B30","a","hist","uscb","s","0","0","0"), ("2023","SD","B42","a","hist","uscb","s","7114401","0","0"), ("2023","SD","B46","a","hist","uscb","s","2228803","0","0"), ("2023","SD","B50","a","hist","uscb","s","61438","0","0"), ("2023","SD","B59","a","hist","uscb","s","179378","0","0"), ("2023","SD","B79","a","hist","uscb","s","33523461","0","0"), ("2023","SD","B80","a","hist","uscb","s","52603","0","0"), ("2023","SD","B89","a","hist","uscb","s","1102314","0","0")
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 ("2023","TX","B01","a","hist","uscb","s","21990","0","0"), ("2023","TX","B21","a","hist","uscb","s","269133","0","0"), ("2023","TX","B22","a","hist","uscb","s","25751","0","0"), ("2023","TX","B30","a","hist","uscb","s","43","0","0"), ("2023","TX","B42","a","hist","uscb","s","1624634","0","0"), ("2023","TX","B46","a","hist","uscb","s","394111","0","0"), ("2023","TX","B50","a","hist","uscb","s","7041","0","0"), ("2023","TX","B59","a","hist","uscb","s","19729","0","0"), ("2023","TX","B79","a","hist","uscb","s","2418656","0","0"), ("2023","TX","B80","a","hist","uscb","s","49432","0","0"), ("2023","TX","B89","a","hist","uscb","s","373058","0","0")
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 ("2023","UT","B01","a","hist","uscb","s","338","0","0"), ("2023","UT","B21","a","hist","uscb","s","1817410","0","0"), ("2023","UT","B22","a","hist","uscb","s","80500","0","0"), ("2023","UT","B30","a","hist","uscb","s","0","0","0"), ("2023","UT","B42","a","hist","uscb","s","3933881","0","0"), ("2023","UT","B46","a","hist","uscb","s","831709","0","0"), ("2023","UT","B50","a","hist","uscb","s","426716","0","0"), ("2023","UT","B59","a","hist","uscb","s","70270","0","0"), ("2023","UT","B79","a","hist","uscb","s","9744244","0","0"), ("2023","UT","B80","a","hist","uscb","s","14693","0","0"), ("2023","UT","B89","a","hist","uscb","s","577150","0","0")
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 ("2023","VT","B01","a","hist","uscb","s","26018","0","0"), ("2023","VT","B21","a","hist","uscb","s","334919","0","0"), ("2023","VT","B22","a","hist","uscb","s","11301","0","0"), ("2023","VT","B30","a","hist","uscb","s","0","0","0"), ("2023","VT","B42","a","hist","uscb","s","511585","0","0"), ("2023","VT","B46","a","hist","uscb","s","473021","0","0"), ("2023","VT","B50","a","hist","uscb","s","40500","0","0"), ("2023","VT","B59","a","hist","uscb","s","45318","0","0"), ("2023","VT","B79","a","hist","uscb","s","952992","0","0"), ("2023","VT","B80","a","hist","uscb","s","490","0","0"), ("2023","VT","B89","a","hist","uscb","s","126243","0","0")
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 ("2023","VA","B01","a","hist","uscb","s","21546","0","0"), ("2023","VA","B21","a","hist","uscb","s","1974846","0","0"), ("2023","VA","B22","a","hist","uscb","s","77020","0","0"), ("2023","VA","B30","a","hist","uscb","s","399920","0","0"), ("2023","VA","B42","a","hist","uscb","s","2682590","0","0"), ("2023","VA","B46","a","hist","uscb","s","1168740","0","0"), ("2023","VA","B50","a","hist","uscb","s","611190","0","0"), ("2023","VA","B59","a","hist","uscb","s","213288","0","0"), ("2023","VA","B79","a","hist","uscb","s","12063189","0","0"), ("2023","VA","B80","a","hist","uscb","s","1916","0","0"), ("2023","VA","B89","a","hist","uscb","s","899822","0","0")
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 ("2023","WA","B01","a","hist","uscb","s","132","0","0"), ("2023","WA","B21","a","hist","uscb","s","9649499","0","0"), ("2023","WA","B22","a","hist","uscb","s","98108","0","0"), ("2023","WA","B30","a","hist","uscb","s","0","0","0"), ("2023","WA","B42","a","hist","uscb","s","16176894","0","0"), ("2023","WA","B46","a","hist","uscb","s","4395362","0","0"), ("2023","WA","B50","a","hist","uscb","s","87938","0","0"), ("2023","WA","B59","a","hist","uscb","s","429670","0","0"), ("2023","WA","B79","a","hist","uscb","s","42316023","0","0"), ("2023","WA","B80","a","hist","uscb","s","118899","0","0"), ("2023","WA","B89","a","hist","uscb","s","2971378","0","0")
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 ("2023","WV","B01","a","hist","uscb","s","381","0","0"), ("2023","WV","B21","a","hist","uscb","s","1498966","0","0"), ("2023","WV","B22","a","hist","uscb","s","10886","0","0"), ("2023","WV","B30","a","hist","uscb","s","2391","0","0"), ("2023","WV","B42","a","hist","uscb","s","714096","0","0"), ("2023","WV","B46","a","hist","uscb","s","528667","0","0"), ("2023","WV","B50","a","hist","uscb","s","8542","0","0"), ("2023","WV","B59","a","hist","uscb","s","65596","0","0"), ("2023","WV","B79","a","hist","uscb","s","5298280","0","0"), ("2023","WV","B80","a","hist","uscb","s","19417","0","0"), ("2023","WV","B89","a","hist","uscb","s","527292","0","0")
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 ("2023","WI","B01","a","hist","uscb","s","2677","0","0"), ("2023","WI","B21","a","hist","uscb","s","454361","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","268849","0","0"), ("2023","WI","B46","a","hist","uscb","s","367441","0","0"), ("2023","WI","B50","a","hist","uscb","s","64150","0","0"), ("2023","WI","B59","a","hist","uscb","s","65978","0","0"), ("2023","WI","B79","a","hist","uscb","s","1796286","0","0"), ("2023","WI","B80","a","hist","uscb","s","4","0","0"), ("2023","WI","B89","a","hist","uscb","s","271341","0","0")
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 ("2023","WY","B01","a","hist","uscb","s","365","0","0"), ("2023","WY","B21","a","hist","uscb","s","2828625","0","0"), ("2023","WY","B22","a","hist","uscb","s","29403","0","0"), ("2023","WY","B30","a","hist","uscb","s","1240","0","0"), ("2023","WY","B42","a","hist","uscb","s","2569480","0","0"), ("2023","WY","B46","a","hist","uscb","s","1486368","0","0"), ("2023","WY","B50","a","hist","uscb","s","97105","0","0"), ("2023","WY","B59","a","hist","uscb","s","61017","0","0"), ("2023","WY","B79","a","hist","uscb","s","15419319","0","0"), ("2023","WY","B80","a","hist","uscb","s","68730","0","0"), ("2023","WY","B89","a","hist","uscb","s","346868","0","0")
x53 B01 B21 B22 B30 B42 B46 B50 B59 B79 B80 B89

Done