Tango.info musical work code: Difference between revisions
Jump to navigation
Jump to search
Line 106: | Line 106: | ||
|- | |- | ||
| 2012-07-24 || 63467 || 45728 || 3514 || 3152 || 2970 | | 2012-07-24 || 63467 || 45728 || 3514 || 3152 || 2970 | ||
|- | |||
| 2012-07-27 || 63467 || 45783 || 3529 || 3166 || 2984 | |||
|} | |} | ||
Revision as of 2012-07-27T17:03:58
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 | - | 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 |
2012-07-24 | 63467 | 45728 | 3514 | 3152 | 2970 |
2012-07-27 | 63467 | 45783 | 3529 | 3166 | 2984 |
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