Foundation in Formation | The Open Company Data Standard v1.1
Foundation Transition Pro Access

GLEIF LEI to National Company
Registration Mapping (CSV & SQL).

Deterministic reconciliation between ISO 17442 Legal Entity Identifiers (LEI), official GLEIF Registration Authority codes (RA000...), and sovereign commercial register IDs (SIREN, HRB, KvK, CRN, ZEFIX UID, KRS, BORME, CNPJ).
TL;DR Summary: Mapping a 20-character ISO 17442 GLEIF LEI to a national corporate registry CSV requires joining RegistrationAuthorityID (official RA000... list v1.9) and stripped RegistrationAuthorityEntityID strings against normalized local keys. Across 8,112,307 verified entities, Central.Enterprises Open Company Data Standard v1.1 aligns sovereign IDs for deterministic KYB and CRM enrichment.

GLEIF Registration Authorities (RA000...) vs. National Corporate Registry Keys

Official GLEIF Registration Authority Codes (RA List v1.9) Mapped to National Registry CSV Datasets
Jurisdiction GLEIF RA Code(s) Official Register Authority National Entity ID Format Canonical Join Key
France → RA000189 · RA000192 INSEE Sirene / Infogreffe RCS 9-digit SIREN (e.g. 552081317) FR-{SIREN}
Germany → RA000217 · RA000242 · RA000304 Amtsgericht Handelsregister (Berlin, Frankfurt, München) HRB / HRA + Court Prefix DE-{COURT_HRB}
Netherlands → RA000463 Kamer van Koophandel (KvK) 8-digit KvK-nummer (zero-padded) NL-{KVK8}
United Kingdom → RA000585 · RA000587 · RA000586 Companies House (E&W, Scotland, NI) 8-char CRN (00445790 / SC123456) GB-{CRN8}
Switzerland → RA000548 · RA000549 Federal UID-Register / ZEFIX Handelsregister CHE-XXX.XXX.XXX (9 digits) CH-{UID9}
Poland → RA000484 · RA000654 Krajowy Rejestr Sądowy (KRS) & REGON 10-digit KRS (LPAD zeros) PL-{KRS10}
Spain → RA000533 · RA000780 Registro Mercantil / BORME Central Spanish NIF Entity Code + Sheet ES-{NIF9}
Brazil → RA000681 · RA000059 Receita Federal (CNPJ) & Juntas Comerciais 14-digit CNPJ (XX.XXX.XXX/XXXX-XX) BR-{CNPJ14}
Italy → RA000407 Registro delle Imprese (Camere di Commercio) Fiscal Code & Provincial REA IT-{CF_REA}
Belgium → RA000025 Crossroads Bank for Enterprises (BCE / KBO) 10-digit Enterprise No. (0XXX.XXX.XXX) BE-{KBO10}
Romania → RA000497 ONRC Registrul Comerțului CUI Fiscal Code + J-Order ID RO-{CUI}
Ireland → RA000402 Companies Registration Office (CRO) 5-to-6-digit CRO Company Number IE-{CRO}

How Does GLEIF RegistrationAuthorityID Normalization Work Across Fragmented Jurisdictions?

GLEIF RegistrationAuthorityID normalization resolves one-to-many court structures before any CSV join executes. While Netherlands (KvK RA000463), Belgium (BCE/KBO RA000025), and Romania (ONRC RA000497) use single central RA codes, Germany splits Handelsregister entries across 140+ local court codes and United States entities map to state Secretaries of State such as Delaware (RA000602). Pair these RA lookups with our 21-Country Registry Identifiers Pillar and preserve leading zeros using the CSV & Excel Import Guide.

SQL & Python Join Pattern: GLEIF Level 1 Golden Copy to Open Data CSV

A deterministic SQL join normalizes hyphens, spaces, and corporate prefixes in RegistrationAuthorityEntityID before matching against Central.Enterprises canonical records downloaded from our CC0 Open Data Catalog. Where GLEIF leaves an entity unmapped (RA888888 or RA999999), fallback matching combines normalized domain roots with SimHash legal-suffix deduplication.

-- DuckDB / PostgreSQL: Join GLEIF Golden Copy CSV against Central.Enterprises Standard v1.1
SELECT
    g.LEI,
    g."Entity.LegalName",
    g."Entity.RegistrationAuthority.RegistrationAuthorityID" AS gleif_ra_code,
    c.country_code || '-' || regexp_replace(upper(g."Entity.RegistrationAuthority.RegistrationAuthorityEntityID"), '[^A-Z0-9]', '', 'g') AS canonical_join_key,
    c.website,
    c.main_category
FROM read_csv('gleif_lei_level1.csv', all_varchar=true) g
JOIN read_csv('Switzerland-Companies-Database-OpenData.csv', all_varchar=true) c
  ON c.country_code = 'CH'
 AND g."Entity.RegistrationAuthority.RegistrationAuthorityID" IN ('RA000548', 'RA000549')
 AND regexp_replace(upper(g."Entity.RegistrationAuthority.RegistrationAuthorityEntityID"), '[^A-Z0-9]', '', 'g')
   = regexp_replace(upper(c.reg_number), '[^A-Z0-9]', '', 'g');

Handling Regional Multi-Authority Registries (France, Switzerland, Poland & Brazil)

Multi-authority jurisdictions publish both statistical and commercial identifiers in parallel LEI records. In France, GLEIF records cite INSEE Sirene (RA000189), Infogreffe RCS (RA000192), or INPI RNE (RA001129) around the shared 9-digit SIREN root; in Switzerland, entities carry federal UID RA000548 alongside cantonal Handelsregister RA000549; in Poland, corporate entities map to KRS RA000484 rather than sole-trader CEIDG RA000486; and in Brazil, Receita Federal CNPJ RA000681 supersedes state Junta Comercial entries. When compliance teams also need verified outreach emails, evaluate Starter 90D and Pro Annual enrichment for Spain, Ireland, Portugal, and Australia.

Frequently Asked Questions

How do GLEIF Registration Authority codes (RA000...) map to national business registries?

Every ISO 17442 LEI record stores an official RegistrationAuthorityID (such as RA000189 for French INSEE Sirene, RA000463 for Dutch KvK, RA000548 for Swiss UID, RA000585 for UK Companies House, or RA000484 for Polish KRS) paired with the entity national registration number in ValidationAuthorityEntityID.

Why should B2B pipelines join GLEIF LEI records with national CSV company databases?

Fewer than 5% of operating private SMEs hold an ISO 17442 LEI because LEIs are primarily mandated for capital-market and regulated financial participants. Joining GLEIF RA keys against Central.Enterprises national registry datasets connects capital-market disclosures with 8,112,307 operating enterprises across 21 countries.

What do the special GLEIF fallback codes RA777777, RA888888, and RA999999 mean in CSV extracts?

GLEIF reserves RA777777 for public legal documents of government or international bodies without a standard company register, RA888888 as a temporary placeholder while a new authority code is approved, and RA999999 when no external registration authority applies to the legal entity.

How does Central.Enterprises standardize regional registers like German Handelsregister or US Secretaries of State?

While GLEIF assigns separate RA codes to over 140 German Amtsgericht courts (such as RA000217 Berlin-Charlottenburg or RA000304 München) and individual US states (such as RA000602 Delaware), Central.Enterprises normalizes every filing into unified COUNTRY-NUMBER reg_number_canonical keys under Standard v1.1.

PRODUCTION DATA PIPELINE

Ready to operationalize standardized corporate registries?

Download free CC0 Open Core archives or license 5.6M+ MX-verified B2B emails and direct switchboard phones across 21 jurisdictions.

Browse 21 Countries → Unlock B2B Contacts →