sub number_members_for_year_for_state {
  my $self = shift;
  my $year = shift;
  my $state = shift;

  my $col = 'members';
  my $table = 'lm_data';
  my $criteria = {state => $state, year => $year, and => {or => {desig_name => ['LU', 'LLG', 'CH', 'BR', 'LG', 'SLG', 'UNIT', 'LDIV']}}};

  my $result = $self->data->sum_column($col, $table, $criteria);
  return $result->[0][0];
}