Select Code to Download

SELECT state, 
sum(IF(month(identifier)=1,1,0)) as 'Jan',
...
from contacts
WHERE state != ''
GROUP BY state;

+----------+-----+-----+----+-------+
| state    | Jan | Feb | Mar| Total |
...
| TX       |  25 | 20  | 22 |    67 |
+----------+-----+-----+----+-------+

 _  _ _  _  
(_|| | |(_|><
 _|