Back

@pypodcats Hi! I would be interested in updating your stats about the Real Python Podcast, and add some commentary. I have made an effort to try to keep a diverse set of guests. I can share some insights from inviting guests and their responses. Let me know @mariatta also if you would like to come on to discuss it.

@pypodcats I was curious what the trend was by year, and this looked accurate to me.

Sharing in case anyone else is curious: https://python-podcast-datasette-8c9c837ad30f.herokuapp.com/python_podcast_datasette?sql=SELECT+%0D%0A++++strftime%28%27%25Y%27%2C+episode_date%29+AS+year%2C%0D%0A++++SUM%28CASE+WHEN+is_woman+%3D+1+THEN+1+ELSE+0+END%29+as+woman_count%2C%0D%0A++++SUM%28CASE+WHEN+is_woman+%3D+0+THEN+1+ELSE+0+END%29+as+non_woman_count%2C%0D%0A++++ROUND%28%28CAST%28SUM%28CASE+WHEN+is_woman+%3D+1+THEN+1+ELSE+0+END%29+AS+REAL%29+%2F+%28SUM%28CASE+WHEN+is_woman+%3D+1+THEN+1+ELSE+0+END%29+%2B+SUM%28CASE+WHEN+is_woman+%3D+0+THEN+1+ELSE+0+END%29%29%29+*+100%2C+2%29+as+woman_percentage%0D%0AFROM+podcast_guests%0D%0AGROUP+BY+strftime%28%27%25Y%27%2C+episode_date%29%0D%0AORDER+BY+year+DESC%3B%0D%0A