NYC Open Data
Search 2,500+ NYC Open Data datasets — taxi trips, 311 calls, restaurants, real estate — and query them with SQL.
Type at least 2 characters to search data.cityofnewyork.us.
Results open in the SQL editor — queries run entirely in your browser, no uploads.
About data.cityofnewyork.us
NYC Open Data is one of the largest municipal open data portals in the world, with datasets from every NYC agency: TLC taxi trips, 311 service requests, restaurant inspections, real estate transactions, NYPD crime data, MTA ridership, and thousands more. SmartQueryTools indexes the catalogue and lets you query datasets in your browser.
Popular topics
Transport
Search data.cityofnewyork.us for transport datasets
311 Calls
Search data.cityofnewyork.us for 311 calls datasets
Restaurants
Search data.cityofnewyork.us for restaurants datasets
Real Estate
Search data.cityofnewyork.us for real estate datasets
Crime
Search data.cityofnewyork.us for crime datasets
Health
Search data.cityofnewyork.us for health datasets
Education
Search data.cityofnewyork.us for education datasets
Environment
Search data.cityofnewyork.us for environment datasets
Frequently Asked Questions
How do I search data.cityofnewyork.us datasets?▼
Type at least two characters into the search box above. Results are pulled live from the NYC Open Data API and filtered to datasets with queryable file formats (CSV, JSON, Parquet, and similar). Each result shows the title, organisation, last-modified date, and available files.
Can I query data.cityofnewyork.us datasets without downloading them?▼
Yes — when you click "Load in Editor", the dataset URL is passed to SmartQueryTools' in-browser SQL engine, which fetches the file directly using HTTP range requests. The data never travels through our servers. Some data.cityofnewyork.us hosts don't expose CORS headers; in that case you can download the file from the source page and upload it via the "My Files" tab in the SQL editor.
What file formats can I query?▼
SmartQueryTools supports CSV, TSV, JSON, NDJSON (JSON Lines), Parquet, GeoJSON, and Excel. Search results are pre-filtered to datasets that include at least one of these formats — datasets that only ship PDF or ZIP files are hidden.
What licence is the data under?▼
Most data.cityofnewyork.us datasets are published under the NYC Open Data Terms, which permits commercial reuse with attribution. Always check the individual dataset page for any dataset-specific licence terms before using the data commercially.
Do I need an account or API key?▼
No. SmartQueryTools is free to use without an account, and data.cityofnewyork.us itself doesn't require an API key for public datasets. The optional $9/month subscription removes daily query limits and unlocks larger result exports.
Other open data sources
UK Government Open Data
Search and query 55,000+ UK government datasets directly in your browser.
Canada Open Government Data
Search 30,000+ Canadian federal government datasets and query them with SQL — no downloads.
Ireland Open Data
Search Irish government open data and run SQL on it instantly — no sign-up, no downloads.
New Zealand Open Data
Search 9,000+ New Zealand government datasets and query them in-browser with SQL.
NSW Government Open Data
Search 6,000+ NSW government datasets — transport, planning, health, environment — query them in your browser.
Queensland Government Open Data
Search Queensland Government open data — health, transport, environment, schools — and query it instantly with SQL.
How it works: SmartQueryTools searches the live data.cityofnewyork.us catalogue and filters results to datasets with queryable file formats. Clicking Load in Editor opens the SQL editor with a pre-populated query that reads the dataset directly via HTTP range requests — only the rows your query touches are downloaded. All processing happens inside your browser using a full analytical SQL engine compiled to WebAssembly.