Tango.info track date statistics: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[category:music]]
[[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  


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


==By day==
==By day==
Line 62: Line 68:


===Least===
===Least===
* 11-01 1 Canaro http://www.tango.info/1927-11-01
* 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
* 12-25 2
* https://tango.info/10-12 1 Juan Félix Maglio https://tango.info/1928-10-12, [[Día de la Raza]]
* 01-01 2
* https://tango.info/12-25 2
* 11-11 3
* https://tango.info/01-01 2
* 02-13 5
* https://tango.info/11-11 3
* 02-10 8
* https://tango.info/02-13 5
* 12-08 9
* https://tango.info/02-10 8
* https://tango.info/12-08 9


===Without===
===Without===
* 10-12
* 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

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

Without

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