Load Total State and Local Spending/Revenue
Year = 2024

Menu

Rows deleted for S27: 0

Rows deleted for S68: 0

Rows deleted for S75: 0

Rows deleted for S06: 0

Rows deleted for S54: 0

Rows deleted for S26: 0

Rows deleted for A45: 0

Rows deleted for S67: 0

Rows deleted for S79: 0
00US
01AL

replace government_spending (year,state,code,spend_rev,source,author,spending,state_spending,local_spending) values ("2024","US","T00","r","a","uscb","5038383583","3158526145","2633575415"),("2024","US","M00","r","a","uscb","-1206435514","-1096510238","-863643254"),("2024","US","R00","r","a","uscb","3612737016","2036999215","1575737801"),("2024","US","T01","r","a","uscb","720882424","23374108","697508316"),("2024","US","T09","r","a","uscb","603461622","466119937","137341685"),("2024","US","T13","r","a","uscb","60523020","58274120","2248900"),("2024","US","T10","r","a","uscb","9171612","8375147","796465"),("2024","US","T16","r","a","uscb","15874735","15629148","245587"),("2024","US","T15","r","a","uscb","30671254","13837624","16833630"),("2024","US","T19","r","a","uscb","85690578","65088683","20601895"),("2024","US","T40","r","a","uscb","701224181","644732109","56492072"),("2024","US","T41","r","a","uscb","523067780","479325719","43742061"),("2024","US","T24","r","a","uscb","178156401","165406390","12750011"),("2024","US","R99","r","a","uscb","73107668","53671346","19436322"),("2024","US","A18","r","a","uscb","153710305","128940253","24770052"),("2024","US","A36","r","a","uscb","251102581","127199502","123903079"),("2024","US","A44","r","a","uscb","27805080","15093166","12711914"),("2024","US","A01","r","a","uscb","33139836","2437026","30702810"),("2024","US","A60","r","a","uscb","3384742","34399","3350343"),("2024","US","A87","r","a","uscb","8373249","2776431","5596818"),("2024","US","A59","r","a","uscb","6751186","4368462","2382724"),("2024","US","A61","r","a","uscb","14645771","2469541","12176230"),("2024","US","A50","r","a","uscb","8823433","1182804","7640629"),("2024","US","A80","r","a","uscb","75419738","1238654","74181084"),("2024","US","A81","r","a","uscb","22744745","132415","22612330"),("2024","US","A89","r","a","uscb","113444606","26290881","87153725"),("2024","US","U20","r","a","uscb","145217006","80802749","64414257"),("2024","US","U01","r","a","uscb","16923755","26858","16896897"),("2024","US","U11","r","a","uscb","5487929","1393707","4094222"),("2024","US","O99","r","a","uscb","162172993","85958616","76214377"),("2024","US","A91","r","a","uscb","88224282","395471","87828811"),("2024","US","A92","r","a","uscb","95132646","9619833","85512813"),("2024","US","A93","r","a","uscb","7658165","11504","7646661"),("2024","US","A94","r","a","uscb","13426917","3298985","10127932"),("2024","US","A90","r","a","uscb","14769043","11690899","3078144"),("2024","US","R95","r","a","uscb","817773930","704035542","113738388"),("2024","US","R01","r","a","uscb","68490081","68349727","140354"),("2024","US","R02","r","a","uscb","720527602","606929568","113598034"),("2024","US","R03","r","a","uscb","13981653","13981653","0"),("2024","US","R98","r","a","uscb","14774594","14774594","0"),("2024","US","E00","s","a","uscb","4968102946","2336248950","2631853996"),("2024","US","S16","s","a","uscb","398107220","347208939","50898281"),("2024","US","S12","s","a","uscb","981970921","24427229","957543692"),("2024","US","S21","s","a","uscb","93943996","89940880","4003116"),("2024","US","S52","s","a","uscb","16924530","570793","16353737"),("2024","US","Q79","s","a","uscb","1092745611","1017967232","74778379"),("2024","US","S36","s","a","uscb","297820966","153190844","144630122"),("2024","US","S32","s","a","uscb","159135304","70100008","89035296"),("2024","US","S22","s","a","uscb","6919933","6861297","58636"),("2024","US","S85","s","a","uscb","1389844","1389844","0"),("2024","US","S44","s","a","uscb","257505386","159257012","98248374"),("2024","US","S01","s","a","uscb","38863910","3371976","35491934"),("2024","US","S60","s","a","uscb","2266499","19081","2247418"),("2024","US","S87","s","a","uscb","8789058","3528015","5261043"),("2024","US","S62","s","a","uscb","161442619","24362222","137080397"),("2024","US","S24","s","a","uscb","74380817","0","74380817"),("2024","US","S04","s","a","uscb","107270431","71331887","35938544"),("2024","US","S66","s","a","uscb","23568420","15162648","8405772"),("2024","US","S59","s","a","uscb","52670122","36062370","16607752"),("2024","US","S61","s","a","uscb","64208677","9466478","54742199"),("2024","US","S50","s","a","uscb","83677396","15255797","68421599"),("2024","US","S80","s","a","uscb","83522510","1907053","81615457"),("2024","US","S81","s","a","uscb","33430809","1244048","32186761"),("2024","US","S23","s","a","uscb","107485003","61822402","45662601"),("2024","US","S25","s","a","uscb","62213583","29664299","32549284"),("2024","US","S31","s","a","uscb","21052687","5901149","15151538"),("2024","US","S29","s","a","uscb","54639020","12319001","42320019"),("2024","US","I89","s","a","uscb","110932394","39175506","71756888"),("2024","US","S03","s","a","uscb","4605165","2426829","2178336"),("2024","US","S89","s","a","uscb","255319242","89770313","165548929"),("2024","US","S91","s","a","uscb","98728831","796266","97932565"),("2024","US","S92","s","a","uscb","94051135","10691051","83360084"),("2024","US","S93","s","a","uscb","6993263","18769","6974494"),("2024","US","S94","s","a","uscb","100136696","21191006","78945690"),("2024","US","S90","s","a","uscb","11390949","9846706","1544243"),("2024","US","S95","s","a","uscb","466222525","393353482","72869043"),("2024","US","S05","s","a","uscb","36169838","36059137","110701"),("2024","US","S11","s","a","uscb","409271202","336512860","72758342"),("2024","US","S14","s","a","uscb","9181714","9181714","0"),("2024","US","S53","s","a","uscb","11599771","11599771","0"),("2024","US","D64","s","a","uscb","52239309","12467556","39771753"),("2024","US","D49","s","a","uscb","3181562022","1089658017","2091904005"),("2024","US","S79","s","e","uscb","152172996","92290370","54018131"),("2024","US","S74","s","e","uscb","908548808","909307546","6701696"),("2024","US","S67","s","a","uscb","32023806","16369316","14058551");

Done