opendatascot

Use opendatascot to download data from statistics.gov.scot with a single line of R code. opendatascot removes the need to write SPARQL code; you simply need the URI of a dataset. opendatascot can be used interactively, or as part of a reproducible analytical pipeline.

Installation

Install opendatascot from GitHub with:

# install.packages("devtools")
devtools::install_github("jsphdms/opendatascot")

If the above does not work, you can install from source:

  1. Go to the opendatascot repository on GitHub
  2. Click Clone or download then Download ZIP
  3. Save the file locally (e.g. your H drive) and Unzip
  4. Install with install.packages()
install.packages("your/directory/opendatascot", repos = NULL,
                 type="source", lib = "your/R/package/library/directory")

Usage

Find the name of the dataset you want using list_sg_dataset()

Learn more in vignette("opendatascot") or ?ods_dataset.

Use list_sg_dataset() to find all datasets currently loaded onto statistics.gov.scot

Use ods_dataset() to get the data from a dataset in statistics.gov.scot

Use ods_structure() to find all the full sets of categories and values for a particular dataset (helpful for creating new filters for ods_dataset!)

Use ods_print_query() to produce the SPARQL query used by ods_dataset().

Examples

Get a dataframe of all datasets on statistics.gov.scot, their uri, and publisher all_scotgov_datasets <- ods_all_datasets()

Discover the structure of the dataset on homelessness applications - so we can use this in a later filter our_structure <- ods_structure("homelessness-applications")

After viewing our_structure - we decide we only want the data for “all applications” and for the periods “2015/2016” and “2016/2017”, so we add these to the filter.

filtered_data <- ods_dataset("homelessness-applications",
                              refPeriod = c("2015/2016", "2016/2017"),
                              applicationType = "All applications")

Future development

This package is under active development, so any further functionality will be mentioned here when it’s ready. If something important is missing, feel free to contact the contributors or add a new issue.

Since this package is under active development, breaking changes may be necessary. We will make it clear once the package is reasonably stable.