Q15, run 2026-11-04-2024-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 A- from A26 until the downgrade on 2026-04-15.
JSON: {"rating": "A-"}
sql run 2
A-. E10's rating was A- from A26 until the downgrade to BBB+ on 2026-04-15 (A27). E17 is a duplicate record with no ratings.
JSON: {"rating": "A-"}
sql run 3
A-. E10's rating was A- (A26) until the downgrade in A27 on 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E10 and E17 share an LEI; A26 set A- and the DG A27 came on 2026-04-15.
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- (A26; the downgrade A27 came on 2026-04-15).
JSON: {"rating": "A-"}
sparql run 1
A-. This is E10's rating (A26). The 2026-04-15 downgrade to BBB+ came later.
JSON: {"rating": "A-"}
sparql run 2
A-. Halden Bank (E10) held A- from 2023-05-01 until the downgrade on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql run 3
A-. E10 was A- (A26) until the downgrade on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 1
A- (A26). The downgrade to BBB+ (A27) came on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. A26 set it, and the downgrade A27 came only on 2026-04-15. E17 is the same entity under the same LEI.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. Halden Bank is E10, and E17 is the same entity by LEI. E10's DG to BBB+ came on 2026-04-15, after 1 Jan 2026.
JSON: {"rating": "A-"}
sql+executed run 1
A- (A26).
JSON: {"rating": "A-"}
sql+executed run 2
A- (E10, A26).
JSON: {"rating": "A-"}
sql+executed run 3
A-. E10 (merged with E17) held A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 1
A-. E10 and its duplicate E17 were rated A- until 2026-04-15 (A26).
JSON: {"rating": "A-"}
sparql+axioms run 2
A- (A26, valid to 2026-04-15).
JSON: {"rating": "A-"}
sparql+axioms run 3
A-. A26 applied until 2026-04-15.
JSON: {"rating": "A-"}