count(...)
Returns a count of a given set of records
Works with the following datatypes:
This function works with 2.0 and 2.1 endpoint(s). What does this mean? »
The count(...)
function is most commonly used in $select
aggregations to return the count of a set of values. For example, to fetch the total number of employees of the City of Chicago:
https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=count(annual_salary)
It can also be used in $group
aggregations, like this one to get the count of employees by job type: