Production environment diagnostics
Verifies source availability, schema discovery, year coverage, country count, and a latest-year query against the live endpoints.
Functional DuckDB queries run first against Hugging Face over HTTP range requests. The uncached raw HTTP probe runs afterward so diagnostics do not consume rate-limit budget ahead of the application query.
Fragile States Index
through-2024 · annual · declared coverage 2006-2024
- Schema columns
- No data
- Years discovered
- No data
- Countries
- No data
- Latest year
- No data
- Rows, latest year
- No data
- Missing values
- No data
- Genuine zeros
- No data
- First query
- No data
- Repeat query
- No data
- Schema discovery
- No data
- HTTP probe status
- No data
- Accept-Ranges
- No data
- TTFB
- No data
- Parquet magic
- No data
- Response bytes
- No data
- Range requests
- No data
- Logical file size
- No data
- Read fraction
- No data
- Transfer encoding
- No data
- Footer probe bytes
- No data
How calculated
Year expression: TRY_CAST(SPLIT_PART("Year", '/', 3) AS INTEGER)
Country key: ISO 3166-1 Code (ISO3 present)
Direction: higher-worse
Bertelsmann Transformation Index
2026 (editions 2006-2026) · biennial · declared coverage 2006-2026
- Schema columns
- No data
- Years discovered
- No data
- Countries
- No data
- Latest year
- No data
- Rows, latest year
- No data
- Missing values
- No data
- Genuine zeros
- No data
- First query
- No data
- Repeat query
- No data
- Schema discovery
- No data
- HTTP probe status
- No data
- Accept-Ranges
- No data
- TTFB
- No data
- Parquet magic
- No data
- Response bytes
- No data
- Range requests
- No data
- Logical file size
- No data
- Read fraction
- No data
- Transfer encoding
- No data
- Footer probe bytes
- No data
How calculated
Year expression: TRY_CAST(SPLIT_PART("Year", '/', 3) AS INTEGER)
Country key: Country (name only, resolved via crosswalk)
Direction: higher-better
Varieties of Democracy
v16 · annual · declared coverage 1789-2025
- Schema columns
- No data
- Years discovered
- No data
- Countries
- No data
- Latest year
- No data
- Rows, latest year
- No data
- Missing values
- No data
- Genuine zeros
- No data
- First query
- No data
- Repeat query
- No data
- Schema discovery
- No data
- HTTP probe status
- No data
- Accept-Ranges
- No data
- TTFB
- No data
- Parquet magic
- No data
- Response bytes
- No data
- Range requests
- No data
- Logical file size
- No data
- Read fraction
- No data
- Transfer encoding
- No data
- Footer probe bytes
- No data
How calculated
Year expression: TRY_CAST("year" AS INTEGER)
Country key: country_text_id (ISO3 present)
Direction: variable-specific
Country crosswalk
ISO3 canonical join key with UN M49 regions. Generated by tools/build_crosswalk.py.
How calculated
Crosswalk not loaded.
Time mode availability
Section 4.3. Common-year mode requires an observation year present in every selected source.
Shared years across all three sources: 2006, 2008, 2010, 2012, 2014, 2016, 2018, 2020, 2022, 2024
Default common year: 2024present in all three sources
How calculated
Computed from each source's declared cadence and coverage in the data catalog. BTI is biennial, so odd years are never shared. Cross-provider correlation is disabled outside these years rather than silently comparing mismatched years.