Adverse events, recalls, labels, approvals and the drug code directory.
Publisher: Food and Drug Administration
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| manufacturer_contact_zip_ext | string | |
| manufacturer_g1_address_2 | string | NA |
| event_location | string | HOSPITAL |
| report_to_fda | string | N |
| manufacturer_contact_t_name | string | NA |
| manufacturer_contact_state | string | IN |
| manufacturer_link_flag | string | Y |
| manufacturer_contact_address_2 | string | NA |
| manufacturer_g1_city | string | BLONIE / MIEKINIA |
| manufacturer_contact_address_1 | string | 11800 EXIT 5 PARKWAY # 120 |
| manufacturer_contact_pcity | string | 31752102 |
| event_type | string | Malfunction |
| report_number | string | 2517506-2013-00293 |
| type_of_report | string | ["Initial submission"] |
| product_problem_flag | string | Y |
| date_received | string | 20130618 |
| manufacturer_address_2 | string | |
| pma_pmn_number | string | K970336 |
| date_of_event | string | 20130424 |
| reprocessed_and_reused_flag | string | N |
| manufacturer_address_1 | string | |
| report_date | string | 20130510 |
| exemption_number | string | |
| manufacturer_contact_zip_code | string | 46037 |
| reporter_occupation_code | string | MEDICAL TECHNOLOGIST |
| manufacturer_contact_plocal | string | 3175210259 |
| noe_summarized | string | 1 |
| manufacturer_contact_l_name | string | TAYLOR |
| source_type | string | ["Health Professional", "User facility"] |
| distributor_zip_code_ext | string | |
| manufacturer_g1_postal_code | string | 55-330 |
| date_facility_aware | string | 20130225 |
| manufacturer_g1_state | string | |
| reporter_country_code | string | US |
| manufacturer_contact_area_code | string | 317 |
| date_added | string | 20130912 |
| manufacturer_contact_f_name | string | TERRY |
| previous_use_code | string | * |
| device | string | [{"device_event_key": "", "implant_flag": "", "date_removed_ |
| reporter_state_code | string | NY |
| manufacturer_zip_code | string | |
| suppl_dates_mfr_received | string | * |
| mfr_report_type | string | Thirty-Day |
| manufacturer_contact_country | string | US |
| date_changed | string | 20250812 |
| health_professional | string | N |
| summary_report_flag | string | N |
| manufacturer_g1_zip_code_ext | string | 0 |
| manufacturer_contact_extension | string | |
| manufacturer_city | string | |
| manufacturer_contact_phone_number | string | 3175 |
| patient | string | [{"patient_sequence_number": "1", "date_received": "20130618 |
| distributor_city | string | |
| date_report | string | 20130524 |
| initial_report_to_fda | string | Unknown |
| distributor_state | string | |
| event_key | string | |
| manufacturer_g1_country | string | PL |
| date_report_to_manufacturer | string | 20130510 |
| manufacturer_contact_city | string | FISHERS |
| mdr_report_key | string | 3176022 |
| removal_correction_number | string | 2517506-6-5-2013-007C |
| number_devices_in_event | string | |
| date_report_to_fda | string | 20130510 |
| manufacturer_name | string | |
| report_source_code | string | Manufacturer report |
| remedial_action | string | ["Notification", "Other"] |
| manufacturer_g1_zip_code | string | 55-33 |
| report_to_manufacturer | string | |
| manufacturer_zip_code_ext | string | |
| manufacturer_g1_name | string | CLINICO MEDICAL SP. Z O.O. |
| adverse_event_flag | string | N |
| distributor_address_1 | string | |
| manufacturer_state | string | |
| distributor_address_2 | string | |
| manufacturer_postal_code | string | |
| single_use_flag | string | Y |
| manufacturer_country | string | |
| mdr_text | string | [{"mdr_text_key": "10850386", "text_type_code": "Additional |
| number_patients_in_event | string |
11 more fields; select the table above to list them all.
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.