---
title: "Generic Statistics Estonia table query"
method: GET
path: "/api/v1/statistical-agencies/stat-estonia/data/{table_id}"
tags: ["Statistical Agencies"]
---

# Generic Statistics Estonia table query

`GET /api/v1/statistical-agencies/stat-estonia/data/{table_id}`

Fetch any Statistics Estonia PxWeb table as tidy rows. Supply `path` for the parent folder (e.g. `majandus/hinnad`) and `table_id` (with or without `.px` / `.PX` extension). Sugra builds a minimal PxWeb query that selects the last `last_n` periods on whichever dimension carries time and aggregates over the remaining eliminable dimensions. For complex filters use the convenience endpoints or browse raw upstream.

## Path parameters

- `table_id` string, required — Statistics Estonia table id (with or without `.px` / `.PX` extension).

## Query parameters

- `path` string, required — Slash-separated parent path for the table.
- `last_n` integer — Number of most-recent time periods to return.

## Response `200`

Tidy observation rows for the requested table with Sugra-normalised time.

- EnvelopeStatEstoniaGenericDataPayload
  - `data` StatEstoniaGenericDataPayload, required — Response for the generic `/data/{table_id}` pass-through.
    - `table_id` string, required — Canonical table id.
    - `path` string, required — Full PxWeb table path.
    - `query` object[] — PxWeb query selection actually sent upstream (after Sugra's defaults).
    - `observations` StatEstoniaObservation[] — Tidy observation rows.
      - `period` string, required — Period code. `YYYYMNN` for monthly series (`2026M03`), `YYYYQN` for quarterly (`2025Q3`), or `YYYY` for annual. When the source splits year + quarter or year + month across two dimensions, Sugra combines them before emitting this field.
      - `time` string, nullable — ISO-8601 UTC timestamp for the first day of the period. `null` when the period cannot be mapped to a calendar date.
      - `value` number, nullable — First measure in the row, parsed as float. `null` when the upstream cell is suppressed (`..`) or missing (`.`).
      - `value_raw` string, nullable — Raw value string from PxWeb (useful for debugging).
    - `count` integer, required — Number of observations returned.
    - `metadata` StatEstoniaMetadata — Upstream metadata block with Sugra-normalised `updated`.
      - `updated` string, nullable — Last-updated timestamp for the table, sourced from the parent tree listing (POST responses return a sentinel `9999-12-31` that Sugra discards). Normalised from Europe/Tallinn local time to UTC ISO-8601.
      - `label` string, nullable — Upstream PxWeb label for the table.
      - `source` string, nullable — Attribution string as delivered by Statistics Estonia.
  - `meta` SugraMeta, required — Metadata on a /api/v1/* response envelope built through `helpers.response.sugra_response`, which is how routes are expected to answer. A route that assembles its own `meta` dict carries only the keys it writes itself, so an optional field below can be absent because this response has nothing to report OR because that route does not build its envelope here - the two are not distinguishable from the outside (API-43).
    - `endpoint` string, required — Requested endpoint path.
    - `data_time` string, required — ISO 8601 timestamp the data on this response is stamped with. It is the source's own timestamp whenever the source supplied one this API could read; when it did not, this field falls back to the value of `response_time` and `data_age_days` is omitted, so the PRESENCE of that field is the signal to read - with the one exception named in its own description, a route that substitutes its own current time for a source timestamp it never received. Usually UTC (`Z`), but a source stating its own numeric offset keeps it (2026-04-16T14:30:00+09:00) rather than being converted a second time. For a source that publishes by period this is the period's START (see `period`) and for one that publishes by calendar day it is that day's midnight - in neither case a moment at which anything was observed or released.
    - `response_time` string, required — ISO 8601 UTC timestamp when this response was produced.
    - `provider` string, required — API name and version.
    - `data_age_days` number, nullable — Age of the data in days at the moment this response was produced, i.e. `response_time` minus `data_time`. Present ONLY when the timestamp this response is stamped with is a clock time that could be read as a real instant. It is ABSENT - never 0 - in every other case. Absent when no readable source timestamp was supplied, because `data_time` then repeats `response_time` and a zero age would assert that the data is current precisely where its true age is unknown. Absent when the source names a calendar day, a month, a quarter or a year (see `period`): the instant is then a boundary this API anchored at midnight, and time since a day or a quarter BEGAN is a different quantity from the age of the data - a daily series is out by up to a day, a quarterly one by up to a quarter. A midnight counts as such a boundary whichever zone it is stated in, and whether the source stated it or this API anchored it. The one case this field cannot see is a route that substitutes its own current time for a source timestamp it never received: the substituted value is a real, readable instant and is indistinguishable from one the source stated, so the age reads as roughly 0. The shared cache-and-fetch helper behind most routes stopped doing that (API-43), but the presence of this field is a statement about the timestamp the response carries, not a guarantee about the route that supplied it. Rounded to 0.001 day (86.4 seconds), so 0.0 is a real measured age anywhere within roughly +/-43 seconds and not a stand-in for unknown; a source stamping an instant in the future reports a negative value (-0.001 or less) rather than being clamped. Sources publish on very different cadences, so a non-zero age is normal, not an error. Preserve absence in client code: a generated client that materialises a missing optional number as its numeric default turns 'age unknown' back into 'age zero', which is the exact confusion this field exists to remove.
    - `source` string, nullable — Identifier of the primary upstream source used for this response.
    - `attribution` string, nullable — Human-readable attribution mandated by an upstream source (e.g. a securities regulator or self-regulatory organization). Present only on responses whose source requires the owner and source to be clearly identified. Do not remove or alter it when using the response.
    - `fallback_used` boolean, nullable — True when the primary source failed and a fallback produced the data.
    - `fallback_chain` string[], nullable — Ordered list of sources attempted, in the order they were tried.
    - `cached` boolean, nullable — True when this response was served from the internal cache.
    - `stale` boolean, nullable — True when the cached response was returned after the upstream rate-limited or errored. Clients can use this to detect degraded data.
    - `period` string, nullable — Unit of observation, when the source publishes by period rather than by instant. `data_time` carries the period's START instant so it stays machine-readable; this field preserves what that instant used to mean, which the conversion would otherwise erase. Present only for such sources, and only when the source hands the API the label itself - a client that converts the period to its start instant before building the envelope loses the label, though not the age exclusion, which is decided by the instant. Note that `data_age_days` is omitted whenever this is present, because an age measured from a period start is not a freshness figure.
    - `notes` string, nullable — Data-quality caveat about THIS response - how old the underlying report is, a chokepoint AIS lower-bound, or that a source-reported `data_time` could not be read and the response time is shown instead. Distinct from `attribution`, which is a licensing obligation. Multiple caveats are joined with ' | '. Present only when there is one.

## Other responses

- `401` — Missing or invalid `x-api-key` header. JSON body with a stable `code` distinguishing `missing_api_key` (no header sent) from `invalid_api_key` (header sent, key not accepted); any other 401 source carries the generic `unauthorized` with its detail as `reason`. Plus `hint`. `plan` is always null on 401 - an unauthenticated request has no plan; quota exhaustion is 429, not 401.
- `422` — Validation Error
- `429` — Daily rate limit exceeded. Check `X-RateLimit-Reset` for the next window.
- `503` — Upstream source is temporarily unavailable. Retry after a short delay.

## Changes

- **2026-09-01** `328d061c12ca` — 3 info
  - added the optional property `meta/data_age_days` to the response with the `200` status
  - added the optional property `meta/notes` to the response with the `200` status
  - added the optional property `meta/period` to the response with the `200` status
- **2026-08-08** `4c4530760ba1` — 12 info
  - added the optional property `code` to the response with the `401` status
  - added the optional property `code` to the response with the `429` status
  - added the optional property `code` to the response with the `503` status
  - added the optional property `hint` to the response with the `401` status
  - …8 more

[Change history](https://skmtc.dev/sugra/apis/sugra-api/changes/api/v1/statistical-agencies/stat-estonia/data/:table_id/get.md)

---

[API](https://skmtc.dev/sugra/apis/sugra-api.md) · [All operations](https://skmtc.dev/sugra/apis/sugra-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/sugra/sugra-api/revisions/85caa556892f/schema)