Help with using GrantNav
GrantNav is a search-engine for grants data that is published by funders in the 360Giving Data Standard. You can use the search results to see summary statistics or browse through the different grants, and click through to explore the data in more detail. GrantNav is not a visualisation tool nor a map, but does help you obtain the data you need for further analysis. This page will help you to get the most out of GrantNav.
Search
Results
- How do the GrantNav filters work?
- Why can't I find results that I know should match the search criteria?
- How can I give feedback on data in GrantNav?
- Why do some grants show an award of £0?
Data In GrantNav
- Why do GrantNav filters show recipient rather than beneficiary location?
- What data is in GrantNav?
- Additional data and GrantNav
- What is included in the GrantNav export files?
Search
How does the GrantNav search box work?
GrantNav provides a search box which allows you to explore the data. There are four search patterns to choose from:
Search | Coverage |
---|---|
Search All | Searches across all fields of the data, including all text and numbers. To learn more about what fields are present in 360Giving data, see the 360Giving Data Standard. Data in fields that are provided by publishers but that aren't part of the standard will be included in this search. |
Locations |
Searches the ward, district and region location of the recipient organisation, of any grant record which features this geographical information. See also: GrantNav and location data |
Recipients | Searches the name of the recipient organisation only. |
Titles and Descriptions | Searches the title and description of the grants only. |
Advanced search
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. You can click on the examples to see how they work
Words and phrases
- A single word: e.g.
people
- 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.
"young people"
- Exclude results that contain a word: e.g.
youth NOT clubs
Using the above you can effectively filter the records to a single organisation or an exact grant. Try:
Fields
- Search words and phrases limited to a specific field, for example:
title:gardens
will search the "title" field for the word "gardens"recipientOrganization.postalCode:NW1
will 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.
Ranges
Dates
To search for grants in a given date range:
- Award date in FY17/18: e.g.
awardDate:[2017-04-01 TO 2018-03-31]
- Planned start date in 2016: e.g.
plannedDates.startDate:[2016-01-01 TO 2016-12-31]
-
Planned start date in 2015 and planned end date in 2017: e.g.
plannedDates.startDate:[2015-01-01 TO 2015-12-31] AND plannedDates.endDate:[2017-01-01 TO 2017-12-31]
Searching for a range of dates works alongside the Award Date filter. Therefore, you can search for a wide date range and then refine, compare or see an overview of the distribution using the filter.
Amounts
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 *]
Searching for a range of values works alongside the Amount Awarded filter. Therefore, you can search for a wide range of values and then refine, compare or see an overview of the distribution using the filter.
Wildcards
Wildcard searches can be run on individual terms, using ? to replace a single character, and * to replace zero or more characters: e.g.
b?g
, you*
. If you’re searching within a specific field, be aware that wildcard searching is only available on names, descriptive text fields, dates and amounts.
Fuzziness
You can search for terms that are similar to, but not exactly like our search terms, using the “fuzzy” operator: ~ . To use it, put the ~ operator at the end of the term you’re looking for e.g.
youht~
, yung~
, pple~
. Or, if you want to specify the ways in which the result can vary from the search term, then the wildcard operators are more appropriate. If you’re searching within a specific field, be aware that fuzzy matching is only available on names and descriptive text fields.
Results
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 Data Standard in the following ways:
GrantNav filter | 360Giving Data Standard field | Notes |
---|---|---|
Amount Awarded | Amount Awarded | Values are banded into the relevant categories. |
Award Year | The year (YYYY) component of date from Award Date field | This is calendar year, not fiscal/financial year. See Ranges for how to search between specific dates. |
Recipient Region | This filter is derived from 360Giving data by GrantNav | See also: GrantNav and location data |
Recipient District | This filter is derived from 360Giving data by GrantNav | See also: GrantNav and location data |
Funding Organisations | Funding Org:Name | Values are taken from the data and will change if the funder name changes. |
Recipient Organisations | Recipient Org:Name | See also: GrantNav and charity names |
Why can't I find results that I know should match the search criteria?
GrantNav's filters show the grants which contain the selected value in the relevant field. If the publisher of the data hasn't included that data, then GrantNav's filters will exclude the grant, even if it appears that it should be included. For example, if a grant is to the “Lancaster Rowing Club” but the grant doesn’t contain any recipient location data, then using the recipient region filter to select ‘North West’ will exclude the grant from the results. This is because GrantNav needs specific types of recipient location data to know where the grant recipient is located - see GrantNav and location data for further details. If you know that a grant is in GrantNav but doesn’t appear where you’d expect, you might want to contact the publisher of the data to let them know. Visit the 360Giving Registry for a full list of organisations and their contact details.
How can I give feedback on data in GrantNav?
All of the data in GrantNav is downloaded directly from the organisations listed and is presented without change. Any queries or feedback that you have about the data itself should be directed to the individual organisation. To find out who published a particular grant, and to see more information about how to contact them, see the “Where is this data from?” section of the relevant grant’s page.
Why do some grants show an award of £0?
Publishers sometimes set the grant value to be £0 for accounting reasons, or to signify something about the grant (such as that it was regranted). Refer to the relevant organisation website for the dataset for further information about their data, and to contact them for clarification. See How can I give feedback on data in GrantNav? for more information on contacting individual organisations.
Data In GrantNav
What data is in GrantNav?
GrantNav contains a curated selection of the data listed in the 360Giving Registry. Data loaded into GrantNav has, at a minimum, a license allowing re-use for any purpose (eg OGL, CC-BY 4.0) and validates against the 360Giving Data Standard at time of download. 360Giving aims to include as much data as possible, but omits datasets that we consider to skew results or that aren't relevant to GrantNav's users. GrantNav is updated on a daily basis. The grants data is then enhanced with data from various open datasets to help power the search tools. For details, please see the Data Used in GrantNav page.
Why do GrantNav filters show recipient rather than beneficiary location?
While the 360Giving Data Standard allows publishers to include beneficiary location data (the place where funded activity is taking place), it can sometimes be hard to determine and record this information in a meaningful way, and so not all data includes this type of information. When there is beneficiary location information available about a grant you will find this data on the grant page and included in the data download.
Additional data and GrantNav
When data is imported into GrantNav, we undertake two processes to 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. To see the datasets used, see Data used in GrantNav
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 to include 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 exactly the 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, if the recipient is registered. 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 included in the GrantNav export files?
You can export data 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 download uses the same field names as the 360Giving Data 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 Data Standard are included in the GrantNav export CSV.
The CSV file contains more fields than are used by core GrantNav functionality, including fields such as beneficiary location data, if this has been provided by the publisher(s). Columns may be entirely blank if no grant in your download uses a particular field. Sometimes, publishers add more fields to the standards for their own use. Such fields are not included in the CSV export, but are included in the JSON export.
The following fields are not in the 360Giving Data Standard and are added to the export data by GrantNav:
Field | Description |
---|---|
Data Source | This is the URL (web link) for the data file containing this grant record. |
Publisher:Name | This is the name of the organisation publishing the data file. This data is held centrally by 360Giving. |
Recipient Region | This is the name of the geographic area, added by GrantNav (see GrantNav and location data for explanation). |
Recipient District | This is the name of the geographic area, added by GrantNav (see GrantNav and location data for explanation). |
Recipient Ward | This is the name of the geographic area, added by GrantNav (see GrantNav and location data for explanation). |
Retrieved for use in GrantNav | This is the date and time the data was accessed for use in GrantNav. |
License (see note below) | The URL (web link) to the specific licence under which the data file containing this grant record was published. |
Exporting from the funders and recipients pages
Data downloaded from the funders and recipients pages contain only the details seen on screen, plus an extra column with the funder or recipient identifiers.
Field | Description |
---|---|
Funder / Recipient | Funder or recipient name |
Funder Id / Recipient Id | Identifier code of the funder or recipient |
Grants | Number of grants made by/to the funder or recipient |
Total | Total value of all grants made by/to the funder or recipient |
Average | Average value of a grant made by/to the funder or recipient |
Largest | Value of the largest grant made by/to the funder or recipient |
Smallest | Value of the smallest grant made by/to the funder or recipient |
Working with the exported data
Since the data is presented in a standard format, it is pretty clean and ready to use. We recommend you import it to your favourite data analysis tool (like PowerBI or Tableau) and work from there. Depending on your search, some exported data can be very large, so it might take some time to load on Google Sheets or Microsoft Excel. See our blog for more ideas of what you can do with the data.