U.S. Department of Education Education Stabilization Fund
School COVID relief spending
How each school district reported using its COVID relief money (ESSER and related funds), by year. Also covers governors' (GEER), colleges' (HEER), and private-school (EANS) funds.
Published by U.S. Department of Education Education Stabilization Fund
Finest detail district
Tables 40
HEER — data notes
Sample of 25 rows out of about 41
· 7 columns
| row_id | reporting_year | row_no | leaid | worksheet_s | variable_s | data_note |
|---|---|---|---|---|---|---|
| 1 | 2023 | 1 | No data | Prime, Enriched | No data | The unit of analysis for the data file is the unit of reporting for HEERF, which is a grant entity with a unique DUNS number. In some cases, multiple grant entities may serve one institution. For institutions undergoing mergers and acquisitions since grants were initially awarded, institutions were instructed to report branches/campuses separately based on the original entities separate. |
| 2 | 2023 | 2 | No data | Enriched | No data | The data variables in the enriched tab are derived from the Integrated Postsecondary Data System (IPEDS) by matching on the Office of Postsecondary Identification Number (OPEID) associated with the grant application and updated in the grants management database on December 31, 2023. |
| 3 | 2023 | 3 | No data | Prime, Enriched | state, stabbr | The state variable in the prime worksheet is derived from grant application information, whereas the state abbreviation variable in the enriched worksheet is derived from a crosswalk with data from the IPEDS and in a small subset of cases the state designations do not match. To the extent that institutions can serve students in different locations, the state designations do not indicate the location of students served, rather, locations of specific campuses or administrative units where HEERF is disbursed from. |
| 4 | 2023 | 4 | No data | Prime, Enriched | All enrolled student count variables in the prime data worksheet that include the string "Enrolled" (e.g., ugFtPellEnrolled), "EnrolledStudentCount" (e.g., aiEnrolledStudentCount), or "EnrolledStudentsNotEligibleTitleIV" (e.g., nEnrolledStudentsNotEligibleTitleIV) All enrolled student count variables in the enriched data worksheet: numIheStudents and all variables that include the string "pct" (e.g., pctPell) | Students enrolled are defined differently in the prime and enriched worksheets. In the prime worksheet, students enrolled represent an unduplicated 12-month calendar year enrollment count and can include non-credit students. In the enriched worksheet, students enrolled represent the count of students as reported to IPEDS for fall enrollment and excludes non-credit students. |
| 5 | 2023 | 5 | No data | Prime | All recipient count variables that include the string "HeerRecipients" (e.g., allStudentsHeerRecipients), "ReceivedAidGrant" (e.g., aiReceivedAidGrant), or "StudentsReceivedGrantsNotEligibleTitleIV" (e.g., nStudentsReceivedGrantsNotEligibleTitleIV) | Institutions were asked to report the number of students in specific subgroups and the total amount of Emergency Financial Aid Grants awarded to that subgroup of students. Some institutions reported groups and/or subgroups of students as students receiving Emergency Financial Aid Grants with a corresponding zero dollars of total aid dispersed to those student recipients. |
| 6 | 2023 | 6 | No data | Prime | All award amount variables that include the string "minimumAward" (e.g., minimumAwardUgFtPell), "maximumAward" (e.g., maximumAwardUgFtPell), or "AverageHeerAmount" (e.g., ugFtPellAverageHeerAmount) | Institutions that reported minimum, average, and maximum Emergency Financial Aid Grants of more than $10,000, $50,000, and $50,000, respectively, were flagged by the Department and reporting institutions were encouraged to double check their numbers in a subsequent data correction period. The values in the data file represent reported values after the subsequent data correction and some values remained above these thresholds. |
| 7 | 2023 | 7 | No data | Prime | All enrolled student count variables that include the string "Enrolled" (e.g., ugFtPellEnrolled) All recipient count variables that include the string "HeerRecipients" (e.g., ugFtPellHeerRecipients) | While possible that IHEs may have awarded HEERF funds to a greater number of recipients than enrolled students (e.g. students who received grants in late December for January enrollment), there are cases where the number of student grant recipients is larger than the number of enrolled students by an order of magnitude. Users should exercise caution before performing an analysis on student grants. |
| 8 | 2023 | 8 | No data | Prime | allEnrolledStudents, allStudentsHeerRecipients, [a1StudentAid/a1Institutional/a2/a3/a4]DirectTotal, [a1StudentAid/a1Institutional/a2/a3/a4]OutstandingTotal, [minimum/maximum]Award, [ugFtPell/ugFtNonPell/ugPtPell/ugPtNonPell/gFt/gPt/other/allStudents]GrantAmountTotal, [ugFtPell/ugFtNonPell/ugPtPell/ugPtNonPell/gFt/gPt/other/allStudents]AverageHeerAmount, p[EnrolledStudents/StudentsGrantedHeer]NotEligibleTitleIV, [ai/a/b/h/nh/w/tmr/ur/nr/ncr/m/wo/ncg/tfo/tfy/ana]AverageHeerfAward, [a1/a2/a3/total]AnnualExpenditure, lostRevenueTotal | These variables are derived from data entered by the grantees or subgrantees. See the HEERF Data Dictionary of the HEERF Supporting Documentation file for further detail on each variable's calculation. |
| 9 | 2023 | 9 | No data | Prime | uei, opeIds | This was automatically filled for institutions from the Department's grant management system, G5 as of December 31, 2023. |
| 10 | 2023 | 10 | No data | Prime, Enriched | dunsNumber, duns | DUNS numbers were assigned as OPEIDs for the City University of New York (CUNY) campuses. |
| 11 | 2023 | 11 | No data | Prime | a3DirectTotal, a3OutstandingTotal, a3AnnualExpenditure, awardedAmountsSsarp | The HEERF data system treats all SSARP Emergency Financial Aid Grants as institutional portion funds in question 9 (institution portion spending). However, in some cases institutions had student portions of SSARP dedicated to Emergency Financial Aid Grants that were not part of the institutional portion award. For these institutions, the sum of institutional expenditures from question 9 may sum to an amount greater than the amount awarded for institutional portion funds. |
| 12 | 2023 | 12 | No data | Prime | allStudentsHeerRecipients, allStudentsGrantAmountTotal, | At some institutions, Emergency Financial Aid Grant checks awarded in 2020 and/or 2021 were never cashed by student recipients and institutions reissued in subsequent years. For some checks that were reissued in 2023, institutions did not get a chance to make corrections to their 2020 and/or 2021 report(s). As such, in a few cases, the sum of emergency financial aid awarded across all years can exceed the sum of awarded funds. |
| 16 | 2022 | 1 | No data | Prime, Enriched | No data | The unit of analysis for the data file is the unit of reporting for HEERF, which is a grant entity with a unique DUNS number. In some cases, multiple grant entities may serve one institution. For institutions undergoing mergers and acquisitions since grants were initially awarded, institutions were instructed to report branches/campuses separately based on the original entities separate. |
| 17 | 2022 | 2 | No data | Enriched | No data | The data variables in the enriched tab are derived from the Integrated Postsecondary Data System (IPEDS) by matching on the Office of Postsecondary Identification Number (OPEID) associated with the grant application and updated in the grants management database on December 31, 2022. |
| 18 | 2022 | 3 | No data | Prime, Enriched | state, stabbr | The state variable in the prime worksheet is derived from grant application information, whereas the state abbreviation variable in the enriched worksheet is derived from a crosswalk with data from the IPEDS and in a small subset of cases the state designations do not match. To the extent that institutions can serve students in different locations, the state designations do not indicate the location of students served, rather, locations of specific campuses or administrative units where HEERF is disbursed from. |
| 19 | 2022 | 4 | No data | Prime, Enriched | All enrolled student count variables in the prime data worksheet that include the string "Enrolled" (e.g., ugFtPellEnrolled), "EnrolledStudentCount" (e.g., aiEnrolledStudentCount), or "EnrolledStudentsNotEligibleTitleIV" (e.g., nEnrolledStudentsNotEligibleTitleIV) All enrolled student count variables in the enriched data worksheet: numIheStudents and all variables that include the string "pct" (e.g., pctPell) | Students enrolled are defined differently in the prime and enriched worksheets. In the prime worksheet, students enrolled represent an unduplicated 12-month calendar year enrollment count and can include non-credit students. In the enriched worksheet, students enrolled represent the count of students as reported to IPEDS for fall enrollment and excludes non-credit students. |
| 20 | 2022 | 5 | No data | Prime | All recipient count variables that include the string "HeerRecipients" (e.g., allStudentsHeerRecipients), "ReceivedAidGrant" (e.g., aiReceivedAidGrant), or "StudentsReceivedGrantsNotEligibleTitleIV" (e.g., nStudentsReceivedGrantsNotEligibleTitleIV) | Institutions were asked to report the number of students in specific subgroups and the total amount of Emergency Financial Aid Grants awarded to that subgroup of students. Some institutions reported groups and/or subgroups of students as students receiving Emergency Financial Aid Grants with a corresponding zero dollars of total aid dispersed to those student recipients. |
| 21 | 2022 | 6 | No data | Prime | All award amount variables that include the string "minimumAward" (e.g., minimumAwardUgFtPell), "maximumAward" (e.g., maximumAwardUgFtPell), or "AverageHeerAmount" (e.g., ugFtPellAverageHeerAmount) | Institutions that reported minimum, average, and maximum Emergency Financial Aid Grants of more than $10,000, $50,000, and $50,000, respectively, were flagged by the Department and reporting institutions were encouraged to double check their numbers in a subsequent data correction period. The values in the data file represent reported values after the subsequent data correction and some values remained above these thresholds. |
| 22 | 2022 | 7 | No data | Prime | All enrolled student count variables that include the string "Enrolled" (e.g., ugFtPellEnrolled) All recipient count variables that include the string "HeerRecipients" (e.g., ugFtPellHeerRecipients) | While possible that IHEs may have awarded HEERF funds to a greater number of recipients than enrolled students (e.g. students who received grants in late December for January enrollment), there are cases where the number of student grant recipients is larger than the number of enrolled students by an order of magnitude. Users should exercise caution before performing an analysis on student grants. |
| 23 | 2022 | 8 | No data | Prime | allEnrolledStudents, allStudentsHeerRecipients, [a1StudentAid/a1Institutional/a2/a3/a4]DirectTotal, [a1StudentAid/a1Institutional/a2/a3/a4]OutstandingTotal, [minimum/maximum]Award, [ugFtPell/ugFtNonPell/ugPtPell/ugPtNonPell/gFt/gPt/other/allStudents]GrantAmountTotal, [ugFtPell/ugFtNonPell/ugPtPell/ugPtNonPell/gFt/gPt/other/allStudents]AverageHeerAmount, p[EnrolledStudents/StudentsGrantedHeer]NotEligibleTitleIV, [ai/a/b/h/nh/w/tmr/ur/nr/ncr/m/wo/ncg/tfo/tfy/ana]AverageHeerfAward, [a1/a2/a3/total]AnnualExpenditure, lostRevenueTotal | These variables are derived from data entered by the grantees or subgrantees. See the HEERF Data Dictionary of the HEERF Supporting Documentation file for further detail on each variable's calculation. |
| 24 | 2022 | 9 | No data | Prime | uei | This was automatically filled for institutions based on information from sam.gov |
| 25 | 2022 | 10 | No data | Prime | opeIds | This was automatically filled for institutions from the Department's grant management system, G5 as of December 31, 2022. |
| 26 | 2022 | 11 | No data | Prime, Enriched | dunsNumber, duns | DUNS numbers were assigned as OPEIDs for the City University of New York (CUNY) campuses. |
| 27 | 2022 | 12 | No data | Prime | allEnrolledStudents, allStudentsHeerRecipients, allStudentsGrantAmountTotal, nEnrolledStudentsNotEligibleTitleIV, pEnrolledStudentsNotEligibleTitleIV, nStudentsReceivedGrantsNotEligibleTitleIV, pStudentsGrantedHeerNotEligibleTitleIV, [ai/a/b/h/nh/w/tmr/ur/nr/ncr/m/wo/ncg/tfo/tfy/ana]EnrolledStudentCount, [ai/a/b/h/nh/w/tmr/ur/nr/ncr/m/wo/ncg/tfo/tfy/ana]ReceivedAidGrant, [ai/a/b/h/nh/w/tmr/ur/nr/ncr/m/wo/ncg/tfo/tfy/ana]TotalAmountOfGrants, | In some cases, institutions reported inconsistent total amounts of students receiving Emergency Financial Aid Grants and amounts of Emergency Financial Aid Grants awarded across questions 8a, 8b, 8c, 8d, 8e, and 8f. For example, for some observations, the total number of HEERF recipients reported by race/ethnicity in 8d differs from the total number of HEERF recipients reported by academic level, enrollment intensity, and Pell grant status in 8a. Several observations were flagged by the Department and reporting institutions were encouraged to double check their numbers in a subsequent data correction period. |
| 28 | 2022 | 13 | No data | Prime | a3DirectTotal, a3OutstandingTotal, a3AnnualExpenditure, awardedAmountsSsarp | The HEERF data system treats all SSARP Emergency Financial Aid Grants as institutional portion funds in question 9 (institution portion spending). However, in some cases institutions had student portions of SSARP dedicated to Emergency Financial Aid Grants that were not part of the institutional portion award. For these institutions, the sum of institutional expenditures from question 9 may sum to an amount greater than the amount awarded for institutional portion funds. |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing