Here is an excerpt from the database I've been working on:
Interesting. I've actually been doing something similar for a few years. I'm planning to eventually make a dynamic mating chart, much nicer than what we have now. I've been scouring the internet for any website with reports of alate/dealate sightings.
Here's what I have for TX in order by month. I omitted some of the columns.
Species Year Month State City/Locale
Solenopsis invicta 2015 1 TX Austin
Nylanderia terricola 2016 2 TX El Paso
Solenopsis invicta 2015 2 TX Austin
Camponotus americanus 2011 3 TX Arlington
Camponotus americanus 2011 3 TX Houston
Camponotus americanus 2012 3 TX Nacogdoches County
Camponotus sp. 2011 3 TX Houston
Camponotus sp. 2015 3 TX Austin
Myrmecocystus sp. 2015 3 TX
Neivamyrmex swainsonii 2013 3 TX Schulenburg
Pheidole sp. 2015 3 TX Austin
Pseudomyrmex gracilis 2009 3 TX San Antonio
Pseudomyrmex gracilis 2015 3 TX Austin
Solenopsis invicta 2015 3 TX Austin
Atta texana 2015 4 TX Corpus Christi
Camponotus americanus 2012 4 TX Travis County
Camponotus pennsylvanicus 2010 4 TX Houston
Camponotus pennsylvanicus 2015 4 TX Weatherford
Camponotus sansabeanus 2015 4 TX Austin
Camponotus sp. 2015 4 TX Austin
Camponotus sp. 2015 4 TX San Antonio
Solenopsis invicta 2009 4 TX Beaumont
Solenopsis invicta 2015 4 TX Austin
Atta texana 2006 5 TX Houston
Atta texana 2006 5 TX Vidor
Atta texana 2006 5 TX Corpus Christi
Atta texana 2012 5 TX Henderson
Atta texana 2013 5 TX Austin
Atta texana 2014 5 TX Austin
Brachymyrmex patagonicus 2014 5 TX Austin
Brachymyrmex patagonicus 2015 5 TX Austin
Brachymyrmex patagonicus 2015 5 TX Austin
Camponotus castaneus 2012 5 TX Humble
Camponotus decipiens 2013 5 TX Desoto
Dolopomyrmex pilatus 2014 5 TX Amarillo
Myrmecocystus sp. 2012 5 TX Panhandle
Pheidole sp. 2014 5 TX Austin
Pheidole sp. 2014 5 TX Austin
Pseudomyrmex caeciliae 2015 5 TX Laredo
Pseudomyrmex gracilis 2009 5 TX San Antonio
Solenopsis geminata 2014 5 TX Austin
Solenopsis invicta 2014 5 TX Killeen
Solenopsis invicta 2014 5 TX Austin
Solenopsis invicta 2015 5 TX Houston
Solenopsis invicta 2015 5 TX Austin
Solenopsis invicta 2015 5 TX Austin
Solenopsis invicta 2015 5 TX Lubbock
Solenopsis invicta 2015 5 TX Lubbock
Solenopsis invicta 2015 5 TX Austin
Solenopsis sp. 2015 5 TX Austin
Solenopsis sp. 2015 5 TX Austin
Aphaenogaster texana 2013 6 TX Fort Worth
Atta texana 2011 6 TX Missouri City
Atta texana 2012 6 TX Houston
Atta texana 2013 6 TX humble
Brachymyrmex patagonicus 2014 6 TX Victoria
Formica pallidefulva 2013 6 TX Cedar Hill
Leptogenys elongata 2006 6 TX Kerrville
Nylanderia terricola 2015 6 TX Murphy
Nylanderia vividula 2014 6 TX Austin
Pogonomyrmex barbatus 2014 6 TX Comstock
Pogonomyrmex barbatus 2015 6 TX Lubbock
Pseudomyrmex gracilis 2014 6 TX Austin
Pseudomyrmex gracilis 2015 6 TX Austin
Solenopsis invicta 2015 6 TX Lubbock
Solenopsis invicta 2015 6 TX Lubbock
Solenopsis invicta 2015 6 TX Lubbock
Solenopsis invicta 2015 6 TX Lubbock
Solenopsis invicta 2015 6 TX Lubbock
Camponotus impressus 2010 7 TX Paris
Nylanderia vividula 2009 7 TX Sugar Land
Pogonomyrmex barbatus 2015 7 TX Lubbock
Pogonomyrmex rugosus 2011 7 TX Panhandle
Pogonomyrmex sp. 2014 7 TX Western
Pseudomyrmex gracilis 2009 7 TX Austin
Solenopsis invicta 2015 7 TX Lubbock
Solenopsis invicta 2015 7 TX Lubbock
Brachymyrmex depilis 2015 8 TX Lubbock
Forelius pruinosus 2015 8 TX Lubbock
Leptogenys elongata 2014 8 TX Austin
Pogonomyrmex barbatus 2015 8 TX Katy
Pogonomyrmex barbatus 2015 8 TX Lubbock
Pogonomyrmex barbatus 2015 8 TX Weatherford
Pseudomyrmex gracilis 2008 8 TX San Antonio
Solenopsis invicta 2015 8 TX Lubbock
Solenopsis invicta 2015 8 TX Lubbock
Solenopsis molesta 2015 8 TX Lubbock
Crematogaster ashmeadi 2014 9 TX Karnack
Crematogaster sp. 2015 9 TX Lubbock
Brachymyrmex depilis 2013 10 TX Collin County
Brachymyrmex patagonicus 2014 10 TX Houston
Myrmecina americana 2012 10 TX Frisco
Pseudomyrmex gracilis 2008 11 TX San Antonio