Tango.info track date statistics: Difference between revisions
Jump to navigation
Jump to search
(→By day) |
(→Least) |
||
(20 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[ | [[Category:Music]] | ||
==Overview== | |||
This page gives some [[tango.info track date]] statistics. | |||
==Yearly== | ==Yearly== | ||
* http://simbatango.com/2009/10/16/the-golden-age-visualized/ | * http://simbatango.com/2009/10/16/the-golden-age-visualized/ | ||
== Monthly == | |||
* http://simbatango.com/2011/04/05/tango-recordings-through-the-year/ | |||
==By date== | ==By date== | ||
Line 13: | Line 19: | ||
ORDER BY COUNT( track_date ) DESC | ORDER BY COUNT( track_date ) DESC | ||
* | * https://tango.info/1935-03-19 86 Gardel | ||
* | * https://tango.info/1934-07-30 75 Gardel | ||
* | * https://tango.info/1947-04-29 74 Troilo | ||
* | * https://tango.info/1963-04-25 59 Troilo | ||
* | * https://tango.info/1944-11-23 53 Troilo, De Angelis | ||
* | * https://tango.info/1944-03-30 51 | ||
* | * https://tango.info/1943-08-10 51 | ||
* | * https://tango.info/1942-10-09 50 | ||
* | * https://tango.info/1935-03-20 50 | ||
* | * https://tango.info/1942-09-09 50 | ||
* | * https://tango.info/1944-12-19 49 | ||
* | * https://tango.info/1942-09-02 49 | ||
* | * https://tango.info/1952-08-13 49 | ||
* | * https://tango.info/1942-06-15 48 | ||
* | * https://tango.info/1951-09-12 48 | ||
* | * https://tango.info/1941-03-04 48 | ||
* | * https://tango.info/1947-08-19 47 | ||
* | * https://tango.info/1943-12-17 44 D'Arienzo, Di Sarli | ||
* | * https://tango.info/1958-12-23 44 | ||
* | * https://tango.info/1948-07-08 44 | ||
* | * https://tango.info/1954-12-10 43 D'Arienzo | ||
* | * https://tango.info/1943-08-04 43 | ||
* | * https://tango.info/1942-08-12 42 D'Arienzo, Di Sarli | ||
* | * https://tango.info/1946-07-11 41 | ||
* | * https://tango.info/1955-06-10 41 | ||
* | * https://tango.info/1942-12-04 40 | ||
==By day== | ==By day== | ||
SELECT substring(track_date,6) AS track_day, | SELECT substring(track_date,6) AS track_day, | ||
count(substring(track_date,6)) | count(substring(track_date,6)) AS track_day_count | ||
FROM `tango_tracks` | FROM `tango_tracks` | ||
WHERE substring(track_date,6) RLIKE '^[0-9]{2}-[0-9]{2}' | WHERE substring(track_date,6) RLIKE '^[0-9]{2}-[0-9]{2}$' | ||
GROUP BY track_day ORDER BY | GROUP BY track_day ORDER BY track_day_count | ||
DESC | DESC | ||
===Most=== | |||
* 10-09 231 | * 10-09 231 | ||
* 12-17 185 | * 12-17 185 | ||
Line 60: | Line 66: | ||
* 07-14 156 | * 07-14 156 | ||
* 11-13 152 | * 11-13 152 | ||
===Least=== | |||
* https://tango.info/11-01 1 Canaro https://tango.info/1927-11-01, http://en.wikipedia.org/wiki/November_1#Holidays_and_observances - All Saints Day | |||
* https://tango.info/10-12 1 Juan Félix Maglio https://tango.info/1928-10-12, [[Día de la Raza]] | |||
* https://tango.info/12-25 2 | |||
* https://tango.info/01-01 2 | |||
* https://tango.info/11-11 3 | |||
* https://tango.info/02-13 5 | |||
* https://tango.info/02-10 8 | |||
* https://tango.info/12-08 9 | |||
===Without=== | |||
* https://tango.info/07-09 [[Nueve de Julio]] |
Latest revision as of 2014-03-25T05:56:51
Overview
This page gives some tango.info track date statistics.
Yearly
Monthly
By date
Days with the most tracks (As of 2011-04-02)
SELECT track_date, COUNT( track_date ) FROM `tango_tracks` WHERE track_date RLIKE '[0-9]{4}-[0-9]{2}-[0-9]{2}' GROUP BY track_date ORDER BY COUNT( track_date ) DESC
- https://tango.info/1935-03-19 86 Gardel
- https://tango.info/1934-07-30 75 Gardel
- https://tango.info/1947-04-29 74 Troilo
- https://tango.info/1963-04-25 59 Troilo
- https://tango.info/1944-11-23 53 Troilo, De Angelis
- https://tango.info/1944-03-30 51
- https://tango.info/1943-08-10 51
- https://tango.info/1942-10-09 50
- https://tango.info/1935-03-20 50
- https://tango.info/1942-09-09 50
- https://tango.info/1944-12-19 49
- https://tango.info/1942-09-02 49
- https://tango.info/1952-08-13 49
- https://tango.info/1942-06-15 48
- https://tango.info/1951-09-12 48
- https://tango.info/1941-03-04 48
- https://tango.info/1947-08-19 47
- https://tango.info/1943-12-17 44 D'Arienzo, Di Sarli
- https://tango.info/1958-12-23 44
- https://tango.info/1948-07-08 44
- https://tango.info/1954-12-10 43 D'Arienzo
- https://tango.info/1943-08-04 43
- https://tango.info/1942-08-12 42 D'Arienzo, Di Sarli
- https://tango.info/1946-07-11 41
- https://tango.info/1955-06-10 41
- https://tango.info/1942-12-04 40
By day
SELECT substring(track_date,6) AS track_day, count(substring(track_date,6)) AS track_day_count FROM `tango_tracks` WHERE substring(track_date,6) RLIKE '^[0-9]{2}-[0-9]{2}$' GROUP BY track_day ORDER BY track_day_count DESC
Most
- 10-09 231
- 12-17 185
- 04-29 181
- 12-19 179
- 11-23 177
- 12-14 166
- 09-27 164
- 03-20 161
- 12-10 160
- 04-25 159
- 07-14 156
- 11-13 152
Least
- https://tango.info/11-01 1 Canaro https://tango.info/1927-11-01, http://en.wikipedia.org/wiki/November_1#Holidays_and_observances - All Saints Day
- https://tango.info/10-12 1 Juan Félix Maglio https://tango.info/1928-10-12, Día de la Raza
- https://tango.info/12-25 2
- https://tango.info/01-01 2
- https://tango.info/11-11 3
- https://tango.info/02-13 5
- https://tango.info/02-10 8
- https://tango.info/12-08 9