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

✎ View and edit SQL

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
2 2 2 IAN M 2006 Unknown   10013 09/12/2014 10/30/2019 2018
3 3 3 CHEWBACCA F 2012 Labrador Retriever Crossbreed   10013 09/12/2014 10/01/2019 2018
4 4 4 LOLA F 2006 Miniature Pinscher   10022 09/13/2014 10/03/2019 2018
5 5 5 LUCY F 2014 Dachshund Smooth Coat Miniature   11215 09/13/2014 09/13/2019 2018
6 6 6 JUNE F 2010 Cavalier King Charles Spaniel   11238 09/13/2014 10/28/2019 2018
7 7 7 APPLE M 2013 Havanese   10025 09/13/2014 10/16/2019 2018
8 8 8 MUNECA F 2013 Beagle   11232 09/13/2014 09/13/2019 2018
9 9 9 BENSON M 2010 Boxer   11209 09/13/2014 10/29/2019 2018
10 10 10 BIGS M 2004 American Pit Bull Terrier/Pit Bull   11208 09/13/2014 10/27/2019 2018
11 11 11 SOPHIE F 2011 Boxer   10308 09/13/2014 10/23/2019 2018
12 12 12 ELIZABETH F 2013 Cavalier King Charles Spaniel   10022 09/13/2014 09/13/2019 2018
13 13 13 AVERY F 2014 American Pit Bull Terrier/Pit Bull   10002 09/13/2014 09/13/2019 2018
14 14 14 OSCAR M 2008 German Shorthaired Pointer   10025 09/13/2014 09/13/2019 2018
15 15 15 BUDDY M 2012 Bull Terrier   10312 09/13/2014 10/05/2019 2018
16 16 16 MAX M 2005 Dachshund, Long Haired   10023 09/14/2014 09/14/2019 2018
17 17 17 ELAINE F 2005 Labrador Retriever   10471 09/14/2014 09/14/2019 2018
18 18 18 DEDE M 2013 Boston Terrier   11236 09/14/2014 09/14/2019 2018
19 19 19 ROCCO M 2010 Chihuahua   10012 09/15/2014 10/04/2019 2018
20 20 20 BLUE M 2008 Collie, Border   10034 09/15/2014 09/24/2019 2018
21 21 21 PEPI M 2004 Unknown   10467 09/15/2014 10/31/2019 2018
22 22 22 BAXTER M 2013 Beagle   11374 09/15/2014 11/21/2019 2018
23 23 23 CHARLIE M 2007 Labrador Retriever   11435 09/16/2014 09/03/2019 2018
24 24 24 KONA M 2008 Shih Tzu   10022 09/16/2014 10/15/2019 2018
25 25 25 TIGGER M 2012 Golden Retriever   10280 09/16/2014 10/31/2019 2018
26 26 26 COOPER M 2011 French Bulldog   10309 09/16/2014 09/16/2019 2018
27 27 27 CHARLIE M 2008 Unknown   10128 09/17/2014 09/16/2019 2018
28 28 28 ZOE F 2014 Labrador Retriever   11101 09/17/2014 09/17/2019 2018
29 29 29 BOO F 2013 Labradoodle   11211 09/17/2014 09/17/2019 2018
30 30 30 BELLA F 2012 Yorkshire Terrier   10013 09/17/2014 09/17/2019 2018
31 31 31 WALTER M 2010 American Pit Bull Terrier/Pit Bull   11375 09/17/2014 05/17/2019 2018
32 32 32 POPPETT F 2011 Dachshund, Long Haired Miniature   10024 09/18/2014 09/18/2019 2018
33 33 33 SMOKEY M 2013 American Staffordshire Terrier   10036 09/18/2014 09/18/2019 2018
34 34 34 GIGI F 2009 Poodle, Standard   11201 09/18/2014 09/18/2019 2018
35 35 35 PHILLIP M 2011 Maltese   10463 09/18/2014 09/18/2019 2018
36 36 36 KATE F 2011 Maltese   10463 09/18/2014 09/18/2019 2018
37 37 37 MONEYPENNY F 2014 Chinese Crested   11215 09/18/2014 09/18/2019 2018
38 38 38 WILLIAM M 2011 Maltese   10463 09/18/2014 09/18/2019 2018
39 39 39 APOLLO M 2011 Maltese   10463 09/18/2014 09/18/2019 2018
40 40 40 SNOOPY M 2012 Unknown   10454 09/18/2014 09/06/2019 2018
41 41 41 LISSY F 2010 Chihuahua   11373 09/19/2014 10/17/2019 2018
42 42 42 PENNY F 2013 Labrador Retriever Crossbreed   11217 09/19/2014 09/19/2019 2018
43 43 43 TESLA F 2013 American Pit Bull Terrier/Pit Bull   11237 09/19/2014 09/19/2019 2018
44 44 44 ANDY M 2010 Chihuahua   11373 09/19/2014 10/17/2019 2018
45 45 45 NINA F 2005 Golden Retriever   10023 09/20/2014 09/20/2019 2018
46 46 46 SASHA F 2014 Manchester Terrier   11385 09/20/2014 09/20/2019 2018
47 47 47 COOPER M 2008 Labrador Retriever   11201 09/20/2014 09/23/2019 2018
48 48 48 BRUTUS M 2013 Cocker Spaniel   11102 09/20/2014 10/23/2019 2018
49 49 49 JOCKI F 2008 Unknown   10463 09/20/2014 06/19/2019 2018
50 50 50 ZOEY F 2014 Labradoodle   10301 09/20/2014 09/20/2019 2018
51 51 51 ROSIE F 2013 Labradoodle   10013 09/20/2014 09/20/2019 2018
52 52 52 RIGGINS F 2011 American Pit Bull Mix / Pit Bull Mix   10023 09/21/2014 09/21/2019 2018
53 53 53 CHANCE M 2008 Border Terrier   11234 09/21/2014 09/21/2019 2018
54 54 54 PATCH M 2004 Maltese   10016 09/21/2014 10/02/2019 2018
55 55 55 WOODY M 2010 Unknown   11205 09/21/2014 11/09/2019 2018
56 56 56 JELLY F 2014 German Shepherd Crossbreed   11364 09/21/2014 09/21/2019 2018
57 57 57 ANDY F 2013 Cocker Spaniel   11201 09/21/2014 09/21/2018 2018
58 58 58 ZOE F 2004 Havanese   11231 09/21/2014 10/31/2019 2018
59 59 59 SOLO M 2008 American Pit Bull Mix / Pit Bull Mix   11234 09/21/2014 06/10/2019 2018
60 60 60 STELLA F 2013 Border Collie   11377 09/22/2014 09/22/2019 2018
61 61 61 LEXY F 2007 Yorkshire Terrier   10314 09/22/2014 09/04/2019 2018
62 62 62 DAKOTA F 2014 Vizsla   10003 09/22/2014 09/22/2019 2018
63 63 63 FIONA F 2013 Boston Terrier   10128 09/22/2014 09/22/2019 2018
64 64 64 PARKER M 2014 Beagle Crossbreed   10309 09/23/2014 09/23/2019 2018
65 65 65 STORM F 2012 Labrador Retriever   11209 09/23/2014 10/04/2019 2018
66 66 66 JULIUS M 2008 Australian Cattledog   11215 09/23/2014 09/23/2019 2018
67 67 67 BEAR M 2013 Shiba Inu   10014 09/24/2014 09/24/2019 2018
68 68 68 RUMI M 2011 Unknown   10021 09/24/2014 07/31/2018 2018
69 69 69 SPEEDY M 2007 Unknown   11234 09/24/2014 03/29/2019 2018
70 70 70 ABBEY F 2013 Weimaraner   11694 09/25/2014 09/25/2019 2018
71 71 71 EMMA F 2013 Vizsla   11694 09/25/2014 09/25/2019 2018
72 72 72 LOLA F 2014 Labrador Retriever   10040 09/25/2014 09/25/2019 2018
73 73 73 DEMO M 2009 Havanese   11365 09/25/2014 10/02/2019 2018
74 74 74 CHASE M 2011 Unknown   11414 09/26/2014 02/13/2019 2018
75 75 75 PORK F 2011 Bull Dog, English   10019 09/26/2014 09/26/2019 2018
76 76 76 COCO F 2008 German Shepherd Dog   11221 09/26/2014 09/26/2019 2018
77 77 77 LULU F 2010 Poodle, Miniature   11211 09/26/2014 09/26/2018 2018
78 78 78 MOJEAU M 2009 Brussels Griffon   10011 09/27/2014 10/14/2019 2018
79 79 79 KINLEY F 2012 German Shepherd Dog   11377 09/27/2014 09/27/2019 2018
80 80 80 RANGER M 2014 German Shepherd Dog   11414 09/27/2014 09/27/2019 2018
81 81 81 SHASHI F 2009 Jack Russell Terrier   10021 09/27/2014 09/27/2019 2018
82 82 82 ARCHIE F 2011 Labrador Retriever   10027 09/28/2014 09/28/2019 2018
83 83 83 ROCKY M 2004 Chihuahua   11222 09/29/2014 04/29/2019 2018
84 84 84 OLIVER M 2012 Poodle, Miniature   10019 09/29/2014 09/29/2019 2018
85 85 85 LOKI F 2014 German Shepherd Crossbreed   11231 09/29/2014 09/29/2019 2018
86 86 86 DUKE M 2012 Unknown   10306 09/29/2014 09/06/2019 2018
87 87 87 Q M 2008 Chihuahua   11222 09/29/2014 03/06/2019 2018
88 88 88 COOPER M 2014 Unknown   11222 09/29/2014 09/29/2019 2018
89 89 89 OLIVER M 2014 English Setter   11238 09/30/2014 09/30/2019 2018
90 90 90 WYLIE M 2010 German Shepherd Dog   10014 09/30/2014 09/30/2019 2018
91 91 91 SASHA F 2012 Beagle   10014 09/30/2014 09/30/2019 2018
92 92 92 KUMBUKA F 2010 Rhodesian Ridgeback   10306 10/01/2014 10/22/2019 2018
93 93 93 MCHUMBA M 2012 Rhodesian Ridgeback   10306 10/01/2014 10/20/2019 2018
94 94 94 DAYO M 2011 Unknown   10306 10/01/2014 10/02/2019 2018
95 95 95 OONA F 2013 Yorkshire Terrier   10021 10/02/2014 10/02/2018 2018
96 96 96 FRANNY F 2014 German Shepherd Dog   10011 10/02/2014 10/02/2019 2018
97 97 97 OZ M 2013 Yorkshire Terrier   10021 10/02/2014 10/02/2018 2018
98 98 98 WINSTON M 2013 Wheaton Terrier   10021 10/02/2014 10/02/2018 2018
99 99 99 B F 2013 Unknown   10003 10/03/2014 10/23/2019 2018
100 100 100 LAYLA F 2013 Havanese   10065 10/04/2014 10/04/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
);