v_malaria_history (view)

Data license: Public Domain (CDC) · Data source: CDC Travelers' Health (Yellow Fever & Malaria, by country)

245 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: valid_from, is_current, screening_class, is_endemic, area_summary, cdc_updated_date, fetch_run_id, valid_from (date), valid_to (date), cdc_updated_date (date)

Next page

CREATE VIEW v_malaria_history AS
SELECT c.display_name, c.iso3, mr.record_id, mr.valid_from, mr.valid_to, mr.is_current,
       mr.screening_class, mr.is_endemic, mr.area_summary, mr.cdc_updated_date,
       mr.fetch_run_id, mr.content_hash
FROM malaria_record mr
JOIN country c USING (country_id)
ORDER BY c.display_name, mr.valid_from DESC;