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 RowNumber

View and edit SQL

Link rowid RowNumber ▼ AnimalName AnimalGender AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
1 1 ALI M 2014 Basenji   10013 09/12/2014 09/12/2019 2018
10 10 BIGS M 2004 American Pit Bull Terrier/Pit Bull   11208 09/13/2014 10/27/2019 2018
100 100 LAYLA F 2013 Havanese   10065 10/04/2014 10/04/2019 2018
1000 1000 OSKAR M 2013 Border Collie   11249 04/08/2015 04/17/2020 2018
10001 10000 JAKE M 2016 Siberian Husky Crossbreed   10463 01/08/2017 01/08/2018 2018
100000 100000 UNKNOWN M 2018 Boston Terrier   11220 09/26/2018 09/26/2019 2018
100001 100001 RYDER M 2012 Unknown   11225 09/26/2018 09/26/2019 2018
100002 100002 STELLA F 2016 Poodle Crossbreed   10001 09/26/2018 09/26/2021 2018
100003 100003 MAZY M 2016 Goldendoodle   10069 09/26/2018 09/26/2019 2018
100004 100004 ORI F 2002 Papillon   10023 09/26/2018 11/11/2019 2018
100005 100005 DOU F 2011 Maltese   11364 09/26/2018 09/03/2020 2018
100006 100006 ALBUS M 2014 Treeing Walker Coonhound   11233 09/26/2018 08/29/2019 2018
100007 100007 FALLON F 2013 Pomeranian   11211 09/26/2018 08/23/2019 2018
100008 100008 COOPER M 2015 American Staffordshire Terrier   10314 09/26/2018 08/14/2019 2018
100009 100009 BRODY M 2015 Golden Retriever   10128 09/26/2018 07/06/2021 2018
10002 10001 JUBILEE F 2013 Beagle   11222 01/08/2017 01/08/2018 2018
100010 100010 BETTY F 2012 Cairn Terrier   10017 09/26/2018 10/04/2019 2018
100011 100011 SAMMY M 2015 Labrador Retriever   10031 09/26/2018 10/14/2022 2018
100012 100012 RYAN M 2013 American Staffordshire Terrier   10037 09/26/2018 09/26/2019 2018
100013 100013 OLIVE F 2006 Pug   11238 09/26/2018 08/27/2019 2018
100014 100014 MIMI F 2008 Shih Tzu   11220 09/26/2018 08/21/2020 2018
100015 100015 PRINCESS F 2008 Lhasa Apso   11694 09/26/2018 10/28/2020 2018
100016 100016 PEANUT M 2009 Unknown   11101 09/26/2018 10/14/2019 2018
100017 100017 ROCKY M 2012 Shih Tzu   10314 09/26/2018 10/21/2020 2018
100018 100018 JASMINE F 2005 Unknown   10309 09/26/2018 11/16/2019 2018
100019 100019 CHICO M 2015 Unknown   10305 09/26/2018 09/26/2019 2018
10003 10002 MATCHA M 2016 American Pit Bull Mix / Pit Bull Mix   10451 01/08/2017 01/08/2018 2018
100020 100020 SUNWAKEN M 2012 Shetland Sheepdog   10025 09/26/2018 09/26/2019 2018
100021 100021 UNKNOWN M 2018 Miniature Pinscher   11355 09/26/2018 09/26/2019 2018
100022 100022 MARTA F 2013 Unknown   10312 09/26/2018 09/26/2019 2018
100023 100023 COCO F 2006 Maltese Crossbreed   11226 09/26/2018 09/26/2019 2018
100024 100024 OLLIE M 2018 Border Terrier   11205 09/26/2018 09/26/2019 2018
100025 100025 PRINCESS F 2010 Shih Tzu   11422 09/26/2018 09/26/2021 2018
100026 100026 ELOISE F 2018 Poodle, Toy   10022 09/26/2018 09/26/2019 2018
100027 100027 JAMES M 2017 Catahoula Leopard Dog   11423 09/26/2018 09/26/2020 2018
100028 100028 JOEY M 2017 Yorkshire Terrier   11435 09/26/2018 11/16/2019 2018
100029 100029 CASEY F 2018 Goldendoodle   10002 09/26/2018 09/26/2019 2018
10004 10003 MIA F 2007 Shih Tzu   10029 01/08/2017 01/07/2018 2018
100030 100030 UNKNOWN M 2018 Golden Retriever   10244 09/26/2018 09/26/2019 2018
100031 100031 UNKNOWN F 2018 Maltese   11208 09/26/2018 09/26/2019 2018
100032 100032 HERBIE M 2010 Unknown   10301 09/26/2018 09/26/2019 2018
100033 100033 HUDSON M 2018 Maltipoo   10024 09/26/2018 09/26/2019 2018
100034 100034 MAXWELL M 2016 Dachshund Crossbreed   11216 09/26/2018 09/26/2019 2018
100035 100035 PENNY F 2018 Australian Shepherd   11217 09/26/2018 09/26/2019 2018
100036 100036 LUCIANO M 2017 Chihuahua   10021 09/26/2018 10/24/2023 2018
100037 100037 RYAN M 2016 Maltese   11237 09/26/2018 11/01/2019 2018
100038 100038 BLUE M 2015 Labrador Retriever Crossbreed   10454 09/26/2018 08/17/2019 2018
100039 100039 DAISY F 2008 Puggle   10022 09/26/2018 11/14/2019 2018
10005 10004 MAMBA F 2016 Maltese   10009 01/08/2017 01/08/2018 2018
100040 100040 SPROCKET M 2012 Cairn Terrier   11362 09/26/2018 11/17/2021 2018
100041 100041 GEORGIE F 2013 Cocker Spaniel   11201 09/26/2018 11/02/2019 2018
100042 100042 CLARENCE M 2013 Unknown   10028 09/26/2018 11/06/2019 2018
100043 100043 ELMO M 2014 German Shepherd Crossbreed   10469 09/26/2018 10/17/2020 2018
100044 100044 HUDSON M 2009 Unknown   10013 09/26/2018 05/09/2020 2018
100045 100045 JAKE M 2014 Terrier mix   11238 09/26/2018 09/07/2020 2018
100046 100046 WAFFLES F 2016 Poodle Crossbreed   10021 09/26/2018 09/03/2019 2018
100047 100047 BELLE F 2011 Unknown   11229 09/26/2018 10/29/2023 2018
100048 100048 PATRICIA F 2007 Cocker Spaniel   10314 09/26/2018 09/29/2019 2018
100049 100049 RALPH M 2018 Pekingese   11434 09/26/2018 09/26/2019 2018
10006 10005 HOPE F 2016 American Staffordshire Terrier   11201 01/08/2017 01/08/2018 2018
100050 100050 UNKNOWN M 2018 Goldendoodle   11369 09/26/2018 09/26/2019 2018
100051 100051 PRINCE M 2018 Labradoodle   11361 09/26/2018 09/26/2019 2018
100052 100052 XANDER M 2018 Yorkshire Terrier   10466 09/26/2018 09/26/2019 2018
100053 100053 SOPHIE F 2018 Cocker Spaniel   11375 09/26/2018 09/26/2019 2018
100054 100054 MOLLY F 2018 Pekingese   10466 09/26/2018 09/26/2019 2018
100055 100055 BATMAN M 2014 Shiba Inu Crossbreed   10128 09/26/2018 09/26/2019 2018
100056 100056 DEXTER M 2017 Poodle, Miniature   10036 09/26/2018 09/26/2023 2018
100057 100057 LILY F 2010 Jack Russell Terrier   11216 09/26/2018 09/26/2019 2018
100058 100058 ZOEY F 2017 Chihuahua Crossbreed   10026 09/26/2018 11/06/2019 2018
100059 100059 SUGAR F 2011 Maltese   11422 09/27/2018 11/01/2019 2018
10007 10006 NIKA F 2015 Unknown   10023 01/08/2017 01/08/2018 2018
100060 100060 AXEL M 2017 Chihuahua Crossbreed   10016 09/27/2018 08/27/2019 2018
100061 100061 LILY F 2018 Maltese Crossbreed   11106 09/27/2018 09/27/2019 2018
100062 100062 ROSIE F 2018 Maltese Crossbreed   11106 09/27/2018 09/27/2019 2018
100063 100063 HAROLD M 2004 Cairn Terrier   10028 09/27/2018 09/27/2019 2018
100064 100064 STELLA F 2018 Shih Tzu Crossbreed   11361 09/27/2018 09/27/2019 2018
100065 100065 FOREST F 2015 Unknown   11233 09/27/2018 09/27/2019 2018
100066 100066 FOREST F 2015 Unknown   11233 09/27/2018 09/27/2019 2018
100067 100067 BERNIE M 2017 Yorkshire Terrier   10010 09/27/2018 09/27/2019 2018
100068 100068 SULAVA M 2018 Maltese   11235 09/27/2018 09/27/2019 2018
100069 100069 PERALTA M 2018 Yorkshire Terrier   10009 09/27/2018 09/27/2019 2018
10008 10007 THEODORE M 2013 Toy Fox Terrier   10039 01/08/2017 01/08/2022 2018
100070 100070 SOLORZANO F 2018 Shih Tzu   10033 09/27/2018 09/27/2019 2018
100071 100071 CODY M 2010 Unknown   10306 09/27/2018 11/17/2019 2018
100072 100072 PAULIE M 2010 Yorkshire Terrier   10306 09/27/2018 08/27/2019 2018
100073 100073 CHOCO F 2014 Labrador Retriever   11238 09/27/2018 10/11/2019 2018
100074 100074 MR. M 2009 Chihuahua   10037 09/27/2018 10/03/2019 2018
100075 100075 PINTO M 2011 Dachshund Smooth Coat Miniature   11201 09/27/2018 10/04/2019 2018
100076 100076 MOOCHIE F 2011 Bichon Frise   11101 09/27/2018 09/19/2019 2018
100077 100077 LUCY F 2011 Shih Tzu   11375 09/27/2018 10/07/2019 2018
100078 100078 HEMPSTEAD M 2010 Labrador Retriever Crossbreed   11693 09/27/2018 09/23/2019 2018
100079 100079 BOB M 2005 Bichon Frise   10011 09/27/2018 10/30/2019 2018
10009 10008 PANDA M 2010 Border Collie   11201 01/08/2017 03/20/2018 2018
100080 100080 MILO M 2005 Bichon Frise   10011 09/27/2018 10/30/2019 2018
100081 100081 LILY F 2010 Maltese   11228 09/27/2018 10/25/2019 2018
100082 100082 CHICO M 2015 Havanese   10038 09/27/2018 11/17/2020 2018
100083 100083 SAMANTHA F 2016 American Pit Bull Mix / Pit Bull Mix   10457 09/27/2018 09/12/2019 2018
100084 100084 BELLA F 2013 Shih Tzu   10453 09/27/2018 08/22/2019 2018
100085 100085 FLOPPY M 2014 Shih Tzu   11220 09/27/2018 02/24/2020 2018
100086 100086 SPARKLE F 2009 Maltese   11422 09/27/2018 11/01/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
);