wa_rate_summary

Pack: wa-medicaid-rates · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/wa_rate_summary for the schema, then POST the same URL with its arguments for the data.

Washington Apple Health FQHC and RHC encounter-rate workbooks at a glance (Washington State Health Care Authority): which quarterly publications are held and when HCA updated each, how many rows and NPIs, min/median/max/mean encounter rate, optionally grouped by FQHC category of service, rate start date or quarter. Also states what is not covered.

Parameters

NameTypeRequiredDescription
programstringnoOne program, or omit for both.
periodstringno”latest” (default), “all”, or the start of an HCA quarter.
group_bystringnoGroup the rate statistics (default none).

Example call

Arguments

{
  "program": "FQHC",
  "group_by": "category"
}

curl

curl -X POST https://gateway.pipeworx.io/wa-medicaid-rates/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"wa_rate_summary","arguments":{"program":"FQHC","group_by":"category"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('wa_rate_summary', {
  "program": "FQHC",
  "group_by": "category"
});

Response shape

FieldTypeDescription
programstring
periodstring
scopestring
publicationsarray
periods_heldarray
summaryobject
rowsnumber
distinct_npisnumber
individual_rows_droppednumber
individuals_notestring
sourcestring
data_as_ofstring
captured_atstring
group_bystring
rows_without_group_valuenumber
groupsarray
Full JSON Schema
{
  "type": "object",
  "properties": {
    "program": {
      "type": "string"
    },
    "period": {
      "type": "string"
    },
    "scope": {
      "type": "string"
    },
    "publications": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "kind": {
            "type": "string"
          },
          "dataset": {
            "type": "string"
          },
          "period_start": {
            "type": "string"
          },
          "period_label": {
            "type": "string"
          },
          "publisher_note": {
            "type": "string"
          },
          "publisher_updated": {
            "type": "string"
          },
          "rows": {
            "type": "number"
          },
          "individual_rows_dropped": {
            "type": "number"
          },
          "duplicate_lines_removed": {
            "type": "number"
          }
        },
        "additionalProperties": true
      }
    },
    "periods_held": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "summary": {
      "type": "object",
      "properties": {
        "rows": {
          "type": "number"
        },
        "min": {
          "type": "number"
        },
        "median": {
          "type": "number"
        },
        "max": {
          "type": "number"
        },
        "mean": {
          "type": "number"
        }
      },
      "additionalProperties": true
    },
    "rows": {
      "type": "number"
    },
    "distinct_npis": {
      "type": "number"
    },
    "individual_rows_dropped": {
      "type": "number"
    },
    "individuals_note": {
      "type": "string"
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": "string"
    },
    "captured_at": {
      "type": "string"
    },
    "group_by": {
      "type": "string"
    },
    "rows_without_group_value": {
      "type": "number"
    },
    "groups": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "category": {
            "type": "string"
          },
          "rows": {
            "type": "number"
          },
          "min": {
            "type": "number"
          },
          "median": {
            "type": "number"
          },
          "max": {
            "type": "number"
          },
          "mean": {
            "type": "number"
          }
        },
        "additionalProperties": true
      }
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}
Connect to just the wa-medicaid-rates pack
{
  "mcpServers": {
    "wa-medicaid-rates": {
      "url": "https://gateway.pipeworx.io/wa-medicaid-rates/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

Regenerated from source · build November 16, 2026