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