Tango.info musical work code

From tango.info wiki
Revision as of 2012-07-22T08:27:40 by Tobiasco (talk | contribs) (→‎Statistics based on track data: | 2012-07-22 || 63455 || 45509 || 3473 || 3118 || 2936)
Jump to navigation Jump to search

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 and TIWC Works with tracks and ISWC Works with tracks and ISWC starting with T037
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
2012-07-06 62748 43936 3254 2939 2761
2012-07-16 62770 44167 3299 2978 2800
2012-07-17 62770 44535 3354 3024 2845
2012-07-18 63240 45121 3389 3053 2874
2012-07-19 63240 45182 3396 3058 2879
2012-07-20 63455 45356 3441 3094 2915
2012-07-21 63455 45484 3463 3111 2929
2012-07-22 63455 45509 3473 3118 2936

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