← Orange Book source history

Orange Book snapshot 38

Run ID
h-20250322031329-fd3edfee7708
Edition
2025-03
Source filename
EOBZIP_2025_03_20250322031329.zip
Source SHA-256
fd3edfee7708f7324cbce64ef0b0ad5718d3ff59b64d8531bb72e3c558fe718b
Source bytes
1,024,937
Status
historical
Discovered
2026-08-03 20:16:18
Validated
2026-08-03 20:16:32
Created
2026-08-03 20:16:18
Updated
2026-08-03 20:16:32

Exact structured row counts#

Dataset browser, Database rows, Snapshot-declared rows table
Dataset browserDatabase rowsSnapshot-declared rows
Products46,35746,357
Te Codes21,30121,301
Patents19,69319,693
Exclusivities2,0622,062

Captures resolving to this snapshot#

Capture, CDX status, Replay status table
CaptureCDX statusReplay statusResultArchive
2025-03-22 03:13 UTC200200completeVerified
2025-03-28 20:22 UTC200200duplicateVerified
2025-03-30 15:53 UTC-200duplicateVerified

Validation evidence#

{
    "approved_prior_to_1982_rows": 5870,
    "compound_te_rows": 131,
    "database_stage": {
        "duplicate_product_key_rows": 0,
        "duplicate_product_keys": 0,
        "exclusivity_orphans": 0,
        "expected_counts": {
            "exclusivities": 2062,
            "patents": 19693,
            "products": 46357,
            "te_codes": 21301
        },
        "patent_orphans": 1,
        "stage_counts": {
            "exclusivities": 2062,
            "patents": 19693,
            "products": 46357,
            "te_codes": 21301
        },
        "te_orphans": 0
    },
    "duplicate_exclusivity_rows_preserved": 16,
    "duplicate_product_key_count": 0,
    "duplicate_product_key_examples": [],
    "duplicate_product_key_rows": 0,
    "exclusivity_orphan_key_examples": [],
    "exclusivity_orphan_keys": [],
    "exclusivity_orphans": 0,
    "exclusivity_rows": 2062,
    "historical_capture": {
        "original_url": "https://www.fda.gov/media/76860/download?attachment",
        "replay_url": "https://web.archive.org/web/20250322031329id_/https://www.fda.gov/media/76860/download?attachment",
        "timestamp": "20250322031329"
    },
    "member_name_aliases": [],
    "patent_orphan_key_examples": [
        [
            "N",
            "216984",
            "002"
        ]
    ],
    "patent_orphan_keys": [
        [
            "N",
            "216984",
            "002"
        ]
    ],
    "patent_orphans": 1,
    "patent_rows": 19693,
    "pediatric_patent_rows": 2239,
    "product_keys": 46357,
    "product_rows": 46357,
    "te_code_rows": 21301,
    "te_orphan_key_examples": [],
    "te_orphan_keys": [],
    "te_orphans": 0
}