-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Serveur: 127.0.0.1
-- Généré le : Lun 20 Décembre 2010 à 10:57
-- Version du serveur: 5.1.54
-- Version de PHP: 5.3.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `ex_s3_savioz_romain`
--

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

--
-- Structure de la table `t_ville`
--

CREATE TABLE IF NOT EXISTS `t_ville` (
  `NPA_Ville` varchar(255) NOT NULL,
  `Nom_Ville` varchar(255) NOT NULL,
  `Canton_Ville` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `t_ville`
--

INSERT INTO `t_ville` (`NPA_Ville`, `Nom_Ville`, `Canton_Ville`) VALUES
('1000', 'Lausanne', 'VD'),
('1000', 'Lausanne 1 D?p?t', 'VD'),
('1000', 'Lausanne 2', 'VD'),
('1000', 'Lausanne 3', 'VD'),
('1000', 'Lausanne 6', 'VD'),
('1000', 'Lausanne 7', 'VD'),
('1000', 'Lausanne 8', 'VD'),
('1000', 'Lausanne 12', 'VD'),
('1000', 'Lausanne 14', 'VD'),
('1000', 'Lausanne 16', 'VD'),
('1000', 'Lausanne 17', 'VD'),
('1000', 'Lausanne 19', 'VD'),
('1000', 'Lausanne 20', 'VD'),
('1000', 'Lausanne 21', 'VD'),
('1000', 'Lausanne 22', 'VD'),
('1000', 'Lausanne 23', 'VD'),
('1000', 'Lausanne 24', 'VD'),
('1000', 'Lausanne 25', 'VD'),
('1000', 'Lausanne 26', 'VD'),
('1000', 'Lausanne 27', 'VD'),
('1000', 'Lausanne Dist', 'VD'),
('1000', 'Lausanne Swisscom', 'VD'),
('1001', 'Lausanne', 'VD'),
('1002', 'Lausanne', 'VD'),
('1003', 'Lausanne', 'VD'),
('1004', 'Lausanne', 'VD'),
('1005', 'Lausanne', 'VD'),
('1006', 'Lausanne', 'VD'),
('1007', 'Lausanne', 'VD'),
('1008', 'Prilly', 'VD'),
('1009', 'Pully', 'VD'),
('1010', 'Lausanne', 'VD'),
('1011', 'Lausanne', 'VD'),
('1012', 'Lausanne', 'VD'),
('1014', 'Lausanne Adm cant', 'VD'),
('1015', 'Lausanne', 'VD'),
('1018', 'Lausanne', 'VD'),
('1020', 'Renens VD', 'VD'),
('1020', 'Renens VD 1', 'VD'),
('1020', 'Renens VD 2', 'VD'),
('1022', 'Chavannes-Renens', 'VD'),
('1023', 'Crissier', 'VD'),
('1024', 'Ecublens VD', 'VD'),
('1025', 'St-Sulpice VD', 'VD'),
('1026', 'Echandens-Denges', 'VD'),
('1027', 'Lonay', 'VD'),
('1028', 'Pr?verenges', 'VD'),
('1030', 'Bussigny-Lausanne', 'VD'),
('1032', 'Romanel-s-Lausanne', 'VD'),
('1033', 'Cheseaux-Lausanne', 'VD'),
('1037', 'Etagni?res', 'VD'),
('1038', 'Bercher', 'VD'),
('1040', 'Echallens', 'VD'),
('1040', 'St-Barth?lemy VD', 'VD'),
('1377', 'Oulens-Echallens', 'VD'),
('1042', 'Bettens', 'VD'),
('1040', 'Villars-le-Terroir', 'VD'),
('1417', 'Epautheyres', 'VD'),
('1041', 'Dommartin', 'VD'),
('1063', 'Peyres-Possens', 'VD'),
('1063', 'Boulens', 'VD'),
('1041', 'Poliez-le-Grand', 'VD'),
('1041', 'Poliez-Pittet', 'VD'),
('1041', 'Bottens', 'VD'),
('1053', 'Bretigny-Morrens', 'VD'),
('1034', 'Boussens', 'VD'),
('1035', 'Bournens', 'VD'),
('1036', 'Sullens', 'VD'),
('1042', 'Assens', 'VD'),
('1043', 'Sugnens', 'VD'),
('1044', 'Fey', 'VD'),
('1045', 'Ogens', 'VD'),
('1407', 'Bioley-Magnoux', 'VD'),
('1042', 'Bioley-Orjulaz', 'VD'),
('1052', 'Mont-sur-Lausanne', 'VD'),
('1053', 'Cugy VD', 'VD'),
('1054', 'Morrens VD', 'VD'),
('1055', 'Froideville', 'VD'),
('1410', 'Thierrens', 'VD'),
('1066', 'Epalinges', 'VD'),
('1073', 'Savigny', 'VD'),
('1083', 'M?zi?res VD', 'VD'),
('1092', 'Belmont-Lausanne', 'VD'),
('1093', 'La Conversion', 'VD'),
('1094', 'Paudex', 'VD'),
('1095', 'Lutry', 'VD'),
('1096', 'Cully', 'VD'),
('1097', 'Riex', 'VD'),
('1098', 'Epesses', 'VD'),
('1058', 'Villars-Tiercelin', 'VD'),
('1059', 'Peney-le-Jorat', 'VD'),
('1061', 'Villars-Mendraz', 'VD'),
('1062', 'Sottens', 'VD'),
('1063', 'Chapelle-s-Moudon', 'VD'),
('1410', 'St-Cierges', 'VD'),
('1073', 'Mollie-Margot', 'VD'),
('1080', 'Les Cullayes', 'VD'),
('1081', 'Montpreveyres', 'VD'),
('1082', 'Corcelles-le-Jorat', 'VD'),
('1088', 'Ropraz', 'VD'),
('1084', 'Carrouge VD', 'VD'),
('1085', 'Vulliens', 'VD'),
('1509', 'Vucherens', 'VD'),
('1510', 'Syens', 'VD'),
('1076', 'Ferlens VD', 'VD'),
('1077', 'Servion', 'VD'),
('1078', 'Essertes', 'VD'),
('1673', 'Auboranges', 'FR'),
('1110', 'Morges', 'VD'),
('1110', 'Morges 1', 'VD'),
('1110', 'Morges 2', 'VD'),
('1112', 'Echichens', 'VD'),
('1167', 'Lussy-sur-Morges', 'VD'),
('1132', 'Lully VD', 'VD'),
('1131', 'Tolochenaz', 'VD'),
('1125', 'Monnaz', 'VD'),
('1126', 'Vaux-sur-Morges', 'VD'),
('1127', 'Clarmont', 'VD'),
('1128', 'Reverolle', 'VD'),
('1113', 'St-Saphorin-Morges', 'VD'),
('1114', 'Colombier VD', 'VD'),
('1115', 'Vullierens', 'VD'),
('1116', 'Cottens VD', 'VD'),
('1117', 'Grancy', 'VD'),
('1304', 'Senarclens', 'VD'),
('1121', 'Bremblens', 'VD'),
('1122', 'Romanel-sur-Morges', 'VD'),
('1123', 'Aclens', 'VD'),
('1124', 'Gollion', 'VD'),
('1134', 'Vufflens-Ch?teau', 'VD'),
('1135', 'Denens', 'VD'),
('1136', 'Bussy-Chardonney', 'VD'),
('1169', 'Yens', 'VD'),
('1168', 'Villars-sous-Yens', 'VD'),
('1144', 'Ballens', 'VD'),
('1149', 'Berolle', 'VD'),
('1146', 'Mollens VD', 'VD'),
('1147', 'Montricher', 'VD'),
('1142', 'Pampigny', 'VD'),
('1141', 'S?very', 'VD'),
('1143', 'Apples', 'VD'),
('1145', 'Bi?re', 'VD'),
('1148', 'L''Isle', 'VD'),
('1162', 'St-Prex', 'VD'),
('1163', 'Etoy', 'VD'),
('1164', 'Buchillon', 'VD'),
('1165', 'Allaman', 'VD'),
('1166', 'Perroy', 'VD'),
('1170', 'Aubonne', 'VD'),
('1172', 'Bougy-Villars', 'VD'),
('1173', 'F?chy', 'VD'),
('1174', 'Montherod', 'VD'),
('1175', 'Lavigny', 'VD'),
('1176', 'St-Livres', 'VD'),
('1180', 'Rolle', 'VD'),
('1182', 'Gilly', 'VD'),
('1183', 'Bursins', 'VD'),
('1184', 'Vinzel', 'VD'),
('1184', 'Luins', 'VD'),
('1185', 'Mont-sur-Rolle', 'VD'),
('1186', 'Essertines-Rolle', 'VD'),
('1187', 'St-Oyens', 'VD'),
('1189', 'Saubraz', 'VD'),
('1188', 'Gimel', 'VD'),
('1195', 'Dully-Bursinel', 'VD'),
('1196', 'Gland', 'VD'),
('1197', 'Prangins', 'VD'),
('1200', 'Gen?ve', 'GE'),
('1200', 'Gen?ve 1', 'GE'),
('1200', 'Gen?ve 2 D?p?t', 'GE'),
('1200', 'Gen?ve 3', 'GE'),
('1200', 'Gen?ve 4', 'GE'),
('1200', 'Gen?ve 2 Transit', 'GE'),
('1200', 'Gen?ve 6', 'GE'),
('1200', 'Gen?ve 7', 'GE'),
('1200', 'Gen?ve 8', 'GE'),
('1200', 'Gen?ve 9', 'GE'),
('1200', 'Gen?ve 11', 'GE'),
('1200', 'Gen?ve 12', 'GE'),
('1200', 'Gen?ve 13', 'GE'),
('1200', 'Gen?ve 17', 'GE'),
('1200', 'Gen?ve 19', 'GE'),
('1200', 'Gen?ve 20', 'GE'),
('1200', 'Gen?ve 21', 'GE'),
('1200', 'Gen?ve 24', 'GE'),
('1200', 'Gen?ve 26', 'GE'),
('1200', 'Gen?ve 28 Balexert', 'GE'),
('1200', 'Gen?ve (CLT)', 'GE'),
('1200', 'Gen?ve 2 Dist', 'GE'),
('1200', 'Gen?ve Dist Ba', 'GE'),
('1201', 'Gen?ve', 'GE'),
('1202', 'Gen?ve', 'GE'),
('1203', 'Gen?ve', 'GE'),
('1204', 'Gen?ve', 'GE'),
('1205', 'Gen?ve', 'GE'),
('1206', 'Gen?ve', 'GE'),
('1207', 'Gen?ve', 'GE'),
('1208', 'Gen?ve', 'GE'),
('1209', 'Gen?ve', 'GE'),
('1211', 'Gen?ve 1', 'GE'),
('1211', 'Gen?ve 2', 'GE'),
('1211', 'Gen?ve 3', 'GE'),
('1211', 'Gen?ve 4', 'GE'),
('1211', 'Gen?ve 6', 'GE'),
('1211', 'Gen?ve 7', 'GE'),
('1211', 'Gen?ve 8', 'GE'),
('1211', 'Gen?ve 10', 'GE'),
('1211', 'Gen?ve 11', 'GE'),
('1211', 'Gen?ve 12', 'GE'),
('1211', 'Gen?ve 13', 'GE'),
('1211', 'Gen?ve 17', 'GE'),
('1211', 'Gen?ve 19', 'GE'),
('1211', 'Gen?ve 20', 'GE'),
('1211', 'Gen?ve 21', 'GE'),
('1211', 'Gen?ve 22', 'GE'),
('1211', 'Gen?ve 23', 'GE'),
('1211', 'Gen?ve 26', 'GE'),
('1211', 'Gen?ve 27', 'GE'),
('1211', 'Gen?ve 28', 'GE'),
('1211', 'Gen?ve 2 Swisscom', 'GE'),
('1212', 'Grand-Lancy', 'GE'),
('1212', 'Grand-Lancy 1', 'GE'),
('1212', 'Grand-Lancy 2', 'GE'),
('1213', 'Petit-Lancy', 'GE'),
('1213', 'Petit-Lancy 1', 'GE'),
('1213', 'Petit-Lancy 2', 'GE'),
('1213', 'Onex', 'GE'),
('1214', 'Vernier', 'GE'),
('1215', 'Gen?ve', 'GE'),
('1215', 'Gen?ve 15 D?p?t', 'GE'),
('1216', 'Cointrin', 'GE'),
('1217', 'Meyrin', 'GE'),
('1217', 'Meyrin 1', 'GE'),
('1217', 'Meyrin 2', 'GE'),
('1218', 'Le Grand-Saconnex', 'GE'),
('1219', 'Le Lignon', 'GE'),
('1219', 'A?re', 'GE'),
('1219', 'Ch?telaine', 'GE'),
('1220', 'Les Avanchets', 'GE'),
('1222', 'V?senaz', 'GE'),
('1223', 'Cologny', 'GE'),
('1224', 'Ch?ne-Bougeries', 'GE'),
('1225', 'Ch?ne-Bourg', 'GE'),
('1226', 'Th?nex', 'GE'),
('1227', 'Carouge GE', 'GE'),
('1227', 'Les Acacias', 'GE'),
('1228', 'Plan-les-Ouates', 'GE'),
('1231', 'Conches', 'GE'),
('1232', 'Confignon', 'GE'),
('1233', 'Bernex', 'GE'),
('1234', 'Vessy', 'GE'),
('1236', 'Cartigny', 'GE'),
('1237', 'Avully', 'GE'),
('1239', 'Collex', 'GE'),
('1241', 'Puplinge', 'GE'),
('1242', 'Satigny', 'GE'),
('1243', 'Presinge', 'GE'),
('1244', 'Choulex', 'GE'),
('1245', 'Collonge-Bellerive', 'GE'),
('1246', 'Corsier GE', 'GE'),
('1247', 'Ani?res', 'GE'),
('1248', 'Hermance', 'GE'),
('1251', 'Gy', 'GE'),
('1252', 'Meinier', 'GE'),
('1253', 'Vandoeuvres', 'GE'),
('1254', 'Jussy', 'GE'),
('1255', 'Veyrier', 'GE'),
('1256', 'Troinex', 'GE'),
('1257', 'La Croix-de-Rozon', 'GE'),
('1258', 'Perly', 'GE'),
('1260', 'Nyon', 'VD'),
('1260', 'Nyon 1 Dist', 'VD'),
('1277', 'Borex', 'VD'),
('1278', 'La Rippe', 'VD'),
('1279', 'Chavannes-de-Bogis', 'VD'),
('1274', 'Grens', 'VD'),
('1275', 'Ch?serex', 'VD'),
('1276', 'Gingins', 'VD'),
('1270', 'Tr?lex', 'VD'),
('1271', 'Givrins', 'VD'),
('1272', 'Genolier', 'VD'),
('1273', 'Le Muids', 'VD'),
('1273', 'Arzier', 'VD'),
('1268', 'Burtigny', 'VD'),
('1261', 'Marchissy', 'VD'),
('1261', 'Le Vaud', 'VD'),
('1269', 'Bassins', 'VD'),
('1261', 'Longirod', 'VD'),
('1188', 'St-George', 'VD'),
('1262', 'Eysins', 'VD'),
('1263', 'Crassier', 'VD'),
('1264', 'St-Cergue', 'VD'),
('1265', 'La Cure', 'VD'),
('1266', 'Duillier', 'VD'),
('1267', 'Vich-Coinsins', 'VD'),
('1268', 'Begnins', 'VD'),
('1281', 'Russin', 'GE'),
('1283', 'Dardagny', 'GE'),
('1283', 'La Plaine', 'GE'),
('1284', 'Chancy', 'GE'),
('1285', 'Athenaz (Avusy)', 'GE'),
('1286', 'Soral', 'GE'),
('1287', 'Laconnex', 'GE'),
('1288', 'Aire-la-Ville', 'GE'),
('1290', 'Versoix', 'GE'),
('1291', 'Commugny', 'VD'),
('1292', 'Chamb?sy', 'GE'),
('1293', 'Bellevue', 'GE'),
('1294', 'Genthod', 'GE'),
('1295', 'Mies-Tannay', 'VD'),
('1296', 'Coppet', 'VD'),
('1297', 'Founex', 'VD'),
('1298', 'C?ligny', 'GE'),
('1299', 'Crans-pr?s-C?ligny', 'VD'),
('1302', 'Vufflens-la-Ville', 'VD'),
('1304', 'Cossonay-Ville', 'VD'),
('1304', 'Dizy', 'VD'),
('1307', 'Lussery-Villars', 'VD'),
('1305', 'Penthalaz', 'VD'),
('1315', 'La Sarraz', 'VD'),
('1317', 'Orny', 'VD'),
('1316', 'Chevilly', 'VD'),
('1337', 'Vallorbe', 'VD'),
('1338', 'Ballaigues', 'VD'),
('1341', 'Orient', 'VD'),
('1346', 'Les Bioux', 'VD'),
('1344', 'L''Abbaye', 'VD'),
('1342', 'Le Pont', 'VD'),
('1343', 'Les Charbonni?res', 'VD'),
('1345', 'Le Lieu', 'VD'),
('1347', 'Le Sentier', 'VD'),
('1348', 'Le Brassus', 'VD'),
('1306', 'Daillens', 'VD'),
('1303', 'Penthaz', 'VD'),
('1308', 'La Chaux-Cossonay', 'VD'),
('1148', 'Cuarnens', 'VD'),
('1313', 'Ferreyres', 'VD'),
('1148', 'Moiry VD', 'VD'),
('1321', 'Arnex-sur-Orbe', 'VD'),
('1318', 'Pompaples', 'VD'),
('1312', 'Ecl?pens', 'VD'),
('1329', 'Bretonni?res', 'VD'),
('1322', 'Croy', 'VD'),
('1323', 'Romainm?tier', 'VD'),
('1324', 'Premier', 'VD'),
('1325', 'Vaulion', 'VD'),
('1326', 'Juriens', 'VD'),
('1148', 'La Praz', 'VD'),
('1148', 'Mont-la-Ville', 'VD'),
('1350', 'Orbe', 'VD'),
('1352', 'Agiez', 'VD'),
('1353', 'Bofflens', 'VD'),
('1354', 'Montcherand', 'VD'),
('1355', 'L''Abergement', 'VD'),
('1356', 'Les Cl?es', 'VD'),
('1357', 'Lignerolle', 'VD'),
('1358', 'Valeyres-Rances', 'VD'),
('1439', 'Rances', 'VD'),
('1373', 'Chavornay', 'VD'),
('1372', 'Bavois', 'VD'),
('1374', 'Corcelles-Chavorn', 'VD'),
('1375', 'Penth?r?az', 'VD'),
('1376', 'Goumoens-la-Ville', 'VD'),
('1400', 'Yverdon-les-Bains', 'VD'),
('1400', 'Yverdon 1', 'VD'),
('1400', 'Yverdon 2', 'VD'),
('1401', 'Yverdon-les-Bains', 'VD'),
('1417', 'Essertines-Yverdon', 'VD'),
('1416', 'Pailly', 'VD'),
('1418', 'Vuarrens', 'VD'),
('1420', 'Fiez', 'VD'),
('1421', 'Fontaines-Grandson', 'VD'),
('1423', 'Villars-Burquin', 'VD'),
('1453', 'Mauborget', 'VD'),
('1429', 'Giez', 'VD'),
('1430', 'Orges', 'VD'),
('1431', 'Vugelles-La Mothe', 'VD'),
('1405', 'Pomy', 'VD'),
('1406', 'Cronay', 'VD'),
('1407', 'Donneloye', 'VD'),
('1408', 'Prahins', 'VD'),
('1409', 'Chan?az', 'VD'),
('1412', 'Valeyres-Ursins', 'VD'),
('1413', 'Orzens', 'VD'),
('1046', 'Rueyres', 'VD'),
('1404', 'Cuarny', 'VD'),
('1427', 'Bonvillars', 'VD'),
('1424', 'Champagne', 'VD'),
('1431', 'Novalles', 'VD'),
('1423', 'Fontanezier', 'VD'),
('1415', 'Molondin', 'VD'),
('1422', 'Grandson', 'VD'),
('1422', 'Grandson 1', 'VD'),
('1422', 'Grandson 2', 'VD'),
('1425', 'Onnens VD', 'VD'),
('1426', 'Concise', 'VD'),
('1426', 'Corcelles-Concise', 'VD'),
('1432', 'Belmont-Yverdon', 'VD'),
('1433', 'Suchy', 'VD'),
('1434', 'Ependes VD', 'VD'),
('1435', 'Essert-Pittet', 'VD'),
('1436', 'Treycovagnes', 'VD'),
('1437', 'Susc?vaz', 'VD'),
('1438', 'Mathod', 'VD'),
('1441', 'Valeyres-Montagny', 'VD'),
('1442', 'Montagny-Yverdon', 'VD'),
('1443', 'Champvent', 'VD'),
('1445', 'Vuiteboeuf', 'VD'),
('1446', 'Baulmes', 'VD'),
('1450', 'Ste-Croix', 'VD'),
('1450', 'La Sagne VD', 'VD'),
('1454', 'L''Auberson', 'VD'),
('1452', 'Les Rasses', 'VD'),
('1453', 'Bullet', 'VD'),
('1450', 'Le Ch?teau-Croix', 'VD'),
('1462', 'Yvonand', 'VD'),
('1463', 'Rovray', 'VD'),
('1464', 'Chavannes-le-Ch?ne', 'VD'),
('1464', 'Ch?ne-P?quier', 'VD'),
('1468', 'Cheyres', 'FR'),
('1470', 'Estavayer-le-Lac', 'FR'),
('1473', 'Font', 'FR'),
('1474', 'Ch?bles FR', 'FR'),
('1483', 'Montet (Broye)', 'FR'),
('1482', 'Cugy FR', 'FR'),
('1541', 'Bussy FR', 'FR'),
('1484', 'Aumont', 'FR'),
('1485', 'Nuvilly', 'FR'),
('1486', 'Vuissens', 'FR'),
('1537', 'Champtauroz', 'VD'),
('1538', 'Treytorrens-Payern', 'VD'),
('1489', 'Murist', 'FR'),
('1510', 'Moudon', 'VD'),
('1512', 'Chavannes-s-Moudon', 'VD'),
('1513', 'Hermenches', 'VD'),
('1514', 'Bussy-sur-Moudon', 'VD'),
('1522', 'Oulens-sur-Lucens', 'VD'),
('1515', 'Villars-le-Comte', 'VD'),
('1515', 'Neyruz-sur-Moudon', 'VD'),
('1410', 'Denezy', 'VD'),
('1522', 'Lucens', 'VD'),
('1521', 'Curtilles', 'VD'),
('1523', 'Granges-Marnand', 'VD'),
('1527', 'Villeneuve FR', 'FR'),
('1528', 'Surpierre', 'FR'),
('1529', 'Cheiry', 'FR'),
('1530', 'Payerne', 'VD'),
('1532', 'F?tigny', 'FR'),
('1533', 'M?ni?res', 'FR'),
('1534', 'Sassel', 'VD'),
('1536', 'Combremont-Petit', 'VD'),
('1526', 'Forel-sur-Lucens', 'VD'),
('1526', 'Cremin', 'VD'),
('1542', 'Rueyres-les-Pr', 'FR'),
('1543', 'Grandcour', 'VD'),
('1544', 'Gletterens', 'FR'),
('1545', 'Chevroux', 'VD'),
('1551', 'Vers-chez-Perrin', 'VD'),
('1552', 'Trey', 'VD'),
('1553', 'Ch?tonnaye', 'FR'),
('1554', 'S?deilles', 'VD'),
('1555', 'Villarzel', 'VD'),
('1682', 'Villars-Bramard', 'VD'),
('1682', 'Dompierre VD', 'VD'),
('1535', 'Combremont-Grand', 'VD'),
('1562', 'Corcelles-Payerne', 'VD'),
('1563', 'Dompierre FR', 'FR'),
('1564', 'Domdidier', 'FR'),
('1565', 'Missy', 'VD'),
('1475', 'Autavaux', 'FR'),
('1567', 'Delley', 'FR'),
('1568', 'Portalban', 'FR'),
('1566', 'St-Aubin FR', 'FR'),
('1580', 'Avenches', 'VD'),
('1626', 'Romanens', 'FR'),
('1692', 'Massonnens', 'FR'),
('1687', 'Vuisternens-Romont', 'FR'),
('1625', 'S?les (Gruy?re)', 'FR'),
('1612', 'Ecoteaux', 'VD'),
('1613', 'Maracon', 'VD'),
('1608', 'Oron-le-Ch?tel', 'VD'),
('1609', 'St-Martin FR', 'FR'),
('1611', 'Le Cr?t-p-Semsales', 'FR'),
('1697', 'La Joux FR', 'FR'),
('1699', 'Bouloz', 'FR'),
('1699', 'Porsel', 'FR'),
('1699', 'Pont (Veveyse)', 'FR'),
('1700', 'Fribourg', 'FR'),
('1700', 'Fribourg 1', 'FR'),
('1702', 'Fribourg', 'FR'),
('1704', 'Fribourg', 'FR'),
('1705', 'Fribourg', 'FR'),
('1707', 'Fribourg', 'FR'),
('1708', 'Fribourg', 'FR'),
('1763', 'Granges-Paccot', 'FR'),
('1700', 'Fribourg 1 Dist', 'FR'),
('1701', 'Fribourg', 'FR'),
('1720', 'Corminboeuf', 'FR'),
('1721', 'Misery-Courtion', 'FR'),
('1735', 'Giffers', 'FR'),
('1736', 'St. Silvester', 'FR'),
('1737', 'Plasselb', 'FR'),
('1738', 'Sangernboden', 'BE'),
('1716', 'Schwarzsee', 'FR'),
('1724', 'Bonnefontaine', 'FR'),
('1727', 'Corpataux-Magneden', 'FR'),
('1728', 'Rossens FR', 'FR'),
('1719', 'Br?nisried', 'FR'),
('1731', 'Ependes FR', 'FR'),
('1732', 'Arconciel', 'FR'),
('1733', 'Treyvaux', 'FR'),
('1720', 'Ch?sopelloz', 'FR'),
('1712', 'Tafers', 'FR'),
('1713', 'St. Antoni', 'FR'),
('1714', 'Heitenried', 'FR'),
('1715', 'Alterswil FR', 'FR'),
('1716', 'Plaffeien', 'FR'),
('1717', 'St. Ursen', 'FR'),
('1718', 'Rechthalten', 'FR'),
('1722', 'Bourguillon', 'FR'),
('1723', 'Marly', 'FR'),
('1724', 'Le Mouret', 'FR'),
('1725', 'Posieux', 'FR'),
('1726', 'Farvagny', 'FR'),
('1746', 'Prez-vers-Nor?az', 'FR'),
('1747', 'Corserey', 'FR'),
('1748', 'Torny-le-Grand', 'FR'),
('1749', 'Middes', 'FR'),
('1740', 'Neyruz FR', 'FR'),
('1741', 'Cottens FR', 'FR'),
('1744', 'Ch?nens', 'FR'),
('1745', 'Lentigny', 'FR'),
('1742', 'Autigny', 'FR'),
('1695', 'Estavayer-Gibloux', 'FR'),
('1691', 'Villarimboud', 'FR'),
('1752', 'Villars-sur-Gl?ne', 'FR'),
('1752', 'Villars-Gl?ne 1', 'FR'),
('1752', 'Villars-Gl?ne 2', 'FR'),
('1753', 'Matran', 'FR'),
('1754', 'Ros', 'FR'),
('1756', 'Onnens FR', 'FR'),
('1757', 'Nor?az', 'FR'),
('1690', 'Villaz-St-Pierre', 'FR'),
('1762', 'Givisiez', 'FR'),
('1772', 'Grolley', 'FR'),
('1773', 'L?chelles', 'FR'),
('1774', 'Cousset', 'FR'),
('1776', 'Montagny-la-Ville', 'FR'),
('1795', 'Courlevon', 'FR'),
('1796', 'Courgevaux', 'FR'),
('1797', 'M?nchenwiler', 'BE'),
('1794', 'Salvenach', 'FR'),
('1793', 'Jeuss', 'FR'),
('1792', 'Cordast', 'FR'),
('1791', 'Courtaman', 'FR'),
('1788', 'Praz (Vully)', 'FR'),
('1789', 'Lugnorre', 'FR'),
('1782', 'Belfaux', 'FR'),
('1783', 'Pensier', 'FR'),
('1784', 'Courtepin', 'FR'),
('1785', 'Cressier FR', 'FR'),
('1786', 'Sugiez', 'FR'),
('1787', 'M?tier (Vully)', 'FR'),
('1800', 'Vevey', 'VD'),
('1800', 'Vevey 1', 'VD'),
('1800', 'Vevey 2', 'VD'),
('1800', 'Vevey 1 Dist', 'VD'),
('1801', 'Le Mont-P?lerin', 'VD'),
('1808', 'Monts-de-Corsier', 'VD'),
('1809', 'Fenil-sur-Corsier', 'VD'),
('1802', 'Corseaux', 'VD'),
('1803', 'Chardonne', 'VD'),
('1804', 'Corsier-sur-Vevey', 'VD'),
('1805', 'Jongny', 'VD'),
('1806', 'St-L?gier-Chi?saz', 'VD'),
('1807', 'Blonay', 'VD'),
('1071', 'Rivaz', 'VD'),
('1071', 'St-Saphorin-Lavaux', 'VD'),
('1814', 'La Tour-de-Peilz', 'VD'),
('1815', 'Clarens', 'VD'),
('1816', 'Chailly-Montreux', 'VD'),
('1817', 'Brent', 'VD'),
('1820', 'Montreux', 'VD'),
('1820', 'Montreux 1', 'VD'),
('1820', 'Montreux 2', 'VD'),
('1820', 'Territet-Veytaux', 'VD'),
('1820', 'Montreux 1 Dist', 'VD'),
('1822', 'Chernex', 'VD'),
('1823', 'Glion', 'VD'),
('1824', 'Caux', 'VD'),
('1832', 'Villard-sur-Chamby', 'VD'),
('1669', 'Sciernes-d''Albeuve', 'FR'),
('1658', 'La Tine', 'VD'),
('1660', 'Les Moulins', 'VD'),
('1659', 'Flendruz', 'VD'),
('1660', 'L''Etivaz', 'VD'),
('1832', 'Chamby', 'VD'),
('1833', 'Les Avants', 'VD'),
('1669', 'Montbovon', 'FR'),
('1658', 'Rossini?re', 'VD'),
('1660', 'Ch?teau-d''Oex', 'VD'),
('1659', 'Rougemont', 'VD'),
('1844', 'Villeneuve VD', 'VD'),
('1847', 'Rennaz', 'VD'),
('1845', 'Noville', 'VD'),
('1846', 'Chessel', 'VD'),
('1852', 'Roche VD', 'VD'),
('1853', 'Yvorne', 'VD'),
('1854', 'Leysin', 'VD'),
('1867', 'St-Triphon', 'VD'),
('1860', 'Aigle', 'VD'),
('1856', 'Corbeyrier', 'VD'),
('1862', 'La Comballaz', 'VD'),
('1862', 'Les Mosses', 'VD'),
('1866', 'La Forclaz VD', 'VD'),
('1884', 'Hu?moz', 'VD'),
('1867', 'Panex', 'VD'),
('1863', 'Le S?pey', 'VD'),
('1864', 'Vers-l''Eglise', 'VD'),
('1865', 'Les Diablerets', 'VD'),
('1867', 'Ollon VD', 'VD'),
('1868', 'Collombey', 'VS'),
('1870', 'Monthey', 'VS'),
('1870', 'Monthey 1', 'VS'),
('1870', 'Monthey 2', 'VS'),
('1871', 'Cho', 'VS'),
('1871', 'Les Giettes', 'VS'),
('1872', 'Troistorrents', 'VS'),
('1873', 'Val-d''Illiez', 'VS'),
('1874', 'Champ?ry', 'VS'),
('1875', 'Morgins', 'VS'),
('1880', 'Bex', 'VD'),
('1880', 'Fenalet-sur-Bex', 'VD'),
('1880', 'Freni?res-sur-Bex', 'VD'),
('1880', 'Les Plans-sur-Bex', 'VD'),
('1882', 'Les Posses-sur-Bex', 'VD'),
('1882', 'Gryon', 'VD'),
('1884', 'Villars-sur-Ollon', 'VD'),
('1885', 'Chesi?res', 'VD'),
('1890', 'St-Maurice', 'VS'),
('1890', 'Mex VS', 'VS'),
('1891', 'V?rossaz', 'VS'),
('1869', 'Massongex', 'VS'),
('1895', 'Vionnaz', 'VS'),
('1897', 'Les Evouettes', 'VS'),
('1899', 'Torgon', 'VS'),
('1892', 'Lavey-Village', 'VD'),
('1893', 'Muraz (Collombey)', 'VS'),
('1896', 'Vouvry', 'VS'),
('1896', 'Miex', 'VS'),
('1897', 'Bouveret', 'VS'),
('1898', 'St-Gingolph', 'VS'),
('1902', 'Evionnaz', 'VS'),
('1903', 'Collonges', 'VS'),
('1904', 'Vernayaz', 'VS'),
('1905', 'Dor?naz', 'VS'),
('1906', 'Charrat', 'VS'),
('1907', 'Saxon', 'VS'),
('1908', 'Riddes', 'VS'),
('1912', 'Leytron', 'VS'),
('1911', 'Ovronnaz', 'VS'),
('1913', 'Saillon', 'VS'),
('1914', 'Is?rables', 'VS'),
('1918', 'La Tzoumaz', 'VS'),
('1955', 'Chamoson', 'VS'),
('1955', 'St-Pierre-Clages', 'VS'),
('1957', 'Ardon', 'VS'),
('1920', 'Martigny', 'VS'),
('1920', 'Martigny 1', 'VS'),
('1920', 'Martigny 2', 'VS'),
('1921', 'Martigny-Croix', 'VS'),
('1923', 'Le Tr?tien', 'VS'),
('1925', 'Le Ch?telard VS', 'VS'),
('1927', 'Chemin', 'VS'),
('1929', 'Trient', 'VS'),
('1928', 'Ravoire', 'VS'),
('1922', 'Salvan', 'VS'),
('1922', 'Granges (Salvan)', 'VS'),
('1923', 'Les Mar?cottes', 'VS'),
('1925', 'Finhaut', 'VS'),
('1926', 'Fully', 'VS'),
('1932', 'Bovernier', 'VS'),
('1947', 'Verseg?res', 'VS'),
('1941', 'Voll?ges', 'VS'),
('1942', 'Levron', 'VS'),
('1948', 'Lourtier', 'VS'),
('1948', 'Fionnay', 'VS'),
('1948', 'Sarreyer', 'VS'),
('1945', 'Liddes', 'VS'),
('1946', 'Bourg-St-Pierre', 'VS'),
('1943', 'Praz-de-Fort', 'VS'),
('1944', 'La Fouly VS', 'VS'),
('1933', 'Sembrancher', 'VS'),
('1934', 'Le Ch?ble VS', 'VS'),
('1936', 'Verbier', 'VS'),
('1937', 'Orsi?res', 'VS'),
('1938', 'Champex-Lac', 'VS'),
('1950', 'Sion', 'VS'),
('1950', 'Sion 1', 'VS'),
('1950', 'Sion 1 Dist', 'VS'),
('1951', 'Sion', 'VS'),
('1950', 'Sion 2', 'VS'),
('1950', 'Sion 3', 'VS'),
('1975', 'St-S?verin', 'VS'),
('1976', 'Erde', 'VS'),
('1976', 'Aven', 'VS'),
('1976', 'Daillon', 'VS'),
('1971', 'Grimisuat', 'VS'),
('1974', 'Arbaz', 'VS'),
('1961', 'Vernami?ge', 'VS'),
('1973', 'Nax', 'VS'),
('1968', 'Mase', 'VS'),
('1969', 'St-Martin VS', 'VS'),
('1981', 'Vex', 'VS'),
('1982', 'Euseigne', 'VS'),
('1984', 'Les Haud?res', 'VS'),
('1986', 'Arolla', 'VS'),
('1985', 'La Sage', 'VS'),
('1987', 'H?r?mence', 'VS'),
('1987', 'M?che', 'VS'),
('1988', 'Les Collons', 'VS'),
('1991', 'Salins', 'VS'),
('1992', 'Les Agettes', 'VS'),
('1992', 'Les Mayens-de-Sion', 'VS'),
('1993', 'Veysonnaz', 'VS'),
('1997', 'Siviez (Nendaz)', 'VS'),
('1996', 'Fey (Nendaz)', 'VS'),
('1996', 'Beuson (Nendaz)', 'VS'),
('1996', 'Baar (Nendaz)', 'VS'),
('1996', 'Basse-Nendaz', 'VS'),
('1997', 'Haute-Nendaz', 'VS'),
('1994', 'Aproz (Nendaz)', 'VS'),
('1962', 'Pont-de-la-Morge', 'VS'),
('1963', 'V?troz', 'VS'),
('1964', 'Conthey', 'VS'),
('1965', 'Savi?se', 'VS'),
('1966', 'Ayent', 'VS'),
('1966', 'Sign?se (Ayent)', 'VS'),
('1967', 'Bramois', 'VS'),
('1983', 'Evol?ne', 'VS'),
('1972', 'Anz?re', 'VS'),
('1988', 'Thyon', 'VS'),
('2000', 'Neuch?tel', 'NE'),
('2004', 'Neuch?tel 4', 'NE'),
('2007', 'Neuch?tel 7', 'NE'),
('2008', 'Neuch?tel', 'NE'),
('2009', 'Neuch?tel 9', 'NE'),
('2001', 'Neuch?tel 1', 'NE'),
('2002', 'Neuch?tel 2', 'NE'),
('2000', 'Neuch?tel 2 Dist', 'NE'),
('2003', 'Neuch?tel 3', 'NE'),
('2006', 'Neuch?tel 6', 'NE'),
('2012', 'Auvernier', 'NE'),
('2013', 'Colombier NE', 'NE'),
('2014', 'B?le', 'NE'),
('2015', 'Areuse', 'NE'),
('2016', 'Cortaillod', 'NE'),
('2017', 'Boudry', 'NE'),
('2022', 'Bevaix', 'NE'),
('2023', 'Gorgier', 'NE'),
('2024', 'St-Aubin-Sauges', 'NE'),
('2025', 'Chez-le-Bart', 'NE'),
('2028', 'Vaumarcus', 'NE'),
('2034', 'Peseux', 'NE'),
('2035', 'Corcelles NE', 'NE'),
('2036', 'Cormondr?che', 'NE'),
('2042', 'Valangin', 'NE'),
('2043', 'Boudevilliers', 'NE'),
('2046', 'Fontaines NE', 'NE'),
('2052', 'Fontainemelon', 'NE'),
('2053', 'Cernier', 'NE'),
('2054', 'Ch?zard-St-Martin', 'NE'),
('2054', 'Les Vieux-Pr', 'NE'),
('2056', 'Dombresson', 'NE'),
('2057', 'Villiers', 'NE'),
('2058', 'Le P?quier NE', 'NE'),
('2063', 'Vilars NE', 'NE'),
('2065', 'Savagnier', 'NE'),
('2067', 'Chaumont', 'NE'),
('2068', 'Hauterive NE', 'NE'),
('2072', 'St-Blaise', 'NE'),
('2073', 'Enges', 'NE'),
('2074', 'Marin-Epagnier', 'NE'),
('3238', 'Gals', 'BE'),
('2087', 'Cornaux NE', 'NE'),
('2088', 'Cressier NE', 'NE'),
('2318', 'Brot-Plamboz', 'NE'),
('2103', 'Noiraigue', 'NE'),
('2105', 'Travers', 'NE'),
('2108', 'Couvet', 'NE'),
('2112', 'M?tiers NE', 'NE'),
('2113', 'Boveresse', 'NE'),
('2114', 'Fleurier', 'NE'),
('2115', 'Buttes', 'NE'),
('2117', 'La C?te-aux-F?es', 'NE'),
('2123', 'St-Sulpice NE', 'NE'),
('2406', 'La Br?vine', 'NE'),
('2126', 'Les Verri?res', 'NE'),
('2406', 'Le Brouillet', 'NE'),
('2406', 'Les Taill?res', 'NE'),
('2127', 'Les Bayards', 'NE'),
('2149', 'Champ-du-Moulin', 'NE'),
('2124', 'Les Sagnettes', 'NE'),
('2116', 'Mont-de-Buttes', 'NE'),
('1454', 'La Vraconnaz', 'VD'),
('2019', 'Chambrelien', 'NE'),
('2019', 'Rochefort', 'NE'),
('2037', 'Montmollin', 'NE'),
('2206', 'Geneveys-Coffrane', 'NE'),
('2207', 'Coffrane', 'NE'),
('2208', 'Les Hauts-Geneveys', 'NE'),
('2300', 'La Chaux-de-Fonds', 'NE'),
('2300', 'La Chaux-de-Fds 1', 'NE'),
('2302', 'La Chaux-de-Fonds', 'NE'),
('2303', 'La Chaux-de-Fonds', 'NE'),
('2306', 'La Chaux-de-Fonds', 'NE'),
('2300', 'Chdfds 1 Dist', 'NE'),
('2301', 'La Chaux-de-Fonds', 'NE'),
('2304', 'La Chaux-de-Fonds', 'NE'),
('2316', 'Petit-Martel', 'NE'),
('2338', 'Les Emibois', 'JU'),
('2314', 'La Sagne NE', 'NE'),
('2316', 'Ponts-de-Martel', 'NE'),
('2322', 'Le Cr?t-du-Locle', 'NE'),
('2325', 'Les Planchettes', 'NE'),
('2300', 'La Cibourg', 'NE'),
('2333', 'La Ferri?re', 'BE'),
('2336', 'Les Bois', 'JU'),
('2400', 'Le Locle', 'NE'),
('2406', 'La Ch?tagne', 'NE'),
('2405', 'La Chaux-du-Milieu', 'NE'),
('2400', 'Le Pr?voux', 'NE'),
('2414', 'Cerneux-P?quignot', 'NE'),
('2416', 'Les Brenets', 'NE'),
('2500', 'Biel/Bienne', 'BE'),
('2500', 'Biel/Bienne 1', 'BE'),
('2500', 'Biel/Bienne 3', 'BE'),
('2500', 'Biel/Bienne 4', 'BE'),
('2500', 'Biel/Bienne 6', 'BE'),
('2500', 'Biel/Bienne 7', 'BE'),
('2500', 'Biel/Bienne 8', 'BE'),
('2500', 'Biel/Bienne 1 Zust', 'BE'),
('2501', 'Biel/Bienne', 'BE'),
('2502', 'Biel/Bienne', 'BE'),
('2503', 'Biel/Bienne', 'BE'),
('2504', 'Biel/Bienne', 'BE'),
('2505', 'Biel/Bienne', 'BE'),
('2512', 'T?scherz-Alferm', 'BE'),
('2513', 'Twann', 'BE'),
('2514', 'Ligerz', 'BE'),
('2515', 'Pr?les', 'BE'),
('2516', 'Lamboing', 'BE'),
('2517', 'Diesse', 'BE'),
('2518', 'Nods', 'BE'),
('2520', 'La Neuveville', 'BE'),
('2523', 'Ligni?res', 'NE'),
('2525', 'Le Landeron', 'NE'),
('2532', 'Magglingen/Macolin', 'BE'),
('2533', 'Evilard', 'BE'),
('2534', 'Orvin', 'BE'),
('2534', 'Les Pr?s-d''Orvin', 'BE'),
('2535', 'Frinvillier', 'BE'),
('2536', 'Plagne', 'BE'),
('2537', 'Vauffelin', 'BE'),
('2538', 'Romont BE', 'BE'),
('2540', 'Grenchen', 'SO'),
('2540', 'Grenchen 1', 'SO'),
('2540', 'Grenchen 2', 'SO'),
('2542', 'Pieterlen', 'BE'),
('2543', 'Lengnau BE', 'BE'),
('2544', 'Bettlach', 'SO'),
('2545', 'Selzach', 'SO'),
('2552', 'Orpund', 'BE'),
('2553', 'Safnern', 'BE'),
('2554', 'Meinisberg', 'BE'),
('2555', 'Br?gg BE', 'BE'),
('2556', 'Scheuren', 'BE'),
('2557', 'Studen BE', 'BE'),
('2558', 'Aegerten', 'BE'),
('2560', 'Nidau', 'BE'),
('2562', 'Port', 'BE'),
('2563', 'Ipsach', 'BE'),
('2564', 'Bellmund', 'BE'),
('2565', 'Jens', 'BE'),
('2572', 'Sutz', 'BE'),
('2575', 'T?uffelen', 'BE'),
('2576', 'L?scherz', 'BE'),
('2577', 'Siselen BE', 'BE'),
('3237', 'Br?ttelen', 'BE'),
('2603', 'P?ry', 'BE'),
('2604', 'La Heutte', 'BE'),
('2605', 'Sonceboz-Sombeval', 'BE'),
('2606', 'Corg?mont', 'BE'),
('2607', 'Cort?bert', 'BE'),
('2608', 'Courtelary', 'BE'),
('2608', 'Mtgne-Courtelary', 'BE'),
('2610', 'St-Imier', 'BE'),
('2610', 'Mont-Soleil', 'BE'),
('2610', 'Mont-Crosin', 'BE'),
('2612', 'Cormoret', 'BE'),
('2613', 'Villeret', 'BE'),
('2615', 'Sonvilier', 'BE'),
('2615', 'Montagne-Sonvilier', 'BE'),
('2616', 'Renan BE', 'BE'),
('2710', 'Tavannes', 'BE'),
('2712', 'Le Fuet', 'BE'),
('2714', 'Le Pr?dame', 'JU'),
('2717', 'Fornet-Dessous', 'BE'),
('2718', 'Fornet-Dessus', 'JU'),
('2716', 'Sornetan', 'BE'),
('2713', 'Bellelay', 'BE'),
('2714', 'Les Genevez JU', 'JU'),
('2718', 'Lajoux JU', 'JU'),
('2720', 'Tramelan', 'BE'),
('2720', 'La Tanne', 'BE'),
('2722', 'Les Reussilles', 'BE'),
('2723', 'Mont-Tramelan', 'BE'),
('2345', 'Les Breuleux', 'JU'),
('2345', 'Le Cerneux-Veusil', 'JU'),
('2345', 'Chaux-des-Breuleux', 'JU'),
('2340', 'Le Noirmont', 'JU'),
('2350', 'Saignel?gier', 'JU'),
('2353', 'Les Pommerats', 'JU'),
('2354', 'Goumois', 'JU'),
('2732', 'Reconvilier', 'BE'),
('2732', 'Saicourt', 'BE'),
('2732', 'Saules BE', 'BE'),
('2732', 'Loveresse', 'BE'),
('2733', 'Pontenet', 'BE'),
('2735', 'Malleray-B?vilard', 'BE'),
('2735', 'B?vilard', 'BE'),
('2736', 'Sorvilier', 'BE'),
('2738', 'Court', 'BE'),
('2740', 'Moutier', 'BE'),
('2740', 'Moutier 1', 'BE'),
('2740', 'Moutier 2', 'BE'),
('2742', 'Perrefitte', 'BE'),
('2748', 'Souboz', 'BE'),
('2743', 'Eschert', 'BE'),
('2744', 'Belprahon', 'BE'),
('2747', 'Seehof', 'BE'),
('2745', 'Grandval', 'BE'),
('2746', 'Cr?mines', 'BE'),
('2747', 'Corcelles BE', 'BE'),
('2762', 'Roches BE', 'BE'),
('2832', 'Rebeuvelier', 'JU'),
('2830', 'Courrendlin', 'JU'),
('2800', 'Del?mont', 'JU'),
('2800', 'Del?mont 1', 'JU'),
('2800', 'Del?mont 2', 'JU'),
('2800', 'Del?mont 1 Dist', 'JU'),
('2802', 'Develier', 'JU'),
('2803', 'Bourrignon', 'JU'),
('2805', 'Soyhi?res', 'JU'),
('2806', 'Mettembert', 'JU'),
('2807', 'Pleigne', 'JU'),
('2807', 'Lucelle', 'JU'),
('2812', 'Movelier', 'JU'),
('2813', 'Ederswiler', 'JU'),
('2814', 'Roggenburg', 'BL'),
('2822', 'Courroux', 'JU'),
('2823', 'Courcelon', 'JU'),
('2824', 'Vicques', 'JU'),
('2825', 'Courchapoix', 'JU'),
('2826', 'Corban', 'JU'),
('2827', 'Mervelier', 'JU'),
('2828', 'Montsevelier', 'JU'),
('2829', 'Vermes', 'JU'),
('2842', 'Rossemaison', 'JU'),
('2843', 'Ch?tillon JU', 'JU'),
('2852', 'Court?telle', 'JU'),
('2853', 'Courfaivre', 'JU'),
('2854', 'Bassecourt', 'JU'),
('2855', 'Glovelier', 'JU'),
('2856', 'Bo?court', 'JU'),
('2857', 'Montavon', 'JU'),
('2863', 'Undervelier', 'JU'),
('2864', 'Soulce', 'JU'),
('2873', 'Saulcy', 'JU'),
('2882', 'St-Ursanne', 'JU'),
('2883', 'Montmelon', 'JU'),
('2884', 'Montenol', 'JU'),
('2885', 'Epauvillers', 'JU'),
('2886', 'Epiquerez', 'JU'),
('2887', 'Soubey', 'JU'),
('2888', 'Seleute', 'JU'),
('2889', 'Ocourt', 'JU'),
('2950', 'Courgenay', 'JU'),
('2900', 'Porrentruy', 'JU'),
('2900', 'Porrentruy 1', 'JU'),
('2900', 'Porrentruy 2', 'JU'),
('2900', 'Porrentruy 1 Dist', 'JU'),
('2902', 'Fontenais', 'JU'),
('2903', 'Villars-Fontenais', 'JU'),
('2904', 'Bressaucourt', 'JU'),
('2905', 'Courtedoux', 'JU'),
('2906', 'Chevenez', 'JU'),
('2907', 'Rocourt', 'JU'),
('2908', 'Grandfontaine', 'JU'),
('2912', 'Roche-d''Or', 'JU'),
('2914', 'Damvant', 'JU'),
('2915', 'Bure', 'JU'),
('2916', 'Fahy', 'JU'),
('2922', 'Courchavon', 'JU'),
('2923', 'Courtema?che', 'JU'),
('2924', 'Montignez', 'JU'),
('2925', 'Buix', 'JU'),
('2926', 'Boncourt', 'JU'),
('2932', 'Coeuve', 'JU'),
('2935', 'Beurnev?sin', 'JU'),
('2942', 'Alle', 'JU'),
('2943', 'Vendlincourt', 'JU'),
('2944', 'Bonfol', 'JU'),
('2946', 'Mi?court', 'JU'),
('2947', 'Charmoille', 'JU'),
('2952', 'Cornol', 'JU'),
('2953', 'Fregi?court-Pleuj', 'JU'),
('2954', 'Asuel', 'JU'),
('3000', 'Bern', 'BE'),
('3000', 'Bern 5', 'BE'),
('3000', 'Bern 6', 'BE'),
('3000', 'Bern 8', 'BE'),
('3000', 'Bern 9', 'BE'),
('3000', 'Bern 13', 'BE'),
('3000', 'Bern 14', 'BE'),
('3000', 'Bern 15', 'BE'),
('3000', 'Bern 21', 'BE'),
('3000', 'Bern 22', 'BE'),
('3000', 'Bern 23', 'BE'),
('3000', 'Bern 25', 'BE'),
('3000', 'Bern 31', 'BE'),
('3000', 'Bern 1 Zustellung', 'BE'),
('3000', 'Bern Postauto', 'BE'),
('3001', 'Bern', 'BE'),
('3002', 'Bern Postfinance', 'BE'),
('3003', 'Bern', 'BE'),
('3004', 'Bern', 'BE'),
('3005', 'Bern', 'BE'),
('3006', 'Bern', 'BE'),
('3007', 'Bern', 'BE'),
('3008', 'Bern', 'BE'),
('3010', 'Bern', 'BE'),
('3011', 'Bern', 'BE'),
('3012', 'Bern', 'BE'),
('3013', 'Bern', 'BE'),
('3014', 'Bern', 'BE'),
('3015', 'Bern', 'BE'),
('3018', 'Bern', 'BE'),
('3019', 'Bern', 'BE'),
('3020', 'Bern', 'BE'),
('3027', 'Bern', 'BE'),
('3095', 'Spiegel b. Bern', 'BE'),
('8000', 'Z?rich', 'ZH'),
('8001', 'Z?rich', 'ZH'),
('8002', 'Z?rich', 'ZH'),
('8003', 'Z?rich', 'ZH'),
('8004', 'Z?rich', 'ZH'),
('8005', 'Z?rich', 'ZH'),
('8006', 'Z?rich', 'ZH'),
('8008', 'Z?rich', 'ZH'),
('8010', 'Z?rich', 'ZH'),
('8010', 'Z?rich M? Ann.', 'ZH'),
('8020', 'Z?rich 1', 'ZH'),
('8016', 'Z?rich 16 Zust', 'ZH'),
('8080', 'Z?rich 80', 'ZH'),
('8021', 'Z?rich 1 Sihlpost', 'ZH'),
('8021', 'Z?rich 1', 'ZH'),
('8022', 'Z?rich', 'ZH'),
('8023', 'Z?rich', 'ZH'),
('8024', 'Z?rich', 'ZH'),
('8026', 'Z?rich', 'ZH'),
('8027', 'Z?rich', 'ZH'),
('8030', 'Z?rich', 'ZH'),
('8031', 'Z?rich', 'ZH'),
('8032', 'Z?rich', 'ZH'),
('8032', 'Z?rich 32 Zust', 'ZH'),
('8033', 'Z?rich', 'ZH'),
('8034', 'Z?rich', 'ZH'),
('8036', 'Z?rich', 'ZH'),
('8037', 'Z?rich', 'ZH'),
('8038', 'Z?rich', 'ZH'),
('8039', 'Z?rich', 'ZH'),
('8040', 'Z?rich', 'ZH'),
('8041', 'Z?rich', 'ZH'),
('8042', 'Z?rich', 'ZH'),
('8044', 'Z?rich', 'ZH'),
('8045', 'Z?rich', 'ZH'),
('8046', 'Z?rich', 'ZH'),
('8047', 'Z?rich', 'ZH'),
('8048', 'Z?rich', 'ZH'),
('8049', 'Z?rich', 'ZH'),
('8050', 'Z?rich', 'ZH'),
('8050', 'Z?rich Dist Ba', 'ZH'),
('8051', 'Z?rich', 'ZH'),
('8052', 'Z?rich', 'ZH'),
('8053', 'Z?rich', 'ZH'),
('8055', 'Z?rich', 'ZH'),
('8057', 'Z?rich', 'ZH'),
('8058', 'Z?rich', 'ZH'),
('8061', 'Z?rich', 'ZH'),
('8063', 'Z?rich', 'ZH'),
('8064', 'Z?rich', 'ZH'),
('8065', 'Z?rich', 'ZH'),
('8088', 'Z?rich', 'ZH'),
('8090', 'Z?rich', 'ZH'),
('8091', 'Z?rich', 'ZH'),
('8092', 'Z?rich', 'ZH'),
('8636', 'Wald ZH Zustellung', 'ZH'),
('4950', 'Huttwil Zustellung', 'BE'),
('8304', 'Wallisellen Zust', 'ZH'),
('3800', 'Interlaken Zust', 'BE'),
('8570', 'Weinfelden Zust', 'TG'),
('3303', 'Jegenstorf Zust', 'BE'),
('8126', 'Zumikon Zust', 'ZH'),
('3098', 'K?niz Zustellung', 'BE'),
('8405', 'Winterthur 5 Zust', 'ZH'),
('8406', 'Winterthur 6 Zust', 'ZH'),
('3422', 'Kirchberg BE Zust', 'BE'),
('8408', 'Winterthur 8 Zust', 'ZH'),
('3510', 'Konolfingen 1 Zust', 'BE'),
('8037', 'Z?rich 37 Zust', 'ZH'),
('4900', 'Langenthal 1 Zust', 'BE'),
('8048', 'Z?rich 48 Zust', 'ZH'),
('8050', 'Z?rich Nord Zust', 'ZH'),
('8053', 'Z?rich 53 Zust', 'ZH'),
('8057', 'Z?rich 57 Zust', 'ZH'),
('9050', 'Appenzell Zust', 'AI'),
('9100', 'Herisau 1 Zust', 'AR'),
('9008', 'St. Gallen 8 Zust', 'SG'),
('6830', 'Chiasso Dist', 'TI'),
('6850', 'Mendrisio Dist', 'TI'),
('3053', 'M''buchsee Zust', 'BE'),
('3110', 'M?nsingen Zust', 'BE'),
('4704', 'Niederbipp Zust', 'BE'),
('2560', 'Nidau Zustellung', 'BE'),
('9470', 'Buchs SG Dist Fil', 'SG'),
('8867', 'Niederurnen Dist F', 'GL'),
('7302', 'Landquart Dist Ba', 'GR'),
('6430', 'Schwyz Dist Fil', 'SZ'),
('6370', 'Stans Dist Fil', 'NW'),
('5200', 'Brugg AG Dist Fil', 'AG'),
('3960', 'Sierre Dist Fil', 'VS'),
('1630', 'Bulle Dist Fil', 'FR'),
('1196', 'Gland Dist Fil', 'VD'),
('5624', 'Waldh?usern AG', 'AG'),
('8087', 'Z?rich', 'ZH'),
('3000', 'Bern 65', 'BE'),
('5510', 'Hunzenschwil LZ', 'AG'),
('1066', 'Epalinges Dist', 'VD'),
('1033', 'Cheseaux Dist', 'VD'),
('3960', 'Niouc', 'VS'),
('4410', 'Liestal Dist Fil', 'BL'),
('1912', 'Produit (Leytron)', 'VS'),
('1912', 'Montagnon(Leytron)', 'VS'),
('1912', 'Dugny (Leytron)', 'VS'),
('1914', 'Auddes-sur-Riddes', 'VS'),
('1932', 'Les Valettes', 'VS'),
('1933', 'Vens(Sembrancher)', 'VS'),
('1933', 'Chamoille', 'VS'),
('1933', 'La Garde', 'VS'),
('1934', 'Cotterg(Le Ch?ble)', 'VS'),
('1934', 'Villette', 'VS'),
('1934', 'Fontenelle', 'VS'),
('1934', 'Montagnier', 'VS'),
('1941', 'Cries (Voll?ges)', 'VS'),
('1945', 'Fontaine Dessus', 'VS'),
('1945', 'Fontaine Dessous', 'VS'),
('1945', 'Dranse (Liddes)', 'VS'),
('1945', 'Chandonne (Liddes)', 'VS'),
('1945', 'Rive Haute(Liddes)', 'VS'),
('1945', 'Fornex(Liddes)', 'VS'),
('1945', 'Les Moulins VS', 'VS'),
('1945', 'Vich?res (Liddes)', 'VS'),
('1945', 'Palasuit (Liddes)', 'VS'),
('1945', 'Chez Petit(Liddes)', 'VS'),
('1945', 'Petit Vich?res', 'VS'),
('1947', 'Prarreyer', 'VS'),
('1947', 'Les Places', 'VS'),
('1947', 'La Montoz', 'VS'),
('1947', 'Champsec', 'VS'),
('1947', 'Le Fregnoley', 'VS'),
('1948', 'Le Planchamp', 'VS'),
('1948', 'Le Morgnes', 'VS'),
('1955', 'Les V?rines', 'VS'),
('1955', 'N?miaz (Chamoson)', 'VS'),
('1955', 'Grugnay (Chamoson)', 'VS'),
('1965', 'Roumaz (Savi?se)', 'VS'),
('1965', 'Granois (Savi?se)', 'VS'),
('1965', 'St-Germain', 'VS'),
('1965', 'Orm?ne (Savi?se)', 'VS'),
('1965', 'Mayens-de-la-Zour', 'VS'),
('1966', 'Fortunau (Ayent)', 'VS'),
('1966', 'Luc (Ayent)', 'VS'),
('1966', 'St-Romain (Ayent)', 'VS'),
('1966', 'Saxonne (Ayent)', 'VS'),
('1966', 'Villa (Ayent)', 'VS'),
('1966', 'La Place (Ayent)', 'VS'),
('1966', 'Botyre (Ayent)', 'VS'),
('1966', 'Blignou (Ayent)', 'VS'),
('1966', 'Argnou (Ayent)', 'VS'),
('1969', 'Liez (St-Martin)', 'VS'),
('1969', 'Trogne (St-Martin)', 'VS'),
('1969', 'Suen (St-Martin)', 'VS'),
('1971', 'Champlan', 'VS'),
('1983', 'Lana (Evol?ne)', 'VS'),
('1991', 'Arvillard (Salins)', 'VS'),
('1991', 'Pravidondaz', 'VS'),
('1991', 'Turin (Salins)', 'VS'),
('1991', 'Mis?riez (Salins)', 'VS'),
('1993', 'Cl?bes (Nendaz)', 'VS'),
('1996', 'Brignon (Nendaz)', 'VS'),
('1971', 'Com?raz(Grimisuat)', 'VS'),
('1992', 'La Vernaz', 'VS'),
('1992', 'Cr?te-?-l''Oeil', 'VS'),
('1996', 'Bioley-de-Brignon', 'VS'),
('1996', 'Bieudron (Nendaz)', 'VS'),
('1996', 'Cond?mines (Nendaz', 'VS'),
('1996', 'Saclentz (Nendaz)', 'VS'),
('4078', 'Basel Reader''s D.', 'BS'),
('1911', 'Mayens-de-Chamoson', 'VS'),
('1585', 'Cotterd', 'VD'),
('1873', 'Champoussin', 'VS'),
('2063', 'Fenin', 'NE'),
('2063', 'Saules', 'NE'),
('1873', 'Les Crosets', 'VS'),
('1095', 'Lutry Distribution', 'VD'),
('1052', 'Mont-Lausanne Dist', 'VD'),
('2013', 'Colombier NE Dist', 'NE'),
('2074', 'Marin-Epagnier Dis', 'NE'),
('2520', 'La Neuveville Dist', 'BE'),
('2710', 'Tavannes Dist', 'BE'),
('2720', 'Tramelan Dist', 'BE'),
('2735', 'Malleray-B?v. Dist', 'BE'),
('2610', 'St-Imier Dist', 'BE'),
('1470', 'Estavayer-le-Lac D', 'FR'),
('1580', 'Avenches Dist', 'VD'),
('1510', 'Moudon Dist', 'VD'),
('3186', 'D?dingen Zust', 'FR'),
('1680', 'Romont FR Dist', 'FR'),
('1844', 'Villeneuve VD Dist', 'VD'),
('1880', 'Bex Distribution', 'VD'),
('1233', 'Bernex Dist', 'GE'),
('1214', 'Vernier Dist', 'GE'),
('1180', 'Rolle Distribution', 'VD'),
('1040', 'Echallens Dist', 'VD'),
('3150', 'Schwarzenburg Zust', 'BE'),
('3177', 'Laupen BE Zust', 'BE'),
('3210', 'Kerzers Zust', 'FR'),
('3294', 'B?ren a.A. Zust', 'BE'),
('3415', 'Hasle-R?egsau Zust', 'BE'),
('3855', 'Brienz BE Zust', 'BE'),
('3860', 'Meiringen Zust', 'BE'),
('4450', 'Sissach Zustellung', 'BL'),
('4460', 'Gelterkinden Zust', 'BL'),
('4512', 'Bellach Zustellung', 'SO'),
('4552', 'Derendingen Zust', 'SO');