home

malaria

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

Custom SQL query

Queries

  • Changes since a date
  • Endemic list as of a date
  • Country history
  • Search area text

Tables

area_statement

area_statement_id, record_id, seq, raw_text, polarity, tier, scope, place_name, elev_max_m, elev_min_m, season_text

150 rows

cdc_iso3

friendly_name, cdc_name, iso3, iso2, note

244 rows

change_event

change_event_id, collection_date, fetch_run_id, entity, country_id, country_name, change_type, changed_fields_json, old_value, new_value, created_at

245 rows

country

country_id, iso3, iso2, display_name, is_subnational_only, created_at

244 rows

country_alias

alias_id, country_id, source_id, native_kind, native_key, native_label, first_seen_fetch_run_id, last_seen_fetch_run_id

732 rows

deferral_rule

rule_id, source_id, code, exposure_type, geo_scope, threshold, deferral_window, description, citation, valid_from, valid_to, pathogen_reduction

7 rows

fetch_run

fetch_run_id, source_id, collection_date, started_at, finished_at, status, http_status, payload_sha256, destination_count, versions_written, changes_emitted, error_detail, tool_version

23 rows

malaria_record

record_id, country_id, valid_from, valid_to, is_current, source_id, fetch_run_id, payload_sha256, content_hash, area_of_risk_html, relative_risk_html, chloroquine_resist_html, species_html, recommended_prophylaxis_html, cdc_updated_date, has_transmission, is_endemic, whole_country_endemic, country_has_any_prophylaxis_area, screening_class, prophylaxis_drugs_json, species_json, chloroquine_resistant, area_summary, created_at

245 rows

raw_payload

payload_sha256, source_id, first_seen_at, byte_size, storage, file_path, compression, body

3 rows

schema_meta

key, value

1 row

source

source_id, code, name, kind, url, authority_tier

3 rows

yellowfever_record

record_id, country_id, valid_from, valid_to, is_current, source_id, fetch_run_id, payload_sha256, content_hash, has_requirements, requirements_html, has_recommendations, recommendations_html, created_at

244 rows

... and 6 hidden tables

Views

  • v_malaria_current
  • country_current
  • v_malaria_history

Download SQLite DB: malaria.db 912.0 KB

Powered by Datasette · Queries took 22.924ms · Data license: Public Domain (CDC) · Data source: CDC Travelers' Health (Yellow Fever & Malaria, by country)