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
GEER — data notes
Sample of 25 rows out of about 64
· 10 columns
| row_id | reporting_year | row_no | leaid | state_s_____outlying_area_s | reporting_level_s | worksheet_s | variable_s | business_rule | data_note |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2023 | 1 | No data | All | Prime | prime | geerFiscalEndMonth, geerFiscalEndDay | No data | These values were pre-populated for grantees based on information submitted in the 2021 Annual Performance Report. |
| 2 | 2023 | 2 | No data | All | Subgrantee | geer1lea, geer1ihe, geer1other, geer2lea, geer2ihe, geer2other | 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 State that requested the temporary UEI). Example: OCAXXXXXX001. Note, some entities also created their own synthetic UEIs to enable submission of the APR, and these synthetic UEIs may or may not follow the same syntax described above. |
| 3 | 2023 | 3 | No data | All | Subgrantee | geer1lea, geer1ihe, geer1other, geer2lea, geer2ihe, geer2other | 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. Note, some entities also created their own synthetic DUNS numbers to enable submission of the APR, and these synthetic DUNS numbers may or may not follow the same syntax described above. |
| 4 | 2023 | 4 | No data | All | Prime | prime | geer1GrantAmountAllocated, geer2GrantAmountAllocated | No data | These amounts were automatically filled for grantees from the Department's grant management system, G5, as of 9/30/23. |
| 5 | 2023 | 5 | No data | All | Prime, Subgrantee | prime, geer1lea, geer1ihe, geer1other, geer2lea, geer2ihe, geer2other | 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 | prime, geer1lea, geer1ihe, geer1other, geer2lea, geer2ihe, geer2other | geer1GrantAmountRemaining, geer2GrantAmountRemaining, geer1AmountRemaining, geer2AmountRemaining, geer1FundsExpendedTotal22, geer1StudentsAssistedTotal22, geer2FundsExpendedTotal22, geer2StudentsAssistedTotal22, geer1FundsExpendedTotal23, geer1StudentsAssistedTotal23, geer2FundsExpendedTotal23, geer2StudentsAssistedTotal23 | No data | These variables are derived from data entered by the grantees or subgrantees. See the GEER Data Dictionary of the GEER Supporting Documentation file for further detail on each variable's calculation. |
| 7 | 2023 | 7 | No data | AZ, ID, IA, MI, NC, PA, VT | Prime | prime | geer1GrantAmountExpendedPrior, geer1GrantAmountExpendedPrior [2022], geer1GrantAmountExpendedCurrent [2022] | GEER-273 | The total amount of the GEER I grant reported as expended by the Governor and all State subrecipients in prior reporting periods does not match the amount reported in the previous annual performance report. |
| 8 | 2023 | 8 | No data | DC, IA, MI, NC | Prime | prime | geer2GrantAmountExpendedPrior, geer2GrantAmountExpendedPrior [2022], geer2GrantAmountExpendedCurrent [2022] | GEER-275 | The total amount of the GEER II grant reported as expended by the Governor and all State subrecipients in prior reporting periods does not match the amount reported in the previous annual performance report. |
| 9 | 2023 | 9 | No data | ID, IL, IN, NV | Prime | prime | geer1GovernorAmountExpendedAdminPrior [2021], geer1GovernorAmountExpendedNonAdminPrior [2021], geer1GovernorAmountExpendedAdminCurrent [2021], geer1GovernorAmountExpendedNonAdminCurrent [2021], geer1GovernorAmountExpendedAdminCurrent [2022], geer1GovernorAmountExpendedNonAdminCurrent [2022], geer1GovernorAmountExpendedAdminCurrent, geer1GovernorAmountExpendedNonAdminCurrent, geer1TotalAmountAwarded [lea], geer1TotalAmountAwarded [ihe], geer1TotalAmountAwarded [other], geer1GrantAmountAllocated | No data | The sum of GEER I subawards to LEAs, IHEs, and other education-related entities and direct expenditures by the State/Outlying Area (across reporting periods) exceeds the amount of GEER I grant funds allocated to the State/Outlying Area. For IL, this difference is less than 1% of the total GEER I grant awarded to the State/Outlying Area. For ID and NV, this difference is 2.3% of the total GEER I grant awarded to the State. For IN, this difference is 3.8% of the total GEER I grant awarded to the State. |
| 10 | 2023 | 10 | No data | OR | Prime | prime | geer2GovernorAmountExpendedAdminCurrent [2021], geer2GovernorAmountExpendedNonAdminCurrent [2021], geer2GovernorAmountExpendedAdminCurrent [2022], geer2GovernorAmountExpendedNonAdminCurrent [2022], geer2GovernorAmountExpendedAdminCurrent, geer2GovernorAmountExpendedNonAdminCurrent, geer2TotalAmountAwarded [lea], geer2TotalAmountAwarded [ihe], geer2TotalAmountAwarded [other], geer2GrantAmountAllocated | No data | The sum of GEER II subawards to LEAs, IHEs, and other education-related entities and direct expenditures by the State/Outlying Area (across reporting periods) exceeds the amount of GEER II grant funds allocated to the State/Outlying Area. For OR, this difference is less than 1% of the total GEER I grant awarded to the State/Outlying Area. |
| 11 | 2023 | 11 | No data | AR, FL, MD, MI, MN, MS, NY, OR, PA, SD, VA | Subgrantee | geer1lea | geer1AmountExpendedCurrent, geer1UsedEdTech, geer1UsedTargetedStudents, geer1UsedMentalHealth, geer1UsedSanitization, geer1UsedExtendedLearning, geer1UsedOther | No data | These grantees reported LEAs that did not expend GEER I funds during the current reporting period (geer1AmountExpendedCurrent = $0), but reported that they used GEER I funds during the current reporting period for one or more purposes (one or more uses of GEER I funds = TRUE). |
| 12 | 2023 | 12 | No data | AR, CT, KY, LA, ME, MD, MN, MS, MT, NV, NJ, OH, OK, PA, SD, VA, MP, VI | Subgrantee | geer1ihe | geer1AmountExpendedCurrent, geer1ServedPreK, geer1ServedK12, geer1ServedPostSecondary, geer1UsedFinancialAid, geer1UsedDistanceLearning, geer1UsedSchoolReopening, geer1UsedMentalHealth, geer1UsedBasicNeeds, geer1UsedCovidTests, geer1UsedMaintainStaff, geer1UsedOther | No data | These grantees reported IHEs that did not expend GEER I funds during the current reporting period (geer1AmountExpendedCurrent = $0), but reported that they used GEER I funds during the current reporting period for one or more purposes (one or more uses of GEER I funds = TRUE) and/or to serve one or more populations (one or more populations served by GEER I funds = TRUE). |
| 13 | 2023 | 13 | No data | AR, CT, DC, FL, GA, HI, ME, MD, MA, MI, MS, MT, NV, NJ, NM, OH, OR, PA, SC, SD, TN, VA, VI | Subgrantee | geer1other | geer1AmountExpendedCurrent, geer1ServedPreK, geer1ServedK12, geer1ServedPostSecondary, geer1UsedFinancialAid, geer1UsedDistanceLearning, geer1UsedSchoolReopening, geer1UsedLostTime, geer1UsedMentalHealth, geer1UsedOther | No data | These grantees reported other education-related entities that did not expend GEER I funds during the current reporting period (geer1AmountExpendedCurrent = $0), but reported that they used GEER I funds during the current reporting period for one or more purposes (one or more uses of GEER I funds = TRUE) and/or to serve one or more populations (one or more populations served by GEER I funds = TRUE). |
| 14 | 2023 | 14 | No data | AR, CA, MD, MI, NY, PA, UT, VA | Subgrantee | geer2lea | geer2AmountExpendedCurrent, geer2UsedEdTech, geer2UsedTargetedStudents, geer2UsedMentalHealth, geer2UsedSanitization, geer2UsedExtendedLearning, geer2UsedOther | No data | These grantees reported LEAs that did not expend GEER II funds during the current reporting period (geer2AmountExpendedCurrent = $0), but reported that they used GEER II funds during the current reporting period for one or more purposes (one or more uses of GEER II funds = TRUE). |
| 15 | 2023 | 15 | No data | AR, GA, KS, KY, LA, ME, MD, MS, MO, OR, PA, SD, TN, GU | Subgrantee | geer2ihe | geer2AmountExpendedCurrent, geer2ServedPreK, geer2ServedK12, geer2ServedPostSecondary, geer2UsedFinancialAid, geer2UsedDistanceLearning, geer2UsedSchoolReopening, geer2UsedMentalHealth, geer2UsedBasicNeeds, geer2UsedCovidTests, geer2UsedMaintainStaff, geer2UsedOther | No data | These grantees reported IHEs that did not expend GEER II funds during the current reporting period (geer2AmountExpendedCurrent = $0), but reported that they used GEER II funds during the current reporting period for one or more purposes (one or more uses of GEER II funds = TRUE) and/or to serve one or more populations (one or more populations served by GEER II funds = TRUE). |
| 16 | 2023 | 16 | No data | AR, DC, MD, MA, MI, MT, NC, OK, PA, SD, TN, GU, VI | Subgrantee | geer2other | geer2AmountExpendedCurrent, geer2ServedPreK, geer2ServedK12, geer2ServedPostSecondary, geer2UsedFinancialAid, geer2UsedDistanceLearning, geer2UsedSchoolReopening, geer2UsedLostTime, geer2UsedMentalHealth, geer2UsedOther | No data | These grantees reported other education-related entities that did not expend GEER II funds during the current reporting period (geer2AmountExpendedCurrent = $0), but reported that they used GEER II funds during the current reporting period for one or more purposes (one or more uses of GEER II funds = TRUE) and/or to serve one or more populations (one or more populations served by GEER II funds = TRUE). |
| 17 | 2023 | 17 | No data | PA | Subgrantee | geer2lea | geer2UsedFundsInternet, geer2UsedFundsMobileHotspots geer2UsedFundsDataPlans geer2UsedFundsHomeInternet geer2UsedFundsDistrictInternet geer2UsedFundsInternetOther | No data | This grantee reported LEAs that provided home internet services (geer2UsedFundsInternet = TRUE), but reported that no types of internet service were provided (all internet types = FALSE). |
| 18 | 2023 | 18 | No data | KY, LA, MS, NJ, OK, VA | Subgrantee | geer1ihe | geer1AmountExpendedCurrent, geer1NumberStudentsFinancialAidGrants | No data | These grantees reported IHEs that did not expend GEER I funds during the current reporting period (geer1AmountExpendedCurrent = $0), but reported counts of students that received financial aid grants during the current reporting period. |
| 19 | 2023 | 19 | No data | CT, MI, MS, OH, SC, VI | Subgrantee | geer1other | geer1AmountExpendedCurrent, geer1NumberStudentsFinancialAidGrants | No data | These grantees reported other education-related entities that did not expend GEER I funds during the current reporting period (geer1AmountExpendedCurrent = $0), but reported counts of students that received financial aid grants during the current reporting period. |
| 20 | 2023 | 20 | No data | MS | Subgrantee | geer2ihe | geer2AmountExpendedCurrent, geer2NumberStudentsFinancialAidGrants | No data | This grantee reported an IHE that did not expend GEER II funds during the current reporting period (geer2AmountExpendedCurrent = $0), but reported counts of students that received financial aid grants during the current reporting period. |
| 21 | 2023 | 21 | No data | GU | Subgrantee | geer2other | geer2AmountExpendedCurrent, geer2NumberStudentsFinancialAidGrants | No data | This grantee reported an other education-related entity that did not expend GEER II funds during the current reporting period (geer2AmountExpendedCurrent = $0), but reported counts of students that received financial aid grants during the current reporting period. |
| 22 | 2023 | 22 | No data | GA, ID, ME, NH, TN | Prime, Subgrantee | prime, geer1lea, geer1ihe, geer1other | geer1GovernorAmountExpendedAdminPrior [2021], geer1GovernorAmountExpendedNonAdminPrior [2021], geer1GovernorAmountExpendedAdminCurrent [2021], geer1GovernorAmountExpendedNonAdminCurrent [2021], geer1GovernorAmountExpendedAdminCurrent [2022], geer1GovernorAmountExpendedNonAdminCurrent [2022], geer1AmountExpendedPrior [lea], geer1AmountExpendedPrior [ihe], geer1AmountExpendedPrior [other], geer1GrantAmountExpendedPrior | No data | For these grantees, the total prior year expenditures (of GEER I funds) as reported at the prime grantee level, in geer1GrantAmountExpendedPrior, does not match the total prior year expenditures as reported at the more granular level across APRs (geer1GovernorAmountExpendedAdminPrior [2021], representing direct expenditures for admin purposes in the 2020 reporting period as reported in the 2021 APR + geer1GovernorAmountExpendedNonAdminPrior [2021], representing direct expenditures for non-admin purposes in the 2020 reporting period as reported in the 2021 APR + geer1GovernorAmountExpendedAdminCurrent [2021], representing direct expenditures for admin purposes in the 2021 reporting period as reported in the 2021 APR + geer1GovernorAmountExpendedNonAdminCurrent [2021], representing direct expenditures for non-admin purposes in the 2021 reporting period as reported in the 2021 APR + geer1GovernorAmountExpendedAdminCurrent [2022], representing direct expenditures for admin purposes in the 2022 reporting period as reported in the 2022 APR + geer1GovernorAmountExpendedNonAdminCurrent [2022], representing direct expenditures for non-admin purposes in the 2022 reporting period as reported in the 2022 APR + geer1AmountExpendedPrior [by LEAs, IHEs, and other education-related entities]). For GA, this difference is less than 1% of the total GEER I grant awarded to the State/Outlying Area. For TN, ID, ME, and NH, this difference is 1.4%, 2.3%, 4.4%, and 4.6% of their total GEER I grant awards, respectively. |
| 23 | 2023 | 23 | No data | ME, NV, NH, NC, GU, VI | Prime, Subgrantee | prime, geer2lea, geer2ihe, geer2other | geer2GovernorAmountExpendedAdminCurrent [2021], geer2GovernorAmountExpendedNonAdminCurrent [2021], geer2GovernorAmountExpendedAdminCurrent [2022], geer2GovernorAmountExpendedNonAdminCurrent [2022], geer2AmountExpendedPrior [lea], geer2AmountExpendedPrior [ihe], geer2AmountExpendedPrior [other], geer2GrantAmountExpendedPrior | No data | For these grantees, the total prior year expenditures (of GEER II funds) as reported at the prime grantee level, in geer2GrantAmountExpendedPrior, does not match the total prior year expenditures as reported at the more granular level across APRs (geer2GovernorAmountExpendedAdminCurrent [2021], representing direct expenditures for admin purposes in the 2021 reporting period as reported in the 2021 APR + geer2GovernorAmountExpendedNonAdminCurrent [2021], representing direct expenditures for non-admin purposes in the 2021 reporting period as reported in the 2021 APR + geer2GovernorAmountExpendedAdminCurrent [2022], representing direct expenditures for admin purposes in the 2022 reporting period as reported in the 2022 APR + geer2GovernorAmountExpendedNonAdminCurrent [2022], representing direct expenditures for non-admin purposes in the 2022 reporting period as reported in the 2022 APR + geer2AmountExpendedPrior [by LEAs, IHEs, and other education-related entities]). For ME, NV, NH, and GU, this difference is less than 1% of the total GEER II grant awarded to the State/Outlying Area. For NC and VI, this difference is 3.9% and 14.9% of their total GEER II grant awards, respectively. |
| 24 | 2023 | 24 | No data | VA | Subgrantee | geer1ihe | entityName | GEER-101b | GEER-101b checks that the count of IHEs reported in the 2023 APR is greater than or equal to the count of entities reported in the 2022 APR. VA awarded funds to an institution during FY 2022, but in FY 2023 (September 2022), the institute returned the full amount of the award. In order to submit a full accounting of funds subawarded in FY 2022, Virginia submitted data about this subaward in the FY 2022 APR, but removed it from the FY 2023 APR. This business rule was lifted in order to enable submission of the 2023 APR. |
| 25 | 2023 | 25 | No data | OH | Subgrantee | geer1other | entityName | GEER-101c | GEER-101c checks that the count of other education-related entities reported in the 2023 APR is greater than or equal to the count of entities reported in the 2022 APR. Ohio previously awarded funds to 5 entities that returned the full amount of the awards in FY 2021 or FY 2022, but the state did not remove these entities from the respective APRs aligned with the date of returned funds and instead removed them from the 2023 APR for the first time. This business rule was lifted in order to enable submission of the 2023 APR. |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing