New general JSON-stat viewer

[Xavier Badosa]

The  Statistical Institute of Catalonia (Idescat) has a JSON-stat API 

https://www.idescat.cat/dev/api/taules/?lang=en

that uses JSON-stat collections to expose the available statistics and datasets, JSON-stat empty datasets to expose metadata and JSON-stat datasets to expose data.

As a consequence, it is possible to discover all the API calls starting from a single end-point:

https://api.idescat.cat/taules/v2?lang=en

To link metadata (empty datasets) with data (datasets) the API uses the describes/describedby properties.

To expose corrections, it uses the monitor property.

Idescat's API uses an extension to describe statuses in a similar way to Eurostat's API.

Idescat has also developed a JSON-stat API viewer. This viewer is a simplified version of Idescat's table editor. It's a general JSON-stat viewer that can accept any JSON-stat response. This viewer supports GET and POST requests. It allows users to design a customized table from a JSON-stat dataset and download it as a spreadsheet.

The JSON-stat viewer accepts any valid JSON-stat response of any kind (collections, datasets, v1 bundles) and, for example, can be used to browse Idescat's API

https://www.idescat.cat/dev/api/taules/visor/?u=https%3A%2F%2Fapi.idescat.cat%2Ftaules%2Fv2%3Flang%3Den&lang=en

but can also be used to view any dataset (or collection or bundle) from any provider that supports JSON-stat (v1 or v2).

Examples:

Eurostat (JSON-stat v2): Unemployment rates by sex and country of birth (%)

https://www.idescat.cat/dev/api/taules/visor/?u=https%3A%2F%2Fec.europa.eu%2Feurostat%2Fapi%2Fdissemination%2Fstatistics%2F1.0%2Fdata%2Flfsa_urgacob%3Fformat%3DJSON%26lang%3Den%26freq%3DA%26unit%3DPC%26sex%3DT%26sex%3DM%26sex%3DF%26age%3DY15-64%26c_birth%3DEU27_2020_FOR%26c_birth%3DNEU27_2020_FOR%26c_birth%3DFOR%26c_birth%3DNAT%26c_birth%3DTOTAL%26geo%3DEU27_2020%26geo%3DEA20%26time%3D2020%26time%3D2021%26time%3D2022%26time%3D2023&lang=en&hist=%5Ec%3D5%2Fr%3D4%2Ft%3D2%2C0%3B-4c%3B-5c%3B6%2C3

Statistics Norway (JSON-stat v1): Labor Force. Age / Sex

https://www.idescat.cat/dev/api/taules/visor/?u=https%3A%2F%2Fdata.ssb.no%2Fapi%2Fv0%2Fdataset%2F1054.json%3Flang%3Den&lang=en&hist=%5Ec%3D0%2Fr%3D1%2Ft%3D4%2C3%3B3d%2C218%3B-0c%3B-1c%3B2%2C3

Ireland's Central Statistics Office (JSON-stat v2 with unit information -currently the viewer only uses the number of decimals information-): ILO Participation, Employment and Unemployment Characteristics

https://www.idescat.cat/dev/api/taules/visor/?u=https%3A%2F%2Fws.cso.ie%2Fpublic%2Fapi.restful%2FPxStat.Data.Cube_API.ReadDataset%2FQLF18%2FJSON-stat%2F2.0%2Fen&q=&lang=en

Any feedback is welcome.

Xavier