Property talk:P2657

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

EU Transparency Register ID
identity code for an organisation, in the transparency register of the European Union

Applicable "stated in" value	EU Transparency Register (Q15851383)
Data type	External identifier
Domain	organization (Q43229) or human (Q5)
Allowed values	\d{8,12}-\d{2}
Example	Union of Penal Chambers (Q4005583) → 309451334691-46 German Research Foundation (Q707283) → 760465913924-94
Source	http://ec.europa.eu/transparencyregister/public/homePage.do
Formatter URL	https://transparency-register.europa.eu/searchregister-or-update/organisation-detail_en?id=$1
Tracking: usage	Category:Pages using Wikidata property P2657 (Q65706148)
Related to country	European Union (Q458) (See 16 others)
See also	accredited by (P5514), CDep.Ro NGO ID (P9605)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 Mix'n'match (Report) Database reports/Constraint violations/P2657 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 10,079 Main statement 6,029 59.8% of uses Qualifier 3 <0.1% of uses Reference 4,047 40.2% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Type “organization (Q43229), human (Q5)”: item must contain property “instance of (P31)” with classes “organization (Q43229), human (Q5)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2657#Type Q43229, Q5, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2657#Unique value, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help)

List of violations of this constraint: Database reports/Constraint violations/P2657#Single value, hourly updated report, SPARQL

Format “\d{8,12}-\d{2}”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P2657#Format, hourly updated report, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2657#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2657#Scope, SPARQL

Bulk Import

Are there any plans for bulk import ? @Airon90: @Pigsonthewing:

just located an export that could be suitable for Mix N'Match

https://data.europa.eu/euodp/en/data/dataset/transparency-register --Teolemon (talk) 16:10, 18 September 2016 (UTC)

--Teolemon (talk) 16:02, 18 September 2016 (UTC)

@Magnus Manske: FYI. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 17:59, 18 September 2016 (UTC)

1st import completed

I've loaded the catalog into Mix N'Match. The parenthesis are blocking some matches, and the db mixes languages. --Teolemon (talk) 19:52, 24 September 2016 (UTC)

Register entries gone missing

I've been trying to match entries in mix n'match, but there are various entries that seem to be no longer available on the register's website (error 500). The entry for the Universal Postal Union (Q17495) for example points to [1]. The site's search function also doesn't show an entry for the Universal Postal Union. Has the organization been removed from the register entirely?

Also: The "Xerox Corporation" link points to [2], which is the entry for Conduent (Q28404490). And the search function doesn't yield any results for Xerox. --Kam Solusar (talk) 02:11, 1 January 2018 (UTC)

item-requires-statement constraint Country

As rightly stated by Sanjorgepinho (talk • contribs • logs) a European organization does not always have a country, so I would propose to lift this item-requires-statement constraint. --Newt713 (talk) 12:54, 28 January 2022 (UTC)

Agreed − Pintoch (talk) 15:02, 22 May 2022 (UTC)