Q30, run 2026-11-04-2024-sonnet-query
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']
sql run 1
13 entities have a foreign-currency issuer rating exactly at their country's ceiling. The ceilings are CV A and VD BB. Examples are E15 (CV, A) and E05 (VD, BB).
JSON: {"entities": ["E1028", "E1194", "E1039", "E5012", "E5091", "E5116", "E1101", "E1126", "E1236", "E15", "E05", "E5047", "E5124"]}
sql run 2
13 entities have an FC issuer rating exactly at the ceiling (A for CV, BB for VD), including E15 and E05. The full list is in the JSON.
JSON: {"entities": ["E5124", "E1039", "E1101", "E1126", "E5047", "E1236", "E5116", "E1194", "E5012", "E5091", "E15", "E05", "E1028"]}
sql run 3
Nine VD entities are at the BB ceiling and four CV entities are at the A ceiling (ceilings from A12 and A37). They are listed in the JSON.
JSON: {"entities": ["E5124", "E1236", "E5012", "E1101", "E05", "E5091", "E1028", "E1126", "E5047", "E1039", "E15", "E5116", "E1194"]}
sql+markdown run 1
E05 and E15. E05's FC rating BB equals the VD ceiling BB, and E15's A equals the CV ceiling A.
JSON: {"entities": ["E05", "E15"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E15']
sql+markdown run 2
13 entities had a FC rating exactly equal to their country's ceiling, which is A for CV and BB for VD (list in JSON).
JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E5012", "E5047", "E5091", "E5116", "E5124"]}
sql+markdown run 3
13 entities, listed in the JSON.
JSON: {"entities": ["E1028", "E5091", "E1039", "E5124", "E5012", "E5047", "E1101", "E1126", "E1194", "E15", "E05", "E1236", "E5116"]}
sparql run 1
(no answer found)
JSON: {"entities": ["E15"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E15']
sparql run 2
The list is in the JSON. The ceilings are A for Corvenia (CV) and BB for Valdoria (VD).
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E1028", "E1101", "E1126", "E05", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql run 3
Partial. The Valdoria and Corvenia ceilings match E05 (BB) and E15 (A); other countries 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 1
13 entities, listed in the JSON. These are entities whose foreign-currency rating equals the ceiling: A for CV and BB for VD. Domicile follows the RESEARCH record where records disagree.
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E1028", "E1101", "E1126", "E05", "E5012", "E5047", "E5091", "E5124", "E1236"]}
sparql+ontology run 2
The ceilings are CV = A and VD = BB. The entities whose FC rating equals the ceiling are in the JSON. Domicile follows the RESEARCH record where it exists.
JSON: {"entities": ["E1028", "E1101", "E1126", "E05", "E1236", "E5012", "E5047", "E5091", "E5124", "E1039", "E1194", "E15", "E5116"]}
sparql+ontology run 3
13 company entities. CV ceiling is A and VD ceiling is BB, and each of these has an FC rating exactly equal to its ceiling.
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E1028", "E1101", "E1126", "E1236", "E05", "E5012", "E5047", "E5091", "E5124"]}
sql+executed run 1
13 entities; the IDs are in the JSON. The ceilings are CV = A and VD = BB.
JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E5012", "E5047", "E5091", "E5116", "E5124"]}
sql+executed run 2
13 entities have an FC rating equal to their ceiling; they are listed in the JSON.
JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E5012", "E5047", "E5091", "E5116", "E5124"]}
sql+executed run 3
14 entities have a foreign-currency issuer rating exactly at their country's ceiling. They are listed in the JSON and include E05 (BB, VD ceiling BB) and E15 (A, CV ceiling A).
JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15", "E5012", "E5047", "E5091", "E5116", "E5124", "E1019x"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124'], got ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15', 'E5012', 'E5047', 'E5091', 'E5116', 'E5124', 'E1019x']
sparql+axioms run 1
The foreign-currency rating equals the ceiling for CV entities at A (E1039, E1194, E15, E5116) and for VD entities at BB (the other nine in the list). The ceilings are CV A (A37) and VD BB (A12).
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E1028", "E1101", "E1126", "E05", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql+axioms run 2
Foreign-currency issuer ratings in force equal to the ceiling of the entity's domicile (CV = A from A37, VD = BB from A12).
JSON: {"entities": ["E1039", "E1194", "E15", "E5116", "E1028", "E1101", "E1126", "E05", "E1236", "E5012", "E5047", "E5091", "E5124"]}
sparql+axioms run 3
E05, E1028, E1101, E1126, E1236, E5012, E5047, E5091 and E5124 are at the VD ceiling of BB. E15, E1039, E1194 and E5116 are at the CV ceiling of A.
JSON: {"entities": ["E05", "E1028", "E1101", "E1126", "E1236", "E5012", "E5047", "E5091", "E5124", "E15", "E1039", "E1194", "E5116"]}