Help with Using GrantNav
- How does the GrantNav search box work?
- How do the GrantNav filters work?
- Additional data and GrantNav
- What is covered in the GrantNav export files?
- Advanced search
How does the GrantNav search box work?
GrantNav provides a freetext search box which allows you to explore the data. There are three search patterns to choose from and these work in the following ways:
See Advanced search for additional ways to search the data held in GrantNav.
How do the GrantNav filters work?
GrantNav has filters which appear on the left hand side of the search results. These work in relation to certain fields in the 360Giving Standard in the following ways:
Additional data and GrantNav
GrantNav uses grants data that is being published to the 360Giving Standard. It is updated on a monthly basis. When the data is imported, we undertake two processes that mean we can provide additional data.
GrantNav and location data
When we import this data, we look at the Location information associated with the Recipient Organisation. This data can vary across publishers.
When a Recipient Org:Postal Code is provided
We use the postcode to add Ward, District and Region codes to the data. This is used in the relevant filters in GrantNav, and also Ward, District and Region names are included in the download files.
When a Recipient Org:Postal Code is missing
If other types of administrative geography are included in the data (such as District or Ward codes) then we attempt to match it to relevant areas. Again, these are used in the filters and the names and codes are included in the download files.
GrantNav and charity names
It’s useful for people to see multiple grants associated with a single organisation together in GrantNav. To do this, we rely on publishers including the relevant company, charity or other registration number in the Recipient Org:Identifier field.
When we import data into GrantNav, we aim to match these identifiers, in order to provide pages that bring together grants from different publishers, even if they spell the recipient names differently.
When we undertook research to do this, we found that quite often registered charities were given different names by various publishers. Even if the Recipient Org:Identifier reference were the exact same, the name given was often different, e.g. “Salford Lads Club” vs “Salford Lads & Girls Club”.
In order to help users, we therefore utilise the data available from the Charity Commission for England and Wales. We look for the official name on this register. With this, we populate the Recipient Org:Name field, which in turn is used in the relevant filter on GrantNav. However, we also maintain the original name from the publisher, and use that in the grant page and freetext search.
What is covered in the GrantNav export files?
Data can be exported from GrantNav searches, and from views of funders and recipients, in either CSV or JSON formats. You can also download the whole data set used in GrantNav.
Exporting from a search
When you export data from a GrantNav search the data provided uses the same field names as the 360Giving Standard. This is provided in a single file - in the case of the CSV file there will be multiple columns for fields that may have more than one value for some grants, such as geographic terms. Please note that not all fields in the 360Giving Standard are included in the GrantNav export files.
The following fields are not in the 360Giving Standard and are added to the export data by GrantNav:
Exporting from the funders and recipients pages
Data downloaded from the funders and recipients pages are different from the search results and grants view downloads as they contain only the details seen on screen, plus an extra column with the funder or recipient identifiers.
In addition to the freetext search, there are many ways you can search the data on this site and target your search with more specific controls.
Words and phrases
- A single word: e.g.
- Multiple words: e.g.
young people gardens(each word does not necessarily have to be present)
- Require each word to be found: e.g.
young AND people
- An exact phrase by enclosing it in quotes: e.g.
- Exclude results that contain a word: e.g.
youth NOT clubs
Using the above you can effectively filter the records to a single publisher or an exact grant. Try:
- Search words and phrases limited to a specific field, for example:
title:gardenswill search the "title" field for the word "gardens"
recipientOrganization.postalCode:NW1will search the for recipients within the "NW1" postcode district (where the field is populated)
fundingOrganization.name:"London Councils"will search the "Funding Organisation:Name" field for "London Councils"
The field names used must match the machine-readable field names in the data. You can find a list of field names in use on the stats page.
Search for grants in a given date range:
- Planned start date in 2012: e.g.
plannedDates.startDate:[2012-01-01 TO 2012-12-31]
Planned start date in 2012 and planned end date in 2014: e.g.
plannedDates.startDate:[2012-01-01 TO 2012-12-31] AND plannedDates.endDate:[2014-01-01 TO 2014-12-31]
In addition to using the filters on results, you can also search for grants by amount (awarded, applied for etc.) within a specific range:
- Amount Awarded between £0 and £150: e.g.
amountAwarded:[0 TO 150]
- Amount Applied For between £800 and £1000: e.g.
amountAppliedFor:[800 TO 1000]
You can also search ranges with one side unbounded:
amountAwarded:>1000(more than 1000)
amountAwarded:>=1000(more than or equal to 1000)
amountAppliedFor:<1000(less than 1000)
amountAppliedFor:<=1000(less than or equal to 1000)
You can also use the * wildcard (see below) when asking for a range: e.g.
amountAwarded:[500 TO *]