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