Have you discovered CAWP? Your best, comprehensive, non partisan resourceful information about Women in US politics. Use their database to identify participation of women at all levels of government, by location and more.
This research group, hosted at Rutgers University, also publishes insightful reports:
https://cawp.rutgers.edu/research-and-scholarship/women-election-2022-marking-midterm-progress
Women in Election 2022: Marking Midterm Progress
by Kelly Dittmar, Ph.D.
Women made gains in representation as a result of the 2022 election, but these gains were more modest and less unbalanced across party lines than in the elections of 2018 and 2020. This report analyzes women’s electoral success in 2022, focusing on the numbers, and puts it into historical context—with special attention to how 2022 compared to the historic elections that preceded it.