FDA.reportPublic FDA data

← Orange Book source history

Orange Book snapshot 25

Run ID
h-20191213002049-74a2ff9319b5
Edition
2019-12
Source filename
EOBZIP_2019_12_20191213002049.zip
Source SHA-256
74a2ff9319b58ac3c9bce48831b042183645478fab1a664fa6464f39eace8726
Source bytes
870,222
Status
historical
Discovered
2026-08-03 20:01:53
Validated
2026-08-03 20:02:06
Created
2026-08-03 20:01:53
Updated
2026-08-03 20:02:06

Exact structured row counts#

Dataset browser, Database rows, Snapshot-declared rows table
Dataset browserDatabase rowsSnapshot-declared rows
Products37,93837,938
Te Codes17,95817,958
Patents15,08815,088
Exclusivities1,9621,962

Captures resolving to this snapshot#

Capture, CDX status, Replay status table
CaptureCDX statusReplay statusResultArchive
2019-12-13 00:20 UTC200200completeVerified

Validation evidence#

{
    "approved_prior_to_1982_rows": 5981,
    "compound_te_rows": 83,
    "database_stage": {
        "duplicate_product_key_rows": 3,
        "duplicate_product_keys": 3,
        "exclusivity_orphans": 3,
        "expected_counts": {
            "exclusivities": 1962,
            "patents": 15088,
            "products": 37938,
            "te_codes": 17958
        },
        "patent_orphans": 0,
        "stage_counts": {
            "exclusivities": 1962,
            "patents": 15088,
            "products": 37938,
            "te_codes": 17958
        },
        "te_orphans": 0
    },
    "duplicate_exclusivity_rows_preserved": 15,
    "duplicate_product_key_count": 3,
    "duplicate_product_key_examples": [
        {
            "application_number": "090740",
            "application_type": "A",
            "product_number": "001",
            "row_count": 2
        },
        {
            "application_number": "202684",
            "application_type": "A",
            "product_number": "001",
            "row_count": 2
        },
        {
            "application_number": "202740",
            "application_type": "A",
            "product_number": "001",
            "row_count": 2
        }
    ],
    "duplicate_product_key_rows": 3,
    "exclusivity_orphan_key_examples": [
        [
            "N",
            "212436",
            "001"
        ],
        [
            "N",
            "212436",
            "002"
        ],
        [
            "N",
            "212436",
            "003"
        ]
    ],
    "exclusivity_orphan_keys": [
        [
            "N",
            "212436",
            "001"
        ],
        [
            "N",
            "212436",
            "002"
        ],
        [
            "N",
            "212436",
            "003"
        ]
    ],
    "exclusivity_orphans": 3,
    "exclusivity_rows": 1962,
    "historical_capture": {
        "original_url": "https://www.fda.gov/media/76860/download",
        "replay_url": "https://web.archive.org/web/20191213002049id_/https://www.fda.gov/media/76860/download",
        "timestamp": "20191213002049"
    },
    "patent_orphan_key_examples": [],
    "patent_orphan_keys": [],
    "patent_orphans": 0,
    "patent_rows": 15088,
    "pediatric_patent_rows": 1497,
    "product_keys": 37935,
    "product_rows": 37938,
    "te_code_rows": 17958,
    "te_orphan_key_examples": [],
    "te_orphan_keys": [],
    "te_orphans": 0
}