nyc_dog_licenses

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

This data as json, CSV (advanced)

Link rowid ▲ RowNumber AnimalName AnimalGender AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
117271 117271 117271 MACHO M 2015 Boxer   11207 12/31/2018 12/31/2019 2018
117270 117270 117270 UNKNOWN F 2018 Schnauzer, Standard   11210 12/31/2018 12/31/2019 2018
117269 117269 117269 LUNA F 2017 Siberian Husky   10456 12/31/2018 02/23/2020 2018
117268 117268 117268 MAURICE M 2010 Poodle, Standard   11201 12/31/2018 02/07/2020 2018
117267 117267 117267 MUSCLES M 2006 American Pit Bull Terrier/Pit Bull   10029 12/31/2018 01/30/2020 2018
117266 117266 117266 GIOVANNI M 2014 Pomeranian   11417 12/31/2018 02/24/2020 2018
117265 117265 117265 JACKI F 2008 Miniature Pinscher   11415 12/31/2018 12/31/2019 2018
117264 117264 117264 KING M 2017 Yorkshire Terrier   10469 12/31/2018 06/01/2023 2018
117263 117263 117263 SASHA F 2007 Siberian Husky   10462 12/31/2018 12/15/2019 2018
117262 117262 117262 RANGER M 2006 American Pit Bull Mix / Pit Bull Mix   11374 12/31/2018 11/27/2020 2018
117261 117261 117261 SASHA F 2011 Cocker Spaniel   11415 12/31/2018 05/23/2023 2018
117260 117260 117260 ANGEL M 2016 American Pit Bull Mix / Pit Bull Mix   11229 12/31/2018 12/03/2019 2018
117259 117259 117259 TYENE F 2017 Siberian Husky   10003 12/31/2018 12/31/2023 2018
117258 117258 117258 HARLEY M 2018 Border Collie Crossbreed   10314 12/31/2018 12/31/2019 2018
117257 117257 117257 SUSIE F 2018 Shih Tzu Crossbreed   10021 12/31/2018 12/31/2019 2018
117256 117256 117256 UNKNOWN M 2018 Morkie   10467 12/31/2018 12/31/2019 2018
117255 117255 117255 UNKNOWN F 2018 Maltese Crossbreed   10011 12/31/2018 12/31/2019 2018
117254 117254 117254 UNKNOWN F 2018 Maltese Crossbreed   10011 12/31/2018 12/31/2019 2018
117253 117253 117253 UNKNOWN F 2018 Poodle Crossbreed   10007 12/31/2018 12/31/2019 2018
117252 117252 117252 WILLOW F 2018 Goldendoodle   10011 12/31/2018 12/31/2019 2018
117251 117251 117251 TANK M 2014 American Pit Bull Mix / Pit Bull Mix   10306 12/31/2018 12/31/2019 2018
117250 117250 117250 HENNY M 2014 American Pit Bull Mix / Pit Bull Mix   11433 12/30/2018 12/30/2019 2018
117249 117249 117249 BEAR M 2016 Australian Cattle Dog   10003 12/30/2018 12/30/2019 2018
117248 117248 117248 RAYMI M 2016 Labrador Retriever Crossbreed   10033 12/30/2018 12/30/2019 2018
117247 117247 117247 BELLA F 2018 Chihuahua   11221 12/30/2018 12/30/2019 2018
117246 117246 117246 HODGE M 2018 Pomeranian   11216 12/30/2018 12/30/2019 2018
117245 117245 117245 MAZIE F 2018 Labrador Retriever Crossbreed   11385 12/30/2018 12/30/2019 2018
117244 117244 117244 ROMAN M 2010 American Pit Bull Terrier/Pit Bull   10310 12/30/2018 12/30/2019 2018
117243 117243 117243 TRANESE F 2018 Maltese   11209 12/30/2018 12/30/2019 2018
117242 117242 117242 AURORA F 2018 Labrador Retriever Crossbreed   10461 12/30/2018 12/30/2019 2018
117241 117241 117241 PABLO M 2010 Cocker Spaniel   10023 12/30/2018 12/30/2019 2018
117240 117240 117240 MILLIE F 2008 Cocker Spaniel   10023 12/30/2018 12/30/2019 2018
117239 117239 117239 JUN M 2010 Maltese   11355 12/30/2018 02/11/2020 2018
117238 117238 117238 APPLE F 2009 Puggle   10128 12/30/2018 02/13/2020 2018
117237 117237 117237 GRINGO M 2007 Chihuahua   11232 12/30/2018 01/09/2020 2018
117236 117236 117236 PEBBLES F 2009 Shih Tzu   11434 12/30/2018 02/02/2020 2018
117235 117235 117235 SAMMY M 2005 Shih Tzu   10028 12/30/2018 12/30/2019 2018
117234 117234 117234 HERBIE M 2005 Pug   11102 12/30/2018 09/23/2019 2018
117233 117233 117233 CHARLIE M 2012 Labrador Retriever   11101 12/30/2018 02/08/2020 2018
117232 117232 117232 JO-JO M 2013 Shih Tzu   10002 12/30/2018 01/29/2021 2018
117231 117231 117231 CAPTAIN M 2016 Maltese Crossbreed   11217 12/30/2018 10/29/2019 2018
117230 117230 117230 PRINCESS F 2017 Yorkshire Terrier   11436 12/30/2018 11/26/2019 2018
117229 117229 117229 ROCKY M 2008 Shih Tzu   11434 12/30/2018 12/18/2019 2018
117228 117228 117228 MASTER M 2016 Rottweiler   10303 12/30/2018 12/30/2019 2018
117227 117227 117227 LEO M 2018 Pomeranian   10028 12/30/2018 12/30/2019 2018
117226 117226 117226 PATTY F 2003 Poodle, Miniature   10019 12/30/2018 12/30/2019 2018
117225 117225 117225 CARBONELL M 2018 Shih Tzu   11218 12/30/2018 12/30/2019 2018
117224 117224 117224 NAME NOT PROVIDED M 2018 Shih Tzu   11373 12/30/2018 12/30/2019 2018
117223 117223 117223 SUMMER F 2012 Unknown   10037 12/30/2018 12/30/2019 2018
117222 117222 117222 LUCKY F 2016 Cocker Spaniel   11206 12/30/2018 12/30/2019 2018
117221 117221 117221 THIERRY M 2016 Bulldog   10016 12/30/2018 12/30/2019 2018
117220 117220 117220 ROCKET M 2018 Yorkshire Terrier   11385 12/30/2018 12/30/2019 2018
117219 117219 117219 NAME M 2018 Shih Tzu   11228 12/30/2018 12/30/2019 2018
117218 117218 117218 MALDONADO M 2018 Shih Tzu   10459 12/30/2018 12/30/2019 2018
117217 117217 117217 KAIYA F 2009 German Shepherd Dog   11221 12/30/2018 12/30/2019 2018
117216 117216 117216 LEO M 2017 Unknown   11356 12/30/2018 12/30/2021 2018
117215 117215 117215 NANA F 2010 Unknown   10306 12/30/2018 12/30/2019 2018
117214 117214 117214 PRINCE M 2018 French Bulldog   11385 12/30/2018 12/30/2019 2018
117213 117213 117213 HOIST M 2017 Beagle   11223 12/30/2018 12/30/2019 2018
117212 117212 117212 DAMIAN M 2017 Unknown   11379 12/30/2018 12/30/2019 2018
117211 117211 117211 RADAR M 2008 Beagle   10019 12/30/2018 12/30/2020 2018
117210 117210 117210 NAME NOT PROVIDED M 2018 Poodle Crossbreed   11416 12/30/2018 12/30/2019 2018
117209 117209 117209 ANDIE F 2014 Terrier mix   11218 12/30/2018 12/30/2019 2018
117208 117208 117208 HULU M 2018 Poodle Crossbreed   10023 12/30/2018 12/30/2019 2018
117207 117207 117207 NAME M 2018 Shih Tzu   11208 12/30/2018 12/30/2019 2018
117206 117206 117206 NAME M 2018 Shiba Inu   11209 12/30/2018 12/30/2019 2018
117205 117205 117205 MAGNOLIA F 2005 Pug   10075 12/30/2018 12/30/2019 2018
117204 117204 117204 BEHARRY M 2018 Yorkshire Terrier   11429 12/30/2018 12/30/2019 2018
117203 117203 117203 DIEGO M 2014 Terrier mix   11201 12/30/2018 01/22/2022 2018
117202 117202 117202 MAX M 2011 Cairn Terrier   11223 12/30/2018 02/02/2020 2018
117201 117201 117201 BAILEY M 2012 Brussels Griffon   11691 12/30/2018 01/03/2020 2018
117200 117200 117200 RILEY M 2010 Cairn Terrier   10028 12/30/2018 01/27/2020 2018
117199 117199 117199 BARKLEY M 2009 Unknown   11234 12/30/2018 01/10/2020 2018
117198 117198 117198 KATIE F 2012 Unknown   11385 12/30/2018 12/02/2019 2018
117197 117197 117197 MILO M 2010 Bichon Frise   11364 12/30/2018 11/26/2019 2018
117196 117196 117196 FRANKIE F 2009 Unknown   11215 12/30/2018 12/21/2019 2018
117195 117195 117195 MICKY M 2010 Siberian Husky   10022 12/30/2018 01/10/2019 2018
117194 117194 117194 TEDDY M 2008 Scottish Terrier   10314 12/30/2018 02/16/2020 2018
117193 117193 117193 BLUE M 2010 American Pit Bull Terrier/Pit Bull   11358 12/30/2018 01/26/2020 2018
117192 117192 117192 ALLIE F 2011 Samoyed   10025 12/30/2018 11/18/2019 2018
117191 117191 117191 MOLLY F 2008 Unknown   10025 12/30/2018 02/06/2020 2018
117190 117190 117190 OLIVE F 2016 Labrador Retriever   11355 12/30/2018 12/30/2019 2018
117189 117189 117189 DUBLIN M 2015 American Pit Bull Mix / Pit Bull Mix   10033 12/30/2018 12/21/2019 2018
117188 117188 117188 OKAMI M 2016 Shiba Inu   11370 12/30/2018 02/11/2024 2018
117187 117187 117187 OLIVIA F 2018 Jindo   10038 12/30/2018 12/30/2021 2018
117186 117186 117186 SAQUISITI F 2018 Poodle   11228 12/30/2018 12/30/2019 2018
117185 117185 117185 MILAN F 2018 Yorkshire Terrier   11219 12/30/2018 12/30/2019 2018
117184 117184 117184 COOKIE M 2018 Shih Tzu   11204 12/30/2018 12/30/2019 2018
117183 117183 117183 COFFEE F 2018 Australian Shepherd   11362 12/30/2018 12/30/2019 2018
117182 117182 117182 BIGGS M 2018 Beagle Crossbreed   10040 12/30/2018 12/30/2019 2018
117181 117181 117181 GORDON M 2018 Maltese Crossbreed   10028 12/30/2018 12/30/2019 2018
117180 117180 117180 HARLEY F 2017 Cockapoo   10023 12/30/2018 12/30/2019 2018
117179 117179 117179 CHURCHILL M 2017 Beagle   10009 12/30/2018 12/30/2019 2018
117178 117178 117178 DUTCH M 2017 Dutch Shepherd   10461 12/30/2018 02/16/2020 2018
117177 117177 117177 OLIVER M 2017 Basset Hound   11365 12/30/2018 01/04/2020 2018
117176 117176 117176 LUIS M 2018 Yorkshire Terrier   11223 12/30/2018 12/30/2019 2018
117175 117175 117175 L F 2018 Goldendoodle   10461 12/30/2018 12/30/2019 2018
117174 117174 117174 FOXY F 2017 Pomeranian   10017 12/30/2018 12/30/2019 2018
117173 117173 117173 GONZALES M 2018 Yorkshire Terrier   10308 12/30/2018 12/30/2019 2018
117172 117172 117172 PANDORA F 2018 Chihuahua   10453 12/30/2018 12/30/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
);