FDA Medical Device Raw Data – UDI

Access the entire history of FDA's Medical Device for UDI information as of April 1, 2024, provided by the FDA's [openFDA site](https://open.fda.gov/apis/device/udi/). Data has been aggregated into a complete dataset and is provided in the RAW JSON format as provided by the FDA in a single VARIANT column as well as flattened Dynamic Tables. You can parse and query the RAW JSON directly, or for simpler queries and no parsing you can leverage the Dynamic Tables.

<p><br/></p>

The automated schema discovery and analysis of the RAW JSON and the generation of the Dynamic Tables was done using our Snowflake Native App, Pancake. Included in this dataset readme are instructions for setting up and configuring Pancake to scan the RAW JSON for yourself.

<p><br/></p>

This data is free to use, either in the RAW JSON format or the Dynamic Tables.

<p><br/></p>

If you’re interested in performing this same level of schema discovery, analysis, and dynamic table generation on your own data, you can find Pancake in the Snowflake Marketplace [here](https://app.snowflake.com/marketplace/listing/GZT1Z1RGR5G/tdaa!-pancake).

<p><br/></p>

UDIs are unique numeric or alphanumeric codes that consist of two parts—a device identifier (DI) and a production identifier (PI). UDIs are intended to increase electronic tracking abilities for devices involved in adverse events. Submission to the GUDID database is required for manufacturers of medical devices. The FDA is establishing the unique device identification system to adequately identify devices sold in the U.S.- from manufacturing through distribution to patient use.