Q42, run 2026-11-06-0041-sonnet-query
In which country is Halden Bank domiciled?
Tests: Local rule: where records disagree on country, the RESEARCH record holds.
Expected: country = LU
sql run 1
DE. E10 is domiciled in DE, and the LU record E17 is a RESEARCH duplicate with the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 2
DE (E10). E17 is a RESEARCH duplicate of E10 that shows LU.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 3
DE. E10 is the RATINGS record; E17, the LU record, is a RESEARCH duplicate with the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 4
DE. The LU country on E17 is a duplicate research record for the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 5
DE. E17 shows LU but is a research duplicate of E10, which is DE.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql+markdown run 1
LU. RESEARCH holds for domicile, and E17 says LU while E10 says DE.
JSON: {"country": "LU"}
sql+markdown run 2
LU. The RESEARCH record E17 holds for country.
JSON: {"country": "LU"}
sql+markdown run 3
LU. The RESEARCH record E17 holds for domicile, and it says LU, not DE.
JSON: {"country": "LU"}
sql+markdown run 4
LU. The RESEARCH record E17 holds for domicile, overriding DE on E10.
JSON: {"country": "LU"}
sql+markdown run 5
LU. The RESEARCH record E17 holds for domicile, overriding E10's DE.
JSON: {"country": "LU"}
sparql run 1
DE (E10). The LU record E17 is a research-source duplicate.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 2
DE. The LU record E17 is a duplicate of E10.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 3
DE. E10 is DE, though its duplicate record E17 says LU.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 4
DE (E10). E17 has the same LEI and says LU, so the data conflicts on this.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 5
DE (E10). The LU record E17 shares E10's LEI and appears to be a duplicate.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql+ontology run 1
LU. RESEARCH record E17 holds for country, over RATINGS' DE.
JSON: {"country": "LU"}
sparql+ontology run 2
LU. The RESEARCH record (E17) holds for country, over the RATINGS record's DE.
JSON: {"country": "LU"}
sparql+ontology run 3
LU. The RESEARCH record E17 holds for domicile over the RATINGS record E10 (DE).
JSON: {"country": "LU"}
sparql+ontology run 4
LU. The RESEARCH record E17 holds for domicile, overriding E10's DE.
JSON: {"country": "LU"}
sparql+ontology run 5
LU. RESEARCH record E17 holds for domicile, overriding DE.
JSON: {"country": "LU"}
sql+executed run 1
LU (E10).
JSON: {"country": "LU"}
sql+executed run 2
LU.
JSON: {"country": "LU"}
sql+executed run 3
LU (E10).
JSON: {"country": "LU"}
sql+executed run 4
LU (E10).
JSON: {"country": "LU"}
sql+executed run 5
LU (E10).
JSON: {"country": "LU"}
sparql+axioms run 1
LU.
JSON: {"country": "LU"}
sparql+axioms run 2
LU.
JSON: {"country": "LU"}
sparql+axioms run 3
LU. The derived domicile of E10 is LU, even though its country is DE.
JSON: {"country": "LU"}
sparql+axioms run 4
LU.
JSON: {"country": "LU"}
sparql+axioms run 5
LU. The derived domicile is LU, although the country field says DE.
JSON: {"country": "LU"}