Skip to content

Instantly share code, notes, and snippets.

@oanalivia oanalivia/french_town.sql
Last active Feb 5, 2018

Embed
What would you like to do?
This file has been truncated, but you can view the full file.
----------------------------------------------------------------------------------------------------
-- More details here : http://growingcookies.com/french-towns-departments-and-regions-january-2018/
-- town table : https://gist.github.com/oanalivia/94fc3aaca90c88bbf8871dbf698637bc
-- department table : https://gist.github.com/oanalivia/040eb8af3d562bf554495de0f1738525/edit
-- region table : https://gist.github.com/oanalivia/0db129e0d66d7371e0f76315326ea82f
-- indexes and constraints : https://gist.github.com/oanalivia/040eb8af3d562bf554495de0f1738525
----------------------------------------------------------------------------------------------------
--
-- Table structure for table `town`
--
CREATE TABLE `town` (
`id` int(11) NOT NULL,
`department_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`postalCode` varchar(8) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `town`
--
INSERT INTO `town` (`id`, `department_id`, `name`, `postalCode`) VALUES
(1, 1, 'Bourg En Bresse', '01000'),
(2, 1, 'Bourg En Bresse', '01000'),
(3, 1, 'St Denis Les Bourg', '01000'),
(4, 1, 'Francheleins', '01090'),
(5, 1, 'Genouilleux', '01090'),
(6, 1, 'Lurcy', '01090'),
(7, 1, 'Montceaux', '01090'),
(8, 1, 'Guereins', '01090'),
(9, 1, 'Francheleins', '01090'),
(10, 1, 'Montmerle Sur Saone', '01090'),
(11, 1, 'Francheleins', '01090'),
(12, 1, 'Arbent', '01100'),
(13, 1, 'Bellignat', '01100'),
(14, 1, 'Oyonnax', '01100'),
(15, 1, 'Groissiat', '01100'),
(16, 1, 'Geovreisset', '01100'),
(17, 1, 'Martignat', '01100'),
(18, 1, 'Apremont', '01100'),
(19, 1, 'Oyonnax', '01100'),
(20, 1, 'Oyonnax', '01100'),
(21, 1, 'Thezillieu', '01110'),
(22, 1, 'Aranc', '01110'),
(23, 1, 'Cormaranche En Bugey', '01110'),
(24, 1, 'Corlier', '01110'),
(25, 1, 'Champdor Corcelles', '01110'),
(26, 1, 'Champdor Corcelles', '01110'),
(27, 1, 'Premillieu', '01110'),
(28, 1, 'Hauteville Lompnes', '01110'),
(29, 1, 'Hostiaz', '01110'),
(30, 1, 'Brenod', '01110'),
(31, 1, 'Montluel', '01120'),
(32, 1, 'Montluel', '01120'),
(33, 1, 'Thil', '01120'),
(34, 1, 'Montluel', '01120'),
(35, 1, 'Ste Croix', '01120'),
(36, 1, 'Dagneux', '01120'),
(37, 1, 'Nievroz', '01120'),
(38, 1, 'La Boisse', '01120'),
(39, 1, 'Pizay', '01120'),
(40, 1, 'Nantua', '01130'),
(41, 1, 'Echallon', '01130'),
(42, 1, 'Le Poizat Lalleyriat', '01130'),
(43, 1, 'Le Poizat Lalleyriat', '01130'),
(44, 1, 'Plagne', '01130'),
(45, 1, 'Charix', '01130'),
(46, 1, 'Les Neyrolles', '01130'),
(47, 1, 'Belleydoux', '01130'),
(48, 1, 'Giron', '01130'),
(49, 1, 'St Germain De Joux', '01130'),
(50, 1, 'Thoissey', '01140'),
(51, 1, 'Mogneneins', '01140'),
(52, 1, 'Illiat', '01140'),
(53, 1, 'Valeins', '01140'),
(54, 1, 'Peyzieux Sur Saone', '01140'),
(55, 1, 'Garnerans', '01140'),
(56, 1, 'St Etienne Sur Chalaronne', '01140'),
(57, 1, 'St Didier Sur Chalaronne', '01140'),
(58, 1, 'Souclin', '01150'),
(59, 1, 'Villebois', '01150'),
(60, 1, 'Lagnieu', '01150'),
(61, 1, 'Vaux En Bugey', '01150'),
(62, 1, 'Leyment', '01150'),
(63, 1, 'St Sorlin En Bugey', '01150'),
(64, 1, 'Chazey Sur Ain', '01150'),
(65, 1, 'Blyes', '01150'),
(66, 1, 'Ste Julie', '01150'),
(67, 1, 'Sault Brenaz', '01150'),
(68, 1, 'St Vulbas', '01150'),
(69, 1, 'Druillat', '01160'),
(70, 1, 'Varambon', '01160'),
(71, 1, 'La Trancliere', '01160'),
(72, 1, 'St Martin Du Mont', '01160'),
(73, 1, 'Pont D Ain', '01160'),
(74, 1, 'Priay', '01160'),
(75, 1, 'Neuville Sur Ain', '01160'),
(76, 1, 'Gex', '01170'),
(77, 1, 'Mijoux', '01170'),
(78, 1, 'Vesancy', '01170'),
(79, 1, 'Chevry', '01170'),
(80, 1, 'Echenevex', '01170'),
(81, 1, 'Cessy', '01170'),
(82, 1, 'Segny', '01170'),
(83, 1, 'Crozet', '01170'),
(84, 1, 'Gorrevod', '01190'),
(85, 1, 'St Benigne', '01190'),
(86, 1, 'Reyssouze', '01190'),
(87, 1, 'Ozan', '01190'),
(88, 1, 'St Etienne Sur Reyssouze', '01190'),
(89, 1, 'Boz', '01190'),
(90, 1, 'Pont De Vaux', '01190'),
(91, 1, 'Chevroux', '01190'),
(92, 1, 'Boissey', '01190'),
(93, 1, 'Arbigny', '01190'),
(94, 1, 'Chavannes Sur Reyssouze', '01190'),
(95, 1, 'Sermoyer', '01190'),
(96, 1, 'Leaz', '01200'),
(97, 1, 'Injoux Genissiat', '01200'),
(98, 1, 'Chezery Forens', '01200'),
(99, 1, 'Injoux Genissiat', '01200'),
(100, 1, 'Eloise', '01200'),
(101, 1, 'Confort', '01200'),
(102, 1, 'Lancrans', '01200'),
(103, 1, 'Montanges', '01200'),
(104, 1, 'Bellegarde Sur Valserine', '01200'),
(105, 1, 'Chatillon En Michaille', '01200'),
(106, 1, 'Chatillon En Michaille', '01200'),
(107, 1, 'Chatillon En Michaille', '01200'),
(108, 1, 'Villes', '01200'),
(109, 1, 'Billiat', '01200'),
(110, 1, 'Ornex', '01210'),
(111, 1, 'Versonnex', '01210'),
(112, 1, 'Ferney Voltaire', '01210'),
(113, 1, 'Grilly', '01220'),
(114, 1, 'Divonne Les Bains', '01220'),
(115, 1, 'Sauverny', '01220'),
(116, 1, 'St Rambert En Bugey', '01230'),
(117, 1, 'Chaley', '01230'),
(118, 1, 'Nivollet Montgriffon', '01230'),
(119, 1, 'Cleyzieu', '01230'),
(120, 1, 'Evosges', '01230'),
(121, 1, 'Arandas', '01230'),
(122, 1, 'Argis', '01230'),
(123, 1, 'Torcieu', '01230'),
(124, 1, 'Tenay', '01230'),
(125, 1, 'Oncieu', '01230'),
(126, 1, 'Conand', '01230'),
(127, 1, 'Dompierre Sur Veyle', '01240'),
(128, 1, 'St Paul De Varax', '01240'),
(129, 1, 'Lent', '01240'),
(130, 1, 'St Andre Le Bouchoux', '01240'),
(131, 1, 'La Chapelle Du Chatelard', '01240'),
(132, 1, 'St Germain Sur Renon', '01240'),
(133, 1, 'Certines', '01240'),
(134, 1, 'Marlieux', '01240'),
(135, 1, 'Journans', '01250'),
(136, 1, 'Bohas Meyriat Rignat', '01250'),
(137, 1, 'Bohas Meyriat Rignat', '01250'),
(138, 1, 'Ceyzeriat', '01250'),
(139, 1, 'St Just', '01250'),
(140, 1, 'Chavannes Sur Suran', '01250'),
(141, 1, 'Hautecourt Romaneche', '01250'),
(142, 1, 'Corveissiat', '01250'),
(143, 1, 'Cize', '01250'),
(144, 1, 'Villereversure', '01250'),
(145, 1, 'Revonnas', '01250'),
(146, 1, 'Bohas Meyriat Rignat', '01250'),
(147, 1, 'Tossiat', '01250'),
(148, 1, 'Drom', '01250'),
(149, 1, 'Hautecourt Romaneche', '01250'),
(150, 1, 'Germagnat', '01250'),
(151, 1, 'Jasseron', '01250'),
(152, 1, 'Simandre Sur Suran', '01250'),
(153, 1, 'Pouillat', '01250'),
(154, 1, 'Grand Corent', '01250'),
(155, 1, 'Ramasse', '01250'),
(156, 1, 'Montagnat', '01250'),
(157, 1, 'Haut Valromey', '01260'),
(158, 1, 'Champagne En Valromey', '01260'),
(159, 1, 'Haut Valromey', '01260'),
(160, 1, 'Brenaz', '01260'),
(161, 1, 'Belmont Luthezieu', '01260'),
(162, 1, 'Vieu', '01260'),
(163, 1, 'Sutrieu', '01260'),
(164, 1, 'Lompnieu', '01260'),
(165, 1, 'Sutrieu', '01260'),
(166, 1, 'Champagne En Valromey', '01260'),
(167, 1, 'Ruffieu', '01260'),
(168, 1, 'Haut Valromey', '01260'),
(169, 1, 'Sutrieu', '01260'),
(170, 1, 'Belmont Luthezieu', '01260'),
(171, 1, 'Haut Valromey', '01260'),
(172, 1, 'Lochieu', '01260'),
(173, 1, 'Champagne En Valromey', '01260'),
(174, 1, 'Virieu Le Petit', '01260'),
(175, 1, 'Beaupont', '01270'),
(176, 1, 'Salavre', '01270'),
(177, 1, 'Pirajoux', '01270'),
(178, 1, 'Coligny', '01270'),
(179, 1, 'Verjon', '01270'),
(180, 1, 'Villemotier', '01270'),
(181, 1, 'Domsure', '01270'),
(182, 1, 'Prevessin Moens', '01280'),
(183, 1, 'Prevessin Moens', '01280'),
(184, 1, 'Pont De Veyle', '01290'),
(185, 1, 'Grieges', '01290'),
(186, 1, 'Cruzilles Les Mepillat', '01290'),
(187, 1, 'Biziat', '01290'),
(188, 1, 'Cormoranche Sur Saone', '01290'),
(189, 1, 'Laiz', '01290'),
(190, 1, 'St Andre D Huiriat', '01290'),
(191, 1, 'Bey', '01290'),
(192, 1, 'Crottet', '01290'),
(193, 1, 'St Jean Sur Veyle', '01290'),
(194, 1, 'Ambleon', '01300'),
(195, 1, 'Chazey Bons', '01300'),
(196, 1, 'Colomieu', '01300'),
(197, 1, 'Parves Et Nattages', '01300'),
(198, 1, 'St Germain Les Paroisses', '01300'),
(199, 1, 'Arboys En Bugey', '01300'),
(200, 1, 'Andert Et Condon', '01300'),
(201, 1, 'Arboys En Bugey', '01300'),
(202, 1, 'Belley', '01300'),
(203, 1, 'Izieu', '01300'),
(204, 1, 'Massignieu De Rives', '01300'),
(205, 1, 'Contrevoz', '01300'),
(206, 1, 'Conzieu', '01300'),
(207, 1, 'Peyrieu', '01300'),
(208, 1, 'Marignieu', '01300'),
(209, 1, 'Murs Et Gelignieux', '01300'),
(210, 1, 'Bregnier Cordon', '01300'),
(211, 1, 'Brens', '01300'),
(212, 1, 'Groslee St Benoit', '01300'),
(213, 1, 'Premeyzel', '01300'),
(214, 1, 'St Champ', '01300'),
(215, 1, 'Parves Et Nattages', '01300'),
(216, 1, 'Magnieu', '01300'),
(217, 1, 'Cuzieu', '01300'),
(218, 1, 'Virignin', '01300'),
(219, 1, 'Confrancon', '01310'),
(220, 1, 'Curtafond', '01310'),
(221, 1, 'St Martin Le Chatel', '01310'),
(222, 1, 'Polliat', '01310'),
(223, 1, 'Buellas', '01310'),
(224, 1, 'Montcet', '01310'),
(225, 1, 'Buellas', '01310'),
(226, 1, 'Montracol', '01310'),
(227, 1, 'St Remy', '01310'),
(228, 1, 'Villette Sur Ain', '01320'),
(229, 1, 'Crans', '01320'),
(230, 1, 'Chatillon La Palud', '01320'),
(231, 1, 'Chatenay', '01320'),
(232, 1, 'St Nizier Le Desert', '01320'),
(233, 1, 'Chalamont', '01320'),
(234, 1, 'Bouligneux', '01330'),
(235, 1, 'Birieux', '01330'),
(236, 1, 'Amberieux En Dombes', '01330'),
(237, 1, 'Versailleux', '01330'),
(238, 1, 'Lapeyrouse', '01330'),
(239, 1, 'Le Plantay', '01330'),
(240, 1, 'Villars Les Dombes', '01330'),
(241, 1, 'Ste Olive', '01330'),
(242, 1, 'Malafretaz', '01340'),
(243, 1, 'Jayat', '01340'),
(244, 1, 'Attignat', '01340'),
(245, 1, 'St Sulpice', '01340'),
(246, 1, 'Etrez', '01340'),
(247, 1, 'Montrevel En Bresse', '01340'),
(248, 1, 'Foissiat', '01340'),
(249, 1, 'Cras Sur Reyssouze', '01340'),
(250, 1, 'Marsonnas', '01340'),
(251, 1, 'St Didier D Aussiat', '01340'),
(252, 1, 'Bereziat', '01340'),
(253, 1, 'Flaxieu', '01350'),
(254, 1, 'Pollieu', '01350'),
(255, 1, 'Lavours', '01350'),
(256, 1, 'Vongnes', '01350'),
(257, 1, 'Cressin Rochefort', '01350'),
(258, 1, 'Culoz', '01350'),
(259, 1, 'Beon', '01350'),
(260, 1, 'Ceyzerieu', '01350'),
(261, 1, 'Anglefort', '01350'),
(262, 1, 'Beligneux', '01360'),
(263, 1, 'Beligneux', '01360'),
(264, 1, 'Beligneux', '01360'),
(265, 1, 'Bressolles', '01360'),
(266, 1, 'Bressolles', '01360'),
(267, 1, 'Loyettes', '01360'),
(268, 1, 'Beligneux', '01360'),
(269, 1, 'Balan', '01360'),
(270, 1, 'Val Revermont', '01370'),
(271, 1, 'Beny', '01370'),
(272, 1, 'Courmangoux', '01370'),
(273, 1, 'Meillonnas', '01370'),
(274, 1, 'Val Revermont', '01370'),
(275, 1, 'Val Revermont', '01370'),
(276, 1, 'St Etienne Du Bois', '01370'),
(277, 1, 'Dommartin', '01380'),
(278, 1, 'St Andre De Bage', '01380'),
(279, 1, 'Bage Le Chatel', '01380'),
(280, 1, 'Boissey', '01380'),
(281, 1, 'St Genis Sur Menthon', '01380'),
(282, 1, 'Bage La Ville', '01380'),
(283, 1, 'St Cyr Sur Menthon', '01380'),
(284, 1, 'Mionnay', '01390'),
(285, 1, 'St Jean De Thurigneux', '01390'),
(286, 1, 'St Marcel', '01390'),
(287, 1, 'Tramoyes', '01390'),
(288, 1, 'St Andre De Corcy', '01390'),
(289, 1, 'Rance', '01390'),
(290, 1, 'Civrieux', '01390'),
(291, 1, 'Monthieux', '01390'),
(292, 1, 'L Abergement Clemenciat', '01400'),
(293, 1, 'Dompierre Sur Chalaronne', '01400'),
(294, 1, 'Chatillon Sur Chalaronne', '01400'),
(295, 1, 'Chanoz Chatenay', '01400'),
(296, 1, 'Sandrans', '01400'),
(297, 1, 'Romans', '01400'),
(298, 1, 'Condeissiat', '01400'),
(299, 1, 'St Georges Sur Renon', '01400'),
(300, 1, 'Neuville Les Dames', '01400'),
(301, 1, 'Sulignat', '01400'),
(302, 1, 'Champfromier', '01410'),
(303, 1, 'Mijoux', '01410'),
(304, 1, 'Chezery Forens', '01410'),
(305, 1, 'Lajoux', '01410'),
(306, 1, 'Lelex', '01410'),
(307, 1, 'Surjoux', '01420'),
(308, 1, 'Chanay', '01420'),
(309, 1, 'Lhopital', '01420'),
(310, 1, 'Corbonod', '01420'),
(311, 1, 'Seyssel', '01420'),
(312, 1, 'Izenave', '01430'),
(313, 1, 'Chevillard', '01430'),
(314, 1, 'Condamine', '01430'),
(315, 1, 'Vieu D Izenave', '01430'),
(316, 1, 'Outriaz', '01430'),
(317, 1, 'Peyriat', '01430'),
(318, 1, 'Maillat', '01430'),
(319, 1, 'St Martin Du Frene', '01430'),
(320, 1, 'Ceignes', '01430'),
(321, 1, 'Lantenay', '01430'),
(322, 1, 'Viriat', '01440'),
(323, 1, 'St Alban', '01450'),
(324, 1, 'Poncin', '01450'),
(325, 1, 'Bolozon', '01450'),
(326, 1, 'Labalme', '01450'),
(327, 1, 'Leyssard', '01450'),
(328, 1, 'Serrieres Sur Ain', '01450'),
(329, 1, 'Cerdon', '01450'),
(330, 1, 'Merignat', '01450'),
(331, 1, 'Challes La Montagne', '01450'),
(332, 1, 'Brion', '01460'),
(333, 1, 'Montreal La Cluse', '01460'),
(334, 1, 'Nantua', '01460'),
(335, 1, 'Port', '01460'),
(336, 1, 'Nurieux Volognat', '01460'),
(337, 1, 'Nurieux Volognat', '01460'),
(338, 1, 'Beard Geovreissiat', '01460'),
(339, 1, 'Serrieres De Briord', '01470'),
(340, 1, 'Benonces', '01470'),
(341, 1, 'Montagnieu', '01470'),
(342, 1, 'Briord', '01470'),
(343, 1, 'Seillonnaz', '01470'),
(344, 1, 'Ars Sur Formans', '01480'),
(345, 1, 'Fareins', '01480'),
(346, 1, 'Chaleins', '01480'),
(347, 1, 'Messimy Sur Saone', '01480'),
(348, 1, 'Jassans Riottier', '01480'),
(349, 1, 'Villeneuve', '01480'),
(350, 1, 'Beauregard', '01480'),
(351, 1, 'Frans', '01480'),
(352, 1, 'Savigneux', '01480'),
(353, 1, 'Ambutrix', '01500'),
(354, 1, 'Amberieu En Bugey', '01500'),
(355, 1, 'Douvres', '01500'),
(356, 1, 'Bettant', '01500'),
(357, 1, 'St Maurice De Remens', '01500'),
(358, 1, 'St Denis En Bugey', '01500'),
(359, 1, 'Ambronay', '01500'),
(360, 1, 'Chateau Gaillard', '01500'),
(361, 1, 'Ordonnaz', '01510'),
(362, 1, 'St Martin De Bavel', '01510'),
(363, 1, 'Armix', '01510'),
(364, 1, 'Cheignieu La Balme', '01510'),
(365, 1, 'Virieu Le Grand', '01510'),
(366, 1, 'Talissieu', '01510'),
(367, 1, 'Rossillon', '01510'),
(368, 1, 'Pugieu', '01510'),
(369, 1, 'Artemare', '01510'),
(370, 1, 'La Burbanche', '01510'),
(371, 1, 'Chavornay', '01510'),
(372, 1, 'St Julien Sur Veyle', '01540'),
(373, 1, 'Vonnas', '01540'),
(374, 1, 'Perrex', '01540'),
(375, 1, 'Collonges', '01550'),
(376, 1, 'Pougny', '01550'),
(377, 1, 'Farges', '01550'),
(378, 1, 'Servignat', '01560'),
(379, 1, 'St Julien Sur Reyssouze', '01560'),
(380, 1, 'Curciat Dongalon', '01560'),
(381, 1, 'Vescours', '01560'),
(382, 1, 'Courtes', '01560'),
(383, 1, 'Mantenay Montlin', '01560'),
(384, 1, 'St Trivier De Courtes', '01560'),
(385, 1, 'Vernoux', '01560'),
(386, 1, 'St Nizier Le Bouchoux', '01560'),
(387, 1, 'Lescheroux', '01560'),
(388, 1, 'Cormoz', '01560'),
(389, 1, 'St Jean Sur Reyssouze', '01560'),
(390, 1, 'Asnieres Sur Saone', '01570'),
(391, 1, 'Manziat', '01570'),
(392, 1, 'Vesines', '01570'),
(393, 1, 'Feillens', '01570'),
(394, 1, 'Sonthonnax La Montagne', '01580'),
(395, 1, 'Sonthonnax La Montagne', '01580'),
(396, 1, 'Matafelon Granges', '01580'),
(397, 1, 'Matafelon Granges', '01580'),
(398, 1, 'Samognat', '01580'),
(399, 1, 'Izernore', '01580'),
(400, 1, 'Chancia', '01590'),
(401, 1, 'Lavancia Epercy', '01590'),
(402, 1, 'Dortan', '01590'),
(403, 1, 'St Bernard', '01600'),
(404, 1, 'Miserieux', '01600'),
(405, 1, 'Toussieux', '01600'),
(406, 1, 'Trevoux', '01600'),
(407, 1, 'Massieux', '01600'),
(408, 1, 'Parcieux', '01600'),
(409, 1, 'Ste Euphemie', '01600'),
(410, 1, 'Reyrieux', '01600'),
(411, 1, 'St Didier De Formans', '01600'),
(412, 1, 'Sergy', '01630'),
(413, 1, 'Peron', '01630'),
(414, 1, 'St Jean De Gonville', '01630'),
(415, 1, 'Challex', '01630'),
(416, 1, 'St Genis Pouilly', '01630'),
(417, 1, 'Boyeux St Jerome', '01640'),
(418, 1, 'L Abergement De Varey', '01640'),
(419, 1, 'St Jean Le Vieux', '01640'),
(420, 1, 'Jujurieux', '01640'),
(421, 1, 'Chaveyriat', '01660'),
(422, 1, 'Mezeriat', '01660'),
(423, 1, 'Vandeins', '01660'),
(424, 1, 'Groslee St Benoit', '01680'),
(425, 1, 'Lhuis', '01680'),
(426, 1, 'Innimond', '01680'),
(427, 1, 'Marchamp', '01680'),
(428, 1, 'Lompnas', '01680'),
(429, 1, 'Miribel', '01700'),
(430, 1, 'St Maurice De Beynost', '01700'),
(431, 1, 'Neyron', '01700'),
(432, 1, 'Miribel', '01700'),
(433, 1, 'Miribel', '01700'),
(434, 1, 'Beynost', '01700'),
(435, 1, 'Thoiry', '01710'),
(436, 1, 'Crottet', '01750'),
(437, 1, 'Replonges', '01750'),
(438, 1, 'St Laurent Sur Saone', '01750'),
(439, 1, 'Charnoz Sur Ain', '01800'),
(440, 1, 'Bourg St Christophe', '01800'),
(441, 1, 'St Eloi', '01800'),
(442, 1, 'Joyeux', '01800'),
(443, 1, 'Villieu Loyes Mollon', '01800'),
(444, 1, 'St Jean De Niost', '01800'),
(445, 1, 'Bourg St Christophe', '01800'),
(446, 1, 'Perouges', '01800'),
(447, 1, 'Meximieux', '01800'),
(448, 1, 'St Maurice De Gourdans', '01800'),
(449, 1, 'Villieu Loyes Mollon', '01800'),
(450, 1, 'Le Montellier', '01800'),
(451, 1, 'Faramans', '01800'),
(452, 1, 'Villieu Loyes Mollon', '01800'),
(453, 1, 'Rignieux Le Franc', '01800'),
(454, 1, 'Marboz', '01851'),
(455, 1, 'Peronnas', '01960'),
(456, 1, 'Servas', '01960'),
(457, 1, 'St Andre Sur Vieux Jonc', '01960'),
(458, 1, 'Relevant', '01990'),
(459, 1, 'Chaneins', '01990'),
(460, 1, 'St Trivier Sur Moignans', '01990'),
(461, 1, 'Baneins', '01990'),
(462, 2, 'Monampteuil', '02000'),
(463, 2, 'Montbavin', '02000'),
(464, 2, 'Royaucourt Et Chailvet', '02000'),
(465, 2, 'Barenton Cel', '02000'),
(466, 2, 'Vaucelles Et Beffecourt', '02000'),
(467, 2, 'Chevregny', '02000'),
(468, 2, 'Chavignon', '02000'),
(469, 2, 'Barenton Bugny', '02000'),
(470, 2, 'Braye En Laonnois', '02000'),
(471, 2, 'Chaillevois', '02000'),
(472, 2, 'Chivy Les Etouvelles', '02000'),
(473, 2, 'Laniscourt', '02000'),
(474, 2, 'Merlieux Et Fouquerolles', '02000'),
(475, 2, 'Laon', '02000'),
(476, 2, 'Bourguignon Sous Montbavin', '02000'),
(477, 2, 'Clacy Et Thierret', '02000'),
(478, 2, 'Chambry', '02000'),
(479, 2, 'Etouvelles', '02000'),
(480, 2, 'Verneuil Sur Serre', '02000'),
(481, 2, 'Aulnois Sous Laon', '02000'),
(482, 2, 'Chery Les Pouilly', '02000'),
(483, 2, 'Filain', '02000'),
(484, 2, 'Mons En Laonnois', '02000'),
(485, 2, 'Molinchart', '02000'),
(486, 2, 'Pargny Filain', '02000'),
(487, 2, 'Urcel', '02000'),
(488, 2, 'Morcourt', '02100'),
(489, 2, 'Remaucourt', '02100'),
(490, 2, 'Fayet', '02100'),
(491, 2, 'Harly', '02100'),
(492, 2, 'Omissy', '02100'),
(493, 2, 'St Quentin', '02100'),
(494, 2, 'Lesdins', '02100'),
(495, 2, 'Essigny Le Petit', '02100'),
(496, 2, 'Gricourt', '02100'),
(497, 2, 'Neuville St Amand', '02100'),
(498, 2, 'Rouvroy', '02100'),
(499, 2, 'Montigny En Arrouaise', '02110'),
(500, 2, 'Montbrehain', '02110'),
(501, 2, 'Aisonville Et Bernoville', '02110'),
(502, 2, 'Grougis', '02110'),
(503, 2, 'Vaux Andigny', '02110'),
(504, 2, 'Becquigny', '02110'),
(505, 2, 'Fieulaine', '02110'),
(506, 2, 'Etaves Et Bocquiaux', '02110'),
(507, 2, 'Molain', '02110'),
(508, 2, 'Brancourt Le Grand', '02110'),
(509, 2, 'Serain', '02110'),
(510, 2, 'Croix Fonsomme', '02110'),
(511, 2, 'St Martin Riviere', '02110'),
(512, 2, 'Bohain En Vermandois', '02110'),
(513, 2, 'Beaurevoir', '02110'),
(514, 2, 'Fontaine Uterte', '02110'),
(515, 2, 'Seboncourt', '02110'),
(516, 2, 'La Vallee Mulatre', '02110'),
(517, 2, 'Ribeauville', '02110'),
(518, 2, 'Fontaine Notre Dame', '02110'),
(519, 2, 'Fonsomme', '02110'),
(520, 2, 'Premont', '02110'),
(521, 2, 'Ramicourt', '02110'),
(522, 2, 'Lesquielles St Germain', '02120'),
(523, 2, 'Landifay Et Bertaignemont', '02120'),
(524, 2, 'Proisy', '02120'),
(525, 2, 'Proix', '02120'),
(526, 2, 'Audigny', '02120'),
(527, 2, 'Bernot', '02120'),
(528, 2, 'Colonfay', '02120'),
(529, 2, 'Flavigny Le Grand Et Beaurain', '02120'),
(530, 2, 'Vadencourt', '02120'),
(531, 2, 'Chigny', '02120'),
(532, 2, 'Hauteville', '02120'),
(533, 2, 'Sains Richaumont', '02120'),
(534, 2, 'Crupilly', '02120'),
(535, 2, 'Marly Gomont', '02120'),
(536, 2, 'Le Herie La Vieville', '02120'),
(537, 2, 'Guise', '02120'),
(538, 2, 'Macquigny', '02120'),
(539, 2, 'Malzy', '02120'),
(540, 2, 'Villers Les Guise', '02120'),
(541, 2, 'Grand Verly', '02120'),
(542, 2, 'Tupigny', '02120'),
(543, 2, 'Wiege Faty', '02120'),
(544, 2, 'Monceau Sur Oise', '02120'),
(545, 2, 'Noyales', '02120'),
(546, 2, 'Vadencourt', '02120'),
(547, 2, 'Puisieux Et Clanlieu', '02120'),
(548, 2, 'Romery', '02120'),
(549, 2, 'Bruyeres Sur Fere', '02130'),
(550, 2, 'Seringes Et Nesles', '02130'),
(551, 2, 'Coulonges Cohan', '02130'),
(552, 2, 'Cramaille', '02130'),
(553, 2, 'Fresnes En Tardenois', '02130'),
(554, 2, 'Beuvardes', '02130'),
(555, 2, 'Villeneuve Sur Fere', '02130'),
(556, 2, 'Arcy Ste Restitue', '02130'),
(557, 2, 'Arcy Ste Restitue', '02130'),
(558, 2, 'Saponay', '02130'),
(559, 2, 'Cierges', '02130'),
(560, 2, 'Mareuil En Dole', '02130'),
(561, 2, 'Loupeigne', '02130'),
(562, 2, 'Goussancourt', '02130'),
(563, 2, 'Dravegny', '02130'),
(564, 2, 'Courmont', '02130'),
(565, 2, 'Vezilly', '02130'),
(566, 2, 'Villers Agron Aiguizy', '02130'),
(567, 2, 'Sergy', '02130'),
(568, 2, 'Villers Sur Fere', '02130'),
(569, 2, 'Coulonges Cohan', '02130'),
(570, 2, 'Fere En Tardenois', '02130'),
(571, 2, 'Roncheres', '02130'),
(572, 2, 'Nampcelles La Cour', '02140'),
(573, 2, 'Landouzy La Ville', '02140'),
(574, 2, 'Jeantes', '02140'),
(575, 2, 'Houry', '02140'),
(576, 2, 'Hary', '02140'),
(577, 2, 'Voharies', '02140'),
(578, 2, 'Fontaine Les Vervins', '02140'),
(579, 2, 'Franqueville', '02140'),
(580, 2, 'Burelles', '02140'),
(581, 2, 'Harcigny', '02140'),
(582, 2, 'Gronard', '02140'),
(583, 2, 'Gercy', '02140'),
(584, 2, 'Lugny', '02140'),
(585, 2, 'Rougeries', '02140'),
(586, 2, 'Laigny', '02140'),
(587, 2, 'Le Sourd', '02140'),
(588, 2, 'Braye En Thierache', '02140'),
(589, 2, 'La Bouteille', '02140'),
(590, 2, 'Marfontaine', '02140'),
(591, 2, 'Haution', '02140'),
(592, 2, 'Plomion', '02140'),
(593, 2, 'Prisces', '02140'),
(594, 2, 'Landouzy La Cour', '02140'),
(595, 2, 'St Pierre Les Franqueville', '02140'),
(596, 2, 'Leme', '02140'),
(597, 2, 'Dagny Lambercy', '02140'),
(598, 2, 'Bancigny', '02140'),
(599, 2, 'La Vallee Au Ble', '02140'),
(600, 2, 'Voulpaix', '02140'),
(601, 2, 'Vervins', '02140'),
(602, 2, 'St Gobert', '02140'),
(603, 2, 'Thenailles', '02140'),
(604, 2, 'Rogny', '02140'),
(605, 2, 'Lappion', '02150'),
(606, 2, 'Nizy Le Comte', '02150'),
(607, 2, 'La Selve', '02150'),
(608, 2, 'Sissonne', '02150'),
(609, 2, 'Oulches La Vallee Foulon', '02160'),
(610, 2, 'Pontavert', '02160'),
(611, 2, 'Meurival', '02160'),
(612, 2, 'Maizy', '02160'),
(613, 2, 'Les Septvallons', '02160'),
(614, 2, 'Beaurieux', '02160'),
(615, 2, 'Craonne', '02160'),
(616, 2, 'Vassogne', '02160'),
(617, 2, 'Bourg Et Comin', '02160'),
(618, 2, 'Chaudardes', '02160'),
(619, 2, 'Cuiry Les Chaudardes', '02160'),
(620, 2, 'Moulins', '02160'),
(621, 2, 'Blanzy Les Fismes', '02160'),
(622, 2, 'Serval', '02160'),
(623, 2, 'Cuissy Et Geny', '02160'),
(624, 2, 'Craonnelle', '02160'),
(625, 2, 'Gernicourt', '02160'),
(626, 2, 'Les Septvallons', '02160'),
(627, 2, 'Jumigny', '02160'),
(628, 2, 'Muscourt', '02160'),
(629, 2, 'Oeuilly', '02160'),
(630, 2, 'Pargnan', '02160'),
(631, 2, 'Les Septvallons', '02160'),
(632, 2, 'Paissy', '02160'),
(633, 2, 'Pont Arcy', '02160'),
(634, 2, 'Les Septvallons', '02160'),
(635, 2, 'Bouffignereux', '02160'),
(636, 2, 'Concevreux', '02160'),
(637, 2, 'Viel Arcy', '02160'),
(638, 2, 'Soupir', '02160'),
(639, 2, 'Les Septvallons', '02160'),
(640, 2, 'Les Septvallons', '02160'),
(641, 2, 'Les Septvallons', '02160'),
(642, 2, 'Les Septvallons', '02160'),
(643, 2, 'Guyencourt', '02160'),
(644, 2, 'Moussy Verneuil', '02160'),
(645, 2, 'La Ville Aux Bois Les Pontavert', '02160'),
(646, 2, 'Vendresse Beaulne', '02160'),
(647, 2, 'Roucy', '02160'),
(648, 2, 'Le Nouvion En Thierache', '02170'),
(649, 2, 'Barzy En Thierache', '02170'),
(650, 2, 'Fontenelle', '02170'),
(651, 2, 'Esqueheries', '02170'),
(652, 2, 'Leschelle', '02170'),
(653, 2, 'Amifontaine', '02190'),
(654, 2, 'Aguilcourt', '02190'),
(655, 2, 'Conde Sur Suippe', '02190'),
(656, 2, 'Bertricourt', '02190'),
(657, 2, 'Pignicourt', '02190'),
(658, 2, 'Orainville', '02190'),
(659, 2, 'Variscourt', '02190'),
(660, 2, 'Neufchatel Sur Aisne', '02190'),
(661, 2, 'Menneville', '02190'),
(662, 2, 'Proviseux Et Plesnoy', '02190'),
(663, 2, 'Prouvais', '02190'),
(664, 2, 'Lor', '02190'),
(665, 2, 'Juvincourt Et Damary', '02190'),
(666, 2, 'La Malmaison', '02190'),
(667, 2, 'Berry Au Bac', '02190'),
(668, 2, 'Evergnicourt', '02190'),
(669, 2, 'Guignicourt', '02190'),
(670, 2, 'Saconin Et Breuil', '02200'),
(671, 2, 'Mercin Et Vaux', '02200'),
(672, 2, 'Belleu', '02200'),
(673, 2, 'Cuisy En Almont', '02200'),
(674, 2, 'Billy Sur Aisne', '02200'),
(675, 2, 'Acy', '02200'),
(676, 2, 'Nampteuil Sous Muret', '02200'),
(677, 2, 'Pernant', '02200'),
(678, 2, 'Ploisy', '02200'),
(679, 2, 'Vauxrezis', '02200'),
(680, 2, 'Chacrise', '02200'),
(681, 2, 'Chaudun', '02200'),
(682, 2, 'Soissons', '02200'),
(683, 2, 'Noyant Et Aconin', '02200'),
(684, 2, 'Pasly', '02200'),
(685, 2, 'Missy Aux Bois', '02200'),
(686, 2, 'Rozieres Sur Crise', '02200'),
(687, 2, 'Buzancy', '02200'),
(688, 2, 'Venizel', '02200'),
(689, 2, 'Villeneuve St Germain', '02200'),
(690, 2, 'Septmonts', '02200'),
(691, 2, 'Ambrief', '02200'),
(692, 2, 'Berzy Le Sec', '02200'),
(693, 2, 'Courmelles', '02200'),
(694, 2, 'Vauxbuin', '02200'),
(695, 2, 'Pommiers', '02200'),
(696, 2, 'Breny', '02210'),
(697, 2, 'Oulchy Le Chateau', '02210'),
(698, 2, 'Oulchy Le Chateau', '02210'),
(699, 2, 'Nanteuil Notre Dame', '02210'),
(700, 2, 'Muret Et Crouttes', '02210'),
(701, 2, 'La Croix Sur Ourcq', '02210'),
(702, 2, 'Billy Sur Ourcq', '02210'),
(703, 2, 'Armentieres Sur Ourcq', '02210'),
(704, 2, 'Grisolles', '02210'),
(705, 2, 'Rocourt St Martin', '02210'),
(706, 2, 'Villemontoire', '02210'),
(707, 2, 'Rozet St Albin', '02210'),
(708, 2, 'Grand Rozoy', '02210'),
(709, 2, 'Coincy', '02210'),
(710, 2, 'Chouy', '02210'),
(711, 2, 'Launoy', '02210'),
(712, 2, 'Oulchy La Ville', '02210'),
(713, 2, 'Montgru St Hilaire', '02210'),
(714, 2, 'Hartennes Et Taux', '02210'),
(715, 2, 'Le Plessier Huleu', '02210'),
(716, 2, 'Latilly', '02210'),
(717, 2, 'Brecy', '02210'),
(718, 2, 'Vichel Nanteuil', '02210'),
(719, 2, 'Vierzy', '02210'),
(720, 2, 'Beugneux', '02210'),
(721, 2, 'Droizy', '02210'),
(722, 2, 'Parcy Et Tigny', '02210'),
(723, 2, 'St Remy Blanzy', '02210'),
(724, 2, 'Cerseuil', '02220'),
(725, 2, 'Bruys', '02220'),
(726, 2, 'Serches', '02220'),
(727, 2, 'Lhuys', '02220'),
(728, 2, 'Jouaignes', '02220'),
(729, 2, 'Quincy Sous Le Mont', '02220'),
(730, 2, 'Tannieres', '02220'),
(731, 2, 'Dhuizel', '02220'),
(732, 2, 'Brenelle', '02220'),
(733, 2, 'Braine', '02220'),
(734, 2, 'Augy', '02220'),
(735, 2, 'Lime', '02220'),
(736, 2, 'Lesges', '02220'),
(737, 2, 'Paars', '02220'),
(738, 2, 'Vasseny', '02220'),
(739, 2, 'St Mard', '02220'),
(740, 2, 'Sermoise', '02220'),
(741, 2, 'Courcelles Sur Vesle', '02220'),
(742, 2, 'Mont Notre Dame', '02220'),
(743, 2, 'Maast Et Violaine', '02220'),
(744, 2, 'St Thibaut', '02220'),
(745, 2, 'Chery Chartreuve', '02220'),
(746, 2, 'Ciry Salsogne', '02220'),
(747, 2, 'Cys La Commune', '02220'),
(748, 2, 'Bazoches Sur Vesles', '02220'),
(749, 2, 'Vauxtin', '02220'),
(750, 2, 'Ville Savoye', '02220'),
(751, 2, 'Cuiry Housse', '02220'),
(752, 2, 'Couvrelles', '02220'),
(753, 2, 'Mont St Martin', '02220'),
(754, 2, 'Fresnoy Le Grand', '02230'),
(755, 2, 'Pleine Selve', '02240'),
(756, 2, 'Mezieres Sur Oise', '02240'),
(757, 2, 'Surfontaine', '02240'),
(758, 2, 'Renansart', '02240'),
(759, 2, 'Regny', '02240'),
(760, 2, 'Brissy Hamegicourt', '02240'),
(761, 2, 'Itancourt', '02240'),
(762, 2, 'Chatillon Sur Oise', '02240'),
(763, 2, 'Sery Les Mezieres', '02240'),
(764, 2, 'Sissy', '02240'),
(765, 2, 'Villers Le Sec', '02240'),
(766, 2, 'Alaincourt', '02240'),
(767, 2, 'Berthenicourt', '02240'),
(768, 2, 'Brissay Choigny', '02240'),
(769, 2, 'Cerizy', '02240'),
(770, 2, 'Parpeville', '02240'),
(771, 2, 'Ribemont', '02240'),
(772, 2, 'Marcy Sous Marle', '02250'),
(773, 2, 'Housset', '02250'),
(774, 2, 'Tavaux Et Pontsericourt', '02250'),
(775, 2, 'Bosmont Sur Serre', '02250'),
(776, 2, 'Chevennes', '02250'),
(777, 2, 'Erlon', '02250'),
(778, 2, 'Toulis Et Attencourt', '02250'),
(779, 2, 'Thiernu', '02250'),
(780, 2, 'Cilly', '02250'),
(781, 2, 'Montigny Sous Marle', '02250'),
(782, 2, 'La Neuville Bosmont', '02250'),
(783, 2, 'Berlancourt', '02250'),
(784, 2, 'Voyenne', '02250'),
(785, 2, 'Autremencourt', '02250'),
(786, 2, 'Marle', '02250'),
(787, 2, 'La Neuville Housset', '02250'),
(788, 2, 'Montigny Le Franc', '02250'),
(789, 2, 'St Pierremont', '02250'),
(790, 2, 'La Capelle', '02260'),
(791, 2, 'St Algis', '02260'),
(792, 2, 'Lerzy', '02260'),
(793, 2, 'Clairfontaine', '02260'),
(794, 2, 'Papleux', '02260'),
(795, 2, 'Englancourt', '02260'),
(796, 2, 'Erloy', '02260'),
(797, 2, 'Gergny', '02260'),
(798, 2, 'Rocquigny', '02260'),
(799, 2, 'Sommeron', '02260'),
(800, 2, 'Froidestrees', '02260'),
(801, 2, 'La Flamengrie', '02260'),
(802, 2, 'Chatillon Les Sons', '02270'),
(803, 2, 'Mortiers', '02270'),
(804, 2, 'Nouvion Et Catillon', '02270'),
(805, 2, 'Remies', '02270'),
(806, 2, 'Dercy', '02270'),
(807, 2, 'Bois Les Pargny', '02270'),
(808, 2, 'La Ferte Chevresis', '02270'),
(809, 2, 'Monceau Les Leups', '02270'),
(810, 2, 'Mesbrecourt Richecourt', '02270'),
(811, 2, 'Chevresis Monceau', '02270'),
(812, 2, 'Froidmont Cohartille', '02270'),
(813, 2, 'Montigny Sur Crecy', '02270'),
(814, 2, 'Monceau Le Neuf Et Faucouzy', '02270'),
(815, 2, 'Couvron Et Aumencourt', '02270'),
(816, 2, 'Crecy Sur Serre', '02270'),
(817, 2, 'Sons Et Roncheres', '02270'),
(818, 2, 'Assis Sur Serre', '02270'),
(819, 2, 'Barenton Sur Serre', '02270'),
(820, 2, 'Chalandry', '02270'),
(821, 2, 'Nouvion Et Catillon', '02270'),
(822, 2, 'Pouilly Sur Serre', '02270'),
(823, 2, 'Pargny Les Bois', '02270'),
(824, 2, 'St Christophe A Berry', '02290'),
(825, 2, 'Berny Riviere', '02290'),
(826, 2, 'Fontenoy', '02290'),
(827, 2, 'Bagneux', '02290'),
(828, 2, 'Tartiers', '02290'),
(829, 2, 'Bieuxy', '02290'),
(830, 2, 'Montigny Lengrain', '02290'),
(831, 2, 'Osly Courtil', '02290'),
(832, 2, 'Morsain', '02290'),
(833, 2, 'Vezaponin', '02290'),
(834, 2, 'Vic Sur Aisne', '02290'),
(835, 2, 'Ambleny', '02290'),
(836, 2, 'Epagny', '02290'),
(837, 2, 'Nouvron Vingre', '02290'),
(838, 2, 'Vassens', '02290'),
(839, 2, 'St Bandry', '02290'),
(840, 2, 'Ressons Le Long', '02290'),
(841, 2, 'Pierremande', '02300'),
(842, 2, 'St Aubin', '02300'),
(843, 2, 'Neuflieux', '02300'),
(844, 2, 'Ognes', '02300'),
(845, 2, 'Audignicourt', '02300'),
(846, 2, 'Blerancourt', '02300'),
(847, 2, 'Commenchon', '02300'),
(848, 2, 'Caillouel Crepigny', '02300'),
(849, 2, 'Bethancourt En Vaux', '02300'),
(850, 2, 'Camelin', '02300'),
(851, 2, 'Camelin', '02300'),
(852, 2, 'Chauny', '02300'),
(853, 2, 'Villequier Aumont', '02300'),
(854, 2, 'Ugny Le Gay', '02300'),
(855, 2, 'Bourguignon Sous Coucy', '02300'),
(856, 2, 'Caumont', '02300'),
(857, 2, 'Sinceny', '02300'),
(858, 2, 'Marest Dampcourt', '02300'),
(859, 2, 'La Neuville En Beine', '02300'),
(860, 2, 'Guivry', '02300'),
(861, 2, 'Guny', '02300'),
(862, 2, 'Manicamp', '02300'),
(863, 2, 'Bichancourt', '02300'),
(864, 2, 'Beaumont En Beine', '02300'),
(865, 2, 'Autreville', '02300'),
(866, 2, 'Viry Noureuil', '02300'),
(867, 2, 'Trosly Loire', '02300'),
(868, 2, 'St Paul Aux Bois', '02300'),
(869, 2, 'Abbecourt', '02300'),
(870, 2, 'Besme', '02300'),
(871, 2, 'Selens', '02300'),
(872, 2, 'Quierzy', '02300'),
(873, 2, 'Pavant', '02310'),
(874, 2, 'Romeny Sur Marne', '02310'),
(875, 2, 'Domptin', '02310'),
(876, 2, 'Nogent L Artaud', '02310'),
(877, 2, 'Coupru', '02310'),
(878, 2, 'Montreuil Aux Lions', '02310'),
(879, 2, 'Saulchery', '02310'),
(880, 2, 'Villiers St Denis', '02310'),
(881, 2, 'Charly Sur Marne', '02310'),
(882, 2, 'Bezu Le Guery', '02310'),
(883, 2, 'Crouttes Sur Marne', '02310'),
(884, 2, 'Brancourt En Laonnois', '02320'),
(885, 2, 'Anizy Le Chateau', '02320'),
(886, 2, 'Wissignicourt', '02320'),
(887, 2, 'Pinon', '02320'),
(888, 2, 'Faucoucourt', '02320'),
(889, 2, 'Lizy', '02320'),
(890, 2, 'Premontre', '02320'),
(891, 2, 'Vauxaillon', '02320'),
(892, 2, 'Vaudesson', '02320'),
(893, 2, 'Suzy', '02320'),
(894, 2, 'Allemant', '02320'),
(895, 2, 'Cessieres', '02320'),
(896, 2, 'Montigny Les Conde', '02330'),
(897, 2, 'Montlevon', '02330'),
(898, 2, 'Conde En Brie', '02330'),
(899, 2, 'Connigis', '02330'),
(900, 2, 'Celles Les Conde', '02330'),
(901, 2, 'Dhuys Et Morin En Brie', '02330'),
(902, 2, 'Pargny La Dhuys', '02330'),
(903, 2, 'Courboin', '02330'),
(904, 2, 'Monthurel', '02330'),
(905, 2, 'St Eugene', '02330'),
(906, 2, 'Vallees En Champagne', '02330'),
(907, 2, 'Vallees En Champagne', '02330'),
(908, 2, 'Vallees En Champagne', '02330'),
(909, 2, 'Ste Genevieve', '02340'),
(910, 2, 'Montcornet', '02340'),
(911, 2, 'Renneval', '02340'),
(912, 2, 'Vincy Reuil Et Magny', '02340'),
(913, 2, 'Le Thuel', '02340'),
(914, 2, 'Clermont Les Fermes', '02340'),
(915, 2, 'Berlise', '02340'),
(916, 2, 'Lislet', '02340'),
(917, 2, 'Montloue', '02340'),
(918, 2, 'Noircourt', '02340'),
(919, 2, 'Dizy Le Gros', '02340'),
(920, 2, 'Soize', '02340'),
(921, 2, 'Vigneux Hocquet', '02340'),
(922, 2, 'La Ville Aux Bois Les Dizy', '02340'),
(923, 2, 'Agnicourt Et Sechelles', '02340'),
(924, 2, 'Chaourse', '02340'),
(925, 2, 'Bucy Les Pierrepont', '02350'),
(926, 2, 'Machecourt', '02350'),
(927, 2, 'Cuirieux', '02350'),
(928, 2, 'Grandlup Et Fay', '02350'),
(929, 2, 'Ste Preuve', '02350'),
(930, 2, 'Liesse Notre Dame', '02350'),
(931, 2, 'Pierrepont', '02350'),
(932, 2, 'Boncourt', '02350'),
(933, 2, 'Ebouleau', '02350'),
(934, 2, 'Chivres En Laonnois', '02350'),
(935, 2, 'Goudelancourt Les Pierrepont', '02350'),
(936, 2, 'Gizy', '02350'),
(937, 2, 'Marchais', '02350'),
(938, 2, 'Missy Les Pierrepont', '02350'),
(939, 2, 'Vesles Et Caumont', '02350'),
(940, 2, 'St Clement', '02360'),
(941, 2, 'Dolignon', '02360'),
(942, 2, 'Dohis', '02360'),
(943, 2, 'Coingt', '02360'),
(944, 2, 'Archon', '02360'),
(945, 2, 'Les Autels', '02360'),
(946, 2, 'Iviers', '02360'),
(947, 2, 'Rozoy Sur Serre', '02360'),
(948, 2, 'Mont St Jean', '02360'),
(949, 2, 'Resigny', '02360'),
(950, 2, 'Morgny En Thierache', '02360'),
(951, 2, 'Rouvroy Sur Serre', '02360'),
(952, 2, 'Chery Les Rozoy', '02360'),
(953, 2, 'Brunehamel', '02360'),
(954, 2, 'Cuiry Les Iviers', '02360'),
(955, 2, 'Grandrieux', '02360'),
(956, 2, 'Parfondeval', '02360'),
(957, 2, 'Raillimont', '02360'),
(958, 2, 'Ostel', '02370'),
(959, 2, 'Aizy Jouy', '02370'),
(960, 2, 'Aizy Jouy', '02370'),
(961, 2, 'Chassemy', '02370'),
(962, 2, 'Vailly Sur Aisne', '02370'),
(963, 2, 'Chavonne', '02370'),
(964, 2, 'Conde Sur Aisne', '02370'),
(965, 2, 'Presles Et Boves', '02370'),
(966, 2, 'Celles Sur Aisne', '02370'),
(967, 2, 'Fresnes', '02380'),
(968, 2, 'Landricourt', '02380'),
(969, 2, 'Jumencourt', '02380'),
(970, 2, 'Quincy Basse', '02380'),
(971, 2, 'Leuilly Sous Coucy', '02380'),
(972, 2, 'Bassoles Aulers', '02380'),
(973, 2, 'Coucy Le Chateau Auffrique', '02380'),
(974, 2, 'Coucy La Ville', '02380'),
(975, 2, 'Crecy Au Mont', '02380'),
(976, 2, 'Verneuil Sous Coucy', '02380'),
(977, 2, 'Pont St Mard', '02380'),
(978, 2, 'Neuvillette', '02390'),
(979, 2, 'Origny Ste Benoite', '02390'),
(980, 2, 'Mont D Origny', '02390'),
(981, 2, 'Thenelles', '02390'),
(982, 2, 'Nogentel', '02400'),
(983, 2, 'Azy Sur Marne', '02400'),
(984, 2, 'Blesmes', '02400'),
(985, 2, 'Chierry', '02400'),
(986, 2, 'Etampes Sur Marne', '02400'),
(987, 2, 'Etrepilly', '02400'),
(988, 2, 'Epieds', '02400'),
(989, 2, 'Bonnesvalyn', '02400'),
(990, 2, 'Nesles La Montagne', '02400'),
(991, 2, 'Lucy Le Bocage', '02400'),
(992, 2, 'Mont St Pere', '02400'),
(993, 2, 'Bouresches', '02400'),
(994, 2, 'Bonneil', '02400'),
(995, 2, 'Essomes Sur Marne', '02400'),
(996, 2, 'Epaux Bezu', '02400'),
(997, 2, 'Bezu St Germain', '02400'),
(998, 2, 'Belleau', '02400'),
(999, 2, 'Gland', '02400'),
(1000, 2, 'Verdilly', '02400'),
(1001, 2, 'Chateau Thierry', '02400'),
(1002, 2, 'Charteves', '02400'),
(1003, 2, 'Brasles', '02400'),
(1004, 2, 'Monthiers', '02400'),
(1005, 2, 'Septvaux', '02410'),
(1006, 2, 'St Nicolas Aux Bois', '02410'),
(1007, 2, 'St Gobain', '02410'),
(1008, 2, 'Magny La Fosse', '02420'),
(1009, 2, 'Levergies', '02420'),
(1010, 2, 'Nauroy', '02420'),
(1011, 2, 'Bellenglise', '02420'),
(1012, 2, 'Aubencheul Aux Bois', '02420'),
(1013, 2, 'Gouy', '02420'),
(1014, 2, 'Lempire', '02420'),
(1015, 2, 'Lehaucourt', '02420'),
(1016, 2, 'Joncourt', '02420'),
(1017, 2, 'Estrees', '02420'),
(1018, 2, 'Hargicourt', '02420'),
(1019, 2, 'Sequehart', '02420'),
(1020, 2, 'Villeret', '02420'),
(1021, 2, 'Vendhuile', '02420'),
(1022, 2, 'Bellicourt', '02420'),
(1023, 2, 'Bony', '02420'),
(1024, 2, 'Le Catelet', '02420'),
(1025, 2, 'Gauchy', '02430'),
(1026, 2, 'Ly Fontaine', '02440'),
(1027, 2, 'Clastres', '02440'),
(1028, 2, 'Gibercourt', '02440'),
(1029, 2, 'Hinacourt', '02440'),
(1030, 2, 'Remigny', '02440'),
(1031, 2, 'Benay', '02440'),
(1032, 2, 'Montescourt Lizerolles', '02440'),
(1033, 2, 'Oisy', '02450'),
(1034, 2, 'Boue', '02450'),
(1035, 2, 'Dorengt', '02450'),
(1036, 2, 'La Neuville Les Dorengt', '02450'),
(1037, 2, 'Lavaqueresse', '02450'),
(1038, 2, 'Fesmy Le Sart', '02450'),
(1039, 2, 'Bergues Sur Sambre', '02450'),
(1040, 2, 'Fesmy Le Sart', '02450'),
(1041, 2, 'Silly La Poterie', '02460'),
(1042, 2, 'Troesnes', '02460'),
(1043, 2, 'La Ferte Milon', '02460'),
(1044, 2, 'La Ferte Milon', '02460'),
(1045, 2, 'Marizy St Mard', '02470'),
(1046, 2, 'Macogny', '02470'),
(1047, 2, 'Passy En Valois', '02470'),
(1048, 2, 'Marizy Ste Genevieve', '02470'),
(1049, 2, 'Priez', '02470'),
(1050, 2, 'Sommelans', '02470'),
(1051, 2, 'Dammard', '02470'),
(1052, 2, 'Monnes', '02470'),
(1053, 2, 'Neuilly St Front', '02470'),
(1054, 2, 'Pithon', '02480'),
(1055, 2, 'Sommette Eaucourt', '02480'),
(1056, 2, 'Bray St Christophe', '02480'),
(1057, 2, 'Dury', '02480'),
(1058, 2, 'Jussy', '02480'),
(1059, 2, 'Ollezy', '02480'),
(1060, 2, 'Cugny', '02480'),
(1061, 2, 'Artemps', '02480'),
(1062, 2, 'Annois', '02480'),
(1063, 2, 'Happencourt', '02480'),
(1064, 2, 'Caulaincourt', '02490'),
(1065, 2, 'Le Verguier', '02490'),
(1066, 2, 'Jeancourt', '02490'),
(1067, 2, 'Maissemy', '02490'),
(1068, 2, 'Pontruet', '02490'),
(1069, 2, 'Vendelles', '02490'),
(1070, 2, 'Attilly', '02490'),
(1071, 2, 'Vermand', '02490'),
(1072, 2, 'Trefcon', '02490'),
(1073, 2, 'Pontru', '02490'),
(1074, 2, 'Logny Les Aubenton', '02500'),
(1075, 2, 'La Herie', '02500'),
(1076, 2, 'Ohis', '02500'),
(1077, 2, 'Besmont', '02500'),
(1078, 2, 'Eparcy', '02500'),
(1079, 2, 'Beaume', '02500'),
(1080, 2, 'Neuve Maison', '02500'),
(1081, 2, 'Martigny', '02500'),
(1082, 2, 'Leuze', '02500'),
(1083, 2, 'Bucilly', '02500'),
(1084, 2, 'Buire', '02500'),
(1085, 2, 'Mondrepuis', '02500'),
(1086, 2, 'Hirson', '02500'),
(1087, 2, 'Effry', '02500'),
(1088, 2, 'Wimy', '02500'),
(1089, 2, 'Any Martin Rieux', '02500'),
(1090, 2, 'Aubenton', '02500'),
(1091, 2, 'Luzoir', '02500'),
(1092, 2, 'Etreux', '02510'),
(1093, 2, 'Venerolles', '02510'),
(1094, 2, 'Hannapes', '02510'),
(1095, 2, 'Iron', '02510'),
(1096, 2, 'Flavy Le Martel', '02520'),
(1097, 2, 'Dhuys Et Morin En Brie', '02540'),
(1098, 2, 'Dhuys Et Morin En Brie', '02540'),
(1099, 2, 'Vendieres', '02540'),
(1100, 2, 'Rozoy Bellevalle', '02540'),
(1101, 2, 'Dhuys Et Morin En Brie', '02540'),
(1102, 2, 'Montfaucon', '02540'),
(1103, 2, 'Viffort', '02540'),
(1104, 2, 'L Epine Aux Bois', '02540'),
(1105, 2, 'Viels Maisons', '02540'),
(1106, 2, 'Origny En Thierache', '02550'),
(1107, 2, 'Essises', '02570'),
(1108, 2, 'Chezy Sur Marne', '02570'),
(1109, 2, 'La Chapelle Sur Chezy', '02570'),
(1110, 2, 'Etreaupont', '02580'),
(1111, 2, 'Autreppes', '02580'),
(1112, 2, 'Sorbais', '02580'),
(1113, 2, 'Beauvois En Vermandois', '02590'),
(1114, 2, 'Aubigny Aux Kaisnes', '02590'),
(1115, 2, 'Germaine', '02590'),
(1116, 2, 'Roupy', '02590'),
(1117, 2, 'Villers St Christophe', '02590'),
(1118, 2, 'Savy', '02590'),
(1119, 2, 'Lanchy', '02590'),
(1120, 2, 'Douchy', '02590'),
(1121, 2, 'Fluquieres', '02590'),
(1122, 2, 'Vaux En Vermandois', '02590'),
(1123, 2, 'Etreillers', '02590'),
(1124, 2, 'Foreste', '02590'),
(1125, 2, 'Ancienville', '02600'),
(1126, 2, 'Retheuil', '02600'),
(1127, 2, 'Soucy', '02600'),
(1128, 2, 'Faverolles', '02600'),
(1129, 2, 'Cutry', '02600'),
(1130, 2, 'Haramont', '02600'),
(1131, 2, 'Villers Cotterets', '02600'),
(1132, 2, 'Vivieres', '02600'),
(1133, 2, 'Fleury', '02600'),
(1134, 2, 'Mortefontaine', '02600'),
(1135, 2, 'Montgobert', '02600'),
(1136, 2, 'Noroy Sur Ourcq', '02600'),
(1137, 2, 'Louatre', '02600'),
(1138, 2, 'Oigny En Valois', '02600'),
(1139, 2, 'Puiseux En Retz', '02600'),
(1140, 2, 'St Pierre Aigle', '02600'),
(1141, 2, 'Largny Sur Automne', '02600'),
(1142, 2, 'Laversine', '02600'),
(1143, 2, 'Longpont', '02600'),
(1144, 2, 'Coeuvres Et Valsery', '02600'),
(1145, 2, 'Coyolles', '02600'),
(1146, 2, 'Villers Cotterets', '02600'),
(1147, 2, 'Villers Helon', '02600'),
(1148, 2, 'Taillefontaine', '02600'),
(1149, 2, 'Corcy', '02600'),
(1150, 2, 'Dommiers', '02600'),
(1151, 2, 'Dampleux', '02600'),
(1152, 2, 'Moy De L Aisne', '02610'),
(1153, 2, 'Buironfosse', '02620'),
(1154, 2, 'Petit Verly', '02630'),
(1155, 2, 'Mennevret', '02630'),
(1156, 2, 'Wassigny', '02630'),
(1157, 2, 'St Simon', '02640'),
(1158, 2, 'Tugny Et Pont', '02640'),
(1159, 2, 'Fossoy', '02650'),
(1160, 2, 'Mezy Moulins', '02650'),
(1161, 2, 'Crezancy', '02650'),
(1162, 2, 'Champs', '02670'),
(1163, 2, 'Folembray', '02670'),
(1164, 2, 'Fontaine Les Clercs', '02680'),
(1165, 2, 'Castres', '02680'),
(1166, 2, 'Dallon', '02680'),
(1167, 2, 'Grugies', '02680'),
(1168, 2, 'Contescourt', '02680'),
(1169, 2, 'Essigny Le Grand', '02690'),
(1170, 2, 'Urvillers', '02690'),
(1171, 2, 'Mennessis', '02700'),
(1172, 2, 'Tergnier', '02700'),
(1173, 2, 'Servais', '02700'),
(1174, 2, 'Tergnier', '02700'),
(1175, 2, 'Condren', '02700'),
(1176, 2, 'Amigny Rouy', '02700'),
(1177, 2, 'Liez', '02700'),
(1178, 2, 'Tergnier', '02700'),
(1179, 2, 'Deuillet', '02700'),
(1180, 2, 'Tergnier', '02700'),
(1181, 2, 'Barisis Aux Bois', '02700'),
(1182, 2, 'Frieres Faillouel', '02700'),
(1183, 2, 'Marcy', '02720'),
(1184, 2, 'Homblieres', '02720'),
(1185, 2, 'Mesnil St Laurent', '02720'),
(1186, 2, 'Holnon', '02760'),
(1187, 2, 'Francilly Selency', '02760'),
(1188, 2, 'Seraucourt Le Grand', '02790'),
(1189, 2, 'Andelain', '02800'),
(1190, 2, 'La Fere', '02800'),
(1191, 2, 'Charmes', '02800'),
(1192, 2, 'Fressancourt', '02800'),
(1193, 2, 'Anguilcourt Le Sart', '02800'),
(1194, 2, 'Nouvion Le Comte', '02800'),
(1195, 2, 'Rogecourt', '02800'),
(1196, 2, 'Danizy', '02800'),
(1197, 2, 'Beautor', '02800'),
(1198, 2, 'Versigny', '02800'),
(1199, 2, 'Vendeuil', '02800'),
(1200, 2, 'Achery', '02800'),
(1201, 2, 'Bertaucourt Epourdon', '02800'),
(1202, 2, 'Courbes', '02800'),
(1203, 2, 'Mayot', '02800'),
(1204, 2, 'Travecy', '02800'),
(1205, 2, 'Licy Clignon', '02810'),
(1206, 2, 'Montigny L Allier', '02810'),
(1207, 2, 'Torcy En Valois', '02810'),
(1208, 2, 'St Gengoulph', '02810'),
(1209, 2, 'Courchamps', '02810'),
(1210, 2, 'Marigny En Orxois', '02810'),
(1211, 2, 'Brumetz', '02810'),
(1212, 2, 'Veuilly La Poterie', '02810'),
(1213, 2, 'Chezy En Orxois', '02810'),
(1214, 2, 'Bussiares', '02810'),
(1215, 2, 'Hautevesnes', '02810'),
(1216, 2, 'Gandelu', '02810'),
(1217, 2, 'Ste Croix', '02820'),
(1218, 2, 'Aubigny En Laonnois', '02820'),
(1219, 2, 'Goudelancourt Les Berrieux', '02820'),
(1220, 2, 'Courtrizy Et Fussigny', '02820'),
(1221, 2, 'Berrieux', '02820'),
(1222, 2, 'Corbeny', '02820'),
(1223, 2, 'Mauregny En Haye', '02820'),
(1224, 2, 'St Erme Outre Et Ramecourt', '02820'),
(1225, 2, 'St Thomas', '02820'),
(1226, 2, 'Aizelles', '02820'),
(1227, 2, 'Montaigu', '02820'),
(1228, 2, 'Watigny', '02830'),
(1229, 2, 'St Michel', '02830'),
(1230, 2, 'Athies Sous Laon', '02840'),
(1231, 2, 'Eppes', '02840'),
(1232, 2, 'Festieux', '02840'),
(1233, 2, 'Coucy Les Eppes', '02840'),
(1234, 2, 'Veslud', '02840'),
(1235, 2, 'Samoussy', '02840'),
(1236, 2, 'Monceau Le Waast', '02840'),
(1237, 2, 'Parfondru', '02840'),
(1238, 2, 'Barzy Sur Marne', '02850'),
(1239, 2, 'Passy Sur Marne', '02850'),
(1240, 2, 'Le Charmel', '02850'),
(1241, 2, 'Trelou Sur Marne', '02850'),
(1242, 2, 'Courtemont Varennes', '02850'),
(1243, 2, 'Jaulgonne', '02850'),
(1244, 2, 'Reuilly Sauvigny', '02850'),
(1245, 2, 'Presles Et Thierny', '02860'),
(1246, 2, 'Martigny Courpierre', '02860'),
(1247, 2, 'Montchalons', '02860'),
(1248, 2, 'Vorges', '02860'),
(1249, 2, 'Colligis Crandelain', '02860'),
(1250, 2, 'Chermizy Ailles', '02860'),
(1251, 2, 'Neuville Sur Ailette', '02860'),
(1252, 2, 'Laval En Laonnois', '02860'),
(1253, 2, 'Trucy', '02860'),
(1254, 2, 'Bouconville Vauclair', '02860'),
(1255, 2, 'Bruyeres Et Montberault', '02860'),
(1256, 2, 'Cerny En Laonnois', '02860'),
(1257, 2, 'Chamouille', '02860'),
(1258, 2, 'Cheret', '02860'),
(1259, 2, 'Nouvion Le Vineux', '02860'),
(1260, 2, 'Lierval', '02860'),
(1261, 2, 'Monthenault', '02860'),
(1262, 2, 'Bievres', '02860'),
(1263, 2, 'Arrancy', '02860'),
(1264, 2, 'Pancy Courtecon', '02860'),
(1265, 2, 'Orgeval', '02860'),
(1266, 2, 'Ployart Et Vaurseine', '02860'),
(1267, 2, 'Besny Et Loizy', '02870'),
(1268, 2, 'Bucy Les Cerny', '02870'),
(1269, 2, 'Cerny Les Bucy', '02870'),
(1270, 2, 'Vivaise', '02870'),
(1271, 2, 'Brie', '02870'),
(1272, 2, 'Crepy', '02870'),
(1273, 2, 'Fourdrain', '02870'),
(1274, 2, 'Chavigny', '02880'),
(1275, 2, 'Sancy Les Cheminots', '02880'),
(1276, 2, 'Nanteuil La Fosse', '02880'),
(1277, 2, 'Juvigny', '02880'),
(1278, 2, 'Chivres Val', '02880'),
(1279, 2, 'Bucy Le Long', '02880'),
(1280, 2, 'Crouy', '02880'),
(1281, 2, 'Missy Sur Aisne', '02880'),
(1282, 2, 'Laffaux', '02880'),
(1283, 2, 'Leury', '02880'),
(1284, 2, 'Vregny', '02880'),
(1285, 2, 'Terny Sorny', '02880'),
(1286, 2, 'Braye', '02880'),
(1287, 2, 'Margival', '02880'),
(1288, 2, 'Vuillery', '02880'),
(1289, 2, 'Clamecy', '02880'),
(1290, 2, 'Cuffies', '02880'),
(1291, 2, 'Neuville Sur Margival', '02880'),
(1292, 3, 'Coulandon', '03000'),
(1293, 3, 'Avermes', '03000'),
(1294, 3, 'Montilly', '03000'),
(1295, 3, 'Moulins', '03000'),
(1296, 3, 'Neuvy', '03000'),
(1297, 3, 'Bressolles', '03000'),
(1298, 3, 'Lavault Ste Anne', '03100'),
(1299, 3, 'Montlucon', '03100'),
(1300, 3, 'Charmeil', '03110'),
(1301, 3, 'Vendat', '03110'),
(1302, 3, 'St Pont', '03110'),
(1303, 3, 'Espinasse Vozelle', '03110'),
(1304, 3, 'Brout Vernet', '03110'),
(1305, 3, 'Cognat Lyonne', '03110'),
(1306, 3, 'Escurolles', '03110'),
(1307, 3, 'St Remy En Rollat', '03110'),
(1308, 3, 'St Didier La Foret', '03110'),
(1309, 3, 'Droiturier', '03120'),
(1310, 3, 'Chatelus', '03120'),
(1311, 3, 'Servilly', '03120'),
(1312, 3, 'Le Breuil', '03120'),
(1313, 3, 'Billezois', '03120'),
(1314, 3, 'Barrais Bussolles', '03120'),
(1315, 3, 'Andelaroche', '03120'),
(1316, 3, 'Arfeuilles', '03120'),
(1317, 3, 'St Prix', '03120'),
(1318, 3, 'Lapalisse', '03120'),
(1319, 3, 'Isserpent', '03120'),
(1320, 3, 'St Christophe', '03120'),
(1321, 3, 'Perigny', '03120'),
(1322, 3, 'Le Bouchaud', '03130'),
(1323, 3, 'St Leger Sur Vouzance', '03130'),
(1324, 3, 'Luneau', '03130'),
(1325, 3, 'Montcombroux Les Mines', '03130'),
(1326, 3, 'Neuilly En Donjon', '03130'),
(1327, 3, 'St Didier En Donjon', '03130'),
(1328, 3, 'Avrilly', '03130'),
(1329, 3, 'Le Donjon', '03130'),
(1330, 3, 'Loddes', '03130'),
(1331, 3, 'Liernolles', '03130'),
(1332, 3, 'Bert', '03130'),
(1333, 3, 'Le Pin', '03130'),
(1334, 3, 'Lenax', '03130'),
(1335, 3, 'Montaiguet En Forez', '03130'),
(1336, 3, 'Chantelle', '03140'),
(1337, 3, 'Barberier', '03140'),
(1338, 3, 'Ussel D Allier', '03140'),
(1339, 3, 'Taxat Senat', '03140'),
(1340, 3, 'Target', '03140'),
(1341, 3, 'Etroussat', '03140'),
(1342, 3, 'Fleuriel', '03140'),
(1343, 3, 'Monestier', '03140'),
(1344, 3, 'Voussac', '03140'),
(1345, 3, 'St Germain De Salles', '03140'),
(1346, 3, 'Chareil Cintrat', '03140'),
(1347, 3, 'Deneuille Les Chantelle', '03140'),
(1348, 3, 'Charroux', '03140'),
(1349, 3, 'Fourilles', '03140'),
(1350, 3, 'Chezelle', '03140'),
(1351, 3, 'Varennes Sur Allier', '03150'),
(1352, 3, 'Montaigu Le Blin', '03150'),
(1353, 3, 'Langy', '03150'),
(1354, 3, 'Bouce', '03150'),
(1355, 3, 'St Gerand Le Puy', '03150'),
(1356, 3, 'Crechy', '03150'),
(1357, 3, 'St Loup', '03150'),
(1358, 3, 'Sanssat', '03150'),
(1359, 3, 'Montoldre', '03150'),
(1360, 3, 'Rongeres', '03150'),
(1361, 3, 'Ygrande', '03160'),
(1362, 3, 'St Leopardin D Augy', '03160'),
(1363, 3, 'St Aubin Le Monial', '03160'),
(1364, 3, 'Bourbon L Archambault', '03160'),
(1365, 3, 'Franchesse', '03160'),
(1366, 3, 'Couzon', '03160'),
(1367, 3, 'St Plaisir', '03160'),
(1368, 3, 'Chamblet', '03170'),
(1369, 3, 'Bizeneuille', '03170'),
(1370, 3, 'Bezenet', '03170'),
(1371, 3, 'St Angel', '03170'),
(1372, 3, 'Deneuille Les Mines', '03170'),
(1373, 3, 'Doyet', '03170'),
(1374, 3, 'Montvicq', '03170'),
(1375, 3, 'Audes', '03190'),
(1376, 3, 'Venas', '03190'),
(1377, 3, 'Estivareilles', '03190'),
(1378, 3, 'Haut Bocage', '03190'),
(1379, 3, 'Nassigny', '03190'),
(1380, 3, 'Vallon En Sully', '03190'),
(1381, 3, 'St Caprais', '03190'),
(1382, 3, 'Haut Bocage', '03190'),
(1383, 3, 'Herisson', '03190'),
(1384, 3, 'Haut Bocage', '03190'),
(1385, 3, 'Reugny', '03190'),
(1386, 3, 'Verneix', '03190'),
(1387, 3, 'Vaux', '03190'),
(1388, 3, 'Le Vernet', '03200'),
(1389, 3, 'Abrest', '03200'),
(1390, 3, 'Vichy', '03200'),
(1391, 3, 'Agonges', '03210'),
(1392, 3, 'Bresnay', '03210'),
(1393, 3, 'St Menoux', '03210'),
(1394, 3, 'Gipcy', '03210'),
(1395, 3, 'Meillers', '03210'),
(1396, 3, 'Autry Issards', '03210'),
(1397, 3, 'Marigny', '03210'),
(1398, 3, 'Souvigny', '03210'),
(1399, 3, 'Chemilly', '03210'),
(1400, 3, 'Besson', '03210'),
(1401, 3, 'Noyant D Allier', '03210'),
(1402, 3, 'Chatillon', '03210'),
(1403, 3, 'Cindre', '03220'),
(1404, 3, 'Treteau', '03220'),
(1405, 3, 'Varennes Sur Teche', '03220'),
(1406, 3, 'Chatelperron', '03220'),
(1407, 3, 'Chavroches', '03220'),
(1408, 3, 'Jaligny Sur Besbre', '03220'),
(1409, 3, 'St Leon', '03220'),
(1410, 3, 'Thionne', '03220'),
(1411, 3, 'Vaumas', '03220'),
(1412, 3, 'St Voir', '03220'),
(1413, 3, 'Sorbier', '03220'),
(1414, 3, 'Trezelles', '03220'),
(1415, 3, 'La Chapelle Aux Chasses', '03230'),
(1416, 3, 'Chevagnes', '03230'),
(1417, 3, 'Thiel Sur Acolin', '03230'),
(1418, 3, 'Gannay Sur Loire', '03230'),
(1419, 3, 'St Martin Des Lais', '03230'),
(1420, 3, 'Beaulon', '03230'),
(1421, 3, 'Garnat Sur Engievre', '03230'),
(1422, 3, 'Paray Le Fresil', '03230'),
(1423, 3, 'Lusigny', '03230'),
(1424, 3, 'Chezy', '03230'),
(1425, 3, 'St Sornin', '03240'),
(1426, 3, 'Le Montet', '03240'),
(1427, 3, 'Rocles', '03240'),
(1428, 3, 'Tronget', '03240'),
(1429, 3, 'Deux Chaises', '03240'),
(1430, 3, 'Le Theil', '03240'),
(1431, 3, 'Treban', '03240'),
(1432, 3, 'Cressanges', '03240'),
(1433, 3, 'St Nicolas Des Biefs', '03250'),
(1434, 3, 'Laprugne', '03250'),
(1435, 3, 'Le Mayet De Montagne', '03250'),
(1436, 3, 'Nizerolles', '03250'),
(1437, 3, 'Ferrieres Sur Sichon', '03250'),
(1438, 3, 'Arronnes', '03250'),
(1439, 3, 'La Chabanne', '03250'),
(1440, 3, 'Chatel Montagne', '03250'),
(1441, 3, 'Lavoine', '03250'),
(1442, 3, 'St Clement', '03250'),
(1443, 3, 'La Guillermie', '03250'),
(1444, 3, 'St Germain Des Fosses', '03260'),
(1445, 3, 'Marcenat', '03260'),
(1446, 3, 'Seuillet', '03260'),
(1447, 3, 'Billy', '03260'),
(1448, 3, 'Magnet', '03260'),
(1449, 3, 'St Felix', '03260'),
(1450, 3, 'Mariol', '03270'),
(1451, 3, 'Busset', '03270'),
(1452, 3, 'Hauterive', '03270'),
(1453, 3, 'St Yorre', '03270'),
(1454, 3, 'Dompierre Sur Besbre', '03290'),
(1455, 3, 'Diou', '03290'),
(1456, 3, 'St Pourcain Sur Besbre', '03290'),
(1457, 3, 'Creuzier Le Vieux', '03300'),
(1458, 3, 'Molles', '03300'),
(1459, 3, 'La Chapelle', '03300'),
(1460, 3, 'Bost', '03300'),
(1461, 3, 'Creuzier Le Neuf', '03300'),
(1462, 3, 'Cusset', '03300'),
(1463, 3, 'St Etienne De Vicq', '03300'),
(1464, 3, 'Neris Les Bains', '03310'),
(1465, 3, 'St Genest', '03310'),
(1466, 3, 'Durdat Larequille', '03310'),
(1467, 3, 'Villebret', '03310'),
(1468, 3, 'Pouzy Mesangy', '03320'),
(1469, 3, 'Couleuvre', '03320'),
(1470, 3, 'Chateau Sur Allier', '03320'),
(1471, 3, 'Limoise', '03320'),
(1472, 3, 'Le Veurdre', '03320'),
(1473, 3, 'Neure', '03320'),
(1474, 3, 'Lurcy Levis', '03320'),
(1475, 3, 'Bellenaves', '03330'),
(1476, 3, 'Louroux De Bouble', '03330'),
(1477, 3, 'Valignat', '03330'),
(1478, 3, 'Naves', '03330'),
(1479, 3, 'Echassieres', '03330'),
(1480, 3, 'Chirat L Eglise', '03330'),
(1481, 3, 'Coutansouze', '03330'),
(1482, 3, 'Neuilly Le Real', '03340'),
(1483, 3, 'La Ferte Hauterive', '03340'),
(1484, 3, 'Mercy', '03340'),
(1485, 3, 'Gouise', '03340'),
(1486, 3, 'Bessay Sur Allier', '03340'),
(1487, 3, 'St Gerand De Vaux', '03340'),
(1488, 3, 'Chapeau', '03340'),
(1489, 3, 'Montbeugny', '03340'),
(1490, 3, 'Cerilly', '03350'),
(1491, 3, 'Le Brethon', '03350'),
(1492, 3, 'Louroux Bourbonnais', '03350'),
(1493, 3, 'Le Vilhain', '03350'),
(1494, 3, 'Theneuille', '03350'),
(1495, 3, 'Braize', '03360'),
(1496, 3, 'Urcay', '03360'),
(1497, 3, 'Meaulne', '03360'),
(1498, 3, 'Valigny', '03360'),
(1499, 3, 'Ainay Le Chateau', '03360'),
(1500, 3, 'Isle Et Bardais', '03360'),
(1501, 3, 'Vitray', '03360'),
(1502, 3, 'Letelon', '03360'),
(1503, 3, 'St Bonnet Troncais', '03360'),
(1504, 3, 'Viplaix', '03370'),
(1505, 3, 'St Desire', '03370'),
(1506, 3, 'Chamberat', '03370'),
(1507, 3, 'Chazemais', '03370'),
(1508, 3, 'Courcais', '03370'),
(1509, 3, 'St Eloy D Allier', '03370'),
(1510, 3, 'St Palais', '03370'),
(1511, 3, 'Mesples', '03370'),
(1512, 3, 'St Sauvier', '03370'),
(1513, 3, 'Archignat', '03380'),
(1514, 3, 'St Martinien', '03380'),
(1515, 3, 'Huriel', '03380'),
(1516, 3, 'Lamaids', '03380'),
(1517, 3, 'La Chapelaude', '03380'),
(1518, 3, 'Quinssaines', '03380'),
(1519, 3, 'Treignat', '03380'),
(1520, 3, 'Beaune D Allier', '03390'),
(1521, 3, 'St Priest En Murat', '03390'),
(1522, 3, 'St Bonnet De Four', '03390'),
(1523, 3, 'Montmarault', '03390'),
(1524, 3, 'Murat', '03390'),
(1525, 3, 'Blomard', '03390'),
(1526, 3, 'Sazeret', '03390'),
(1527, 3, 'Chappes', '03390'),
(1528, 3, 'St Marcel En Murat', '03390'),
(1529, 3, 'Vernusse', '03390'),
(1530, 3, 'St Ennemond', '03400'),
(1531, 3, 'Gennetines', '03400'),
(1532, 3, 'Yzeure', '03400'),
(1533, 3, 'Toulon Sur Allier', '03400'),
(1534, 3, 'St Victor', '03410'),
(1535, 3, 'Domerat', '03410'),
(1536, 3, 'Lignerolles', '03410'),
(1537, 3, 'Premilhat', '03410');
INSERT INTO `cookiejar_town` (`id`, `department_id`, `name`, `postalCode`) VALUES
(1538, 3, 'Teillet Argenty', '03410'),
(1539, 3, 'Ste Therence', '03420'),
(1540, 3, 'La Petite Marche', '03420'),
(1541, 3, 'Mazirat', '03420'),
(1542, 3, 'St Fargeol', '03420'),
(1543, 3, 'Ronnet', '03420'),
(1544, 3, 'Marcillat En Combraille', '03420'),
(1545, 3, 'Arpheuilles St Priest', '03420'),
(1546, 3, 'St Marcel En Marcillat', '03420'),
(1547, 3, 'Terjat', '03420'),
(1548, 3, 'Cosne D Allier', '03430'),
(1549, 3, 'Villefranche D Allier', '03430'),
(1550, 3, 'Villefranche D Allier', '03430'),
(1551, 3, 'Tortezais', '03430'),
(1552, 3, 'Vieure', '03430'),
(1553, 3, 'Sauvagny', '03430'),
(1554, 3, 'St Hilaire', '03440'),
(1555, 3, 'Buxieres Les Mines', '03440'),
(1556, 3, 'Chavenon', '03440'),
(1557, 3, 'Chouvigny', '03450'),
(1558, 3, 'Lalizolle', '03450'),
(1559, 3, 'Sussat', '03450'),
(1560, 3, 'Vicq', '03450'),
(1561, 3, 'Ebreuil', '03450'),
(1562, 3, 'Nades', '03450'),
(1563, 3, 'Veauce', '03450'),
(1564, 3, 'Bagneux', '03460'),
(1565, 3, 'Villeneuve Sur Allier', '03460'),
(1566, 3, 'Aubigny', '03460'),
(1567, 3, 'Aurouer', '03460'),
(1568, 3, 'Trevol', '03460'),
(1569, 3, 'Saligny Sur Roudon', '03470'),
(1570, 3, 'Pierrefitte Sur Loire', '03470'),
(1571, 3, 'Monetay Sur Loire', '03470'),
(1572, 3, 'Coulanges', '03470'),
(1573, 3, 'St Pourcain Sur Sioule', '03500'),
(1574, 3, 'Montord', '03500'),
(1575, 3, 'Lafeline', '03500'),
(1576, 3, 'Meillard', '03500'),
(1577, 3, 'Loriges', '03500'),
(1578, 3, 'Monetay Sur Allier', '03500'),
(1579, 3, 'Chatel De Neuvre', '03500'),
(1580, 3, 'Contigny', '03500'),
(1581, 3, 'Cesset', '03500'),
(1582, 3, 'Bayet', '03500'),
(1583, 3, 'Bransat', '03500'),
(1584, 3, 'Louchy Montfand', '03500'),
(1585, 3, 'Paray Sous Briailles', '03500'),
(1586, 3, 'Saulcet', '03500'),
(1587, 3, 'Verneuil En Bourbonnais', '03500'),
(1588, 3, 'Molinet', '03510'),
(1589, 3, 'Chassenard', '03510'),
(1590, 3, 'Hyds', '03600'),
(1591, 3, 'Louroux De Beaune', '03600'),
(1592, 3, 'Commentry', '03600'),
(1593, 3, 'Colombier', '03600'),
(1594, 3, 'La Celle', '03600'),
(1595, 3, 'Malicorne', '03600'),
(1596, 3, 'Desertines', '03630'),
(1597, 3, 'Serbannes', '03700'),
(1598, 3, 'Brugheas', '03700'),
(1599, 3, 'Bellerive Sur Allier', '03700'),
(1600, 3, 'Le Mayet D Ecole', '03800'),
(1601, 3, 'Mazerier', '03800'),
(1602, 3, 'Poezat', '03800'),
(1603, 3, 'Saulzet', '03800'),
(1604, 3, 'Biozat', '03800'),
(1605, 3, 'Begues', '03800'),
(1606, 3, 'St Priest D Andelot', '03800'),
(1607, 3, 'Gannat', '03800'),
(1608, 3, 'Jenzat', '03800'),
(1609, 3, 'Charmes', '03800'),
(1610, 3, 'Monteignet Sur L Andelot', '03800'),
(1611, 3, 'St Bonnet De Rochefort', '03800'),
(1612, 4, 'La Robine Sur Galabre', '04000'),
(1613, 4, 'Digne Les Bains', '04000'),
(1614, 4, 'La Javie', '04000'),
(1615, 4, 'La Robine Sur Galabre', '04000'),
(1616, 4, 'Digne Les Bains', '04000'),
(1617, 4, 'La Robine Sur Galabre', '04000'),
(1618, 4, 'Entrages', '04000'),
(1619, 4, 'La Robine Sur Galabre', '04000'),
(1620, 4, 'Manosque', '04100'),
(1621, 4, 'Aubenas Les Alpes', '04110'),
(1622, 4, 'Reillanne', '04110'),
(1623, 4, 'Oppedette', '04110'),
(1624, 4, 'Ste Croix A Lauze', '04110'),
(1625, 4, 'Vacheres', '04110'),
(1626, 4, 'Montjustin', '04110'),
(1627, 4, 'Montfuron', '04110'),
(1628, 4, 'Villemus', '04110'),
(1629, 4, 'Castellane', '04120'),
(1630, 4, 'Castellane', '04120'),
(1631, 4, 'Castellane', '04120'),
(1632, 4, 'Peyroules', '04120'),
(1633, 4, 'Rougon', '04120'),
(1634, 4, 'La Palud Sur Verdon', '04120'),
(1635, 4, 'Castellane', '04120'),
(1636, 4, 'Castellane', '04120'),
(1637, 4, 'Demandolx', '04120'),
(1638, 4, 'La Garde', '04120'),
(1639, 4, 'Soleilhas', '04120'),
(1640, 4, 'Castellane', '04120'),
(1641, 4, 'La Palud Sur Verdon', '04120'),
(1642, 4, 'Volx', '04130'),
(1643, 4, 'Verdaches', '04140'),
(1644, 4, 'St Martin Les Seyne', '04140'),
(1645, 4, 'Montclar', '04140'),
(1646, 4, 'Le Vernet', '04140'),
(1647, 4, 'Seyne', '04140'),
(1648, 4, 'Selonnet', '04140'),
(1649, 4, 'Barles', '04140'),
(1650, 4, 'Auzet', '04140'),
(1651, 4, 'Revest Des Brousses', '04150'),
(1652, 4, 'Redortiers', '04150'),
(1653, 4, 'Simiane La Rotonde', '04150'),
(1654, 4, 'Banon', '04150'),
(1655, 4, 'La Rochegiron', '04150'),
(1656, 4, 'Montsalier', '04150'),
(1657, 4, 'Simiane La Rotonde', '04150'),
(1658, 4, 'Saumane', '04150'),
(1659, 4, 'Revest Du Bion', '04150'),
(1660, 4, 'Simiane La Rotonde', '04150'),
(1661, 4, 'L Hospitalet', '04150'),
(1662, 4, 'Chateau Arnoux St Auban', '04160'),
(1663, 4, 'L Escale', '04160'),
(1664, 4, 'La Mure Argens', '04170'),
(1665, 4, 'Thorame Haute', '04170'),
(1666, 4, 'Thorame Haute', '04170'),
(1667, 4, 'Lambruisse', '04170'),
(1668, 4, 'St Andre Les Alpes', '04170'),
(1669, 4, 'Angles', '04170'),
(1670, 4, 'La Mure Argens', '04170'),
(1671, 4, 'Thorame Basse', '04170'),
(1672, 4, 'Vergons', '04170'),
(1673, 4, 'Allons', '04170'),
(1674, 4, 'Moriez', '04170'),
(1675, 4, 'St Julien Du Verdon', '04170'),
(1676, 4, 'Villeneuve', '04180'),
(1677, 4, 'Les Mees', '04190'),
(1678, 4, 'Noyers Sur Jabron', '04200'),
(1679, 4, 'Valernes', '04200'),
(1680, 4, 'Theze', '04200'),
(1681, 4, 'Bevons', '04200'),
(1682, 4, 'Peipin', '04200'),
(1683, 4, 'Authon', '04200'),
(1684, 4, 'Curel', '04200'),
(1685, 4, 'St Vincent Sur Jabron', '04200'),
(1686, 4, 'Vaumeilh', '04200'),
(1687, 4, 'Valbelle', '04200'),
(1688, 4, 'Chateauneuf Val St Donat', '04200'),
(1689, 4, 'Chateauneuf Miravail', '04200'),
(1690, 4, 'Entrepierres', '04200'),
(1691, 4, 'Aubignosc', '04200'),
(1692, 4, 'Peipin', '04200'),
(1693, 4, 'Les Omergues', '04200'),
(1694, 4, 'St Geniez', '04200'),
(1695, 4, 'Sisteron', '04200'),
(1696, 4, 'Sigoyer', '04200'),
(1697, 4, 'Entrepierres', '04200'),
(1698, 4, 'Entrepierres', '04200'),
(1699, 4, 'Mison', '04200'),
(1700, 4, 'Brunet', '04210'),
(1701, 4, 'Valensole', '04210'),
(1702, 4, 'Corbieres', '04220'),
(1703, 4, 'Ste Tulle', '04220'),
(1704, 4, 'Montlaux', '04230'),
(1705, 4, 'Ongles', '04230'),
(1706, 4, 'St Etienne Les Orgues', '04230'),
(1707, 4, 'Revest St Martin', '04230'),
(1708, 4, 'Cruis', '04230'),
(1709, 4, 'Fontienne', '04230'),
(1710, 4, 'Lardiers', '04230'),
(1711, 4, 'Mallefougasse Auges', '04230'),
(1712, 4, 'Braux', '04240'),
(1713, 4, 'Ubraye', '04240'),
(1714, 4, 'Le Fugeret', '04240'),
(1715, 4, 'St Benoit', '04240'),
(1716, 4, 'Meailles', '04240'),
(1717, 4, 'Annot', '04240'),
(1718, 4, 'Bayons', '04250'),
(1719, 4, 'Melve', '04250'),
(1720, 4, 'Faucon Du Caire', '04250'),
(1721, 4, 'Chateaufort', '04250'),
(1722, 4, 'Bayons', '04250'),
(1723, 4, 'Nibles', '04250'),
(1724, 4, 'Clamensane', '04250'),
(1725, 4, 'Le Caire', '04250'),
(1726, 4, 'Turriers', '04250'),
(1727, 4, 'Bayons', '04250'),
(1728, 4, 'Bayons', '04250'),
(1729, 4, 'La Motte Du Caire', '04250'),
(1730, 4, 'Gigors', '04250'),
(1731, 4, 'Bellaffaire', '04250'),
(1732, 4, 'Valavoire', '04250'),
(1733, 4, 'Allos', '04260'),
(1734, 4, 'Allos', '04260'),
(1735, 4, 'Chateauredon', '04270'),
(1736, 4, 'Senez', '04270'),
(1737, 4, 'Majastres', '04270'),
(1738, 4, 'St Jeannet', '04270'),
(1739, 4, 'Mezel', '04270'),
(1740, 4, 'Estoublon', '04270'),
(1741, 4, 'Entrages', '04270'),
(1742, 4, 'Estoublon', '04270'),
(1743, 4, 'St Julien D Asse', '04270'),
(1744, 4, 'Bras D Asse', '04270'),
(1745, 4, 'Beynes', '04270'),
(1746, 4, 'Cereste', '04280'),
(1747, 4, 'Sourribes', '04290'),
(1748, 4, 'Volonne', '04290'),
(1749, 4, 'Salignac', '04290'),
(1750, 4, 'Dauphin', '04300'),
(1751, 4, 'Pierrerue', '04300'),
(1752, 4, 'Sigonce', '04300'),
(1753, 4, 'Mane', '04300'),
(1754, 4, 'Niozelles', '04300'),
(1755, 4, 'Limans', '04300'),
(1756, 4, 'St Maime', '04300'),
(1757, 4, 'Forcalquier', '04300'),
(1758, 4, 'St Martin Les Eaux', '04300'),
(1759, 4, 'Peyruis', '04310'),
(1760, 4, 'Ganagobie', '04310'),
(1761, 4, 'Val De Chalvagne', '04320'),
(1762, 4, 'Castellet Les Sausses', '04320'),
(1763, 4, 'Val De Chalvagne', '04320'),
(1764, 4, 'Entrevaux', '04320'),
(1765, 4, 'Sausses', '04320'),
(1766, 4, 'Val De Chalvagne', '04320'),
(1767, 4, 'Clumanc', '04330'),
(1768, 4, 'Chaudon Norante', '04330'),
(1769, 4, 'St Lions', '04330'),
(1770, 4, 'Blieux', '04330'),
(1771, 4, 'St Jacques', '04330'),
(1772, 4, 'Tartonne', '04330'),
(1773, 4, 'Barreme', '04330'),
(1774, 4, 'Senez', '04330'),
(1775, 4, 'Meolans Revel', '04340'),
(1776, 4, 'Meolans Revel', '04340'),
(1777, 4, 'St Vincent Les Forts', '04340'),
(1778, 4, 'La Breole', '04340'),
(1779, 4, 'Le Lauzet Ubaye', '04340'),
(1780, 4, 'Meolans Revel', '04340'),
(1781, 4, 'Malijai', '04350'),
(1782, 4, 'Moustiers Ste Marie', '04360'),
(1783, 4, 'Villars Colmars', '04370'),
(1784, 4, 'Beauvezer', '04370'),
(1785, 4, 'Colmars', '04370'),
(1786, 4, 'Hautes Duyes', '04380'),
(1787, 4, 'Barras', '04380'),
(1788, 4, 'Thoard', '04380'),
(1789, 4, 'Thoard', '04380'),
(1790, 4, 'Le Castellard Melan', '04380'),
(1791, 4, 'Le Castellard Melan', '04380'),
(1792, 4, 'Hautes Duyes', '04380'),
(1793, 4, 'Les Thuiles', '04400'),
(1794, 4, 'Enchastrayes', '04400'),
(1795, 4, 'Faucon De Barcelonnette', '04400'),
(1796, 4, 'Uvernet Fours', '04400'),
(1797, 4, 'Barcelonnette', '04400'),
(1798, 4, 'Enchastrayes', '04400'),
(1799, 4, 'Uvernet Fours', '04400'),
(1800, 4, 'Uvernet Fours', '04400'),
(1801, 4, 'St Pons', '04400'),
(1802, 4, 'Puimoisson', '04410'),
(1803, 4, 'St Jurs', '04410'),
(1804, 4, 'Prads Haute Bleone', '04420'),
(1805, 4, 'Prads Haute Bleone', '04420'),
(1806, 4, 'Le Brusquet', '04420'),
(1807, 4, 'Archail', '04420'),
(1808, 4, 'Beaujeu', '04420'),
(1809, 4, 'Prads Haute Bleone', '04420'),
(1810, 4, 'La Javie', '04420'),
(1811, 4, 'Draix', '04420'),
(1812, 4, 'Marcoux', '04420'),
(1813, 4, 'Allemagne En Provence', '04500'),
(1814, 4, 'Riez', '04500'),
(1815, 4, 'Montagnac Montpezat', '04500'),
(1816, 4, 'Roumoules', '04500'),
(1817, 4, 'Quinson', '04500'),
(1818, 4, 'St Laurent Du Verdon', '04500'),
(1819, 4, 'Ste Croix Du Verdon', '04500'),
(1820, 4, 'Montagnac Montpezat', '04500'),
(1821, 4, 'Le Chaffaut St Jurson', '04510'),
(1822, 4, 'Mallemoisson', '04510'),
(1823, 4, 'Aiglun', '04510'),
(1824, 4, 'Mirabeau', '04510'),
(1825, 4, 'Le Chaffaut St Jurson', '04510'),
(1826, 4, 'Malijai', '04510'),
(1827, 4, 'St Paul Sur Ubaye', '04530'),
(1828, 4, 'Val D Oronaye', '04530'),
(1829, 4, 'Val D Oronaye', '04530'),
(1830, 4, 'La Condamine Chatelard', '04530'),
(1831, 4, 'La Condamine Chatelard', '04530'),
(1832, 4, 'Montfort', '04600'),
(1833, 4, 'Chateau Arnoux St Auban', '04600'),
(1834, 4, 'Champtercier', '04660'),
(1835, 4, 'Oraison', '04700'),
(1836, 4, 'Le Castellet', '04700'),
(1837, 4, 'Entrevennes', '04700'),
(1838, 4, 'Lurs', '04700'),
(1839, 4, 'Puimichel', '04700'),
(1840, 4, 'La Brillanne', '04700'),
(1841, 4, 'Esparron De Verdon', '04800'),
(1842, 4, 'Greoux Les Bains', '04800'),
(1843, 4, 'St Martin De Bromes', '04800'),
(1844, 4, 'Esparron De Verdon', '04800'),
(1845, 4, 'Jausiers', '04850'),
(1846, 4, 'Pierrevert', '04860'),
(1847, 4, 'St Michel L Observatoire', '04870'),
(1848, 4, 'St Michel L Observatoire', '04870'),
(1849, 5, 'Gap', '05000'),
(1850, 5, 'La Batie Vieille', '05000'),
(1851, 5, 'La Freissinouse', '05000'),
(1852, 5, 'Rambaud', '05000'),
(1853, 5, 'La Rochette', '05000'),
(1854, 5, 'Pelleautier', '05000'),
(1855, 5, 'Neffes', '05000'),
(1856, 5, 'Gap', '05000'),
(1857, 5, 'Chateauvieux', '05000'),
(1858, 5, 'Villar St Pancrace', '05100'),
(1859, 5, 'Nevache', '05100'),
(1860, 5, 'Puy St Andre', '05100'),
(1861, 5, 'Val Des Pres', '05100'),
(1862, 5, 'Montgenevre', '05100'),
(1863, 5, 'Puy St Pierre', '05100'),
(1864, 5, 'Cervieres', '05100'),
(1865, 5, 'Briancon', '05100'),
(1866, 5, 'Vitrolles', '05110'),
(1867, 5, 'Lardier Et Valenca', '05110'),
(1868, 5, 'Barcillonnette', '05110'),
(1869, 5, 'Claret', '05110'),
(1870, 5, 'Esparron', '05110'),
(1871, 5, 'Curbans', '05110'),
(1872, 5, 'Monetier Allemont', '05110'),
(1873, 5, 'La Saulce', '05110'),
(1874, 5, 'Les Vigneaux', '05120'),
(1875, 5, 'St Martin De Queyrieres', '05120'),
(1876, 5, 'L Argentiere La Bessee', '05120'),
(1877, 5, 'Valserres', '05130'),
(1878, 5, 'Fouillouse', '05130'),
(1879, 5, 'Piegut', '05130'),
(1880, 5, 'Lettret', '05130'),
(1881, 5, 'St Etienne Le Laus', '05130'),
(1882, 5, 'Sigoyer', '05130'),
(1883, 5, 'Jarjayes', '05130'),
(1884, 5, 'Venterol', '05130'),
(1885, 5, 'Tallard', '05130'),
(1886, 5, 'La Haute Beaume', '05140'),
(1887, 5, 'St Julien En Beauchene', '05140'),
(1888, 5, 'La Faurie', '05140'),
(1889, 5, 'La Beaume', '05140'),
(1890, 5, 'Aspres Sur Buech', '05140'),
(1891, 5, 'Montbrand', '05140'),
(1892, 5, 'Aspremont', '05140'),
(1893, 5, 'St Pierre D Argencon', '05140'),
(1894, 5, 'Montjay', '05150'),
(1895, 5, 'Sorbiers', '05150'),
(1896, 5, 'Moydans', '05150'),
(1897, 5, 'St Andre De Rosans', '05150'),
(1898, 5, 'Ste Marie', '05150'),
(1899, 5, 'Ribeyret', '05150'),
(1900, 5, 'Rosans', '05150'),
(1901, 5, 'Bruis', '05150'),
(1902, 5, 'Montmorin', '05150'),
(1903, 5, 'Savines Le Lac', '05160'),
(1904, 5, 'Pontis', '05160'),
(1905, 5, 'St Apollinaire', '05160'),
(1906, 5, 'Le Sauze Du Lac', '05160'),
(1907, 5, 'Reallon', '05160'),
(1908, 5, 'Orcieres', '05170'),
(1909, 5, 'Orcieres', '05170'),
(1910, 5, 'Rochebrune', '05190'),
(1911, 5, 'Rousset', '05190'),
(1912, 5, 'Breziers', '05190'),
(1913, 5, 'Espinasses', '05190'),
(1914, 5, 'Remollon', '05190'),
(1915, 5, 'Theus', '05190'),
(1916, 5, 'St Andre D Embrun', '05200'),
(1917, 5, 'St Sauveur', '05200'),
(1918, 5, 'Puy St Eusebe', '05200'),
(1919, 5, 'Puy Sanieres', '05200'),
(1920, 5, 'Embrun', '05200'),
(1921, 5, 'Les Orres', '05200'),
(1922, 5, 'Crots', '05200'),
(1923, 5, 'Crevoux', '05200'),
(1924, 5, 'Baratier', '05200'),
(1925, 5, 'Le Monetier Les Bains', '05220'),
(1926, 5, 'Montgardin', '05230'),
(1927, 5, 'La Batie Neuve', '05230'),
(1928, 5, 'Avancon', '05230'),
(1929, 5, 'Chorges', '05230'),
(1930, 5, 'Prunieres', '05230'),
(1931, 5, 'La Salle Les Alpes', '05240'),
(1932, 5, 'Le Devoluy', '05250'),
(1933, 5, 'Le Devoluy', '05250'),
(1934, 5, 'Le Devoluy', '05250'),
(1935, 5, 'Le Devoluy', '05250'),
(1936, 5, 'Le Devoluy', '05250'),
(1937, 5, 'Chabottes', '05260'),
(1938, 5, 'St Michel De Chaillol', '05260'),
(1939, 5, 'St Leger Les Melezes', '05260'),
(1940, 5, 'Forest St Julien', '05260'),
(1941, 5, 'Champoleon', '05260'),
(1942, 5, 'Ancelle', '05260'),
(1943, 5, 'St Jean St Nicolas', '05260'),
(1944, 5, 'St Jean St Nicolas', '05260'),
(1945, 5, 'Puy St Vincent', '05290'),
(1946, 5, 'Vallouise', '05290'),
(1947, 5, 'Salerans', '05300'),
(1948, 5, 'Val Buech Meouge', '05300'),
(1949, 5, 'Saleon', '05300'),
(1950, 5, 'Ventavon', '05300'),
(1951, 5, 'Upaix', '05300'),
(1952, 5, 'Garde Colombe', '05300'),
(1953, 5, 'Garde Colombe', '05300'),
(1954, 5, 'Barret Sur Meouge', '05300'),
(1955, 5, 'Garde Colombe', '05300'),
(1956, 5, 'Laragne Monteglin', '05300'),
(1957, 5, 'Eourres', '05300'),
(1958, 5, 'Le Poet', '05300'),
(1959, 5, 'Lazer', '05300'),
(1960, 5, 'Val Buech Meouge', '05300'),
(1961, 5, 'Val Buech Meouge', '05300'),
(1962, 5, 'St Pierre Avez', '05300'),
(1963, 5, 'La Roche De Rame', '05310'),
(1964, 5, 'Champcella', '05310'),
(1965, 5, 'Freissinieres', '05310'),
(1966, 5, 'La Grave', '05320'),
(1967, 5, 'St Chaffrey', '05330'),
(1968, 5, 'Pelvoux', '05340'),
(1969, 5, 'Pelvoux', '05340'),
(1970, 5, 'St Veran', '05350'),
(1971, 5, 'Chateau Ville Vieille', '05350'),
(1972, 5, 'Chateau Ville Vieille', '05350'),
(1973, 5, 'Arvieux', '05350'),
(1974, 5, 'Molines En Queyras', '05350'),
(1975, 5, 'Chateauroux Les Alpes', '05380'),
(1976, 5, 'Chateauneuf D Oze', '05400'),
(1977, 5, 'Manteyer', '05400'),
(1978, 5, 'La Roche Des Arnauds', '05400'),
(1979, 5, 'St Auban D Oze', '05400'),
(1980, 5, 'Oze', '05400'),
(1981, 5, 'Chabestan', '05400'),
(1982, 5, 'Veynes', '05400'),
(1983, 5, 'Furmeyer', '05400'),
(1984, 5, 'Montmaur', '05400'),
(1985, 5, 'Rabou', '05400'),
(1986, 5, 'Le Saix', '05400'),
(1987, 5, 'Ristolas', '05460'),
(1988, 5, 'Abries', '05460'),
(1989, 5, 'Aiguilles', '05470'),
(1990, 5, 'Villar D Arene', '05480'),
(1991, 5, 'Les Costes', '05500'),
(1992, 5, 'St Bonnet En Champsaur', '05500'),
(1993, 5, 'La Motte En Champsaur', '05500'),
(1994, 5, 'Poligny', '05500'),
(1995, 5, 'Buissard', '05500'),
(1996, 5, 'St Eusebe En Champsaur', '05500'),
(1997, 5, 'La Fare En Champsaur', '05500'),
(1998, 5, 'St Julien En Champsaur', '05500'),
(1999, 5, 'St Bonnet En Champsaur', '05500'),
(2000, 5, 'St Bonnet En Champsaur', '05500'),
(2001, 5, 'St Laurent Du Cros', '05500'),
(2002, 5, 'Laye', '05500'),
(2003, 5, 'Le Noyer', '05500'),
(2004, 5, 'Vars', '05560'),
(2005, 5, 'Reotier', '05600'),
(2006, 5, 'Guillestre', '05600'),
(2007, 5, 'Mont Dauphin', '05600'),
(2008, 5, 'Eygliers', '05600'),
(2009, 5, 'St Crepin', '05600'),
(2010, 5, 'Ceillac', '05600'),
(2011, 5, 'Risoul', '05600'),
(2012, 5, 'St Clement Sur Durance', '05600'),
(2013, 5, 'Trescleoux', '05700'),
(2014, 5, 'Savournon', '05700'),
(2015, 5, 'Chanousse', '05700'),
(2016, 5, 'Orpierre', '05700'),
(2017, 5, 'Nossage Et Benevent', '05700'),
(2018, 5, 'Montrond', '05700'),
(2019, 5, 'Etoile St Cyrice', '05700'),
(2020, 5, 'Villebois Les Pins', '05700'),
(2021, 5, 'Le Bersac', '05700'),
(2022, 5, 'L Epine', '05700'),
(2023, 5, 'Montclus', '05700'),
(2024, 5, 'La Piarre', '05700'),
(2025, 5, 'Serres', '05700'),
(2026, 5, 'La Batie Montsaleon', '05700'),
(2027, 5, 'Mereuil', '05700'),
(2028, 5, 'Ste Colombe', '05700'),
(2029, 5, 'Sigottier', '05700'),
(2030, 5, 'La Chapelle En Valgaudemar', '05800'),
(2031, 5, 'St Firmin', '05800'),
(2032, 5, 'Chauffayer', '05800'),
(2033, 5, 'St Jacques En Valgodemard', '05800'),
(2034, 5, 'Aspres Les Corps', '05800'),
(2035, 5, 'St Maurice En Valgodemard', '05800'),
(2036, 5, 'Le Glaizil', '05800'),
(2037, 5, 'Villar Loubiere', '05800'),
(2038, 6, 'Nice', '06000'),
(2039, 6, 'Nice', '06100'),
(2040, 6, 'Le Cannet', '06110'),
(2041, 6, 'Le Cannet', '06110'),
(2042, 6, 'Grasse', '06130'),
(2043, 6, 'Grasse', '06130'),
(2044, 6, 'Grasse', '06130'),
(2045, 6, 'Tourrettes Sur Loup', '06140'),
(2046, 6, 'Vence', '06140'),
(2047, 6, 'Coursegoules', '06140'),
(2048, 6, 'Cannes', '06150'),
(2049, 6, 'Antibes', '06160'),
(2050, 6, 'Antibes', '06160'),
(2051, 6, 'Roquebrune Cap Martin', '06190'),
(2052, 6, 'Roquebrune Cap Martin', '06190'),
(2053, 6, 'Nice', '06200'),
(2054, 6, 'Nice', '06200'),
(2055, 6, 'Nice', '06200'),
(2056, 6, 'Mandelieu La Napoule', '06210'),
(2057, 6, 'Mandelieu La Napoule', '06210'),
(2058, 6, 'Vallauris', '06220'),
(2059, 6, 'Vallauris', '06220'),
(2060, 6, 'Villefranche Sur Mer', '06230'),
(2061, 6, 'St Jean Cap Ferrat', '06230'),
(2062, 6, 'Beausoleil', '06240'),
(2063, 6, 'Mougins', '06250'),
(2064, 6, 'La Rochette', '06260'),
(2065, 6, 'La Croix Sur Roudoule', '06260'),
(2066, 6, 'Pierlas', '06260'),
(2067, 6, 'St Leger', '06260'),
(2068, 6, 'Ascros', '06260'),
(2069, 6, 'Auvare', '06260'),
(2070, 6, 'Lieuche', '06260'),
(2071, 6, 'Puget Theniers', '06260'),
(2072, 6, 'Puget Rostang', '06260'),
(2073, 6, 'La Penne', '06260'),
(2074, 6, 'St Pierre', '06260'),
(2075, 6, 'St Antonin', '06260'),
(2076, 6, 'Rigaud', '06260'),
(2077, 6, 'Villeneuve Loubet', '06270'),
(2078, 6, 'Nice', '06300'),
(2079, 6, 'Beaulieu Sur Mer', '06310'),
(2080, 6, 'La Turbie', '06320'),
(2081, 6, 'Cap D Ail', '06320'),
(2082, 6, 'Roquefort Les Pins', '06330'),
(2083, 6, 'Cantaron', '06340'),
(2084, 6, 'La Trinite', '06340'),
(2085, 6, 'Drap', '06340'),
(2086, 6, 'Eze', '06360'),
(2087, 6, 'Mouans Sartoux', '06370'),
(2088, 6, 'Moulinet', '06380'),
(2089, 6, 'Sospel', '06380'),
(2090, 6, 'Bendejun', '06390'),
(2091, 6, 'Chateauneuf Villevieille', '06390'),
(2092, 6, 'Berre Les Alpes', '06390'),
(2093, 6, 'Coaraze', '06390'),
(2094, 6, 'Contes', '06390'),
(2095, 6, 'Cannes', '06400'),
(2096, 6, 'Biot', '06410'),
(2097, 6, 'Isola', '06420'),
(2098, 6, 'Rimplas', '06420'),
(2099, 6, 'Bairols', '06420'),
(2100, 6, 'Clans', '06420'),
(2101, 6, 'Ilonse', '06420'),
(2102, 6, 'Tournefort', '06420'),
(2103, 6, 'St Sauveur Sur Tinee', '06420'),
(2104, 6, 'Marie', '06420'),
(2105, 6, 'Roure', '06420'),
(2106, 6, 'La Tour', '06420'),
(2107, 6, 'Roubion', '06420'),
(2108, 6, 'Valdeblore', '06420'),
(2109, 6, 'Tende', '06430'),
(2110, 6, 'La Brigue', '06430'),
(2111, 6, 'Tende', '06430'),
(2112, 6, 'Peille', '06440'),
(2113, 6, 'Luceram', '06440'),
(2114, 6, 'Peillon', '06440'),
(2115, 6, 'Touet De L Escarene', '06440'),
(2116, 6, 'Peille', '06440'),
(2117, 6, 'Blausasc', '06440'),
(2118, 6, 'Luceram', '06440'),
(2119, 6, 'L Escarene', '06440'),
(2120, 6, 'Utelle', '06450'),
(2121, 6, 'Lantosque', '06450'),
(2122, 6, 'Roquebilliere', '06450'),
(2123, 6, 'St Martin Vesubie', '06450'),
(2124, 6, 'St Martin Vesubie', '06450'),
(2125, 6, 'Utelle', '06450'),
(2126, 6, 'Venanson', '06450'),
(2127, 6, 'Belvedere', '06450'),
(2128, 6, 'La Bollene Vesubie', '06450'),
(2129, 6, 'Escragnolles', '06460'),
(2130, 6, 'Caussols', '06460'),
(2131, 6, 'St Vallier De Thiey', '06460'),
(2132, 6, 'Chateauneuf D Entraunes', '06470'),
(2133, 6, 'Daluis', '06470'),
(2134, 6, 'Villeneuve D Entraunes', '06470'),
(2135, 6, 'Peone', '06470'),
(2136, 6, 'Beuil', '06470'),
(2137, 6, 'Peone', '06470'),
(2138, 6, 'Guillaumes', '06470'),
(2139, 6, 'St Martin D Entraunes', '06470'),
(2140, 6, 'Entraunes', '06470'),
(2141, 6, 'Entraunes', '06470'),
(2142, 6, 'Sauze', '06470'),
(2143, 6, 'La Colle Sur Loup', '06480'),
(2144, 6, 'Castillon', '06500'),
(2145, 6, 'Ste Agnes', '06500'),
(2146, 6, 'Menton', '06500'),
(2147, 6, 'Castellar', '06500'),
(2148, 6, 'Gorbio', '06500'),
(2149, 6, 'Le Broc', '06510'),
(2150, 6, 'Consegudes', '06510'),
(2151, 6, 'Bezaudun Les Alpes', '06510'),
(2152, 6, 'Bouyon', '06510'),
(2153, 6, 'Gattieres', '06510'),
(2154, 6, 'Carros', '06510'),
(2155, 6, 'Les Ferres', '06510'),
(2156, 6, 'Grasse', '06520'),
(2157, 6, 'St Cezaire Sur Siagne', '06530'),
(2158, 6, 'Cabris', '06530'),
(2159, 6, 'Le Tignet', '06530'),
(2160, 6, 'Peymeinade', '06530'),
(2161, 6, 'Speracedes', '06530'),
(2162, 6, 'Breil Sur Roya', '06540'),
(2163, 6, 'Fontan', '06540'),
(2164, 6, 'Saorge', '06540'),
(2165, 6, 'La Roquette Sur Siagne', '06550'),
(2166, 6, 'Valbonne', '06560'),
(2167, 6, 'Valbonne', '06560'),
(2168, 6, 'St Paul De Vence', '06570'),
(2169, 6, 'Pegomas', '06580'),
(2170, 6, 'Theoule Sur Mer', '06590'),
(2171, 6, 'Theoule Sur Mer', '06590'),
(2172, 6, 'Antibes', '06600'),
(2173, 6, 'Antibes', '06600'),
(2174, 6, 'La Gaude', '06610'),
(2175, 6, 'Gourdon', '06620'),
(2176, 6, 'Le Bar Sur Loup', '06620'),
(2177, 6, 'Courmes', '06620'),
(2178, 6, 'Greolieres', '06620'),
(2179, 6, 'Cipieres', '06620'),
(2180, 6, 'St Jeannet', '06640'),
(2181, 6, 'Le Rouret', '06650'),
(2182, 6, 'Opio', '06650'),
(2183, 6, 'St Dalmas Le Selvage', '06660'),
(2184, 6, 'St Etienne De Tinee', '06660'),
(2185, 6, 'St Etienne De Tinee', '06660'),
(2186, 6, 'Levens', '06670'),
(2187, 6, 'St Martin Du Var', '06670'),
(2188, 6, 'St Blaise', '06670'),
(2189, 6, 'La Roquette Sur Var', '06670'),
(2190, 6, 'Colomars', '06670'),
(2191, 6, 'Duranus', '06670'),
(2192, 6, 'Levens', '06670'),
(2193, 6, 'Castagniers', '06670'),
(2194, 6, 'Tourrette Levens', '06690'),
(2195, 6, 'St Laurent Du Var', '06700'),
(2196, 6, 'Massoins', '06710'),
(2197, 6, 'Thiery', '06710'),
(2198, 6, 'Touet Sur Var', '06710'),
(2199, 6, 'Malaussene', '06710'),
(2200, 6, 'Villars Sur Var', '06710'),
(2201, 6, 'St Andre De La Roche', '06730'),
(2202, 6, 'Chateauneuf Grasse', '06740'),
(2203, 6, 'Valderoure', '06750'),
(2204, 6, 'Andon', '06750'),
(2205, 6, 'Caille', '06750'),
(2206, 6, 'Andon', '06750'),
(2207, 6, 'Seranon', '06750'),
(2208, 6, 'Seranon', '06750'),
(2209, 6, 'Aspremont', '06790'),
(2210, 6, 'Cagnes Sur Mer', '06800'),
(2211, 6, 'Cagnes Sur Mer', '06800'),
(2212, 6, 'Auribeau Sur Siagne', '06810'),
(2213, 6, 'Gilette', '06830'),
(2214, 6, 'Tourette Du Chateau', '06830'),
(2215, 6, 'Toudon', '06830'),
(2216, 6, 'Bonson', '06830'),
(2217, 6, 'Revest Les Roches', '06830'),
(2218, 6, 'Gars', '06850'),
(2219, 6, 'Brianconnet', '06850'),
(2220, 6, 'St Auban', '06850'),
(2221, 6, 'Les Mujouls', '06910'),
(2222, 6, 'Pierrefeu', '06910'),
(2223, 6, 'Aiglun', '06910'),
(2224, 6, 'Amirat', '06910'),
(2225, 6, 'Collongues', '06910'),
(2226, 6, 'Sallagriffon', '06910'),
(2227, 6, 'La Roque En Provence', '06910'),
(2228, 6, 'Le Mas', '06910'),
(2229, 6, 'Roquesteron', '06910'),
(2230, 6, 'Cuebris', '06910'),
(2231, 6, 'Sigale', '06910'),
(2232, 6, 'Falicon', '06950'),
(2233, 7, 'St Julien En St Alban', '07000'),
(2234, 7, 'Gourdon', '07000'),
(2235, 7, 'Coux', '07000'),
(2236, 7, 'Ajoux', '07000'),
(2237, 7, 'Veyras', '07000'),
(2238, 7, 'Lyas', '07000'),
(2239, 7, 'Pranles', '07000'),
(2240, 7, 'Flaviac', '07000'),
(2241, 7, 'Creysseilles', '07000'),
(2242, 7, 'Freyssenet', '07000'),
(2243, 7, 'St Priest', '07000'),
(2244, 7, 'Pourcheres', '07000'),
(2245, 7, 'Privas', '07000'),
(2246, 7, 'Annonay', '07100'),
(2247, 7, 'Boulieu Les Annonay', '07100'),
(2248, 7, 'St Marcel Les Annonay', '07100'),
(2249, 7, 'Roiffieux', '07100'),
(2250, 7, 'Laurac En Vivarais', '07110'),
(2251, 7, 'Prunet', '07110'),
(2252, 7, 'Montreal', '07110'),
(2253, 7, 'Loubaresse', '07110'),
(2254, 7, 'Beaumont', '07110'),
(2255, 7, 'Sanilhac', '07110'),
(2256, 7, 'Tauriers', '07110'),
(2257, 7, 'Largentiere', '07110'),
(2258, 7, 'Joannas', '07110'),
(2259, 7, 'Laboule', '07110'),
(2260, 7, 'Chassiers', '07110'),
(2261, 7, 'Chazeaux', '07110'),
(2262, 7, 'Rocles', '07110'),
(2263, 7, 'Rocher', '07110'),
(2264, 7, 'Valgorge', '07110'),
(2265, 7, 'Uzer', '07110'),
(2266, 7, 'Vinezac', '07110'),
(2267, 7, 'St Alban Auriolles', '07120'),
(2268, 7, 'Pradons', '07120'),
(2269, 7, 'Balazuc', '07120'),
(2270, 7, 'Grospierres', '07120'),
(2271, 7, 'Labeaume', '07120'),
(2272, 7, 'Chauzon', '07120'),
(2273, 7, 'Ruoms', '07120'),
(2274, 7, 'St Alban Auriolles', '07120'),
(2275, 7, 'Sampzon', '07120'),
(2276, 7, 'Chateaubourg', '07130'),
(2277, 7, 'Toulaud', '07130'),
(2278, 7, 'Cornas', '07130'),
(2279, 7, 'St Romain De Lerps', '07130'),
(2280, 7, 'Soyons', '07130'),
(2281, 7, 'St Peray', '07130'),
(2282, 7, 'Les Assions', '07140'),
(2283, 7, 'St Pierre St Jean', '07140'),
(2284, 7, 'Les Vans', '07140'),
(2285, 7, 'Malarce Sur La Thines', '07140'),
(2286, 7, 'Ste Marguerite Lafigere', '07140'),
(2287, 7, 'Chambonas', '07140'),
(2288, 7, 'Les Salelles', '07140'),
(2289, 7, 'Les Vans', '07140'),
(2290, 7, 'Les Vans', '07140'),
(2291, 7, 'Malarce Sur La Thines', '07140'),
(2292, 7, 'Montselgues', '07140'),
(2293, 7, 'Malbosc', '07140'),
(2294, 7, 'St Pierre St Jean', '07140'),
(2295, 7, 'Gravieres', '07140'),
(2296, 7, 'Les Vans', '07140'),
(2297, 7, 'Malarce Sur La Thines', '07140'),
(2298, 7, 'Orgnac L Aven', '07150'),
(2299, 7, 'Vagnas', '07150'),
(2300, 7, 'Salavas', '07150'),
(2301, 7, 'Labastide De Virac', '07150'),
(2302, 7, 'Vallon Pont D Arc', '07150'),
(2303, 7, 'Lagorce', '07150'),
(2304, 7, 'Bessas', '07150'),
(2305, 7, 'Nonieres', '07160'),
(2306, 7, 'Le Chambon', '07160'),
(2307, 7, 'Jaunac', '07160'),
(2308, 7, 'Mariac', '07160'),
(2309, 7, 'Dornas', '07160'),