JSON-stat Command Line Conversion Tools
The JSON-stat Command Line Conversion Tools contain command line tools for converting to and from JSON-stat. They support different JSON flavors, CSV (including CSV-stat) and SDMX-JSON. They are built upon the JSON-stat Javascript Toolkit and the JSON-stat Javascript Utilities Suite.
Installation
npm install -g jsonstat-conv
More in the Installation page.
Available commands
- arrow2jsonstat - converts an Apache Arrow file to JSON-stat
- csv2jsonstat - converts CSV into JSON-stat
- jsonstat2array - converts JSON-stat into an array of arrays
- jsonstat2arrobj - converts JSON-stat into an array of objects
- jsonstat2arrow - converts JSON-stat to the Apache Arrow format
- jsonstat2csv - converts JSON-stat into CSV
- jsonstat2objarr - converts JSON-stat into an object of column-oriented arrays
- jsonstat2object - converts JSON-stat into a DataTable object
- jsonstatdice - creates JSON-stat from JSON-stat
- jsonstatslice (deprecated) - creates JSON-stat from JSON-stat
- sdmx2jsonstat - converts SDMX into JSON-stat
Check the API Reference page for more.
Example
Get unemployment rate time series by country from Eurostat and convert it to CSV.
curl "https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tesem120" -o unr.jsonstat
jsonstat2csv unr.jsonstat unr.csv
Or using the stream interface:
curl "https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tesem120" | jsonstat2csv > unr.csv -t
More in the Examples page.