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 AnimalGender descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid RowNumber AnimalName AnimalGender ▲ AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
1 1 1 ALI M 2014 Basenji   10013 09/12/2014 09/12/2019 2018
2 2 2 IAN M 2006 Unknown   10013 09/12/2014 10/30/2019 2018
7 7 7 APPLE M 2013 Havanese   10025 09/13/2014 10/16/2019 2018
9 9 9 BENSON M 2010 Boxer   11209 09/13/2014 10/29/2019 2018
10 10 10 BIGS M 2004 American Pit Bull Terrier/Pit Bull   11208 09/13/2014 10/27/2019 2018
14 14 14 OSCAR M 2008 German Shorthaired Pointer   10025 09/13/2014 09/13/2019 2018
15 15 15 BUDDY M 2012 Bull Terrier   10312 09/13/2014 10/05/2019 2018
16 16 16 MAX M 2005 Dachshund, Long Haired   10023 09/14/2014 09/14/2019 2018
18 18 18 DEDE M 2013 Boston Terrier   11236 09/14/2014 09/14/2019 2018
19 19 19 ROCCO M 2010 Chihuahua   10012 09/15/2014 10/04/2019 2018
20 20 20 BLUE M 2008 Collie, Border   10034 09/15/2014 09/24/2019 2018
21 21 21 PEPI M 2004 Unknown   10467 09/15/2014 10/31/2019 2018
22 22 22 BAXTER M 2013 Beagle   11374 09/15/2014 11/21/2019 2018
23 23 23 CHARLIE M 2007 Labrador Retriever   11435 09/16/2014 09/03/2019 2018
24 24 24 KONA M 2008 Shih Tzu   10022 09/16/2014 10/15/2019 2018
25 25 25 TIGGER M 2012 Golden Retriever   10280 09/16/2014 10/31/2019 2018
26 26 26 COOPER M 2011 French Bulldog   10309 09/16/2014 09/16/2019 2018
27 27 27 CHARLIE M 2008 Unknown   10128 09/17/2014 09/16/2019 2018
31 31 31 WALTER M 2010 American Pit Bull Terrier/Pit Bull   11375 09/17/2014 05/17/2019 2018
33 33 33 SMOKEY M 2013 American Staffordshire Terrier   10036 09/18/2014 09/18/2019 2018
35 35 35 PHILLIP M 2011 Maltese   10463 09/18/2014 09/18/2019 2018
38 38 38 WILLIAM M 2011 Maltese   10463 09/18/2014 09/18/2019 2018
39 39 39 APOLLO M 2011 Maltese   10463 09/18/2014 09/18/2019 2018
40 40 40 SNOOPY M 2012 Unknown   10454 09/18/2014 09/06/2019 2018
44 44 44 ANDY M 2010 Chihuahua   11373 09/19/2014 10/17/2019 2018
47 47 47 COOPER M 2008 Labrador Retriever   11201 09/20/2014 09/23/2019 2018
48 48 48 BRUTUS M 2013 Cocker Spaniel   11102 09/20/2014 10/23/2019 2018
53 53 53 CHANCE M 2008 Border Terrier   11234 09/21/2014 09/21/2019 2018
54 54 54 PATCH M 2004 Maltese   10016 09/21/2014 10/02/2019 2018
55 55 55 WOODY M 2010 Unknown   11205 09/21/2014 11/09/2019 2018
59 59 59 SOLO M 2008 American Pit Bull Mix / Pit Bull Mix   11234 09/21/2014 06/10/2019 2018
64 64 64 PARKER M 2014 Beagle Crossbreed   10309 09/23/2014 09/23/2019 2018
66 66 66 JULIUS M 2008 Australian Cattledog   11215 09/23/2014 09/23/2019 2018
67 67 67 BEAR M 2013 Shiba Inu   10014 09/24/2014 09/24/2019 2018
68 68 68 RUMI M 2011 Unknown   10021 09/24/2014 07/31/2018 2018
69 69 69 SPEEDY M 2007 Unknown   11234 09/24/2014 03/29/2019 2018
73 73 73 DEMO M 2009 Havanese   11365 09/25/2014 10/02/2019 2018
74 74 74 CHASE M 2011 Unknown   11414 09/26/2014 02/13/2019 2018
78 78 78 MOJEAU M 2009 Brussels Griffon   10011 09/27/2014 10/14/2019 2018
80 80 80 RANGER M 2014 German Shepherd Dog   11414 09/27/2014 09/27/2019 2018
83 83 83 ROCKY M 2004 Chihuahua   11222 09/29/2014 04/29/2019 2018
84 84 84 OLIVER M 2012 Poodle, Miniature   10019 09/29/2014 09/29/2019 2018
86 86 86 DUKE M 2012 Unknown   10306 09/29/2014 09/06/2019 2018
87 87 87 Q M 2008 Chihuahua   11222 09/29/2014 03/06/2019 2018
88 88 88 COOPER M 2014 Unknown   11222 09/29/2014 09/29/2019 2018
89 89 89 OLIVER M 2014 English Setter   11238 09/30/2014 09/30/2019 2018
90 90 90 WYLIE M 2010 German Shepherd Dog   10014 09/30/2014 09/30/2019 2018
93 93 93 MCHUMBA M 2012 Rhodesian Ridgeback   10306 10/01/2014 10/20/2019 2018
94 94 94 DAYO M 2011 Unknown   10306 10/01/2014 10/02/2019 2018
97 97 97 OZ M 2013 Yorkshire Terrier   10021 10/02/2014 10/02/2018 2018
98 98 98 WINSTON M 2013 Wheaton Terrier   10021 10/02/2014 10/02/2018 2018
101 101 101 BUDDY M 2014 Labrador Retriever Crossbreed   10016 10/04/2014 10/04/2019 2018
103 103 103 BLU M 2014 Cane Corso   11216 10/05/2014 10/05/2019 2018
104 104 104 BUDDY M 2010 Cocker Spaniel   10038 10/05/2014 10/15/2019 2018
107 107 107 BEAR M 2013 Poodle   11215 10/06/2014 10/06/2019 2018
111 111 111 DAX M 2009 Welsh Corgi, Cardigan   10021 10/07/2014 10/07/2019 2018
115 115 115 HENDRIX M 2012 Shih Tzu   11375 10/08/2014 10/08/2019 2018
116 116 116 OTIS M 2011 Labrador Retriever Crossbreed   11231 10/08/2014 06/08/2019 2018
120 120 120 WATSON M 2013 Beagle   11238 10/09/2014 10/10/2019 2018
121 121 121 MURPHY M 2012 Labradoodle   10016 10/09/2014 07/18/2019 2018
125 125 125 DIESEL M 2010 Unknown   11201 10/10/2014 09/19/2019 2018
127 127 127 LUCKY M 2013 Maltese   11101 10/11/2014 10/11/2019 2018
128 128 128 CHARLIE M 2013 Vizsla   10025 10/11/2014 10/11/2019 2018
130 130 130 JASPER M 2010 Jack Russell Terrier   10451 10/11/2014 10/11/2019 2018
131 131 131 FELLA M 2003 Lhasa Apso   10023 10/11/2014 10/11/2019 2018
133 133 133 BODHI M 2005 Unknown   11231 10/11/2014 09/09/2019 2018
136 136 136 SORU M 2010 Labrador Retriever Crossbreed   11238 10/13/2014 10/13/2019 2018
138 138 138 LEROY M 2010 Bull Dog, French   10013 10/13/2014 03/27/2019 2018
139 139 139 SAMMY M 2007 Australian Shepherd   10027 10/14/2014 10/14/2019 2018
140 140 140 GOBI M 2014 Labrador Retriever   10128 10/14/2014 10/14/2019 2018
141 141 141 CHEWBACCA M 2014 German Shepherd Dog   11204 10/14/2014 10/14/2019 2018
144 144 144 CASPER M 2012 Beagle   11414 10/16/2014 02/17/2019 2018
145 145 145 JJYODAA M 2010 Shih Tzu   10314 10/16/2014 10/16/2019 2018
148 148 148 FRITZ M 2005 Schnauzer, Miniature   10009 10/17/2014 10/17/2019 2018
150 150 150 BACON M 2001 Shiba Inu   10002 10/17/2014 10/27/2019 2018
152 152 152 MILEY M 2007 Yorkshire Terrier   10016 10/17/2014 10/17/2019 2018
155 155 155 GUINNESS M 2012 Beagle Crossbreed   11379 10/18/2014 10/18/2019 2018
156 156 156 ROOSEVELT M 2012 Beagle Crossbreed   11379 10/18/2014 10/18/2019 2018
157 157 157 ROSS M 2014 Bichon Frise   11238 10/18/2014 10/18/2019 2018
159 159 159 ELVIS M 2009 Yorkshire Terrier   10035 10/18/2014 10/18/2019 2018
166 166 166 WATSON M 2012 Wheaton Terrier   11215 10/22/2014 10/22/2019 2018
167 167 167 JACKSON M 2014 French Bulldog   10009 10/22/2014 10/22/2019 2018
168 168 168 Q M 2007 Golden Retriever   11238 10/22/2014 08/31/2019 2018
169 169 169 WINSTON M 2005 Norfolk Terrier   10128 10/22/2014 11/30/2019 2018
171 171 171 BENJAMIN M 2011 Unknown   11229 10/23/2014 11/22/2019 2018
172 172 172 CYCLOPSE M 2011 Shih Tzu   11223 10/23/2014 10/23/2019 2018
176 176 176 BUDDY M 2014 Great Dane   10023 10/23/2014 10/23/2019 2018
177 177 177 BRUNO M 2014 Newfoundland   10016 10/24/2014 10/24/2019 2018
178 178 178 MOMO M 2011 Bouvier Des Flandres   11385 10/24/2014 11/04/2019 2018
179 179 179 RIO M 2011 Shih Tzu   10465 10/24/2014 11/10/2019 2018
181 181 181 DUKE M 2008 Unknown   11374 10/24/2014 11/01/2019 2018
184 184 184 LAMBO M 2011 Cavalier King Charles Spaniel   11377 10/24/2014 11/14/2019 2018
185 185 185 HUDSON M 2012 Labrador Retriever   10025 10/24/2014 11/19/2019 2018
186 186 186 FRANK M 2012 Dachshund Smooth Coat   10036 10/24/2014 08/27/2019 2018
187 187 187 QQ M 2011 Unknown   11385 10/24/2014 11/04/2019 2018
190 190 190 JAMPY M 2014 American Pit Bull Mix / Pit Bull Mix   10009 10/25/2014 10/25/2019 2018
192 192 192 JASPER M 2009 Pomeranian   11375 10/25/2014 10/25/2019 2018
193 193 193 LUIGI M 2010 Pomeranian   10009 10/25/2014 10/25/2019 2018
194 194 194 ALFIE M 2009 Welsh Corgi, Pembroke   10003 10/25/2014 08/23/2018 2018
196 196 196 PETTITTE M 2014 Beagle   10003 10/25/2014 10/25/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
);