...
| Info | ||||
|---|---|---|---|---|
| ||||
It is strongly recommended to read through the introduction of the JSON-stat toolkit by its author |
Short word about JSON-statJSON-stat.org describe the format that is a simple lightweight JSON dissemination format best suited for data visualisation, mobile apps or open data initiatives.
...
For further usage details of the toolkit, please consult the or the README of the jsonstat-toolkit
...
Then the dimensional structure of the dataset is summarized summarised in two arrays indicating the code and size of each dimension used by the dataset.
We can observe that the GEO dimension is quite large (2031 positions) as this dataset is a one of Eurostat's regional datasets, meaning that it contains statistical data for countries and their subdivision in statistical regions also called NUTS regison regions (see more information on NUTS classification)
| Code Block |
|---|
"id":[ : ["freq", "unit", "geo", "time" ], "size": [ 1, 1, 2031, 33 ], |
Dimension metadata : index and label
The dimension object in the response contains for each uses dimension code an object as keys to references objects with its title and for each position (called category in JSON-stat) a list of key-value pair of its code and their corresponding order and a key-value pair of its code and corresponding label.
| Code Block |
|---|
"dimension":{
"freq":{
"label":"Time frequency",
"category":{
"index":{
"A":0
},
"label":{
"A":"Annual"
}
}
},
[...] |
...
Filtering on geoLevel
As the above regional dataset have more than 2000 positions for the GEO dimension and is a regional dataset, it is interesting to make use of the special filter geoLevel to help retireving retrieving content for a specific NUTS levelFollowing . Following table list the filter value and example for possible value of this filter with example on DEMO_R_D3DENS dataset.
| Value | Description | ||
|---|---|---|---|
| aggregate | filter GEO dimension on European aggregates based on a white list - (EU15, EU25, EU27_2007, EU27_2019, EU28, EA19, etc.)
| ||
| country | filter GEO dimension on country code (EU Member States, or EFTA, or Candidate Countries or other countries)
| ||
| nuts1 | NUTS code level 1: filter GEO dimension on level-1 NUTS codes (major socio-economic regions)
| ||
| nuts2 | filter GEO dimension on level-2 NUTS code level 2: (basic regions for the application of regional policies)
| ||
| nuts3 | filter GEO dimension on level-3 NUTS code level 3: (small regions for specific diagnoses )
|
...
It is possible to restrict the response to a specific time value values or time value a range of values.
| Value | Description | ||||
|---|---|---|---|---|---|
time=YYYY or time_period=YYYY | Filter TIME dimension on a one or more specific time value values (ie. time=2020)
| ||||
| sinceTimePeriod=YYYY | Filter TIME dimension on all time values since the specified value included (i.e for example sinceTimePeriod=2020 means "all time values since 2020, 2020 included")
| ||||
| untilTimePeriod=YYYY | Filter TIME dimension on all time values until the specified value included (i.e for example untilTimePeriod=2010 2000 means "all time values until 2000, 2000 included")
| ||||
sinceTimePeriod=YYYY AND untilTimePeriod=YYYY | Both filter above can be combined Filter TIME dimension by combining both above filters to define a FROM-TO range (i.e for example sinceTimePeriod=2010&untilTimePeriod=2020 means "all time values from 2010 to 2020, both ends included")
| ||||
| lastTimePeriod=N | This fitler allows Filter TIME dimension to always retrieve the N latest positions for TIME dimension (i.e for example lastTimePeriod=1 means 'most recent data" or lastTimePeriod=3 means "last 3 positions")
|
...
For example to retrieve only EU27 data for 2022 from of our example dataset, the following query should be used
...
From Eurostat query builder
Eurostat continue to provide website include a Query Builder on its website.
From Eurostat Databrowser
The advanced menu for download in DataBrowser is providing a query based on the currently visualized visualised data if you open the menu via Download > Options and other formats and then select the following options in below table (as shown in below screenshot
)
| File format | JSON-stat (.json) |
| Data scope | Data on this page only |
| Endpoint | JSON |
| Section | ||||
|---|---|---|---|---|
|
From JSON-stat community
JSON-stat community is maintaining a showcase on Eurostat data that could also be used as a query builder or a data previewer
...