Q18, run 2026-11-06-0935-sonnet-query
Which issuers were on Rating Watch Negative on 1 October 2026?
Tests: Watch over time: Marlow's Watch ended with its 2026 affirmation.
Expected: issuers = ['E06']
sql run 1
E06. The watch from A17 is still open, whereas E14's watch (A35) was resolved by A33.
JSON: {"issuers": ["E06"]}
sql run 2
E06 (A17). E14's watch from A35 was resolved by the A33 affirmation, which has no watch.
JSON: {"issuers": ["E06"]}
sql run 3
E06, from A17.
JSON: {"issuers": ["E06"]}
sql run 4
E06, from A17. E14's watch (A35) was cleared by A33.
JSON: {"issuers": ["E06"]}
sql run 5
E06, from A17. E14's watch (A35) was resolved by A33.
JSON: {"issuers": ["E06"]}
sql+markdown run 1
E06, from A17. E14's earlier watch (A35) was cleared by A33.
JSON: {"issuers": ["E06"]}
sql+markdown run 2
E06. A17 (2026-09-03) put it on RWN. E14's watch (A35) was superseded by the affirmation A33, which carries no watch.
JSON: {"issuers": ["E06"]}
sql+markdown run 3
E06. A17 (2026-09-03) placed it on RWN. E14's Watch from A35 was followed by A33, which carries no watch.
JSON: {"issuers": ["E06"]}
sql+markdown run 4
E06 (A17). E14's watch (A35) was resolved by the affirmation A33.
JSON: {"issuers": ["E06"]}
sql+markdown run 5
E06. A17 placed it on RWN on 2026-09-03. E14's watch from A35 was cleared by A33.
JSON: {"issuers": ["E06"]}
sparql run 1
E06 (A17, unresolved). E14's watch was resolved by A33.
JSON: {"issuers": ["E06"]}
sparql run 2
E06, from A17.
JSON: {"issuers": ["E06"]}
sparql run 3
E06 (A17, 2026-09-03). E14's earlier watch (A35) was superseded by A33 with no watch.
JSON: {"issuers": ["E06"]}
sparql run 4
E06 (A17). Marlow's watch was resolved by A33.
JSON: {"issuers": ["E06"]}
sparql run 5
E06. E14's watch (A35) was resolved on 2026-05-01 (A33).
JSON: {"issuers": ["E06"]}
sparql+ontology run 1
E06. A17 placed it on RWN. E14's watch (A35) was cleared by A33.
JSON: {"issuers": ["E06"]}
sparql+ontology run 2
E06. A17 placed it on Watch Negative on 2026-09-03. E14's Watch from A35 was cleared by the affirmation A33.
JSON: {"issuers": ["E06"]}
sparql+ontology run 3
E06. A17 placed it on RWN on 2026-09-03. E14's Watch (A35) was cleared by the affirmation A33, which carries no watch.
JSON: {"issuers": ["E06"]}
sparql+ontology run 4
E06. Its Watch (A17, 2026-09-03) is still in place, whereas E14's Watch was resolved by A33.
JSON: {"issuers": ["E06"]}
sparql+ontology run 5
E06. E14's Watch (A35) was superseded by the affirmation A33, which carries no watch.
JSON: {"issuers": ["E06"]}
sql+executed run 1
E06 (A17).
JSON: {"issuers": ["E06"]}
sql+executed run 2
E06 (A17).
JSON: {"issuers": ["E06"]}
sql+executed run 3
E06 (A17). E14's watch ended on 2026-05-01.
JSON: {"issuers": ["E06"]}
sql+executed run 4
E06 (A17). E14's watch ended on 2026-05-01.
JSON: {"issuers": ["E06"]}
sql+executed run 5
E06 (A17).
JSON: {"issuers": ["E06"]}
sparql+axioms run 1
E06.
JSON: {"issuers": ["E06"]}
sparql+axioms run 2
E06 (A17).
JSON: {"issuers": ["E06"]}
sparql+axioms run 3
E06. A35 for Marlow ended on 2026-05-01.
JSON: {"issuers": ["E06"]}
sparql+axioms run 4
E06 (A17).
JSON: {"issuers": ["E06"]}
sparql+axioms run 5
E06 (A17).
JSON: {"issuers": ["E06"]}