nyc_dog_licenses
Data source: New York City Dept. of Mental Health and Hygeine
117,371 rows sorted by ZipCode descending
This data as json, CSV (advanced)
Link | rowid | RowNumber | AnimalName | AnimalGender | AnimalBirthMonth | BreedName | Borough | ZipCode ▲ | LicenseIssuedDate | LicenseExpiredDate | Extract Year |
---|---|---|---|---|---|---|---|---|---|---|---|
20545 | 20545 | 20545 | RAVEN | F | 2010 | Affenpinscher | 99508 | 05/08/2017 | 05/08/2019 | 2018 | |
16858 | 16858 | 16858 | KANHA | M | 2016 | Chihuahua Crossbreed | 99202 | 04/01/2017 | 04/01/2018 | 2018 | |
108866 | 108866 | 108865 | BETTY | F | 2007 | American Pit Bull Mix / Pit Bull Mix | 98363 | 11/12/2018 | 12/27/2019 | 2018 | |
108867 | 108867 | 108866 | LUKA | M | 2014 | American Pit Bull Mix / Pit Bull Mix | 98363 | 11/12/2018 | 12/27/2019 | 2018 | |
25538 | 25538 | 25538 | NUTMEG | F | 2008 | Jack Russell Terrier | 98072 | 06/25/2017 | 06/18/2018 | 2018 | |
71063 | 71063 | 71063 | MILLY | F | 2014 | Boxer | 98058 | 05/07/2018 | 04/19/2019 | 2018 | |
23199 | 23199 | 23199 | MATILDA | F | 2016 | Labrador Retriever | 97209 | 06/02/2017 | 06/13/2018 | 2018 | |
33326 | 33326 | 33326 | MOJO | M | 2015 | Havanese | 94117 | 08/28/2017 | 10/24/2018 | 2018 | |
45003 | 45003 | 45003 | LOLA | F | 2015 | Great Pyrenees | 94109 | 12/14/2017 | 12/13/2018 | 2018 | |
11556 | 11556 | 11556 | TOBLERONE | M | 2006 | Labrador Retriever | 90403 | 01/30/2017 | 01/30/2018 | 2018 | |
36473 | 36473 | 36473 | TEDDY | M | 2016 | Shih Tzu | 8830 | 09/22/2017 | 08/31/2018 | 2018 | |
19923 | 19923 | 19923 | JABBA | F | 2007 | Chihuahua | 84108 | 05/02/2017 | 02/02/2018 | 2018 | |
20902 | 20902 | 20902 | OLLIE | M | 2013 | Cavalier King Charles Spaniel | 84014 | 05/12/2017 | 05/12/2018 | 2018 | |
103503 | 103503 | 103503 | TBD | F | 2018 | German Shepherd Dog | 8009 | 10/15/2018 | 10/15/2019 | 2018 | |
85797 | 85797 | 85797 | MAGGIE | F | 2014 | Scottish Deerhound | 7977 | 07/18/2018 | 07/18/2019 | 2018 | |
19559 | 19559 | 19559 | LUCIFER | M | 2016 | Jack Russell Terrier | 78751 | 04/29/2017 | 06/16/2018 | 2018 | |
101237 | 101237 | 101237 | RAGAMUFFIN | M | 2006 | Bichon Frise | 78749 | 10/03/2018 | 10/03/2019 | 2018 | |
98064 | 98064 | 98064 | MILO | M | 2017 | Dachshund | 7733 | 09/17/2018 | 08/01/2019 | 2018 | |
70267 | 70267 | 70267 | LUNA | F | 2015 | Doberman Pinscher | 7728 | 05/03/2018 | 05/01/2019 | 2018 | |
12521 | 12521 | 12520 | NAME NOT PROVIDED | F | 2016 | Maltese Crossbreed | 7650 | 02/12/2017 | 02/12/2018 | 2018 | |
102159 | 102159 | 102159 | DOG | M | 2018 | Shih Tzu | 7606 | 10/08/2018 | 10/08/2019 | 2018 | |
21235 | 21235 | 21235 | MENDOZA | M | 2017 | Schnauzer, Standard | 7601 | 05/15/2017 | 05/15/2018 | 2018 | |
12939 | 12939 | 12939 | MISHA | M | 2007 | Unknown | 7430 | 02/19/2017 | 03/06/2018 | 2018 | |
12949 | 12949 | 12949 | ROSIE | F | 2006 | Unknown | 7430 | 02/19/2017 | 03/06/2018 | 2018 | |
22654 | 22654 | 22654 | JOURNEY | M | 2017 | Labrador Retriever | 7430 | 05/29/2017 | 05/29/2018 | 2018 | |
39506 | 39506 | 39506 | MAPLE | F | 2016 | Unknown | 7307 | 10/23/2017 | 12/15/2018 | 2018 | |
37871 | 37871 | 37871 | RINGO | M | 2012 | Estrela Mountain Dog | 7306 | 10/06/2017 | 10/06/2019 | 2018 | |
99438 | 99438 | 99438 | NAME | F | 2018 | Morkie | 7306 | 09/23/2018 | 09/23/2019 | 2018 | |
11904 | 11904 | 11904 | UNKNOWN | F | 2016 | Maltese Crossbreed | 7304 | 02/03/2017 | 02/03/2018 | 2018 | |
11607 | 11607 | 11607 | CODY | M | 2006 | Shih Tzu | 7302 | 01/31/2017 | 03/24/2018 | 2018 | |
31103 | 31103 | 31103 | YORKIE-POO | M | 2017 | Yorkshire Terrier Crossbreed | 7302 | 08/08/2017 | 08/08/2018 | 2018 | |
62448 | 62448 | 62448 | NAME NOT PROVIDED | M | 2018 | Siberian Husky | 7302 | 03/26/2018 | 03/26/2019 | 2018 | |
79579 | 79579 | 79579 | MORKY | M | 2018 | Yorkshire Terrier | 7093 | 06/17/2018 | 06/17/2019 | 2018 | |
64144 | 64144 | 64144 | MIMI | F | 2015 | Shih Tzu Crossbreed | 7090 | 04/04/2018 | 08/21/2019 | 2018 | |
102189 | 102189 | 102189 | DOG | M | 2018 | Pug | 7087 | 10/08/2018 | 10/08/2019 | 2018 | |
108278 | 108278 | 108277 | HUGO | M | 2017 | Goldendoodle | 7087 | 11/09/2018 | 11/09/2019 | 2018 | |
17328 | 17328 | 17327 | PUCCI | M | 2015 | Chihuahua | 7036 | 04/06/2017 | 03/03/2018 | 2018 | |
15369 | 15369 | 15369 | DUCHESS | F | 2017 | Morkie | 7010 | 03/16/2017 | 03/16/2018 | 2018 | |
103061 | 103061 | 103061 | TBD | M | 2018 | Pug | 7002 | 10/13/2018 | 10/13/2019 | 2018 | |
99526 | 99526 | 99526 | RALPH | M | 2015 | Great Dane | 6901 | 09/24/2018 | 09/24/2019 | 2018 | |
99656 | 99656 | 99656 | DAISY | F | 2006 | Maltese | 6901 | 09/24/2018 | 09/24/2019 | 2018 | |
24405 | 24405 | 24405 | LOLA | F | 2010 | American Staffordshire Terrier | 68164 | 06/13/2017 | 06/12/2018 | 2018 | |
24821 | 24821 | 24821 | ROCKS | M | 2011 | American Pit Bull Mix / Pit Bull Mix | 68164 | 06/17/2017 | 06/17/2018 | 2018 | |
90308 | 90308 | 90308 | POM | M | 2018 | Pomeranian | 6615 | 08/07/2018 | 08/07/2019 | 2018 | |
38513 | 38513 | 38513 | PUG | F | 2014 | Pug | 6518 | 10/12/2017 | 10/12/2019 | 2018 | |
91699 | 91699 | 91699 | KALIFORNIA | M | 2017 | Labrador Retriever | 6473 | 08/15/2018 | 08/15/2019 | 2018 | |
43926 | 43926 | 43926 | SNICKERS | F | 2006 | American Staffordshire Terrier | 6403 | 12/05/2017 | 12/10/2019 | 2018 | |
23792 | 23792 | 23792 | SPARKY | M | 2013 | Schnauzer, Miniature | 60510 | 06/08/2017 | 06/10/2018 | 2018 | |
29016 | 29016 | 29015 | LAIKA | F | 2012 | Unknown | 48375 | 07/25/2017 | 08/24/2018 | 2018 | |
32985 | 32985 | 32985 | DAYTON | M | 2015 | Border Collie | 45822 | 08/24/2017 | 08/24/2020 | 2018 | |
53536 | 53536 | 53536 | DODO | M | 2017 | Goldendoodle | 43210 | 02/10/2018 | 02/10/2019 | 2018 | |
106945 | 106945 | 106945 | PLUTO | M | 2013 | Italian Greyhound | 37209 | 11/02/2018 | 08/27/2019 | 2018 | |
34288 | 34288 | 34288 | WINSTON | M | 2017 | Dachshund, Long Haired Miniature | 37129 | 09/06/2017 | 09/06/2018 | 2018 | |
22083 | 22083 | 22083 | CUCA | F | 2013 | Unknown | 33467 | 05/23/2017 | 04/21/2019 | 2018 | |
19154 | 19154 | 19154 | UNKNOWN | F | 2017 | Yorkshire Terrier | 33456 | 04/25/2017 | 04/25/2018 | 2018 | |
113513 | 113513 | 113513 | ZEUS | M | 2018 | French Bulldog | 33428 | 12/08/2018 | 12/08/2019 | 2018 | |
6580 | 6580 | 6579 | MASON | M | 2010 | Beagle | 33401 | 08/10/2016 | 07/16/2019 | 2018 | |
82252 | 82252 | 82252 | MOLLY | F | 2015 | Labrador Retriever | 33401 | 07/02/2018 | 08/17/2020 | 2018 | |
49775 | 49775 | 49774 | BAILEY | F | 2017 | Border Terrier | 33139 | 01/20/2018 | 01/20/2023 | 2018 | |
6625 | 6625 | 6624 | PIP | F | 2012 | Labrador Retriever Crossbreed | 32819 | 08/11/2016 | 07/31/2018 | 2018 | |
30003 | 30003 | 30003 | MORKIE | M | 2017 | Maltese Crossbreed | 32617 | 08/01/2017 | 08/01/2018 | 2018 | |
13603 | 13603 | 13603 | CHLOE | F | 2009 | Poodle, Toy | 32163 | 02/26/2017 | 06/12/2022 | 2018 | |
103226 | 103226 | 103226 | JUNE | F | 2014 | Beagle | 32043 | 10/14/2018 | 10/19/2019 | 2018 | |
7717 | 7717 | 7717 | MOLLY | F | 2014 | Shih Tzu | 31539 | 09/21/2016 | 08/31/2018 | 2018 | |
13867 | 13867 | 13867 | SPANKY | M | 2008 | Unknown | 28411 | 03/01/2017 | 04/17/2018 | 2018 | |
91935 | 91935 | 91935 | GHOST | M | 2015 | Staffordshire Bull Terrier | 27857 | 08/16/2018 | 08/16/2019 | 2018 | |
20207 | 20207 | 20207 | POLLY | F | 2016 | Golden Retriever | 27707 | 05/05/2017 | 05/05/2018 | 2018 | |
9191 | 9191 | 9191 | BERNIE | M | 2012 | Tibetan Spaniel | 22314 | 12/17/2016 | 01/26/2018 | 2018 | |
89626 | 89626 | 89626 | COMET | M | 2006 | German Shepherd Crossbreed | 18702 | 08/04/2018 | 08/04/2019 | 2018 | |
15875 | 15875 | 15875 | TYSON | M | 2014 | American Pit Bull Mix / Pit Bull Mix | 17046 | 03/22/2017 | 03/22/2018 | 2018 | |
48476 | 48476 | 48476 | NA | F | 2017 | Yorkshire Terrier | 14850 | 01/12/2018 | 01/12/2019 | 2018 | |
2063 | 2063 | 2063 | ASHLEY | F | 2014 | Puggle | 14847 | 08/16/2015 | 08/16/2018 | 2018 | |
88856 | 88856 | 88856 | MIA | F | 2008 | Unknown | 14450 | 07/31/2018 | 05/22/2019 | 2018 | |
73167 | 73167 | 73167 | HERMES | F | 2017 | Cardigan Welsh Corgi | 14221 | 05/16/2018 | 05/16/2019 | 2018 | |
37049 | 37049 | 37049 | DUTCH | M | 2017 | German Shepherd Dog | 14220 | 09/27/2017 | 09/27/2020 | 2018 | |
22494 | 22494 | 22494 | JACKSON | M | 2014 | Shih Tzu | 14216 | 05/27/2017 | 05/26/2018 | 2018 | |
36114 | 36114 | 36114 | BUBBLE | M | 2015 | Poodle | 14207 | 09/19/2017 | 09/19/2018 | 2018 | |
22244 | 22244 | 22244 | BUCK | M | 2016 | German Shepherd Dog | 13637 | 05/24/2017 | 05/24/2018 | 2018 | |
31300 | 31300 | 31300 | MILLY | M | 2016 | Poodle | 13501 | 08/10/2017 | 08/10/2018 | 2018 | |
21207 | 21207 | 21207 | NAME NOT PROVIDED | M | 2017 | Shih Tzu | 13369 | 05/15/2017 | 05/15/2018 | 2018 | |
38890 | 38890 | 38890 | MALTESE | M | 2017 | Maltese | 13202 | 10/17/2017 | 10/17/2018 | 2018 | |
91046 | 91046 | 91046 | LOKI | M | 2015 | American Pit Bull Mix / Pit Bull Mix | 13068 | 08/10/2018 | 08/10/2019 | 2018 | |
90695 | 90695 | 90695 | BEAU | M | 2018 | Havanese | 1305 | 08/08/2018 | 08/08/2019 | 2018 | |
97545 | 97545 | 97545 | MAX | M | 2015 | Maltese | 13045 | 09/13/2018 | 11/01/2018 | 2018 | |
116604 | 116604 | 116604 | PRINCESS | F | 2017 | American Pit Bull Mix / Pit Bull Mix | 13032 | 12/26/2018 | 12/26/2019 | 2018 | |
10243 | 10243 | 10242 | LOTUS | F | 2014 | Miniature Pinscher | 13027 | 01/12/2017 | 01/12/2018 | 2018 | |
50300 | 50300 | 50300 | HUDSON | M | 2017 | Border Collie | 12866 | 01/23/2018 | 01/23/2019 | 2018 | |
104904 | 104904 | 104904 | SIMON | M | 2009 | Poodle | 12866 | 10/22/2018 | 10/22/2019 | 2018 | |
100788 | 100788 | 100788 | LUCAS | M | 2015 | Labrador Retriever | 12790 | 10/01/2018 | 11/24/2019 | 2018 | |
12694 | 12694 | 12693 | JAX | M | 2012 | American Staffordshire Terrier | 12775 | 02/15/2017 | 02/15/2018 | 2018 | |
12716 | 12716 | 12715 | CAPONE | M | 2013 | American Pit Bull Terrier/Pit Bull | 12775 | 02/15/2017 | 02/15/2018 | 2018 | |
98341 | 98341 | 98341 | POMA | F | 2018 | Maltese Crossbreed | 12701 | 09/17/2018 | 09/17/2019 | 2018 | |
15633 | 15633 | 15633 | LADY | F | 2012 | Yorkshire Terrier | 12590 | 03/19/2017 | 03/20/2018 | 2018 | |
56500 | 56500 | 56500 | THUNDER | F | 2013 | German Shepherd Crossbreed | 12590 | 02/26/2018 | 02/26/2020 | 2018 | |
48879 | 48879 | 48879 | AUDREY | F | 2016 | Pomeranian Crossbreed | 12553 | 01/16/2018 | 01/16/2019 | 2018 | |
46749 | 46749 | 46749 | UNKNOWN | M | 2017 | Yorkshire Terrier | 12550 | 12/31/2017 | 12/31/2018 | 2018 | |
57904 | 57904 | 57904 | CHUCHI | M | 2014 | Shih Tzu | 12550 | 03/04/2018 | 04/17/2023 | 2018 | |
48324 | 48324 | 48324 | SEDONA | F | 2012 | American Bully | 12538 | 01/11/2018 | 01/26/2019 | 2018 | |
34827 | 34827 | 34827 | STELLA | F | 2015 | Dachshund | 12533 | 09/11/2017 | 10/28/2018 | 2018 | |
41119 | 41119 | 41119 | KURI | F | 2017 | Shiba Inu | 12401 | 11/08/2017 | 11/08/2018 | 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 );