City employee pay statistics
get_city_salary_statsRetrieve salary statistics for City of Charlotte employees, including head count and annual pay rates, aggregated by department or job title for any quarter.
Instructions
Pay statistics for City of Charlotte employees: head count and annual pay rates.
Aggregated by department or job title for one quarter (the latest by default); individual employees are not listed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | ||
| limit | No | ||
| quarter | No | ||
| group_by | No | department | |
| job_title | No | Partial match, e.g. 'Fire Fighter' or 'Captain'. | |
| department | No | Partial match on abbreviated department names, e.g. 'CFD' (Fire), 'CMPD' (Police), 'CDOT', 'CATS', 'Charlotte Water'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| year | Yes | ||
| notes | Yes | ||
| filters | Yes | ||
| overall | Yes | ||
| quarter | Yes | ||
| group_by | Yes |