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,200 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 | 2022-03-03 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-03-02 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-03-01 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-28 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-25 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-24 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-23 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-22 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-18 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-17 | 3.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-16 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-15 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-14 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-11 | 3.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-10 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-09 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-08 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-07 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-04 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-03 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-02 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-02-01 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-31 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-28 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-27 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-26 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-25 | 4.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-24 | 2.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-21 | 3.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-20 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-19 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-18 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-14 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-13 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-12 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-11 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-10 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-07 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-06 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-05 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-04 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2022-01-03 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-31 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-30 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-29 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-28 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-27 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-23 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-22 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-12-21 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |