Q30, run 2026-11-06-0041-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']
sql run 1
Eight entities. Corvenia's ceiling is A (A37), and E15, E1039 and E1194 are rated A. Valdoria's ceiling is BB (A12), and E05, E1028, E1101, E1126 and E1236 are rated BB.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}
sql run 2
E05, E1028, E1236, E1101 and E1126 at VD's BB ceiling, and E1039, E1194 and E15 at CV's A ceiling.
JSON: {"entities": ["E05", "E1028", "E1236", "E1101", "E1126", "E1039", "E1194", "E15"]}
sql run 3
E05, E1028, E1039, E1101, E1126, E1194, E1236 and E15. Each has a foreign-currency LTIDR equal to its country's ceiling.
JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15"]}
sql run 4
E05, E1028, E1101, E1126, E1236 (BB, Valdoria ceiling) and E15, E1039, E1194 (A, Corvenia ceiling).
JSON: {"entities": ["E05", "E1028", "E1101", "E1126", "E1236", "E15", "E1039", "E1194"]}
sql run 5
8 entities. Corvenia's ceiling is A and Valdoria's is BB, and these entities sit exactly at it.
JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}
sql+markdown run 1
Eight entities: E05, E1028, E1101, E1126 and E1236 at BB (VD ceiling), and E15, E1039 and E1194 at A (CV ceiling).
JSON: {"entities": ["E05", "E1126", "E1236", "E1194", "E15", "E1039", "E1028", "E1101"]}
sql+markdown run 2
Eight entities: E15, E1194 and E1039 at Corvenia's ceiling of A, and E1028, E1236, E05, E1101 and E1126 at Valdoria's ceiling of BB.
JSON: {"entities": ["E15", "E1194", "E1039", "E1028", "E1236", "E05", "E1101", "E1126"]}
sql+markdown run 3
8 entities have an FC rating exactly at their country's ceiling. In CV (ceiling A) they are E15, E1039 and E1194. In VD (ceiling BB) they are E05, E1028, E1101, E1126 and E1236.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}
sql+markdown run 4
Eight entities (listed in the JSON) had a foreign-currency rating exactly at their country's ceiling. They are E05, E15 and others in VD (ceiling BB) and CV (ceiling A).
JSON: {"entities": ["E1101", "E05", "E1236", "E1126", "E1028", "E15", "E1194", "E1039"]}
sql+markdown run 5
Eight entities were exactly at their country's ceiling (BB for VD, A for CV): E05, E1028, E1101, E1126, E1236, E1039, E15 and E1194. E1279 is excluded because its rating was withdrawn.
JSON: {"entities": ["E05", "E1028", "E1101", "E1126", "E1236", "E1039", "E15", "E1194"]}
sparql run 1
The entities in the JSON are rated exactly at their country's ceiling: BB for VD and A for CV.
JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15"]}
sparql run 2
The JSON list covers entities whose foreign-currency issuer rating equals their country's ceiling. The ceilings are CV = A and VD = BB. It may be incomplete.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1126"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15'], got ['E15', 'E1039', 'E1194', 'E05', 'E1028', 'E1126']
sparql run 3
E05 and E15. E05 is BB against a ceiling of BB (A12, A14), and E15 is A against a ceiling of A for CV (A37, A41). Other entities with hidden records are not checked.
JSON: {"entities": ["E05", "E15"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15'], got ['E05', 'E15']
sparql run 4
E15 and E05. I read A12 (BB) as Valdoria's ceiling, which matches E05's FC BB. Corvenia's ceiling is A (A37), which matches E15's FC A (A41).
JSON: {"entities": ["E15", "E05"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15'], got ['E15', 'E05']
sparql run 5
E15, E1039 and E1194 sit at the CV ceiling of A, and E05, E1028, E1101, E1126 and E1236 sit at the VD ceiling of BB. I compared each entity's latest foreign-currency rating with the ceiling.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}
sparql+ontology run 1
8 entities, listed in the JSON. Their foreign-currency ratings equal the ceiling: CV's A (E1039, E1194, E15) or VD's BB (E1028, E1101, E1126, E05, E1236).
JSON: {"entities": ["E1039", "E1194", "E15", "E1028", "E1101", "E1126", "E05", "E1236"]}
sparql+ontology run 2
Foreign-currency ratings exactly at the ceiling are in the JSON: the ceiling is A for CV (A37) and BB for VD (A12). That gives A for E1039, E1194 and E15, and BB for E1028, E1101, E1126, E1236 and E05.
JSON: {"entities": ["E1039", "E1194", "E15", "E1028", "E1101", "E1126", "E1236", "E05"]}
sparql+ontology run 3
8 entities, listed in the JSON. Their FC ratings equal the ceiling for their domicile: A for CV and BB for VD. About 25 rows of the CV/VD query were not shown, so this list may be incomplete.
JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236"]}
sparql+ontology run 4
Eight entities were at their ceiling. The CV ceiling is A and the VD ceiling is BB, and the ones at exactly that level are listed in the JSON.
JSON: {"entities": ["E1039", "E1194", "E15", "E1101", "E1236", "E1126", "E05", "E1028"]}
sparql+ontology run 5
E1039, E1194 and E15 sit at Corvenia's A ceiling. E05, E1028, E1101, E1126 and E1236 sit at Valdoria's BB ceiling.
JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}
sql+executed run 1
Eight entities had a foreign-currency rating exactly at their country's ceiling (the CV ceiling is A, the VD ceiling is BB). They are listed in the JSON.
JSON: {"entities": ["E05", "E1039", "E1236", "E1028", "E1194", "E1101", "E1126", "E15"]}
sql+executed run 2
8 entities. Corvenia's ceiling is A and E15, E1039 and E1194 are rated A. Valdoria's ceiling is BB and E05, E1028, E1101, E1126 and E1236 are rated BB.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}
sql+executed run 3
E15, E1039 and E1194 are at the CV ceiling of A. E05, E1236, E1101, E1126 and E1028 are at the VD ceiling of BB.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1236", "E1101", "E1126", "E1028"]}
sql+executed run 4
Eight entities were exactly at their country's ceiling: E05, E1028, E1101, E1126, E1236 (VD, BB) and E15, E1039, E1194 (CV, A).
JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236"]}
sql+executed run 5
8 entities were exactly at their country's ceiling: E05 (BB/BB), E1028, E1101, E1126, E1236 (all BB/BB), E1039, E1194 and E15 (all A/A).
JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15"]}
sparql+axioms run 1
E05, E1028, E1101, E1126 and E1236 (VD, ceiling BB, rated BB), plus E15, E1039 and E1194 (CV, ceiling A, rated A).
JSON: {"entities": ["E05", "E1028", "E1101", "E1126", "E1236", "E15", "E1039", "E1194"]}
sparql+axioms run 2
Corvenia's ceiling is A and Valdoria's is BB. Entities rated exactly at their ceiling are in the JSON list.
JSON: {"entities": ["E1039", "E1194", "E15", "E1028", "E1101", "E1126", "E05", "E1236"]}
sparql+axioms run 3
The entities listed in the JSON, whose foreign-currency rating equals their country's ceiling.
JSON: {"entities": ["E05", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236", "E15"]}
sparql+axioms run 4
The entities whose foreign-currency rating equals the ceiling: CV's ceiling is A (A37) and VD's is BB (A12). I took the matches from foreign-currency ratings in force.
JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}
sparql+axioms run 5
E15 (A), E1039 (A), E05 (BB) and E1028 (BB), each at the ceiling of its own country. Only CV and VD ceilings were checked.
JSON: {"entities": ["E15", "E1039", "E05", "E1028"]}
Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15'], got ['E15', 'E1039', 'E05', 'E1028']