query_table

io.github.pipeworx-io/statfin-fi · Verify this server

Get an actual figure out of a Statistics Finland (StatFin) table of Finnish official statistics — how many Finns hold a tertiary qualification, the current consumer price index, births and deaths, employment, and the rest of the Tilastokeskus catalogue. path is "folder/table.px" using the bare 4-character table id (e.g. "vkour/15ig.px", "khi/11xs.px"); the longer "statfin_<folder>_pxt_<id>.px" form found in older StatFin docs was retired upstream and is rewritten to the current form for you. Answers in ONE call: pass `select` with plain-English labels from the question — {"Information": "tertiary level qualification"} against "vkour/15ig.px" returns the 1,672,232 Finns who hold one — and this pack resolves them against the table's own metadata, defaults the year to the latest published and every other breakdown to its total, and reports each of those choices back in `selection_resolved` alongside a flattened `figures` list. `select` keys and values may be either the English label or the native Finnish code ("contentscode", "kaste5T8"). Pass `body` instead for a raw PxWeb query object when you already know the codes.