WP user role to access different partcipants group

Hello,

I want to know if it is possible to have a database with several groups of participants and associated editors. In example, I want to group participants using their “City” field. Then I will create a WordPress user that can have viewing and editing capabilities for each of the cities (but only one of them) and an administrator to access them all.

Example: A workers union wants a website to archive their members in each city, and have an admin for every city. Headquarters can access all.

Thank you for your time!