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 is a search engine for open grants data being published in the 360Giving 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

Data In GrantNav




Search


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

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

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

Fields

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

To search for grants in a given date range:

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:

You can also search ranges with one side unbounded:

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 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. 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 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. The data is re-loaded once per month, so organisations that have recently published 360Giving data may not appear immediately. 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 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.

When you export data from a GrantNav search the download 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 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 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.