Tango.info musical work code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
Line 65: Line 65:
! Works with tracks and ISWC starting with T037
! Works with tracks and ISWC starting with T037
|-
|-
| 2012-03-08 || - || 34,583 || 2,102 || ||  
| 2012-03-08 || - || 34583 || 2102 || ||  
|-
|-
| 2012-03-15 || - || 37,139 || 2,318 || ||  
| 2012-03-15 || - || 37139 || 2318 || ||  
|-
|-
| 2012-03-17 || - || 40,051 || 2,644 || ||  
| 2012-03-17 || - || 40051 || 2644 || ||  
|-
|-
| 2012-03-20 || - || 41,135 || 2,759 || 2,503 || 2,361
| 2012-03-20 || - || 41135 || 2759 || 2503 || 2361
|-
|-
| 2012-03-25 || - || 42,097 || 2,905 || 2,632 || 2,474
| 2012-03-25 || - || 42097 || 2905 || 2632 || 2474
|-
|-
| 2012-04-06 || - || 42,341 || 2,947 || 2,670 || 2,508
| 2012-04-06 || - || 42341 || 2947 || 2670 || 2508
|-
|-
| 2012-06-19 || - || 43,111 || 3,098 || 2,802 || 2,631
| 2012-06-19 || - || 43111 || 3098 || 2802 || 2631
|-
|-
| 2012-06-20 || - || 43,347 || 3,129 || 2,828 || 2,655
| 2012-06-20 || - || 43347 || 3129 || 2828 || 2655
|-
|-
| 2012-07-01 || - || 43,537 || 3,173 || 2,869 || 2,695
| 2012-07-01 || - || 43537 || 3173 || 2869 || 2695
|-
|-
| 2012-07-03 || - || 43,636 || 3,197 || 2,890 || 2,716
| 2012-07-03 || - || 43636 || 3197 || 2890 || 2716
|-
|-
| 2012-07-04 || 62733 || 43802 || 3227 || 2914 || 2737
| 2012-07-04 || 62733 || 43802 || 3227 || 2914 || 2737

Revision as of 2012-07-27T23:05:50

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_track` 
WHERE  `product_tin` REGEXP  '[0-9]{14}'
AND `product_side` > 0
AND `track_num` > 0

UNION ALL

SELECT count(*) 
FROM  `ti_track` 
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_track`
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_track` 
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_track` 
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 - 34583 2102
2012-03-15 - 37139 2318
2012-03-17 - 40051 2644
2012-03-20 - 41135 2759 2503 2361
2012-03-25 - 42097 2905 2632 2474
2012-04-06 - 42341 2947 2670 2508
2012-06-19 - 43111 3098 2802 2631
2012-06-20 - 43347 3129 2828 2655
2012-07-01 - 43537 3173 2869 2695
2012-07-03 - 43636 3197 2890 2716
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
2012-07-24 63467 45728 3514 3152 2970
2012-07-27 63467 45891 3547 3180 2998

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