Wikidata:Property proposal/GLEI RAL

GLEI RAL edit

Originally proposed at Wikidata:Property proposal/Organization

Done: GLEIF registration authority code (P9487) (Talk and documentation)

Description	(alias: GLEIF Registration Authorities List code) National registration authority code in the GLEI RAL list
Represents	GLEIF Registration Authorities List (Q106448148)
Data type	External identifier
Domain	registration authority (Q166140)
Example 1	Firmenbuch (Q1419112) → RA000017
Example 2	Register of Associations (Q106448105) → RA000710
Example 3	Commercial Register (Q12297114) → RA000065
Example 4	Bulstat Registry (Q106447925) → RA000730
Example 5	EDGAR (Q3050604) → RA000665
Source	https://www.gleif.org/en/about-lei/code-lists/gleif-registration-authorities-list
Planned use	import to Mix-n-Match and start coreferencing
Number of IDs in source	738, as of 2021-04-10 (updated 2019-12-05), reference URL: https://www.gleif.org/content/2-about-lei/7-code-lists/1-gleif-registration-authorities-list/2019-12-05_ra-list-v1.5.csv
Expected completeness	eventually complete (Q21873974)
Formatter URL	https://search.gleif.org/#/search/simpleSearch=$1
See also	org-id.guide ID (P4824), Wikidata:Property_proposal/OpenCorporates register id, Wikidata:Property_proposal/OpenCorporates register jurisdiction
Applicable "stated in"-value	GLEIF Registration Authorities List (Q106448148)
Distinct-values constraint	yes
Wikidata project	Wikidata:WikiProject_Companies

Motivation edit

Notified participants of WikiProject Companies

We should collect more data about company and nonprofit registers. Vladimir Alexiev (talk) 08:28, 10 April 2021 (UTC)[reply]

records: 738, date 2021-04-10, updated 2019-12-05
source: https://www.gleif.org/en/about-lei/code-lists/gleif-registration-authorities-list
download: https://www.gleif.org/content/2-about-lei/7-code-lists/1-gleif-registration-authorities-list/2019-12-05_ra-list-v1.5.csv

RAL Fields:

Registration Authority Code
Country: fully correlated with Country Code (i.e. redundant): these commands find nothing

csvtk cut -f "Country Code,Country" ra-list-v1.5-2019-12-05.csv |sort|uniq|csvtk cut -f1|sort|uniq -d
csvtk cut -f "Country Code,Country" ra-list-v1.5-2019-12-05.csv |sort|uniq|csvtk cut -f2|sort|uniq -d

Country Code: 2-alpha code, 224 unique, 2 empty. Most populous:

csvtk cut -f "Country Code,Country" ra-list-v1.5-2019-12-05.csv |sort|uniq -c|sort -rn|head -6
    167 DE,Germany
     58 US,United States of America
     58 CO,Colombia
     28 BR,Brazil
     21 AE,United Arab Emirates
     14 CA,Canada

Jurisdiction (country or region): 548 unique, 2 empty, name not code. Most populous:

csvtk cut -f "Jurisdiction (country or region)" ra-list-v1.5-2019-12-05.csv |sort|uniq -c|sort -rn|head -5
     12 Slovakia
     12 India
      8 Spain
      7 Czech Republic
      7 Croatia

As you see, Germany has the most registers (every Land) followed by US (every State). But Slovakia has the most registers with the same jurisdiction (the whole Country)

International name of Register
Local name of Register
International name of organisation responsible for the Register
Local name of organisation responsible for the Register
- As you see, RAL makes a distinction between the Register and the Agency that keeps it
Website
Comments

Discussion edit

Support --Jklamo (talk) 13:52, 10 April 2021 (UTC)[reply]
Support Absolutely! - PKM (talk) 19:54, 10 April 2021 (UTC)[reply]
Thanks for the formatterURL! (It returns a list of GLEI-registered companies from that national registry) --Vladimir Alexiev (talk) 06:44, 12 April 2021 (UTC)[reply]
- Is is not perfect, but it is from official page and it is giving somehow relevant results.--Jklamo (talk) 08:02, 12 April 2021 (UTC)[reply]
Support GLEIF is an important standard. ArthurPSmith (talk) 16:50, 12 April 2021 (UTC)[reply]
Support Sure! RShigapov 10:11, 13 April 2021 (UTC)[reply]

@Vladimir Alexiev, Jklamo, PKM, ArthurPSmith, RShigapov:

Done GLEIF registration authority code (P9487) Pamputt (talk) 09:55, 26 April 2021 (UTC)[reply]