API · x402

City Table Clean: send a Socrata or CKAN city open-data CSV URL (or upload) and get bac…

City Table Clean: send a Socrata or CKAN city open-data CSV URL (or upload) and get back a cleaned CSV plus a change report: trimmed whitespace, normalized headers, ISO dates, plain numbers, de-duplicated rows, and a per-cell change log.

by city-table-clean.onrender.com · discovered, not yet claimed by its owner · updated 2026-10-10

Mirrored from Coinbase's public x402 Bazaar. The description is the provider's own text and has not been reviewed here; the payment requirements are copied as published.

What it does

Tags: open-data · csv · socrata · ckan · data-cleaning · bazaar

Use with an agent

Discover. Agents find this listing with GET https://bazaar.saylorinnovations.com/discovery/search?query=…, the MCP tool search_resources, or /discovery/resources.
Inspect. Fetch /resources/36416.json for the price and payment options.
Pay. Call GET https://city-table-clean.onrender.com/v1/clean. The provider answers 402 with its payment requirements. An x402 client signs one of the options below and retries with PAYMENT-SIGNATURE.
Execute. The provider returns 200 with the data. Agent Bazaar is not in the request path and never sees your payment.

For humans

You don't need an account or an API key; you need a wallet holding a small amount of USDC on Base, and an x402-capable client (see the examples below). Call the endpoint unpaid first to see exactly what it asks for.

Pricing & payment

Price: $0.02 / request
Protocol: x402 v2
Auth: No account or API key. Pay per request.
Networks: Base
Calls (30d): 1 · 1 unique payers (third-party data from the public x402 Bazaar)

x402 payment requirements

Scheme	Network	Asset	Amount	Pay to	Timeout
exact	Base eip155:8453	USDC	$0.02	0x4c6BEb8b77365524A24f21d9111dF5c65033a758	120s

accepts[] (raw JSON)

[
  {
    "scheme": "exact",
    "network": "eip155:8453",
    "payTo": "0x4c6BEb8b77365524A24f21d9111dF5c65033a758",
    "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
    "amount": "20000",
    "amountUsd": 0.02,
    "maxTimeoutSeconds": 120
  }
]

Schemas

Output schema (JSON Schema)

{
  "properties": {
    "example": {
      "properties": {
        "changes": {
          "items": {
            "properties": {
              "action": {
                "type": "string"
              },
              "after": {},
              "before": {},
              "column": {
                "type": [
                  "string",
                  "null"
                ]
              },
              "row": {
                "type": "integer"
              }
            },
            "type": "object"
          },
          "type": "array"
        },
        "cleaned_csv": {
          "description": "Cleaned CSV text",
          "type": "string"
        },
        "report": {
          "description": "Summary: header map, column types, change counts, duplicates removed",
          "type": "object"
        },
        "source": {
          "type": "object"
        }
      },
      "required": [
        "cleaned_csv",
        "report"
      ],
      "type": "object"
    },
    "type": {
      "type": "string"
    }
  },
  "required": [
    "type"
  ],
  "type": "object"
}

Example shape — generated from the schema, not a captured live response

{
  "example": {
    "changes": [
      {
        "action": "string",
        "after": null,
        "before": null,
        "column": "string",
        "row": 0
      }
    ],
    "cleaned_csv": "string",
    "report": {},
    "source": {}
  },
  "type": "string"
}

Examples

curl

curl "https://city-table-clean.onrender.com/v1/clean"
# -> 402 Payment Required, accepts[] lists how to pay
# retry with a PAYMENT-SIGNATURE (or PAYMENT header) once paid

JavaScript

const res = await fetch("https://city-table-clean.onrender.com/v1/clean");
if (res.status === 402) {
  const { accepts } = await res.json();
  // pay one of accepts[] via an x402 client, then retry with the payment header
}

Python

import httpx
res = httpx.get("https://city-table-clean.onrender.com/v1/clean")
if res.status_code == 402:
    accepts = res.json()["accepts"]
    # pay one of accepts[] via an x402 client, then retry with the payment header

Details

Provider: city-table-clean.onrender.com
Endpoint: https://city-table-clean.onrender.com/v1/clean
Machine-readable: /resources/36416.json