Q15, run 2026-11-06-0041-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 was rated A- (A26) until the downgrade on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql run 2
A-, from A26. The downgrade to BBB+ (A27) came on 2026-04-15.
JSON: {"rating": "A-"}
sql run 3
A-. E10 was assigned A- (A26), and the downgrade to BBB+ (A27) came on 2026-04-15.
JSON: {"rating": "A-"}
sql run 4
A-. E10 was only cut on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql run 5
A-. Halden Bank (E10) was not downgraded to BBB+ until A27 on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E10 is the same entity as E17, and the downgrade to BBB+ came on 2026-04-15, after this date.
JSON: {"rating": "A-"}
sql+markdown run 2
A-, from A26. The downgrade A27 only came on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. E10 (Halden Bank) was assigned A- (A26) and not downgraded until 2026-04-15 (A27). E17 is a RESEARCH record of the same LEI.
JSON: {"rating": "A-"}
sql+markdown run 4
A-. The downgrade to BBB+ (A27) came on 2026-04-15, after that date.
JSON: {"rating": "A-"}
sql+markdown run 5
A-. Halden Bank (E10) was downgraded to BBB+ only on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql run 1
A-, from A26. The downgrade to BBB+ (A27) came on 2026-04-15.
JSON: {"rating": "A-"}
sparql run 2
A-. Halden Bank (E10) was cut to BBB+ only on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql run 3
A- (A26). E10 was downgraded only on 2026-04-15.
JSON: {"rating": "A-"}
sparql run 4
A-. E10 held A- (A26) until the downgrade on 2026-04-15.
JSON: {"rating": "A-"}
sparql run 5
A-. E10's rating was A- (A26) until the downgrade on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. E10 was downgraded to BBB+ only on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. E10's rating was A- from A26 until the downgrade on 2026-04-15 (A27). E17 is the same entity.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. E10 was assigned A- (A26) and not downgraded until 2026-04-15 (A27). I used E10 and ignored E17, which has the same LEI.
JSON: {"rating": "A-"}
sparql+ontology run 4
A-. A26 (A-, 2023-05-01) held until A27 on 2026-04-15, and E17 (same LEI) has no actions.
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. E10's downgrade to BBB+ (A27) came on 2026-04-15, after the date asked about.
JSON: {"rating": "A-"}
sql+executed run 1
A-. E10 held A- (A26) until 2026-04-15.
JSON: {"rating": "A-"}
sql+executed run 2
A-. E10 held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sql+executed run 3
A-. E10 was A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sql+executed run 4
A- (A26, valid to 2026-04-15).
JSON: {"rating": "A-"}
sql+executed run 5
A-. E10 held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 1
A-. E10 and E17 are the same entity, and A26 ran until 2026-04-15.
JSON: {"rating": "A-"}
sparql+axioms run 2
A- (A26, E10).
JSON: {"rating": "A-"}
sparql+axioms run 3
A-. A26 on E10, which is the same entity as E17.
JSON: {"rating": "A-"}
sparql+axioms run 4
A-. A26 was in force until 2026-04-15.
JSON: {"rating": "A-"}
sparql+axioms run 5
A-. E10's rating (A26) was in force until 2026-04-15.
JSON: {"rating": "A-"}