NYSgptData LibraryConnectPricing

Open Payments

Payments from drug and device companies to physicians and hospitals, 2019 to 2025.

95.9MRecords
5Tables
414Fields
CurrentYears

Publisher: Centers for Medicare and Medicaid Services

Try it

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

Tables
Fields in op_general
FieldTypeExample
change_typestringUNCHANGED
covered_recipient_typestringCovered Recipient Physician
teaching_hospital_ccnstring
teaching_hospital_idstring
teaching_hospital_namestring
covered_recipient_profile_idstring54709
covered_recipient_npistring1205831005
covered_recipient_first_namestringDAVID
covered_recipient_middle_namestringG
covered_recipient_last_namestringALTMAN
covered_recipient_name_suffixstringJR.
recipient_primary_business_street_address_line1string11900 E 12 MILE RD
recipient_primary_business_street_address_line2stringSTE 201
recipient_citystringWARREN
recipient_statestringMI
recipient_zip_codestring48093
recipient_countrystringUnited States
recipient_provincestring
recipient_postal_codestring
covered_recipient_primary_type_1stringMedical Doctor
covered_recipient_primary_type_2string
covered_recipient_primary_type_3string
covered_recipient_primary_type_4string
covered_recipient_primary_type_5string
covered_recipient_primary_type_6string
covered_recipient_specialty_1stringAllopathic & Osteopathic Physicians|Dermatology
covered_recipient_specialty_2string
covered_recipient_specialty_3string
covered_recipient_specialty_4string
covered_recipient_specialty_5string
covered_recipient_specialty_6string
covered_recipient_license_state_code1stringMI
covered_recipient_license_state_code2stringFL
covered_recipient_license_state_code3string
covered_recipient_license_state_code4string
covered_recipient_license_state_code5string
submitting_applicable_manufacturer_or_applicable_gpo_namestringCelgene Corporation
applicable_manufacturer_or_applicable_gpo_making_payment_idstring100000000343
applicable_manufacturer_or_applicable_gpo_making_payment_namestringCelgene Corporation
applicable_manufacturer_or_applicable_gpo_making_payment_statestringNJ
applicable_manufacturer_or_applicable_gpo_making_payment_countrystringUnited States
total_amount_of_payment_usdollarsstring3000.00
date_of_paymentstring05/08/2019
number_of_payments_included_in_total_amountstring1
form_of_payment_or_transfer_of_valuestringCash or cash equivalent
nature_of_payment_or_transfer_of_valuestringCompensation for services other than consulting, including s
city_of_travelstringFort Worth
state_of_travelstringTX
country_of_travelstringUnited States
physician_ownership_indicatorstringNo
third_party_payment_recipient_indicatorstringNo Third Party Payment
name_of_third_party_entity_receiving_payment_or_transfer_of_valuestringENLIGHTENMENT BIOCONSULT LLC
charity_indicatorstringNo
third_party_equals_covered_recipient_indicatorstringNo
contextual_informationstringNo payment was made directly to this author. This is a fair
delay_in_publication_indicatorstringNo
record_idstring672907505
dispute_status_for_publicationstringNo
related_product_indicatorstringYes
covered_or_noncovered_indicator_1stringCovered
indicate_drug_or_biological_or_device_or_medical_supply_1stringDrug
product_category_or_therapeutic_area_1stringDermatology
name_of_drug_or_biological_or_device_or_medical_supply_1stringOtezla
associated_drug_or_biological_ndc_1string59572-630-27
associated_device_or_medical_supply_pdi_1stringN/A
covered_or_noncovered_indicator_2stringCovered
indicate_drug_or_biological_or_device_or_medical_supply_2stringDrug
product_category_or_therapeutic_area_2stringNEUROSCIENCE;TOBACCO DEPENDENCE
name_of_drug_or_biological_or_device_or_medical_supply_2stringCHANTIX
associated_drug_or_biological_ndc_2string0069-0471-02
associated_device_or_medical_supply_pdi_2stringN/A
covered_or_noncovered_indicator_3stringCovered
indicate_drug_or_biological_or_device_or_medical_supply_3stringDevice
product_category_or_therapeutic_area_3stringGASTROINTESTINAL
name_of_drug_or_biological_or_device_or_medical_supply_3stringCOLOGUARD
associated_drug_or_biological_ndc_3string0071-1012-68
associated_device_or_medical_supply_pdi_3stringN/A
covered_or_noncovered_indicator_4stringCovered
indicate_drug_or_biological_or_device_or_medical_supply_4stringDrug
product_category_or_therapeutic_area_4stringONCOLOGY

12 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