{"uid":"cap_06u4rWNO6hOzFVkwre5g-","slug":"city-table-clean-socrata-ckan-csv-cleaner-x402-600d02e8","name":"City Table Clean – Socrata/CKAN CSV Cleaner (x402)","description":"Three x402-paid data APIs on one host. PricePlain: Posted US hospital prices (CMS price-transparency files), cleaned: Twin Cities, MN first. Cash and payer-negotiated rates per CPT/DRG code with canonical insurer names, provenance (source file URL + date) and data-quality flags. Posted prices, not quotes. TableGrab: public URL or file -> typed JSON tables / Markdown. City Table Clean: Socrata/CKAN city CSV cleaner with a per-change log.","url":"https://priceplain.onrender.com/v1/clean/upload?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"file":{"type":"string","format":"binary"},"dedupe":{"type":"string"}}},"responseSchema":{"type":"json","example":{"report":{"change_counts":{"date_standardized":1},"duplicates_removed":0},"changes":[{"row":1,"after":"2026-10-01","action":"date_standardized","before":"2026-10-01T00:00:00.000","column":"date"}],"cleaned_csv":"case_number,date,ward\nJK437343,2026-10-01,28\n"}},"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_HHmNZT40CtLHCEbSFRZzb","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":"Accepts a city government CSV file upload and returns a cleaned CSV with standardized dates, deduplicated rows, and a per-change audit log.","exampleAgentPrompt":"Can you clean up this city open data CSV I exported from Socrata — standardize the date formats and remove any duplicate rows — and give me a log of every change that was made?","exampleUseCases":[{"title":"Standardize dates in ward CSV","prompt":"I have a CSV from the Minneapolis open data portal with messy date fields like '2026-10-01T00:00:00.000' — can you clean it up so all dates are just YYYY-MM-DD and give me a report of what changed?"},{"title":"Deduplicate city incident records","prompt":"This CKAN export of city service requests has a bunch of duplicate rows — please remove the dupes and send me the cleaned CSV along with a count of how many duplicates were dropped."},{"title":"Audit changes before importing civic data","prompt":"Before I import this city council case CSV into our database, can you run it through the City Table Clean API to fix any formatting issues and give me a detailed per-row change log so I can review what was altered?"}],"resultDescription":"Returns a JSON object containing: a cleaned CSV string with standardized dates and deduplicated rows, an array of per-row change objects (each noting row index, column, before/after values, and action taken), and a summary report with counts of each type of change applied and duplicates removed.","failureModes":["Non-CSV or unparseable file upload returns an error","Very large files may time out on the Render free-tier host","Malformed CSV with inconsistent column counts may produce incomplete cleaning","Invalid dedupe parameter value may be ignored or cause a 400 error","Payment not completed via x402 protocol results in 402 Payment Required with no data returned"],"whenToPreferThis":"Choose this endpoint when you have a Socrata or CKAN city government CSV that needs automated date standardization, deduplication, and a traceable per-change audit log before downstream ingestion or analysis. It is purpose-built for civic open-data formats and provides provenance via change logs, unlike generic CSV converters that only transform format without logging mutations.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T00:30:13.351Z","isFirstParty":false,"canonicalSlug":"city-table-clean-socrata-ckan-csv-cleaner-x402-600d02e8"}