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 sectors for locations #2765

Closed sylvanr closed 1 year ago

sylvanr commented 2 years ago

https://fcdo.iati.cloud/api/budgets/aggregations/?reporting_organisation_identifier=GB-GOV-1,GB-1&order_by=recipient_country&group_by=sector,recipient_country&aggregations=value&format=json&budget_period_start=2021-04-01&budget_period_end=2022-03-31

https://fcdo.iati.cloud/search/budget?q=reporting_org_ref:(GB-GOV-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":"recipient_country_code","limit":-1,"sort":"value asc","facet":{"value":"sum(budget_value)","name":{"type":"terms","field":"recipient_country_name","limit":1},"sectors":{"type":"terms","field":"sector_code","limit":-1,"facet":{"value":"sum(budget_value)"}},"region":{"type":"terms","field":"recipient_region_code","limit":1}}}}&rows=0