Include "relevant" in the CSV file - and drop the category scores #66
Description
Related to #65
Having spent more time with the csv download, and request this be ordered according to the methodology in #65, I'e two more requests:
- Add a new column for "relevant" to state the number of records that were relevant to the test (we state total and not relevant, but miss that last step)
- Remove the categories, so we just have an ordered list of the tests - eg:
| type | indicator_num | name | score | total_tested | failed | passed | not-relevant | relevant |
|---|---|---|---|---|---|---|---|---|
| test | 3 | Organisation strategy is present | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 4 | Annual report is present | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 5 | Allocation policy is present | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 6 | Procurement policy is present | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 7 | Strategy (country/sector) or Memorandum of Understanding | 1 | 0 | 0 | 1 | 0 | |
| test | 8 | Audit is present | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 9 | Organisation budget available one year forward | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 9 | Organisation budget available two years forward | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 9 | Organisation budget available three years forward | 100 | 1 | 0 | 1 | 0 | 1 |
| test | 10 | Disaggregated budget | 1 | 0 | 0 | 1 | 0 | |
| test | 11 | Budget available forward annually | 1 | 0 | 0 | 1 | 0 | |
| test | 11 | Budget available forward quarterly | 1 | 0 | 0 | 1 | 0 | |
| test | 12 | Budget document is present | 1 | 0 | 0 | 1 | 0 | |
| test | 13 | Commitment is present | 1 | 0 | 0 | 1 | 0 | |
| test | 14 | Disbursements or expenditures are present | 1 | 0 | 0 | 1 | 0 | |
| test | 15 | Capital spend is present | 1 | 0 | 0 | 1 | 0 | |
| test | 15 | Publish detailed CRS purpose codes in the sector field | 1 | 0 | 0 | 1 | 0 | |
| test | 16 | Title is present | 1 | 0 | 0 | 1 | 0 | |
| test | 16 | Title has at least 10 characters | 1 | 0 | 0 | 1 | 0 | |
| test | 17 | Description is present | 1 | 0 | 0 | 1 | 0 | |
| test | 17 | Description has at least 80 characters | 1 | 0 | 0 | 1 | 0 | |
| test | 18 | Planned start date is present | 1 | 0 | 0 | 1 | 0 | |
| test | 18 | Planned end date is present | 1 | 0 | 0 | 1 | 0 | |
| test | 19 | Actual start date is present | 1 | 0 | 0 | 1 | 0 | |
| test | 19 | Actual end date is present | 1 | 0 | 0 | 1 | 0 | |
| test | 20 | Current status is present | 1 | 0 | 0 | 1 | 0 | |
| test | 20 | Current status is valid | 1 | 0 | 0 | 1 | 0 | |
| test | 21 | Contact info is present | 1 | 0 | 0 | 1 | 0 | |
| test | 22 | Sector is present | 1 | 0 | 0 | 1 | 0 | |
| test | 22 | Sector uses DAC CRS 5 digit purpose codes | 1 | 0 | 0 | 1 | 0 | |
| test | 23 | Location (sub-national) | 1 | 0 | 0 | 1 | 0 | |
| test | 23 | Location (sub-national) coordinates or point | 1 | 0 | 0 | 1 | 0 | |
| test | 24 | Conditions data | 1 | 0 | 0 | 1 | 0 | |
| test | 24 | Conditions document | 1 | 0 | 0 | 1 | 0 | |
| test | 25 | IATI Identifier is present | 1 | 0 | 0 | 1 | 0 | |
| test | 25 | IATI Identifier starts with reporting org ref | 1 | 0 | 0 | 1 | 0 | |
| test | 26 | Flow type | 1 | 0 | 0 | 1 | 0 | |
| test | 26 | Flow type uses standard codelist | 1 | 0 | 0 | 1 | 0 | |
| test | 27 | Aid type is present | 1 | 0 | 0 | 1 | 0 | |
| test | 27 | Aid type is valid | 1 | 0 | 0 | 1 | 0 | |
| test | 28 | Default finance type | 1 | 0 | 0 | 1 | 0 | |
| test | 28 | Finance type uses standard codelist | 1 | 0 | 0 | 1 | 0 | |
| test | 29 | Tied aid status | 1 | 0 | 0 | 1 | 0 | |
| test | 29 | Tied aid status uses standard codelist | 1 | 0 | 0 | 1 | 0 | |
| test | 30 | Implementing organisation | 1 | 0 | 0 | 1 | 0 | |
| test | 30 | Participating Orgs | 1 | 0 | 0 | 1 | 0 | |
| test | 31 | Tender is present | 1 | 0 | 0 | 1 | 0 | |
| test | 31 | Contract is present | 1 | 0 | 0 | 1 | 0 | |
| test | 33 | Objectives of activity document | 1 | 0 | 0 | 1 | 0 | |
| test | 34 | Pre- and/or post-project impact appraisal documents | 1 | 0 | 0 | 1 | 0 | |
| test | 35 | Project performance and evaluation document | 1 | 0 | 0 | 1 | 0 | |
| test | 36 | Results data | 1 | 0 | 0 | 1 | 0 | |
| test | 36 | Results document | 1 | 0 | 0 | 1 | 0 |