`14 Dog License owner information exported from the Kristen Scalise's Kanine system
Visit: Fiscal Office Dog Licensing Data Downloads
Run Report: '14 Owner Information


--
-- Table structure for table `dog_license2014`
--

CREATE TABLE IF NOT EXISTS `dog_license2014` (
  `firstname` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `streetnumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `street` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pobox` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `Index` (`firstname`,`lastname`,`streetnumber`,`street`,`city`,`zip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Page 19 of 19