Q43, run 2026-11-05-1515-sonnet-query
How many distinct entities are domiciled in Luxembourg (LU)?
Tests: Local rule: the RESEARCH record's country holds over the RATINGS record's, so Halden Bank is in LU.
Expected: count = 1
sql run 1
0. The only LU record is E17, a duplicate of the DE entity E10.
JSON: {"count": 0}
Why: count: expected 1, got 0
sql run 2
0. The only LU record, E17, duplicates the DE-domiciled Halden Bank.
JSON: {"count": 0}
Why: count: expected 1, got 0
sql run 3
0. The only LU record, E17, is a duplicate of E10, which is DE.
JSON: {"count": 0}
Why: count: expected 1, got 0
sql run 4
1.
JSON: {"count": 1}
sql run 5
0. The only LU record, E17, duplicates the German E10, so no distinct entity is domiciled in LU.
JSON: {"count": 0}
Why: count: expected 1, got 0
sql+markdown run 1
1, which is Halden Bank (E10).
JSON: {"count": 1}
sql+markdown run 2
1.
JSON: {"count": 1}
sql+markdown run 3
1 (E10/E17).
JSON: {"count": 1}
sql+markdown run 4
1.
JSON: {"count": 1}
sql+markdown run 5
1.
JSON: {"count": 1}
sparql run 1
1. The only LU record is E17, which is an alias of Halden Bank.
JSON: {"count": 1}
sparql run 2
1, but this is ambiguous. Only E17 says LU, and it shares E10's LEI, so it may just be a duplicate of a DE entity.
JSON: {"count": 1}
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 1, got None
sparql run 4
1. Only E17 is recorded as LU, and it duplicates E10, which is DE.
JSON: {"count": 1}
sparql run 5
1.
JSON: {"count": 1}
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 1, got None
sparql+ontology run 2
1.
JSON: {"count": 1}
sparql+ontology run 3
1. Only the LEI behind E17 resolves to LU after the RESEARCH override.
JSON: {"count": 1}
sparql+ontology run 4
1, which is Halden Bank (LEI 391200QYPVFF2O9K2039).
JSON: {"count": 1}
sparql+ontology run 5
1, the Halden Bank entity (E17 and E10 share an LEI).
JSON: {"count": 1}
sql+executed run 1
1 (E10).
JSON: {"count": 1}
sql+executed run 2
1 (E10 is the only LU entity).
JSON: {"count": 1}
sql+executed run 3
1 (E10).
JSON: {"count": 1}
sql+executed run 4
1.
JSON: {"count": 1}
sql+executed run 5
1.
JSON: {"count": 1}
sparql+axioms run 1
1. E10 and E17 are the same entity.
JSON: {"count": 1}
sparql+axioms run 2
1. E10 and E17 are the same entity.
JSON: {"count": 1}
sparql+axioms run 3
1 (E10/E17).
JSON: {"count": 1}
sparql+axioms run 4
1. Only E10 and E17 are in LU, and they are the same entity.
JSON: {"count": 1}
sparql+axioms run 5
1. Records E10 and E17 share one LEI.
JSON: {"count": 1}