Monitor NYC 311 data freshness and schema changes
Created by
Mikel Myers
Check NYC 311 Open Data for schema changes, missing required fields, duplicates, and stale updates using a bounded 25-row public API sample.
CKAN & Socrata Schema Change Monitormikelmyers/open-data-release-contract-monitor
Source key
State
Http status
Observed rows
+3 fieldsTextNumberBooleanListObject
Input
Maximum observed rows per source:25
Persistent baseline store name:open-data-contract-baselines-nyc-311-example
Public API sources(required)
Source kind(required):socrata
Socrata domain:data.cityofnewyork.us
Dataset ID:erm2-nwe9
Bounded query:$order=created_date DESC
Required fields
Key fields
Freshness field:created_date
Stale threshold in hours:168
Output fields
Source key
State
Http status
Observed rows
Duplicate key count
Warnings
Duration ms
Sign up on Apify01
Create your Apify account to access the CKAN & Socrata Schema Change Monitor.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
