Q1, run 2026-11-04-1738-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 last action before 1 Jan 2025 was A01 (A-, 2024-03-12); the downgrade A02 came on 2025-06-20.
JSON: {"rating": "A-"}
sql run 2
A-. E01's last action before 1 Jan 2025 was A01 (A-); the downgrade to BBB (A02) came on 2025-06-20.
JSON: {"rating": "A-"}
sql run 3
A-. Kestrel Energy plc (E01) was assigned A- on 2024-03-12 (A01) and not downgraded until 2025-06-20 (A02).
JSON: {"rating": "A-"}
sql run 4
A-. Kestrel Energy (E01) was rated A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql run 5
A-. Kestrel's FC issuer rating was A- from A01 (2024-03-12) and was cut to BBB only on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sql+markdown run 1
A-. E01's LTIDR FC was A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 2
A-. E01's LTIDR FC was A- from A01 (2024-03-12). The downgrade to BBB (A02) came on 2025-06-20, after that date.
JSON: {"rating": "A-"}
sql+markdown run 3
A-. E01's rating was A- from A01 (2024-03-12) until it was downgraded to BBB on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sql+markdown run 4
A-. The A01 rating (A-, assigned 2024-03-12) held until the A02 downgrade on 2025-06-20.
JSON: {"rating": "A-"}
sql+markdown run 5
A-. Kestrel Energy (E01) was assigned A- on 2024-03-12 (A01) and not downgraded until 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql run 1
A-. Kestrel Energy (E01) was assigned A- on 2024-03-12 (A01), and the downgrade to BBB came later, on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql run 2
A-. Kestrel Energy (E01) was rated A- from A01 (2024-03-12) until the downgrade to BBB in A02 (2025-06-20).
JSON: {"rating": "A-"}
sparql run 3
A-. The FC issuer rating was A- from A01 (2024-03-12) and was cut to BBB only on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql run 4
A-. A01 set Kestrel Energy (E01) at A- on 2024-03-12, and the next action (A02) came on 2025-06-20, so A- held on 1 Jan 2025.
JSON: {"rating": "A-"}
sparql run 5
A-. E01's A- (A01, 2024-03-12) was still in force until the downgrade to BBB (A02) on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 1
A-. E01's rating was A- (A01, assigned 2024-03-12) until the downgrade to BBB on 2025-06-20 (A02).
JSON: {"rating": "A-"}
sparql+ontology run 2
A-. E01's rating was set by A01 (A-, 2024-03-12) and stayed until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 3
A-. Kestrel Energy (E01) held A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}
sparql+ontology run 4
A-. Kestrel Energy (E01) was assigned A- on 2024-03-12 (A01), and the downgrade to BBB came on 2025-06-20 (A02), after 1 Jan 2025.
JSON: {"rating": "A-"}
sparql+ontology run 5
A-. Kestrel's FC LTIDR was A- from A01 (2024-03-12) until the downgrade A02 on 2025-06-20.
JSON: {"rating": "A-"}