ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ABOUT THIS WORKBOOK
2
This data was created by Portland State University and the Northwest Environmental Justice Center. The data was clipped to the federal 468 environment and energy programs identified by the authors (see Tab 3), and processed from https://www.usaspending.gov/ for fiscal years 2008 through April 6, 2025 (see Tab 2). All use of this data should be cited per the suggested citation below.

The authors recommend looking at FY 2010 data onward. USA Spending data for FY 2008 and FY 2009 seem more incomplete.

Suggested citation: Lalande, S., Huber, J., and Cochran, B. 2025. Patterns in Energy and Environment Program Spending: Nationwide. Northwest Environmental Justice Center. Accessed at https://www.pdx.edu/policy-consensus-center/federal-energy-environment-investment-project.
3
4
DATA DEFINITIONS
The column headers in tab 2 represent the grant or loan recipient type name from USA Spending ("Recipient_Type") and a broader grouping of recipient types assigned by the authors ("Recipient_Group"). The Recipient types and groupings are listed below with the letter codes from USA Spending.

The spending data for each fiscal year begins with "TotalFedAction_EnergyEnv_2008", which is the total federal obligations for a state in FY 2008 across the 468 energy and environment programs listed in tab 3. The next column "TotalFedAction_2008" is the total of ALL federal grants and loans for a state in FY 2008. The federal fiscal year runs from October 1 to September 30. No per capita information is provided, since Congressional Districts are delineated to have similar populations within a state.

For each fiscal year, the spending data is also presented in constant 2024 dollars "TotalFedAction_EnergyEnv_2008_2024$" and "TotalFedAction_2008_2024$". The spending dollars were adjusted using the GDP implicit price deflator (https://www.bea.gov/data/prices-inflation/gdp-price-deflator).
5
6
STATE AND TERRITORIAL GOVERNMENT
7
A = State Government
8
F = U.S. Territory or Possession
9
10
LOCAL AND REGIONAL GOVERNMENT
11
B = County Government
12
C = City or Township Government
13
D = Special District Government
14
E = Regional Organization
15
G = Independent School District
16
17
HIGHER EDUCATION
18
H = Public/State Controlled Institution of Higher Education
19
O = Private Institution of Higher Education
20
S = Hispanic-serving Institution
21
T = Historically Black College or University (HBCU)
22
23
24
TRIBAL ENTITIES
25
I = Indian/Native American Tribal Government (Federally -Recognized)
26
J = Indian/Native American Tribal Government (Other than Federally-Recognized)
27
K = Indian/Native American Tribal Designated Organization
28
L = Public/Indian Housing Authority
29
U = Tribally Controlled College or University (TCCU)
30
V = Alaska Native and Native Hawaiian Serving Institutions
31
32
NONPROFITS
33
M = Nonprofit with 501C3 IRS Status (Other than an Institution of Higher Education)
34
N = Nonprofit without 501C3 IRS Status (Other than an Institution of Higher Education)
35
36
INDIVIDUALS
37
P = Individual
38
39
PRIVATE BUSINESS
40
Q = For-Profit Organization (Other than Small Business)
41
R = Small Business
42
43
NON-DOMESTIC
44
W = Non-domestic (non-U.S.) Entity
45
46
OTHER
47
W = Non-domestic (non-U.S.) Entity
48
X = Other
49
Compound: Recipient is more than one type
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100