Functions and Add-Ins for Working with '' Data Sets and Projects

High-level tools for working with '' data sets. '' is a platform where you can find interesting data, store and showcase your own data and data projects, and find and collaborate with other members. In addition to exploring, querying and charting data on the site, you can access data via 'API' endpoints and integrations. Use this package to access, query and explore data sets, and to publish your insights. Visit <>, for additional information.

CircleCI cran version

The package is the main R package for working with datasets on
Using this packages users can:

  • Query and join datasets
  • Choose between SQL and SPARQL
  • Publish insights
  • Use's REST API (via included dwapi package)

Getting Started

To get started, load the library and checkout the quickstart vignette.

vignette("quickstart", package = "")

Here is a simple example:

intro_ds <- ""
sample_query <-
  "SELECT t.Name, t.Height, s.AssistsPerGame ",
  "FROM DataDotWorldBBallTeam as t ",
  "JOIN DataDotWorldBBallStats as s ON t.Name = s.Name ",
  "ORDER BY s.AssistsPerGame DESC")), dataset = intro_ds)

Notice that dataset is parameter required by most functions and can be provided in two formats:

  1. URL: ""
  2. Path: "jonloyens/an-intro-to-dataworld-dataset"

Publishing Insights

For your convenience, this package allows you to publish insights to data projects without leaving R Studio.

Using R Studio's "Addins" menu, look for DATA.WORLD > New insight.

Add-in Menu

The add-in will automatically capture the active plot in R Studio's plot view and give you the opportunity to quickly choose the project, and enter title and description for your insight.

Add-in Window


To get the current released version from CRAN:


To get the current development version from GitHub:

devtools::install_github("datadotworld/", build_vignettes = TRUE)


First, users must obtain an API authentication token at:

IMPORTANT: For your security, do not include your API authentication token in code that is intended to be shared with others.

Configuration can be provided in 3 forms:

  • Via config file
  • Via environment variables
  • At runtime

Config files are the most convenient configuration method. Once saved configuration will be automatically restored when is loaded.

From the R console:

saved_cfg <-"YOUR API TOKEN")

For additional configuration options, see ?set_config


Check out the quickstart and query vignette and the package documentation (?

> ?



  • When insight add-in is activated but package is not attached, attempt to load saved configuration
  • Clarify error message that is displayed if environment is not configured
  • Gracefully handle activation of add-in if user has no suitable projects


  • Set explicit versoin for dwapi dependency
  • Fix installation and load issue related to use of .onLoad


  • Introduce "Add Insight" add-in
  • Improve reloading of saved API tokens
  • Address compatibility issues with testthat 2.0


  • Address requests from CRAN reviewers related to 1.1.0


  • Delete all defunct and deprecated functions
  • First attempted CRAN release

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.


1.2.2 by Rafael Pereira, a year ago

Report a bug at

Browse source code at

Authors: Rafael Pereira [aut, cre] , Triet Le [aut] , Bryon Jacob [aut] , Scott Came [aut]

Documentation:   PDF Manual  

Apache License 2.0 license

Imports httr, ini, miniUI, shiny, stringi

Depends on dwapi

Suggests covr, knitr, lintr, readr, rmarkdown, testthat

See at CRAN