Property talk:P1827

Latest comment: 1 month ago by CV213 in topic ISWC format

Documentation

ISWC
identifier for musical works, adopted as international standard ISO 15707
DescriptionThe International Standard Musical Work Code is a unique identifier for musical works. It is adopted as international standard ISO 15707. The ISO subcommittee with responsibility for the standard is TC 46/SC 9. Each item in the registry has an ID which is accessible via this page and through other online resources. The authority also provides a unique IPI code directly "binded" to authors, composer, and other subject. These two codes could be extremely useful during an Authority control process.
Applicable "stated in" valueISWC Network (Q82271165)
Data typeExternal identifier
Template parameter"ISWC" in en:Template:Infobox_musical_composition (and could be used elsewhere in many other wikis, if adopted)
Domain
According to this template: creative works, author, composer.
According to statements in the property:
musical work/composition (Q105543609)
When possible, data should only be stored as statements
Allowed valuesT-[0-9]{3}\.[0-9]{3}\.[0-9]{3}-[0-9]
Example
According to this template: Dancing Queen (Q870786) => T-000000001-0
According to statements in the property:
Symphony No. 9 (Q11985)T-905.029.737-5
Supercalifragilisticexpialidocious (Q103)T-900.214.198-2
You Never Can Tell (Q2416766)T-070.940.913-1
When possible, data should only be stored as statements
Source
According to statements in the property:
http://www.iswc.org/
When possible, data should only be stored as statements
Formatter URLhttps://musicbrainz.org/iswc/$1
https://repertoire.bmi.com/Search/Search?Main_Search_Text=$1&Main_Search=ISWC
Tracking: usageCategory:Pages using Wikidata property P1827 (Q111558911)
See alsoIPI name number (P1828), ISRC (P1243), MusicBrainz work ID (P435), BMI work ID (P4860), ACE Repertory work ID (P4894), AllMusic composition ID (P1994), SESAC work number (P7956), SOCAN work number (P8106)
Lists
Proposal discussionProposal discussion
Current uses
Total19,437
Main statement10,46853.9% of uses
Qualifier1,7328.9% of uses
Reference7,23737.2% 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/P1827#Entity types
Scope is as main value (Q54828448), as reference (Q54828450), as qualifier (Q54828449): 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/P1827#Scope, 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/P1827#Unique value, SPARQL (every item), SPARQL (by value)
Single value: this property generally contains a single value. (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/P1827#Single value, SPARQL
Format “T-[0-9]{3}\.[0-9]{3}\.[0-9]{3}-[0-9]: 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/P1827#Format, SPARQL
Item “instance of (P31): Items with this property should also have “instance of (P31)”. (Help)
List of violations of this constraint: Database reports/Constraint violations/P1827#Item P31, hourly updated report, search, SPARQL
Type “musical work/composition (Q105543609): item must contain property “instance of (P31)” with classes “musical work/composition (Q105543609)” 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/P1827#Type Q105543609, SPARQL
Item “title (P1476): Items with this property should also have “title (P1476)”. (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/P1827#Item P1476, SPARQL
Conflicts with “MusicBrainz release group ID (P436): this property must not be used with the listed properties and values. (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/P1827#Conflicts with P436, search, SPARQL
Conflicts with “Discogs master ID (P1954): this property must not be used with the listed properties and values. (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/P1827#Conflicts with P1954, search, SPARQL
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/P1827#Conflicts with P31, SPARQL
 
This property is being used by:

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

 
Validate ISWC numbers
Report incorrect ISWC numbers, found by validating the checksum (Help)
Violations query: SELECT ?item #?itemLabel ?iswcnr ?checksum ?checksum2 ?quot ?rem WITH { SELECT DISTINCT * WHERE { ?item wdt:P1827 ?iswcnr . FILTER(strlen(?iswcnr) = 15) BIND(xsd:integer(substr(?iswcnr, 3, 1))*1 + xsd:integer(substr(?iswcnr, 4, 1))*2 + xsd:integer(substr(?iswcnr, 5, 1))*3 + xsd:integer(substr(?iswcnr, 7, 1))*4 + xsd:integer(substr(?iswcnr, 8, 1))*5 + xsd:integer(substr(?iswcnr, 9, 1))*6 + xsd:integer(substr(?iswcnr, 11, 1))*7 + xsd:integer(substr(?iswcnr, 12, 1))*8 + xsd:integer(substr(?iswcnr, 13, 1))*9 + 1 AS ?checksum) #BIND(floor(?checksum/10) AS ?quot) #BIND(?checksum - 10*?quot AS ?rem) BIND(10 - ?checksum + 10*floor(?checksum/10) AS ?checksum2) FILTER(SUBSTR(STR(?checksum2), strlen(?checksum2), 1) != substr(?iswcnr, 15, 1)) } #LIMIT 1000 } AS %i WHERE { INCLUDE %i SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } }
List of this constraint violations: Database reports/Complex constraint violations/P1827#Validate ISWC numbers

ISWC format edit

@Epìdosis: this should be stored in database format:

  1. T0000000010 - database format / most compact format
  2. T-000000001-0 - check digit and prefix separated / medium compact format
  3. T-000.000.001-0 - optimized for readability by human eyes / least compact format

CV213 (talk) 15:33, 16 February 2024 (UTC)Reply

I'm unsure, I've never used this ID and it's onestly beyond my sphere of interest. I reported it in Wikidata talk:WikiProject Music#ISWC format. --Epìdosis 15:38, 16 February 2024 (UTC)Reply
IMO it's more important that the format is consistent than if it contains spacing characters or not. According to Wikidata:Database_reports/Constraint_violations/P1827#"Format"_violations there are currently 63 items with format issues. Infrastruktur (talk) 15:47, 18 February 2024 (UTC)Reply
If it contains no spaces it is consistent not only within WD but with other professional databases. CV213 (talk) 18:07, 18 February 2024 (UTC)Reply
Return to "P1827" page.