Statistics Netherlands (CBS) Open Data API Client

The data and meta data from Statistics Netherlands (www.cbs.nl) can be browsed and downloaded. The client uses the open data API of Statistics Netherlands.

the url of the CBS Open Data api will change from "http" to "https"

cbsodataR version 2.4 and later will use https by default.

downloads

Retrieve data from the open data interface (dutch) of Statistics Netherlands (cbs.nl) with R.

Python user? Use cbsodata.

Installation

From CRAN

install.packages("cbsodataR")

The latest development version of cbsodata can installed using devtools.

devtools::install_github("edwindj/cbsodataR")

Usage

Retrieve list a tables.

Use the Identifier from tables to retrieve table information

> get_meta('71509ENG')
 
71509ENG: 'Yield apples and pears', 2013
  FruitFarmingRegions: 'Fruit farming regions'
  Periods: 'Periods'

Or download data

> library(dplyr) # to help select data and use the %>% operator
> get_data('71509ENG') %>% select(2:5) %>% head

Source: local data frame [6 x 4]

  FruitFarmingRegions Periods TotalAppleVarieties_1 CoxSOrangePippin_2
1   Total Netherlands    1997                   420                 43
2   Total Netherlands    1998                   518                 40
3   Total Netherlands    1999                   568                 39
4   Total Netherlands    2000                   461                 27
5   Total Netherlands    2001                   408                 30
6   Total Netherlands    2002                   354                 17

News

version 0.3

changed api: all (new) functions are prefixed with cbs_ to have a more clean programming interface.
old functions are still available and working but are deprecated.
verbose=FALSE and cache=TRUE by default: (for new functions).
get_table_list renamed to cbs_get_toc
data by default is typed: converted to the numeric representation (was not the case)
data is not recoded anymore, but label columns can be added to the data set by using cbs_add_label_columns.
View shows the column title.
cbs_add_date_column adds a column with the period converted to Date or numeric.