{"uid":"cap_JrEVUilzQxDpP3NI87eJn","slug":"city-table-clean-socrata-ckan-csv-cleaner-1c6b07a2","name":"City Table Clean – Socrata/CKAN CSV Cleaner","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?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":{"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_pwOptdJ9eLsvgRCehCYcn","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 a public Socrata or CKAN city CSV by standardizing dates, deduplicating rows, and returning cleaned CSV plus a per-change audit log","exampleAgentPrompt":"Can you clean the Socrata CSV at https://data.cityofchicago.org/resource/ijzp-q8t2.csv — deduplicate rows, standardize any dates, and give me the cleaned CSV along with a log of every change that was made?","exampleUseCases":[{"title":"Cleaning a city crime report CSV","prompt":"Clean this Chicago crime data Socrata CSV for me — https://data.cityofchicago.org/resource/ijzp-q8t2.csv — deduplicate it and standardize all the date columns, and show me exactly what was changed row by row."},{"title":"Preparing CKAN dataset for analysis","prompt":"I need to use this CKAN dataset for a report — can you clean it at https://data.edmonton.ca/api/3/action/datastore_search?resource_id=xyz, deduplicate, fix any messy dates, and return the cleaned CSV with a change log?"},{"title":"Auditing data quality of a civic dataset","prompt":"Before I import this Socrata CSV into my database, can you run it through the City Table Clean endpoint — https://data.minneapolismn.gov/resource/abcd-1234.csv — up to 10000 rows, and give me the full list of changes so I can audit what was normalized?"}],"resultDescription":"Returns a JSON object with: a 'cleaned_csv' string containing the deduplicated and date-standardized CSV data, a 'changes' array listing each row-level modification (row number, column, action taken, before/after values), and a 'report' summary with counts of each type of change applied and total duplicates removed.","failureModes":["Non-Socrata/CKAN URL returns an error or unsupported format response","CSV exceeds 50,000 row limit — request must use max_rows to cap it","URL returns a 403 or 404 if the dataset is private or has been removed","Malformed or non-CSV content at the URL causes a parsing failure","x402 payment not completed results in 402 Payment Required response"],"whenToPreferThis":"Use this endpoint when you specifically have a Socrata (/resource/xxxx-xxxx.csv, /d/xxxx-xxxx, rows.csv) or CKAN city open data URL and need standardized dates, deduplication, and a detailed per-change audit log — not just a raw download. Prefer this over generic CSV parsers when working with civic/government open data portals and you need provenance of every transformation made.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T00:32:44.433Z","isFirstParty":false,"canonicalSlug":"city-table-clean-socrata-ckan-csv-cleaner-1c6b07a2"}