How to group and count JSON data with jq — group_by

How many users per city? Group the rows, then count each group.

Every filter was executed against the cheatsheet's sample config.json with jq 1.7 before publishing; the sample file sits at the bottom of the cheatsheet so you can reproduce every output.

jq -c '.users | group_by(.city) | map({city: .[0].city, count: length})' config.json
# output: [{"city":"lisboa","count":1},{"city":"madrid","count":2}]

jq Cheatsheet one-page card — 30 filters that actually work — The full one-page card — jq Cheatsheet. Get the complete cheatsheet on GitHub