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.

719,554 rowsexport restricted — no row in this table may be redistributed

Sources in this table

metric_daily719,554 rowsrestricted — hover for the licence

active:entity_id = SMH×

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