get_px_exp: Get patient experience data from MySQL (in the cloud)

In CDU-data-science-team/nottshcOpenData: Open datasets from Nottinghamshire Healthcare NHS Foundation Trust (NOTTSHC)

Description

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

Usage

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

CDU-data-science-team/nottshcOpenData documentation built on Dec. 17, 2021, 12:53 p.m.