Q30, run 2026-11-04-1738-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']

✅ D1 sql run 1 graded by code · query session

The 8 entities are in the JSON. The ceilings are A for CV and BB for VD, and these entities' FC ratings equal them exactly.

JSON: {"entities": ["E05", "E15", "E1028", "E1039", "E1101", "E1126", "E1194", "E1236"]}

✅ D1 sql run 2 graded by code · query session

8 entities: E15, E1039 and E1194 sit at the CV ceiling of A, and E05, E1028, E1236, E1126 and E1101 sit at the VD ceiling of BB.

JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1236", "E1126", "E1101"]}

✅ D1 sql run 3 graded by code · query session

Eight entities. Corvenia's ceiling is A (A37) and Valdoria's is BB (A12). The foreign-currency issuer ratings at those levels are A for E15, E1039 and E1194, and BB for E05, E1236, E1101, E1126 and E1028.

JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1236", "E1101", "E1126", "E1028"]}

✅ D1 sql run 4 graded by code · query session

E1039, E1194, E15 (Corvenia, ceiling A) and E05, E1028, E1101, E1126, E1236 (Valdoria, ceiling BB). The ceilings are taken from the Country Ceiling records A37 and A12.

JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}

✅ D1 sql run 5 graded by code · query session

8 entities. The CV ceiling is A, which E15, E1039 and E1194 sit at. The VD ceiling is BB, which E05, E1028, E1101, E1126 and E1236 sit at.

JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}

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

8 entities, listed in the JSON. Their FC rating equals the country ceiling (CV is A, VD is BB).

JSON: {"entities": ["E1039", "E1236", "E1101", "E05", "E1028", "E1126", "E1194", "E15"]}

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

8 entities had an FC rating exactly at the ceiling. At CV's ceiling of A: E1194, E1039, E15. At VD's ceiling of BB: E1028, E1101, E1126, E1236, E05.

JSON: {"entities": ["E1194", "E1039", "E15", "E1028", "E1101", "E1126", "E1236", "E05"]}

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

Eight entities: E1101, E1236, E05, E1028 and E1126 sit at VD's ceiling of BB, and E1039, E1194 and E15 sit at CV's ceiling of A.

JSON: {"entities": ["E1101", "E1236", "E05", "E1028", "E1126", "E1039", "E1194", "E15"]}

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

Eight entities were at their ceiling: five in VD at BB and three in CV at A (listed in the JSON).

JSON: {"entities": ["E05", "E1039", "E1028", "E1236", "E1126", "E1101", "E15", "E1194"]}

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

The list is in the JSON.

JSON: {"entities": ["E1126", "E1101", "E1236", "E1028", "E05", "E1194", "E1039", "E15"]}

✅ D4 sparql run 1 graded by code · query session

8 entities (IDs in the JSON). The ceilings are A for Corvenia and BB for Valdoria, and these entities are rated exactly at them.

JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}

✅ D4 sparql run 2 graded by code · query session

Eight entities have an FC rating exactly at their country ceiling. The ceilings are CV = A and VD = BB: E15, E1039 and E1194 at A, and E05, E1028, E1101, E1126 and E1236 at BB.

JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}

❌ D4 sparql run 3 graded by code · query session

The list in the JSON is partial. I only had the VD ceiling (BB) and the CV ceiling (BBB+), and the lists I pulled were truncated.

JSON: {"entities": ["E05", "E1028", "E1101", "E1126"]}

Why: entities: expected ['E05', 'E1028', 'E1039', 'E1101', 'E1126', 'E1194', 'E1236', 'E15'], got ['E05', 'E1028', 'E1101', 'E1126']

✅ D4 sparql run 4 graded by code · query session

Corvenia's ceiling is A and Valdoria's is BB. At the ceiling: E1039, E1194 and E15 (A, CV); E1028, E1101, E1126, E05 and E1236 (BB, VD).

JSON: {"entities": ["E1039", "E1194", "E15", "E1028", "E1101", "E1126", "E05", "E1236"]}

✅ D4 sparql run 5 graded by code · query session

E15 and E1039 and E1194 at the CV ceiling of A, plus E05, E1028, E1101, E1126 and E1236 at the VD ceiling of BB.

JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}

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

Five VD-domiciled entities sit at the BB ceiling, and E1039, E1194 and E15 sit at the A ceiling for CV. The sovereign CV is excluded.

JSON: {"entities": ["E1028", "E1101", "E1126", "E05", "E1236", "E1039", "E1194", "E15"]}

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

The 8 entities are in the JSON. Five VD-domiciled entities are at the BB ceiling and three CV-domiciled entities are at the A ceiling.

JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}

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

8 entities. The CV ceiling is A and E15, E1039 and E1194 are at A. The VD ceiling is BB and E05, E1028, E1101, E1126 and E1236 are at BB.

JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}

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

The Country Ceilings are A for CV (A37) and BB for VD (A12). The eight entities whose foreign-currency rating equals that ceiling are in the JSON.

JSON: {"entities": ["E15", "E1039", "E1194", "E05", "E1028", "E1101", "E1126", "E1236"]}

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

8 entities, listed in the JSON. Country Ceilings are A for CV and BB for VD, and these entities' FC ratings equal them.

JSON: {"entities": ["E1039", "E1194", "E15", "E05", "E1028", "E1101", "E1126", "E1236"]}