Column medicare._enrollments.state_count

Overview of column state_count in table medicare._enrollments

Table	medicare._enrollments
Qualified name	medicare._enrollments.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._enrollments.state_count