return to Menu

select year,state,code,fy,source,spending,state_spending,local_spending from government_spending where year >= 2025 and state = 'US' and spend_rev = 's' and code in ('GDP','GDC') and fy in ('hist','fy28') order by code
start year 1929
data 1929

data104,556
start year 1929
data 1929

data1,191,124

0.99999960997299 0.99999974845931
replace government_spending (year,state,code,author,source,fy,spend_rev,spending) values ("2025","US","GDP","bea","a","hist","s","30767088"),("2025","US","GDC","bea","a","hist","s","23852994"),("2025","US","GDP","bea","a","hist","r","30767088"),("2025","US","GDC","bea","a","hist","r","23852994")
replace government_spending (year,state,code,author,source,fy,spend_rev,spending) values ("2025","US","GDP","bea","a","hist","s","30767088"),("2025","US","GDC","bea","a","hist","s","23852994"),("2025","US","GDP","bea","a","hist","r","30767088"),("2025","US","GDC","bea","a","hist","r","23852994"), ("2026","US","GDP","cgc","g","hist","s","30552700"),("2026","US","GDC","cgc","g","hist","s","23369100"),("2026","US","GDP","cgc","g","hist","r","30552700"),("2026","US","GDC","cgc","g","hist","r","23369100"), ("2031","US","GDP","cgc","g","fy28","s","41253900"),("2031","US","GDC","cgc","g","fy28","s","28227100"),("2031","US","GDP","cgc","g","fy28","r","41253900"),("2031","US","GDC","cgc","g","fy28","r","28227100"), ("2027","US","GDP","cgc","g","fy28","s","33793000"),("2027","US","GDC","cgc","g","fy28","s","23835500"),("2027","US","GDP","cgc","g","fy28","r","33793000"),("2027","US","GDC","cgc","g","fy28","r","23835500"), ("2030","US","GDP","cgc","g","fy28","s","39285300"),("2030","US","GDC","cgc","g","fy28","s","27414700"),("2030","US","GDP","cgc","g","fy28","r","39285300"),("2030","US","GDC","cgc","g","fy28","r","27414700"), ("2028","US","GDP","cgc","g","fy28","s","33129200"),("2028","US","GDC","cgc","g","fy28","s","24313200"),("2028","US","GDP","cgc","g","fy28","r","33129200"),("2028","US","GDC","cgc","g","fy28","r","24313200"), ("2029","US","GDP","cgc","g","fy28","s","37371600"),("2029","US","GDC","cgc","g","fy28","s","24808300"),("2029","US","GDP","cgc","g","fy28","r","37371600"),("2029","US","GDC","cgc","g","fy28","r","24808300")

Done