series: Retrieve Series Table

View source: R/accessdb.R

seriesR Documentation

Retrieve Series Table


This function pulls and returns a table called 'SERIES' from the database.


series(dsid = NULL, = TRUE, ordered = TRUE, return.query = FALSE)



character. (Optional) id's of datasets matching the 'DSID' column of the 'DATASET' table (retrieved using datasets()) for which series information is to be returned.

logical. TRUE returns additional information from the 'DATASET' table about the datasets in which the series are recorded. FALSE only returns the raw 'SERIES' table.


logical. TRUE orders the result in the order data was entered into the database, while FALSE returns the result in a random order, to the benefit of faster query execution.


logical. TRUE will not query the database but instead return the constructed SQL query as a character string.


The 'SERIES' table gives information about all of the time series in the database. Each series is given a code which is however not unique across datasets (see .IDvars). Each series also has a label describing the series. Further information recorded are the minimum and maximum time coverage, and (optionally) a separate series source and url. By default = TRUE and the frequency of the data, the date when the dataset containing the series was last updated, the dataset and data source are added to the 'SERIES' table from the 'DATASET' table.

If = FALSE, the 'DATASET' table is not joined to the 'SERIES' table, and ordered = TRUE only orders the series within each dataset to maintain the column order of series in the source data. In that case the datasets are returned in alphabetic order of 'DSID', not the order in which they were entered into the 'DATASET' table.


A data.table with information about the available time series in the database.

See Also

datasets, ugatsdb


# By default returns all series with additional information

# Raw series table
series( = FALSE)

# Only series in the Monthly Macroeconomic Indicators of the BoU

ugatsdb documentation built on Nov. 24, 2022, 1:06 a.m.