Dataset to reproduce analysis on the impact of indoor residual spraying (IRS) on malaria at Illovo Nchalo, Malawi

The repository contains:

- Excel sheets for each round of indoor residual spraying from 2014 - 2018 for villages based on the Illovo Nchalo Estate (provided by public health officer)

- Weather data for 1999 - 2019 downloaded from Sasri Weather web for Malawi - Illovo Nchalo (Open access after signing up)

- Explanation of variables downloaded from Sasri Weather Web

- Expected population: number of residents living in Illovo clinic's catchment areas based on 2016 and 2019 census. Linear interpolation for the other years

- Malaria data per month per clinic from the public health officer's records at Illovo Nchalo for 7 clinics for 2014 - 2018

- Malaria data downloaded and selected from DHIS2 (access upon request and approval)

Description of IRS data:

- Village: Name of the villages based at Illovo being targeted for IRS

- Target_spray: Number of structures within the village targeted for spraying

- Sprayed: Number of structures actually sprayed

- Date_start: Start date of the IRS campaign in a village

- Date_end: End date of the IRS campaign in that village

- Coverage_p: Percentage of structures sprayed calculated from "target_spray" and "sprayed"

Notes on reconciling the different years of IRS:

1. Post office and D. compound have been added to Nkombedzi

2. B compound has been added to Riverside/Mess

3. The following villages attend the following clinics

The following villages attend the assigned clinics:
- Mess and Bonksville -> Factory
- Mlambe and Paxman -> Mangulenje
- Sande Ranch -> Lengwe
- Mechanical Pool -> Mwanza

Description of the malaria data:

- Date, month, year

- Time_dummy: 1 to 48, over the study period

- Village: The name of the village the clinic is based in. In further analyses, this is referred to as "clinic" instead to avoid confusion.

- Total_cases: total number of cases testing positive for malaria by RDT, or in a very small percentage of cases microscopy (only used when RDT gives inconclusive or conflicting results, or when symptoms persist with negative RDT). Cases_on + cases_off = total_cases

- Cases_on: Number of malaria cases from residents of villages located within the boundaries of the Illovo estate

- Cases_off: Number of malaria cases from residents of villages located (just) outside the boundaries of the Illovo estate

- Total_patients: Total number of patients attending the clinic that month

From the selected control clinics only "WHO NMCP P Confirmed malaria cases" was used to indicate the number of malaria cases and "CMED Total Population" to indicate the clinic catchment population. Further info on DHIS2 website. 

For further information don't hesitate to contact Remy Hoek Spaans.