Q1, run 2026-11-06-0935-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-. Kestrel's LTIDR was A- from A01 (2024-03-12) until the downgrade to BBB in A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql run 2
A-. A01 assigned A- on 2024-03-12, and the downgrade to BBB (A02) only came on 2025-06-20.
JSON: {"rating": "A-"}
sql run 3
A-. Kestrel'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 4
A-. The last action before that date was A01 (2024-03-12, A-), and the downgrade A02 only came on 2025-06-20.
JSON: {"rating": "A-"}
sql run 5
A-. Kestrel's rating was A- from A01 (2024-03-12) until the downgrade to BBB in A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E01's rating was set at A- by A01 and stayed there until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 2
A-. E01's rating was A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. Kestrel's LTIDR was A- from A01 (2024-03-12) until the downgrade to BBB in A02 (2025-06-20).
JSON: {"rating": "A-"}
sql+markdown run 4
A-. Kestrel's rating was A- from A01 until the downgrade to BBB on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sql+markdown run 5
A-. Kestrel's LTIDR FC was A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sparql run 1
A-. Kestrel's FC LT IDR was A- from A01 (2024-03-12). It was only cut to BBB on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql run 2
A-. Kestrel Energy's (E01) rating on 1 January 2025 was A-, assigned in A01 on 2024-03-12 and not changed until A02 on 2025-06-20.
JSON: {"rating": "A-"}
sparql run 3
A-. E01's long-term FC rating was A- from A01 (2024-03-12) until the downgrade to BBB in A02 (2025-06-20).
JSON: {"rating": "A-"}
sparql run 4
A-. The latest action on or before 1 Jan 2025 is A01 (2024-03-12); A02 downgraded it to BBB only on 2025-06-20.
JSON: {"rating": "A-"}
sparql run 5
A-. Kestrel Energy (E01) was assigned A- on 2024-03-12 (A01), and the next action was not until 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. E01's rating on 2025-01-01 was set by A01 (A-); the downgrade A02 came later, on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. Kestrel's FC long-term rating was set to A- by A01 (2024-03-12) and not changed until A02 (2025-06-20).
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. Kestrel Energy (E01) was A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 4
A-. Kestrel's FC LTIDR was set at A- by A01 and was not cut to BBB until A02 on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. Kestrel's FC LTIDR was A- from A01 (2024-03-12) until the downgrade to BBB in A02 (2025-06-20).
JSON: {"rating": "A-"}
sql+executed run 1
A-. E01's rating was A- (A01) from 2024-03-12 to 2025-06-20.
JSON: {"rating": "A-"}
sql+executed run 2
A-. E01's FC LTIDR was A- from 2024-03-12 to 2025-06-20 (A01), so it covered 1 Jan 2025.
JSON: {"rating": "A-"}
sql+executed run 3
A-. Kestrel's foreign-currency long-term rating was A- on that date (A01, valid 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}
sql+executed run 4
A-. E01's foreign-currency issuer rating on 1 Jan 2025 was A- (A01, valid 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}
sql+executed run 5
A-. E01's foreign-currency issuer rating on 2025-01-01 was A- (A01, valid 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}
sparql+axioms run 1
A-. Kestrel Energy's issuer rating on 1 Jan 2025 was A- (A01, valid 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}
sparql+axioms run 2
A-. Kestrel's foreign-currency issuer rating on 1 Jan 2025 was A- (A01, valid 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}
sparql+axioms run 3
A-. Kestrel's foreign-currency long-term rating was A- on that date (A01, valid 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}
sparql+axioms run 4
A-. Action A01 (E01, long-term foreign-currency issuer rating) held from 2024-03-12 to 2025-06-20.
JSON: {"rating": "A-"}
sparql+axioms run 5
A-. Kestrel's long-term foreign-currency rating on that date was A- (A01, 2024-03-12 to 2025-06-20).
JSON: {"rating": "A-"}