City Table Clean
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.
Not tested: has real-world effectsour last check, 2026-10-10
0 of 0checks answered this week
n/amedian answer time
$0.02listed price per call
n/aprice it asked us
Paid test badge: not yet. The checks above are free: we call the tool without paying and read the payment request it sends back. The Verified badge needs paid calls whose answers match the promised output, and nobody can buy a badge.
Endpoint
POST https://city-table-clean.onrender.com/v1/clean
| Category | Everything else |
|---|---|
| Provider host | city-table-clean.onrender.com |
| Networks | eip155:8453 |
| Payment schemes | exact |
| Self-reported calls, 30 days | 0 from 0 payers (the provider's figure, not ours) |
Our checks, last 30 days
We never call tools that send, buy, move money or file anything, not even without paying.
Example input (from the provider)
{
"body": {
"url": "https://data.cityofchicago.org/resource/ijzp-q8t2.csv?$limit=100"
},
"bodyType": "json",
"method": "POST",
"type": "http"
}
Promised output schema (from the provider)
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"input": {
"additionalProperties": false,
"properties": {
"body": {
"properties": {
"dedupe": {
"default": true,
"type": "boolean"
},
"include_changes": {
"default": true,
"type": "boolean"
},
"max_rows": {
"default": 50000,
"maximum": 50000,
"minimum": 1,
"type": "integer"
},
"url": {
"description": "https URL of a public CSV: Socrata (/resource/xxxx-xxxx.csv, /d/xxxx-xxxx, rows.csv) or CKAN resource/download URL",
"format": "uri",
"type": "string"
}
},
"required": [
"url"
],
"type": "object"
},
"bodyType": {
"enum": [
"json",
"form-data",
"text"
],
"type": "string"
},
"method": {
"enum": [
"POST",
"PUT",
"PATCH"
],
"type": "string"
},
"type": {
"const": "http",
"type": "string"
}
},
"required": [
"type",
"method",
"bodyType",
"body"
],
"type": "object"
},
"output": {
"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"
}
},
"required": [
"input"
],
"type": "object"
}