Property talk:P2686

Documentation

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

OpenSecrets people ID
identifier used by Opensecrets for people involved in US elections

Associated item	OpenSecrets (Q127231756)
Data type	External identifier
Domain	people, organizations (note: this should be moved to the property statements)
Allowed values	[Nn]00\d{6}
Example	Paul Ryan (Q203966) → N00004357 Mondaire Jones (Q96781248) → N00044908
Source	https://www.opensecrets.org/
Formatter URL	https://www.opensecrets.org/personal-finances/net-worth?cid=$1
Robot and gadget jobs	Congressional members info can be imported from https://github.com/unitedstates/congress-legislators
Tracking: usage	Category:Pages using Wikidata property P2686 (Q55090929)
Related to country	United States (Q30) (See 826 others)
See also	OpenSecrets organization ID (P4691), LittleSis people ID (P3388)
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 Items with deprecated 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/P2686 Database reports/Constraint violations/P2686 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 729 Main statement 727 99.7% of uses Qualifier 2 0.3% of uses
Search for values

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

Format “[Nn]00\d{6}”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P2686#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/P2686#Item P31, hourly updated report, search, SPARQL

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

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

This property is being used by:

• en:Template:Open Secrets, en:Template:OpenSecretsPeople

---

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Ten American politicians without an ID

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT DISTINCT ?item WHERE { MINUS { ?item p:P570 ?statement_0. ?statement_0 psv:P570 ?statementValue_0. ?statementValue_0 wikibase:timeValue ?P570_0. } ?item p:P106 ?statement1. ?statement1 (ps:P106) wd:Q82955. ?item p:P31 ?statement2. ?statement2 (ps:P31) wd:Q5. ?item p:P27 ?statement3. ?statement3 (ps:P27/(wdt:P279*)) wd:Q30. MINUS { ?item p:P2686 ?statement4. ?statement4 (ps:P2686) _:anyValueP2686. } ?item p:P1412 ?statement5. ?statement5 (ps:P1412/(wdt:P279*)) wd:Q1860. ?item p:P31 ?statement6. ?statement6 (ps:P31) wd:Q5. ?item p:P569 ?statement_7. ?statement_7 psv:P569 ?statementValue_7. ?statementValue_7 wikibase:timePrecision ?precision_7. FILTER(?precision_7 >= 11 ) ?statementValue_7 wikibase:timeValue ?P569_7. FILTER(?P569_7 > "+1950-01-01T00:00:00Z"^^xsd:dateTime) } LIMIT 10

Article	description	date of birth	start time	end time	coordinate location	image
Cal Dooley	American politician	1954-01-11
Calvin Say	American politician	1952-02-01
Carl C. Perkins	American politician	1954-08-06
Carte Goodwin	American attorney and politician (born 1974)	1974-02-27
Casey Cagle	American politician	1966-01-12
Chael Sonnen	American mixed martial artist (born 1977)	1977-04-03
Charles Bass	American politician	1952-01-08
Charlie Luken	American politician in Ohio (born 1951)	1951-07-18
John Grisham	American writer (born 1955)	1955-02-08
Randy Bass	American baseball player and politician	1954-03-13

---

∑ 10 items.