About this Dataset

Allegheny County Dog Licenses

A list of dog license dates, dog breeds, and dog name by zip code. Currently this dataset does not include City of Pittsburgh dogs.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:04:49.924218
Tags: _etl, breed, dog-licenses, dogs, license

Tables

2007 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2007_dog_licenses

1.37 MB
98738 rows
8 columns


CREATE TABLE n_2007_dog_licenses (
  "n__id" BIGINT,
  "license_type" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dog_name" VARCHAR,
  "owner_zip" BIGINT,
  "exp_year" BIGINT,
  "valid_date" TIMESTAMP
);

2008 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2008_dog_licenses

1.45 MB
97156 rows
8 columns


CREATE TABLE n_2008_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2009 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2009_dog_licenses

1.46 MB
100091 rows
8 columns


CREATE TABLE n_2009_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2010 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2010_dog_licenses

1.48 MB
101567 rows
8 columns


CREATE TABLE n_2010_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2011 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2011_dog_licenses

1.46 MB
99845 rows
8 columns


CREATE TABLE n_2011_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2012 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2012_dog_licenses

1.44 MB
98626 rows
8 columns


CREATE TABLE n_2012_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2013 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2013_dog_licenses

1.44 MB
99859 rows
8 columns


CREATE TABLE n_2013_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2014 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2014_dog_licenses

1.42 MB
98328 rows
8 columns


CREATE TABLE n_2014_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2015 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2015_dog_licenses

1.47 MB
101141 rows
8 columns


CREATE TABLE n_2015_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2016 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2016_dog_licenses

1.34 MB
94902 rows
8 columns


CREATE TABLE n_2016_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2017 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2017_dog_licenses

1.33 MB
91424 rows
8 columns


CREATE TABLE n_2017_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2018 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2018_dog_licenses

1.35 MB
91225 rows
8 columns


CREATE TABLE n_2018_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2019 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2019_dog_licenses

1.33 MB
91060 rows
8 columns


CREATE TABLE n_2019_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2020 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2020_dog_licenses

742.62 KB
86003 rows
7 columns


CREATE TABLE n_2020_dog_licenses (
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2021 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2021_dog_licenses

1.15 MB
82454 rows
8 columns


CREATE TABLE n_2021_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);

2022 Dog Licenses

@usgov.allegheny_county_city_of_pitts_allegheny_county_dog_licenses.n_2022_dog_licenses

1.08 MB
75977 rows
8 columns


CREATE TABLE n_2022_dog_licenses (
  "n__id" BIGINT,
  "licensetype" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "dogname" VARCHAR,
  "ownerzip" BIGINT,
  "expyear" BIGINT,
  "validdate" TIMESTAMP
);