Q48, run 2026-11-05-2135-sonnet
How many instruments held a rating on 1 October 2026?
Tests: Local action: the expected rating doesn't count.
Expected: count = 106
csv run 1
106 instruments. Eight instruments have only EX rows and are excluded.
JSON: {"count": 106}
csv run 2
106 instruments. 115 instruments exist, and 9 have no active rating: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049, whose only action is an EX.
JSON: {"count": 106}
csv run 3
106 instruments, applying the same EX exclusion as Q25.
JSON: {"count": 106}
csv run 4
106 instruments held a rating on 2026-10-01. The 8 instruments with an EX action, whether before or after that date, are excluded.
JSON: {"count": 106}
csv run 5
106. This is I01–I07 plus 99 of the I10xx instruments. Eight instruments with only an EX action are excluded: I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
rdf run 1
106 instruments held a rating on 2026-10-01, excluding expired ones.
JSON: {"count": 106}
rdf run 2
109. There are 115 rated instruments, and six had expired by 2026-10-01 (see Q25).
JSON: {"count": 109}
Why: count: expected 106, got 109
rdf run 3
106 instruments, excluding the nine whose only action is EX.
JSON: {"count": 106}
rdf run 4
109. That is 115 instruments less the six already expired.
JSON: {"count": 109}
Why: count: expected 106, got 109
rdf run 5
109. This counts instruments with a rating on 2026-10-01. Of the 114 rated, I08, I1008, I1012, I1021, I1046 and I1049 had already expired (I1015 expires only on 2026-12-17).
JSON: {"count": 109}
Why: count: expected 106, got 109
rdf+ontology run 1
106. Of 115 instruments, 9 have only EX actions and are unrated.
JSON: {"count": 106}
rdf+ontology run 2
106. Of 115 instruments, 9 carry only an EX action and are unrated.
JSON: {"count": 106}
rdf+ontology run 3
106. There are 115 instruments, and 9 have only an Expected action: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
rdf+ontology run 4
106 instruments. There are 115 in total, and 9 have only an EX action.
JSON: {"count": 106}
rdf+ontology run 5
106. There are 115 instruments, and 9 have only an Expected action.
JSON: {"count": 106}
csv+ontology run 1
106 instruments held a rating. Nine have only an EX action and no assignment: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+ontology run 2
106. Of 115 instruments, 9 have only EX actions and no assignment: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049.
JSON: {"count": 106}
csv+ontology run 3
106 of the 115 instruments. Nine have only an EX action or an action dated after 2026-10-01.
JSON: {"count": 106}
csv+ontology run 4
106. Of 115 instruments, 9 have only EX actions (I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049).
JSON: {"count": 106}
csv+ontology run 5
106 instruments (7 of I01–I08 plus 99 of I1001–I1107). The 8 with only an EX action, or none by the cutoff, are excluded. Hand count.
JSON: {"count": 106}
csv+markdown run 1
106. Nine instruments have no rating: I08 and the eight with only an EX action (I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049).
JSON: {"count": 106}
csv+markdown run 2
106. Of 115 instruments, 9 have no assigned rating, only an expected-rating (EX) record: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+markdown run 3
106 instruments. Of 115 instruments, 9 have no assigned INST rating: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+markdown run 4
106. There are 115 instruments, and 9 have only an expected rating (EX).
JSON: {"count": 106}
csv+markdown run 5
106. Nine instruments have only an Expected rating or none: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049.
Three entities (E1115, E1158, E1303) have a withdrawal dated before later actions. I treated them as rated because the latest action holds.
JSON: {"count": 106}
csv+padding run 1
106 instruments (7 from I01–I07 and 99 from the I1xxx range). The 8 with only EX actions are excluded.
JSON: {"count": 106}
csv+padding run 2
106 instruments. I counted those with an assignment (AS) on or before 2026-10-01. Eight instruments (I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046) and I1049 have only an EX action and are excluded.
JSON: {"count": 106}
csv+padding run 3
109. That is 7 seed instruments plus 102 generated, with 6 expired before 2026-10-01 excluded. I counted I1001, I1007 and I1015 as rated because their EX actions fall after 1 October; I assumed EX means the rating expired on that date.
Assumptions: I excluded QA-source records from the counts, merged same-LEI duplicates, and ordered actions by date. E1115, E1158 and E1303 have withdrawal actions dated before later rating actions, so by date they count as rated. I treated E1279 as still rated because only its foreign-currency rating was withdrawn.
JSON: {"count": 109}
Why: count: expected 106, got 109
csv+padding run 4
106: 7 of I01–I07 plus 99 of the I10xx instruments. I08 and the I10xx instruments whose only action is EX are excluded.
JSON: {"count": 106}
csv+padding run 5
106. This is 99 filler instruments plus I01 to I07; instruments with only an EX action count as unrated.
JSON: {"count": 106}
executed run 1
106. I counted the instruments with an open rating row on 1 Oct 2026 (7 from the I01–I07 block plus 99 from I1002–I1107).
JSON: {"count": 106}
executed run 2
106 instruments had an open rating on 1 Oct 2026.
JSON: {"count": 106}
executed run 3
106 instruments held an open rating on 1 Oct 2026.
JSON: {"count": 106}
executed run 4
106 instruments have an open rating. I08 is the only unrated instrument, and none had matured by 2026-10-01.
JSON: {"count": 106}
executed run 5
106 instruments (I01–I07 plus 99 I1xxx) have an open rating.
JSON: {"count": 106}
csv+neutral run 1
106 (7 of I01–I08 plus 99 of I1001–I1107). The instruments excluded as only Expected are I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+neutral run 2
106. There are 115 instruments, of which 9 have only an Expected action: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+neutral run 3
106. There are 115 instruments, of which 9 have only an Expected action or none.
JSON: {"count": 106}
csv+neutral run 4
106 of 115 instruments. The nine unrated ones are I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049, which have only EX actions.
JSON: {"count": 106}
csv+neutral run 5
106. Nine of the 115 instruments are unrated: I08 and 8 others that have only an EX action.
JSON: {"count": 106}
csv+axioms run 1
106. Of 115 instruments, 9 have no rating in force: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049 (only EX actions).
JSON: {"count": 106}
csv+axioms run 2
106 instruments. Of 115, nine have only expected ratings: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+axioms run 3
106. There are 115 instruments, and 9 have only an expected rating: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049.
JSON: {"count": 106}
csv+axioms run 4
106. There are 115 instruments, and 9 have only EX actions (I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049).
JSON: {"count": 106}
csv+axioms run 5
106. There are 115 instruments, and 9 have only an expected rating: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}
csv+axioms+markdown run 1
106. Of the 115 instruments, I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049 have only EX actions.
JSON: {"count": 106}
csv+axioms+markdown run 2
106 instruments held a rating. That is 115 instruments less 8 with only an EX action (I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046, I1049 less I08 counted already, so 9 unrated in total). Treat this count as approximate.
JSON: {"count": 106}
csv+axioms+markdown run 3
106 of the 115 instruments, with 9 unrated because they have only an EX action.
JSON: {"count": 106}
csv+axioms+markdown run 4
106. There are 115 instruments, and 9 have only an Expected rating (EX) and no assignment.
JSON: {"count": 106}
csv+axioms+markdown run 5
106. Of the 115 instruments, 9 have only an EX action and are unrated: I08, I1001, I1007, I1008, I1012, I1015, I1021, I1046 and I1049.
JSON: {"count": 106}