Ca Medical Exclusion Coverage
ca_medical_exclusion_coverageWhat the California DHCS Medi-Cal S&I (Suspended and Ineligible Provider) exclusion data covers and how current it is: total exclusions held, how many carry an NPI or license number, how many distinct provider types appear, the oldest and newest suspension dates, the list-wide statutory basis (Welfare & Institutions Code §§14043.6/14123), and the CHHS Open Data Portal's "last modified" date for the copy this pack serves. Use to check the screening data is fresh enough to rely on before a compliance decision, and to see the one-line note on what DHCS does NOT publish (a per-record exclusion reason). Pass year (e.g. 2025) or start_date/end_date to instead COUNT how many exclusions have a suspension date in that year or range, counted over the whole 23,000+ row list, not a page — answers "how many California Medi-Cal exclusions took effect in 2025". The response names the date field counted (suspended_since). Sourced from California DHCS via the CHHS Open Data Portal, keyless.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | Count records whose date field falls in this calendar year (e.g. 2025), counted over the WHOLE list, not a page. Ignored if start_date/end_date are given. | |
| end_date | No | Inclusive range end, YYYY-MM-DD. Use with start_date for a custom date range instead of a calendar year. | |
| start_date | No | Inclusive range start, YYYY-MM-DD. Use with end_date for a custom date range instead of a calendar year. |