Tango.info track date statistics: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
Line 3: Line 3:
* http://simbatango.com/2009/10/16/the-golden-age-visualized/
* http://simbatango.com/2009/10/16/the-golden-age-visualized/


==Daily==
==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

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
Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_track_date_statistics&oldid=35839"