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 RowNumber

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid RowNumber ▼ AnimalName AnimalGender AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
100087 100087 100087 SIMCOE M 2015 Chihuahua Crossbreed   11217 09/27/2018 10/02/2019 2018
100088 100088 100088 CHOCCO M 2016 Jindo Dog, Korea   10038 09/27/2018 08/29/2019 2018
100089 100089 100089 ARIEL F 2018 Lhasa Apso   11360 09/27/2018 09/27/2019 2018
10010 10010 10009 PENNY F 2014 Unknown   10003 01/09/2017 01/19/2018 2018
100090 100090 100090 BRUNO M 2018 Lhasa Apso   11354 09/27/2018 09/27/2019 2018
100091 100091 100091 UNKNOWN F 2018 Chihuahua   11209 09/27/2018 09/27/2019 2018
100092 100092 100092 OREO M 2018 Havanese   10456 09/27/2018 09/27/2019 2018
100093 100093 100093 COCO F 2018 Cockapoo   11357 09/27/2018 09/27/2019 2018
100094 100094 100094 UNKNOWN M 2018 Pomeranian Crossbreed   11231 09/27/2018 09/27/2019 2018
100095 100095 100095 FLUFFY M 2018 Cotton De Tulear   10453 09/27/2018 09/27/2019 2018
100096 100096 100096 ROCCO M 2018 American Pit Bull Terrier/Pit Bull   11213 09/27/2018 09/27/2019 2018
100097 100097 100097 SPIKE M 2010 Maltese   11422 09/27/2018 11/01/2019 2018
100098 100098 100098 BRANDY F 2018 Greyhound   10019 09/27/2018 09/27/2019 2018
100099 100099 100099 SHREK M 2016 Shiba Inu   10009 09/27/2018 09/27/2019 2018
1001 1001 1001 GATSBY M 2013 American Staffordshire Terrier   10001 04/09/2015 04/09/2020 2018
10011 10011 10010 MILO M 2014 Jack Russell Terrier   11101 01/09/2017 01/09/2018 2018
100100 100100 100100 PEARL F 2017 Chihuahua Crossbreed   10028 09/27/2018 09/27/2019 2018
100101 100101 100101 SASHA F 2009 Shih Tzu   11208 09/27/2018 09/27/2019 2018
100102 100102 100102 UNKNOWN F 2016 American Pit Bull Mix / Pit Bull Mix   11226 09/27/2018 09/27/2019 2018
100103 100103 100103 KOH F 2018 Shih Tzu   10304 09/27/2018 09/27/2019 2018
100104 100104 100104 BLEU F 2013 Boston Terrier   10453 09/27/2018 09/27/2019 2018
100105 100105 100105 LOLA F 2016 Brussels Griffon   11375 09/27/2018 09/27/2020 2018
100106 100106 100106 ONYX M 2009 Unknown   10025 09/27/2018 10/02/2019 2018
100107 100107 100107 ZOE F 2006 Unknown   10025 09/27/2018 09/08/2019 2018
100108 100108 100108 SAM M 2015 Poodle, Toy   10022 09/27/2018 10/14/2019 2018
100109 100109 100109 REMY M 2011 Maltipoo   10010 09/27/2018 02/24/2020 2018
10012 10012 10011 COCO F 2014 Maltese   11212 01/09/2017 01/09/2018 2018
100110 100110 100110 LUNA F 2014 Yorkshire Terrier   11222 09/27/2018 09/03/2019 2018
100111 100111 100111 BELLA F 2002 Bichon Frise   11421 09/27/2018 10/18/2020 2018
100112 100112 100112 DAISY F 2015 Siberian Husky   10019 09/27/2018 10/26/2019 2018
100113 100113 100113 MEG F 2014 Poodle   10017 09/27/2018 05/29/2023 2018
100114 100114 100114 LOLA F 2008 Unknown   11235 09/27/2018 11/17/2019 2018
100115 100115 100115 AMOS M 2007 Cocker Spaniel   11201 09/27/2018 11/16/2019 2018
100116 100116 100116 MOCHI M 2011 Chow Chow   10065 09/27/2018 10/17/2019 2018
100117 100117 100117 CLEOPATRA F 2008 Yorkshire Terrier   10022 09/27/2018 11/09/2019 2018
100118 100118 100118 ROSE F 2014 German Shepherd Dog   10024 09/27/2018 09/27/2019 2018
100119 100119 100119 DAHLIA M 2018 Portuguese Water Dog   11201 09/27/2018 09/27/2019 2018
10013 10013 10012 STELLA F 2015 Pembroke Welsh Corgi Crossbreed   10011 01/09/2017 01/09/2018 2018
100120 100120 100120 NOODLE M 2018 Goldendoodle   11101 09/27/2018 09/27/2019 2018
100121 100121 100121 BROOKLYN F 2018 Beagle Crossbreed   10005 09/27/2018 09/27/2019 2018
100122 100122 100122 TOMMASO M 2018 Pomeranian Crossbreed   11201 09/27/2018 09/27/2019 2018
100123 100123 100123 UNKNOWN M 2018 Pomeranian Crossbreed   10035 09/27/2018 09/27/2019 2018
100124 100124 100124 COCO M 2018 Poodle   11365 09/27/2018 09/27/2019 2018
100125 100125 100125 BINKY M 2017 Yorkshire Terrier   11213 09/27/2018 09/27/2020 2018
100126 100126 100126 SMERGULINEO M 2018 Pomeranian   11234 09/27/2018 09/27/2019 2018
100127 100127 100127 FIGUEROA F 2018 Yorkshire Terrier   10029 09/27/2018 09/27/2019 2018
100128 100128 100128 MAYHEM F 2018 Australian Cattledog   10304 09/27/2018 07/01/2024 2018
100129 100129 100129 PEPITA F 2017 Terrier mix   11210 09/27/2018 08/18/2019 2018
10014 10014 10013 MILO M 2016 French Bulldog   10128 01/09/2017 01/09/2018 2018
100130 100130 100130 ELOISE F 2017 Chihuahua   11231 09/27/2018 09/24/2019 2018
100131 100131 100131 SOOKIE F 2018 American English Coonhound   11415 09/27/2018 09/27/2019 2018
100132 100132 100132 HAILEY F 2013 Australian Shepherd   11361 09/27/2018 09/27/2021 2018
100133 100133 100133 BAILEY M 2005 Silky Terrier   10009 09/27/2018 09/27/2019 2018
100134 100134 100134 ZOOKOE M 2016 Chihuahua Crossbreed   10016 09/27/2018 09/27/2019 2018
100135 100135 100135 PIZZAZZ F 2018 Yorkshire Terrier   10002 09/27/2018 09/27/2019 2018
100136 100136 100136 LOKI M 2018 Pointer   10009 09/27/2018 09/27/2019 2018
100137 100137 100137 BAMBI F 2018 Lhasa Apso   11103 09/27/2018 09/27/2019 2018
100138 100138 100138 DOOBOO M 2016 Bull Dog, English   10016 09/27/2018 09/27/2019 2018
100139 100139 100139 BROWNIE M 2017 Maltese Crossbreed   11222 09/27/2018 09/27/2019 2018
10015 10015 10014 CRICKET F 2005 Bull Dog, French   11201 01/09/2017 01/30/2018 2018
100140 100140 100140 TUCKER M 2017 Unknown   10308 09/27/2018 09/27/2019 2018
100141 100141 100141 TUG M 2007 Italian Greyhound   10002 09/27/2018 11/14/2019 2018
100142 100142 100142 MUNECA F 2014 Cocker Spaniel   11375 09/27/2018 09/07/2019 2018
100143 100143 100143 PENNY F 2011 Unknown   10023 09/27/2018 07/22/2019 2018
100144 100144 100144 FREDDY M 2008 Lhasa Apso   11215 09/27/2018 09/09/2019 2018
100145 100145 100145 B.J. M 2009 Maltese   10026 09/27/2018 09/30/2019 2018
100146 100146 100146 MIKO M 2015 Golden Retriever   10471 09/27/2018 09/09/2019 2018
100147 100147 100147 COCO F 2014 Shih Tzu   11223 09/27/2018 11/20/2020 2018
100148 100148 100148 STEALY M 2011 American Pit Bull Terrier/Pit Bull   10029 09/27/2018 11/16/2019 2018
100149 100149 100149 GUCCI F 2015 American Pit Bull Terrier/Pit Bull   10024 09/27/2018 08/11/2019 2018
10016 10016 10015 BUDDY M 2003 Labrador Retriever   10065 01/09/2017 01/14/2018 2018
100150 100150 100150 FINN M 2014 Golden Retriever   11218 09/27/2018 05/31/2023 2018
100151 100151 100151 SWEEPEA F 2013 Chihuahua   11228 09/27/2018 10/18/2019 2018
100152 100152 100152 REDFORD M 2010 American Pit Bull Terrier/Pit Bull   10029 09/27/2018 01/28/2020 2018
100153 100153 100153 YODA M 2015 Anatolian Shepherd Dog   10065 09/27/2018 09/25/2021 2018
100154 100154 100154 HARRISON M 2013 Shih Tzu   11225 09/27/2018 12/10/2019 2018
100155 100155 100155 STELLA F 2009 Labrador Retriever   10307 09/27/2018 09/27/2019 2018
100156 100156 100156 TALA F 2012 American Pit Bull Mix / Pit Bull Mix   10033 09/27/2018 10/28/2019 2018
100157 100157 100157 CHANEL F 2018 Poodle Crossbreed   10002 09/27/2018 09/27/2019 2018
100158 100158 100158 BAGEL M 2018 Labrador Retriever   11432 09/27/2018 09/27/2019 2018
100159 100159 100159 MANCHA M 2018 Cockapoo   11432 09/27/2018 09/27/2019 2018
10017 10017 10016 MOZZARELLA F 2009 Unknown   11204 01/09/2017 01/24/2018 2018
100160 100160 100160 RAE F 2015 American Staffordshire Terrier   11215 09/27/2018 09/27/2023 2018
100161 100161 100161 LADY F 2013 German Shepherd Crossbreed   11230 09/27/2018 09/27/2019 2018
100162 100162 100162 QUINN M 2018 German Shepherd Dog   11365 09/27/2018 09/27/2019 2018
100163 100163 100163 BELLA F 2010 Pomeranian Crossbreed   10009 09/27/2018 09/27/2020 2018
100164 100164 100164 GIZMO M 2015 Unknown   10301 09/27/2018 09/27/2019 2018
100165 100165 100165 MARYKU F 2007 Shiba Inu   11211 09/27/2018 09/27/2021 2018
100166 100166 100166 KAZAR M 2018 American Pit Bull Terrier/Pit Bull   11213 09/27/2018 09/21/2020 2018
100167 100167 100167 TEDDY M 2018 Shih Tzu Crossbreed   11372 09/27/2018 09/27/2019 2018
100168 100168 100168 KOVU M 2018 Yorkshire Terrier   11232 09/27/2018 09/27/2019 2018
100169 100169 100169 PRINCE M 2018 Cocker Spaniel   11417 09/27/2018 09/27/2019 2018
10018 10018 10017 PHOEBE F 2016 Goldendoodle   10001 01/09/2017 01/09/2018 2018
100170 100170 100170 BELLE F 2018 Goldendoodle   11419 09/27/2018 09/27/2019 2018
100171 100171 100171 SHIRLEY F 2017 German Shepherd Crossbreed   11228 09/27/2018 09/27/2019 2018
100172 100172 100172 UNKNOWN M 2018 Havanese   10040 09/27/2018 09/27/2019 2018
100173 100173 100173 BUDDY M 2018 Yorkshire Terrier   11214 09/27/2018 09/27/2019 2018
100174 100174 100174 UNKNOWN F 2017 Chihuahua Crossbreed   11231 09/27/2018 09/27/2019 2018
100175 100175 100175 JONAS M 2017 Unknown   10457 09/27/2018 09/27/2019 2018
100176 100176 100176 UDON M 2018 Samoyed   10025 09/27/2018 09/27/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
);