Data & Formats

Domains Database CSV Format Reference

A complete column-by-column reference for the Domains Database CSV file - what each field contains, data types, and how to use them for filtering and segmentation.

Domains Database CSV Format Reference
April 15, 2026 Data & Formats WhoisExtractor Team

Overview

The Domains Database delivers a CSV file containing newly registered domain names collected from registries worldwide. This article describes every column in the CSV so you can confidently import, filter, and process the data.

The daily feed (pid=10) covers 240,000+ new registrations per day across 1,570+ TLDs. Each row represents one unique domain name observed on that date.

For access and pricing, see the Domains Database page.

CSV Column Reference

domain

The full registered domain name including its TLD extension.

  • Type: String
  • Example: examplestartup.io
  • Always present: Yes
  • Notes: Lowercase. Does not include a trailing dot. Does not include www..

tld

The top-level domain extension, without the leading dot.

  • Type: String
  • Example: io, com, co.uk, in
  • Always present: Yes
  • Notes: For multi-part ccTLDs like .co.uk or .com.au, the full second-level TLD is included (e.g. co.uk, not just uk).

registered_at

The date the domain was registered, as reported by the registry.

  • Type: Date string YYYY-MM-DD
  • Example: 2026-04-14
  • Always present: Yes for daily feed records
  • Notes: Reflects the date of first registration. Matches the date of the file in normal circumstances.

registrar

The name of the registrar through which the domain was registered.

  • Type: String
  • Example: GoDaddy.com, LLC
  • Always present: Usually. May be empty for some ccTLD registries that do not publish registrar information.

registrar_iana_id

The ICANN/IANA assigned numeric ID for the registrar.

  • Type: Integer (stored as string)
  • Example: 146
  • Always present: No. Empty for ccTLDs not under ICANN registrar accreditation.

nameservers

A pipe-delimited (|) list of nameserver hostnames for the domain.

  • Type: String (pipe-separated)
  • Example: ns1.cloudflare.com|ns2.cloudflare.com
  • Always present: No. Empty if the registry does not publish nameserver data, or if the domain has no nameservers assigned yet.
  • Notes: Split on | to get an array of individual nameserver hostnames.

status

A pipe-delimited (|) list of EPP status codes for the domain.

  • Type: String (pipe-separated)
  • Example: clientTransferProhibited|clientDeleteProhibited
  • Always present: No. Empty for registries that do not publish EPP status.
  • Notes: Common values include clientTransferProhibited, clientDeleteProhibited, clientUpdateProhibited. See Understanding WHOIS Data Fields for the full status code reference.

Filtering the Data

Filter by TLD

To extract only .io domains using standard tools:

Excel - Text Filter: Select the tld column, use Data > Filter, then filter where tld equals io.

Python:

import pandas as pd

df = pd.read_csv("domains-2026-04-15.csv")
io_domains = df[df["tld"] == "io"]
print(io_domains.shape[0], "new .io domains today")

Command line (grep):

grep ',io,' domains-2026-04-15.csv > io-domains.csv

Filter by Keyword in Domain Name

# Get all domains containing "shop" or "store"
ecommerce = df[df["domain"].str.contains("shop|store", case=False)]

Filter by Registrar

# Get all GoDaddy registrations
godaddy = df[df["registrar"].str.contains("GoDaddy", case=False, na=False)]

Filter by Nameserver Provider

This is useful for identifying domains using specific hosting infrastructure:

# Get all domains using Cloudflare nameservers
cloudflare = df[df["nameservers"].str.contains("cloudflare", case=False, na=False)]

Combining Domain Data With Contact Information

The Domains Database contains domain names and registration metadata only - it does not include registrant contact information. To get contact details:

  • WHOIS Contact Data: The WHOIS Database adds registrant name, email, phone, and address for domains where this is publicly available. Cross-reference by domain name.
  • Website Contact Data: The Website Database adds emails and phone numbers extracted from the domain's live website.
domains database csv data format reference tld domain data

Was this article helpful?

Thanks for the feedback! Glad this helped. Thanks for letting us know. Open a support ticket if you need more help.