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
State agency — data notes
Sample of 24 rows out of about 24
· 10 columns
| row_id | reporting_year | row_no | leaid | outlying_area_s | reporting_level_s | worksheet_s | variable_s | business_rule_s | data_note |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2023 | 1 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp, crossact, schools | No data | No data | Many of the variable names in this dataset are shared with the ESSER dataset. Please note that this was done for reporting purposes only and these variables often represent different elements in this file. As such, the ESF-SEA and ESSER datasets should not be merged on these shared variable names. For more details about ESF-SEA variables, please see the ESF-SEA Data Dictionary of the ESF-SEA Supporting Documentation file. |
| 2 | 2023 | 2 | No data | All | Subgrantee | cares, crrsa, arp, crossact, schools | ueiNumber | No data | The federal government transitioned grantees and subgrantees from DUNS to UEI in 2022; natural persons and entities that were unable to obtain a UEI, or dissolved before UEIs were assigned, are assigned a synthetic UEI. The syntax of Department-issued synthetic UEIs is as follows: "O**XXXXXX###" (where ** is the 2 letter code of the Outlying Area that requested the temporary UEI). Example: OGUXXXXXX001. |
| 3 | 2023 | 3 | No data | All | Subgrantee | cares, crrsa, arp, crossact, schools | dunsNumber | No data | The federal government transitioned grantees and subgrantees from DUNS to UEI in 2022. Subgrantees that had not previously existed or registered to receive federal moneys did not therefore have DUNS numbers, and were provided synthetic DUNS numbers to enable submission. The syntax of Department-issued synthetic DUNS numbers is as follows: "999999###". Example: 999999001. |
| 4 | 2023 | 4 | No data | All | Prime | prime | esser1GrantAmountAllocated, esser2GrantAmountAllocated, esser3GrantAmountAllocated | No data | These amounts were automatically filled for grantees using information from the Department's grant management system, G5, as of 9/30/23. |
| 5 | 2023 | 5 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp | All expenditure and remaining funds variables | No data | Per the Uniform Guidance (CFR, Title 2, Subtitle A, Chapter II, Part 200), a grantee or subgrantee may report expenditures on a cash or accrual basis, as long as the methodology is disclosed and is consistently applied. Therefore, expenditures are not consistently reported across all grantees and subgrantees, but are consistently reported across reporting years by each grantee and subgrantee. In terms of data, two entities pursuing different accounting methodologies could legitimately report purchases made the same day as expenditures in different reporting periods, for example. |
| 6 | 2023 | 6 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp | esser[1/2/3]GrantAmountRemaining, esser[1/2/3]MandPhysicalExpendedTotal, esser[1/2/3]MandAcademicExpendedTotal, esser[1/2/3]MandAcademicExpendedTotal, esser[1/2/3]MandOperationalExpendedTotal, esser[1/2/3]MandatoryRemaining | No data | These variables are derived from data entered by the grantees or subgrantees. See the ESF-SEA Data Dictionary of the ESF-SEA Supporting Documentation file for further detail on each variable's calculation. |
| 7 | 2023 | 7 | No data | VI | Subgrantee | crrsa | esser2MandPhysicalPersonnelSalaries, esser2MandPhysicalPersonnelBenefits, esser2MandPhysicalTechnical, esser2MandPhysicalPropertyServices, esser2MandPhysicalOtherServices, esser2MandPhysicalSupplies, esser2MandPhysicalProperty, esser2MandPhysicalDebtService, esser2MandPhysicalOtherItems, esser2MandPhysicalBuilding, esser2MandPhysicalMeals, esser2MandPhysicalCleaning, esser2MandPhysicalTempClassroom, esser2MandPhysicalTempTransportation, esser2MandPhysicalCapacityBuilding, esser2MandPhysicalHealthProtocols | No data | This Outlying Area reported LEAs with a sum of ESF-II SEA subgrant expenditures by accounting object in the current reporting period to address physical health and safety that differed from the sum of subgrant expenditures by activity in the current reporting period to address physical health and safety by more than $100. |
| 8 | 2023 | 8 | No data | VI | Subgrantee | crrsa | esser2MandAcademicPersonnelSalaries, esser2MandAcademicPersonnelBenefits, esser2MandAcademicTechnical, esser2MandAcademicPropertyServices, esser2MandAcademicOtherServices, esser2MandAcademicSupplies, esser2MandAcademicProperty, esser2MandAcademicDebtService, esser2MandAcademicOtherItems, esser2MandAcademicExtendedLearning, esser2MandAcademicTutoring, esser2MandAcademicAddlStaff, esser2MandAcademicScreening, esser2MandAcademicCoordination, esser2MandAcademicEcp, esser2MandAcademicHardware, esser2MandAcademicWifi, esser2MandAcademicCurriculum | No data | This Outlying Area reported LEAs with a sum of ESF-II SEA subgrant expenditures by accounting object in the current reporting period to address students' academic needs that differed from the sum of subgrant expenditures by activity in the current reporting period to address students' academic needs by more than $100. |
| 16 | 2022 | 1 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp, crossact, schools | No data | No data | Many of the variable names in this dataset are shared with the ESSER dataset. Please note that this was done for reporting purposes only and these variables often represent different elements in this file. As such, the ESF-SEA and ESSER datasets should not be merged on these shared variable names. For more details about ESF-SEA variables, please see the ESF-SEA Data Dictionary of the ESF-SEA Supporting Documentation file. |
| 17 | 2022 | 2 | No data | All | Subgrantee | cares, crrsa, arp, crossact, schools | ueiNumber | No data | The federal government transitioned grantees and subgrantees from DUNS to UEI in 2022; natural persons and entities that were unable to obtain a UEI, or dissolved before UEIs were assigned, are assigned a synthetic UEI. The syntax of Department-issued synthetic UEIs is as follows: "O**XXXXXX###" (where ** is the 2 letter code of the Outlying Area that requested the temporary UEI). Example: OGUXXXXXX001. |
| 18 | 2022 | 3 | No data | All | Subgrantee | cares, crrsa, arp, crossact, schools | dunsNumber | No data | The federal government transitioned grantees and subgrantees from DUNS to UEI in 2022. Subgrantees that had not previously existed or registered to receive federal moneys did not therefore have DUNS numbers, and were provided synthetic DUNS numbers to enable submission. The syntax of Department-issued synthetic DUNS numbers is as follows: "999999###". Example: 999999001. |
| 19 | 2022 | 4 | No data | All | Prime | prime | esser1GrantAmountAllocated, esser2GrantAmountAllocated, esser3GrantAmountAllocated | No data | These amounts were automatically filled for grantees using information from the Department's grant management system, G5, as of 9/30/22. |
| 20 | 2022 | 5 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp | All expenditure and remaining funds variables | No data | Per the Uniform Guidance (CFR, Title 2, Subtitle A, Chapter II, Part 200), a grantee or subgrantee may report expenditures on a cash or accrual basis, as long as the methodology is disclosed and is consistently applied. Therefore, expenditures are not consistently reported across all grantees and subgrantees, but are consistently reported across reporting years by each grantee and subgrantee. In terms of data, two entities pursuing different accounting methodologies could legitimately report purchases made the same day as expenditures in different reporting periods, for example. |
| 21 | 2022 | 6 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp | esser[1/2/3]GrantAmountRemaining, esser[1/2/3]MandPhysicalExpendedTotal, esser[1/2/3]MandAcademicExpendedTotal, esser[1/2/3]MandAcademicExpendedTotal, esser[1/2/3]MandOperationalExpendedTotal, esser[1/2/3]MandatoryRemaining | No data | These variables are derived from data entered by the grantees or subgrantees. See the ESF-SEA Data Dictionary of the ESF-SEA Supporting Documentation file for further detail on each variable's calculation. |
| 22 | 2022 | 7 | No data | All | Subgrantee | crossact, schools | esserAAmountExpendedStaff, esserANumberEmployedSpecialEd, esserANumberEmployedParaprofessionals, esserANumberEmployedBilingual, esserANumberEmployedCounselors, esserANumberEmployedNurses, esserANumberEmployedContractors, esserANumberEmployedOtherTeachers, esserANumberEmployedSupportPersonnel, esserANumberEmployedAdminStaff, schoolName, esserASchoolFteSpecialEd, esserASchoolFteBilingual, esserASchoolFteCounselors, esserASchoolFteNurses | No data | Responses to ESF-SEA questions 3.c8 “SEA and/or LEA Hiring and Retention of Specific Positions with ESF I-SEA, ESF II-SEA, and/or ARP-OA SEA Funds” and 4.c1 “Access to select staff" were optional for the Fiscal Year 2021 and 2022 Annual Performance Reports. Discretion should be used when utilizing these data as grantees were not required to provide responses for these questions. |
| 23 | 2021 | 1 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp, crossact, schools | No data | No data | Many of the variable names in this dataset are shared with the ESSER dataset. Please note that this was done for reporting purposes only and these variables often represent different elements in this file. As such, the ESF-SEA and ESSER datasets should not be merged on these shared variable names. For more details about ESF-SEA variables, please see the ESF-SEA Data Dictionary of the ESF-SEA Supporting Documentation file. |
| 24 | 2021 | 2 | No data | All | Subgrantee | cares, crrsa, arp, crossact, schools | ueiNumber | No data | The federal government transitioned grantees and subgrantees from DUNS to UEI in 2022; natural persons and entities that were unable to obtain a UEI, or dissolved before UEIs were assigned, are assigned a synthetic UEI. The syntax of Department-issued synthetic UEIs is as follows: "O**XXXXXX###" (where ** is the 2 letter code of the Outlying Area that requested the temporary UEI). Example: OGUXXXXXX001. |
| 25 | 2021 | 3 | No data | All | Subgrantee | cares, crrsa, arp, crossact, schools | dunsNumber | No data | The federal government transitioned grantees and subgrantees from DUNS to UEI in 2022. Subgrantees that had not previously existed or registered to receive federal moneys did not therefore have DUNS numbers, and were provided synthetic DUNS numbers to enable submission. The syntax of Department-issued synthetic DUNS numbers is as follows: "999999###". Example: 999999001. |
| 26 | 2021 | 4 | No data | All | Prime | prime | esser1GrantAmountAllocated, esser2GrantAmountAllocated, esser3GrantAmountAllocated | No data | These amounts were automatically filled for grantees using information from the Department's grant management system, G5, as of 9/30/21. |
| 27 | 2021 | 5 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp | All expenditure and remaining funds variables | No data | Per the Uniform Guidance (CFR, Title 2, Subtitle A, Chapter II, Part 200), a grantee or subgrantee may report expenditures on a cash or accrual basis, as long as the methodology is disclosed and is consistently applied. Therefore, expenditures are not consistently reported across all grantees and subgrantees, but are consistently reported across reporting years by each grantee and subgrantee. In terms of data, two entities pursuing different accounting methodologies could legitimately report purchases made the same day as expenditures in different reporting periods, for example. |
| 28 | 2021 | 6 | No data | All | Prime, Subgrantee | prime, cares, crrsa, arp | esser[1/2/3]GrantAmountRemaining, esser[1/2/3]MandPhysicalExpendedTotal, esser[1/2/3]MandAcademicExpendedTotal, esser[1/2/3]MandAcademicExpendedTotal, esser[1/2/3]MandOperationalExpendedTotal, esser[1/2/3]MandatoryRemaining | No data | These variables are derived from data entered by the grantees or subgrantees. See the ESF-SEA Data Dictionary of the ESF-SEA Supporting Documentation file for further detail on each variable's calculation. |
| 29 | 2021 | 7 | No data | GU, VI | Prime | prime | esser3SeaDirectExpendLostTimeCurrent, isEsser3Mand20Summer, isEsser3Mand20AftSch, isEsser3Mand20ExtendedTime, isEsser3Mand20Tutoring, isEsser3Mand20AddlTeachers, isEsser3Mand20StaffSocial, isEsser3Mand20StaffMental, isEsser3Mand20StaffStudentNeeds, isEsser3Mand20Screening, isEsser3Mand20Coordination, isEsser3Mand20EarlyChildhood, isEsser3Mand20Curriculum, isEsser3Mand20Capacity, isEsser3Mand20Other | No data | Guam and Virgin Islands reported $0 in expenditures from their ARP-OA SEA Reserves to address the impact of learning loss, provide evidence-based summer enrichment programs, and provide evidence-based comprehensive afterschool programs, but answered "True" to at least one use of funds categories. |
| 30 | 2021 | 8 | No data | AS | Prime, Subgrantee | prime, cares | esser1GrantAmountAllocated, esser1SeaReserveAdminTotal, esser1SeaReserveEmergencyTotal, esser1MandatorySubgrantAwarded | No data | American Samoa reported a total of subawards and Reserves that exceeds its ESF-I SEA allocation. |
| 31 | 2021 | 9 | No data | All | Subgrantee | crossact, schools | esserAAmountExpendedStaff, esserANumberEmployedSpecialEd, esserANumberEmployedParaprofessionals, esserANumberEmployedBilingual, esserANumberEmployedCounselors, esserANumberEmployedNurses, esserANumberEmployedContractors, esserANumberEmployedOtherTeachers, esserANumberEmployedSupportPersonnel, esserANumberEmployedAdminStaff, schoolName, esserASchoolFteSpecialEd, esserASchoolFteBilingual, esserASchoolFteCounselors, esserASchoolFteNurses | No data | Responses to ESF-SEA questions 3.c8 “SEA and/or LEA Hiring and Retention of Specific Positions with ESF I-SEA, ESF II-SEA, and/or ARP-OA SEA Funds” and 4.c1 “Access to select staff" were optional for the Fiscal Year 2021 and 2022 Annual Performance Reports. Discretion should be used when utilizing these data as grantees were not required to provide responses for these questions. |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing