All Datasets

Overview (10)

`INFORM_Risk_sources.tsv`

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/INFORM_Risk_sources.tsv

Data Structure

Rows: 73
Columns: 2
$ indicator <chr> "Physical exposure to earthquake MMI VI", "Physical exposure…
$ sources   <chr> "['GEM']", "['GEM']", "['UNDRR']", "['UNDRR']", "['UNDRR']",…

`INFORM_Risk_sources_counts.tsv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/INFORM_Risk_sources_counts.tsv

Data Structure

Rows: 26
Columns: 2
$ sources <chr> "WHO", "JRC, EC", "World Bank", "UNDRR", "CRED", "FAO", "UNDP"…
$ count   <dbl> 14, 8, 8, 7, 5, 4, 3, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1…

`fts_api_grouped_germany.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/fts/fts_api_grouped_germany.csv

Data Structure

Rows: 755
Columns: 29
$ id                         <dbl> 224913, 225486, 225628, 231190, 231195, 231…
$ amountUSD                  <dbl> 2654006, 2389486, 0, 0, 2344666, 0, 426439,…
$ fullParkedAmountUSD        <dbl> 2654006, 2389486, 34216182, 11723329, NA, 2…
$ budgetYear                 <dbl> 2020, 2020, 2021, 2021, 2025, 2021, 2025, 2…
$ childFlowIds               <chr> NA, NA, "[265099, 265100, 225630, 265098, 2…
$ contributionType           <chr> "financial", "financial", "financial", "fin…
$ createdAt                  <dttm> 2020-12-08 02:25:33, 2020-12-16 02:25:56, …
$ date                       <dttm> 2020-12-07, 2020-12-15, 2020-12-17, 2021-0…
$ decisionDate               <dttm> 2020-12-07, 2020-12-15, 2020-12-17, 2021-0…
$ description                <chr> "Adolescents and young adults, especially g…
$ grandBargainEarmarkingType <chr> NA, NA, "['tightly earmarked']", "['earmark…
$ exchangeRate               <dbl> 0.837, 0.837, 0.837, 0.853, 0.853, 0.938, 0…
$ firstReportedDate          <dttm> 2020-12-07, 2020-12-15, 2020-12-17, 2021-0…
$ flowType                   <chr> "Parked", "Parked", "Parked", "Parked", "St…
$ keywords                   <chr> "['Multiyear']", "['Multiyear']", "['Multiy…
$ newMoney                   <lgl> TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, T…
$ originalAmount             <dbl> 2221403, 2000000, 0, 0, 2000000, 0, 400000,…
$ originalCurrency           <chr> "EUR", "EUR", "EUR", "EUR", "EUR", "EUR", "…
$ method                     <chr> "Traditional aid", "Traditional aid", "Trad…
$ parentFlowId               <dbl> NA, NA, NA, NA, 231190, NA, 231201, NA, NA,…
$ status                     <chr> "commitment", "commitment", "paid", "commit…
$ updatedAt                  <dttm> 2020-12-08 14:55:39, 2020-12-17 09:03:43, …
$ versionId                  <dbl> 1, 1, 1, 1, 2, 1, 2, 1, 1, 1, 1, 1, 1, 2, 3…
$ sourceObjects              <chr> "[{'type': 'Organization', 'id': '4306', 'n…
$ destinationObjects         <chr> "[{'type': 'Organization', 'id': '3369', 'n…
$ boundary                   <chr> "incoming", "incoming", "incoming", "incomi…
$ onBoundary                 <chr> "shared", "shared", "shared", "shared", "si…
$ reportDetails              <chr> "[{'sourceType': 'Primary', 'organization':…
$ refCode                    <chr> "2020.1877.8", "2020.1883.6", "AA-S09 321.5…

`full_country_list_with_stats.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/full_country_list_with_stats.csv

Data Structure

Rows: 248
Columns: 24
$ country_UN                  <chr> "Algeria", "Egypt", "Libya", "Morocco", "S…
$ region_code                 <chr> "002", "002", "002", "002", "002", "002", …
$ region_name                 <chr> "Africa", "Africa", "Africa", "Africa", "A…
$ sub_region_code             <chr> "015", "015", "015", "015", "015", "015", …
$ sub_region_name             <chr> "Northern Africa", "Northern Africa", "Nor…
$ intermediate_region_code    <chr> NA, NA, NA, NA, NA, NA, NA, "014", "014", …
$ intermediate_region_name    <chr> NA, NA, NA, NA, NA, NA, NA, "Eastern Afric…
$ m49_code                    <chr> "012", "818", "434", "504", "729", "788", …
$ iso_alpha2_code             <chr> "DZ", "EG", "LY", "MA", "SD", "TN", "EH", …
$ iso_alpha3_code             <chr> "DZA", "EGY", "LBY", "MAR", "SDN", "TUN", …
$ is_LDC                      <lgl> FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, F…
$ is_LLDC                     <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, …
$ is_SIDS                     <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, …
$ is_G77                      <lgl> TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE,…
$ is_EU                       <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, …
$ is_G20                      <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, …
$ is_AU                       <lgl> TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, …
$ is_P5                       <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, …
$ is_UN_member                <lgl> TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE,…
$ is_OECD                     <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, …
$ world_bank_income_group     <chr> "Upper middle income", "Lower middle incom…
$ world_bank_lending_category <chr> "IBRD", "IBRD", "IBRD", "IBRD", "IDA", "IB…
$ country                     <chr> "Algeria", "Egypt", "Libya", "Morocco", "S…
$ UN_regional_group           <chr> "African States", "African States", "Afric…

`hdx_organizations.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/hdx_organizations.csv

Data Structure

Rows: 374
Columns: 1
$ organization <chr> "3isolution", "acaps", "acfcolombia", "accion-contra-el-h…

`mptf_participating_orgs.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/mptf_participating_orgs.csv

Data Structure

Rows: 238
Columns: 9
$ agency_code                          <chr> "002100", "004471", "001999", "00…
$ ORGANIZATION                         <chr> "UNDP", "NGO/OCHA", "UNICEF", "NG…
$ BUDGET                               <dbl> 2701816494, 1434736588, 787179175…
$ NET_FUNDED                           <dbl> 2333254635, 1424884825, 748256233…
$ EXPENDITURE                          <dbl> 2059729007.8, 1284024779.7, 68900…
$ delivery_rate                        <dbl> 88.28, 90.11, 92.08, 115.75, 88.6…
$ FUNDS_COUNT                          <dbl> 238, 6, 139, 14, 111, 105, 103, 6…
$ implementing_group_code              <chr> "UNDP_GROUP_0001", "OCHA_GROUP_00…
$ implementing_agent_group_description <chr> "UNDP (United Nations Development…

`reliefweb_orgs.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/reliefweb_orgs.csv

Data Structure

Rows: 100
Columns: 30
$ id                        <dbl> 47419, 52175, 50943, 51822, 51845, 52284, 45…
$ score                     <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,…
$ href                      <chr> "https://api.reliefweb.int/v1/sources/47419"…
$ fields.id                 <dbl> 47419, 52175, 50943, 51822, 51845, 52284, 45…
$ fields.uuid               <chr> "1c11963b-0fc7-43c2-9cdd-82c77ef20263", "79d…
$ fields.name               <chr> "11.11.11", "360 Consulting", "360 Health Sy…
$ fields.status             <chr> "inactive", "active", "inactive", "active", …
$ fields.shortname          <chr> "11.11.11", "360 Consulting", "360HSDC", "3i…
$ fields.homepage           <chr> "https://www.11.be/en/", "https://360consult…
$ fields.content_type       <chr> "['job']", "['report']", "['job']", "['job',…
$ fields.type.id            <dbl> 275, 275, 275, 274, 274, 274, 275, 274, 274,…
$ fields.type.name          <chr> "Other", "Other", "Other", "Non-governmental…
$ fields.country            <chr> "[{'href': 'https://api.reliefweb.int/v1/cou…
$ fields.url                <chr> "https://reliefweb.int/taxonomy/term/47419",…
$ fields.url_alias          <chr> "https://reliefweb.int/organization/111111",…
$ fields.date.changed       <dttm> 2025-03-12 08:42:00, 2024-10-11 16:02:49, 2…
$ fields.date.created       <dttm> 2019-01-28 17:18:02, 2024-10-11 16:02:49, 2…
$ fields.description        <chr> NA, NA, NA, "3iS's mission is to lead and fa…
$ fields.redirects          <chr> NA, NA, NA, "['https://reliefweb.int/organiz…
$ `fields.description-html` <chr> NA, NA, NA, "<p>3iS's mission is to lead and…
$ fields.longname           <chr> NA, NA, NA, NA, NA, "Hamleh - The Arab Cente…
$ fields.logo.id            <dbl> NA, NA, NA, NA, NA, NA, 1129689, NA, NA, NA,…
$ fields.logo.width         <dbl> NA, NA, NA, NA, NA, NA, 50, NA, NA, NA, NA, …
$ fields.logo.height        <dbl> NA, NA, NA, NA, NA, NA, 50, NA, NA, NA, NA, …
$ fields.logo.url           <chr> NA, NA, NA, NA, NA, NA, "https://reliefweb.i…
$ fields.logo.filename      <chr> NA, NA, NA, NA, NA, NA, "Eight Fold Capacity…
$ fields.logo.mimetype      <chr> NA, NA, NA, NA, NA, NA, "image/png", NA, NA,…
$ fields.logo.filesize      <dbl> NA, NA, NA, NA, NA, NA, 1085, NA, NA, NA, NA…
$ fields.spanish_name       <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
$ fields.disclaimer         <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …

`sdg_indicators_custodian_agencies.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/sdg_indicators_custodian_agencies.csv

Data Structure

Rows: 267
Columns: 3
$ indicator <chr> "1.1.1 Proportion of the population living below the interna…
$ agency    <chr> "ILO", "World Bank", "World Bank", "World Bank", "ILO", "UN-…
$ website   <chr> "http://www.ilo.org/ilostat", "http://data.worldbank.org", "…

`sdg_indicators_custodian_agencies_counts.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/sdg_indicators_custodian_agencies_counts.csv

Data Structure

Rows: 48
Columns: 2
$ agency <chr> "WHO", "UNEP", "FAO", "World Bank", "OECD", "ILO", "UNICEF", "U…
$ count  <dbl> 27, 24, 22, 16, 15, 14, 13, 12, 12, 12, 10, 6, 5, 5, 5, 5, 5, 5…

`un_system.csv`

View

https://raw.githubusercontent.com/UN-CRAFd/crafd-reference-datasets/refs/heads/main/data/output/un_system.csv

Data Structure

Rows: 38
Columns: 6
$ full_organization_name  <chr> "United Nations Development Programme", "Unite…
$ short_organization_name <chr> "UNDP", "UNEP", "UNFPA", "UN-HABITAT", "UNICEF…
$ url                     <chr> "http://www.undp.org/content/undp/en/home.html…
$ description             <chr> "The United Nations Development Programme (UND…
$ organization_type       <chr> "Funds and Programmes", "Funds and Programmes"…
$ location_hq             <chr> "New York City, USA", "Nairobi, Kenya", "New Y…

How To Use The Datasets

First, copy any of the URLs above for the respective dataset.

In R

df <- readr::read_csv("PASTE_URL_HERE")

In Python

import pandas as pd

df = pd.read_csv("PASTE_URL_HERE")

In PowerBI

Chose import option Web.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-to-web

In Airtable

Choose CSV File then Link (URL).