Tango.info musical work code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
(→‎Statistics based on track data: | 2012-07-22 || 63467 || 45700 || 3509 || 3148 || 2966)
No edit summary
Line 11: Line 11:


TIWC that start with the letter Z '''are not stable'''.
TIWC that start with the letter Z '''are not stable'''.
== Obtain via tagger ==
Data is available via the [[tango.info track tagger]] with the tag %tiwc%.


== TIWC-6 ==
== TIWC-6 ==

Revision as of 2012-07-22T17:10:14

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.

Obtain via tagger

Data is available via the tango.info track tagger with the tag %tiwc%.

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 63467 45700 3509 3148 2966

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