The table data_control contains the downloaded data for each control
batch. Each line contains the search hits for each keyword in a
control batch for a given location and date. Global data
gets the value world as location. Data is downloaded and automatically
written to the table through the function download_control. The
function start_db exports the table data_control as database
connection tbl_control to the package environment gt.env. Users
can access the database table through dplyr::tbl.
The sample data included in data_control was simulated based on actual
Google Trends data.
Example data for the table data_control is available as R object
example_control.
example_controlA tibble with 2,400 rows and 5 variables:
Column of type character showing the ISO2 code of
the country or region for which the data was downloaded.
Column of type character showing the keyword for
which the data was downloaded.
Column of type integer showing the date for which the
data was downloaded. Can be transformed into date format with
lubridate::as_date.\item{hits}{Column of typedoubleshowing search volumes for the respective location-keyword-date combination.} \item{batch}{Column of typeinteger` showing the number of each
batch.
download_control()