---
title: "Database File Status - WhoisFreaks"
slug: "/documentation/database-file-status"
description: "Check the freshness and availability window of every WhoisFreaks database file from a single endpoint."
---

# Database Files Status

Check the freshness and availability window of every WhoisFreaks database file from a single endpoint.

## Overview

The **Database Files Status** endpoint returns a single JSON document describing the current state of every downloadable WhoisFreaks database file. For each file group, you get the **last update** date (when the most recent snapshot was generated) and the **available from** date (the earliest snapshot still hosted on our servers).

Use this endpoint to:

*   Monitor freshness before triggering a download in your pipeline.
*   Determine the date range you can safely back-fill against.
*   Build dashboards or alerts that flag stale or missing snapshots.

**Note:** This endpoint is public and does not require an API key. Dates are returned in `YYYY-MM-DD` format. When a particular cadence is not produced for a given dataset, the value is the literal string `"Not Available"`.

A successful request returns `200 OK` with a JSON object. The top-level keys correspond to product groups; nested objects describe individual file types and (where applicable) their daily, weekly, and monthly variants.

## Response Fields

Every leaf object in the response shares the same shape, alast_updateand anavailable_fromdate. The table below describes the top-level groups.

| Field | Type | Description |
| --- | --- | --- |
| newly | object | Newly registered domain feeds, segmented by TLD type and cleanup state. * `gtld` — Newly registered gTLD domains with WHOIS. * `cctld` — Newly registered ccTLD domains with WHOIS. * `cleaned_gtld` — Cleaned, deduplicated gTLD set. * `cleaned_cctld` — Cleaned ccTLD set. * `dns` — Newly registered domains with DNS records. |
| expired | object | Expired domains feed (with WHOIS). |
| cleaned_expired | object | Cleaned expired domains feed, with duplicates and parking artefacts removed. |
| dropped | object | Dropped (deleted, available for registration) domains feed. |
| dropped_with_backlinks | object | Dropped domains enriched with backlink and authority signals. |
| database_updates | object | Full-database snapshots offered in three cadences. Each child has`daily`,`weekly`, and`monthly` sub-keys. * `domain_whois` — Domain WHOIS snapshots. * `dns` — DNS records snapshots. * `subdomains` — Subdomains database snapshots. * `ip_whois` — IP WHOIS snapshots. |

### Leaf Object Schema

| Field | Type | Description |
| --- | --- | --- |
| last_update | string | ISO date (`YYYY-MM-DD`) of the most recent snapshot. Returns`"Not Available"`if no snapshot has ever been produced. |
| available_from | string | ISO date (`YYYY-MM-DD`) of the earliest snapshot still hosted. Use this as the lower bound of your back-fill range. |

### Status Codes

##### Success Codes

*   200  Status payload returned successfully.

##### Failure Codes

*   429  Too many requests, IP rate limit exceeded. Retry after a short backoff.
*   500  Internal server error while gathering file metadata. Safe to retry.
*   503  Service temporarily unavailable. Retry with exponential backoff.