Q25, run 2026-11-06-0041-sonnet-query

← back to the run

How many instruments held an investment-grade rating on 1 October 2026?

Tests: Instrument ratings: counted on the instrument's own rating, not its issuer's.

Expected: count = 66

✅ D1 sql run 1 graded by code · query session

66. These are instruments whose latest rating on 1 Oct 2026 was BBB- or better and had not expired (EX).

JSON: {"count": 66}

✅ D1 sql run 2 graded by code · query session

66. This counts instruments whose latest INST action by 1 October 2026 is not an expiry (EX) and whose rating is BBB- or better.

JSON: {"count": 66}

✅ D1 sql run 3 graded by code · query session

66. Of 106 instruments rated on 1 October 2026, 66 were BBB- or higher.

JSON: {"count": 66}

✅ D1 sql run 4 graded by code · query session

66 instruments.

JSON: {"count": 66}

✅ D1 sql run 5 graded by code · query session

66. This counts the latest instrument rating at or before 2026-10-01 that is BBB- or higher, excluding expired ratings.

JSON: {"count": 66}

✅ D2 sql+markdown run 1 graded by code · query session

66. This counts instruments whose latest INST rating on 2026-10-01 is BBB- or higher. EX actions are excluded.

JSON: {"count": 66}

✅ D2 sql+markdown run 2 graded by code · query session

66 instruments, excluding the unconfirmed expected rating on I08.

JSON: {"count": 66}

✅ D2 sql+markdown run 3 graded by code · query session

66. This counts non-QA instruments whose latest INST action on or before 2026-10-01 is investment grade. EX actions are ignored.

JSON: {"count": 66}

✅ D2 sql+markdown run 4 graded by code · query session

66 instruments, counting each instrument's latest non-EX action, excluding QA issuers and withdrawals.

JSON: {"count": 66}

✅ D2 sql+markdown run 5 graded by code · query session

66 instruments were rated investment grade on 2026-10-01. This counts each instrument's latest non-Expected rating, excluding QA issuers.

JSON: {"count": 66}

❌ D4 sparql run 1 graded by code · query session

69. This counts instruments whose latest rating on 1 Oct 2026 was BBB- or better, excluding expired ratings.

JSON: {"count": 69}

Why: count: expected 66, got 69

✅ D4 sparql run 2 graded by code · query session

66. I counted instruments whose latest rating on 1 October 2026 was investment grade, excluding those whose latest action was EX (action code not defined in the data; I treated it as an expiry). Of the 69 investment-grade rated instruments, three had a latest EX action and were removed: I08, I1012, I1021.

JSON: {"count": 66}

✅ D4 sparql run 3 graded by code · query session

66. This counts instruments whose latest rating on 1 Oct 2026 was BBB- or better, excluding expired or withdrawn ratings.

JSON: {"count": 66}

❌ D4 sparql run 4 graded by code · query session

106. The query returned 106 both for rated instruments and for investment-grade ones, which looks inconsistent: I02 (BB+) and I04 (BB) are not investment grade. Treat this figure as unreliable.

JSON: {"count": 106}

Why: count: expected 66, got 106

✅ D4 sparql run 5 graded by code · query session

66. This counts instruments with a latest rating on or before 2026-10-01 that is investment grade, excluding withdrawn or expired ratings.

JSON: {"count": 66}

✅ D5 sparql+ontology run 1 graded by code · query session

66. These are instruments of non-QA issuers whose latest rating on 2026-10-01 is BBB- or better, ignoring Expected ratings (EX).

JSON: {"count": 66}

✅ D5 sparql+ontology run 2 graded by code · query session

66. This counts instruments of non-QA issuers whose latest rating on 1 Oct 2026 is BBB- or higher. Expected-rating (EX) and withdrawn actions are excluded.

JSON: {"count": 66}

✅ D5 sparql+ontology run 3 graded by code · query session

66. This counts instruments whose latest non-EX action leaves them at BBB- or higher on 2026-10-01.

JSON: {"count": 66}

✅ D5 sparql+ontology run 4 graded by code · query session

66. Of 106 instruments with a rating on that date, 66 were at BBB- or better. The expected rating on I08 is excluded.

JSON: {"count": 66}

✅ D5 sparql+ontology run 5 graded by code · query session

66 instruments, excluding the unconfirmed expected rating (EX) on I08.

JSON: {"count": 66}

✅ D3 sql+executed run 1 graded by code · query session

66 instruments held an investment-grade rating.

JSON: {"count": 66}

✅ D3 sql+executed run 2 graded by code · query session

66 instruments held a current rating of BBB- or better on 1 October 2026.

JSON: {"count": 66}

✅ D3 sql+executed run 3 graded by code · query session

66. This is the number of instruments with a current INST rating of BBB- or higher.

JSON: {"count": 66}

✅ D3 sql+executed run 4 graded by code · query session

66 distinct instruments held an investment-grade rating (BBB- or higher) on 1 October 2026.

JSON: {"count": 66}

✅ D3 sql+executed run 5 graded by code · query session

66 instruments held an investment-grade (BBB- or above) rating on 1 October 2026.

JSON: {"count": 66}

✅ D6 sparql+axioms run 1 graded by code · query session

66 instruments held an in-force rating of BBB- or better.

JSON: {"count": 66}

✅ D6 sparql+axioms run 2 graded by code · query session

66 of the 106 rated instruments held an investment-grade rating.

JSON: {"count": 66}

✅ D6 sparql+axioms run 3 graded by code · query session

66 instruments.

JSON: {"count": 66}

✅ D6 sparql+axioms run 4 graded by code · query session

66 instruments held an investment-grade rating on 1 Oct 2026.

JSON: {"count": 66}

✅ D6 sparql+axioms run 5 graded by code · query session

66.

JSON: {"count": 66}