-- Communes de France métropolitaine de 10 000 habitants ou plus (population municipale, recensement 2023)
-- Sources : INSEE (populations légales 2023) et La Poste (codes postaux), via @etalab/decoupage-administratif 6.0.0
-- Encodage : UTF-8 (base Oracle en AL32UTF8 recommandée)

CREATE TABLE villes (
  id          NUMBER(5)          NOT NULL,
  code_postal VARCHAR2(5 CHAR)   NOT NULL,
  departement VARCHAR2(2 CHAR)   NOT NULL,
  commune     VARCHAR2(100 CHAR) NOT NULL,
  population  NUMBER(8)          NOT NULL,
  CONSTRAINT pk_villes PRIMARY KEY (id),
  CONSTRAINT ck_villes_pop CHECK (population >= 10000)
);

SET DEFINE OFF;

INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (1, '01500', '01', 'Ambérieu-en-Bugey', 15934);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (2, '01000', '01', 'Bourg-en-Bresse', 42372);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (3, '01220', '01', 'Divonne-les-Bains', 10464);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (4, '01210', '01', 'Ferney-Voltaire', 12094);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (5, '01170', '01', 'Gex', 13627);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (6, '01700', '01', 'Miribel', 10395);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (7, '01100', '01', 'Oyonnax', 22480);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (8, '01630', '01', 'Saint-Genis-Pouilly', 14432);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (9, '01200', '01', 'Valserhône', 16712);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (10, '02300', '02', 'Chauny', 11596);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (11, '02400', '02', 'Château-Thierry', 15097);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (12, '02000', '02', 'Laon', 24220);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (13, '02100', '02', 'Saint-Quentin', 52813);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (14, '02200', '02', 'Soissons', 28046);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (15, '02700', '02', 'Tergnier', 13045);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (16, '02600', '02', 'Villers-Cotterêts', 10489);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (17, '03300', '03', 'Cusset', 13316);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (18, '03100', '03', 'Montluçon', 33147);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (19, '03000', '03', 'Moulins', 19206);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (20, '03200', '03', 'Vichy', 25115);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (21, '03400', '03', 'Yzeure', 12897);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (22, '04000', '04', 'Digne-les-Bains', 17979);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (23, '04100', '04', 'Manosque', 22718);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (24, '05100', '05', 'Briançon', 11411);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (25, '05000', '05', 'Gap', 41293);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (26, '06160', '06', 'Antibes', 77637);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (27, '06240', '06', 'Beausoleil', 11936);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (28, '06410', '06', 'Biot', 10511);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (29, '06800', '06', 'Cagnes-sur-Mer', 53354);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (30, '06150', '06', 'Cannes', 74350);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (31, '06510', '06', 'Carros', 13803);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (32, '06130', '06', 'Grasse', 50970);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (33, '06340', '06', 'La Trinité', 10602);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (34, '06110', '06', 'Le Cannet', 41938);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (35, '06210', '06', 'Mandelieu-la-Napoule', 21640);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (36, '06500', '06', 'Menton', 30604);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (37, '06370', '06', 'Mouans-Sartoux', 11015);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (38, '06250', '06', 'Mougins', 19782);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (39, '06000', '06', 'Nice', 357737);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (40, '06190', '06', 'Roquebrune-Cap-Martin', 12037);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (41, '06700', '06', 'Saint-Laurent-du-Var', 32172);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (42, '06560', '06', 'Valbonne', 11939);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (43, '06220', '06', 'Vallauris', 29259);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (44, '06140', '06', 'Vence', 19917);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (45, '06270', '06', 'Villeneuve-Loubet', 17548);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (46, '07100', '07', 'Annonay', 17274);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (47, '07200', '07', 'Aubenas', 12416);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (48, '07500', '07', 'Guilherand-Granges', 11235);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (49, '07300', '07', 'Tournon-sur-Rhône', 11279);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (50, '08000', '08', 'Charleville-Mézières', 45560);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (51, '08200', '08', 'Sedan', 16667);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (52, '09100', '09', 'Pamiers', 16473);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (53, '10600', '10', 'La Chapelle-Saint-Luc', 12648);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (54, '10100', '10', 'Romilly-sur-Seine', 14959);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (55, '10120', '10', 'Saint-André-les-Vergers', 12806);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (56, '10300', '10', 'Sainte-Savine', 10289);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (57, '10000', '10', 'Troyes', 62088);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (58, '11000', '11', 'Carcassonne', 46080);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (59, '11400', '11', 'Castelnaudary', 12151);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (60, '11300', '11', 'Limoux', 10532);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (61, '11200', '11', 'Lézignan-Corbières', 10343);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (62, '11100', '11', 'Narbonne', 57587);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (63, '12100', '12', 'Millau', 22044);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (64, '12000', '12', 'Onet-le-Château', 12080);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (65, '12000', '12', 'Rodez', 23981);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (66, '12200', '12', 'Villefranche-de-Rouergue', 11271);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (67, '13080', '13', 'Aix-en-Provence', 149695);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (68, '13190', '13', 'Allauch', 21443);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (69, '13104', '13', 'Arles', 51811);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (70, '13400', '13', 'Aubagne', 47529);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (71, '13390', '13', 'Auriol', 13037);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (72, '13130', '13', 'Berre-l''Étang', 13832);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (73, '13320', '13', 'Bouc-Bel-Air', 15381);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (74, '13480', '13', 'Cabriès', 10240);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (75, '13220', '13', 'Châteauneuf-les-Martigues', 18455);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (76, '13160', '13', 'Châteaurenard', 16545);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (77, '13270', '13', 'Fos-sur-Mer', 15862);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (78, '13710', '13', 'Fuveau', 10337);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (79, '13120', '13', 'Gardanne', 21597);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (80, '13180', '13', 'Gignac-la-Nerthe', 10343);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (81, '13118', '13', 'Istres', 44292);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (82, '13600', '13', 'La Ciotat', 38477);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (83, '13410', '13', 'Lambesc', 10024);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (84, '13170', '13', 'Les Pennes-Mirabeau', 22537);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (85, '13700', '13', 'Marignane', 33692);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (86, '13001', '13', 'Marseille', 886040);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (87, '13117', '13', 'Martigues', 48298);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (88, '13140', '13', 'Miramas', 26203);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (89, '13380', '13', 'Plan-de-Cuques', 11632);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (90, '13110', '13', 'Port-de-Bouc', 15802);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (91, '13330', '13', 'Pélissanne', 11085);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (92, '13340', '13', 'Rognac', 12576);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (93, '13310', '13', 'Saint-Martin-de-Crau', 14145);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (94, '13300', '13', 'Salon-de-Provence', 44194);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (95, '13240', '13', 'Septèmes-les-Vallons', 11995);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (96, '13150', '13', 'Tarascon', 15396);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (97, '13530', '13', 'Trets', 10946);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (98, '13127', '13', 'Vitrolles', 36758);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (99, '14400', '14', 'Bayeux', 12659);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (100, '14000', '14', 'Caen', 109400);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (101, '14200', '14', 'Hérouville-Saint-Clair', 23470);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (102, '14123', '14', 'Ifs', 11937);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (103, '14100', '14', 'Lisieux', 19645);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (104, '14120', '14', 'Mondeville', 10331);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (105, '14500', '14', 'Vire Normandie', 17457);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (106, '15000', '15', 'Aurillac', 26214);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (107, '16000', '16', 'Angoulême', 41908);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (108, '16100', '16', 'Cognac', 18532);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (109, '16800', '16', 'Soyaux', 10087);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (110, '17000', '17', 'La Rochelle', 79851);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (111, '17300', '17', 'Rochefort', 23460);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (112, '17200', '17', 'Royan', 19425);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (113, '17100', '17', 'Saintes', 25363);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (114, '18000', '18', 'Bourges', 64186);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (115, '18100', '18', 'Vierzon', 25068);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (116, '19100', '19', 'Brive-la-Gaillarde', 47095);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (117, '19000', '19', 'Tulle', 13401);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (118, '21200', '21', 'Beaune', 20352);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (119, '21300', '21', 'Chenôve', 14244);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (120, '21800', '21', 'Chevigny-Saint-Sauveur', 11108);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (121, '21000', '21', 'Dijon', 161830);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (122, '21240', '21', 'Talant', 11896);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (123, '22100', '22', 'Dinan', 14764);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (124, '22400', '22', 'Lamballe-Armor', 17241);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (125, '22300', '22', 'Lannion', 20315);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (126, '22440', '22', 'Ploufragan', 11507);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (127, '22190', '22', 'Plérin', 14425);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (128, '22000', '22', 'Saint-Brieuc', 44364);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (129, '23000', '23', 'Guéret', 12955);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (130, '24100', '24', 'Bergerac', 27110);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (131, '24330', '24', 'Boulazac Isle Manoire', 10759);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (132, '24000', '24', 'Périgueux', 29055);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (133, '25400', '25', 'Audincourt', 14071);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (134, '25000', '25', 'Besançon', 118489);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (135, '25200', '25', 'Montbéliard', 24672);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (136, '25300', '25', 'Pontarlier', 18067);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (137, '25700', '25', 'Valentigney', 10501);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (138, '26500', '26', 'Bourg-lès-Valence', 19992);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (139, '26200', '26', 'Montélimar', 40595);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (140, '26700', '26', 'Pierrelatte', 13756);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (141, '26800', '26', 'Portes-lès-Valence', 10477);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (142, '26100', '26', 'Romans-sur-Isère', 33464);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (143, '26000', '26', 'Valence', 64458);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (144, '27140', '27', 'Gisors', 12410);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (145, '27400', '27', 'Louviers', 18705);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (146, '27500', '27', 'Pont-Audemer', 10023);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (147, '27100', '27', 'Val-de-Reuil', 13245);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (148, '27200', '27', 'Vernon', 25290);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (149, '27000', '27', 'Évreux', 49360);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (150, '28000', '28', 'Chartres', 38324);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (151, '28200', '28', 'Châteaudun', 12830);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (152, '28100', '28', 'Dreux', 31543);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (153, '28110', '28', 'Lucé', 15921);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (154, '28300', '28', 'Mainvilliers', 10629);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (155, '28500', '28', 'Vernouillet', 12310);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (156, '29200', '29', 'Brest', 142346);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (157, '29900', '29', 'Concarneau', 20845);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (158, '29100', '29', 'Douarnenez', 14068);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (159, '29170', '29', 'Fouesnant', 10436);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (160, '29490', '29', 'Guipavas', 15538);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (161, '29800', '29', 'Landerneau', 16363);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (162, '29480', '29', 'Le Relecq-Kerhuon', 11897);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (163, '29600', '29', 'Morlaix', 15194);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (164, '29470', '29', 'Plougastel-Daoulas', 13434);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (165, '29280', '29', 'Plouzané', 13567);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (166, '29000', '29', 'Quimper', 64385);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (167, '29300', '29', 'Quimperlé', 12469);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (168, '20000', '2A', 'Ajaccio', 76320);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (169, '20137', '2A', 'Porto-Vecchio', 11198);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (170, '20200', '2B', 'Bastia', 46867);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (171, '20290', '2B', 'Borgo', 10311);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (172, '30100', '30', 'Alès', 46125);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (173, '30200', '30', 'Bagnols-sur-Cèze', 18112);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (174, '30300', '30', 'Beaucaire', 15692);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (175, '30000', '30', 'Nîmes', 151839);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (176, '30130', '30', 'Pont-Saint-Esprit', 10958);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (177, '30800', '30', 'Saint-Gilles', 14734);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (178, '30600', '30', 'Vauvert', 11671);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (179, '30400', '30', 'Villeneuve-lès-Avignon', 13148);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (180, '31190', '31', 'Auterive', 10456);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (181, '31130', '31', 'Balma', 17772);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (182, '31700', '31', 'Blagnac', 27604);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (183, '31320', '31', 'Castanet-Tolosan', 15317);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (184, '31780', '31', 'Castelginest', 11271);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (185, '31770', '31', 'Colomiers', 40882);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (186, '31270', '31', 'Cugnaux', 20662);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (187, '31470', '31', 'Fonsorbes', 12954);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (188, '31240', '31', 'L''Union', 12638);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (189, '31600', '31', 'Muret', 26079);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (190, '31830', '31', 'Plaisance-du-Touch', 21079);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (191, '31520', '31', 'Ramonville-Saint-Agne', 15158);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (192, '31800', '31', 'Saint-Gaudens', 12139);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (193, '31240', '31', 'Saint-Jean', 11261);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (194, '31650', '31', 'Saint-Orens-de-Gameville', 14646);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (195, '31600', '31', 'Seysses', 10539);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (196, '31000', '31', 'Toulouse', 514819);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (197, '31170', '31', 'Tournefeuille', 30168);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (198, '31270', '31', 'Villeneuve-Tolosane', 11044);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (199, '32000', '32', 'Auch', 22428);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (200, '33440', '33', 'Ambarès-et-Lagrave', 17644);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (201, '33510', '33', 'Andernos-les-Bains', 12710);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (202, '33120', '33', 'Arcachon', 11092);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (203, '33380', '33', 'Biganos', 11431);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (204, '33290', '33', 'Blanquefort', 17215);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (205, '33000', '33', 'Bordeaux', 267991);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (206, '33520', '33', 'Bruges', 20020);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (207, '33130', '33', 'Bègles', 31831);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (208, '33150', '33', 'Cenon', 26834);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (209, '33610', '33', 'Cestas', 16666);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (210, '33320', '33', 'Eysines', 24825);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (211, '33270', '33', 'Floirac', 18300);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (212, '33170', '33', 'Gradignan', 26952);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (213, '33470', '33', 'Gujan-Mestras', 22153);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (214, '33115', '33', 'La Teste-de-Buch', 27566);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (215, '33110', '33', 'Le Bouscat', 25081);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (216, '33185', '33', 'Le Haillan', 11392);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (217, '33320', '33', 'Le Taillan-Médoc', 11073);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (218, '33500', '33', 'Libourne', 25036);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (219, '33310', '33', 'Lormont', 25769);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (220, '33850', '33', 'Léognan', 10670);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (221, '33380', '33', 'Mios', 12043);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (222, '33700', '33', 'Mérignac', 78090);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (223, '33290', '33', 'Parempuyre', 10672);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (224, '33600', '33', 'Pessac', 67339);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (225, '33240', '33', 'Saint-André-de-Cubzac', 12626);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (226, '33450', '33', 'Saint-Loubès', 10027);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (227, '33160', '33', 'Saint-Médard-en-Jalles', 32910);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (228, '33400', '33', 'Talence', 46338);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (229, '33140', '33', 'Villenave-d''Ornon', 42545);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (230, '34300', '34', 'Agde', 29939);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (231, '34500', '34', 'Béziers', 81545);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (232, '34170', '34', 'Castelnau-le-Lez', 26058);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (233, '34110', '34', 'Frontignan', 24136);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (234, '34990', '34', 'Juvignac', 14055);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (235, '34970', '34', 'Lattes', 17351);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (236, '34400', '34', 'Lunel', 26623);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (237, '34130', '34', 'Mauguio', 16522);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (238, '34000', '34', 'Montpellier', 310240);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (239, '34140', '34', 'Mèze', 12669);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (240, '34980', '34', 'Saint-Gély-du-Fesc', 10472);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (241, '34430', '34', 'Saint-Jean-de-Védas', 13328);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (242, '34200', '34', 'Sète', 45337);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (243, '34750', '34', 'Villeneuve-lès-Maguelone', 10872);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (244, '35830', '35', 'Betton', 12964);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (245, '35170', '35', 'Bruz', 19683);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (246, '35510', '35', 'Cesson-Sévigné', 18761);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (247, '35135', '35', 'Chantepie', 10670);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (248, '35410', '35', 'Châteaugiron', 10845);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (249, '35800', '35', 'Dinard', 10772);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (250, '35300', '35', 'Fougères', 20307);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (251, '35740', '35', 'Pacé', 11703);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (252, '35000', '35', 'Rennes', 230890);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (253, '35136', '35', 'Saint-Jacques-de-la-Lande', 13800);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (254, '35400', '35', 'Saint-Malo', 47439);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (255, '35500', '35', 'Vitré', 19365);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (256, '36000', '36', 'Châteauroux', 42963);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (257, '36100', '36', 'Issoudun', 11159);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (258, '37400', '37', 'Amboise', 12937);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (259, '37170', '37', 'Chambray-lès-Tours', 12720);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (260, '37230', '37', 'Fondettes', 10954);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (261, '37300', '37', 'Joué-lès-Tours', 38423);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (262, '37520', '37', 'La Riche', 10487);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (263, '37270', '37', 'Montlouis-sur-Loire', 11335);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (264, '37550', '37', 'Saint-Avertin', 14999);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (265, '37540', '37', 'Saint-Cyr-sur-Loire', 17029);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (266, '37700', '37', 'Saint-Pierre-des-Corps', 15898);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (267, '37000', '37', 'Tours', 139259);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (268, '38300', '38', 'Bourgoin-Jallieu', 30151);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (269, '38230', '38', 'Charvieu-Chavagneux', 10547);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (270, '38320', '38', 'Eybens', 10493);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (271, '38600', '38', 'Fontaine', 22020);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (272, '38000', '38', 'Grenoble', 156140);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (273, '38080', '38', 'L''Isle-d''Abeau', 17515);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (274, '38800', '38', 'Le Pont-de-Claix', 10956);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (275, '38240', '38', 'Meylan', 18770);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (276, '38400', '38', 'Saint-Martin-d''Hères', 37695);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (277, '38120', '38', 'Saint-Égrève', 17986);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (278, '38360', '38', 'Sassenage', 11646);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (279, '38170', '38', 'Seyssinet-Pariset', 11739);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (280, '38200', '38', 'Vienne', 31778);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (281, '38090', '38', 'Villefontaine', 19445);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (282, '38500', '38', 'Voiron', 21847);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (283, '38130', '38', 'Échirolles', 37491);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (284, '39100', '39', 'Dole', 23840);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (285, '39000', '39', 'Lons-le-Saunier', 16618);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (286, '40600', '40', 'Biscarrosse', 15836);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (287, '40100', '40', 'Dax', 22109);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (288, '40000', '40', 'Mont-de-Marsan', 31592);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (289, '40990', '40', 'Saint-Paul-lès-Dax', 14481);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (290, '40280', '40', 'Saint-Pierre-du-Mont', 10092);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (291, '40220', '40', 'Tarnos', 12957);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (292, '41000', '41', 'Blois', 47219);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (293, '41200', '41', 'Romorantin-Lanthenay', 18373);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (294, '41100', '41', 'Vendôme', 15758);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (295, '42160', '42', 'Andrézieux-Bouthéon', 10425);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (296, '42700', '42', 'Firminy', 17060);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (297, '42500', '42', 'Le Chambon-Feugerolles', 12314);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (298, '42600', '42', 'Montbrison', 16123);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (299, '42153', '42', 'Riorges', 11139);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (300, '42800', '42', 'Rive-de-Gier', 15242);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (301, '42300', '42', 'Roanne', 35409);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (302, '42400', '42', 'Saint-Chamond', 35646);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (303, '42170', '42', 'Saint-Just-Saint-Rambert', 15764);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (304, '42000', '42', 'Saint-Étienne', 173136);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (305, '43000', '43', 'Le Puy-en-Velay', 18540);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (306, '44150', '44', 'Ancenis-Saint-Géréon', 11600);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (307, '44130', '44', 'Blain', 10376);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (308, '44340', '44', 'Bouguenais', 20530);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (309, '44470', '44', 'Carquefou', 20921);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (310, '44110', '44', 'Châteaubriant', 12260);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (311, '44220', '44', 'Couëron', 24103);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (312, '44350', '44', 'Guérande', 16804);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (313, '44500', '44', 'La Baule-Escoublac', 16912);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (314, '44240', '44', 'La Chapelle-sur-Erdre', 20690);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (315, '44000', '44', 'Nantes', 327734);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (316, '44700', '44', 'Orvault', 28534);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (317, '44160', '44', 'Pontchâteau', 11474);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (318, '44210', '44', 'Pornic', 18745);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (319, '44380', '44', 'Pornichet', 12800);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (320, '44400', '44', 'Rezé', 43556);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (321, '44250', '44', 'Saint-Brevin-les-Pins', 14541);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (322, '44800', '44', 'Saint-Herblain', 50973);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (323, '44600', '44', 'Saint-Nazaire', 74568);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (324, '44230', '44', 'Saint-Sébastien-sur-Loire', 28596);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (325, '44980', '44', 'Sainte-Luce-sur-Loire', 16400);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (326, '44470', '44', 'Thouaré-sur-Loire', 11004);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (327, '44119', '44', 'Treillières', 10600);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (328, '44120', '44', 'Vertou', 26227);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (329, '45200', '45', 'Amilly', 13582);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (330, '45120', '45', 'Châlette-sur-Loing', 12677);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (331, '45400', '45', 'Fleury-les-Aubrais', 21804);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (332, '45500', '45', 'Gien', 13459);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (333, '45140', '45', 'Ingré', 10062);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (334, '45380', '45', 'La Chapelle-Saint-Mesmin', 11017);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (335, '45200', '45', 'Montargis', 14825);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (336, '45160', '45', 'Olivet', 23507);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (337, '45000', '45', 'Orléans', 116357);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (338, '45800', '45', 'Saint-Jean-de-Braye', 23147);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (339, '45140', '45', 'Saint-Jean-de-la-Ruelle', 16768);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (340, '45770', '45', 'Saran', 17316);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (341, '46000', '46', 'Cahors', 20050);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (342, '47000', '47', 'Agen', 32801);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (343, '47200', '47', 'Marmande', 17328);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (344, '47300', '47', 'Villeneuve-sur-Lot', 22350);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (345, '48000', '48', 'Mende', 12464);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (346, '49000', '49', 'Angers', 159022);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (347, '49240', '49', 'Avrillé', 15251);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (348, '49150', '49', 'Baugé-en-Anjou', 11712);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (349, '49110', '49', 'Beaupréau-en-Mauges', 23989);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (350, '49250', '49', 'Brissac Loire Aubance', 10878);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (351, '49120', '49', 'Chemillé-en-Anjou', 21999);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (352, '49300', '49', 'Cholet', 54404);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (353, '49700', '49', 'Doué-en-Anjou', 11029);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (354, '49130', '49', 'Les Ponts-de-Cé', 13149);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (355, '49140', '49', 'Loire-Authion', 16765);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (356, '49110', '49', 'Mauges-sur-Loire', 18695);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (357, '49110', '49', 'Montrevault-sur-Èvre', 15726);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (358, '49270', '49', 'Orée d''Anjou', 17162);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (359, '49400', '49', 'Saumur', 26241);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (360, '49500', '49', 'Segré-en-Anjou Bleu', 17667);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (361, '49230', '49', 'Sèvremoine', 25797);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (362, '49800', '49', 'Trélazé', 16333);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (363, '50300', '50', 'Avranches', 10143);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (364, '50480', '50', 'Carentan-les-Marais', 10218);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (365, '50100', '50', 'Cherbourg-en-Cotentin', 78258);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (366, '50400', '50', 'Granville', 12510);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (367, '50440', '50', 'La Hague', 11484);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (368, '50000', '50', 'Saint-Lô', 19471);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (369, '51000', '51', 'Châlons-en-Champagne', 42971);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (370, '51100', '51', 'Reims', 177674);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (371, '51430', '51', 'Tinqueux', 10771);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (372, '51300', '51', 'Vitry-le-François', 10996);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (373, '51200', '51', 'Épernay', 22174);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (374, '52000', '52', 'Chaumont', 20827);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (375, '52100', '52', 'Saint-Dizier', 22858);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (376, '53200', '53', 'Château-Gontier-sur-Mayenne', 16584);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (377, '53000', '53', 'Laval', 49400);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (378, '53100', '53', 'Mayenne', 12883);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (379, '54520', '54', 'Laxou', 14771);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (380, '54400', '54', 'Longwy', 15679);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (381, '54300', '54', 'Lunéville', 18262);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (382, '54320', '54', 'Maxéville', 10090);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (383, '54000', '54', 'Nancy', 103671);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (384, '54700', '54', 'Pont-à-Mousson', 14190);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (385, '54200', '54', 'Toul', 15768);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (386, '54500', '54', 'Vandœuvre-lès-Nancy', 29942);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (387, '54600', '54', 'Villers-lès-Nancy', 14718);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (388, '54190', '54', 'Villerupt', 10102);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (389, '55000', '55', 'Bar-le-Duc', 14607);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (390, '55100', '55', 'Verdun', 16890);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (391, '56400', '56', 'Auray', 14207);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (392, '56520', '56', 'Guidel', 12338);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (393, '56700', '56', 'Hennebont', 15910);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (394, '56600', '56', 'Lanester', 23263);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (395, '56100', '56', 'Lorient', 58329);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (396, '56270', '56', 'Ploemeur', 18872);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (397, '56800', '56', 'Ploërmel', 10163);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (398, '56300', '56', 'Pontivy', 14640);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (399, '56890', '56', 'Saint-Avé', 12470);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (400, '56000', '56', 'Vannes', 55790);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (401, '57360', '57', 'Amnéville', 10875);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (402, '57150', '57', 'Creutzwald', 12254);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (403, '57290', '57', 'Fameck', 14788);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (404, '57190', '57', 'Florange', 12035);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (405, '57600', '57', 'Forbach', 20493);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (406, '57800', '57', 'Freyming-Merlebach', 13266);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (407, '57700', '57', 'Hayange', 15806);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (408, '57280', '57', 'Maizières-lès-Metz', 11580);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (409, '57155', '57', 'Marly', 10286);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (410, '57000', '57', 'Metz', 122572);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (411, '57950', '57', 'Montigny-lès-Metz', 21718);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (412, '57500', '57', 'Saint-Avold', 14755);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (413, '57400', '57', 'Sarrebourg', 12170);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (414, '57200', '57', 'Sarreguemines', 20143);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (415, '57350', '57', 'Stiring-Wendel', 10956);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (416, '57100', '57', 'Thionville', 42658);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (417, '57140', '57', 'Woippy', 14967);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (418, '57970', '57', 'Yutz', 17391);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (419, '58000', '58', 'Nevers', 33085);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (420, '59112', '59', 'Annœullin', 10847);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (421, '59410', '59', 'Anzin', 13183);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (422, '59280', '59', 'Armentières', 26998);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (423, '59270', '59', 'Bailleul', 14732);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (424, '59860', '59', 'Bruay-sur-l''Escaut', 11644);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (425, '59400', '59', 'Cambrai', 31134);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (426, '59540', '59', 'Caudry', 13833);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (427, '59560', '59', 'Comines', 12731);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (428, '59210', '59', 'Coudekerque-Branche', 20787);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (429, '59170', '59', 'Croix', 20566);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (430, '59220', '59', 'Denain', 20665);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (431, '59500', '59', 'Douai', 40250);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (432, '59282', '59', 'Douchy-les-Mines', 10109);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (433, '59140', '59', 'Dunkerque', 86263);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (434, '59155', '59', 'Faches-Thumesnil', 18619);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (435, '59610', '59', 'Fourmies', 11449);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (436, '59760', '59', 'Grande-Synthe', 20239);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (437, '59820', '59', 'Gravelines', 11430);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (438, '59250', '59', 'Halluin', 20715);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (439, '59320', '59', 'Haubourdin', 15074);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (440, '59330', '59', 'Hautmont', 14152);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (441, '59190', '59', 'Hazebrouck', 21912);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (442, '59510', '59', 'Hem', 18582);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (443, '59460', '59', 'Jeumont', 10160);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (444, '59110', '59', 'La Madeleine', 21790);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (445, '59130', '59', 'Lambersart', 27090);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (446, '59000', '59', 'Lille', 238246);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (447, '59120', '59', 'Loos', 22567);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (448, '59390', '59', 'Lys-lez-Lannoy', 14050);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (449, '59700', '59', 'Marcq-en-Barœul', 40184);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (450, '59770', '59', 'Marly', 11995);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (451, '59520', '59', 'Marquette-lez-Lille', 12622);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (452, '59600', '59', 'Maubeuge', 28767);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (453, '59370', '59', 'Mons-en-Barœul', 21105);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (454, '59420', '59', 'Mouvaux', 13369);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (455, '59960', '59', 'Neuville-en-Ferrain', 10002);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (456, '59590', '59', 'Raismes', 12199);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (457, '59790', '59', 'Ronchin', 19787);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (458, '59223', '59', 'Roncq', 14075);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (459, '59100', '59', 'Roubaix', 98286);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (460, '59230', '59', 'Saint-Amand-les-Eaux', 15974);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (461, '59350', '59', 'Saint-André-lez-Lille', 13233);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (462, '59880', '59', 'Saint-Saulve', 10947);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (463, '59113', '59', 'Seclin', 13261);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (464, '59450', '59', 'Sin-le-Noble', 16076);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (465, '59490', '59', 'Somain', 11766);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (466, '59200', '59', 'Tourcoing', 98772);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (467, '59300', '59', 'Valenciennes', 43468);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (468, '59690', '59', 'Vieux-Condé', 10617);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (469, '59491', '59', 'Villeneuve-d''Ascq', 62868);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (470, '59118', '59', 'Wambrechies', 11012);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (471, '59290', '59', 'Wasquehal', 20726);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (472, '59139', '59', 'Wattignies', 15525);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (473, '59150', '59', 'Wattrelos', 40847);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (474, '60000', '60', 'Beauvais', 55550);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (475, '60500', '60', 'Chantilly', 10591);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (476, '60600', '60', 'Clermont', 10564);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (477, '60200', '60', 'Compiègne', 40761);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (478, '60100', '60', 'Creil', 36301);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (479, '60800', '60', 'Crépy-en-Valois', 14351);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (480, '60160', '60', 'Montataire', 14257);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (481, '60110', '60', 'Méru', 13897);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (482, '60180', '60', 'Nogent-sur-Oise', 21907);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (483, '60400', '60', 'Noyon', 12971);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (484, '60700', '60', 'Pont-Sainte-Maxence', 12361);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (485, '60300', '60', 'Senlis', 15157);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (486, '61000', '61', 'Alençon', 25490);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (487, '61200', '61', 'Argentan', 13527);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (488, '61100', '61', 'Flers', 14432);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (489, '62000', '62', 'Arras', 42875);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (490, '62260', '62', 'Auchel', 10051);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (491, '62210', '62', 'Avion', 17435);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (492, '62600', '62', 'Berck', 12951);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (493, '62200', '62', 'Boulogne-sur-Mer', 40539);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (494, '62700', '62', 'Bruay-la-Buissière', 21424);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (495, '62160', '62', 'Bully-les-Mines', 12146);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (496, '62400', '62', 'Béthune', 25224);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (497, '62100', '62', 'Calais', 67571);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (498, '62220', '62', 'Carvin', 17909);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (499, '62710', '62', 'Courrières', 10176);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (500, '62440', '62', 'Harnes', 12247);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (501, '62110', '62', 'Hénin-Beaumont', 25688);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (502, '62300', '62', 'Lens', 32920);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (503, '62190', '62', 'Lillers', 10193);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (504, '62800', '62', 'Liévin', 30063);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (505, '62219', '62', 'Longuenesse', 10548);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (506, '62730', '62', 'Marck', 10467);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (507, '62680', '62', 'Méricourt', 11619);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (508, '62290', '62', 'Nœux-les-Mines', 11590);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (509, '62590', '62', 'Oignies', 10323);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (510, '62230', '62', 'Outreau', 13138);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (511, '62280', '62', 'Saint-Martin-Boulogne', 10888);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (512, '62500', '62', 'Saint-Omer', 14382);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (513, '62630', '62', 'Étaples', 10710);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (514, '63170', '63', 'Aubière', 10459);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (515, '63110', '63', 'Beaumont', 10728);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (516, '63400', '63', 'Chamalières', 17509);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (517, '63000', '63', 'Clermont-Ferrand', 146351);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (518, '63800', '63', 'Cournon-d''Auvergne', 19951);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (519, '63360', '63', 'Gerzat', 10335);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (520, '63500', '63', 'Issoire', 15115);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (521, '63430', '63', 'Pont-du-Château', 12412);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (522, '63200', '63', 'Riom', 18820);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (523, '63300', '63', 'Thiers', 11637);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (524, '64600', '64', 'Anglet', 43271);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (525, '64100', '64', 'Bayonne', 54306);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (526, '64200', '64', 'Biarritz', 26206);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (527, '64140', '64', 'Billère', 14384);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (528, '64700', '64', 'Hendaye', 18102);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (529, '64140', '64', 'Lons', 13606);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (530, '64400', '64', 'Oloron-Sainte-Marie', 10684);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (531, '64300', '64', 'Orthez', 10881);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (532, '64000', '64', 'Pau', 80441);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (533, '64500', '64', 'Saint-Jean-de-Luz', 14857);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (534, '64122', '64', 'Urrugne', 10661);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (535, '65100', '65', 'Lourdes', 13266);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (536, '65000', '65', 'Tarbes', 44399);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (537, '66700', '66', 'Argelès-sur-Mer', 10616);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (538, '66330', '66', 'Cabestany', 10465);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (539, '66140', '66', 'Canet-en-Roussillon', 13227);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (540, '66000', '66', 'Perpignan', 121616);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (541, '66380', '66', 'Pia', 11615);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (542, '66750', '66', 'Saint-Cyprien', 12068);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (543, '66240', '66', 'Saint-Estève', 11630);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (544, '67800', '67', 'Bischheim', 18558);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (545, '67240', '67', 'Bischwiller', 12242);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (546, '67170', '67', 'Brumath', 10499);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (547, '67150', '67', 'Erstein', 10790);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (548, '67500', '67', 'Haguenau', 36391);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (549, '67800', '67', 'Hœnheim', 11742);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (550, '67400', '67', 'Illkirch-Graffenstaden', 27872);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (551, '67380', '67', 'Lingolsheim', 20826);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (552, '67210', '67', 'Obernai', 12587);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (553, '67540', '67', 'Ostwald', 13946);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (554, '67700', '67', 'Saverne', 11460);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (555, '67300', '67', 'Schiltigheim', 34708);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (556, '67000', '67', 'Strasbourg', 293771);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (557, '67600', '67', 'Sélestat', 19589);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (558, '68700', '68', 'Cernay', 12057);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (559, '68000', '68', 'Colmar', 66970);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (560, '68500', '68', 'Guebwiller', 11243);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (561, '68110', '68', 'Illzach', 14923);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (562, '68260', '68', 'Kingersheim', 13354);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (563, '68100', '68', 'Mulhouse', 104978);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (564, '68120', '68', 'Pfastatt', 10314);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (565, '68400', '68', 'Riedisheim', 12200);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (566, '68170', '68', 'Rixheim', 14380);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (567, '68300', '68', 'Saint-Louis', 22805);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (568, '68310', '68', 'Wittelsheim', 10645);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (569, '68270', '68', 'Wittenheim', 15553);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (570, '69220', '69', 'Belleville-en-Beaujolais', 14016);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (571, '69530', '69', 'Brignais', 12503);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (572, '69500', '69', 'Bron', 42982);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (573, '69300', '69', 'Caluire-et-Cuire', 43597);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (574, '69680', '69', 'Chassieu', 11208);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (575, '69960', '69', 'Corbas', 11315);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (576, '69290', '69', 'Craponne', 12084);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (577, '69150', '69', 'Décines-Charpieu', 29877);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (578, '69320', '69', 'Feyzin', 10304);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (579, '69340', '69', 'Francheville', 15604);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (580, '69740', '69', 'Genas', 13421);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (581, '69700', '69', 'Givors', 21379);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (582, '69520', '69', 'Grigny-sur-Rhône', 10030);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (583, '69001', '69', 'Lyon', 519127);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (584, '69330', '69', 'Meyzieu', 36687);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (585, '69780', '69', 'Mions', 13843);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (586, '69310', '69', 'Oullins-Pierre-Bénite', 38168);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (587, '69140', '69', 'Rillieux-la-Pape', 31389);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (588, '69190', '69', 'Saint-Fons', 19285);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (589, '69230', '69', 'Saint-Genis-Laval', 21212);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (590, '69800', '69', 'Saint-Priest', 49229);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (591, '69110', '69', 'Sainte-Foy-lès-Lyon', 21692);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (592, '69170', '69', 'Tarare', 10893);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (593, '69160', '69', 'Tassin-la-Demi-Lune', 23200);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (594, '69120', '69', 'Vaulx-en-Velin', 53069);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (595, '69400', '69', 'Villefranche-sur-Saône', 36172);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (596, '69100', '69', 'Villeurbanne', 163684);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (597, '69200', '69', 'Vénissieux', 65502);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (598, '69130', '69', 'Écully', 17944);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (599, '70400', '70', 'Héricourt', 10621);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (600, '70000', '70', 'Vesoul', 15078);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (601, '71400', '71', 'Autun', 13172);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (602, '71100', '71', 'Chalon-sur-Saône', 45102);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (603, '71200', '71', 'Le Creusot', 20509);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (604, '71300', '71', 'Montceau-les-Mines', 17064);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (605, '71000', '71', 'Mâcon', 35177);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (606, '72700', '72', 'Allonnes', 10739);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (607, '72200', '72', 'La Flèche', 14947);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (608, '72000', '72', 'Le Mans', 146249);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (609, '72300', '72', 'Sablé-sur-Sarthe', 12326);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (610, '73100', '73', 'Aix-les-Bains', 32406);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (611, '73200', '73', 'Albertville', 19978);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (612, '73000', '73', 'Chambéry', 59964);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (613, '73290', '73', 'La Motte-Servolex', 12067);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (614, '74000', '74', 'Annecy', 132117);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (615, '74100', '74', 'Annemasse', 37628);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (616, '74130', '74', 'Bonneville', 13335);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (617, '74300', '74', 'Cluses', 17795);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (618, '74370', '74', 'Fillière', 10075);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (619, '74240', '74', 'Gaillard', 11423);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (620, '74800', '74', 'La Roche-sur-Foron', 11348);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (621, '74190', '74', 'Passy', 10856);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (622, '74150', '74', 'Rumilly', 16442);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (623, '74160', '74', 'Saint-Julien-en-Genevois', 16222);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (624, '74700', '74', 'Sallanches', 17319);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (625, '74200', '74', 'Thonon-les-Bains', 37928);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (626, '74100', '74', 'Vétraz-Monthoux', 10949);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (627, '75001', '75', 'Paris', 2103778);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (628, '76360', '76', 'Barentin', 12022);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (629, '76230', '76', 'Bois-Guillaume', 14539);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (630, '76210', '76', 'Bolbec', 11590);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (631, '76380', '76', 'Canteleu', 14402);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (632, '76320', '76', 'Caudebec-lès-Elbeuf', 10476);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (633, '76200', '76', 'Dieppe', 28496);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (634, '76250', '76', 'Déville-lès-Rouen', 10802);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (635, '76500', '76', 'Elbeuf', 15474);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (636, '76400', '76', 'Fécamp', 17313);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (637, '76120', '76', 'Le Grand-Quevilly', 25789);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (638, '76600', '76', 'Le Havre', 166687);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (639, '76140', '76', 'Le Petit-Quevilly', 22208);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (640, '76150', '76', 'Maromme', 10957);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (641, '76130', '76', 'Mont-Saint-Aignan', 20165);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (642, '76290', '76', 'Montivilliers', 15478);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (643, '76350', '76', 'Oissel-sur-Seine', 12317);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (644, '76170', '76', 'Port-Jérôme-sur-Seine', 10617);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (645, '76000', '76', 'Rouen', 117662);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (646, '76800', '76', 'Saint-Étienne-du-Rouvray', 29518);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (647, '76300', '76', 'Sotteville-lès-Rouen', 29003);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (648, '76190', '76', 'Yvetot', 11438);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (649, '77210', '77', 'Avon', 13651);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (650, '77170', '77', 'Brie-Comte-Robert', 19003);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (651, '77600', '77', 'Bussy-Saint-Georges', 27498);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (652, '77240', '77', 'Cesson', 11222);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (653, '77420', '77', 'Champs-sur-Marne', 27451);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (654, '77500', '77', 'Chelles', 54620);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (655, '77410', '77', 'Claye-Souilly', 13353);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (656, '77380', '77', 'Combs-la-Ville', 23350);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (657, '77120', '77', 'Coulommiers', 16374);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (658, '77190', '77', 'Dammarie-les-Lys', 23559);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (659, '77230', '77', 'Dammartin-en-Goële', 11907);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (660, '77300', '77', 'Fontainebleau', 15583);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (661, '77260', '77', 'La Ferté-sous-Jouarre', 10254);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (662, '77400', '77', 'Lagny-sur-Marne', 21461);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (663, '77350', '77', 'Le Mée-sur-Seine', 19527);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (664, '77127', '77', 'Lieusaint', 14017);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (665, '77185', '77', 'Lognes', 15074);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (666, '77100', '77', 'Meaux', 56905);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (667, '77000', '77', 'Melun', 45995);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (668, '77290', '77', 'Mitry-Mory', 20456);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (669, '77550', '77', 'Moissy-Cramayel', 18511);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (670, '77130', '77', 'Montereau-Fault-Yonne', 22279);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (671, '77144', '77', 'Montévrain', 15687);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (672, '77250', '77', 'Moret-Loing-et-Orvanne', 12810);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (673, '77140', '77', 'Nemours', 12889);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (674, '77186', '77', 'Noisiel', 16053);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (675, '77330', '77', 'Ozoir-la-Ferrière', 21238);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (676, '77340', '77', 'Pontault-Combault', 39096);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (677, '77160', '77', 'Provins', 11632);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (678, '77680', '77', 'Roissy-en-Brie', 23229);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (679, '77310', '77', 'Saint-Fargeau-Ponthierry', 15724);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (680, '77176', '77', 'Savigny-le-Temple', 31148);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (681, '77700', '77', 'Serris', 10326);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (682, '77400', '77', 'Thorigny-sur-Marne', 10440);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (683, '77200', '77', 'Torcy', 22810);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (684, '77360', '77', 'Vaires-sur-Marne', 13931);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (685, '77000', '77', 'Vaux-le-Pénil', 11474);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (686, '77270', '77', 'Villeparisis', 26946);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (687, '78260', '78', 'Achères', 22241);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (688, '78570', '78', 'Andrésy', 13834);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (689, '78410', '78', 'Aubergenville', 12723);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (690, '78390', '78', 'Bois-d''Arcy', 16586);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (691, '78955', '78', 'Carrières-sous-Poissy', 20825);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (692, '78420', '78', 'Carrières-sur-Seine', 14791);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (693, '78570', '78', 'Chanteloup-les-Vignes', 10861);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (694, '78400', '78', 'Chatou', 30598);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (695, '78700', '78', 'Conflans-Sainte-Honorine', 36958);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (696, '78290', '78', 'Croissy-sur-Seine', 11013);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (697, '78330', '78', 'Fontenay-le-Fleury', 13680);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (698, '78280', '78', 'Guyancourt', 29778);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (699, '78800', '78', 'Houilles', 33983);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (700, '78170', '78', 'La Celle-Saint-Cloud', 20460);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (701, '78150', '78', 'Le Chesnay-Rocquencourt', 30689);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (702, '78230', '78', 'Le Pecq', 16059);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (703, '78110', '78', 'Le Vésinet', 15554);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (704, '78340', '78', 'Les Clayes-sous-Bois', 16804);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (705, '78130', '78', 'Les Mureaux', 34632);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (706, '78520', '78', 'Limay', 17885);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (707, '78600', '78', 'Maisons-Laffitte', 23093);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (708, '78200', '78', 'Mantes-la-Jolie', 43526);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (709, '78711', '78', 'Mantes-la-Ville', 22332);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (710, '78160', '78', 'Marly-le-Roi', 16756);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (711, '78310', '78', 'Maurepas', 20629);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (712, '78360', '78', 'Montesson', 14549);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (713, '78180', '78', 'Montigny-le-Bretonneux', 32465);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (714, '78370', '78', 'Plaisir', 31811);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (715, '78300', '78', 'Poissy', 40983);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (716, '78120', '78', 'Rambouillet', 27724);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (717, '78210', '78', 'Saint-Cyr-l''École', 21268);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (718, '78100', '78', 'Saint-Germain-en-Laye', 45931);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (719, '78500', '78', 'Sartrouville', 52763);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (720, '78190', '78', 'Trappes', 34689);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (721, '78510', '78', 'Triel-sur-Seine', 12206);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (722, '78480', '78', 'Verneuil-sur-Seine', 16280);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (723, '78000', '78', 'Versailles', 84095);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (724, '78450', '78', 'Villepreux', 11931);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (725, '78220', '78', 'Viroflay', 17237);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (726, '78960', '78', 'Voisins-le-Bretonneux', 10624);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (727, '78140', '78', 'Vélizy-Villacoublay', 23011);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (728, '78990', '78', 'Élancourt', 26365);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (729, '79300', '79', 'Bressuire', 19970);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (730, '79000', '79', 'Niort', 59854);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (731, '79200', '79', 'Parthenay', 10140);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (732, '79100', '79', 'Thouars', 13891);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (733, '80100', '80', 'Abbeville', 22395);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (734, '80000', '80', 'Amiens', 136449);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (735, '81000', '81', 'Albi', 51290);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (736, '81100', '81', 'Castres', 42505);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (737, '81600', '81', 'Gaillac', 16162);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (738, '81300', '81', 'Graulhet', 13129);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (739, '81500', '81', 'Lavaur', 10965);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (740, '81200', '81', 'Mazamet', 10085);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (741, '82100', '82', 'Castelsarrasin', 14343);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (742, '82200', '82', 'Moissac', 13419);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (743, '82000', '82', 'Montauban', 62945);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (744, '83170', '83', 'Brignoles', 17850);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (745, '83310', '83', 'Cogolin', 12301);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (746, '83390', '83', 'Cuers', 13271);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (747, '83300', '83', 'Draguignan', 40826);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (748, '83370', '83', 'Fréjus', 59719);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (749, '83400', '83', 'Hyères', 55858);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (750, '83260', '83', 'La Crau', 19556);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (751, '83210', '83', 'La Farlède', 10014);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (752, '83130', '83', 'La Garde', 26476);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (753, '83250', '83', 'La Londe-les-Maures', 10584);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (754, '83500', '83', 'La Seyne-sur-Mer', 63732);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (755, '83160', '83', 'La Valette-du-Var', 23719);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (756, '83330', '83', 'Le Beausset', 10219);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (757, '83340', '83', 'Le Luc', 11310);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (758, '83490', '83', 'Le Muy', 10118);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (759, '83220', '83', 'Le Pradet', 10933);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (760, '83190', '83', 'Ollioules', 14568);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (761, '83380', '83', 'Roquebrune-sur-Argens', 15442);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (762, '83270', '83', 'Saint-Cyr-sur-Mer', 11658);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (763, '83470', '83', 'Saint-Maximin-la-Sainte-Baume', 17896);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (764, '83530', '83', 'Saint-Raphaël', 37113);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (765, '83120', '83', 'Sainte-Maxime', 14118);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (766, '83110', '83', 'Sanary-sur-Mer', 18538);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (767, '83140', '83', 'Six-Fours-les-Plages', 37109);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (768, '83210', '83', 'Solliès-Pont', 12521);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (769, '83000', '83', 'Toulon', 179116);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (770, '83550', '83', 'Vidauban', 12608);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (771, '84400', '84', 'Apt', 10143);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (772, '84000', '84', 'Avignon', 92188);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (773, '84500', '84', 'Bollène', 14024);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (774, '84200', '84', 'Carpentras', 31619);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (775, '84300', '84', 'Cavaillon', 25636);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (776, '84800', '84', 'L''Isle-sur-la-Sorgue', 20244);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (777, '84130', '84', 'Le Pontet', 18386);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (778, '84170', '84', 'Monteux', 13301);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (779, '84100', '84', 'Orange', 29706);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (780, '84210', '84', 'Pernes-les-Fontaines', 10504);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (781, '84120', '84', 'Pertuis', 19548);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (782, '84700', '84', 'Sorgues', 19006);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (783, '84270', '84', 'Vedène', 11974);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (784, '85190', '85', 'Aizenay', 10365);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (785, '85300', '85', 'Challans', 22943);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (786, '85200', '85', 'Fontenay-le-Comte', 14059);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (787, '85000', '85', 'La Roche-sur-Yon', 54849);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (788, '85500', '85', 'Les Herbiers', 16521);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (789, '85100', '85', 'Les Sables-d''Olonne', 49603);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (790, '85600', '85', 'Montaigu-Vendée', 21134);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (791, '85270', '85', 'Saint-Hilaire-de-Riez', 13074);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (792, '86180', '86', 'Buxerolles', 10289);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (793, '86100', '86', 'Châtellerault', 31003);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (794, '86000', '86', 'Poitiers', 89916);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (795, '87270', '87', 'Couzeix', 10195);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (796, '87000', '87', 'Limoges', 129937);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (797, '87350', '87', 'Panazol', 11342);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (798, '87200', '87', 'Saint-Junien', 11415);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (799, '88100', '88', 'Saint-Dié-des-Vosges', 19251);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (800, '88000', '88', 'Épinal', 32251);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (801, '89000', '89', 'Auxerre', 35097);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (802, '89100', '89', 'Sens', 27106);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (803, '90000', '90', 'Belfort', 45912);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (804, '91290', '91', 'Arpajon', 11698);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (805, '91200', '91', 'Athis-Mons', 36613);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (806, '91070', '91', 'Bondoufle', 10767);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (807, '91800', '91', 'Brunoy', 25643);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (808, '91220', '91', 'Brétigny-sur-Orge', 26658);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (809, '91380', '91', 'Chilly-Mazarin', 20443);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (810, '91100', '91', 'Corbeil-Essonnes', 54471);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (811, '91410', '91', 'Dourdan', 11415);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (812, '91210', '91', 'Draveil', 30098);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (813, '91700', '91', 'Fleury-Mérogis', 13721);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (814, '91190', '91', 'Gif-sur-Yvette', 22544);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (815, '91350', '91', 'Grigny', 26842);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (816, '91430', '91', 'Igny', 10833);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (817, '91260', '91', 'Juvisy-sur-Orge', 19292);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (818, '91940', '91', 'Les Ulis', 25886);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (819, '91160', '91', 'Longjumeau', 21996);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (820, '91300', '91', 'Massy', 51729);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (821, '91540', '91', 'Mennecy', 16433);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (822, '91230', '91', 'Montgeron', 24022);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (823, '91420', '91', 'Morangis', 14129);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (824, '91390', '91', 'Morsang-sur-Orge', 21667);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (825, '91400', '91', 'Orsay', 16498);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (826, '91120', '91', 'Palaiseau', 37471);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (827, '91130', '91', 'Ris-Orangis', 31189);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (828, '91180', '91', 'Saint-Germain-lès-Arpajon', 11623);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (829, '91240', '91', 'Saint-Michel-sur-Orge', 21776);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (830, '91280', '91', 'Saint-Pierre-du-Perray', 11993);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (831, '91700', '91', 'Sainte-Geneviève-des-Bois', 35438);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (832, '91600', '91', 'Savigny-sur-Orge', 37601);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (833, '91370', '91', 'Verrières-le-Buisson', 15057);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (834, '91270', '91', 'Vigneux-sur-Seine', 31466);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (835, '91140', '91', 'Villebon-sur-Yvette', 10291);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (836, '91170', '91', 'Viry-Châtillon', 30838);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (837, '91330', '91', 'Yerres', 27906);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (838, '91860', '91', 'Épinay-sous-Sénart', 11611);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (839, '91360', '91', 'Épinay-sur-Orge', 10722);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (840, '91150', '91', 'Étampes', 26857);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (841, '91000', '91', 'Évry-Courcouronnes', 66919);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (842, '92160', '92', 'Antony', 64263);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (843, '92600', '92', 'Asnières-sur-Seine', 93941);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (844, '92220', '92', 'Bagneux', 44572);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (845, '92270', '92', 'Bois-Colombes', 28909);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (846, '92100', '92', 'Boulogne-Billancourt', 119019);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (847, '92340', '92', 'Bourg-la-Reine', 21019);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (848, '92370', '92', 'Chaville', 20594);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (849, '92290', '92', 'Châtenay-Malabry', 35825);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (850, '92320', '92', 'Châtillon', 36705);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (851, '92140', '92', 'Clamart', 58576);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (852, '92110', '92', 'Clichy', 64410);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (853, '92700', '92', 'Colombes', 91053);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (854, '92400', '92', 'Courbevoie', 82902);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (855, '92260', '92', 'Fontenay-aux-Roses', 24070);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (856, '92380', '92', 'Garches', 17743);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (857, '92230', '92', 'Gennevilliers', 50979);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (858, '92130', '92', 'Issy-les-Moulineaux', 67669);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (859, '92250', '92', 'La Garenne-Colombes', 30197);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (860, '92350', '92', 'Le Plessis-Robinson', 28848);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (861, '92300', '92', 'Levallois-Perret', 68092);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (862, '92240', '92', 'Malakoff', 30557);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (863, '92190', '92', 'Meudon', 46334);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (864, '92120', '92', 'Montrouge', 46324);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (865, '92000', '92', 'Nanterre', 97783);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (866, '92200', '92', 'Neuilly-sur-Seine', 59538);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (867, '92800', '92', 'Puteaux', 44002);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (868, '92500', '92', 'Rueil-Malmaison', 82874);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (869, '92210', '92', 'Saint-Cloud', 29855);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (870, '92330', '92', 'Sceaux', 20884);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (871, '92150', '92', 'Suresnes', 48956);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (872, '92310', '92', 'Sèvres', 22303);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (873, '92170', '92', 'Vanves', 28622);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (874, '92410', '92', 'Ville-d''Avray', 11089);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (875, '92390', '92', 'Villeneuve-la-Garenne', 26021);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (876, '93300', '93', 'Aubervilliers', 88365);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (877, '93600', '93', 'Aulnay-sous-Bois', 87599);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (878, '93170', '93', 'Bagnolet', 43086);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (879, '93000', '93', 'Bobigny', 56927);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (880, '93140', '93', 'Bondy', 50595);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (881, '93390', '93', 'Clichy-sous-Bois', 29354);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (882, '93700', '93', 'Drancy', 72390);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (883, '93440', '93', 'Dugny', 11700);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (884, '93220', '93', 'Gagny', 42313);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (885, '93120', '93', 'La Courneuve', 47167);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (886, '93150', '93', 'Le Blanc-Mesnil', 62376);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (887, '93350', '93', 'Le Bourget', 15925);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (888, '93310', '93', 'Le Pré-Saint-Gervais', 16993);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (889, '93340', '93', 'Le Raincy', 14735);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (890, '93260', '93', 'Les Lilas', 23843);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (891, '93320', '93', 'Les Pavillons-sous-Bois', 25804);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (892, '93190', '93', 'Livry-Gargan', 47228);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (893, '93370', '93', 'Montfermeil', 28703);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (894, '93100', '93', 'Montreuil', 111934);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (895, '93360', '93', 'Neuilly-Plaisance', 21941);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (896, '93330', '93', 'Neuilly-sur-Marne', 39800);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (897, '93160', '93', 'Noisy-le-Grand', 72978);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (898, '93130', '93', 'Noisy-le-Sec', 45510);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (899, '93500', '93', 'Pantin', 61929);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (900, '93230', '93', 'Romainville', 37152);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (901, '93110', '93', 'Rosny-sous-Bois', 47180);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (902, '93200', '93', 'Saint-Denis', 149077);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (903, '93400', '93', 'Saint-Ouen-sur-Seine', 53615);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (904, '93270', '93', 'Sevran', 52535);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (905, '93240', '93', 'Stains', 41388);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (906, '93290', '93', 'Tremblay-en-France', 38348);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (907, '93250', '93', 'Villemomble', 29795);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (908, '93420', '93', 'Villepinte', 41470);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (909, '93430', '93', 'Villetaneuse', 12530);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (910, '93800', '93', 'Épinay-sur-Seine', 52833);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (911, '94140', '94', 'Alfortville', 45531);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (912, '94110', '94', 'Arcueil', 22200);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (913, '94470', '94', 'Boissy-Saint-Léger', 17325);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (914, '94380', '94', 'Bonneuil-sur-Marne', 18270);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (915, '94360', '94', 'Bry-sur-Marne', 18503);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (916, '94230', '94', 'Cachan', 31103);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (917, '94500', '94', 'Champigny-sur-Marne', 78072);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (918, '94220', '94', 'Charenton-le-Pont', 28830);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (919, '94430', '94', 'Chennevières-sur-Marne', 18710);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (920, '94550', '94', 'Chevilly-Larue', 19826);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (921, '94600', '94', 'Choisy-le-Roi', 45946);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (922, '94000', '94', 'Créteil', 93397);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (923, '94120', '94', 'Fontenay-sous-Bois', 53757);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (924, '94260', '94', 'Fresnes', 29528);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (925, '94250', '94', 'Gentilly', 19963);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (926, '94200', '94', 'Ivry-sur-Seine', 65064);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (927, '94340', '94', 'Joinville-le-Pont', 20525);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (928, '94240', '94', 'L''Haÿ-les-Roses', 31188);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (929, '94510', '94', 'La Queue-en-Brie', 12241);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (930, '94270', '94', 'Le Kremlin-Bicêtre', 24110);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (931, '94170', '94', 'Le Perreux-sur-Marne', 35260);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (932, '94420', '94', 'Le Plessis-Trévise', 21112);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (933, '94450', '94', 'Limeil-Brévannes', 27406);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (934, '94700', '94', 'Maisons-Alfort', 56799);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (935, '94130', '94', 'Nogent-sur-Marne', 32455);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (936, '94310', '94', 'Orly', 24658);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (937, '94490', '94', 'Ormesson-sur-Marne', 10977);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (938, '94160', '94', 'Saint-Mandé', 21071);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (939, '94100', '94', 'Saint-Maur-des-Fossés', 76572);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (940, '94410', '94', 'Saint-Maurice', 14506);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (941, '94370', '94', 'Sucy-en-Brie', 27764);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (942, '94320', '94', 'Thiais', 32918);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (943, '94460', '94', 'Valenton', 14406);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (944, '94440', '94', 'Villecresnes', 11647);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (945, '94800', '94', 'Villejuif', 60183);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (946, '94190', '94', 'Villeneuve-Saint-Georges', 36221);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (947, '94290', '94', 'Villeneuve-le-Roi', 21000);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (948, '94350', '94', 'Villiers-sur-Marne', 33162);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (949, '94300', '94', 'Vincennes', 48193);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (950, '94400', '94', 'Vitry-sur-Seine', 93963);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (951, '95100', '95', 'Argenteuil', 106130);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (952, '95400', '95', 'Arnouville', 15023);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (953, '95260', '95', 'Beaumont-sur-Oise', 10232);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (954, '95870', '95', 'Bezons', 36434);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (955, '95000', '95', 'Cergy', 70906);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (956, '95240', '95', 'Cormeilles-en-Parisis', 27292);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (957, '95170', '95', 'Deuil-la-Barre', 23099);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (958, '95330', '95', 'Domont', 16065);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (959, '95600', '95', 'Eaubonne', 26211);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (960, '95880', '95', 'Enghien-les-Bains', 11432);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (961, '95120', '95', 'Ermont', 29489);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (962, '95470', '95', 'Fosses', 10570);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (963, '95130', '95', 'Franconville', 37754);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (964, '95140', '95', 'Garges-lès-Gonesse', 41791);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (965, '95500', '95', 'Gonesse', 27707);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (966, '95190', '95', 'Goussainville', 31301);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (967, '95220', '95', 'Herblay-sur-Seine', 31779);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (968, '95280', '95', 'Jouy-le-Moutier', 17854);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (969, '95290', '95', 'L''Isle-Adam', 12493);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (970, '95380', '95', 'Louvres', 12560);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (971, '95370', '95', 'Montigny-lès-Cormeilles', 22457);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (972, '95360', '95', 'Montmagny', 15105);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (973, '95160', '95', 'Montmorency', 21763);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (974, '95520', '95', 'Osny', 17954);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (975, '95340', '95', 'Persan', 14359);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (976, '95220', '95', 'Pierrelaye', 10130);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (977, '95000', '95', 'Pontoise', 31970);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (978, '95350', '95', 'Saint-Brice-sous-Forêt', 15063);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (979, '95210', '95', 'Saint-Gratien', 21336);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (980, '95320', '95', 'Saint-Leu-la-Forêt', 16138);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (981, '95310', '95', 'Saint-Ouen-l''Aumône', 25578);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (982, '95110', '95', 'Sannois', 26924);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (983, '95200', '95', 'Sarcelles', 59173);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (984, '95230', '95', 'Soisy-sous-Montmorency', 18008);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (985, '95150', '95', 'Taverny', 27593);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (986, '95490', '95', 'Vauréal', 16079);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (987, '95400', '95', 'Villiers-le-Bel', 30053);
INSERT INTO villes (id, code_postal, departement, commune, population) VALUES (988, '95610', '95', 'Éragny-sur-Oise', 18436);

COMMIT;
