Pull Philippines data fields information from the publicly available Department of Health COVID-19 Data Drop

A wrapper to googledrive and googlesheets4 functions to pull data from the Philppines' COVID-19 Data Drop resource that is publicly distributed via Google Drive

ph_get_fields(version = "current", date = NULL)

Arguments

version	A character value specifying whether to get the most currently available dataset ("current") or to get archive data ("archive"). Default to "current"
date	Date in <YYYY-MM-DD> format; This is the date up to which extracted data reports to. Only used when version is set to "archive" otherwise ignored.

Value

A tibble of metadata for the fields used in the various datasets distributed via the COVID-19 Data Drop

Examples

ph_get_fields()
#> Getting information on Google Drive directory structure of the DoH Data Drop for latest available data up to 2020-06-23.
#> # A tibble: 61 x 7
#>    Sheet  Field  Description      Type  Question.Format Possible.Respon… Purpose
#>    <chr>  <chr>  <chr>            <chr> <chr>           <chr>            <chr>  
#>  1 Case … CaseC… Random code ass… Text  ""              ""               ""     
#>  2 Case … Age    Age              Numb… ""              ""               ""     
#>  3 Case … AgeGr… Five-year age g… Text  ""              ""               ""     
#>  4 Case … Sex    Sex              Text  ""              ""               ""     
#>  5 Case … DateS… Date when speci… Date  ""              ""               ""     
#>  6 Case … DateR… Date of release… Date  ""              ""               ""     
#>  7 Case … DateR… Date publicly a… Date  ""              ""               ""     
#>  8 Case … DateD… Date died        Date  ""              ""               ""     
#>  9 Case … DateR… Date recovered   Date  ""              ""               ""     
#> 10 Case … Remov… Type of removal… Text  ""              ""               ""     
#> # … with 51 more rows