Q4, run 2026-11-04-1738-sonnet-query
What is Northwind Holdings' current outlook?
Tests: Identity: two records with the same LEI are one entity, whatever their names.
Expected: outlook = positive
sql run 1
Positive. E03 (NORTHWIND HLDGS) shares E02's LEI, so it is the same entity, and its latest action A09 (2025-09-15) has outlook POS.
JSON: {"outlook": "POS"}
sql run 2
Positive. E03 is a RESEARCH duplicate of E02 (same LEI), and its A09 (2025-09-15) is the latest action, with outlook POS.
JSON: {"outlook": "POS"}
sql run 3
Positive. Northwind Holdings has two records, E02 and E03, with the same LEI. The latest action is A09 (E03, 2025-09-15), an affirmation at A with a Positive outlook.
JSON: {"outlook": "POS"}
sql run 4
Positive. E03 shares Northwind Holdings' LEI (213800PHEIYNJMHTDV74) with E02, so it is a duplicate record of the same entity. Its latest action, A09 (2025-09-15), has a POS outlook and supersedes E02's STA from A08.
JSON: {"outlook": "POS"}
sql run 5
Positive. E03 shares E02's LEI, so it is the same entity, and its A09 (2025-09-15) is the latest action, with a Positive outlook.
JSON: {"outlook": "POS"}
sql+markdown run 1
POS. E02 and E03 share an LEI, so they are the same entity. The latest action is A09 (2025-09-15) with outlook POS.
JSON: {"outlook": "POS"}
sql+markdown run 2
Positive (POS). E02 and E03 share an LEI, so they are one entity. The latest action is A09 (E03, 2025-09-15), which gives outlook POS.
JSON: {"outlook": "POS"}
sql+markdown run 3
Positive. E03 (NORTHWIND HLDGS) has the same LEI as E02, so they are one entity. The latest action is A09 (2025-09-15), which gave a POS outlook.
JSON: {"outlook": "POS"}
sql+markdown run 4
Positive. E02 and E03 share an LEI, so they are one entity, and the latest action is A09 (2025-09-15, POS).
JSON: {"outlook": "POS"}
sql+markdown run 5
Positive (POS). E02 and E03 share an LEI, so they are the same entity, and the latest action is A09 (2025-09-15, A, POS).
JSON: {"outlook": "POS"}
sparql run 1
Positive. E02 and E03 share one LEI, so they are the same entity. The latest action is A09 (2025-09-15), which affirmed A with a Positive outlook.
JSON: {"outlook": "Positive"}
sparql run 2
Positive. E03 is the research duplicate of E02 (same LEI). Its latest action, A09 (2025-09-15), has a Positive outlook and is more recent than A08 (Stable).
JSON: {"outlook": "Positive"}
sparql run 3
Positive. E02 and E03 share one LEI, so they are the same entity. The latest action is A09 (2025-09-15), an affirmation at A with a Positive outlook.
JSON: {"outlook": "Positive"}
sparql run 4
Positive. E03 shares E02's LEI, so it is a duplicate record of Northwind Holdings. Its latest action, A09 (2025-09-15), is A with a Positive outlook.
JSON: {"outlook": "Positive"}
sparql run 5
Positive. E03 is the same entity as E02 (same LEI) and carries the later action, A09 (2025-09-15, A, Positive), which supersedes A08 (Stable).
JSON: {"outlook": "Positive"}
sparql+ontology run 1
Positive. E02 and E03 share an LEI, so they are one entity, and the latest action is A09 (2025-09-15) with outlook POS.
JSON: {"outlook": "POS"}
sparql+ontology run 2
Positive. E03 is the same entity as E02 (same LEI), and its latest action, A09 on 2025-09-15, gives outlook POS.
JSON: {"outlook": "POS"}
sparql+ontology run 3
Positive. E03 is the RESEARCH record of the same LEI as E02, so both are one entity, and its latest action is A09 (2025-09-15), an affirmation at A with a Positive outlook.
JSON: {"outlook": "POS"}
sparql+ontology run 4
Positive. E02 and E03 share an LEI, so they are one entity, and the latest action is E03's A09 (2025-09-15), an affirmation at A with a Positive outlook.
JSON: {"outlook": "POS"}
sparql+ontology run 5
Positive. E02 and E03 share an LEI, and the latest action is A09 (2025-09-15, Positive).
JSON: {"outlook": "POS"}