Column medicare.qc_enrl_bene.state_count

Overview of column state_count in table medicare.qc_enrl_bene

Table	medicare.qc_enrl_bene
Qualified name	medicare.qc_enrl_bene.state_count
Datatype	string
Column type	computed
Tables, required for computation	[‘medicare._ps’]

Expressions

(
  SELECT COUNT(distinct state)
  FROM medicare._ps AS ps2
  WHERE
    _ps.bene_id = ps2.bene_id
    AND _ps.year = ps2.year
)

Data lineage for column medicare.qc_enrl_bene.state_count