{"uid":"cap_OZw9_dhmFm8iEvVJqrzbq","slug":"city-table-clean-f7193719","name":"City Table Clean","description":"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. Feedback/support: POST /feedback (free) or js4336638@gmail.com.","url":"https://city-table-clean.onrender.com/v1/clean?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"url":{"type":"string","format":"uri","description":"https URL of a public CSV: Socrata (/resource/xxxx-xxxx.csv, /d/xxxx-xxxx, rows.csv) or CKAN resource/download URL"},"dedupe":{"type":"boolean","default":true},"max_rows":{"type":"integer","default":50000,"maximum":50000,"minimum":1},"include_changes":{"type":"boolean","default":true}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.02","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.02/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_HRWVz3ls19Gu2K0-q1LBh","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.02","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans city open-data CSVs (Socrata or CKAN) by normalizing headers, trimming whitespace, standardizing dates, removing duplicates, and returning a cleaned CSV plus a per-cell change log.","exampleAgentPrompt":"Can you clean this Socrata dataset for me — https://data.cityofchicago.org/resource/wrvz-psew.csv — deduplicate the rows and give me back a cleaned CSV with a full change report showing what was fixed?","exampleUseCases":[{"title":"Prep city crime data for analysis","prompt":"I have this Socrata CSV of Chicago crime reports at https://data.cityofchicago.org/resource/ijzp-q8t2.csv — can you clean it up, normalize the headers and dates, remove any duplicate rows, and send me the cleaned file plus a log of every change that was made?"},{"title":"Fix messy CKAN transit dataset","prompt":"There's a CKAN dataset at https://open.toronto.ca/dataset/ttc-routes-and-schedules/ with inconsistent column names and weird date formats — can you run it through the city data cleaner, keep deduplication on, and give me the cleaned CSV with a change report?"},{"title":"Audit changes in a budget dataset","prompt":"Can you clean the city budget CSV at https://data.sfgov.org/resource/xdgd-c79v.csv and give me a detailed per-cell change log so I can audit exactly what was normalized or corrected before I import it into our dashboard?"}],"resultDescription":"Returns a cleaned CSV file with trimmed whitespace, normalized column headers, ISO-formatted dates, plain numeric values, and deduplicated rows, along with a structured change report detailing every per-cell modification made during the cleaning process.","failureModes":["Invalid or inaccessible CSV URL returns an error — URL must be publicly reachable","Non-CSV content at the URL (e.g. HTML, JSON) causes a parse failure","Dataset exceeds max_rows limit of 50,000 rows and is truncated or rejected","Malformed Socrata or CKAN URL format not recognized by the service","Network timeout if the remote CSV is very large or the host is slow","Payment failure if USDC balance is insufficient for the $0.02 per-call fee"],"whenToPreferThis":"Choose this endpoint when working specifically with Socrata or CKAN city open-data CSVs that need standardization before analysis or ingestion — it is purpose-built for municipal dataset quirks (inconsistent headers, mixed date formats, duplicate rows) and returns both a cleaned file and an auditable change log in one call. Prefer it over generic CSV tools when you need the change report for data governance or when the source is a known city data portal URL.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T00:30:42.428Z","isFirstParty":false,"canonicalSlug":"city-table-clean-f7193719"}