Tango.info track date statistics

Yearly

• http://simbatango.com/2009/10/16/the-golden-age-visualized/

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 

• http://www.tango.info/1935-03-19 86 Gardel
• http://www.tango.info/1934-07-30 75 Gardel
• http://www.tango.info/1947-04-29 74 Troilo
• http://www.tango.info/1963-04-25 59 Troilo
• http://www.tango.info/1944-11-23 53 Troilo, De Angelis
• http://www.tango.info/1944-03-30 51
• http://www.tango.info/1943-08-10 51
• http://www.tango.info/1942-10-09 50
• http://www.tango.info/1935-03-20 50
• http://www.tango.info/1942-09-09 50
• http://www.tango.info/1944-12-19 49
• http://www.tango.info/1942-09-02 49
• http://www.tango.info/1952-08-13 49
• http://www.tango.info/1942-06-15 48
• http://www.tango.info/1951-09-12 48
• http://www.tango.info/1941-03-04 48
• http://www.tango.info/1947-08-19 47
• http://www.tango.info/1943-12-17 44 D'Arienzo, Di Sarli
• http://www.tango.info/1958-12-23 44
• http://www.tango.info/1948-07-08 44
• http://www.tango.info/1954-12-10 43 D'Arienzo
• http://www.tango.info/1943-08-04 43
• http://www.tango.info/1942-08-12 42 D'Arienzo, Di Sarli
• http://www.tango.info/1946-07-11 41
• http://www.tango.info/1955-06-10 41
• http://www.tango.info/1942-12-04 40

By day

SELECT substring(track_date,6) AS track_day, 
 count(substring(track_date,6)) 
FROM `tango_tracks` 
WHERE substring(track_date,6) RLIKE '^[0-9]{2}-[0-9]{2}$' 
GROUP BY track_day ORDER BY count(substring(track_date,6))  
DESC

• 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