Price data health

Review query

For the person doing the review. It lists rows in the order above; the update is a template to fill with the reviewed figure, the date the evidence describes and the citation.

-- Floral stems: what needs evidence
select id, name, stem_cost_low, stem_cost_high, priced_as_of, reviewed_at,
       source_type, source_reference, market, region
  from floral_stem
 where active
 order by priced_as_of nulls first, id;

-- Budget benchmarks: what needs evidence
select id, share_low_bps, share_mid_bps, share_high_bps, priced_as_of, reviewed_at,
       source_type, source_reference, market, region
  from budget_benchmark
 order by priced_as_of nulls first, id;

-- After checking one row against its source (substitute real values):
-- update floral_stem
--    set stem_cost_low = <reviewed>, stem_cost_high = <reviewed>,
--        priced_as_of = '<date the evidence describes>',
--        reviewed_at = '<date you checked it>',
--        source_type = 'supplier-quote', source_reference = '<citation>'
--  where id = '<id>';