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, e.g. T0370000024
• 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.

Statistics based on track data

SELECT date(CURRENT_TIMESTAMP())

UNION ALL

SELECT count(*) 
FROM  `ti_tracks` 
WHERE  `product_tin` REGEXP  '[0-9]{14}'
AND `product_side` > 0
AND `track_num` > 0

UNION ALL

SELECT count(*) 
FROM  `ti_tracks` 
WHERE  `work_id` REGEXP  '[TZ]{1}[0-9]{10}'
AND  `product_tin` REGEXP  '[0-9]{14}'

UNION ALL

SELECT COUNT( DISTINCT work_id)
FROM  `ti_tracks`
WHERE  `work_id` REGEXP  '[TZ]{1}[0-9]{10}'
AND `product_tin` REGEXP  '[0-9]{14}'

UNION ALL

SELECT COUNT( DISTINCT work_id )
FROM  `ti_tracks` 
WHERE  `work_id` REGEXP  '[T]{1}[0-9]{10}'
AND  `product_tin` REGEXP  '[0-9]{14}'

UNION ALL

SELECT COUNT( DISTINCT work_id ) 
FROM  `ti_tracks` 
WHERE  `work_id` REGEXP  'T037[0-9]{7}'
AND  `product_tin` REGEXP  '[0-9]{14}'

Date	Tracks	Tracks with TIWC	Works with tracks	Works with ISWC with tracks	Works with ISWC starting with T037 with tracks
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	2,361
2012-03-25	-	42,097	2,905	2,632	2,474
2012-04-06	-	42,341	2,947	2,670	2,508
2012-06-19	-	43,111	3,098	2,802	2,631
2012-06-20	-	43,347	3,129	2,828	2,655
2012-07-01	-	43,537	3,173	2,869	2,695
2012-07-03	-	43,636	3,197	2,890	2,716
2012-07-04	62733	43802	3227	2914	2737
2012-07-05	62733	43855	3239	2925	2748

List of performer specific sets that have been checked

It was tried to find codes for all tracks by these performers:

• Angel D'Agostino - 0 missing
• Angel Vargas - 2 missing