nyc_dog_licenses
Data source: New York City Dept. of Mental Health and Hygeine
117,371 rows sorted by LicenseExpiredDate
This data as json, CSV (advanced)
Link | rowid | RowNumber | AnimalName | AnimalGender | AnimalBirthMonth | BreedName | Borough | ZipCode | LicenseIssuedDate | LicenseExpiredDate ▼ | Extract Year |
---|---|---|---|---|---|---|---|---|---|---|---|
3000 | 3000 | 3000 | CHARLIE | F | 2014 | Terrier mix | 10022 | 01/01/2016 | 01/01/2018 | 2018 | |
3167 | 3167 | 3167 | LILY | F | 2014 | Labrador Retriever | 10309 | 01/16/2016 | 01/01/2018 | 2018 | |
8454 | 8454 | 8454 | QUEEN | F | 2005 | Rottweiler Crossbreed | 11236 | 11/07/2016 | 01/01/2018 | 2018 | |
8532 | 8532 | 8532 | PUMA | M | 2010 | English Springer Spaniel | 10025 | 11/12/2016 | 01/01/2018 | 2018 | |
8592 | 8592 | 8592 | CHARLIE | M | 2014 | Irish Wolfhound | 11215 | 11/16/2016 | 01/01/2018 | 2018 | |
8629 | 8629 | 8629 | GINGER | F | 2002 | Jack Russell Terrier | 11360 | 11/18/2016 | 01/01/2018 | 2018 | |
8682 | 8682 | 8682 | TYSON | M | 2014 | American Pit Bull Mix / Pit Bull Mix | 10309 | 11/22/2016 | 01/01/2018 | 2018 | |
8692 | 8692 | 8692 | BUDDY | M | 2007 | Great Pyrenees | 11364 | 11/22/2016 | 01/01/2018 | 2018 | |
8744 | 8744 | 8744 | GEORGE | M | 2015 | Bull Dog, French | 10012 | 11/27/2016 | 01/01/2018 | 2018 | |
8874 | 8874 | 8874 | ARKANTOS | M | 2007 | German Shepherd Dog | 11432 | 12/04/2016 | 01/01/2018 | 2018 | |
9009 | 9009 | 9009 | GINGER | F | 2009 | Golden Retriever | 11230 | 12/09/2016 | 01/01/2018 | 2018 | |
9211 | 9211 | 9211 | MARIA | F | 2005 | Australian Shepherd | 10452 | 12/18/2016 | 01/01/2018 | 2018 | |
9236 | 9236 | 9236 | LOLA | F | 2007 | Pug | 11375 | 12/19/2016 | 01/01/2018 | 2018 | |
9473 | 9473 | 9473 | MAX | M | 2016 | Yorkshire Terrier | 11233 | 01/01/2017 | 01/01/2018 | 2018 | |
9477 | 9477 | 9477 | MILKA | F | 2011 | Golden Retriever | 10038 | 01/01/2017 | 01/01/2018 | 2018 | |
9480 | 9480 | 9480 | KODIAK | F | 2014 | Siberian Husky | 10026 | 01/01/2017 | 01/01/2018 | 2018 | |
9481 | 9481 | 9481 | LYDIE | F | 2016 | Labradoodle | 10003 | 01/01/2017 | 01/01/2018 | 2018 | |
9483 | 9483 | 9483 | WHISKEY | M | 2011 | Boxer | 10032 | 01/01/2017 | 01/01/2018 | 2018 | |
9484 | 9484 | 9484 | DIXIE | F | 2006 | Labrador Retriever | 10011 | 01/01/2017 | 01/01/2018 | 2018 | |
9485 | 9485 | 9485 | MILO | M | 2012 | Beagle | 11104 | 01/01/2017 | 01/01/2018 | 2018 | |
9486 | 9486 | 9486 | HARLEY | F | 2016 | West Highland White Terrier | 10310 | 01/01/2017 | 01/01/2018 | 2018 | |
9488 | 9488 | 9488 | HUDSON | M | 2014 | Cocker Spaniel Crossbreed | 10128 | 01/01/2017 | 01/01/2018 | 2018 | |
9489 | 9489 | 9489 | WIGGLES | F | 2016 | Pomeranian | 10305 | 01/01/2017 | 01/01/2018 | 2018 | |
9493 | 9493 | 9493 | CHEWBACCA | M | 2016 | Yorkshire Terrier Crossbreed | 11234 | 01/01/2017 | 01/01/2018 | 2018 | |
9495 | 9495 | 9495 | ZELDA | F | 2016 | Chihuahua Crossbreed | 11217 | 01/01/2017 | 01/01/2018 | 2018 | |
9496 | 9496 | 9496 | GRETZKY | M | 2010 | Labrador Retriever | 10025 | 01/01/2017 | 01/01/2018 | 2018 | |
9497 | 9497 | 9497 | CHERRY | F | 2016 | American Staffordshire Terrier | 10038 | 01/01/2017 | 01/01/2018 | 2018 | |
9501 | 9501 | 9501 | LILLY | F | 2016 | Chihuahua | 11221 | 01/01/2017 | 01/01/2018 | 2018 | |
9502 | 9502 | 9502 | HUGO | M | 2016 | Havanese | 10128 | 01/01/2017 | 01/01/2018 | 2018 | |
9957 | 9957 | 9956 | BOWIE | M | 2015 | Australian Shepherd | 10461 | 01/07/2017 | 01/01/2018 | 2018 | |
10301 | 10301 | 10301 | FLORENCE | F | 2013 | Tibetan Terrier | 10021 | 01/13/2017 | 01/01/2018 | 2018 | |
10323 | 10323 | 10323 | MABEL | F | 2013 | Tibetan Terrier | 10021 | 01/13/2017 | 01/01/2018 | 2018 | |
11274 | 11274 | 11274 | BAGEL | M | 2007 | Pug | 11377 | 01/26/2017 | 01/01/2018 | 2018 | |
13600 | 13600 | 13600 | POLLIE | F | 2012 | American Pit Bull Terrier/Pit Bull | 11102 | 02/26/2017 | 01/01/2018 | 2018 | |
13954 | 13954 | 13954 | LAYLA | F | 2010 | Dachshund Smooth Coat Miniature | 10075 | 03/01/2017 | 01/01/2018 | 2018 | |
2728 | 2728 | 2728 | MAGGIE | F | 2010 | American Pit Bull Terrier/Pit Bull | 10471 | 11/18/2015 | 01/01/2019 | 2018 | |
2999 | 2999 | 2999 | IZZIE | F | 2011 | Catahoula Leopard Dog | 10023 | 01/01/2016 | 01/01/2019 | 2018 | |
3786 | 3786 | 3786 | DAISY | F | 2011 | Chihuahua | 10302 | 03/13/2016 | 01/01/2019 | 2018 | |
33437 | 33437 | 33435 | APOLLO | M | 2014 | Miniature Pinscher | 10128 | 08/29/2017 | 01/01/2019 | 2018 | |
41430 | 41430 | 41430 | COOPER | M | 2013 | Labrador Retriever Crossbreed | 10065 | 11/11/2017 | 01/01/2019 | 2018 | |
41812 | 41812 | 41812 | BUTTERS | M | 2008 | Pomeranian | 11360 | 11/14/2017 | 01/01/2019 | 2018 | |
42183 | 42183 | 42183 | PUPA | F | 2008 | Cocker Spaniel | 11375 | 11/18/2017 | 01/01/2019 | 2018 | |
42206 | 42206 | 42206 | RITA | F | 2008 | Old English Sheepdog | 11222 | 11/19/2017 | 01/01/2019 | 2018 | |
42329 | 42329 | 42329 | COCO | M | 2006 | Poodle | 10010 | 11/20/2017 | 01/01/2019 | 2018 | |
43749 | 43749 | 43749 | DAISY | F | 2014 | Maltese | 11215 | 12/05/2017 | 01/01/2019 | 2018 | |
43802 | 43802 | 43802 | TYSON | M | 2005 | Yorkshire Terrier | 11215 | 12/05/2017 | 01/01/2019 | 2018 | |
44242 | 44242 | 44241 | LIESL | F | 2008 | Miniature Pinscher | 10075 | 12/08/2017 | 01/01/2019 | 2018 | |
45445 | 45445 | 45445 | SHELBY | F | 2005 | Pomeranian | 11101 | 12/18/2017 | 01/01/2019 | 2018 | |
46762 | 46762 | 46762 | CLEMENTINE | F | 2011 | Unknown | 11215 | 12/31/2017 | 01/01/2019 | 2018 | |
46809 | 46809 | 46809 | HAMILTON | M | 2017 | Boston Terrier | 10021 | 01/01/2018 | 01/01/2019 | 2018 | |
46810 | 46810 | 46810 | NAME NOT PROVIDED | M | 2017 | Poodle | 10466 | 01/01/2018 | 01/01/2019 | 2018 | |
46811 | 46811 | 46811 | NAME NOT PROVIDED | M | 2017 | Cocker Spaniel | 10038 | 01/01/2018 | 01/01/2019 | 2018 | |
46812 | 46812 | 46812 | DUKE | M | 2009 | Bichon Frise Crossbreed | 11211 | 01/01/2018 | 01/01/2019 | 2018 | |
46822 | 46822 | 46822 | ALBY | M | 2017 | Dachshund, Wirehaired | 10028 | 01/01/2018 | 01/01/2019 | 2018 | |
46823 | 46823 | 46823 | NAME NOT PROVIDED | F | 2017 | West High White Terrier | 11104 | 01/01/2018 | 01/01/2019 | 2018 | |
46824 | 46824 | 46824 | BRUCE | M | 2015 | Shiba Inu | 11216 | 01/01/2018 | 01/01/2019 | 2018 | |
46833 | 46833 | 46833 | BRUNO | M | 2015 | Jack Russell Terrier | 10023 | 01/01/2018 | 01/01/2019 | 2018 | |
46834 | 46834 | 46834 | NAME NOT PROVIDED | F | 2017 | Bichon Frise Crossbreed | 11379 | 01/01/2018 | 01/01/2019 | 2018 | |
46835 | 46835 | 46835 | NAME NOT PROVIDED | F | 2017 | Maltese Crossbreed | 11378 | 01/01/2018 | 01/01/2019 | 2018 | |
46836 | 46836 | 46836 | NAME NOT PROVIDED | F | 2017 | German Shepherd Dog | 11377 | 01/01/2018 | 01/01/2019 | 2018 | |
46847 | 46847 | 46847 | PIP | M | 2017 | Boston Terrier | 11106 | 01/01/2018 | 01/01/2019 | 2018 | |
46848 | 46848 | 46848 | SAGE | F | 2016 | Labrador Retriever Crossbreed | 10466 | 01/01/2018 | 01/01/2019 | 2018 | |
46849 | 46849 | 46849 | NAME NOT PROVIDED | M | 2017 | Puggle | 11106 | 01/01/2018 | 01/01/2019 | 2018 | |
46861 | 46861 | 46861 | NAME NOT PROVIDED | M | 2017 | Puggle | 11368 | 01/01/2018 | 01/01/2019 | 2018 | |
46862 | 46862 | 46862 | NAME NOT PROVIDED | F | 2017 | Pomeranian | 11429 | 01/01/2018 | 01/01/2019 | 2018 | |
46863 | 46863 | 46863 | NAME NOT PROVIDED | M | 2017 | Poodle | 10457 | 01/01/2018 | 01/01/2019 | 2018 | |
46864 | 46864 | 46864 | NAME NOT PROVIDED | F | 2017 | Bichon Frise Crossbreed | 10472 | 01/01/2018 | 01/01/2019 | 2018 | |
46877 | 46877 | 46877 | CHIQUITA | F | 2017 | Morkie | 10027 | 01/01/2018 | 01/01/2019 | 2018 | |
46878 | 46878 | 46878 | SMOKEY | M | 2017 | German Shepherd Dog | 10030 | 01/01/2018 | 01/01/2019 | 2018 | |
46879 | 46879 | 46879 | LOUIE | M | 2017 | Labrador Retriever Crossbreed | 10312 | 01/01/2018 | 01/01/2019 | 2018 | |
46880 | 46880 | 46880 | NAME NOT PROVIDED | F | 2017 | Chihuahua | 11379 | 01/01/2018 | 01/01/2019 | 2018 | |
46881 | 46881 | 46881 | NAME NOT PROVIDED | M | 2017 | West High White Terrier | 11368 | 01/01/2018 | 01/01/2019 | 2018 | |
46882 | 46882 | 46882 | NAME NOT PROVIDED | F | 2017 | Beagle | 11414 | 01/01/2018 | 01/01/2019 | 2018 | |
46887 | 46887 | 46887 | ADDIE | F | 2016 | German Shepherd Dog | 10030 | 01/01/2018 | 01/01/2019 | 2018 | |
46903 | 46903 | 46903 | GUS | M | 2017 | Shih Tzu | 10025 | 01/01/2018 | 01/01/2019 | 2018 | |
46904 | 46904 | 46904 | NAME NOT PROVIDED | M | 2017 | Boston Terrier | 11368 | 01/01/2018 | 01/01/2019 | 2018 | |
46905 | 46905 | 46905 | CASTRO | F | 2017 | Maltese | 10453 | 01/01/2018 | 01/01/2019 | 2018 | |
46906 | 46906 | 46906 | EVIE | F | 2016 | Terrier mix | 10002 | 01/01/2018 | 01/01/2019 | 2018 | |
47177 | 47177 | 47176 | CORA | F | 2011 | Welsh Corgi, Pembroke | 10010 | 01/03/2018 | 01/01/2019 | 2018 | |
47415 | 47415 | 47415 | DJ | M | 2016 | Shih Tzu | 11226 | 01/04/2018 | 01/01/2019 | 2018 | |
47418 | 47418 | 47418 | RILEY | F | 2014 | American Pit Bull Terrier/Pit Bull | 11356 | 01/04/2018 | 01/01/2019 | 2018 | |
48686 | 48686 | 48686 | LEX | M | 2010 | West High White Terrier | 11429 | 01/14/2018 | 01/01/2019 | 2018 | |
48790 | 48790 | 48790 | BEAKER | F | 2011 | Unknown | 11215 | 01/15/2018 | 01/01/2019 | 2018 | |
49253 | 49253 | 49253 | BLACK | M | 2008 | Unknown | 11385 | 01/17/2018 | 01/01/2019 | 2018 | |
51379 | 51379 | 51379 | O | M | 2009 | Irish Terrier | 11201 | 01/29/2018 | 01/01/2019 | 2018 | |
51654 | 51654 | 51653 | ROCK | M | 2012 | Beagle Crossbreed | 11373 | 01/30/2018 | 01/01/2019 | 2018 | |
52093 | 52093 | 52093 | ORIEO | F | 2010 | Labrador Retriever Crossbreed | 10465 | 02/03/2018 | 01/01/2019 | 2018 | |
53931 | 53931 | 53930 | TEDDY | M | 2016 | Shih Tzu Crossbreed | 10312 | 02/12/2018 | 01/01/2019 | 2018 | |
54866 | 54866 | 54866 | MOOSE | M | 2016 | Goldendoodle | 11102 | 02/16/2018 | 01/01/2019 | 2018 | |
55857 | 55857 | 55856 | PUMPKIN | F | 2015 | Miniature Schnauzer | 11213 | 02/22/2018 | 01/01/2019 | 2018 | |
68605 | 68605 | 68605 | OTIS | M | 2013 | Shih Tzu | 10023 | 04/25/2018 | 01/01/2019 | 2018 | |
85770 | 85770 | 85770 | PENNY | F | 2009 | Poodle, Toy | 11379 | 07/18/2018 | 01/01/2019 | 2018 | |
567 | 567 | 567 | TIREM | M | 2013 | Australian Shepherd | 10002 | 01/31/2015 | 01/01/2020 | 2018 | |
9476 | 9476 | 9476 | ELLA | F | 2011 | German Shorthaired Pointer | 10150 | 01/01/2017 | 01/01/2020 | 2018 | |
11867 | 11867 | 11867 | CASSIUS | M | 2010 | Cane Corso | 11385 | 02/03/2017 | 01/01/2020 | 2018 | |
46832 | 46832 | 46832 | JAMIE | F | 2007 | Boxer | 11209 | 01/01/2018 | 01/01/2020 | 2018 | |
50522 | 50522 | 50522 | WALTER | M | 2013 | Cardigan Welsh Corgi | 10023 | 01/24/2018 | 01/01/2020 | 2018 | |
108864 | 108864 | 108863 | MAX | M | 2009 | Yorkshire Terrier | 10024 | 11/12/2018 | 01/01/2020 | 2018 | |
109382 | 109382 | 109378 | MILKY | F | 2008 | Maltese | 11374 | 11/14/2018 | 01/01/2020 | 2018 | |
110627 | 110627 | 110627 | JAKE | M | 2015 | German Shepherd Dog | 11423 | 11/23/2018 | 01/01/2020 | 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 );