Datasets / EDGAR ↔ GLEIF — Company-to-LEI Crosswalk

CC07k rows

Loading DuckDB in your browser…

About

The resolved link between SEC EDGAR public companies (CIK / ticker) and their GLEIF Legal Entity Identifier (LEI) — one row per asserted identity, each carrying the match method, weight and status. Exact normalized-name matches are confirmed (~95% precision); name-only fuzzy matches are surfaced as candidates, not confirmed. A point-in-time snapshot with an as-of date on every row — a static download rots, so the maintained, always-current feed is the paid tier.

License: CC0
Rows: 7k
Source: SEC EDGAR + GLEIF

Connects to

cikedgar.cik
Exact CIK as reported by SEC EDGAR — exact by construction.
status: confirmed · confidence: 1
leigleif.lei
Splink probabilistic name resolution — exact-name matches confirmed (~95% precision); fuzzy surfaced as candidate, not confirmed.
status: per-row (see the status column) · confidence: per-row (match_probability)

Use anywhere

-- one ATTACH exposes every Meridian open dataset
INSTALL ducklake; INSTALL httpfs;
ATTACH 'ducklake:https://openlake.meridian.online/catalog/open.ducklake' AS meridian (READ_ONLY);
USE meridian;
SELECT x.company_name, x.ticker, x.lei, g.country, x.match_probability, x.status
FROM edgar_gleif x
JOIN gleif g ON g.lei = x.lei
WHERE x.status = 'confirmed'
LIMIT 100;

Starter query — filters and SQL you build appear here.