Home / Geographic / Italy Regions

Italy Regions

Rows 110

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

Download

Preview

id	name
1	Agrigento
2	Alessandria
3	Ancona
4	Aosta
5	Arezzo
6	Ascoli Piceno
7	Asti
8	Avellino
9	Bari
10	Barletta-Andria-Trani
11	Belluno
12	Benevento
13	Bergamo
14	Biella
15	Bologna
16	Bolzano
17	Brescia
18	Brindisi
19	Cagliari
20	Caltanissetta
21	Campobasso
22	Carbonia-Iglesias
23	Caserta
24	Catania
25	Catanzaro

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 `italy_regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `italy_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=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `italy_regions` WRITE;
/*!40000 ALTER TABLE `italy_regions` DISABLE KEYS */;
INSERT INTO `italy_regions` VALUES (1,'Agrigento'),(2,'Alessandria'),(3,'Ancona'),(4,'Aosta'),(5,'Arezzo'),(6,'Ascoli Piceno'),(7,'Asti'),(8,'Avellino'),(9,'Bari'),(10,'Barletta-Andria-Trani'),(11,'Belluno'),(12,'Benevento'),(13,'Bergamo'),(14,'Biella'),(15,'Bologna'),(16,'Bolzano'),(17,'Brescia'),(18,'Brindisi'),(19,'Cagliari'),(20,'Caltanissetta'),(21,'Campobasso'),(22,'Carbonia-Iglesias'),(23,'Caserta'),(24,'Catania'),(25,'Catanzaro'),(26,'Chieti'),(27,'Como'),(28,'Cosenza'),(29,'Cremona'),(30,'Crotone'),(31,'Cuneo'),(32,'Enna'),(33,'Fermo'),(34,'Ferrara'),(35,'Firenze'),(36,'Foggia'),(37,'Forlì-Cesena'),(38,'Frosinone'),(39,'Genova'),(40,'Gorizia'),(41,'Grosseto'),(42,'Imperia'),(43,'Isernia'),(44,'L\'Aquila'),(45,'La Spezia'),(46,'Latina'),(47,'Lecce'),(48,'Lecco'),(49,'Livorno'),(50,'Lodi'),(51,'Lucca'),(52,'Macerata'),(53,'Mantova'),(54,'Massa-Carrara'),(55,'Matera'),(56,'Medio Campidano'),(57,'Messina'),(58,'Milano'),(59,'Modena'),(60,'Monza e Brianza'),(61,'Napoli'),(62,'Novara'),(63,'Nuoro'),(64,'Ogliastra'),(65,'Olbia-Tempio'),(66,'Oristano'),(67,'Padova'),(68,'Palermo'),(69,'Parma'),(70,'Pavia'),(71,'Perugia'),(72,'Pesaro e Urbino'),(73,'Pescara'),(74,'Piacenza'),(75,'Pisa'),(76,'Pistoia'),(77,'Pordenone'),(78,'Potenza'),(79,'Prato'),(80,'Ragusa'),(81,'Ravenna'),(82,'Reggio Calabria'),(83,'Reggio Emilia'),(84,'Rieti'),(85,'Rimini'),(86,'Roma'),(87,'Rovigo'),(88,'Salerno'),(89,'Sassari'),(90,'Savona'),(91,'Siena'),(92,'Siracusa'),(93,'Sondrio'),(94,'Taranto'),(95,'Teramo'),(96,'Terni'),(97,'Torino'),(98,'Trapani'),(99,'Trento'),(100,'Treviso'),(101,'Trieste'),(102,'Udine'),(103,'Varese'),(104,'Venezia'),(105,'Verbano-Cusio-Ossola'),(106,'Vercelli'),(107,'Verona'),(108,'Vibo Valentia'),(109,'Vicenza'),(110,'Viterbo');
/*!40000 ALTER TABLE `italy_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

Italy Regions

Download

Preview

Raw SQL