Pull Philippines data on testing aggregates 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_tests(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 case information on testing aggregates distributed via the COVID-19 Data Drop

Examples

ph_get_tests()
#> Getting information on Google Drive directory structure of the DoH Data Drop for latest available data up to 2020-06-23.
#> # A tibble: 2,533 x 17
#>    facility_name report_date daily_output_sa… daily_output_un… daily_output_po…
#>    <chr>         <chr>                  <dbl>            <dbl>            <dbl>
#>  1 Allegiant Re… 2020-05-13                20               20                9
#>  2 Allegiant Re… 2020-05-14                20               20               11
#>  3 Allegiant Re… 2020-05-15                 0                0                0
#>  4 Allegiant Re… 2020-05-16                20               20                8
#>  5 Allegiant Re… 2020-05-17                 0                0                0
#>  6 Allegiant Re… 2020-05-18                20               20                4
#>  7 Allegiant Re… 2020-05-19                 0                0                0
#>  8 Allegiant Re… 2020-05-20                 0                0                0
#>  9 Allegiant Re… 2020-05-21                40               40                5
#> 10 Allegiant Re… 2020-05-22                40               40                0
#> # … with 2,523 more rows, and 12 more variables:
#> #   daily_output_negative_individuals <dbl>, daily_output_equivocal <dbl>,
#> #   daily_output_invalid <dbl>, remaining_available_tests <dbl>,
#> #   backlogs <dbl>, cumulative_samples_tested <int>,
#> #   cumulative_unique_individuals <int>, cumulative_positive_individuals <int>,
#> #   cumulative_negative_individuals <int>, pct_positive_cumulative <dbl>,
#> #   pct_negative_cumulative <dbl>, validation_status <chr>