Q42, run 2026-11-04-1738-sonnet-query
In which country is Halden Bank domiciled?
Tests: Local rule: where records disagree, the RATINGS record holds.
Expected: country = DE
sql run 1
DE, from E10. E17's LU is a RESEARCH-source duplicate with the same LEI.
JSON: {"country": "DE"}
sql run 2
DE. E10 is domiciled in DE; the LU in E17 is a conflicting RESEARCH duplicate with the same LEI.
JSON: {"country": "DE"}
sql run 3
DE. The RATINGS record E10 says DE, and the research duplicate E17 says LU. I took the RATINGS record as authoritative.
JSON: {"country": "DE"}
sql run 4
DE. E10 is the RATINGS record, while E17 (LU) is a RESEARCH duplicate with the same LEI.
JSON: {"country": "DE"}
sql run 5
DE. E10 is in the RATINGS system. E17 (LU) is a RESEARCH duplicate with the same LEI.
JSON: {"country": "DE"}
sql+markdown run 1
DE. This is the RATINGS record E10, which holds over the RESEARCH record E17 (LU).
JSON: {"country": "DE"}
sql+markdown run 2
DE. The RATINGS record E10 holds, over RESEARCH record E17 (LU).
JSON: {"country": "DE"}
sql+markdown run 3
DE. The RATINGS record E10 holds, over the LU in E17.
JSON: {"country": "DE"}
sql+markdown run 4
DE. The RATINGS record E10 holds; the RESEARCH duplicate E17 says LU.
JSON: {"country": "DE"}
sql+markdown run 5
DE. The RATINGS record E10 holds; the RESEARCH record E17 says LU.
JSON: {"country": "DE"}
sparql run 1
DE. The LU record E17 is a duplicate of E10 by LEI.
JSON: {"country": "DE"}
sparql run 2
DE (E10). The duplicate record E17 says LU, but it shares E10's LEI and comes from the RESEARCH source.
JSON: {"country": "DE"}
sparql run 3
DE. E17 (LU) is a duplicate of E10 with the same LEI.
JSON: {"country": "DE"}
sparql run 4
DE (E10). E17 is a duplicate record of E10 that carries LU.
JSON: {"country": "DE"}
sparql run 5
DE. E10 is domiciled in Germany; E17's LU record is a research duplicate with the same LEI.
JSON: {"country": "DE"}
sparql+ontology run 1
DE. The RATINGS record E10 holds over the RESEARCH record E17, which says LU.
JSON: {"country": "DE"}
sparql+ontology run 2
DE. The RATINGS record E10 holds, over the RESEARCH record E17, which says LU.
JSON: {"country": "DE"}
sparql+ontology run 3
DE. The RATINGS record E10 holds, over the RESEARCH record E17 that says LU.
JSON: {"country": "DE"}
sparql+ontology run 4
DE. The RATINGS record E10 holds, and the LU shown on E17 is only the RESEARCH copy.
JSON: {"country": "DE"}
sparql+ontology run 5
DE. The RATINGS record E10 holds over the RESEARCH record E17, which says LU.
JSON: {"country": "DE"}