search

zimmerman-team / IATI.cloud

IATI datastore powered by Apache Solr. Automatically Extracts and parses IATI XML files referenced in the IATI Registry & refreshed every 3 hrs. IATI is a global initiative to improve the transparency of development and humanitarian resources and their results for addressing poverty and crises.
https://datastore.iati.cloud
MIT License
32 stars 28 forks source link

FCDO Review Budget - Sector data #2764

Closed sylvanr closed 1 year ago

sylvanr commented 2 years ago

Refresh of the data and a dive into the sector data processing of the iati.cloud v2.

Alternative solution is to check the data against the Direct Indexing IATI.cloud implementation, perhaps that would remove the need for all these checks.

sylvanr commented 2 years ago

https://fcdo.iati.cloud/api/budgets/aggregations/?reporting_organisation_identifier=GB-GOV-1,GB-1&group_by=sector&aggregations=value&budget_period_start=2021-04-01&budget_period_end=2022-03-31&format=json'
https://fcdo.iati.cloud/search/budget?q=reporting_org_ref:(GB-GOV-1 GB-1) AND budget_period_start_iso_date_f:[2021-04-01T00:00:00Z TO ] AND budget_period_end_iso_date_f:[ TO 2022-03-31T00:00:00Z]&json.facet={"items":{"type":"terms","field":"sector_code","limit":-1,"facet":{"value":"sum(budget_value)"}}}&rows=0