I would like to easily link a field on the "Unique Device Identifier" database to a field on the "Recalls" database, so I can easily see more information of a device/lead which has a recall. Which field would it be?
Thank you
2
-
Where are these databases? How is this on topic for open data?– James RisnerNov 16, 2022 at 16:45
-
Hi James! I meant this databases: open.fda.gov/apis/device/recall open.fda.gov/apis/device/udi– Filipa PereiraNov 17, 2022 at 16:45
Add a comment
|
1 Answer
You can link based on the field, openfda.device_name, which is common between the "Recalls" and the "Unique Device Identifier" APIs
-
Indeed that is a common field. However, it is not a unique identifier, since there are multiple devices with the same openfda.device_name. Do you know about any other field which can be used? Nov 24, 2022 at 11:48
-