Q30, run 2026-11-05-1515-sonnet-query

← back to the run

Which entities had a foreign-currency issuer rating exactly at their country's ceiling on 1 October 2026?

Tests: Ceilings: which ratings the cap binds.

Expected: entities = ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124']

✅ D1 sql run 1 graded by code · query session

13 entities (list in JSON) have a foreign-currency issuer rating exactly at their country's ceiling. Ceilings are A for CV (A37) and BB for VD (A12).

JSON: {"entities": ["E5047", "E1028", "E5124", "E5012", "E1101", "E1126", "E1039", "E1236", "E1194", "E5116", "E5091", "E05", "E15"]}

❌ D1 sql run 2 graded by code · query session

E05 (BB, A14) and E15 (A, A41) sit at their country ceilings (VD BB, CV A). I did not check the other entities domiciled in those countries.

JSON: {"entities": ["E05", "E15"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']

✅ D1 sql run 3 graded by code · query session

The list is in the JSON. The ceilings are CV = A (A37) and VD = BB (A12); the list is entities in each country whose foreign-currency rating equals it.

JSON: {"entities": ["E15", "E1039", "E1194", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}

✅ D1 sql run 4 graded by code · query session

(no answer found)

JSON: {"entities": ["E1101", "E5012", "E5047", "E5091", "E5116", "E5124", "E15", "E1236", "E1039", "E05", "E1028", "E1126", "E1194"]}

✅ D1 sql run 5 graded by code · query session

13 entities, listed in the JSON. The ceiling is BB for VD and A for CV.

JSON: {"entities": ["E1101", "E1126", "E5124", "E5047", "E5012", "E5091", "E1236", "E1028", "E05", "E5116", "E15", "E1194", "E1039"]}

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

13 entities had an FC rating exactly at their country's ceiling (BB for VD, A for CV); the list is in the JSON.

JSON: {"entities": ["E5012", "E5047", "E1126", "E1101", "E1028", "E5091", "E05", "E5124", "E1236", "E1039", "E5116", "E1194", "E15"]}

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

13 entities had an FC rating equal to their country's ceiling; the IDs are in the JSON.

JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15", "E5012", "E5047", "E5091", "E5116", "E5124"]}

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

13 entities have an FC rating equal to their country's ceiling, including E15 and E05; the list is in the JSON.

JSON: {"entities": ["E5047", "E1194", "E5124", "E15", "E1101", "E1039", "E1028", "E5116", "E5091", "E1126", "E1236", "E5012", "E05"]}

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

See the list in the JSON. These are entities whose FC LTIDR equalled their country's ceiling on 2026-10-01, using the RESEARCH country where records disagree.

JSON: {"entities": ["E1039", "E1028", "E1126", "E1101", "E05", "E5047", "E1236", "E5091", "E1194", "E5116", "E5124", "E15", "E5012"]}

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

13 entities (list in the JSON), including E15 and E05, whose foreign-currency ratings equal their country's ceiling.

JSON: {"entities": ["E1039", "E15", "E1028", "E1194", "E1101", "E1236", "E5116", "E1126", "E5091", "E05", "E5012", "E5047", "E5124"]}

❌ D4 sparql run 1 graded by code · query session

Not fully determined. E05 at BB (ceiling BB) and E15 at A (ceiling A) are at the ceiling, but I could not scan all CV and VD entities.

JSON: {"entities": ["E05", "E15"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']

✅ D4 sparql run 2 graded by code · query session

13 entities. Their foreign-currency issuer rating equals their country's ceiling (listed in the JSON).

JSON: {"entities": ["E1028", "E1039", "E1101", "E1126", "E05", "E1194", "E1236", "E15", "E5012", "E5047", "E5091", "E5116", "E5124"]}

❌ D4 sparql run 3 graded by code · query session

(no answer found)

JSON: {"entities": null}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got None

❌ D4 sparql run 4 graded by code · query session

The ones I could confirm are in the JSON. They sit at the CV ceiling of A or the VD ceiling of BB, but country assignments for some entities were not checked, so the list is partial.

JSON: {"entities": ["E15", "E1039", "E05", "E1028", "E5012", "E5047"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E15', 'E1039', 'E05', 'E1028', 'E5012', 'E5047']

✅ D4 sparql run 5 graded by code · query session

The entities whose foreign-currency rating equals their country's ceiling are in the JSON below.

JSON: {"entities": ["E1028", "E1101", "E1126", "E05", "E1236", "E5012", "E5047", "E5091", "E5124", "E1039", "E1194", "E15", "E5116"]}

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

(no answer found)

JSON: {"entities": []}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got []

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

E05, E1028 (both BB, VD's ceiling) and E15 (A, CV's ceiling). This list may be incomplete.

JSON: {"entities": ["E05", "E1028", "E15"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E1028', 'E15']

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

Partial: E05 and E15. Their FC ratings equal their ceilings (BB for VD, A for CV); I did not check other VD/CV entities.

JSON: {"entities": ["E05", "E15"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']

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

13 entities; the list is in the JSON. Each has a foreign-currency rating equal to its country's ceiling.

JSON: {"entities": ["E1194", "E5116", "E1039", "E15", "E5012", "E5124", "E1101", "E1236", "E5047", "E5091", "E1028", "E1126", "E05"]}

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

Entities at the ceiling: BB for VD entities and A for CV entities. This relies on the country on each entity's own record.

JSON: {"entities": ["E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124", "E1039", "E1194", "E15", "E5116"]}

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

13 entities had an FC rating exactly at their country's ceiling (listed in the JSON).

JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15", "E5012", "E5047", "E5091", "E5116", "E5124"]}

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

Thirteen entities were exactly at their country's ceiling (listed in the JSON). They include E05 and E15.

JSON: {"entities": ["E5012", "E1236", "E5047", "E1194", "E5091", "E15", "E5116", "E5124", "E1028", "E1126", "E05", "E1101", "E1039"]}

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

13 entities sit exactly at their country's ceiling (BB for VD, A for CV). The list is in the JSON.

JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E5012", "E5047", "E5091", "E5116", "E5124"]}

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

13 entities sit exactly at their ceiling: CV (A) E1194, E15, E5116, E1039; VD (BB) E1028, E5091, E1126, E1101, E5012, E5124, E5047, E1236, E05.

JSON: {"entities": ["E1194", "E15", "E5116", "E1039", "E1028", "E5091", "E1126", "E1101", "E5012", "E5124", "E5047", "E1236", "E05"]}

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

13 entities have a rating equal to their country ceiling; see the JSON.

JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E5012", "E5047", "E5091", "E5116", "E5124"]}

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

13 entities (listed in the JSON).

JSON: {"entities": ["E1028", "E1039", "E1101", "E1126", "E05", "E1194", "E1236", "E15", "E5012", "E5047", "E5091", "E5116", "E5124"]}

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

13 entities, listed in the JSON. Four Corvenia-domiciled entities sit at the A ceiling and nine Valdoria-domiciled entities at the BB ceiling.

JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}

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

Four CV entities (A) and nine VD entities (BB) have an FC rating exactly at their country's ceiling; they are listed in the JSON.

JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}

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

E05 (BB at the VD ceiling of BB) and E15 (A at the CV ceiling of A). I checked only a few entities, so this may be incomplete.

JSON: {"entities": ["E05", "E15"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']

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

The list is in the JSON; it includes E05 and E15.

JSON: {"entities": ["E1028", "E1039", "E1101", "E1126", "E05", "E1194", "E1236", "E15", "E5012", "E5047", "E5091", "E5116", "E5124"]}