All Collections
Using the Database
The GovernorHub database site: Database Queries
The GovernorHub database site: Database Queries

How to use database queries to search for governors or governing boards (and other groups) based on chosen filters.

Hannah Goode avatar
Written by Hannah Goode
Updated over a week ago

Searching for governors

To search for governors based on specific filters, click on Query Governors under Database Queries in the left-hand menu. 

There are three types of filters: governor filters, governing board filters and tag filters. 

Use the drop-down menus and check boxes to set as many filters as you want. Some filters (such as tag filters) allow for multiple options to be selected. 

Once you've chosen your filters, click the Run Query button.

The results are displayed in a table below the filters. 

Use the ↓ Spreadsheet link to export the results as an Excel file, the ↓ Address labels link to export the results as a Word document formatted into address labels or the ↓ Addresses as CSV to export the results as a CSV file of addresses.

By default, the results are listed alphabetically by governor name, but you can click on any of the other column headings (Email, Board, Term of Office Start/End, etc) to reorder the results. 

Click on one of the governor's names to see more information, including their contact details and details of the board they are on. 

You can also search through the results to narrow them down further.

Note: the Download as spreadsheet link will always export the full results of the query, even when a search has been applied.

Searching for governing boards and other groups

To search for governing boards and other groups, click on Query Governing Boards under Database Queries in the left-hand menu. 

There are two types of filters: governing board filters and tag filters. 

Use the drop-down menus or check boxes to set as many filters as you want. Some filters (such as tag filters) allow for multiple options to be selected. 

Once you've chosen your filters, click the Run Query button.

The results are displayed in a table below the filters. 

Use the ↓ Spreadsheet link to export the results as an Excel file, or the ↓ Vacancies link to download a report showing the vacancies for all the boards. 

By default, the results are listed alphabetically by governing board name, but you can click on any of the other column headings (Group Type, Clerk, Chair, etc) to reorder the results. 

Click on one of the results to see more information for the board. 

You can also search through the results to narrow them down further.

Note: the Download as spreadsheet link will always export the full results of the query, even when a search has been applied.

Did this answer your question?