Property talk:P3520

Documentation

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

databaseOlympics.com athlete ID (archived)
identifier for an Olympic athlete (sportsperson) at databaseOlympics.com

Applicable "stated in" value	databaseolympics.com (Q21725558)
Data type	External identifier
Corresponding template	Template:DatabaseOlympics (Q19750845)
Allowed values	[0-9A-Za-z%]{4,14}\d\d
Example	Doina Ignat (Q185515) → IGNATDOI01 Robert Leroux (Q25899) → LEROUROB01
Source	https://web.archive.org/web/20160111011410/http://databaseolympics.com/
Formatter URL	https://web.archive.org/web/20160101000000/http://www.databaseolympics.com/players/playerpage.htm?ilkid=$1
Tracking: usage	Category:Pages using Wikidata property P3520 (Q28608839)
See also	Olympic.org athlete ID (archived) (P3171), Sports-Reference.com Olympic athlete ID (archived) (P1447), The-Sports.org athlete ID (P4391), Olympics.com athlete ID (P5815), Olympedia people ID (P8286)
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 Database reports/Humans with missing claims/P3520 Database reports/Constraint violations/P3520 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 6,954 Main statement 6,936 99.7% of uses Qualifier 2 <0.1% of uses Reference 16 0.2% of uses
Search for values

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

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

List of violations of this constraint: Database reports/Constraint violations/P3520#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

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

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Brimin Kipruto (Q9140), Nikolaj Pešalov (Q2571825)
List of violations of this constraint: Database reports/Constraint violations/P3520#Single value, SPARQL

Format “[0-9A-Za-z%]{4,14}\d\d”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Item “instance of (P31): human (Q5)”: Items with this property should also have “instance of (P31): human (Q5)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3520#Item P31, hourly updated report, search, SPARQL

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

List of violations of this constraint: Database reports/Constraint violations/P3520#Scope, 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/P3520#Entity types

This property is being used by: en:Template:DatabaseOlympics fa:الگو:Databaseolympics ro:Format:DatabaseOlympics vi:Bản mẫu:DatabaseOlympics pt:Predefinição:DatabaseOlympics uz:Andoza:DatabaseOlympics Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

formatter regex

The formatter regex still needs improvement. There are IDs such as this one in which special characters are (presumably hex-ISO 8859) encoded. The first eight characters can therefore also contain % and \d. Additionally, the identifier is case-insensitive, thus all IDs also work if lowercase letters are used. —MisterSynergy (talk) 16:28, 27 January 2017 (UTC)

Database shut down?

I cannot access the database any longer, maybe it was shut down by the owners?! We should watch it for a while before we take action here. —MisterSynergy (talk) 06:24, 18 April 2017 (UTC)

Me neither, but I last added couple of ID's yesterday, April 17th for a pair of norwegian speed skaters and it was up then. But another thing is that I really think that this databaseOlympics.com-database was just a previous version of the Sports-reference.com/olympics database (short discussion in norwegian wikipedia in norwegian language). So looking back, maybe this has something to do with the Sports-reference.com/Olympics-database are about to become published at the IOC's website soon, see discussions/information at Property talk:P1447. Best regards Migrant (talk) 15:54, 18 April 2017 (UTC)

From my experience both databases were too different to be related to each other in any way, but this is just my personal judgement which I cannot support by any sources. Sports-Reference is much better anyway, and databaseOlympics was basically never anything else than a backup database in case there was a problem with the sports-reference profile about an athlete. Still, let’s watch how it develops … Regards, MisterSynergy (talk) 16:13, 18 April 2017 (UTC)

Btw, have you found any profile of an olympian without a medal at databaseOlympics.com, I haven't. At Sports-reference.com/Olympics I have only found olympians with a result from the olympics, but from Olympic.org I have found olympians also with results from the newly youth olympics allthough they link up wrong olympiad but correct year and disipline and also some who did not compete at the olympics but they may have been added on early as a possible reserve athlete.

See also the copyright period stated at the bottom of the page for databaseOlympics.com which said 2002-2011 and results from their last olympics was the 2008 Summer Olympics. This post from the Sports-reference.com blog do mention the website which is the redirected page you'll get to when you try databaseOlympics.com which is to RotoWire.com. And if I remembers correctly the Sports-reference.com/Olympics were established roundabout the time for expiring copyright-period of databaseOlympics.com.

Best regards Migrant (talk) 17:15, 18 April 2017 (UTC)

Since the service is still offline, I’ve set deprecated rank for the formatter ID and the source website. The values will no longer be linked on item pages, but still appear in the identifiers section. We should not remove them for now. —MisterSynergy (talk) 20:13, 31 May 2017 (UTC)