core.metric_daily
Derived from the tables above via the registry in app/core/metrics.py. Export is decided per METRIC here, not per source - see core.metric_registry.
metric_daily723,100 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 1,250 in a heap (the page LIMIT), under a 5s statement timeout.
| metric_idtext | entity_idtext | as_of_date ↓date | valuenumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_at |
|---|
| regime_code | US | 2021-12-20 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-17 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-16 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-15 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-14 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-13 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-10 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-09 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-08 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-07 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-06 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-03 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-02 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-01 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-30 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-29 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-26 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-24 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-23 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-22 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-19 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-18 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-17 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-16 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-15 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-12 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-11 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-10 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-09 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-08 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-05 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-04 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-03 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-02 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-11-01 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-29 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-28 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-27 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-26 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-25 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-22 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-21 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-20 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-19 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-18 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-15 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-14 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-13 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-12 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-11 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |