German statistics table by GENESIS code

Fetch any Destatis GENESIS table by its code (five digits, a hyphen, four more), the same code /destatis/search and /destatis/statistics/{code}/tables already hand out. Thirteen curated shortcuts stay on /destatis/{table}. This long-tail route is admission-controlled: one in-flight request per API key, a platform cap of 720 uncached fetches per UTC day (tunable DESTATIS_LONGTAIL_DAILY), and it never waits for the shared GENESIS slot - a busy lane is 429 with Retry-After. A table too large for a direct request is refused with both levers that work: a narrower year window, and a contents slice. Optional classifying is VARIABLE:KEY, e.g. GP19A2:GP19-05, taken from /destatis/variables/{code}/values. Repeat the parameter for more than one variable (five classifying plus one regional). A key that is not in that value list is refused here with HTTP 400 and is never sent upstream: GENESIS answers Status 0 and the whole cube for an invalid classifying key. The answer may be served from cache; a cache hit is free and is not counted against the budget.

Request Code Samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

Responses

🟢200OK

application/json

Tidy observations for the requested GENESIS table.

Bodyapplication/json

Example

{
    "data": {
        "table": "string",
        "genesis_code": "string",
        "title": "string",
        "description": "string",
        "country": "string",
        "start_year": 0,
        "end_year": 0,
        "count": 0,
        "data": [
            {
                "period": "string",
                "period_label": "string",
                "subperiod": "string",
                "measure": "string",
                "measure_code": "string",
                "unit": "string",
                "value": 0,
                "quality": "string",
                "measure_note": "string",
                "variant": 0,
                "dimensions": {
                    "property1": {
                        "property1": "string",
                        "property2": "string"
                    },
                    "property2": {
                        "property1": "string",
                        "property2": "string"
                    }
                },
                "property1": "string",
                "property2": "string"
            }
        ],
        "source": "string",
        "licence": "string",
        "source_note": "string",
        "classifying_requested": [
            {
                "property1": "string",
                "property2": "string"
            }
        ],
        "property1": "string",
        "property2": "string"
    },
    "meta": {
        "endpoint": "/api/v1/fred/us/cpi",
        "data_time": "2026-04-16T14:30:00Z",
        "response_time": "2026-04-16T14:30:12Z",
        "provider": "Sugra API v1.0.1",
        "data_age_days": 0,
        "source": "string",
        "attribution": "string",
        "fallback_used": true,
        "fallback_chain": [
            "string"
        ],
        "cached": true,
        "stale": true,
        "stale_since": "string",
        "period": "string",
        "notes": "string"
    }
}

🟠401Unauthorized

🟠413

🟠422Parameter Error

🟠429

🔴503Service Unavailable