Skip to contents

Static mapping of the tables get_polis_data() supports.

Usage

polis_tables_mapping

Format

A data.frame with one row per supported table and columns:

table_name

Short identifier used by tables = "...".

endpoint

OData endpoint suffix appended to https://extranet.who.int/polis/api/v2/.

date_field

Column used for both the OData filter and the dedup tiebreaker.

file_stem

Canonical on-disk filename stem (the raw_* name the downloaded table is written under, e.g. raw_afp for case). The cleaning pipeline reads these stems and writes polished_* outputs.

Details

Each date_field identifies the column used for date filtering. Revision dates (LastUpdateDate or UpdatedDate) also support checks for edited records. Tables filtered by event dates (Start or PublishDate) require a full refresh to detect edits. Records with missing filter dates, or dates outside the requested years, are excluded by the date filter.

A date_field of NA marks a reference table (e.g. population) that carries no usable update date: it is pulled whole in a single Id-paginated pass, ignoring min_date/max_date/region.