Tango.info musical work code

Definition

A tango.info musical work code (TIWC) is a tango.info code that identifies a tango.info musical work.

TIWC can start with the letter T or with the letter Z.

• TIWC that start with the letter T are ISWC.
• TIWC that start with Z are not ISWC.
  • TIWC that start with the Z000 contain the SADAIC work number, e.g. the TIWC Z0000015621 contains the SADAIC work number 15621.
  • TIWC that start with Z but do not start with Z000 start with Z0999.

TIWC that start with the letter Z are not stable.

TIWC-6

As of 2011-12-29 the old TIWC 6-char codes have been withdrawn.

As of 2010 there is no plan to make these codes stable. New works are added frequently, often entering the system with

The work_codes are not stable (yet), they are sometimes changed.

Once they were planned to be 6 letter mnemonic. This needs lot of manual work. There are still many codes starting with zz and some have more than 3 numbers in it.

Current policy aims to have at least 4 letter and only 2 numbers. E.g.

• comm01 = Comme il faut

This is easier to achieve than 6 numbers : T.i editor can drag drop in Excel (automatic filling and increasing number) to get new codes. This also means number may change, if a new work gets inserted somewhere between abcd01 and abcd05 then all works after abcd05 may have a number shift.

In a good DB one would probably have a simple numeric work_id. work_id could be implemented additionally.

Statistics based on track data

Query A

SELECT * 
FROM  `tango_tracks` 
WHERE  `work_id` 
REGEXP  '[TZ0-9]{11}'
AND  `product_tin` 
REGEXP  '[0-9]{14}'

Query B

SELECT DISTINCT(work_id)
FROM  `tango_tracks`
WHERE  `work_id` REGEXP  '[TZ0-9]{11}'
AND `product_tin` REGEXP  '[0-9]{14}'

date: Result A | Result B | other

• 2012-03-08: 34,583 | 2,102
• 2012-03-15: 37,139 | 2,318
• 2012-03-17: 40,051 | 2,644
• 2012-03-20: 41,135 | 2,759 | (2,503 ISWC, 2,361 T037)
• 2012-03-25: 42,097 | 2,905 | (2,632 ISWC, 2,474 T037)