Q30, run 2026-11-05-1819-sonnet-query-graphdb
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']
sparql run 1
The Country Ceiling data covers only CV (A) and VD (BB). The entities at exactly those levels are E1194, E15, E1039 and E5116 in CV, and E5124, E1236, E1126, E05, E5047, E1028, E5091, E5012 and E1101 in VD.
JSON: {"entities": ["E1194", "E15", "E1039", "E5116", "E5124", "E1236", "E1126", "E05", "E5047", "E1028", "E5091", "E5012", "E1101"]}
sparql run 2
See JSON. The ceilings are A for CV and BB for VD, and these entities' foreign-currency ratings equal them.
JSON: {"entities": ["E1194", "E15", "E5116", "E1039", "E1101", "E1028", "E1126", "E5012", "E1236", "E5047", "E5124", "E5091", "E05"]}
sparql run 3
Partial: E15 (A foreign-currency rating at the A ceiling for CV), E05 (BB at the BB ceiling for VD) and E5012 (BB, VD). The full check did not run, so there may be others.
JSON: {"entities": ["E15", "E05", "E5012"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E15', 'E05', 'E5012']
sparql run 4
These are the Corvenia entities rated A (the ceiling is A, A37) and the Valdoria entities rated BB (the ceiling is BB, A12).
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql run 5
The 13 entities in the JSON have a foreign-currency issuer rating equal to the Country Ceiling. The ceilings are A for CV (A37) and BB for VD (A12).
JSON: {"entities": ["E1194", "E15", "E1039", "E5116", "E5124", "E1236", "E1126", "E05", "E5047", "E1028", "E1101", "E5091", "E5012"]}
sparql+ontology run 1
13 entities have an FC rating exactly at their ceiling. The ceilings are A for CV and BB for VD, and domicile follows the RESEARCH record where records disagree.
JSON: {"entities": ["E1194", "E15", "E5116", "E1039", "E1101", "E1028", "E5012", "E1236", "E5047", "E5124", "E5091", "E1126", "E05"]}
sparql+ontology run 2
Listed in the JSON, against a CV ceiling of A and a VD ceiling of BB.
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql+ontology run 3
E05 (BB, ceiling BB) and E15 (A, ceiling A); other entities were not checked.
JSON: {"entities": ["E05", "E15"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']
sparql+ontology run 4
13 entities, listed in the JSON. At the CV ceiling of A: E1039, E1194, E15, E5116. At the VD ceiling of BB: E05, E1028, E1101, E1126, E1236, E5012, E5047, E5091, E5124.
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql+ontology run 5
Partial: only the visible rows could be checked. Entities with a foreign-currency rating equal to the ceiling (BB for VD, A for CV) are listed in the JSON.
JSON: {"entities": ["E5124", "E1236", "E1126", "E05", "E5047", "E1028", "E5012", "E5091", "E1194", "E15", "E1039", "E5116"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E5124', 'E1236', 'E1126', 'E05', 'E5047', 'E1028', 'E5012', 'E5091', 'E1194', 'E15', 'E1039', 'E5116']
sparql+axioms run 1
E05, E5047 and E5012 at Valdoria's BB ceiling, and E15 at Corvenia's A ceiling. This is a partial, best-effort list.
JSON: {"entities": ["E05", "E5047", "E5012", "E15"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E5047', 'E5012', 'E15']
sparql+axioms run 2
E05, E15 (?). E05's BB equals Valdoria's ceiling (A14, A12), and E15's A equals Corvenia's ceiling (A41, A37). Other entities were not checked.
JSON: {"entities": ["E05", "E15"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']
sparql+axioms run 3
13 entities. Five are domiciled in CV, where the ceiling is A, and eight in VD, where it is BB. Two are rated A and BB respectively in the same way as E15 and E05; the full list is in the JSON.
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql+axioms run 4
The JSON lists the entities whose foreign-currency rating equals the ceiling in CV (A) and VD (BB). I could not check other countries' ceilings.
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql+axioms run 5
The 13 entities in the JSON have a foreign-currency rating equal to their country's ceiling (A for CV, BB for VD).
JSON: {"entities": ["E1194", "E15", "E5116", "E1039", "E5124", "E1236", "E1126", "E05", "E5047", "E1028", "E1101", "E5091", "E5012"]}