Washington State Open Data: Dataset Rows by SoQL Query

wadatasocrata/dataset-rows

Rows from any tabular dataset on the Washington State Open Data (data.wa.gov), chosen by its 8-character dataset id (for example d886-d5q2, Electric Vehicle Population Size History). Narrow, project, sort and aggregate with SoQL: select, where, order, group, a text search q, limit (1 to 50, default 10) and offset. Values come back as the portal publishes them, mostly strings. A filter that matches nothing returns an empty list; an unknown dataset id is refused as a validation error. State of Washington data as served by Omnial; not an official State of Washington product.

activeper callv1

Price

$0.0026 per call

You pay the price shown. If a call turns out to cost more than its quote, you pay the actual price, capped at twice the quote. No monthly minimum. Top-ups start at $0.50.

Data source

Washington State Open Data Portal (data.wa.gov)

Data from the State of Washington, published on the Washington State Open Data Portal (data.wa.gov). Attribute the publishing agency named in each dataset's metadata (for example Washington State Department of Licensing) and honour that dataset's declared licence. Served by Omnial; not an official State of Washington product.

Use it

Five steps: search, inspect, learn, run, settle. No per-tool setup; your agent reaches this tool through the meta-tools it already has.

Connect once and your AI can find and run this tool, and any other it needs.

Install it Create an account

agent

// 1. search: find the tool
omnial_search({ query: "what you need" })

// 2. inspect: price and input schema
omnial_inspect({ tool: "wadatasocrata/dataset-rows" })

// 3. learn: read the usage guide at runtime
omnial_learn({ tool: "wadatasocrata/dataset-rows" })

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "wadatasocrata/dataset-rows", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "wadatasocrata/dataset-rows", input: { /* ... */ } })

// 5. settle: the call is charged when it finishes, nothing to do

Not connected yet? Point your MCP client at https://mcp.eden-engine.com/mcp, then copy a config for your client.

Pricing

Every charge this tool can incur.

Charge	Price
Per call	$0.0026

Updated: Oct 21, 2026

Input and output schemas

Input schema

input_schema.json

{
  "type": "object",
  "required": [
    "dataset_id"
  ],
  "properties": {
    "q": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional text search across the dataset's text columns."
    },
    "group": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional SoQL group by, used with an aggregate in select, for example select=city,count(*) with group=city."
    },
    "limit": {
      "type": "integer",
      "default": 10,
      "maximum": 50,
      "minimum": 1,
      "description": "How many rows to return, 1 to 50. Defaults to 10."
    },
    "order": {
      "type": "string",
      "maxLength": 200,
      "description": "Optional SoQL ordering, for example date DESC. Leave out for the portal's default order."
    },
    "where": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL filter, for example date >= '2025-01-01T00:00:00'. Column names are those of the returned rows; an unknown column is refused as a validation error."
    },
    "offset": {
      "type": "integer",
      "maximum": 1000000,
      "minimum": 0,
      "description": "Rows to skip, for reading further pages in the order given by `order`. Leave out to start at the first row."
    },
    "select": {
      "type": "string",
      "maxLength": 500,
      "description": "Optional SoQL select: a comma list of columns or expressions, for example date,battery_electric_vehicle,electric_vehicle_total, or count(*) with group. Leave out for every column."
    },
    "dataset_id": {
      "type": "string",
      "pattern": "^[a-z0-9]{4}-[a-z0-9]{4}$",
      "description": "The dataset's 8-character id, two groups of four lowercase letters or digits joined by a hyphen, for example d886-d5q2. Find ids with the dataset-search tool or in a dataset's page address."
    }
  },
  "additionalProperties": false
}

Output schema

output_schema.json

{
  "type": "object",
  "required": [
    "results"
  ],
  "properties": {
    "results": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      },
      "description": "One entry per row; empty when the filter matches nothing. Columns, and their value types, are the dataset's own; computed region columns and geometry objects pass through unchanged."
    }
  },
  "description": "The rows the portal returned, in the portal's order.",
  "additionalProperties": true
}