The R client for the Finnish Customs (Tulli) database Uljas. See: https://tulli.fi/en/statistics/uljas-api
You can install the uljas from github with:
# install.packages("devtools")
devtools::install_github("jhuovari/uljas")Statistics present in the database.
library(uljas)
stats <- uljas_stats(lang = "en")
knitr::kable(stats)| ifile | title | utime |
|---|---|---|
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/01 CN/ULJAS_CN | CN, CC BY 4.0 | 26.6.2020 8.14.01 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/01 CN/VANHAKK_CN | CN / HS, CC BY 4.0 | 6.2.2020 19.48.03 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/02 SITC/ULJAS_SITC | SITC rev4, CC BY 4.0 | 26.6.2020 8.19.19 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/02 SITC/VANHAKK_SITC | SITC rev3, CC BY 4.0 | 6.2.2020 19.48.32 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/03 CPA/ULJAS_CPA2008 | CPA2008, CC BY 4.0 | 26.6.2020 8.22.16 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/03 CPA/VANHAULJAS_CPA2002 | CPA2002, CC BY 4.0 | 6.2.2020 19.49.16 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/04 TOL/ULJAS_TOL | NACE 2008, CC BY 4.0 | 26.6.2020 8.23.33 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/05 BEC/ULJAS_BEC | BEC, CC BY 4.0 | 26.6.2020 11.13.24 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/06 KAUPPATASE/ULJAS_KAUPPATASE | TRADE BALANCE, CC BY 4.0 | 26.6.2020 8.23.34 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/06 KAUPPATASE/ULJAS_KAUPPATASE_VIEW | TRADE BALANCE, CC BY 4.0 | 26.6.2020 8.22.16 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/09 INDEKSIT/ULJAS_INDEKSIT | INDEXES OF FOREIGN TRADE, CC BY 4.0 | 26.6.2020 8.19.09 |
| /DATABASE/01 ULKOMAANKAUPPATILASTOT/10 ENNAKKO/ULJAS_ENNAKKO | PRELIMINARY STATISTICS, CC BY 4.0 | 8.7.2020 13.06.24 |
| /DATABASE/02 LOGISTIIKKATILASTOT/07 KULJETUSMUOTO/ULJAS_KTAPA | SITC AND MODE OF TRANSPORT, CC BY 4.0 | 26.6.2020 8.25.44 |
| /DATABASE/02 LOGISTIIKKATILASTOT/07 KULJETUSMUOTO/ULJAS_ULKOKONTTI | CONTAINER TRANSPORT OF EXTERNAL TRADE, CC BY 4.0 | 26.6.2020 8.26.04 |
| /DATABASE/02 LOGISTIIKKATILASTOT/08_TRANSITO/ULJAS_TRANSITO | TRANSIT TRANSPORTS, CC BY 4.0 | 22.6.2020 15.31.02 |
| /DATABASE/02 LOGISTIIKKATILASTOT/09 RAJALIIKENNE/ULJAS_RAJALIIKENNE | BORDER TRAFFIC, CC BY 4.0 | 23.6.2020 15.10.56 |
| /DATABASE/03 VERO- JA KANTOTILASTOT/11 TULLINKANTO/ULJAS_tullinkanto | State revenue debited by Finnish Customs, CC BY 4.0 | 28.5.2020 10.15.49 |
uljas_dims return dimensions that are available for a certain
statistics. Use ifile from uljas_stats.
sitc_dims <- uljas_dims(ifile = "/DATABASE/01 ULKOMAANKAUPPATILASTOT/02 SITC/ULJAS_SITC")
str(sitc_dims)
#> List of 5
#> $ Classification of Products SITC:'data.frame': 10 obs. of 4 variables:
#> ..$ label: chr [1:10] "Classification of Products SITC" "Classification of Products SITC5" "Classification of Products SITC4" "Classification of Products SITC3" ...
#> ..$ elim : chr [1:10] "N" "N" "N" "N" ...
#> ..$ size : int [1:10] 4336 2972 1025 264 68 11 78 341 1365 49
#> ..$ show : chr [1:10] "T" "CT" "CT" "CT" ...
#> $ Time period :'data.frame': 3 obs. of 4 variables:
#> ..$ label: chr [1:3] "Time period" "Quarter" "Year"
#> ..$ elim : chr [1:3] "N" "N" "N"
#> ..$ size : int [1:3] 220 488 122
#> ..$ show : chr [1:3] "T" "T" "T"
#> $ Country :'data.frame': 27 obs. of 4 variables:
#> ..$ label: chr [1:27] "Country" "Continent" "Continent - Europe by countries" "Continent - North Africa by countries" ...
#> ..$ elim : chr [1:27] "N" "N" "N" "N" ...
#> ..$ size : int [1:27] 252 10 59 10 54 19 35 6 36 15 ...
#> ..$ show : chr [1:27] "T" "CT" "CT" "CT" ...
#> $ Flow :'data.frame': 1 obs. of 4 variables:
#> ..$ label: chr "Flow"
#> ..$ elim : chr "N"
#> ..$ size : int 3
#> ..$ show : chr "T"
#> $ Indicators :'data.frame': 1 obs. of 4 variables:
#> ..$ label: chr "Indicators"
#> ..$ elim : chr "N"
#> ..$ size : int 16
#> ..$ show : chr "T"uljas_class returns values in the classification (specified with class
parameter) for statistics (specified with ifile parameter). Also all (in
main classifications) with class = NULL.
sitc_dims$`Classification of Products SITC`$label
#> [1] "Classification of Products SITC"
#> [2] "Classification of Products SITC5"
#> [3] "Classification of Products SITC4"
#> [4] "Classification of Products SITC3"
#> [5] "Classification of Products SITC2"
#> [6] "Classification of Products SITC1"
#> [7] "Classification of Products SITC1+2"
#> [8] "Classification of Products SITC1+2+3"
#> [9] "Classification of Products SITC1+2+3+4"
#> [10] "SITC Products"
sitc_class <- uljas_class(ifile = "/DATABASE/01 ULKOMAANKAUPPATILASTOT/02 SITC/ULJAS_SITC", class = "SITC Products")
# sitc_class_all <- uljas_class(ifile = "/DATABASE/01 ULKOMAANKAUPPATILASTOT/02 SITC/ULJAS_SITC", class = NULL)
str(sitc_class)
#> List of 1
#> $ SITC Products:'data.frame': 49 obs. of 2 variables:
#> ..$ code: chr [1:49] "" "0" "02" "05" ...
#> ..$ text: chr [1:49] "Total" "Food and live animals" "Dairy products and birds' eggs" "Vegetables and fruit" ...uljas_data returns the data for class value combinations from a
statistics (specified with ifile parameter).
sitc_query <- list(`SITC Products` = c("0" , "02"), `Time Period` = "=ALL", Flow = 1, Country = "AT", Indicators = "V1")
sitc_data <- uljas_data(ifile = "/DATABASE/01 ULKOMAANKAUPPATILASTOT/02 SITC/ULJAS_SITC", classifiers = sitc_query)
head(sitc_data)
#> # A tibble: 6 x 5
#> `SITC Products` `Time Period` Flow Country values
#> <chr> <chr> <chr> <chr> <int>
#> 1 0 Food and live ani~ 202004 Imports by countrie~ AT (2002--.) A~ 2.25e6
#> 2 0 Food and live ani~ 202003 Imports by countrie~ AT (2002--.) A~ 3.03e6
#> 3 0 Food and live ani~ 202002 Imports by countrie~ AT (2002--.) A~ 4.36e6
#> 4 0 Food and live ani~ 202001 Imports by countrie~ AT (2002--.) A~ 1.83e6
#> 5 0 Food and live ani~ 201912 Imports by countrie~ AT (2002--.) A~ 2.02e6
#> 6 0 Food and live ani~ 201911 Imports by countrie~ AT (2002--.) A~ 1.68e6An individual request return is limited to 50 000 cells.