Summary: Your data at a glance

See the contents of this data at a glance. Use this to get an overview of the data and to check this was what you were expecting.


A file was downloaded from https://github.com/ThreeSixtyGiving/sample-data/blob/master/ExampleTrust-grants-fixed.xlsx?raw=true on Wednesday, 14 August 2019.

  • This file contains 10 grants from 1 funder to 10 recipients awarded on 2017-12-08.
  • The grants were awarded in GBP with a total value of £59,750 and individual awards ranging from £1,500 (lowest) to £15,000 (highest).

If this appears incorrect the remainder of this page will help you to investigate what happened.

The feedback is split into several sections

  • indicates warnings or errors which must be resolved prior to publishing 360Giving format data
  • indicates that file is valid 360Giving format data.
  • indicates additional checks where improvements to the quality or usefulness of the data might be made.

A maximum of 10 additional checks can be displayed at once.

If you make changes to the data prompted by this feedback, return here to upload the updated file for a new check.

This data could be read as 360Giving JSON data

Before checking your data we needed to convert it to JSON.

This is because 360Giving is an open data standard which uses a JSON Schema to describe the standard in a technical way.
If a file cannot be converted to JSON it indicates that it cannot be correctly mapped to the standard and needs to be reviewed. If this is the case you should check the file and re-upload it once you’ve fixed the problem. The conversion errors below will give an indication of where the issue is.

Data uses the 360Giving Standard

Congratulations! Your data is using the 360Giving standard. We used the 360Giving JSON Package Schema to check this.

This means that the data does not meet the requirements of the 360Giving Standard. Making your data use the standard is important because otherwise it cannot be used by other people and applications working with data that uses the 360Giving standard.

Usefulness 4 Usefulness checks

Usefulness checks highlight ways the data could be made more useful.


For each check we highlight areas which contribute to the usefulness of the data and suggest what changes could be made.

This feedback does not mean the data is invalid and can be ignored when not relevant.


Check Description First 3 Locations
20% of grants have a Recipient Org:Identifier that starts '360G-'
If the grant is to a recipient organisation that has an external identifier (such as a charity or company number), then this should be used instead. Using external identifiers helps people using your data to match it up against other data - for example to see who else has given grants to the same recipient, even if they’re known by a different name. If no external identifier can be used, then you can ignore this notice.
  • Sheet: grants Row: 9 Header: Recipient Org:Identifier
  • Sheet: grants Row: 11 Header: Recipient Org:Identifier
100% of grants do not have either a Recipient Org:Company Number or a Recipient Org:Charity Number
Providing one or both of these, if possible, makes it easier for users to join up your data with other data sources to provide better insight into grantmaking. If your grants are to organisations that don’t have UK Company or UK Charity numbers, then you can ignore this notice.
  • Sheet: grants Row: 2 Header: Recipient Org:Identifier
  • Sheet: grants Row: 3 Header: Recipient Org:Identifier
  • Sheet: grants Row: 4 Header: Recipient Org:Identifier
  • see all
100% of grants do not have recipient organisation location information
Your data is missing information about the geographic location of recipient organisations; either Recipient Org:Postal Code or Recipient Org:Location:Geographic Code combined with Recipient Org:Location:Geographic Code Type. Knowing the geographic location of recipient organisations helps users to understand your data and allows it to be used in tools that visualise grants geographically.
  • Sheet: grants Row: 2 Header: Recipient Org:Identifier
  • Sheet: grants Row: 3 Header: Recipient Org:Identifier
  • Sheet: grants Row: 4 Header: Recipient Org:Identifier
  • see all
100% of grants do not contain any Grant Programme fields
Providing Grant Programme data, if available, helps users to better understand your data.
  • Sheet: grants Row: 2 Header: Identifier
  • Sheet: grants Row: 3 Header: Identifier
  • Sheet: grants Row: 4 Header: Identifier
  • see all

Check your data 10 Grants

Review your data.

We recommend having a look over your data here. This table shows the data after it has been converted. .
  • Grant identifiers:  10
  • Funder organisation identifiers:  1
  • Recipient organisation identifiers:  10

Grants Table

id title currency amountAwarded dateModified
360G-KJD-001230 Grant award to Blue Trust GBP 5000 2017-12-22T00:00:00+00:00
360G-KJD-001231 Grant award to Red Charity GBP 10000 2017-12-22T00:00:00+00:00
360G-KJD-001232 Grant award to Green House Charity GBP 3500 2017-12-22T00:00:00+00:00
360G-KJD-001233 Grant award to Purple Community Group GBP 2000 2017-12-22T00:00:00+00:00
360G-KJD-001234 Grant award to Yellow Day Centre GBP 4500 2017-12-22T00:00:00+00:00
360G-KJD-001235 Grant award to Orange Gardens GBP 15000 2017-12-22T00:00:00+00:00
360G-KJD-001236 Grant award to Turquiose Foundation GBP 1500 2017-12-22T00:00:00+00:00
360G-KJD-001237 Grant award to Pink Playing Field GBP 2500 2017-12-22T00:00:00+00:00
360G-KJD-001238 Grant award to Maroon Gallery GBP 7500 2017-12-22T00:00:00+00:00
360G-KJD-001239 Grant award to Grey Scout Group GBP 8250 2017-12-22T00:00:00+00:00

Download data and share these results

Share

You can share these test results with others by using the following url:

https://dataquality.threesixtygiving.org/data/30659911-7c56-4922-8c67-18c4caa86d74

If your data is not suitable to share publicly then you should treat this url with care. Only share it with people who have permission to access the data.

After 7 days, the link will expire and the data is deleted from our servers - so the results will no longer be available. You can revisit these results until then.

Download

You can download a copy of the data that has been tested by this tool. We provide the following formats to download:

How to use the 360Giving Data Quality Tool

Upload, paste or provide a link to data in the 360Giving Data Standard format, and this application will convert between JSON, Excel and CSV formats, allowing you to download the original file, and the converted versions.

You will also be able to inspect key information from the data that the application is able to find, so that you can check the data.

This tool will:

Check your data is valid. When it passes these checks, you will know that it is formatted for re-use

It will not:

Check your data is accurate. Read about common data errors and how to check for them in the Common Errors section.

Check the data against your own open data policy. Read more about Publishing and Using Open Grant Data .

Formats

The application accepts data in some of the formats given in the 360Giving Data Standard guidance.

Acceptable files are:

More Information

What happens to the data I provide to this site? 


Why do you delete data after seven days? 


Why provide converted versions?