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	copied
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