i’m assuming that you’re trying to use annotations. i think i read somewhere that they purposely don’t include annotations in the CSV because of the way the data is stored. (it’s not just male or female. it’s also potentially someone agreeing or disagreeing with the original annotation.) that said, you could extract the data in a few ways, i think:
- if you want to get the observation details, then even though the CSV won’t include annotation data, you can query by annotation fields. see https://forum.inaturalist.org/t/annotation-filter-is-missing/2677. so instead of pulling back, say, all fox squirrels with a field that says male or female, i think you could do this as 3 different queries – one for all fox squirrels, one for female fox squirrels, and one for male fox squirrels.
- if you don’t have a lot of species to look at and don’t need super-precise figures, you could just look at the taxon page. there’s a graph shows you seasonality by default but can also give you seasonality by sex.
- similar to #2, you could get the actual numbers that make up the graphs (and add additional filters) by using the API (https://api.inaturalist.org/v1/docs/#!/Observations/get_observations_histogram, https://api.inaturalist.org/v1/docs/#!/Observations/get_observations_popular_field_values).
- similar to #3 + #1, if you just care about totals (not about individual observations), you could use the API to get, say, the total number of female fox squirrels. see https://api.inaturalist.org/v1/docs/#!/Observations/get_observations, and just pull back the first record (page = 1, per page = 1, only id = true) for a given taxon (+sex), and the result set will also include a total count (even though you’re just pulling back the first record in the set).