Introduction
The API is used by ChartJS within the WordPress pages.
This documentation aims to provide all the information you need to work with our API.
Authenticating requests
This API is not authenticated.
Data extract
APIs for extracting data for ChartJS
eCMS by Product
Provide eCMS import/export and return in values of CIF or Nett weight
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/ecmd/import/products/cif"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 59
vary: Origin
{
"title": "Customs iM of products as total CIF",
"labels": [
2017,
2018,
2019,
2020,
2021,
2022,
2023
],
"datasets": [
{
"label": "Food products",
"data": [
288879063,
27551189361,
54966371919,
87646550049,
162355620980,
199853812722,
120133438656
],
"backgroundColor": "#39E705"
},
{
"label": "Machinery and vehicles",
"data": [
944082402,
55078902604,
142958014399,
149097767584,
194572100098,
253642225088,
243750496924
],
"backgroundColor": "#0A2A5A"
},
{
"label": "Metal, plastic and rubber products",
"data": [
617070713,
74046284520,
171237875497,
159171579453,
185945827497,
275668859977,
359113418648
],
"backgroundColor": "#2549C0"
},
{
"label": "Miscellaneous",
"data": [
119372557,
3298251095,
7129775855,
6974166014,
9788568553,
13074183931,
11643770149
],
"backgroundColor": "#9F8E81"
},
{
"label": "Stone, glass and metal",
"data": [
232447616,
25773258912,
58783683961,
59615059975,
66419706697,
76543051732,
73436692366
],
"backgroundColor": "#F017CD"
},
{
"label": "Textiles, garments and footwear",
"data": [
496326099,
7819126979,
19070768693,
27003942437,
30891898309,
41904619338,
42327663780
],
"backgroundColor": "#7E8ED0"
}
]
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.eCMS by Chapter
Provide eCMS import/export by Chapter
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/ecmd/import/hs/27"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 58
vary: Origin
{
"title": "My First Chart",
"labels": [
2017,
2018,
2019,
2020,
2021,
2022,
2023
],
"datasets": [
{
"label": "AAK00 - AA KALITY (AAK)",
"data": [
12583280,
31072670887,
71683370755,
53414451324,
32263639135,
48211548624,
133707162131
],
"backgroundColor": "#87CB9B"
},
{
"label": "AAA00 - AA Airport",
"data": [
null,
8405782,
25736252,
19093415,
10953920,
13265959,
16562579
],
"backgroundColor": "#8FBB61"
},
{
"label": "AAA02 - AA Airport Passenger (AAPX)",
"data": [
null,
1949,
6002,
null,
null,
null,
null
],
"backgroundColor": "#A7A14C"
},
{
"label": "AAK04 - BOLE LEMY Industrial Park (BLP)",
"data": [
null,
114100,
270670,
21152,
148378,
1212518,
124509
],
"backgroundColor": "#656F1A"
},
{
"label": "AAK05 - EASTERN Industrial Park (EIP)",
"data": [
null,
51678,
16273908,
9298373,
15801910,
6805256,
4790197
],
"backgroundColor": "#B2E479"
},
{
"label": "BAH00 - BAHIRDAR (BAH)",
"data": [
null,
8846673,
5460785,
36399766,
141352217,
89431151,
349851540
],
"backgroundColor": "#45203D"
},
{
"label": "COM00 - COMBOLCHA (COM)",
"data": [
null,
612246,
42692201,
50953202,
13677995,
4133386,
31349418
],
"backgroundColor": "#21F84A"
},
{
"label": "DDL00 - DIRE DAWA LAGAR (DDL)",
"data": [
null,
142238266,
464010801,
94082944,
154242734,
276708952,
370089101
],
"backgroundColor": "#0FE2AA"
},
{
"label": "HAW00 - HAWASSA (HAW)",
"data": [
null,
34227137,
15589280,
149773123,
198898322,
224517990,
124770244
],
"backgroundColor": "#F776B6"
},
{
"label": "MEK00 - MEKELE (MEK)",
"data": [
null,
20950304,
494505935,
221482836,
null,
null,
2312425
],
"backgroundColor": "#BB49B9"
},
{
"label": "MOJ00 - MOJO Dry Port (MOJ)",
"data": [
null,
1213449355,
3555141607,
4323530877,
6384001923,
5970975210,
6825309110
],
"backgroundColor": "#E7A331"
},
{
"label": "MOY00 - MOYALE (MOY)",
"data": [
null,
576209,
1866600,
4805999,
12600659,
8354585,
257381434
],
"backgroundColor": "#A855EC"
},
{
"label": "NAZ00 - NAZARETH (NAZ)",
"data": [
null,
255685559,
466089746,
null,
null,
null,
null
],
"backgroundColor": "#8ACF6A"
},
{
"label": "AAA01 - AA Parcel Post (AAP)",
"data": [
null,
null,
147559,
185304,
177725,
398604,
408499
],
"backgroundColor": "#6C152B"
},
{
"label": "AAA03 - AA GERJI Cargo (AAGC)",
"data": [
null,
null,
1189815,
206076,
236630,
1315751,
79305
],
"backgroundColor": "#4B01FD"
},
{
"label": "BAH02 - GONDER (GON)",
"data": [
null,
null,
11422176,
19772,
null,
37903723,
null
],
"backgroundColor": "#34A799"
},
{
"label": "JIJ00 - JIJIGA (JIJ)",
"data": [
null,
null,
44426748,
null,
null,
null,
null
],
"backgroundColor": "#9D8A3E"
},
{
"label": "JIM00 - JIMMA (JIM)",
"data": [
null,
null,
385,
40686,
73326432,
57817026,
133513818
],
"backgroundColor": "#63F040"
},
{
"label": "MIL02 - SEMERA Dry Port (SEM)",
"data": [
null,
null,
33114480,
89477887,
33095612,
61343049,
244805522
],
"backgroundColor": "#81A590"
},
{
"label": "NAZ00 - ADAMA",
"data": [
null,
null,
2106980,
264856607,
47216055,
1086594464,
901015317
],
"backgroundColor": "#9F7831"
},
{
"label": "NAZ00 - ADAMA (NAZ)",
"data": [
null,
null,
4624737,
null,
null,
null,
null
],
"backgroundColor": "#A42E7D"
},
{
"label": "BAH04 - METEMA YOHANNES (METY)",
"data": [
null,
null,
null,
1163822,
null,
null,
null
],
"backgroundColor": "#6F95D3"
},
{
"label": "JIJ00 - JIGJIGA (JIJ)",
"data": [
null,
null,
null,
57588152,
44758501,
null,
86651030
],
"backgroundColor": "#C75F02"
},
{
"label": "NAZ01 - Adama Industry Park",
"data": [
null,
null,
null,
1613428,
null,
2325443,
5399187
],
"backgroundColor": "#26A742"
},
{
"label": "AAK03 - AA KALITY GELAN (GLN)",
"data": [
null,
null,
null,
null,
303350,
null,
null
],
"backgroundColor": "#50F1FC"
},
{
"label": "COM01 - COMBOLCHA INDUSTRY PARK",
"data": [
null,
null,
null,
null,
113866,
null,
21333594
],
"backgroundColor": "#95E86B"
},
{
"label": "HAW01 - HAWASSA INDUSTRY PARK",
"data": [
null,
null,
null,
null,
950453,
965374,
574986
],
"backgroundColor": "#05AE0C"
},
{
"label": "MEK05 - MEKELE INDUSTRY PARK",
"data": [
null,
null,
null,
null,
61681,
null,
null
],
"backgroundColor": "#F55A9D"
},
{
"label": "BAH08 - Woreta Dry Port Office",
"data": [
null,
null,
null,
null,
null,
996621,
null
],
"backgroundColor": "#F6CB9A"
},
{
"label": "COM02 - DEBREBIRHAN INDUSTRY PARK",
"data": [
null,
null,
null,
null,
null,
59407,
2063495
],
"backgroundColor": "#DFEBFB"
},
{
"label": "DDL03 - DIRE DAWA INDUSTRY PARK",
"data": [
null,
null,
null,
null,
null,
null,
7280
],
"backgroundColor": "#CC7EC5"
}
]
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.eCMS by Product and Chapter
Provide eCMS import/export chapter and return in values in CIF or Nett weight
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/ecmd/import/product/27/cif"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 57
vary: Origin
{
"title": "Customs import of HS27 Mineral fuels, oils and distillation; bituminous substances; waxes as total CIF",
"labels": [
2017,
2018,
2019,
2020,
2021,
2022,
2023
],
"datasets": [
{
"label": "HS27 Mineral fuels, oils and distillation; bituminous substances; waxes",
"data": [
12583280,
32757830145,
76868047422,
58739044745,
39395557498,
56056673093,
143085554721
],
"backgroundColor": "#340C2E"
}
]
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.eCMS by Chapter group by Office
Provide eCMS import/export by Chapter and return in values of CIF or Nett weight. Group per Office
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/ecmd/import/office/27/cif"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 56
vary: Origin
{
"title": "Customs import of HS27 Mineral fuels, oils and distillation; bituminous substances; waxes as total CIF",
"labels": [
"AAK00 - AA KALITY (AAK)",
"MOJ00 - MOJO Dry Port (MOJ)",
"NAZ00 - ADAMA",
"DDL00 - DIRE DAWA LAGAR (DDL)",
"HAW00 - HAWASSA (HAW)",
"MEK00 - MEKELE (MEK)",
"NAZ00 - NAZARETH (NAZ)",
"BAH00 - BAHIRDAR (BAH)",
"MIL02 - SEMERA Dry Port (SEM)",
"MOY00 - MOYALE (MOY)",
"JIM00 - JIMMA (JIM)",
"JIJ00 - JIGJIGA (JIJ)",
"COM00 - COMBOLCHA (COM)",
"AAA00 - AA Airport",
"AAK05 - EASTERN Industrial Park (EIP)",
"BAH02 - GONDER (GON)",
"JIJ00 - JIJIGA (JIJ)",
"COM01 - COMBOLCHA INDUSTRY PARK",
"NAZ01 - Adama Industry Park",
"NAZ00 - ADAMA (NAZ)",
"AAA03 - AA GERJI Cargo (AAGC)",
"HAW01 - HAWASSA INDUSTRY PARK",
"COM02 - DEBREBIRHAN INDUSTRY PARK",
"AAK04 - BOLE LEMY Industrial Park (BLP)",
"AAA01 - AA Parcel Post (AAP)",
"BAH04 - METEMA YOHANNES (METY)",
"BAH08 - Woreta Dry Port Office",
"AAK03 - AA KALITY GELAN (GLN)",
"MEK05 - MEKELE INDUSTRY PARK",
"AAA02 - AA Airport Passenger (AAPX)",
"DDL03 - DIRE DAWA INDUSTRY PARK"
],
"datasets": {
"data": [
370365426136,
28272408082,
2301789423,
1501372798,
747776096,
739251500,
721775305,
631342132,
461836550,
285585486,
264698347,
188997683,
143418448,
94017907,
53021322,
49345671,
44426748,
21447460,
9338058,
4624737,
3027577,
2490813,
2122902,
1891327,
1317691,
1163822,
996621,
303350,
61681,
7951,
7280
],
"backgroundColor": [
"#611175",
"#C34417",
"#1A22B7",
"#DB4A89",
"#5109DE",
"#4B929B",
"#131F6B",
"#149477",
"#2087FF",
"#F9843A",
"#7B7C2B",
"#505402",
"#9F58DF",
"#B2143A",
"#7AA7AD",
"#4316E8",
"#CC7DD4",
"#5A0E2F",
"#942B8B",
"#E5609C",
"#7B03F0",
"#45DEE0",
"#76F1CB",
"#ECB522",
"#A60DF9",
"#F0A021",
"#1616E2",
"#17EC65",
"#BFCA3A",
"#B1889D",
"#1EB237"
]
}
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.Trucking Fleet
provides the trucking fleet by Age, Status, Capacity Grouped by Level
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/trucks/fleet"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 55
vary: Origin
{
"Private: Level 1": {
"Age": {
"0-10 years": "1153",
"10-15 years": "913",
"15-20 years": "176",
"20+ years": "55"
},
"Status": {
"On Duty": "2026",
"On Maintenance": "166",
"Non Operational": "105",
"GPS Fitted": "894"
},
"Capacity": {
"200-299": "17",
"300-349": "24",
"350-379": "105",
"380+": "2151"
}
},
"Private: Level 4": {
"Age": {
"0-10 years": "487",
"10-15 years": "271",
"15-20 years": "79",
"20+ years": "114"
},
"Status": {
"On Duty": "742",
"On Maintenance": "126",
"Non Operational": "83",
"GPS Fitted": "15"
},
"Capacity": {
"200-299": "137",
"300-349": "67",
"350-379": "116",
"380+": "631"
}
},
"Assocaitions: Level 1": {
"Age": {
"0-10 years": "4375",
"10-15 years": "639",
"15-20 years": "39",
"20+ years": "6"
},
"Status": {
"On Duty": "4554",
"On Maintenance": "215",
"Non Operational": "290",
"GPS Fitted": "109"
},
"Capacity": {
"200-299": "165",
"300-349": "118",
"350-379": "1041",
"380+": "3735"
}
},
"Assocaitions: Level 2": {
"Age": {
"0-10 years": "38",
"10-15 years": "961",
"15-20 years": "1513",
"20+ years": "497"
},
"Status": {
"On Duty": "2464",
"On Maintenance": "310",
"Non Operational": "235",
"GPS Fitted": "82"
},
"Capacity": {
"200-299": "1299",
"300-349": "256",
"350-379": "352",
"380+": "1102"
}
},
"Assocaitions: Level 3": {
"Age": {
"0-10 years": "8",
"10-15 years": "18",
"15-20 years": "53",
"20+ years": "1720"
},
"Status": {
"On Duty": "1252",
"On Maintenance": "305",
"Non Operational": "242",
"GPS Fitted": "0"
},
"Capacity": {
"200-299": "1253",
"300-349": "245",
"350-379": "120",
"380+": "181"
}
}
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.Rail Freight
Will provide Chart Data for
- Commodity
- Containers Imported
- Empty Containers
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/rail/transports"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 54
vary: Origin
[
{
"id": 1,
"month": "2019-01-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "3170",
"multimodal_40": "21",
"unimodal_20": "212",
"unimodal_40": null,
"full_container_teu": "40",
"return_empty_container_20": "4142",
"return_empty_container_40": "11",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 2,
"month": "2019-02-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "10010",
"multimodal_20": "2860",
"multimodal_40": "0",
"unimodal_20": "516",
"unimodal_40": null,
"full_container_teu": "60",
"return_empty_container_20": "1794",
"return_empty_container_40": "35",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 3,
"month": "2019-03-01",
"wheat_tons": "0",
"iron_tons": "1415",
"fertiliser_tons": "15750",
"multimodal_20": "2622",
"multimodal_40": "15",
"unimodal_20": "316",
"unimodal_40": null,
"full_container_teu": "71",
"return_empty_container_20": "2612",
"return_empty_container_40": "7",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 4,
"month": "2019-04-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "7910",
"multimodal_20": "1120",
"multimodal_40": "0",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "4",
"return_empty_container_20": "844",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 5,
"month": "2019-05-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "14630",
"multimodal_20": "2498",
"multimodal_40": "0",
"unimodal_20": "98",
"unimodal_40": null,
"full_container_teu": "22",
"return_empty_container_20": "92",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 6,
"month": "2019-06-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "8680",
"multimodal_20": "4270",
"multimodal_40": "77",
"unimodal_20": "100",
"unimodal_40": null,
"full_container_teu": "36",
"return_empty_container_20": "72",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 7,
"month": "2019-07-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "10360",
"multimodal_20": "3708",
"multimodal_40": "970",
"unimodal_20": "200",
"unimodal_40": null,
"full_container_teu": "54",
"return_empty_container_20": "1734",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 8,
"month": "2019-08-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "3524",
"multimodal_40": "657",
"unimodal_20": "94",
"unimodal_40": null,
"full_container_teu": "128",
"return_empty_container_20": "1924",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 9,
"month": "2019-09-01",
"wheat_tons": "2520",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "3388",
"multimodal_40": "859",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "132",
"return_empty_container_20": "2718",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 10,
"month": "2019-10-01",
"wheat_tons": "10290",
"iron_tons": "0",
"fertiliser_tons": "5180",
"multimodal_20": "3192",
"multimodal_40": "371",
"unimodal_20": "200",
"unimodal_40": null,
"full_container_teu": "244",
"return_empty_container_20": "2192",
"return_empty_container_40": "24",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 11,
"month": "2019-11-01",
"wheat_tons": "10360",
"iron_tons": "0",
"fertiliser_tons": "4830",
"multimodal_20": "3870",
"multimodal_40": "403",
"unimodal_20": "480",
"unimodal_40": null,
"full_container_teu": "162",
"return_empty_container_20": "3342",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 12,
"month": "2019-12-01",
"wheat_tons": "10220",
"iron_tons": "0",
"fertiliser_tons": "3367",
"multimodal_20": "3098",
"multimodal_40": "823",
"unimodal_20": "460",
"unimodal_40": null,
"full_container_teu": "150",
"return_empty_container_20": "3636",
"return_empty_container_40": "55",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 13,
"month": "2020-01-01",
"wheat_tons": "2590",
"iron_tons": "1829.34989",
"fertiliser_tons": "385",
"multimodal_20": "2616",
"multimodal_40": "674",
"unimodal_20": "416",
"unimodal_40": null,
"full_container_teu": "186",
"return_empty_container_20": "2616",
"return_empty_container_40": "6",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 14,
"month": "2020-02-01",
"wheat_tons": "12950",
"iron_tons": "0",
"fertiliser_tons": "11200",
"multimodal_20": "2706",
"multimodal_40": "672",
"unimodal_20": "670",
"unimodal_40": null,
"full_container_teu": "342",
"return_empty_container_20": "2174",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 15,
"month": "2020-03-01",
"wheat_tons": "7630",
"iron_tons": "0",
"fertiliser_tons": "24360",
"multimodal_20": "2728",
"multimodal_40": "588",
"unimodal_20": "11",
"unimodal_40": null,
"full_container_teu": "346",
"return_empty_container_20": "2613",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 16,
"month": "2020-04-01",
"wheat_tons": "0",
"iron_tons": "2561.268",
"fertiliser_tons": "10010",
"multimodal_20": "1844",
"multimodal_40": "321",
"unimodal_20": "586",
"unimodal_40": null,
"full_container_teu": "508",
"return_empty_container_20": "2094",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 17,
"month": "2020-05-01",
"wheat_tons": "5180",
"iron_tons": "2561.288",
"fertiliser_tons": "11620",
"multimodal_20": "1996",
"multimodal_40": "181",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "796",
"return_empty_container_20": "1837",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 18,
"month": "2020-06-01",
"wheat_tons": "8190",
"iron_tons": "5076.918",
"fertiliser_tons": "14630",
"multimodal_20": "3090",
"multimodal_40": "567",
"unimodal_20": "408",
"unimodal_40": null,
"full_container_teu": "798",
"return_empty_container_20": "1903",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 19,
"month": "2020-07-01",
"wheat_tons": "17710",
"iron_tons": "6195.311",
"fertiliser_tons": "5180",
"multimodal_20": "2032",
"multimodal_40": "697",
"unimodal_20": "306",
"unimodal_40": null,
"full_container_teu": "748",
"return_empty_container_20": "1208",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 20,
"month": "2020-08-01",
"wheat_tons": "2590",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "3478",
"multimodal_40": "860",
"unimodal_20": "420",
"unimodal_40": null,
"full_container_teu": "830",
"return_empty_container_20": "2260",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 21,
"month": "2020-09-01",
"wheat_tons": "4640",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "4060",
"multimodal_40": "1048",
"unimodal_20": "388",
"unimodal_40": null,
"full_container_teu": "700",
"return_empty_container_20": "3540",
"return_empty_container_40": "0",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 22,
"month": "2020-10-01",
"wheat_tons": "2590",
"iron_tons": "2035.87",
"fertiliser_tons": "0",
"multimodal_20": "3038",
"multimodal_40": "1712",
"unimodal_20": "296",
"unimodal_40": null,
"full_container_teu": "740",
"return_empty_container_20": "3240",
"return_empty_container_40": "487",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 23,
"month": "2020-11-01",
"wheat_tons": "11900.45",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "3570",
"multimodal_40": "1806",
"unimodal_20": "102",
"unimodal_40": null,
"full_container_teu": "726",
"return_empty_container_20": "2892",
"return_empty_container_40": "445",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 24,
"month": "2020-12-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "2496",
"multimodal_40": "1718",
"unimodal_20": "210",
"unimodal_40": null,
"full_container_teu": "808",
"return_empty_container_20": "2760",
"return_empty_container_40": "599",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 25,
"month": "2021-01-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "36260",
"multimodal_20": "2344",
"multimodal_40": "1500",
"unimodal_20": "194",
"unimodal_40": null,
"full_container_teu": "770",
"return_empty_container_20": "2818",
"return_empty_container_40": "703",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 26,
"month": "2021-02-01",
"wheat_tons": "0",
"iron_tons": "2539.68",
"fertiliser_tons": "40040",
"multimodal_20": "3122",
"multimodal_40": "1552",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "1058",
"return_empty_container_20": "1564",
"return_empty_container_40": "1200",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 27,
"month": "2021-03-01",
"wheat_tons": "0",
"iron_tons": "5216.64",
"fertiliser_tons": "36680",
"multimodal_20": "2906",
"multimodal_40": "1288",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "1024",
"return_empty_container_20": "1888",
"return_empty_container_40": "829",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 28,
"month": "2021-04-01",
"wheat_tons": "0",
"iron_tons": "653.12",
"fertiliser_tons": "32060",
"multimodal_20": "2480",
"multimodal_40": "1413",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "1352",
"return_empty_container_20": "1852",
"return_empty_container_40": "870",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 29,
"month": "2021-05-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "23800",
"multimodal_20": "2070",
"multimodal_40": "1375",
"unimodal_20": "162",
"unimodal_40": null,
"full_container_teu": "1270",
"return_empty_container_20": "694",
"return_empty_container_40": "690",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 30,
"month": "2021-06-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "33740",
"multimodal_20": "1698",
"multimodal_40": "1270",
"unimodal_20": "212",
"unimodal_40": null,
"full_container_teu": "1956",
"return_empty_container_20": "620",
"return_empty_container_40": "885",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 31,
"month": "2021-07-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "21700",
"multimodal_20": "1306",
"multimodal_40": "1181",
"unimodal_20": "0",
"unimodal_40": null,
"full_container_teu": "1150",
"return_empty_container_20": "52",
"return_empty_container_40": "283",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 32,
"month": "2021-08-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "5740",
"multimodal_20": "1572",
"multimodal_40": "1358",
"unimodal_20": "44",
"unimodal_40": null,
"full_container_teu": "1484",
"return_empty_container_20": "75",
"return_empty_container_40": "458",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 33,
"month": "2021-09-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "4620",
"multimodal_20": "2126",
"multimodal_40": "1227",
"unimodal_20": "340",
"unimodal_40": null,
"full_container_teu": "1138",
"return_empty_container_20": "550",
"return_empty_container_40": "795",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 34,
"month": "2021-10-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "6860",
"multimodal_20": "3154",
"multimodal_40": "1264",
"unimodal_20": "337",
"unimodal_40": null,
"full_container_teu": "1236",
"return_empty_container_20": "1028",
"return_empty_container_40": "974",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 35,
"month": "2021-11-01",
"wheat_tons": "2170",
"iron_tons": "0",
"fertiliser_tons": "6090",
"multimodal_20": "3360",
"multimodal_40": "1139",
"unimodal_20": "338",
"unimodal_40": null,
"full_container_teu": "1174",
"return_empty_container_20": "1317",
"return_empty_container_40": "936",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 36,
"month": "2021-12-01",
"wheat_tons": "21140",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "2300",
"multimodal_40": "1468",
"unimodal_20": "314",
"unimodal_40": null,
"full_container_teu": "1466",
"return_empty_container_20": "1414",
"return_empty_container_40": "684",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 37,
"month": "2022-01-01",
"wheat_tons": "18130",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "2884",
"multimodal_40": "1249",
"unimodal_20": "80",
"unimodal_40": null,
"full_container_teu": "810",
"return_empty_container_20": "1276",
"return_empty_container_40": "703",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 38,
"month": "2022-02-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "26180",
"multimodal_20": "1874",
"multimodal_40": "1101",
"unimodal_20": "82",
"unimodal_40": null,
"full_container_teu": "1060",
"return_empty_container_20": "1300",
"return_empty_container_40": "710",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 39,
"month": "2022-03-01",
"wheat_tons": "11830",
"iron_tons": "0",
"fertiliser_tons": "23170",
"multimodal_20": "2964",
"multimodal_40": "1050",
"unimodal_20": "228",
"unimodal_40": null,
"full_container_teu": "1094",
"return_empty_container_20": "784",
"return_empty_container_40": "805",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 40,
"month": "2022-04-01",
"wheat_tons": "70",
"iron_tons": "0",
"fertiliser_tons": "29330",
"multimodal_20": "1208",
"multimodal_40": "937",
"unimodal_20": "488",
"unimodal_40": null,
"full_container_teu": "1376",
"return_empty_container_20": "1038",
"return_empty_container_40": "695",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 41,
"month": "2022-05-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "33670",
"multimodal_20": "1764",
"multimodal_40": "1203",
"unimodal_20": "264",
"unimodal_40": null,
"full_container_teu": "1294",
"return_empty_container_20": "592",
"return_empty_container_40": "872",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 42,
"month": "2022-06-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "22050",
"multimodal_20": "1566",
"multimodal_40": "816",
"unimodal_20": "140",
"unimodal_40": null,
"full_container_teu": "1632",
"return_empty_container_20": "262",
"return_empty_container_40": "192",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 43,
"month": "2022-07-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "19390",
"multimodal_20": "2190",
"multimodal_40": "1580",
"unimodal_20": "768",
"unimodal_40": null,
"full_container_teu": "1882",
"return_empty_container_20": "571",
"return_empty_container_40": "363",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 44,
"month": "2022-08-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "2590",
"multimodal_20": "1642",
"multimodal_40": "1167",
"unimodal_20": "604",
"unimodal_40": null,
"full_container_teu": "1734",
"return_empty_container_20": "1424",
"return_empty_container_40": "794",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 45,
"month": "2022-09-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "7770",
"multimodal_20": "2128",
"multimodal_40": "1002",
"unimodal_20": "456",
"unimodal_40": null,
"full_container_teu": "1488",
"return_empty_container_20": "848",
"return_empty_container_40": "596",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 46,
"month": "2022-10-01",
"wheat_tons": "0",
"iron_tons": "693",
"fertiliser_tons": "0",
"multimodal_20": "2456",
"multimodal_40": "1722",
"unimodal_20": "568",
"unimodal_40": null,
"full_container_teu": "1492",
"return_empty_container_20": "1174",
"return_empty_container_40": "563",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 47,
"month": "2022-11-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "0",
"multimodal_20": "2100",
"multimodal_40": "1546",
"unimodal_20": "456",
"unimodal_40": null,
"full_container_teu": "1286",
"return_empty_container_20": "1098",
"return_empty_container_40": "964",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 48,
"month": "2022-12-01",
"wheat_tons": "0",
"iron_tons": "0",
"fertiliser_tons": "910",
"multimodal_20": "1832",
"multimodal_40": "1632",
"unimodal_20": "746",
"unimodal_40": null,
"full_container_teu": "1202",
"return_empty_container_20": "1360",
"return_empty_container_40": "938",
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
},
{
"id": 49,
"month": "2023-01-01",
"wheat_tons": null,
"iron_tons": null,
"fertiliser_tons": null,
"multimodal_20": null,
"multimodal_40": null,
"unimodal_20": null,
"unimodal_40": null,
"full_container_teu": null,
"return_empty_container_20": null,
"return_empty_container_40": null,
"created_at": "2023-10-22T10:33:58.000000Z",
"updated_at": "2023-10-22T10:33:58.000000Z"
}
]
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.Road cost values
This API provides the online calculator with all the default values, including updated exchange rates and the cost of items such as tyres, etc.
The back-end contains hard-coded values that are subsequently overridden by values from the database, allowing for maintenance through the settings table. The 'name' of the values is 'transportation_rates'.
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/road/modjo"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 53
vary: Origin
{
"rate": {
"_default": "ETB",
"_use": 56.66,
"ETB": 56.66
},
"trips": 12,
"income_trip": 320000,
"income_backhaul": 20000,
"trip_km": 2000,
"cost_truck": 16000000,
"cost_truck_min": 16000000,
"cost_truck_max": 16000000,
"depreciation_years": 10,
"yellow_card": 1500,
"insurance_year": 34000,
"road_charges_100km_usd": 10,
"road_charge_usd": 20,
"fuel_etb": 79.54,
"km_l": 5,
"driver_salary": 10000,
"driver_dsa_trip": 13000,
"cost_tyre_usd": 722,
"tyres": 22,
"tyre_km": 40000,
"cost_service_maintenance_year_usd": 3000,
"cost_incidentals_trip_usd": 100
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.Shipping cost
Provider the shipping cost per originating port. For each month in US$.
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/shipping_cost"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 52
vary: Origin
{
"Periods": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"Antwerp": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
1600,
1600,
1650,
1700,
1800,
1800,
1800,
1900
],
"40_cost": [
2350,
2500,
2500,
2500,
2800,
2800,
2800,
2900
]
},
"Jebel Ali": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
1260,
2135,
2290,
2240,
2290,
2290,
2290,
2295
],
"40_cost": [
2189,
3739,
4000,
4005,
4100,
4100,
4100,
4215
]
},
"Jeddah": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
750,
1500,
1500,
1500,
1600,
1900,
1600,
1000
],
"40_cost": [
1050,
2750,
2800,
2800,
2900,
3000,
2900,
2950
]
},
"Ningbo": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
4400,
4200,
4095,
3895,
5095,
4695,
3890,
2785
],
"40_cost": [
7430,
7230,
6425,
6220,
8620,
8320,
5015,
2715
]
},
"Port Belawan": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
4395,
4245,
4095,
3995,
5095,
4895,
4295,
3195
],
"40_cost": [
7345,
7195,
6445,
6245,
8545,
8645,
5645,
3745
]
},
"Port Kelang": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
4410,
4260,
4005,
4005,
5105,
4900,
4300,
2700
],
"40_cost": [
7365,
7265,
6260,
6255,
8555,
8655,
5655,
2750
]
},
"Shanghai": {
"Period": [
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10"
],
"20_cost": [
4400,
4150,
4095,
3895,
5095,
4695,
3890,
2785
],
"40_cost": [
7430,
7230,
6425,
6220,
8620,
8320,
5015,
2715
]
}
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.Commercial Cargo Time
Will provide Chart Data time taken for commercial cargo The two station IDs with a full set of data are: GAL00, JIJ02 and DDL02. There are other IDs in the database, but they would need to have more data imported. By proving 'ALL" as the station, att the data will be in a sub-array with the stations as keys.
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/data/time/GAL00"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 51
vary: Origin
{
"data": {
"period": [
"2020-01",
"2020-02",
"2020-03",
"2020-04",
"2020-05",
"2020-06",
"2020-07",
"2020-08",
"2020-09",
"2020-10",
"2020-11",
"2020-12",
"2021-01",
"2021-02",
"2021-03",
"2021-04",
"2021-05",
"2021-06",
"2021-07",
"2021-08",
"2021-09",
"2021-10",
"2021-11",
"2021-12",
"2022-01",
"2022-02",
"2022-03",
"2022-04",
"2022-05",
"2022-06",
"2022-07",
"2022-08",
"2022-09",
"2022-10",
"2022-11",
"2022-12",
"2023-01",
"2023-02",
"2023-03",
"2023-04",
"2023-05",
"2023-06",
"2023-07"
],
"transit": [
"46.52",
"48.23",
"51.14",
"52.77",
"55.06",
"53.52",
"53.30",
"52.81",
"60.29",
"57.75",
"54.92",
"52.75",
"61.58",
"58.34",
"59.15",
"59.50",
"53.06",
"56.66",
"53.94",
"51.94",
"55.72",
"52.17",
"52.11",
"50.38",
"64.07",
"48.50",
"52.22",
"55.98",
"79.75",
"54.23",
"58.27",
"56.25",
"60.20",
"54.71",
"50.57",
"51.39",
"55.96",
"56.30",
"52.09",
"57.88",
"60.75",
"66.96",
"75.35"
],
"registration": [
"188.20",
"201.47",
"243.45",
"349.97",
"281.84",
"280.25",
"275.08",
"221.77",
"231.67",
"247.12",
"362.09",
"261.55",
"213.63",
"215.40",
"193.94",
"227.67",
"200.38",
"245.31",
"221.19",
"212.10",
"249.85",
"309.64",
"383.70",
"506.09",
"442.90",
"389.62",
"399.66",
"376.30",
"407.52",
"527.27",
"335.78",
"483.08",
"383.82",
"361.88",
"446.88",
"502.70",
"563.62",
"405.82",
"360.76",
"338.39",
"358.42",
"302.06",
"228.25"
],
"clearance": [
"439.14",
"406.76",
"418.69",
"327.02",
"301.16",
"323.05",
"308.17",
"290.39",
"332.81",
"346.68",
"409.14",
"406.96",
"389.52",
"408.46",
"331.51",
"351.15",
"302.73",
"318.43",
"312.84",
"369.17",
"391.13",
"377.64",
"452.91",
"592.16",
"595.27",
"699.54",
"603.84",
"532.40",
"584.20",
"674.85",
"629.82",
"539.31",
"533.04",
"536.63",
"616.26",
"590.20",
"535.85",
"604.05",
"569.46",
"516.45",
"460.62",
"382.63",
"336.89"
],
"n": [
3668,
3665,
2398,
2134,
2621,
2558,
2706,
2381,
2993,
1978,
2369,
2197,
1707,
1518,
1718,
1589,
1977,
751,
1056,
2041,
1978,
1744,
1054,
1050,
786,
641,
771,
332,
402,
362,
421,
200,
390,
443,
268,
302,
368,
467,
418,
435,
256,
359,
170
],
"total": [
673.86,
656.46,
713.28,
729.76,
638.06,
656.8199999999999,
636.55,
564.97,
624.77,
651.55,
826.15,
721.26,
664.73,
682.2,
584.6,
638.3199999999999,
556.1700000000001,
620.4000000000001,
587.97,
633.21,
696.7,
739.45,
888.72,
1148.63,
1102.24,
1137.6599999999999,
1055.72,
964.6800000000001,
1071.47,
1256.35,
1023.87,
1078.6399999999999,
977.06,
953.22,
1113.71,
1144.29,
1155.43,
1066.17,
982.3100000000001,
912.72,
879.79,
751.65,
640.49
],
"regression": [
605.260052854124,
616.0860525521003,
626.9120522500767,
637.7380519480531,
648.5640516460295,
659.3900513440059,
670.2160510419823,
681.0420507399587,
691.868050437935,
702.6940501359114,
713.5200498338878,
724.3460495318642,
735.1720492298406,
745.998048927817,
756.8240486257934,
767.6500483237697,
778.4760480217461,
789.3020477197225,
800.1280474176989,
810.9540471156753,
821.7800468136517,
832.606046511628,
843.4320462096044,
854.2580459075809,
865.0840456055573,
875.9100453035337,
886.7360450015101,
897.5620446994865,
908.3880443974629,
919.2140440954392,
930.0400437934156,
940.866043491392,
951.6920431893684,
962.5180428873448,
973.3440425853212,
984.1700422832976,
994.996041981274,
1005.8220416792503,
1016.6480413772267,
1027.474041075203,
1038.3000407731795,
1049.1260404711559,
1059.9520401691323
]
}
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.Project management
APIs for managing projects
List Projects
Retrieve an JSON of relevant projects. It could be displayed in datatables.net. The API is not currently used on the site.
Example request:
const url = new URL(
"https://etlsp.protal.africa/stats/api/projects/json"
);
const headers = {
"Content-Type": "application/json",
"Accept": "application/json",
};
fetch(url, {
method: "GET",
headers,
}).then(response => response.json());Example response (200):
Show headers
cache-control: no-cache, private
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 50
vary: Origin
{
"data": [
[
"Cooperating Partner: AFD (Implementing Agency: AFD)",
"Grant",
"Logistics",
"2019-2022",
"Completed",
"Contribution to the DPF2",
"Euro 100.00",
"Euro 85m to Budget Support and Euro 15m to technical assistance: <br />\n4 M to support TA to PPP unit (via EF)<br />\n1.5 M for long term experts to MoF (HGER) and PEHAA (SOE gov) (via Expertise France)<br />\n2.5 M to PEHAA (SOE governance)<br />\n4 M to support the MoF (HGER & SOE gov<br />\n3M contribution to the WB MDTF<br />\nNote: Logistics are indirectly included in these TA programmes",
""
],
[
"Cooperating Partner: AfDB",
"Loan",
"Infrastructure",
null,
"Completed",
"Modjo – Hawassa Expressway",
"UA 153.00",
"Improve the road transport connection between Hawassa industrial / agricultural node with Modjo port and Addis Ababa by improving the level of transport service. This road connects the Mombasa – Addis Road.<br />\nConstruct 200km 4 lane dual carriageway high speed expressway.<br />\nPhase I: AfDB, with co-financing from Korea Exim Bank, financed the construction of 100km of expressway between Modjo and Zeway - Complete <br />\nPhase II: WB and China Exim Bank funded the construction of 100 km from Zeway to Hawassa - Complete",
""
],
[
"Cooperating Partner: AfDB (Implementing Agency: Government of Ethiopia)",
"Loan",
"Transport Infrastructure",
"2017-2026",
"On-going",
"Ethiopia Integrated Transport Program Phase I (Jimma-Chida And Sodo-Sawla Road Upgrading Project)",
"UA 191.34",
"The Ethiopia Integrated Transport Program Phase I (Jimma – Chida and Sodo-Sawla Road Upgrading Project) consist the upgrading of the existing 240 km road sections to all weather high standard asphalt concrete surfaced road with a 7m wide carriageway and 1.5m x 2 sealed shoulders. The road will connect the towns of Jimma and Sodo directly and further connect Sawla to the main trunk road network, linking the local populations to Addis Ababa city and the rest of the country. The project includes skills development and capacity building in transport sectoral issues and climate change, and support in women entrepreneurial capacity. In addition, the project will implement fully the environmental and social management plan including improvements in emergency response facilities at Sawla hospital. The expected outcomes include improved road network, increased travel speeds and savings in time and vehicle operating costs. Other outcomes include increased skills, knowledge and capacity in transport issues, and improved response to road safety emergencies.",
"<a href=\"https://projectsportal.afdb.org/dataportal/VProject/show/P-ET-D00-007 \" target=\"_blank\"><i class=\"fa fa-link\"></i></a>"
],
[
"Cooperating Partner: AfDB (Implementing Agency: Governments of Ethiopia and Djibouti)",
"Grant",
"Transport Infrastructure",
"2019-2026",
"Ongoing",
"Ethiopia – Djibouti Transport Corridor Project Phase I ",
"UA 70.00",
"Construct 60km of 4 lane dual carriageway expressway between Adama and Awash towns<br />\nDesign OSBP at Dewele border point<br />\nDesign of road section and capacity building in Djibouti",
"<a href=\"https://projectsportal.afdb.org/dataportal/VProject/show/P-Z1-DB0-227#:~:text=The%20Ethiopia%20%E2%80%93%20Djibouti%20Transport%20Corridor,the%20economy%2C%20trade%20and%20transport. \" target=\"_blank\"><i class=\"fa fa-link\"></i></a>"
],
[
"Cooperating Partner: AfDB (Implementing Agency: Governments of Ethiopia and Kenya)",
"Loan",
"Transport Infrastructure",
null,
"Completed",
"Mombasa – Nairobi – Addis Ababa Road corridor project Phases I, II and III",
"UA 190.00",
"Construct 1000km of bitumen surfaced road in Kenya (500km) and Ethiopia (500km). Completed.<br />\nConstruct and operationalize one -stop-border post at Moyale border point. Completed.<br />\nUndertake studies to find ways to maximize the benefits of the OSBP. Completed<br />\nReview and recommend laws and regulations that would enhance trade and ways to remove barriers to trade. Completed.<br />\n5-year post construction data collection and analysis to monitor wealth creation/ accumulation/ poverty reduction of people affected by projects within the 700km road corridor from Moyale to Modjo. Completed",
"<a href=\"https://projectsportal.afdb.org/dataportal/VProject/show/P-Z1-DB0-032 \" target=\"_blank\"><i class=\"fa fa-link\"></i></a>"
],
[
"Cooperating Partner: AfDB (Implementing Agency: PACCI)",
"Grant",
"Trade Facilitation",
"2020-2022",
"On-going",
"Improving Trade Facilitation Environment in the IGAD Region Through Knowledge Generation and Capacity Building [ITFE]",
" ",
"A grant provided to PACCI to enhance capacities of the IGAD, PACCI and its organizations to facilitate cross-border trade and SMEs’ capacity enhancement in terms of competitiveness and knowledge of trade facilitation issues and their development along the Ethiopia-Djibouti Corridor, and ultimately the broader Eastern Africa Region",
"<a href=\"https://www.pacci.org/improving-trade-facilitation-in-eastern-africa/ \" target=\"_blank\"><i class=\"fa fa-link\"></i></a>"
],
[
"Cooperating Partner: EU (Implementing Agency: Framework Contract SUEZ)",
"Grant",
"Logistics",
"Completed 2020",
"Completed",
"Support to Horn of Africa Initiative on Regional Integration and Economic Development (2019/413262/1)",
" ",
"Study completed which identified policy, institutional, regulatory and administrative barriers hindering cross-border trade in goods and services (and investment), including those governing the logistics industry, in the Horn of Africa region.<br />\nhttps://hoainitiative.org/wp-content/uploads/2021/05/2019-413262-HoAI-NTBs-and-Trade-Facilitation-Study-clean.pdf ",
"<a href=\"https://hoainitiative.org/wp-content/uploads/2021/05/2019-413262-HoAI-NTBs-and-Trade-Facilitation-Study-clean.pdf \" target=\"_blank\"><i class=\"fa fa-link\"></i></a>"
],
[
"Cooperating Partner: EU EDF National",
"Grant",
"Logistics",
"2021-2023",
"Suspended",
"Regional Connectivity and Competitiveness - budget support Component",
"Euro 98.00",
"Budget support in 2 tranches: 1st tranch upon signature of the agreement and 2nd tranch upon presentation of a report showing how the FDRE had completed the 12 agreed indicators",
""
],
[
"Cooperating Partner: EU-EDF National",
"Grant",
"Budget Support Logistics",
"2021-2023",
"On-going",
"Regional Connectivity and Competitiveness - Ethiopia Transport and Logistics Support Programme. Project No. FED/2020/422 – 457",
"Euro 2.00",
"Technical support to monitor Budget Support Indicators<br />\nTechnical support to MoTL and EMA<br />\nEthiopia-Djibouti Corridor Management Authority Proposal and Work Plan<br />\nNational Logistics Masterplan Diagnostics<br />\nSupport to implementation of components of the National Logistics Master Plan",
""
],
[
"Cooperating Partner: EU-EDF National",
"Grant",
"Customs",
null,
"Completed",
"electronic Customs Management System (e-CMS)",
"Euro ",
"",
""
],
[
"Cooperating Partner: EU-EDF Regional",
"Grant",
"Transport",
null,
"On-going",
"Tripartite Transport and Transit Facilitation Programme",
"Euro ",
"Facilitate the development of a more competitive integrated and liberalised regional road transport market in the Eastern and Southern Africa region and to develop and implement harmonised road transport policies, laws, regulations and standards for efficient cross border road transport and transit networks, transport and logistics services, systems and procedures through:<br />\nHarmonised Vehicle Load Management<br />\nHarmonised Vehicle and Driver Regulations and Standards<br />\nIntegrated Transport Registers and Information Platform System<br />\nEfficiency of Regional Transport Corridors",
""
],
[
"Cooperating Partner: EU-EDF Regional (Implementing Agency: TMEA (AFD))",
"Grant",
"Logistics",
"2021-2024",
"On-going",
"Support to the Djibouti corridor. Managed through the EUD Djibouti Office, AFD Nairobi regional office and TMEA Djibouti Office",
"Euro 63.00",
"The EU-EDF Regional has provided a grant of €63 million to the French Development Agency (AFD) to support activities on the Ethio-Djibouti Corridor. The programme is being implemented by TMEA<br />\nSpecific Objectives:<br />\n1.\tImproved efficiency and capacity of the Djibouti Corridor. <br />\n2.\tMore harmonised trading and regulatory framework between Djibouti and Ethiopia.<br />\n3.\tEnhanced trade capacity for Djiboutian and Ethiopian companies in comparative advantage sectors<br />\n4.\tIncreased capacity of targeted women traders to participate in trade",
""
],
[
"Cooperating Partner: FCDO",
null,
"Infrastructure and Logistics",
"2018-2022",
"On-going",
"Unlocking Prosperity in the Horn of Africa",
"GBP 25.00",
"Constructing a 22.5km bypass around Hargeisa<br />\nTrade facilitation to support faster, more efficient cross border trade between Somaliland and Ethiopia. <br />\nlinking large ‘anchor’ businesses in both Somaliland and Ethiopia with small and medium-sized enterprises (SMEs) via financing and development interventions",
""
],
[
"Cooperating Partner: FCDO",
null,
"Logistics",
"2017-2025",
"On-going",
"Ethiopia Investment Advisory Facility (EIAF) and its successor EIAF 2",
"GBP 20.00",
"TA to Govt of Ethiopia for Public Investment Management, with a component on trade logistics:<br />\nImproving efficient import of basic commodities by ESLSE<br />\nEnterprise transformation planning for railways sector<br />\nTrade facilitation on Ethiopia-Berbera corridor",
""
],
[
"Cooperating Partner: FCDO",
null,
"Logistics",
null,
"On-going",
"Update of the Berbera Corridor Diagnostic Study",
" ",
"Refresh the understanding of the current status of the Berbera Corridor since the 2017 diagnostic. <br />\nAssess investments and progress made over the past four years and identify priority gaps that remain for a continued phased approach towards achieving a competitive and inclusive Berbera Development Corridor that benefits the citizens of Somaliland and Ethiopia. <br />\nAssess the strategic and policy framework necessary to ensure that the Government, businesses, and people of Somaliland are well equipped to take advantage of the opportunities a trade corridor provides. <br />\nAssess the key transmission points where Somalilanders are likely to benefit along with policy recommendations on how to realise these",
""
],
[
"Cooperating Partner: Flying Swans",
"PPP",
"Logistics",
"2018-2022",
"On-going",
"Cool Logistics Project",
"Euro 32.00",
"Cool Port Addis - cold storage facility integrated into a railway terminal near Addis Ababa<br />\nCool Rail Ethiopia – development of dedicated railway solutions to carry reefers from and to Djibouti port<br />\nCross-Dock Djibouti – developing a cross-docking facility at Djibouti port to fill empty reefer containers with import cargo from unrefrigerated containers.<br />\nFruit and Vegetables - support the growth of export capacity through identifying ideal growth windows, sharing Dutch best practices in production and export and facilitating matchmaking between producers and importers",
""
],
[
"Cooperating Partner: JICA",
null,
"Transport",
null,
"On-Going",
"Project for the improvement of axle-load control on Trunk Roads",
" ",
"The Preparatory study on the Project for Improvement of Axle Load Control on Trunk Roads in FDRE. Final Report. https://openjicareport.jica.go.jp/pdf/12229142.pdf",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Design and implementation of a Cargo Tracking System along the Ethiopia-Djibouti Corridor",
" ",
"",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Djibouti Corridor Management Adviser",
" ",
"Lead the work of the Djibouti component of the Ethiopia Djibouti Corridor Management Authority Secretariat and liaise with his/her counterparty in Ethiopia daily<br />\nSupport the implementation of the Djibouti Technical Committees’ work plans at the national level<br />\nOrganise, support and take minutes of meetings of the TCs at national level<br />\nSupport consultants doing studies and other work requested by the TCs as part of their work programmes<br />\nCoordinate implementation of the Djibouti component of Corridor infrastructure development<br />\nCoordinate implementation of the Djibouti component of Transport and Trade Facilitation projects",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Jijiga Inland Container Depot",
" ",
"",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Pre-Feasibility Diagnostic Study on Socio-Economic Development of the LAPSSAT Corridor",
" ",
"The primary purpose of the pre-feasibility diagnostic study is to assess, identify and advise on trade opportunities between Kenya and Ethiopia, the key barriers to trade and strategic policy and institutional framework necessary for a competitive and inclusive socio-economic development of the LAPSSET corridor, that benefits the businesses and people of Kenya and Ethiopia. ",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Ethiopia Country Programme (Transport, Logistics and Infrastructure Components)",
" ",
"",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Somaliland Country Programme (Transport, Logistics and Infrastructure Components)",
" ",
"",
""
],
[
"Cooperating Partner: TMEA",
null,
null,
null,
null,
"Djibouti Country Programme (Transport, Logistics and Infrastructure Components) ",
" ",
"",
""
],
[
"Cooperating Partner: TMEA",
null,
"Logistics",
null,
null,
"Feasibility study on the design and implementation of the cross border Electronic Cargo Tracking System (eCTS) and Covid-19 digital surveillance tracker for the Berbera corridor",
" ",
"",
""
],
[
"Cooperating Partner: TMEA",
null,
"Logistics",
null,
null,
"Support to the Secretariats and Work Programme of the Ethiopia-Djibouti Corridor",
" ",
"",
""
],
[
"Cooperating Partner: World Bank",
null,
null,
"2021-2023",
"On-going",
"Ethiopia Growth and Competitiveness Programmatic DPF ",
"USD ",
"Two analytical pieces are proposed to assess the (a) Impact of reforming the multimodal regime and (b) Impact of reforming FOB directive on logistics efficiency.<br />\nEthiopia Annual Logistics Performance Report: The objective of the component is to prepare a logistics performance benchmarking report and system to support strategic planning, evidence-based policy making, and monitoring of the implementation of policies related to logistics in Ethiopia. This would be achieved through the establishment of a national system for collecting, processing and publishing logistics statistics on an annual basis in Ethiopia. <br />\nRegulations to operationalize key reforms: The objective is to fill gaps in regulation on the management and operation of dry ports, multi-modalism and the distribution of traffic between road and rail transport, transit, contracts for shipment, axle loads and vehicle masses, and goods vehicle equipment and dimensions. The regulations will be drafted to meet the requirements of the private sector but in conformity with national strategic objectives and international commitments.<br />\nLogistics skills assessment: The proposed TA will examine the skills, competencies and professional training available for logistics in Ethiopia and define an implementation plan and time framework for responding to these needs.",
""
],
[
"Cooperating Partner: World Bank",
"Loan",
"Infrastructure",
"2022-2027",
"In Preparation",
"Horn of Africa Initiative and the Djibouti Corridor",
"USD 500.00",
"Component 1: Safe, Smart, Efficient and Resilient Road Corridor Construction<br />\nComponent 2: Trade Facilitation and Logistics Enhancement<br />\nComponent 3: Localized Complementary Infrastructure and Interventions<br />\nComponent 4: Institutional Development and Project Monitoring<br />\nComponent 5: Contingent Emergency Response Component (CERC)",
""
],
[
"Cooperating Partner: World Bank",
"Loan",
"Logistics",
"2018-2023",
"On-going",
"Ethiopia Transport and Logistics Program (ETLP)",
"USD 150.00",
"The objective of the project is to enhance the performance of the Ethiopia-Djibouti Corridor through improvements in operational and physical capacity, efficiency and range of logistics services at Modjo Dry Port.<br />\nImprovements of physical capacity at Modjo, investments in IT systems to enhance operational coordination and regulatory and institutional capacity support",
""
],
[
"Cooperating Partner: World Bank",
"Grant",
"Trade Facilitation",
"2022-2023",
"Ongoing",
"Support to HOAI Trade Facilitation and Regional Integration Pillars",
"USD 200.00",
"Support of Horn of Africa Initiative to help achieve two objectives: a) assit HoA countries with the trade reform roadmap focusing on trade policies, NTBs, and trade facilitation aspects; and b) enable the WBG to provide an adequate response to support the HoA countries to implement the reform roadmap, potentially through different instruments (lending, DPL-PBCs, TA,etc)",
""
],
[
"Cooperating Partner: World Bank",
"Loan",
"Transport",
"Close 2024",
"On-going",
"Road Sector Support Project (RSSP)",
"USD 320.00",
"Component 1 (US$285 million)- Upgrading of critical link road (Nekempte-Bure)<br />\nComponent 2 (US$25 million)- Support to enhancing road asset management practice<br />\nComponent 3 (US$10 million)- Support to Road Safety and Institutional Development",
""
],
[
"Cooperating Partner: World Bank",
"Loan",
"Transport",
"Close 2022",
"Completed",
"Expressway Development Support Project (EDSP): ",
"USD 295.00",
"Component 1: Construction of High-Capacity Highway between (Zeway) - Arsi Negele (57 km) of the new Modjo - Hawassa Highway (201km) to an expressway standard. (US$265M)<br />\nComponent 2: Institutional Development and Regulatory Framework (US$18 M)<br />\nComponent 3: Road Safety and Institutional Development Support to the Transport Sector. (US$12M)",
""
],
[
"Cooperating Partner: World Bank",
"Loan",
"Transport",
"Closing 2023",
"On-going",
"Transport Systems Improvement Project (TRANSIP): ",
"USD 300.00",
"Component 1: Traffic Management and Road Safety in the City of Addis Ababa ($190.10M); <br />\nComponent 2: Improvement of Integrated Urban Planning and Transport System ($2.80M); <br />\nComponent 3: Road Safety Interventions and Institutional Strengthening of Selected Federal Transport Institutions ($107.10M). ",
""
]
]
}
Received response:
Request failed with error:
Tip: Check that you're properly connected to the network.
If you're a maintainer of ths API, verify that your API is running and you've enabled CORS.
You can check the Dev Tools console for debugging information.