API Aid

Parameters

See Parameter Quick Guide

Available API Calls

/sector/:sector

Returns an array of aggregated aid data for all of the desired sector.

/receiver

Aid data aggregated by receivers

/year

Aid data aggregated by year.

/origin/organization

Aid data aggregated by origin organization.

/receiver/organization

Aid data aggregated by receiving organization.

/project

Aid data projects filtered to parameters.

/project/:projectId

Returns details of a particular project.

/stats

Summary stats for given parameters.

 

aid/sector/:sector

Returns an array of aggregated aid data for all of the desired sector.

:sector -
3: Sector codes 3 digits long, highest level
5: Sector codes 5 digits long, mid level

Example

http://api.aiddata.org/aid/sector/3

{
  project_count: 1439253,
  term_count: 44,
  stats: {
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  items: [
    {
      term: "311",
      count: 144838,
      total_count: 144286,
      min: -162134172.09,
      max: 3093077609965.7334,
      total: 7095244551832.702,
      mean: 49174864.86445464,
      source: {
        _id: "526a71fd4c817be30545ecca",
        id: 126,
        code: "311",
        name: "Agriculture"
      }
    }
  ]
}

aid/receiver

Aid data aggregated by receivers

Parameters
  See Parameter Quick Guide

Example

http://api.aiddata.org/aid/receiver

{
  project_count: 1439253,
  term_count: 234,
  stats: {
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  items: [
    {
      term: 110593438,
      count: 6717,
      total_count: 6713,
      min: -398915.88,
      max: 3093077609965.7334,
      total: 4060730312719.5347,
      mean: 604905454.002612,
      item: {
        id: 110593438,
        name: "Central African Republic",
        iso3: "CAF"
      }
    }
  ]
}

aid/year

Aid data aggregated by year.

Parameters
  See Parameter Quick Guide

Example

http://api.aiddata.org/aid/year

{
  project_count: 1439253,
  term_count: 71,
  stats: {
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  items: [
    {
      term: 1986,
      count: 8142,
      total_count: 8096,
      min: 0,
      max: 3093077609965.7334,
      total: 4115928087961.707,
      mean: 508390327.07036895,
      source: 1986
    }
  ]
}

aid/origin/organization

Aid data aggregated by origin organization.

Parameters
  See Parameter Quick Guide

Example

http://api.aiddata.org/aid/origin/organization

{
  project_count: 1439253,
  term_count: 86,
  stats: {
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  items: [
    {
      term: 60,
      count: 1010,
      total_count: 954,
      min: 826035.9875952776,
      max: 3093077609965.7334,
      total: 7612372292937.221,
      mean: 7979425883.581992,
      item: {
        id: 60,
        name: "Saudi Arabia",
        iso3: "SAU"
      }
    }
  ]
}

aid/receiver/organization

Aid data aggregated by receiving organization.

Parameters
  See Parameter Quick Guide

Example

http://api.aiddata.org/aid/receiver/organization

{
  project_count: 1439253,
  term_count: 234,
  stats: {
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  items: [
    {
      term: 110593438,
      count: 6717,
      total_count: 6713,
      min: -398915.88,
      max: 3093077609965.7334,
      total: 4060730312719.5347,
      mean: 604905454.002612,
      item: {
        id: 110593438,
        name: "Central African Republic",
        iso3: "CAF"
      }
    }
  ]
}

aid/project

Aid data projects filtered to parameters.

Parameters
  See Parameter Quick Guide

Example

http://api.aiddata.org/aid/project

{
  project_count: 1439253,
  stats: {
    _type: "statistical",
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  items: [
    {
      project_id: 1,
      title: "Line of Credit to Ecobank Transnational Incorporated (ETI)",
      long_description: "Provide financial resources to ETI for medium-to-long term project finance and to finance capital equipment, including permanent working capital required to create new production capacities and increase the capacity utilization of existing facilities.",
      sector3: {
        _id: 111,
        name: "BANKING AND FINANCIAL SERVICES",
        code: "240"
      },
      sector5: {
        _id: 116,
        name: "Formal sector financial intermediaries",
        code: "24030"
      },
      sector7: [
        {
          _id: 287,
          name: "All formal sector financial intermediaries",
          code: "24030.02"
        },
        {
          _id: 288,
          name: "Credit lines",
          code: "24030.03"
        }
      ],
      transactions: [
        {
          tr_funding_region: {
            _id: 120834146,
            name: "Multilaterals",
            type_name: "UNKNOWN",
            type_id: 3250263
          },
          tr_currency_name: "UA (AFDB)",
          tr_flow_type_name: "a_ no value",
          tr_type_id: 1,
          tr_flow_type_id: 6,
          tr_receiver_country: {
            _id: 110593755,
            name: "Togo",
            type_name: "UNKNOWN",
            iso3: "TGO",
            parentAgencyId: 110593687,
            iso2: "TG",
            oecdCode: 283,
            type_id: 3250263
          },
          tr_type_name: "Commitment Loan / Grant Amount",
          tr_date: "2003-01-01T05:00:00.000Z",
          tr_funding_org: {
            _id: 112064756,
            name: "AFDB Group",
            type_name: "UNKNOWN",
            parentAgencyId: 120834146,
            type_id: 3250263
          },
          tr_constant_value: 29589911.449629888,
          tr_sector5: {
            _id: 116,
            name: "Formal sector financial intermediaries",
            code: "24030"
          },
          tr_receiver_region: {
            _id: 110593687,
            name: "Africa, South of Sahara",
            type_name: "UNKNOWN",
            iso3: "",
            iso2: "",
            oecdCode: 289,
            type_id: 3250263
          },
          tr_deflator_value: 73.11858,
          tr_sector3: {
            _id: 111,
            name: "BANKING AND FINANCIAL SERVICES",
            code: "240"
          },
          tr_currency_type_id: 6,
          tr_id: 136345059,
          tr_year: 2003,
          tr_provider: {
            _id: 1,
            name: "African Development Bank (AFDB)",
            parentAgencyId: 112064756,
            oecdCode: 913
          },
          tr_value: 14560000,
          tr_nominal_value: 21635723.075226787
        },
        {
          tr_funding_region: {
            _id: 120834146,
            name: "Multilaterals",
            type_name: "UNKNOWN",
            type_id: 3250263
          },
          tr_currency_name: "USD",
          tr_flow_type_name: "a_ no value",
          tr_type_id: 3,
          tr_flow_type_id: 6,
          tr_receiver_country: {
            _id: 110593755,
            name: "Togo",
            type_name: "UNKNOWN",
            iso3: "TGO",
            parentAgencyId: 110593687,
            iso2: "TG",
            oecdCode: 283,
            type_id: 3250263
          },
          tr_type_name: "Amount Usd Constant",
          tr_date: "2003-01-01T05:00:00.000Z",
          tr_funding_org: {
            _id: 112064756,
            name: "AFDB Group",
            type_name: "UNKNOWN",
            parentAgencyId: 120834146,
            type_id: 3250263
          },
          tr_constant_value: 0,
          tr_sector5: {
            _id: 116,
            name: "Formal sector financial intermediaries",
            code: "24030"
          },
          tr_receiver_region: {
            _id: 110593687,
            name: "Africa, South of Sahara",
            type_name: "UNKNOWN",
            iso3: "",
            iso2: "",
            oecdCode: 289,
            type_id: 3250263
          },
          tr_deflator_value: 73.11858,
          tr_sector3: {
            _id: 111,
            name: "BANKING AND FINANCIAL SERVICES",
            code: "240"
          },
          tr_currency_type_id: 2,
          tr_id: 136345061,
          tr_year: 2003,
          tr_provider: {
            _id: 1,
            name: "African Development Bank (AFDB)",
            parentAgencyId: 112064756,
            oecdCode: 913
          },
          tr_value: 0,
          tr_nominal_value: 0
        },
        {
          tr_funding_region: {
            _id: 120834146,
            name: "Multilaterals",
            type_name: "UNKNOWN",
            type_id: 3250263
          },
          tr_currency_name: "USD",
          tr_flow_type_name: "a_ no value",
          tr_type_id: 4,
          tr_flow_type_id: 6,
          tr_receiver_country: {
            _id: 110593755,
            name: "Togo",
            type_name: "UNKNOWN",
            iso3: "TGO",
            parentAgencyId: 110593687,
            iso2: "TG",
            oecdCode: 283,
            type_id: 3250263
          },
          tr_type_name: "Disbursement Amount",
          tr_date: "2003-01-01T05:00:00.000Z",
          tr_funding_org: {
            _id: 112064756,
            name: "AFDB Group",
            type_name: "UNKNOWN",
            parentAgencyId: 120834146,
            type_id: 3250263
          },
          tr_constant_value: 0,
          tr_sector5: {
            _id: 116,
            name: "Formal sector financial intermediaries",
            code: "24030"
          },
          tr_receiver_region: {
            _id: 110593687,
            name: "Africa, South of Sahara",
            type_name: "UNKNOWN",
            iso3: "",
            iso2: "",
            oecdCode: 289,
            type_id: 3250263
          },
          tr_deflator_value: 73.11858,
          tr_sector3: {
            _id: 111,
            name: "BANKING AND FINANCIAL SERVICES",
            code: "240"
          },
          tr_currency_type_id: 2,
          tr_id: 136345062,
          tr_year: 2003,
          tr_provider: {
            _id: 1,
            name: "African Development Bank (AFDB)",
            parentAgencyId: 112064756,
            oecdCode: 913
          },
          tr_value: 0,
          tr_nominal_value: 0
        }
      ],
      organisations: [
        {
          org_name: "African Development Bank (AFDB)",
          org_id: 1,
          org_role_name: "Funding",
          org_role_id: 3
        }
      ],
      source: {
        _id: 1,
        label: "Annual Report",
        key: "annual-report"
      }
    }
  ]
}

aid/project/:projectId

Returns details of a particular project.

Parameters
:projectId - id of desired project
See Parameter Quick Guide

Example

http://api.aiddata.org/aid/project/42

{
  _id: "5269fd92e4b0c74e42976cb9",
  _class: "org.aiddata.replication.mongo.model.AidDataProject",
  project_id: 42,
  sector3: {
    _id: 46,
    name: "WATER SUPPLY AND SANITATION",
    code: "140"
  },
  sector5: {
    _id: 50,
    name: "Water resources protection",
    code: "14015"
  },
  sector7: [
    {
      _id: 127,
      name: "Water conservation",
      code: "14015.03"
    },
    {
      _id: 132,
      name: "Intakes, storage, pumping stations, conveyance and distribution systems",
      code: "14020.04"
    },
    {
      _id: 137,
      name: "Small system sewerage",
      code: "14030.03"
    },
    {
      _id: 140,
      name: "River flow control",
      code: "14040.03"
    }
  ],
  title: "Douala New Bell District Rainwater Drainage Project",
  source: {
    _id: 1,
    key: "annual-report",
    label: "Annual Report"
  },
  long_description: "The project aims at improving health conditions in the district by: (i) eliminating floods which affect 55 ha of the 360 ha project area; (ii) lowering the ground-water table, the present level of which, near the surface, is a source of contamination of spring water; and (iii) providing drinking water and public toilet facilities. The project will also make it possible to equip the Douala Urban Community (CUD) Sanitation Service to improve the functioning and maintenance of the project installation. Finally, the strengthening of the revenue collection office of the municipality will enable the CUD to improve the recovery of taxes and, consequently, its own finances. The ADB loan will finance 100 per cent of the foreign exchange costs and 34.2 per cent of the local currency costs of the project. ",
  active: true,
  date_created: "2008-08-04T12:55:00.000Z",
  md5: "18f3c765967b0e3bd52c9885305900eb",
  transactions: [
    {
      tr_id: 136219734,
      tr_type_id: 1,
      tr_type_name: "Commitment Loan / Grant Amount",
      tr_currency_type_id: 6,
      tr_currency_name: "UA (AFDB)",
      tr_value: 32300000,
      tr_constant_value: 66467349.424649976,
      tr_nominal_value: 44412499.833453126,
      tr_deflator_value: 66.818521,
      tr_date: "1992-01-01T05:00:00.000Z",
      tr_year: 1992,
      tr_flow_type_id: 6,
      tr_flow_type_name: "a_ no value",
      tr_funding_region: {
        _id: 120834146,
        name: "Multilaterals",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_funding_org: {
        _id: 112064756,
        name: "AFDB Group",
        parentAgencyId: 120834146,
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_provider: {
        _id: 1,
        name: "African Development Bank (AFDB)",
        oecdCode: 913,
        parentAgencyId: 112064756
      },
      tr_receiver_region: {
        _id: 110593687,
        name: "Africa, South of Sahara",
        oecdCode: 289,
        iso2: "",
        iso3: "",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_receiver_country: {
        _id: 110593629,
        name: "Cameroon",
        oecdCode: 229,
        parentAgencyId: 110593687,
        iso2: "CM",
        iso3: "CMR",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_sector3: {
        _id: 46,
        name: "WATER SUPPLY AND SANITATION",
        code: "140"
      },
      tr_sector5: {
        _id: 50,
        name: "Water resources protection",
        code: "14015"
      }
    },
    {
      tr_id: 136219736,
      tr_type_id: 3,
      tr_type_name: "Amount Usd Constant",
      tr_currency_type_id: 2,
      tr_currency_name: "USD",
      tr_value: 0,
      tr_constant_value: 0,
      tr_nominal_value: 0,
      tr_deflator_value: 66.818521,
      tr_date: "1992-01-01T05:00:00.000Z",
      tr_year: 1992,
      tr_flow_type_id: 6,
      tr_flow_type_name: "a_ no value",
      tr_funding_region: {
        _id: 120834146,
        name: "Multilaterals",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_funding_org: {
        _id: 112064756,
        name: "AFDB Group",
        parentAgencyId: 120834146,
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_provider: {
        _id: 1,
        name: "African Development Bank (AFDB)",
        oecdCode: 913,
        parentAgencyId: 112064756
      },
      tr_receiver_region: {
        _id: 110593687,
        name: "Africa, South of Sahara",
        oecdCode: 289,
        iso2: "",
        iso3: "",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_receiver_country: {
        _id: 110593629,
        name: "Cameroon",
        oecdCode: 229,
        parentAgencyId: 110593687,
        iso2: "CM",
        iso3: "CMR",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_sector3: {
        _id: 46,
        name: "WATER SUPPLY AND SANITATION",
        code: "140"
      },
      tr_sector5: {
        _id: 50,
        name: "Water resources protection",
        code: "14015"
      }
    },
    {
      tr_id: 136219737,
      tr_type_id: 4,
      tr_type_name: "Disbursement Amount",
      tr_currency_type_id: 2,
      tr_currency_name: "USD",
      tr_value: 0,
      tr_constant_value: 0,
      tr_nominal_value: 0,
      tr_deflator_value: 66.818521,
      tr_date: "1992-01-01T05:00:00.000Z",
      tr_year: 1992,
      tr_flow_type_id: 6,
      tr_flow_type_name: "a_ no value",
      tr_funding_region: {
        _id: 120834146,
        name: "Multilaterals",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_funding_org: {
        _id: 112064756,
        name: "AFDB Group",
        parentAgencyId: 120834146,
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_provider: {
        _id: 1,
        name: "African Development Bank (AFDB)",
        oecdCode: 913,
        parentAgencyId: 112064756
      },
      tr_receiver_region: {
        _id: 110593687,
        name: "Africa, South of Sahara",
        oecdCode: 289,
        iso2: "",
        iso3: "",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_receiver_country: {
        _id: 110593629,
        name: "Cameroon",
        oecdCode: 229,
        parentAgencyId: 110593687,
        iso2: "CM",
        iso3: "CMR",
        type_id: 3250263,
        type_name: "UNKNOWN"
      },
      tr_sector3: {
        _id: 46,
        name: "WATER SUPPLY AND SANITATION",
        code: "140"
      },
      tr_sector5: {
        _id: 50,
        name: "Water resources protection",
        code: "14015"
      }
    }
  ],
  organisations: [
    {
      org_id: 1,
      org_name: "African Development Bank (AFDB)",
      org_role_id: 3,
      org_role_name: "Funding"
    }
  ],
  total_project_cost: {
    currency_type_id: 6,
    currency_name: "UA (AFDB)",
    value: 39800000,
    constant_value: 81900944.49229315,
    nominal_value: 54724999.794781245,
    deflator_value: 66.818521
  }
}

aid/stats

Summary stats for given parameters.

Parameters
  See Parameter Quick Guide

Example

http://api.aiddata.org/aid/stats

{
  type: "stats",
  project_count: 1439253,
  stats: {
    _type: "statistical",
    count: 2489601,
    total: 17733476190335.555,
    min: -6997000000,
    max: 3093077609965.7334,
    mean: 7123019.387578795,
    sum_of_squares: 1.4157241661913592e+25,
    variance: 5686499702570364000,
    std_deviation: 2384638274.9948397
  },
  stats_year: {
    min: 1947,
    max: 2016
  }
}