Socrata Nyc · Research
NYC Open Data / Query a dataset's rows with SoQL
Filter, sort and aggregate the rows of any public dataset on data.cityofnewyork.us with SoQL (Socrata's SQL-like language): select, where, order, group, having, full-text q, limit and offset. Rows come back as a GeoJSON FeatureCollection: each row is one feature, its columns are in properties (all values as strings) and geometry is the row's location or null. Up to 500 rows per call (default 100). Examples on this portal: PLUTO tax lots (64uk-42ks), ACRIS real property master (bnx9-e6tj), ACRIS parties (636b-3b5g), ACRIS legals (8h5j-fqxa), DOB permits (ipu4-2q9a), 311 requests (erm2-nwe9). A bad column name or SoQL syntax answers 400 at $0; an unknown dataset is a miss ($0). Free: the Socrata SODA API on data.cityofnewyork.us needs no key. Anonymous calls share an IP rate limit, so a burst can answer 429 (rate_limited, $0). This data has been modified for use from its original source, NYC Open Data (the City of New York). The City of New York cannot vouch for the accuracy or completeness of the data.
Live data
You are looking at the live public catalog.
Sign in to run this operation, inspect live eligibility, and see governed execution and audit evidence. Sign in.