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 sorted by RowNumber descending

View and edit SQL

Link rowid RowNumber ▲ AnimalName AnimalGender AnimalBirthMonth BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
99999 99999 UNKNOWN F 2017 Miniature Schnauzer   11355 09/26/2018 09/26/2019 2018
99998 99998 STEVIE F 2017 Australian Shepherd   10002 09/26/2018 09/26/2023 2018
99997 99997 DAISY F 2016 Beagle   11201 09/26/2018 09/26/2019 2018
99996 99996 TANGO M 2014 Labrador Retriever Crossbreed   10462 09/26/2018 07/10/2020 2018
99995 99995 BAILEY F 2017 Labrador Retriever Crossbreed   10028 09/26/2018 10/19/2019 2018
99994 99994 CHICKEN F 2017 Golden Retriever   11109 09/26/2018 10/19/2023 2018
99993 99993 COSMO M 2012 Boston Terrier   10032 09/26/2018 09/26/2021 2018
99992 99992 LILLY F 2017 Wheaton Terrier   10069 09/26/2018 09/26/2019 2018
99991 99991 BELLE F 2016 Poodle Crossbreed   10001 09/26/2018 09/26/2021 2018
99990 99990 UNKNOWN F 2018 Schnauzer Crossbreed   11220 09/26/2018 09/26/2019 2018
10000 9999 ROMEO M 2011 Shih Tzu Crossbreed   11206 01/08/2017 01/08/2018 2018
99989 99989 UNKNOWN M 2018 Yorkshire Terrier   11355 09/26/2018 09/26/2019 2018
99988 99988 UNKNOWN M 2018 German Shepherd Dog   11358 09/26/2018 09/26/2019 2018
99987 99987 PENNY F 2018 Goldendoodle   10307 09/26/2018 09/26/2019 2018
99986 99986 STORMY M 2012 Beagle Crossbreed   10032 09/26/2018 11/16/2019 2018
99985 99985 SCOUT F 2015 Labrador Retriever   10035 09/26/2018 11/10/2019 2018
99984 99984 MOLLY F 2010 Unknown   10013 09/26/2018 05/09/2020 2018
99983 99983 TAZ F 2009 Maltese   10128 09/26/2018 11/04/2019 2018
99982 99982 MOLI F 2011 American Pit Bull Mix / Pit Bull Mix   10009 09/26/2018 07/25/2019 2018
99981 99981 GIZMO M 2009 Shih Tzu   11220 09/26/2018 08/01/2020 2018
99980 99980 CALI F 2013 Golden Retriever   10023 09/26/2018 11/03/2019 2018
9999 9998 GINA F 2013 Labrador Retriever Crossbreed   10040 01/08/2017 02/19/2018 2018
99979 99979 OTTO M 2013 Unknown   10019 09/26/2018 11/20/2019 2018
99978 99978 MAGGIE F 2006 Poodle, Toy   11201 09/26/2018 10/19/2019 2018
99977 99977 MINNIE F 2005 Chihuahua   10026 09/26/2018 10/02/2019 2018
99976 99976 GIUSEPPE M 2015 Maltese   10038 09/26/2018 10/20/2019 2018
99975 99975 DAISY F 2013 Labrador Retriever Crossbreed   11101 09/26/2018 10/30/2019 2018
99974 99974 HUDSON M 2014 American Pit Bull Terrier/Pit Bull   11694 09/26/2018 08/14/2019 2018
99973 99973 RASHEEDA F 2011 Unknown   11201 09/26/2018 09/26/2019 2018
99972 99972 UNKNOWN M 2018 Pug Crossbreed   10467 09/26/2018 09/26/2019 2018
99971 99971 ASPEN M 2013 Maltese Crossbreed   11374 09/26/2018 09/26/2019 2018
99970 99970 BARRY M 2009 Chihuahua Crossbreed   10037 09/26/2018 09/26/2019 2018
9998 9997 TOBY M 2015 Labrador Retriever   11238 01/08/2017 12/15/2018 2018
99969 99969 UNKNOWN M 2018 Maltese   11351 09/26/2018 09/26/2019 2018
99968 99968 UNKNOWN M 2018 Siberian Husky   10453 09/26/2018 09/26/2019 2018
99967 99967 UNKNOWN M 2018 Shih Tzu   11365 09/26/2018 09/26/2019 2018
99966 99966 UNKNOWN M 2018 Yorkshire Terrier   11207 09/26/2018 09/26/2019 2018
99965 99965 MILO M 2016 Shih Tzu   10466 09/26/2018 07/19/2019 2018
99964 99964 SHEA M 2017 Poodle   10022 09/26/2018 09/26/2023 2018
99963 99963 PENNY F 2018 Bull Dog, American   10033 09/26/2018 09/26/2019 2018
99962 99962 CHUKO M 2018 Rottweiler   10301 09/26/2018 09/26/2019 2018
99961 99961 JETER M 2017 Unknown   11224 09/26/2018 09/26/2019 2018
99960 99960 COOKIE M 2016 Great Dane   11220 09/26/2018 09/26/2019 2018
9997 9996 ZOOEY F 2007 French Bulldog   11215 01/08/2017 01/08/2018 2018
99959 99959 UNKNOWN F 2018 Shih Tzu   11368 09/26/2018 09/26/2019 2018
99958 99958 BELLA F 2018 Labrador Retriever   11004 09/26/2018 09/26/2023 2018
99957 99957 ICHIRO F 2018 Shiba Inu   10456 09/26/2018 09/26/2019 2018
99956 99956 DIDEROT M 2011 Maltese   11249 09/26/2018 08/19/2019 2018
99955 99955 DUNCAN M 2012 Unknown   10023 09/26/2018 10/29/2019 2018
99954 99954 ELLA F 2013 American Pit Bull Mix / Pit Bull Mix   11206 09/26/2018 04/17/2019 2018
99953 99953 NILBERT M 2007 Shetland Sheepdog   10128 09/26/2018 08/27/2019 2018
99952 99952 SWEETIE F 2014 Beagle Crossbreed   10461 09/26/2018 11/04/2019 2018
99951 99951 BEN M 2016 Poodle   10011 09/26/2018 04/18/2019 2018
99950 99950 NITRO M 2004 Pomeranian   10029 09/26/2018 09/05/2019 2018
9996 9995 LUNA F 2016 French Bulldog   10011 01/08/2017 01/08/2020 2018
99949 99949 BAJJI M 2011 Unknown   11205 09/26/2018 11/16/2019 2018
99948 99948 STELLA F 2012 Boxer   11238 09/26/2018 10/30/2019 2018
99947 99947 DAX M 2016 Cocker Spaniel Crossbreed   11361 09/26/2018 04/25/2019 2018
99946 99946 YOFI M 2012 Puggle   10065 09/26/2018 11/14/2019 2018
99945 99945 BAXTER M 2006 Puggle   11379 09/26/2018 09/26/2019 2018
99944 99944 MORRIS M 2011 Labradoodle   11215 09/26/2018 09/26/2019 2018
99943 99943 MATILDA F 2010 Dachshund, Wirehaired, Miniature   11375 09/26/2018 09/26/2020 2018
99942 99942 ARMANY F 2018 Yorkshire Terrier   11204 09/26/2018 09/26/2019 2018
99941 99941 KITTY F 2011 Pug   10028 09/26/2018 09/26/2023 2018
99940 99940 UNKNOWN M 2018 Pembroke Welsh Corgi   11211 09/26/2018 09/26/2019 2018
9995 9994 AMBER F 2008 Beagle Crossbreed   11215 01/08/2017 01/08/2018 2018
99939 99939 UNKNOWN M 2018 Maltipoo   11355 09/26/2018 09/26/2019 2018
99938 99938 GORDON M 2017 Labrador Retriever Crossbreed   10065 09/26/2018 10/23/2019 2018
99937 99937 COCO F 2016 Chihuahua Crossbreed   10458 09/26/2018 09/19/2020 2018
99936 99936 MILOU F 2017 Miniature Schnauzer   10028 09/25/2018 09/27/2019 2018
99935 99935 LUNA F 2016 Australian Cattledog   10465 09/25/2018 09/21/2019 2018
99934 99934 MANUEL M 2015 Pug   10003 09/25/2018 11/18/2019 2018
99933 99933 ITALIAN F 2017 Italian Greyhound   10128 09/25/2018 10/31/2019 2018
99932 99932 POOKI F 2013 Cockapoo   11201 09/25/2018 09/25/2023 2018
99931 99931 TAFFY F 2017 Shih Tzu   11415 09/25/2018 09/25/2019 2018
99930 99930 ALBERT M 2013 Labrador Retriever   10019 09/25/2018 09/25/2019 2018
9994 9993 GARAY M 2016 Pomeranian   11214 01/08/2017 01/08/2018 2018
99929 99929 BLUE M 2018 American Pit Bull Mix / Pit Bull Mix   11417 09/25/2018 09/25/2019 2018
99928 99928 DAISY F 2018 Terrier mix   10301 09/25/2018 09/25/2019 2018
99927 99927 OREO M 2014 Border Collie Crossbreed   11101 09/25/2018 09/25/2019 2018
99926 99926 DOLCE F 2013 Unknown   10314 09/25/2018 09/25/2019 2018
99925 99925 FRANKIE M 2017 Unknown   10474 09/25/2018 09/25/2019 2018
99924 99924 KOBI M 2018 Bichon Frise   11103 09/25/2018 09/25/2019 2018
99923 99923 YADI F 2018 Yorkshire Terrier Crossbreed   11205 09/25/2018 09/25/2019 2018
99922 99922 CASHEW M 2018 Staffordshire Bull Terrier   10025 09/25/2018 09/25/2019 2018
99921 99921 BOLEYN F 2010 Bull Dog, English   10019 09/25/2018 10/10/2019 2018
99920 99920 SELENE F 2014 German Shepherd Dog   10463 09/25/2018 10/02/2019 2018
9993 9992 OTTO M 2016 Chow Chow   11216 01/08/2017 01/08/2018 2018
99919 99919 KAILY F 2013 Schnauzer, Miniature   10459 09/25/2018 09/19/2019 2018
99918 99918 WILLA F 2000 Shih Tzu   10128 09/25/2018 07/30/2019 2018
99917 99917 EDDIE M 2006 Lhasa Apso   10033 09/25/2018 11/18/2020 2018
99916 99916 CORY M 2009 Cavalier King Charles Spaniel   10065 09/25/2018 10/30/2020 2018
99915 99915 SNOOKIE F 2010 Maltese   11379 09/25/2018 10/17/2019 2018
99914 99914 DOT F 2015 Labradoodle   11231 09/25/2018 11/20/2019 2018
99913 99913 CALLIE F 2013 Maltese   11357 09/25/2018 11/20/2019 2018
99912 99912 SNUGGLES M 2006 Unknown   10039 09/25/2018 09/04/2019 2018
99911 99911 BUDDY M 2006 Shih Tzu   11366 09/25/2018 09/30/2019 2018
99910 99910 MUNCHKIN F 2007 Unknown   10001 09/25/2018 09/02/2019 2018
9992 9991 ABBY F 2013 Boston Terrier   11373 01/08/2017 11/03/2018 2018
99909 99909 TAZ M 2014 Pug   11378 09/25/2018 08/26/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
);