Cookies disclaimer

I agree Our site saves small pieces of text information (cookies) on your device in order to deliver better content and for statistical purposes. You can disable the usage of cookies by changing the settings of your browser. By browsing our website without changing the browser settings you grant us permission to store that information on your device.

Help with Using GrantNav

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:

Search Coverage
Search All Searches across all fields - covering text and numbers.
Only 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

Only Recipients Searches the name of the recipient organisation only.

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:

GrantNav filter 360Giving 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
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

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.

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:

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 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.

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

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. 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"

Using the above you can effectively filter the records to a single publisher or an exact grant. Try:

  • "The Dulverton Trust"
  • "360G-wolfson-19750"

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)
    • fundingOrganisation.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.

Ranges

Dates

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]

Amounts

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 *]

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*

Fuzziness

You can search for terms that are similar to, but not exactly like our search terms, using the “fuzzy” operator: e.g. youht~, yung~, pple~