INSERT INTO `patient` (`idPat`, `idMut`, `idMed`, `nomPat`, `pnomPat`, `dateNais`, `adPat`, `CPPat`, `villePat`) VALUES
(4237, 3, 196, 'Kragor', 'Maryvonne', '1921-12-30', '31 RUE PAULIN PARIS ', '51100', 'REIMS'),
(4238, 3, 136, 'Sorge', 'Mikaël', '1904-01-01', '5153 LES GRANDS PRES ', '51500', 'TAISSY'),
(4239, 2, 192, 'Sounra', 'Geoffrey', '2008-12-30', '26 RUE STE CATHERINE ', '51800', 'SAINTE MENEHOULD'),
(4240, 1, 130, 'Lugru', 'Violaine', '2002-12-30', '78 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4241, 5, 138, 'Vadai', 'Fernande', '1926-12-30', '11 BD FOCH ', '51100', 'REIMS'),
(4242, 3, 100, 'Quursro', 'Umberto', '1980-12-29', '178 AV DU GENERAL LECLERC ', '51530', 'DIZY'),
(4243, 4, 151, 'Cagur', 'Laurens', '1991-01-01', '213 AV JEAN JAURES ', '51100', 'REIMS'),
(4244, 5, 133, 'Carru', 'Rémy', '1911-12-31', '5 RLE DU PONT NAUDIN ', '51240', 'CHEPY'),
(4245, 3, 175, 'Farra', 'Juergen', '1999-12-30', '40 RUE DE ST BRICE ', '51100', 'REIMS'),
(4246, 3, 102, 'Lesu', 'Coralie', '1927-12-31', '24 RUE DE THILLOIS ', '51100', 'REIMS'),
(4247, 5, 192, 'Yagor', 'Sonia', '2008-12-29', '48 RUE ST JEAN ', '51480', 'CUMIERES'),
(4248, 2, 166, 'Vroryan', 'Guibert', '1953-01-01', '65 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4249, 1, 170, 'Quovrou', 'Mélissa', '1948-01-01', '61 RUE ERNEST RENAN ', '51100', 'REIMS'),
(4250, 2, 77, 'Fanvur', 'Antoine', '1998-12-31', '22 RUE NUNGESSER ET COLI ', '51100', 'REIMS'),
(4251, 4, 103, 'Madu', 'Uriel', '1980-01-01', '25 RUE CAMILLE COROT ', '51000', 'CHALONS EN CHAMPAGNE'),
(4252, 4, 80, 'Gangu', 'Graeme', '1976-12-30', '5060 LE VILLAGE ', '51110', 'HEUTREGIVILLE'),
(4253, 3, 46, 'Cadan', 'Vincent', '1967-12-31', '3 RUE DE LA GROTTE ', '51390', 'COURMAS'),
(4254, 4, 137, 'Sanra', 'Christopher', '2012-12-29', '3 RUE FRESNET REMI PASCAL ', '51380', 'VERZY'),
(4255, 3, 69, 'Normi', 'Timothée', '1998-12-29', '1 RUE RAYMOND QUENEAU ', '51370', 'SAINT BRICE COURCELLES'),
(4256, 5, 127, 'Sorfan', 'Bruce', '1918-12-31', '37 RUE DE LA GOULETTE ', '51100', 'REIMS'),
(4257, 4, 113, 'Gine', 'Hervé', '1956-12-30', '1 RUE DE COURTISOLS ', '51460', 'SAINT-ETIENNE-AU-TEMPLE'),
(4258, 3, 94, 'Nedi', 'Anthony', '1947-01-01', '2 RUE LEON BLUM NEUV ', '51100', 'REIMS'),
(4259, 4, 110, 'Trugor', 'Guillemette', '1926-12-30', '15 RUE DE LA FAUVETTE ', '51200', 'EPERNAY'),
(4260, 1, 50, 'Fanan', 'Fernande', '1963-12-31', '5 RUE DES MURS ', '51100', 'REIMS'),
(4261, 4, 183, 'Srarfe', 'Reine', '1936-01-01', '111 RUE DE CERNAY ', '51100', 'REIMS'),
(4262, 4, 90, 'Farcor', 'Ric', '1945-12-31', '24 ALL DE FORETS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4263, 5, 108, 'Laco', 'Colette', '1981-12-31', '5 RUE DE L EGLISE ', '51140', 'TRIGNY'),
(4264, 4, 145, 'Gaiprou', 'Bruce', '1977-12-29', '4 RUE PABLO PICASSO ', '51140', 'MUIZON'),
(4265, 2, 8, 'Srosa', 'Michelle', '1933-12-31', '4 CHEM DE L ABBAYE ', '51120', 'NESLE-LA-REPOSTE'),
(4266, 3, 185, 'Nursai', 'Eugène', '1982-12-31', '25 RUE DU GENERAL LECLERC ', '51220', 'SAINT-THIERRY'),
(4267, 5, 127, 'Lantar', 'Susan', '1947-01-01', '80 RUE DE CHOISET ', '51300', 'LOISY-SUR-MARNE'),
(4268, 4, 164, 'Morran', 'Lilian', '1956-12-30', '3 RUE JULIETTE RECAMIER ', '51000', 'CHALONS EN CHAMPAGNE'),
(4269, 5, 197, 'Hatrai', 'Tony', '1995-12-30', '9 RUE DE HOUDAN ', '51370', 'SAINT BRICE COURCELLES'),
(4270, 2, 1, 'Couye', 'Katie', '2010-12-31', '42 RUE SABATTHIER ', '51000', 'CHALONS EN CHAMPAGNE'),
(4271, 1, 71, 'Hada', 'Guillermo', '1950-01-01', '8 RUE DE BACONNES ', '51430', 'BEZANNES'),
(4272, 1, 104, 'Tratran', 'Didier', '1965-12-30', '3 AV GEORGES CLEMENCEAU ', '51100', 'REIMS'),
(4273, 5, 8, 'Frosa', 'Werner', '1917-12-30', '22 AV P VAILLANT COUTURIER ', '51430', 'TINQUEUX'),
(4274, 1, 90, 'Gagou', 'César', '1932-01-01', '6 RUE SAINT THIERRY ', '51100', 'REIMS'),
(4275, 4, 66, 'Crori', 'Edith', '2005-12-31', '6 ALL DES BLEUETS ', '51400', 'LES PETITES LOGES'),
(4276, 5, 150, 'Rouvon', 'Ginette', '1971-12-31', '153 AV DE LAON ', '51100', 'REIMS'),
(4277, 3, 132, 'Manla', 'Gaétane', '1968-12-29', '10 RUE DE SOLFERINO ', '51100', 'REIMS'),
(4278, 2, 75, 'Dokru', 'Isabella', '2010-12-31', '3 RUE DE VINETZ ', '51000', 'CHALONS EN CHAMPAGNE'),
(4279, 4, 10, 'Nurla', 'Orianne', '1961-12-29', '17 RUE DU CHAMP DE MARS ', '51100', 'REIMS'),
(4280, 3, 182, 'Leca', 'Kurt', '1959-12-30', '4 RUE JEAN JAURES ', '51480', 'OEUILLY'),
(4281, 3, 6, 'Surga', 'Flavio', '1969-12-31', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4282, 4, 26, 'Vorkre', 'Felipe', '1953-12-30', '3 RUE DES VERGERS ', '51520', 'SARRY'),
(4283, 5, 92, 'Matou', 'Mohammad', '1913-12-30', '23 RUE FREDERIC PLOMB ', '51200', 'EPERNAY'),
(4284, 3, 188, 'Tara', 'Joseph', '1944-01-01', '650 RUE DE CHAMPAGNE ', '52200', 'LANGRES'),
(4285, 1, 162, 'Lesor', 'Bertil', '1919-01-01', '3 RTE DE L ECLUSE ', '51160', 'AY-CHAMPAGNE'),
(4286, 2, 85, 'Mouna', 'Jessica', '1986-12-29', '14 BD HENRY VASNIER ', '51100', 'REIMS'),
(4287, 5, 159, 'Soupron', 'Timothy', '2009-12-31', '11 RUE DES CARREAUX ', '51350', 'CORMONTREUIL'),
(4288, 2, 54, 'Ruhan', 'Sylvine', '1935-12-31', '9001 RUE ANDRE FAIVRE ', '51100', 'REIMS'),
(4289, 4, 147, 'Dato', 'Angelo', '1909-12-30', '2 RUE DES ARTISANS ', '51350', 'CORMONTREUIL'),
(4290, 3, 61, 'Ganvou', 'Anna', '1910-01-01', '135 RUE DE COURLANCY ', '51100', 'REIMS'),
(4291, 2, 83, 'Quatrou', 'Natacha', '1978-12-31', '5 RUE DES TROIS MAILLETS ', '51600', 'SUIPPES'),
(4292, 3, 61, 'Fama', 'Janet', '1985-12-31', '17 RUE DU TEMPLE ', '51100', 'REIMS'),
(4293, 5, 165, 'Goupra', 'Odile', '1961-12-30', '10 RUE GOIOT ', '51100', 'REIMS'),
(4294, 2, 180, 'Maca', 'Delphine', '1922-01-01', '60 RUE ETIENNE OEHMICHEN ', '51000', 'CHALONS EN CHAMPAGNE'),
(4295, 2, 108, 'Fokrou', 'Christiane', '1982-12-30', '6 RUE DE BACONNES ', '51430', 'BEZANNES'),
(4296, 2, 181, 'Ceha', 'Guillermo', '1947-12-31', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4297, 4, 87, 'Nanze', 'Carole', '1977-01-01', '23 PL DROUET D ERLON ', '51100', 'REIMS'),
(4298, 1, 24, 'Favor', 'Aldo', '1987-12-30', '3 RUE DU BRABANT ', '51150', 'CONDE-SUR-MARNE'),
(4299, 4, 80, 'Relan', 'Gordon', '1966-12-31', '63 RUE DU VIEUX COLOMBIER ', '51100', 'REIMS'),
(4300, 3, 44, 'Lelon', 'Hernandez', '1926-12-31', '5 RUE HELENE NAUTRE ', '51100', 'REIMS'),
(4301, 1, 124, 'Vouman', 'Félix', '1971-12-30', '12 RUE DES CHARRETIERS ', '51600', 'SOMME-SUIPPE'),
(4302, 1, 113, 'Tantra', 'Elisa', '1958-01-01', '31 RUE DU GROUPE TRITANT ', '51000', 'CHALONS EN CHAMPAGNE'),
(4303, 1, 184, 'Gavan', 'Myriam', '1992-12-30', '5 BD LUNDY ', '51100', 'REIMS'),
(4304, 3, 70, 'Truhan', 'Ronald', '2006-12-30', '84 RUE L HOPITAL AUBAN MOET ', '51200', 'EPERNAY'),
(4305, 3, 71, 'Fanna', 'Constance', '1996-12-30', '37 RUE DE LA GARE ', '52100', 'SAINT-EULIEN'),
(4306, 3, 47, 'Manvou', 'Luis', '1988-12-30', '1 PL DE LA MAIRIE ', '51300', 'VITRY-EN-PERTHOIS'),
(4307, 2, 77, 'Chouran', 'Franck', '1963-01-01', '8 RUE FREDERIC MISTRAL ', '51430', 'BEZANNES'),
(4308, 1, 193, 'Tranlai', 'Georges', '2007-12-30', '13 RUE DES TELLIERS ', '51100', 'REIMS'),
(4309, 4, 36, 'Toule', 'Aline', '1992-12-29', '37 RUE DE LA GARE ', '52100', 'SAINT-EULIEN'),
(4310, 4, 151, 'Gancou', 'Emma', '1915-01-01', '22 RUE DE LA MAGDELEINE ', '51100', 'REIMS'),
(4311, 4, 31, 'Misan', 'Joan', '1947-12-30', '3 RUE DE TROUAN ', '51320', 'LE MEIX TIERCELIN'),
(4312, 4, 110, 'Zocu', 'Eurinsa', '1948-01-01', '38 BD HIPPOLYTE FAURE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4313, 5, 4, 'Farou', 'Aline', '1911-12-31', '24 RUE SAINT JEAN ', '51240', 'CHEPY'),
(4314, 3, 168, 'Vegron', 'Marianne', '1966-01-01', '9001 RUE PIERRE TAITTINGER ', '51100', 'REIMS'),
(4315, 3, 116, 'Data', 'Philippon', '1909-12-31', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4316, 1, 64, 'Ratran', 'Heddy', '1929-12-30', '16 RUE BLONDEL ', '51100', 'REIMS'),
(4317, 5, 94, 'Nancou', 'Thierry', '1951-01-01', '11 RUE FOLLE PEINE ', '51100', 'REIMS'),
(4318, 3, 95, 'Tanpror', 'Ulrich', '1987-12-31', '5195 LE VILLAGE ', '51800', 'FLORENT-EN-ARGONNE'),
(4319, 4, 78, 'Gomor', 'Isabelle', '2003-12-30', '3 RUE HOUZEAU MUIRON ', '51100', 'REIMS'),
(4320, 3, 136, 'Tana', 'Sylvine', '1937-12-29', '19 RUE DE CLAIRMARAIS ', '51100', 'REIMS'),
(4321, 3, 32, 'Tedi', 'Emile', '1905-12-31', '136 RUE DES CAPUCINS ', '51100', 'REIMS'),
(4322, 1, 84, 'Taido', 'Maxence', '1956-01-01', '11 RUE GEORGES TANGRE ', '51170', 'FISMES'),
(4323, 4, 127, 'Quanyan', 'Gaétane', '1973-01-01', '21 RUE PASSE DEMOISELLES ', '51100', 'REIMS'),
(4324, 1, 199, 'Nasu', 'Arnold', '1935-01-01', '89 RUE D ALSACE LORRAINE ', '51100', 'REIMS'),
(4325, 3, 18, 'Nome', 'Rodolfo', '1931-12-30', '198 AV JEAN JAURES ', '51100', 'REIMS'),
(4326, 4, 63, 'Drirou', 'Mylène', '1982-12-31', '65 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4327, 5, 190, 'Hene', 'Jakob', '1936-01-01', '32 RUE JEAN JACQUES ROUSSEAU ', '51100', 'REIMS'),
(4328, 4, 147, 'Carvron', 'Gervaise', '2012-12-30', '14 RUE JEAN JAURES ', '51000', 'CHALONS EN CHAMPAGNE'),
(4329, 1, 166, 'Fonjai', 'Romuald', '1913-12-30', '16 VC DES SARRAZINS ', '51250', 'SERMAIZE-LES-BAINS'),
(4330, 5, 186, 'Vanzu', 'Claudio', '1984-01-01', '23 RUE HUGUES KRAFFT ', '51100', 'REIMS'),
(4331, 3, 103, 'Prucrou', 'Bertil', '1911-01-01', '22 RUE DU PORT DE MARNE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4332, 4, 47, 'Krolar', 'Tony', '1908-01-01', '136 RUE DE LA MAISON BLANCHE ', '51100', 'REIMS'),
(4333, 1, 182, 'Krarvan', 'Bill', '1988-12-31', '6 RUE DU LYCEE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4334, 1, 158, 'Figo', 'Fabrizio', '1913-12-31', '1 RUE BRULART ', '51100', 'REIMS'),
(4335, 4, 198, 'Togru', 'Erik', '1999-12-31', '60 RUE DES MOISSONS ', '51100', 'REIMS'),
(4336, 5, 197, 'Guje', 'Miguel', '1908-12-30', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4337, 5, 25, 'Riquou', 'Christina', '1911-12-31', '22 RUE DIDEROT ', '51430', 'TINQUEUX'),
(4338, 3, 38, 'Canve', 'Francis', '2008-12-30', '37 AV DES ALLIES ', '51000', 'CHALONS EN CHAMPAGNE'),
(4339, 1, 19, 'Nando', 'Eléna', '1917-12-31', '7 ALL DU CHALET ', '51110', 'BOULT-SUR-SUIPPE'),
(4340, 5, 125, 'Routan', 'Yan', '1950-01-01', '1 RUE RENE FRANCART ', '51100', 'REIMS'),
(4341, 5, 138, 'Craikra', 'Luce', '1949-12-31', '14 RUE PRINCIPALE ', '52500', 'MAATZ'),
(4342, 4, 127, 'Danle', 'Morris', '2003-12-31', '134 RUE PIERRE BROSSOLETTE ', '51100', 'REIMS'),
(4343, 3, 164, 'Dave', 'Judith', '1913-12-31', '15 RUE MICHEL SICRE ', '51100', 'REIMS'),
(4344, 3, 159, 'Tursor', 'Mariane', '2001-12-31', '10 RUE GERARD PHILIPE ', '51100', 'REIMS'),
(4345, 4, 13, 'Gega', 'Bernhard', '1941-12-31', '21 BD WILSON ', '51310', 'ESTERNAY'),
(4346, 1, 106, 'Maca', 'Petr', '2004-12-30', '39 AV HENRI FARMAN ', '51100', 'REIMS'),
(4347, 2, 134, 'Fame', 'Amine', '1918-12-31', '9 RUE DE TREPAIL ', '51150', 'BOUZY'),
(4348, 3, 40, 'Gaje', 'Arian', '1969-12-30', '25 PL DU GENERAL DE GAULLE ', '51530', 'SAINT-MARTIN-D\'ABLOIS'),
(4349, 5, 14, 'Hoprar', 'Petrovic', '1985-12-30', '5056 LE VILLAGE ', '51800', 'FLORENT-EN-ARGONNE'),
(4350, 3, 179, 'Yime', 'Josiane', '1957-12-31', '51 AV BONAPARTE PROL ', '51430', 'TINQUEUX'),
(4351, 1, 103, 'Rurso', 'Silvia', '1909-12-30', '2 IMP DES TEMPLIERS ', '51520', 'LA VEUVE'),
(4352, 4, 182, 'Nacar', 'Frank', '1993-12-31', '15 RUE M CLEMENCE FOURIAUX ', '51100', 'REIMS'),
(4353, 2, 172, 'Yanco', 'Graeme', '1974-12-31', '104 AV DE LAON ', '51100', 'REIMS'),
(4354, 3, 191, 'Raidi', 'Audrey', '1949-12-31', '32 RUE THIERCELIN PARRICHAULT ', '51200', 'EPERNAY'),
(4355, 3, 149, 'Derar', 'Karim', '1949-12-31', '58 AV D EPERNAY ', '51100', 'REIMS'),
(4356, 1, 48, 'Dute', 'Gwenaelle', '1956-12-29', '26 RUE DE PONTGIVART ', '51100', 'REIMS'),
(4357, 2, 130, 'Ransa', 'Coralie', '1999-01-01', '17 RUE CROIX ST MARC ', '51100', 'REIMS'),
(4358, 4, 48, 'Gelou', 'Nils', '1971-12-30', '5 RUE TOURNEBONNEAU ', '51100', 'REIMS'),
(4359, 5, 20, 'Franvai', 'Sylvette', '1997-12-30', '1 ALL VICTOR GRIGNARD ', '51430', 'BEZANNES'),
(4360, 3, 120, 'Lena', 'Bernadette', '1934-12-30', '4 RUE MARIE STUART ', '51100', 'REIMS'),
(4361, 3, 75, 'Naima', 'Sylvia', '1991-12-30', '1 RUE DU GENERAL LECLERC ', '51400', 'MOURMELON LE GRAND'),
(4362, 4, 58, 'Vanfou', 'Mariane', '1960-12-30', '4 RUE GRACCHUS BABEUF ', '51000', 'CHALONS EN CHAMPAGNE'),
(4363, 4, 6, 'Logi', 'Victoria', '1983-12-30', '7 RUE DES TEMPLIERS ', '51100', 'REIMS'),
(4364, 1, 155, 'Jadro', 'Hans', '2013-12-29', '10 AV AMPERE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4365, 1, 61, 'Vaive', 'Gene', '1936-12-31', '5061 LA VOIE DE MANGE ', '51360', 'VAL-DE-VESLE'),
(4366, 2, 33, 'Sada', 'Roseline', '1973-12-30', '38 RUE DES CHAMPS FLUTETS ', '51510', 'COMPERTRIX'),
(4367, 5, 40, 'Dura', 'Aaron', '1994-12-31', '3 RUE IRENEE LELIEVRE ', '51100', 'REIMS'),
(4368, 2, 56, 'Droga', 'Earl', '1990-01-01', '7 RUE GUILLAUME APOLLINAIRE ', '51100', 'REIMS'),
(4369, 2, 7, 'Hocha', 'Maryse', '1986-12-30', '2 RUE HINCMAR ', '51100', 'REIMS'),
(4370, 3, 185, 'Loula', 'Auguste', '1938-12-29', '22 RUE DE LA MAGDELEINE ', '51100', 'REIMS'),
(4371, 4, 71, 'Canfan', 'Alejandra', '1993-12-30', '85 BD J F KENNEDY ', '51000', 'CHALONS EN CHAMPAGNE'),
(4372, 5, 197, 'Name', 'Rodolphe', '1992-12-30', '10 RUE DE LA HAIE ', '51300', 'COUVROT'),
(4373, 2, 131, 'Norgan', 'Richard', '2005-12-30', '17 RUE D ANJOU ', '51200', 'EPERNAY'),
(4374, 4, 65, 'Dansou', 'Astrid', '1950-12-31', '11 RUE MACQUART ', '51100', 'REIMS'),
(4375, 4, 178, 'Geta', 'Armel', '1936-01-01', '9 RUE DE L\'ERABLE ', '51230', 'LENHARREE'),
(4376, 2, 83, 'Roncan', 'Saïd', '1934-01-01', '5 ALL DES NIRVALLES ', '51430', 'BEZANNES'),
(4377, 1, 156, 'Fege', 'Clémentine', '1960-12-30', '17 BD DE LA PAIX ', '51100', 'REIMS'),
(4378, 3, 37, 'Hese', 'Jeannine', '2012-12-30', '57 RUE ARTHUR HANNEQUIN ', '51340', 'PARGNY-SUR-SAULX'),
(4379, 1, 53, 'Voge', 'Gloria', '1911-01-01', '11 RUE SAINT EXUPERY ', '51400', 'LIVRY-LOUVERCY'),
(4380, 3, 154, 'Zoucar', 'Josée', '1995-12-31', '1 PAS FOURCHE ', '51200', 'EPERNAY'),
(4381, 4, 174, 'Gouce', 'Maurizio', '1951-12-30', '7 RUE DE SAINT EXUPERY ', '51170', 'FISMES'),
(4382, 5, 50, 'Goce', 'Antony', '1935-12-31', '7 CHE DU TELEGRAPHE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4383, 2, 71, 'Mugur', 'Antoine', '1970-12-30', '5 RUE DE LA POMPELLE ', '51100', 'REIMS'),
(4384, 5, 88, 'Vrurga', 'Duong', '1998-12-31', '28 RUE DES SORANGES ', '51220', 'HERMONVILLE'),
(4385, 1, 198, 'Morvru', 'Patricio', '1972-12-30', '20 RUE DES MONDETTES ', '51160', 'CHAMPILLON'),
(4386, 1, 42, 'Honfou', 'Alphonse', '1965-12-30', '9 BD DE L\'EUROPE ', '51420', 'WITRY-LES-REIMS'),
(4387, 1, 165, 'Randre', 'Elise', '1966-12-30', '9001 ALL RONSARD ', '51100', 'REIMS'),
(4388, 4, 142, 'Srahan', 'Adèle', '1977-01-01', '9 GR GRANDE RUE ', '51800', 'ARGERS'),
(4389, 4, 59, 'Nece', 'Dave', '1946-12-31', '6 RUE DES JARDINS ', '51290', 'MARGERIE-HANCOURT'),
(4390, 5, 60, 'Rouquo', 'Douglas', '1923-12-30', '49 RUE LECOINTRE ', '51100', 'REIMS'),
(4391, 1, 190, 'Franson', 'Siegfried', '1987-12-31', '20 RUE DU GENERAL GOURAUD ', '51400', 'MOURMELON LE GRAND'),
(4392, 3, 21, 'Mousi', 'Sylvaine', '1939-12-30', '2 RLE DES CONSINS ', '51500', 'ECUEIL'),
(4393, 1, 30, 'Tanan', 'Angéla', '1956-12-30', '5 RUE JACQUES MONOD ', '51430', 'TINQUEUX'),
(4394, 5, 89, 'Ranfe', 'Corinne', '1947-12-31', '22 RUE DE CHASTILLON ', '51000', 'CHALONS EN CHAMPAGNE'),
(4395, 2, 61, 'Letan', 'Jurgen', '1999-12-31', '5000 RUE DE SOMPUIS ', '51300', 'BLACY'),
(4396, 1, 160, 'Situr', 'Daniel', '1937-12-29', '15 RUE TOURNEBONNEAU ', '51100', 'REIMS'),
(4397, 4, 10, 'Vranga', 'Chantale', '1979-12-31', '65 RUE DU BARBATRE ', '51100', 'REIMS'),
(4398, 2, 162, 'Naca', 'Volker', '1949-12-31', '13 RTE DE BETHENY ', '51450', 'BETHENY'),
(4399, 1, 152, 'Visa', 'Viviane', '1990-12-30', '68 RUE PRINCIPALE ', '51320', 'SOUDRON'),
(4400, 4, 91, 'Trandan', 'Jeannine', '1916-12-29', '21 AV HENRI FARMAN ', '51100', 'REIMS'),
(4401, 1, 16, 'Mosai', 'Jurgen', '1973-12-31', '104 RUE DU CHALET ', '51100', 'REIMS'),
(4402, 3, 70, 'Dantre', 'Karen', '1933-12-31', '7 IMP SAINT ELOI ', '51140', 'COURCELLES-SAPICOURT'),
(4403, 1, 104, 'Formar', 'Bret', '1988-01-01', '1 RUE DU LAC ', '51290', 'GIFFAUMONT-CHAMPAUBERT'),
(4404, 3, 60, 'Feva', 'Ulrich', '1921-12-31', '25 RUE LAFAYETTE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4405, 3, 32, 'Nannu', 'Linda', '2008-12-29', '5002 CHE DE REUIL ', '51480', 'DAMERY'),
(4406, 4, 173, 'Nosa', 'Ahmad', '1973-12-30', '6 RUE JULIAN GRIMAU ', '51260', 'SAINT-JUST-SAUVAGE'),
(4407, 3, 151, 'Rega', 'Dana', '2000-01-01', '5 RUE DU MONT LAMPAS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4408, 5, 59, 'Huhur', 'Tim', '1930-12-30', '18 RUE ROGER SALENGRO ', '51500', 'RILLY-LA-MONTAGNE'),
(4409, 5, 64, 'Goya', 'Ken', '2008-12-30', '9001 RUE CHARLIER ', '51100', 'REIMS'),
(4410, 1, 64, 'Rufe', 'Claudia', '2004-12-31', '19 RUE PIERRE DEVOUASSOUD ', '50390', 'ORGLANDES'),
(4411, 2, 8, 'Chaquor', 'Leila', '2004-01-01', '92 AV DE SAINTE MENEHOULD ', '51000', 'CHALONS EN CHAMPAGNE'),
(4412, 3, 179, 'Mafon', 'Julio', '2003-12-30', '385 RUE DE BRE ', '51480', 'NANTEUIL-LA-FORET'),
(4413, 3, 121, 'Vique', 'Augustin', '1923-12-31', '28 CHS BOCQUAINE ', '51100', 'REIMS'),
(4414, 2, 139, 'Musur', 'Pierrette', '1982-12-29', '5056 RUE DES CHENEVIERES ', '51240', 'SAINT-JEAN-SUR-MOIVRE'),
(4415, 4, 8, 'Cuha', 'Tanguy', '1913-12-30', '30 RUE DU GENERAL COMPERE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4416, 3, 72, 'Gaidan', 'Gery', '1994-01-01', '16 RUE PIERRE BAYEN ', '51000', 'CHALONS EN CHAMPAGNE'),
(4417, 1, 143, 'Dahou', 'Yvette', '1938-12-31', '85 BD CHARLES ARNOULD ', '51100', 'REIMS'),
(4418, 2, 186, 'Jorcar', 'Marchal', '2012-12-29', '2 RUE CURIE ', '51450', 'BETHENY'),
(4419, 2, 51, 'Cretar', 'Scott', '1928-12-29', '11 AV ROGER SALENGRO ', '51430', 'TINQUEUX'),
(4420, 2, 189, 'Vasou', 'Kamal', '1983-01-01', '156 AV DU GENERAL SARRAIL ', '51000', 'CHALONS EN CHAMPAGNE'),
(4421, 2, 114, 'Vuhon', 'Jozef', '1986-01-01', '9028 VLG PERSHING ', '52000', 'CHAUMONT'),
(4422, 4, 92, 'Cace', 'Lisa', '1994-12-31', '95 AV DE SAINTE MENEHOULD ', '51000', 'CHALONS EN CHAMPAGNE'),
(4423, 1, 128, 'Fanhe', 'Rosine', '2010-12-29', '10 RUE DES FALLOISES ', '51130', 'VERTUS'),
(4424, 3, 185, 'Lavro', 'Annette', '1964-01-01', '15 RUE DU BAC ', '51300', 'VITRY LE FRANCOIS'),
(4425, 1, 51, 'Rurya', 'Johan', '1958-12-31', '9050 RUE ABRAHAM MOIVRE ', '51300', 'VITRY LE FRANCOIS'),
(4426, 2, 188, 'Tanprou', 'Claudine', '1980-01-01', '19 PL DROUET D ERLON ', '51100', 'REIMS'),
(4427, 5, 59, 'Sotri', 'Annick', '1975-12-30', '20 RUE DU RAFFARD ', '51260', 'GRANGES-SUR-AUBE'),
(4428, 5, 43, 'Krumor', 'Jacky', '1919-12-30', '4 ALL JEAN NOISIEZ ', '51110', 'WARMERIVILLE'),
(4429, 4, 85, 'Sarfran', 'Cécile', '1962-12-30', '43 ESP FLECHAMBAULT ', '51100', 'REIMS'),
(4430, 4, 157, 'Ronzan', 'Doucet', '2006-12-29', '1 ALL VICTOR GRIGNARD ', '51430', 'BEZANNES'),
(4431, 1, 30, 'Sidu', 'Artur', '1999-12-31', '41 RUE DE NEUFCHATEL ', '51100', 'REIMS'),
(4432, 4, 193, 'Nratran', 'Maryse', '1919-01-01', '129 RUE DE CERNAY ', '51100', 'REIMS'),
(4433, 4, 3, 'Lounre', 'Marianne', '1973-12-31', '22 BD WILSON ', '51310', 'ESTERNAY'),
(4434, 4, 164, 'Nrange', 'Elisabeth', '1935-01-01', '49 RUE DE CHATIVESLE ', '51100', 'REIMS'),
(4435, 2, 33, 'Lonvo', 'Michael', '1984-01-01', '13 RUE TRINITE ', '51300', 'VITRY LE FRANCOIS'),
(4436, 5, 75, 'Murha', 'Antoinette', '1907-12-31', '32 RUE D ALGER ', '51110', 'SAINT-ETIENNE-SUR-SUIPPE'),
(4437, 4, 168, 'Yursai', 'Abdallah', '1933-01-01', '28 GR GRANDE RUE ', '51520', 'SOGNY-AUX-MOULINS'),
(4438, 1, 65, 'Varar', 'Sofia', '1959-12-30', '14 RUE VILLEBOIS MAREUIL ', '51200', 'EPERNAY'),
(4439, 5, 126, 'Louve', 'Solange', '1961-12-31', '3 RUE HENRI IV ', '51100', 'REIMS'),
(4440, 4, 106, 'Hagu', 'Rachid', '1952-12-30', '81 RUE JEAN JACQUES ROUSSEAU ', '51000', 'CHALONS EN CHAMPAGNE'),
(4441, 2, 12, 'Larfar', 'Ronan', '1971-12-30', '68 ALL DE FORETS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4442, 2, 103, 'Nanpra', 'Aline', '1950-12-31', '6 RUE VICTOR ROGELET ', '51100', 'REIMS'),
(4443, 4, 194, 'Fidan', 'Frederik', '1935-12-30', '72 RUE PONSARDIN ', '51100', 'REIMS'),
(4444, 4, 167, 'Sredou', 'Martial', '1920-12-31', '43 ALL VOLTAIRE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4445, 3, 100, 'Hantra', 'Dirk', '1964-12-31', '1 RUE TOURNEBONNEAU ', '51100', 'REIMS'),
(4446, 1, 24, 'Rurlor', 'Laure', '2005-12-31', '2 RUE LAMOUCHE ', '51100', 'REIMS'),
(4447, 5, 30, 'Heprou', 'Vicky', '1994-12-30', '22 BD FRANCOIS 1ER ', '51300', 'VITRY LE FRANCOIS'),
(4448, 3, 137, 'Louya', 'Abdou', '2001-12-31', '9001 RUE ANCIENS COMBATTANTS 39 45 ', '52700', 'BOURDONS-SUR-ROGNON'),
(4449, 2, 198, 'Nila', 'Gwenaelle', '1913-12-29', '15 RUE JACQUES PREVERT ', '51100', 'REIMS'),
(4450, 2, 40, 'Tala', 'Enrico', '1950-01-01', '45 RUE PASTEUR ', '51000', 'CHALONS EN CHAMPAGNE'),
(4451, 1, 115, 'Hisur', 'David', '1968-12-30', '14 RUE DES FILLES DIEU ', '51100', 'REIMS'),
(4452, 2, 23, 'Grounru', 'Wendy', '1912-01-01', '16 RUE DE LA RUCHE ', '51200', 'EPERNAY'),
(4453, 4, 186, 'Henon', 'Ralph', '1969-12-31', '31 RTE DE REIMS ', '51450', 'BETHENY'),
(4454, 3, 125, 'Zana', 'Harold', '1943-01-01', '14 BD DIEU LUMIERE ', '51100', 'REIMS'),
(4455, 1, 115, 'Coufa', 'Paola', '1998-12-31', '35 RUE L HOPITAL AUBAN MOET ', '51200', 'EPERNAY'),
(4456, 1, 159, 'Ceno', 'Umberto', '2011-12-30', '4 PL DE L HOTEL DE VILLE ', '51100', 'REIMS'),
(4457, 2, 161, 'Moca', 'Rémi', '1912-12-30', '126 RUE GAMBETTA ', '51100', 'REIMS'),
(4458, 3, 74, 'Gurfe', 'Gwen', '1984-12-30', '1 ALL VICTOR GRIGNARD ', '51430', 'BEZANNES'),
(4459, 2, 58, 'Rudai', 'Mickael', '1926-12-30', '9003 RUE DE DIJON ', '52000', 'CHAUMONT'),
(4460, 4, 37, 'Tena', 'Hassan', '1996-12-29', '9 RUE DU COMMANDANT POTHIER ', '51200', 'EPERNAY'),
(4461, 2, 141, 'Ganvan', 'Karine', '2000-01-01', '2 RUE GOSSET ', '51100', 'REIMS'),
(4462, 5, 106, 'Vronvur', 'Carol', '1917-12-30', '21 ALL DES ACACIAS ', '51500', 'CHAMPFLEURY'),
(4463, 3, 49, 'Tanpri', 'Sylvaine', '1944-12-30', '8 IMP DES CARMELITES ', '51100', 'REIMS'),
(4464, 2, 101, 'Vanvu', 'Kay', '1989-12-30', '34 ALL DE FORETS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4465, 3, 114, 'Manfi', 'Rodolphe', '1920-12-31', '14 RUE TITON ', '51000', 'CHALONS EN CHAMPAGNE'),
(4466, 2, 115, 'Jica', 'Guilhem', '1941-12-31', '47 RUE ETIENNE OEHMICHEN ', '51000', 'CHALONS EN CHAMPAGNE'),
(4467, 3, 62, 'Douce', 'Véronique', '1993-12-30', '28 RUE LAMARTINE ', '51530', 'MARDEUIL'),
(4468, 2, 145, 'Vrete', 'Fernande', '1934-12-30', '9 RUE CHARLES LEDRU ', '51170', 'FISMES'),
(4469, 4, 191, 'Danca', 'Marcello', '1910-12-31', '19 RUE LESAGE ', '51100', 'REIMS'),
(4470, 4, 56, 'Hanai', 'Rudolf', '1936-01-01', '101 RUE LESAGE ', '51100', 'REIMS'),
(4471, 3, 111, 'Durcha', 'Jackie', '1920-12-29', '13 RUE DES VIEILLES POSTES ', '51000', 'CHALONS EN CHAMPAGNE'),
(4472, 2, 162, 'Zuhan', 'Karin', '1958-12-30', '2 BD JOFFRE ', '51100', 'REIMS'),
(4473, 1, 169, 'Jorga', 'Amaury', '1920-01-01', '5 RUE NEY ', '51140', 'HOURGES'),
(4474, 4, 176, 'Gegar', 'Henrik', '1941-12-31', '9001 LA HATE ', '52140', 'AVRECOURT'),
(4475, 5, 110, 'Turhu', 'Sarah', '2012-12-29', '16 RUE LEON JOLLY ', '51120', 'SEZANNE'),
(4476, 3, 112, 'Reha', 'Bernard', '1933-12-30', '7 RUE SAINT CLOUD ', '51600', 'SUIPPES'),
(4477, 2, 45, 'Canda', 'Eveline', '1969-12-31', '1 RUE DE LA COTE ', '51300', 'BIGNICOURT-SUR-MARNE'),
(4478, 5, 63, 'Larto', 'Mikael', '1938-12-30', '29 RUE DU GENERAL GOURAUD ', '51400', 'MOURMELON LE GRAND'),
(4479, 2, 158, 'Hango', 'Emilio', '1904-01-01', '47 RUE ETIENNE OEHMICHEN ', '51000', 'CHALONS EN CHAMPAGNE'),
(4480, 5, 98, 'Daca', 'Gloria', '1928-01-01', '9 RUE DES ACACIAS ', '51310', 'ESTERNAY'),
(4481, 5, 26, 'Hivra', 'Jamal', '1969-12-31', '75 AV JEAN JAURES ', '51100', 'REIMS'),
(4482, 1, 94, 'Grursai', 'Normand', '1913-12-31', '30 RTE DE LA CLAIRE ', '50700', 'BRIX'),
(4483, 1, 59, 'Hetor', 'Cécile', '2010-12-30', '35 BD FOCH ', '51100', 'REIMS'),
(4484, 2, 181, 'Neprar', 'Abdelhamid', '1920-01-01', '10 RUE GERARD PHILIPE ', '51100', 'REIMS'),
(4485, 1, 95, 'Faima', 'Oriane', '1941-01-01', '53 AV DE PARIS ', '51100', 'REIMS'),
(4486, 5, 8, 'Nefa', 'Siegfried', '2013-12-30', '3 ESP FLECHAMBAULT ', '51100', 'REIMS'),
(4487, 1, 162, 'Trehan', 'Sari', '1965-01-01', '7 RUE DE TALLEYRAND ', '51100', 'REIMS'),
(4488, 4, 157, 'Taca', 'Roman', '1944-12-31', '21 RUE HENRI IV ', '51100', 'REIMS'),
(4489, 5, 179, 'Naiquo', 'Girard', '1936-12-31', '39 RUE ANTOINE GOUSSIEZ ', '51100', 'REIMS'),
(4490, 2, 9, 'Crorfor', 'Gaétane', '2012-12-30', '9006 RUE DU BAC ', '51700', 'DORMANS'),
(4491, 4, 71, 'Neyu', 'Adriana', '1912-12-31', '17 RUE DES TUILERIES ', '51250', 'SERMAIZE-LES-BAINS'),
(4492, 2, 157, 'Lefou', 'Karin', '1937-12-30', '22 RUE DE LA MARNE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4493, 1, 137, 'Sanhi', 'Martine', '1921-12-30', '22 RUE GEORGES CHARPAK ', '51430', 'BEZANNES'),
(4494, 2, 94, 'Satur', 'Andrei', '1943-01-01', '10 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4495, 4, 2, 'Ludon', 'Stéfan', '1964-12-29', '3 RUE CHAUSSE COQ ', '51270', 'MONTMORT-LUCY'),
(4496, 2, 86, 'Matou', 'Isabelle', '1908-01-01', '67 RUE FAVART D HERBIGNY ', '51100', 'REIMS'),
(4497, 4, 113, 'Hortrur', 'Nikola', '1981-12-29', '21 AV HENRI FARMAN ', '51100', 'REIMS'),
(4498, 3, 102, 'Dovu', 'Maureen', '1927-12-31', '5038 DAUCOURT ', '51800', 'ELISE-DAUCOURT'),
(4499, 3, 147, 'Varnar', 'Emma', '1988-12-31', '31 RUE FANART ', '51100', 'REIMS'),
(4500, 5, 14, 'Lance', 'Ali', '2002-12-31', '26 RUE DU MARECHAL FOCH ', '51400', 'MOURMELON LE GRAND'),
(4501, 3, 1, 'Kracre', 'Bert', '1959-12-31', '95 RUE SAINT THIERRY ', '51100', 'REIMS'),
(4502, 4, 170, 'Nusa', 'Maria', '1909-12-31', '18 RUE DE GABES ', '51100', 'REIMS'),
(4503, 4, 18, 'Selai', 'Pepe', '1912-12-31', '3 RUE TOURNEBONNEAU ', '51100', 'REIMS'),
(4504, 5, 82, 'Sigo', 'Lina', '2009-12-30', '58 RUE ROBERT ', '51450', 'BETHENY'),
(4505, 3, 190, 'Truna', 'Stéphane', '1904-12-31', '43 AV DE PARIS ', '51100', 'REIMS'),
(4506, 1, 165, 'Getra', 'Marylène', '2005-12-29', '2 IMP BAUDIER ', '51800', 'ECLAIRES'),
(4507, 2, 114, 'Hutrou', 'Aude', '2001-12-29', '9 RUE JEAN MERMOZ ', '51100', 'REIMS'),
(4508, 5, 40, 'Sasre', 'Yolande', '1976-01-01', '66 RUE DU CHAMP DE MARS ', '51100', 'REIMS'),
(4509, 1, 130, 'Vurmi', 'Virgile', '1998-12-31', '22 CHE DE LA FOSSE AUX BREBIS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4510, 1, 54, 'Hadre', 'Rosa', '1915-01-01', '24 RUE DAVID ', '51100', 'REIMS'),
(4511, 3, 159, 'Yafon', 'Bénédicte', '2001-12-30', '33 PAS LEBEAU ', '51100', 'REIMS'),
(4512, 5, 192, 'Premon', 'Odile', '1990-12-31', '3 RUE DE POUILLY ', '51100', 'REIMS'),
(4513, 2, 147, 'Venan', 'Werner', '1923-12-31', '8 BD DE L\'EUROPE ', '51420', 'WITRY-LES-REIMS'),
(4514, 5, 165, 'Cartan', 'Mélanie', '1924-12-30', '1 RUE DE CHEVIGNE ', '51100', 'REIMS'),
(4515, 1, 104, 'Cofu', 'Marketta', '1954-12-30', '5 PAS DU CIMETIERE ', '51100', 'REIMS'),
(4516, 5, 53, 'Fuha', 'Michelle', '1991-12-30', '16 RUE DE VENISE ', '51100', 'REIMS'),
(4517, 2, 115, 'Retu', 'Wolfgang', '1928-12-29', '19 AV JACQUES SIMON ', '51470', 'SAINT-MEMMIE'),
(4518, 3, 38, 'Rorcan', 'Mario', '1998-01-01', '11 RUE JEAN BAPTISTE MOTTE ', '51430', 'TINQUEUX'),
(4519, 4, 76, 'Naku', 'Hamid', '1970-12-31', '9005 RUE BASSE DES COURS ', '51170', 'BASLIEUX-LES-FISMES'),
(4520, 4, 61, 'Hangra', 'Saïd', '1995-12-30', '13 RUE HENRI POINCARE ', '50580', 'PORTBAIL'),
(4521, 3, 161, 'Soukou', 'Andy', '1954-12-31', '15 PL TOULOUSE LAUTREC ', '51100', 'REIMS'),
(4522, 2, 56, 'Grouquo', 'Vlad', '1917-12-30', '5093 COULMIER OUEST ', '51240', 'LA CHAUSSEE SUR MARNE'),
(4523, 4, 105, 'Ronda', 'Felipe', '1947-12-31', '3 IMP DU BAS CHEMIN ', '52100', 'SAINT-EULIEN'),
(4524, 2, 194, 'Doja', 'Hélène', '1956-12-30', '46 AV GENERAL CHARLES DE GAULLE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4525, 4, 50, 'Mamou', 'Davy', '1938-12-30', '20 RUE DE LA HUCHETTE ', '51170', 'FISMES'),
(4526, 5, 56, 'Cralo', 'Dana', '1992-12-31', '3 RUE DE TOUSSAINT ', '51000', 'CHALONS EN CHAMPAGNE'),
(4527, 2, 187, 'Nove', 'Billy', '1989-12-31', '12 RUE GAMBETTA ', '51500', 'RILLY-LA-MONTAGNE'),
(4528, 1, 83, 'Trurho', 'Arturo', '1910-12-30', '25 RUE STE GENEVIEVE ', '51100', 'REIMS'),
(4529, 1, 68, 'Nase', 'Virginie', '1903-01-01', '14 RUE DE BECHERET ', '51260', 'ESCLAVOLLES LUREY'),
(4530, 5, 176, 'Tonse', 'Stan', '2000-01-01', '23 RUE DE L EPARGNE ', '51100', 'REIMS'),
(4531, 3, 151, 'Seso', 'Bruno', '2008-12-29', '4 RUE PAUL DOUMER ', '51350', 'CORMONTREUIL'),
(4532, 1, 67, 'Fangra', 'Abdallah', '1932-12-29', '86 RUE DES CAPUCINS ', '51100', 'REIMS'),
(4533, 3, 79, 'Krana', 'Mickaël', '1916-12-30', '16 RUE PARMENTIER ', '51000', 'CHALONS EN CHAMPAGNE'),
(4534, 5, 192, 'Hansa', 'Edwige', '1992-01-01', '16 RUE DES SORBIERS ', '51170', 'FAVEROLLES-ET-COEMY'),
(4535, 3, 27, 'Gorre', 'Chrystelle', '1967-12-31', '1 PAS FOURCHE ', '51200', 'EPERNAY'),
(4536, 2, 6, 'Tanvo', 'Romaric', '1989-12-31', '5 RUE DE L HOTEL DE VILLE ', '51120', 'SEZANNE'),
(4537, 3, 59, 'Hemar', 'Rémi', '1948-12-30', '5 RUE DU PONT LEVIS ', '51300', 'VITRY LE FRANCOIS'),
(4538, 4, 133, 'Tiprai', 'Toni', '1978-12-30', '3 RUE 16E ET 22E DRAGONS ', '51100', 'REIMS'),
(4539, 2, 37, 'Lodou', 'Mustapha', '2010-12-31', '19 RUE DES BLEUETS ', '51190', 'AVIZE'),
(4540, 3, 49, 'Foula', 'Grégory', '1980-12-31', '27 RUE D ALSACE LORRAINE ', '51100', 'REIMS'),
(4541, 3, 66, 'Canlo', 'Cindy', '1905-12-31', '9022 RUE DES AILETTES ', '51500', 'TAISSY'),
(4542, 4, 96, 'Lousa', 'Laurie', '1908-12-30', '22 RUE CUVIER ', '52000', 'CHAUMONT'),
(4543, 2, 113, 'Vonva', 'Arnaud', '1960-01-01', '7 RUE ARMONVILLE ', '51100', 'REIMS'),
(4544, 1, 190, 'Zutrou', 'Etienne', '1956-01-01', '16 RUE DU BUAT ', '51190', 'GRAUVES'),
(4545, 4, 196, 'Trate', 'Renaud', '1967-01-01', '21 RUE FRANCOIS BONAL ', '51200', 'EPERNAY'),
(4546, 3, 1, 'Lefa', 'Sonia', '1926-12-30', '10 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4547, 5, 30, 'Gane', 'Philibert', '1978-12-30', '45 AV DE RETHEL ', '51420', 'WITRY-LES-REIMS'),
(4548, 1, 94, 'Tacar', 'Bryan', '1922-01-01', '40 RUE PRIEUR DE LA MARNE ', '51100', 'REIMS'),
(4549, 3, 54, 'Tego', 'Lucy', '1919-01-01', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4550, 5, 41, 'Zotan', 'Wendy', '1987-01-01', '60 RUE DE ST BRICE ', '51100', 'REIMS'),
(4551, 3, 97, 'Gorgan', 'Lionel', '2010-12-29', '19 RUE THIERS ', '51400', 'MOURMELON LE GRAND'),
(4552, 4, 131, 'Gursrou', 'Marty', '1992-01-01', '26 ALL HENRI LHOTELAIN ', '51450', 'BETHENY'),
(4553, 1, 125, 'Cugai', 'Mélanie', '1934-12-30', '14 RUE DES FILLES DIEU ', '51100', 'REIMS'),
(4554, 1, 113, 'Jila', 'Guillemette', '2008-12-31', '30 RUE DU CHANTIER DE BATEAUX ', '51300', 'VITRY LE FRANCOIS'),
(4555, 2, 99, 'Crouhe', 'Ginette', '1982-12-30', '55 AV DU COLONEL MOLL ', '51300', 'VITRY LE FRANCOIS'),
(4556, 5, 94, 'Furgri', 'Murphy', '1905-12-31', '6121 LES HAMEAUX DE LA MER ', '50270', 'BARNEVILLE-CARTERET'),
(4557, 5, 7, 'Nanfo', 'Violaine', '1959-01-01', '32 RTE NATIONALE ', '51240', 'CHEPY'),
(4558, 5, 134, 'Hima', 'Err :502', '1989-12-31', '38 RUE DE LA BRIQUETERIE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4559, 4, 3, 'Fafai', 'Yvette', '1980-12-31', '1 RUE GERARD PHILIPE NEUV ', '51100', 'REIMS'),
(4560, 1, 1, 'Jame', 'Ingo', '1915-01-01', '10 RUE DE LA LIBERATION ', '52140', 'RANCONNIERES'),
(4561, 4, 181, 'Frucor', 'Adolphe', '1936-12-30', '44 RUE NEUVE ', '51530', 'CRAMANT'),
(4562, 2, 139, 'Trorno', 'Pauline', '1936-12-30', '20 RUE DE LA HUCHETTE ', '51170', 'FISMES'),
(4563, 2, 128, 'Carfe', 'Hector', '1921-12-30', '10 RUE DE CONTRAI ', '51100', 'REIMS'),
(4564, 2, 106, 'Soyu', 'Jennifer', '1917-12-30', '2 PL DU COMMERCE ', '51430', 'TINQUEUX'),
(4565, 3, 193, 'Tolu', 'Raoul', '1996-12-31', '35 RUE MARTIN PELLER ', '51100', 'REIMS'),
(4566, 1, 65, 'Volo', 'Joël', '2003-01-01', '95 RUE DES TANNERIES ', '52000', 'CHAUMONT'),
(4567, 1, 70, 'Nachan', 'Clarisse', '1950-12-30', '6 ALL DES ARTS ', '51420', 'CERNAY-LES-REIMS'),
(4568, 4, 98, 'Trugrar', 'Hadrien', '1953-12-30', '13 RUE VICTOR LAMBERT ', '51430', 'BEZANNES'),
(4569, 4, 166, 'Tacon', 'Marthe', '1945-12-30', '2 RUE CURIE ', '51450', 'BETHENY'),
(4570, 5, 26, 'Mece', 'Yohan', '1977-12-31', '6 ALL DU BELLAY ', '51100', 'REIMS'),
(4571, 2, 147, 'Quoman', 'Herbert', '1948-12-30', '2 RTE DE WITRY ', '51100', 'REIMS'),
(4572, 5, 178, 'Roma', 'Claudie', '2006-01-01', '24 RUE PASTEUR ', '51200', 'EPERNAY'),
(4573, 5, 9, 'Vosa', 'Ludovic', '1920-12-29', '25 ALL GUY DE MAUPASSANT ', '51100', 'REIMS'),
(4574, 3, 144, 'Hanra', 'Guylaine', '1984-01-01', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4575, 3, 200, 'Ripror', 'Marius', '1998-12-29', '22 RUE LESAGE ', '51100', 'REIMS'),
(4576, 2, 154, 'Vanrar', 'Guillermo', '1958-12-30', '13 ALL LEON MICHAUD ', '51100', 'REIMS'),
(4577, 2, 142, 'Zanca', 'Emilio', '1992-12-29', '41 RUE D ALSACE LORRAINE ', '51100', 'REIMS'),
(4578, 4, 155, 'Gaigai', 'Alexandrine', '1973-12-30', '9001 LA CHAUSSEE BRUNEHAUT ', '51170', 'FISMES'),
(4579, 1, 9, 'Seto', 'Taylor', '1902-01-01', '21 RUE DE TAHURE ', '51600', 'SOUAIN-PERTHES-LES-HURLUS'),
(4580, 2, 163, 'Chaisron', 'Casimir', '1954-01-01', '12 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4581, 5, 120, 'Nrolur', 'Rémi', '1932-12-30', '1 RTE DE PARIS ', '51700', 'TROISSY'),
(4582, 2, 121, 'Ramon', 'Gaëlle', '1969-12-31', '6 RUE VOIE DE LA VEUVE ', '51520', 'RECY'),
(4583, 3, 20, 'Rafur', 'Fatima', '1975-12-31', '485 RUE DE LA REPUBLIQUE ', '51530', 'DIZY'),
(4584, 3, 140, 'Vurmou', 'Janin', '1964-01-01', '8 ALL DES TULIPES ', '51450', 'BETHENY'),
(4585, 3, 188, 'Gosar', 'Yuri', '1903-01-01', '34 RUE ROGER SALENGRO ', '51100', 'REIMS'),
(4586, 2, 45, 'Tranfa', 'Roland', '2004-12-30', '14 RUE SAINT HILAIRE ', '51100', 'REIMS'),
(4587, 4, 108, 'Sove', 'Lucette', '1949-12-29', '54 RUE CHARLIER ', '51100', 'REIMS'),
(4588, 2, 23, 'Racra', 'Hakim', '1926-12-30', '16 RUE DE LA TOUR ', '51120', 'LA VILLENEUVE LES CHARLEVILLE'),
(4589, 4, 50, 'Foutan', 'Rose', '1998-12-30', '7 RUE EMILE ZOLA ', '51530', 'MARDEUIL'),
(4590, 2, 155, 'Vancon', 'Arnold', '1928-12-29', '143 RUE DE COURLANCY ', '51100', 'REIMS'),
(4591, 2, 95, 'Sorle', 'Nathan', '1996-12-30', '15 RUE DE LA SABLONNIERE ', '51700', 'DORMANS'),
(4592, 5, 176, 'Yeda', 'Pauline', '1947-01-01', '41 RUE DE NEUFCHATEL ', '51100', 'REIMS'),
(4593, 5, 61, 'Lovur', 'Dolores', '1928-12-30', '2 RUE SAINTE BARBE ', '51270', 'ORBAIS'),
(4594, 1, 185, 'Yalou', 'Patricio', '1979-12-30', '16 RUE D ENFER ', '51300', 'VITRY LE FRANCOIS'),
(4595, 5, 8, 'Vorgi', 'Valentine', '1915-12-30', '14 RUE DE MAGENTA ', '51200', 'EPERNAY'),
(4596, 5, 134, 'Tresa', 'Lawrence', '1979-12-30', '8 RUE MOULIN BRULE ', '51100', 'REIMS'),
(4597, 5, 118, 'Trogru', 'Andrés', '1941-12-30', '7 RUE DES CRINCENELLES ', '51530', 'CUIS'),
(4598, 1, 11, 'Hahon', 'Bruce', '1908-01-01', '3 ALL DU VEAU D OR ', '51500', 'SILLERY'),
(4599, 2, 31, 'Doulou', 'Jakub', '1944-12-31', '13 RUE RAYMOND POINCARE ', '51100', 'REIMS'),
(4600, 3, 150, 'Hecrar', 'Marjolaine', '1931-12-30', '21 RUE VICTOR HUGO ', '51500', 'LUDES'),
(4601, 4, 193, 'Cehan', 'Larry', '1982-12-31', '3 ALL GABRIEL MONIN ', '51100', 'REIMS'),
(4602, 2, 89, 'Vaiqua', 'Markus', '1926-12-29', '42 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4603, 4, 10, 'Laka', 'Lucile', '1916-01-01', '80 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4604, 2, 171, 'Lara', 'Gabriele', '1906-01-01', '6 RUE THEOPHILE GAUTIER ', '51000', 'CHALONS EN CHAMPAGNE'),
(4605, 1, 134, 'Garhou', 'Yves', '2000-12-31', '44 RUE DE LA MAISON ROUGE ', '51110', 'AUMENANCOURT'),
(4606, 1, 167, 'Reza', 'Sabine', '2000-12-30', '7 ESP LE ROUET ', '51100', 'REIMS'),
(4607, 1, 17, 'Reto', 'Jakub', '1981-12-30', '9015 ALL DES JONQUILLES ', '51450', 'BETHENY'),
(4608, 1, 19, 'Mouco', 'Alfonso', '1964-01-01', '4 BD JOFFRE ', '51100', 'REIMS'),
(4609, 5, 10, 'Vurfo', 'Lambert', '1978-12-30', '4 RUE CDT MARIN LA MESLEE ', '51100', 'REIMS'),
(4610, 1, 89, 'Vanfou', 'Matthew', '2001-12-31', '63 RUE DU GENERAL ABBE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4611, 3, 112, 'Rurman', 'Johanne', '1987-12-30', '3 RUE PASSE DEMOISELLES ', '51100', 'REIMS'),
(4612, 3, 154, 'Haiche', 'Heidi', '1917-12-31', '14 ESP REMI PELLOT ', '51100', 'REIMS'),
(4613, 2, 36, 'Ganfa', 'Federico', '2010-12-30', '37 RUE DE LA GARE ', '52100', 'SAINT-EULIEN'),
(4614, 3, 42, 'Sanya', 'Mohamed', '1911-12-30', '104 AV DE PARIS ', '51100', 'REIMS'),
(4615, 3, 30, 'Vorto', 'Florian', '1908-01-01', '51 BD DU GENERAL LECLERC ', '51100', 'REIMS'),
(4616, 4, 10, 'Honlan', 'Monika', '1933-12-29', '2 PAS FOURCHE ', '51200', 'EPERNAY'),
(4617, 3, 94, 'Krefe', 'Abraham', '2003-12-31', '2 RUE DE VILLERS ALLERAND ', '51160', 'GERMAINE'),
(4618, 4, 188, 'Grouda', 'Muriel', '1976-12-31', '1 RUE LE CULAIS ', '50390', 'ORGLANDES'),
(4619, 5, 124, 'Prifo', 'Fred', '1904-12-31', '16 RUE PRINCIPALE ', '51130', 'VILLESENEUX'),
(4620, 3, 125, 'Gesan', 'Ray', '1921-12-30', '4 GR GRANDE RUE ', '51300', 'THIEBLEMONT-FAREMONT'),
(4621, 5, 117, 'Churca', 'Eduardo', '2013-12-30', '4 RUE DE MATIGNICOURT ', '51300', 'ECRIENNES'),
(4622, 2, 132, 'Fanlou', 'Adriana', '1978-01-01', '7 HAMEAU ROSSIGNOL ', '50270', 'SAINT-JEAN-DE-LA-RIVIERE'),
(4623, 2, 6, 'Fouke', 'Flavien', '2003-12-31', '50 RUE P VAILLANT COUTURIER ', '51100', 'REIMS'),
(4624, 2, 190, 'Riga', 'Ségolène', '1966-01-01', '11 RUE DE LA POMPELLE ', '51100', 'REIMS'),
(4625, 3, 89, 'Hafa', 'Robinson', '1996-12-31', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4626, 4, 41, 'Vuva', 'Alessandro', '1921-12-30', '7 RUE BRUYANT ', '51100', 'REIMS'),
(4627, 4, 88, 'Krurce', 'Janin', '1974-12-31', '11 RUE JEAN BAPTISTE MOTTE ', '51430', 'TINQUEUX'),
(4628, 1, 175, 'Fonrur', 'Andréi', '1908-12-30', '51 RUE DU COMMERCE ', '51350', 'CORMONTREUIL'),
(4629, 2, 70, 'Ronkre', 'Ralph', '1989-01-01', '3 RUE GERBERT ', '51100', 'REIMS'),
(4630, 5, 85, 'Srocor', 'Benny', '1978-12-29', '2 RUE DE TAISSY ', '51500', 'SAINT-LEONARD'),
(4631, 1, 75, 'Chegur', 'Duncan', '1931-12-31', '11 RUE LOUIS REMY AUBERT ROCHE ', '51300', 'VITRY LE FRANCOIS'),
(4632, 1, 117, 'Maimi', 'Lucien', '1918-12-31', '4 PL SAINTE CROIX ', '51000', 'CHALONS EN CHAMPAGNE'),
(4633, 5, 88, 'Canze', 'Berthe', '2007-12-30', '4 PL HUGUES PLOMB ', '51200', 'EPERNAY'),
(4634, 3, 135, 'Hagur', 'Allan', '1944-01-01', '6 RUE DU GUE SARRAZIN ', '51360', 'PRUNAY'),
(4635, 5, 43, 'Larcra', 'Denny', '1999-01-01', '19 AV D EPERNAY ', '51100', 'REIMS'),
(4636, 2, 160, 'Gador', 'Jonathan', '1975-12-30', '16 RUE DE LA RUCHE ', '51200', 'EPERNAY'),
(4637, 3, 133, 'Hacan', 'Constance', '1978-01-01', '26 AV DES TILLEULS ', '51260', 'MARCILLY-SUR-SEINE'),
(4638, 4, 4, 'Lanpran', 'Léo', '1941-12-30', '45 RUE JACQUART ', '51100', 'REIMS'),
(4639, 4, 98, 'Gera', 'Jeannot', '1994-12-29', '3 RUE CERES ', '51100', 'REIMS'),
(4640, 4, 38, 'Tarpre', 'Lucien', '1922-12-29', '8 RUE DES CHAUFFOURS ', '51210', 'MONTMIRAIL'),
(4641, 1, 139, 'Franvor', 'Mike', '1917-12-31', '444 AV DE LAON ', '51100', 'REIMS'),
(4642, 2, 98, 'Crainu', 'Julio', '1954-12-31', '3 RUE DU CHATELET ', '51100', 'REIMS'),
(4643, 3, 97, 'Raha', 'Ludwig', '2016-12-29', '38 ALL GUY DE MAUPASSANT ', '51100', 'REIMS'),
(4644, 2, 74, 'Cantai', 'Andry', '1940-12-31', '36 RUE GUSTAVE LAURENT ', '51100', 'REIMS'),
(4645, 1, 181, 'Praron', 'Hernandez', '1911-12-31', '125 RUE DE VESLE ', '51100', 'REIMS'),
(4646, 3, 199, 'Trutran', 'Klaus', '1997-12-29', '36 RUE ROGER SALENGRO ', '51100', 'REIMS'),
(4647, 5, 125, 'Mangi', 'Julia', '1938-01-01', '65 BD HIPPOLYTE FAURE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4648, 3, 187, 'Frande', 'Christel', '1936-01-01', '28 RUE DE LA FONTAINE ', '51170', 'SERZY-ET-PRIN'),
(4649, 1, 133, 'Sasa', 'Ronan', '1913-12-30', '13 RUE DE CHAMPAGNE ', '51330', 'GIVRY-EN-ARGONNE'),
(4650, 3, 46, 'Tonho', 'Kathleen', '1937-12-29', '35 RUE CLOVIS ', '51100', 'REIMS'),
(4651, 5, 51, 'Nanro', 'Laurie', '1988-12-29', '3 RUE ERNEST DAGONET ', '51000', 'CHALONS EN CHAMPAGNE'),
(4652, 1, 17, 'Dontri', 'Hassane', '2005-12-30', '27 RUE NEUVE ', '51110', 'BOULT-SUR-SUIPPE'),
(4653, 5, 190, 'Heme', 'Mickaël', '1904-12-31', '22 RUE DE TAISSY ', '51100', 'REIMS'),
(4654, 5, 50, 'Fancar', 'Annick', '1997-12-29', '53 RUE GRANDE RUE ', '51480', 'VENTEUIL'),
(4655, 3, 172, 'Sase', 'Philip', '1960-12-30', '5 RUE SAINT LAZARE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4656, 2, 61, 'Kouvra', 'Leonardo', '1916-12-29', '5 RUE DE LA COTE ARCHEROT ', '52400', 'VOISEY'),
(4657, 3, 163, 'Jaca', 'Tania', '1912-12-29', '1 ALL VICTOR GRIGNARD ', '51430', 'BEZANNES'),
(4658, 1, 55, 'Hara', 'Pierrick', '2004-01-01', '23 RUE DU GRAND CERF ', '51100', 'REIMS'),
(4659, 1, 18, 'Durse', 'Martial', '1917-12-29', '64 AV JEAN JAURES ', '51100', 'REIMS'),
(4660, 3, 156, 'Mounrou', 'Dalila', '1943-12-30', '9 RUE DES MASSONS ', '50580', 'FIERVILLE-LES-MINES'),
(4661, 2, 194, 'Gatran', 'Aldo', '1938-12-30', '17 RUE PIERRE LAPLACE ', '51100', 'REIMS'),
(4662, 2, 125, 'Cruno', 'Luce', '1932-12-30', '126 BD ALBERT 1 ER ', '51100', 'REIMS'),
(4663, 3, 110, 'Naman', 'Nicole', '2013-12-29', '34 RUE ROGER SALENGRO ', '51100', 'REIMS'),
(4664, 2, 80, 'Tevu', 'Hanna', '2007-12-30', '1 RUE DES PLACES ', '51240', 'SAINT-GERMAIN-LA-VILLE'),
(4665, 3, 59, 'Fufe', 'Murphy', '1937-12-30', '17 RUE DE LA JUIVERIE ', '51200', 'EPERNAY'),
(4666, 1, 12, 'Haca', 'Viviana', '1904-12-31', '3 ALL EDMOND FORBOTTEAUX ', '51100', 'REIMS'),
(4667, 1, 138, 'Manva', 'Aline', '2004-12-31', '410 AV DE LAON ', '51100', 'REIMS'),
(4668, 1, 3, 'Railu', 'Leslie', '1911-12-30', '5 RUE HELENE NAUTRE ', '51100', 'REIMS'),
(4669, 2, 64, 'Rande', 'Natacha', '1916-12-30', '40 RUE ALEXANDRE HENROT ', '51100', 'REIMS'),
(4670, 4, 119, 'Ganfrur', 'Joachim', '1914-12-30', '49 RUE HONORE DE BALZAC ', '51350', 'CORMONTREUIL'),
(4671, 3, 16, 'Tantra', 'Ramon', '1926-01-01', '2 RUE DES ROISES ', '51700', 'PASSY-GRIGNY'),
(4672, 3, 12, 'Vatu', 'Doucet', '1968-12-31', '134 RUE PIERRE BROSSOLETTE ', '51100', 'REIMS'),
(4673, 2, 74, 'Lurve', 'Billy', '1945-12-30', '8 IMP DU CHATEAU ', '51390', 'JOUY-LES-REIMS'),
(4674, 2, 148, 'Lesi', 'Guilhem', '2005-12-31', '39 BD DE LA PAIX ', '51100', 'REIMS'),
(4675, 3, 162, 'Murchan', 'Jésus', '1974-01-01', '4 RUE DES VIVIERS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4676, 3, 106, 'Fatan', 'Sydney', '1990-12-31', '1 RUE EL BIAR ', '51240', 'LA CHAUSSEE SUR MARNE'),
(4677, 2, 11, 'Mohu', 'Marta', '1933-12-31', '32 RUE DES MESANGES ', '51130', 'BLANCS-COTEAUX'),
(4678, 3, 63, 'Sanmou', 'Rob', '1906-12-31', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4679, 3, 24, 'Tahan', 'Fabian', '1940-12-31', '3 PTR PETITE RUE NOTRE DAME ', '51600', 'SUIPPES'),
(4680, 1, 192, 'Finor', 'Yvan', '1915-12-30', '66 RUE JACQUART ', '51100', 'REIMS'),
(4681, 4, 52, 'Larman', 'Solange', '2011-12-31', '3 RUE DE SEZANNE ', '51200', 'EPERNAY'),
(4682, 5, 180, 'Trorja', 'Nico', '1956-12-30', '4 BD JOFFRE ', '51100', 'REIMS'),
(4683, 2, 58, 'Fayor', 'Frederik', '1974-12-30', '4 RUE DU COMMANDANT LAMY ', '51100', 'REIMS'),
(4684, 3, 123, 'Sesa', 'Edith', '1962-01-01', '26 BD PASTEUR ', '51100', 'REIMS'),
(4685, 2, 80, 'Drami', 'Laetitia', '1983-01-01', '9 RUE DES ELUS ', '51100', 'REIMS'),
(4686, 4, 1, 'Fovou', 'Marthe', '1917-01-01', '9001 RUE JULES ROMAINS ', '51350', 'CORMONTREUIL'),
(4687, 3, 70, 'Marse', 'Luc', '1906-12-31', '64 AV JEAN JAURES ', '51100', 'REIMS'),
(4688, 2, 107, 'Caro', 'Fanny', '1910-12-30', '24 RUE ERNEST RENAN ', '51100', 'REIMS'),
(4689, 3, 55, 'Tetran', 'Tom', '1962-12-30', '13 RUE CHABAUD ', '51100', 'REIMS'),
(4690, 3, 43, 'Vatu', 'Romaric', '1942-12-30', '2 RUE DE MACON ', '51100', 'REIMS'),
(4691, 4, 171, 'Harmai', 'Alan', '1917-12-29', '131 BD POMMERY ', '51100', 'REIMS'),
(4692, 4, 159, 'Lorson', 'Cyrille', '1991-01-01', '27 RUE BOUCHER DE PERTHES ', '51100', 'REIMS'),
(4693, 1, 110, 'Nuvan', 'Mickael', '1983-12-31', '1 RUE SCULPTEURS JACQUES ', '51100', 'REIMS'),
(4694, 3, 189, 'Dannan', 'Jacqueline', '1968-12-31', '49 BD DU GENERAL LECLERC ', '51100', 'REIMS'),
(4695, 2, 65, 'Caiva', 'Jessie', '1968-12-31', '126 BD ALBERT 1 ER ', '51100', 'REIMS'),
(4696, 3, 50, 'Cagrou', 'Luc', '1987-12-31', '123 RUE DU BARBATRE ', '51100', 'REIMS'),
(4697, 4, 22, 'Gonlan', 'Natalie', '1999-01-01', '6 RUE DE L ETANG DU MOULIN ', '51120', 'LA FORESTIERE'),
(4698, 4, 170, 'Dolon', 'Henry', '1940-01-01', '40 RUE DE ST BRICE ', '51100', 'REIMS'),
(4699, 1, 104, 'Seprou', 'Germain', '1961-12-31', '27 RUE LEOPOLD CHARPENTIER ', '51100', 'REIMS'),
(4700, 4, 157, 'Tredo', 'Gregor', '1955-12-31', '16 RUE PIERRE DE COUBERTIN ', '51100', 'REIMS'),
(4701, 1, 124, 'Ritur', 'Monika', '1971-12-30', '61 RUE P VAILLANT COUTURIER ', '51100', 'REIMS'),
(4702, 4, 13, 'Prame', 'Err :502', '1921-12-30', '5007 LE VILLAGE ', '51800', 'GRATREUIL'),
(4703, 4, 141, 'Cotan', 'Graeme', '1986-12-31', '39 IMP ROUGE COQ ', '51120', 'LE MEIX SAINT EPOING'),
(4704, 2, 128, 'Furfor', 'Boris', '1948-12-30', '110 RUE DES ROMAINS ', '51100', 'REIMS'),
(4705, 1, 156, 'Marta', 'Sylvia', '1983-12-31', '20 RUE DU HUIT MAI ', '51700', 'MAREUIL-LE-PORT'),
(4706, 3, 108, 'Laya', 'Régina', '2010-12-30', '410 AV DE LAON ', '51100', 'REIMS'),
(4707, 4, 92, 'Naci', 'Alfredo', '1919-01-01', '275 AV DE LAON ', '51100', 'REIMS'),
(4708, 4, 65, 'Mate', 'Samira', '1967-12-30', '1 RUE DU LIMOUSIN ', '51200', 'EPERNAY'),
(4709, 2, 131, 'Nanlan', 'Juliette', '2013-12-29', '10 CHE DE HAUT ', '51240', 'SONGY'),
(4710, 1, 118, 'Diquai', 'Liza', '1926-01-01', '95 RUE GEORGES CHARPAK ', '51430', 'BEZANNES'),
(4711, 5, 70, 'Lounon', 'Lisa', '1992-12-30', '11 RUE JEAN BAPTISTE MOTTE ', '51430', 'TINQUEUX'),
(4712, 1, 131, 'Cagre', 'Louisa', '1919-12-30', '4 RUE DE L EGLISE ', '50700', 'VALOGNES'),
(4713, 1, 182, 'Lorhor', 'Nikos', '1961-12-29', '12 RUE D AUNIS ', '51350', 'CORMONTREUIL'),
(4714, 3, 85, 'Fonnai', 'Maxime', '1936-01-01', '1 RUE DU PUITS ', '51210', 'RIEUX'),
(4715, 2, 182, 'Srazar', 'Jenny', '1946-12-31', '35 RUE DURUY ', '51100', 'REIMS'),
(4716, 2, 30, 'Danrai', 'Fabrizio', '1922-01-01', '13 RUE DU VIEUX MOULIN ', '51210', 'LE BREUIL'),
(4717, 2, 10, 'Morve', 'Gerhard', '1940-12-29', '15 ALL DU BOIS ', '51500', 'VILLE-EN-SELVE'),
(4718, 5, 85, 'Prumou', 'Marketta', '1992-12-31', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4719, 4, 31, 'Tarvran', 'Greg', '1957-12-30', '29 GR GRANDE RUE ', '51430', 'BEZANNES'),
(4720, 3, 172, 'Kroutou', 'Patrick', '1986-12-31', '9002 RTE DE CHALONS ', '51800', 'SAINTE MENEHOULD'),
(4721, 5, 117, 'Temar', 'Pedro', '1923-12-30', '2 RUE DES ECOLES ', '51390', 'GUEUX'),
(4722, 3, 127, 'Gagon', 'Rémi', '1953-12-30', '9001 RUE PONSARDIN ', '51100', 'REIMS'),
(4723, 1, 16, 'Horlor', 'Olga', '1940-12-31', '42 RUE M CLEMENCE FOURIAUX ', '51100', 'REIMS'),
(4724, 5, 114, 'Herar', 'Xavier', '1983-12-31', '16 RUE DE LA RUCHE ', '51200', 'EPERNAY'),
(4725, 1, 91, 'Chesou', 'Pamela', '1939-12-30', '12 RUE FERRAND DE MONTHELON ', '51100', 'REIMS'),
(4726, 3, 64, 'Darma', 'Sylvine', '1910-12-30', '13 RUE TOURNEBONNEAU ', '51100', 'REIMS'),
(4727, 2, 45, 'Kaisi', 'Keith', '1909-12-30', '30 GR GRANDE RUE ', '51520', 'SARRY'),
(4728, 5, 200, 'Rouquou', 'Mitch', '1915-12-31', '13 RUE DE LYON ', '51100', 'REIMS'),
(4729, 3, 99, 'Matu', 'Maryse', '1932-12-31', '14 RUE DE BRETAGNE ', '51200', 'EPERNAY'),
(4730, 3, 166, 'Tegu', 'Mark', '1952-01-01', '33 RUE GABRIEL VAILLANT ', '51310', 'LA NOUE'),
(4731, 5, 174, 'Cheror', 'Cristina', '1997-12-31', '19 RUE LESAGE ', '51100', 'REIMS'),
(4732, 1, 44, 'Travon', 'Olivia', '1926-01-01', '15 RUE PIERRE DE COUBERTIN ', '51100', 'REIMS'),
(4733, 1, 152, 'Chicur', 'Tomas', '2004-12-29', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4734, 5, 95, 'Chando', 'Lawrence', '1981-12-31', '2 AV DES SORBIERS ', '51350', 'CORMONTREUIL'),
(4735, 4, 162, 'Gurdai', 'Aurélie', '1910-01-01', '86 BD ST MARCEAUX ', '51100', 'REIMS'),
(4736, 3, 7, 'Yita', 'Jacqueline', '1952-12-29', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4737, 3, 101, 'Gurse', 'Andy', '1916-01-01', '2 RUE DES MADERIAUX ', '51310', 'LES ESSARTS LE VICOMTE'),
(4738, 2, 123, 'Runo', 'Juan', '1915-12-31', '410 AV DE LAON ', '51100', 'REIMS'),
(4739, 1, 168, 'Conrou', 'Mounir', '1915-12-31', '6 RUE DE LA TENE ', '51360', 'VAL-DE-VESLE'),
(4740, 1, 67, 'Mouco', 'Amanda', '1912-12-31', '1 RUE 16E ET 22E DRAGONS ', '51100', 'REIMS'),
(4741, 2, 159, 'Lega', 'Riccardo', '1914-12-31', '7 IMP DES CARMELITES ', '51100', 'REIMS'),
(4742, 4, 91, 'Fondai', 'Maurizio', '1989-12-29', '34 RUE DES PETITS AYEUX ', '51460', 'COURTISOLS'),
(4743, 4, 132, 'Rasu', 'Kamel', '1964-12-31', '28 CHS BOCQUAINE ', '51100', 'REIMS'),
(4744, 3, 182, 'Somai', 'Guylaine', '1934-01-01', '5 RUE PAUL LAPIE ', '51100', 'REIMS'),
(4745, 2, 173, 'Gufan', 'Quentin', '1908-12-30', '18 RUE RUINART DE BRIMONT ', '51100', 'REIMS'),
(4746, 5, 194, 'Quarcu', 'Maria', '1904-12-31', '11 RUE LAMOUCHE ', '51100', 'REIMS'),
(4747, 3, 120, 'Lere', 'Jessie', '2008-12-29', '9002 ALL DE MAXENU ', '51530', 'PIERRY'),
(4748, 3, 167, 'Tretra', 'Patricio', '2012-12-30', '32 RUE PAUL FORT ', '51000', 'CHALONS EN CHAMPAGNE'),
(4749, 3, 98, 'Saivan', 'Félix', '1967-12-30', '110 RUE DES CAPUCINS ', '51100', 'REIMS'),
(4750, 1, 34, 'Vechor', 'Mauricette', '1972-12-31', '46 RUE DE MARS ', '51100', 'REIMS'),
(4751, 4, 77, 'Dancu', 'Reinhard', '1917-12-31', '5 RUE DU VIEUX CHATEAU ', '52500', 'GENEVRIERES'),
(4752, 5, 58, 'Honror', 'Yvon ', '1995-12-30', '8 RUE DU CHATEAU ', '51210', 'LE THOULT TROSNAY'),
(4753, 3, 21, 'Prarcu', 'Claudio', '1939-12-30', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4754, 5, 187, 'Tancar', 'Patrick', '1987-01-01', '16 RUE CLOVIS ', '51100', 'REIMS'),
(4755, 4, 137, 'Narlan', 'Gaston', '1995-12-30', '4 ALL DE ROUERGUE ', '51200', 'EPERNAY'),
(4756, 1, 18, 'Lecon', 'Evelyne', '1919-12-30', '28 RUE DES SORANGES ', '51220', 'HERMONVILLE'),
(4757, 3, 180, 'Drorar', 'Doucet', '1984-12-30', '48 RUE DE LA JUSTICE ', '51100', 'REIMS'),
(4758, 4, 139, 'Jegu', 'Michelle', '1984-12-31', '60 RUE CLOVIS CHEZEL ', '51100', 'REIMS'),
(4759, 2, 132, 'Vara', 'Ronan', '1997-12-31', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4760, 3, 87, 'Fruve', 'Tang', '1976-12-31', '2 IMP BAUDIER ', '51800', 'ECLAIRES'),
(4761, 5, 113, 'Hepran', 'Pamela', '1957-12-31', '2 RUE DUQUENELLE ', '51100', 'REIMS'),
(4762, 3, 37, 'Moular', 'Ralf', '1976-12-31', '14 RUE GRANDE RUE ', '51600', 'SAINT-HILAIRE-LE-GRAND'),
(4763, 3, 197, 'Luda', 'Thomas', '1947-12-31', '10 RUE DU GENERAL GOURAUD ', '51400', 'MOURMELON LE GRAND'),
(4764, 2, 167, 'Huro', 'Abdelhamid', '1956-12-30', '26 RUE PASTEUR ', '51200', 'EPERNAY'),
(4765, 4, 82, 'Dude', 'Gilberte', '2001-12-31', '23 RUE DE LA PAIX ', '51420', 'WITRY-LES-REIMS'),
(4766, 2, 12, 'Naro', 'Juergen', '1931-12-31', '1 RUE DU CHAMP LA CHEVRE ', '52000', 'CHAUMONT'),
(4767, 1, 133, 'Quutra', 'Christiane', '1938-12-30', '34 RUE LEON BOURGEOIS ', '51310', 'ESTERNAY'),
(4768, 1, 167, 'Honmor', 'Ramon', '1943-12-31', '154 RTE DE WITRY ', '51100', 'REIMS'),
(4769, 3, 85, 'Dane', 'Mac', '1923-12-30', '31 RUE DES BOUCHERS ', '51420', 'WITRY-LES-REIMS'),
(4770, 2, 82, 'Quudre', 'Rolf', '1947-12-31', '4 RUE THOMAS MARTIN ', '51000', 'CHALONS EN CHAMPAGNE');
INSERT INTO `patient` (`idPat`, `idMut`, `idMed`, `nomPat`, `pnomPat`, `dateNais`, `adPat`, `CPPat`, `villePat`) VALUES
(4771, 5, 135, 'Danra', 'Omar', '1986-01-01', '9001 RUE CAPORAL CHEF DIVRY ', '51100', 'REIMS'),
(4772, 4, 162, 'Datra', 'Frank', '1918-12-30', '136 RUE DES CAPUCINS ', '51100', 'REIMS'),
(4773, 1, 105, 'Dicha', 'Karima', '1992-12-31', '12 RUE DE LOUVOIS ', '51150', 'BOUZY'),
(4774, 4, 109, 'Cruda', 'Konstantinos', '1991-12-30', '2 RUE DE MACON ', '51100', 'REIMS'),
(4775, 3, 84, 'Rage', 'Lawrence', '1949-12-31', '40 RUE DE CHEVIGNE ', '51100', 'REIMS'),
(4776, 3, 31, 'Fougai', 'Gauthier', '1991-12-30', '18 RUE DES 3 PILIERS ', '51100', 'REIMS'),
(4777, 2, 172, 'Dougo', 'Tarik', '1948-12-29', '14 RUE DES GOBELINS ', '51100', 'REIMS'),
(4778, 3, 146, 'Nrarme', 'Louise', '1936-12-30', '7 RUE PAVEE ', '51300', 'VITRY LE FRANCOIS'),
(4779, 4, 184, 'Quutor', 'Rachel', '1948-01-01', '76 BD CHARLES ARNOULD ', '51100', 'REIMS'),
(4780, 4, 21, 'Hadu', 'Yvette', '1964-12-29', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4781, 1, 36, 'Monmar', 'Farid', '1991-12-30', '2 RUE PAUL LANGEVIN ', '51350', 'CORMONTREUIL'),
(4782, 2, 9, 'Yantre', 'Jérôme', '1930-12-31', '16 RUE WERLE ', '51100', 'REIMS'),
(4783, 2, 52, 'Vanhe', 'Neil', '1994-12-30', '11 RUE DE PARIS ', '51120', 'SEZANNE'),
(4784, 3, 135, 'Forcra', 'Ines', '2010-12-29', '17 RUE PASTEUR ', '51310', 'ESTERNAY'),
(4785, 5, 70, 'Nazou', 'Lucien', '1997-12-29', '37 BD DOCTEUR HENRI HENROT ', '51100', 'REIMS'),
(4786, 2, 165, 'Hurha', 'Pascaline', '1960-01-01', '153 AV DE LAON ', '51100', 'REIMS'),
(4787, 2, 23, 'Raido', 'Irina', '1944-12-31', '1 RUE DES JONCS ', '51200', 'EPERNAY'),
(4788, 3, 182, 'Renur', 'Andréas', '1978-12-30', '2 AV D EPERNAY ', '51100', 'REIMS'),
(4789, 1, 89, 'Sacar', 'Eugène', '1913-12-31', '2 RUE DES JACOBINS ', '51100', 'REIMS'),
(4790, 5, 31, 'Gante', 'Francesco', '1947-12-30', '19 RUE FRERES ARNOULD ', '51100', 'REIMS'),
(4791, 3, 49, 'Tonnran', 'Frédérick', '1991-01-01', '5021 LA VOIE DE LAVAL ', '51600', 'SAINT-JEAN-SUR-TOURBE'),
(4792, 1, 197, 'Turzo', 'Benoît', '1992-01-01', '78 LE BOIS DES FILLES ', '51210', 'BOISSY-LE-REPOS'),
(4793, 5, 172, 'Nadai', 'Françoise', '1916-01-01', '6 RUE THEODORE GERICAULT ', '51100', 'REIMS'),
(4794, 5, 112, 'Frango', 'Youri', '1962-12-31', '2 IMP DES CITES ', '51300', 'COUVROT'),
(4795, 5, 110, 'Fehor', 'Ann', '1917-12-29', '12 RUE DU DOCTEUR MAILLOT ', '51000', 'CHALONS EN CHAMPAGNE'),
(4796, 5, 109, 'Lihou', 'Audrey', '1961-12-30', '13 RUE DU LYCEE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4797, 5, 121, 'Sacan', 'Viktor', '1992-12-30', '8 BD JOFFRE ', '51100', 'REIMS'),
(4798, 5, 102, 'Lunur', 'Yannick', '1966-12-30', '21 RUE DE WITRY ', '51100', 'REIMS'),
(4799, 3, 52, 'Nornru', 'Aubert', '2004-12-29', '3 RUE DU GRAND MAU ', '51470', 'SAINT-MEMMIE'),
(4800, 1, 135, 'Vojou', 'Graeme', '1956-12-30', '18 RUE DES 3 PILIERS ', '51100', 'REIMS'),
(4801, 1, 139, 'Cantra', 'Stphane', '1962-12-31', '23 AV GABRIEL PERI ', '51430', 'TINQUEUX'),
(4802, 3, 76, 'Trifur', 'Ali', '1975-12-30', '39 LA VOIE SAINT MARTIN ', '51130', 'VAL-DES-MARAIS'),
(4803, 3, 150, 'Seyo', 'Annick', '1945-12-30', '6 RUE ANDRE FAIVRE ', '51100', 'REIMS'),
(4804, 1, 117, 'Pranar', 'Casimir', '2001-12-29', '46 RUE DE LA BRIQUETERIE ', '51100', 'REIMS'),
(4805, 4, 152, 'Sehe', 'Tarek', '1965-01-01', '4 RUE DES MOISSONS ', '51100', 'REIMS'),
(4806, 1, 85, 'Vore', 'Damien', '1946-12-31', '44 RTE DE MARSON ', '51470', 'MONCETZ-LONGEVAS'),
(4807, 4, 151, 'Lakro', 'Carmen', '1988-12-30', '9007 RLE DES REMPARTS ', '51210', 'MONTMIRAIL'),
(4808, 1, 151, 'Gonon', 'Harry', '1969-12-29', '8 RUE DE LA FAUVETTE ', '51200', 'EPERNAY'),
(4809, 1, 94, 'Nrame', 'Carla', '1932-12-31', '5 PL DU 13EME REGIMENT DE GENIE ', '51200', 'EPERNAY'),
(4810, 4, 53, 'Haci', 'Marcelle', '1986-12-30', '32 RUE GERUZEZ ', '51100', 'REIMS'),
(4811, 3, 128, 'Rortor', 'Joerg', '1928-12-29', '2 ALL RENE FONCK ', '51450', 'BETHENY'),
(4812, 3, 37, 'Prurta', 'Luciano', '1972-01-01', '101 RUE SAINT THIERRY ', '51100', 'REIMS'),
(4813, 1, 15, 'Franfe', 'Franco', '1944-01-01', '6 RUE DES MEULIERES ', '51530', 'SAINT-MARTIN-D\'ABLOIS'),
(4814, 4, 148, 'Tanfrou', 'Carolyn', '1988-12-31', '1 RUE JEAN LE LOUP ', '51100', 'REIMS'),
(4815, 1, 80, 'Hofai', 'Edwige', '1960-12-29', '1 SQ DE VESLE ', '51140', 'JONCHERY-SUR-VESLE'),
(4816, 5, 42, 'Gainan', 'Sandra', '1971-12-31', '162 AV JEAN JAURES ', '51100', 'REIMS'),
(4817, 3, 156, 'Husar', 'Denise', '1933-12-31', '249 RUE DE COURLANCY ', '51100', 'REIMS'),
(4818, 3, 123, 'Housa', 'Emily', '1974-01-01', '58 RUE DE LONGJUMEAU ', '51500', 'TAISSY'),
(4819, 1, 103, 'Dahar', 'France', '1929-12-31', '36 AV HOCHE ', '51100', 'REIMS'),
(4820, 4, 181, 'Vartru', 'Estelle', '1922-12-31', '5 RUE D ARCIS LE PONSART ', '51170', 'COURVILLE'),
(4821, 1, 158, 'Danna', 'Pamela', '1988-12-31', '13 RUE PERSON ', '51300', 'VITRY LE FRANCOIS'),
(4822, 3, 2, 'Danjor', 'Pamela', '1996-12-31', '11 RUE GUTENBERG ', '51370', 'SAINT BRICE COURCELLES'),
(4823, 2, 147, 'Kradan', 'Maryvonne', '1923-12-31', '5 IMP DU CHENOIS ', '51450', 'BETHENY'),
(4824, 2, 133, 'Vasra', 'Magali', '1937-12-31', '27 BD DE LA PAIX ', '51100', 'REIMS'),
(4825, 2, 175, 'Cradan', 'Alexandre', '1919-12-31', '19 RUE D AVIGNON ', '51100', 'REIMS'),
(4826, 3, 116, 'Norprou', 'Berthe', '1984-12-30', '7 RUE BURIDAN ', '51100', 'REIMS'),
(4827, 1, 2, 'Hacra', 'Petrovic', '1931-01-01', '15 RUE WACHTER ', '51450', 'BETHENY'),
(4828, 5, 177, 'Fulu', 'Sofia', '1948-12-29', '40 RUE DE ST BRICE ', '51100', 'REIMS'),
(4829, 1, 52, 'Grerai', 'Franz', '1934-12-31', '24 RUE GALLIEN ', '50760', 'VALCANVILLE'),
(4830, 5, 99, 'Srorne', 'Konstantinos', '1999-12-30', '44 RUE DU GENERAL LECLERC ', '51130', 'BLANCS-COTEAUX'),
(4831, 3, 23, 'Craisa', 'Johann', '1969-12-30', '104 RUE PONSARDIN ', '51100', 'REIMS'),
(4832, 4, 158, 'Hudran', 'Madeleine', '1977-12-29', '18 AV JEAN JAURES ', '51100', 'REIMS'),
(4833, 3, 41, 'Vranrur', 'Tang', '1964-12-31', '2 RUE JOSEPH JACQUET ', '51100', 'REIMS'),
(4834, 4, 35, 'Dudra', 'Olivia', '2000-12-30', '51 AV JEANNE D ARC ', '51000', 'CHALONS EN CHAMPAGNE'),
(4835, 2, 18, 'Quanvo', 'Gwen', '1910-12-31', '15 RUE DU GENERAL ABBE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4836, 4, 175, 'Tanvor', 'Hervé', '1960-12-30', '17 RUE PIERRE REVERDY ', '51350', 'CORMONTREUIL'),
(4837, 5, 105, 'Vese', 'Gwen', '1981-12-30', '19 RUE SORBON ', '51370', 'SAINT BRICE COURCELLES'),
(4838, 4, 56, 'Mordri', 'Cristian', '1992-01-01', '9001 RUE CAPORAL CHEF DIVRY ', '51100', 'REIMS'),
(4839, 3, 102, 'Manye', 'Girard', '1970-12-30', '9 RUE REIMBEAU ', '51100', 'REIMS'),
(4840, 4, 190, 'Courai', 'Dieudonné', '1988-12-30', '4 RUE DE L ARGILIENNE ', '51340', 'PARGNY-SUR-SAULX'),
(4841, 2, 200, 'Gato', 'Bryan', '1958-12-29', '20 AV ALEXANDRE DE SERBIE ', '51100', 'REIMS'),
(4842, 2, 16, 'Rarfa', 'Tim', '1908-12-31', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4843, 5, 122, 'Dankran', 'Ginette', '1901-01-01', '9 RUE DE JERICHO ', '51000', 'CHALONS EN CHAMPAGNE'),
(4844, 1, 87, 'Gesa', 'Huber', '1945-12-30', '3 RUE DU FBG D ARNOTAY ', '51480', 'VENTEUIL'),
(4845, 5, 153, 'Fanu', 'Stephen', '1967-01-01', '11 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4846, 3, 72, 'Cesa', 'Louise', '1907-12-31', '33 GR GRANDE RUE ', '51260', 'SARON-SUR-AUBE'),
(4847, 3, 123, 'Lana', 'Joan', '1952-12-30', '9 RUE DE REIMS ', '51200', 'EPERNAY'),
(4848, 3, 165, 'Ratur', 'Jeannot', '1932-12-30', '60 PL DROUET D ERLON ', '51100', 'REIMS'),
(4849, 5, 159, 'Mornou', 'Yvain', '1943-12-30', '11 RUE MAXIME CUISINIER ', '51100', 'REIMS'),
(4850, 2, 70, 'Loutor', 'Priscilla', '1916-12-31', '2 RUE GOSSET ', '51100', 'REIMS'),
(4851, 5, 125, 'Lurdo', 'Armin', '1968-12-30', '13 RUE IGOR STRAVINSKI ', '51100', 'REIMS'),
(4852, 1, 17, 'Feha', 'Otto', '1963-12-30', '7 RUE DE LA MAIRIE ', '51260', 'GRANGES-SUR-AUBE'),
(4853, 1, 29, 'Gapru', 'Kamal', '1932-12-29', '1 ALL VICTOR GRIGNARD ', '51430', 'BEZANNES'),
(4854, 1, 155, 'Lodur', 'Marcos', '1994-12-29', '80 RUE LEON BOURGEOIS ', '51420', 'NOGENT-L ABBESSE'),
(4855, 5, 152, 'Tivra', 'Ahmad', '2014-12-30', '57 RUE DU GENERAL LECLERC ', '51510', 'FAGNIERES'),
(4856, 2, 39, 'Yiho', 'Mélanie', '1999-12-31', '179 AV JEAN JAURES ', '51100', 'REIMS'),
(4857, 4, 61, 'Nuvou', 'Bénédicte', '1927-12-30', '2 MONTBLERU HAMEAU ', '51310', 'NEUVY'),
(4858, 4, 85, 'Nouya', 'Frank', '1960-01-01', '9001 RUE CAPORAL CHEF DIVRY ', '51100', 'REIMS'),
(4859, 2, 63, 'Tante', 'Rita', '1990-01-01', '10 ALL DU MONT AIGU ', '51160', 'AVENAY-VAL-D\'OR'),
(4860, 3, 2, 'Dezon', 'Laurence', '1972-01-01', '28 RUE GAMBETTA ', '51100', 'REIMS'),
(4861, 5, 186, 'Vela', 'Dan', '1974-01-01', '29 RUE D ALGER ', '51100', 'REIMS'),
(4862, 1, 124, 'Rana', 'Jocelyne', '1960-12-29', '56 RUE HINCMAR ', '51100', 'REIMS'),
(4863, 5, 110, 'Vatror', 'Philippon', '1936-01-01', '4 RUE PAUL DOUMER ', '51350', 'CORMONTREUIL'),
(4864, 5, 111, 'Nrana', 'Philippe', '1930-12-31', '45 RUE VICTOR HUGO ', '51530', 'MARDEUIL'),
(4865, 2, 163, 'Grunan', 'Augustine', '2002-12-31', '13 RUE BERTRAND DE MUN ', '51100', 'REIMS'),
(4866, 1, 121, 'Leta', 'Peggy', '1933-12-31', '69 RUE MARCEL THIL ', '51100', 'REIMS'),
(4867, 2, 12, 'Yonan', 'Miguel', '1960-01-01', '42 RUE ANATOLE FRANCE ', '51260', 'SAINT-JUST-SAUVAGE'),
(4868, 1, 137, 'Tira', 'Gabriel', '1973-12-30', '121 RUE DE LA CHEPPE ', '51460', 'COURTISOLS'),
(4869, 5, 99, 'Mefi', 'Yvette', '1901-01-01', '30 RUE DE LA SEINE MARITIME ', '51100', 'REIMS'),
(4870, 2, 95, 'Tanquan', 'Eddie', '1956-12-29', '27 RUE M CLEMENCE FOURIAUX ', '51100', 'REIMS'),
(4871, 1, 88, 'Zorkran', 'Phil', '1925-12-30', '37 RUE MAXIME DAVID ', '51000', 'CHALONS EN CHAMPAGNE'),
(4872, 2, 26, 'Frursan', 'Adrien', '1935-12-31', '8 CHE DU DESERT ', '51300', 'VITRY LE FRANCOIS'),
(4873, 2, 16, 'Dute', 'Saïd', '1957-12-30', '9001 RUE DIDEROT ', '51100', 'REIMS'),
(4874, 3, 29, 'Guvor', 'Micheline', '1968-01-01', '6 RUE WILLIAM MUIR RUSSEL ', '51170', 'COURVILLE'),
(4875, 1, 70, 'Gasu', 'Charlotte', '1960-12-31', '49 RUE LESAGE ', '51100', 'REIMS'),
(4876, 1, 182, 'Feva', 'Rosa', '2007-01-01', '1 RUE DE LA GRENOUILLERE ', '51230', 'CONNANTRE'),
(4877, 3, 168, 'Sanho', 'Baudouin', '1934-12-31', '30 AVE J JAURES CTE LABESSE ', '51120', 'SEZANNE'),
(4878, 4, 91, 'Vehu', 'Tarek', '2008-01-01', '4 RUE DOM PERIGNON ', '51200', 'EPERNAY'),
(4879, 4, 143, 'Krevor', 'Frederik', '1955-12-30', '9001 RUE PIERRE TAITTINGER ', '51100', 'REIMS'),
(4880, 1, 90, 'Durnar', 'Sylvia', '1972-12-31', '33 BD HIPPOLYTE FAURE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4881, 5, 171, 'Vanno', 'Gerhard', '1943-12-30', '102 RUE CHARLIER ', '51100', 'REIMS'),
(4882, 2, 155, 'Daro', 'Jeanine', '1973-12-31', '24 RUE DU JOLY ', '50480', 'SAINTE-MARIE-DU-MONT'),
(4883, 3, 10, 'Falou', 'Petr', '1938-12-31', '21 RUE BUIRETTE ', '51100', 'REIMS'),
(4884, 2, 45, 'Taze', 'Gilberto', '1956-01-01', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4885, 1, 38, 'Nrurmai', 'Yvette', '1912-12-29', '42 RUE M CLEMENCE FOURIAUX ', '51100', 'REIMS'),
(4886, 1, 101, 'Turca', 'Neil', '1984-01-01', '29 RUE D ALSACE LORRAINE ', '51100', 'REIMS'),
(4887, 4, 59, 'Cusan', 'Ségolène', '1933-12-30', '7 IMP CHOILLI ', '51110', 'WARMERIVILLE'),
(4888, 4, 107, 'Franvro', 'Paolo', '1948-12-29', '65 RUE DE COURCELLES ', '51100', 'REIMS'),
(4889, 4, 131, 'Turcan', 'Cameron', '1975-01-01', '40 ALL VOLTAIRE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4890, 5, 199, 'Coupro', 'Peters', '1949-12-30', '55 AV DU COLONEL MOLL ', '51300', 'VITRY LE FRANCOIS'),
(4891, 1, 163, 'Vafur', 'Stuart', '1904-01-01', '4 RTE DE BUSSY ', '51600', 'SUIPPES'),
(4892, 1, 138, 'Mafan', 'Marty', '1914-12-31', '2 RUE DU HAN ', '51300', 'MAISONS-EN-CHAMPAGNE'),
(4893, 1, 59, 'Larar', 'Maryvonne', '1962-12-31', '6 RUE JEAN DE LA FONTAINE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4894, 3, 113, 'Vagon', 'Myriam', '1973-12-30', '183 AV DE LAON ', '51100', 'REIMS'),
(4895, 1, 164, 'Rancu', 'David', '1968-12-30', '5 RUE DU MARECHAL TITO ', '51000', 'CHALONS EN CHAMPAGNE'),
(4896, 3, 169, 'Granda', 'Dariusz', '1957-01-01', '25 RUE DES ELUS ', '51100', 'REIMS'),
(4897, 3, 190, 'Sorqua', 'Mauricette', '1929-12-30', '9001 RUE CAPORAL CHEF DIVRY ', '51100', 'REIMS'),
(4898, 5, 186, 'Yondou', 'Jack', '1985-12-29', '9001 RUE ANDRE FAIVRE ', '51100', 'REIMS'),
(4899, 3, 82, 'Lantan', 'Igor', '1933-12-30', '11 AV DE FRANCHE COMTE ', '51200', 'EPERNAY'),
(4900, 1, 163, 'Larva', 'Carine', '1924-12-30', '5 RUE DES MESANGES ', '51000', 'CHALONS EN CHAMPAGNE'),
(4901, 2, 16, 'Zouro', 'Gloria', '2011-12-30', '60 AV DES ALLIES ', '51000', 'CHALONS EN CHAMPAGNE'),
(4902, 2, 157, 'Cagrou', 'Jones', '1909-12-30', '12 RUE MARIE STUART ', '51100', 'REIMS'),
(4903, 1, 83, 'Cusa', 'Patricia', '1915-01-01', '29 RUE D ALGER ', '51100', 'REIMS'),
(4904, 5, 139, 'Quude', 'Rita', '1968-01-01', '22 RUE DES ROMAINS ', '51100', 'REIMS'),
(4905, 2, 20, 'Totan', 'Josiane', '1914-12-30', '5 RUE DU MONT LAMPAS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4906, 2, 127, 'Genri', 'Miriam', '1901-01-01', '2 ALL DU BUISSON DE MUIRE ', '51430', 'TINQUEUX'),
(4907, 3, 128, 'Ganlan', 'Eurinsa', '1913-12-31', '31 RUE DU CANAL LOUIS XII ', '51000', 'CHALONS EN CHAMPAGNE'),
(4908, 2, 90, 'Surca', 'Cameron', '2011-12-30', '112 AV JEAN JAURES ', '51100', 'REIMS'),
(4909, 2, 168, 'Lase', 'Vinh', '1980-12-31', '46 RUE DU PERTHOIS ', '51300', 'FRIGNICOURT'),
(4910, 1, 21, 'Vavre', 'Lucy', '1967-12-31', '57 RUE JEAN JAURES ', '51000', 'CHALONS EN CHAMPAGNE'),
(4911, 2, 147, 'Teman', 'Emma', '1943-12-31', '27 RUE D ARGENTELLE ', '51700', 'VINCELLES'),
(4912, 1, 181, 'Mevu', 'Ted', '1904-01-01', '9001 RUE CAPORAL CHEF DIVRY ', '51100', 'REIMS'),
(4913, 1, 163, 'Groutu', 'Chantal', '1957-12-30', '12 RUE DE DAMPIERRE ', '51460', 'SAINT-ETIENNE-AU-TEMPLE'),
(4914, 1, 57, 'Taque', 'Jeanne', '2006-12-29', '9001 RUE DE L ECAILLE ', '51100', 'REIMS'),
(4915, 1, 45, 'Fahor', 'Doucet', '1952-01-01', '4 RUE LAMOUCHE ', '51100', 'REIMS'),
(4916, 3, 186, 'Coudre', 'Janin', '1913-12-31', '1 AV PIERRE DUBOIS ', '51160', 'AVENAY-VAL-D\'OR'),
(4917, 2, 92, 'Saica', 'Agathe', '1998-12-29', '12 AV HENRI BECQUEREL ', '51000', 'CHALONS EN CHAMPAGNE'),
(4918, 5, 185, 'Fava', 'Marinette', '1949-12-31', '51 RUE CHANZY ', '51100', 'REIMS'),
(4919, 1, 55, 'Chuse', 'Josette', '1915-01-01', '10 RUE MARIE STUART ', '51100', 'REIMS'),
(4920, 2, 74, 'Lanvre', 'Maurice', '1960-12-29', '84 RUE CHANZY ', '51100', 'REIMS'),
(4921, 3, 189, 'Turjur', 'Philipp', '1930-12-30', '5078 RUE DE TABURE ', '51800', 'HANS'),
(4922, 3, 1, 'Vuvan', 'Cécilia', '1911-12-31', '21 RUE PIERRE BROSSOLETTE ', '51100', 'REIMS'),
(4923, 3, 75, 'Vrulan', 'Renée', '1991-12-30', '3 RUE DU CHATELET ', '51100', 'REIMS'),
(4924, 4, 59, 'Quuhar', 'Déborah', '1930-12-30', '95 BD DU GENERAL LECLERC ', '51100', 'REIMS'),
(4925, 5, 187, 'Sonde', 'Carol', '1907-01-01', '10 RUE THIERS ', '51400', 'MOURMELON LE GRAND'),
(4926, 1, 39, 'Fortrou', 'Sofiane', '2006-01-01', '3 PL DU GENERAL LECLERC ', '51800', 'SAINTE MENEHOULD'),
(4927, 3, 5, 'Laiti', 'Véronique', '1967-12-30', '8 RUE DE TAISSY ', '51500', 'SAINT-LEONARD'),
(4928, 1, 50, 'Dove', 'Klein', '2001-12-30', '9001 RUE PAUL MILLOT ', '51370', 'SAINT BRICE COURCELLES'),
(4929, 5, 39, 'Sajur', 'Ioannis', '1999-12-30', '1 RUE ROBERT ESPAGNE ', '51000', 'CHALONS EN CHAMPAGNE'),
(4930, 1, 96, 'Vahu', 'Eveline', '1911-12-30', '36 RUE ROGER SALENGRO ', '51100', 'REIMS'),
(4931, 2, 119, 'Tofon', 'Victor', '1972-12-30', '2 RUE DES JARDINS ', '51300', 'BRUSSON'),
(4932, 1, 154, 'Motai', 'Roseline', '1907-12-31', '16 RUE DES ORMEAUX ', '51300', 'MAROLLES'),
(4933, 4, 160, 'Janha', 'Mac', '1973-12-29', '44 RUE FAVART D HERBIGNY ', '51100', 'REIMS'),
(4934, 2, 83, 'Donno', 'Erika', '2006-12-30', '4 RUE PAUL DOUMER ', '51350', 'CORMONTREUIL'),
(4935, 4, 199, 'Treran', 'Ludovic', '1925-12-31', '11 RUE CHARLES DE GAULLE ', '51430', 'BEZANNES'),
(4936, 3, 8, 'Srougar', 'Constance', '1994-01-01', '6 RUE THEODORE GERICAULT ', '51100', 'REIMS'),
(4937, 5, 104, 'Cufur', 'Ronan', '1918-12-30', '11 RUE JEAN RENAULT ', '51520', 'SARRY'),
(4938, 4, 148, 'Corgron', 'Maryvonne', '1932-01-01', '18 RUE DES 3 PILIERS ', '51100', 'REIMS'),
(4939, 3, 139, 'Rouvu', 'Wally', '1955-12-30', '59 RUE M CLEMENCE FOURIAUX ', '51100', 'REIMS'),
(4940, 2, 103, 'Charha', 'Ayméric', '1944-12-30', '40 RUE DE STRASBOURG ', '51100', 'REIMS'),
(4941, 1, 50, 'Mola', 'Mariane', '1947-12-31', '180 RUE RAYMOND MATHIEU ', '51430', 'BEZANNES'),
(4942, 3, 52, 'Dutrou', 'Philibert', '1985-12-30', '10 RUE GOIOT ', '51100', 'REIMS'),
(4943, 3, 7, 'Vorar', 'Anders', '1949-12-30', '12 RUE SAINT MICHEL ', '51240', 'MAIRY-SUR-MARNE'),
(4944, 3, 190, 'Gumon', 'Félix', '1939-12-31', '49 BD DAUPHINOT ', '51100', 'REIMS'),
(4945, 5, 43, 'Ramou', 'Harry', '1965-12-30', '18 RUE ERNEST VALLEE ', '51190', 'AVIZE'),
(4946, 3, 137, 'Murfe', 'Jocelyn', '1977-01-01', '27 RUE SAINT MEMJE ', '51300', 'VITRY LE FRANCOIS'),
(4947, 2, 49, 'Vunai', 'Nikos', '1929-12-31', '4 RUE CDT MARIN LA MESLEE ', '51100', 'REIMS'),
(4948, 2, 120, 'Honre', 'Susanne', '2006-12-29', '36 RUE D ORFEUIL ', '51000', 'CHALONS EN CHAMPAGNE'),
(4949, 3, 60, 'Founa', 'Klein', '1949-12-31', '28 RUE GAMBETTA ', '51100', 'REIMS'),
(4950, 2, 49, 'Laga', 'Déborah', '1941-12-31', '34 RUE ROGER SALENGRO ', '51510', 'COMPERTRIX'),
(4951, 4, 102, 'Canhai', 'Corinne', '1997-12-30', '47 RUE ETIENNE OEHMICHEN ', '51000', 'CHALONS EN CHAMPAGNE'),
(4952, 3, 116, 'Sannon', 'Roth', '1937-12-29', '5 RUE DES ROTISSEURS ', '51300', 'VITRY LE FRANCOIS'),
(4953, 3, 195, 'Tranvu', 'Manfred', '1974-12-30', '36 RUE GUSTAVE LAURENT ', '51100', 'REIMS'),
(4954, 1, 113, 'Nrouqua', 'Johanna', '1917-12-31', '6 RUE DE LOUVOIS ', '51150', 'BOUZY'),
(4955, 4, 132, 'Cada', 'Andrei', '1992-01-01', '13 PL TOULOUSE LAUTREC ', '51100', 'REIMS'),
(4956, 1, 91, 'Prorlan', 'Mounir', '1951-12-30', '82 RUE P VAILLANT COUTURIER ', '51100', 'REIMS'),
(4957, 2, 189, 'Cugan', 'Vicky', '1982-12-30', '39 RUE MICHEL SICRE ', '51100', 'REIMS'),
(4958, 2, 88, 'Hehor', 'Colin', '1918-12-31', '84 AV DE LAON ', '51100', 'REIMS'),
(4959, 4, 21, 'Cuson', 'Geneviève', '1904-12-31', '127 BD CHARLES ARNOULD ', '51100', 'REIMS'),
(4960, 5, 47, 'Jatri', 'Marylise', '2000-12-29', '32 RUE GERUZEZ ', '51100', 'REIMS'),
(4961, 1, 26, 'Hedo', 'Rainer', '1965-12-29', '1 RUE SCULPTEURS JACQUES ', '51100', 'REIMS'),
(4962, 3, 144, 'Hahe', 'Mireille', '1978-01-01', '9026 RUE DES AILETTES ', '51500', 'TAISSY'),
(4963, 1, 43, 'Vouma', 'Pablo', '1928-12-31', '6 RUE D ALGER ', '51100', 'REIMS'),
(4964, 2, 105, 'Nevou', 'Paulette', '2005-12-31', '32 RUE CERES ', '51100', 'REIMS'),
(4965, 1, 10, 'Nanri', 'Valéry', '1947-12-30', '28 CHS BOCQUAINE ', '51100', 'REIMS'),
(4966, 1, 59, 'Prarjou', 'Margarita', '1964-12-30', '12 ALL ANTOINE DE ST EXUPERY ', '51450', 'BETHENY'),
(4967, 4, 78, 'Norla', 'Sari', '1932-12-31', '53 RUE HENRI MARTIN ', '51200', 'EPERNAY'),
(4968, 4, 115, 'Saran', 'Hugues', '2012-12-30', '22 RUE DES GOUTTES D OR ', '51200', 'EPERNAY'),
(4969, 2, 54, 'Cedu', 'Omar', '1920-01-01', '44 RUE GAMBETTA ', '51100', 'REIMS'),
(4970, 3, 97, 'Nantre', 'Aicha', '1948-12-30', '17 PAS TALLEYRAND ', '51100', 'REIMS'),
(4971, 2, 108, 'Dransai', 'Olive', '1928-12-31', '170 AV DU GENERAL SARRAIL ', '51000', 'CHALONS EN CHAMPAGNE'),
(4972, 5, 52, 'Lorga', 'Elisa', '1937-01-01', '32 RUE DU PONT JACQUOT ', '51300', 'MAISONS-EN-CHAMPAGNE'),
(4973, 2, 85, 'Torna', 'Ioannis', '1973-12-30', '2 RUE BERGSON ', '51100', 'REIMS'),
(4974, 4, 172, 'Denou', 'Frederik', '1981-12-29', '7 CHEM DU HAUT ', '51260', 'MARCILLY-SUR-SEINE'),
(4975, 4, 162, 'Raiva', 'Hamel', '1944-12-31', '1 RTE DES FORGES ', '50700', 'BRIX'),
(4976, 5, 55, 'Gero', 'Kris', '1930-12-31', '4 RUE PAUL DOUMER ', '51350', 'CORMONTREUIL'),
(4977, 2, 129, 'Crihur', 'Ghislaine', '1944-12-31', '8 RUE ALFRED DE MUSSET ', '51100', 'REIMS'),
(4978, 5, 132, 'Toucu', 'Odette', '1927-01-01', '20 RUE DE TAISSY ', '51100', 'REIMS'),
(4979, 2, 79, 'Nardou', 'Laurie', '1944-12-31', '12 RTE DE LOUVOIS ', '51520', 'SAINT-MARTIN-SUR-LE-PRE'),
(4980, 2, 96, 'Gouyo', 'Germain', '1932-12-30', '4 RUE DE LA GLACIERE ', '51300', 'VITRY LE FRANCOIS'),
(4981, 4, 152, 'Tannur', 'Niels', '1952-12-29', '8 RUE RENE HERR ', '51200', 'EPERNAY'),
(4982, 4, 110, 'Ragru', 'Marius', '1964-12-29', '43 RUE LEON BOURGEOIS ', '51000', 'CHALONS EN CHAMPAGNE'),
(4983, 5, 100, 'Cota', 'Donatien', '1919-12-30', '5008 RAGONET ', '51110', 'WARMERIVILLE'),
(4984, 4, 110, 'Traile', 'Mounir', '2003-12-30', '59 RUE ANTOINE GOUSSIEZ ', '51100', 'REIMS'),
(4985, 1, 124, 'Lapra', 'Baptiste', '1982-12-31', '4 RUE DES CHARMILLES ', '51300', 'MAROLLES'),
(4986, 4, 90, 'Jama', 'Rodolphe', '1954-12-31', '59 RUE M CLEMENCE FOURIAUX ', '51100', 'REIMS'),
(4987, 1, 184, 'Mine', 'Roland', '2014-12-30', '55 RUE HENRI MARTIN ', '51200', 'EPERNAY'),
(4988, 2, 69, 'Varsre', 'Brett', '1926-12-30', '18 RUE DES JARDINS ', '51100', 'REIMS'),
(4989, 5, 107, 'Nanur', 'Didier', '1966-12-30', '143 RUE DE COURCELLES ', '51100', 'REIMS'),
(4990, 3, 22, 'Faman', 'Johann', '1930-12-30', '1 RTE DU HAMEAU AU CLERC ', '50700', 'MORVILLE'),
(4991, 3, 107, 'Dorvou', 'Guillaume', '1996-12-29', '32 RUE GERUZEZ ', '51100', 'REIMS'),
(4992, 5, 199, 'Gantou', 'Luc', '1976-12-30', '87 RUE DU MONT D ARENE ', '51100', 'REIMS'),
(4993, 4, 28, 'Case', 'France', '2016-12-29', '4 RUE DE LA GARE ', '51330', 'LE VIEIL DAMPIERRE'),
(4994, 2, 91, 'Zarhi', 'Aline', '1984-12-30', '36 RUE DE MONTLEAN ', '51210', 'MONTMIRAIL'),
(4995, 1, 52, 'Vecan', 'Martin', '1907-01-01', '134 RUE PIERRE BROSSOLETTE ', '51100', 'REIMS'),
(4996, 4, 9, 'Vema', 'Eve', '1991-12-30', '29 RUE DU GENERAL GOURAUD ', '51400', 'MOURMELON LE GRAND'),
(4997, 2, 82, 'Veya', 'Romain', '1917-12-30', '11 RUE DES TEMPLIERS ', '51100', 'REIMS'),
(4998, 4, 97, 'Lapra', 'Romain', '1999-12-30', '13 RUE JEAN JACQUES ROUSSEAU ', '51000', 'CHALONS EN CHAMPAGNE'),
(4999, 2, 103, 'Nanur', 'Rolande', '1912-12-29', '3 LA FOULERIE ', '51270', 'ORBAIS'),
(5000, 3, 159, 'Ganno', 'Aline', '1908-12-30', '8 RUE DE LA FONTAINE AUX LOUPS ', '51290', 'HAUTEVILLE'),
(22631, 2632, 3320, 'TOURNOUX', 'Cédric', '1975-01-14', '34 rue des Escargots', '52190', 'Villiers-lès-Aprey'),
(22632, 2639, 3315, 'BOUABDILLAH', 'Oualid', '1988-01-11', '10 rue de la Gare', '52200', 'Langres'),
(22633, 2631, NULL, 'CHIRAC', 'Jacques', '1932-01-28', '12 rue du Pere Lachaise', '75000', 'Paris'),
(22634, 2635, 3310, 'MACRON', 'Emmanuel', '1977-01-23', '69 rue Brigitte Lahaie', '06969', 'Le Tube'),
(22635, 2636, 3319, 'CHATEAU', 'Thierry', '2011-01-11', '1 impasse Partout', '02400', 'Château Thierry'),
(22636, 2633, NULL, 'JACOB', 'Rabbi', '2012-01-12', '3 rue de la Gare', '94800', 'Villejuif'),
(22637, 2634, 3315, 'PAULJACQUES', 'Pierre', '2001-01-01', '158 avenue Pierre Pauljacques', '69000', 'Lyon'),
(22638, 2638, 3314, 'BELMONDO', 'Jean-Luc', '2002-01-02', '4 boulevard Jean-Paul Belmondo', '62800', 'Liévin'),
(22639, 2637, 3313, 'FRANCOIS', 'Alain', '1978-01-03', '10010 chemin du Binaire', '51000', 'Reims');

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

--
-- Structure de la table `prescrireexam`
--

CREATE TABLE `prescrireexam` (
  `idConsult` int(11) NOT NULL,
  `idTpExam` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `prescrireexam`
--

INSERT INTO `prescrireexam` (`idConsult`, `idTpExam`) VALUES
(629, 1),
(766, 1),
(868, 1),
(993, 1),
(1565, 1),
(2243, 1),
(2430, 1),
(2483, 1),
(2783, 1),
(2926, 1),
(3190, 1),
(3784, 1),
(3808, 1),
(3930, 1),
(4113, 1),
(4841, 1),
(4856, 1),
(4942, 1),
(5227, 1),
(5314, 1),
(5623, 1),
(5977, 1),
(6303, 1),
(7342, 1),
(8080, 1),
(9161, 1),
(9241, 1),
(9289, 1),
(9402, 1),
(9491, 1),
(9765, 1),
(9813, 1),
(100, 2),
(252, 2),
(396, 2),
(530, 2),
(747, 2),
(768, 2),
(1208, 2),
(1301, 2),
(1829, 2),
(2245, 2),
(2464, 2),
(2478, 2),
(3101, 2),
(3491, 2),
(3728, 2),
(4646, 2),
(4672, 2),
(4732, 2),
(5006, 2),
(5385, 2),
(5558, 2),
(5903, 2),
(6074, 2),
(6301, 2),
(6442, 2),
(7944, 2),
(8681, 2),
(8752, 2),
(9127, 2),
(9295, 2),
(9387, 2),
(9452, 2),
(9648, 2),
(9866, 2),
(9972, 2),
(44, 3),
(387, 3),
(505, 3),
(912, 3),
(1507, 3),
(1661, 3),
(1863, 3),
(2102, 3),
(2412, 3),
(2429, 3),
(2456, 3),
(2459, 3),
(2818, 3),
(2993, 3),
(3127, 3),
(3245, 3),
(3438, 3),
(3550, 3),
(3607, 3),
(4609, 3),
(4907, 3),
(4930, 3),
(5162, 3),
(5232, 3),
(5300, 3),
(5805, 3),
(6577, 3),
(6810, 3),
(7763, 3),
(8332, 3),
(8502, 3),
(8718, 3),
(8869, 3),
(9110, 3),
(9288, 3),
(9577, 3),
(9670, 3),
(9859, 3),
(100, 4),
(133, 4),
(1157, 4),
(1246, 4),
(1263, 4),
(1358, 4),
(2052, 4),
(2349, 4),
(2767, 4),
(2775, 4),
(2847, 4),
(3044, 4),
(3239, 4),
(4265, 4),
(4787, 4),
(5538, 4),
(5665, 4),
(5686, 4),
(6263, 4),
(6929, 4),
(7156, 4),
(7719, 4),
(7725, 4),
(8602, 4),
(8691, 4),
(9353, 4),
(9546, 4),
(61, 5),
(1202, 5),
(1386, 5),
(1426, 5),
(1793, 5),
(2000, 5),
(2174, 5),
(2182, 5),
(2702, 5),
(3103, 5),
(3114, 5),
(3205, 5),
(3571, 5),
(3597, 5),
(3751, 5),
(3962, 5),
(4030, 5),
(4239, 5),
(4830, 5),
(5337, 5),
(6758, 5),
(6874, 5),
(6917, 5),
(7166, 5),
(7238, 5),
(7346, 5),
(7426, 5),
(7669, 5),
(7698, 5),
(7721, 5),
(7752, 5),
(7895, 5),
(8405, 5),
(8452, 5),
(9339, 5),
(9549, 5),
(9603, 5),
(9925, 5),
(10000, 5),
(599, 6),
(609, 6),
(1022, 6),
(1852, 6),
(1896, 6),
(2233, 6),
(2591, 6),
(3031, 6),
(3428, 6),
(3749, 6),
(4027, 6),
(4080, 6),
(4379, 6),
(4945, 6),
(5386, 6),
(5987, 6),
(6900, 6),
(7288, 6),
(7361, 6),
(7426, 6),
(7603, 6),
(7616, 6),
(7846, 6),
(7877, 6),
(7939, 6),
(8299, 6),
(8782, 6),
(8909, 6),
(192, 7),
(606, 7),
(1326, 7),
(1487, 7),
(1575, 7),
(1675, 7),
(1710, 7),
(1739, 7),
(2036, 7),
(2611, 7),
(2928, 7),
(3368, 7),
(3433, 7),
(3450, 7),
(3490, 7),
(4005, 7),
(4277, 7),
(4483, 7),
(5166, 7),
(5495, 7),
(5670, 7),
(5701, 7),
(5753, 7),
(5919, 7),
(6015, 7),
(6124, 7),
(6133, 7),
(6349, 7),
(6552, 7),
(6573, 7),
(6643, 7),
(6729, 7),
(7449, 7),
(7877, 7),
(8905, 7),
(9188, 7),
(9491, 7),
(9768, 7),
(9927, 7),
(9947, 7),
(220, 8),
(295, 8),
(433, 8),
(1163, 8),
(1597, 8),
(1836, 8),
(1954, 8),
(2115, 8),
(2127, 8),
(2316, 8),
(3033, 8),
(4068, 8),
(4776, 8),
(5006, 8),
(5336, 8),
(5472, 8),
(5601, 8),
(5738, 8),
(6018, 8),
(6831, 8),
(6848, 8),
(7282, 8),
(7501, 8),
(7509, 8),
(8153, 8),
(8436, 8),
(8565, 8),
(9372, 8),
(9432, 8),
(9468, 8),
(9741, 8),
(9990, 8),
(310, 9),
(634, 9),
(767, 9),
(850, 9),
(1758, 9),
(2355, 9),
(2775, 9),
(3057, 9),
(3305, 9),
(3490, 9),
(4243, 9),
(4442, 9),
(4717, 9),
(4980, 9),
(5515, 9),
(6036, 9),
(6857, 9),
(7233, 9),
(7553, 9),
(7965, 9),
(8208, 9),
(8450, 9),
(8478, 9),
(8641, 9),
(8915, 9),
(9291, 9),
(9352, 9),
(9669, 9),
(9965, 9),
(144, 10),
(486, 10),
(514, 10),
(1032, 10),
(1402, 10),
(1639, 10),
(2018, 10),
(2046, 10),
(2121, 10),
(2226, 10),
(2502, 10),
(2782, 10),
(2889, 10),
(3105, 10),
(3370, 10),
(4150, 10),
(4318, 10),
(4572, 10),
(5298, 10),
(6280, 10),
(6289, 10),
(6824, 10),
(6859, 10),
(7025, 10),
(7058, 10),
(7205, 10),
(7646, 10),
(8204, 10),
(8284, 10),
(8307, 10),
(8323, 10),
(8609, 10),
(8673, 10),
(9711, 10),
(9835, 10),
(216, 11),
(857, 11),
(1167, 11),
(1210, 11),
(1251, 11),
(1345, 11),
(1505, 11),
(1732, 11),
(1774, 11),
(2242, 11),
(2547, 11),
(2692, 11),
(2970, 11),
(3289, 11),
(3402, 11),
(3549, 11),
(4149, 11),
(4296, 11),
(4894, 11),
(5006, 11),
(5008, 11),
(5092, 11),
(5172, 11),
(6400, 11),
(6972, 11),
(7061, 11),
(8205, 11),
(8284, 11),
(8289, 11),
(8634, 11),
(9305, 11),
(9315, 11),
(9327, 11),
(9477, 11),
(38, 12),
(224, 12),
(484, 12),
(853, 12),
(1090, 12),
(1585, 12),
(1946, 12),
(2004, 12),
(2572, 12),
(2579, 12),
(3021, 12),
(3160, 12),
(3343, 12),
(3438, 12),
(4049, 12),
(4363, 12),
(4378, 12),
(4722, 12),
(4760, 12),
(5933, 12),
(6354, 12),
(7272, 12),
(8044, 12),
(8114, 12),
(8594, 12),
(9391, 12),
(9531, 12),
(9736, 12),
(9743, 12),
(9805, 12),
(283, 13),
(510, 13),
(573, 13),
(620, 13),
(717, 13),
(857, 13),
(984, 13),
(1027, 13),
(1073, 13),
(1120, 13),
(1190, 13),
(1414, 13),
(1754, 13),
(1876, 13),
(2138, 13),
(2145, 13),
(2419, 13),
(2541, 13),
(2594, 13),
(2753, 13),
(3138, 13),
(3959, 13),
(3974, 13),
(5934, 13),
(6534, 13),
(6548, 13),
(6664, 13),
(6797, 13),
(6915, 13),
(7082, 13),
(8981, 13),
(9341, 13),
(9979, 13),
(231, 14),
(673, 14),
(1033, 14),
(1421, 14),
(1662, 14),
(2614, 14),
(4324, 14),
(4960, 14),
(5102, 14),
(5115, 14),
(5214, 14),
(5675, 14),
(5903, 14),
(6285, 14),
(6287, 14),
(6902, 14),
(7207, 14),
(7773, 14),
(7779, 14),
(8103, 14),
(8294, 14),
(8310, 14),
(8608, 14),
(8619, 14),
(8729, 14),
(8840, 14),
(9152, 14),
(9274, 14),
(182, 15),
(646, 15),
(704, 15),
(873, 15),
(1316, 15),
(1328, 15),
(1778, 15),
(1898, 15),
(2259, 15),
(2590, 15),
(2795, 15),
(2852, 15),
(2873, 15),
(4043, 15),
(4177, 15),
(4462, 15),
(5122, 15),
(5691, 15),
(6117, 15),
(6175, 15),
(6335, 15),
(6422, 15),
(6440, 15),
(6572, 15),
(6983, 15),
(7421, 15),
(7612, 15),
(8118, 15),
(8190, 15),
(8390, 15),
(8485, 15),
(8617, 15),
(8644, 15),
(9046, 15),
(9139, 15),
(9196, 15),
(9331, 15),
(9363, 15),
(9511, 15),
(275, 16),
(893, 16),
(1064, 16),
(1185, 16),
(1235, 16),
(1656, 16),
(1697, 16),
(2020, 16),
(2266, 16),
(2274, 16),
(2285, 16),
(2464, 16),
(2664, 16),
(2722, 16),
(2776, 16),
(3121, 16),
(4025, 16),
(4519, 16),
(5102, 16),
(5722, 16),
(5754, 16),
(5799, 16),
(6032, 16),
(6312, 16),
(6595, 16),
(6691, 16),
(7659, 16),
(7686, 16),
(7689, 16),
(8038, 16),
(8596, 16),
(8780, 16),
(9151, 16),
(9660, 16),
(9858, 16),
(208, 17),
(320, 17),
(373, 17),
(948, 17),
(995, 17),
(997, 17),
(1032, 17),
(1561, 17),
(1607, 17),
(1828, 17),
(1943, 17),
(2136, 17),
(2656, 17),
(2674, 17),
(2847, 17),
(2981, 17),
(3304, 17),
(3394, 17),
(3603, 17),
(4438, 17),
(5148, 17),
(5196, 17),
(5264, 17),
(5447, 17),
(6107, 17),
(6263, 17),
(7286, 17),
(7882, 17),
(8297, 17),
(8317, 17),
(8495, 17),
(9156, 17),
(9934, 17),
(140, 18),
(1022, 18),
(1913, 18),
(2370, 18),
(2405, 18),
(2626, 18),
(2994, 18),
(4171, 18),
(4369, 18),
(5153, 18),
(6267, 18),
(6338, 18),
(6364, 18),
(6695, 18),
(6698, 18),
(6713, 18),
(6999, 18),
(7840, 18),
(7932, 18),
(8126, 18),
(8204, 18),
(8210, 18),
(9507, 18),
(9629, 18),
(640, 19),
(800, 19),
(1327, 19),
(1427, 19),
(1453, 19),
(1458, 19),
(1470, 19),
(1559, 19),
(1721, 19),
(1829, 19),
(2128, 19),
(3075, 19),
(3091, 19),
(3149, 19),
(3587, 19),
(3638, 19),
(3830, 19),
(4002, 19),
(4461, 19),
(4510, 19),
(4620, 19),
(5034, 19),
(5318, 19),
(5590, 19),
(5752, 19),
(5949, 19),
(6414, 19),
(6624, 19),
(6892, 19),
(6915, 19),
(8610, 19),
(8767, 19),
(9101, 19),
(9554, 19),
(9711, 19),
(9804, 19),
(27, 20),
(673, 20),
(826, 20),
(859, 20),
(1026, 20),
(1488, 20),
(1794, 20),
(2019, 20),
(2857, 20),
(2991, 20),
(3062, 20),
(3360, 20),
(3462, 20),
(3746, 20),
(4135, 20),
(4144, 20),
(4408, 20),
(4536, 20),
(4550, 20),
(4918, 20),
(5221, 20),
(5332, 20),
(5504, 20),
(5751, 20),
(5766, 20),
(6749, 20),
(6794, 20),
(7413, 20),
(7460, 20),
(7466, 20),
(7903, 20),
(8289, 20),
(8495, 20),
(8697, 20),
(8771, 20),
(9636, 20),
(1, 21),
(254, 21),
(388, 21),
(707, 21),
(713, 21),
(877, 21),
(1125, 21),
(1542, 21),
(1573, 21),
(1795, 21),
(1863, 21),
(2348, 21),
(2545, 21),
(3699, 21),
(3741, 21),
(4431, 21),
(4595, 21),
(4786, 21),
(4919, 21),
(5178, 21),
(5342, 21),
(5397, 21),
(5466, 21),
(6522, 21),
(6584, 21),
(7134, 21),
(7571, 21),
(7655, 21),
(7658, 21),
(7881, 21),
(8299, 21),
(8686, 21),
(8705, 21),
(8717, 21),
(9166, 21),
(9732, 21),
(35, 22),
(548, 22),
(1363, 22),
(1611, 22),
(2127, 22),
(2171, 22),
(2883, 22),
(2971, 22),
(3058, 22),
(3833, 22),
(4058, 22),
(4511, 22),
(5292, 22),
(5311, 22),
(5331, 22),
(5427, 22),
(5645, 22),
(6068, 22),
(6308, 22),
(6710, 22),
(6938, 22),
(7279, 22),
(7334, 22),
(7401, 22),
(7682, 22),
(7843, 22),
(8057, 22),
(8565, 22),
(8593, 22),
(9960, 22),
(148, 23),
(350, 23),
(773, 23),
(926, 23),
(1519, 23),
(1806, 23),
(2124, 23),
(2262, 23),
(2324, 23),
(2558, 23),
(2641, 23),
(2775, 23),
(3242, 23),
(3276, 23),
(3669, 23),
(4026, 23),
(4193, 23),
(4505, 23),
(4559, 23),
(4633, 23),
(5507, 23),
(5693, 23),
(5913, 23),
(6217, 23),
(6408, 23),
(6995, 23),
(7293, 23),
(7418, 23),
(7666, 23),
(7680, 23),
(8237, 23),
(8850, 23),
(9148, 23),
(9233, 23),
(791, 24),
(1189, 24),
(1406, 24),
(1815, 24),
(1838, 24),
(2707, 24),
(2834, 24),
(2904, 24),
(3209, 24),
(3351, 24),
(3481, 24),
(3528, 24),
(3619, 24),
(3798, 24),
(3862, 24),
(4792, 24),
(4842, 24),
(4872, 24),
(5994, 24),
(6069, 24),
(6578, 24),
(6800, 24),
(6801, 24),
(7172, 24),
(7413, 24),
(7670, 24),
(7762, 24),
(7919, 24),
(8975, 24),
(9000, 24),
(9865, 24),
(9988, 24),
(211, 25),
(331, 25),
(359, 25),
(1354, 25),
(1439, 25),
(2009, 25),
(3146, 25),
(3313, 25),
(3731, 25),
(3825, 25),
(4170, 25),
(4217, 25),
(4378, 25),
(4500, 25),
(4601, 25),
(4878, 25),
(5022, 25),
(5146, 25),
(5394, 25),
(5724, 25),
(6359, 25),
(6385, 25),
(8126, 25),
(8809, 25),
(9107, 25),
(9707, 25),
(39, 26),
(51, 26),
(120, 26),
(145, 26),
(628, 26),
(742, 26),
(842, 26),
(970, 26),
(1461, 26),
(1597, 26),
(1613, 26),
(1616, 26),
(1694, 26),
(2304, 26),
(2359, 26),
(3727, 26),
(3827, 26),
(3888, 26),
(4007, 26),
(4041, 26),
(4432, 26),
(4936, 26),
(5325, 26),
(5727, 26),
(6253, 26),
(6420, 26),
(6639, 26),
(7145, 26),
(7813, 26),
(7870, 26),
(7876, 26),
(7927, 26),
(8595, 26),
(9019, 26),
(9098, 26),
(9233, 26),
(112, 27),
(355, 27),
(625, 27),
(1239, 27),
(2193, 27),
(2264, 27),
(3630, 27),
(3654, 27),
(3955, 27),
(4217, 27),
(4454, 27),
(4711, 27),
(4892, 27),
(4901, 27),
(5369, 27),
(6016, 27),
(6281, 27),
(6381, 27),
(6427, 27),
(6867, 27),
(7100, 27),
(7817, 27),
(8000, 27),
(8146, 27),
(8617, 27),
(9443, 27),
(496, 28),
(556, 28),
(992, 28),
(1121, 28),
(1168, 28),
(1224, 28),
(1663, 28),
(1720, 28),
(2624, 28),
(3038, 28),
(3344, 28),
(3569, 28),
(3742, 28),
(3859, 28),
(3885, 28),
(4807, 28),
(5360, 28),
(5666, 28),
(5781, 28),
(6020, 28),
(7284, 28),
(7411, 28),
(7968, 28),
(8975, 28),
(9285, 28),
(9431, 28),
(9952, 28),
(2, 29),
(127, 29),
(723, 29),
(1237, 29),
(1615, 29),
(1767, 29),
(2768, 29),
(3317, 29),
(3365, 29),
(3445, 29),
(3639, 29),
(3916, 29),
(4145, 29),
(4355, 29),
(4488, 29),
(4791, 29),
(4879, 29),
(5002, 29),
(5234, 29),
(5375, 29),
(5536, 29),
(5718, 29),
(6025, 29),
(7033, 29),
(7271, 29),
(7288, 29),
(7823, 29),
(7848, 29),
(7916, 29),
(8057, 29),
(8409, 29),
(8673, 29),
(9174, 29),
(9472, 29),
(9544, 29),
(557, 30),
(939, 30),
(1147, 30),
(1184, 30),
(1288, 30),
(1504, 30),
(1506, 30),
(1835, 30),
(1920, 30),
(2328, 30),
(2462, 30),
(3716, 30),
(3735, 30),
(4709, 30),
(4856, 30),
(5054, 30),
(5208, 30),
(5571, 30),
(5800, 30),
(5991, 30),
(6087, 30),
(6612, 30),
(6807, 30),
(7493, 30),
(7585, 30),
(7826, 30),
(8605, 30),
(8607, 30),
(9135, 30),
(9364, 30),
(217, 31),
(235, 31),
(440, 31),
(487, 31),
(1069, 31),
(1997, 31),
(2289, 31),
(2295, 31),
(2707, 31),
(3614, 31),
(3976, 31),
(4128, 31),
(4184, 31),
(4718, 31),
(4738, 31),
(5025, 31),
(5711, 31),
(6036, 31),
(6045, 31),
(6834, 31),
(7901, 31),
(7965, 31),
(8033, 31),
(9601, 31),
(430, 32),
(714, 32),
(1035, 32),
(1474, 32),
(1616, 32),
(1795, 32),
(1930, 32),
(2110, 32),
(2663, 32),
(3807, 32),
(4125, 32),
(4253, 32),
(4364, 32),
(4513, 32),
(4563, 32),
(4774, 32),
(5547, 32),
(5643, 32),
(5664, 32),
(5854, 32),
(6087, 32),
(6144, 32),
(6901, 32),
(6908, 32),
(6992, 32),
(7024, 32),
(7122, 32),
(7401, 32),
(7502, 32),
(8082, 32),
(8145, 32),
(8667, 32),
(9719, 32),
(9959, 32),
(210, 33),
(235, 33),
(888, 33),
(1577, 33),
(1760, 33),
(2001, 33),
(2229, 33),
(2254, 33),
(2460, 33),
(2838, 33),
(2854, 33),
(3055, 33),
(3094, 33),
(3341, 33),
(3541, 33),
(3844, 33),
(4028, 33),
(4217, 33),
(4671, 33),
(5089, 33),
(5090, 33),
(5355, 33),
(5904, 33),
(6222, 33),
(6392, 33),
(6490, 33),
(6629, 33),
(6682, 33),
(6862, 33),
(7182, 33),
(8073, 33),
(8302, 33),
(9627, 33),
(9751, 33),
(9897, 33),
(346, 34),
(426, 34),
(538, 34),
(832, 34),
(839, 34),
(899, 34),
(1107, 34),
(1112, 34),
(1231, 34),
(1306, 34),
(1319, 34),
(1429, 34),
(1762, 34),
(2588, 34),
(3122, 34),
(3893, 34),
(4352, 34),
(4565, 34),
(4667, 34),
(4864, 34),
(5552, 34),
(5693, 34),
(5720, 34),
(5960, 34),
(6028, 34),
(6344, 34),
(6408, 34),
(6573, 34),
(6616, 34),
(6673, 34),
(6831, 34),
(6980, 34),
(7043, 34),
(7520, 34),
(7846, 34),
(8188, 34),
(9020, 34),
(9132, 34),
(9840, 34),
(9875, 34),
(9981, 34),
(329, 35),
(420, 35),
(1046, 35),
(1659, 35),
(2349, 35),
(2807, 35),
(3902, 35),
(3958, 35),
(4063, 35),
(4407, 35),
(5108, 35),
(5918, 35),
(6215, 35),
(6250, 35),
(7439, 35),
(8418, 35),
(8555, 35),
(8733, 35),
(8765, 35),
(8901, 35),
(8964, 35),
(9138, 35),
(9139, 35),
(9275, 35),
(9340, 35),
(69, 36),
(1153, 36),
(1735, 36),
(1864, 36),
(2204, 36),
(2274, 36),
(2300, 36),
(2627, 36),
(2884, 36),
(3386, 36),
(3481, 36),
(3702, 36),
(4306, 36),
(5122, 36),
(5218, 36),
(5310, 36),
(5635, 36),
(6056, 36),
(6180, 36),
(6276, 36),
(6535, 36),
(7074, 36),
(7306, 36),
(7337, 36),
(7370, 36),
(7988, 36),
(7998, 36),
(8594, 36),
(8949, 36),
(9245, 36),
(9440, 36),
(9671, 36),
(9980, 36),
(355, 37),
(843, 37),
(1097, 37),
(1405, 37),
(1920, 37),
(2254, 37),
(2570, 37),
(2748, 37),
(3136, 37),
(3479, 37),
(3636, 37),
(3993, 37),
(4240, 37),
(4279, 37),
(4327, 37),
(5784, 37),
(5842, 37),
(6093, 37),
(6190, 37),
(6262, 37),
(6411, 37),
(6603, 37),
(7558, 37),
(7829, 37),
(7866, 37),
(8080, 37),
(8180, 37),
(8183, 37),
(8501, 37),
(8675, 37),
(9497, 37),
(9535, 37),
(9758, 37),
(9910, 37),
(718, 38),
(1290, 38),
(1749, 38),
(2011, 38),
(3168, 38),
(3242, 38),
(3370, 38),
(3697, 38),
(3813, 38),
(4132, 38),
(4422, 38),
(4904, 38),
(5119, 38),
(5289, 38),
(5452, 38),
(5613, 38),
(6030, 38),
(6214, 38),
(6298, 38),
(6728, 38),
(6960, 38),
(7288, 38),
(7298, 38),
(7531, 38),
(7572, 38),
(8231, 38),
(8635, 38),
(8797, 38),
(8996, 38),
(9577, 38),
(9744, 38),
(9979, 38),
(321, 39),
(536, 39),
(990, 39),
(1066, 39),
(1336, 39),
(1708, 39),
(2029, 39),
(2309, 39),
(2326, 39),
(2666, 39),
(3137, 39),
(3484, 39),
(3739, 39),
(3892, 39),
(3954, 39),
(6177, 39),
(6267, 39),
(6331, 39),
(6591, 39),
(6600, 39),
(6647, 39),
(6650, 39),
(7087, 39),
(7160, 39),
(8489, 39),
(9746, 39),
(4, 40),
(320, 40),
(352, 40),
(457, 40),
(560, 40),
(1381, 40),
(1770, 40),
(1966, 40),
(2305, 40),
(2355, 40),
(2506, 40),
(2599, 40),
(2620, 40),
(2653, 40),
(2697, 40),
(4284, 40),
(4374, 40),
(4475, 40),
(4511, 40),
(4585, 40),
(4586, 40),
(4877, 40),
(5799, 40),
(5892, 40),
(6060, 40),
(6287, 40),
(6392, 40),
(6561, 40),
(6712, 40),
(7845, 40),
(7880, 40),
(8576, 40),
(8754, 40),
(8988, 40),
(9470, 40),
(9475, 40),
(9931, 40),
(9938, 40),
(1, 1140),
(2, 1140),
(5, 1140),
(3, 1141),
(6, 1142),
(7, 1142),
(3, 1143),
(9, 1144),
(10, 1144);

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

--
-- Structure de la table `prescriremedoc`
--

CREATE TABLE `prescriremedoc` (
  `idConsult` int(11) NOT NULL,
  `idRem` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `rembourser`
--

CREATE TABLE `rembourser` (
  `idRem` int(11) NOT NULL,
  `idMut` int(11) NOT NULL,
  `quotiteRem` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `rembourser`
--

INSERT INTO `rembourser` (`idRem`, `idMut`, `quotiteRem`) VALUES
(1, 10, 0.95),
(1, 11, 0.95),
(1, 12, 0.95),
(1, 13, 0.95),
(1, 14, 1),
(1, 17, 1),
(1, 5012, 0.5),
(2, 13, 0.8),
(2, 14, 0.85),
(2, 15, 0.95),
(2, 16, 0.95),
(2, 17, 0.95),
(2, 18, 0.95),
(2, 19, 0.95),
(2, 5012, 0.85),
(3, 10, 1),
(3, 11, 1),
(3, 12, 1),
(3, 13, 0.85),
(3, 14, 0.85),
(3, 15, 1),
(3, 16, 0.85),
(3, 17, 1),
(3, 18, 0.85),
(3, 19, 0.85),
(4, 15, 0.5),
(4, 17, 1.1),
(4, 19, 0.8),
(5, 13, 0.2),
(5, 14, 0.2),
(5, 16, 0.2),
(5, 17, 0),
(5, 18, 0),
(6, 12, 0.5),
(6, 13, 0.5),
(6, 14, 0.65),
(6, 15, 0.5),
(6, 16, 0.5),
(6, 17, 0.65),
(6, 18, 0.85),
(7, 15, 0.85),
(7, 16, 0.85),
(7, 17, 0.85),
(7, 18, 0.85),
(7, 5012, 0.85),
(8, 10, 0.85),
(8, 11, 1),
(8, 12, 1),
(8, 13, 1),
(8, 14, 1),
(8, 15, 1),
(8, 16, 1),
(8, 18, 0.5),
(8, 19, 0.5),
(9, 11, 0.4),
(9, 12, 0.4),
(9, 13, 0.4),
(9, 14, 0.4),
(9, 15, 0.4),
(9, 16, 0.4),
(10, 10, 1),
(10, 11, 0.2),
(10, 12, 0),
(10, 13, 0.5),
(10, 14, 0.62),
(10, 15, 0.7),
(10, 16, 0.3),
(10, 17, 2),
(10, 18, 0.25),
(10, 19, 0.85),
(10, 5012, 0.05);

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

--
-- Structure de la table `remede`
--

CREATE TABLE `remede` (
  `idRem` int(11) NOT NULL,
  `nomRem` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `remede`
--

INSERT INTO `remede` (`idRem`, `nomRem`) VALUES
(1, 'Aspirine'),
(2, 'Paracétamol'),
(3, 'Amoxiciline'),
(4, 'Supositoire Miam'),
(5, 'Viagra'),
(6, 'prostamole'),
(7, 'dragées Fuca'),
(8, 'Vitamine C'),
(9, 'Smecta'),
(10, 'Whisky');

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

--
-- Structure de la table `reverser`
--

CREATE TABLE `reverser` (
  `idTpExam` int(11) NOT NULL,
  `idMut` int(11) NOT NULL,
  `quotieTpExam` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `reverser`
--

INSERT INTO `reverser` (`idTpExam`, `idMut`, `quotieTpExam`) VALUES
(1140, 10, 0.7),
(1141, 11, 0.6),
(1142, 14, 0.8),
(1143, 13, 0.5),
(1144, 16, 0.8),
(2631, 2631, 0.85),
(2631, 2632, 0.95),
(2631, 2633, 0.65),
(2631, 2634, 0.75),
(2631, 2635, 0.55),
(2631, 2636, 0.45),
(2631, 2637, 0.35),
(2631, 2638, 0.75),
(2631, 2639, 0.75),
(2632, 2634, 0.79),
(2632, 2638, 0.73),
(2633, 2633, 0.69),
(2635, 2636, 0.49),
(2636, 2637, 0.37),
(2637, 2632, 0.68),
(2638, 2635, 0.56),
(2639, 2639, NULL);

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

--
-- Structure de la table `sejour_hospitalisation`
--

CREATE TABLE `sejour_hospitalisation` (
  `idSejour` int(11) NOT NULL,
  `idPat` int(11) NOT NULL,
  `idMed` int(11) NOT NULL,
  `idSer` int(11) NOT NULL,
  `dateHAdmissiion` datetime NOT NULL,
  `dateSortie` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `sejour_hospitalisation`
--

INSERT INTO `sejour_hospitalisation` (`idSejour`, `idPat`, `idMed`, `idSer`, `dateHAdmissiion`, `dateSortie`) VALUES
(2420, 27, 3316, 1634, '2019-12-12 12:12:12', '2019-12-15 12:12:12'),
(2421, 52, 3320, 1635, '2018-01-01 10:00:00', '2019-02-10 12:12:12'),
(2422, 28, 3310, 1638, '2019-04-01 09:00:00', '2019-04-10 10:00:00'),
(2423, 51, 3318, 1637, '2019-12-20 12:00:00', NULL),
(2424, 27, 3320, 1634, '2019-12-01 09:00:00', '2020-01-10 10:00:00'),
(2425, 28, 3310, 1638, '2019-12-01 10:00:00', '2019-01-02 10:00:00'),
(2426, 51, 3315, 1636, '2019-12-25 13:15:00', NULL),
(2427, 25, 3320, 1636, '2020-01-01 00:08:00', NULL),
(2428, 52, 3311, 1634, '2019-12-01 20:00:00', '2019-12-01 22:00:00'),
(2821, 2742, 3315, 1627, '2019-07-08 00:00:00', '2019-12-09 00:00:00'),
(2822, 2744, 3315, 1627, '2019-07-08 00:00:00', '2019-12-09 00:00:00'),
(2824, 2743, 3320, 1626, '2019-12-08 00:00:00', '2019-12-13 00:00:00'),
(2825, 2742, 3318, 1637, '2019-12-24 00:00:00', '2019-12-26 00:00:00'),
(2826, 2743, 3311, 1625, '2019-11-08 00:00:00', '2019-12-09 00:00:00'),
(2827, 2741, 3314, 1636, '2019-12-08 00:00:00', '2019-12-20 00:00:00'),
(2828, 2745, 3318, 1635, '2019-12-08 00:00:00', '2019-12-10 00:00:00'),
(2840, 2744, 3315, 1627, '2019-07-08 00:00:00', '2019-12-09 00:00:00'),
(2841, 2741, 3315, 1627, '2019-07-08 00:00:00', '2019-07-18 00:00:00'),
(2844, 2744, 3315, 1627, '2019-07-08 00:00:00', '2019-12-09 00:00:00'),
(2860, 2744, 3315, 1627, '2019-07-08 00:00:00', '2019-12-09 00:00:00'),
(2861, 2741, 3316, 1623, '2019-01-08 00:00:00', '2019-01-19 00:00:00'),
(2862, 2744, 3310, 1624, '2019-10-09 00:00:00', '2019-10-17 00:00:00'),
(2863, 2744, 3317, 1636, '2019-01-24 00:00:00', '2019-01-26 00:00:00'),
(2864, 52, 3310, 1630, '2019-02-08 00:00:00', '2019-03-09 00:00:00'),
(2865, 53, 3315, 1631, '2019-04-08 00:00:00', '2019-05-20 00:00:00'),
(2866, 27, 3316, 1634, '2019-01-08 00:00:00', '2019-11-10 00:00:00'),
(2867, 28, 3317, 1634, '2019-01-17 14:00:00', NULL),
(2868, 29, 3318, 1635, '2019-01-17 14:00:00', '2019-01-17 15:00:00'),
(2869, 25, 3318, 1628, '2019-01-18 09:00:00', '2019-01-19 15:00:00');

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

--
-- Structure de la table `service`
--

CREATE TABLE `service` (
  `idSer` int(11) NOT NULL,
  `idHopital` int(11) NOT NULL,
  `idMed` int(11) NOT NULL,
  `nomSer` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `service`
--

INSERT INTO `service` (`idSer`, `idHopital`, `idMed`, `nomSer`) VALUES
(1621, 1621, 3310, 'Pédiatrie'),
(1622, 1621, 3311, 'Ophtalmologie'),
(1623, 1621, 3313, 'Gynécologie'),
(1624, 1621, 3313, 'Oncologie gynécologique'),
(1625, 1622, 3314, 'Pédiatrie'),
(1626, 1622, 3315, 'Ophtalmologie'),
(1627, 1623, 3317, 'Pédiatrie'),
(1628, 1623, 3318, 'Urologie'),
(1629, 1624, 3319, 'Neurochirurgie'),
(1630, 1, 3310, 'Pédiatrie'),
(1631, 1, 3313, 'Ophtalmologie'),
(1632, 2, 3313, 'Gynécologie'),
(1633, 1, 3310, 'Oncologie gynécologique'),
(1634, 3, 3313, 'Pédiatrie'),
(1635, 4, 3310, 'Ophtalmologie'),
(1636, 4, 3310, 'Pédiatrie'),
(1637, 5, 3311, 'Urologie'),
(1638, 1, 3311, 'Neurochirurgie');

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

--
-- Structure de la table `typeexamenmedical`
--

CREATE TABLE `typeexamenmedical` (
  `idTpExam` int(11) NOT NULL,
  `nomTpExam` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `typeexamenmedical`
--

INSERT INTO `typeexamenmedical` (`idTpExam`, `nomTpExam`) VALUES
(1, 'Analyse d’urine'),
(2, 'Analyse de sang'),
(3, 'Arthrographie'),
(4, 'Arthroscanner'),
(5, 'Aspirations'),
(6, 'Echographie Générale'),
(7, 'Echographie Gynécologique Avec Sone Endocavitaire'),
(8, 'Echographie Interventionnelle'),
(9, 'Echographie Mammaire'),
(10, 'Echographie Obstétricale Par Médecins Agréés Tout Terme Avec Étude 3D Et Dopplers'),
(11, 'Echographie Ostéoarticulaire Avec Sonde Ultra Haute Fréquence'),
(12, 'Echographie Thyroidienne Spécialisée Avec Prélèvements Échoguidés'),
(13, 'Echographie Urinaire Et Prostatique Et Voie Endorectale Et 3D'),
(14, 'Elastographie'),
(15, 'Electrocardiogramme'),
(16, 'Evacuation Kyste'),
(17, 'Gynécologique : Injection De Contraste'),
(18, 'Hystérographie'),
(19, 'Hystérosonographie'),
(20, 'Imagerie De L’Implant'),
(21, 'Mammaire : Microbiopsie'),
(22, 'Mammographie 3D'),
(23, 'Mammotome Hh'),
(24, 'Orthopantomogramme'),
(25, 'Ostéoarticulaire : Ponctions'),
(26, 'Ostéroïdose'),
(27, 'Pelvimétrie Conventionnelle Et Par Scanner'),
(28, 'Prélèvement Ganglionnaire'),
(29, 'Radiologie Dentaire'),
(30, 'Radiologie Digestive Colographie Et Scanner'),
(31, 'Radiologie Gynécologique'),
(32, 'Radiologie Interventionnelle : Infiltrations Rachidiennes Et Ostéoarticulaires'),
(33, 'Radiologie Orl'),
(34, 'Radiologie Ostéoarticulaire '),
(35, 'Radiologie Urinaire'),
(36, 'Sialographie'),
(37, 'Test d’effort'),
(38, 'Thyroidienne : Ponction Cytologique'),
(39, 'Traitement Percutané Des Calcifications Tendineuses'),
(40, 'Uiv Et Uroscanner'),
(1140, 'angiographie'),
(1141, 'echographie'),
(1142, 'irm'),
(1143, 'scanner'),
(1144, 'phlebographie'),
(2331, 'Torture mentale'),
(2332, 'Triturage'),
(2333, 'Enfonçage'),
(2334, 'Tabassement'),
(2335, 'Visseuse électrique'),
(2336, 'Aaaahhhrggg'),
(2631, 'Proctologie'),
(2632, 'Cardiologie'),
(2633, 'Scintigraphie'),
(2634, 'Radiologie'),
(2635, 'Neurologie'),
(2636, 'Oncologie'),
(2637, 'Psychiatrie'),
(2638, 'Dialyse'),
(2639, 'Maternité');

--
-- Index pour les tables exportées
--

--
-- Index pour la table `consultation`
--
ALTER TABLE `consultation`
  ADD PRIMARY KEY (`idConsult`),
  ADD KEY `FK_realiser` (`idMed`),
  ADD KEY `FK_suivre` (`idPat`);

--
-- Index pour la table `examenmedical`
--
ALTER TABLE `examenmedical`
  ADD PRIMARY KEY (`idExam`),
  ADD KEY `FK_effectuer` (`idLab`),
  ADD KEY `FK_proceder` (`idTpExam`),
  ADD KEY `FK_subir` (`idPat`);

--
-- Index pour la table `exercer`
--
ALTER TABLE `exercer`
  ADD PRIMARY KEY (`idSer`,`idMed`),
  ADD KEY `FK_exercer2` (`idMed`);

--
-- Index pour la table `guerir`
--
ALTER TABLE `guerir`
  ADD PRIMARY KEY (`idMaladie`,`idRem`),
  ADD KEY `FK_guerir2` (`idRem`);

--
-- Index pour la table `hopital`
--
ALTER TABLE `hopital`
  ADD PRIMARY KEY (`idHopital`);

--
-- Index pour la table `laboratoire`
--
ALTER TABLE `laboratoire`
  ADD PRIMARY KEY (`idLab`),
  ADD KEY `FK_dependre` (`idHopital`);

--
-- Index pour la table `maladie`
--
ALTER TABLE `maladie`
  ADD PRIMARY KEY (`idMaladie`);

--
-- Index pour la table `medecin`
--
ALTER TABLE `medecin`
  ADD PRIMARY KEY (`idMed`);

--
-- Index pour la table `mutuelle`
--
ALTER TABLE `mutuelle`
  ADD PRIMARY KEY (`idMut`);

--
-- Index pour la table `patient`
--
ALTER TABLE `patient`
  ADD PRIMARY KEY (`idPat`),
  ADD KEY `FK_cotiser` (`idMut`),
  ADD KEY `FK_declarer_traitant` (`idMed`);

--
-- Index pour la table `prescrireexam`
--
ALTER TABLE `prescrireexam`
  ADD PRIMARY KEY (`idConsult`,`idTpExam`),
  ADD KEY `FK_prescrireExam2` (`idTpExam`);

--
-- Index pour la table `prescriremedoc`
--
ALTER TABLE `prescriremedoc`
  ADD PRIMARY KEY (`idConsult`,`idRem`),
  ADD KEY `FK_prescrireMedoc2` (`idRem`);

--
-- Index pour la table `rembourser`
--
ALTER TABLE `rembourser`
  ADD PRIMARY KEY (`idRem`,`idMut`),
  ADD KEY `FK_rembourser2` (`idMut`);

--
-- Index pour la table `remede`
--
ALTER TABLE `remede`
  ADD PRIMARY KEY (`idRem`);

--
-- Index pour la table `reverser`
--
ALTER TABLE `reverser`
  ADD PRIMARY KEY (`idTpExam`,`idMut`),
  ADD KEY `FK_reverser2` (`idMut`);

--
-- Index pour la table `sejour_hospitalisation`
--
ALTER TABLE `sejour_hospitalisation`
  ADD PRIMARY KEY (`idSejour`),
  ADD KEY `FK_aller` (`idPat`),
  ADD KEY `FK_demander` (`idMed`),
  ADD KEY `FK_localiser` (`idSer`);

--
-- Index pour la table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`idSer`),
  ADD KEY `FK_diriger` (`idMed`),
  ADD KEY `FK_situer` (`idHopital`);

--
-- Index pour la table `typeexamenmedical`
--
ALTER TABLE `typeexamenmedical`
  ADD PRIMARY KEY (`idTpExam`);

--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `consultation`
--
ALTER TABLE `consultation`
  ADD CONSTRAINT `FK_realiser` FOREIGN KEY (`idMed`) REFERENCES `medecin` (`idMed`),
  ADD CONSTRAINT `FK_suivre` FOREIGN KEY (`idPat`) REFERENCES `patient` (`idPat`);

--
-- Contraintes pour la table `examenmedical`
--
ALTER TABLE `examenmedical`
  ADD CONSTRAINT `FK_effectuer` FOREIGN KEY (`idLab`) REFERENCES `laboratoire` (`idLab`),
  ADD CONSTRAINT `FK_proceder` FOREIGN KEY (`idTpExam`) REFERENCES `typeexamenmedical` (`idTpExam`),
  ADD CONSTRAINT `FK_subir` FOREIGN KEY (`idPat`) REFERENCES `patient` (`idPat`);

--
-- Contraintes pour la table `exercer`
--
ALTER TABLE `exercer`
  ADD CONSTRAINT `FK_exercer` FOREIGN KEY (`idSer`) REFERENCES `service` (`idSer`),
  ADD CONSTRAINT `FK_exercer2` FOREIGN KEY (`idMed`) REFERENCES `medecin` (`idMed`);

--
-- Contraintes pour la table `guerir`
--
ALTER TABLE `guerir`
  ADD CONSTRAINT `FK_guerir` FOREIGN KEY (`idMaladie`) REFERENCES `maladie` (`idMaladie`),
  ADD CONSTRAINT `FK_guerir2` FOREIGN KEY (`idRem`) REFERENCES `remede` (`idRem`);

--
-- Contraintes pour la table `laboratoire`
--
ALTER TABLE `laboratoire`
  ADD CONSTRAINT `FK_dependre` FOREIGN KEY (`idHopital`) REFERENCES `hopital` (`idHopital`);

--
-- Contraintes pour la table `patient`
--
ALTER TABLE `patient`
  ADD CONSTRAINT `FK_cotiser` FOREIGN KEY (`idMut`) REFERENCES `mutuelle` (`idMut`),
  ADD CONSTRAINT `FK_declarer_traitant` FOREIGN KEY (`idMed`) REFERENCES `medecin` (`idMed`);

--
-- Contraintes pour la table `prescrireexam`
--
ALTER TABLE `prescrireexam`
  ADD CONSTRAINT `FK_prescrireExam` FOREIGN KEY (`idConsult`) REFERENCES `consultation` (`idConsult`),
  ADD CONSTRAINT `FK_prescrireExam2` FOREIGN KEY (`idTpExam`) REFERENCES `typeexamenmedical` (`idTpExam`);

--
-- Contraintes pour la table `prescriremedoc`
--
ALTER TABLE `prescriremedoc`
  ADD CONSTRAINT `FK_prescrireMedoc` FOREIGN KEY (`idConsult`) REFERENCES `consultation` (`idConsult`),
  ADD CONSTRAINT `FK_prescrireMedoc2` FOREIGN KEY (`idRem`) REFERENCES `remede` (`idRem`);

--
-- Contraintes pour la table `rembourser`
--
ALTER TABLE `rembourser`
  ADD CONSTRAINT `FK_rembourser` FOREIGN KEY (`idRem`) REFERENCES `remede` (`idRem`),
  ADD CONSTRAINT `FK_rembourser2` FOREIGN KEY (`idMut`) REFERENCES `mutuelle` (`idMut`);

--
-- Contraintes pour la table `reverser`
--
ALTER TABLE `reverser`
  ADD CONSTRAINT `FK_reverser` FOREIGN KEY (`idTpExam`) REFERENCES `typeexamenmedical` (`idTpExam`),
  ADD CONSTRAINT `FK_reverser2` FOREIGN KEY (`idMut`) REFERENCES `mutuelle` (`idMut`);

--
-- Contraintes pour la table `sejour_hospitalisation`
--
ALTER TABLE `sejour_hospitalisation`
  ADD CONSTRAINT `FK_aller` FOREIGN KEY (`idPat`) REFERENCES `patient` (`idPat`),
  ADD CONSTRAINT `FK_demander` FOREIGN KEY (`idMed`) REFERENCES `medecin` (`idMed`),
  ADD CONSTRAINT `FK_localiser` FOREIGN KEY (`idSer`) REFERENCES `service` (`idSer`);

--
-- Contraintes pour la table `service`
--
ALTER TABLE `service`
  ADD CONSTRAINT `FK_diriger` FOREIGN KEY (`idMed`) REFERENCES `medecin` (`idMed`),
  ADD CONSTRAINT `FK_situer` FOREIGN KEY (`idHopital`) REFERENCES `hopital` (`idHopital`);

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