Property talk:P8687

Documentation

• Start a query
• Current uses
• Statistics by class
• Units
• Scale of values
• List of qualifiers
• Count

social media followers
number of subscribers on a particular social media website (use as main statement only; see P3744 instead for qualifier). Qualify with "point in time" and property for account. For Twitter, use numeric id.

Data type	Quantity
Allowed values	According to this template: integers >1000. Generally, one value per media and calendar year, not more than one per quarter. According to statements in the property: 0 ≤ 𝓧 ≤ 1,000,000,000 When possible, data should only be stored as statements
Allowed units	not applicable
Usage notes	Qualify with "point in time" and property for account. For Twitter, use numeric id.
Example	Cristiano Ronaldo (Q11571) → 201,000,000 Magnus Manske (Q13520818) → 1,640
See also	number of subscribers (P3744)
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 statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Minimum and maximum Items with highest numeric value Items with lowest numeric value Database reports/Complex constraint violations/P8687 Database reports/Constraint violations/P8687 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 687,054 Main statement 686,547 >99.9% of uses Qualifier 422 <0.1% of uses Reference 85 <0.1% of uses

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

Integer: values should be integers (ie. they shouldn't have a fractional part) (Help)

List of violations of this constraint: Database reports/Constraint violations/P8687#integer, hourly updated report, 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/P8687#Entity types

Required qualifier “point in time (P585)”: this property should be used with the listed qualifier. (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/P8687#mandatory qualifier, SPARQL

Units: “novalue”: value unit must be one of listed. (Help)

List of violations of this constraint: Database reports/Constraint violations/P8687#Units, hourly updated report

Scope is as main value (Q54828448): 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/P8687#Scope, SPARQL

Qualifiers “point in time (P585), Twitter (X) numeric user ID (P6552), Instagram username (P2003), YouTube channel ID (P2397), Facebook username (P2013), SoundCloud ID (P3040), subreddit (P3984), Bandsintown artist ID (P7195), Genius artist ID (P2373), KKBox artist ID (P5154), Line Music artist ID (P4747), Melon artist ID (P4473), Myspace ID (P3265), SongMeanings artist ID (P7200), The DJ List artist ID (P6935), TikTok username (P7085), Spotify artist ID (P1902), Deezer artist ID (P2722), Rate Your Music artist ID (P5404), Quora topic ID (P3417), sourcing circumstances (P1480), reason for deprecated rank (P2241), Pinterest username (P3836), V Live channel ID (P4756), Naver Post member ID (P9893), Telegram username (P3789), Daum Cafe ID (P9819), LinkedIn company or organization ID (P4264), LinkedIn personal profile ID (P6634), Likee username (P9812), VK ID (P3185), Twitch channel ID (P5797), Mastodon address (P4033), reason for preferred rank (P7452), YouTube handle (P11245), Twitter (X) username (P2002), GitHub username (P2037), XING company ID (P6619), XING profile ID (P7176), Spotify user ID (P11625), SlideShare username (P4016), Medium username (P3899), Loop ID (P2798), ResearchGate profile ID (P2038), Threads username (P11892), Aparat channel ID (P12066), ‎Twitch numeric channel ID (P12229)”: this property should be used only with the listed qualifiers. (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/P8687#allowed qualifiers, SPARQL

Range from “0” to “1000000000”: values should be in the range from “0” to “1000000000”. (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/P8687#Range

This property is being used by: eo:Ŝablono:Informkesto televida kanalo Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

qualifier for identifier should also be available as statement
query currently excludes Twitter (Help)
Violations query: SELECT ?item ?st ?prop ?qualv WITH { SELECT * { hint:Query hint:optimizer "None". ?item p:P8687 ?st . ?st ?qual ?qualv . FILTER( ?qual != pq:P585 ) FILTER( ?qual != pq:P6552 ) ?prop wikibase:qualifier ?qual . ?prop wikibase:claim ?p . ?prop wikibase:statementProperty ?ps . MINUS { ?item ?p ?a . ?a ?ps ?qualv } } } as %all WHERE { INCLUDE %all FILTER( datatype(?qualv) = xsd:string ) }
List of this constraint violations: Database reports/Complex constraint violations/P8687#qualifier for identifier should also be available as statement

retrieved (P813) is unsuitable as a qualifier

There seems to have been an addition some time ago, but this isn't actually needed. point in time (P585) should be used to indicate the date of the follower count. --- Jura 09:45, 12 February 2021 (UTC)

retrieved (P813) and point in time (P585) don't exclude each other.

The retrieved (P813) date is as relevant here as anywhere else, especially for archived data.- Coagulans (talk) 10:29, 12 February 2021 (UTC)

So let's do like (almost) anywhere else and not add it as qualifier. --- Jura 12:00, 12 February 2021 (UTC)

use as main statement

This was proposed as a property for main statement, see Wikidata:Property_proposal/social_media_followers. I don't see any consensus to change this. We came up with the approach after going through two other approaches. --- Jura 06:40, 25 February 2021 (UTC)

• Moved them back to number of subscribers (P3744) as qualifier. Eventually these should be converted (if not deleted, given that the bot may have already added the info). --- Jura 19:15, 8 January 2022 (UTC)

units

There are a bunch of constraint violations at Wikidata:Database_reports/Constraint_violations/P8687#"Units"_violations making it different to query and compare wdt:P8687 values. I will look into cleaning these up. --- Jura 10:43, 13 April 2021 (UTC)

• While fixing some of them, I noticed they were using them in an unpredictable way: [1] [2] --- Jura 10:57, 22 April 2021 (UTC)
• Cleaned them out. --- Jura 19:15, 8 January 2022 (UTC)

values lacking point in time (P585) qualifier

SELECT ?item ?itemLabel ?value 
WHERE
{
	hint:Query hint:optimizer "None".
    ?statement ps:P8687 ?value 
    MINUS { ?statement pq:P585 [] }             
    ?item p:P8687 ?statement .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

The above finds some. These still need to be fixed/cleaned up. --- Jura 19:15, 8 January 2022 (UTC)

Qualifier value for identifier should also be a main statement value

There are a few items that lack that (sample). I added a complex constraint to monitor it. One for Twitter is still todo. --- Jura 15:05, 10 January 2022 (UTC)

Village pump discussion on why this property was a terrible idea

See Wikidata:Project chat#social media followers (P8687) was a terrible idea. {{u|Sdkb}} ^talk 00:59, 23 March 2022 (UTC)

Discussion is now archived, see: Wikidata:Project_chat/Archive/2022/03#social media followers (P8687) was a terrible idea. --UliSchukraft (talk) 18:30, 1 June 2022 (UTC)