Home / Geographic / France Regions

France Regions

Rows 95

Last updated 2026-01-05 13:29:01

Download

Preview

id	name
1	Ain
2	Aisne
3	Allier
4	Alpes-de-Haute-Provence
5	Alpes-Maritimes
6	Ardèche
7	Ardennes
8	Ariège
9	Aube
10	Aude
11	Aveyron
12	Bas-Rhin
13	Bouches-du-Rhône
14	Calvados
15	Cantal
16	Charente
17	Charente-Maritime
18	Cher
19	Corrèze
20	Corse-du-Sud
21	Côte-d'Or
22	Côtes-d'Armor
23	Creuse
24	Deux-Sèvres
25	Dordogne

Raw SQL

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `france_regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `france_regions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `france_regions` WRITE;
/*!40000 ALTER TABLE `france_regions` DISABLE KEYS */;
INSERT INTO `france_regions` VALUES (1,'Ain'),(2,'Aisne'),(3,'Allier'),(4,'Alpes-de-Haute-Provence'),(5,'Alpes-Maritimes'),(6,'Ardèche'),(7,'Ardennes'),(8,'Ariège'),(9,'Aube'),(10,'Aude'),(11,'Aveyron'),(12,'Bas-Rhin'),(13,'Bouches-du-Rhône'),(14,'Calvados'),(15,'Cantal'),(16,'Charente'),(17,'Charente-Maritime'),(18,'Cher'),(19,'Corrèze'),(20,'Corse-du-Sud'),(21,'Côte-d\'Or'),(22,'Côtes-d\'Armor'),(23,'Creuse'),(24,'Deux-Sèvres'),(25,'Dordogne'),(26,'Doubs'),(27,'Drôme'),(28,'Essonne'),(29,'Eure'),(30,'Eure-et-Loir'),(31,'Finistère'),(32,'Gard'),(33,'Gers'),(34,'Gironde'),(35,'Haut-Rhin'),(36,'Haute-Corse'),(37,'Haute-Garonne'),(38,'Haute-Loire'),(39,'Haute-Saône'),(40,'Haute-Savoie'),(41,'Haute-Vienne'),(42,'Hautes-Alpes'),(43,'Hautes-Pyrénées'),(44,'Hauts-de-Seine'),(45,'Hérault'),(46,'Ille-et-Vilaine'),(47,'Indre'),(48,'Indre-et-Loire'),(49,'Isère'),(50,'Jura'),(51,'Landes'),(52,'Loir-et-Cher'),(53,'Loire'),(54,'Loire-Atlantique'),(55,'Loiret'),(56,'Lot'),(57,'Lot-et-Garonne'),(58,'Lozère'),(59,'Maine-et-Loire'),(60,'Manche'),(61,'Marne'),(62,'Mayenne'),(63,'Meurthe-et-Moselle'),(64,'Meuse'),(65,'Morbihan'),(66,'Moselle'),(67,'Nièvre'),(68,'Nord'),(69,'Oise'),(70,'Orne'),(71,'Paris'),(72,'Pas-de-Calais'),(73,'Puy-de-Dôme'),(74,'Pyrénées-Atlantiques'),(75,'Pyrénées-Orientales'),(76,'Rhône'),(77,'Saône-et-Loire'),(78,'Sarthe'),(79,'Savoie'),(80,'Seine-et-Marne'),(81,'Seine-Maritime'),(82,'Seine-Saint-Denis'),(83,'Somme'),(84,'Tarn'),(85,'Tarn-et-Garonne'),(86,'Territoire de Belfort'),(87,'Val d\'Oise'),(88,'Val-de-Marne'),(89,'Var'),(90,'Vaucluse'),(91,'Vendée'),(92,'Vienne'),(93,'Vosges'),(94,'Yonne'),(95,'Yvelines');
/*!40000 ALTER TABLE `france_regions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Categories

Popular

France Regions

Download

Preview

Raw SQL