🔬 Research Datasets
Customer research records — protected backend · Role-based access
4
Total Records
All datasets
4
Pending Verification
Require review
1
Research Districts
Mukono
1
Photo Consent Refused
Enforced in workflows
1
Datasets
mukono_farmer_interviews
Import is idempotent: Re-uploading a record with the same
external_record_id + dataset_key will upsert (update) rather than duplicate it. Always run Preview first before committing.
Import Preview — Mukono Farmer Interviews
The 4 records from AgriGuard_Mukono_Interview_Import.xlsx have been pre-loaded below. Review the field mapping and validation results, then click Commit Import to upsert into the database.
Field Mapping
| Source Column | Target Field | Rule Applied |
|---|---|---|
| external_record_id | external_record_id | Stable upsert key — pass through as-is |
| dataset_key | dataset_key | Must match target dataset |
| name_provisional | name_provisional | Protected PII — super-admin only |
| age_years | age_years | NULL if blank — never substitute zero |
| phone_provisional | phone_provisional (TEXT) | Stored as text — leading zeros preserved |
| network_reported | network_reported | Reported name only, not verified payment account |
| land_acres_exact | land_acres_exact (NUMERIC) | NULL if unknown; "Plot (less than one acre)" → null exact acres |
| land_size_reported | land_size_reported (TEXT) | Exact free-text preserved |
| cover_type_reported | cover_type_reported | "Flood" = reported observation only, NOT active policy |
| photo_consent | photo_consent | refused | given | not_recorded — refused blocks photo workflows |
| interview_date | interview_date | NULL if blank — NOT replaced with upload date |
| village_reported | village_reported | "Buntaba" — provisional spelling, flagged for review |
| source_file | source_file | Original filename/UUID preserved |
| verification_status | verification_status | Default: pending_verification |
Validation Results
4
Total Rows
4
Ready
0
Errors
4
Warnings
CSV Upload — Import Records from Other Districts
Upload a CSV file from field interviews in any district. The CSV must include a header row matching the standard field mapping below.
Use Preview to validate before committing. Imports are idempotent —
re-uploading the same external_record_id + dataset_key will upsert, not duplicate.
Required CSV Columns
external_record_id, dataset_key, name_provisional, age_years, phone_provisional,
network_reported, land_acres_exact, land_size_reported, cover_type_reported,
photo_consent, interview_date, village_reported, source_file
Accuracy label: All figures below are observations from 4 research records currently pending verification. These are not confirmed programme statistics, not active policy counts, and not willingness-to-pay data.
Mukono District — Research Summary Pending Verification
Records Overview
Total interview records 4
Ages recorded 2
Ages not recorded 2
Exact acreage recorded 3
Land described only 1
Photo consent refused 1
Recorded Ages
Farmer 1 64
Farmer 2 72
Farmer 3 Not recorded
Farmer 4 Not recorded
2 of 4 records have age data
Land / Acreage
10 acres (Coffee) 1
5 acres (Maize) 1
3 acres (Beans) 1
Plot <1 acre 1
Mobile Networks (Reported)
MTN 3
Airtel 1
Network names are reported by respondents — not verified payment accounts
Crops Mentioned
Coffee
Maize
Beans
Bananas (secondary)
1 record — no crop recorded
Cover Type Reported
Flood (reported) 2
Not recorded 2
⚠ "Flood" = research observation only. Not a confirmed purchase, active policy, or WTP indicator.
Disclaimer: These statistics are observations from 4 research interview records which are currently pending verification. They do not represent confirmed programme enrolment, active insurance coverage, or validated agricultural data. Names and telephone numbers are retained in the protected backend only; public summaries must be anonymised. No interview quotes, satisfaction scores, willingness-to-pay findings or claims outcomes are recorded.
Verification Checklist 4 Items Pending
| Check | Status | Notes |
|---|---|---|
| Mukono appears in district selectors (research context) | ✓ Done | Research-only; not in USSD insurance registration districts |
| Exactly 4 records imported | Pending import commit | 4 rows in seed; confirm via record count after commit |
| Re-import does not duplicate | Enforced by UNIQUE constraint | (external_record_id, dataset_key) UNIQUE in DB |
| Phone leading zeros preserved | Enforced by TEXT type | phone_provisional stored as VARCHAR |
| Unknown ages / acreage / interview dates remain NULL | Enforced by schema | NULL not zero; blank → NULL rule in migration |
| Photo consent refused preserved & enforced | Enforced in API | POST /review returns 403 for photo fields on refused records |
| Kamwenge records & statistics unchanged | ✓ Confirmed | Separate schema; Mukono is research_records only |
| Unauthorised visitors cannot retrieve identifiable data | Enforced by API roles | requireAdminKey + PII stripped for analytics role |
| Records persist after refresh & new login | Pending DB deploy | In-memory stub active until DATABASE_URL set |
| Village "Buntaba" spelling flagged for review | Flagged in verification_notes | No parish, subcounty, or coordinates inferred |
| Research consent not recorded — retained for review | Human review required | research_consent = 'not_recorded' for all 4 records |
| No gender inference from names | ✓ Enforced | No gender field in schema |
Research Districts
| District Key | District Name | Country | Research Enabled | Insurance Availability |
|---|---|---|---|---|
| Loading… | ||||
Datasets Catalogue
| Dataset Key | Display Name | District | Source | Verification Status | Records |
|---|---|---|---|---|---|
| Loading… | |||||