global_affairs_grants
4 rows where countries contains "Vanuatu 9.09%"
This data as json, CSV (advanced)
Suggested facets: policyMarkers, budgets, Locations, dateModified (date), start (date), end (date), countries (array), DACSectors (array), policyMarkers (array), budgets (array), Locations (array), otherIdentifiers (array), participatingOrgs (array), relatedActivities (array), transactions (array)
| id ▼ | projectNumber | dateModified | title | description | status | start | end | countries | executingAgencyPartner | DACSectors | maximumContribution | ContributingOrganization | expectedResults | resultsAchieved | aidType | collaborationType | financeType | flowType | reportingOrganisation | programName | selectionMechanism | policyMarkers | regions | alternameImPositions | budgets | Locations | otherIdentifiers | participatingOrgs | programDataStructure | relatedActivities | transactions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1116 | CA-3-M012902003 | 2025-03-04T06:33:31 | Joint Office for Commonwealth Permanent Missions to the United Nations -2010-11 | This grant represents Canada’s support for the Commonwealth Joint Office for Small States in New York. These states include Dominica, Gambia, Grenada, Maldives, Saint Vincent and the Grenadines, Samoa, Seychelles, Solomon Islands, Tuvalu, and Vanuatu. Canada’s support enables these countries to maintain representation at the United Nations and engage in discussions on development issues and challenges. | Closed | 2009-02-09T00:00:00 | 2011-03-31T00:00:00 | ["Maldives 9.09%", "Nauru 9.09%", "Dominica 9.10%", "Tuvalu 9.09%", "Grenada 9.09%", "Vanuatu 9.09%", "Solomon Islands 9.09%", "Saint Vincent And The Grenadines 9.09%", "Seychelles 9.09%", "Gambia 9.09%", "Samoa 9.09%"] | Joint Office for Commonwealth Permanent Missions to the United Nations | ["Public sector policy and administrative management 100.00%"] | 182516.51 | Contributions to specific-purpose programmes and funds managed by implementing partners | Bilateral | Aid grant excluding debt reorganisation | Global Affairs Canada | IFM International Security | Pre-APP | ["Gender equality", "Environmental sustainability (cross-cutting)", "Participatory development and good governance", "Trade development", "Biodiversity", "Climate change mitigation", "Climate Change Adaptation", "Urban issues", "Desertification", "Children's issues", "Youth Issues", "Indigenous Issues", "Disability", "ICT as a tool for development"] | ["200000.00"] | ["4.1748 73.50888", "-9.43333 159.95", "-8.52425 179.19471", "-17.73381 168.32188", "15.30174 -61.38808", "13.15527 -61.22742", "12.05644 -61.74849", "-13.83333 -171.76666", "-0.55085 166.9252"] | ["2009200456"] | ["Joint Office for Commonwealth Permanent Missions to the United Nations "] | ["CA-3-M012902006", "CA-3-M012902004", "CA-3-M012902005"] | ["182516.51", "176346.93", "6169.58"] | |||||||
| 1117 | CA-3-M012902004 | 2025-03-04T06:33:31 | Joint Office for Commonwealth Permanent Missions to the United Nations - 2011-12 | This grant represents Canada’s support for the Commonwealth Joint Office for Small States in New York. These states include Dominica, Gambia, Grenada, Maldives, Saint Vincent and the Grenadines, Samoa, Seychelles, Solomon Islands, Tuvalu, and Vanuatu. Canada’s support enables these countries to maintain representation at the United Nations and engage in discussions on development issues and challenges. | Closed | 2011-04-01T00:00:00 | 2012-03-31T00:00:00 | ["Dominica 9.10%", "Maldives 9.09%", "Vanuatu 9.09%", "Gambia 9.09%", "Nauru 9.09%", "Grenada 9.09%", "Saint Vincent And The Grenadines 9.09%", "Solomon Islands 9.09%", "Seychelles 9.09%", "Tuvalu 9.09%", "Samoa 9.09%"] | Joint Office for Commonwealth Permanent Missions to the United Nations | ["Public sector policy and administrative management 100.00%"] | 168209.83 | Contributions to specific-purpose programmes and funds managed by implementing partners | Bilateral | Aid grant excluding debt reorganisation | Global Affairs Canada | IFM International Security | Pre-APP | ["Gender equality", "Environmental sustainability (cross-cutting)", "Participatory development and good governance", "Trade development", "Biodiversity", "Climate change mitigation", "Climate Change Adaptation", "Urban issues", "Desertification", "Children's issues", "Youth Issues", "Disability", "Indigenous Issues", "ICT as a tool for development"] | ["200000.00"] | ["4.1748 73.50888", "-9.43333 159.95", "-8.52425 179.19471", "-17.73381 168.32188", "15.30174 -61.38808", "13.15527 -61.22742", "12.05644 -61.74849", "-13.83333 -171.76666", "-0.55085 166.9252"] | ["2009200457"] | ["Joint Office for Commonwealth Permanent Missions to the United Nations "] | ["CA-3-M012902005", "CA-3-M012902006", "CA-3-M012902003"] | ["168209.83", "167084.74", "-2492.51", "2492.51", "1125.09"] | |||||||
| 1118 | CA-3-M012902005 | 2025-03-04T06:33:31 | Joint Office for Commonwealth Permanent Missions to the United Nations -2012 -13 | This grant represents Canada’s support for the Commonwealth Joint Office for Small States in New York. These states include Dominica, Gambia, Grenada, Maldives, Saint Vincent and the Grenadines, Samoa, Seychelles, Solomon Islands, Tuvalu, and Vanuatu. Canada’s support enables these countries to maintain representation at the United Nations and engage in discussions on development issues and challenges. | Closed | 2012-04-01T00:00:00 | 2013-03-26T00:00:00 | ["Nauru 9.09%", "Grenada 9.09%", "Vanuatu 9.09%", "Dominica 9.10%", "Solomon Islands 9.09%", "Tuvalu 9.09%", "Seychelles 9.09%", "Saint Vincent And The Grenadines 9.09%", "Samoa 9.09%", "Maldives 9.09%", "Gambia 9.09%"] | Joint Office for Commonwealth Permanent Missions to the United Nations | ["Public sector policy and administrative management 100.00%"] | 179000.00 | Contributions to specific-purpose programmes and funds managed by implementing partners | Bilateral | Aid grant excluding debt reorganisation | Global Affairs Canada | IFM International Security | Pre-APP | ["Gender equality", "Environmental sustainability (cross-cutting)", "Participatory development and good governance", "Trade development", "Biodiversity", "Climate change mitigation", "Climate Change Adaptation", "Urban issues", "Desertification", "Children's issues", "Youth Issues", "Indigenous Issues", "Disability", "ICT as a tool for development"] | ["190000.00"] | ["4.1748 73.50888", "-9.43333 159.95", "-8.52425 179.19471", "-17.73381 168.32188", "15.30174 -61.38808", "13.15527 -61.22742", "12.05644 -61.74849", "-13.83333 -171.76666", "-0.55085 166.9252"] | ["2009200458"] | ["Joint Office for Commonwealth Permanent Missions to the United Nations "] | ["CA-3-M012902004", "CA-3-M012902006", "CA-3-M012902003"] | ["179000.00", "179000.00"] | |||||||
| 1119 | CA-3-M012902006 | 2025-03-04T06:33:31 | Joint Office for Commonwealth Permanent Missions to the United Nations -2013-14 | This grant represents Canada’s support for the Commonwealth Joint Office for Small States in New York. These states include Dominica, Gambia, Grenada, Maldives, Saint Vincent and the Grenadines, Samoa, Seychelles, Solomon Islands, Tuvalu, and Vanuatu. Canada’s support enables these countries to maintain representation at the United Nations and engage in discussions on development issues and challenges. | Closed | 2013-03-27T00:00:00 | 2015-03-31T00:00:00 | ["Samoa 9.09%", "Nauru 9.09%", "Seychelles 9.09%", "Saint Vincent And The Grenadines 9.09%", "Dominica 9.10%", "Vanuatu 9.09%", "Maldives 9.09%", "Solomon Islands 9.09%", "Grenada 9.09%", "Tuvalu 9.09%", "Gambia 9.09%"] | Joint Office for Commonwealth Permanent Missions to the United Nations | ["Public sector policy and administrative management 100.00%"] | 70308.00 | Contributions to specific-purpose programmes and funds managed by implementing partners | Bilateral | Aid grant excluding debt reorganisation | Global Affairs Canada | IFM International Security | Pre-APP | ["Gender equality", "Environmental sustainability (cross-cutting)", "Participatory development and good governance", "Trade development", "Biodiversity", "Climate change mitigation", "Climate Change Adaptation", "Urban issues", "Desertification", "Children's issues", "Youth Issues", "Disability", "Indigenous Issues", "ICT as a tool for development"] | ["70308.00"] | ["4.1748 73.50888", "-9.43333 159.95", "-8.52425 179.19471", "-17.73381 168.32188", "-4.61667 55.45", "13.45 -16.57", "15.30174 -61.38808", "13.15527 -61.22742", "12.05644 -61.74849", "-13.83333 -171.76666", "-0.55085 166.9252"] | ["2013200213"] | ["Joint Office for Commonwealth Permanent Missions to the United Nations "] | ["CA-3-M012902005", "CA-3-M012902004", "CA-3-M012902003"] | ["70308.00", "70308.00"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [global_affairs_grants] ( [id] INTEGER PRIMARY KEY, [projectNumber] TEXT, [dateModified] TEXT, [title] TEXT, [description] TEXT, [status] TEXT, [start] TEXT, [end] TEXT, [countries] TEXT, [executingAgencyPartner] TEXT, [DACSectors] TEXT, [maximumContribution] TEXT, [ContributingOrganization] TEXT, [expectedResults] TEXT, [resultsAchieved] TEXT, [aidType] TEXT, [collaborationType] TEXT, [financeType] TEXT, [flowType] TEXT, [reportingOrganisation] TEXT, [programName] TEXT, [selectionMechanism] TEXT, [policyMarkers] TEXT, [regions] TEXT, [alternameImPositions] TEXT, [budgets] TEXT, [Locations] TEXT, [otherIdentifiers] TEXT, [participatingOrgs] TEXT, [programDataStructure] TEXT, [relatedActivities] TEXT, [transactions] TEXT );