-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le :  mer. 18 avr. 2018 à 20:59
-- Version du serveur :  10.1.28-MariaDB
-- Version de PHP :  7.1.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Base de données :  `election`
--
-- DROP DATABASE IF EXISTS `election`;
-- CREATE DATABASE IF NOT EXISTS `election` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- USE `election`;

-- --------------------------------------------------------

--
-- Structure de la table `candidat`
--

CREATE TABLE `candidat` (
  `id` int(11) NOT NULL,
  `parti_id` int(11) DEFAULT NULL,
  `bsq_id` int(11) DEFAULT NULL,
  `nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `annee` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `candidat`
--

INSERT INTO `candidat` (`id`, `parti_id`, `bsq_id`, `nom`, `prenom`, `annee`) VALUES
(74, 27, 599, 'Marcotte', 'Jacques', 2014),
(76, 27, 639, 'Lévesque', 'Sylvain', 2014),
(77, 22, 153, 'De Bellefeuille', 'Julie', 2014),
(78, 8, 189, 'Turcotte', 'Dave', 2014),
(79, 10, 419, 'Giraud', 'Darryl L', 2014),
(80, 8, 143, 'Bouillé', 'Marie', 2014),
(81, 8, 361, 'Hivon', 'Véronique', 2014),
(82, 11, 153, 'St-Onge', 'Pierre-Paul', 2014),
(83, 8, 389, 'Breton', 'Daniel', 2014),
(84, 22, 619, 'Jovanovic', 'Milan', 2014),
(85, 8, 379, 'Lisée', 'Jean-François', 2014),
(86, 6, 451, 'Charbonneau', 'Francine', 2014),
(87, 8, 439, 'Bureau-Blouin', 'Léo', 2014),
(88, 22, 603, 'Pouliot', 'Thomas', 2014),
(89, 22, 653, 'Bergeron', 'Dany', 2014),
(91, 8, 561, 'Aubé', 'Gilles', 2014),
(92, 22, 323, 'Landry', 'Jean', 2014),
(93, 8, 711, 'Bérubé', 'Pascal', 2014),
(94, 22, 673, 'Pouliot', 'Adrien', 2014),
(95, 8, 103, 'Hallé', 'Isabelle', 2014),
(97, 6, 303, 'Vien', 'Dominique', 2014),
(98, 27, 353, 'Leclerc', 'Élizabeth', 2014),
(99, 10, 209, 'Baril', 'Marcel', 2014),
(100, 11, 149, 'Labelle', 'Carmen', 2014),
(101, 8, 367, 'McKay', 'Scott', 2014),
(102, 8, 183, 'Langlois', 'Pierre', 2014),
(103, 6, 103, 'Bolduc', 'Ghislain', 2014),
(104, 22, 183, 'L\'Heureux', 'Guy', 2014),
(105, 8, 673, 'Guimond', 'Michel', 2014),
(106, 8, 289, 'Mathieu', 'Kaven', 2014),
(107, 10, 409, 'Maynard', 'James', 2014),
(108, 10, 403, 'Weizfeld', 'Abraham', 2014),
(109, 6, 183, 'Merlini', 'Richard', 2014),
(110, 22, 659, 'Cloutier', 'Benoit', 2014),
(123, 10, 413, 'Mireault', 'Mathieu', 2014),
(124, 8, 173, 'Pilon', 'Laurent', 2014),
(125, 8, 193, 'St-Arnaud', 'Bertrand', 2014),
(126, 27, 673, 'St-Laurent', 'Michelyne C.', 2014),
(127, 8, 495, 'Beaudoin', 'Denise', 2014),
(128, 8, 753, 'Dufour', 'Marjolain', 2014),
(129, 6, 419, 'Arcand', 'Pierre', 2014),
(130, 8, 111, 'Hébert', 'Réjean', 2014),
(131, 22, 599, 'Beaulieu', 'Daniel', 2014),
(132, 8, 329, 'Dubois', 'Jean-René', 2014),
(133, 6, 209, 'Ménard', 'Nicole', 2014),
(134, 8, 553, 'Primeau', 'Jean-Francois', 2014),
(135, 8, 263, 'Pelletier', 'Émilien', 2014),
(136, 8, 443, 'Rocque', 'François-Gycelain', 2014),
(137, 27, 429, 'Parent', 'Mario', 2014),
(139, 22, 419, 'Floch', 'Hélène', 2014),
(140, 11, 387, 'Leduc', 'Alexandre', 2014),
(141, 11, 433, 'Frappier', 'André', 2014),
(142, 6, 163, 'Charlebois', 'Lucie', 2014),
(143, 8, 213, 'Drainville', 'Bernard', 2014),
(144, 6, 393, 'Blais', 'Marguerite', 2014),
(145, 8, 397, 'Pintal', 'Lorraine', 2014),
(146, 8, 363, 'Paquette', 'Pierre', 2014),
(147, 8, 323, 'St-Arnaud', 'Gaëtan', 2014),
(148, 6, 745, 'Méthot', 'Laurence', 2014),
(149, 8, 433, 'De Courcy', 'Diane', 2014),
(150, 27, 613, 'Deltell', 'Gérard', 2014),
(151, 7, 559, 'Soublière', 'Pierre', 2014),
(152, 8, 623, 'Châteauvert', 'Pierre', 2014),
(153, 8, 599, 'Genois', 'Hugues', 2014),
(154, 10, 391, 'Cahn', 'Lisa Julie', 2014),
(155, 22, 417, 'Morissette', 'Guy', 2014),
(156, 8, 525, 'Cousineau', 'Claude', 2014),
(158, 22, 273, 'Picard', 'François', 2014),
(159, 6, 441, 'Ouellette', 'Guy', 2014),
(160, 8, 163, 'Séguin', 'Marie-Louise', 2014),
(161, 8, 593, 'Champagne', 'Noëlla', 2014),
(162, 6, 189, 'Denis', 'Marie-Josée', 2014),
(163, 27, 377, 'Medza', 'Sylvain', 2014),
(164, 27, 373, 'Campeau', 'Richard', 2014),
(165, 11, 249, 'Jarrousse', 'Céline', 2014),
(166, 11, 745, 'Gélineau', 'Jacques', 2014),
(168, 8, 703, 'Lebel', 'Harold', 2014),
(169, 11, 603, 'Jobin-Lawler', 'Alexandre', 2014),
(170, 27, 293, 'Poulin', 'Samuel', 2014),
(172, 6, 293, 'Dutil', 'Robert', 2014),
(173, 7, 417, 'Deschamps', 'Fernand', 2014),
(174, 27, 143, 'Samson', 'Claire', 2014),
(175, 27, 309, 'Spénard', 'André', 2014),
(176, 11, 383, 'Khadir', 'Amir', 2014),
(177, 8, 431, 'Mahiout', 'Leila', 2014),
(178, 8, 515, 'Marceau', 'Nicolas', 2014),
(179, 8, 377, 'Kotto', 'Maka', 2014),
(180, 11, 367, 'Huard', 'Olivier', 2014),
(181, 8, 123, 'Breton', 'Michel', 2014),
(182, 27, 329, 'Martel', 'Donald', 2014),
(183, 7, 623, 'Moreau', 'Claude', 2014),
(184, 8, 209, 'Stanké', 'Sophie', 2014),
(185, 11, 353, 'Beaudry', 'Louise', 2014),
(187, 22, 639, 'Martin', 'Jean-Alex', 2014),
(188, 8, 393, 'Fournier', 'Véronique', 2014),
(189, 8, 383, 'Legault', 'Sylvie', 2014),
(191, 22, 303, 'Aubin', 'Patrice', 2014),
(193, 8, 273, 'Lebel', 'Daniel', 2014),
(194, 11, 417, 'Kadiri', 'Hasnaa', 2014),
(195, 11, 393, 'Alexander', 'Molly', 2014),
(196, 6, 149, 'Billette', 'Stéphane', 2014),
(197, 11, 619, 'Domingue', 'Marie Céline', 2014),
(198, 11, 633, 'Duchesne', 'Marie-Ève', 2014),
(199, 11, 377, 'Chateauneuf', 'Gaétan', 2014),
(200, 8, 659, 'Paré', 'Catherine', 2014),
(201, 6, 173, 'Moreau', 'Pierre', 2014),
(202, 27, 659, 'Picard', 'Marc', 2014),
(203, 11, 379, 'Trudelle', 'Jean', 2014),
(204, 6, 427, 'Heurtel', 'David', 2014),
(205, 6, 213, 'Tremblay', 'Jean-Guy', 2014),
(206, 10, 387, 'Lewis-Richmond', 'Malcolm', 2014),
(207, 29, 603, 'Dion-Garneau', 'Camille', 2014),
(208, 8, 465, 'Gadoury Hamelin', 'Diane', 2014),
(209, 8, 633, 'Maltais', 'Agnès', 2014),
(210, 7, 387, 'Dandenault', 'Christine', 2014),
(211, 8, 481, 'Desjardins', 'Martine', 2014),
(212, 27, 449, 'Dydzak', 'Joseph', 2014),
(213, 6, 429, 'Rotiroti', 'Filomena', 2014),
(214, 8, 449, 'Poirier', 'Jean', 2014),
(215, 6, 353, 'Bellerose', 'Pierre-Luc', 2014),
(216, 6, 593, 'Auger', 'Pierre Michel', 2014),
(217, 8, 663, 'Girard', 'Sylvie', 2014),
(218, 27, 397, 'Richer', 'Benoit', 2014),
(220, 27, 663, 'Dubé', 'Christian', 2014),
(221, 8, 483, 'Goyer', 'Daniel', 2014),
(222, 11, 133, 'Beauregard', 'André', 2014),
(223, 8, 679, 'Marois', 'Pauline', 2014),
(224, 27, 423, 'Assouline', 'Valérie', 2014),
(225, 27, 447, 'Cavaliere', 'Domenico', 2014),
(226, 6, 223, 'Tessier', 'Maxime', 2014),
(227, 6, 407, 'Ouimet', 'François', 2014),
(228, 8, 653, 'Dallaire', 'Patrice', 2014),
(229, 27, 363, 'Legault', 'François', 2014),
(230, 6, 633, 'Tanlet', 'Florent', 2014),
(231, 8, 619, 'Payette', 'Dominique', 2014),
(232, 27, 453, 'Jarry', 'Jean-François', 2014),
(233, 6, 309, 'Couture', 'José', 2014),
(234, 27, 465, 'Lemay', 'Mathieu', 2014),
(235, 11, 389, 'Massé', 'Manon', 2014),
(236, 27, 451, 'Loranger', 'Sylvain', 2014),
(237, 10, 437, 'Nyaburerwa', 'Alix', 2014),
(238, 11, 639, 'Voisine', 'Monique', 2014),
(239, 8, 253, 'Zakaïb', 'Élaine', 2014),
(241, 27, 495, 'D\'Amours', 'Sylvie', 2014),
(242, 6, 423, 'Sklavounos', 'Gerry', 2014),
(243, 6, 283, 'Vallières', 'Karine', 2014),
(244, 27, 515, 'Charette', 'Claude', 2014),
(245, 8, 269, 'Blanchet', 'Yves-François', 2014),
(246, 6, 437, 'St-Pierre', 'Christine', 2014),
(247, 7, 583, 'Bédard', 'Jean-Paul', 2014),
(248, 11, 553, 'Sarazin', 'Marc', 2014),
(249, 8, 369, 'Léger', 'Nicole', 2014),
(250, 26, 713, 'St-Pierre', 'Louis-Patrick', 2014),
(251, 7, 213, 'Chénier', 'Pierre', 2014),
(252, 6, 371, 'Tanguay', 'Marc', 2014),
(253, 8, 773, 'Gaudreault', 'Sylvain', 2014),
(254, 6, 699, 'D\'Amour', 'Jean', 2014),
(255, 22, 209, 'Godin', 'Christian', 2014),
(256, 8, 731, 'Lelièvre', 'Gaétan', 2014),
(257, 27, 419, 'Leboeuf', 'Jamilla', 2014),
(258, 8, 763, 'Bédard', 'Stéphane', 2014),
(259, 7, 369, 'Royer', 'Geneviève', 2014),
(260, 11, 213, 'Lévesque', 'Carl', 2014),
(261, 27, 133, 'Bonnardel', 'François', 2014),
(262, 11, 429, 'Charpentier', 'Stéphanie', 2014),
(263, 6, 545, 'Lacroix', 'Christian', 2014),
(264, 26, 753, 'Boivin Ringuette', 'Nicolas', 2014),
(265, 6, 203, 'Barrette', 'Gaétan', 2014),
(266, 8, 387, 'Poirier', 'Carole', 2014),
(267, 6, 193, 'Ferdinand', 'Magdala', 2014),
(268, 8, 333, 'Deschênes', 'Alexis', 2014),
(269, 8, 699, 'Lagacé', 'Michel', 2014),
(270, 8, 421, 'Gendron', 'Roxanne', 2014),
(271, 6, 679, 'Simard', 'Caroline', 2014),
(272, 6, 563, 'Fortin', 'André', 2014),
(273, 6, 367, 'Nantel', 'Robert', 2014),
(274, 29, 633, 'Boivin', 'Guy', 2014),
(275, 6, 333, 'Girard', 'Jean-Denis', 2014),
(276, 10, 421, 'Brière', 'Théo', 2014),
(277, 8, 451, 'Benhabib', 'Djemila', 2014),
(278, 22, 505, 'Morin', 'Bruno', 2014),
(279, 27, 103, 'Boulanger', 'Pierre-Luc', 2014),
(280, 6, 663, 'Turmel', 'Simon', 2014),
(281, 8, 177, 'Therrien', 'Alain', 2014),
(282, 22, 111, 'Collette', 'Marcel', 2014),
(283, 8, 403, 'Pion', 'Eliane', 2014),
(284, 22, 333, 'Bonneau', 'Pierre-Louis', 2014),
(285, 8, 423, 'Céré', 'Pierre', 2014),
(286, 8, 603, 'Desgagnés', 'Paule', 2014),
(287, 8, 779, 'Cloutier', 'Alexandre', 2014),
(288, 27, 111, 'Stratford', 'Gaston', 2014),
(289, 6, 703, 'Huot', 'Pierre', 2014),
(290, 7, 177, 'Héroux', 'Hélène', 2014),
(291, 10, 417, 'Diallo', 'Tidiane', 2014),
(292, 27, 367, 'Lavallée', 'Lise', 2014),
(293, 6, 449, 'Rousselle', 'Jean', 2014),
(295, 7, 419, 'Johnston', 'Diane', 2014),
(296, 29, 369, 'Chandonnet', 'Louis', 2014),
(297, 8, 153, 'Leclair', 'Guy', 2014),
(298, 8, 563, 'Vallières-Murray', 'Maryse', 2014),
(299, 8, 713, 'Roy', 'Sylvain', 2014),
(300, 10, 389, 'Wiseman', 'Stewart', 2014),
(301, 11, 481, 'Giguère', 'Sylvie', 2014),
(302, 27, 711, 'Gobeil-Nadon', 'Yann', 2014),
(303, 10, 401, 'Tyrrell', 'Alex', 2014),
(304, 7, 401, 'Hoffman', 'Rachel', 2014),
(305, 11, 431, 'Généreux', 'Claude', 2014),
(306, 27, 439, 'Bolduc', 'Vincent', 2014),
(307, 6, 659, 'Vaillancourt', 'Ghyslain', 2014),
(308, 11, 401, 'Desjardins', 'Annick', 2014),
(309, 6, 553, 'Iraca', 'Alexandre', 2014),
(310, 8, 243, 'Duchesne', 'Pierre', 2014),
(312, 6, 129, 'Paradis', 'Pierre', 2014),
(313, 8, 793, 'Ferland', 'Luc', 2014),
(314, 0, 623, 'Breton', 'José', 2014),
(315, 7, 173, 'Sullivan', 'Linda', 2014),
(316, 7, 183, 'Chouinard', 'Normand', 2014),
(317, 6, 249, 'Rocheleau', 'Simon', 2014),
(318, 6, 643, 'Bolduc', 'Yves', 2014),
(319, 22, 149, 'De Martin', 'Albert', 2014),
(320, 6, 243, 'Murray', 'Jean', 2014),
(321, 6, 229, 'Bienvenu', 'Michel', 2014),
(322, 11, 361, 'Trudel', 'Flavie', 2014),
(323, 27, 699, 'Roy', 'Charles', 2014),
(324, 6, 169, 'Nichols', 'Marie-Claude', 2014),
(325, 33, 353, 'Dupré', 'Claude', 2014),
(326, 6, 253, 'Plante', 'Alain', 2014),
(327, 27, 441, 'Dejoie', 'Carlie', 2014),
(328, 27, 783, 'Truchon', 'François', 2014),
(329, 0, 309, 'Roy', 'Benoît', 2014),
(330, 26, 481, 'Marginean', 'Alain', 2014),
(331, 11, 659, 'Bolduc', 'Olivier', 2014),
(332, 26, 423, 'Tremblay', 'Miguel', 2014),
(333, 7, 371, 'Le Seigle', 'Yves', 2014),
(334, 27, 481, 'Surprenant', 'Claude', 2014),
(335, 8, 413, 'Comtois-Lussier', 'Michaël', 2014),
(336, 6, 417, 'Fournier', 'Jean-Marc', 2014),
(337, 22, 361, 'Colangelo Lauzon', 'Mikey', 2014),
(338, 8, 643, 'Laberge', 'Clément', 2014),
(339, 6, 673, 'Bernier', 'Raymond', 2014),
(340, 6, 177, 'Pellerin', 'Jean Paul', 2014),
(342, 6, 557, 'Vallée', 'Stéphanie', 2014),
(343, 22, 343, 'Lapointe', 'Jonathan', 2014),
(344, 6, 483, 'Leclerc', 'Luc', 2014),
(345, 11, 177, 'Laramée', 'Christian', 2014),
(346, 10, 433, 'Leurent-Bonnevie', 'Virginia', 2014),
(347, 11, 793, 'Richer', 'André', 2014),
(348, 26, 639, 'Fillion', 'Mathieu', 2014),
(349, 8, 229, 'Ouellet', 'Martine', 2014),
(350, 11, 349, 'Delmé', 'Linda', 2014),
(351, 7, 379, 'Chénier', 'Stéphane', 2014),
(352, 8, 249, 'Bergeron', 'Stéphane', 2014),
(353, 27, 653, 'Asselin', 'Mario', 2014),
(354, 6, 111, 'Hardy', 'Guy', 2014),
(355, 6, 619, 'Blais', 'François', 2014),
(356, 8, 427, 'Lavigne', 'Odette', 2014),
(357, 8, 411, 'Bénard', 'Louis-David', 2014),
(358, 6, 573, 'Bastien', 'Serge', 2014),
(359, 8, 567, 'Chapadeau', 'Gilles', 2014),
(360, 8, 745, 'Richard', 'Lorraine', 2014),
(361, 11, 653, 'Minville', 'Pascal', 2014),
(362, 8, 409, 'Desroches', 'Laurence', 2014),
(363, 6, 653, 'Hamad', 'Sam', 2014),
(364, 8, 349, 'Lahaie', 'Patrick', 2014),
(365, 22, 293, 'Bégin', 'Stéphane', 2014),
(366, 22, 623, 'Garcia', 'Andrés', 2014),
(367, 8, 343, 'Trudel', 'Luc', 2014),
(368, 11, 233, 'Ostiguy', 'Jean Marc', 2014),
(369, 6, 123, 'Reid', 'Pierre', 2014),
(370, 6, 401, 'Weil', 'Kathleen', 2014),
(371, 10, 213, 'Lovatt-Smith', 'Catherine', 2014),
(372, 11, 427, 'Fortier-Moreau', 'Geneviève', 2014),
(373, 11, 403, 'Dufresne', 'Suzanne', 2014),
(374, 22, 633, 'Deblois', 'Anne', 2014),
(375, 8, 407, 'Fortin', 'Élisabeth', 2014),
(376, 10, 377, 'Lapierre', 'Thomas', 2014),
(377, 22, 679, 'Mélançon', 'Chantal', 2014),
(378, 8, 639, 'Dean', 'Marc', 2014),
(379, 27, 323, 'Roy', 'Sylvie', 2014),
(380, 27, 153, 'Moreau', 'Claude', 2014),
(381, 6, 363, 'Bergevin', 'Jean-Marc', 2014),
(382, 6, 349, 'Plante', 'Marc H.', 2014),
(383, 11, 713, 'Chartier', 'Patricia', 2014),
(384, 8, 733, 'Richard', 'Jeannine', 2014),
(385, 8, 453, 'Traversy', 'Mathieu', 2014),
(386, 6, 289, 'Lessard', 'Laurent', 2014),
(387, 11, 559, 'Avalos', 'Laura', 2014),
(388, 8, 783, 'Trottier', 'Denis', 2014),
(389, 11, 453, 'Smith', 'Yan', 2014),
(390, 11, 419, 'Semak', 'Roy', 2014),
(391, 22, 309, 'Couture', 'Eric', 2014),
(392, 29, 643, 'Pouleur', 'Stéphane', 2014),
(393, 8, 381, 'Mailloux', 'Louise', 2014),
(394, 8, 437, 'Abitbol', 'Évelyne', 2014),
(395, 8, 149, 'Hébert', 'Huguette', 2014),
(396, 8, 613, 'Robitaille', 'Christian', 2014),
(397, 0, 203, 'Houda-Pepin', 'Fatima', 2014),
(398, 6, 443, 'Ouimet', 'Gilles', 2014),
(399, 8, 441, 'Cooke', 'Jean', 2014),
(400, 27, 149, 'IsaBelle', 'Claire', 2014),
(401, 8, 447, 'Proulx', 'Suzanne', 2014),
(403, 6, 783, 'Couillard', 'Philippe', 2014),
(404, 11, 673, 'Duchesneau', 'Jean-Pierre', 2014),
(405, 11, 515, 'Lépine', 'François', 2014),
(406, 22, 253, 'Gaudet', 'Marc', 2014),
(407, 26, 421, 'Vaillancourt', 'Galia', 2014),
(408, 26, 177, 'Moreau', 'Robert', 2014),
(409, 8, 473, 'Desrosiers', 'Gyslaine', 2014),
(410, 10, 427, 'Bourgault', 'Marijo', 2014),
(411, 6, 431, 'de Santis', 'Rita', 2014),
(412, 11, 421, 'Laperle', 'Édith', 2014),
(413, 11, 163, 'Bessette', 'Andrée', 2014),
(414, 11, 193, 'Vigeant', 'Francis', 2014),
(415, 27, 633, 'Brabant', 'Steve', 2014),
(416, 11, 473, 'Giguère', 'Annie', 2014),
(417, 6, 373, 'Thériault', 'Lise', 2014),
(418, 8, 417, 'Bandou', 'Rachid', 2014),
(419, 2, 111, 'Lafrance', 'Philippe', 2014),
(420, 11, 263, 'Pelland', 'Danielle', 2014),
(421, 8, 429, 'Harnois', 'Joanie', 2014),
(422, 22, 409, 'Fortier', 'Louis-Charles', 2014),
(423, 6, 759, 'Simard', 'Serge', 2014),
(424, 26, 623, 'Zanetti', 'Sol', 2014),
(425, 11, 535, 'Bertrand', 'Clotilde', 2014),
(426, 8, 373, 'Chouakri', 'Yasmina', 2014),
(427, 27, 203, 'Kim', 'Jin', 2014),
(428, 11, 699, 'Gagnon', 'Louis', 2014),
(429, 26, 699, 'Massé', 'Étienne', 2014),
(430, 31, 699, 'Malenfant', 'Frank', 2014),
(431, 27, 189, 'Tremblay', 'Serge', 2014),
(432, 27, 283, 'Dion', 'Alain', 2014),
(433, 6, 683, 'Morin', 'Norbert', 2014),
(434, 27, 303, 'Lachance', 'Stéphanie', 2014),
(435, 11, 561, 'Renaud', 'Benoit', 2014),
(436, 6, 579, 'Bourgeois', 'Guy', 2014),
(437, 6, 143, 'Tremblay', 'Chantal', 2014),
(438, 6, 599, 'Matte', 'Michel', 2014),
(439, 11, 333, 'Landry', 'Jean-Claude', 2014),
(440, 8, 559, 'Morin', 'Yves', 2014),
(441, 10, 431, 'Aberra', 'Adam', 2014),
(442, 33, 169, 'Dupré', 'Léon', 2014),
(443, 11, 423, 'Fontecilla', 'Andrés', 2014),
(444, 6, 473, 'Collin', 'Marie-Claude', 2014),
(445, 11, 129, 'Van Caloen', 'Benoit', 2014),
(446, 6, 733, 'Chevarie', 'Germain', 2014),
(447, 11, 113, 'Pigot', 'Hélène', 2014),
(448, 11, 253, 'Mathieu', 'Marie-Ève', 2014),
(449, 11, 711, 'Tremblay', 'Gérald', 2014),
(450, 10, 449, 'Demers', 'Andréanne', 2014),
(451, 6, 639, 'Huot', 'Patrick', 2014),
(452, 6, 403, 'Birnbaum', 'David', 2014),
(453, 11, 703, 'Besner', 'Marie-Neige', 2014),
(454, 10, 559, 'Fleury', 'Roger', 2014),
(455, 10, 423, 'Tessier', 'Jeremy', 2014),
(456, 8, 223, 'Lamarre', 'Diane', 2014),
(457, 22, 407, 'Crespi', 'Pierre Ennio', 2014),
(458, 8, 113, 'Cardin', 'Serge', 2014),
(459, 6, 409, 'Kelley', 'Geoffrey', 2014),
(460, 7, 563, 'Lang', 'Louis', 2014),
(461, 6, 133, 'Proulx', 'Pascal', 2014),
(462, 22, 363, 'Raynault', 'Charles-Étienne', 2014),
(463, 6, 263, 'Arpin', 'Louise', 2014),
(464, 11, 111, 'Poulin', 'André', 2014),
(465, 27, 411, 'Bitton', 'Albert', 2014),
(466, 33, 535, 'Dupré', 'Serge', 2014),
(467, 0, 449, 'Boyer', 'Jean-Marc', 2014),
(468, 8, 303, 'Goupil', 'Linda', 2014),
(469, 26, 289, 'Grégoire-Gauthier', 'Annie', 2014),
(470, 22, 473, 'Fournier', 'Jean Philippe', 2014),
(471, 27, 793, 'Cameron', 'Michael Donald', 2014),
(472, 11, 413, 'Faour', 'Ali', 2014),
(473, 11, 103, 'Nadeau', 'Ludovick', 2014),
(474, 6, 561, 'Gaudreault', 'Maryse', 2014),
(475, 6, 343, 'Giguère', 'Pierre', 2014),
(476, 22, 263, 'Labbé', 'Simon', 2014),
(477, 27, 593, 'D\'Amours', 'Andrew', 2014),
(478, 27, 731, 'Blanchard', 'Yvan', 2014),
(479, 27, 361, 'Larouche', 'Denise', 2014),
(480, 22, 663, 'Roy', 'Sébastien', 2014),
(481, 27, 421, 'McCann', 'Rebecca', 2014),
(482, 11, 663, 'Bonnier Viger', 'Yv', 2014),
(483, 11, 373, 'Lessard', 'Marlène', 2014),
(484, 27, 643, 'Beaulieu', 'Hugues', 2014),
(485, 11, 573, 'Camirand', 'Ghislaine', 2014),
(486, 27, 333, 'Brunelle', 'Diego', 2014),
(487, 11, 363, 'Fournier', 'Sylvain', 2014),
(488, 26, 573, 'Vézeau', 'Grégory', 2014),
(489, 6, 233, 'Gendron', 'Jacques', 2014),
(490, 8, 573, 'Gendron', 'François', 2014),
(491, 6, 623, 'Drolet', 'André', 2014),
(492, 27, 193, 'Roberge', 'Jean-François', 2014),
(493, 2, 113, 'Roy', 'Jossy', 2014),
(494, 27, 393, 'Boulanger', 'Louis-Philippe', 2014),
(495, 8, 133, 'Lalumière', 'Joanne', 2014),
(496, 8, 505, 'Péladeau', 'Pierre Karl', 2014),
(497, 28, 153, 'de Repentigny', 'Yves', 2014),
(498, 6, 323, 'Dastous', 'Luc', 2014),
(499, 27, 583, 'Gauthier', 'Sylvain', 2014),
(500, 10, 411, 'Bourassa', 'Charles', 2014),
(501, 26, 603, 'Belleau', 'Éric', 2014),
(502, 22, 193, 'Maher', 'Michael', 2014),
(503, 6, 397, 'Daoust', 'Jacques', 2014),
(504, 22, 731, 'Rioux', 'Christian', 2014),
(505, 27, 553, 'Langelier', 'René', 2014),
(506, 8, 371, 'Pelletier', 'Mathieu', 2014),
(507, 27, 123, 'Bourget', 'Marc-Alexandre', 2014),
(508, 10, 153, 'Haliburton', 'Victoria', 2014),
(509, 6, 361, 'Corriveau', 'Robert', 2014),
(510, 22, 243, 'Gour', 'Gilbert', 2014),
(511, 27, 243, 'Jolin-Barrette', 'Simon', 2014),
(512, 6, 433, 'Montpetit', 'Marie', 2014),
(513, 6, 603, 'Gagnon', 'France', 2014),
(514, 11, 343, 'Audet', 'Marie-Line', 2014),
(515, 7, 561, 'Girard Bernier', 'Gabriel', 2014),
(516, 27, 563, 'Mongeon', 'Michel', 2014),
(517, 26, 293, 'Roy', 'Vanessa', 2014),
(518, 2, 387, 'Mallette', 'Etienne', 2014),
(519, 6, 525, 'Leblond', 'Isabelle', 2014),
(520, 6, 153, 'Lemieux', 'Lyse', 2014),
(521, 11, 643, 'Gueppe', 'Eveline', 2014),
(522, 8, 535, 'Richer', 'Roland', 2014),
(523, 11, 371, 'Martineau', 'Véronique', 2014),
(524, 10, 169, 'Radcliffe', 'Thomas', 2014),
(525, 8, 399, 'Leboeuf-McGregor', 'Richard', 2014),
(526, 27, 623, 'Foster', 'Émilie', 2014),
(527, 11, 613, 'Bernheim', 'Jean Claude', 2014),
(528, 10, 323, 'Fillion', 'François', 2014),
(529, 27, 343, 'Mongeau', 'Stéphane', 2014),
(530, 11, 593, 'Favreau', 'Lucie', 2014),
(531, 26, 593, 'Lavigne-Lefebvre', 'Nicolas', 2014),
(532, 6, 113, 'Fortin', 'Luc', 2014),
(534, 26, 353, 'Lamarre', 'Francis', 2014),
(535, 27, 229, 'Robichaud', 'Stéphane', 2014),
(536, 26, 703, 'Beaudoin', 'Pierre', 2014),
(537, 11, 563, 'Levy', 'Charmain', 2014),
(538, 33, 293, 'Paquet', 'Jean', 2014),
(539, 23, 731, 'Beau-Ferron', 'Catherine', 2014),
(540, 11, 143, 'Normandin', 'Myriam-Zaa', 2014),
(541, 4, 111, 'Lambert', 'Lionel', 2014),
(542, 28, 163, 'Domingos', 'Patricia', 2014),
(543, 4, 663, 'Biron', 'Paul', 2014),
(544, 22, 451, 'Mirabella', 'David', 2014),
(545, 25, 293, 'Genesse', 'Robert', 2014),
(546, 22, 643, 'Roy Verville', 'Monique', 2014),
(547, 10, 353, 'Baril', 'Pierre', 2014),
(548, 10, 393, 'Sweeney', 'Sharon', 2014),
(549, 6, 391, 'Chagnon', 'Jacques', 2014),
(550, 6, 399, 'Poeti', 'Robert', 2014),
(551, 8, 545, 'Pagé', 'Sylvain', 2014),
(552, 8, 391, 'Laroche', 'Denise', 2014),
(553, 6, 465, 'Féné', 'Wenet', 2014),
(555, 27, 401, 'Sidel', 'Noah', 2014),
(556, 2, 397, 'St-Onge', 'Raynald', 2014),
(557, 11, 407, 'Raymond-Dufour', 'Marie-France', 2014),
(558, 10, 253, 'Bourgault', 'Claude', 2014),
(559, 27, 559, 'Pelletier', 'Carl', 2014),
(560, 11, 309, 'Dumont', 'Mathieu', 2014),
(561, 27, 409, 'Deguire', 'Denis', 2014),
(562, 27, 129, 'Lemay', 'François', 2014),
(563, 2, 393, 'Sanchez', 'Jairo Gaston', 2014),
(564, 27, 433, 'Bessette', 'Sylvain', 2014),
(565, 8, 353, 'Villeneuve', 'André', 2014),
(566, 31, 783, 'Boucher', 'Julie', 2014),
(567, 6, 559, 'Carrière', 'Marc', 2014),
(568, 27, 545, 'Remy-Quevedo', 'Cedrick', 2014),
(569, 8, 293, 'Gagnon Lacroix', 'Alex', 2014),
(570, 7, 619, 'Fournier', 'Normand', 2014),
(571, 27, 561, 'Citegetse', 'Jean Bosco', 2014),
(572, 27, 753, 'Fortin-Morand', 'Marie-Christine', 2014),
(573, 10, 399, 'Stevenson', 'Stéphanie', 2014),
(574, 8, 129, 'Beauregard', 'René', 2014),
(575, 8, 419, 'Beauséjour', 'Audrey', 2014),
(576, 11, 731, 'Leboeuf', 'Daniel', 2014),
(577, 32, 173, 'Mailly', 'François', 2014),
(578, 26, 663, 'Belley', 'Nicolas', 2014),
(579, 6, 713, 'Arsenault', 'Damien', 2014),
(580, 27, 535, 'Chouinard', 'Nicole', 2014),
(581, 28, 169, 'Leclerc', 'Julien', 2014),
(582, 11, 579, 'Dufour', 'Valérie', 2014),
(583, 26, 389, 'Payne', 'Nic', 2014),
(584, 2, 703, 'Cyr', 'Tom-Henri', 2014),
(585, 6, 439, 'Polo', 'Saul', 2014),
(586, 27, 713, 'Landry', 'Jean-Marc', 2014),
(587, 27, 223, 'Vaillancourt', 'Sébastien', 2014),
(588, 23, 427, 'Valiquette', 'Benoit', 2014),
(589, 27, 505, 'Charbonneau', 'Patrice', 2014),
(590, 23, 713, 'Dubois', 'Patrick', 2014),
(591, 6, 453, 'Glia', 'Meriem', 2014),
(592, 22, 367, 'Lacombe', 'Pierre', 2014),
(593, 26, 653, 'Côté', 'Patrick', 2014),
(594, 8, 283, 'Boucher', 'Etienne-Alexis', 2014),
(595, 33, 289, 'Cadieux', 'Denis', 2014),
(596, 7, 437, 'Breton', 'Yvon', 2014),
(597, 11, 391, 'Desjardins', 'Mélissa', 2014),
(598, 27, 213, 'Provencher', 'Guillaume', 2014),
(599, 22, 269, 'Lussier', 'Benoit', 2014),
(600, 27, 619, 'Trudel', 'Denise', 2014),
(601, 6, 505, 'Dubois', 'Armand', 2014),
(602, 26, 233, 'van Duyse', 'Anthony', 2014),
(603, 2, 441, 'Gagnon', 'Emily', 2014),
(604, 11, 545, 'Dagenais', 'Gabriel', 2014),
(605, 26, 411, 'Landry', 'François', 2014),
(606, 27, 273, 'Schneeberger', 'Sébastien', 2014),
(607, 11, 273, 'Soulard', 'Francis', 2014),
(608, 26, 437, 'Boivin', 'Julie', 2014),
(609, 27, 557, 'Paradis', 'André', 2014),
(610, 26, 407, 'Paquette', 'Maude', 2014),
(611, 8, 401, 'Sirard', 'Olivier', 2014),
(612, 7, 397, 'Studd', 'Eileen', 2014),
(613, 8, 169, 'Archambault', 'Marcos', 2014),
(614, 27, 387, 'Walsh', 'Brendan', 2014),
(615, 26, 133, 'Beaudoin', 'Jocelyn', 2014),
(616, 22, 579, 'Perron-Tellier', 'Maxym', 2014),
(617, 26, 673, 'Bouchard', 'Jean', 2014),
(618, 10, 111, 'Carbonneau', 'Vincent J.', 2014),
(619, 26, 449, 'Boily', 'Étienne', 2014),
(620, 26, 643, 'Lavallée', 'Alexandre', 2014),
(621, 27, 349, 'Poisson', 'Martin', 2014),
(622, 11, 583, 'Dubois', 'Jean-François', 2014),
(623, 26, 223, 'Gervais-Després', 'Éric', 2014),
(624, 22, 683, 'Mercier', 'Gaétan', 2014),
(625, 11, 683, 'Côté', 'Simon', 2014),
(626, 27, 683, 'Caron', 'Mireille', 2014),
(627, 26, 253, 'Tremblay', 'Jean-François', 2014),
(628, 8, 557, 'Sarault', 'Cédric', 2014),
(629, 27, 573, 'Racine', 'Nadia', 2014),
(630, 26, 329, 'Lachapelle', 'Marjolaine', 2014),
(631, 22, 465, 'Giroux', 'Éric', 2014),
(632, 22, 329, 'Laquerre', 'Guillaume', 2014),
(633, 6, 329, 'Vallée', 'Denis', 2014),
(634, 27, 437, 'Pourreaux', 'Serge', 2014),
(635, 6, 413, 'Leitao', 'Carlos J', 2014),
(636, 6, 731, 'St-Onge', 'Annie', 2014),
(637, 2, 423, 'St-Onge', 'Hugô', 2014),
(638, 11, 483, 'Cameron', 'Duncan Hart', 2014),
(639, 11, 323, 'Letendre', 'Christine', 2014),
(640, 6, 447, 'Habel', 'Jean', 2014),
(642, 27, 679, 'Latrémouille', 'Ian', 2014),
(643, 27, 369, 'Binette', 'Mathieu', 2014),
(644, 26, 367, 'Strasbourg', 'Christian', 2014),
(645, 28, 483, 'Ware', 'Alec', 2014),
(646, 11, 557, 'Harvey', 'Alexis', 2014),
(647, 6, 535, 'St-Denis', 'Yves', 2014),
(648, 11, 623, 'Bouchard', 'Sébastien', 2014),
(649, 26, 779, 'Fauteux-Aïmola', 'Sabrina', 2014),
(650, 10, 193, 'Harper', 'Mary', 2014),
(651, 27, 173, 'Cloutier', 'Claudia', 2014),
(652, 6, 411, 'Coiteux', 'Martin', 2014),
(653, 10, 283, 'Dion-Fontaine', 'Aurélie', 2014),
(655, 11, 449, 'Moran', 'Janina', 2014),
(656, 26, 169, 'Cauchon', 'Jean-Gabriel', 2014),
(657, 27, 473, 'Laframboise', 'Mario', 2014),
(658, 23, 643, 'Couillard', 'Maxime', 2014),
(659, 4, 619, 'Lachance', 'Daniel', 2014),
(660, 26, 515, 'St-Onge', 'Chantal', 2014),
(661, 26, 111, 'Boudou-Laforce', 'Étienne', 2014),
(662, 22, 449, 'Robert', 'Alain', 2014),
(663, 27, 525, 'Milot', 'Robert', 2014),
(664, 11, 567, 'Leclerc', 'Guy', 2014),
(665, 22, 173, 'Chalhoub', 'Claude', 2014),
(666, 27, 483, 'Charette', 'Benoit', 2014),
(667, 11, 465, 'St-Pierre', 'Joëlle', 2014),
(668, 8, 233, 'Prévost', 'Simon', 2014),
(669, 22, 289, 'Rancourt', 'Sylvain', 2014),
(670, 22, 169, 'Paul', 'Michel', 2014),
(671, 27, 703, 'Fleurent', 'Steven', 2014),
(672, 11, 189, 'Lusignan', 'Carole', 2014),
(673, 23, 421, 'Marcil', 'Mathieu', 2014),
(674, 27, 413, 'Allen', 'Jamie', 2014),
(675, 27, 603, 'Caire', 'Éric', 2014),
(676, 11, 203, 'Beaupré', 'Johane', 2014),
(677, 27, 407, 'Thériault', 'Marc', 2014),
(678, 26, 447, 'Forget', 'Bruno', 2014),
(679, 6, 753, 'Levesque', 'Michel', 2014),
(680, 11, 397, 'Pires', 'Rosa', 2014),
(681, 6, 773, 'Pageau', 'Tommy', 2014),
(682, 27, 269, 'Lamontagne', 'André', 2014),
(683, 11, 437, 'Dick', 'Geneviève', 2014),
(684, 26, 193, 'Laramée', 'Martin', 2014),
(685, 11, 441, 'Rhéaume', 'Lise-Anne', 2014),
(686, 7, 423, 'Macrisopoulos', 'Peter', 2014),
(687, 27, 443, 'Skeete', 'Christopher', 2014),
(688, 10, 397, 'Bergeron-Bossé', 'Antonin', 2014),
(689, 6, 567, 'Blanchette', 'Luc', 2014),
(690, 27, 579, 'Martel', 'Sylvain', 2014),
(691, 31, 149, 'Bourdon', 'Louis-Paul', 2014),
(693, 23, 703, 'Gagnon', 'Pier-Luc', 2014),
(694, 8, 579, 'Larouche', 'Élizabeth', 2014),
(695, 6, 379, 'Valade', 'Thiery', 2014),
(696, 22, 613, 'Plamondon', 'Julie', 2014),
(697, 27, 427, 'Cayo', 'Wilner', 2014),
(698, 26, 143, 'Savard', 'Claude', 2014),
(699, 26, 163, 'Marquis', 'Patrick', 2014),
(700, 11, 759, 'Chrétien-Pineault', 'Marie-Lise', 2014),
(701, 6, 269, 'Mercier', 'Brigitte', 2014),
(702, 26, 759, 'Belva', 'Ariane', 2014),
(703, 8, 759, 'Claveau', 'Jean-Marie', 2014),
(704, 27, 759, 'Emond', 'Claudie', 2014),
(705, 10, 371, 'Drouin', 'Benoit', 2014),
(706, 11, 439, 'Chatel-Launay', 'Nicolas', 2014),
(707, 23, 553, 'Gagné', 'Christine', 2014),
(708, 11, 763, 'Godin', 'Réjean', 2014),
(709, 26, 441, 'Simard', 'Patrick', 2014),
(710, 27, 399, 'Bouchaala', 'Zoubir', 2014),
(711, 26, 431, 'Luthu', 'Félix', 2014),
(712, 22, 203, 'Fernandez', 'Sebastian', 2014),
(713, 6, 387, 'Provencher', 'David', 2014),
(714, 26, 273, 'Phénix', 'Alexandre', 2014),
(715, 27, 253, 'Baller', 'Martin', 2014),
(716, 26, 183, 'Gouin', 'Jean-Pierre', 2014),
(717, 0, 759, 'Tremblay', 'Pascal', 2014),
(718, 11, 173, 'Laberge', 'Xavier P.-', 2014),
(719, 10, 673, 'Parent', 'Marielle', 2014),
(720, 22, 421, 'Pouliot', 'Simon', 2014),
(721, 11, 293, 'Vincent', 'Diane', 2014),
(722, 26, 545, 'Richard-Léonard', 'Philippe', 2014),
(724, 26, 203, 'Létourneau-Prézeau', 'François', 2014),
(725, 26, 369, 'Goyette-Gingras', 'Camille', 2014),
(726, 26, 263, 'Pothier', 'Éric', 2014),
(727, 2, 427, 'Da Silva', 'Ana', 2014),
(728, 6, 383, 'Sagala', 'Richard', 2014),
(729, 26, 381, 'Lacelle', 'Olivier', 2014),
(730, 26, 153, 'Rousseau', 'Florence', 2014),
(731, 27, 263, 'Soucy', 'Chantal', 2014),
(732, 26, 213, 'Villemaire', 'Fabien', 2014),
(733, 22, 413, 'Popert', 'Patricia', 2014),
(734, 27, 381, 'Franche', 'Paul', 2014),
(735, 6, 381, 'Auguste-Constant', 'Cheraquie', 2014),
(736, 7, 429, 'Colly', 'Garnet', 2014),
(737, 26, 763, 'Gosselin', 'Philippe', 2014),
(738, 10, 113, 'Andrews', 'Jeremy', 2014),
(739, 11, 243, 'Falardeau', 'Jean ', 2014),
(740, 10, 407, 'Symon', 'John', 2014),
(741, 6, 273, 'Chabot', 'Isabelle', 2014),
(742, 27, 169, 'Tison', 'Luc', 2014),
(743, 2, 379, 'Babin', 'Matthew', 2014),
(744, 26, 659, 'Lévesque-Morin', 'Alexis', 2014),
(745, 27, 379, 'Dubois', 'Carl', 2014),
(746, 11, 599, 'Côté', 'Catherine', 2014),
(748, 26, 783, 'Cauchon', 'Luc-Antoine', 2014),
(749, 6, 369, 'Blais', 'Claude', 2014),
(750, 7, 557, 'Deschênes', 'Alexandre', 2014),
(751, 16, 243, 'Lepage', 'Michel', 2014),
(752, 27, 371, 'Di Battista Manseau', 'Julie', 2014),
(753, 10, 439, 'McKenna', 'Léo', 2014),
(755, 26, 103, 'Beaudin', 'Évelyne', 2014),
(756, 26, 361, 'Legault', 'Sylvain', 2014),
(758, 26, 505, 'Trottier-Kavanagh', 'Mathieu', 2014),
(759, 11, 679, 'Bernard', 'Jean-Yves', 2014),
(760, 23, 381, 'Boulanger', 'Marc', 2014),
(761, 11, 283, 'Landry', 'Colombe', 2014),
(762, 23, 349, 'Thibodeau', 'Jimmy', 2014),
(763, 6, 515, 'Racette', 'Mario', 2014),
(764, 26, 123, 'Spick', 'Denis', 2014),
(765, 6, 763, 'Mallette', 'Michel', 2014),
(766, 2, 229, 'Boutin-Sinotte', 'Hugo', 2014),
(767, 8, 683, 'Simard', 'André', 2014),
(768, 26, 465, 'Bugeaud', 'Pierre-Alexandre', 2014),
(769, 10, 535, 'Lefebvre', 'Rouge', 2014),
(770, 26, 417, 'Beaudry', 'Jennifer', 2014),
(771, 26, 209, 'Dupuis', 'Linda', 2014),
(772, 26, 745, 'Rivard', 'Yan', 2014),
(773, 10, 429, 'Miscione', 'Melissa', 2014),
(774, 22, 283, 'Côté', 'Dave', 2014),
(775, 11, 505, 'Lemay-Thivierge', 'Vincent', 2014),
(776, 22, 411, 'Pinto', 'Trevor', 2014),
(777, 23, 407, 'Bisaillon-Roy', 'Thierry', 2014),
(778, 6, 421, 'David', 'Hélène', 2014),
(779, 26, 413, 'Martinova-Croteau', 'Viviane', 2014),
(780, 27, 113, 'Girard', 'Philippe', 2014),
(781, 6, 793, 'Boucher', 'Jean', 2014),
(782, 26, 711, 'Vadeboncoeur Harrison', 'Joëlle', 2014),
(783, 26, 383, 'Servant', 'Martin', 2014),
(784, 27, 209, 'LeBlanc', 'Donald', 2014),
(785, 0, 289, 'Leblanc', 'Rodrigue', 2014),
(786, 26, 579, 'Trudel', 'Richard', 2014),
(787, 11, 123, 'Tremblay', 'Patricia', 2014),
(788, 6, 481, 'Emard', 'Vicki', 2014),
(789, 26, 427, 'Michaud', 'Benjamin', 2014),
(790, 6, 377, 'Gagnon', 'Jean-Pierre', 2014),
(792, 26, 249, 'Coulombe', 'Mathieu', 2014),
(793, 11, 381, 'David', 'Françoise', 2014),
(794, 27, 403, 'Smart', 'Elizabeth', 2014),
(795, 2, 389, 'Bissonnette', 'Marc', 2014),
(796, 8, 309, 'Pouliot-Audet', 'Olivier', 2014),
(797, 6, 389, 'Klisko', 'Anna', 2014),
(798, 0, 383, 'Hughes', 'Roger', 2014),
(799, 7, 389, 'Lachapelle', 'Serge', 2014),
(800, 31, 659, 'Gagné', 'Dave', 2014),
(801, 26, 309, 'Tessier-Moreau', 'Lorenzo', 2014),
(802, 26, 559, 'Boily', 'Philippe', 2014),
(803, 26, 113, 'Campbell', 'Jean-Simon', 2014),
(804, 6, 779, 'Gagnon', 'Pascal', 2014),
(806, 27, 567, 'Flebus', 'Bernard', 2014),
(807, 11, 773, 'Dumais', 'Réjean', 2014),
(808, 23, 387, 'Canning', 'Justin', 2014),
(809, 23, 683, 'Blais', 'Renaud', 2014),
(810, 27, 233, 'Roy', 'Nathalie', 2014),
(811, 11, 209, 'St-Denis', 'Michèle', 2014),
(812, 11, 169, 'Fortin Côté', 'David', 2014),
(813, 11, 269, 'Desrochers', 'François', 2014),
(814, 23, 623, 'Dumais', 'Sébastien', 2014),
(815, 26, 683, 'Leblanc-Lavoie', 'Joël', 2014),
(816, 27, 733, 'Jomphe', 'Mario-Michel', 2014),
(817, 6, 613, 'Chartier', 'Bernard', 2014),
(818, 26, 349, 'Brien', 'Dany', 2014),
(819, 26, 619, 'Cyr', 'Guillaume ', 2014),
(820, 11, 399, 'Emond', 'Alexandre', 2014),
(821, 11, 409, 'Belley', 'Jean-François', 2014),
(822, 6, 495, 'Boisvert', 'Ismaël', 2014),
(823, 10, 369, 'Cox', 'David', 2014),
(824, 10, 441, 'Edge', 'Brendan', 2014),
(825, 11, 733, 'Porowska', 'Natalia', 2014),
(826, 26, 387, 'Marchand', 'Simon', 2014),
(828, 23, 793, 'Guillemette', 'Matthew', 2014),
(829, 22, 495, 'Linskiy', 'Andre', 2014),
(830, 0, 153, 'Larocque', 'Sylvain', 2014),
(831, 26, 567, 'Dallaire', 'Ghislain', 2014),
(832, 26, 399, 'Drouin', 'Myriam', 2014),
(833, 26, 561, 'Harb', 'Eid', 2014),
(834, 27, 745, 'Pinard', 'Christine', 2014),
(835, 23, 133, 'Deschamps', 'Stéphane', 2014),
(836, 22, 113, 'Drogue', 'François', 2014),
(837, 11, 495, 'Jaccoud', 'Mylène', 2014),
(838, 26, 451, 'Rieussec', 'Maël', 2014),
(839, 26, 679, 'Thériault', 'François', 2014),
(840, 26, 371, 'Dao Phan', 'Geneviève', 2014),
(841, 26, 149, 'Labrie', 'Yann', 2014),
(842, 26, 379, 'Labelle', 'Sophie-Geneviève', 2014),
(843, 26, 189, 'Bossé Bélanger', 'Jade', 2014),
(844, 26, 397, 'Longchamp', 'Julien', 2014),
(845, 26, 229, 'Létourneau', 'Josée', 2014),
(846, 26, 377, 'Saavedra Renaud', 'Diego', 2014),
(847, 27, 177, 'Leftakis', 'Denis ', 2014),
(848, 23, 619, 'Fiset', 'Sylvain', 2014),
(849, 26, 443, 'Paré', 'Bernard', 2014),
(850, 22, 177, 'Dagenais', 'Alexandre', 2014),
(851, 11, 223, 'Blanchard', 'Manon', 2014),
(852, 26, 173, 'Masse', 'Vincent', 2014),
(853, 28, 349, 'Requilé', 'Laurence J.', 2014),
(854, 26, 773, 'Beaulieu', 'Nicolas', 2014),
(855, 26, 439, 'Voyer', 'David', 2014),
(856, 26, 243, 'Siouï', 'Marc-Olivier', 2014),
(857, 11, 783, 'Néron', 'Guillaume', 2014),
(858, 23, 393, 'Kruzynski', 'Anna', 2014),
(859, 6, 583, 'Boulet', 'Julie', 2014),
(860, 23, 779, 'Dubé', 'Francis', 2014),
(861, 26, 583, 'Clavet-Massicotte', 'Gabriel-Olivier', 2014),
(862, 8, 583, 'Beaudoin', 'André', 2014),
(863, 22, 779, 'Lavoie', 'Yann', 2014),
(864, 0, 113, 'Richard', 'Hubert', 2014),
(865, 11, 525, 'Mayer', 'Lucie', 2014),
(866, 11, 303, 'Comeau', 'Benoit', 2014),
(867, 11, 443, 'Des Rochers-Lamarche', 'Marie-Claire', 2014),
(868, 27, 289, 'de la Sablonnière', 'Luc', 2014),
(869, 7, 377, 'Brunelle', 'Claude', 2014),
(870, 26, 599, 'Grimard', 'Stéphanie', 2014),
(871, 27, 383, 'Clavet', 'Alain', 2014),
(872, 23, 273, 'Bélanger', 'Frédéric', 2014),
(874, 26, 363, 'Gauthier', 'Gabriel', 2014),
(876, 27, 183, 'Le Bouyonnec', 'Stéphane', 2014),
(877, 23, 193, 'Dessureault', 'Vincent', 2014),
(879, 26, 557, 'Vaive', 'Marcel', 2014),
(880, 11, 451, 'Paradis', 'Anik', 2014),
(881, 26, 283, 'Proulx', 'Vincent', 2014),
(882, 11, 183, 'André', 'Marilou', 2014),
(884, 11, 369, 'Larocque', 'Natacha', 2014),
(885, 11, 229, 'Robert', 'Sébastien', 2014),
(886, 26, 731, 'Deroy', 'Frédérick', 2014),
(887, 11, 753, 'Clavette', 'Marie-Pierre', 2014),
(888, 26, 129, 'Pépin', 'Nicolas', 2014),
(889, 10, 373, 'Teclou', 'Annibal', 2014),
(890, 11, 447, 'da Silva Pereira', 'André', 2014),
(891, 2, 383, 'Deslandes', 'Hate\'s', 2014),
(892, 27, 389, 'Thauvette', 'Patrick', 2014),
(894, 10, 451, 'Jitaru', 'Bianca', 2014),
(895, 23, 269, 'Gauthier', 'Sébastien', 2014),
(896, 29, 213, 'Portron', 'Florent', 2014),
(897, 26, 525, 'Massicotte', 'Diane', 2014),
(898, 11, 329, 'Dion', 'Marc', 2014),
(899, 26, 269, 'Doucet', 'Magali', 2014),
(900, 11, 289, 'Blouin', 'Nadia', 2014),
(901, 26, 793, 'Allen-Mercier', 'Zoé', 2014),
(902, 26, 553, 'Beauchamp', 'Jonathan', 2014),
(903, 26, 343, 'Guillemette', 'Jean', 2014),
(904, 6, 711, 'Gravel', 'Dave', 2014),
(905, 33, 349, 'Richmond', 'François-Xavier', 2014),
(907, 26, 483, 'Cauchon', 'Louis-Félix', 2014),
(908, 26, 333, 'de Repentigny', 'André', 2014),
(909, 23, 633, 'Savard', 'Jean-Luc', 2014),
(910, 22, 189, 'Grenier', 'Maryse', 2014),
(911, 27, 249, 'Renaud', 'Yves', 2014),
(912, 27, 773, 'Boucher', 'Mélanie', 2014),
(913, 23, 525, 'Dubé', 'Patrick', 2014),
(914, 31, 633, 'Drolet', 'Sylvain', 2014),
(915, 26, 733, 'Boudreau', 'David', 2014),
(916, 26, 393, 'Forest', 'Étienne', 2014),
(917, 26, 303, 'Lefebvre', 'Mathilde', 2014),
(919, 26, 535, 'Cloutier', 'Samuel', 2014),
(922, 26, 633, 'Dorion', 'Catherine', 2014),
(923, 26, 613, 'Leblanc', 'Sophie', 2014),
(924, 27, 763, 'Doyon', 'Jean-Francois', 2014),
(925, 23, 481, 'Davis', 'Jonathan', 2014),
(927, 26, 433, 'Ladouceur-Despins', 'Gabrielle', 2014),
(929, 0, 763, 'Pettersen', 'Marc', 2014),
(933, 26, 453, 'Jacob', 'Jean-François', 2014),
(934, 10, 379, 'Svetoushkina', 'Ksenia', 2014),
(935, 26, 373, 'Couture', 'Raphael', 2014),
(936, 26, 495, 'Jean-Louis', 'Curtis', 2014),
(937, 27, 779, 'Marchildon', 'Élise', 2014),
(938, 11, 779, 'Plamondon', 'Frédérick', 2014),
(939, 27, 431, 'Del Fabbro', 'Fabrizio', 2014),
(940, 2, 431, 'Brunet', 'Jean-François', 2014),
(941, 0, 525, 'Roy', 'Mario', 2014);

-- --------------------------------------------------------

--
-- Structure de la table `circonscription`
--

CREATE TABLE `circonscription` (
  `bsq` int(11) NOT NULL,
  `depute_actuel_id` int(11) DEFAULT NULL,
  `circonscription` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `annee` int(11) NOT NULL,
  `geo` longtext COLLATE utf8_unicode_ci NOT NULL,
  `depute_elu_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `circonscription`
--

INSERT INTO `circonscription` (`bsq`, `depute_actuel_id`, `circonscription`, `annee`, `geo`, `depute_elu_id`) VALUES
(103, 103, 'Mégantic', 2014, '', NULL),
(104, NULL, 'Mégantic', 2018, '', NULL),
(110, NULL, 'Saint-François', 2018, '', NULL),
(111, 354, 'Saint-François', 2014, '', NULL),
(113, 532, 'Sherbrooke', 2014, '', NULL),
(116, NULL, 'Sherbrooke', 2018, '', NULL),
(120, NULL, 'Orford', 2018, '', NULL),
(123, 369, 'Orford', 2014, '', NULL),
(126, NULL, 'Johnson', 2018, '', NULL),
(129, 312, 'Brome-Missisquoi', 2014, '', NULL),
(132, NULL, 'Richmond', 2018, '', NULL),
(133, 261, 'Granby', 2014, '', NULL),
(138, NULL, 'Drummond–Bois-Francs', 2018, '', NULL),
(143, 174, 'Iberville', 2014, '', NULL),
(144, NULL, 'Arthabaska', 2018, '', NULL),
(149, 196, 'Huntingdon', 2014, '', NULL),
(150, NULL, 'Nicolet-Bécancour', 2018, '', NULL),
(153, 297, 'Beauharnois', 2014, '', NULL),
(163, 142, 'Soulanges', 2014, '', NULL),
(169, 324, 'Vaudreuil', 2014, '', NULL),
(173, NULL, 'Châteauguay', 2014, '', NULL),
(177, 281, 'Sanguinet', 2014, '', NULL),
(183, 109, 'La Prairie', 2014, '', NULL),
(189, 78, 'Saint-Jean', 2014, '', NULL),
(193, 492, 'Chambly', 2014, '', NULL),
(203, 265, 'La Pinière', 2014, '', NULL),
(204, NULL, 'Brome-Missisquoi', 2018, '', NULL),
(206, NULL, 'Granby', 2018, '', NULL),
(209, 133, 'Laporte', 2014, '', NULL),
(210, NULL, 'Iberville', 2018, '', NULL),
(212, NULL, 'Saint-Jean', 2018, '', NULL),
(213, NULL, 'Marie-Victorin', 2014, '', NULL),
(216, NULL, 'Huntingdon', 2018, '', NULL),
(218, NULL, 'Beauharnois', 2018, '', NULL),
(220, NULL, 'Soulanges', 2018, '', NULL),
(223, 456, 'Taillon', 2014, '', NULL),
(224, NULL, 'Vaudreuil', 2018, '', NULL),
(226, NULL, 'Châteauguay', 2018, '', NULL),
(229, 349, 'Vachon', 2014, '', NULL),
(230, NULL, 'Sanguinet', 2018, '', NULL),
(232, NULL, 'LaPrairie', 2018, '', NULL),
(233, 810, 'Montarville', 2014, '', NULL),
(236, NULL, 'LaPinière', 2018, '', NULL),
(238, NULL, 'Chambly', 2018, '', NULL),
(240, NULL, 'Vachon', 2018, '', NULL),
(243, 511, 'Borduas', 2014, '', NULL),
(244, NULL, 'Laporte', 2018, '', NULL),
(246, NULL, 'Marie-Victorin', 2018, '', NULL),
(249, 352, 'Verchères', 2014, '', NULL),
(250, NULL, 'Taillon', 2018, '', NULL),
(252, NULL, 'Montarville', 2018, '', NULL),
(253, NULL, 'Richelieu', 2014, '', NULL),
(256, NULL, 'Verchères', 2018, '', NULL),
(258, NULL, 'Borduas', 2018, '', NULL),
(260, NULL, 'Saint-Hyacinthe', 2018, '', NULL),
(263, 731, 'Saint-Hyacinthe', 2014, '', NULL),
(264, NULL, 'Richelieu', 2018, '', NULL),
(269, 682, 'Johnson', 2014, '', NULL),
(273, 606, 'Drummond—Bois-Francs', 2014, '', NULL),
(283, 243, 'Richmond', 2014, '', NULL),
(289, 386, 'Lotbinière-Frontenac', 2014, '', NULL),
(293, NULL, 'Beauce-Sud', 2014, '', NULL),
(300, NULL, 'Verdun', 2018, '', NULL),
(303, 97, 'Bellechasse', 2014, '', NULL),
(304, NULL, 'Marguerite-Bourgeoys', 2018, '', NULL),
(306, NULL, 'Marquette', 2018, '', NULL),
(309, 175, 'Beauce-Nord', 2014, '', NULL),
(310, NULL, 'Jacques-Cartier', 2018, '', NULL),
(312, NULL, 'Nelligan', 2018, '', NULL),
(316, NULL, 'Robert-Baldwin', 2018, '', NULL),
(318, NULL, 'Saint-Laurent', 2018, '', NULL),
(320, NULL, 'D\'Arcy-McGee', 2018, '', NULL),
(323, NULL, 'Arthabaska', 2014, '', NULL),
(324, NULL, 'Notre-Dame-de-Grâce', 2018, '', NULL),
(326, NULL, 'Saint-Henri–Sainte-Anne', 2018, '', NULL),
(329, 182, 'Nicolet-Bécancour', 2014, '', NULL),
(330, NULL, 'Sainte-Marie–Saint-Jacques', 2018, '', NULL),
(332, NULL, 'Westmount–Saint-Louis', 2018, '', NULL),
(333, 275, 'Trois-Rivières', 2014, '', NULL),
(336, NULL, 'Mont-Royal–Outremont', 2018, '', NULL),
(338, NULL, 'Acadie', 2018, '', NULL),
(340, NULL, 'Maurice-Richard', 2018, '', NULL),
(343, 475, 'Saint-Maurice', 2014, '', NULL),
(344, NULL, 'Laurier-Dorion', 2018, '', NULL),
(346, NULL, 'Gouin', 2018, '', NULL),
(349, 382, 'Maskinongé', 2014, '', NULL),
(350, NULL, 'Mercier', 2018, '', NULL),
(352, NULL, 'Hochelaga-Maisonneuve', 2018, '', NULL),
(353, 565, 'Berthier', 2014, '', NULL),
(356, NULL, 'Rosemont', 2018, '', NULL),
(358, NULL, 'Viau', 2018, '', NULL),
(360, NULL, 'Bourassa-Sauvé', 2018, '', NULL),
(361, 81, 'Joliette', 2014, '', NULL),
(363, 229, 'L\'Assomption', 2014, '', NULL),
(364, NULL, 'Jeanne-Mance–Viger', 2018, '', NULL),
(366, NULL, 'Anjou–Louis-Riel', 2018, '', NULL),
(367, 292, 'Repentigny', 2014, '', NULL),
(369, 249, 'Pointe-aux-Trembles', 2014, '', NULL),
(370, NULL, 'Bourget', 2018, '', NULL),
(371, 252, 'LaFontaine', 2014, '', NULL),
(373, 417, 'Anjou—Louis-Riel', 2014, '', NULL),
(377, 179, 'Bourget', 2014, '', NULL),
(379, 85, 'Rosemont', 2014, '', NULL),
(380, NULL, 'Pointe-aux-Trembles', 2018, '', NULL),
(381, NULL, 'Gouin', 2014, '', NULL),
(383, 176, 'Mercier', 2014, '', NULL),
(387, 266, 'Hochelaga-Maisonneuve', 2014, '', NULL),
(389, 235, 'Sainte-Marie—Saint-Jacques', 2014, '', NULL),
(390, NULL, 'LaFontaine', 2018, '', NULL),
(391, 549, 'Westmount—Saint-Louis', 2014, '', NULL),
(393, NULL, 'Saint-Henri—Sainte-Anne', 2014, '', NULL),
(397, NULL, 'Verdun', 2014, '', NULL),
(399, 550, 'Marguerite-Bourgeoys', 2014, '', NULL),
(401, 370, 'Notre-Dame-de-Grâce', 2014, '', NULL),
(403, 452, 'D\'Arcy-McGee', 2014, '', NULL),
(407, 227, 'Marquette', 2014, '', NULL),
(409, 459, 'Jacques-Cartier', 2014, '', NULL),
(411, 652, 'Nelligan', 2014, '', NULL),
(413, 635, 'Robert-Baldwin', 2014, '', NULL),
(417, 336, 'Saint-Laurent', 2014, '', NULL),
(419, 129, 'Mont-Royal', 2014, '', NULL),
(421, 778, 'Outremont', 2014, '', NULL),
(423, 242, 'Laurier-Dorion', 2014, '', NULL),
(427, 204, 'Viau', 2014, '', NULL),
(429, 213, 'Jeanne-Mance—Viger', 2014, '', NULL),
(431, 411, 'Bourassa-Sauvé', 2014, '', NULL),
(433, 512, 'Crémazie', 2014, '', NULL),
(437, 246, 'Acadie', 2014, '', NULL),
(439, 585, 'Laval-des-Rapides', 2014, '', NULL),
(441, 159, 'Chomedey', 2014, '', NULL),
(443, NULL, 'Fabre', 2014, '', NULL),
(447, 640, 'Sainte-Rose', 2014, '', NULL),
(449, 293, 'Vimont', 2014, '', NULL),
(451, 86, 'Mille-Îles', 2014, '', NULL),
(453, 385, 'Terrebonne', 2014, '', NULL),
(454, NULL, 'Laval-des-Rapides', 2018, '', NULL),
(460, NULL, 'Chomedey', 2018, '', NULL),
(465, 234, 'Masson', 2014, '', NULL),
(466, NULL, 'Fabre', 2018, '', NULL),
(470, NULL, 'Sainte-Rose', 2018, '', NULL),
(473, 657, 'Blainville', 2014, '', NULL),
(476, NULL, 'Vimont', 2018, '', NULL),
(481, 334, 'Groulx', 2014, '', NULL),
(482, NULL, 'Mille-Îles', 2018, '', NULL),
(483, 666, 'Deux-Montagnes', 2014, '', NULL),
(495, 241, 'Mirabel', 2014, '', NULL),
(502, NULL, 'Groulx', 2018, '', NULL),
(505, NULL, 'Saint-Jérôme', 2014, '', NULL),
(508, NULL, 'Deux-Montagnes', 2018, '', NULL),
(514, NULL, 'Mirabel', 2018, '', NULL),
(515, 178, 'Rousseau', 2014, '', NULL),
(520, NULL, 'Argenteuil', 2018, '', NULL),
(525, 156, 'Bertrand', 2014, '', NULL),
(526, NULL, 'Saint-Jérôme', 2018, '', NULL),
(530, NULL, 'LesPlaines', 2018, '', NULL),
(535, 647, 'Argenteuil', 2014, '', NULL),
(536, NULL, 'Blainville', 2018, '', NULL),
(542, NULL, 'Terrebonne', 2018, '', NULL),
(545, 551, 'Labelle', 2014, '', NULL),
(548, NULL, 'Masson', 2018, '', NULL),
(553, 309, 'Papineau', 2014, '', NULL),
(554, NULL, 'L\'Assomption', 2018, '', NULL),
(557, 342, 'Gatineau', 2014, '', NULL),
(559, 567, 'Chapleau', 2014, '', NULL),
(560, NULL, 'Repentigny', 2018, '', NULL),
(561, 474, 'Hull', 2014, '', NULL),
(563, 272, 'Pontiac', 2014, '', NULL),
(566, NULL, 'Berthier', 2018, '', NULL),
(567, 689, 'Rouyn-Noranda—Témiscamingue', 2014, '', NULL),
(570, NULL, 'Joliette', 2018, '', NULL),
(573, 490, 'Abitibi-Ouest', 2014, '', NULL),
(576, NULL, 'Rousseau', 2018, '', NULL),
(579, 436, 'Abitibi-Est', 2014, '', NULL),
(582, NULL, 'Prévost', 2018, '', NULL),
(583, 859, 'Laviolette', 2014, '', NULL),
(588, NULL, 'Bertrand', 2018, '', NULL),
(593, 216, 'Champlain', 2014, '', NULL),
(594, NULL, 'Labelle', 2018, '', NULL),
(599, 438, 'Portneuf', 2014, '', NULL),
(602, NULL, 'Hull', 2018, '', NULL),
(603, 675, 'La Peltrie', 2014, '', NULL),
(608, NULL, 'Pontiac', 2018, '', NULL),
(613, NULL, 'Chauveau', 2014, '', NULL),
(614, NULL, 'Gatineau', 2018, '', NULL),
(619, 355, 'Charlesbourg', 2014, '', NULL),
(620, NULL, 'Chapleau', 2018, '', NULL),
(623, 491, 'Jean-Lesage', 2014, '', NULL),
(626, NULL, 'Papineau', 2018, '', NULL),
(633, 209, 'Taschereau', 2014, '', NULL),
(636, NULL, 'Rouyn-Noranda–Témiscamingue', 2018, '', NULL),
(639, 451, 'Vanier-Les Rivières', 2014, '', NULL),
(642, NULL, 'Abitibi-Ouest', 2018, '', NULL),
(643, NULL, 'Jean-Talon', 2014, '', NULL),
(648, NULL, 'Abitibi-Est', 2018, '', NULL),
(653, NULL, 'Louis-Hébert', 2014, '', NULL),
(659, 202, 'Chutes-de-la-Chaudière', 2014, '', NULL),
(660, NULL, 'Trois-Rivières', 2018, '', NULL),
(663, NULL, 'Lévis', 2014, '', NULL),
(666, NULL, 'Maskinongé', 2018, '', NULL),
(670, NULL, 'Laviolette–Saint-Maurice', 2018, '', NULL),
(673, 339, 'Montmorency', 2014, '', NULL),
(676, NULL, 'Champlain', 2018, '', NULL),
(679, 271, 'Charlevoix-Côte-de-Beaupré', 2014, '', NULL),
(683, 433, 'Côte-du-Sud', 2014, '', NULL),
(699, 254, 'Rivière-du-Loup—Témiscouata', 2014, '', NULL),
(702, NULL, 'Jean-Talon', 2018, '', NULL),
(703, 168, 'Rimouski', 2014, '', NULL),
(708, NULL, 'Louis-Hébert', 2018, '', NULL),
(711, 93, 'Matane-Matapédia', 2014, '', NULL),
(713, 299, 'Bonaventure', 2014, '', NULL),
(714, NULL, 'Portneuf', 2018, '', NULL),
(720, NULL, 'LaPeltrie', 2018, '', NULL),
(726, NULL, 'Vanier-Les Rivières', 2018, '', NULL),
(730, NULL, 'Taschereau', 2018, '', NULL),
(731, 256, 'Gaspé', 2014, '', NULL),
(733, 446, 'Îles-de-la-Madeleine', 2014, '', NULL),
(736, NULL, 'Jean-Lesage', 2018, '', NULL),
(742, NULL, 'Montmorency', 2018, '', NULL),
(745, 360, 'Duplessis', 2014, '', NULL),
(748, NULL, 'Charlesbourg', 2018, '', NULL),
(753, NULL, 'René-Lévesque', 2014, '', NULL),
(754, NULL, 'Chauveau', 2018, '', NULL),
(759, 423, 'Dubuc', 2014, '', NULL),
(760, NULL, 'Charlevoix–Côte-de-Beaupré', 2018, '', NULL),
(763, NULL, 'Chicoutimi', 2014, '', NULL),
(773, 253, 'Jonquière', 2014, '', NULL),
(779, 287, 'Lac-Saint-Jean', 2014, '', NULL),
(783, 403, 'Roberval', 2014, '', NULL),
(793, 781, 'Ungava', 2014, '', NULL),
(802, NULL, 'Beauce-Sud', 2018, '', NULL),
(806, NULL, 'Beauce-Nord', 2018, '', NULL),
(810, NULL, 'Lotbinière-Frontenac', 2018, '', NULL),
(814, NULL, 'Chutes-de-la-Chaudière', 2018, '', NULL),
(818, NULL, 'Lévis', 2018, '', NULL),
(822, NULL, 'Bellechasse', 2018, '', NULL),
(826, NULL, 'Côte-du-Sud', 2018, '', NULL),
(834, NULL, 'Rivière-du-Loup–Témiscouata', 2018, '', NULL),
(838, NULL, 'Rimouski', 2018, '', NULL),
(842, NULL, 'Matane-Matapédia', 2018, '', NULL),
(850, NULL, 'Bonaventure', 2018, '', NULL),
(854, NULL, 'Gaspé', 2018, '', NULL),
(858, NULL, 'Îles-de-la-Madeleine', 2018, '', NULL),
(902, NULL, 'Duplessis', 2018, '', NULL),
(906, NULL, 'René-Lévesque', 2018, '', NULL),
(914, NULL, 'Dubuc', 2018, '', NULL),
(918, NULL, 'Chicoutimi', 2018, '', NULL),
(922, NULL, 'Jonquière', 2018, '', NULL),
(926, NULL, 'Lac-Saint-Jean', 2018, '', NULL),
(930, NULL, 'Roberval', 2018, '', NULL),
(938, NULL, 'Ungava', 2018, '', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `migration_versions`
--

CREATE TABLE `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `migration_versions`
--

INSERT INTO `migration_versions` (`version`) VALUES
('20180413165936'),
('20180416194354'),
('20180418175033');

-- --------------------------------------------------------

--
-- Structure de la table `parti`
--

CREATE TABLE `parti` (
  `chef_id` int(11) DEFAULT NULL,
  `num_dgeq` int(11) NOT NULL,
  `nom` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `sigle` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(75) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `parti`
--

INSERT INTO `parti` (`chef_id`, `num_dgeq`, `nom`, `sigle`, `logo`) VALUES
(NULL, 0, 'Candidats indépendants/Independent candidates', 'Ind.', ''),
(NULL, 2, 'Bloc pot', 'B.P.', ''),
(NULL, 4, 'Parti unité nationale', 'P.U.N.', ''),
(NULL, 6, 'Parti libéral du Québec/Quebec Liberal Party', 'P.L.Q./Q.L.P.', 'plq.svg'),
(NULL, 7, 'Parti marxiste-léniniste du Québec', 'P.M.L.Q.', 'pmlq.png'),
(NULL, 8, 'Parti québécois', 'P.Q.', 'pq.svg'),
(NULL, 10, 'Parti vert du Québec/Green Party of Québec', 'P.V.Q./G.P.Q.', 'pvq.svg'),
(NULL, 11, 'Québec solidaire', 'Q.S.', 'qs.svg'),
(NULL, 16, 'Parti indépendantiste', 'P.I.', 'piq.png'),
(NULL, 22, 'Équipe Adrien Pouliot - Parti conservateur du Québec', 'É.A.P. - P.C.Q.', 'pcq.png'),
(NULL, 23, 'Parti nul', 'P.N.', 'pnq.jpg'),
(NULL, 25, 'Québec - Révolution démocratique', 'Q.R.D.', ''),
(NULL, 26, 'Option nationale - Pour l\'indépendance du Québec', 'O.N. - P.I.Q.', 'on.svg'),
(NULL, 27, 'Coalition avenir Québec - L\'équipe François Legault', 'C.A.Q.-É.F.L.', 'caq.svg'),
(NULL, 28, 'Parti équitable', 'P.Éq.', 'peq.jpg'),
(NULL, 29, 'Équipe autonomiste', 'É.A.', ''),
(NULL, 31, 'Parti des sans parti', 'P.S.P.', ''),
(NULL, 32, 'Union citoyenne du Québec / Québec Citizens\' Union', 'U.C.Q./Q.C.U.', ''),
(NULL, 33, 'Mon pays le Québec', 'M.P.Q.', 'mplq.jpg');

-- --------------------------------------------------------

--
-- Structure de la table `prediction`
--

CREATE TABLE `prediction` (
  `id` int(11) NOT NULL,
  `usager_id` int(11) DEFAULT NULL,
  `candidat_id` int(11) DEFAULT NULL,
  `circonscription_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `prediction`
--

INSERT INTO `prediction` (`id`, `usager_id`, `candidat_id`, `circonscription_id`) VALUES
(2, 1, 582, 579),
(3, 1, 616, 579),
(4, 5, 582, 579),
(5, 4, 690, 579),
(6, 4, 237, 437),
(7, 4, 889, 373),
(8, 6, 425, 535),
(9, 6, 582, 579),
(10, 6, 358, 573),
(11, 6, 498, 323),
(12, 6, 237, 437),
(13, 6, 299, 713),
(14, 6, 510, 243),
(15, 6, 441, 431),
(16, 6, 163, 377),
(17, 6, 574, 129),
(18, 6, 492, 193);

-- --------------------------------------------------------

--
-- Structure de la table `resultat`
--

CREATE TABLE `resultat` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `statut`
--

CREATE TABLE `statut` (
  `id` int(11) NOT NULL,
  `etat` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `usager`
--

CREATE TABLE `usager` (
  `id` int(11) NOT NULL,
  `username` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `circonscription_id` int(11) DEFAULT NULL,
  `code_postal` varchar(7) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `usager`
--

INSERT INTO `usager` (`id`, `username`, `password`, `active`, `circonscription_id`, `code_postal`) VALUES
(1, 'jonathmartel@gmail.com', '$2y$10$yO4LpqFn7LvKEFvGJDdb0eBim0eae0ma7nb/xUW7S//KITd0J0Nt6', 0, NULL, ''),
(4, 'test@test.com', '$2y$10$VMr1kDtDOnwdZ76XPxmZg.BUU1JWdthRSzXvDHGgM4UFF8L3DWfJO', 0, NULL, ''),
(5, 'test1@test.com', '$2y$10$c5pxR0Z.Kb9fxSuMqbWB2eOh.EiDMUDFIIIPeFSj.bmAe.6xysxI6', 0, NULL, ''),
(6, 'test2@test.com', '$2y$10$S4PVheZSpG54VKCgauU8NuWl1bktFAHpkM5Gw6bM4ZuDxkbT5OYhS', 0, NULL, '');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `candidat`
--
ALTER TABLE `candidat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_6AB5B471712547C6` (`parti_id`),
  ADD KEY `IDX_6AB5B471F4E36` (`bsq_id`);

--
-- Index pour la table `circonscription`
--
ALTER TABLE `circonscription`
  ADD PRIMARY KEY (`bsq`);
--  ,
--  ADD UNIQUE KEY `UNIQ_FEDDA65A9C80A68A` (`depute_actuel_id`),
--  ADD UNIQUE KEY `UNIQ_FEDDA65ABE4E1C0C` (`depute_elu_id`);

--
-- Index pour la table `migration_versions`
--
ALTER TABLE `migration_versions`
  ADD PRIMARY KEY (`version`);

--
-- Index pour la table `parti`
--
ALTER TABLE `parti`
  ADD PRIMARY KEY (`num_dgeq`),
  ADD UNIQUE KEY `UNIQ_94225E84150A48F1` (`chef_id`);

--
-- Index pour la table `prediction`
--
ALTER TABLE `prediction`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_36396FC84F36F0FC` (`usager_id`),
  ADD KEY `IDX_36396FC88D0EB82` (`candidat_id`),
  ADD KEY `IDX_36396FC8755DBAE` (`circonscription_id`);

--
-- Index pour la table `resultat`
--
ALTER TABLE `resultat`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `statut`
--
ALTER TABLE `statut`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `usager`
--
ALTER TABLE `usager`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_3CDC65FFF85E0677` (`username`),
  ADD KEY `IDX_3CDC65FF755DBAE` (`circonscription_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `prediction`
--
ALTER TABLE `prediction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT pour la table `resultat`
--
ALTER TABLE `resultat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `statut`
--
ALTER TABLE `statut`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `usager`
--
ALTER TABLE `usager`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `candidat`
--
ALTER TABLE `candidat`
  ADD CONSTRAINT `FK_6AB5B471712547C6` FOREIGN KEY (`parti_id`) REFERENCES `parti` (`num_dgeq`),
  ADD CONSTRAINT `FK_6AB5B471F4E36` FOREIGN KEY (`bsq_id`) REFERENCES `circonscription` (`bsq`);

--
-- Contraintes pour la table `circonscription`
--
ALTER TABLE `circonscription`
  ADD CONSTRAINT `FK_FEDDA65A9C80A68A` FOREIGN KEY (`depute_actuel_id`) REFERENCES `candidat` (`id`),
  ADD CONSTRAINT `FK_FEDDA65ABE4E1C0C` FOREIGN KEY (`depute_elu_id`) REFERENCES `candidat` (`id`);

--
-- Contraintes pour la table `parti`
--
ALTER TABLE `parti`
  ADD CONSTRAINT `FK_94225E84150A48F1` FOREIGN KEY (`chef_id`) REFERENCES `candidat` (`id`);

--
-- Contraintes pour la table `prediction`
--
ALTER TABLE `prediction`
  ADD CONSTRAINT `FK_36396FC84F36F0FC` FOREIGN KEY (`usager_id`) REFERENCES `usager` (`id`),
  ADD CONSTRAINT `FK_36396FC8755DBAE` FOREIGN KEY (`circonscription_id`) REFERENCES `circonscription` (`bsq`),
  ADD CONSTRAINT `FK_36396FC88D0EB82` FOREIGN KEY (`candidat_id`) REFERENCES `candidat` (`id`);

--
-- Contraintes pour la table `usager`
--
ALTER TABLE `usager`
  ADD CONSTRAINT `FK_3CDC65FF755DBAE` FOREIGN KEY (`circonscription_id`) REFERENCES `circonscription` (`bsq`);
COMMIT;

/*!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 */;