search

fedspendingtransparency / usaspending-api

Server application to serve U.S. federal spending data via a RESTful API
https://www.usaspending.gov
Creative Commons Zero v1.0 Universal
310 stars 113 forks source link

[DEV-10945] Update the disaster award endpoints to use the covid_faba_spending table #4133

Closed aguest-kc closed 4 months ago

aguest-kc commented 4 months ago

Description: Updates the /api/v2/disaster/award/amount/ and /api/v2/disaster/award/count/ endpoints to use the covid_faba_spending table for their results.

Technical details: A new view was added that groups Covid-19 FABA spending by award and then stores those totals and counts in the covid_faba_spending table. The disaster award endpoints then use these rows for their calculations.

Requirements for PR merge:

  1. [x] Unit & integration tests updated
  2. [x] Necessary PR reviewers:
    • [x] Backend
  3. [x] Data validation completed
  4. [x] Appropriate Operations ticket(s) created
  5. [x] Jira Ticket DEV-10945:
    • [x] Link to this Pull-Request
    • [x] Performance evaluation of affected (API | Script | Download)
    • [x] Before / After data comparison

Area for explaining above N/A when needed:

2. API documentation updated
No API documentation was affected by this change.

4. Matview impact assessment completed
No matviews are affected by this change.

5. Frontend impact assessment completed
The frontend is not impacted by this change.