FDA.reportPublic FDA data

← Orange Book source history

Orange Book snapshot 9

Run ID
h-20230715152700-a67488948f0b
Edition
2023-07
Source filename
EOBZIP_2023_07_20230715152700.zip
Source SHA-256
a67488948f0bb92f9c92ee2936d421c13d50a63a3ef504efe70403a9f20a39a3
Source bytes
944,010
Status
historical
Discovered
2026-08-03 19:56:16
Validated
2026-08-03 19:56:28
Created
2026-08-03 19:56:16
Updated
2026-08-03 19:56:29

Exact structured row counts#

Dataset browser, Database rows, Snapshot-declared rows table
Dataset browserDatabase rowsSnapshot-declared rows
Products43,51643,516
Te Codes20,11220,112
Patents18,48818,488
Exclusivities1,9671,967

Captures resolving to this snapshot#

Capture, CDX status, Replay status table
CaptureCDX statusReplay statusResultArchive
2023-07-15 15:27 UTC301200completeVerified
2023-07-23 20:44 UTC200200duplicateVerified

Validation evidence#

{
    "approved_prior_to_1982_rows": 5871,
    "compound_te_rows": 107,
    "database_stage": {
        "duplicate_product_keys": 0,
        "exclusivity_orphans": 0,
        "expected_counts": {
            "exclusivities": 1967,
            "patents": 18488,
            "products": 43516,
            "te_codes": 20112
        },
        "patent_orphans": 0,
        "stage_counts": {
            "exclusivities": 1967,
            "patents": 18488,
            "products": 43516,
            "te_codes": 20112
        },
        "te_orphans": 0
    },
    "duplicate_exclusivity_rows_preserved": 10,
    "exclusivity_orphans": 0,
    "exclusivity_rows": 1967,
    "historical_capture": {
        "original_url": "http://www.fda.gov/media/76860/download",
        "replay_url": "https://web.archive.org/web/20230715152700id_/http://www.fda.gov/media/76860/download",
        "timestamp": "20230715152700"
    },
    "patent_orphans": 0,
    "patent_rows": 18488,
    "pediatric_patent_rows": 2165,
    "product_keys": 43516,
    "product_rows": 43516,
    "te_code_rows": 20112,
    "te_orphans": 0
}