Property talk:P2600

Documentation

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

Geni.com profile ID
profile on the Geni.com genealogy website

Associated item	geni.com (Q2621214)
Applicable "stated in" value	geni.com (Q2621214)
Data type	External identifier
Domain	According to this template: human (Q5) According to statements in the property: human (Q5) or human whose existence is disputed (Q21070568) When possible, data should only be stored as statements
Allowed values	6000[0-9]{15}|[4-5][0-9]{18}|3[9]{0,1}[0-9]{17}|[1-2][0-9]{17}|[1-9][0-9]{0,6}
Example	Elizabeth II (Q9682) → 6000000003075071669 Charlemagne (Q3044) → 6000000002457013227 Alan Braverman (Q23696694) → 9 Robert Gould Shaw II (Q7344895) → 4167 Georg Iggers (Q123687) → 96048
Source	https://www.geni.com/
Formatter URL	https://www.geni.com/profile/index/$1
Robot and gadget jobs	Not required, but Geni does have an API which can be used to cross-check data such as birth date, etc if anyone with the required skills is interested.
Tracking: usage	Category:Pages using Wikidata property P2600 (Q61034960)
See also	Portrait Archive ID (P9352), GeneaStar person ID (P8094)
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) 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/Humans with missing claims/P2600 Database reports/Constraint violations/P2600 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 411,626 Main statement 409,201 out of 175,458,158 (0% complete) 99.4% of uses Qualifier 6 <0.1% of uses Reference 2,419 0.6% 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/P2600#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).
List of violations of this constraint: Database reports/Constraint violations/P2600#Single value, SPARQL

Format “6000[0-9]{15}|[4-5][0-9]{18}|3[9]{0,1}[0-9]{17}|[1-2][0-9]{17}|[1-9][0-9]{0,6}”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Type “human (Q5), human whose existence is disputed (Q21070568)”: item must contain property “instance of (P31)” with classes “human (Q5), human whose existence is disputed (Q21070568)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P2600#Type Q5, Q21070568, hourly updated report, 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/P2600#Scope, hourly updated report, SPARQL

Item “sex or gender (P21)”: Items with this property should also have “sex or gender (P21)”. (Help)

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

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

List of violations of this constraint: Database reports/Constraint violations/P2600#Entity types, hourly updated report

Pattern ^(https?://www\.geni\.com/people/)?[A-Za-z1-4ªéºí-]+/(600\d{16})(\?through=\d+)?$ will be automatically replaced to \2. Testing: TODO list

Statistics

P2600 on values

Property	Values with 2600	Values without P2600	%without	ref
father (P22)	83128	38719	31.8	w wo
mother (P25)	36663	36474	49.9	w wo
child (P40)	143118	141486	49.7	w wo
spouse (P26) ⇔	81682	51869	38.8	w wo symmetric
sibling (P3373)	35337	29408	45.4	w wo symmetric
relative (P1038)				create_w create_wo

See also: Wikidata:WikiProject_Genealogy#Identifiers on values

Discussion

P2600 geni.com profile ID - Wikidata does store ID plus irrelevant URL part

The geni.com ID is purely numeric. The part before the "/" which is stored in Property:P2600 is only for search engine optimization, is not part of the ID and can be changed by any editor of a profile without effect on the ability to find the profile. Also, the internal link if one browses the tree view goes to a base URL plus a numeric ID. Compare:

Desc.	Value to be stored in P2600	URL
CURRENT	Elizabeth-II-Queen-of-the-United-Kingdom/6000000003075071669	https://www.geni.com/people/Elizabeth-II-Queen-of-the-United-Kingdom/6000000003075071669
TEST		https://www.geni.com/people/Elizabeth-II-Queen-of-the-UK/6000000003075071669
TEST		https://www.geni.com/people/whatever/6000000003075071669
INTERNAL	6000000003075071669	https://www.geni.com/profile/index/6000000003075071669

That Wikidata allows storing of the ID plus some URL parts means that duplicate usage of IDs on different WD-items cannot be detected with the standard tools. For this it would be necessary for WD to only store the ID itself.

The property is called "geni.com profile ID" also the API documentation talks of "profile" [1]. Wikidata could store only the ID and link to https://www.geni.com/profile/index/<ID>.

There is also a representation isssue, e.g. Reasonator currently fails to display the complete P2600 value [2]. 92.231.172.31 14:51, 12 April 2018 (UTC)

This is not an uncommon issue for our ID's; how to handle it should probably be discussed on the talk page of the property. Also, if there doesn't seem to be any objections to the change to a numeric format, a bot request should be made to switch them, and any necessary formatter URL change made when the bot has run. ArthurPSmith (talk) 15:15, 12 April 2018 (UTC)

ArthurPSmith - where to do the bot request? 92.231.172.31 15:22, 12 April 2018 (UTC)

Wikidata:Bot_requests ArthurPSmith (talk) 16:04, 12 April 2018 (UTC)

Pinging those involved with original proposal - @Chuq, Richard_Arthur_Norton_(1958-_), Pigsonthewing, Edgars2007, Micru: - any comments on switching to numeric format? ArthurPSmith (talk) 20:01, 12 April 2018 (UTC)

Thank you for the ping. https://www.geni.com/profile/index/6000000003075071669 clearly works, but are we sure that https://www.geni.com/profile/index/$1 is the canonical formatter URL? Happy for the change to be made, anyway, as we can always update the formatter URL later. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 22:29, 12 April 2018 (UTC)

Nice find! Yes, I always worried that if you modified the person's name the link would change, and of course when you take out the name WITHOUT adding in "index" it just takes you to your home page, if you are registered. Again, nice find! --RAN (talk) 22:48, 12 April 2018 (UTC)

Looks fine. I can do the conversion. --Edgars2007 (talk) 05:39, 13 April 2018 (UTC)

Edgars2007, 24h have passed since your statement and since the repeated confirmation of the canonical form. How long will it take you? 77.179.94.217 17:17, 14 April 2018 (UTC)

Re the canonical form, User:Pigsonthewing, if one goes to the tree view, html, then there are links to the profiles in the form presented above. 77.14.76.242 18:13, 13 April 2018 (UTC)

ID format

d{6} example: (Q160311): 979118, (Q23583025): 932813
d{7} example: https://www.geni.com/profile/index/2396911
d{18} example: https://www.geni.com/profile/index/297283339470004936
d{19} many

78.55.76.113 23:05, 17 April 2018 (UTC), 77.180.221.242 23:44, 8 May 2018 (UTC)

SPARQL

List humans having property P2580

SELECT
?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel
(GROUP_CONCAT(DISTINCT ?bblid) AS ?bblids) 
(GROUP_CONCAT(DISTINCT ?isni) AS ?isnis) 
(GROUP_CONCAT(DISTINCT ?viaf) AS ?viafs) 
(GROUP_CONCAT(DISTINCT ?gnd) AS ?gnds) 
(GROUP_CONCAT(DISTINCT ?geni) AS ?genis)
WHERE {
    ?human wdt:P31 wd:Q5 .
    OPTIONAL{?human wdt:P2580 ?bblid .}  
    OPTIONAL{?human wdt:P22 ?father .}
    OPTIONAL{?human wdt:P25 ?mother .}
    OPTIONAL{?human wdt:P569 ?dateOfBirth .}
    OPTIONAL{?human wdt:P19 ?placeOfBirth .}
    OPTIONAL{?human wdt:P570 ?dateOfDeath .}
    OPTIONAL{?human wdt:P20 ?placeOfDeath .}
    OPTIONAL{?human wdt:P213 ?isni .}
    OPTIONAL{?human wdt:P214 ?viaf .}
    OPTIONAL{?human wdt:P227 ?gnd .}
    ?human wdt:P2600 ?geni .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel
ORDER BY ?dateOfBirth

Try it!

92.229.132.140 19:11, 6 May 2018 (UTC)

Mix'n'match

Mix'n'match - create catalog

http://www.geni.com/platform/developer/help/api?path=profile&version=1

Load

• all IDs that are in WD
• all from https://www.wikidata.org/w/index.php?title=Property_talk:P2600&oldid=675105985#geni.com/profile
• ? all from all Wikimedia projects?

92.229.132.140 20:46, 6 May 2018 (UTC)

Quarry

Proposal to use quarry to collect IDs at Wikidata:Project chat#geni.com - read data from Wikidata 78.55.254.253 13:46, 9 May 2018 (UTC)

Direct link to one query https://quarry.wmflabs.org/query/26867, thanks a lot to User:Edgars2007. 77.179.86.244 11:24, 10 May 2018 (UTC)