The data and meta data from Statistics Netherlands (< https://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.
Retrieve data from the open data interface (dutch) of Statistics Netherlands (cbs.nl) with R.
Python user? Use cbsodata.
From CRAN
install.packages("cbsodataR")
The latest development version of cbsodata
can installed using devtools
.
devtools::install_github("edwindj/cbsodataR")
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
version 0.3.2
version 0.3.1
version 0.3
cbs_
to have a more clean programming interface.verbose=FALSE
and cache=TRUE
by default: (for new functions).get_table_list
renamed to cbs_get_toc
typed
: converted to the numeric representation (was not the case)cbs_add_label_columns
.View
shows the column title.cbs_add_date_column
adds a column with the period converted to Date
or numeric
.version 0.2.3
get_data
(issue #4), suggestion of Jonathan de Bruinversion 0.2.2
httr
: better performance and error handling of failed connections.get_tables_themes
: suggestion of Wietse Dol.