Property talk:P8002

Documentation

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

Social Security Death Index entry
identifier for a person listed in Social Security Death Index or Death Master File

Represents	Social Security number (Q5612679)
Associated item	Social Security Administration (Q2824618)
Data type	External identifier
Allowed values	^(?!666|000|9\d{2})\d{3}-(?!00)\d{2}-(?!0{4})\d{4}$
Example	Marcy Leroy Ditmanson (Q84938650) → 397-10-0719 Alfhild Jensen Gislefoss (Q15924627) → 397-32-8379 Elvis Presley (Q303) → 409-52-2002
See also	Fichier des personnes décédées ID (matchID) (P9058)
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/Complex constraint violations/P8002 Database reports/Constraint violations/P8002 Map Random list
Living people protection class	property that may violate privacy (Q44601380)
Proposal discussion	Proposal discussion
Current uses	Total 139 Main statement 84 out of 89,430,629 (0% complete) 60.4% of uses Qualifier 3 2.2% of uses Reference 52 37.4% of uses
Search for values

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

Format “^(?!666|000|9\d{2})\d{3}-(?!00)\d{2}-(?!0{4})\d{4}$”: value must be formatted using this pattern (PCRE syntax). (Help)

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

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/P8002#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Item “date of death (P570)”: Items with this property should also have “date of death (P570)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P8002#Item P570, 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/P8002#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)

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/P8002#Scope, 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/P8002#Entity types

Citation needed: the property must have at least one reference (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/P8002#citation needed

Single best value: this property generally contains a single value. If there are several, one would have preferred rank (Help)

List of violations of this constraint: Database reports/Constraint violations/P8002#single best value, hourly updated report, SPARQL

Not a U.S. citizen or permanent resident
Social Security numbers are only issued to U.S. citizens, permanent residents, or temporary (working) residents. This constraint will show a false positive for temporary residents; however, these should be fairly rare. (Help)
Violations query: SELECT ?item WHERE { ?item wdt:P31 wd:Q5. ?item wdt:P8002 ?ssn. OPTIONAL { ?item wdt:P27 wd:Q30. BIND(wdt:P27 AS ?rel) } OPTIONAL { ?item wdt:P5389 wd:Q30. BIND(wdt:P5389 AS ?rel) } FILTER(!BOUND(?rel)) }
List of this constraint violations: Database reports/Complex constraint violations/P8002#Not a U.S. citizen or permanent resident

Potential items
Americans who died in the US after 2000 without P8002 (Help)
Violations query: SELECT ?item ?d WHERE { ?item wdt:P20 / wdt:P17 wd:Q30; wdt:P570 ?d. FILTER(YEAR(?d) > 2000 && YEAR(?d) < YEAR(now()) ) MINUS { ?item p:P8002 [] } ?item wdt:P31 wd:Q5 ; wdt:P27 wd:Q30 . } LIMIT 500
List of this constraint violations: Database reports/Complex constraint violations/P8002#Potential items