Tango.info track date statistics: Difference between revisions
Jump to navigation
Jump to search
(→Daily) |
(→Daily) |
||
Line 3: | Line 3: | ||
* http://simbatango.com/2009/10/16/the-golden-age-visualized/ | * http://simbatango.com/2009/10/16/the-golden-age-visualized/ | ||
== | ==By date== | ||
Days with the most tracks (As of 2011-04-02) | Days with the most tracks (As of 2011-04-02) | ||
Line 39: | Line 39: | ||
* http://www.tango.info/1955-06-10 41 | * http://www.tango.info/1955-06-10 41 | ||
* http://www.tango.info/1942-12-04 40 | * 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 |
Revision as of 2011-04-02T16:10:26
Yearly
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