Tango.info musical work code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
(→‎Statistics based on track data: | 2014-04-22 || 78606 || 71732 || 8550 || 6061 || 5487)
(→‎Statistics based on track data: | 2014-04-23 || 78620 || 71824 || 8606 || 6078 || 5495)
Line 397: Line 397:
|-
|-
| 2014-04-22 || 78606 || 71732 || 8550 || 6061 || 5487
| 2014-04-22 || 78606 || 71732 || 8550 || 6061 || 5487
|-
| 2014-04-23 || 78620 || 71824 || 8606 || 6078 || 5495
|}
|}


Revision as of 2014-04-23T04:59:55

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

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}'
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
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

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:

Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_musical_work_code&oldid=63112"