Q19, run 2026-11-06-0935-sonnet-query
Which issuers had a Negative outlook on 1 October 2026?
Tests: Outlooks: set by affirmations, without a rating change.
Expected: issuers = ['E01', 'E09']
sql run 1
E01 (A03) and E09 (A25). E06's watch action carries no outlook.
JSON: {"issuers": ["E01", "E09"]}
sql run 2
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sql run 3
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sql run 4
E01 (A03) and E09 (A25). E06 is on watch, with no outlook shown.
JSON: {"issuers": ["E01", "E09"]}
sql run 5
E01 and E09, from A03 and A25.
JSON: {"issuers": ["E01", "E09"]}
sql+markdown run 1
E01 (A03) and E09 (A25). E06's outlook is blank on its watch action, so I have not counted it.
JSON: {"issuers": ["E01", "E09"]}
sql+markdown run 2
E01 and E09. They have NEG outlooks from A03 and A25.
JSON: {"issuers": ["E01", "E09"]}
sql+markdown run 3
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sql+markdown run 4
E01 (A03) and E09 (A25). E06's watch action carries no outlook, so I did not count it.
JSON: {"issuers": ["E01", "E09"]}
sql+markdown run 5
E01 and E09. A03 and A25 set NEG outlooks. E06's A17 left the outlook blank, so I did not count it.
JSON: {"issuers": ["E01", "E09"]}
sparql run 1
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sparql run 2
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sparql run 3
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sparql run 4
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sparql run 5
E01 and E09 (A03, A25).
JSON: {"issuers": ["E01", "E09"]}
sparql+ontology run 1
E01 and E09, from A03 and A25.
JSON: {"issuers": ["E01", "E09"]}
sparql+ontology run 2
E01 and E09. A03 and A25 are their latest actions, and both carry a NEG outlook.
JSON: {"issuers": ["E01", "E09"]}
sparql+ontology run 3
E01 and E09. Their latest actions (A03, A25) carry a NEG outlook.
JSON: {"issuers": ["E01", "E09"]}
sparql+ontology run 4
E01 and E09. These are the two entities whose latest outlook is NEG (A03 and A25). E06's latest action, A17, carries no outlook.
JSON: {"issuers": ["E01", "E09"]}
sparql+ontology run 5
E01 (A03) and E09 (A25). E06's Watch action records no outlook, so I have not counted it.
JSON: {"issuers": ["E01", "E09"]}
sql+executed run 1
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sql+executed run 2
E01 and E09 (A03, A25).
JSON: {"issuers": ["E01", "E09"]}
sql+executed run 3
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sql+executed run 4
E01 and E09 (A03, A25).
JSON: {"issuers": ["E01", "E09"]}
sql+executed run 5
E01 and E09 (A03, A25).
JSON: {"issuers": ["E01", "E09"]}
sparql+axioms run 1
E01 and E09 (A03, A25).
JSON: {"issuers": ["E01", "E09"]}
sparql+axioms run 2
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sparql+axioms run 3
E01 and E09 (A03, A25).
JSON: {"issuers": ["E01", "E09"]}
sparql+axioms run 4
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}
sparql+axioms run 5
E01 (A03) and E09 (A25).
JSON: {"issuers": ["E01", "E09"]}