Property talk:P5452

Documentation

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

MyHeritage Surname ID
string identifying a surname (family name) at the MyHeritage genealogy website

Associated item	MyHeritage (Q589757)
Applicable "stated in" value	MyHeritage (Q589757)
Data type	External identifier
Domain	family name (Q101352)
Allowed values	[\p{Latin} '-]+
Example	Farquharson (Q1397060) → farquharson Jakupović (Q16802302) → jakupović Mabbett (Q19861038) → mabbett Smith (Q1158446) → smith
Formatter URL	https://lastnames.myheritage.com/last-name/$1
See also	Digital Dictionary of Surnames in Germany ID (P6597), Geneanet family name ID (P9644), Géopatronyme ID (P3370)
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 Database reports/Constraint violations/P5452 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 14,337 Main statement 14,328 >99.9% of uses Qualifier 4 <0.1% of uses Reference 5 <0.1% of uses
Search for values

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

Type “family name (Q101352)”: item must contain property “instance of (P31)” with classes “family name (Q101352)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P5452#Type Q101352, hourly updated report, SPARQL

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

List of violations of this constraint: Database reports/Constraint violations/P5452#Single value, hourly updated report, 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/P5452#Unique value, SPARQL (every item), SPARQL (by value)

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/P5452#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/P5452#Scope, SPARQL

Format “[\p{Latin} '-]+”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Demidov (Q16056296), Demidova (Q94956110), Auf’m Kamp (Q107368873)
List of violations of this constraint: Database reports/Constraint violations/P5452#Format, SPARQL

Specific Querys

Query to show list of the most popular family names in Wikidata that do not have a "MyHeritage Surname ID", it includes a link to show them in myhertage so you may connect them in easily back to wikidata using something like Wikidata:Tools/Wikidata for Web

SELECT ?count ?name ?name_label ?check_url 

WITH {
  SELECT ?item ?name WHERE {
    ?item wdt:P734 ?name
  } LIMIT 1000000 
} AS %uses

WITH {
  SELECT (COUNT(*) AS ?count) ?name WHERE {
     INCLUDE %uses
  } GROUP BY ?name
  HAVING (?count > 4)
} AS %names

WHERE {
  INCLUDE %names
  MINUS {?name wdt:P5452 [] } .
  ?name rdfs:label ?name_label FILTER(lang(?name_label) = 'en') .

  wd:P5452 wdt:P1630 ?fmt .
  BIND(IRI(REPLACE(str(?name_label), '(^.*)', ?fmt)) AS ?check_url) .
} ORDER BY DESC(?count)

Try it!

Simpler query just showing 50 names and without any refinement in regard to popularity

SELECT ?item ?item_label ?check_url WHERE {
  ?item wdt:P31 wd:Q101352 .
  MINUS {?item wdt:P5452 [] } .
  ?item rdfs:label ?item_label FILTER(lang(?item_label) = 'en') .

  wd:P5452 wdt:P1630 ?fmt .
  BIND(IRI(REPLACE(str(?item_label), '(^.*)', ?fmt)) AS ?check_url) .
} LIMIT 50

Try it!