Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Include "relevant" in the CSV file - and drop the category scores #66

Open
stevieflow opened this issue Dec 21, 2021 · 0 comments
Open

Comments

@stevieflow
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant