FDA.reportPublic FDA data

← Orange Book source history

Orange Book snapshot 27

Run ID
h-20220629024740-5c6f7cd8ea54
Edition
2022-06
Source filename
EOBZIP_2022_06_20220629024740.zip
Source SHA-256
5c6f7cd8ea54e291ee151de9f5029cb259f8dd89dcbe6dacbe78c05bb89ab752
Source bytes
959,802
Status
historical
Discovered
2026-08-03 20:02:51
Validated
2026-08-03 20:03:05
Created
2026-08-03 20:02:51
Updated
2026-08-03 20:03:05

Exact structured row counts#

Dataset browser, Database rows, Snapshot-declared rows table
Dataset browserDatabase rowsSnapshot-declared rows
Products41,61641,616
Te Codes19,04319,043
Patents16,75016,750
Exclusivities1,9751,975

Captures resolving to this snapshot#

Capture, CDX status, Replay status table
CaptureCDX statusReplay statusResultArchive
2022-06-29 02:47 UTC200200completeVerified
2022-06-30 22:37 UTC-200duplicateVerified

Validation evidence#

{
    "approved_prior_to_1982_rows": 5872,
    "compound_te_rows": 107,
    "database_stage": {
        "duplicate_product_key_rows": 0,
        "duplicate_product_keys": 0,
        "exclusivity_orphans": 0,
        "expected_counts": {
            "exclusivities": 1975,
            "patents": 16750,
            "products": 41616,
            "te_codes": 19043
        },
        "patent_orphans": 9,
        "stage_counts": {
            "exclusivities": 1975,
            "patents": 16750,
            "products": 41616,
            "te_codes": 19043
        },
        "te_orphans": 0
    },
    "duplicate_exclusivity_rows_preserved": 14,
    "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": 1975,
    "historical_capture": {
        "original_url": "https://www.fda.gov/media/76860/download",
        "replay_url": "https://web.archive.org/web/20220629024740id_/https://www.fda.gov/media/76860/download",
        "timestamp": "20220629024740"
    },
    "patent_orphan_key_examples": [
        [
            "N",
            "215904",
            "001"
        ],
        [
            "N",
            "216318",
            "001"
        ]
    ],
    "patent_orphan_keys": [
        [
            "N",
            "215904",
            "001"
        ],
        [
            "N",
            "216318",
            "001"
        ]
    ],
    "patent_orphans": 9,
    "patent_rows": 16750,
    "pediatric_patent_rows": 1684,
    "product_keys": 41616,
    "product_rows": 41616,
    "te_code_rows": 19043,
    "te_orphan_key_examples": [],
    "te_orphan_keys": [],
    "te_orphans": 0
}