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 AnimalName

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid RowNumber AnimalName ▼ AnimalGender AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
85276 85276 85276 'RUSTY M 2014 Cavalier King Charles Spaniel   11378 07/16/2018 07/11/2019 2018
98492 98492 98492 (LEELA)LILA F 2005 German Shepherd Crossbreed   10009 09/18/2018 07/30/2019 2018
50837 50837 50837 - M 2017 Havanese   11207 01/26/2018 01/26/2019 2018
11915 11915 11915 -ROY- M 2009 American Pit Bull Mix / Pit Bull Mix   10037 02/04/2017 02/04/2018 2018
4189 4189 4189 0HSO M 2010 Unknown   10010 04/10/2016 04/10/2019 2018
105408 105408 105407 2 M 2007 Maltese   11416 10/25/2018 10/31/2019 2018
49499 49499 49499 90201 M 2014 Maltese   11426 01/18/2018 12/15/2018 2018
12286 12286 12286 A F 2015 Tibetan Mastiff   10472 02/09/2017 02/09/2018 2018
12298 12298 12298 A M 2015 Tibetan Mastiff   10472 02/09/2017 02/09/2018 2018
12311 12311 12311 A F 2015 Tibetan Mastiff   10472 02/09/2017 02/09/2018 2018
17828 17828 17828 A M 2017 Yorkshire Terrier   11214 04/11/2017 04/11/2018 2018
55622 55622 55622 A M 2017 Yorkshire Terrier   11219 02/21/2018 02/21/2019 2018
31885 31885 31885 A.J M 2012 Maltese   11419 08/15/2017 09/25/2018 2018
3426 3426 3426 A.J. M 2013 Unknown   10011 02/12/2016 03/14/2019 2018
93114 93114 93114 A.J. M 2005 Puggle   10308 08/23/2018 07/30/2019 2018
47176 47176 47175 AALIYAH F 2011 Unknown   10027 01/03/2018 02/03/2019 2018
58713 58713 58713 AALIYAH F 2007 Cocker Spaniel   11226 03/07/2018 03/21/2019 2018
104833 104833 104832 AALIYAH M 2016 Siberian Husky   11214 10/22/2018 10/22/2019 2018
110389 110389 110389 AALIYAH F 2003 Rat Terrier   11370 11/20/2018 11/29/2019 2018
2727 2727 2727 AALSKA F 2013 American Eskimo dog   11363 11/18/2015 11/18/2020 2018
106748 106748 106748 AALTO M 2017 Labrador Retriever Crossbreed   11231 11/01/2018 11/01/2019 2018
78738 78738 78738 AAMINA F 2017 Siberian Husky   11207 06/13/2018 06/13/2019 2018
40741 40741 40741 AANG M 2017 Labrador Retriever Crossbreed   11432 11/03/2017 11/03/2018 2018
4955 4955 4955 AARON M 2007 Unknown   11214 05/19/2016 06/25/2018 2018
47107 47107 47107 AARON M 2014 Labrador Retriever   10006 01/03/2018 02/09/2019 2018
64384 64384 64384 AARON M 2016 Chihuahua Crossbreed   10069 04/05/2018 04/05/2019 2018
83797 83797 83797 AARON M 2013 Poodle, Standard   11377 07/09/2018 06/19/2019 2018
87566 87566 87566 AARON M 2009 Labrador Retriever   10033 07/26/2018 07/23/2020 2018
3443 3443 3443 ABACO F 2014 Pug   10036 02/15/2016 02/15/2018 2018
35253 35253 35253 ABACUS M 2015 American Pit Bull Terrier/Pit Bull   10462 09/13/2017 09/13/2018 2018
34747 34747 34747 ABALEEN F 2016 Terrier mix   11201 09/10/2017 09/10/2018 2018
84966 84966 84966 ABANO F 2018 Bichon Frise Crossbreed   11214 07/15/2018 07/15/2019 2018
70 70 70 ABBEY F 2013 Weimaraner   11694 09/25/2014 09/25/2019 2018
551 551 551 ABBEY F 2013 Labrador Retriever   10023 01/27/2015 02/26/2019 2018
1076 1076 1076 ABBEY F 2010 Rhodesian Ridgeback   10025 04/17/2015 04/16/2020 2018
4339 4339 4339 ABBEY F 2011 Labrador Retriever   10009 04/16/2016 04/16/2018 2018
13444 13444 13444 ABBEY F 2005 Rhodesian Ridgeback   10014 02/24/2017 02/03/2018 2018
16128 16128 16128 ABBEY M 2007 Cavalier King Charles Spaniel   10308 03/25/2017 03/25/2018 2018
16897 16897 16896 ABBEY F 2017 English Cocker Spaniel   10128 04/01/2017 03/26/2019 2018
20190 20190 20190 ABBEY F 2013 Brussels Griffon   10001 05/04/2017 06/15/2018 2018
20580 20580 20580 ABBEY F 2011 American Pit Bull Mix / Pit Bull Mix   10314 05/08/2017 06/08/2018 2018
21331 21331 21330 ABBEY F 2006 Shih Tzu   11434 05/16/2017 06/16/2018 2018
38537 38537 38537 ABBEY F 2003 Dalmatian   10065 10/13/2017 10/13/2018 2018
40048 40048 40048 ABBEY F 2009 Pekingese   10308 10/27/2017 12/07/2018 2018
48590 48590 48590 ABBEY F 2004 Unknown   10314 01/13/2018 01/30/2019 2018
49353 49353 49353 ABBEY F 2011 German Shepherd Crossbreed   10309 01/18/2018 02/28/2019 2018
56050 56050 56050 ABBEY F 2017 Airedale Terrier   10306 02/23/2018 03/08/2019 2018
67693 67693 67692 ABBEY F 2015 Miniature Schnauzer   11238 04/21/2018 04/21/2023 2018
85105 85105 85105 ABBEY F 2009 Labrador Retriever Crossbreed   10032 07/16/2018 07/16/2019 2018
89684 89684 89684 ABBEY F 2018 Labrador Retriever   11209 08/04/2018 08/04/2019 2018
90999 90999 90999 ABBEY F 2014 Goldendoodle   11215 08/10/2018 08/10/2019 2018
96222 96222 96222 ABBEY F 2017 Jack Russell Terrier Crossbreed   11102 09/08/2018 09/07/2020 2018
106683 106683 106683 ABBEY F 2010 Unknown   10026 11/01/2018 11/01/2019 2018
111154 111154 111154 ABBEY F 2010 Labrador Retriever Crossbreed   10465 11/26/2018 12/04/2019 2018
115055 115055 115055 ABBEY F 2017 Miniature Schnauzer   10024 12/17/2018 12/17/2023 2018
77359 77359 77359 ABBEYROAD F 2007 Labrador Retriever   10463 06/07/2018 07/27/2019 2018
25059 25059 25059 ABBI F 2016 Terrier Crossbreed   11211 06/19/2017 06/19/2018 2018
27143 27143 27143 ABBI F 2014 American Pit Bull Terrier/Pit Bull   11221 07/10/2017 06/28/2018 2018
31877 31877 31877 ABBI F 2017 Jack Russell Terrier   10308 08/15/2017 08/15/2022 2018
43508 43508 43508 ABBI F 2017 Chihuahua   11216 12/02/2017 12/02/2018 2018
88550 88550 88550 ABBI F 2017 Havanese   11102 07/30/2018 07/30/2019 2018
8241 8241 8241 ABBIE F 2008 Labrador Retriever   11215 10/22/2016 08/30/2021 2018
12242 12242 12242 ABBIE F 2010 Welsh Corgi, Pembroke   10025 02/08/2017 02/07/2020 2018
28062 28062 28062 ABBIE F 2003 Schnauzer, Miniature   11209 07/17/2017 06/29/2018 2018
28492 28492 28492 ABBIE F 2006 Cairn Terrier   10023 07/21/2017 07/27/2019 2018
33377 33377 33376 ABBIE F 2003 Unknown   11379 08/28/2017 10/05/2018 2018
43240 43240 43240 ABBIE F 2008 Golden Retriever   11209 11/29/2017 11/23/2018 2018
48322 48322 48322 ABBIE F 2016 Jack Russell Terrier   11372 01/11/2018 01/20/2019 2018
73496 73496 73496 ABBIE F 2011 Poodle   10039 05/18/2018 05/18/2021 2018
74949 74949 74949 ABBIE F 2015 Unknown   10305 05/25/2018 05/25/2019 2018
82000 82000 82000 ABBIE F 2016 American Pit Bull Terrier/Pit Bull   10451 06/30/2018 06/30/2019 2018
89246 89246 89246 ABBIE F 2012 Chihuahua   10033 08/02/2018 06/30/2019 2018
89827 89827 89827 ABBIE F 2006 Golden Retriever   11231 08/05/2018 08/27/2019 2018
91965 91965 91965 ABBIE F 2009 Welsh Corgi, Pembroke   10027 08/16/2018 08/16/2019 2018
100731 100731 100731 ABBIE F 2003 Unknown   10023 10/01/2018 11/16/2019 2018
101191 101191 101191 ABBIE F 2010 German Shepherd Dog   10308 10/03/2018 11/23/2019 2018
101298 101298 101298 ABBIE F 2005 Pekingese   11224 10/04/2018 09/24/2019 2018
56238 56238 56238 ABBOTT M 2014 Pug   10473 02/24/2018 04/15/2019 2018
76962 76962 76962 ABBOTT M 2014 Unknown   10036 06/05/2018 05/04/2019 2018
1014 1014 1014 ABBY F 2012 Havanese   10009 04/10/2015 05/21/2020 2018
3248 3248 3248 ABBY F 2013 Greyhound   11231 01/25/2016 02/04/2021 2018
3636 3636 3636 ABBY F 2009 Unknown   10025 02/29/2016 03/22/2019 2018
5181 5181 5181 ABBY F 2013 Labrador Retriever Crossbreed   11216 06/03/2016 06/02/2018 2018
6050 6050 6050 ABBY F 2013 Maltese   11354 07/22/2016 09/19/2018 2018
6304 6304 6304 ABBY F 2008 Labrador Retriever   10001 08/01/2016 09/24/2021 2018
6709 6709 6708 ABBY F 2015 English Springer Spaniel   11222 08/14/2016 08/14/2018 2018
6975 6975 6975 ABBY F 2015 French Bulldog   11373 08/23/2016 06/22/2018 2018
7704 7704 7704 ABBY F 2011 Labrador Retriever   10014 09/20/2016 09/05/2019 2018
8895 8895 8895 ABBY F 2012 Miniature Pinscher   10023 12/05/2016 01/14/2018 2018
9992 9992 9991 ABBY F 2013 Boston Terrier   11373 01/08/2017 11/03/2018 2018
10368 10368 10368 ABBY F 2010 Unknown   11385 01/13/2017 01/03/2018 2018
10412 10412 10412 ABBY F 2003 Rat Terrier   10307 01/14/2017 01/14/2018 2018
11096 11096 11096 ABBY F 2010 Yorkshire Terrier   11211 01/24/2017 02/05/2018 2018
11100 11100 11100 ABBY F 2015 Terrier Crossbreed   11104 01/24/2017 01/24/2022 2018
12547 12547 12546 ABBY F 2015 Cavalier King Charles Spaniel   10001 02/13/2017 02/13/2018 2018
12763 12763 12762 ABBY F 2016 Terrier mix   11416 02/16/2017 02/16/2018 2018
14134 14134 14134 ABBY F 2016 German Shepherd Dog   11104 03/03/2017 03/03/2019 2018
14593 14593 14593 ABBY F 2001 Wheaton Terrier   10024 03/08/2017 03/12/2018 2018
14748 14748 14748 ABBY F 2004 Petit Basset Griffon Vendeen   10128 03/09/2017 04/14/2018 2018
15662 15662 15662 ABBY F 2007 Unknown   11211 03/20/2017 03/16/2018 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
);