nyc_dog_licenses
Data source: New York City Dept. of Mental Health and Hygeine
117,371 rows sorted by LicenseIssuedDate
This data as json, CSV (advanced)
Link | rowid | RowNumber | AnimalName | AnimalGender | AnimalBirthMonth | BreedName | Borough | ZipCode | LicenseIssuedDate ▼ | LicenseExpiredDate | Extract Year |
---|---|---|---|---|---|---|---|---|---|---|---|
2998 | 2998 | 2998 | WEMBLEY | M | 2014 | Labrador Retriever Crossbreed | 11206 | 01/01/2016 | 01/01/2021 | 2018 | |
2999 | 2999 | 2999 | IZZIE | F | 2011 | Catahoula Leopard Dog | 10023 | 01/01/2016 | 01/01/2019 | 2018 | |
3000 | 3000 | 3000 | CHARLIE | F | 2014 | Terrier mix | 10022 | 01/01/2016 | 01/01/2018 | 2018 | |
9473 | 9473 | 9473 | MAX | M | 2016 | Yorkshire Terrier | 11233 | 01/01/2017 | 01/01/2018 | 2018 | |
9474 | 9474 | 9474 | MONTY | M | 2004 | Cavalier King Charles Spaniel | 10025 | 01/01/2017 | 02/08/2018 | 2018 | |
9475 | 9475 | 9475 | EMMIE | F | 2011 | Irish Setter | 10010 | 01/01/2017 | 02/20/2020 | 2018 | |
9476 | 9476 | 9476 | ELLA | F | 2011 | German Shorthaired Pointer | 10150 | 01/01/2017 | 01/01/2020 | 2018 | |
9477 | 9477 | 9477 | MILKA | F | 2011 | Golden Retriever | 10038 | 01/01/2017 | 01/01/2018 | 2018 | |
9478 | 9478 | 9478 | MORGAN | F | 2012 | Unknown | 10025 | 01/01/2017 | 01/21/2018 | 2018 | |
9479 | 9479 | 9479 | CZIKA | F | 2015 | Bichon Frise | 11385 | 01/01/2017 | 02/14/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 | |
9482 | 9482 | 9482 | PATCHES | M | 2011 | Unknown | 11207 | 01/01/2017 | 01/03/2019 | 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 | |
9487 | 9487 | 9487 | MORGAN | F | 2008 | Poodle, Miniature | 11109 | 01/01/2017 | 01/10/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 | |
9490 | 9490 | 9490 | SAMWISE | M | 2012 | Welsh Corgi, Cardigan | 10310 | 01/01/2017 | 02/01/2020 | 2018 | |
9491 | 9491 | 9491 | HARLEY | M | 2015 | Wheaton Terrier | 10025 | 01/01/2017 | 02/09/2018 | 2018 | |
9492 | 9492 | 9492 | JUSTICE | F | 2014 | German Shepherd Dog | 10314 | 01/01/2017 | 01/31/2022 | 2018 | |
9493 | 9493 | 9493 | CHEWBACCA | M | 2016 | Yorkshire Terrier Crossbreed | 11234 | 01/01/2017 | 01/01/2018 | 2018 | |
9494 | 9494 | 9494 | GEOFFREY | M | 2010 | Chihuahua | 10069 | 01/01/2017 | 01/01/2022 | 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 | |
9498 | 9498 | 9498 | BRODY | M | 2013 | Labrador Retriever | 11209 | 01/01/2017 | 02/17/2019 | 2018 | |
9499 | 9499 | 9499 | GUNTHER | M | 2007 | Unknown | 11206 | 01/01/2017 | 04/22/2021 | 2018 | |
9500 | 9500 | 9500 | GRACIE | F | 2013 | Unknown | 10025 | 01/01/2017 | 01/21/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 | |
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 | |
46813 | 46813 | 46813 | PEGASUS | M | 2007 | Maltese | 10462 | 01/01/2018 | 04/08/2018 | 2018 | |
46814 | 46814 | 46814 | CHRISTOPHER | M | 2004 | Chihuahua | 11421 | 01/01/2018 | 02/28/2019 | 2018 | |
46815 | 46815 | 46815 | LINA | F | 2005 | American Pit Bull Terrier/Pit Bull | 10033 | 01/01/2018 | 12/30/2018 | 2018 | |
46816 | 46816 | 46816 | MOTEK | F | 2005 | Unknown | 10033 | 01/01/2018 | 01/03/2019 | 2018 | |
46817 | 46817 | 46817 | AVALANCHE | F | 2010 | Havanese | 10025 | 01/01/2018 | 01/03/2020 | 2018 | |
46818 | 46818 | 46818 | ARCHIE | M | 2010 | Yorkshire Terrier | 11201 | 01/01/2018 | 01/25/2020 | 2018 | |
46819 | 46819 | 46819 | RUBY | F | 2012 | Shih Tzu | 10016 | 01/01/2018 | 02/09/2019 | 2018 | |
46820 | 46820 | 46820 | KONA | F | 2013 | Labrador Retriever | 10023 | 01/01/2018 | 02/18/2019 | 2018 | |
46821 | 46821 | 46821 | ROMEO | M | 2015 | American Pit Bull Mix / Pit Bull Mix | 11106 | 01/01/2018 | 01/04/2020 | 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 | |
46825 | 46825 | 46825 | SASSY | F | 2010 | Labrador Retriever Crossbreed | 10024 | 01/01/2018 | 12/13/2018 | 2018 | |
46826 | 46826 | 46826 | GRACIE | F | 2012 | Unknown | 11362 | 01/01/2018 | 12/06/2018 | 2018 | |
46827 | 46827 | 46827 | ROCKY | M | 2005 | Pug | 10306 | 01/01/2018 | 12/20/2018 | 2018 | |
46828 | 46828 | 46828 | LOLITA | F | 2006 | Chihuahua | 11421 | 01/01/2018 | 06/29/2019 | 2018 | |
46829 | 46829 | 46829 | DAISY | F | 2015 | German Shepherd Crossbreed | 10304 | 01/01/2018 | 01/16/2019 | 2018 | |
46830 | 46830 | 46830 | ROONEY | M | 2015 | Cocker Spaniel | 10016 | 01/01/2018 | 02/20/2019 | 2018 | |
46831 | 46831 | 46831 | MILLIE | F | 2014 | Rat Terrier | 10027 | 01/01/2018 | 12/13/2022 | 2018 | |
46832 | 46832 | 46832 | JAMIE | F | 2007 | Boxer | 11209 | 01/01/2018 | 01/01/2020 | 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 | |
46837 | 46837 | 46837 | MIDNIGHT | M | 2006 | Chihuahua | 10308 | 01/01/2018 | 02/27/2019 | 2018 | |
46838 | 46838 | 46838 | CHEWBACCA | M | 2014 | Collie | 10028 | 01/01/2018 | 02/14/2019 | 2018 | |
46839 | 46839 | 46839 | EINSTEIN | M | 2013 | West High White Terrier | 10308 | 01/01/2018 | 02/27/2019 | 2018 | |
46840 | 46840 | 46840 | GREG | M | 2015 | Cocker Spaniel Crossbreed | 11367 | 01/01/2018 | 12/10/2018 | 2018 | |
46841 | 46841 | 46841 | GUINESS | M | 2007 | Wheaton Terrier | 11356 | 01/01/2018 | 02/08/2019 | 2018 | |
46842 | 46842 | 46842 | BINKS | F | 2003 | Unknown | 10312 | 01/01/2018 | 12/30/2018 | 2018 | |
46843 | 46843 | 46843 | ALLY | F | 2011 | Unknown | 10308 | 01/01/2018 | 02/01/2019 | 2018 | |
46844 | 46844 | 46844 | LOUIE | M | 2009 | Rat Terrier | 10027 | 01/01/2018 | 01/19/2023 | 2018 | |
46845 | 46845 | 46845 | BALISSA | F | 2012 | Whippet | 10024 | 01/01/2018 | 01/19/2019 | 2018 | |
46846 | 46846 | 46846 | RASCAL | M | 2009 | Dachshund, Wirehaired | 11215 | 01/01/2018 | 01/01/2021 | 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 | |
46850 | 46850 | 46850 | LINK | M | 2009 | Akita | 10009 | 01/01/2018 | 01/02/2019 | 2018 | |
46851 | 46851 | 46851 | GINGER | F | 2013 | American Pit Bull Mix / Pit Bull Mix | 10013 | 01/01/2018 | 02/19/2019 | 2018 | |
46852 | 46852 | 46852 | SIMON | M | 2016 | Pug | 11367 | 01/01/2018 | 01/02/2019 | 2018 | |
46853 | 46853 | 46853 | BLIZZARD | M | 2009 | Pomeranian Crossbreed | 11205 | 01/01/2018 | 02/14/2019 | 2018 | |
46854 | 46854 | 46854 | SEAMUS | M | 2006 | Beagle | 11201 | 01/01/2018 | 09/23/2018 | 2018 | |
46855 | 46855 | 46855 | CANDI | F | 2013 | Pomeranian | 10019 | 01/01/2018 | 02/13/2020 | 2018 | |
46856 | 46856 | 46856 | JAVIER | M | 2014 | Chihuahua | 11421 | 01/01/2018 | 02/18/2019 | 2018 | |
46857 | 46857 | 46857 | CHARLEY | F | 2014 | Poodle, Toy | 10013 | 01/01/2018 | 02/19/2023 | 2018 | |
46858 | 46858 | 46858 | LUCY | F | 2010 | American Pit Bull Mix / Pit Bull Mix | 11225 | 01/01/2018 | 12/30/2018 | 2018 | |
46859 | 46859 | 46859 | WAFFLES | M | 2013 | Shih Tzu | 10306 | 01/01/2018 | 01/29/2019 | 2018 | |
46860 | 46860 | 46860 | FIONA | F | 2013 | German Shepherd Crossbreed | 10075 | 01/01/2018 | 02/16/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 | |
46865 | 46865 | 46865 | SAMBUCA | M | 2016 | Labrador Retriever | 11228 | 01/01/2018 | 10/27/2019 | 2018 | |
46866 | 46866 | 46866 | DONUT | F | 2016 | Labrador Retriever Crossbreed | 10466 | 01/01/2018 | 11/05/2018 | 2018 | |
46867 | 46867 | 46867 | SAMMIE | M | 2013 | Pomeranian | 10019 | 01/01/2018 | 02/13/2020 | 2018 | |
46868 | 46868 | 46868 | BONES | M | 2010 | Whippet | 10024 | 01/01/2018 | 01/19/2019 | 2018 | |
46869 | 46869 | 46869 | PICKLES | M | 2012 | Cocker Spaniel | 10024 | 01/01/2018 | 02/09/2019 | 2018 | |
46870 | 46870 | 46870 | DUO | M | 2003 | Unknown | 11367 | 01/01/2018 | 11/29/2018 | 2018 | |
46871 | 46871 | 46871 | HENRY | M | 2008 | Unknown | 10010 | 01/01/2018 | 01/03/2019 | 2018 | |
46872 | 46872 | 46872 | GORDON | M | 2003 | Golden Retriever | 10029 | 01/01/2018 | 11/29/2018 | 2018 | |
46873 | 46873 | 46873 | LUXE | F | 2005 | Chihuahua | 11216 | 01/01/2018 | 12/30/2019 | 2018 | |
46874 | 46874 | 46874 | SNOW | F | 2010 | Maltipoo | 11207 | 01/01/2018 | 01/05/2019 | 2018 | |
46875 | 46875 | 46875 | GUITY | M | 2016 | Maltese | 11233 | 01/01/2018 | 01/04/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 );