NYC Open Data ↗ 60.0K rows 3.6 MB Apr 6, 2026

NYC Dog Licensing Dataset

Licensed dogs across NYC — names, breeds, boroughs. Find out if there are more Bellas or Maxes, which neighborhoods love French Bulldogs, and how dog ownership has changed over the years.

Open in Data Lab

Schema

7 columns in this dataset

Column	Type	Description
`animal_name`	VARCHAR
`breed`	VARCHAR
`borough`	VARCHAR
`zip_code`	VARCHAR
`license_issued_date`	TIMESTAMP
`license_expired_date`	TIMESTAMP
`animal_gender`	VARCHAR

Example Queries

Try these queries to start exploring the data

Most popular dog names

Run in Data Lab

SELECT animal_name, COUNT(*) as total FROM nyc_dogs WHERE animal_name IS NOT NULL GROUP BY animal_name ORDER BY total DESC LIMIT 20

Top breeds by borough

Run in Data Lab

SELECT borough, breed, COUNT(*) as total FROM nyc_dogs GROUP BY borough, breed QUALIFY ROW_NUMBER() OVER (PARTITION BY borough ORDER BY COUNT(*) DESC) <= 3 ORDER BY borough, total DESC

Registrations over time

Run in Data Lab

SELECT DATE_TRUNC('year', license_issued_date) as year, COUNT(*) as registrations FROM nyc_dogs GROUP BY year ORDER BY year