Q9, run 2026-11-04-1738-sonnet-query

← back to the run

As of 1 October 2026, how many distinct issuers hold an issuer rating?

Tests: Everything at once: identity, withdrawal, instrument versus issuer, ceiling versus rating.

Expected: count = 278

❌ D1 sql run 1 graded by code · query session

291. This counts distinct LEIs whose latest issuer-rating action by 1 Oct 2026 is not a withdrawal.

JSON: {"count": 291}

Why: count: expected 278, got 291

❌ D1 sql run 2 graded by code · query session

291. This counts distinct LEI-deduplicated entities whose latest long-term rating action on or before 2026-10-01 is not a withdrawal, and it includes the sovereign CV.

JSON: {"count": 291}

Why: count: expected 278, got 291

❌ D1 sql run 3 graded by code · query session

291. These are distinct LEIs whose latest issuer rating on 1 October 2026 is not a withdrawal.

JSON: {"count": 291}

Why: count: expected 278, got 291

❌ D1 sql run 4 graded by code · query session

291. These are the distinct issuers whose latest long-term issuer rating on 2026-10-01 was not a withdrawal, deduplicated by LEI.

JSON: {"count": 291}

Why: count: expected 278, got 291

❌ D1 sql run 5 graded by code · query session

291. This counts distinct LEIs with a non-withdrawn LTIDR on 2026-10-01.

JSON: {"count": 291}

Why: count: expected 278, got 291

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

278 distinct issuers hold an LTIDR or STIDR that was not withdrawn as of 2026-10-01. QA records are excluded and records are merged by LEI.

JSON: {"count": 278}

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

278 distinct issuers held a non-withdrawn long-term issuer rating on 2026-10-01. QA records are excluded and same-LEI records are merged.

JSON: {"count": 278}

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

278. This counts distinct LEIs whose latest long-term issuer rating on 1 October 2026 is not a withdrawal (WD). Duplicate records and QA records are excluded.

JSON: {"count": 278}

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

278. This counts distinct entities (by LEI) with a current, non-withdrawn LTIDR or STIDR, QA records excluded.

JSON: {"count": 278}

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

278 distinct issuers hold an LTIDR or STIDR, counting RESEARCH duplicates once by LEI and excluding QA and withdrawn ratings. This count includes the two sovereigns, which hold LTIDRs.

JSON: {"count": 278}

❌ D4 sparql run 1 graded by code · query session

290. This is the count of distinct LEIs whose latest long-term issuer rating on 2026-10-01 is not WD.

JSON: {"count": 290}

Why: count: expected 278, got 290

❌ D4 sparql run 2 graded by code · query session

290. That is 288 distinct LEIs plus the two sovereigns (CV, VD), counting each issuer's latest long-term issuer rating (LTIDR) that is not WD as of 2026-10-01.

JSON: {"count": 290}

Why: count: expected 278, got 290

❌ D4 sparql run 3 graded by code · query session

About 290. 291 entities have a latest FC rating that is not withdrawn, and E02/E03 share an LEI. I could not fully reconcile the LEI counts, so this is approximate.

JSON: {"count": 290}

Why: count: expected 278, got 290

❌ D4 sparql run 4 graded by code · query session

290. 291 rated entity records de-duplicate to 290: 288 distinct LEIs, plus the two sovereigns, which have no LEI. This includes the sovereigns and excludes withdrawn ratings.

JSON: {"count": 290}

Why: count: expected 278, got 290

❌ D4 sparql run 5 graded by code · query session

289. This counts distinct LEIs with a latest long-term issuer rating that is not a withdrawal, as of 2026-10-01, so duplicate records are merged. The count includes the two sovereigns, CV and VD, and it is sensitive to that choice.

JSON: {"count": 289}

Why: count: expected 278, got 289

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

278. This counts distinct LEIs, plus the sovereign CV, with a non-withdrawn long-term issuer rating on 2026-10-01 and QA excluded.

JSON: {"count": 278}

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

278. This counts distinct LEIs (277) plus the sovereign CV, each with a non-withdrawn latest long-term issuer rating on 2026-10-01. QA records are excluded and duplicate records are merged by LEI.

JSON: {"count": 278}

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

278. This counts distinct LEIs whose latest long-term issuer rating on 2026-10-01 is not a withdrawal and excludes QA records.

JSON: {"count": 278}

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

278. That is 277 distinct LEIs with a live long-term issuer rating, plus the Republic of Corvenia (CV), which has no LEI.

JSON: {"count": 278}

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

278. This counts distinct LEIs whose latest LTIDR on each basis on 1 Oct 2026 is not WD, with QA records excluded.

JSON: {"count": 278}