Property talk:P5452
Jump to navigation
Jump to search
Documentation
MyHeritage Surname ID
string identifying a surname (family name) at the MyHeritage genealogy website
string identifying a surname (family name) at the MyHeritage genealogy website
[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, SPARQLSingle 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, SPARQLDistinct 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
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
List of violations of this constraint: Database reports/Constraint violations/P5452#Format, SPARQL
Specific Querys
[edit]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)
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
Categories:
- All Properties
- Properties with external-id-datatype
- Properties used on 10000+ items
- Properties with constraints on type
- Properties with single value constraints
- Properties with unique value constraints
- Properties with entity type constraints
- Properties with scope constraints
- Properties with format constraints