Regional Sector comparison - total number of projects in recipient region, by sector

sector	id	test link JSON	test link JSONP
ACTION RELATING TO DEBT	S100	?sector=S100	?sector=S100&jsonp
AGRICULTURE, FORESTRY, FISHING	S101	?sector=S101	?sector=S101&jsonp
BANKING AND FINANCIAL SERVICES	S102	?sector=S102	?sector=S102&jsonp
BUSINESS AND OTHER SERVICES	S103	?sector=S103	?sector=S103&jsonp
COMMUNICATIONS	S104	?sector=S104	?sector=S104&jsonp
DEVELOPMENTAL FOOD AID/FOOD SECURITY ASSISTANCE	S105	?sector=S105	?sector=S105&jsonp
DISASTER PREVENTION AND PREPAREDNESS	S106	?sector=S106	?sector=S106&jsonp
EDUCATION	S107	?sector=S107	?sector=S107&jsonp
EMERGENCY RESPONSE	S108	?sector=S108	?sector=S108&jsonp
ENERGY	S109	?sector=S109	?sector=S109&jsonp
GENERAL BUDGET SUPPORT	S110	?sector=S110	?sector=S110&jsonp
GENERAL ENVIRONMENTAL PROTECTION	S111	?sector=S111	?sector=S111&jsonp
GOVERNMENT AND CIVIL SOCIETY	S112	?sector=S112	?sector=S112&jsonp
HEALTH	S113	?sector=S113	?sector=S113&jsonp
INDUSTRY, MINING, CONSTRUCTION	S114	?sector=S114	?sector=S114&jsonp
OTHER COMMODITY ASSISTANCE	S115	?sector=S115	?sector=S115&jsonp
OTHER MULTISECTOR	S116	?sector=S116	?sector=S116&jsonp
OTHER SOCIAL INFRASTRUCTURE AND SERVICES	S117	?sector=S117	?sector=S117&jsonp
POPULATION POLICIES/PROGRAMMES AND REPRODUCTIVE HEALTH	S118	?sector=S118	?sector=S118&jsonp
RECONSTRUCTION RELIEF AND REHABILITATION	S119	?sector=S119	?sector=S119&jsonp
TRADE POLICIES AND REGULATIONS	S120	?sector=S120	?sector=S120&jsonp
TRANSPORT AND STORAGE	S121	?sector=S121	?sector=S121&jsonp
UNALLOCATED/UNSPECIFIED	S122	?sector=S122	?sector=S122&jsonp
WATER SUPPLY AND SANITATION	S123	?sector=S123	?sector=S123&jsonp

sector :: FORWARD lookup table JSON:

{"ACTION RELATING TO DEBT":"S100","AGRICULTURE, FORESTRY, FISHING":"S101","BANKING AND FINANCIAL SERVICES":"S102","BUSINESS AND OTHER SERVICES":"S103","COMMUNICATIONS":"S104","DEVELOPMENTAL FOOD AID\/FOOD SECURITY ASSISTANCE":"S105","DISASTER PREVENTION AND PREPAREDNESS":"S106","EDUCATION":"S107","EMERGENCY RESPONSE":"S108","ENERGY":"S109","GENERAL BUDGET SUPPORT":"S110","GENERAL ENVIRONMENTAL PROTECTION":"S111","GOVERNMENT AND CIVIL SOCIETY":"S112","HEALTH":"S113","INDUSTRY, MINING, CONSTRUCTION":"S114","OTHER COMMODITY ASSISTANCE":"S115","OTHER MULTISECTOR":"S116","OTHER SOCIAL INFRASTRUCTURE AND SERVICES":"S117","POPULATION POLICIES\/PROGRAMMES AND REPRODUCTIVE HEALTH":"S118","RECONSTRUCTION RELIEF AND REHABILITATION":"S119","TRADE POLICIES AND REGULATIONS":"S120","TRANSPORT AND STORAGE":"S121","UNALLOCATED\/UNSPECIFIED":"S122","WATER SUPPLY AND SANITATION":"S123"}

sector :: REVERSE lookup table JSON:

{"S100":"ACTION RELATING TO DEBT","S101":"AGRICULTURE, FORESTRY, FISHING","S102":"BANKING AND FINANCIAL SERVICES","S103":"BUSINESS AND OTHER SERVICES","S104":"COMMUNICATIONS","S105":"DEVELOPMENTAL FOOD AID\/FOOD SECURITY ASSISTANCE","S106":"DISASTER PREVENTION AND PREPAREDNESS","S107":"EDUCATION","S108":"EMERGENCY RESPONSE","S109":"ENERGY","S110":"GENERAL BUDGET SUPPORT","S111":"GENERAL ENVIRONMENTAL PROTECTION","S112":"GOVERNMENT AND CIVIL SOCIETY","S113":"HEALTH","S114":"INDUSTRY, MINING, CONSTRUCTION","S115":"OTHER COMMODITY ASSISTANCE","S116":"OTHER MULTISECTOR","S117":"OTHER SOCIAL INFRASTRUCTURE AND SERVICES","S118":"POPULATION POLICIES\/PROGRAMMES AND REPRODUCTIVE HEALTH","S119":"RECONSTRUCTION RELIEF AND REHABILITATION","S120":"TRADE POLICIES AND REGULATIONS","S121":"TRANSPORT AND STORAGE","S122":"UNALLOCATED\/UNSPECIFIED","S123":"WATER SUPPLY AND SANITATION"}

region	id	test link JSON	test link JSONP
Africa	R100	?region=R100	?region=R100&jsonp
America	R101	?region=R101	?region=R101&jsonp
Asia	R102	?region=R102	?region=R102&jsonp
Europe	R103	?region=R103	?region=R103&jsonp
Middle East	R104	?region=R104	?region=R104&jsonp
Multi-Region	R105	?region=R105	?region=R105&jsonp
Oceania	R106	?region=R106	?region=R106&jsonp

region :: FORWARD lookup table JSON:

{"Africa":"R100","America":"R101","Asia":"R102","Europe":"R103","Middle East":"R104","Multi-Region":"R105","Oceania":"R106"}

region :: REVERSE lookup table JSON:

{"R100":"Africa","R101":"America","R102":"Asia","R103":"Europe","R104":"Middle East","R105":"Multi-Region","R106":"Oceania"}