Property talk:P3267

Documentation

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

Flickr user ID
identifier for a person or organisation, with an account at Flickr

Associated item	Flickr (Q103204)
Applicable "stated in" value	Flickr (Q103204)
Data type	External identifier
Domain	human (Q5) or organization (Q43229)
Allowed values	\d{5,11}@N\d{2}
Usage notes	Turn a username into a user ID with the webform found at https://www.webfx.com/tools/idgettr/
Example	Ian Emes (Q5981474) → 47978897@N06 SpaceX (Q193701) → 130608600@N05
Source	https://www.flickr.com/
Formatter URL	https://www.flickr.com/people/$1
Tracking: usage	Category:Pages using Wikidata property P3267 (Q28973087)
Related to country	United States of America (Q30) (See 762 others)
See also	website username or ID (P554)
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/Constraint violations/P3267 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 2,949 Main statement 2,900 98.3% of uses Qualifier 3 0.1% of uses Reference 46 1.6% of uses
Search for values

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

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

Conflicts with “website account on (P553): Flickr (Q103204)”: this property must not be used with the listed properties and values. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3267#Conflicts with P553, hourly updated report, search, SPARQL

Type “human (Q5), organization (Q43229)”: item must contain property “instance of (P31)” with classes “human (Q5), organization (Q43229)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Laval University Sports and Physical Education Complex (Q3373081), Greenbelt Park (Q5603701), Marsh-Billings-Rockefeller National Historical Park (Q6773285), Governor of Maryland (Q693032), White House (Q35525)
List of violations of this constraint: Database reports/Constraint violations/P3267#Type Q5, Q43229, SPARQL

Scope is as main value (Q54828448), as qualifier (Q54828449), as reference (Q54828450): the property must be used by specified way only (Help)

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

Format “\d{5,11}@N\d{2}”: 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).
List of violations of this constraint: Database reports/Constraint violations/P3267#Format, SPARQL

Qualifiers “website username or ID (P554), number of subscribers (P3744), language of work or name (P407), start time (P580), number of viewers/listeners (P5436), reason for deprecated rank (P2241), archive URL (P1065), archive date (P2960), point in time (P585), reason for preferred rank (P7452), earliest date (P1319), earliest end date (P8554), latest start date (P8555), latest date (P1326), subject named as (P1810), number of works (P3740)”: 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). Known exceptions: White House (Q35525)
List of violations of this constraint: Database reports/Constraint violations/P3267#allowed qualifiers, SPARQL

Allowed entity types are Wikibase item (Q29934200), Wikibase MediaInfo (Q59712033): 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/P3267#Entity types

This property is being used by: uk:Шаблон:У соціальних мережах ca:Plantilla:Identificadors vec:Modèl:Identifegadori, vec:Modeło:Identifegadori pt:Predefinição:Flickr zh-yue:Template:人物拎, zh-yue:Template:社交媒體模 hak:模板:Ngoi-phu lièn-kiet ko:틀:플리커 en:Template:Flickr image inline link zh:Template:Flickr nan:Pang-bô͘:Flickr yue:Template:人物拎, yue:Template:社交媒體模, yue:Template:Flickr Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

Find the actual ID

use this form 1Veertje (talk) 22:15, 6 June 2019 (UTC)

Thank you for posting this. It allowed me to realize that I was conflating ID with username. — Dcflyer (talk) 11:05, 14 June 2019 (UTC)

An alternative is this tool. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:39, 3 October 2019 (UTC)

Constraint violations: format

As of this writing, there are 753 format constraint (Q21502404) violations for format as a regular expression (P1793), out of 897 uses of Flickr user ID (P3267). After looking at the history of this property, it doesn’t appear that the regular expression (Q185612) was subject to any changes; however the overwhelming number of Flickr account usernames do not match this regex.

— Dcflyer (talk) 10:41, 14 June 2019 (UTC)

SOLVED — see above, to obtain the actual ID from the username: Property talk:P3267#Find the actual ID

— Dcflyer (talk) 10:57, 14 June 2019 (UTC)

How to record corresponding username and its changes?

Flickr usernames can be changed, hence why the unique ID is used here instead. For example, SpaceX (Q193701) had the username 'spacexphotos' until sometime in 2016 or early 2017 (based on Wayback Machine snapshots), when it was changed to 'spacex' instead. What would the best way of recording this be? (The current situation seems very poor to me.) One idea that comes to mind is having two entries with the same ID value but a different website username or ID (P554) qualifier and giving the current one a preferred rank. –JustTheRealArchivist (talk) 23:29, 26 January 2022 (UTC)

Converting existing entities to use the user ID

Since Dcflyer’s post in 2019, the number of entities which use a text string rather than a user ID has risen to a little over ~1000.

As part of the data modelling for Flickypedia, I’d quite like to use this field! In particular, when linking to a Flickr photographer in creator (P170), I want to link to the Wikidata entity where it exists. And in turn, I’d rather my code only had to query for the canonical user ID, and not look for the text versions as well.

I’ve got a script which can do bulk lookups of the "username ~> user ID", so I’m going to do that and gradually clean up the existing data in this field. I won’t be able to get everything, because some of these entities are protected or semi-protected, but hopefully I can make it a little better! Alexwlchan (talk) 15:35, 10 November 2023 (UTC)