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 BreedName

View and edit SQL

Link rowid RowNumber AnimalName AnimalGender AnimalBirthMonth BreedName ▼ Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
6463 6462 CHEWIE M 2012 Affenpinscher   10019 08/07/2016 05/24/2018 2018
7999 7999 IVY F 2012 Affenpinscher   11222 10/07/2016 10/07/2021 2018
8608 8608 ANNIE F 2008 Affenpinscher   10065 11/17/2016 11/17/2018 2018
13841 13841 LOKI F 2011 Affenpinscher   11222 02/28/2017 01/19/2018 2018
17527 17527 COBY M 2016 Affenpinscher   10458 04/08/2017 04/08/2018 2018
19679 19679 PATTY F 2009 Affenpinscher   11692 04/30/2017 04/30/2020 2018
20545 20545 RAVEN F 2010 Affenpinscher   99508 05/08/2017 05/08/2019 2018
22522 22522 DUKEPOMPEY M 2009 Affenpinscher   10037 05/28/2017 05/28/2018 2018
30415 30415 TEDDY M 2009 Affenpinscher   11215 08/04/2017 08/04/2019 2018
33527 33526 NINJA M 2012 Affenpinscher   10029 08/30/2017 10/13/2018 2018
35023 35023 MOGWAI F 2015 Affenpinscher   11374 09/12/2017 09/12/2018 2018
36860 36859 COCO F 2007 Affenpinscher   10011 09/25/2017 09/25/2018 2018
37009 37009 CREEPY F 2015 Affenpinscher   11216 09/27/2017 09/27/2018 2018
37389 37389 OREO F 2016 Affenpinscher   10465 10/01/2017 07/11/2018 2018
45354 45354 MOXIE F 2003 Affenpinscher   10036 12/18/2017 12/18/2018 2018
52122 52122 KUBIAK M 2016 Affenpinscher   11217 02/03/2018 12/27/2020 2018
53444 53444 SPIKE M 2014 Affenpinscher   10462 02/09/2018 01/11/2020 2018
55706 55706 IKE M 2010 Affenpinscher   10026 02/21/2018 02/21/2019 2018
62284 62284 MERLIN M 2013 Affenpinscher   10016 03/25/2018 04/19/2019 2018
68208 68207 DIEGO M 2017 Affenpinscher   10014 04/23/2018 04/23/2019 2018
76994 76994 TINO M 2017 Affenpinscher   11205 06/06/2018 06/06/2023 2018
81579 81579 LIL F 2010 Affenpinscher   10021 06/28/2018 06/28/2019 2018
87543 87543 ULA M 2006 Affenpinscher   10018 07/26/2018 07/07/2019 2018
88733 88733 AFFENPINSCHER M 2018 Affenpinscher   10017 07/31/2018 07/31/2019 2018
89506 89506 WILLOW F 2015 Affenpinscher   11238 08/04/2018 08/04/2023 2018
95193 95191 NORI F 2018 Affenpinscher   11237 09/03/2018 09/03/2019 2018
95890 95890 TESTING M 2017 Affenpinscher   10013 09/06/2018 09/06/2019 2018
101601 101601 BOBBY M 2017 Affenpinscher   10025 10/05/2018 10/12/2019 2018
101723 101723 SPARKY M 2010 Affenpinscher   10023 10/05/2018 10/25/2019 2018
102144 102144 BIGGIE F 2015 Affenpinscher   10005 10/08/2018 02/06/2019 2018
108923 108921 UNKNOWN M 2018 Affenpinscher   10025 11/12/2018 11/12/2019 2018
115198 115198 TINKERBELLE F 2014 Affenpinscher   11694 12/17/2018 02/01/2021 2018
115944 115944 HALEY F 2015 Affenpinscher   11233 12/21/2018 01/14/2020 2018
7431 7431 CLEO F 2014 Afghan Hound   10023 09/10/2016 09/10/2018 2018
11905 11905 NATALIE F 2008 Afghan Hound   11694 02/03/2017 02/03/2019 2018
22269 22269 MAX M 2016 Afghan Hound   10013 05/25/2017 05/25/2020 2018
23858 23858 PICASSO F 2008 Afghan Hound   10021 06/08/2017 07/26/2018 2018
29288 29288 FALCON M 2012 Afghan Hound   10306 07/27/2017 07/27/2022 2018
33347 33346 TROY M 2009 Afghan Hound   10308 08/28/2017 08/31/2019 2018
48953 48953 CARLO M 2013 Afghan Hound   10021 01/16/2018 03/03/2019 2018
53492 53492 DOSIE F 2009 Afghan Hound   11228 02/10/2018 04/16/2019 2018
53573 53573 ZEUS M 2014 Afghan Hound   11228 02/10/2018 04/09/2019 2018
65283 65283 NICK M 2009 Afghan Hound   11385 04/09/2018 05/31/2019 2018
68062 68060 FARRAH F 2009 Afghan Hound   10023 04/23/2018 06/14/2019 2018
68979 68979 CASPER M 2011 Afghan Hound   11207 04/27/2018 01/13/2019 2018
69075 69075 ROBIN M 2013 Afghan Hound   11207 04/27/2018 01/13/2019 2018
77114 77114 INDIE F 2016 Afghan Hound   10021 06/06/2018 06/06/2019 2018
87693 87693 CHLOE F 2011 Afghan Hound   10035 07/27/2018 07/27/2021 2018
88200 88200 GINGER F 2007 Afghan Hound   10473 07/30/2018 08/28/2019 2018
94174 94174 TEST M 2018 Afghan Hound   11385 08/29/2018 08/29/2019 2018
94565 94565 JAZZY F 2008 Afghan Hound   10003 08/30/2018 09/27/2019 2018
99873 99873 SOBHRE F 2006 Afghan Hound   10075 09/25/2018 11/19/2019 2018
30605 30605 STEVIE F 2017 Afghan Hound Crossbreed   11206 08/05/2017 08/05/2022 2018
82735 82735 ABBY F 2014 Afghan Hound Crossbreed   10309 07/04/2018 07/04/2023 2018
89902 89901 DOG M 2018 Afghan Hound Crossbreed   10013 08/05/2018 08/05/2019 2018
95970 95970 TESTING F 2018 Afghan Hound Crossbreed   10013 09/06/2018 09/06/2019 2018
3170 3170 HONDO M 2008 Airedale Terrier   10030 01/17/2016 01/17/2021 2018
3617 3617 AUGIE M 2015 Airedale Terrier   11375 02/27/2016 04/25/2021 2018
5481 5480 MILLIE F 2009 Airedale Terrier   10033 06/23/2016 06/23/2021 2018
6225 6225 LEO M 2013 Airedale Terrier   11201 07/29/2016 09/27/2021 2018
7869 7869 JACK M 2014 Airedale Terrier   10023 10/01/2016 11/08/2021 2018
7898 7898 BUEHLE M 2001 Airedale Terrier   10023 10/01/2016 11/08/2021 2018
18222 18222 HALO F 2017 Airedale Terrier   11234 04/15/2017 04/15/2018 2018
23141 23141 CHEFREE M 2015 Airedale Terrier   11432 06/02/2017 06/21/2019 2018
24162 24162 ATTICUS M 2017 Airedale Terrier   11375 06/12/2017 06/12/2018 2018
25232 25232 PRINCE M 2013 Airedale Terrier   10033 06/21/2017 06/21/2018 2018
27826 27826 JOSIE F 2006 Airedale Terrier   10032 07/16/2017 07/02/2018 2018
28552 28552 CHARLIE F 2015 Airedale Terrier   11218 07/21/2017 07/26/2018 2018
30710 30710 CHANCE M 2011 Airedale Terrier   11412 08/06/2017 08/06/2018 2018
36455 36455 HOWARD M 2017 Airedale Terrier   10019 09/22/2017 09/22/2022 2018
40978 40978 SCOUT F 2014 Airedale Terrier   11217 11/06/2017 11/06/2019 2018
45574 45574 ARIA F 2017 Airedale Terrier   10031 12/19/2017 12/19/2018 2018
46449 46449 COSMOS F 2008 Airedale Terrier   10027 12/28/2017 12/28/2018 2018
50202 50202 HARRY M 2014 Airedale Terrier   10003 01/23/2018 03/09/2019 2018
50531 50531 CLARA F 2014 Airedale Terrier   10009 01/24/2018 01/03/2020 2018
50569 50569 BOBBIE F 2007 Airedale Terrier   10469 01/24/2018 03/13/2019 2018
51786 51784 FLOKI M 2015 Airedale Terrier   10308 01/31/2018 01/31/2019 2018
52348 52348 MAGGIE F 2014 Airedale Terrier   10306 02/05/2018 03/26/2019 2018
54996 54996 RICKY M 2015 Airedale Terrier   11211 02/16/2018 04/06/2019 2018
55008 55008 WRIGLEY M 2014 Airedale Terrier   10307 02/16/2018 02/16/2019 2018
56015 56014 TILDEN F 2015 Airedale Terrier   10023 02/23/2018 02/23/2020 2018
56050 56050 ABBEY F 2017 Airedale Terrier   10306 02/23/2018 03/08/2019 2018
56096 56095 XENA F 2015 Airedale Terrier   10306 02/23/2018 04/15/2020 2018
57668 57668 LOLA F 2013 Airedale Terrier   10017 03/03/2018 04/25/2019 2018
65081 65081 GWEN F 2014 Airedale Terrier   11211 04/09/2018 03/13/2020 2018
65122 65122 UTHER M 2014 Airedale Terrier   11211 04/09/2018 03/13/2020 2018
67373 67372 CADBURY F 2006 Airedale Terrier   10019 04/19/2018 06/09/2019 2018
71633 71633 AMI F 2016 Airedale Terrier   11215 05/09/2018 06/14/2019 2018
74005 74005 BEOWOLF M 2011 Airedale Terrier   11694 05/21/2018 07/09/2019 2018
81036 81036 LIBBY F 2013 Airedale Terrier   10025 06/25/2018 06/25/2019 2018
81492 81492 CEECEE F 2017 Airedale Terrier   10314 06/27/2018 06/27/2019 2018
82764 82764 DOUGLYN F 2018 Airedale Terrier   10128 07/04/2018 07/04/2019 2018
83170 83170 ELSA F 2014 Airedale Terrier   10312 07/06/2018 08/29/2019 2018
85035 85035 BAILEY M 2009 Airedale Terrier   10308 07/16/2018 09/10/2019 2018
85378 85378 KOOPER M 2017 Airedale Terrier   10306 07/17/2018 06/06/2019 2018
87554 87554 SHERMAN M 2011 Airedale Terrier   11105 07/26/2018 08/12/2019 2018
88393 88393 GROVER M 2009 Airedale Terrier   11225 07/30/2018 09/05/2020 2018
88541 88541 DANNY M 2016 Airedale Terrier   10306 07/30/2018 06/18/2019 2018
89706 89706 KOTO M 2017 Airedale Terrier   10011 08/04/2018 08/04/2019 2018
90156 90156 LOKI M 2016 Airedale Terrier   11421 08/06/2018 09/13/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
);