Get patient experience data from MySQL (in the cloud)

Source: R/patient_experience.R

Note that you will need to configure Sys.getenv("UID_MYSQL_SUCE"), and Sys.getenv("PWD_MYSQL_SUCE") or use open_data = TRUE to retrieve the public dataset

get_px_exp(
  from = NULL,
  to = NULL,
  remove_demographics = TRUE,
  conn = conn_mysql_suce,
  open_data = TRUE,
  remove_optout = TRUE
)

Arguments

from

String, specifying start date in "YYYY-MM-DD" format
to

String, specifying end date in "YYYY-MM-DD" format
remove_demographics

Logical, specifying whether to remove demographic features (which must NOT be open sourced) (TRUE) or leave them in (FALSE).
conn

A database connection- by default done automatically
open_data

Logical, indicating whether you want to use the pre-cleaned open dataset that contains no demographic information or responses where the respondent opted out of sharing. Setting to FALSE requires an authenticated account
remove_optout

Logical, specifying whether you want to remove people who opted out of sharing. This MUST be done if data is shared. The open dataset does not contain any opt outs, for this reason

Value

SQL Table

Last updated by

Milan Wiedemann

Last updated date

2021-07-18