Endemic list as of a date

The deferral-relevant endemic country list as it stood on a past date.

Custom SQL query (hide) 

SELECT c.iso3, c.display_name, mr.screening_class, mr.area_summary
FROM malaria_record mr JOIN country c USING (country_id)
WHERE mr.is_endemic = 1
  AND mr.valid_from <= :as_of
  AND (mr.valid_to > :as_of OR mr.valid_to IS NULL)
ORDER BY c.display_name

Query parameters

Edit SQL

0 results