-- MySQL dump 10.16  Distrib 10.2.14-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: fslreporting_testdb
-- ------------------------------------------------------
-- Server version	10.2.14-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `inspections_fresh_produce_fd`
--

DROP TABLE IF EXISTS `inspections_fresh_produce_fd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inspections_fresh_produce_fd` (
  `InspectionID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `InspectionDate` date NOT NULL,
  `YYYY` varchar(4) NOT NULL,
  `MM` varchar(2) NOT NULL,
  `DD` varchar(2) NOT NULL,
  `YearRange` varchar(9) NOT NULL,
  `Period` varchar(2) NOT NULL,
  `WeekNo` varchar(2) NOT NULL,
  `Location` varchar(20) NOT NULL,
  `DataCheck` int(11) NOT NULL DEFAULT 0,
  `ImagesUploaded` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`InspectionID`)
) ENGINE=InnoDB AUTO_INCREMENT=577 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inspections_fresh_produce_fd`
--

LOCK TABLES `inspections_fresh_produce_fd` WRITE;
/*!40000 ALTER TABLE `inspections_fresh_produce_fd` DISABLE KEYS */;
INSERT INTO `inspections_fresh_produce_fd` VALUES (1,'2013-04-15','2013','04','15','2012-2013','08','1','Tamworth',0,0),(2,'2013-04-16','2013','04','16','2012-2013','08','1','Yate',0,0),(3,'2013-04-18','2013','04','18','2012-2013','08','1','Rochdale',0,0),(4,'2013-04-03','2013','04','03','2012-2013','07','3','Tamworth',0,0),(5,'2013-04-09','2013','04','09','2012-2013','07','4','Kent',0,0),(6,'2013-04-12','2013','04','12','2012-2013','07','4','Kent',0,0),(7,'2013-03-20','2013','03','20','2012-2013','07','1','Yate',0,0),(8,'2013-03-21','2013','03','21','2012-2013','07','1','Tamworth',0,0),(9,'2013-03-21','2013','03','21','2012-2013','07','1','Rochdale',0,0),(10,'2013-03-08','2013','03','08','2012-2013','07','3','Kent',0,0),(11,'2013-04-25','2013','04','25','2012-2013','08','2','Tamwoth',0,0),(12,'2013-04-30','2013','04','30','2012-2013','08','1','Kent',0,0),(13,'2013-05-07','2013','05','07','2012-2013','08','4','Yate',0,0),(14,'2013-05-09','2013','05','09','2012-2013','08','4','Kent',0,0),(16,'2013-05-10','2013','04','10','2012-2013','08','4','Rochdale',0,0),(17,'2013-05-15','2013','05','15','2012-2013','09','1','Yate',0,0),(18,'2013-05-16','2013','05','16','2012-2013','09','1','Tamworth',0,0),(19,'2013-05-17','2013','05','17','2012-2013','09','1','Rochdale',0,0),(20,'2013-05-23','2013','05','23','2012-2013','09','2','Tamworth',0,0),(21,'2013-05-30','2013','05','30','2012-2013','09','3','Yate',0,0),(22,'2013-06-04','2013','06','04','2012-2013','09','4','Kent',0,0),(23,'2013-06-05','2013','06','05','2012-2013','09','4','Kent',0,0),(24,'2013-06-06','2013','06','06','2012-2013','09','4','Rochdale',0,0),(25,'2013-06-13','2013','06','13','2012-2013','10','1','Yate',0,0),(26,'2013-06-14','2013','06','14','2012-2013','10','1','Rochdale',0,0),(27,'2013-06-20','2013','06','20','2012-2013','10','2','Tamworth',0,0),(28,'2013-06-27','2013','06','27','2012-2013','10','3','Kent',0,0),(29,'2013-06-28','2013','06','28','2012-2013','10','3','Tamworth',0,0),(30,'2013-07-03','2013','07','03','2012-2013','10','4','Yate',0,0),(31,'2013-07-04','2013','07','04','2012-2013','10','4','Rochdale',0,0),(32,'2013-07-05','2013','07','05','2012-2013','10','4','Kent',0,0),(33,'2013-07-09','2013','07','09','2012-2013','11','1','Tamworth',0,0),(34,'2013-07-17','2013','07','17','2012-2013','11','2','Tamworth',0,0),(35,'2013-07-12','2013','07','12','2012-2013','11','1','Rochdale',0,0),(36,'2013-07-23','2013','07','23','2012-2013','11','3','Yate',0,0),(38,'2013-07-24','2013','07','24','2012-2013','11','3','Kent',0,0),(39,'2013-07-26','2013','07','26','2012-2013','11','3','Rochdale',0,0),(40,'2013-07-31','2013','07','31','2012-2013','11','4','Kent',0,0),(42,'2013-08-01','2013','08','01','2012-2013','11','4','Rochdale',0,0),(43,'2013-08-09','2013','08','09','2012-2013','12','1','Rochdale',0,0),(44,'2013-08-16','2013','08','16','2012-2013','12','2','Kent',0,0),(45,'2013-08-20','2013','08','20','2012-2013','12','2','Yate',0,0),(46,'2013-08-22','2013','08','22','2012-2013','12','3','Tamworth',0,0),(47,'2013-08-23','2013','08','23','2012-2013','12','3','Rochdale',0,0),(48,'2013-08-28','2013','08','28','2012-2013','12','4','Kent',0,0),(49,'2013-08-27','2013','08','27','2012-2013','12','4','Yate',0,0),(50,'2013-08-29','2013','08','29','2012-2013','12','4','Tamworth',0,0),(51,'2013-09-03','2013','09','03','2012-2013','13','1','Tamworth',0,0),(52,'2013-09-05','2013','09','05','2012-2013','13','1','Rochdale',0,0),(53,'2013-09-06','2013','09','06','2012-2013','13','1','Yate',0,0),(54,'2013-09-12','2013','09','12','2012-2013','13','2','Kent',0,0),(55,'2013-09-16','2013','09','16','2012-2013','13','3','Tamworth',0,0),(56,'2013-09-19','2013','09','19','2012-2013','13','3','Rochdale',0,0),(57,'2013-09-25','2013','09','25','2012-2013','13','4','Yate',0,0),(58,'2013-09-26','2013','09','26','2012-2013','13','4','Kent',0,0),(59,'2013-10-03','2013','10','03','2013-2014','01','1','Rochdale',1,0),(60,'2013-10-11','2013','10','11','2013-2014','01','2','Yate',1,0),(61,'2013-10-10','2013','10','10','2013-2014','01','2','Rochdale',1,0),(62,'2013-10-15','2013','10','15','2013-2014','01','3','Kent',1,0),(63,'2013-10-16','2013','10','16','2013-2014','01','3','Tamworth',1,0),(64,'2013-10-18','2013','10','18','2013-2014','01','3','Yate',1,0),(65,'2013-10-22','2013','10','22','2013-2014','01','4','Kent',1,0),(66,'2013-10-24','2013','10','24','2013-2014','01','4','Tamwoth',1,0),(75,'2013-10-31','2013','10','31','2013-2014','02','1','Tamworth',1,0),(76,'2013-11-01','2013','11','01','2013-2014','02','1','Yate',1,0),(77,'2013-11-05','2013','11','05','2013-2014','02','2','Yate',1,0),(78,'2013-11-15','2013','11','15','2013-2014','02','3','Kent',1,0),(79,'2013-11-18','2013','11','18','2013-2014','02','4','Warrington',1,0),(80,'2013-11-19','2013','11','19','2013-2014','02','4','Kent',1,0),(81,'2013-11-21','2013','11','21','2013-2014','02','4','Warrington',1,0),(82,'2013-11-22','2013','11','22','2013-2014','02','4','Tamworth',1,0),(83,'2013-11-26','2013','11','26','2013-2014','03','1','Tamworth',1,0),(84,'2013-11-27','2013','11','27','2013-2014','03','1','Yate',1,0),(85,'2013-12-05','2013','12','05','2013-2014','03','2','Warrington',1,0),(86,'2013-12-06','2013','12','06','2013-2014','03','2','Yate',1,0),(87,'2013-12-12','2013','12','12','2013-2014','03','3','Warrington',1,0),(88,'2013-12-13','2013','12','13','2013-2014','03','3','Kent',1,0),(89,'2013-12-14','2013','12','14','2013-2014','03','3','Tamworth',1,0),(90,'2013-12-17','2013','12','17','2013-2014','03','3','Kent',1,0),(91,'2013-12-31','2013','12','31','2013-2014','04','2','Yate',1,0),(92,'2014-01-06','2014','01','06','2013-2014','04','2','Warrington',1,0),(93,'2014-01-09','2014','01','09','2013-2014','04','3','Kent',1,0),(94,'2014-01-13','2014','01','13','2013-2014','04','4','Tamworth',1,0),(95,'2014-01-14','2014','01','14','2013-2014','04','4','Warrington',1,0),(96,'2014-01-15','2014','01','15','2013-2014','04','4','Yate',1,0),(97,'2014-01-16','2014','01','16','2013-2014','04','4','Kent',1,0),(98,'2014-01-17','2014','01','17','2013-2014','04','4','Tamworth',1,0),(99,'2014-01-20','2014','01','20','2013-2014','05','1','Tamworth',1,0),(100,'2014-01-21','2014','01','21','2013-2014','05','1','Yate',1,0),(101,'2012-12-31','2012','12','31','2012-2013','04','1','Rochdale',0,0),(102,'2013-01-07','2013','01','07','2012-2013','04','2','Tamworth',0,0),(103,'2013-01-08','2013','01','08','2012-2013','04','2','Yate',0,0),(104,'2013-01-09','2013','01','09','2012-2013','04','2','Yate',0,0),(105,'2013-01-10','2013','01','10','2012-2013','04','2','Rochdale',0,0),(106,'2013-01-14','2013','01','14','2012-2013','04','3','Kent',0,0),(107,'2013-01-16','2013','01','16','2012-2013','04','3','Tamworth',0,0),(108,'2013-01-18','2013','01','18','2012-2013','04','3','Kent',0,0),(109,'2014-01-22','2014','01','22','2013-2014','05','1','Kent',1,0),(110,'2014-01-23','2014','01','23','2013-2014','05','1','Warrington',1,0),(111,'2014-01-27','2014','01','27','2013-2014','05','2','Tamworth',1,0),(112,'2014-01-28','2014','01','28','2013-2014','05','2','Yate',1,0),(113,'2014-02-05','2014','02','05','2013-2014','05','3','Kent',1,0),(114,'2014-02-07','2014','02','07','2013-2014','05','3','Warrington',1,0),(115,'2014-02-18','2014','02','18','2013-2014','06','1','Yate',1,0),(116,'2014-02-20','2014','02','20','2013-2014','06','1','Warrington',1,0),(117,'2014-02-21','2014','02','21','2013-2014','06','1','Tamworth',1,0),(118,'2014-02-24','2014','02','24','2013-2014','06','2','Warrington',1,0),(119,'2014-02-25','2014','02','25','2013-2014','06','2','Tamworth',1,0),(120,'2014-03-04','2014','03','04','2013-2014','06','3','Yate',1,0),(121,'2014-03-05','2014','03','05','2013-2014','06','3','Kent',1,0),(122,'2014-03-14','2014','03','14','2013-2014','06','4','Kent',1,0),(123,'2014-03-18','2014','03','18','2013-2014','07','1','Tamworth',1,0),(124,'2014-03-28','2014','03','28','2013-2014','07','2','Kent',1,0),(125,'2014-04-01','2014','04','01','2013-2014','07','3','Tamworth',1,0),(126,'2014-04-02','2014','04','02','2013-2014','07','3','Yate',1,0),(127,'2014-04-10','2014','04','10','2013-2014','07','4','Warrington',1,0),(128,'2014-04-11','2014','04','11','2013-2014','07','4','Yate',1,0),(129,'2014-04-12','2014','04','12','2013-2014','07','4','Kent',1,0),(130,'2014-04-09','2014','04','09','2013-2014','07','4','Warrington',1,0),(131,'2014-04-17','2014','04','17','2013-2014','08','1','Warrington',1,0),(132,'2014-04-22','2014','04','22','2013-2014','08','1','Yate',1,0),(133,'2014-04-24','2014','04','24','2013-2014','08','1','Warrington',1,0),(134,'2014-04-29','2014','04','29','2013-2014','08','3','Yate',1,0),(135,'2014-04-30','2014','04','30','2013-2014','08','3','Tamworth',1,0),(136,'2014-05-02','2014','05','02','2013-2014','08','3','Kent',1,0),(137,'2014-05-08','2014','05','08','2013-2014','08','4','Kent',1,0),(138,'2014-05-09','2014','05','09','2013-2014','08','4','Tamworth',1,0),(139,'2014-05-12','2014','05','12','2013-2014','09','1','Tamworth',1,0),(140,'2014-05-13','2014','05','13','2013-2014','09','1','Yate',1,0),(141,'2014-05-15','2014','05','15','2013-2014','09','1','Warrington',1,0),(142,'2014-05-16','2014','05','16','2013-2014','09','1','Kent',1,0),(144,'2014-05-23','2014','05','23','2013-2014','09','2','Tamworth',1,0),(145,'2014-05-27','2014','05','27','2013-2014','09','3','Yate',1,0),(146,'2014-06-02','2014','06','02','2013-2014','09','4','Warrington',1,0),(147,'2014-06-05','2014','06','05','2013-2014','09','4','Kent',1,0),(148,'2014-06-10','2014','06','10','2013-2014','10','1','Tamworth',1,0),(149,'2014-06-13','2014','06','13','2013-2014','10','1','Kent',1,0),(150,'2014-06-17','2014','06','17','2013-2014','10','2','Yate',1,0),(151,'2014-06-19','2014','06','19','2013-2014','10','2','Tamworth',1,0),(152,'2014-06-24','2014','06','24','2013-2014','10','3','Yate',1,0),(153,'2014-06-26','2014','06','26','2013-2014','10','3','Kent',1,0),(154,'2014-07-01','2014','07','01','2013-2014','10','4','Warrington',1,0),(155,'2014-07-04','2014','07','04','2013-2014','10','4','Yate',1,0),(156,'2014-07-08','2014','07','08','2013-2014','11','1','Yate',1,0),(157,'2014-07-11','2014','07','11','2013-2014','11','1','Warrington',1,0),(158,'2014-07-15','2014','07','15','2013-2014','11','2','Kent',1,0),(159,'2014-07-22','2014','07','22','2013-2014','11','3','Yate',1,0),(160,'2014-07-24','2014','07','24','2013-2014','11','3','Tamworth',1,0),(161,'2014-07-25','2014','07','25','2013-2014','11','3','Kent',1,0),(162,'2014-07-29','2014','07','29','2013-2014','11','4','Yate',1,0),(163,'2014-07-31','2014','07','31','2013-2014','11','4','Tamworth',1,0),(164,'2014-08-07','2014','08','07','2013-2014','12','1','Yate',1,0),(165,'2014-08-12','2014','08','12','2013-2014','12','2','Warrington',1,0),(166,'2014-08-14','2014','08','14','2013-2014','12','2','Kent',1,0),(167,'2014-08-15','2014','08','15','2013-2014','12','2','Tamworth',1,0),(168,'2014-08-22','2014','08','22','2013-2014','12','3','Tamworth',1,0),(169,'2014-08-27','2014','08','27','2013-2014','12','4','Warrington',1,0),(170,'2014-08-28','2014','08','28','2013-2014','12','4','Kent',1,0),(171,'2014-08-29','2014','08','29','2013-2014','12','4','Yate',1,0),(172,'2014-09-04','2014','09','04','2013-2014','13','1','Yate',1,0),(173,'2014-09-08','2014','09','08','2013-2014','13','2','Warrington',1,0),(174,'2014-09-11','2014','09','11','2013-2014','13','2','Kent',1,0),(175,'2014-09-12','2014','09','12','2013-2014','13','2','Tamworth',1,0),(176,'2014-09-18','2014','09','18','2013-2014','13','3','Tamworth',1,0),(177,'2014-09-19','2014','09','19','2013-2014','13','3','Kent',1,0),(178,'2014-09-23','2014','09','23','2013-2014','13','4','Yate',1,0),(179,'2014-09-25','2014','09','25','2013-2014','13','4','Warrington',1,0),(180,'2014-09-29','2014','09','29','2014-2015','01','1','Warrington',1,0),(181,'2014-10-02','2014','10','02','2014-2015','01','2','Yate',1,0),(182,'2014-10-07','2014','10','07','2014-2015','01','2','Tamworth',1,0),(183,'2014-10-14','2014','10','14','2014-2015','01','3','Kent',1,0),(184,'2014-10-21','2014','10','21','2014-2015','01','4','Tamworth',1,0),(185,'2014-10-23','2014','10','23','2014-2015','01','4','Warrington',1,0),(186,'2014-10-24','2014','10','24','2014-2015','01','4','Yate',1,0),(187,'2014-10-25','2014','10','25','2014-2015','01','4','Kent',1,0),(188,'2014-11-04','2014','11','04','2014-2015','02','1','Tamworth',1,0),(189,'2014-11-06','2014','11','06','2014-2015','02','1','Warrington',1,0),(190,'2014-11-07','2014','11','07','2014-2015','02','1','Kent',1,0),(191,'2014-11-13','2014','11','13','2014-2015','02','2','Tamworth',1,0),(192,'2014-11-14','2014','11','14','2014-2015','02','2','Kent',1,0),(193,'2014-11-15','2014','11','15','2014-2015','02','2','Yate',1,0),(194,'2014-11-18','2014','11','18','2014-2015','02','3','Warrington',1,0),(195,'2014-11-20','2014','11','20','2014-2015','02','3','Yate',1,0),(196,'2014-11-26','2014','11','26','2014-2015','03','1','Warrington',1,0),(197,'2014-11-27','2014','11','27','2014-2015','03','1','Yate',1,0),(198,'2014-12-02','2014','12','02','2014-2015','03','2','Tamworth',1,0),(199,'2014-12-04','2014','12','04','2014-2015','03','2','Warrington',1,0),(200,'2014-12-05','2014','12','05','2014-2015','03','3','Kent',1,0),(201,'2014-12-09','2014','12','09','2014-2015','03','3','Yate',1,0),(202,'2014-12-12','2014','12','12','2014-2015','03','4','Tamworth',1,0),(203,'2014-12-16','2014','12','16','2014-2015','03','4','Kent',1,0),(204,'2015-01-06','2015','01','06','2014-2015','04','1','Yate',1,0),(205,'2015-01-07','2015','01','07','2014-2015','04','1','Tamworth',1,0),(206,'2015-01-08','2015','01','08','2014-2015','04','2','Warrington',1,0),(207,'2015-01-09','2015','01','09','2014-2015','04','2','Kent',1,0),(208,'2015-01-13','2015','01','13','2014-2015','04','4','Tamworth',1,0),(209,'2015-01-14','2015','01','14','2014-2015','04','4','Warrington',1,0),(210,'2015-01-15','2015','01','15','2014-2015','04','4','Kent',1,0),(211,'2015-01-16','2015','01','16','2014-2015','04','4','Yate',1,0),(212,'2015-01-20','2015','01','20','2014-2015','05','1','Tamworth',1,0),(215,'2015-01-27','2015','01','27','2014-2015','05','2','Tamworth',1,0),(216,'2015-02-05','2015','02','05','2014-2015','05','3','Yate',1,0),(217,'2015-02-06','2015','02','06','2014-2015','05','3','Kent',1,0),(218,'2015-02-12','2015','02','12','2014-2015','05','4','Kent',1,0),(219,'2015-02-13','2015','02','13','2014-2015','05','4','Warrington',1,0),(220,'2015-01-22','2015','01','22','2014-2015','05','1','Warrington',1,0),(221,'2015-01-24','2015','01','24','2014-2015','05','1','Yate',1,0),(222,'2015-02-24','2015','02','24','2014-2015','06','2','Yate',1,0),(223,'2015-03-03','2015','03','03','2014-2015','06','3','Tamworth',1,0),(224,'2015-03-04','2015','03','04','2014-2015','06','3','Yate',1,0),(225,'2015-03-06','2015','03','06','2014-2015','06','4','Warrington',1,0),(227,'2015-03-06','2015','03','06','2014-2015','06','4','Kent',1,0),(228,'2015-03-07','2015','03','07','2014-2015','06','4','Kent',1,0),(229,'2015-03-12','2015','03','12','2014-2015','06','4','Tamworth',1,0),(230,'2015-03-13','2015','03','13','2014-2015','06','4','Warrington',1,0),(231,'2015-03-14','2015','03','14','2014-2015','06','4','Kent',1,0),(232,'2015-03-20','2015','03','20','2014-2015','07','1','Yate',1,0),(233,'2015-03-26','2015','03','26','2014-2015','07','1','Kent',1,0),(234,'2015-03-27','2015','03','27','2014-2015','07','2','Yate',1,0),(235,'2015-03-31','2015','03','31','2014-2015','07','2','Tamworth',1,0),(236,'2015-04-02','2015','04','02','2014-2015','07','3','Warrington',1,0),(237,'2015-04-08','2015','04','08','2014-2015','07','4','Warrington',1,0),(238,'2015-04-09','2015','04','09','2014-2015','07','4','Kent',1,0),(239,'2015-04-10','2015','04','10','2014-2015','07','4','Tamworth',1,0),(240,'2015-04-14','2015','04','14','2014-2015','08','1','Tamworth',1,0),(241,'2015-04-16','2015','04','16','2014-2015','08','1','Warrington',1,0),(242,'2015-04-17','2015','04','17','2014-2015','08','1','Yate',1,0),(243,'2015-04-20','2015','04','20','2014-2015','08','2','Tamworth',1,0),(244,'2015-04-27','2015','04','27','2014-2015','08','3','Kent',1,0),(245,'2015-05-05','2015','05','05','2014-2015','08','4','Kent',1,0),(246,'2015-05-07','2015','05','07','2014-2015','08','4','Warrington',1,0),(247,'2015-05-08','2015','05','08','2014-2015','08','4','Yate',1,0),(248,'2015-05-20','2015','05','20','2014-2015','09','2','Tamworth',1,0),(249,'2015-05-22','2015','05','22','2014-2015','09','2','Yate',1,0),(250,'2015-05-26','2015','05','26','2014-2015','09','3','Kent',1,0),(251,'2015-05-27','2015','05','27','2014-2015','09','3','Yate',1,0),(252,'2015-05-29','2015','05','29','2014-2015','09','3','Yate',1,0),(254,'2015-06-02','2015','06','02','2014-2015','09','4','Tamworth',1,0),(255,'2015-06-04','2015','06','04','2014-2015','09','4','Warrington',1,0),(256,'2015-06-05','2015','06','05','2014-2015','09','4','Kent',1,0),(257,'2015-06-09','2015','06','09','2014-2015','10','1','Tamworth',1,0),(258,'2015-06-14','2015','06','14','2014-2015','10','1','Yate',1,0),(259,'2015-06-16','2015','06','16','2014-2015','10','2','Warrington',1,0),(260,'2015-06-19','2015','06','19','2014-2015','10','2','Yate',1,0),(261,'2015-06-19','2015','06','19','2014-2015','10','2','Warrington',1,0),(262,'2015-06-20','2015','06','20','2014-2015','10','2','Warrington',1,0),(263,'2015-06-23','2015','06','23','2014-2015','10','3','Kent',1,0),(264,'2015-06-26','2015','06','26','2014-2015','10','3','Kent',1,0),(265,'2015-07-03','2015','07','03','2014-2015','10','4','Kent',1,0),(266,'2015-07-07','2015','07','07','2014-2015','11','1','Warrington',1,0),(267,'2015-07-10','2015','07','10','2014-2015','11','1','Yate',1,0),(268,'2015-07-14','2015','07','14','2014-2015','11','2','Tamworth',1,0),(269,'2015-07-21','2015','07','21','2014-2015','11','3','Yate',1,0),(270,'2015-07-24','2015','07','24','2014-2015','11','4','Yate',1,0),(271,'2015-07-29','2015','07','29','2014-2015','11','4','Yate',1,0),(272,'2015-07-30','2015','07','30','2014-2015','11','4','Kent',1,0),(273,'2015-07-31','2015','07','31','2014-2015','11','4','Kent',1,0),(274,'2015-08-05','2015','08','05','2014-2015','12','1','Tamworth',1,0),(275,'2015-08-14','2015','08','14','2014-2015','12','2','Warrington',1,1),(276,'2015-08-21','2015','08','21','2014-2015','12','3','Tamworth',1,1),(277,'2015-08-22','2015','08','22','2014-2015','12','3','Kent',1,1),(278,'2015-08-25','2015','08','25','2014-2015','12','4','Warrington',1,1),(279,'2015-08-26','2015','08','26','2014-2015','12','4','Yate',1,1),(280,'2015-08-27','2015','08','27','2014-2015','12','4','Yate',1,1),(281,'2015-08-28','2015','08','28','2014-2015','12','4','Kent',1,1),(283,'2015-09-11','2015','09','11','2014-2015','13','2','Tamworth',1,1),(284,'2015-09-14','2015','09','14','2014-2015','13','3','Warrington',1,1),(285,'2015-09-15','2015','09','15','2014-2015','13','3','Yate',1,1),(286,'2015-09-16','2015','09','16','2014-2015','13','3','Tamworth',1,1),(287,'2015-09-18','2015','09','18','2014-2015','13','4','Warrington',1,1),(288,'2015-09-22','2015','09','22','2014-2015','13','4','Kent',1,1),(289,'2015-09-24','2015','09','24','2014-2015','13','4','Yate',1,1),(290,'2015-09-25','2015','09','25','2014-2015','13','4','Kent',1,1),(291,'2015-10-01','2015','10','01','2015-2016','01','1','Tamworth',1,1),(292,'2015-10-02','2015','10','02','2015-2016','01','1','Kent',1,1),(293,'2015-10-06','2015','10','06','2015-2016','01','2','Yate',1,1),(295,'2015-10-08','2015','10','08','2015-2016','01','2','Warrington',1,1),(296,'2015-10-15','2015','10','15','2015-2016','01','3','Yate',1,1),(297,'2015-10-16','2015','10','16','2015-2016','01','3','Kent',1,1),(299,'2015-10-16','2015','10','16','2015-2016','01','3','Tamworth',1,1),(300,'2015-10-23','2015','10','23','2015-2016','01','4','Warrington',1,1),(301,'2015-10-27','2015','10','27','2015-2016','02','1','Yate',1,1),(302,'2015-10-30','2015','10','30','2015-2016','02','2','Kent',1,1),(303,'2015-11-03','2015','11','03','2015-2016','02','2','Tamworth',1,1),(304,'2015-11-05','2015','11','05','2015-2016','02','2','Warrington',1,1),(305,'2015-11-05','2015','11','05','2015-2016','02','2','Yate',1,1),(306,'2015-11-10','2015','11','10','2015-2016','02','3','Tamworth',1,1),(307,'2015-11-12','2015','11','12','2015-2016','02','3','Kent',1,1),(308,'2015-11-18','2015','11','18','2015-2016','02','4','Warrington',1,1),(309,'2015-11-27','2015','11','27','2015-2016','03','1','Yate',1,1),(310,'2015-12-01','2015','12','01','2015-2016','03','2','Yate',1,1),(311,'2015-12-10','2015','12','10','2015-2016','03','3','Warrington',1,1),(312,'2015-12-11','2015','12','11','2015-2016','03','3','Kent',1,1),(313,'2015-12-15','2015','12','15','2015-2016','03','4','Kent',1,1),(314,'2015-12-16','2015','12','16','2015-2016','03','4','Tamworth',1,1),(315,'2015-12-17','2015','12','17','2015-2016','03','4','Warrington',1,1),(317,'2015-12-18','2015','12','18','2015-2016','03','4','Tamworth',1,1),(318,'2015-12-22','2015','12','22','2015-2016','04','1','Kent',1,1),(319,'2015-12-29','2015','12','29','2015-2016','04','2','Yate',1,1),(320,'2015-12-30','2015','12','30','2015-2016','04','2','Kent',1,1),(321,'2016-01-04','2016','01','04','2015-2016','04','3','Warrington',1,1),(322,'2016-01-05','2016','01','05','2015-2016','04','3','Tamworth',1,1),(323,'2016-01-08','2016','01','08','2015-2016','04','2','Warrington',1,1),(324,'2016-01-11','2016','01','11','2015-2016','04','4','Tamworth',1,1),(325,'2016-01-14','2016','01','14','2015-2016','04','4','Yate',1,1),(326,'2016-01-18','2016','01','18','2015-2016','05','1','Warrington',1,1),(327,'2016-01-20','2016','01','20','2015-2016','05','1','Kent',1,1),(328,'2016-01-22','2016','01','22','2015-2016','05','1','Yate',1,1),(329,'2016-01-25','2016','01','25','2015-2016','05','2','Warrington',1,1),(330,'2016-01-26','2016','01','26','2015-2016','05','2','Kent',1,1),(331,'2016-01-27','2016','01','27','2015-2016','05','2','Tamworth',1,1),(332,'2016-02-03','2016','02','03','2015-2016','05','3','Tamworth',1,1),(333,'2016-02-05','2016','02','05','2015-2016','05','3','Yate',1,1),(334,'2016-02-15','2016','02','15','2015-2016','06','1','Tamworth',1,1),(335,'2016-02-19','2016','02','19','2015-2016','06','1','Yate',1,1),(336,'2016-02-23','2016','02','23','2015-2016','06','2','Warrington',1,1),(337,'2016-02-24','2016','02','24','2015-2016','06','2','Kent',1,1),(338,'2016-02-25','2016','02','25','2015-2016','06','2','Yate',1,1),(339,'2016-02-26','2016','02','26','2015-2016','06','2','Warrington',1,1),(340,'2016-02-29','2016','02','29','2015-2016','06','2','Tamworth',1,1),(341,'2016-03-10','2016','03','10','2015-2016','06','4','Kent',1,1),(342,'2016-03-14','2016','03','14','2015-2016','07','1','Warrington',1,1),(344,'2016-03-17','2016','03','17','2015-2016','07','1','Tamworth',1,1),(345,'2016-03-18','2016','03','18','2015-2016','07','2','Yate',1,1),(346,'2016-03-24','2016','03','24','2015-2016','07','3','Kent',1,1),(347,'2016-03-29','2016','03','29','2015-2016','07','3','Warrington',1,1),(348,'2016-03-31','2016','03','31','2015-2016','07','3','Tamworth',1,1),(349,'2016-04-01','2016','04','01','2015-2016','07','3','Yate',1,1),(350,'2016-04-06','2016','04','06','2015-2016','07','4','Kent',1,1),(351,'2016-04-11','2016','04','11','2015-2016','08','1','Warrington',1,1),(352,'2016-04-14','2016','04','14','2015-2016','08','1','Yate',1,1),(354,'2016-04-15','2016','04','15','2015-2016','08','1','Tamworth',1,1),(355,'2016-04-22','2016','04','22','2015-2016','08','3','Warrington',1,1),(356,'2016-04-29','2016','04','29','2015-2016','08','3','Kent',1,1),(357,'2016-05-04','2016','05','04','2015-2016','08','4','Kent',1,1),(358,'2016-05-06','2016','05','06','2015-2016','08','4','Kent',1,1),(359,'2016-05-06','2016','05','06','2015-2016','08','4','Yate',1,1),(360,'2016-05-10','2016','05','10','2015-2016','09','1','Tamworth',1,1),(361,'2016-05-11','2016','05','11','2015-2016','09','1','Yate',1,1),(362,'2016-05-12','2016','05','12','2015-2016','09','1','Warrington',1,1),(363,'2016-05-18','2016','05','18','2015-2016','09','1','Tamworth',1,1),(364,'2016-05-19','2016','05','19','2015-2016','09','1','Kent',1,1),(365,'2016-05-19','2016','05','19','2015-2016','09','1','Warrington',1,1),(366,'2016-05-26','2016','05','26','2015-2016','09','3','Kent',1,1),(368,'2016-06-03','2016','06','03','2015-2016','09','4','Yate',1,1),(369,'2016-06-07','2016','06','07','2015-2016','10','1','Tamworth',1,1),(370,'2016-06-09','2016','06','09','2015-2016','10','2','Yate',1,1),(371,'2016-06-16','2016','06','16','2015-2016','10','1','Tamworth',1,1),(372,'2016-06-17','2016','06','17','2015-2016','10','1','Kent',1,1),(373,'2016-06-22','2016','06','22','2015-2016','10','2','Warrington',1,1),(374,'2016-06-23','2016','06','23','2015-2016','10','2','Kent',1,1),(375,'2016-06-24','2016','06','24','2015-2016','10','2','Warrington',1,1),(376,'2016-07-01','2016','07','01','2015-2016','10','4','Yate',1,1),(377,'2016-07-06','2016','07','06','2015-2016','11','1','Yate',1,1),(378,'2016-07-07','2016','07','07','2015-2016','11','1','Kent',1,1),(379,'2016-07-08','2016','07','08','2015-2016','11','1','Tamworth',1,1),(380,'2016-07-14','2016','07','14','2015-2016','11','2','Tamworth',1,1),(381,'2016-07-15','2016','07','15','2015-2016','11','2','Kent',1,1),(382,'2016-07-21','2016','07','21','2015-2016','11','3','Yate',1,1),(383,'2016-07-22','2016','07','22','2015-2016','11','3','Warrington',1,1),(384,'2016-07-29','2016','07','29','2015-2016','11','4','Kent',1,1),(385,'2016-08-03','2016','08','03','2015-2016','12','1','Kent',1,1),(386,'2016-08-10','2016','08','10','2015-2016','12','1','Tamworth',1,1),(387,'2016-08-12','2016','08','12','2015-2016','12','2','Warrington',1,1),(389,'2016-08-16','2016','08','16','2015-2016','12','3','Tamworth',1,1),(390,'2016-08-18','2016','08','18','2015-2016','12','3','Yate',1,1),(391,'2016-08-18','2016','08','18','2015-2016','12','3','Warrington',1,1),(392,'2016-08-19','2016','08','19','2015-2016','12','3','Kent',1,1),(393,'2016-08-26','2016','08','26','2015-2016','12','1','Yate',1,1),(394,'2016-09-01','2016','09','01','2015-2016','13','1','Yate',1,1),(395,'2016-09-02','2016','09','02','2015-2016','13','1','Warrington',1,1),(396,'2016-09-07','2016','09','07','2015-2016','13','2','Tamworth',1,1),(397,'2016-09-15','2016','09','15','2015-2016','13','3','Kent',1,1),(398,'2016-09-16','2016','09','16','2015-2016','13','3','Yate',1,1),(399,'2016-09-19','2016','09','19','2015-2016','13','2','Tamworth',1,1),(400,'2016-09-21','2016','09','21','2015-2016','13','4','Warrington',1,1),(401,'2016-09-23','2016','09','23','2015-2016','13','4','Kent',1,1),(402,'2016-09-28','2016','09','28','2016-2017','01','1','Yate',1,1),(403,'2016-09-29','2016','09','29','2016-2017','01','1','Kent',1,1),(404,'2016-10-13','2016','10','13','2016-2017','01','3','Tamworth',1,1),(405,'2016-10-14','2016','10','14','2016-2017','01','3','Yate',1,1),(406,'2016-10-18','2016','10','18','2016-2017','01','4','Warrington',1,1),(407,'2016-10-20','2016','10','20','2016-2017','01','4','Tamworth',1,1),(408,'2016-10-21','2016','10','21','2016-2017','01','4','Kent',1,1),(409,'2016-10-21','2016','10','21','2016-2017','01','4','Warrington',1,1),(410,'2016-10-27','2016','10','27','2016-2017','02','1','Kent',1,1),(411,'2016-11-01','2016','11','01','2016-2017','02','2','Warrington',1,1),(412,'2016-11-02','2016','11','02','2016-2017','02','2','Tamworth',1,1),(413,'2016-11-04','2016','11','04','2016-2017','02','2','Yate',1,1),(414,'2016-11-10','2016','11','10','2016-2017','02','3','Tamworth',1,1),(415,'2016-11-11','2016','11','11','2016-2017','02','3','Kent',1,1),(416,'2016-11-16','2016','11','16','2016-2017','02','4','Warrington',1,1),(417,'2016-11-16','2016','11','16','2016-2017','02','4','Kent',1,1),(418,'2016-11-23','2016','11','23','2016-2017','03','1','Kent',1,1),(419,'2016-11-30','2016','11','30','2016-2017','03','2','Warrington',1,1),(420,'2016-12-02','2016','12','02','2016-2017','03','2','Kent',1,1),(421,'2016-12-06','2016','12','06','2016-2017','03','2','Warrington',1,1),(422,'2016-12-07','2016','12','07','2016-2017','03','3','Tamworth',1,1),(423,'2016-12-09','2016','12','09','2016-2017','03','3','Yate',1,1),(424,'2016-12-16','2016','12','16','2016-2017','03','4','Tamworth',1,1),(425,'2016-12-16','2016','12','16','2016-2017','03','4','Yate',1,1),(426,'2016-12-21','2016','12','21','2016-2017','04','1','Kent',1,1),(427,'2016-12-22','2016','12','22','2016-2017','04','1','Yate',1,1),(428,'2016-12-30','2016','12','30','2016-2017','04','3','Kent',1,1),(430,'2017-01-03','2017','01','03','2016-2017','04','3','Tamworth',1,1),(431,'2017-01-04','2017','01','04','2016-2017','04','3','Warrington',1,1),(432,'2017-01-05','2017','01','05','2016-2017','04','3','Yate',1,1),(433,'2017-01-11','2017','01','11','2016-2017','04','4','Tamworth',1,1),(434,'2017-01-12','2017','01','12','2016-2017','04','4','Warrington',1,1),(435,'2017-01-16','2017','01','16','2016-2017','05','1','Warrington',1,1),(436,'2017-01-18','2017','01','18','2016-2017','05','1','Tamworth',1,1),(437,'2017-01-20','2017','01','20','2016-2017','05','1','Yate',1,1),(438,'2017-01-25','2017','01','25','2016-2017','05','2','Kent',1,1),(439,'2017-01-27','2017','01','27','2016-2017','05','3','Yate',1,1),(440,'2017-01-30','2017','01','30','2016-2017','05','3','Tamworth',1,1),(441,'2017-02-09','2017','02','09','2016-2017','05','4','Kent',1,1),(442,'2017-02-10','2017','02','10','2016-2017','05','4','Warrington',1,1),(443,'2017-02-16','2017','02','16','2016-2017','06','1','Yate',1,1),(444,'2017-02-16','2017','02','16','2016-2017','06','1','Kent',1,1),(445,'2017-02-24','2017','02','24','2016-2017','06','2','Tamworth',1,1),(446,'2017-02-28','2017','02','28','2016-2017','06','2','Warrington',1,1),(447,'2017-03-01','2017','03','01','2016-2017','06','3','Portbury',1,1),(448,'2017-03-07','2017','03','07','2016-2017','06','4','Tamworth',1,1),(449,'2017-03-09','2017','03','09','2016-2017','06','4','Warrington',1,1),(450,'2017-03-10','2017','03','10','2016-2017','06','4','Kent',1,1),(451,'2017-03-16','2017','03','16','2016-2017','07','1','Portbury',1,1),(452,'2017-03-16','2017','03','16','2016-2017','07','1','Tamworth',1,1),(453,'2017-03-20','2017','03','20','2016-2017','07','2','Warrington',1,1),(454,'2017-03-24','2017','03','24','2016-2017','07','2','Kent',1,1),(455,'2017-03-29','2017','03','29','2016-2017','07','2','Portbury',1,1),(456,'2017-04-03','2017','04','03','2016-2017','07','4','Tamworth',1,1),(457,'2017-04-05','2017','04','05','2016-2017','07','4','Warrington',1,1),(458,'2017-04-07','2017','04','07','2016-2017','07','4','Kent',1,1),(459,'2017-04-19','2017','04','19','2016-2017','08','1','Portbury',1,1),(460,'2017-04-21','2017','04','21','2016-2017','08','1','Kent',1,1),(461,'2017-04-25','2017','04','25','2016-2017','08','2','Tamworth',1,1),(462,'2017-04-26','2017','04','26','2016-2017','08','2','Warrington',1,1),(463,'2017-04-27','2017','04','27','2016-2017','08','3','Portbury',1,1),(464,'2017-05-03','2017','05','03','2016-2017','08','3','Tamworth',1,1),(465,'2017-05-04','2017','05','04','2016-2017','08','4','Warrington',1,1),(466,'2017-05-05','2017','05','05','2016-2017','08','4','Kent',1,1),(467,'2017-05-11','2017','05','11','2016-2017','09','1','Portbury',1,1),(468,'2017-05-12','2017','05','12','2016-2017','09','1','Kent',1,1),(469,'2017-05-22','2017','05','22','2016-2017','09','2','Warrington',1,1),(470,'2017-05-23','2017','05','23','2016-2017','09','3','Tamworth',1,1),(471,'2017-05-24','2017','05','24','2016-2017','09','3','Warrington',1,1),(472,'2017-05-26','2017','05','26','2016-2017','09','3','Kent',1,1),(473,'2017-06-02','2017','06','02','2016-2017','09','4','Tamworth',1,1),(474,'2017-06-07','2017','06','07','2016-2017','10','1','Tamworth',1,1),(475,'2017-06-07','2017','06','07','2016-2017','10','1','Portbury',1,1),(476,'2017-06-09','2017','06','09','2016-2017','10','1','Kent',1,1),(477,'2017-06-20','2017','06','20','2016-2017','10','2','Warrington',1,1),(478,'2017-06-21','2017','06','21','2016-2017','10','2','Tamworth',1,1),(479,'2017-06-22','2017','06','22','2016-2017','10','2','Portbury',1,1),(480,'2017-06-23','2017','06','23','2016-2017','10','3','Kent',1,1),(481,'2017-06-29','2017','06','29','2016-2017','10','4','Warrington',1,1),(482,'2017-06-30','2017','06','30','2016-2017','10','4','Portbury',1,1),(483,'2017-07-04','2017','07','04','2016-2017','11','1','Warrington',1,1),(484,'2017-07-05','2017','07','05','2016-2017','11','1','Tamworth',1,1),(485,'2017-07-06','2017','07','06','2016-2017','11','1','Portbury',1,1),(486,'2017-07-07','2017','07','07','2016-2017','11','1','Kent',1,1),(487,'2017-07-18','2017','07','18','2016-2017','11','3','Tamworth',1,1),(488,'2017-07-19','2017','07','19','2016-2017','11','3','Warrington',1,1),(489,'2017-07-20','2017','07','20','2016-2017','11','3','Portbury',1,1),(490,'2017-07-28','2017','07','28','2016-2017','11','4','Kent',1,1),(491,'2017-08-07','2017','08','07','2016-2017','12','1','Warrington',1,1),(492,'2017-08-09','2017','08','09','2016-2017','12','1','Warrington',1,1),(493,'2017-08-10','2017','08','10','2016-2017','12','1','Tamworth',1,1),(494,'2017-08-11','2017','08','11','2016-2017','12','1','Kent',1,1),(495,'2017-08-11','2017','08','11','2016-2017','12','1','Portbury',1,1),(496,'2017-08-17','2017','08','17','2016-2017','12','2','Tamworth',1,1),(497,'2017-08-24','2017','08','24','2016-2017','12','4','Portbury',1,1),(498,'2017-08-25','2017','08','25','2016-2017','12','4','Kent',1,1),(499,'2017-09-06','2017','09','06','2016-2017','13','1','Portbury',1,1),(500,'2017-09-08','2017','09','08','2016-2017','13','1','Kent',1,1),(501,'2017-09-08','2017','09','08','2016-2017','13','1','Tamworth',1,1),(502,'2017-09-13','2017','09','13','2016-2017','13','1','Warrington',1,1),(503,'2017-09-21','2017','09','21','2016-2017','13','4','Tamworth',1,1),(504,'2017-09-22','2017','09','22','2016-2017','13','4','Portbury',1,1),(508,'2017-09-22','2017','09','22','2016-2017','13','4','Kent',1,1),(509,'2017-09-22','2017','09','22','2016-2017','13','4','Warrington',1,1),(510,'2017-10-04','2017','10','04','2017-2018','01','1','Portbury',1,1),(511,'2017-10-05','2017','10','05','2017-2018','01','1','Tamworth',1,1),(512,'2017-10-06','2017','10','06','2017-2018','01','1','Kent',1,1),(513,'2017-10-11','2017','10','11','2017-2018','01','2','Warrington',1,1),(514,'2017-10-12','2017','10','12','2017-2018','01','2','Tamworth',1,1),(515,'2017-10-19','2017','10','19','2017-2018','01','1','Warrington',1,1),(516,'2017-10-20','2017','10','20','2017-2018','01','4','Kent',1,1),(517,'2017-10-20','2017','10','20','2017-2018','01','1','Portbury',1,1),(518,'2017-11-03','2017','11','03','2017-2018','02','1','Kent',1,1),(519,'2017-11-08','2017','11','08','2017-2018','02','3','Warrington',1,1),(520,'2017-11-09','2017','11','09','2017-2018','02','3','Portbury',1,1),(521,'2017-11-13','2017','11','13','2017-2018','02','4','Warrington',1,1),(522,'2017-11-16','2017','11','16','2017-2018','02','4','Portbury',1,1),(523,'2017-11-16','2017','11','16','2017-2018','02','4','Tamworth',1,1),(524,'2017-11-17','2017','11','17','2017-2018','02','4','Kent',1,1),(525,'2017-11-17','2017','11','17','2017-2018','02','4','Tamworth',1,1),(526,'2017-11-23','2017','11','23','2017-2018','03','1','Portbury',1,1),(527,'2017-11-24','2017','11','24','2017-2018','03','1','Tamworth',1,1),(528,'2017-12-01','2017','12','01','2017-2018','03','2','Kent',1,1),(529,'2017-12-06','2017','12','06','2017-2018','03','3','Warrington',1,1),(530,'2017-12-07','2017','12','07','2017-2018','03','3','Portbury',1,1),(531,'2017-12-08','2017','12','08','2017-2018','03','3','Tamworth',1,1),(532,'2017-12-14','2017','12','14','2017-2018','03','4','Warrington',1,1),(533,'2017-12-20','2017','12','20','2017-2018','03','4','Kent',1,1),(534,'2017-12-22','2017','12','22','2017-2018','04','1','Kent',1,1),(535,'2018-01-02','2018','01','02','2017-2018','04','2','Warrington',1,1),(536,'2018-01-05','2018','01','05','2017-2018','04','1','Kent',1,1),(537,'2018-01-09','2018','01','09','2017-2018','04','3','Warrington',1,1),(538,'2018-01-10','2018','01','10','2017-2018','04','3','Tamworth',1,1),(540,'2018-01-11','2018','01','11','2017-2018','04','3','Portbury',1,1),(541,'2018-01-11','2018','01','11','2017-2018','04','4','Tamworth',1,1),(542,'2018-01-12','2018','01','12','2017-2018','04','4','Portbury',1,1),(543,'2018-01-17','2018','01','17','2017-2018','05','1','Warrington',1,1),(546,'2018-01-18','2018','01','18','2017-2018','05','1','Portbury',1,1),(547,'2018-01-19','2018','01','19','2017-2018','05','1','Kent',1,1),(548,'2018-01-25','2018','01','25','2017-2018','05','3','Tamworth',1,1),(549,'2018-01-31','2018','01','31','2017-2018','05','3','Portbury',1,1),(550,'2018-02-01','2018','02','01','2017-2018','05','4','Warrington',1,1),(551,'2018-02-02','2018','02','02','2017-2018','05','4','Kent',1,1),(552,'2018-02-08','2018','02','08','2017-2018','05','4','Tamworth',1,1),(553,'2018-02-13','2018','02','13','2017-2018','06','1','Tamworth',1,1),(554,'2018-02-16','2018','02','16','2017-2018','06','1','Kent',1,1),(555,'2018-02-16','2018','02','16','2017-2018','06','1','Warrington',1,1),(556,'2018-02-23','2018','02','23','2017-2018','06','1','Portbury',1,1),(557,'2018-02-28','2018','02','28','2017-2018','06','3','Tamworth',1,1),(558,'2018-03-01','2018','03','01','2017-2018','06','3','Portbury',1,1),(559,'2018-03-09','2018','03','09','2017-2018','06','3','Kent',1,1),(560,'2018-03-09','2018','03','09','2017-2018','06','4','Warrington',1,1),(561,'2018-03-13','2018','03','13','2017-2018','07','1','Tamworth',1,1),(562,'2018-03-14','2018','03','14','2017-2018','07','1','Warrington',1,1),(563,'2018-03-15','2018','03','15','2017-2018','07','1','Portbury',1,1),(564,'2018-03-19','2018','03','19','2017-2018','07','1','Tamworth',1,1),(565,'2018-03-20','2018','03','20','2017-2018','07','1','Kent',1,1),(566,'2018-03-21','2018','03','21','2017-2018','07','2','Portbury',1,1),(567,'2018-03-26','2018','03','26','2017-2018','07','3','Warrington',1,1),(568,'2018-04-06','2018','04','06','2017-2018','07','4','Kent',1,1),(569,'2018-04-17','2018','04','17','2017-2018','08','1','Tamworth',1,1),(570,'2018-04-18','2018','04','18','2017-2018','08','1','Warrington',1,1),(571,'2018-04-18','2018','04','18','2017-2018','08','1','Portbury',1,1),(572,'2018-04-20','2018','04','20','2017-2018','08','1','Kent',1,1),(573,'2018-04-25','2018','04','25','2017-2018','08','2','Tamworth',1,1),(574,'2018-04-26','2018','04','26','2017-2018','08','2','Portbury',1,1),(575,'2018-05-03','2018','05','03','2017-2018','08','3','Warrington',1,1),(576,'2018-05-04','2018','05','04','2017-2018','08','3','Kent',1,1);
/*!40000 ALTER TABLE `inspections_fresh_produce_fd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inspections_fresh_produce_p`
--

DROP TABLE IF EXISTS `inspections_fresh_produce_p`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inspections_fresh_produce_p` (
  `InspectionID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `InspectionDate` date NOT NULL,
  `YYYY` varchar(4) NOT NULL,
  `MM` varchar(2) NOT NULL,
  `DD` varchar(2) NOT NULL,
  `YearRange` varchar(9) NOT NULL,
  `Period` varchar(2) NOT NULL,
  `WeekNo` varchar(2) NOT NULL,
  `Location` varchar(20) NOT NULL,
  `DataCheck` int(11) NOT NULL DEFAULT 0,
  `ImagesUploaded` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`InspectionID`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inspections_fresh_produce_p`
--

LOCK TABLES `inspections_fresh_produce_p` WRITE;
/*!40000 ALTER TABLE `inspections_fresh_produce_p` DISABLE KEYS */;
INSERT INTO `inspections_fresh_produce_p` VALUES (1,'2013-04-15','2013','04','15','2012-2013','08','1','Tamworth',0,0),(2,'2013-03-19','2013','03','19','2012-2013','07','1','Tamworth',0,0),(3,'2013-05-21','2013','05','21','2012-2013','09','2','Tamworth',0,0),(4,'2013-06-28','2013','06','28','2012-2013','10','3','Tamworth',0,0),(5,'2013-07-10','2013','07','10','2012-2013','11','1','Tamworth',0,0),(6,'2013-08-22','2013','08','22','2012-2013','12','3','Tamworth',0,0),(7,'2013-09-03','2013','09','03','2012-2013','13','1','Tamworth',0,0),(8,'2013-10-16','2013','10','16','2013-2014','01','3','Tamworth',1,0),(9,'2013-10-31','2013','10','31','2013-2014','02','1','Tamworth',1,0),(10,'2013-11-26','2013','11','26','2013-2014','03','1','Tamworth',1,0),(11,'2014-01-17','2014','01','17','2013-2014','04','4','Tamworth',1,0),(12,'2014-01-20','2014','01','20','2013-2014','05','1','Tamworth',1,0),(13,'2014-02-06','2014','02','06','2013-2014','06','1','Tamworth',1,0),(14,'2014-02-21','2014','02','21','2013-2014','06','1','Tamworth',1,0),(15,'2014-03-18','2014','03','18','2013-2014','07','1','Tamworth',1,0),(16,'2014-04-30','2014','04','30','2013-2014','08','3','Tamworth',1,0),(17,'2014-05-23','2014','05','23','2013-2014','09','2','Tamworth',1,0),(18,'2014-06-10','2014','06','10','2013-2014','10','1','Tamworth',1,0),(20,'2014-07-31','2014','07','31','2013-2014','11','4','Tamworth',1,0),(21,'2014-08-15','2014','08','15','2013-2014','12','2','Tamworth',1,0),(22,'2014-09-18','2014','09','18','2013-2014','13','3','Tamworth',1,0),(23,'2014-10-07','2014','10','07','2014-2015','01','2','Tamworth',1,0),(24,'2014-11-13','2014','11','13','2014-2015','02','2','Tamworth',1,0),(25,'2014-12-12','2014','12','12','2014-2015','03','4','Tamworth',1,0),(26,'2015-01-07','2015','01','07','2014-2015','04','1','Tamworth',1,0),(27,'2015-01-27','2015','01','27','2014-2015','05','2','Tamworth',1,0),(28,'2015-03-12','2015','03','12','2014-2015','06','4','Tamworth',1,0),(29,'2015-03-31','2015','03','31','2014-2015','07','2','Tamworth',1,0),(30,'2015-04-20','2015','04','20','2014-2015','08','2','Tamworth',1,0),(31,'2015-05-20','2015','05','20','2014-2015','09','2','Tamworth',1,0),(32,'2015-06-09','2015','06','09','2014-2015','10','1','Tamworth',1,0),(33,'2015-07-14','2015','07','14','2014-2015','11','2','Tamworth',1,1),(34,'2015-08-21','2015','08','21','2014-2015','12','3','Tamworth',1,1),(35,'2015-09-11','2015','09','11','2014-2015','13','2','Tamworth',1,1),(36,'2015-10-01','2015','10','01','2015-2016','01','1','Tamworth',1,1);
/*!40000 ALTER TABLE `inspections_fresh_produce_p` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inspections_prepped`
--

DROP TABLE IF EXISTS `inspections_prepped`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inspections_prepped` (
  `InspectionID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `InspectionDate` date NOT NULL,
  `YYYY` varchar(4) NOT NULL,
  `MM` varchar(2) NOT NULL,
  `DD` varchar(2) NOT NULL,
  `YearRange` varchar(9) NOT NULL,
  `Period` varchar(2) NOT NULL,
  `WeekNo` varchar(2) NOT NULL,
  `Location` varchar(20) NOT NULL,
  `DataCheck` int(11) NOT NULL DEFAULT 0,
  `ImagesUploaded` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`InspectionID`)
) ENGINE=InnoDB AUTO_INCREMENT=290 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inspections_prepped`
--

LOCK TABLES `inspections_prepped` WRITE;
/*!40000 ALTER TABLE `inspections_prepped` DISABLE KEYS */;
INSERT INTO `inspections_prepped` VALUES (1,'2013-04-18','2013','04','18','2012-2013','08','1','Rochdale',0,0),(2,'2013-04-03','2013','04','03','2012-2013','07','3','Tamworth',0,0),(3,'2013-03-19','2013','03','19','2012-2013','07','1','Tamworth',0,0),(4,'2013-03-20','2013','03','20','2012-2013','07','1','Yate',0,0),(5,'2013-03-21','2013','03','21','2012-2013','07','1','Tamworth',0,0),(6,'2013-04-25','2013','04','25','2012-2013','08','2','Tamworth',0,0),(7,'2013-04-30','2013','04','30','2012-2013','08','3','Kent',0,0),(8,'2013-05-07','2013','05','07','2012-2013','08','4','Yate',0,0),(10,'2013-05-09','2013','05','09','2012-2013','08','4','Kent',0,0),(12,'2013-05-10','2013','05','10','2012-2013','08','4','Rochdale',0,0),(13,'2013-04-15','2013','04','15','2012-2013','08','1','Tamworth',0,0),(14,'2013-04-16','2013','04','16','2012-2013','08','1','Yate',0,0),(15,'2013-05-15','2013','05','15','2012-2013','09','1','Yate',0,0),(16,'2013-05-16','2013','05','16','2012-2013','09','1','Tamworth',0,0),(17,'2013-05-17','2013','05','17','2012-2013','09','1','Rochdale',0,0),(18,'2013-05-23','2013','05','23','2012-2013','09','2','Tamworth',0,0),(19,'2013-06-04','2013','06','04','2012-2013','09','4','Kent',0,0),(20,'2013-06-05','2013','06','05','2012-2013','09','4','Kent',0,0),(21,'2013-05-30','2013','05','30','2012-2013','09','3','Yate',0,0),(22,'2013-06-06','2013','06','06','2012-2013','09','4','Rochdale',0,0),(23,'2013-06-13','2013','06','13','2012-2013','10','1','Yate',0,0),(24,'2013-06-14','2013','06','14','2012-2013','10','1','Rochdale',0,0),(25,'2013-06-20','2013','06','20','2012-2013','10','2','Tamworth',0,0),(26,'2013-06-27','2013','06','27','2012-2013','10','3','Kent',0,0),(27,'2013-06-28','2013','06','28','2012-2013','10','3','Tamworth',0,0),(28,'2013-07-03','2013','07','03','2012-2013','10','4','Yate',0,0),(29,'2013-07-04','2013','07','04','2012-2013','10','4','Rochdale',0,0),(30,'2013-07-05','2013','07','05','2012-2013','10','4','Kent',0,0),(31,'2013-07-09','2013','07','09','2012-2013','11','1','Tamworth',0,0),(32,'2013-07-17','2013','07','17','2012-2013','11','2','Tamworth',0,0),(33,'2013-07-12','2013','07','12','2012-2013','11','1','Rochdale',0,0),(34,'2013-07-23','2013','07','23','2012-2013','11','3','Yate',0,0),(35,'2013-07-24','2013','07','24','2012-2013','11','3','Kent',0,0),(36,'2013-07-26','2013','07','26','2012-2013','11','3','Rochdale',0,0),(37,'2013-07-31','2013','07','31','2012-2013','11','4','Kent',0,0),(38,'2013-08-01','2013','08','01','2012-2013','11','4','Rochdale',0,0),(39,'2013-08-09','2013','08','09','2012-2013','12','1','Rochdale',0,0),(40,'2013-08-16','2013','08','16','2012-2013','12','2','Kent',0,0),(41,'2013-08-20','2013','08','20','2012-2013','12','3','Yate',0,0),(42,'2013-08-22','2013','08','22','2012-2013','12','3','Tamworth',0,0),(43,'2013-08-23','2013','08','23','2012-2013','12','3','Rochdale',0,0),(44,'2013-08-27','2013','08','27','2012-2013','12','4','Yate',0,0),(45,'2013-08-28','2013','08','28','2012-2013','12','4','Kent',0,0),(46,'2013-08-29','2013','08','29','2012-2013','12','4','Tamworth',0,0),(48,'2013-09-05','2013','09','05','2012-2013','13','1','Rochdale',0,0),(49,'2013-09-06','2013','09','06','2012-2013','13','1','Yate',0,0),(50,'2013-09-12','2013','09','12','2012-2013','13','2','Kent',0,0),(51,'2013-09-16','2013','09','16','2012-2013','13','3','Tamworth',0,0),(52,'2013-09-19','2013','09','19','2012-2013','13','3','Rochdale',0,0),(53,'2013-09-25','2013','09','25','2012-2013','13','4','Yate',0,0),(54,'2013-09-26','2013','09','26','2012-2013','13','4','Kent',0,0),(55,'2013-09-03','2013','09','03','2012-2013','13','1','Tamwoth',0,0),(56,'2013-10-03','2013','10','03','2013-2014','01','1','Rochdale',1,0),(57,'2013-10-11','2013','10','11','2013-2014','01','2','Yate',1,0),(58,'2013-10-10','2013','10','10','2013-2014','01','2','Rochdale',1,0),(59,'2013-10-15','2013','10','15','2013-2014','01','3','Kent',1,0),(60,'2013-10-16','2013','10','16','2013-2014','01','3','Tamworth',1,0),(61,'2013-10-18','2013','10','18','2013-2014','01','3','Yate',1,0),(62,'2013-10-22','2013','10','22','2013-2014','01','4','Kent',1,0),(63,'2013-10-24','2013','10','24','2013-2014','01','4','Tamworth',1,0),(72,'2013-10-31','2013','10','31','2013-2014','02','1','Tamworth',1,0),(73,'2013-11-01','2013','11','01','2013-2014','02','1','Yate',1,0),(74,'2013-11-05','2013','11','05','2013-2014','02','2','Yate',1,0),(75,'2013-11-15','2013','11','15','2013-2014','02','3','Kent',1,0),(76,'2013-11-18','2013','11','18','2013-2014','02','4','Warrington',1,0),(77,'2013-11-19','2013','11','19','2013-2014','02','4','Kent',1,0),(78,'2013-11-21','2013','11','21','2013-2014','02','4','Warrington',1,0),(79,'2013-11-22','2013','11','22','2013-2014','02','4','Tamworth',1,0),(81,'2013-11-26','2013','11','26','2013-2014','03','1','Tamworth',1,0),(82,'2013-11-27','2013','11','27','2013-2014','03','1','Yate',1,0),(83,'2013-12-05','2013','12','05','2013-2014','03','2','Warrington',1,0),(84,'2013-12-06','2013','12','06','2013-2014','03','2','Yate',1,0),(85,'2013-12-12','2013','12','12','2013-2014','03','3','Warrington',1,0),(86,'2013-12-13','2013','12','13','2013-2014','03','3','Kent',1,0),(87,'2013-12-14','2013','12','14','2013-2014','03','3','Tamworth',1,0),(88,'2013-12-17','2013','12','17','2013-2014','03','4','Kent',1,0),(89,'2013-12-31','2013','12','31','2013-2014','04','2','Yate',1,0),(90,'2014-01-06','2014','01','06','2013-2014','04','3','Warrington',1,0),(91,'2014-01-09','2014','01','09','2013-2014','04','3','Kent',1,0),(92,'2014-01-13','2014','01','13','2013-2014','04','4','Tamworth',1,0),(93,'2014-01-14','2014','01','14','2013-2014','04','4','Warrington',1,0),(94,'2014-01-15','2014','01','15','2013-2014','04','4','Yate',1,0),(95,'2014-01-16','2014','01','16','2013-2014','04','4','Kent',1,0),(96,'2014-01-17','2014','01','17','2013-2014','04','4','Tamworth',1,0),(97,'2014-01-20','2014','01','20','2013-2014','05','1','Tamworth',1,0),(98,'2014-01-21','2014','01','21','2013-2014','05','1','Yate',1,0),(99,'2014-01-22','2014','01','22','2013-2014','05','1','Kent',1,0),(100,'2014-01-23','2014','01','23','2013-2014','05','1','Warrington',1,0),(103,'2014-01-27','2014','01','27','2013-2014','05','2','Tamworth',1,0),(104,'2014-01-28','2014','01','28','2013-2014','05','2','Yate',1,0),(105,'2014-02-05','2014','02','05','2013-2014','05','3','Kent',1,0),(106,'2014-02-07','2014','02','07','2013-2014','05','3','Warrington',1,0),(107,'2014-02-18','2014','02','18','2013-2014','06','1','Yate',1,0),(108,'2014-02-20','2014','02','20','2013-2014','06','1','Warrington',1,0),(109,'2014-02-21','2014','02','21','2013-2014','06','1','Tamworth',1,0),(110,'2014-02-24','2014','02','24','2013-2014','06','2','Warrington',1,0),(111,'2014-02-25','2014','02','25','2013-2014','06','2','Tamworth',1,0),(112,'2014-03-04','2014','03','04','2013-2014','06','3','Yate',1,0),(113,'2014-03-05','2014','03','05','2013-2014','06','3','Kent',1,0),(114,'2014-03-05','2014','03','05','2013-2014','06','3','Kent',1,0),(115,'2014-03-14','2014','03','14','2013-2014','06','4','Kent',1,0),(116,'2014-03-18','2014','03','18','2013-2014','07','1','Tamworth',1,0),(117,'2014-03-28','2014','03','28','2013-2014','07','2','Kent',1,0),(118,'2014-04-01','2014','04','01','2013-2014','07','3','Tamworth',1,0),(119,'2014-04-02','2014','04','02','2013-2014','07','3','Yate',1,0),(120,'2014-04-10','2014','04','10','2013-2014','07','4','Warrington',1,0),(121,'2014-04-11','2014','04','11','2013-2014','07','4','Yate',1,0),(122,'2014-04-12','2014','04','12','2013-2014','07','4','Kent',1,0),(123,'2014-04-09','2014','04','09','2013-2014','07','4','Warrington',1,0),(124,'2014-04-17','2014','04','17','2013-2014','08','1','Warrington',1,0),(125,'2014-04-22','2014','04','22','2013-2014','08','1','Yate',1,0),(126,'2014-04-24','2014','04','24','2013-2014','08','1','Warrington',1,0),(127,'2014-04-29','2014','04','29','2013-2014','08','3','Yate',1,0),(128,'2014-04-30','2014','04','30','2013-2014','08','3','Tamworth',1,0),(129,'2014-05-02','2014','05','02','2013-2014','08','3','Kent',1,0),(130,'2014-05-08','2014','05','08','2013-2014','08','4','Kent',1,0),(131,'2014-05-09','2014','05','09','2013-2014','08','4','Tamworth',1,0),(132,'2014-05-12','2014','05','12','2013-2014','09','1','Tamworth',1,0),(133,'2014-05-13','2014','05','13','2013-2014','09','1','Yate',1,0),(134,'2014-05-15','2014','05','15','2013-2014','09','1','Warrington',1,0),(135,'2014-05-16','2014','05','16','2013-2014','09','1','Kent',1,0),(136,'2014-05-23','2014','05','23','2013-2014','09','2','Tamworth',1,0),(137,'2014-05-27','2014','05','27','2013-2014','09','3','Yate',1,0),(138,'2014-06-02','2014','06','02','2013-2014','09','4','Warrington',1,0),(139,'2014-06-05','2014','06','05','2013-2014','09','4','Kent',1,0),(140,'2014-06-10','2014','06','10','2013-2014','10','1','Tamworth',1,0),(141,'2014-06-13','2014','06','13','2013-2014','10','1','Kent',1,0),(142,'2014-06-17','2014','06','17','2013-2014','10','2','Yate',1,0),(143,'2014-06-19','2014','06','19','2013-2014','10','2','Tamworth',1,0),(144,'2014-06-24','2014','06','24','2013-2014','10','3','Yate',1,0),(145,'2014-06-26','2014','06','26','2013-2014','10','3','Kent',1,0),(146,'2014-07-01','2014','07','01','2013-2014','10','4','Warrington',1,0),(147,'2014-07-04','2014','07','04','2013-2014','10','4','Yate',1,0),(148,'2014-07-08','2014','07','08','2013-2014','11','1','Yate',1,0),(149,'2014-07-11','2014','07','11','2013-2014','11','1','Warrington',1,0),(150,'2014-07-15','2014','07','15','2013-2014','11','2','Kent',1,0),(151,'2014-07-22','2014','07','22','2013-2014','11','3','Yate',1,0),(152,'2014-07-24','2014','07','24','2013-2014','11','3','Tamworth',1,0),(153,'2014-07-25','2014','07','25','2013-2014','11','3','Kent',1,0),(155,'2014-07-29','2014','07','29','2013-2014','11','4','Yate',1,0),(156,'2014-07-31','2014','07','31','2013-2014','11','4','Tamworth',1,0),(157,'2014-08-07','2014','08','07','2013-2014','12','1','Yate',1,0),(158,'2014-08-12','2014','08','12','2013-2014','12','2','Warrington',1,0),(159,'2014-08-14','2014','08','14','2013-2014','12','2','Kent',1,0),(160,'2014-08-15','2014','08','15','2013-2014','12','2','Tamworth',1,0),(161,'2014-08-22','2014','08','22','2013-2014','12','3','Tamworth',1,0),(162,'2014-08-27','2014','08','27','2013-2014','12','4','Warrington',1,0),(163,'2014-08-28','2014','08','28','2013-2014','12','4','Kent',1,0),(164,'2014-08-29','2014','08','29','2013-2014','12','4','Yate',1,0),(165,'2014-09-04','2014','09','04','2013-2014','13','1','Yate',1,0),(166,'2014-09-09','2014','09','09','2013-2014','13','2','Warrington',1,0),(167,'2014-09-11','2014','09','11','2013-2014','13','2','Kent',1,0),(168,'2014-09-12','2014','09','12','2013-2014','13','2','Tamworth',1,0),(169,'2014-09-18','2014','09','18','2013-2014','13','3','Tamworth',1,0),(170,'2014-09-19','2014','09','19','2013-2014','13','3','Kent',1,0),(171,'2014-09-23','2014','09','23','2013-2014','13','4','Yate',1,0),(172,'2014-09-25','2014','09','25','2013-2014','13','4','Warrington',1,0),(173,'2014-09-29','2014','09','29','2014-2015','01','1','Warrington',1,0),(174,'2014-10-02','2014','10','02','2014-2015','01','2','Yate',1,0),(175,'2014-10-07','2014','10','07','2014-2015','01','2','Tamworth',1,0),(176,'2014-10-14','2014','10','14','2014-2015','01','3','Kent',1,0),(177,'2014-10-21','2014','10','21','2014-2015','01','4','Tamworth',1,0),(178,'2014-10-23','2014','10','23','2014-2015','01','4','Warrington',1,0),(179,'2014-10-24','2014','10','24','2014-2015','01','4','Yate',1,0),(180,'2014-10-25','2014','10','25','2014-2015','01','4','Kent',1,0),(181,'2014-11-04','2014','11','04','2014-2015','02','1','Tamworth',1,0),(182,'2014-11-06','2014','11','06','2014-2015','02','1','Warrington',1,0),(184,'2014-11-07','2014','11','07','2014-2015','02','1','Kent',1,0),(185,'2014-11-13','2014','11','13','2014-2015','02','2','Tamworth',1,0),(186,'2014-11-14','2014','11','14','2014-2015','02','2','Kent',1,0),(187,'2014-11-15','2014','11','15','2014-2015','02','2','Yate',1,0),(188,'2014-11-18','2014','11','18','2014-2015','02','3','Warrington',1,0),(189,'2014-11-20','2014','11','20','2014-2015','02','3','Yate',1,0),(190,'2014-11-26','2014','11','26','2014-2015','03','1','Warrington',1,0),(191,'2014-11-27','2014','11','27','2014-2015','03','1','Yate',1,0),(192,'2014-12-02','2014','12','02','2014-2015','03','2','Tamworth',1,0),(193,'2014-12-04','2014','12','04','2014-2015','03','2','Warrington',1,0),(194,'2014-12-05','2014','12','05','2014-2015','03','3','Kent',1,0),(195,'2014-12-09','2014','12','09','2014-2015','03','3','Yate',1,0),(196,'2014-12-12','2014','12','12','2014-2015','03','3','Tamworth',1,0),(197,'2014-12-16','2014','12','16','2014-2015','03','4','Kent',1,0),(198,'2015-01-06','2015','01','06','2014-2015','04','1','Yate',1,0),(199,'2015-01-07','2015','01','07','2014-2015','04','1','Tamworth',1,0),(200,'2015-01-08','2015','01','08','2014-2015','04','2','Warrington',1,0),(201,'2015-01-09','2015','01','09','2014-2015','04','2','Kent',1,0),(202,'2015-01-13','2015','01','13','2014-2015','04','4','Tamworth',1,0),(203,'2015-01-14','2015','01','14','2014-2015','04','4','Warrington',1,0),(204,'2015-01-15','2015','01','15','2014-2015','04','4','Kent',1,0),(206,'2015-01-16','2015','01','16','2014-2015','04','4','Yate',1,0),(207,'2015-01-20','2015','01','20','2014-2015','05','1','Tamworth',1,0),(208,'2015-01-23','2015','01','23','2014-2015','05','1','Warrington',1,0),(209,'2015-01-24','2015','01','24','2014-2015','05','1','Yate',1,0),(210,'2015-01-27','2015','01','27','2014-2015','05','2','Tamworth',1,0),(211,'2015-02-05','2015','02','05','2014-2015','05','3','Yate',1,0),(212,'2015-02-06','2015','02','06','2014-2015','05','3','Kent',1,0),(214,'2015-02-13','2015','02','13','2014-2015','05','4','Warrington',1,0),(215,'2015-02-12','2015','02','12','2014-2015','05','4','Kent',1,0),(216,'2015-02-24','2015','02','24','2014-2015','06','2','Yate',1,0),(217,'2015-03-03','2015','03','03','2014-2015','06','3','Tamworth',1,0),(219,'2015-03-04','2015','03','04','2014-2015','06','3','Yate',1,0),(220,'2015-03-06','2015','03','06','2014-2015','06','4','Warrington',1,0),(221,'2015-03-07','2015','03','07','2014-2015','06','4','Kent',1,0),(222,'2015-03-12','2015','03','12','2014-2015','06','4','Tamworth',1,0),(223,'2015-03-13','2015','03','13','2014-2015','06','4','Warrington',1,0),(224,'2015-03-14','2015','03','14','2014-2015','06','4','Kent',1,0),(225,'2015-03-20','2015','03','20','2014-2015','07','1','Yate',1,0),(226,'2015-03-26','2015','03','26','2014-2015','07','1','Kent',1,0),(227,'2015-03-27','2015','03','27','2014-2015','07','1','Yate',1,0),(228,'2015-03-31','2015','03','31','2014-2015','07','2','Tamworth',1,0),(229,'2015-04-02','2015','04','02','2014-2015','07','3','Warrington',1,0),(230,'2015-04-08','2015','04','08','2014-2015','07','4','Warrington',1,0),(231,'2015-04-09','2015','04','09','2014-2015','07','4','Kent',1,0),(232,'2015-04-10','2015','04','10','2014-2015','07','4','Tamworth',1,0),(234,'2015-04-14','2015','04','14','2014-2015','08','1','Tamworth',1,0),(235,'2015-04-16','2015','04','16','2014-2015','08','1','Warrington',1,0),(236,'2015-04-17','2015','04','17','2014-2015','08','1','Yate',1,0),(237,'2015-04-20','2015','04','20','2014-2015','08','2','Tamworth',1,0),(238,'2015-04-28','2015','04','28','2014-2015','08','3','Kent',1,0),(239,'2015-05-05','2015','05','05','2014-2015','08','4','Kent',1,0),(240,'2015-05-07','2015','05','07','2014-2015','08','4','Warrington',1,0),(241,'2015-05-08','2015','05','08','2014-2015','08','4','Yate',1,0),(242,'2015-05-20','2015','05','20','2014-2015','09','2','Tamworth',1,0),(243,'2015-05-22','2015','05','22','2014-2015','09','2','Yate',1,0),(244,'2015-05-26','2015','05','26','2014-2015','09','3','Kent',1,0),(245,'2015-05-27','2015','05','27','2014-2015','09','3','Yate',1,0),(246,'2015-06-02','2015','06','02','2014-2015','09','4','Tamworth',1,0),(247,'2015-06-04','2015','06','04','2014-2015','09','4','Warrington',1,0),(248,'2015-06-05','2015','06','05','2014-2015','09','4','Kent',1,0),(249,'2015-06-09','2015','06','09','2014-2015','10','1','Tamworth',1,0),(250,'2015-06-13','2015','06','13','2014-2015','10','1','Yate',1,0),(251,'2015-06-16','2015','06','16','2014-2015','10','2','Warrington',1,0),(252,'2015-06-19','2015','06','19','2014-2015','10','2','Yate',1,0),(253,'2015-06-20','2015','06','20','2014-2015','10','2','Warrington',1,0),(254,'2015-06-23','2015','06','23','2014-2015','10','3','Kent',1,0),(255,'2015-06-26','2015','06','26','2014-2015','10','3','Kent',1,0),(256,'2015-07-03','2015','07','03','2014-2015','10','4','Kent',1,0),(257,'2015-07-07','2015','07','07','2014-2015','11','1','Warrington',1,0),(258,'2015-07-10','2015','07','10','2014-2015','11','1','Yate',1,0),(259,'2015-07-14','2015','07','14','2014-2015','11','2','Tamworth',1,0),(260,'2015-07-21','2015','07','21','2014-2015','11','3','Yate',1,0),(261,'2015-07-24','2015','07','24','2014-2015','11','4','Yate',1,0),(262,'2015-07-29','2015','07','29','2014-2015','11','4','Yate',1,0),(263,'2015-07-30','2015','07','30','2014-2015','11','4','Kent',1,0),(264,'2015-07-31','2015','07','31','2014-2015','11','4','Kent',1,1),(265,'2015-08-05','2015','08','05','2014-2015','12','1','Tamworth',1,1),(266,'2015-08-14','2015','08','14','2014-2015','12','2','Warrington',1,1),(267,'2015-08-21','2015','08','21','2014-2015','12','3','Tamworth',1,1),(268,'2015-08-22','2015','08','22','2014-2015','12','3','Kent',1,1),(269,'2015-08-25','2015','08','25','2014-2015','12','4','Warrington',1,1),(270,'2015-08-26','2015','08','26','2014-2015','12','4','Yate',1,1),(271,'2015-08-28','2015','08','28','2014-2015','12','4','Kent',1,1),(272,'2015-08-27','2015','08','27','2014-2015','12','4','Yate',1,1),(273,'2015-09-11','2015','09','11','2014-2015','13','2','Tamworth',1,1),(274,'2015-09-14','2015','09','14','2014-2015','13','3','Warrington',1,1),(275,'2015-09-15','2015','09','15','2014-2015','13','3','Yate',1,1),(276,'2015-09-16','2015','09','16','2014-2015','13','3','Tamworth',1,1),(277,'2015-09-18','2015','09','18','2014-2015','13','4','Warrington',1,1),(278,'2015-09-22','2015','09','22','2014-2015','13','4','Kent',1,1),(279,'2015-09-24','2015','09','24','2014-2015','13','4','Yate',1,1),(280,'2015-09-25','2015','09','25','2014-2015','13','4','Kent',1,1),(281,'2015-10-01','2015','10','01','2015-2016','01','1','Tamworth',1,1),(282,'2015-10-02','2015','10','02','2015-2016','01','1','Kent',1,1),(283,'2015-10-06','2015','10','06','2015-2016','01','2','Yate',1,1),(285,'2015-10-08','2015','10','08','2015-2016','01','2','Warrington',1,1),(286,'2015-10-15','2015','10','15','2015-2016','01','3','Yate',1,1),(287,'2015-10-16','2015','10','16','2015-2016','01','3','Kent',1,1),(289,'2015-10-16','2015','10','16','2015-2016','01','3','Tamworth',1,1);
/*!40000 ALTER TABLE `inspections_prepped` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-05-16 18:54:10
