NYSgptData LibraryConnectPricing

Drug and device safety

Adverse events, recalls, labels, approvals and the drug code directory.

57MRecords
31Tables
759Fields
CurrentYears

Publisher: Food and Drug Administration

Try it

This runs against the full table, free, with no key.

Tables
Fields in fda_device_event
FieldTypeExample
manufacturer_contact_zip_extstring
manufacturer_g1_address_2stringNA
event_locationstringHOSPITAL
report_to_fdastringN
manufacturer_contact_t_namestringNA
manufacturer_contact_statestringIN
manufacturer_link_flagstringY
manufacturer_contact_address_2stringNA
manufacturer_g1_citystringBLONIE / MIEKINIA
manufacturer_contact_address_1string11800 EXIT 5 PARKWAY # 120
manufacturer_contact_pcitystring31752102
event_typestringMalfunction
report_numberstring2517506-2013-00293
type_of_reportstring["Initial submission"]
product_problem_flagstringY
date_receivedstring20130618
manufacturer_address_2string
pma_pmn_numberstringK970336
date_of_eventstring20130424
reprocessed_and_reused_flagstringN
manufacturer_address_1string
report_datestring20130510
exemption_numberstring
manufacturer_contact_zip_codestring46037
reporter_occupation_codestringMEDICAL TECHNOLOGIST
manufacturer_contact_plocalstring3175210259
noe_summarizedstring1
manufacturer_contact_l_namestringTAYLOR
source_typestring["Health Professional", "User facility"]
distributor_zip_code_extstring
manufacturer_g1_postal_codestring55-330
date_facility_awarestring20130225
manufacturer_g1_statestring
reporter_country_codestringUS
manufacturer_contact_area_codestring317
date_addedstring20130912
manufacturer_contact_f_namestringTERRY
previous_use_codestring*
devicestring[{"device_event_key": "", "implant_flag": "", "date_removed_
reporter_state_codestringNY
manufacturer_zip_codestring
suppl_dates_mfr_receivedstring*
mfr_report_typestringThirty-Day
manufacturer_contact_countrystringUS
date_changedstring20250812
health_professionalstringN
summary_report_flagstringN
manufacturer_g1_zip_code_extstring0
manufacturer_contact_extensionstring
manufacturer_citystring
manufacturer_contact_phone_numberstring3175
patientstring[{"patient_sequence_number": "1", "date_received": "20130618
distributor_citystring
date_reportstring20130524
initial_report_to_fdastringUnknown
distributor_statestring
event_keystring
manufacturer_g1_countrystringPL
date_report_to_manufacturerstring20130510
manufacturer_contact_citystringFISHERS
mdr_report_keystring3176022
removal_correction_numberstring2517506-6-5-2013-007C
number_devices_in_eventstring
date_report_to_fdastring20130510
manufacturer_namestring
report_source_codestringManufacturer report
remedial_actionstring["Notification", "Other"]
manufacturer_g1_zip_codestring55-33
report_to_manufacturerstring
manufacturer_zip_code_extstring
manufacturer_g1_namestringCLINICO MEDICAL SP. Z O.O.
adverse_event_flagstringN
distributor_address_1string
manufacturer_statestring
distributor_address_2string
manufacturer_postal_codestring
single_use_flagstringY
manufacturer_countrystring
mdr_textstring[{"mdr_text_key": "10850386", "text_type_code": "Additional
number_patients_in_eventstring

11 more fields; select the table above to list them all.

Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Health