Derived metrics

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.

698,194 rowsexport restricted — no row in this table may be redistributed

Sources in this table

metric_daily698,194 rowsrestricted — hover for the licence

active:entity_id = SMH×sorted by as_of_date ↑×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 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_attimestamp with time zone