Payments from drug and device companies to physicians and hospitals, 2019 to 2025.
Publisher: Centers for Medicare and Medicaid Services
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| change_type | string | UNCHANGED |
| covered_recipient_type | string | Covered Recipient Physician |
| teaching_hospital_ccn | string | |
| teaching_hospital_id | string | |
| teaching_hospital_name | string | |
| covered_recipient_profile_id | string | 54709 |
| covered_recipient_npi | string | 1205831005 |
| covered_recipient_first_name | string | DAVID |
| covered_recipient_middle_name | string | G |
| covered_recipient_last_name | string | ALTMAN |
| covered_recipient_name_suffix | string | JR. |
| recipient_primary_business_street_address_line1 | string | 11900 E 12 MILE RD |
| recipient_primary_business_street_address_line2 | string | STE 201 |
| recipient_city | string | WARREN |
| recipient_state | string | MI |
| recipient_zip_code | string | 48093 |
| recipient_country | string | United States |
| recipient_province | string | |
| recipient_postal_code | string | |
| covered_recipient_primary_type_1 | string | Medical Doctor |
| covered_recipient_primary_type_2 | string | |
| covered_recipient_primary_type_3 | string | |
| covered_recipient_primary_type_4 | string | |
| covered_recipient_primary_type_5 | string | |
| covered_recipient_primary_type_6 | string | |
| covered_recipient_specialty_1 | string | Allopathic & Osteopathic Physicians|Dermatology |
| covered_recipient_specialty_2 | string | |
| covered_recipient_specialty_3 | string | |
| covered_recipient_specialty_4 | string | |
| covered_recipient_specialty_5 | string | |
| covered_recipient_specialty_6 | string | |
| covered_recipient_license_state_code1 | string | MI |
| covered_recipient_license_state_code2 | string | FL |
| covered_recipient_license_state_code3 | string | |
| covered_recipient_license_state_code4 | string | |
| covered_recipient_license_state_code5 | string | |
| submitting_applicable_manufacturer_or_applicable_gpo_name | string | Celgene Corporation |
| applicable_manufacturer_or_applicable_gpo_making_payment_id | string | 100000000343 |
| applicable_manufacturer_or_applicable_gpo_making_payment_name | string | Celgene Corporation |
| applicable_manufacturer_or_applicable_gpo_making_payment_state | string | NJ |
| applicable_manufacturer_or_applicable_gpo_making_payment_country | string | United States |
| total_amount_of_payment_usdollars | string | 3000.00 |
| date_of_payment | string | 05/08/2019 |
| number_of_payments_included_in_total_amount | string | 1 |
| form_of_payment_or_transfer_of_value | string | Cash or cash equivalent |
| nature_of_payment_or_transfer_of_value | string | Compensation for services other than consulting, including s |
| city_of_travel | string | Fort Worth |
| state_of_travel | string | TX |
| country_of_travel | string | United States |
| physician_ownership_indicator | string | No |
| third_party_payment_recipient_indicator | string | No Third Party Payment |
| name_of_third_party_entity_receiving_payment_or_transfer_of_value | string | ENLIGHTENMENT BIOCONSULT LLC |
| charity_indicator | string | No |
| third_party_equals_covered_recipient_indicator | string | No |
| contextual_information | string | No payment was made directly to this author. This is a fair |
| delay_in_publication_indicator | string | No |
| record_id | string | 672907505 |
| dispute_status_for_publication | string | No |
| related_product_indicator | string | Yes |
| covered_or_noncovered_indicator_1 | string | Covered |
| indicate_drug_or_biological_or_device_or_medical_supply_1 | string | Drug |
| product_category_or_therapeutic_area_1 | string | Dermatology |
| name_of_drug_or_biological_or_device_or_medical_supply_1 | string | Otezla |
| associated_drug_or_biological_ndc_1 | string | 59572-630-27 |
| associated_device_or_medical_supply_pdi_1 | string | N/A |
| covered_or_noncovered_indicator_2 | string | Covered |
| indicate_drug_or_biological_or_device_or_medical_supply_2 | string | Drug |
| product_category_or_therapeutic_area_2 | string | NEUROSCIENCE;TOBACCO DEPENDENCE |
| name_of_drug_or_biological_or_device_or_medical_supply_2 | string | CHANTIX |
| associated_drug_or_biological_ndc_2 | string | 0069-0471-02 |
| associated_device_or_medical_supply_pdi_2 | string | N/A |
| covered_or_noncovered_indicator_3 | string | Covered |
| indicate_drug_or_biological_or_device_or_medical_supply_3 | string | Device |
| product_category_or_therapeutic_area_3 | string | GASTROINTESTINAL |
| name_of_drug_or_biological_or_device_or_medical_supply_3 | string | COLOGUARD |
| associated_drug_or_biological_ndc_3 | string | 0071-1012-68 |
| associated_device_or_medical_supply_pdi_3 | string | N/A |
| covered_or_noncovered_indicator_4 | string | Covered |
| indicate_drug_or_biological_or_device_or_medical_supply_4 | string | Drug |
| product_category_or_therapeutic_area_4 | string | ONCOLOGY |
12 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.