songbaelee/spice-sme-pipeline

Internal CRS Innovative Finance tool for tracking spice sector SME lending candidates across Uganda, Madagascar, and Tanzania. Filterable pipeline directory with financial profiles, CRS relationship status, and data confidence ratings. # East Africa Spice Sector — SME Lending Pipeline An internal tool for tracking agri-SME lending candidates across Uganda, Madagascar, and Tanzania. Built for the CRS Innovative Finance team as part of the design process for a spice sector lending facility. ## What this is A filterable, sortable directory of spice sector SMEs evaluated as potential borrowers for a new CRS-managed lending facility. Each entry includes a financial profile (revenues, staff, capital need), CRS relationship status, donor/investor history, and data confidence ratings that distinguish between verified figures, company-reported numbers, and estimates derived from proxy signals. This is a working document, not a published dataset. Figures are updated as research and interviews progress. ## Structure ``` spice-sme-pipeline/ ├── index.html — frontend (shared across all countries) ├── uganda.json — Uganda SME entries ├── madagascar.json — Madagascar SME entries (forthcoming) ├── tanzania.json — Tanzania SME entries (forthcoming) └── README.md ``` The HTML frontend loads whichever country JSON is selected. To add or update entries, edit the relevant JSON file — the HTML never needs to change. ## Data schema Each entry in the JSON files follows this structure: | Field | Description | |---|---| | `id` | Unique identifier, e.g. `uga-001` | | `name` | Company name | | `founded` | Year founded | | `hq_location` | District / region | | `website` | Company website | | `primary_contact` | Name and title of key contact | | `org_type` | Private company / Cooperative / Social enterprise / Family business | | `value_chain_role` | Position in the value chain | | `primary_products` | List of primary crops / products | | `farmer_network_size` | Number of smallholder outgrowers | | `certifications` | Certifications held | | `export_markets` | Export destinations | | `revenue_usd_est` | Estimated annual revenue (range) | | `revenue_source` | Source of the revenue figure — see confide …