How to use the Alexa Top 1M domain list for analysis

If you want to do some basic analytics on domain names e.g. the amount of popular domains sorted by country domain, here is how to create such an overview:

1. Download the top 1.000.000 sites .csv from Alexa:, they sold this list in the past but some years ago they gave it for free. For production uses you would probably use the Alexa webservices on Amazon to give you real time information.

2. This csv file contains domains in the form of e.g. “” along with their ranking, you can easily import this in e.g. a sqlite database using e.g. the firefox sqlite plugin (or the sqlite commandline plugin) (or with the pro version of dbvisualizer) (etc).


3. If you now want to match this against an existing set of url’s e.g. in a set of bookmarks you will have to figure out what is “top level” and what is not because if you have a bookmark you would use

 parse_url($bookmarkurl, PHP_URL_HOST) 

to get the host and will get

But… in Alexa you would want to match this with “” not “apps.” (otherwise it can not be matched). The problem here is how you would know that “apps.” would have to be stripped since in e.g. “” you would have to strip it in another place. This is an unsolvable problem: you will need to have a list of all country level domains.

So… to make this match there are several alternatives but most famous is the effective_tld_names list : (public suffix list)


Which is used e.g. in Firefox, Opera and Chrome

For PHP there is an existing class by the you can reuse to get the solution which you can include in a /lib.

4. You then simply use

 $registeredDomain = getRegisteredDomain($base_href_host, $tldTree); 

($tldTree is given bij DKIM-reputation as a global array which you can pass to a constructor and $base_href_host is the PHP_URL_HOST).

5. And next you can add two columns in your SqlLite table: the registered domain and the country level part (filled by a sql update run using the registeredDomain here above).

6. Based on this table you can now run lots of analytics on the top 1.000.000 domain names, you can even add new meta information to your own bookmarks collection.

However please note:

- Alexa gives you only the top level registed domain, so e.g. you can not distinguish between popularity of and : these will both the general  facebook rank. What happens in this case is actually that facebook acts as a further domain hierarchie: you will have to make a list of those kinds of sites and will have to further give popularity scores based on statistics in e.g., or blog platforms on its individual members. I have not seen yet a list of domains which you have to “take out of this Alexa list to analyze further” (someone out there probably has done this already but I have not found it yet). Basically these sites acts as N-level domain and should be put under its own catgegory not under .com.
If such a list has really not been created by anyone else (which I doubt) I will add some GPL project on e.g. Google Code with at least a good start of these types of N level registers.

- If you want to add whois records information maybe the is also handy for you

85 How to tie a tie video’s

image When I bought the book “the 85 ways to tie a tie” (13 feb 2005, I love my blog archives) I read about the 85 possible combinations of making a knot, the 4 most used ones (as can be predicted from the mathematical models) and 9 new aesthetic ones. I think this book belongs in every man’s library. It contains essential information on ties, the history and 85 ways including famous people who used these types of knots.

In my todo list I then added an item to make a movie of every possible knot combination and make a seperate section on this blog about it. It stayed on my todo list and I didn’t came to it. However in the meantime many video services started and I noted some tie-a-tie instrucitonal video’s appearing on these sites.

I thought I would share you these movies so they can help you to change once in a while the knot on your tie (or… monday’s the full windsor knot, tuesdays the half windsor knot, etc…).

I will keep the index of possible knots on the sequence from the book (in the book you can find with each knot a long description of the background of the knot and where it is used most and a long range of beautiful pictures, comparisons and descriptions on how to tie each knot):




Knot 1: “Oriental” also known as “simple knot“, “red knot“, “petit noeud

Much used in China, it’s the first knot taught to schoolboys. It’s however also handy when you have a tie of very heavy fabric.

The tie, which is placed inverted around the neck, is suitable with wool, and thick silk ties. The “Oriental” knot is symmetric knot which gets bigger as the tie gets thicker.


FOUR MOVE KNOTS (1 centre)

Knot 2: “Four-in-hand”

The best known and most used knot today. The name was derived from the 19th century gentlemen’s club of the same name.

This is the knot most fathers pass to their sons nowadays.


FIVE MOVE KNOTS (1 centre)

Knot 3: “Kelvin”

An extension of the oriental (1), you might have seen Fred Astaire wearing this one all the time.


FIVE MOVE KNOTS (2 centres)

Knot 4: “Nicky”

The advantage over the Pratt/Shelby is that it unties cleanly. It was invented by the Italian tie shop Nicky.

How To Tie A Shelby Knot
Knot 5: “Pratt” also known as “Shelby” and “reverse Half Windsor”

Apart from the four-in-a-hand (2), Windsor (31) and half Windsor (7) the Pratt/Shelby are the only knots which have gained widespread popularity.

It was used as early as WWII. The american inventor Jerry Pratt used it 30 years before don Shelby introduced it on TV in 1989.


Six Move Knots (1 centre)

Knot 6: “Victoria”

It’s a knot similar to the four-in-a-hand but with added bulk, which can be handy for thin or well-worn ties.


Six Move Knots (2 centres)

Knot 7: Half-Windsor

This is probably the most versatile of most knots and suits most collars.

Knot 8, 9, 10: I have found no video yet, maybe you can send me one Knot 8, Knot 9, Knot 10: I will skip them for this blogposting

Seven Move Knots (1 centre)

Knot 11: I have found no video yet, maybe you can send me one Knot 11: I will skip it in this blogposting

Seven Move Knots (2 centres)

Knot 12: “St. Andrew”

Lies between the half-Windsor and the Windsor but is more narrowly shaped. “not for an accountant but good for a merchant banker”
Knot 13, 14, 15, 16: I have found no video yet, maybe you can send me one Knot 13, 14, 15, 16 (smaller christensen), knot 17: I will skip them for this blogposting

Seven Move Knots (3 centres)

Knot 18: “Platssburgh” or “Dovorian”

For light or medium weight ties with a semi cutaway collar. Most effective in bringing back life to well-worn ties.

Knot 19: I have found no video yet, maybe you can send me one Knot 19: “Self-releasing Platssburgh”
Knot 20,21: I have found no video yet, maybe you can send me one Knot 20. 21: skipped

Eight Move Knots (1 centre)

Knot 22: I have found no video yet, maybe you can send me one Knot 22: skipped

Eight Move Knots (2 centres)

Knot 23: I have found no video yet, maybe you can send me one Knot 23: “Cavendish”

Its the same size as the Windsor but with two mirrored four-in-hands with the slight asymmetry. “A four-in-hand with  substance”

Knot 25: “Christensen”

This was published in 1917 by the Swedish mail order company Stralin and Persson and republished by Swedish tie make Amanda Christensen.

It was invented for straight ties but works well with narrow ties.

Knot 26-30: I have found no video yet, maybe you can send me one Knot 26,27,28,29,30 : skipped

Eight Move Knots (3 centres)

Knot 31: “Windsor”

The Prince of Wales, Duke of Windsor took a liking in large tie knots in 30’s. It is one of the four most used knots.

“fastened with the popular Windsor knot, larger than the usual four-in-hand, to fill the space of the whole spread collar” (Esquire 1940)

Knot 32-42: I have found no video yet, maybe you can send me one Knot 32-42, some of which are also known as Windsors : skipped

Nine Move Knots (1 centre)

Knot 43: I have found no video yet, maybe you can send me one Knot 43: skipped

Nine Move Knots (2 centres)

Knot 44: I have found no video yet, maybe you can send me one Knot 44: “Grantchester”

Among the three principal nine moves ties (44, 54 and 78) the Grantchester is the narrowest and least conspicious.

Knot 45-53: I have found no video yet, maybe you can send me one Knot 45, 46, 47, 48 (non releasing Grantchester), 49, 50,51, 52,53: skipped

Nine Move Knots (3 centres)

Knot 54 “Hanover”

The natural extension of the Oriental and the half-windsor. The only knots with perfect symmetry and balance.

Because of the size of the knot to be used with cutaway or semi-cutaway collars.

Knot 55-77: I have found no video yet, maybe you can send me one Knot 55,56,57,58,59,60,61,62,63,64,
: skipped

Nive Move Knots (4 centres)

Knot 78: I have found no video yet, maybe you can send me one Knot 78 “Balthus”

The Balthus is the last and broadest of knot classes. It is a direct extension from the Plattsburgh.

Named after the artist Balthus.

Knot 79-85: I have found no video yet, maybe you can send me one Knot 79 to 85: skipped


The bow tie
A cravat


More references / learning resources:

- wikipedia on neckties:
- references to knots on dmoz:

The top 10 handiest Outlook shortcut keys

Here we go:

CTRL-K : complete a recipient name in your email form
CTRL-Q : set as read, handy for selecting “all” in newsletter folders and then set them all as read
CTRL-R : reply, saves time to mouse to the “button”
CTRL-N: to create a new message, saves time to go to the “button”
CTRL-SHIFT-C: create a new contact, handy when on the phone
CTRL-SHIFT-N: create a new note, handy when in a  do-not-want-to-lose-focus state
CTRL-1…N : switch from mail to contacts to notes etc…
F6 and ENTER: use them together to switch between panes and hit enter to open, saves a lot of mouse-ing time
F2: as it works in more apps, it also works here: you can immediately edit the contents of a selected field, handy when renaming folders

and last but not least:

CTRL-SHIFT-P: to create a search folder, if you never hit it you will find some handy predefined searches like “large mail”, handy when cleaning up.

Hoe verkoop ik een NL Domein naam?

Het was weer een tijdje geleden dat ik een NL domeinnaam overgedragen heb. Met .COM of .NET is het piece of cake, je kunt online de gegevens wijzigen en voila de andere partij heeft de domeinnaam. Met NL Domeinnamen moet je helaas met nog steeds met allerlei formulieren gaan stoeien, ondertekenen, faxen enz…

Alle benodigde formulieren zijn hier te vinden:,727,5890,,,,Mutatieformulieren.html

Het is allemaal vrij omslachtig. Omdat je meestal ook verhuist van hosting/registratie bedrijf A naar hosting/registratie bedrijf B moet je EERST verhuizen en kun je DAN pas e.e.a. op naam van iemand anders zetten:


a- het formulier Formulier voor verhuizing .nl-domeinnaam invullen met je oude whois gegevens EN de naam van je huidige register (e.g. hosting company A) en laten tekenen door de  nieuwe register. Hiermee wordt je domein dan ergens anders ondergebracht (dus laten tekenen door bijvoorbeeld hosting company B). Let op: de gegevens op het formulier moeten overeenkomen met je whois gegevens. Ik was inmiddels verhuist dus dan is de optie OF je oude adresgegevens op het formulier invullen of allereerst je whois gegevens laten aanpassen door je register.

b- het formulier Registratiecontract .nl-domeinnaam (.pdf) invullen. De verhuizing wordt namelijk gezien als een nieuwe registratie. En dit indienen bij de nieuwe register.

c- het formulier invullen op de site van bedrijf waar je op dit moment je domeinnaam geregistreerd hebt om hen op de hoogte te stellen van de verhuizing. (dit kan vaak gefaxed worden) (hier is geen standaard formulier voor).


d- het formulier Formulier voor wijziging domeinnaamhouder invullen en laten tekenen door de nieuwe eigenaar. Deze kan  dit dan indienen bij de nieuwe register,

e- het formulier Registratiecontract .nl-domeinnaam (.pdf) in laten vullen door de nieuwe eigenaar en laten indienen bij zijn register / deelnemer. De verhuizing wordt namelijk gezien als een nieuwe registratie. (maar als het goed is heb je hier dus niets meer mee te maken).

Qua workflow ziet het dus als volgt uit:

Formulier a en b verzenden naar de nieuwe register
Formulier c verzenden naar je oude register
Formulier d verzenden naar degene die de domeinnaam gekocht heeft omdat deze het formulier eerst moet ondertekenen.

De nieuwe eigenaar moet dan formulier d en e verzenden naar de nieuwe register maar daar heb jij zelf geen last meer van.