it might look a little daunting if you’ve never used it, but i think it just takes a little getting used to. the link i pointed to earlier provides you provides all the different options that are available, but you don’t have to use them all. in your example, you would just need to specify a project, a date range, date_field = created, and interval = month_of_year.
so for example, if your project ID = 5894 (Mammals of California), and you wanted to see stuff in 2019, that would translate to this request URL: https://api.inaturalist.org/v1/observations/histogram?project_id=5894&created_d1=2019%2F01%2F01%2000%3A00&created_d2=2019%2F12%2F31%2023%3A59&date_field=created&interval=month_of_year, which would provide the following results:
{
"total_results": 12,
"page": 1,
"per_page": 12,
"results": {
"month_of_year": {
"1": 1988,
"2": 1809,
"3": 2581,
"4": 3687,
"5": 3842,
"6": 3263,
"7": 2874,
"8": 2991,
"9": 346,
"10": 0,
"11": 0,
"12": 37
}
}
}
1-12 in the above results translates to January through December. you can even pull these directly into Excel by getting data from a JSON (which is the format of the results that the URL provides).
…
i’m seeing that even though i used a created date range of 2019/01/01 00:00 to 2019/12/31 23:59, i’m getting results in December (12), which should not be the case, since December hasn’t happened yet. so i bet there’s some sort of inconsistency in how it filters dates vs how it reports those dates with respect to time zones. maybe it is taking local and translating to UTC? not sure… i’ll have to look at it later when i have more time…