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
308 stars 109 forks source link

[DEV-11422] Updated the query to calculate total_outlays #4179

Closed ayubshahab closed 1 month ago

ayubshahab commented 2 months ago

Description: Update the delta query for summary_state_view to use the file-C records directly and create a temporary view to get the award_ids and their corresponding total_outlays as well as their respective fiscal_years. Then, ultimately, when it comes to aggregating the total_outlays for a respective POP State and POP Country we can aggregate the total_outlays based on a group by for fiscal_year.

Technical details: N/A

Requirements for PR merge:

  1. [x] Unit & integration tests updated
  2. [x] API documentation updated
  3. [x] Necessary PR reviewers:
    • [x] Backend
  4. [x] Appropriate Operations ticket(s) created
  5. [x] Jira Ticket DEV-11422:
    • [x] Link to this Pull-Request

Area for explaining above N/A when needed: