Q37, run 2026-11-04-1644-haiku
How many distinct legal entities does the data describe?
Tests: Identity: records with the same LEI are one entity.
Expected: count = 16
csv run 1
17. There are 19 records, and E03 (same LEI as E02) and E17 (same LEI as E10) are duplicates. The two sovereigns (VD, CV) are counted as entities.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv run 2
17 counting the two sovereigns, which appear as entities in the data. There are 19 rows, and E03 and E17 duplicate E02 and E10 by LEI. Excluding the sovereigns, which have no LEI, gives 15.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv run 3
17. There are 19 records (E01–E17 plus VD and CV), minus two duplicate LEIs (E03 duplicates E02, E17 duplicates E10).
JSON: {"count": 17}
Why: count: expected 16, got 17
csv run 4
17. The 19 entity rows less two duplicate LEIs (E03 = E02, E17 = E10). Excluding the sovereigns (VD, CV), which have no LEI, gives 15.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv run 5
17. The data has 19 rows. E03 duplicates E02 and E17 duplicates E10 (same LEIs), which leaves 17 distinct entities, including the two sovereigns (VD, CV) that have no LEI.
JSON: {"count": 17}
Why: count: expected 16, got 17
rdf run 1
17
There are 19 records, but E03 duplicates E02 (same LEI), and E17 shares E10's LEI despite a different country (LU vs DE). Counting the sovereigns VD and CV, this gives 17 if E17 is the same entity as E10; if not, it is 18.
JSON: {"count": 17}
Why: count: expected 16, got 17
rdf run 2
17. There are 19 records, and E03 and E17 duplicate E02 and E10 by LEI. This count includes the two sovereigns (VD and CV), which have no LEI.
JSON: {"count": 17}
Why: count: expected 16, got 17
rdf run 3
17. There are 19 entity records, but E03 duplicates E02 and E17 duplicates E10 by LEI.
JSON: {"count": 17}
Why: count: expected 16, got 17
rdf run 4
17. There are 19 IDs (E01–E17, VD, CV). E03 duplicates E02's LEI and E17 duplicates E10's, so 17 remain. The sovereigns have no LEI, so the count includes them only as separate IDs.
JSON: {"count": 17}
Why: count: expected 16, got 17
rdf run 5
17
There are 19 entity records. E03 duplicates E02 and E17 duplicates E10 by LEI, leaving 17, including the two sovereigns, which have no LEI.
JSON: {"count": 17}
Why: count: expected 16, got 17
rdf+ontology run 1
16. The data has 19 entity records. E17 duplicates E10, E03 duplicates E02, and E16 is QA test data, which leaves 16.
JSON: {"count": 16}
rdf+ontology run 2
16.
There are 19 records. Remove E16 (QA), and merge E03 into E02 and E17 into E10 (same LEIs).
JSON: {"count": 16}
rdf+ontology run 3
16. The distinct entities are E01, E02, E04–E15, VD and CV. E16 is excluded as QA, and E03 and E17 are duplicates.
JSON: {"count": 16}
rdf+ontology run 4
16. This counts the 14 non-sovereign entities after merging E03 into E02 and E17 into E10, plus VD and CV. E16 is QA data and is excluded.
JSON: {"count": 16}
rdf+ontology run 5
16. This counts the distinct non-QA entities: E01, E02, E04–E15, VD and CV. E03 and E17 duplicate E02 and E10, and E16 is QA.
JSON: {"count": 16}
csv+ontology run 1
16. These are the distinct LEIs in RATINGS, counting the two sovereigns (VD and CV) and treating E03 and E17 as duplicates. QA record E16 is excluded.
JSON: {"count": 16}
csv+ontology run 2
16. There are 18 records; E03 and E17 duplicate E02 and E10 by LEI, and E16 is QA and excluded. The two sovereigns have no LEI, so they count as their own entities (VD, CV).
JSON: {"count": 16}
csv+ontology run 3
16. These are the distinct entities excluding the QA record E16, with E03 counted as E02 and E17 counted as E10.
JSON: {"count": 16}
csv+ontology run 4
16. The data has 19 records, but E03 duplicates E02 and E17 duplicates E10. E16 is a QA record and is excluded.
JSON: {"count": 16}
csv+ontology run 5
16
There are 19 records, minus E03 and E17 (duplicate LEIs), minus E16 (QA data), giving 16 distinct entities.
JSON: {"count": 16}
csv+markdown run 1
16. The data has 19 records, minus E16 (QA), minus E03 and E17 (duplicate LEIs of E02 and E10). This count includes the sovereigns VD and CV, which the ontology treats as entities even though they have no LEI. Excluding them gives 14.
JSON: {"count": 16}
csv+markdown run 2
16. The data describes 16 distinct LEIs or sovereigns, excluding the QA record E16 and counting E02/E03 and E10/E17 once each.
JSON: {"count": 16}
csv+markdown run 3
16. The data describes E01, E02, E04–E15 and the sovereigns VD and CV. E03 and E17 duplicate E02 and E10, and E16 is QA and excluded.
JSON: {"count": 16}
csv+markdown run 4
16. After dropping the QA record E16, the distinct entities are E01, E02, E04–E15 and the sovereigns VD and CV. If sovereigns are excluded, the count is 14.
JSON: {"count": 16}
csv+markdown run 5
16. This counts distinct LEIs (E03 merges into E02, and E17 into E10) plus the two sovereigns VD and CV, which the ontology counts as entities despite having no LEI. E16 is excluded as QA.
JSON: {"count": 16}
csv+padding run 1
17. The data has 19 entity records. Two are duplicates by LEI (E03 of E02, E17 of E10), leaving 17. This includes the two sovereigns (VD, CV), which have no LEI; without them the count is 15.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv+padding run 2
17. The file has 19 rows, but E03 duplicates E02 and E17 duplicates E10.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv+padding run 3
17. The data has 19 records; E03 duplicates E02's LEI and E17 duplicates E10's, leaving 17 distinct entities, including the two sovereigns.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv+padding run 4
17. The data has 19 rows, but E03 and E17 share LEIs with E02 and E10. The sovereigns VD and CV have no LEI but are counted as entities.
JSON: {"count": 17}
Why: count: expected 16, got 17
csv+padding run 5
17. There are 19 records, and E03 and E17 duplicate E02 and E10 by LEI.
JSON: {"count": 17}
Why: count: expected 16, got 17