Community Data Lab
Explore real datasets, write SQL, build charts, save reports, and share what you find. Everything runs in your browser — no account, no setup, no data leaves your machine.
SELECT borough, COUNT(*) AS total, ROUND(AVG(resolution_days), 1) AS avg_days FROM nyc_311 GROUP BY borough ORDER BY total DESC; What you can do
A full data workspace in your browser
SQL editor with autocomplete
Write queries with real-time suggestions for tables, columns, and SQL keywords. Hit Ctrl+Enter to run.
Built-in charts
Toggle bar, line, pie, or scatter charts on any query result. Pick your label and value columns to customize.
Save & share reports
Save your queries locally. Share them as a link — the SQL is compressed into the URL so anyone can open it.
Export results
Download any query result as CSV or JSON with one click. Great for moving data into other tools.
Upload your own data
Drag in Parquet, CSV, TSV, or JSON files up to 200MB. They load instantly into DuckDB for querying.
AI query assistant
Describe what you want in plain English. The AI sees your tables and suggests SQL you can run with one click.
Open Data
Start with a real dataset
Curated NYC datasets ready to query. Click to load one directly into the Data Lab.
NYC 311 Service Requests
Real 311 service request data from New York City. Every row is a complaint or request — noise, heat, potholes, rodents, ...
NYC Dog Licensing Dataset
Licensed dogs across NYC — names, breeds, boroughs. Find out if there are more Bellas or Maxes, which neighborhoods love...
NYC Street Tree Census
Every street tree in New York City from the 2015 Tree Census, recorded by volunteers. Includes species, size, health con...
How it works
Powered by DuckDB in your browser
Load data
Pick a dataset from our catalog, upload your own file, or load the sample data to start exploring immediately.
Write SQL
Use the editor with autocomplete to query your data. DuckDB handles aggregations, window functions, CTEs — the full SQL toolkit.
Visualize
Toggle charts to see your results as bar, line, pie, or scatter plots. Switch chart types and columns instantly.
Share
Save reports locally, export as CSV/JSON, or generate a shareable link that encodes your query right in the URL.
Our approach
Principles
Runs locally
Your data never leaves your browser. DuckDB-WASM processes everything on your machine. No server, no uploads, no tracking.
No account needed
Just open it and start querying. Reports save to your browser's local storage. Share via links, not logins.
Built for learning
Example queries for every dataset. Autocomplete to help you learn SQL syntax. AI assistant when you get stuck.
Free forever
The Data Lab is a nonprofit community resource. No premium tier, no paywalled features, no ads.
Ready to explore?
Open the Data Lab, load a dataset, and start asking questions. No setup, no sign-up — just data.