You are here :
-
Public Consultations
-
Reference
-
Statistics
-
Publications
-
Blog
- Brands answer the call to the 2nd ‘Cercle des .marque’ event
- Analysis of the .RE
- About the attack on French ISPs’ DNS resolvers
- Using Afnic open data : example with the term COVID
- Hosting a domain name with compound characters
- Eligibility of a holder located in the United Kingdom post Brexit
- Can compound characters be used in a domain name?
- Functioning of Afnic during lockdown
- Which Top Level Domains have an IP address?
- Lala Andriamampianina, may you rest in peace
- Resolutions for 2020: Afnic goes elliptic
- 6 tips to prevent your website from being hacked
- In search of low-cost nTLDs
- Exploring the city through the .paris community
- .org - an alternative perspective
- Looking back on the success of the first meeting of the Cercle des .marque
- Key success factors for Internet extensions: an evaluation grid
- [Video] Conclusions on the Internet Governance Forum (IGF) France 2019
- A brief example of using Afnic Open Data
- Food for thought on the "new TLD" business models
- 30 years of success and danger: the Web, URLs and the future
- [Success stories] Strengthen your infrastructure to suit your ambitions
- February 1, 2019: is the DNS going to shake?
- [Success stories] They chose to have their own TLD
- [Success stories] .museum, how a historic Internet suffix was revived
- The main steps in effectively launching your .brand
- 6 secrets on how to improve the renewal of domain names
- [Video] Back to IGF 2018 in Paris
- A .BRAND to enhance customer experience
- Afnic commits to DNS security at the international level
- Replacement of the KSK of the root zone: Are you ready?
- How the SNCF implemented its new digital strategy with oui.sncf
- Franco-Dutch research project on automatic classification of domain name abuse
- The auditive memorization of domain names
- What are the possible actions against domain name abuses?
- Identity theft by domain name: what Afnic does
- Cybersquatting, Spam, Phishing… the different types of domain name abuses
- [Video] Review of the French Internet Governance Forum 2018
- Custom Internet extensions: the opportunities for brands
- How to avoid inadmissibility in the SYRELI procedure
- Which English terms are most used in .FR domain names?
- Domain name security, the example of cryptocurrencies
- What are the terms most used in .fr domain names?
- Personality test: Are you ready for GDPR?
- Do GeoTLDs like .alsace have an effect on local SEO?
- The 11 vital locations to display your domain name!
- What means of action for a Right-holder ineligible under the Naming Policy?
- Domain name litigation: the recognition of an AOC rights in the SYRELI procedure
- Why choose a domain name under a geoTLD?
- Afnic, a community first and foremost!
- The defense of personality rights in the SYRELI procedure
- When will the next round of the new gTLDs take place?
- A million good reasons for coming to the Afnic Forum...
- Yeti DNS-over-TLS public resolver
- 2016, the beginning of a new cycle for Afnic
- .fr has just passed the 3 million domain names milestone
- My experience inside the Afnic Legal Department
- Future of ICANN Privatization? Internationalization? Supervision?
- Excellence at Afnic - Our coming-out
- Speech at the transmittal of the IANA Stewardship Transition Plan
- Exclusive offer: 100% money back on your domain name*!
- 8 tips for choosing the right domain name
- IPv6 and DNSSEC are respectively 20 and 19 years old. Same fight and challenges?
- L.45-2 paragraph 1 of the CPCE: When a domain name disrupts the French law
- How to avoid getting your domain name stolen by email?
- Accountability and IANA transition: behind the scenes
- Stop selling domain names!
- abc.xyz : erratum.xyz
- A comprehensive approach to French regional branding
- abc.xyz : Meanwhile, back in France…
- abc.xyz: Why not alphabet.com? (The conspiracy theory version)
- abc.xyz : The controversial success of .xyz
- Corporate Communications, Constant Crisis
- abc.xyz : Why not alphabet.com ?
- alphabet.xyz : How Alphabet got its domain name
- abc.xyz : Don't worry, we're still getting used to the name too!
- IANA transition crosses a major milestone in Buenos Aires
- A day in the life of the Icann empowered community
- IANA transition : the machine is moving, but the deadline is approaching
- Corporate Social Responsibility and the DNA of ccTLDs
- China Changing in Leaps and Bounds
- Towards a less intrusive DNS
- ICANN: what does accountability stand for?
- ICANN Singapore. A debate at the other end of the world
- ICANN Reform, or opening Pandora's box
- Internet Governance Forum: What is to be done?
- Slam spam!
- Icann : freeze !
- Scams and identity theft, the experience of a SYRELI reporter
- French Regional Reform Does Not Mean the End of GeoTLDs
- Lessons Learnt from NETmundial
- Suggestions for a successful IANA transition
- Wind of change at Afnic!
- Back to the future of the Afnic Legal Service
- The US Backs ICANN for Internet Governance
- Should the registrars streamline their gTLD strategy?
- The IANA elephant in the room
- 2014 : change of course for the naming system
- Why do regions want a place online?
- What can Afnic do?
- Internet governance: let’s get to work!
-
FAQ
-
Glossary
-
Certificates
Using Afnic open data : example with the term COVID
09 June 2020 - By Pierre-Aymeric Masse
Every month, Afnic makes a set of data available to the public.
This data include:
- .fr domain names
- .fr indicators by owner country
- .fr indicators by month, quarter and year
- number of .fr domain names by zipcode
- .fr indicators by type of owner
- .fr indicators by owner zipcode
- .fr indicators by type of domain
- .fr indicators by registrar
So, for example, you can study the geographical distribution of domain name owners, the proportion of businesses that have a domain name, etc.
This data is available at http://opendata.afnic.fr
Today, we’re going to look at how to study the creation of domain names associated with the term ‘COVID’ in .fr.
There are many different ways of doing this. We’re going to use Python processing with a new library called Vaex.
Python is a programming language widely used for data processing and very often used in conjunction with Pandas.
When decompressed, the ‘noms de domaine en point fr’ (.fr domain names) file is 0.45 GB! With files of this size, it is possible to use Pandas, but processing would take rather a long time.
Vaex is in fact a development of the Pandas API with technical choices allowing these kinds of volumes to be processed almost instantaneously.
The first step is to download the file. Nothing difficult about this since the data are in a .csv zipped file. Classic!
We import the libraries and the file:
We notice that the file name includes the month and year. If you wish to automate the import and processing, all you need to do is generate the url. The file is in Latin-1, since the French requires accents.
Next, it is necessary to perform a small processing operation to get rid of the spaces and accents in the column headings. We’re going to take this opportunity to also change the date format, which is French.
Now that we have the imported file in the Dataframe “df”, let’s see what we have. we see that we have more than 6M domains, some of them with “date deleted from Whois”. So we find ourselves with a file with the whole zone since its creation, or at least since the open data was made available, with the domains that are still active, those with no deletion date, and the rest, inactive.
We’re going to keep only those domains created since January 2020.
This greatly reduces the number, to just 208,732 domains. So now we prepare our analyses by filtering our data. Vaex is very useful in this case since it offers us a lazy computation system allowing us to very quickly tag a set of data and process them only when we need them.
Now let’s look only at the domain names of interest to us.
Around 1,200 domains - so not that many compared with the total number created.
Let’s take a quick look at the number of domains created during this period
The top five are revealing; we see that April was the strongest month in terms of domain creation.
Finally, let’s take a look at the domains
With this short demonstration, we’ve seen how simple it is to use Afnic open data. You can carry out different analyses such as trends in domain creation, how long they stay registered for on average, etc.
The entire code is available from Afnic’s GitHub.
Pierre-Aymeric Masse
![]() | Data scientist |
Is this domain
available ?
News
- December 10, 2020 Three major projects on the roadmap of the Afnic International College
- November 23, 2020 Lucien Castex has been reappointed as a member of the Multistakeholder Advisory ...
- November 17, 2020 Marianne Georgelin joins Afnic's Executive Committee as Legal Director
- November 16, 2020 ‘Je passe au numérique’: the Afnic initiative for VSEs/SMEs
- November 12, 2020 The Afnic Foundation announces its 2020 winners promoting an inclusive Internet ...