This tool is alpha. Please report any problems on GitHub issues.

Data Summary

A file was downloaded from https://github.com/ThreeSixtyGiving/sample-data/blob/master/ExampleTrust-grants-fixed.xlsx?raw=true on Monday, 19 February 2018.


  • 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 summary looks incorrect, you can use the Review section alongside any warnings or errors to investigate what happened and make changes to your original data before loading it again for a new check.

Converted to JSON

In order to validate your data we needed to convert it to JSON.

360Giving uses JSON Schema to describe the standard in a technical way. In order to validate the data against the schema we have converted it to JSON and will perform all tests on the converted data. If there are conversion errors, the data may not look as you expect — check the Review section to see if the data appears as expected

Valid against Schema

Congratulations! Your data is valid against 360Giving JSON Package Schema.

Validation ensures that your data is compliant with the basic requirements of the 360Giving Standard. If your data validates then it can be used by any user or application who knows how to work with 360Giving data.

Additional Checks 4 Additional checks

Additional checks have been made on your data.


Additional checks highlight some specific areas where the source data may be incorrect or require further attention. They can also suggest ways to increase the usefulness of the data. In any case, these checks do not indicate validation errors and can be ignored if they are not relevant.


Check Description First 3 Locations
2 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
10 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
10 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
10 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

Review 10 Grants

Review your data.

The table below shows your data after it has been processed .
  • 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 and Share

Download

The following files are available to download:

Share

Use the following url to share these results:

https://dataquality.threesixtygiving.org/data/48d59877-88be-444b-8e85-82fcce90289b

After 7 days all uploaded data is deleted from our servers, and the results will no longer be available. Anyone using the link to this page after that will be shown a message that tells them the file has been removed.

These results will be available for 7 days from the day the data was first uploaded. You can revisit these results until then.

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?