Q15, run 2026-11-04-1738-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- (A26) until the downgrade A27 on 2026-04-15.
JSON: {"rating": "A-"}
sql run 2
A-. A26 set E10 at A-, and the downgrade A27 came only on 2026-04-15.
JSON: {"rating": "A-"}
sql run 3
A-. Halden Bank (E10) was cut to BBB+ only on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql run 4
A-. The downgrade A27 only came on 2026-04-15.
JSON: {"rating": "A-"}
sql run 5
A-. E10's downgrade, A27, was not until 2026-04-15.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E10 was downgraded to BBB+ only on 2026-04-15 (A27). E17 is the same LEI.
JSON: {"rating": "A-"}
sql+markdown run 2
A-. E10 was A- (A26) until the downgrade to BBB+ on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sql+markdown run 3
A-. E10's downgrade to BBB+ (A27) came on 2026-04-15, after 1 January 2026.
JSON: {"rating": "A-"}
sql+markdown run 4
A-. E10's downgrade to BBB+ (A27) is dated 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-. Halden Bank (E10) was rated A- (A26) until the downgrade on 2026-04-15 (A27).
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-. E10 held A- from A26 until the downgrade on 2026-04-15. E17 is only a duplicate record of E10.
JSON: {"rating": "A-"}
sparql run 4
A-. E10 was A- (A26) until the downgrade to BBB+ on 2026-04-15 (A27). E17 is a duplicate record of E10 and has no ratings.
JSON: {"rating": "A-"}
sparql run 5
A-. E10 was A- (A26) until the downgrade to BBB+ on 2026-04-15 (A27). E17 is a research duplicate of E10, since it shares E10's LEI.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. E10's rating was A- (A26) until the downgrade on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. E10's rating was A- from A26 until the downgrade A27 on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. E10's rating was A- from A26 until the downgrade A27 on 2026-04-15.
JSON: {"rating": "A-"}
sparql+ontology run 4
A-. E10 was A- (A26) until the downgrade to BBB+ on 2026-04-15 (A27).
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. A26 was in force until the downgrade A27 on 2026-04-15.
JSON: {"rating": "A-"}