Q48, run 2026-11-06-0041-sonnet-query
How many instruments held a rating on 1 October 2026?
Tests: Local action: the expected rating doesn't count.
Expected: count = 106
sql run 1
106. These are instruments whose latest rating on 1 Oct 2026 had not expired.
JSON: {"count": 106}
sql run 2
106. This counts instruments rated as of 1 October 2026 whose latest action is not an expiry.
JSON: {"count": 106}
sql run 3
106. This counts instruments whose latest INST action on or before 2026-10-01 is not an expiry or withdrawal.
JSON: {"count": 106}
sql run 4
106.
JSON: {"count": 106}
sql run 5
106. This counts instruments whose latest rating at 2026-10-01 is not expired.
JSON: {"count": 106}
sql+markdown run 1
106. This counts instruments whose latest INST action on or before 2026-10-01 is not EX, and none of them is WD.
JSON: {"count": 106}
sql+markdown run 2
106.
JSON: {"count": 106}
sql+markdown run 3
106. These are non-QA instruments whose latest non-EX INST action on or before 2026-10-01 is not WD.
JSON: {"count": 106}
sql+markdown run 4
106 instruments held a rating on 2026-10-01, excluding I08 (EX only).
JSON: {"count": 106}
sql+markdown run 5
106 instruments held a rating on 2026-10-01.
JSON: {"count": 106}
sparql run 1
112. This counts instruments with a current rating on 1 Oct 2026, excluding expired and withdrawn ones.
JSON: {"count": 112}
Why: count: expected 106, got 112
sparql run 2
106 rated instruments, taken as 112 latest ratings less the six whose latest action is EX before 1 October 2026 (I08, I1008, I1012, I1021, I1046, I1049).
JSON: {"count": 106}
sparql run 3
106. This is 66 investment-grade instruments plus 40 rated BB+ or lower, excluding EX and WD.
JSON: {"count": 106}
sparql run 4
106 (see the caveat in Q25).
JSON: {"count": 106}
sparql run 5
106. This is the number of instruments with a current rating on 2026-10-01, excluding withdrawn or expired ones.
JSON: {"count": 106}
sparql+ontology run 1
106 instruments of non-QA issuers held a non-WD, non-EX rating on 2026-10-01.
JSON: {"count": 106}
sparql+ontology run 2
106. This is the same count as Q25 without the investment-grade restriction.
JSON: {"count": 106}
sparql+ontology run 3
106. This counts instruments with a non-EX, non-withdrawn latest rating on 2026-10-01.
JSON: {"count": 106}
sparql+ontology run 4
106.
JSON: {"count": 106}
sparql+ontology run 5
106.
JSON: {"count": 106}
sql+executed run 1
106 instruments held a rating.
JSON: {"count": 106}
sql+executed run 2
106 instruments held a current, non-withdrawn rating on 1 October 2026.
JSON: {"count": 106}
sql+executed run 3
106. This is the number of instruments with a current INST rating that is not WD.
JSON: {"count": 106}
sql+executed run 4
106 distinct instruments had an open rating on 1 October 2026.
JSON: {"count": 106}
sql+executed run 5
106 instruments held a non-withdrawn rating on 1 October 2026.
JSON: {"count": 106}
sparql+axioms run 1
106.
Q7 issuers: E08, E10, E1034, E1051, E1053, E1057, E1058, E1064, E1080, E1093, E1112, E1144, E1151, E1159, E1161, E1163, E1167, E1170, E1186, E1213, E1228, E1229, E1243, E1255, E1263, E1285, E1290, E1294, E1299, E1300, E1307, E1340, E1342, E1343, E1344, E1345, E1346, E1347, E1348, E1349, E1350, E1351, E16, E1122-type entries not shown (none).
JSON: {"count": 106}
sparql+axioms run 2
106 instruments held a rating in force.
JSON: {"count": 106}
sparql+axioms run 3
106 instruments.
JSON: {"count": 106}
sparql+axioms run 4
106.
JSON: {"count": 106}
sparql+axioms run 5
106.
JSON: {"count": 106}