Dataset: NYC Dog Licenses

About this Dataset

NYC Dog Licenses

Context

I have taken this dataset from the NYC Open Data Website: https://data.cityofnewyork.us

I wanted to use the cleaned version of this dataset and I thought people might like to use this version. The original dataset was last updated on 10th September 2018.

Description:
All dog owners residing in NYC are required by law to license their dogs. The data is sourced from the DOHMH Dog Licensing System (https://a816-healthpsi.nyc.gov/DogLicense), where owners can apply for and renew dog licenses. 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.

Content

The original dataset contained 122K rows and 15 columns. After cleaning the data, the count has reduced to 121862 rows.

Acknowledgements

Thank you to the city of new york for collecting and providing this data! As well as the NYC Department of Health who acquired this data from owners who registered their dogs for the dog license.

Inspiration

I'll let you guys get creative and explore the dataset.

Tables

Nyc Dogs Clean

@kaggle.smithaachar_nyc_dog_licensing_clean.nyc_dogs_clean

3.8 MB
121862 rows
17 columns


CREATE TABLE nyc_dogs_clean (
  "unnamed_0" BIGINT,
  "x" BIGINT,
  "rownumber" BIGINT,
  "animalname" VARCHAR,
  "animalgender" VARCHAR,
  "animalbirthmonth" VARCHAR,
  "breedname" VARCHAR,
  "borough" VARCHAR,
  "zipcode" BIGINT,
  "communitydistrict" DOUBLE,
  "censustract2010" DOUBLE,
  "nta" VARCHAR,
  "citycouncildistrict" DOUBLE,
  "congressionaldistrict" DOUBLE,
  "statesenatorialdistrict" DOUBLE,
  "licenseissueddate" TIMESTAMP,
  "licenseexpireddate" TIMESTAMP
);

Nyc Dog Licensing Dataset

@kaggle.smithaachar_nyc_dog_licensing_clean.nyc_dog_licensing_dataset

2.43 MB
121949 rows
15 columns


CREATE TABLE nyc_dog_licensing_dataset (
  "rownumber" BIGINT,
  "animalname" VARCHAR,
  "animalgender" VARCHAR,
  "animalbirthmonth" VARCHAR,
  "breedname" VARCHAR,
  "borough" VARCHAR,
  "zipcode" DOUBLE,
  "communitydistrict" DOUBLE,
  "censustract2010" DOUBLE,
  "nta" VARCHAR,
  "citycouncildistrict" DOUBLE,
  "congressionaldistrict" DOUBLE,
  "statesenatorialdistrict" DOUBLE,
  "licenseissueddate" TIMESTAMP,
  "licenseexpireddate" TIMESTAMP
);