Last active
November 23, 2016 21:03
-
-
Save jueyang/9bd225eb58d4d9524b92 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
// the following is a sample of a donor country | |
{'name': 'core_total', 'value':10000,'donor-country':'JPN'}, // from core-fund.csv, the sum of all core contribution | |
{'name': 'noncore_total', 'value': 50000,'donor-country':'JPN'}, // from fund-modality.csv, the sum of all 5 types of funding | |
{'name': 'cost_sharing', 'value': 10000, 'donor-country':'JPN'}, // from fund-modality.csv, sum of the respective type | |
{'name': 'thematic_trust_funds', 'value': 10000, 'donor-country':'JPN'}, | |
{'name': 'trust_funds', 'value': 10000, 'donor-country':'JPN'}, | |
{'name': 'special_activities', 'value': 10000, 'donor-country':'JPN'}, | |
{'name': 'unv', 'value': 10000, 'donor-country':'JPN'}, | |
... | |
// the following is the total value of the same name/structure for ALL donors | |
{'name': 'core_total', 'value':1000000,'donor-country':'all'}, | |
{'name': 'noncore_total', 'value': 6000000,'donor-country':'all'}, | |
{'name': 'cost_sharing', 'value': 150000, 'donor-country':'all'}, | |
{'name': 'thematic_trust_funds', 'value': 150000, 'donor-country':'all'}, | |
{'name': 'trust_funds', 'value': 150000, 'donor-country':'all'}, | |
{'name': 'special_activities', 'value': 150000,'donor-country':'all'}, | |
{'name': 'unv', 'value': 150000, 'donor-country':'all'} | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
fund_modalities.csv | |
----- | |
key, | |
Fund Rollup Level 3, // used, eg "Trust Fund" | |
Donor, | |
Donor Description, | |
Donor Rollup Level 3, // used, eg "JPN" | |
Donor Rollup Level 3 Descr, | |
Donor Rollup Level 4, | |
Donor Rollup Level 4 Descr, | |
Contribution Revenue // used, eg "100000" | |
core_fund.csv | |
----- | |
Business Unit, | |
Fund Rollup Level 1, | |
Fund Rollup Level 2, // used, only one value "CORE" | |
Donor, | |
Donor Desc, | |
Donor Short Desc, | |
Donor Level 3, // same as the Donor Rollup Level 3 above, eg "JPN" | |
Donor Level 3 Desc, | |
Donor Level 4, | |
Donor Level 4 Desc, | |
CONTRIBUTION REVENUES // used, eg "100000" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment