IDN Forums - Internationalized Domain Names  
Home | Advertise on idnforums | Premium Membership

Go Back   IDN Forums - Internationalized Domain Names > IDN Discussions > General Discussion

General Discussion Feel free to talk about anything and everything in this board.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 3rd November 2013, 07:02 AM
Junior Member
 
Join Date: Oct 2012
Posts: 16
iTrader: (1)
Rep Power: 0
joel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished road
presence of idn in top 1000000 alexa

Hello

Based on 8 month old data, here the idn tld in alexa 1st million:

SELECT SUBSTRING_INDEX(domain, '.', -1) AS c,COUNT(*) FROM alexainfos WHERE domain LIKE "xn--%" GROUP BY c;


c count(*)
com 306
xn--p1ai 241
net 67
tk 26
jp 18
su 13
eu 10
de 6
se 6
ua 5
gr 5
il 5
tv 4
tw 4
kz 4
cc 4
es 3
pl 3
biz 3
ws 3
dk 2
bg 2
fr 2
no 2
pt 1
hu 1
tr 1
info 1
it 1
th 1
kr 1
vn 1
lt 1
co 1
ru 1
br 1
nu 1
org 1
as 1
ar 1
Reply With Quote
  #2 (permalink)  
Old 3rd November 2013, 01:54 PM
squirrel's Avatar
Senior Member
 
Join Date: Nov 2009
Posts: 2,940
iTrader: (11)
Rep Power: 7084
squirrel is a name known to all
squirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to all
Re: presence of idn in top 1000000 alexa

Cool. Do you have the average ranking for each ?
Reply With Quote
  #3 (permalink)  
Old 3rd November 2013, 02:05 PM
Junior Member
 
Join Date: Oct 2012
Posts: 16
iTrader: (1)
Rep Power: 0
joel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished roadjoel is on a distinguished road
Re: presence of idn in top 1000000 alexa

SELECT SUBSTRING_INDEX(domain, '.', -1) AS c , SUM(alexa) /COUNT(*) AS averagerank, COUNT(*) FROM alexainfos WHERE domain LIKE "xn--%" GROUP BY c;

c averagerank COUNT(*)
com 619795.8627 306
xn--p1ai 583481.3000 240
net 598526.5672 67
tk 486606.1923 26
jp 564734.0556 18
su 659621.3077 13
eu 506296.3000 10
de 754648.5000 6
se 830622.6667 6
ua 668669.0000 5
gr 707600.8000 5
il 751079.6000 5
tw 881618.7500 4
tv 744712.0000 4
kz 297731.2500 4
cc 325373.0000 4
biz 503850.6667 3
ws 650404.3333 3
pl 714208.3333 3
es 769613.3333 3
no 799579.0000 2
bg 826388.5000 2
fr 955106.5000 2
dk 446037.0000 2
org 647092.0000 1
hu 993004.0000 1
ru 797659.0000 1
br 811063.0000 1
vn 532375.0000 1
pt 516361.0000 1
nu 849795.0000 1
th 864641.0000 1
info 886064.0000 1
co 462613.0000 1
it 919353.0000 1
ar 951220.0000 1
lt 305833.0000 1
kr 986789.0000 1
tr 175411.0000 1
as 160365.0000 1
Reply With Quote
  #4 (permalink)  
Old 3rd November 2013, 02:16 PM
squirrel's Avatar
Senior Member
 
Join Date: Nov 2009
Posts: 2,940
iTrader: (11)
Rep Power: 7084
squirrel is a name known to all
squirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to allsquirrel is a name known to all
Re: presence of idn in top 1000000 alexa

Cool
Reply With Quote
  #5 (permalink)  
Old 3rd November 2013, 08:05 PM
DktoInc's Avatar
Senior Member
 
Join Date: Dec 2009
Location: Land of the Loon
Posts: 1,583
iTrader: (2)
Rep Power: 2171
DktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura aboutDktoInc has a spectacular aura about
Re: presence of idn in top 1000000 alexa

thank you
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 10:43 PM.

Site Sponsors
Your ad here
buy t-shirt
מחיר הזהב

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright idnforums.com 2005

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54