# Data Dictionary - US Product & Food/Drug/Device Recalls (CPSC + FDA) - unified, normalised feed

**Units:** stated per column in the descriptions below (this is a relational table; columns mix units).

| column | type | description |
|---|---|---|
| `source` | str | CPSC / FDA-food / FDA-drug / FDA-device (part of primary key) |
| `recall_id` | str | Recall number/id within the source (part of primary key) |
| `recall_date` | str | Recall date (YYYY-MM-DD) |
| `product` | str | Recalled product description |
| `product_type` | str | Product type / category |
| `recalling_firm` | str | Recalling firm / manufacturer |
| `reason` | str | Reason for recall / hazard description |
| `classification` | str | FDA severity classification (Class I/II/III; null for CPSC) |
| `status` | str | Recall status (Ongoing/Completed/Terminated; null for CPSC) |
| `country` | str | Country of the recalling firm / manufacture |
| `state` | str | US state (FDA rows) |
| `url` | str | Link to the recall notice (CPSC) |

*Source: U.S. Consumer Product Safety Commission (CPSC) & U.S. Food and Drug Administration (openFDA).*