Property talk:P2291

Documentation

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

charted in
chart where the element reached a position

Represents	record chart (Q373899)
Data type	Item
Template parameter	Template:singlechart in English Wikipedia
Domain	According to this template: albums, songs, DVDs According to statements in the property: work (Q386724), human (Q5), musical group (Q215380) or musical duo (Q9212979) When possible, data should only be stored as statements
Example	Thriller (Q44320) → Billboard 200 (Q188819) LOL <(^^,)> (Q664873) → Album Top-40 (Q25405857)
Source	external reference (such as IFPI, ...) (note: this information should be moved to a property statement; use property source website for the property (P1896))
Robot and gadget jobs	A bot can import values from English Wikipedia
See also	ranking (P1352), series ordinal (P1545)
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 By value of property Most statements Fewest statements Most sitelinks Most linked wikis Total of sitelinks on items Most identifiers Fewest identifiers 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/P2291 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 2,495 Main statement 2,234 89.5% of uses Qualifier 261 10.5% of uses
Search for values

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

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/P2291#Entity types

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

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

Required qualifier “ranking (P1352)”: 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/P2291#mandatory qualifier, SPARQL

Qualifiers “ranking (P1352), start time (P580), end time (P582), point in time (P585), reason for deprecated rank (P2241), reason for preferred rank (P7452), earliest date (P1319), latest start date (P8555), earliest end date (P8554), latest date (P1326), applies to part, aspect, or form (P518), subject named as (P1810)”: 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/P2291#allowed qualifiers, SPARQL

Type “work (Q386724), human (Q5), musical group (Q215380), musical duo (Q9212979)”: item must contain property “instance of (P31)” with classes “work (Q386724), human (Q5), musical group (Q215380), musical duo (Q9212979)” 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).
List of violations of this constraint: Database reports/Constraint violations/P2291#Type Q386724, Q5, Q215380, Q9212979, SPARQL

Value type “record chart (Q373899), ranked list (Q80793969)”: This property should use items as value that contain property “instance of (P31)”. On these, the value for instance of (P31) should be an item that uses subclass of (P279) with value record chart (Q373899), ranked list (Q80793969) (or a subclass thereof). (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/P2291#Value type Q373899, Q80793969, SPARQL

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/P2291#citation needed

This property is being used by: ca:Plantilla:Infotaula d'àlbum Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Broad scope

Based on this discussion last month, should we broad the scope of this property for other things than music charts? Some languages need to be adjusted. @Jheald, Jura1, Pasleim: pinging since the discussion sadly died. Sjoerd de Bruin (talk) 18:56, 17 February 2018 (UTC)

I would prefer not to broaden the scope of this one. I think its quite a specific property for quite a specific concept, and one that works well. Jheald (talk) 20:59, 17 February 2018 (UTC)

Covers, and other issues

I'm planning to import no. 1 Billboard Hot 100 rankings from the English Wikipedia list articles. Issues:

• How are covers represented? Is the data added to the item for the original song, or is a new item created for the cover version?
• How should singles containing two songs be represented?
  • Should each song have the data added separately? (Should an item exist representing the single, with another two items representing the songs?)
  • Is this different for singles with an A-side and a B-side, as opposed to two A-sides?
  • Do digital singles' B-sides qualify as actual B-sides?

Jc86035 (talk) 17:02, 18 February 2018 (UTC)

Also, why isn't point in time (P585) an allowed qualifier? Shouldn't the "chart date" be listed alongside the tracking period(s)? (Billboard has different tracking periods for sales/streaming and airplay, so this makes only allowing those three qualifiers a bit more complicated.) Jc86035 (talk) 17:05, 18 February 2018 (UTC)

Covers should have their own item. With a based on (P144) to the original. Singles should have 3 (or later in the CD age 3+) items: 1 for the single and 1 for each song. Linked to each other with has part(s) (P527)/part of (P361) (depending on what the item is about). Is it the single that's in the Billboard 100 or a song? point in time (P585) isn't a qualifier because we have start time (P580) and end time (P582) to mark the period. Mbch331 (talk) 17:21, 18 February 2018 (UTC)

@Mbch331: Which period is used, for Billboard Hot 100 specifically? Currently the radio airplay period is Monday to Sunday and the other data is from Friday to Thursday; it would make more sense to me to put the methodology information on the item for the chart than in every chart position statement. Jc86035 (talk) 06:03, 19 February 2018 (UTC)

Furthermore, for data after the inclusion of digital downloads and streaming, should there still be separate items for the single and the song; and should cover versions which are counted as the same as the original song by Billboard (i.e. Despacito (Justin Bieber) and Perfect Duet (Beyoncé)) have the data on the cover version or the original, or whichever version Billboard credits the chart position to? Jc86035 (talk) 06:12, 19 February 2018 (UTC)

If the cover is made by a different artist, then in the eyes of Wikidata they are different concepts and thus different items. The data applies to the version Billboard uses. But since you're importing from enwiki, do you have an example of a list article you are planning to use? That would make it easier to answer your questions. Mbch331 (talk) 06:41, 19 February 2018 (UTC)

@Mbch331: I'll use 1972, 1996 and 2018 as examples. 1972 for the singles with B-sides, 1996 for the double A-sides and remixes (i.e. Macarena (Q1149738)), and 2018 for the singles without physical versions and the weird crediting situation with Perfect (Q29051557). There are various points concerning the changes in methodology (tracking week, etc.) and the inclusion of non-singles, airplay, streaming, digital downloads and remixes in the English Wikipedia article. I'm not going to add reference statements straight from the lists (though some of them, e.g. 1987, do have multiple reliable secondary sources) but will add references (with URL, title, publisher, access date) in Billboard's https://www.billboard.com/charts/hot-100/1983-01-01 format. I've been trying to convert the tables into CSV.

For items like Bad Blood (Q19892111) (digital download single released as a remix of the original), does a new item need to be created for both the remix and the single, or is the remix the single, or are both of them considered the same as the original item? The current Wikidata item appears to be about the remix single. Jc86035 (talk) 08:01, 19 February 2018 (UTC)

@Mbch331: Should I put the start date and end date as both sets of dates (Monday–Sunday and Friday–Thursday), or the full range (Friday–Sunday after)? Or is it supposed to be the period that the chart was the latest chart published, or the period from the chart date to the day before the next chart date? I'll probably end up importing album chart positions first, since they're just less complicated in terms of data structure. Jc86035 (talk) 04:59, 21 February 2018 (UTC)