Created
February 14, 2017 20:44
-
-
Save amfriedman/7aab1b8d23c87620bfe5f2add470416c to your computer and use it in GitHub Desktop.
SQL ranking problem
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # ************************************************************ | |
| /*!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 */; | |
| /*!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 */; | |
| # Dump of table candidates | |
| # ------------------------------------------------------------ | |
| DROP TABLE IF EXISTS `candidates`; | |
| CREATE TABLE `candidates` ( | |
| `id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
| `ocd_id` varchar(255) NOT NULL COMMENT 'Open Civic Data identifier', | |
| `votesmart_id` int(10) unsigned DEFAULT NULL, | |
| `is_pseudocandidate` tinyint(1) NOT NULL, | |
| `is_pseudocandidate_all_other_candidates` tinyint(1) unsigned NOT NULL, | |
| `is_pseudocandidate_total_votes` tinyint(1) unsigned NOT NULL, | |
| `is_pseudocandidate_total_ballots` tinyint(1) unsigned NOT NULL, | |
| `display_order` int(2) NOT NULL, | |
| `slug` varchar(100) NOT NULL, | |
| `display_name` varchar(100) DEFAULT NULL, | |
| `first_name` varchar(50) NOT NULL, | |
| `nick_name` varchar(50) DEFAULT NULL, | |
| `middle_name` varchar(50) DEFAULT NULL, | |
| `last_name` varchar(50) NOT NULL, | |
| `suffix` varchar(10) DEFAULT NULL, | |
| `name_for_search` varchar(100) NOT NULL, | |
| `title` varchar(50) DEFAULT NULL, | |
| `date_of_birth` date DEFAULT NULL, | |
| `n_contests` int(3) unsigned NOT NULL DEFAULT '0', | |
| `created_at` datetime NOT NULL, | |
| `source_file_id` int(6) unsigned DEFAULT NULL, | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `votesmart_id` (`votesmart_id`), | |
| KEY `source_file_id` (`source_file_id`), | |
| KEY `first_name` (`first_name`,`middle_name`,`last_name`), | |
| KEY `last_name` (`last_name`), | |
| KEY `name_for_search` (`name_for_search`), | |
| KEY `slug` (`slug`), | |
| KEY `display_name` (`display_name`), | |
| KEY `is_pseudocandidate` (`is_pseudocandidate`), | |
| KEY `display_order` (`display_order`), | |
| FULLTEXT KEY `ft-display_name-nick_name` (`display_name`,`nick_name`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| LOCK TABLES `candidates` WRITE; | |
| /*!40000 ALTER TABLE `candidates` DISABLE KEYS */; | |
| INSERT INTO `candidates` (`id`, `ocd_id`, `votesmart_id`, `is_pseudocandidate`, `is_pseudocandidate_all_other_candidates`, `is_pseudocandidate_total_votes`, `is_pseudocandidate_total_ballots`, `display_order`, `slug`, `display_name`, `first_name`, `nick_name`, `middle_name`, `last_name`, `suffix`, `name_for_search`, `title`, `date_of_birth`, `n_contests`, `created_at`, `source_file_id`) | |
| VALUES | |
| (1,'',NULL,1,0,0,1,100,'Total-Ballots-Cast','Total Ballots Cast','','Total Ballots',NULL,'Total Ballots Cast',NULL,'TotalBallotsTotalBallotsCast',NULL,NULL,0,'2017-01-26 00:15:58',NULL), | |
| (2,'',NULL,1,0,1,0,90,'Total-Votes-Cast','Total Votes Cast','','Total Votes',NULL,'Total Votes Cast',NULL,'TotalVotesTotalVotesCast',NULL,NULL,0,'2017-01-26 00:15:58',NULL), | |
| (3,'',NULL,1,0,0,0,60,'Blank-Votes','Blank Votes','','Blanks',NULL,'Blank Votes',NULL,'BlanksBlankVotes',NULL,NULL,0,'2017-01-26 00:15:58',NULL), | |
| (4,'',NULL,1,0,0,0,70,'Spoiled-Votes','Spoiled Votes','','Spoiled',NULL,'Spoiled Votes',NULL,'SpoiledSpoiledVotes',NULL,NULL,0,'2017-01-26 00:15:58',NULL), | |
| (5,'',NULL,1,0,0,0,80,'No-Preference-Votes','No Preference Votes','','No Preference',NULL,'No Preference Votes',NULL,'NoPreferenceNoPreferenceVotes',NULL,NULL,0,'2017-01-26 00:15:58',NULL), | |
| (6,'',NULL,1,1,0,0,50,'All-Other-Votes','All Other Votes','','All Others',NULL,'All Other Votes',NULL,'AllOthersAllOtherVotes',NULL,NULL,0,'2017-01-26 00:15:58',NULL), | |
| (21,'',NULL,0,0,0,0,0,'George-Demo-Washington','George Demo Washington','George',NULL,'Demo','Washington',NULL,'GeorgeDemoWashington',NULL,NULL,2,'2017-01-26 00:15:58',NULL), | |
| (22,'',NULL,0,0,0,0,0,'Abraham-Demo-Lincoln','Abraham Demo Lincoln','Abraham',NULL,'Demo','Lincoln',NULL,'AbrahamDemoLincoln',NULL,NULL,2,'2017-01-26 00:15:58',NULL), | |
| (23,'',NULL,0,0,0,0,0,'Theodore-Demo-Roosevelt','Theodore Demo Roosevelt','Theodore',NULL,'Demo','Roosevelt',NULL,'TheodoreDemoRoosevelt',NULL,NULL,2,'2017-01-26 00:15:58',NULL), | |
| (24,'',NULL,0,0,0,0,0,'Andrew-Demo-Jackson','Andrew Demo Jackson','Andrew',NULL,'Demo','Jackson',NULL,'AndrewDemoJackson',NULL,NULL,2,'2017-01-26 00:15:58',NULL); | |
| /*!40000 ALTER TABLE `candidates` ENABLE KEYS */; | |
| UNLOCK TABLES; | |
| # Dump of table candidates_contests_divisions | |
| # ------------------------------------------------------------ | |
| DROP TABLE IF EXISTS `candidates_contests_divisions`; | |
| CREATE TABLE `candidates_contests_divisions` ( | |
| `id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
| `division_id` int(11) unsigned NOT NULL, | |
| `contest_id` int(8) unsigned NOT NULL, | |
| `candidate_id` int(8) unsigned NOT NULL, | |
| `is_winner` tinyint(1) NOT NULL, | |
| `n_votes` int(10) DEFAULT NULL, | |
| `pct_candidate_votes` decimal(10,9) DEFAULT NULL, | |
| `pct_raw_votes` decimal(10,9) DEFAULT NULL, | |
| `is_partial_division` tinyint(1) NOT NULL, | |
| `source_id` int(10) unsigned DEFAULT NULL, | |
| `source_page` int(10) unsigned DEFAULT NULL, | |
| `source_row` int(10) unsigned DEFAULT NULL, | |
| `created_at` datetime NOT NULL, | |
| PRIMARY KEY (`id`), | |
| UNIQUE KEY `division_id` (`division_id`,`contest_id`,`candidate_id`), | |
| KEY `contest_id` (`contest_id`), | |
| KEY `candidate_id` (`candidate_id`), | |
| KEY `n_votes` (`n_votes`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| LOCK TABLES `candidates_contests_divisions` WRITE; | |
| /*!40000 ALTER TABLE `candidates_contests_divisions` DISABLE KEYS */; | |
| INSERT INTO `candidates_contests_divisions` (`id`, `division_id`, `contest_id`, `candidate_id`, `is_winner`, `n_votes`, `pct_candidate_votes`, `pct_raw_votes`, `is_partial_division`, `source_id`, `source_page`, `source_row`, `created_at`) | |
| VALUES | |
| (1,10,1,21,0,164,0.108825481,0.108036890,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (2,11,1,21,1,1479,0.717612809,0.712771084,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (3,15,1,21,0,329,0.315134099,0.290893015,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (4,14,1,21,0,821,0.156589738,0.156172722,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (5,12,1,21,1,986,0.469077069,0.467520151,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (6,13,1,21,1,6078,0.977799227,0.977484721,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (7,13,1,22,0,133,0.021396396,0.021389514,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (8,12,1,22,0,932,0.443387250,0.441915599,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (9,15,1,22,1,666,0.637931034,0.588859416,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (10,10,1,22,1,1332,0.883875248,0.877470355,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (11,11,1,22,0,533,0.258612324,0.256867469,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (12,14,1,22,1,4395,0.838260537,0.836028152,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (13,13,1,6,0,5,0.000804375,0.000804117,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (14,15,1,6,0,49,0.046934865,0.043324491,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (15,10,1,6,0,11,0.007299270,0.007246376,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (16,11,1,6,0,49,0.023774866,0.023614457,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (17,14,1,6,0,27,0.005149723,0.005136009,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (18,12,1,6,0,184,0.087535680,0.087245139,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (19,12,1,3,0,7,0.003330161,0.003319108,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (20,14,1,3,0,14,0.002670226,0.002663115,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (21,11,1,3,0,14,0.006792819,0.006746987,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (22,10,1,3,0,11,0.007299270,0.007246376,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (23,13,1,3,0,2,0.000321750,0.000321646,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (24,15,1,3,0,87,0.083333333,0.076923076,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (25,12,2,23,0,126,0.091106290,0.087927424,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (26,14,2,23,0,1134,0.234588332,0.234491315,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (27,13,2,23,1,1134,0.537186167,0.533898305,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (28,10,2,23,0,756,0.479695431,0.476670870,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (29,11,2,23,1,1134,0.670609107,0.666666666,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (30,15,2,23,1,3276,0.748286888,0.746071509,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (31,11,2,24,0,544,0.321703134,0.319811875,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (32,12,2,24,1,1223,0.884309472,0.853454291,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (33,13,2,24,0,951,0.450497394,0.447740112,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (34,10,2,24,1,816,0.517766497,0.514501891,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (35,15,2,24,0,951,0.217222476,0.216579366,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (36,14,2,24,1,3670,0.759205626,0.758891645,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (37,13,2,6,0,26,0.012316437,0.012241054,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (38,11,2,6,0,13,0.007687758,0.007642563,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (39,14,2,6,0,30,0.006206040,0.006203473,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (40,10,2,6,0,4,0.002538071,0.002522068,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (41,12,2,6,0,34,0.024584237,0.023726448,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (42,15,2,6,0,151,0.034490634,0.034388521,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (43,15,2,3,0,13,0.002969392,0.002960601,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (44,10,2,3,0,10,0.006345177,0.006305170,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (45,13,2,3,0,13,0.006158218,0.006120527,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (46,11,2,3,0,10,0.005913660,0.005878894,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (47,14,2,3,0,2,0.000413736,0.000413564,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (48,12,2,3,0,50,0.036153289,0.034891835,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (49,15,3,21,1,1950,0.583133971,0.561474229,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (50,10,3,21,0,1733,0.254329321,0.250180453,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (51,14,3,21,0,866,0.271473354,0.233549083,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (52,13,3,21,0,1300,0.357044767,0.355482636,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (53,11,3,21,0,650,0.252623396,0.249520153,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (54,12,3,21,1,6498,0.825038090,0.808410052,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (55,14,3,24,1,2242,0.702821316,0.604638619,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (56,12,3,24,0,1345,0.170771965,0.167330181,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (57,13,3,24,1,2242,0.615764899,0.613070823,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (58,15,3,24,0,1345,0.402212918,0.387273250,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (59,11,3,24,1,1345,0.522736105,0.516314779,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (60,10,3,24,1,4933,0.723950689,0.712140897,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (61,13,3,6,0,99,0.027190332,0.027071369,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (62,10,3,6,0,148,0.021719988,0.021365670,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (63,12,3,6,0,33,0.004189944,0.004105498,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (64,15,3,6,0,49,0.014653110,0.014108839,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (65,14,3,6,0,82,0.025705329,0.022114347,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (66,11,3,6,0,578,0.224640497,0.221880998,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (67,15,3,3,0,129,0.038576555,0.037143679,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (68,11,3,3,0,32,0.012436844,0.012284069,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (69,12,3,3,0,162,0.020568816,0.020154267,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (70,13,3,3,0,16,0.004394397,0.004375170,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (71,10,3,3,0,113,0.016583504,0.016312978,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (72,14,3,3,0,518,0.162382445,0.139697950,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (73,12,4,21,0,719,0.073367346,0.073135998,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (74,11,4,21,0,1294,0.356768679,0.355592195,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (75,13,4,21,1,863,0.480244852,0.477851605,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (76,10,4,21,0,144,0.128456735,0.127772848,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (77,18,4,21,0,719,0.293469387,0.279766536,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (78,14,4,21,1,1150,0.798611111,0.785519125,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (79,17,4,21,0,1150,0.350930729,0.348062953,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (80,15,4,21,1,5462,0.759349367,0.757769145,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (81,15,4,24,0,1563,0.217294591,0.216842397,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (82,10,4,24,1,893,0.796610169,0.792369121,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (83,13,4,24,0,446,0.248191430,0.246954595,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (84,11,4,24,1,2232,0.615384615,0.613355317,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (85,18,4,24,1,1563,0.637959183,0.608171206,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (86,17,4,24,1,2009,0.613060726,0.608050847,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (87,14,4,24,0,223,0.154861111,0.152322404,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (88,12,4,24,1,8930,0.911224489,0.908351134,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (89,15,4,6,0,168,0.023356040,0.023307436,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (90,12,4,6,0,151,0.015408163,0.015359576,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (91,18,4,6,0,168,0.068571428,0.065369649,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (92,14,4,6,0,67,0.046527777,0.045765027,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (93,17,4,6,0,118,0.036008544,0.035714285,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (94,11,4,6,0,101,0.027846705,0.027754877,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (95,10,4,6,0,84,0.074933095,0.074534161,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (96,13,4,6,0,488,0.271563717,0.270210409,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (97,10,4,3,0,6,0.005352363,0.005323868,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (98,12,4,3,0,31,0.003163265,0.003153290,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (99,13,4,3,0,9,0.005008347,0.004983388,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (100,17,4,3,0,27,0.008239243,0.008171912,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (101,11,4,3,0,12,0.003308519,0.003297609,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (102,15,4,3,0,15,0.002085360,0.002081021,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (103,14,4,3,0,24,0.016666666,0.016393442,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (104,18,4,3,0,120,0.048979591,0.046692607,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (105,18,5,22,0,187,0.074030087,0.072734344,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (106,14,5,22,0,937,0.454633672,0.441772748,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (107,17,5,22,1,562,0.502683363,0.453591606,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (108,13,5,22,1,1874,0.702925731,0.586908863,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (109,12,5,22,0,562,0.337740384,0.323174238,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (110,11,5,22,0,562,0.349285270,0.319318181,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (111,15,5,22,0,749,0.241690868,0.233697347,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (112,10,5,22,0,9555,0.442013230,0.439552856,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (113,15,5,23,1,2306,0.744111003,0.719500780,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (114,12,5,23,1,1025,0.615985576,0.589419206,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (115,17,5,23,0,512,0.457960644,0.413236481,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (116,13,5,23,0,256,0.096024006,0.080175383,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (117,14,5,23,1,1025,0.497331392,0.483262611,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (118,11,5,23,1,1025,0.637041640,0.582386363,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (119,18,5,23,1,2306,0.912905779,0.896927265,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (120,10,5,23,1,12040,0.556969052,0.553868801,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (121,10,5,6,0,22,0.001017717,0.001012052,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (122,14,5,6,0,99,0.048034934,0.046676096,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (123,17,5,6,0,44,0.039355992,0.035512510,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (124,18,5,6,0,33,0.013064133,0.012835472,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (125,15,5,6,0,44,0.014198128,0.013728549,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (126,12,5,6,0,77,0.046274038,0.044278320,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (127,11,5,6,0,22,0.013673088,0.012500000,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (128,13,5,6,0,536,0.201050262,0.167867209,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (129,11,5,3,0,151,0.093847110,0.085795454,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (130,18,5,3,0,45,0.017814726,0.017502917,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (131,14,5,3,0,60,0.029112081,0.028288543,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (132,17,5,3,0,121,0.108228980,0.097659402,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (133,15,5,3,0,106,0.034204582,0.033073322,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (134,12,5,3,0,75,0.045072115,0.043128234,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (135,10,5,3,0,121,0.005597446,0.005566289,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (136,13,5,3,0,527,0.197674418,0.165048543,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (137,17,6,23,1,3413,0.651957975,0.642749529,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (138,13,6,23,1,3413,0.621110100,0.618409132,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (139,14,6,23,0,488,0.139628040,0.138991740,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (140,11,6,23,0,4388,0.262157963,0.261938872,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (141,15,6,23,1,2925,0.777305341,0.774014289,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (142,12,6,23,1,2438,0.600788565,0.597256246,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (143,18,6,23,0,488,0.118937362,0.118734793,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (144,10,6,23,1,21447,0.898266041,0.897814802,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (145,18,6,24,1,2545,0.620277845,0.619221411,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (146,15,6,24,0,636,0.169014084,0.168298491,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (147,13,6,24,0,1909,0.347406733,0.345895995,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (148,10,6,24,0,2227,0.093273580,0.093226724,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (149,12,6,24,0,1591,0.392065056,0.389759921,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (150,14,6,24,1,2863,0.819170243,0.815437197,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (151,17,6,24,0,1591,0.303915950,0.299623352,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (152,11,6,24,1,12090,0.722308519,0.721704871,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (153,11,6,6,0,260,0.015533516,0.015520534,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (154,12,6,6,0,29,0.007146377,0.007104360,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (155,10,6,6,0,202,0.008460378,0.008456128,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (156,13,6,6,0,173,0.031483166,0.031346258,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (157,15,6,6,0,202,0.053680574,0.053453294,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (158,17,6,6,0,231,0.044126074,0.043502824,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (159,14,6,6,0,144,0.041201716,0.041013956,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (160,18,6,6,0,1070,0.260784791,0.260340632,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (161,18,6,3,0,7,0.001706068,0.001703163,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (162,11,6,3,0,14,0.000836420,0.000835721,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (163,10,6,3,0,12,0.000502596,0.000502344,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (164,13,6,3,0,24,0.004367606,0.004348613,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (165,14,6,3,0,16,0.004577968,0.004557106,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (166,12,6,3,0,24,0.005914243,0.005879470,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (167,15,6,3,0,16,0.004251926,0.004233924,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (168,17,6,3,0,75,0.014326647,0.014124293,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (169,14,7,21,1,45,0.043310875,0.042816365,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (170,11,7,21,1,30,0.096463022,0.095846645,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (171,12,7,21,1,60,0.310880829,0.294117647,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (172,13,7,21,1,30,0.096153846,0.091743119,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (173,10,7,21,1,120,0.701754385,0.579710144,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (174,15,7,21,1,612,0.419753086,0.415760869,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (175,11,7,22,1,61,0.196141479,0.194888178,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (176,13,7,22,1,61,0.195512820,0.186544342,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (177,10,7,22,1,20,0.116959064,0.096618357,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (178,12,7,22,1,102,0.528497409,0.500000000,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (179,15,7,22,1,163,0.111796982,0.110733695,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (180,14,7,22,1,815,0.784408084,0.775451950,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (181,12,7,24,1,22,0.113989637,0.107843137,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (182,10,7,24,1,22,0.128654970,0.106280193,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (183,13,7,24,1,196,0.628205128,0.599388379,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (184,14,7,24,1,175,0.168431183,0.166508087,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (185,11,7,24,1,218,0.700964630,0.696485623,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (186,15,7,24,1,676,0.463648834,0.459239130,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (187,12,7,6,0,9,0.046632124,0.044117647,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (188,15,7,6,0,7,0.004801097,0.004755434,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (189,11,7,6,0,2,0.006430868,0.006389776,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (190,14,7,6,0,4,0.003849855,0.003805899,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (191,10,7,6,0,9,0.052631578,0.043478260,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (192,13,7,6,0,25,0.080128205,0.076452599,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (193,15,7,3,0,14,0.009602194,0.009510869,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (194,12,7,3,0,11,0.056994818,0.053921568,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (195,14,7,3,0,12,0.011549566,0.011417697,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (196,13,7,3,0,15,0.048076923,0.045871559,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (197,11,7,3,0,2,0.006430868,0.006389776,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (198,10,7,3,0,36,0.210526315,0.173913043,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (199,8,1,21,0,2629,0.463668430,0.461066292,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (200,9,1,21,1,7228,0.578101255,0.573377756,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (201,9,1,22,0,5194,0.415420299,0.412026019,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (202,8,1,22,1,2797,0.493298059,0.490529638,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (203,9,1,6,0,81,0.006478445,0.006425511,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (204,8,1,6,0,244,0.043033509,0.042792002,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (205,8,1,3,0,32,0.005643738,0.005612065,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (206,9,1,3,0,103,0.008238022,0.008170712,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (214,4,1,21,1,9857,0.542398063,0.538398514,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (215,4,1,22,0,7991,0.439718263,0.436475857,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (216,4,1,6,0,325,0.017883673,0.017751802,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (217,4,1,3,0,135,0.007428602,0.007373825,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (221,16,1,21,1,9857,0.542398063,0.538398514,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (222,1,1,21,1,9857,0.542398063,0.538398514,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (223,16,1,22,0,7991,0.439718263,0.436475857,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (224,1,1,22,0,7991,0.439718263,0.436475857,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (225,16,1,6,0,325,0.017883673,0.017751802,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (226,1,1,6,0,325,0.017883673,0.017751802,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (227,16,1,3,0,135,0.007428602,0.007373825,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (228,1,1,3,0,135,0.007428602,0.007373825,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (236,7,1,21,1,19714,0.542398063,0.538398514,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (237,7,1,22,0,15982,0.439718263,0.436475857,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (238,7,1,6,0,650,0.017883673,0.017751802,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (239,7,1,3,0,270,0.007428602,0.007373825,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (243,8,2,23,0,2016,0.433548387,0.427118644,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (244,9,2,23,0,5544,0.489622891,0.488415117,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (245,8,2,24,1,2583,0.555483870,0.547245762,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (246,9,2,24,1,5572,0.492095734,0.490881860,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (247,9,2,6,0,207,0.018281374,0.018236278,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (248,8,2,6,0,51,0.010967741,0.010805084,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (249,9,2,3,0,28,0.002472842,0.002466743,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (250,8,2,3,0,70,0.015053763,0.014830508,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (258,4,2,23,0,7560,0.473298691,0.470412544,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (259,4,2,24,1,8155,0.510549051,0.507435753,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (260,4,2,6,0,258,0.016152256,0.016053761,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (261,4,2,3,0,98,0.006135353,0.006097940,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (265,16,2,23,0,7560,0.473298691,0.470412544,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (266,1,2,23,0,7560,0.473298691,0.470412544,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (267,16,2,24,1,8155,0.510549051,0.507435753,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (268,1,2,24,1,8155,0.510549051,0.507435753,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (269,16,2,6,0,258,0.016152256,0.016053761,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (270,1,2,6,0,258,0.016152256,0.016053761,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (271,16,2,3,0,98,0.006135353,0.006097940,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (272,1,2,3,0,98,0.006135353,0.006097940,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (280,7,2,23,0,15120,0.473298691,0.470412544,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (281,7,2,24,1,16310,0.510549051,0.507435753,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (282,7,2,6,0,516,0.016152256,0.016053761,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (283,7,2,3,0,196,0.006135353,0.006097940,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (287,9,3,21,0,4116,0.404520884,0.379774866,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (288,8,3,21,1,8881,0.514452876,0.505463858,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (289,9,3,24,1,5829,0.572874692,0.537829857,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (290,8,3,24,0,7623,0.441580258,0.433864541,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (291,9,3,6,0,230,0.022604422,0.021221627,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (292,8,3,6,0,759,0.043966865,0.043198634,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (293,9,3,3,0,663,0.065159705,0.061173648,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (294,8,3,3,0,307,0.017783699,0.017472965,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (302,4,3,21,0,12997,0.473686128,0.457511968,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (303,4,3,24,1,13452,0.490268970,0.473528583,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (304,4,3,6,0,989,0.036044901,0.034814136,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (305,4,3,3,0,970,0.035352430,0.034145311,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (309,16,3,21,0,12997,0.473686128,0.457511968,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (310,1,3,21,0,12997,0.473686128,0.457511968,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (311,16,3,24,1,13452,0.490268970,0.473528583,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (312,1,3,24,1,13452,0.490268970,0.473528583,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (313,16,3,6,0,989,0.036044901,0.034814136,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (314,1,3,6,0,989,0.036044901,0.034814136,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (315,16,3,3,0,970,0.035352430,0.034145311,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (316,1,3,3,0,970,0.035352430,0.034145311,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (324,7,3,21,0,25994,0.473686128,0.457511968,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (325,7,3,24,1,26904,0.490268970,0.473528583,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (326,7,3,6,0,1978,0.036044901,0.034814136,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (327,7,3,3,0,1940,0.035352430,0.034145311,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (331,8,4,21,0,2157,0.148267803,0.147770089,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (332,9,4,21,1,7475,0.716682646,0.713399503,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (333,3,4,21,0,1869,0.326348873,0.318181818,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (334,9,4,24,0,2232,0.213998082,0.213017751,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (335,8,4,24,1,12055,0.828636238,0.825854627,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (336,3,4,24,1,3572,0.623712240,0.608103506,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (337,9,4,6,0,723,0.069319271,0.069001717,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (338,8,4,6,0,336,0.023095958,0.023018428,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (339,3,4,6,0,286,0.049938885,0.048689138,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (340,8,4,3,0,49,0.003368160,0.003356854,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (341,9,4,3,0,48,0.004602109,0.004581026,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (342,3,4,3,0,147,0.025667888,0.025025536,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (346,4,4,21,0,9632,0.385619345,0.384127617,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (347,16,4,21,0,1869,0.326348873,0.318181818,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (348,2,4,21,0,1869,0.326348873,0.318181818,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (349,4,4,24,1,14287,0.571983345,0.569770687,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (350,16,4,24,1,3572,0.623712240,0.608103506,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (351,2,4,24,1,3572,0.623712240,0.608103506,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (352,4,4,6,0,1059,0.042397309,0.042233300,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (353,16,4,6,0,286,0.049938885,0.048689138,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (354,2,4,6,0,286,0.049938885,0.048689138,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (355,4,4,3,0,97,0.003883417,0.003868394,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (356,16,4,3,0,147,0.025667888,0.025025536,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (357,2,4,3,0,147,0.025667888,0.025025536,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (361,1,4,21,0,9632,0.385619345,0.384127617,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (362,7,4,21,0,1869,0.326348873,0.318181818,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (363,1,4,24,1,14287,0.571983345,0.569770687,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (364,7,4,24,1,3572,0.623712240,0.608103506,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (365,1,4,6,0,1059,0.042397309,0.042233300,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (366,7,4,6,0,286,0.049938885,0.048689138,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (367,1,4,3,0,97,0.003883417,0.003868394,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (368,7,4,3,0,147,0.025667888,0.025025536,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (377,3,5,22,0,749,0.205543358,0.196587926,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (378,9,5,22,0,3560,0.454893943,0.417889423,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (379,8,5,22,0,10679,0.429047810,0.423148551,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (380,9,5,23,1,3587,0.458343981,0.421058809,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (381,8,5,23,1,14090,0.566090799,0.558307247,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (382,3,5,23,1,2818,0.773326015,0.739632545,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (383,8,5,6,0,121,0.004861390,0.004794547,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (384,9,5,6,0,679,0.086762075,0.079704190,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (385,3,5,6,0,77,0.021130625,0.020209973,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (386,8,5,3,0,347,0.013941341,0.013749653,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (387,3,5,3,0,166,0.045554335,0.043569553,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (388,9,5,3,0,693,0.088550983,0.081347576,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (392,16,5,22,0,749,0.205543358,0.196587926,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (393,2,5,22,0,749,0.205543358,0.196587926,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (394,4,5,22,0,14239,0.435230468,0.421821305,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (395,4,5,23,1,17677,0.540316664,0.523669866,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (396,16,5,23,1,2818,0.773326015,0.739632545,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (397,2,5,23,1,2818,0.773326015,0.739632545,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (398,4,5,6,0,800,0.024452867,0.023699490,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (399,16,5,6,0,77,0.021130625,0.020209973,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (400,2,5,6,0,77,0.021130625,0.020209973,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (401,4,5,3,0,1040,0.031788727,0.030809337,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (402,16,5,3,0,166,0.045554335,0.043569553,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (403,2,5,3,0,166,0.045554335,0.043569553,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (407,7,5,22,0,749,0.205543358,0.196587926,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (408,1,5,22,0,14239,0.435230468,0.421821305,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (409,1,5,23,1,17677,0.540316664,0.523669866,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (410,7,5,23,1,2818,0.773326015,0.739632545,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (411,1,5,6,0,800,0.024452867,0.023699490,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (412,7,5,6,0,77,0.021130625,0.020209973,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (413,1,5,3,0,1040,0.031788727,0.030809337,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (414,7,5,3,0,166,0.045554335,0.043569553,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (423,3,6,23,0,3901,0.417755408,0.414118895,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (424,9,6,23,1,6826,0.535246608,0.532906550,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (425,8,6,23,1,28273,0.632902041,0.632194445,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (426,3,6,24,1,4136,0.442921396,0.439065817,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (427,9,6,24,0,5408,0.424057084,0.422203138,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (428,8,6,24,0,15908,0.356106733,0.355708599,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (429,8,6,6,0,491,0.010991224,0.010978936,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (430,9,6,6,0,519,0.040696306,0.040518385,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (431,3,6,6,0,1301,0.139323195,0.138110403,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (432,3,6,3,0,82,0.008781323,0.008704883,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (433,8,6,3,0,50,0.001119269,0.001118017,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (434,9,6,3,0,56,0.004391123,0.004371925,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (438,16,6,23,0,3901,0.417755408,0.414118895,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (439,2,6,23,0,3901,0.417755408,0.414118895,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (440,4,6,23,1,35099,0.611214627,0.610088474,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (441,16,6,24,1,4136,0.442921396,0.439065817,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (442,2,6,24,1,4136,0.442921396,0.439065817,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (443,4,6,24,0,21316,0.371197213,0.370513288,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (444,4,6,6,0,1010,0.017588158,0.017555752,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (445,16,6,6,0,1301,0.139323195,0.138110403,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (446,2,6,6,0,1301,0.139323195,0.138110403,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (447,16,6,3,0,82,0.008781323,0.008704883,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (448,2,6,3,0,82,0.008781323,0.008704883,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (449,4,6,3,0,106,0.001845885,0.001842484,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (453,7,6,23,0,3901,0.417755408,0.414118895,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (454,1,6,23,1,35099,0.611214627,0.610088474,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (455,7,6,24,1,4136,0.442921396,0.439065817,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (456,1,6,24,0,21316,0.371197213,0.370513288,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (457,1,6,6,0,1010,0.017588158,0.017555752,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (458,7,6,6,0,1301,0.139323195,0.138110403,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (459,7,6,3,0,82,0.008781323,0.008704883,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (460,1,6,3,0,106,0.001845885,0.001842484,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (469,9,7,21,1,687,0.244571021,0.241052631,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (470,8,7,21,1,210,0.311111111,0.290055248,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (471,8,7,22,1,183,0.271111111,0.252762430,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (472,9,7,22,1,1039,0.369882520,0.364561403,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (473,8,7,24,1,262,0.388148148,0.361878453,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (474,9,7,24,1,1047,0.372730509,0.367368421,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (475,8,7,6,0,20,0.029629629,0.027624309,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (476,9,7,6,0,36,0.012815948,0.012631578,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (477,9,7,3,0,41,0.014595941,0.014385964,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (478,8,7,3,0,49,0.072592592,0.067679558,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (484,4,7,21,1,897,0.257462686,0.250979294,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (485,4,7,22,1,1222,0.350746268,0.341913822,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (486,4,7,24,1,1309,0.375717566,0.366256295,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (487,4,7,6,0,56,0.016073478,0.015668718,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (488,4,7,3,0,90,0.025832376,0.025181869,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (491,16,7,21,1,897,0.257462686,0.250979294,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (492,1,7,21,1,897,0.257462686,0.250979294,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (493,16,7,22,1,1222,0.350746268,0.341913822,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (494,1,7,22,1,1222,0.350746268,0.341913822,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (495,16,7,24,1,1309,0.375717566,0.366256295,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (496,1,7,24,1,1309,0.375717566,0.366256295,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (497,16,7,6,0,56,0.016073478,0.015668718,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (498,1,7,6,0,56,0.016073478,0.015668718,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (499,16,7,3,0,90,0.025832376,0.025181869,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (500,1,7,3,0,90,0.025832376,0.025181869,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (506,7,7,21,1,1794,0.257462686,0.250979294,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (507,7,7,22,1,2444,0.350746268,0.341913822,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (508,7,7,24,1,2618,0.375717566,0.366256295,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (509,7,7,6,0,112,0.016073478,0.015668718,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (510,7,7,3,0,180,0.025832376,0.025181869,0,NULL,NULL,NULL,'2017-02-13 18:01:50'), | |
| (513,10,1,2,0,1507,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (514,10,1,1,0,1518,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (515,11,1,2,0,2061,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (516,11,1,1,0,2075,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (517,15,1,2,0,1044,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (518,15,1,1,0,1131,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (519,14,1,2,0,5243,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (520,14,1,1,0,5257,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (521,12,1,2,0,2102,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (522,12,1,1,0,2109,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (523,13,1,2,0,6216,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (524,13,1,1,0,6218,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (525,8,1,2,0,5670,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (526,8,1,1,0,5702,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (527,9,1,2,0,12503,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (528,9,1,1,0,12606,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (529,4,1,2,0,18173,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (530,4,1,1,0,18308,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (531,16,1,2,0,18173,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (532,16,1,1,0,18308,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (533,1,1,2,0,18173,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (534,1,1,1,0,18308,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (535,7,1,2,0,36346,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (536,7,1,1,0,36616,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (537,12,2,2,0,1383,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (538,12,2,1,0,1433,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (539,14,2,2,0,4834,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (540,14,2,1,0,4836,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (541,13,2,2,0,2111,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (542,13,2,1,0,2124,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (543,10,2,2,0,1576,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (544,10,2,1,0,1586,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (545,11,2,2,0,1691,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (546,11,2,1,0,1701,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (547,15,2,2,0,4378,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (548,15,2,1,0,4391,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (549,8,2,2,0,4650,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (550,8,2,1,0,4720,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (551,9,2,2,0,11323,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (552,9,2,1,0,11351,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (553,4,2,2,0,15973,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (554,4,2,1,0,16071,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (555,16,2,2,0,15973,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (556,16,2,1,0,16071,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (557,1,2,2,0,15973,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (558,1,2,1,0,16071,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (559,7,2,2,0,31946,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (560,7,2,1,0,32142,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (561,15,3,2,0,3344,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (562,15,3,1,0,3473,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (563,10,3,2,0,6814,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (564,10,3,1,0,6927,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (565,14,3,2,0,3190,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (566,14,3,1,0,3708,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (567,13,3,2,0,3641,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (568,13,3,1,0,3657,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (569,11,3,2,0,2573,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (570,11,3,1,0,2605,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (571,12,3,2,0,7876,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (572,12,3,1,0,8038,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (573,9,3,2,0,10175,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (574,9,3,1,0,10838,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (575,8,3,2,0,17263,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (576,8,3,1,0,17570,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (577,4,3,2,0,27438,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (578,4,3,1,0,28408,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (579,16,3,2,0,27438,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (580,16,3,1,0,28408,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (581,1,3,2,0,27438,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (582,1,3,1,0,28408,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (583,7,3,2,0,54876,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (584,7,3,1,0,56816,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (585,12,4,2,0,9800,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (586,12,4,1,0,9831,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (587,11,4,2,0,3627,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (588,11,4,1,0,3639,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (589,13,4,2,0,1797,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (590,13,4,1,0,1806,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (591,10,4,2,0,1121,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (592,10,4,1,0,1127,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (593,18,4,2,0,2450,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (594,18,4,1,0,2570,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (595,14,4,2,0,1440,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (596,14,4,1,0,1464,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (597,17,4,2,0,3277,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (598,17,4,1,0,3304,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (599,15,4,2,0,7193,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (600,15,4,1,0,7208,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (601,8,4,2,0,14548,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (602,8,4,1,0,14597,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (603,9,4,2,0,10430,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (604,9,4,1,0,10478,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (605,3,4,2,0,5727,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (606,3,4,1,0,5874,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (607,4,4,2,0,24978,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (608,4,4,1,0,25075,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (609,16,4,2,0,5727,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (610,16,4,1,0,5874,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (611,2,4,2,0,5727,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (612,2,4,1,0,5874,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (613,1,4,2,0,24978,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (614,1,4,1,0,25075,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (615,7,4,2,0,5727,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (616,7,4,1,0,5874,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (617,18,5,2,0,2526,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (618,18,5,1,0,2571,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (619,14,5,2,0,2061,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (620,14,5,1,0,2121,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (621,17,5,2,0,1118,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (622,17,5,1,0,1239,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (623,13,5,2,0,2666,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (624,13,5,1,0,3193,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (625,12,5,2,0,1664,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (626,12,5,1,0,1739,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (627,11,5,2,0,1609,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (628,11,5,1,0,1760,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (629,15,5,2,0,3099,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (630,15,5,1,0,3205,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (631,10,5,2,0,21617,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (632,10,5,1,0,21738,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (633,3,5,2,0,3644,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (634,3,5,1,0,3810,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (635,9,5,2,0,7826,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (636,9,5,1,0,8519,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (637,8,5,2,0,24890,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (638,8,5,1,0,25237,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (639,16,5,2,0,3644,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (640,16,5,1,0,3810,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (641,2,5,2,0,3644,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (642,2,5,1,0,3810,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (643,4,5,2,0,32716,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (644,4,5,1,0,33756,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (645,7,5,2,0,3644,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (646,7,5,1,0,3810,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (647,1,5,2,0,32716,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (648,1,5,1,0,33756,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (649,17,6,2,0,5235,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (650,17,6,1,0,5310,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (651,13,6,2,0,5495,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (652,13,6,1,0,5519,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (653,14,6,2,0,3495,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (654,14,6,1,0,3511,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (655,11,6,2,0,16738,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (656,11,6,1,0,16752,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (657,15,6,2,0,3763,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (658,15,6,1,0,3779,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (659,12,6,2,0,4058,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (660,12,6,1,0,4082,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (661,18,6,2,0,4103,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (662,18,6,1,0,4110,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (663,10,6,2,0,23876,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (664,10,6,1,0,23888,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (665,3,6,2,0,9338,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (666,3,6,1,0,9420,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (667,9,6,2,0,12753,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (668,9,6,1,0,12809,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (669,8,6,2,0,44672,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (670,8,6,1,0,44722,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (671,16,6,2,0,9338,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (672,16,6,1,0,9420,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (673,2,6,2,0,9338,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (674,2,6,1,0,9420,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (675,4,6,2,0,57425,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (676,4,6,1,0,57531,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (677,7,6,2,0,9338,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (678,7,6,1,0,9420,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (679,1,6,2,0,57425,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (680,1,6,1,0,57531,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (681,14,7,2,0,1039,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (682,14,7,1,0,1051,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (683,11,7,2,0,311,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (684,11,7,1,0,313,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (685,12,7,2,0,193,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (686,12,7,1,0,204,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (687,13,7,2,0,312,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (688,13,7,1,0,327,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (689,10,7,2,0,171,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (690,10,7,1,0,207,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (691,15,7,2,0,1458,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (692,15,7,1,0,1472,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (693,9,7,2,0,2809,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (694,9,7,1,0,2850,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (695,8,7,2,0,675,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (696,8,7,1,0,724,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (697,4,7,2,0,3484,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (698,4,7,1,0,3574,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (699,16,7,2,0,3484,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (700,16,7,1,0,3574,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (701,1,7,2,0,3484,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (702,1,7,1,0,3574,NULL,NULL,0,NULL,NULL,NULL,'0000-00-00 00:00:00'), | |
| (709,7,7,1,0,7148,NULL,NULL,0,NULL,NULL,NULL,'2017-02-13 18:16:49'), | |
| (710,7,7,2,0,6968,NULL,NULL,0,NULL,NULL,NULL,'2017-02-13 18:16:49'); | |
| /*!40000 ALTER TABLE `candidates_contests_divisions` ENABLE KEYS */; | |
| UNLOCK TABLES; | |
| # Dump of table contests | |
| # ------------------------------------------------------------ | |
| DROP TABLE IF EXISTS `contests`; | |
| CREATE TABLE `contests` ( | |
| `id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
| `ocd_id` varchar(255) NOT NULL COMMENT 'Open Civic Data identifier', | |
| `votesmart_id` int(10) unsigned DEFAULT NULL, | |
| `name` varchar(100) NOT NULL, | |
| `slug` varchar(200) DEFAULT NULL, | |
| `event_id` int(8) unsigned NOT NULL, | |
| `office_id` int(6) unsigned NOT NULL, | |
| `division_id` int(6) unsigned DEFAULT NULL, | |
| `primary_party_id` int(3) DEFAULT NULL, | |
| `is_special` tinyint(1) NOT NULL, | |
| `is_vacancy` tinyint(1) NOT NULL, | |
| `is_no_candidates` tinyint(1) NOT NULL, | |
| `n_seats` int(2) unsigned NOT NULL DEFAULT '1' COMMENT 'Allows for multi-seat offices', | |
| `status` varchar(30) NOT NULL DEFAULT 'draft', | |
| `data_audit_progress` varchar(500) DEFAULT NULL, | |
| `n_data_audit_failures` int(3) unsigned NOT NULL DEFAULT '1', | |
| `is_safe_to_publish` tinyint(1) NOT NULL DEFAULT '0', | |
| `created_at` datetime NOT NULL, | |
| PRIMARY KEY (`id`), | |
| KEY `event_id` (`event_id`), | |
| KEY `office_id_2` (`office_id`), | |
| KEY `is_special` (`is_special`), | |
| KEY `division_id` (`division_id`), | |
| KEY `is_no_candidates` (`is_no_candidates`), | |
| KEY `n_data_audit_failures` (`n_data_audit_failures`), | |
| KEY `status` (`status`), | |
| KEY `primary_party_id` (`primary_party_id`), | |
| KEY `slug` (`slug`), | |
| FULLTEXT KEY `ft-name` (`name`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| LOCK TABLES `contests` WRITE; | |
| /*!40000 ALTER TABLE `contests` DISABLE KEYS */; | |
| INSERT INTO `contests` (`id`, `ocd_id`, `votesmart_id`, `name`, `slug`, `event_id`, `office_id`, `division_id`, `primary_party_id`, `is_special`, `is_vacancy`, `is_no_candidates`, `n_seats`, `status`, `data_audit_progress`, `n_data_audit_failures`, `is_safe_to_publish`, `created_at`) | |
| VALUES | |
| (1,'',NULL,'',NULL,1,5,1,1,0,0,0,1,'published',NULL,0,1,'2017-01-09 22:44:36'), | |
| (2,'',NULL,'',NULL,1,5,1,2,0,0,0,1,'published',NULL,0,1,'2017-01-09 22:44:36'), | |
| (3,'',NULL,'',NULL,2,5,1,NULL,0,0,0,1,'published',NULL,0,1,'2017-01-09 22:44:36'), | |
| (4,'',NULL,'',NULL,1,2,8,1,0,0,0,1,'published',NULL,0,1,'2017-01-09 22:44:36'), | |
| (5,'',NULL,'',NULL,1,2,8,2,0,0,0,1,'published',NULL,0,1,'2017-01-09 22:44:36'), | |
| (6,'',NULL,'',NULL,2,2,8,NULL,0,0,0,1,'published',NULL,0,1,'2017-01-09 22:44:36'), | |
| (7,'',NULL,'',NULL,2,7,4,NULL,0,0,0,3,'published',NULL,0,1,'2017-01-09 22:44:36'); | |
| /*!40000 ALTER TABLE `contests` ENABLE KEYS */; | |
| UNLOCK TABLES; | |
| /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; | |
| /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; | |
| /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment