Q1, run 2026-11-04-2024-sonnet-query
What was Kestrel Energy's rating on 1 January 2025?
Tests: Time: a rating holds from one action to the next, so 'the rating on a date' is the latest action on or before it.
Expected: rating = A-
sql run 1
A-. E01's LTIDR was A- from A01 (2024-03-12), and the downgrade to BBB (A02) came only on 2025-06-20.
JSON: {"rating": "A-"}
sql run 2
A-. Kestrel's issuer rating (E01) was A- from A01 (2024-03-12) until it was downgraded on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sql run 3
A-. E01's rating was A- from A01 (2024-03-12) until it was downgraded to BBB in A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E01's LTIDR FC was A- from AS A01 (2024-03-12) until DG A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 2
A-. E01's FC LTIDR was A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. The 2024-03-12 assignment (A01) stood until the downgrade on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql run 1
A-. The last foreign-currency rating before 1 Jan 2025 was A01 (A-, 2024-03-12). The downgrade to BBB (A02) came on 2025-06-20.
JSON: {"rating": "A-"}
sparql run 2
A-. E01's rating was A- (A01, 2024-03-12) until it was downgraded on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql run 3
A-. A01 (2024-03-12) is the last rating before A02's downgrade on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. E01's LTIDR was A- (A01, 2024-03-12) until it was downgraded to BBB on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. The latest action on or before 1 Jan 2025 was A01 (2024-03-12, assigned A-). The downgrade to BBB (A02) came on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. Assigned A- on 2024-03-12 (A01) and downgraded to BBB only on 2025-06-20 (A02), so A- held on 1 Jan 2025.
JSON: {"rating": "A-"}
sql+executed run 1
A-. E01's LTIDR was A- from 2024-03-12 to 2025-06-20 (A01).
JSON: {"rating": "A-"}
sql+executed run 2
A-. Kestrel's FC LTIDR was A- from 2024-03-12 to 2025-06-20 (E01, A01).
JSON: {"rating": "A-"}
sql+executed run 3
A-. E01's rating of A- (A01) ran from 2024-03-12 to 2025-06-20, so it covered 1 January 2025.
JSON: {"rating": "A-"}
sparql+axioms run 1
A-. Action A01 (2024-03-12 to 2025-06-20) was in force on that date.
JSON: {"rating": "A-"}
sparql+axioms run 2
A-. Kestrel's rating in force on that date was A- (A01, valid to 2025-06-20).
JSON: {"rating": "A-"}
sparql+axioms run 3
A-. A01 held Kestrel (E01) at A- from 2024-03-12 to 2025-06-20.
JSON: {"rating": "A-"}