search_healthcare_providers

tech.dataporium/mcp · Verify this server

US healthcare providers, hospitals and health systems from official US government data, linked by keys (NPI for providers, CCN for hospitals, PAC ID for group practices, a system ID for health systems). kind "hospitals" (default): every active Medicare hospital with type, ownership, beds, star rating (1 to 5), health system, listed owner (ticker) and the latest yearly financials; filter by q (name or city), state, city, zip, hospital_type (e.g. "Short-term acute care", "Critical access", "Psychiatric", "Children's"), ownership, system (ID or slug), ticker (e.g. HCA, THC, CYH, UHS); sort e.g. "net_patient_revenue" (default), "beds", "star_rating", "net_income", "operating_margin_pct". kind "health_systems": systems with hospitals, beds, clinicians, revenue roll-ups and listed owner; q, state, ticker. kind "providers": every provider with an NPI (doctors, nurse practitioners, clinics, pharmacies and more): q (name or NPI), specialty (e.g. "cardiology"), entity_type, state, city, zip, medicare=true for Medicare clinicians. kind "groups": Medicare group practices with their organization NPI and linked health system. kind "hospital_financials": yearly cost report financials per hospital (fiscal_year, state, system, ticker). kind "hospital_quality": quality measures (measure e.g. "mortality_heart_attack", "readmission_heart_failure", "would_recommend", "infection_c_diff", "ed_time_minutes") with national medians; best first by default. kind "provider_counts" / "hospital_counts": totals grouped by group_by (providers: state, specialty, medicare_specialty, entity_type; hospitals: state, hospital_type, ownership, star_rating, system, teaching). kind "specialties": specialty names and codes with provider counts. Medicare use and money (newest data year by default; year= for another): kind "procedures": Medicare services per provider and procedure code: give npi (a doctor's codes) or code (e.g. "99213", "G0439"; the providers billing it, with state). kind "procedure_codes": codes ranked by Medicare payments nationally or in a state (q = code or category words). kind "code_profile": one code (code=) by year and state. kind "procedure_providers": providers ranked by Medicare payments (state, specialty = provider type). kind "lab_tests" / "lab_test_providers": lab test codes with the lab fee schedule rate / labs ranked. kind "hospital_procedures": hospital stays per DRG (inpatient) and outpatient services per APC per hospital (ccn, code, state, system, ticker; filters {"setting": "outpatient"}); "hospital_procedure_codes": DRG/APC national totals. kind "prescriptions": Medicare drug claims and cost per prescriber and drug (npi or drug, e.g. "eliquis"). kind "drugs": drugs ranked by cost nationally or in a state (q, ticker). kind "drug_profile": one drug (drug=): totals by year and state, spending by manufacturer, top prescribers, Medicaid use, listed company. kind "prescribers": prescribers ranked. kind "drug_spending": spending by drug, manufacturer or listed company (group_by drug|manufacturer|company|year; ticker). kind "medicaid_drugs": Medicaid prescriptions and amount per drug product in a state (default national) and year (filters {"quarter": 1}). kind "payments": company payments to doctors and teaching hospitals (npi, ccn, ticker or filters {"payer": id}); "payment_companies": paying companies ranked (q, ticker); "payment_company": one company (q = name or ID); "payment_recipients": doctors and hospitals ranked by payments received. kind "company_summary": a listed company's (ticker=) Medicare drug spending and payments to doctors, its certified labs and its device approvals, recalls and adverse events. Diagnostics and labs: kind "labs": every certified US lab (about 300,000, all payers) with lab type, segment (independent_reference, pol = physician office, hospital, other), certificate, accreditations, yearly test volume, listed company (ticker, e.g. DGX, LH) and NPI/CCN links; q (name or lab number), state, city, zip, ticker, filters {"segment": "pol", "certificate_type": "accreditation", "accreditation": "CAP", "lab_type": "Pharmacy"}. kind "lab_counts": lab counts and test volumes by group_by segment, lab_type, certificate_type, state, volume_band, accreditation, company, segment_state, year or segment_year (trend). kind "lab_companies": lab companies with labs, states, volumes and Medicare lab payments. kind "lab_profile": one lab (q = 10-character lab number). kind "lab_test_segments": Medicare lab tests by group_by segment (independent_lab, pathology_practice, physician_office, hospital_setting, other), category (chemistry, hematology, immunology, microbiology, molecular_infectious, molecular_genetic, pla, pathology, toxicology, ...), year, place, segment_year, category_year, segment_category or code (with fee schedule rate and private insurer median). kind "lab_private_prices": private insurer lab prices (2016 reporting) next to the Medicare rate (code, q). Medical devices: kind "device_procedures": Medicare procedures that use devices by group_by category (e.g. joint, spine, cardiac_rhythm, structural_heart, coronary, neurostim, ophthalmic, imaging), subcategory, code, place (office, asc, hospital_outpatient, hospital_inpatient, ...), provider, year, category_year or category_place (code, year, filters {"category": "joint", "place": "asc"}). "How many knee replacements": kind "device_procedures", group_by "code", q "27447". kind "device_procedure_states": the same by state (code or filters {"category": ...}). kind "device_hospital_procedures": device-heavy hospital stays (DRG) and outpatient services (APC) by group_by category, code, state, hospital or year (ccn, state, system, ticker, filters {"setting": "inpatient"}). kind "device_procedures_icd": CALIFORNIA ONLY, all payers: inpatient procedure counts by ICD-10-PCS code with official descriptions, category and device category (group_by code, category, device_category, year; q = words or code prefix); its answer carries a required source line in "attribution": always show that line with these numbers. kind "medical_equipment": Medicare equipment and supplies (glucose monitors, sleep apnea machines, wheelchairs, braces) by group_by code, category, state or year; kind "equipment_referrers": doctors ordering the most. kind "devices": device product codes with class and counts. kind "device_approvals": 510(k) clearances, De Novo grants and PMA approvals (ticker, q, year, filters {"pathway": "pma"}; group_by year, pathway, company, year_pathway). kind "device_recalls": recalls (ticker, filters {"recall_class": "I"}; group_by year, class, root_cause, company). kind "device_adverse_events": adverse event reports by group_by year, product_code or company (ticker, filters {"event_type": "death"}). kind "device_companies": listed device makers with approval, recall and event totals; "device_company": one maker (ticker=, e.g. MDT, ABT, BSX). For one provider, hospital, system or group in full, use get_healthcare_provider. Extra filters: list_filters. The answer has website_link: share it so the user can see the data on dataporium.tech.