Tango.info musical work code: Difference between revisions
Jump to navigation
Jump to search
(→List of statistics based on track data: | 2018-02-28 || 100039 || 91511 || 10572 || 7313 || 6377) |
|||
(377 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[ | [[Category:Tango.info]] | ||
[[ | [[Category:Identifier]] | ||
== Definition == | == Definition == | ||
A [[tango.info musical work]] code (TIWC) is a [[tango.info code]] that identifies a [[tango.info musical work]]. | 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 can start with the letter T or with the letter Z. A TIWC that starts with the letter: | ||
* T is an [[ISWC]], e.g. T0370000024 | |||
* | * Z | ||
** | ** is not an ISWC | ||
** | ** '''is not stable''' | ||
** can start either with: | |||
*** Z000 and then contains the SADAIC work number, e.g. the TIWC Z0000015621 contains the SADAIC work number 15621. | |||
*** Z0999. These contain a subrange, codes therein can be assigned to tracks: https://tango.info/?q=Z099990 | |||
== Obtain via tagger == | == Obtain via tagger == | ||
Line 19: | Line 20: | ||
== Statistics based on track data == | == Statistics based on track data == | ||
=== SQL statement for statistics based on track data === | |||
SELECT date(CURRENT_TIMESTAMP()) | SELECT date(CURRENT_TIMESTAMP()) | ||
Line 25: | Line 27: | ||
SELECT count(*) | SELECT count(*) | ||
FROM `ti_track` | FROM `ti_track` | ||
WHERE ` | WHERE `tinp` REGEXP '[0-9]{14}' | ||
AND ` | AND `side_num` > 0 | ||
AND `track_num` > 0 | AND `track_num` > 0 | ||
Line 34: | Line 36: | ||
FROM `ti_track` | FROM `ti_track` | ||
WHERE `work_id` REGEXP '[TZ]{1}[0-9]{10}' | WHERE `work_id` REGEXP '[TZ]{1}[0-9]{10}' | ||
AND ` | AND `tinp` REGEXP '[0-9]{14}' | ||
UNION ALL | UNION ALL | ||
SELECT COUNT( DISTINCT work_id) | SELECT COUNT( DISTINCT work_id) | ||
FROM ` | FROM `ti_track` | ||
WHERE `work_id` REGEXP '[TZ]{1}[0-9]{10}' | WHERE `work_id` REGEXP '[TZ]{1}[0-9]{10}' | ||
AND ` | AND `tinp` REGEXP '[0-9]{14}' | ||
UNION ALL | UNION ALL | ||
Line 48: | Line 50: | ||
FROM `ti_track` | FROM `ti_track` | ||
WHERE `work_id` REGEXP '[T]{1}[0-9]{10}' | WHERE `work_id` REGEXP '[T]{1}[0-9]{10}' | ||
AND ` | AND `tinp` REGEXP '[0-9]{14}' | ||
UNION ALL | UNION ALL | ||
Line 55: | Line 57: | ||
FROM `ti_track` | FROM `ti_track` | ||
WHERE `work_id` REGEXP 'T037[0-9]{7}' | WHERE `work_id` REGEXP 'T037[0-9]{7}' | ||
AND ` | AND `tinp` REGEXP '[0-9]{14}' | ||
=== List of statistics based on track data === | |||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
! style="width: | ! style="width:90px" | Date | ||
! Tracks | ! Tracks | ||
! Tracks | ! Tracks having TIWC | ||
! Works | ! Works having tracks and TIWC | ||
! Works | ! Works having tracks and ISWC | ||
! Works | ! Works having tracks and ISWC starting with T037 | ||
|- | |- | ||
| 2012-03-08 || - || | | 2012-03-08 || - || 34583 || 2102 || || | ||
|- | |- | ||
| 2012-03-15 || - || | | 2012-03-15 || - || 37139 || 2318 || || | ||
|- | |- | ||
| 2012-03-17 || - || | | 2012-03-17 || - || 40051 || 2644 || || | ||
|- | |- | ||
| 2012-03-20 || - || | | 2012-03-20 || - || 41135 || 2759 || 2503 || 2361 | ||
|- | |- | ||
| 2012-03-25 || - || | | 2012-03-25 || - || 42097 || 2905 || 2632 || 2474 | ||
|- | |- | ||
| 2012-04-06 || - || | | 2012-04-06 || - || 42341 || 2947 || 2670 || 2508 | ||
|- | |- | ||
| 2012-06-19 || - || | | 2012-06-19 || - || 43111 || 3098 || 2802 || 2631 | ||
|- | |- | ||
| 2012-06-20 || - || | | 2012-06-20 || - || 43347 || 3129 || 2828 || 2655 | ||
|- | |- | ||
| 2012-07-01 || - || | | 2012-07-01 || - || 43537 || 3173 || 2869 || 2695 | ||
|- | |- | ||
| 2012-07-03 || - || | | 2012-07-03 || - || 43636 || 3197 || 2890 || 2716 | ||
|- | |- | ||
| 2012-07-04 || 62733 || 43802 || 3227 || 2914 || 2737 | | 2012-07-04 || 62733 || 43802 || 3227 || 2914 || 2737 | ||
Line 106: | Line 109: | ||
|- | |- | ||
| 2012-07-24 || 63467 || 45728 || 3514 || 3152 || 2970 | | 2012-07-24 || 63467 || 45728 || 3514 || 3152 || 2970 | ||
|- | |||
| 2012-07-27 || 63467 || 45891 || 3547 || 3180 || 2998 | |||
|- | |||
| 2012-07-28 || 63467 || 46102 || 3595 || 3221 || 3038 | |||
|- | |||
| 2012-07-29 || 63479 || 46275 || 3637 || 3259 || 3075 | |||
|- | |||
| 2012-07-30 || 63479 || 46305 || 3647 || 3268 || 3083 | |||
|- | |||
| 2012-08-01 || 63521 || 46437 || 3677 || 3296 || 3110 | |||
|- | |||
| 2012-08-08 || 63612 || 46674 || 3716 || 3326 || 3135 | |||
|- | |||
| 2012-08-14 || 63612 || 46729 || 3730 || 3336 || 3144 | |||
|- | |||
| 2012-08-15 || 63612 || 46934 || 3793 || 3394 || 3198 | |||
|- | |||
| 2012-08-16 || 63612 || 47006 || 3817 || 3416 || 3220 | |||
|- | |||
| 2012-08-17 || 63612 || 47044 || 3832 || 3431 || 3235 | |||
|- | |||
| 2012-08-19 || 63612 || 47075 || 3835 || 3434 || 3237 | |||
|- | |||
| 2012-08-25 || 63624 || 47133 || 3857 || 3453 || 3256 | |||
|- | |||
| 2012-08-26 || 63624 || 47181 || 3880 || 3474 || 3267 | |||
|- | |||
| 2012-08-30 || 63624 || 47255 || 3902 || 3495 || 3287 | |||
|- | |||
| 2012-09-04 || 63624 || 47339 || 3926 || 3518 || 3309 | |||
|- | |||
| 2012-09-07 || 63624 || 47489 || 3976 || 3564 || 3353 | |||
|- | |||
| 2012-09-09 || 63624 || 47576 || 4005 || 3587 || 3375 | |||
|- | |||
| 2012-09-14 || 63624 || 47633 || 4025 || 3602 || 3389 | |||
|- | |||
| 2012-09-15 || 63624 || 47799 || 4049 || 3625 || 3408 | |||
|- | |||
| 2012-09-17 || 63624 || 47901 || 4084 || 3655 || 3438 | |||
|- | |||
| 2012-09-19 || 63624 || 48031 || 4121 || 3689 || 3468 | |||
|- | |||
| 2012-09-20 || 63624 || 48199 || 4183 || 3745 || 3524 | |||
|- | |||
| 2012-09-21 || 63624 || 48358 || 4242 || 3792 || 3569 | |||
|- | |||
| 2012-11-10 || 63692 || 48674 || 4350 || 3887 || 3660 | |||
|- | |||
| 2012-11-11 || 63692 || 48949 || 4456 || 3986 || 3751 | |||
|- | |||
| 2012-11-12 || 63692 || 49010 || 4480 || 4007 || 3772 | |||
|- | |||
| 2012-11-18 || 63735 || 49056 || 4488 || 4015 || 3779 | |||
|- | |||
| 2012-11-25 || 63735 || 49112 || 4504 || 4028 || 3791 | |||
|- | |||
| 2012-11-30 || 63735 || 49125 || 4509 || 4033 || 3796 | |||
|- | |||
| 2012-12-26 || 63735 || 49146 || 4516 || 4038 || 3801 | |||
|- | |||
| 2013-01-08 || 65168 || 49290 || 4521 || 4042 || 3805 | |||
|- | |||
| 2013-01-10 || 65168 || 49442 || 4535 || 4054 || 3816 | |||
|- | |||
| 2013-01-11 || 65168 || 49533 || 4542 || 4058 || 3820 | |||
|- | |||
| 2013-01-12 || 65168 || 49657 || 4561 || 4075 || 3837 | |||
|- | |||
| 2013-01-13 || 65168 || 49903 || 4604 || 4109 || 3869 | |||
|- | |||
| 2013-01-16 || 65346 || 50072 || 4634 || 4133 || 3891 | |||
|- | |||
| 2013-01-18 || 65346 || 50110 || 4646 || 4144 || 3902 | |||
|- | |||
| 2013-01-20 || 65427 || 50251 || 4669 || 4165 || 3923 | |||
|- | |||
| 2013-01-27 || 65427 || 50540 || 4732 || 4225 || 3982 | |||
|- | |||
| 2013-01-31 || 65522 || 50859 || 4800 || 4288 || 4037 | |||
|- | |||
| 2013-02-01 || 65522 || 50908 || 4811 || 4298 || 4045 | |||
|- | |||
| 2013-02-08 || 65542 || 51544 || 4926 || 4399 || 4141 | |||
|- | |||
| 2013-02-10 || 65542 || 51756 || 5008 || 4467 || 4192 | |||
|- | |||
| 2013-02-11 || 66449 || 52695 || 5044 || 4496 || 4218 | |||
|- | |||
| 2013-02-14 || 66631 || 52909 || 5054 || 4505 || 4227 | |||
|- | |||
| 2013-02-15 || 66692 || 52975 || 5056 || 4507 || 4229 | |||
|- | |||
| 2013-02-16 || 66790 || 53204 || 5129 || 4570 || 4290 | |||
|- | |||
| 2013-02-21 || 67888 || 54070 || 5215 || 4647 || 4359 | |||
|- | |||
| 2013-02-26 || 68125 || 54548 || 5273 || 4694 || 4399 | |||
|- | |||
| 2013-03-03 || 68169 || 54657 || 5301 || 4716 || 4418 | |||
|- | |||
| 2013-03-07 || 68182 || 54724 || 5319 || 4732 || 4433 | |||
|- | |||
| 2013-03-13 || 68290 || 54978 || 5373 || 4776 || 4475 | |||
|- | |||
| 2013-03-20 || 68304 || 55014 || 5381 || 4783 || 4481 | |||
|- | |||
| 2013-04-01 || 68333 || 55288 || 5458 || 4848 || 4532 | |||
|- | |||
| 2013-04-04 || 68410 || 55484 || 5494 || 4878 || 4561 | |||
|- | |||
| 2013-04-05 || 68635 || 55751 || 5516 || 4897 || 4579 | |||
|- | |||
| 2013-04-07 || 68635 || 55946 || 5580 || 4950 || 4622 | |||
|- | |||
| 2013-04-15 || 68660 || 56017 || 5600 || 4969 || 4641 | |||
|- | |||
| 2013-04-17 || 68660 || 56105 || 5636 || 5005 || 4658 | |||
|- | |||
| 2013-04-20 || 68660 || 56156 || 5667 || 5036 || 4680 | |||
|- | |||
| 2013-04-25 || 68864 || 56204 || 5674 || 5043 || 4686 | |||
|- | |||
| 2013-04-26 || 68864 || 56378 || 5699 || 5064 || 4705 | |||
|- | |||
| 2013-05-05 || 68932 || 58938 || 6347 || 5194 || 4792 | |||
|- | |||
| 2013-05-07 || 68972 || 59223 || 6486 || 5239 || 4833 | |||
|- | |||
| 2013-05-12 || 69044 || 59427 || 6529 || 5262 || 4854 | |||
|- | |||
| 2013-05-17 || 69056 || 60001 || 6844 || 5322 || 4895 | |||
|- | |||
| 2013-05-22 || 69069 || 60044 || 6858 || 5335 || 4907 | |||
|- | |||
| 2013-05-23 || 69069 || 60610 || 7166 || 5357 || 4927 | |||
|- | |||
| 2013-05-26 || 69159 || 60691 || 7166 || 5357 || 4927 | |||
|- | |||
| 2013-06-01 || 69159 || 61570 || 7546 || 5417 || 4980 | |||
|- | |||
| 2013-06-02 || 69171 || 61631 || 7582 || 5428 || 4986 | |||
|- | |||
| 2013-06-26 || 69196 || 61664 || 7585 || 5431 || 4987 | |||
|- | |||
| 2013-07-01 || 69196 || 61666 || 7586 || 5432 || 4988 | |||
|- | |||
| 2013-07-02 || 69387 || 61860 || 7588 || 5434 || 4989 | |||
|- | |||
| 2013-07-15 || 69506 || 61981 || 7610 || 5447 || 5002 | |||
|- | |||
| 2013-08-06 || 69582 || 62058 || 7618 || 5454 || 5008 | |||
|- | |||
| 2013-08-06 || 69732 || 62212 || 7622 || 5458 || 5012 | |||
|- | |||
| 2013-08-13 || 70783 || 62326 || 7633 || 5463 || 5017 | |||
|- | |||
| 2013-08-15 || 70783 || 62511 || 7650 || 5469 || 5023 | |||
|- | |||
| 2013-08-19 || 70795 || 62709 || 7680 || 5484 || 5038 | |||
|- | |||
| 2013-09-04 || 70864 || 62774 || 7684 || 5487 || 5041 | |||
|- | |||
| 2013-09-05 || 70932 || 62838 || 7692 || 5493 || 5045 | |||
|- | |||
| 2013-09-11 || 70932 || 62886 || 7698 || 5496 || 5048 | |||
|- | |||
| 2013-09-17 || 70932 || 62925 || 7708 || 5499 || 5051 | |||
|- | |||
| 2013-09-20 || 70932 || 62983 || 7717 || 5504 || 5055 | |||
|- | |||
| 2013-09-22 || 70932 || 63055 || 7741 || 5522 || 5072 | |||
|- | |||
| 2013-09-25 || 71005 || 63133 || 7741 || 5522 || 5072 | |||
|- | |||
| 2013-09-30 || 71364 || 63503 || 7748 || 5524 || 5074 | |||
|- | |||
| 2013-10-12 || 71431 || 63587 || 7763 || 5537 || 5086 | |||
|- | |||
| 2013-10-19 || 71770 || 63961 || 7787 || 5555 || 5103 | |||
|- | |||
| 2013-10-20 || 71874 || 64065 || 7799 || 5565 || 5113 | |||
|- | |||
| 2013-10-24 || 72106 || 64265 || 7808 || 5575 || 5115 | |||
|- | |||
| 2013-10-26 || 72108 || 64389 || 7893 || 5580 || 5117 | |||
|- | |||
| 2013-10-29 || 72108 || 64445 || 7906 || 5584 || 5121 | |||
|- | |||
| 2013-11-02 || 72447 || 64793 || 7921 || 5597 || 5132 | |||
|- | |||
| 2013-11-05 || 72632 || 64872 || 7936 || 5609 || 5142 | |||
|- | |||
| 2013-11-09 || 72684 || 64954 || 7938 || 5611 || 5143 | |||
|- | |||
| 2013-11-09 || 72752 || 65023 || 7950 || 5617 || 5149 | |||
|- | |||
| 2013-11-11 || 72892 || 65177 || 7950 || 5617 || 5149 | |||
|- | |||
| 2013-11-15 || 73370 || 65431 || 7957 || 5623 || 5150 | |||
|- | |||
| 2013-11-16 || 73645 || 65762 || 7961 || 5625 || 5151 | |||
|- | |||
| 2013-11-17 || 73736 || 65894 || 7968 || 5629 || 5153 | |||
|- | |||
| 2013-11-18 || 73816 || 66088 || 7992 || 5647 || 5168 | |||
|- | |||
| 2013-11-20 || 73827 || 66116 || 7994 || 5648 || 5168 | |||
|- | |||
| 2013-11-22 || 73827 || 66191 || 8004 || 5653 || 5169 | |||
|- | |||
| 2013-11-23 || 73827 || 66430 || 8032 || 5678 || 5191 | |||
|- | |||
| 2013-11-24 || 73843 || 66535 || 8048 || 5690 || 5202 | |||
|- | |||
| 2013-11-28 || 73879 || 66571 || 8049 || 5691 || 5203 | |||
|- | |||
| 2013-11-30 || 73879 || 66574 || 8051 || 5693 || 5205 | |||
|- | |||
| 2013-12-08 || 73879 || 66591 || 8057 || 5701 || 5212 | |||
|- | |||
| 2013-12-12 || 73879 || 66659 || 8073 || 5711 || 5222 | |||
|- | |||
| 2013-12-19 || 74039 || 66810 || 8075 || 5713 || 5223 | |||
|- | |||
| 2014-01-01 || 74115 || 66898 || 8084 || 5720 || 5229 | |||
|- | |||
| 2014-01-09 || 74176 || 66964 || 8103 || 5727 || 5234 | |||
|- | |||
| 2014-02-05 || 74259 || 67057 || 8109 || 5733 || 5239 | |||
|- | |||
| 2014-02-06 || 74331 || 67145 || 8113 || 5736 || 5242 | |||
|- | |||
| 2014-02-14 || 74515 || 67348 || 8115 || 5738 || 5243 | |||
|- | |||
| 2014-02-16 || 74535 || 67376 || 8119 || 5743 || 5246 | |||
|- | |||
| 2014-02-17 || 74535 || 67387 || 8126 || 5750 || 5251 | |||
|- | |||
| 2014-02-20 || 75086 || 67957 || 8170 || 5795 || 5286 | |||
|- | |||
| 2014-03-01 || 75095 || 67964 || 8174 || 5799 || 5288 | |||
|- | |||
| 2014-03-02 || 75663 || 67981 || 8176 || 5801 || 5290 | |||
|- | |||
| 2014-03-04 || 75668 || 68280 || 8200 || 5810 || 5296 | |||
|- | |||
| 2014-03-08 || 75728 || 68412 || 8252 || 5854 || 5333 | |||
|- | |||
| 2014-03-11 || 75785 || 68481 || 8265 || 5867 || 5343 | |||
|- | |||
| 2014-03-17 || 75843 || 68536 || 8271 || 5868 || 5344 | |||
|- | |||
| 2014-03-18 || 75908 || 68605 || 8276 || 5871 || 5347 | |||
|- | |||
| 2014-03-23 || 76212 || 68925 || 8282 || 5876 || 5352 | |||
|- | |||
| 2014-03-31 || 76504 || 69228 || 8285 || 5879 || 5355 | |||
|- | |||
| 2014-04-02 || 76756 || 69477 || 8285 || 5879 || 5355 | |||
|- | |||
| 2014-04-03 || 76832 || 69554 || 8286 || 5880 || 5356 | |||
|- | |||
| 2014-04-06 || 77006 || 69733 || 8293 || 5886 || 5362 | |||
|- | |||
| 2014-04-08 || 77243 || 70007 || 8297 || 5890 || 5366 | |||
|- | |||
| 2014-04-08 || 77445 || 70220 || 8301 || 5892 || 5368 | |||
|- | |||
| 2014-04-09 || 77505 || 70295 || 8312 || 5900 || 5376 | |||
|- | |||
| 2014-04-10 || 77649 || 70444 || 8314 || 5902 || 5378 | |||
|- | |||
| 2014-04-12 || 77891 || 70713 || 8336 || 5922 || 5398 | |||
|- | |||
| 2014-04-13 || 78101 || 70941 || 8343 || 5928 || 5403 | |||
|- | |||
| 2014-04-14 || 78200 || 71067 || 8357 || 5940 || 5414 | |||
|- | |||
| 2014-04-15 || 78453 || 71313 || 8365 || 5948 || 5421 | |||
|- | |||
| 2014-04-16 || 78466 || 71394 || 8400 || 5969 || 5432 | |||
|- | |||
| 2014-04-17 || 78468 || 71439 || 8433 || 5996 || 5449 | |||
|- | |||
| 2014-04-20 || 78506 || 71604 || 8502 || 6041 || 5475 | |||
|- | |||
| 2014-04-21 || 78550 || 71651 || 8516 || 6049 || 5479 | |||
|- | |||
| 2014-04-22 || 78606 || 71732 || 8550 || 6061 || 5487 | |||
|- | |||
| 2014-04-23 || 78620 || 71824 || 8606 || 6078 || 5495 | |||
|- | |||
| 2014-05-30 || 78798 || 71964 || 8635 || 6098 || 5499 | |||
|- | |||
| 2014-07-20 || 78903 || 71995 || 8638 || 6100 || 5501 | |||
|- | |||
| 2014-07-25 || 78964 || 72077 || 8666 || 6108 || 5504 | |||
|- | |||
| 2014-07-29 || 79140 || 72269 || 8671 || 6112 || 5507 | |||
|- | |||
| 2014-07-30 || 79187 || 72322 || 8682 || 6122 || 5516 | |||
|- | |||
| 2014-07-31 || 79187 || 72347 || 8689 || 6129 || 5520 | |||
|- | |||
| 2014-08-14 || 79271 || 72433 || 8710 || 6157 || 5548 | |||
|- | |||
| 2014-08-21 || 79271 || 72506 || 8767 || 6222 || 5557 | |||
|- | |||
| 2014-08-29 || 79314 || 72567 || 8798 || 6243 || 5570 | |||
|- | |||
| 2014-09-07 || 79757 || 72835 || 8838 || 6269 || 5591 | |||
|- | |||
| 2014-09-10 || 80671 || 73288 || 8912 || 6291 || 5608 | |||
|- | |||
| 2014-09-13 || 80791 || 74327 || 9075 || 6358 || 5662 | |||
|- | |||
| 2014-10-07 || 81197 || 74712 || 9092 || 6367 || 5667 | |||
|- | |||
| 2014-10-16 || 81437 || 74954 || 9096 || 6371 || 5669 | |||
|- | |||
| 2014-12-31 || 81542 || 75070 || 9122 || 6390 || 5679 | |||
|- | |||
| 2015-01-10 || 82190 || 75129 || 9126 || 6393 || 5681 | |||
|- | |||
| 2015-01-11 || 82190 || 75444 || 9148 || 6413 || 5698 | |||
|- | |||
| 2015-01-13 || 82251 || 75561 || 9187 || 6440 || 5720 | |||
|- | |||
| 2015-01-14 || 82251 || 75698 || 9202 || 6454 || 5722 | |||
|- | |||
| 2015-01-15 || 82251 || 75994 || 9251 || 6488 || 5752 | |||
|- | |||
| 2015-01-16 || 82251 || 76147 || 9342 || 6564 || 5799 | |||
|- | |||
| 2015-01-28 || 82251 || 76157 || 9345 || 6567 || 5801 | |||
|- | |||
| 2015-06-01 || 82314 || 76212 || 9365 || 6575 || 5809 | |||
|- | |||
| 2015-06-10 || 82375 || 76286 || 9389 || 6593 || 5824 | |||
|- | |||
| 2015-06-22 || 82515 || 76429 || 9403 || 6603 || 5832 | |||
|- | |||
| 2015-06-30 || 82555 || 76479 || 9412 || 6607 || 5835 | |||
|- | |||
| 2015-08-31 || 82890 || 76812 || 9441 || 6630 || 5857 | |||
|- | |||
| 2015-10-13 || 83791 || 77697 || 9452 || 6639 || 5866 | |||
|- | |||
| 2015-10-16 || 86283 || 78173 || 9487 || 6670 || 5891 | |||
|- | |||
| 2015-10-17 || 86283 || 79843 || 9611 || 6762 || 5979 | |||
|- | |||
| 2015-10-28 || 86285 || 79874 || 9632 || 6777 || 5993 | |||
|- | |||
| 2015-10-31 || 86351 || 80024 || 9705 || 6818 || 6029 | |||
|- | |||
| 2015-11-06 || 86383 || 80143 || 9756 || 6858 || 6055 | |||
|- | |||
| 2015-11-07 || 86383 || 80168 || 9779 || 6871 || 6066 | |||
|- | |||
| 2015-11-09 || 86383 || 80231 || 9829 || 6910 || 6101 | |||
|- | |||
| 2015-11-10 || 86383 || 80298 || 9864 || 6943 || 6117 | |||
|- | |||
| 2015-11-11 || 86428 || 80420 || 9926 || 6985 || 6142 | |||
|- | |||
| 2015-11-13 || 86444 || 80498 || 9981 || 6994 || 6148 | |||
|- | |||
| 2015-11-15 || 86832 || 80943 || 10043 || 7025 || 6176 | |||
|- | |||
| 2016-06-18 || 86832 || 80945 || 10046 || 7025 || 6176 | |||
|- | |||
| 2016-11-21 || 87378 || 81642 || 10239 || 7125 || 6207 | |||
|- | |||
| 2017-08-06 || 88564 || 82873 || 10292 || 7146 || 6225 | |||
|- | |||
| 2017-08-18 || 89108 || 83431 || 10303 || 7153 || 6231 | |||
|- | |||
| 2017-08-25 || 90021 || 84344 || 10336 || 7166 || 6244 | |||
|- | |||
| 2017-09-12 || 90295 || 84629 || 10361 || 7188 || 6265 | |||
|- | |||
| 2018-02-03 || 91006 || 85256 || 10414 || 7215 || 6290 | |||
|- | |||
| 2018-02-11 || 96611 || 88741 || 10491 || 7264 || 6339 | |||
|- | |||
| 2018-02-20 || 100039 || 90548 || 10493 || 7266 || 6341 | |||
|- | |||
| 2018-02-21 || 100039 || 90744 || 10495 || 7267 || 6342 | |||
|- | |||
| 2018-02-23 || 100039 || 91040 || 10500 || 7271 || 6346 | |||
|- | |||
| 2018-02-25 || 100039 || 91386 || 10535 || 7296 || 6362 | |||
|- | |||
| 2018-02-28 || 100039 || 91511 || 10572 || 7313 || 6377 | |||
|} | |} | ||
== Dubious codes == | |||
TIDB contained: | |||
*T0370437527, is now Z0000120923 | |||
*T0370014597, is now Z0000001480 | |||
*T0370237663, is now Z0000072999 | |||
*T0370020748, is now Z0000002174 | |||
*T0391714003 in track table, is now T0046988877 | |||
Not found in SADAIC, but kept: | |||
* T0370023010 Pobre corazoncito 2479 | |||
* T0370018146 [[Matasano]] 1842, found in ISWCnet | |||
* T0370124756 [[El curdela]] - found in ISWCnet | |||
* T0370404628 [[Destino de flor]] 114773 - found in ISWCnet | |||
* T0370067916 [[Fogon de huella]] 14138 - found in ISWCnet | |||
* T0370026100 [[Romantica]] 2902, code not found in ISWCnet | |||
* T0370014257 [[Griseta]] 1446, code not found in ISWCnet | |||
Non T037 | |||
* T0464664989, not found | |||
T037 not in SADAIC | |||
* T0370005347 Canillita ASCAP+CISAC, Sadaic#540 | |||
== List of performer specific sets that have been checked == | == List of performer specific sets that have been checked == | ||
Line 112: | Line 534: | ||
* Angel D'Agostino - 0 missing | * Angel D'Agostino - 0 missing | ||
* Angel Vargas - 2 missing | * Angel Vargas - 2 missing | ||
Now with own made codes, almost complete: | |||
* https://tango.info/performance/JuanaDarie | |||
* https://tango.info/performance/RodolBiagi | |||
* https://tango.info/performance/OsvalPugli | |||
* https://tango.info/performance/EnriqRodri | |||
* https://tango.info/performance/RoberRufin |
Latest revision as of 2018-02-28T04:50:53
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. A TIWC that starts with the letter:
- T is an ISWC, e.g. T0370000024
- Z
- is not an ISWC
- is not stable
- can start either with:
- Z000 and then contains the SADAIC work number, e.g. the TIWC Z0000015621 contains the SADAIC work number 15621.
- Z0999. These contain a subrange, codes therein can be assigned to tracks: https://tango.info/?q=Z099990
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
SQL statement for statistics based on track data
SELECT date(CURRENT_TIMESTAMP()) UNION ALL SELECT count(*) FROM `ti_track` WHERE `tinp` REGEXP '[0-9]{14}' AND `side_num` > 0 AND `track_num` > 0 UNION ALL SELECT count(*) FROM `ti_track` WHERE `work_id` REGEXP '[TZ]{1}[0-9]{10}' AND `tinp` REGEXP '[0-9]{14}' UNION ALL SELECT COUNT( DISTINCT work_id) FROM `ti_track` WHERE `work_id` REGEXP '[TZ]{1}[0-9]{10}' AND `tinp` REGEXP '[0-9]{14}' UNION ALL SELECT COUNT( DISTINCT work_id ) FROM `ti_track` WHERE `work_id` REGEXP '[T]{1}[0-9]{10}' AND `tinp` REGEXP '[0-9]{14}' UNION ALL SELECT COUNT( DISTINCT work_id ) FROM `ti_track` WHERE `work_id` REGEXP 'T037[0-9]{7}' AND `tinp` REGEXP '[0-9]{14}'
List of statistics based on track data
Date | Tracks | Tracks having TIWC | Works having tracks and TIWC | Works having tracks and ISWC | Works having 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 |
2012-07-28 | 63467 | 46102 | 3595 | 3221 | 3038 |
2012-07-29 | 63479 | 46275 | 3637 | 3259 | 3075 |
2012-07-30 | 63479 | 46305 | 3647 | 3268 | 3083 |
2012-08-01 | 63521 | 46437 | 3677 | 3296 | 3110 |
2012-08-08 | 63612 | 46674 | 3716 | 3326 | 3135 |
2012-08-14 | 63612 | 46729 | 3730 | 3336 | 3144 |
2012-08-15 | 63612 | 46934 | 3793 | 3394 | 3198 |
2012-08-16 | 63612 | 47006 | 3817 | 3416 | 3220 |
2012-08-17 | 63612 | 47044 | 3832 | 3431 | 3235 |
2012-08-19 | 63612 | 47075 | 3835 | 3434 | 3237 |
2012-08-25 | 63624 | 47133 | 3857 | 3453 | 3256 |
2012-08-26 | 63624 | 47181 | 3880 | 3474 | 3267 |
2012-08-30 | 63624 | 47255 | 3902 | 3495 | 3287 |
2012-09-04 | 63624 | 47339 | 3926 | 3518 | 3309 |
2012-09-07 | 63624 | 47489 | 3976 | 3564 | 3353 |
2012-09-09 | 63624 | 47576 | 4005 | 3587 | 3375 |
2012-09-14 | 63624 | 47633 | 4025 | 3602 | 3389 |
2012-09-15 | 63624 | 47799 | 4049 | 3625 | 3408 |
2012-09-17 | 63624 | 47901 | 4084 | 3655 | 3438 |
2012-09-19 | 63624 | 48031 | 4121 | 3689 | 3468 |
2012-09-20 | 63624 | 48199 | 4183 | 3745 | 3524 |
2012-09-21 | 63624 | 48358 | 4242 | 3792 | 3569 |
2012-11-10 | 63692 | 48674 | 4350 | 3887 | 3660 |
2012-11-11 | 63692 | 48949 | 4456 | 3986 | 3751 |
2012-11-12 | 63692 | 49010 | 4480 | 4007 | 3772 |
2012-11-18 | 63735 | 49056 | 4488 | 4015 | 3779 |
2012-11-25 | 63735 | 49112 | 4504 | 4028 | 3791 |
2012-11-30 | 63735 | 49125 | 4509 | 4033 | 3796 |
2012-12-26 | 63735 | 49146 | 4516 | 4038 | 3801 |
2013-01-08 | 65168 | 49290 | 4521 | 4042 | 3805 |
2013-01-10 | 65168 | 49442 | 4535 | 4054 | 3816 |
2013-01-11 | 65168 | 49533 | 4542 | 4058 | 3820 |
2013-01-12 | 65168 | 49657 | 4561 | 4075 | 3837 |
2013-01-13 | 65168 | 49903 | 4604 | 4109 | 3869 |
2013-01-16 | 65346 | 50072 | 4634 | 4133 | 3891 |
2013-01-18 | 65346 | 50110 | 4646 | 4144 | 3902 |
2013-01-20 | 65427 | 50251 | 4669 | 4165 | 3923 |
2013-01-27 | 65427 | 50540 | 4732 | 4225 | 3982 |
2013-01-31 | 65522 | 50859 | 4800 | 4288 | 4037 |
2013-02-01 | 65522 | 50908 | 4811 | 4298 | 4045 |
2013-02-08 | 65542 | 51544 | 4926 | 4399 | 4141 |
2013-02-10 | 65542 | 51756 | 5008 | 4467 | 4192 |
2013-02-11 | 66449 | 52695 | 5044 | 4496 | 4218 |
2013-02-14 | 66631 | 52909 | 5054 | 4505 | 4227 |
2013-02-15 | 66692 | 52975 | 5056 | 4507 | 4229 |
2013-02-16 | 66790 | 53204 | 5129 | 4570 | 4290 |
2013-02-21 | 67888 | 54070 | 5215 | 4647 | 4359 |
2013-02-26 | 68125 | 54548 | 5273 | 4694 | 4399 |
2013-03-03 | 68169 | 54657 | 5301 | 4716 | 4418 |
2013-03-07 | 68182 | 54724 | 5319 | 4732 | 4433 |
2013-03-13 | 68290 | 54978 | 5373 | 4776 | 4475 |
2013-03-20 | 68304 | 55014 | 5381 | 4783 | 4481 |
2013-04-01 | 68333 | 55288 | 5458 | 4848 | 4532 |
2013-04-04 | 68410 | 55484 | 5494 | 4878 | 4561 |
2013-04-05 | 68635 | 55751 | 5516 | 4897 | 4579 |
2013-04-07 | 68635 | 55946 | 5580 | 4950 | 4622 |
2013-04-15 | 68660 | 56017 | 5600 | 4969 | 4641 |
2013-04-17 | 68660 | 56105 | 5636 | 5005 | 4658 |
2013-04-20 | 68660 | 56156 | 5667 | 5036 | 4680 |
2013-04-25 | 68864 | 56204 | 5674 | 5043 | 4686 |
2013-04-26 | 68864 | 56378 | 5699 | 5064 | 4705 |
2013-05-05 | 68932 | 58938 | 6347 | 5194 | 4792 |
2013-05-07 | 68972 | 59223 | 6486 | 5239 | 4833 |
2013-05-12 | 69044 | 59427 | 6529 | 5262 | 4854 |
2013-05-17 | 69056 | 60001 | 6844 | 5322 | 4895 |
2013-05-22 | 69069 | 60044 | 6858 | 5335 | 4907 |
2013-05-23 | 69069 | 60610 | 7166 | 5357 | 4927 |
2013-05-26 | 69159 | 60691 | 7166 | 5357 | 4927 |
2013-06-01 | 69159 | 61570 | 7546 | 5417 | 4980 |
2013-06-02 | 69171 | 61631 | 7582 | 5428 | 4986 |
2013-06-26 | 69196 | 61664 | 7585 | 5431 | 4987 |
2013-07-01 | 69196 | 61666 | 7586 | 5432 | 4988 |
2013-07-02 | 69387 | 61860 | 7588 | 5434 | 4989 |
2013-07-15 | 69506 | 61981 | 7610 | 5447 | 5002 |
2013-08-06 | 69582 | 62058 | 7618 | 5454 | 5008 |
2013-08-06 | 69732 | 62212 | 7622 | 5458 | 5012 |
2013-08-13 | 70783 | 62326 | 7633 | 5463 | 5017 |
2013-08-15 | 70783 | 62511 | 7650 | 5469 | 5023 |
2013-08-19 | 70795 | 62709 | 7680 | 5484 | 5038 |
2013-09-04 | 70864 | 62774 | 7684 | 5487 | 5041 |
2013-09-05 | 70932 | 62838 | 7692 | 5493 | 5045 |
2013-09-11 | 70932 | 62886 | 7698 | 5496 | 5048 |
2013-09-17 | 70932 | 62925 | 7708 | 5499 | 5051 |
2013-09-20 | 70932 | 62983 | 7717 | 5504 | 5055 |
2013-09-22 | 70932 | 63055 | 7741 | 5522 | 5072 |
2013-09-25 | 71005 | 63133 | 7741 | 5522 | 5072 |
2013-09-30 | 71364 | 63503 | 7748 | 5524 | 5074 |
2013-10-12 | 71431 | 63587 | 7763 | 5537 | 5086 |
2013-10-19 | 71770 | 63961 | 7787 | 5555 | 5103 |
2013-10-20 | 71874 | 64065 | 7799 | 5565 | 5113 |
2013-10-24 | 72106 | 64265 | 7808 | 5575 | 5115 |
2013-10-26 | 72108 | 64389 | 7893 | 5580 | 5117 |
2013-10-29 | 72108 | 64445 | 7906 | 5584 | 5121 |
2013-11-02 | 72447 | 64793 | 7921 | 5597 | 5132 |
2013-11-05 | 72632 | 64872 | 7936 | 5609 | 5142 |
2013-11-09 | 72684 | 64954 | 7938 | 5611 | 5143 |
2013-11-09 | 72752 | 65023 | 7950 | 5617 | 5149 |
2013-11-11 | 72892 | 65177 | 7950 | 5617 | 5149 |
2013-11-15 | 73370 | 65431 | 7957 | 5623 | 5150 |
2013-11-16 | 73645 | 65762 | 7961 | 5625 | 5151 |
2013-11-17 | 73736 | 65894 | 7968 | 5629 | 5153 |
2013-11-18 | 73816 | 66088 | 7992 | 5647 | 5168 |
2013-11-20 | 73827 | 66116 | 7994 | 5648 | 5168 |
2013-11-22 | 73827 | 66191 | 8004 | 5653 | 5169 |
2013-11-23 | 73827 | 66430 | 8032 | 5678 | 5191 |
2013-11-24 | 73843 | 66535 | 8048 | 5690 | 5202 |
2013-11-28 | 73879 | 66571 | 8049 | 5691 | 5203 |
2013-11-30 | 73879 | 66574 | 8051 | 5693 | 5205 |
2013-12-08 | 73879 | 66591 | 8057 | 5701 | 5212 |
2013-12-12 | 73879 | 66659 | 8073 | 5711 | 5222 |
2013-12-19 | 74039 | 66810 | 8075 | 5713 | 5223 |
2014-01-01 | 74115 | 66898 | 8084 | 5720 | 5229 |
2014-01-09 | 74176 | 66964 | 8103 | 5727 | 5234 |
2014-02-05 | 74259 | 67057 | 8109 | 5733 | 5239 |
2014-02-06 | 74331 | 67145 | 8113 | 5736 | 5242 |
2014-02-14 | 74515 | 67348 | 8115 | 5738 | 5243 |
2014-02-16 | 74535 | 67376 | 8119 | 5743 | 5246 |
2014-02-17 | 74535 | 67387 | 8126 | 5750 | 5251 |
2014-02-20 | 75086 | 67957 | 8170 | 5795 | 5286 |
2014-03-01 | 75095 | 67964 | 8174 | 5799 | 5288 |
2014-03-02 | 75663 | 67981 | 8176 | 5801 | 5290 |
2014-03-04 | 75668 | 68280 | 8200 | 5810 | 5296 |
2014-03-08 | 75728 | 68412 | 8252 | 5854 | 5333 |
2014-03-11 | 75785 | 68481 | 8265 | 5867 | 5343 |
2014-03-17 | 75843 | 68536 | 8271 | 5868 | 5344 |
2014-03-18 | 75908 | 68605 | 8276 | 5871 | 5347 |
2014-03-23 | 76212 | 68925 | 8282 | 5876 | 5352 |
2014-03-31 | 76504 | 69228 | 8285 | 5879 | 5355 |
2014-04-02 | 76756 | 69477 | 8285 | 5879 | 5355 |
2014-04-03 | 76832 | 69554 | 8286 | 5880 | 5356 |
2014-04-06 | 77006 | 69733 | 8293 | 5886 | 5362 |
2014-04-08 | 77243 | 70007 | 8297 | 5890 | 5366 |
2014-04-08 | 77445 | 70220 | 8301 | 5892 | 5368 |
2014-04-09 | 77505 | 70295 | 8312 | 5900 | 5376 |
2014-04-10 | 77649 | 70444 | 8314 | 5902 | 5378 |
2014-04-12 | 77891 | 70713 | 8336 | 5922 | 5398 |
2014-04-13 | 78101 | 70941 | 8343 | 5928 | 5403 |
2014-04-14 | 78200 | 71067 | 8357 | 5940 | 5414 |
2014-04-15 | 78453 | 71313 | 8365 | 5948 | 5421 |
2014-04-16 | 78466 | 71394 | 8400 | 5969 | 5432 |
2014-04-17 | 78468 | 71439 | 8433 | 5996 | 5449 |
2014-04-20 | 78506 | 71604 | 8502 | 6041 | 5475 |
2014-04-21 | 78550 | 71651 | 8516 | 6049 | 5479 |
2014-04-22 | 78606 | 71732 | 8550 | 6061 | 5487 |
2014-04-23 | 78620 | 71824 | 8606 | 6078 | 5495 |
2014-05-30 | 78798 | 71964 | 8635 | 6098 | 5499 |
2014-07-20 | 78903 | 71995 | 8638 | 6100 | 5501 |
2014-07-25 | 78964 | 72077 | 8666 | 6108 | 5504 |
2014-07-29 | 79140 | 72269 | 8671 | 6112 | 5507 |
2014-07-30 | 79187 | 72322 | 8682 | 6122 | 5516 |
2014-07-31 | 79187 | 72347 | 8689 | 6129 | 5520 |
2014-08-14 | 79271 | 72433 | 8710 | 6157 | 5548 |
2014-08-21 | 79271 | 72506 | 8767 | 6222 | 5557 |
2014-08-29 | 79314 | 72567 | 8798 | 6243 | 5570 |
2014-09-07 | 79757 | 72835 | 8838 | 6269 | 5591 |
2014-09-10 | 80671 | 73288 | 8912 | 6291 | 5608 |
2014-09-13 | 80791 | 74327 | 9075 | 6358 | 5662 |
2014-10-07 | 81197 | 74712 | 9092 | 6367 | 5667 |
2014-10-16 | 81437 | 74954 | 9096 | 6371 | 5669 |
2014-12-31 | 81542 | 75070 | 9122 | 6390 | 5679 |
2015-01-10 | 82190 | 75129 | 9126 | 6393 | 5681 |
2015-01-11 | 82190 | 75444 | 9148 | 6413 | 5698 |
2015-01-13 | 82251 | 75561 | 9187 | 6440 | 5720 |
2015-01-14 | 82251 | 75698 | 9202 | 6454 | 5722 |
2015-01-15 | 82251 | 75994 | 9251 | 6488 | 5752 |
2015-01-16 | 82251 | 76147 | 9342 | 6564 | 5799 |
2015-01-28 | 82251 | 76157 | 9345 | 6567 | 5801 |
2015-06-01 | 82314 | 76212 | 9365 | 6575 | 5809 |
2015-06-10 | 82375 | 76286 | 9389 | 6593 | 5824 |
2015-06-22 | 82515 | 76429 | 9403 | 6603 | 5832 |
2015-06-30 | 82555 | 76479 | 9412 | 6607 | 5835 |
2015-08-31 | 82890 | 76812 | 9441 | 6630 | 5857 |
2015-10-13 | 83791 | 77697 | 9452 | 6639 | 5866 |
2015-10-16 | 86283 | 78173 | 9487 | 6670 | 5891 |
2015-10-17 | 86283 | 79843 | 9611 | 6762 | 5979 |
2015-10-28 | 86285 | 79874 | 9632 | 6777 | 5993 |
2015-10-31 | 86351 | 80024 | 9705 | 6818 | 6029 |
2015-11-06 | 86383 | 80143 | 9756 | 6858 | 6055 |
2015-11-07 | 86383 | 80168 | 9779 | 6871 | 6066 |
2015-11-09 | 86383 | 80231 | 9829 | 6910 | 6101 |
2015-11-10 | 86383 | 80298 | 9864 | 6943 | 6117 |
2015-11-11 | 86428 | 80420 | 9926 | 6985 | 6142 |
2015-11-13 | 86444 | 80498 | 9981 | 6994 | 6148 |
2015-11-15 | 86832 | 80943 | 10043 | 7025 | 6176 |
2016-06-18 | 86832 | 80945 | 10046 | 7025 | 6176 |
2016-11-21 | 87378 | 81642 | 10239 | 7125 | 6207 |
2017-08-06 | 88564 | 82873 | 10292 | 7146 | 6225 |
2017-08-18 | 89108 | 83431 | 10303 | 7153 | 6231 |
2017-08-25 | 90021 | 84344 | 10336 | 7166 | 6244 |
2017-09-12 | 90295 | 84629 | 10361 | 7188 | 6265 |
2018-02-03 | 91006 | 85256 | 10414 | 7215 | 6290 |
2018-02-11 | 96611 | 88741 | 10491 | 7264 | 6339 |
2018-02-20 | 100039 | 90548 | 10493 | 7266 | 6341 |
2018-02-21 | 100039 | 90744 | 10495 | 7267 | 6342 |
2018-02-23 | 100039 | 91040 | 10500 | 7271 | 6346 |
2018-02-25 | 100039 | 91386 | 10535 | 7296 | 6362 |
2018-02-28 | 100039 | 91511 | 10572 | 7313 | 6377 |
Dubious codes
TIDB contained:
- T0370437527, is now Z0000120923
- T0370014597, is now Z0000001480
- T0370237663, is now Z0000072999
- T0370020748, is now Z0000002174
- T0391714003 in track table, is now T0046988877
Not found in SADAIC, but kept:
- T0370023010 Pobre corazoncito 2479
- T0370018146 Matasano 1842, found in ISWCnet
- T0370124756 El curdela - found in ISWCnet
- T0370404628 Destino de flor 114773 - found in ISWCnet
- T0370067916 Fogon de huella 14138 - found in ISWCnet
- T0370026100 Romantica 2902, code not found in ISWCnet
- T0370014257 Griseta 1446, code not found in ISWCnet
Non T037
- T0464664989, not found
T037 not in SADAIC
- T0370005347 Canillita ASCAP+CISAC, Sadaic#540
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
Now with own made codes, almost complete: