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

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid RowNumber AnimalName AnimalGender AnimalBirthMonth ▲ BreedName Borough ZipCode LicenseIssuedDate LicenseExpiredDate Extract Year
101817 101817 101817 LOLA F 917 Labrador Retriever Crossbreed   11417 10/05/2018 06/03/2023 2018
64850 64850 64850 KOKO F 816 Collie Crossbreed   11235 04/08/2018 04/08/2020 2018
85938 85938 85938 LENNY M 8 Miniature Schnauzer   11205 07/19/2018 07/19/2019 2018
109878 109878 109878 MOCHI F 218 Welsh Terrier   10029 11/17/2018 11/17/2019 2018
50891 50891 50891 JASPER M 217 Labrador Retriever Crossbreed   10023 01/26/2018 01/26/2019 2018
81533 81533 81533 ORION M 217 German Shorthaired Pointer   11235 06/27/2018 06/27/2019 2018
40301 40301 40301 DOG F 2018 Yorkshire Terrier   11370 10/30/2017 10/30/2018 2018
47200 47200 47199 LEEO M 2018 Yorkshire Terrier Crossbreed   10026 01/03/2018 01/03/2019 2018
49107 49107 49107 LUCY F 2018 Schnauzer Crossbreed   10013 01/17/2018 01/17/2019 2018
51000 51000 51000 BAYLEY M 2018 Cocker Spaniel Crossbreed   10470 01/27/2018 01/27/2020 2018
53793 53793 53793 COQUETA F 2018 Yorkshire Terrier   10461 02/11/2018 02/11/2019 2018
54152 54152 54152 APOLLO M 2018 American Pit Bull Terrier/Pit Bull   11210 02/13/2018 02/13/2019 2018
54871 54871 54871 SYBIL F 2018 Chihuahua Crossbreed   11218 02/16/2018 02/16/2019 2018
55197 55197 55196 WYNNIE F 2018 Golden Retriever   11109 02/18/2018 02/18/2019 2018
55495 55495 55495 RYDER F 2018 Siberian Husky   10028 02/20/2018 02/20/2019 2018
56983 56983 56983 GREY M 2018 American Bully   10029 02/27/2018 02/27/2019 2018
57086 57086 57086 CHIEF M 2018 Rottweiler   10463 02/28/2018 02/28/2019 2018
57090 57090 57090 DRAKO M 2018 Maltipoo   10467 02/28/2018 02/28/2019 2018
57220 57220 57220 CHARLI F 2018 Goldendoodle   11201 03/01/2018 03/01/2019 2018
57277 57277 57277 FOXY F 2018 Chihuahua   11204 03/01/2018 03/01/2019 2018
57302 57302 57302 FINNEGAN M 2018 Labradoodle   11211 03/01/2018 03/01/2019 2018
57409 57409 57409 BUBBLES F 2018 Maltipoo   10475 03/02/2018 03/02/2019 2018
57443 57443 57443 TITAN M 2018 Silky Terrier   11211 03/02/2018 03/02/2019 2018
57494 57494 57494 JAKE M 2018 Labrador Retriever   11234 03/02/2018 03/02/2019 2018
57704 57704 57704 WINNIE F 2018 Goldendoodle   10003 03/03/2018 03/03/2019 2018
57772 57772 57772 MABLE F 2018 Beagle Crossbreed   10009 03/04/2018 03/04/2019 2018
57927 57927 57927 COOKIE M 2018 Yorkshire Terrier   11220 03/04/2018 03/04/2019 2018
57928 57928 57928 MARLA F 2018 Labrador Retriever Crossbreed   10065 03/04/2018 03/04/2019 2018
58038 58038 58038 DOBBY M 2018 Dachshund Crossbreed   10023 03/05/2018 03/05/2019 2018
58097 58097 58097 CHET M 2018 Labradoodle   10023 03/05/2018 03/05/2019 2018
58171 58171 58171 ROXY F 2018 Chihuahua   11206 03/05/2018 03/05/2019 2018
58207 58207 58207 YOGI M 2018 Bernese Mountain Dog   10011 03/05/2018 03/05/2019 2018
58413 58413 58412 STARR F 2018 Unknown   11413 03/06/2018 03/06/2019 2018
58454 58454 58453 PIO M 2018 Yorkshire Terrier   10026 03/06/2018 03/06/2019 2018
58546 58546 58546 MAX M 2018 Labrador Retriever   11234 03/06/2018 03/06/2019 2018
58609 58609 58609 NOMI F 2018 Miniature Australian Shepherd   10018 03/06/2018 03/06/2019 2018
58650 58650 58650 SASHA F 2018 German Shepherd Dog   11373 03/07/2018 03/07/2019 2018
58658 58658 58658 SINATRA M 2018 Dachshund Smooth Coat Miniature   11105 03/07/2018 03/07/2019 2018
58981 58981 58981 BILENKIS M 2018 Yorkshire Terrier   11235 03/09/2018 03/09/2019 2018
59046 59046 59046 SAVANNAH F 2018 American Pit Bull Terrier/Pit Bull   11209 03/09/2018 03/09/2019 2018
59058 59058 59058 HINES M 2018 Havanese   10310 03/09/2018 03/09/2019 2018
59144 59144 59144 WARD F 2018 Yorkshire Terrier   10458 03/09/2018 03/09/2019 2018
59184 59184 59184 SONNY M 2018 Labradoodle   10025 03/09/2018 03/09/2019 2018
59189 59189 59189 ACEVEDO M 2018 Maltese   11229 03/09/2018 03/09/2019 2018
59224 59224 59224 JONAH M 2018 Yorkshire Terrier   11208 03/09/2018 03/09/2019 2018
59269 59269 59269 BOSZCZYK F 2018 Yorkshire Terrier   11692 03/09/2018 03/09/2019 2018
59271 59271 59271 HICKSON M 2018 Yorkshire Terrier   11691 03/09/2018 03/09/2019 2018
59273 59273 59273 VENICE F 2018 American Pit Bull Terrier/Pit Bull   11209 03/09/2018 03/09/2019 2018
59326 59326 59326 TUCKER M 2018 German Shorthaired Pointer   11229 03/10/2018 03/10/2019 2018
59352 59352 59352 GROOT M 2018 Shih Tzu Crossbreed   10002 03/10/2018 03/10/2019 2018
59395 59395 59395 CLOVER F 2018 Labrador Retriever   10031 03/10/2018 03/10/2019 2018
59434 59434 59434 NOT M 2018 Beagle   11432 03/10/2018 03/10/2019 2018
59437 59437 59437 BROOKLYN M 2018 Unknown   11374 03/11/2018 03/11/2019 2018
59499 59499 59499 PEPPER F 2018 Pomeranian   11101 03/11/2018 03/11/2019 2018
59501 59501 59501 PUPPY F 2018 Yorkshire Terrier   10309 03/11/2018 03/11/2019 2018
59545 59545 59545 ROSIE F 2018 Yorkshire Terrier Crossbreed   11224 03/11/2018 03/11/2019 2018
59643 59643 59643 BROWNY F 2018 Beagle   11385 03/12/2018 03/12/2019 2018
59659 59659 59659 THEO M 2018 Cavalier King Charles Spaniel   11231 03/12/2018 03/12/2019 2018
59723 59723 59723 KIM M 2018 Poodle Crossbreed   11362 03/12/2018 03/12/2019 2018
59765 59765 59765 NAME F 2018 Pembroke Welsh Corgi   11372 03/12/2018 03/12/2019 2018
59941 59941 59941 DIEGO M 2018 Unknown   11417 03/13/2018 03/13/2019 2018
60023 60023 60022 PIPPA F 2018 Miniature Pinscher   11209 03/13/2018 03/13/2019 2018
60025 60025 60024 UNKNOWN F 2018 Poodle Crossbreed   10308 03/13/2018 03/13/2019 2018
60103 60103 60103 EDISON M 2018 Australian Shepherd   11205 03/13/2018 03/13/2023 2018
60105 60105 60105 UNKNOWN M 2018 Havanese   10309 03/13/2018 03/13/2019 2018
60179 60179 60179 CHARLIE M 2018 Chihuahua   10467 03/13/2018 03/13/2019 2018
60222 60222 60222 FUNNY F 2018 Wire Fox Terrier   10036 03/14/2018 03/14/2019 2018
60231 60231 60231 RILEY M 2018 Australian Shepherd   11213 03/14/2018 03/14/2019 2018
60233 60233 60233 SAPPHIRE F 2018 Yorkshire Terrier   10456 03/14/2018 03/14/2019 2018
60268 60268 60268 VADER M 2018 French Bulldog   11201 03/14/2018 03/14/2019 2018
60271 60271 60271 UNKNOWN M 2018 Yorkshire Terrier Crossbreed   11417 03/14/2018 03/14/2019 2018
60279 60279 60279 VELVET F 2018 Yorkshire Terrier   11234 03/14/2018 03/14/2019 2018
60280 60280 60280 NANGSA F 2018 Yorkshire Terrier   11377 03/14/2018 03/14/2019 2018
60347 60347 60347 MOOKIE M 2018 Siberian Husky Crossbreed   10306 03/14/2018 03/14/2019 2018
60398 60398 60398 LOLA F 2018 Dalmatian   10028 03/15/2018 03/15/2019 2018
60462 60462 60462 ROSCOE M 2018 Shiba Inu   11231 03/15/2018 03/15/2019 2018
60509 60509 60509 DUCK M 2018 Nova Scotia Duck Tolling Retriever   11201 03/15/2018 03/15/2019 2018
60519 60519 60519 HUGO M 2018 Shiba Inu   10038 03/15/2018 03/15/2019 2018
60588 60588 60588 HUGGINS M 2018 Pomeranian   11238 03/16/2018 03/16/2019 2018
60589 60589 60589 MELO M 2018 Yorkshire Terrier   10457 03/16/2018 03/16/2019 2018
60612 60612 60612 NAME M 2018 Labrador Retriever   11234 03/16/2018 03/16/2019 2018
60617 60617 60617 MARCUCCI F 2018 Maltese   10301 03/16/2018 03/16/2019 2018
60663 60663 60663 PENNY F 2018 Yorkshire Terrier   10314 03/16/2018 03/16/2019 2018
60672 60672 60672 JAZZY F 2018 Maltese   10460 03/16/2018 03/16/2019 2018
60674 60674 60674 BAIN M 2018 Yorkshire Terrier   10467 03/16/2018 03/16/2019 2018
60688 60688 60688 MOONY M 2018 Poodle Crossbreed   10016 03/16/2018 03/16/2019 2018
60755 60755 60755 TWINKLE F 2018 Yorkshire Terrier   11206 03/16/2018 03/16/2019 2018
60770 60770 60770 GIULIANO M 2018 Chihuahua   11234 03/17/2018 03/17/2019 2018
60794 60794 60794 BELLA F 2018 Yorkshire Terrier   11434 03/17/2018 03/17/2019 2018
60795 60795 60795 NOT F 2018 Yorkshire Terrier   11418 03/17/2018 03/17/2019 2018
60819 60819 60819 SASSY M 2018 Goldendoodle   11201 03/17/2018 03/17/2019 2018
60837 60837 60837 EMMANUELE F 2018 Yorkshire Terrier   10312 03/17/2018 03/17/2019 2018
60841 60841 60841 ROSITA F 2018 Chihuahua   10312 03/17/2018 03/17/2019 2018
60847 60847 60847 LIBBY F 2018 Poodle, Toy   10029 03/17/2018 03/17/2019 2018
60849 60849 60849 PUPPY M 2018 Yorkshire Terrier   10029 03/17/2018 03/17/2019 2018
60866 60866 60866 PANCAKE F 2018 Cardigan Welsh Corgi   11211 03/17/2018 03/17/2019 2018
60868 60868 60868 APOLLO M 2018 Siberian Husky   10025 03/17/2018 03/17/2019 2018
60873 60873 60873 MJ M 2018 Yorkshire Terrier   10457 03/17/2018 03/17/2019 2018
60878 60878 60878 KEEGAN M 2018 Golden Retriever   10025 03/17/2018 03/17/2019 2018
60881 60881 60881 TEDDY M 2018 Yorkshire Terrier   10312 03/17/2018 03/17/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
);