To understand how the UNOCHA Financial Tracking Service is working, you can wathc this intro video
OCHA has looked at building interoperrability with IATI through a pilot project in 2019/2020, resulting in Lessons from connecting IATI And FTS and the following report: Improving humanitarian transparency with the International Aid Transparency Initiative (IATI)and the UN OCHA Financial Tracking Service (FTS)
First we can pull data from the API with the get_FTS function:
ftsflow2020 <- get_FTS(url = "https://api.hpc.tools",
ext = "/v1/public/fts/flow?",
boundary = "year=2019",
limit = "&limit=1000")
#> successful API Query
ftsflow2019 <- get_FTS(url = "https://api.hpc.tools",
ext = "/v1/public/fts/flow?",
boundary = "year=2020",
limit = "&limit=1000")
#> successful API QueryLet’s look at the structure of the output
names(ftsflow2020)
#> [1] "flowCount" "fundingTotal" "pledgeTotal"and the content:
| flowCount | fundingTotal | pledgeTotal | |
|---|---|---|---|
| init | 13132 | 24805095396 | 33087222 |
| X | 1553 | 2344607387 | 7127329 |
| X.1 | 3451 | 3451 | 3451 |
| X.2 | 124682 , 6988564 , 2014 , financial , 2019-06-22T04:25:33.583Z , 2014-10-02T00:00:00Z , 2014-10-02T00:00:00Z , Food security (2014.0972.1) , earmarked , 0.787 , 2014-10-03T00:00:00Z , Parked , Food , Multiyear , TRUE , 5500000 , EUR , Traditional aid , commitment , 2019-06-24T08:24:25.205Z , 2 , Organization , 4306 , Germany, Government of , single , Government , National government , Location , 83 , Germany , single , UsageYear , 34 , 2014 , single , Organization , 2987 , Deutsche Gesellschaft für Internationale Zusammenarbeit, single , Private organization/foundation , International organization/foundation/individual , GlobalCluster , 6 , Food Security , single , Location , 38 , Cambodia , single , UsageYear , 34 , 2014 , shared , UsageYear , 37 , 2015 , shared , UsageYear , 36 , 2016 , shared , UsageYear , 38 , 2017 , shared , UsageYear , 39 , 2018 , shared , UsageYear , 40 , 2019 , shared , UsageYear , 41 , 2020 , shared , incoming , shared , Primary , Germany, Government of , From EDRIS , 2019-06-21T00:00:00.000Z , 2014.0972.1 | 127925 , 10254605 , 2015 , financial , 2019-06-22T04:25:34.256Z , 2015-04-15T00:00:00Z , 2015-04-15T00:00:00Z , (Shan State) The aim of the plan is to improve the food situation of farmers population in Shan State. The plan concentrates his activities upon mountain villages and communities close to the border in the Shan State in which many households straightened on subsistence agriculture are food-threatened. (2015.1800.0), earmarked , 0.923 , 2015-04-25T00:00:00Z , Parked , Multiyear , TRUE , 9465000 , EUR , Traditional aid , commitment , 2019-06-24T08:23:36.527Z , 5 , Organization , 4306 , Germany, Government of , single , Government , National government , Location , 83 , Germany , single , UsageYear , 37 , 2015 , single , Organization , 2987 , Deutsche Gesellschaft für Internationale Zusammenarbeit , single , Private organization/foundation , International organization/foundation/individual , GlobalCluster , 26480 , Coordination and support services , shared , GlobalCluster , 4 , Emergency Shelter and NFI , shared , GlobalCluster , 8 , Logistics , shared , Location , 153 , Myanmar , single , UsageYear , 42 , 2021 , shared , UsageYear , 41 , 2020 , shared , UsageYear , 40 , 2019 , shared , UsageYear , 39 , 2018 , shared , UsageYear , 38 , 2017 , shared , UsageYear , 36 , 2016 , shared , UsageYear , 37 , 2015 , shared , incoming , shared , Primary , Germany, Government of , From EDRIS , 2019-06-21T00:00:00.000Z , 2015.1800.0 | 131935 , 0 , 2015 , 161967 , 161968 , 161969 , 161970 , 166684 , 166688 , 166689 , 166710 , 167995 , 177874 , 184731 , 184732 , 198023 , financial , 2017-12-07T04:25:16.166Z , 2015-07-23T00:00:00Z , 2015-07-23T00:00:00Z , Multi-year basic relief (NFIs and fuel vouchers) for vulnerable IDPs who have fled acute violence in Iraq Financial year 2015: 1.000.000,00 € 2016: 3.000.000,00 € 2017: 5.000.000,00€ 2018: 2.000.000,00€ Top up financial year 2017: 4.000.000,00 € 2018: 1.000.000,00 € 2019: 2.000.000,00 € 2018: 500.000,00€ 2019: 1.500.000,00 € (AA-S05-321.50 IRQ 13/15), earmarked , 0.905 , 2015-07-25T00:00:00Z , Parked , Multiyear , TRUE , 0 , EUR , Traditional aid , commitment , 2019-09-19T23:22:37.082Z , 4 , Organization , 4306 , Germany, Government of , single , Government , National government , Location , 83 , Germany , single , UsageYear , 37 , 2015 , single , Organization , 2986 , International Organization for Migration , single , UN agency , Location , 106 , Iraq , single , UsageYear , 37 , 2015 , shared , UsageYear , 38 , 2017 , shared , UsageYear , 40 , 2019 , shared , UsageYear , 39 , 2018 , shared , UsageYear , 36 , 2016 , shared , incoming , shared , Primary , Deutsche Gesellschaft für Internationale Zusammenarbeit , From EDRIS , 2017-12-13T00:00:00.000Z , Primary , Germany, Government of , From EDRIS , 2019-01-31T00:00:00.000Z , AA-S05-321.50 IRQ 13/15 |