return to Menu
1,304chek
replace government_spending (year,state,code,source,fy,spend_rev, author,spending,state_spending,local_spending) values
("1966","US","SME","a","hist","s","cms","1304","1304","0"),("1966","US","XME","a","hist","s","cms","769.534","0","0"),("1966","US","SMO","a","hist","s","cms","5910","0","0"),
("1967","US","SME","a","hist","s","cms","3141","3141","0"),("1967","US","XME","a","hist","s","cms","1173","0","0"),("1967","US","SMO","a","hist","s","cms","6640","0","0"),
("1968","US","SME","a","hist","s","cms","3541","3541","0"),("1968","US","XME","a","hist","s","cms","1805.52","0","0"),("1968","US","SMO","a","hist","s","cms","7546","0","0"),
("1969","US","SME","a","hist","s","cms","4174","4174","0"),("1969","US","XME","a","hist","s","cms","2284.66","0","0"),("1969","US","SMO","a","hist","s","cms","8520","0","0"),
("1970","US","SME","a","hist","s","cms","5290","5290","0"),("1970","US","XME","a","hist","s","cms","2726.84","0","0"),("1970","US","SMO","a","hist","s","cms","9669","0","0"),
("1971","US","SME","a","hist","s","cms","6695","6695","0"),("1971","US","XME","a","hist","s","cms","3362.25","0","0"),("1971","US","SMO","a","hist","s","cms","11205","0","0"),
("1972","US","SME","a","hist","s","cms","8314","8314","0"),("1972","US","XME","a","hist","s","cms","4601.29","0","0"),("1972","US","SMO","a","hist","s","cms","12867","0","0"),
("1973","US","SME","a","hist","s","cms","9423","9423","0"),("1973","US","XME","a","hist","s","cms","4599.85","0","0"),("1973","US","SMO","a","hist","s","cms","13844","0","0"),
("1974","US","SME","a","hist","s","cms","11073","11073","0"),("1974","US","XME","a","hist","s","cms","5818.39","0","0"),("1974","US","SMO","a","hist","s","cms","15945","0","0"),
("1975","US","SME","a","hist","s","cms","13446","13446","0"),("1975","US","XME","a","hist","s","cms","6840.4","0","0"),("1975","US","SMO","a","hist","s","cms","18846","0","0"),
("1976","US","SME","a","hist","s","cms","15188","15188","0"),("1976","US","XME","a","hist","s","cms","8568.24","0","0"),("1976","US","SMO","a","hist","s","cms","20686","0","0"),
("1977","US","SME","a","hist","s","cms","17464","17464","0"),("1977","US","XME","a","hist","s","cms","9875.83","0","0"),("1977","US","SMO","a","hist","s","cms","23038.91","0","0"),
("1978","US","SME","a","hist","s","cms","19465","19465","0"),("1978","US","XME","a","hist","s","cms","10679.9","0","0"),("1978","US","SMO","a","hist","s","cms","24952.03","0","0"),
("1979","US","SME","a","hist","s","cms","22332","22332","0"),("1979","US","XME","a","hist","s","cms","12407.3","0","0"),("1979","US","SMO","a","hist","s","cms","28217.57","0","0"),
("1980","US","SME","a","hist","s","cms","26032","26032","0"),("1980","US","XME","a","hist","s","cms","13956.7","0","0"),("1980","US","SMO","a","hist","s","cms","32173.48","0","0"),
("1981","US","SME","a","hist","s","cms","30307","30307","0"),("1981","US","XME","a","hist","s","cms","16833.3","0","0"),("1981","US","SMO","a","hist","s","cms","36100.44","0","0"),
("1982","US","SME","a","hist","s","cms","32011","32011","0"),("1982","US","XME","a","hist","s","cms","17390.7","0","0"),("1982","US","SMO","a","hist","s","cms","40718.8","0","0"),
("1983","US","SME","a","hist","s","cms","35266","35266","0"),("1983","US","XME","a","hist","s","cms","18985.2","0","0"),("1983","US","SMO","a","hist","s","cms","43749.9","0","0"),
("1984","US","SME","a","hist","s","cms","38233","38233","0"),("1984","US","XME","a","hist","s","cms","20060.9","0","0"),("1984","US","SMO","a","hist","s","cms","46329.4","0","0"),
("1985","US","SME","a","hist","s","cms","40937","40937","0"),("1985","US","XME","a","hist","s","cms","22654.6","0","0"),("1985","US","SMO","a","hist","s","cms","49580.6","0","0"),
("1986","US","SME","a","hist","s","cms","45383","45383","0"),("1986","US","XME","a","hist","s","cms","24995.5","0","0"),("1986","US","SMO","a","hist","s","cms","53535.9","0","0"),
("1987","US","SME","a","hist","s","cms","50339","50339","0"),("1987","US","XME","a","hist","s","cms","27435.2","0","0"),("1987","US","SMO","a","hist","s","cms","57087.6","0","0"),
("1988","US","SME","a","hist","s","cms","55080","55080","0"),("1988","US","XME","a","hist","s","cms","30461.6","0","0"),("1988","US","SMO","a","hist","s","cms","61939.8","0","0"),
("1989","US","SME","a","hist","s","cms","61952","61952","0"),("1989","US","XME","a","hist","s","cms","34604","0","0"),("1989","US","SMO","a","hist","s","cms","67757.3","0","0"),
("1990","US","SME","a","hist","s","cms","73661","73661","0"),("1990","US","XME","a","hist","s","cms","41103.2","0","0"),("1990","US","SMO","a","hist","s","cms","74634.7","0","0"),
("1991","US","SME","a","hist","s","cms","93211","93211","0"),("1991","US","XME","a","hist","s","cms","52532.7","0","0"),("1991","US","SMO","a","hist","s","cms","81109.9","0","0"),
("1992","US","E72","a","hist","s","cms","108186000","0","0"),("1992","US","E73","a","hist","s","cms","84099904","0","0"),("1992","US","G73","a","hist","s","cms","1687570","0","0"),
("1993","US","E72","a","hist","s","cms","122373000","0","0"),("1993","US","E73","a","hist","s","cms","89563937","0","0"),("1993","US","G73","a","hist","s","cms","2059314","0","0"),
("1994","US","E72","a","hist","s","cms","134414000","0","0"),("1994","US","E73","a","hist","s","cms","95272658","0","0"),("1994","US","G73","a","hist","s","cms","1967199","0","0"),
("1995","US","E72","a","hist","s","cms","144862000","0","0"),("1995","US","E73","a","hist","s","cms","101063896","0","0"),("1995","US","G73","a","hist","s","cms","1940232","0","0"),
("1996","US","E72","a","hist","s","cms","152170000","0","0"),("1996","US","E73","a","hist","s","cms","105647854","0","0"),("1996","US","G73","a","hist","s","cms","2036619","0","0"),
("1997","US","E72","a","hist","s","cms","160849000","0","0"),("1997","US","E73","a","hist","s","cms","105258955","0","0"),("1997","US","G73","a","hist","s","cms","2015505","0","0"),
("1998","US","E72","a","hist","s","cms","169013000","0","0"),("1998","US","E73","a","hist","s","cms","108332132","0","0"),("1998","US","G73","a","hist","s","cms","2388401","0","0"),
("1999","US","E72","a","hist","s","cms","183471000","0","0"),("1999","US","E73","a","hist","s","cms","113662260","0","0"),("1999","US","G73","a","hist","s","cms","2513499","0","0"),
("2000","US","S72","a","hist","s","cms","200383000","0","0"),("2000","US","S73","a","hist","s","cms","84070600","0","0"),
("2001","US","S72","a","hist","s","cms","224132000","0","0"),("2001","US","S73","a","hist","s","cms","84779100","0","0"),
("2002","US","S72","a","hist","s","cms","248100000","0","0"),("2002","US","S73","a","hist","s","cms","94332200","0","0"),
("2003","US","S72","a","hist","s","cms","268963000","0","0"),("2003","US","S73","a","hist","s","cms","100185300","0","0"),
("2004","US","S72","a","hist","s","cms","290743000","0","0"),("2004","US","S73","a","hist","s","cms","117117300","0","0"),
("2005","US","S72","a","hist","s","cms","309351000","0","0"),("2005","US","S73","a","hist","s","cms","133428100","0","0"),
("2006","US","S72","a","hist","s","cms","306680000","0","0"),("2006","US","S73","a","hist","s","cms","150073400","0","0"),
("2007","US","S72","a","hist","s","cms","325856000","0","0"),("2007","US","S73","a","hist","s","cms","154465700","0","0"),
("2008","US","S72","a","hist","s","cms","344397000","0","0"),("2008","US","S73","a","hist","s","cms","168066700","0","0"),
("2009","US","S72","a","hist","s","cms","374709000","0","0"),("2009","US","S73","a","hist","s","cms","173803300","0","0"),
("2010","US","S72","a","hist","s","cms","397365000","0","0"),("2010","US","S73","a","hist","s","cms","181522700","0","0"),
("2011","US","S72","a","hist","s","cms","406747000","0","0"),("2011","US","S73","a","hist","s","cms","211879400","0","0"),
("2012","US","S72","a","hist","s","cms","422737000","0","0"),("2012","US","S73","a","hist","s","cms","202060300","0","0"),
("2013","US","S72","a","hist","s","cms","444976000","0","0"),("2013","US","S73","a","hist","s","cms","209133100","0","0"),
("2014","US","S72","a","hist","s","cms","498159000","0","0"),("2014","US","S73","a","hist","s","cms","194006500","0","0"),
("2015","US","S72","a","hist","s","cms","542995000","0","0"),("2015","US","S73","a","hist","s","cms","220137600","0","0"),
("2016","US","S72","a","hist","s","cms","564869000","0","0"),("2016","US","S73","a","hist","s","cms","250121700","0","0"),
("2017","US","S72","a","hist","s","cms","578501000","0","0"),("2017","US","S73","a","hist","s","cms","274110000","0","0"),
("2018","US","S72","a","hist","s","cms","596516000","0","0"),("2018","US","S73","a","hist","s","cms","298900000","0","0"),
("2019","US","S72","a","hist","s","cms","615009000","0","0"),("2019","US","S73","a","hist","s","cms","327606000","0","0"),
("2020","US","S72","a","hist","s","cms","672011000","0","0"),("2020","US","S73","a","hist","s","cms","329438000","0","0"),
("2021","US","S72","a","hist","s","cms","735377000","0","0"),("2021","US","S73","a","hist","s","cms","363069000","0","0"),
("2022","US","S72","a","hist","s","cms","805732000","0","0"),("2022","US","S73","a","hist","s","cms","415662000","0","0")
Done