Dog license records for the 2018 'extract year.' Note that each record represents a unique dog license that was active during the year, but not necessarily a unique record per dog, since a license that is renewed during the year results in a separate record of an active license period. Each record stands as a unique license period for the dog over the course of the yearlong time frame.

Data source: New York City Dept. of Mental Health and Hygeine

117,371 rows sorted by rowid descending

View and edit SQL

Link rowid ▲ RowNumber AnimalName AnimalGender AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
117371 117371 HUNTER M 2017 Siberian Husky   10456 12/31/2018 12/31/2019 2018
117370 117370 LUNA F 2018 Jindo   11385 12/31/2018 12/31/2019 2018
117369 117369 UNKNOWN F 2018 Dachshund   10454 12/31/2018 12/31/2019 2018
117368 117368 UNKNOWN M 2018 Australian Shepherd   11233 12/31/2018 12/31/2019 2018
117367 117367 BOLAND F 2018 Pomeranian   10306 12/31/2018 12/31/2019 2018
117366 117366 TOBY M 2018 Maltese   10470 12/31/2018 12/31/2019 2018
117365 117365 HUGO M 2018 Poodle   11217 12/31/2018 12/31/2019 2018
117364 117364 ERNIE M 2016 Labrador Retriever   11249 12/31/2018 12/31/2020 2018
117363 117363 DEXTER M 2010 Unknown   10009 12/31/2018 10/21/2019 2018
117362 117362 OTIS M 2011 Rottweiler   10075 12/31/2018 01/27/2020 2018
117361 117361 SHEA F 2013 Golden Retriever   11377 12/31/2018 02/08/2020 2018
117360 117360 BELLA F 2010 Chihuahua   10463 12/31/2018 02/17/2020 2018
117359 117359 DUSTY F 2008 Norfolk Terrier   10028 12/31/2018 12/10/2019 2018
117358 117358 BELLA F 2009 Yorkshire Terrier   10029 12/31/2018 12/13/2019 2018
117357 117357 LEXI F 2014 Jack Russell Terrier   11219 12/31/2018 02/13/2020 2018
117356 117356 PIPA M 2015 Pug   11366 12/31/2018 02/19/2021 2018
117355 117355 GRIFF M 2012 Yorkshire Terrier Crossbreed   11201 12/31/2018 01/24/2020 2018
117354 117354 GAVIN M 2015 Chihuahua   10016 12/31/2018 01/25/2020 2018
117353 117353 TRIXIE F 2013 Basset Hound   10307 12/31/2018 12/12/2019 2018
117352 117352 WINNIE M 2014 Chihuahua Crossbreed   11413 12/31/2018 12/05/2019 2018
117351 117351 CUPID M 2014 Jack Russell Terrier   10473 12/31/2018 12/23/2019 2018
117350 117350 APPA M 2013 Goldendoodle   10027 12/31/2018 01/30/2020 2018
117349 117349 PRADA F 2010 Shih Tzu   11374 12/31/2018 12/29/2019 2018
117348 117348 SHILOH F 2006 Unknown   11249 12/31/2018 11/29/2019 2018
117347 117347 SPIKE M 2005 Pomeranian   10003 12/31/2018 01/30/2020 2018
117346 117346 TOTO F 2009 Cairn Terrier   10308 12/31/2018 11/30/2019 2018
117345 117345 YOSHI M 2016 Labrador Retriever Crossbreed   10024 12/31/2018 12/31/2021 2018
117344 117344 LOLA F 2017 Jack Russell Terrier   10703 12/31/2018 12/31/2019 2018
117343 117343 SAMMIE F 2018 Shih Tzu Crossbreed   10128 12/31/2018 12/31/2019 2018
117342 117342 RUTH F 2018 Labrador Retriever Crossbreed   10025 12/31/2018 12/31/2019 2018
117341 117341 UNKNOWN M 2018 Poodle   10019 12/31/2018 12/31/2019 2018
117340 117340 PLUTO F 2018 Cockapoo   10128 12/31/2018 12/31/2019 2018
117339 117339 UNKNOWN M 2018 Poodle Crossbreed   10005 12/31/2018 12/31/2019 2018
117338 117338 GRIFFIN M 2015 Terrier mix   10021 12/31/2018 08/28/2020 2018
117337 117337 SNOW M 2014 Border Collie   10306 12/31/2018 05/23/2021 2018
117336 117336 EMMY F 2014 Cocker Spaniel   11105 12/31/2018 02/23/2020 2018
117335 117335 CHIQUIS F 2013 Shih Tzu   10032 12/31/2018 01/31/2021 2018
117334 117334 CECI F 2013 Jack Russell Terrier   10032 12/31/2018 01/31/2021 2018
117333 117333 BAXTER M 2009 Unknown   10312 12/31/2018 02/11/2020 2018
117332 117332 NIKKO M 2008 Shih Tzu   10065 12/31/2018 01/29/2020 2018
117331 117331 TEDDY M 2010 Beagle   11220 12/31/2018 02/07/2020 2018
117330 117330 ESTES F 2003 Staffordshire Bull Terrier   10307 12/31/2018 02/22/2020 2018
117329 117329 BRANDY F 2007 Cocker Spaniel   10471 12/31/2018 01/10/2020 2018
117328 117328 SPARKY M 2013 Unknown   10025 12/31/2018 12/26/2019 2018
117327 117327 UNKNOWN M 2018 Poodle Crossbreed   10454 12/31/2018 12/31/2019 2018
117326 117326 UNKNOWN M 2018 Chihuahua   11216 12/31/2018 12/31/2019 2018
117325 117325 UNKNOWN M 2018 Shih Tzu   11213 12/31/2018 12/31/2019 2018
117324 117324 UNKNOWN F 2018 Pug   10017 12/31/2018 12/31/2019 2018
117323 117323 PENNY F 2018 Yorkshire Terrier Crossbreed   10016 12/31/2018 12/31/2019 2018
117322 117322 LILY F 2018 Havanese   10005 12/31/2018 12/31/2019 2018
117321 117321 DIAMOND F 2017 Maltese   11207 12/31/2018 12/31/2019 2018
117320 117320 SUZZY F 2012 Unknown   11212 12/31/2018 11/22/2019 2018
117319 117319 ROCCO M 2017 Labrador Retriever   10469 12/31/2018 12/24/2020 2018
117318 117318 MADISON F 2016 Shih Tzu Crossbreed   10029 12/31/2018 12/13/2019 2018
117317 117317 BRUTUS M 2014 Bull Dog, English   10306 12/31/2018 02/06/2020 2018
117316 117316 GIZMO M 2013 Chihuahua   10312 12/31/2018 02/01/2020 2018
117315 117315 HERMES M 2008 Shih Tzu   10011 12/31/2018 09/16/2019 2018
117314 117314 SCOOTER M 2006 Jack Russell Terrier   11206 12/31/2018 01/30/2020 2018
117313 117313 SPARKY M 2007 Wheaton Terrier   11697 12/31/2018 01/03/2020 2018
117312 117312 CHIQUITA F 2012 Poodle, Toy   11355 12/31/2018 12/12/2019 2018
117311 117311 ROMAN M 2015 Jack Russell Terrier Crossbreed   10002 12/31/2018 12/31/2019 2018
117310 117310 UNKNOWN F 2018 Shih Tzu Crossbreed   10307 12/31/2018 12/31/2019 2018
117309 117309 STELLA F 2018 Boston Terrier   10010 12/31/2018 12/31/2019 2018
117308 117308 UNKNOWN M 2018 Pug   11104 12/31/2018 12/31/2019 2018
117307 117307 HUGO M 2018 Labradoodle   11215 12/31/2018 12/31/2019 2018
117306 117306 ROCCO M 2015 German Shepherd Crossbreed   11366 12/31/2018 02/16/2020 2018
117305 117305 HARRY M 2013 Miniature Schnauzer   10301 12/31/2018 12/22/2019 2018
117304 117304 UNKNOWN F 2018 Maltese Crossbreed   10001 12/31/2018 12/31/2019 2018
117303 117303 COTTON F 2016 Unknown   10451 12/31/2018 12/31/2019 2018
117302 117302 UNKNOWN F 2018 Morkie   10458 12/31/2018 12/31/2019 2018
117301 117301 VIKTOR M 2018 Poodle   11106 12/31/2018 12/31/2019 2018
117300 117300 UNKNOWN F 2018 Chihuahua   10036 12/31/2018 12/31/2019 2018
117299 117299 UNKNOWN F 2018 Poodle Crossbreed   10001 12/31/2018 12/31/2019 2018
117298 117298 EDGAR M 2014 Scottish Terrier   10024 12/31/2018 12/03/2019 2018
117297 117297 RIPLEY F 2015 American Pit Bull Mix / Pit Bull Mix   11101 12/31/2018 12/16/2019 2018
117296 117296 LUCY F 2015 Chihuahua Crossbreed   11361 12/31/2018 12/27/2019 2018
117295 117295 SAEWOO M 2014 Maltese   11225 12/31/2018 01/05/2020 2018
117294 117294 IRISH F 2015 Boston Terrier   10069 12/31/2018 02/03/2021 2018
117293 117293 PENELOPE F 2014 Bull Dog, English   10306 12/31/2018 02/06/2020 2018
117292 117292 TULLY M 2014 Unknown   10016 12/31/2018 12/29/2019 2018
117291 117291 RIO M 2005 Poodle, Standard   11385 12/31/2018 10/08/2019 2018
117290 117290 CJ M 2002 Maltese   10314 12/31/2018 01/30/2020 2018
117289 117289 BELLA F 2008 Yorkshire Terrier   11365 12/31/2018 02/25/2020 2018
117288 117288 BAILEY M 2008 Cocker Spaniel   10280 12/31/2018 12/16/2019 2018
117287 117287 OOGIE M 2013 French Bulldog   11201 12/31/2018 11/19/2019 2018
117286 117286 LOVELY F 2014 Yorkshire Terrier Crossbreed   11355 12/31/2018 02/05/2020 2018
117285 117285 WILMA F 2016 Dachshund Crossbreed   11249 12/31/2018 02/16/2021 2018
117284 117284 SUSIE F 2007 Greyhound   10003 12/31/2018 12/31/2019 2018
117283 117283 BIM M 2015 Shih Tzu   11365 12/31/2018 12/31/2019 2018
117282 117282 KEBAB M 2013 Shih Tzu Crossbreed   10128 12/31/2018 12/31/2019 2018
117281 117281 UNKNOWN F 2018 Boston Terrier   10002 12/31/2018 12/31/2019 2018
117280 117280 UNKNOWN F 2018 Pomeranian Crossbreed   10022 12/31/2018 12/31/2019 2018
117279 117279 UNKNOWN F 2018 Bichon Frise Crossbreed   11213 12/31/2018 12/31/2019 2018
117278 117278 TOBY M 2013 Yorkshire Terrier   10457 12/31/2018 12/31/2019 2018
117277 117277 ROSEBUD F 2016 German Shepherd Dog   10012 12/31/2018 10/07/2020 2018
117276 117276 HONEY F 2017 Pomeranian Crossbreed   10014 12/31/2018 02/10/2021 2018
117275 117275 TINO M 2017 Labrador Retriever Crossbreed   11201 12/31/2018 12/31/2019 2018
117274 117274 UNKNOWN M 2018 Havanese   10011 12/31/2018 12/31/2019 2018
117273 117273 UNKNOWN M 2018 Maltese   11207 12/31/2018 12/31/2019 2018
117272 117272 UNKNOWN M 2018 Pomeranian Crossbreed   10023 12/31/2018 12/31/2019 2018

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [nyc_dog_licenses] (
   [RowNumber] TEXT,
   [AnimalName] TEXT,
   [AnimalGender] TEXT,
   [AnimalBirthMonth] TEXT,
   [BreedName] TEXT,
   [Borough] TEXT,
   [ZipCode] TEXT,
   [LicenseIssuedDate] TEXT,
   [LicenseExpiredDate] TEXT,
   [Extract Year] TEXT
);