Q15, run 2026-11-05-1515-sonnet-query
What was Halden Bank's rating on 1 January 2026?
Tests: Time: the downgrade came later in 2026.
Expected: rating = A-
sql run 1
A-. E10's rating was A- (A26) until the 2026-04-15 downgrade (A27).
JSON: {"rating": "A-"}
sql run 2
A-. E10's downgrade to BBB+ came on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql run 3
A-. A27 (downgrade to BBB+) came only on 2026-04-15.
JSON: {"rating": "A-"}
sql run 4
A-. E10 was A- (A26) until the downgrade on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql run 5
A-. The downgrade to BBB+ (A27) came on 2026-04-15, after the date asked.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E10 and E17 share an LEI, and the downgrade to BBB+ came only on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql+markdown run 2
A-. E10's A26 holds until A27 on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. E10 and E17 are one entity; the downgrade to BBB+ (A27) came on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 4
A-. E10's downgrade to BBB+ (A27) is dated 2026-04-15, after 1 January 2026.
JSON: {"rating": "A-"}
sql+markdown run 5
A-. A26 applies until the downgrade A27 on 2026-04-15, and the E17 record shares E10's LEI.
JSON: {"rating": "A-"}
sparql run 1
A-. Halden Bank's downgrade to BBB+ (A27) came on 2026-04-15, after that date.
JSON: {"rating": "A-"}
sparql run 2
A-. E10's rating was A- until the downgrade on 2026-04-15. E17 shares E10's LEI.
JSON: {"rating": "A-"}
sparql run 3
A- (A26, E10). The downgrade came on 2026-04-15.
JSON: {"rating": "A-"}
sparql run 4
A-. E10's downgrade to BBB+ came only on 2026-04-15 (A26, A27).
JSON: {"rating": "A-"}
sparql run 5
A-. E10 held A- (A26) until the 2026-04-15 downgrade. E17 shares E10's LEI and carries no ratings.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. E10 and E17 share an LEI, so they are one entity, and E10 was A- until the 2026-04-15 downgrade.
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. E10's downgrade to BBB+ came on 2026-04-15, after the date.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. Halden Bank held A- from 2023-05-01 (A26) until the downgrade on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql+ontology run 4
A-. The downgrade to BBB+ came on 2026-04-15 (A27), after that date.
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. E10 held A- (A26) until the 2026-04-15 downgrade. E17 has the same LEI and no actions.
JSON: {"rating": "A-"}
sql+executed run 1
A- (A26).
JSON: {"rating": "A-"}
sql+executed run 2
A-. E10's rating on 2026-01-01 was A- (A26).
JSON: {"rating": "A-"}
sql+executed run 3
A-. E10's rating was A- (A26) until 2026-04-15.
JSON: {"rating": "A-"}
sql+executed run 4
A-. E10 held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sql+executed run 5
A-. E10 (merged with E17) was rated A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 1
A- (A26).
JSON: {"rating": "A-"}
sparql+axioms run 2
A-. Halden Bank (E10) held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 3
A-. Halden Bank's A26 held until the 2026-04-15 downgrade (A27).
JSON: {"rating": "A-"}
sparql+axioms run 4
A- (A26).
JSON: {"rating": "A-"}
sparql+axioms run 5
A- (A26).
JSON: {"rating": "A-"}