return to Menu

See blog entry for source details
replace government_spending (year,state,code,source,fy,spend_rev,author,spending) values ("1945","US","FDA","a","hist","s","frb","0"), ("1945","US","FDM","a","hist","s","frb","0"), ("1946","US","FDA","a","hist","s","frb","0"), ("1946","US","FDM","a","hist","s","frb","0"), ("1947","US","FDA","a","hist","s","frb","0"), ("1947","US","FDM","a","hist","s","frb","0"), ("1948","US","FDA","a","hist","s","frb","0"), ("1948","US","FDM","a","hist","s","frb","0"), ("1949","US","FDA","a","hist","s","frb","0"), ("1949","US","FDM","a","hist","s","frb","0"), ("1950","US","FDA","a","hist","s","frb","0"), ("1950","US","FDM","a","hist","s","frb","0"), ("1951","US","FDA","a","hist","s","frb","1941"), ("1951","US","FDM","a","hist","s","frb","45"), ("1952","US","FDA","a","hist","s","frb","1996"), ("1952","US","FDM","a","hist","s","frb","55"), ("1953","US","FDA","a","hist","s","frb","1871"), ("1953","US","FDM","a","hist","s","frb","61"), ("1954","US","FDA","a","hist","s","frb","2045"), ("1954","US","FDM","a","hist","s","frb","86"), ("1955","US","FDA","a","hist","s","frb","3111"), ("1955","US","FDM","a","hist","s","frb","127"), ("1956","US","FDA","a","hist","s","frb","3845"), ("1956","US","FDM","a","hist","s","frb","157"), ("1957","US","FDA","a","hist","s","frb","4728"), ("1957","US","FDM","a","hist","s","frb","175"), ("1958","US","FDA","a","hist","s","frb","5041"), ("1958","US","FDM","a","hist","s","frb","195"), ("1959","US","FDA","a","hist","s","frb","6956"), ("1959","US","FDM","a","hist","s","frb","204"), ("1960","US","FDA","a","hist","s","frb","7378"), ("1960","US","FDM","a","hist","s","frb","201"), ("1961","US","FDA","a","hist","s","frb","8851"), ("1961","US","FDM","a","hist","s","frb","312"), ("1962","US","FDA","a","hist","s","frb","9123"), ("1962","US","FDM","a","hist","s","frb","453"), ("1963","US","FDA","a","hist","s","frb","10953"), ("1963","US","FDM","a","hist","s","frb","551"), ("1964","US","FDA","a","hist","s","frb","12056"), ("1964","US","FDM","a","hist","s","frb","676"), ("1965","US","FDA","a","hist","s","frb","14810"), ("1965","US","FDM","a","hist","s","frb","949"), ("1966","US","FDA","a","hist","s","frb","18258"), ("1966","US","FDM","a","hist","s","frb","1480"), ("1967","US","FDA","a","hist","s","frb","19462"), ("1967","US","FDM","a","hist","s","frb","2169"), ("1968","US","FDA","a","hist","s","frb","22728"), ("1968","US","FDM","a","hist","s","frb","2616"), ("1969","US","FDA","a","hist","s","frb","34278"), ("1969","US","FDM","a","hist","s","frb","3499"), ("1970","US","FDA","a","hist","s","frb","37848"), ("1970","US","FDM","a","hist","s","frb","5957"), ("1971","US","FDA","a","hist","s","frb","40451"), ("1971","US","FDM","a","hist","s","frb","10542"), ("1972","US","FDA","a","hist","s","frb","45546"), ("1972","US","FDM","a","hist","s","frb","15160"), ("1973","US","FDA","a","hist","s","frb","59877"), ("1973","US","FDM","a","hist","s","frb","19709"), ("1974","US","FDA","a","hist","s","frb","76072"), ("1974","US","FDM","a","hist","s","frb","24420"), ("1975","US","FDA","a","hist","s","frb","79029"), ("1975","US","FDM","a","hist","s","frb","31152"), ("1976","US","FDA","a","hist","s","frb","82118"), ("1976","US","FDM","a","hist","s","frb","45418"), ("1977","US","FDA","a","hist","s","frb","92621"), ("1977","US","FDM","a","hist","s","frb","59512"), ("1978","US","FDA","a","hist","s","frb","117354"), ("1978","US","FDM","a","hist","s","frb","75627"), ("1979","US","FDA","a","hist","s","frb","144295"), ("1979","US","FDM","a","hist","s","frb","99954"), ("1980","US","FDA","a","hist","s","frb","163383"), ("1980","US","FDM","a","hist","s","frb","117260"), ("1981","US","FDA","a","hist","s","frb","192214"), ("1981","US","FDM","a","hist","s","frb","137628"), ("1982","US","FDA","a","hist","s","frb","202193"), ("1982","US","FDM","a","hist","s","frb","196517"), ("1983","US","FDA","a","hist","s","frb","212323"), ("1983","US","FDM","a","hist","s","frb","255930"), ("1984","US","FDA","a","hist","s","frb","241132"), ("1984","US","FDM","a","hist","s","frb","304033"), ("1985","US","FDA","a","hist","s","frb","256553"), ("1985","US","FDM","a","hist","s","frb","394587"), ("1986","US","FDA","a","hist","s","frb","268376"), ("1986","US","FDM","a","hist","s","frb","575435"), ("1987","US","FDA","a","hist","s","frb","313519"), ("1987","US","FDM","a","hist","s","frb","677841"), ("1988","US","FDA","a","hist","s","frb","364316"), ("1988","US","FDM","a","hist","s","frb","770459"), ("1989","US","FDA","a","hist","s","frb","378070"), ("1989","US","FDM","a","hist","s","frb","905165"), ("1990","US","FDA","a","hist","s","frb","396972"), ("1990","US","FDM","a","hist","s","frb","1050306"), ("1991","US","FDA","a","hist","s","frb","405736"), ("1991","US","FDM","a","hist","s","frb","1179729"), ("1992","US","FDA","a","hist","s","frb","451677"), ("1992","US","FDM","a","hist","s","frb","1299797"), ("1993","US","FDA","a","hist","s","frb","564165"), ("1993","US","FDM","a","hist","s","frb","1399296"), ("1994","US","FDA","a","hist","s","frb","716783"), ("1994","US","FDM","a","hist","s","frb","1480246"), ("1995","US","FDA","a","hist","s","frb","814908"), ("1995","US","FDM","a","hist","s","frb","1600095"), ("1996","US","FDA","a","hist","s","frb","895813"), ("1996","US","FDM","a","hist","s","frb","1740359"), ("1997","US","FDA","a","hist","s","frb","1032256"), ("1997","US","FDM","a","hist","s","frb","1847555"), ("1998","US","FDA","a","hist","s","frb","1323758"), ("1998","US","FDM","a","hist","s","frb","2113010"), ("1999","US","FDA","a","hist","s","frb","1620483"), ("1999","US","FDM","a","hist","s","frb","2323499"), ("2000","US","FDA","a","hist","s","frb","1892900"), ("2000","US","FDM","a","hist","s","frb","2535824"), ("2001","US","FDA","a","hist","s","frb","2175623"), ("2001","US","FDM","a","hist","s","frb","2956420"), ("2002","US","FDA","a","hist","s","frb","2406836"), ("2002","US","FDM","a","hist","s","frb","3230475"), ("2003","US","FDA","a","hist","s","frb","2602671"), ("2003","US","FDM","a","hist","s","frb","3346388"), ("2004","US","FDA","a","hist","s","frb","2640891"), ("2004","US","FDM","a","hist","s","frb","3407181"), ("2005","US","FDA","a","hist","s","frb","2589715"), ("2005","US","FDM","a","hist","s","frb","3627218"), ("2006","US","FDA","a","hist","s","frb","2644481"), ("2006","US","FDM","a","hist","s","frb","3956458"), ("2007","US","FDA","a","hist","s","frb","2938117"), ("2007","US","FDM","a","hist","s","frb","4602238"), ("2008","US","FDA","a","hist","s","frb","3118309"), ("2008","US","FDM","a","hist","s","frb","5041969"), ("2009","US","FDA","a","hist","s","frb","6703787"), ("2009","US","FDM","a","hist","s","frb","987799"), ("2010","US","FDA","a","hist","s","frb","6437298"), ("2010","US","FDM","a","hist","s","frb","1194287"), ("2011","US","FDA","a","hist","s","frb","6178597"), ("2011","US","FDM","a","hist","s","frb","1336809"), ("2012","US","FDA","a","hist","s","frb","6103474"), ("2012","US","FDM","a","hist","s","frb","1468060"), ("2013","US","FDA","a","hist","s","frb","6111353"), ("2013","US","FDM","a","hist","s","frb","1589754"), ("2014","US","FDA","a","hist","s","frb","6234619"), ("2014","US","FDM","a","hist","s","frb","1646186"), ("2015","US","FDA","a","hist","s","frb","6350100"), ("2015","US","FDM","a","hist","s","frb","1803851"), ("2016","US","FDA","a","hist","s","frb","6570217"), ("2016","US","FDM","a","hist","s","frb","1977111"), ("2017","US","FDA","a","hist","s","frb","6685669"), ("2017","US","FDM","a","hist","s","frb","2161480"), ("2018","US","FDA","a","hist","s","frb","6808433"), ("2018","US","FDM","a","hist","s","frb","2314979"), ("2019","US","FDA","a","hist","s","frb","7318099"), ("2019","US","FDM","a","hist","s","frb","2429819"), ("2020","US","FDA","a","hist","s","frb","7775145"), ("2020","US","FDM","a","hist","s","frb","2431388"), ("2021","US","FDA","a","hist","s","frb","8372641"), ("2021","US","FDM","a","hist","s","frb","2534783"), ("2022","US","FDA","a","hist","s","frb","9303695"), ("2022","US","FDM","a","hist","s","frb","2717875"), ("2023","US","FDA","a","hist","s","frb","9047513"), ("2023","US","FDM","a","hist","s","frb","2906200"), ("2024","US","FDA","a","hist","s","frb","9197802"), ("2024","US","FDM","a","hist","s","frb","3077968"), ("2025","US","FDA","a","hist","s","frb","9308508"), ("2025","US","FDM","a","hist","s","frb","3231348"), ("2026","US","FDA","a","hist","s","frb","9420546"), ("2026","US","FDM","a","hist","s","frb","3392371"), ("2027","US","FDA","g","fy28","s","frb","9533932"), ("2027","US","FDM","g","fy28","s","frb","3561418"), ("2028","US","FDA","g","fy28","s","frb","9648683"), ("2028","US","FDM","g","fy28","s","frb","3738889"), ("2029","US","FDA","g","fy28","s","frb","9764815"), ("2029","US","FDM","g","fy28","s","frb","3925204"), ("2030","US","FDA","g","fy28","s","frb","9882345"), ("2030","US","FDM","g","fy28","s","frb","4120803"), ("2031","US","FDA","g","fy28","s","frb","10001290"), ("2031","US","FDM","g","fy28","s","frb","4326149"), ("2032","US","FDA","g","fy28","s","frb","10121667"), ("2032","US","FDM","g","fy28","s","frb","4541728")

Done